SUMMAR:

• 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.
• Well-rounded experience: management, business analysis, architectural and design, testing, implementation and training.

PROFESSIONAL EXPERIENCE:

Solutions Architect

Confidential

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.

 ETL Architect

Confidential

Led the effort to build credit portfolio datamart at Confidential 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

Solutions Architect and Development Lead

Confidential

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

 Technology Consultant, HP

Confidential

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

Senior Consultant 

Confidential

Responsibilites:

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.

ETL Developer

Confidential

Worked on multiple ETL projects at Confidential (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

TECHNICAL SKILLS:

Data Modeling Tools: Erwin, Visio, ER/Studio

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