We provide IT Staff Augmentation Services!

Senior Data Analyst/program Management Consultant Resume

2.00/5 (Submit Your Rating)

SUMMARY:

  • Confidential 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, 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 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.
  • 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

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

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

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 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:

  • Client Wells Fargo: 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 data for MDM. Designed ESB with SOA for calculations, and pre-calculated results. Provided a data virtualization layer. Work on the data governance program development. Used TOGAF to capture current state enterprise architecture, and to communicate future direction ideas.
  • 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.
  • Client Barclays: 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. Provided data virtualization layer. Informatica as ETL. Performed data mapping for the ETL, and for a number of data transformation routines developed in SQL. Engaged in the data analysis efforts to infer the logical and physical properties of the data and of the information it represented.
  • Client BMO: 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, with Hadoop having been used as the data repository.
  • Involved in presales efforts/analysis.

Confidential

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.
  • Built an MDM repository,
  • Customized the proprietary data repository logical model for the client.
  • Collected, compiled and analyzed relevant information for the assessment of the impact of migration from a legacy data repository to a meta-data driven data repository
  • Developed code for loading vendor data into the new data repository.
  • Assisted with the remediation of differences between the two 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, 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 MDM repository (Asset Control) to a metadata driven 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 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 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 for data governance.
  • Conducted technical and business analysis of the requirements for the meta-data repository project to scan the 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 Data and Master Data (Client, Counterparty & Product MDM) architecture & modeling related work
  • Worked on the data-warehousing components data modeling

Confidential

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 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 Data and Master Data (Product & Client MDM)
  • Modeled client data management and migrated from legacy to a new repository.
  • Work on the data governance program development.
  • Informatica as ETL
  • Used TOGAF to capture and to communicate enterprise architecture proposals, ideas.
  • Data mapping for Informatica, as well as for manual data transformation tasks using PL/SQL.
  • Worked on POC projects, such as 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

Confidential, NY

Enterprise Architect Consultant

Responsibilities:

  • Provided data architecture on the Cash Securities Data Store program
  • Responsible for the current state analysis of the global trades processing, trade information and 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 data), static reporting and OLAP systems, globally
  • Made proposals to the executive management encompassing all aspects of data and process architecture.
  • Performed Information Architecture of the ratings issuance events capturing system, including client, instrument and business entity 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 data solution involving Golden Source, as one of the components of data management the solution
  • Worked on the data modeling for the Intex / Zenta data feeds replacement project.
  • Hibernate used for data virtualization.
  • 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 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.
  • 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, with the SOA implemented using .Net
  • Developed SQL procedures for the DTS/SSIS packages that populated the star-schemas, from which the OLAP cubes were sourced
  • Architected data repository, designed 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

Confidential, NY

Enterprise Architect/BI Architect

Responsibilities:

  • 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 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
  • 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 Freddie Mac 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

Confidential, NY

Strategy Consultant

Responsibilities:

  • 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

Confidential

Systems Architecture Consultant/BI Architect

Responsibilities:

  • 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.), 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

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

Confidential

Enterprise Information Data Architect

Responsibilities:

  • Led the modeling effort in the design of the Global Counter Party/Client repository data warehouse ( 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

Confidential

BI/ Information Architecture Consultan t

Responsibilities:

  • 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.

We'd love your feedback!