SUMMARY

• Confidential is an experienced hands - on data architect, a seasoned professional in data and information management methodology to incorporate 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.
• Confidential 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 incorporation of data administration into the project life cycle. Strong analyst, who can grasp difficult multifaceted concepts to understand clients’ business needs.
• Confidential 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, 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, using Markit EDM, 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 with Data3sixty.
• Reverse engineer and document business workflows.
• Systems: Markit EDM, Eagle PACE, Agresso, Data3Sixty
• 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 incorporate 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.

Confidential, New York City, NY

Solution/Enterprise Architect Consultant

Responsibilities:

• Created conceptual data model in the Capital Markets area and facilitated sessions to validate with cross functional business practitioners. Modeled business processes and defined business rules across product lines and business areas and analyzed data across systems to identify exceptions. Created logical and physical models for legacy applications and mapped to conceptual data model. Designed a data hub Erwin model for the finance and capital markets domain, including risk metrics, pricing, trades, positions, counterparty and security/product reference data.
• Designed a logical data model for the global counterparty credit risk reporting for Wells Fargo Bank using Erwin as the data modeling tool, based on the analysis of the legacy system, and business requirements compliant with BSBC 239.
• Created business dimensional model for compliance data across business functional globally to facilitate integrated reporting and analysis.
• Architected a compliance reporting solution for the global compliance initiative Barclays, which sources the data from about two dozen compliance information capturing and maintenance systems, including Issue Tracking - Actimize. Developed business taxonomy.
• Designed a customer scoring algorithm for the AML division of BMO. The risk factor data is captured and stored in IBM Netezza. IBM BDW.
• Client Deutsche Bank: Architected a Volcker metrics BI reporting modeling for Deutsche Bank.
• Involved in presales efforts/analysis.

Confidential, Mexico City, Mexico

Enterprise Architect/Business Analyst 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.
• 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.

Confidential, NJ

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 reference data repository (Asset Control) to a metadata driven reference data repository (ESM)
• 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
• Evaluated several vendor tools, as potential candidates for the firm-wide meta-data repository project, involving Teradata, MS SQL Server, BO XI, DB2, Informatica, IBM MF, WSAA, Rochade, Metacenter, Erwin, as a partial list of meta-data sources, and tools
• Conducted technical and business analysis of the requirements for the meta-data repository project to scan the reference data (client & product), as well as infrastructure data, ETL meta-data, models meta-data & business taxonomy data to facilitate data governance.
• Performed thorough assessment of capabilities of the selected MD tools, and produced a functionality ratings document
• Generated use cases for the prove-of-concept (POC) for the meta-data repository (MDR)
• Performed transactional as well as Reference Data and Master Data (Client, Counterparty & Product) architecture & modeling related work
• Worked on the data-warehousing components data modeling

Confidential, NY

Enterprise Architect Consultant

Responsibilities:

• Supported broad range of data architecture functions across multiple divisions. Created enterprise conceptual data model used for enterprise data architecture, in-house system development, package solution evaluations and implementations, and data integration activities.
• Developed data quality methodology. Facilitated data integration efforts. Marketed concepts of Data Management to end user community and other consulting firms participating in various engagements. Introduced several techniques and methodologies to facilitate modeling. Worked on SOA Conceptual Architecture. Designed business taxonomy.
• Modeled trading and reference data for cross asset class data store, combining data from futures and options, equities, Fixed Income, OTC, FX, exotics source systems (incl.: GMI, R&N)
• Data modeler for Federal Prime Broker/Dealer Reporting and Fixed Income Trading repository projects
• Designed/modeled the Trading Limits Monitoring System (E-Limits)
• Designer/modeler of Accounting Rules Engine (Sun GL/Oracle GL)
• Architected and modeled transactional as well as Reference Data and Master Data (Product & Client)
• Modeled client data management and migrated from legacy to a new repository

Confidential, NY

Data Architect/Business Analyst

Responsibilities:

• Worked on POC projects, such as reference data reconciliation, market data repository, and trades repository for several clients in the area of banking and finance
• Prepared presentations, interviewed users and SMEs, prepared data-flow and process-flow diagrams.
• Worked on a reconciliation system proposal, developed the OLAP component using MS SSAS, and evaluated several front-end presentational layers, with the back-end database implemented on MS SQL Server
• Provided data architecture on the Cash Securities Data Store program
• Responsible for the current state analysis of the global trades processing, trade information and reference data repository systems, data modeling and for proposing feasible solutions to optimize the current infrastructure for IB
• Identified redundancies in the processing of data from the point of inception to the point of capturing in multiple repositories
• Proposed a number of architectural options to streamline the processing of the data and to create a single source of truth for transactions processing information (including reference data), static reporting and OLAP systems, globally
• Made proposals to the executive management encompassing all aspects of data and process architecture.

Confidential, NY

Enterprise Architect

Responsibilities:

• Performed Information Architecture of the ratings issuance events capturing system, including client, instrument and business entity reference data modeling for the project
• Responsible for data architecture/modeling, as a consultant, with extensive market, credit and operational risk assessment experience
• Designed a model for risk exposures capturing and monitoring system, the purpose of which was to facilitate the process of capturing and maintaining ratings of financial instruments (Loans, Leases, Equities, Fixed Income - RMBS, CMBS, Whole Loans, CDO, CMO, etc.) and commercial organizations
• Involved in planning and design of integration of multiple disparate financial performance systems into a comprehensive enterprise-wide reference data solution involving Golden Source, as one of the components of reference data management the solution
• Worked on the data modeling for the Intex / Zenta data feeds replacement project.
• Conceptualized business requirements and generation of data models, capable of capturing all aspects of business processes necessary to perform multifactor (multi-dimensional) analysis of global operations
• Responsible for delivering both logical and physical database models of the normalized operational data store, client data, product data, and historical repository to ensure the common understanding of data entities across different arms of the business, including reference data, and to achieve the best performance of procedures developed by the team, also produced the star-schema model for the usage by the OLAP components developed in Business Objects XI and SSAS.

Confidential, Seattle, WA

Enterprise Architect

Responsibilities:

• Responsible for conceptual and physical data modeling, process architecture, business analysis, gathering business requirements, aligning financial data feeds coming into the fixed income products performance and risk management analysis system from both internal and external sources; PolyPaths, Intex, BBG, etc.
• Designed the mathematical calculations of various risk measures, risk margins as an integral component of the multidimensional analysis of financial data
• Modeled star-schema for the OLAP component
• Developed SQL procedures for the DTS/SSIS packages that populated the star-schemas, from which the OLAP cubes were sourced
• Architected reference data repository, designed reference data management tool
• Architected enterprise-wide Market Risk repository system (Loans, Equities, Fixed Income and Derivatives - SWAPS, FUTURES, OPTIONS, etc.) from its inception to the delivery of the first production version of it. This included data modeling, information architecture of the front-end component, as well as lead a team of developers who were tasked with implementing the ETL process
• Developed reporting using SSRS
• Responsible for the data and process architecture, development of bank-wide reporting environment using ProClarity, as well as development of SQL procedures for the Fixed Income desk at the bank integrating data sourced from multiple internal systems, as well as from outside sources
• Designed and optimized conceptual, as well as physical schemas of the databases for Prime Finance, as well as star-schemas for the OLAP type of analysis
• Responsible for dimensional design and modeling, as well as modeling of reference data used to populate the dimensions
• Designed and implemented fuzzy logical approach aimed at integrating collateral information from two different sources Intex and Loan Performance System

Confidential, VA

Data Architect/BI Architect

Responsibilities:

• Involved with the business analysis, data architecture and development for the 2003 closing of the books project, which was successfully completed on June 30, 2004
• Served as an Enterprise System Architect for the operational and management analytical Fixed Income products data processing system, as well as 2004 closing of the books project
• Interacted with the subject matter experts at Confidential to create business taxonomy.
• Responsible for Conceptual Design using ERwin, multidimensional design (snowflake-schema) for MicroStrategy, reverse engineering of Sybase SQL, UNIX shell, and Perl scripts
• Conducted analysis and redesign of the existing business process, data model, ER Diagram using ERwin, data and process flow, identified weak spots and inefficiencies
• Consulted and advised the executive officers of the company concerning data, analytics, portfolio management, management reporting, outsourcing, scoring models and information architecture in general
• Built a number of enterprise-wide financial Data Warehouses storing large amounts of transactional data, such as trades of instruments, and structures thereof (Equities, Fixed Income - RMBS, CMBS, CDO, CLO, etc., and Derivatives SWAPS, FUTURES, OPTIONS, etc. based in part on the data feeds (Intex, Reuters, Moody’s, etc.), reference data repository systems, ), as well as risk metrics, risk margins and other measures for IB, Prime Finance and other areas
• Worked on design and development of real time analysis tools, as well as gathered and documented business requirements from the clients of Aleri, such as Lehman Brothers, Deutsche Bank, UBS, etc.
• Led data/process architecture projects, as well as development projects involving utilization of outsourced programming and design resources in the Russian Federation.

Confidential, NY

VP of Data Architecture

Responsibilities:

• Managed several data warehousing and real time financial data analysis tools projects for major financial industry players involving information architecture, data modeling, storing and processing large numbers of records describing the trades and static data pertaining to financial instruments traded by the clients, based in part on the data feeds (Reuters and Moody’s, etc.)
• Analyzed business and systems for the clients, as well as gathered & documented business requirements and produced functional specifications
• Led the business analysis and data modeling effort for the AIB Group aimed at reducing the data processing time at AIB Treasury & International by an order on magnitude using vectorized data processing
• Led the modeling effort in the design of the Global Counter Party/Client repository data warehouse (reference data) from its inception
• Gathered and documented business requirements, produced functional specifications for the development team, and performed the logical and physical system design
• Managed the back end SQL development effort for the project (SYBASE), also served as the application DBA
• Managed gathering and documenting business requirements, and produced the functional specifications for conceptually unique model of fully scalable, true metadata driven data warehouse
• Responsible for the Conceptual and Physical Modeling, as well as the backend implementation using SQL, C/C++ and K language, and participated in the front end development in Java
• Designed and implemented the Risk Management system, using Monte Carlo simulation based on the Markovian Process of credit ratings movements
• Gathered, analyzed and documented business requirements, produced functional specifications and designed and implemented a P&L attribution system.