SUMMARY

• He is an experienced hands - on data architect, a seasoned professional in data and information management methodology to in corporate multiple business processes and subject areas to build stable structures of shareable re-usable data highly skilled modeler in operational, transactional, reference data and multi-dimensional metadata-driven designs, resourceful facilitator, who leverages of relevant in-depth analysis to identify opportunities for optimized business processes successful communicator in socializing and marketing benefits of data management and data governance function to client community and to IS professionals.
• He is a skilled negotiator in communicating with vendors in evaluation of package solutions. He is an experienced coordinator and planner in creating policies and procedures for in corporation of data administration into the project life cycle. Strong analyst, who can grasp difficult multifaceted concepts to understand clients’ business needs, using TOGAF to communicate enterprise architecture constructs, components and interrelationships thereof.
• He has over 25 years of experience in the financial industry, including over 15 years of experience architecting enterprise-wide solutions for front office, middle office and back office, in the areas of Risk Management, Compliance, and Master Data Management supporting Commodities, Equities, Fixed Income and Derivatives, as well as OTC products for IB, Prime Finance, Asset Management and other areas of finance, including recent regulatory compliance and data governance related professional activities, including but not limited to design and development of business taxonomies, data stewardship workflows, data definitions and data dictionaries.

PROFESSIONAL EXPERIENCE

Confidential

Senior Data Architect/Data Governance Consultant

Responsibilities:

• Provided Data Governance consulting to multiple clients: Kansas City Southern and Verisk
• Performed Data Modeling using Erwin. Prepared meta-data for data governance tools consumption (Collibra, Informatica).
• Analyzed the source data to be ingested by the AWS data repository and provided architecture consulting.

Confidential

Senior Data Analyst/Program Management Consultant

Responsibilities:

• Designed and implemented business data lineage solution using Collibra and Ab Initio across all UK and EU business units for Merchant Services, Consumer Loans, and Corporate Card divisions. The components of the solution have been built using SQL Server and PowerShell.
• Performed Data Modeling using ER/Studio.
• Working on the design and architecture of the central hub client identity service data repository.
• Performed mapping of data elements and critical data elements across multiple data consuming and data providing systems. Performed other relevant data mapping and engaged in data transformation efforts (hands on.)
• Provide data governance program management consulting to the senior management of the bank.
• Participate in the ongoing data quality controls integration with the data lineages.
• Technology: Hadoop, SQL Server, Collibra, Ab Intio, PowerShell, ER/Studio.

Confidential, Madison, WI

Data Architecture Consultant

Responsibilities:

• Advise senior executive management on design, architecture and development of a new Risk Reporting Business Intelligence solution.
• Designed and Developed a POC of an adaptable and extensible metadata-driven financial reporting Data Warehouse with the data virtualization layer, using Markit EDM for ETL, SQL Server, SSAS and Tableau. The solution provides for the early-arriving facts scenario.
• Work on the data governance program development.
• Analyze the existing data repositories as data sources for the BI reporting solution.
• Engage in Data & Conceptual Modeling using CA Erwin 9.
• Work on creation of a Business Glossary.
• Worked on data mapping, designed and developed data transformation solutions based on the mapping.
• Evaluated migration to Azure Cloud.
• Technology: SQL Server 2016, Oracle 11g, SSAS, Tableau 9.3, CA Erwin 9

Confidential, Pasadena, CA

Data Architecture Consultant

Responsibilities:

• Worked on conceptual data model for the fixed income products performance and risk assessment multi-dimensional metadata-driven analysis.
• Designed data retention methodology.
• Performed data architecture tasks using ER Studio.
• Analyzed Fixed Income products reference data to in corporate the same into the risk management metrics repository design.
• Worked on reporting methodologies and multi-dimensional analysis solutions.
• Proposed a new truly multi-dimensional approach to building a risk reporting solution.
• Worked on ADCO solution cluster/client nodes automated metadata-driven deployment design and implementation.
• Optimized and developed data virtualization layer using Oracle views.
• Work on the data governance program development, evaluated Collibra.
• Ab Initio as ETL
• Responsible for data mapping and development of data transformation routines using PL/SQL.

Confidential

Solution/Enterprise Architect Consultant

Responsibilities:

• Established data architecture standards. Created enterprise conceptual data model and facilitated sessions to validate with cross functional business practitioners. Created physical models for legacy applications and mapped to enterprise conceptual data model to create canonical model. Facilitated project to create common terminology across the enterprise (business taxonomy.)
• Performed business analysis in the areas of AML and KYC.
• Built an MDM repository,
• Customized the proprietary reference data repository logical model for the client.
• Collected, compiled and analyzed relevant information for the assessment of the impact of migration from a legacy reference data repository to a meta-data driven reference data repository
• Developed code for loading vendor reference data into the new reference data repository.
• Assisted with the remediation of differences between the two reference data paradigms
• Worked with and analyzed vendor feeds (Valmer, Reuters, etc.,) as a part of the effort.
• Worked on the design and implementation of ESB with SOA
• Used SSIS as ETL
• Used TOGAF to communicate enterprise architecture ideas.
• Performed data mapping, transformation, and in-depth data analyses.

Confidential

Senior Business Analyst

Responsibilities:

• Collected, compiled and analyzed relevant information for the assessment of the impact of migration of all systems at the bank, globally, (including risk, pricing, and trading systems) from a legacy MDM repository (Asset Control) to a metadata driven reference data repository (ESM) with the SOA layer.
• Designed and developed business taxonomy.
• Developed methods and instruments for the analysis.
• Assisted with the remediation of differences between the two reference data paradigms
• Worked with and analyzed vendor feeds (BBG, Reuters, etc.,) as a part of the effort
• Asset Control, MS SQL Server, Oracle, Sybase, ER/Studio
• The migration affected both product and client reference data consuming systems