SUMMARY:

Senior Datawarehouse/BI Solution Architect and Manager with over 11 + years experience in managing large datawarehouse and business intelligence development, implementation and support projects. Experience in Enterprise Datawarehouse Architecture design, tool recommendation and vendor management and ability to lead and handle large team and delivery assurance.Extensive knowledge and experience in analytics, data modeling, predictive and forecasting and working with open source systems.

CORE STRENGTHS:

• Business Analytics
• Delivery Assurance
• Datawarehouse Architecture
• ETL Design and Architecture
• Data Modeling (Star and Relational)
• Data analysis and mapping
• Data Quality and Governance
• Master Data Management
• Production Support

TECHNICAL SKILLS:

Domain: Fixed Income and Asset Management, Equity research, Brokerage, Derivative (Futures and Options).

Data Modeling: Erwin, IBM Rational Data Architect(Star schema and Enterprise Datawarehouse design)

ETL Tools: Informatica 8.x, 9.x, B2B, PowerExchange CDC, Informatica Data Quality, SQL Server Integration Service, Talend, Talend MDM, and Oracle Data Integrator.

BI and Reporting: OBIEE, Cognos Framework Manager, Query and Report Studio, MS Excel.

Programming: T - SQL, PL/SQL, Pearl, Python and Unix scripting.

PROFESSIONAL EXPERIENCE:

Technical Manager(ETL and MDM)

Confidential, NY

Responsibilities:

• Source system data analysis and creating re-usable ETL process.
• Address and account information cross validation.
• Developing customer (Legal Entity) hierarchies and Organizational Hierarchies.
• Designed and support unified data model (Party model) for client on-boarding.
• Technical Delivery and team management.

Tools: - Informatica 8.x, B2B, SQL Server 2008, Oracle Exadata, Unix, Tidal, SQL and Excel.

Technical Manager/Architect

Confidential, NY

Responsibilities:

• Support Daily load of InvestOne data with holdings information and Reports.
• Creating and maintaining new fund information including multi sleeves and multi portfolio funds.
• Developed MSCI BarraOne load process for interfacing with Bloomberg provided asset information.
• Support daily process for upload and download to Factset data for analytical information on holdings and positions.
• Developed ETL for providing data for Yield to Worst and Yield to Mature Reports.
• Fixed incorrect Market Value calculation based on Asset classes.
• Support for small enhancements and bug fixes.
• Technical delivery management.
• Data Model design as per Bus Architecture.
• Build Informatica ETL mappings to maintain type 1 and type 2 dimensionality when loading Fund (sleeves), Security, Benchmark, Index dimensions.
• Design and build Slowly Changing Dimension and Surrogate key creation logic in the mappings.
• Design and ETL Fund level and security level analytic fact tables (including risk analytics) for holdings and Index constituents.
• Build ETL mappings to create Fund-Benchmark and Benchmark-Index relation fact snapshots.
• Design mechanism to load benchmark and index level facts in order to facilitate comparison reports (Cognos) of Fund vs Benchmark analytics.
• Implement business rules and logic to implement netting rules as per ISDA agreement with Counterparties and calculate risk exposure through OTC derivatives. Load Entity dimension and counterparty holdings and counterparty netting facts.
• Technical Delivery Management

Tools: - Informatica 8.x, Actuate10, Cognos, Oracle 10g, SQL Server 2008, Unix, Python, Excel, SQL and Autosys.

ETL Architect/Lead

Confidential

Responsibilities:

• Designed and developed data models for Customer (Legal Entity), Driver History and Third Party Interfaces.
• Attending JAD and Requirement sessions.
• Designed Change Data Capture Architecture for forward flow of data from Mainframe DataCom DB.
• Design and implemented PowerExchange for real-time CDC.
• Developed ETL specs, design and deployment document.
• Overseeing ETL development and Data Quality issues.
• Technical Delivery Management.

Tools: Informatica 8.x,PowerExchange 8, Oracle11g,Unix Scripting, Business Objects and Erwin.

Data Integration Consultant

Confidential, PA

Responsibilities:

• Participate with business to review existing architecture with the Client.
• Analyzing existing mapping and ETL process for Sales Datawarehouse.
• Created Informatica mappings/workflow to parse EDI files to capture returns by product and calculate net quantity sold.

Tools: Informatica 8.x, Oracle 10g, Autosys.

Confidential

Responsibilities:

• Designed and developed enhancing the functionality Confidential customized credit allocation, quota calculation and reporting dropship audit.
• Designing and Developed Confidential ’s External Credit Allocation (ECA) process and practices.ECA allocate Sales Transactions to corresponding Participants and/or Positions and/or Titles prior to TrueComp compensation calculation.
• Designed and Developed Darwin a sales compensation and forecasting datawarehouse providing ad-hoc, trending and forecasting data.

Tools: Informatica 8.x, Oracle 10g, Oracle Data Integrator, Cognos Datamanager, SQL Server 2005/ 2008, Excel, TSM.

ETL Architect

Confidential, NY

Responsibilities:

• Created reports and dashboard for equity research applications
• Document system flow.
• PL/SQL Scripting.

Tools: Qlick View, Oracle 10g, Excel.

Datawarehouse Architect

Confidential, Jersey City

Responsibilities:

• Worked with service owners/ end users to identify performance measures of their services.
• Identified Key performance indicators and value added measures for the service areas.
• Identified threshold and SLA for services.
• Analyzed source system for all the service area and profiled data.
• Developing Functional Specification document for Data mart.
• Designed and data modeling for data warehouse (Star schema) for 9 service areas.
• Developed Data mapping document.

Tools: - Sybase 12, Erwin, Excel, Informatica 7.x, SQL and .net.

Datawarehouse Developer

Confidential, NY

Responsibilities:

• Loading Data from various vendors like Thomson, Confidential and IBES into staging tables.
• Reading the COA table for PAC Data and mapping with Informatica mappings.
• Calculating ERI and other aggregation at the staging level.
• Developed dynamic tables for creating weekly and monthly summary reports.
• Calculating ERI and other aggregation at the staging level
• Developed Equity Valuation process using multi stage DCF and residual income model
• Created Staging, Dimensions and Reference table mappings to load data feed from transaction systems and, reference data source systems (Securities Master database)
• Design ETL request process containing security identifiers (CUSIP, ISIN…) to source attributes (Price, Rating…) for instruments holding balance positions in the warehouse.

Tools: Sybase 12, SQL Server 2005, Erwin, Excel, SQL, Informatica 7.x, and .net.