Mattias Tornyi

--www.linkedin.com/in/mattiastornyi Mattias Tornyi Career Summary Accomplished IT professional with 25+ years of experience in financial services and IT consulting. Resultsoriented with excellent communication and leadership skills and a passion for enterprise IT, data analysis and visualization, innovation and process improvement. Hands-on technical skills in databases, data warehouses, SQL programming, data analysis, business intelligence, technical specifications, requirements and project management. Extensive experience overseeing large complex IT environments and managing technical teams. Deep knowledge of Wealth Management, Clearing and Broker/Dealer operations. Skills IT Leadership IT Project Management Enterprise IT Strategy Software & Application Development Agile Methodologies Vendor Management IT Infrastructure Information Security IT Policies & Procedures Email Archiving/Record Retention Business Process Improvement Business Intelligence Business Continuity Trading Systems/OMSs Broker/Dealer Operations & Systems Wealth Management Relational Databases SQL Server Tableau Snowflake ETL/ELT T-SQL JIRA/Confluence Data Analysis and Analytics Experience SVP, Head of Data Sciences - Wedbush Securities, Los Angeles, CA • • • • • • • Established a new Data Sciences department and managed a team of data analysts and data engineers. Developed charter and core mission to enhance and leverage the firm's data assets with a focus on governance, analytics, and warehousing. Designed and built a data dictionary for “books and records” data including PII identification and business definitions, published to users via Tableau dashboards. Conducted proof-of-concept evaluations of cloud-based data warehouse platforms, with a formal recommendation to implement Snowflake. Deployed and evangelized Tableau Desktop and Tableau Server as the primary data visualization/analytics platform. Designed and built interactive dashboards for the firm's Financial Advisors for tracking business health and KPIs for assets under management, transaction/fee revenues, client demographics, and asset flows. Designed and built interactive dashboards to track KPIs and SLAs for the executive leadership group and operational areas of the firm including Credit/Margin, New Accounts, and Finance. Conducted user training, communication and support. SVP, Head of PMO - Wedbush Securities, Los Angeles, CA • • • ● ● - Head of the Project Management Office, responsible for establishing the firm's first PMO, hiring and leading a team of ~10 project managers and business analysts. Implemented new policies, procedures and standards to govern the IT project lifecycle using the Agile framework. Developed tools and standards for tracking of project status and issues using Jira and Confluence. Established a master repository of the firm’s project portfolio. SVP, Business Process Improvement - Wedbush Securities, Los Angeles, CA ● - - Responsible for identifying and implementing process improvements, operational efficiencies, and improving service capabilities through automation and leveraging technology solutions. Developed a new workflow system for managing call notices and check/wire/ACH requests. Realized cost savings of 2,500 man-hours/year. Implemented a 3rd party Accounts Payable workflow solution to improve invoice process. Performed buy vs. build ROI analysis and recommendation to the leadership team. Reduced lead-times for review and approval activities by over 50% and significantly improved governance/control capabilities. Realized a 50% reduction of FTEs needed within the Accounts Mattias Tor nyi 31 0 .7 80 .3 731 P a g e 1|2 ● • Payable department. Designed and developed a new Account Opening system including electronic signature functionality. Reduced new account applications from a 50% NIGO rate to +90% and significant efficiency improvements. Designed and developed a new corporate intranet using Drupal and Open Atrium. Significantly improved the user experience and gained efficiencies through de-centralized content management. VP, Director of IT - Wedbush Securities, Los Angeles, CA ● ● ● ● ● ● ● ● - Responsible for all aspect of IT including Infrastructure, Systems Development, Project Management and Information Security. Managed a team of 30 employees, overseeing an IT environment with 1,500 users in 35 offices, with a ~$25mm yearly operating budget. Created and managed IT strategy, budgets, policies and procedures. Responsible for operational oversight of Purchasing, Facilities, and Mail Services functions. Vendor selection and implementation of core IT services and financial services systems such as Bloomberg OMS, Thomson One. Extensive experience with Thomson Reuters BETA Systems and Sungard Phase3 systems and APIs. Deployed a new Email Archiving solution resulting in significant efficiency improvements in system administration, email surveillance, and eDiscovery, adhering to record retention requirements in SEC 17a-3 and SEC 17a-4. Led a team of engineers and developers to implemented NetApp enterprise storage solutions. Successfully implemented a fault-tolerant system with real-time data replication to remote backup site, and WORM-compliant storage capabilities (per requirements in SEC 17a-3 and SEC 17a-4). Secured funding and oversaw a complete upgrade of the corporate network infrastructure utilizing Cisco firewalls, IPS, core routers, core switches, top-of-rack/aggregation switches. Performed cost-benefit analysis of outsourced vs insourced mail services operations. Oversaw the transition to insourcing and reduced total operating expense by ~30%. Product Manager - Wedbush Securities, Los Angeles, CA ● ● ● - Product and project manager for the firm’s in-house developed Wealth Management solution used by financial advisors and sales/operations staff. Managed a team of software developers to enhance and maintain front-office system. Performed hands-on back-end development, requirements gathering, system design, functional/performance testing, and back-office integration. Responsible for user training, client presentations, troubleshooting, and product marketing. Sr. Database Developer - Wedbush Securities, Los Angeles, CA ● ● ● ● Database development and design in a large-scale clustered SQL Server environment. Developed large-scale ETL processes importing data from brokerage processing system. Developed complex T-SQL stored procedures for account management, settlement, and trade reconciliation systems. Performed performance optimization utilizing index design, index hints, data partitioning, and data aggregation processing. Co-Owner/Tableau Consultant - Tornyi Consulting, Los Angeles, CA ● • • - - Designed and developed interactive data visualization dashboards and score cards using Tableau for a charter school network, to track financial health, academic achievements and enrollment KPIs. Performed data analysis and cleansing. Consulted with client for requirements and performed general maintenance and publishing of dashboard updates. Sr. IT Consultant - Cap Gemini Ernst & Young, Seattle, WA IT Consultant - Cap Gemini, Sweden Accounting Manager - ABB Coiltech, Sweden - Education & Certifications ● ● Bachelors of Science in Computer Science, University of Skövde Sweden,- FINRA Series 99 – Operations Professional Mattias ● ● ● Certified Bitcoin Professional (CBP) Microsoft Certified Professional - MS SQL Server 6.5 Microsoft Certified Professional - MS Access 95 Tor nyi 31 0 .7 80 .3 731 P a g e 2|2