SUMMARY:

• 14 years of Business Intelligence/Data Warehousing experience.
• Expert in leading bigger teams located in different geographic locations in designing and building large scale ETL/ELT applications, Analytical & Reporting applications, Global Reference Data and data quality solutions for Financial, Manufacturing, Health Care, Media and Entertainment industries using Agile and traditional approaches.
• Expertise in Ab Initio/Informatica/SSIS/SAS DI Studio/Talend ETL methodology in designing and developing extraction, transformation and load processes (ETL) with high - volumes for batch and real time applications.
• Expert in high performance ELT based Data Integration solutions using MPP database platforms (Teradata/Netezza) and Informatica Push down optimization (PDO) techniques.
• Expert in Relational/Dimensional data modeling & Data Architecture and exposed to data vault modeling.
• Expert in Data Governance, Data Quality frameworks and best practices.
• Expert in building Data Integration (DI) Architecture Framework that supports rapid development of ETL applications with Audit, Balance and Control (ABC) capability, performing Impact Analysis and building Data Lineage reports.
• Proven experience in implementing scalable Metadata solutions to capture enterprise wide business and technical Metadata in one central repository, establish connections among different Metadata categories and provide an interface to search for Metadata.
• Expert in the implementation of Master Data Management (MDM) solution for reference codes for Health Care industry and Instrument/Security reference data for Investment Banks.
• Exposed to SOA architecture, Big Data Analytics using open source software framework hadoop, Enterprise Data Lake, Cloud Computing and SaaS architecture.
• Exposed to consumption layer tools i.e. Cognos, Business Objects, Micro Strategy and SAS.
• Proven experience in Teradata, Oracle, DB2, Netezza, Sybase, and Redbrick.
• Excellent leadership qualities in mentoring, delegating and coordinating responsibilities in a dynamic environment with effective communication and presentation skills.
• Diverse business knowledge across healthcare, media, entertainment, manufacturing and finance industries.  

TECHNICAL SKILLS:

ETL Tools: Ab Initio, Informatica, SSIS, SAS DI Studio, Talend

Relational Databases: Teradata, Oracle, DB2, Sybase, Netezza, SQL Server, MS Access

Big Data Technologies: Hadoop, Pig, Hive, MapReduce, DataLake

Reporting Tools: Cognos, SAS BI, Business Objects, Micro Strategy, QlikView, Tableau

Data Quality Tools: Ab Initio Data Profiler, Informatica IDQ, SAS DataFlux dfPower Studio

OLAP Technologies: SSAS, SAS OLAP Cube Studio

Metadata Technologies: Ab Initio Metadata Hub, Informatica Metadata Manager

Scripting Languages: Korn Shell, VI, Sed, Awk, Perl, Python

Job Scheduling Tools: Tivoli Work Load Scheduler (TWS), Autosys, Control M, Maestro

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Leading the effort to migrate, enhance and integrate the critical rebate accounting system datamarts from OptumRx and CatamaranRx legacy environments as part of the larger Optum and Catamaran integration program ORCA.
• Data from Rebates transactional system is brought into Hadoop Data Lake.
• Ab Initio data management framework is used to process the data, apply the rebate accounting rules and finally load ready files are loaded into the datamart on Netezza. Extracts are sent to downstream applications.
• Responsible for successful end to end delivery of the first phase of the application under tight deadlines.

Environment: IBM DB2 I-series, hadoop data lake, Talend, Ab Initio, Netezza & MicroStrategy.

Confidential 

• Led the effort in designing and developing an end to end data quality solution for Client Reference Data program (CRD) at Confidential ISG division for different business imperatives/domains i.e. Dodd Frank, FATCA, UK/US AML, EMIR, MiFID, Customer Identification Program (CIP), GICS, RDC Regulatory Screening & Global Rolling Review.
• Responsible for designing and developing an account validation engine (AVE) that provides the business with a 360 degree view of the data quality of any account on a QlikView dashboard.

Environment: Informatica IDQ Developer, Sybase & QlikView.

Confidential

• Led the effort in designing and building a centralized reference data repository at Confidential to provide consistent, complete, & accurate reference data to all of the downstream client reporting applications.
• Bloomberg is the primary vendor of the security master, security pricing, issuer & FATCA data.
• Reference data for securities/instruments held in CPB client portfolios is only maintained in RDH to optimize cost and processing times.
• Designed the scalable data model to capture and maintain the reference data from multiple reference data vendors.
• Designed the rules driven MDM solution to determine the golden copy from different vendor feeds.
• Designed a scalable solution to classify securities based on business classification rules from a web interface.

Responsibilities:

• Led the effort to build credit portfolio datamart at Bank of Oklahoma that provides a standard set of reports to the primary constituencies (credit administration, business line management and regulators) describing critical aspects of BOK's credit portfolios and delivering an ad-hoc reporting capability that will allow credit administration and business line management staff to reasonably answer questions relevant to BOK's credit exposures.
• Designed and developed the SSIS packages to extract data from source systems into staging area and from staging to Warehouse.
• Implemented hash methodology to do efficient comparison while building type2 dimensions.

Environment: SSIS, Cognos, SSAS Cube, SQL Server 2008, Oracle, SQL, .NET Framework 3.5, UC4

Confidential

Development Lead

• Worked for around three years in multiple roles at Dell IT Enterprise Business Intelligence (EBI) division as end-to-end development lead/solution architect/ETL Architect for the critical analytical applications i.e. World Wide Revenue, Units and Margin (WWRUM), Financial Reporting Initiative (FRI), Client Reinvention (CR) and Global Attach Rate. Implemented data marts on Teradata using Informatica as the integration tool.
• Informatica PDO technique was used. Reviewed the teradata explain plans and recommended PI to be used, stats to be collected to improve the query performance.
• Row level security was implemented using MicroStrategy command manager scripts.

Environment: Informatica, Business Objects, Micro Strategy, SSAS Cube, Teradata, Oracle, SQL, Linux, CTL M, KSH, Linux

Responsibilities:

• Worked in multiple roles as SAS platform Administrator and also as Data Integration Architect for the Customer Data Environment (CDE) project to provide the necessary platform for Disney to capture, consolidate, leverage and deliver customer information for reporting, analytics, modeling and campaign management activities.
• Additionally, the CDE project will provide processes to manage customer data and clear strategies to leverage and monetize data from across business units.
• Responsible for developing data model to store audit, balance and control (ABC) information with the help of data modelers.
• Identify and design the architecture utilities to load audit, balance and control (ABC) tables and to collect run time statistics of the ETL jobs.

Environment: SAS 9.1.3, SAS DI Studio 3.4, SAS Management Console, HP Neoview, HP UNIX, Maestro, KSH, PERL

Confidential

• Worked on multiple projects at Blue Cross Blue Shield Association (BCBSA) in different roles i.e. Metadata Architect/Data Quality Analyst/ETL Designer.
• Designed and developed solution to integrate provider data.
• Designed and implemented scalable metadata solution to capture business and technical metadata in one central repository.
• Developed infrastructure to capture, store and maintain reference codes from different business units across BCBSA FEP and also worked as a data quality analyst and was responsible for assessing the quality of the provider data.

Environment: Ab Initio (GDE 1.15.1, Co>Operating System 2.15.3), DB2, SQL, Cognos, CDMA and Ab Initio EME, SSIS, SQL Server.

Confidential

Responsibilities:

• Worked on multiple ETL applications at BCBSA FEP and was involved in the analysis, and design of a number of ETL applications using Ab Initio, DB2 & KSH. BCBSA FEP has a legacy reference codes repository application (CDMA) with backend database as SQL Server and front end interface as MS Access to assist data stewards for storing and maintaining reference codes.
• Developed ETL application using SSIS to integrate codes repository with mainstream ETL application to be maintained by data stewards.

Environment: Ab Initio, DB2, SQL, Cognos, CDMA and Ab Initio EME, SSIS, SQL Server.

Confidential

• Worked on multiple ETL projects at America Online (AOL) and was involved in the analysis, design, development and support of a number of ETL applications i.e. True Comp Payroll, NetAgent, Account Security Question, Customer UpCell & Orion. Converted business requirements into ETL design specifications.
• Created high level design document that contains overall process flow, source and target systems and functional specifications for each Ab Initio graph to be developed.
• Created detail design document that contains detailed information for each individual Ab Initio graph to be developed i.e. what Ab Initio components to be used inside the graph.
• Created job scheduling logic with dependency information between jobs.
• Led the development team in developing applications based on design documents. Responsible for performance tuning of Ab Initio processes.

Environment: Ab Initio, SQL, Netezza, Sybase, Oracle & Perl.

Confidential

Responsibilities:

• Worked on multiple ETL projects at JP Morgan Chase (JPMC) analytical systems division and involved in the design, implementation and maintenance of ETL applications i.e. FDR to TSYS card processor migration, Business card web feed, ACME, & Patriot Act. Designed and developed ETL transformation logic using Ab Initio GDE.
• Developed wrapper scripts for the Ab Initio deployed scripts. Implemented source data validation routines.
• Implemented high volume database loads into Operational Data Store (ODS), and Analytical Data Store (ADS) tables using Ab Initio database components. SQL*Loader Direct Load mechanism with exchange Partition Exchange technique was used to load Tera Bytes of data into ODS tables.
• ODS tables are Range Partitioned and each partition is further subdivided into List Partitions.
• Responsible for performance tuning of Ab Initio ETL processes and database loads.

Environment: Ab Initio, SQL, PL/SQL, Oracle, KSH, Sed, Awk