SUMMARY

• Senior Data Architect with over 20 years of progressive experience in architecture, design, development, and management of software, database, BI and analytics solutions for Investment banking, commercial banking), wealth and asset management companies.
• Proven ability to combine vision and strong business acumen with well - developed management and leadership qualities and excellent ability to motivate, facilitate, mentor and interact smoothly and effectively with staff, peers, and senior management.

TECHNICAL SKILLS

• Data Governance
• Informatica Axon, IDQ, EDC, MDM
• Data Quality dimensions, rules, and profiling Net (C#, VB.Net), OOP
• SQL, T-SQL, PL/SQL, PostgresSQL
• Oracle, Toad, GreenPlum
• Data Modeling (OLTP,OLAP)
• Data Mining and Machine Learning
• System analysis
• JIRA and Scrum (Agile) Software Development
• Bloomberg API and Web Services
• IT management
• Perforce, TFS, QC, and SourceTree
• Excel VBA, PowerPoint VBA
• VBScript and Shell scripting
• AWS, Microsoft Azure
• SQL Server (SSIS, SSRS)
• BI (OLAP) and Analytics
• Python( pandas, numpy, matplotlib, seaborn)
• UML
• DevOps, SOA
• Hadoop, MapReduce, Hive
• Alteryx, Tableau, PowerBI

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles CA

Vice President, Lead Data Architect

Responsibilities:

• Oversaw data architecture current state maturity assessment activities, identified data architecture gaps and facilitated architecture future state roadmap.
• Architecture and designed digitization and automation of Loan origination process and data flow. Resulted in full LOS transparency, and achieved a 5X throughput and productivity increase
• Led the design and development of new strategic data pipeline for delivering CCAR regulatory attributes to the parent company. Achieving 100% automated data quality monitoring, SOX, GDPR, CCPA compliance, and acceptance rate.
• Oversaw and led the architecture and design of bank’s data lake platform as part of analytics and digital transformation initiatives.
• Developed data architecture governance strategy, and metrics and developed data stewardship program across organization
• Coordinated the development and distribution of over 20 enterprise-wide data architecture standards which resulted in higher levels of architecture capability maturity, and regulatory compliance.
• Instituted end-to-end technical guidance and roadmap for data management, and data architecture governance initiatives
• Oversaw and coordinated data architecture governance activates, including rollout of Informatica Axon, IDQ, EDC, and MDM products, and automation of data profiling, monitoring data quality rules and dimensions, data lineage, data cleansing and data mastering, resulted in tenfold reduction in regulatory compliance cost
• Introduced data profiling concepts and tools to EA, IT, Data Office and data stewards, and developed training material for these tools.

Confidential, Los Angeles, CA

Fixed Income Developer / Architect - Consultant

Responsibilities:

• Designed, and developed trading desk front-end application (Nucleus) -C#, VB.net, VBA - (utilizing Bloomberg DDM (BPIPE), Pub\Sub, CDE (Bloomberg Custom Data Entry) Worksheet Connect, and Bloomberg desktop API to record, calculate, and report on lists of assets and their associated values over time. This trading desk business critical application provided real time updates to all trading desks resulting in a significant cost saving and enhanced capabilities.
• Designed and developed MiFIDII European regulatory report interim solution (ETL, SQL code and trade log parsing algorithm in Alteryx), and MiFID manual trade reporting tool which resulted in over $400K cost saving for the company.
• Designed and developed emerging markets security tracking Excel based application (VBA, VB.net, C#) to track live and historical data of over 1500 securities with advanced charting and reporting capabilities. This application is business critical application for EM desk.
• Designed and developed Market Data snapshot SSRS report for over 150 securities, and distributed to over 80 portfolio managers, traders, and analysts every 30 minutes around the clock. Developed on Bloomberg WebService (C#), SQL Server, Alteryx ETL, SSRS and a creative data driven subscription algorithm that I wrote and introduced to the company for the first time to achieve maximum scheduling flexibility
• Designed and developed Tableau PDF scheduling tool and UI. Resulted in significant increase in productivity by automating Tableau PDF generation for hundreds of Tableau users throughout the company
• Designed and developed numerous tools and reports for traders, portfolio managers, and analysts utilizing Tableau, SSRS, Alteryx and Excel (.net, VBA), MATLAB, Python which resulted in significant reduction in maintenance cost, and greatly improved the flexibility and aesthetics of these reports
• Data modeled, designed and developed numerous databases in SQL Server and PDW as the backend storage for various Fixed income tactical and enterprise applications
• Served as go-to-person on certain key technical areas like Bloomberg API and Webservice, SSRS, Alteryx ETL, troubleshooting Excel models, templates and addins, ad hoc algorithmic programming requests, and specific data modeling requests.

Confidential

Senior Principle Software Engineer

Responsibilities:

• Designed, and Implemented company’s first Business Intelligence (BI) infrastructure, and introduced BI technologies, tools and methodologies, and trained financial staff and IT personal on BI tools including, SSRS, Alteryx, Python, Tableau, Power Query, and Power BI. Achieving a 3X productivity increase.
• Designed, developed and managed a business-critical Investment banking pitch book application by integrating DBs, Salesforce and File Servers with PowerPoint and Excel to assist over 1200 bankers world-wide in accessing, extracting, formatting and standardizing 100K+ files, logos, bios, images, tables, CRM data elements, charts, league tables, stock synopses, market overview decks, disclaimers, deal profiles, maps etc. Achieving in 4X throughput and productivity increase.
• Managed and guided planning, analyzing requirements, designing, developing, and testing of enterprise-wide software applications, databases, EDW, BI and analytics projects.
• Developed data mining, clustering, and pattern detection and interpolation projects on financial and marketing datasets.
• Developed, managed and implemented company’s data architecture, data quality, and metadata management strategy and standards
• Implemented IT service management best practices, and guiding principles (ITIL, TOGAF) by continually improving IT services which resulted in increased service consumer satisfaction, service efficiency and productivity, and significant reduction in maintenance cost.
• Conducted regular staff training sessions on topics such as data analysis, BI and self-Service best practices and tools (Python, SQL, VBA, PQ, PowerBI, Alteryx, Tableau)
• Coordinated and managed teams of offshore and in-house developers, analysts, and QA engineers responsible for all aspects of SDLC including, planning, analyzing, developing and testing complex financial applications in various programming languages, in an agile environment.
• Managed, developed and implemented BI and Analytics solutions. Designed BI platforms for streamlining analytics, Business Intelligence and data mining tools resulting in transformed business, BI and analytics capabilities.
• Assisted financial staff in developing complex financial and mathematical models