Data Warehousing/Master Data Management Technologies

• Business Intelligence Tools: Microstrategy 9, BusinessObjects 5.x 6.x including Webintelligence ,
• Data Modeling Tools: ERWIN All Fusion r7.2, ER Studio 8, Visio,
• ETL Tools: Informatica 5.x and 6.x, Abinitio GDE 1.14.33/2.14.102,
• Data Warehouse Design/Architecture : Dimensional Modeling, ODS Modeling, Star Schema, Snow Flake Schema,
• Relational Databases: SQL Server 2000/2005/2008, SQL Agent ,Oracle 8.i 9.i, 10G, Toad 11
• Data Warehousing Methodologies Kimball, Bill Inmon
• Summary of Experience:
• Data Warehouse/Data Architecture/Data Quality/MDM:
• Designed and Implemented multiple Finance Data Warehouses primarily in SQL server
• Designed ODS, Data warehouse and Data mart data models
• Designed multiple system integration architecture
• Demonstrated leadership in the development and implementation of strategic and tactical data related initiatives.
• Designed and implemented in SQL server and Excel quantitative models for data validation
• Determined and provided remediation of data quality related issues working with large and complex enterprise data repositories and large volumes of data.
• Extensive Hands on Experience in Data Modeling, SQL, Metadata Management, End to End Data Warehouse Process Design, Source to Target Data Mapping, MDM match Rule Design, Data Cleansing Rule Design
• Extensive experience with Data Warehouse Architecture, Data Architecture, System Integration Design and Architecture
• Designed Match Rules, Data Cleansing Rules for Master Data Implementations
• Determined Existing Process Flows and Developed Future Process Flows, in conjunction with Users, Using Tools Such as Visio, Power Point and Data Modeling Tools
• Perform data mining and analysis to support ongoing continuous price monitoring of operational or financial data to recognize patterns and trends, investigate anomalies, and assess internal control environment.
• Developed Data Strategy for Multiple Clients
• Developed MDM Solution Architecture for Multiple Clients
• Managed Successfully Delivered Multiple Data Warehouse, MDM Projects
• Management Experience:
• Provide thought leadership and problem solving capabilities specific to data acquisition, analysis and interpretation.
• Demonstrated team leadership experience in complex organizations and ambiguous situations
• Identified and escalated issues impacting delivery timelines and budget.
• Planned and executed data analytic procedures in support of audits, investigations and special reviews, with a minimal supervision
• Reviewed and documented processes, procedures, and control environment
• Drafted reports detailing work performed and conclusions reached
• Ability to concurrently work on multiple projects and participate in assignments in a team environment.
• Strong organizational skills and proven ability to effectively prioritize initiatives to meet expectations.
• Excellent communication and interpersonal skills required with the ability to present complex and sensitive issues to all levels of senior management.
• Authored Business Requirements documents, Functional Requirements Documents, Process Flow Diagrams and Technical Design Documents for Various Clients
• Managed Off-Shore and Onshore Teams team sizes have been between 8-10
• Designed End to End and Delivered Multiple Successful MDM, Data Warehouse/BI Projects

Experience:

Confidential

Data Architecture/Financial Reporting

Price Validation Data Mart Architecture Design:

Designed and implemented pricing validation data primarily for Fixed Income and Equities. Created a staging area, and a data mart for pricing data analysis and reporting.

Securities Exception Reports Design Development in SQL Server and Microstrategy

• Worked with AIG corporate IT to implement several reports for the valuation group. These multi-vendor price reports contained asset class based security price exception rules. These rules isolated securities as pricing exceptions based on various algorithms that are based on the staleness of pricing, number of vendor/broker pricing available for a security etc.
• Created several stored procedures in SQL server to create pricing exception reports from the data mart
• Created Monthly CDO-CLO reports in Microstrategy to determine prices of AIGs CDO holdings. These deals are validated in INTEX if the observed price falls outside of price tolerance.
• Created Short term Investments report in Microstrategy
• Created custom reports on as needed basis for own pricing analysis and for the analysis in support of other analysts within the pricing group

Data Governance:

Created and maintain all documentation around algorithms and business rules and definitions of fields used in the reports

Reports Testing

Verified the price tolerance rules for different asset classes using SQL server advanced queries to ensure business rules/algorithms were implemented correctly for all the reports

New FAS 157 Rules Engine Development and Impact Analysis

The current FAS leveling rule set is deemed to be extremely complex. Worked with analysts to implement a new set of rules that try to simplify the FAS leveling process by only changing Asset Classes, Tranches and Ratings. We changed rules on certain asset classes and pricing categories to determine the flows in and out of level 2 and level 3

Data Audit Controls

Multilevel 10K/10Q Reconciliations by Asset Class : Created a multi-step process that reconciles the marked to market fixed income and equity securities from an unadjusted month end market value to the adjusted market value that reconciles to the 10k/10Q market

value

Market Value Reconciliation: Identified the factors needed in addition to Price and Notional to validate the market value in the data warehouse.

Presentation/Documentation for Internal Audit: Met with Internal Audit group to walk them through the whole process of pricing exception reports development and implementation and incorporated their feedback as when deemed appropriate

Fixed Income Securities Price Valuation

• Validate Price for sovereign bonds for the Short term Investments of AIG using Risk Watch
• Create interest rate data from Bloomberg for the currencies that don't have a yield curve in Risk Watch
• Implemented an MBS cash flow model PSA and CPR in a SQL server database based on PV, average life, SMM, Amortization factor and various other variables.

Confidential

Information/Data Architect

• Designed Staging Area, ODS, Data Warehouse, Data mart for State reporting
• Created Data warehouse Architecture containing Dimensions, Facts, Fact-less Facts Degenerate Dimensions
• Designed and ODS architecture that is more normalized that enables us to store detailed member information
• Designed a switch table technique to convert source data into a star schema
• Designed a normalized Snow Flake member dimension

Confidential

Senior Data Warehouse Architect: Designed a Reporting Data Warehouse for Barclays Client-Onboarding group

Project Solution Delivery Management

• Managed a team of three consultants
• Was Responsible for the Management Delivery of a Document Management Solution that contained Business Analysis Data Analysis technical Architecture Design

Data Warehouse Strategy Delivery:

• Designed Data ETL Integration architecture for new document management system
• Designed the new systems metadata and reference data architecture
• Used Statistical Quality control Six Sigma methods to Client On Boarding Milestones performance management metrics
• Designed BI strategy around the performance management metric

Confidential

Senior Data Warehouse Architect: Designed a Reporting Data Warehouse with Informatica as the ETL tool

Project Management Business Analysis

• Managed the Master data Management Data Warehouse Solution Delivery
• Met with Business Stakeholders Users to Understand Master Data Requirement Governance Requirements

MDM Architecture, Design Solution Delivery

• Designed Match Rules for Multiple Reference Entities, e.g. Constituents, Universities, Schools
• Designed the Hub Integration Process with the Data Warehouse
• Designed Outbound Integration Processes Among the Hub and Other OLTP systems

Data Warehouse Strategy Delivery:

• ETL Architects and ETL developers
• Performed an Assessment of the Existing Reporting Architecture
• Developed a Data Warehouse Strategy and Roadmap

Data Warehouse Design Architecture:

• Designed a Reporting Data Warehouse based on Ralph Kimball Methodology
• Designing a Factless Fact Table for Reference Master Data

Conversion/Migration of Current CRM system to SalesForce

• Developed strategy and execution plans for CRM system migration from SalesLogix to Sales Force
• Developed an Analytical Framework for Data Migration Data Conversion
• Working on a Strategy to Minimize the impact on Reporting Due to this Migration

Confidential

Senior Data Architect

Data Modeling/Data Warehouse Architecture and Design/BI solutions/Metadata Management

• Developed and Implemented a Credit Card Loyalty Data Mart in SQL server 2000
• Managed the technical Design data Warehouse Solution Implementation
• Designed Implemented Enterprise Data Warehouse for Credit Card Group containing an Stating Area, ODS and a Data Mart
• Developed the Automation of the Data warehouse

Confidential

Data Architecture and Collateral Analysis of CDOs

• Created Data Architecture, Databases and ETL Processes for Underlying Collateral Analysis
• Designed Automated Recursive Processes to Analyze CDO Data
• Used Data from Two Different Sources Trading Historical to Design the Data Mart

Data Warehouse Architect, Design and Analysis

• Developed Logical and Physical Data Models for Analysis Used Eventually by the Department of Justice
• Redesigned Data Marts for Specific Reporting Needs Related to On Line Search Engine Merger Activities

Confidential

Senior Data Warehouse Architect

Worked on the data model to integrate data from SAP and Peoplesoft into a Single Data warehouse

Confidential

Senior Architect

Developed Business Process Flows for Serbain-Auxley Compliance for Multiple Business Functions

Confidential

Senior Technical Engagement Manager /Data warehouse Architect

• Managed a Team of 3 Developers at the client site
• Designed a data mart for the customer profile application to gain insight into the customer segmentation

Confidential

Enterprise Data Warehouse Architect/Technical Manager Designed data mart for Asset Under Management AUM

Data Modeling/Data Warehouse Architecture and Design

• Designed the Assets Under Management Data Architecture for Reporting
• Designed a Fact less Fact table for client demographic analysis

Abinito ETL Design and Implementation

• Designed the architecture of the Data warehouse integrating Abinitio as the ETL tool
• Designed the staging, ODS and Data warehouse data model for Asset Under Management