SUMMARY:

• 8+ years IT experience in Data warehousing & ETL Design, Development, Enhancement, Maintenance, Production support using IBM Datastage (7x,8x,9x) with extensive business knowledge in Insurance, Banking and Retail domains
• Conversant with Kimball, Inmon Concepts of Data Warehousing and Dimensional Data Modelling such as Star Schema, Snow Flake Schema and IIW Modelling such as Anchor Modelling.
• Data profiling to integrate the source data from multiple source systems into a common Data warehouse and there by provide appropriate mapping rules based on the source & target models.
• Experience in using the modelling tool Erwin to make Target model changes and promote the same to higher environments.
• Understand the existing Data Architecture, Data Sources, filter and cleanse data to locate and correct code problems. Assess Data quality and eliminate irrelevant data using IBM Quality Stage data mapping, transformation and loading in the Common Database post Data profiling and Data cleansing.
• Design and development of Reusable components In Datastage to validate the data quality in flat files using the transformer looping techniques and control tables which is reused across multiple projects.
• Capacity planning for resource disk and resource scratch disk used in ETL jobs to ensure the disk space availability in the Unix server for history load and daily data loads.
• Performance tuning by identifying the bottleneck and enabling appropriate partitioning technique, node configuration to enable parallelism in the ETL job.
• Identifying and suggest appropriate indexes in target tables to improve the read capability in DB.
• Worked extensively with the Onsite - Offshore model, co-ordination with clients/users, understanding the client requirements and providing appropriate design.
• Sound analytical and problem solving skills with a good exposure to the key facets of leading teams to meet set objectives and ability to adapt and learn new technologies.

TECHNICAL SKILLS:

Operating System: Windows 2000, UNIX/LINUX

Primary Data Integration Tools: WebSphere Datastage 8x,9x,11x Ascential Datastage 7.5

Secondary Data Integration Tools: Informatica Power center 9.1.6, IBM QualityStage (8.7)

Database: Oracle 9i, Oracle 10G, MS-SQL server 2000, DB2, Teradata

Modelling Tool: ERWIN (Standard edition)

Script Language: Unix

Scheduling Tools: Autosys

Tools: /Utilities: Toad, HP Quality Center, PEGA, Erwin (Data Modelling)Big Data Hadoop, Hive, Map Reduce, Pig

PROFESSIONAL EXPERIENCE:

Confidential

Tools: & Technologies:IBM Websphere Datastage (8.7, 9.1,11.3), UNIX, DB2(LUW, z/os), Erwin Standard

Project Lead

Responsibilities:

• As a project lead handled the ETL development cycle which includes ideating feasible solutions to the ETL challenges, ETL implementation of Anchor modelling based on IIW Modelling Standards, creation of low level design document and Attribute level mapping document.
• Discussion with End users to understand the report requirements, analyze the source data model and provide mapping rule for the Target table.
• Creation of low level design document and Attribute level mapping document for ODS to Warehouse load.
• Data profiling on the source data to ensure the data quality supports the transformation provided and all the business rules are covered.
• Understand the existing Data Architecture, Data Sources, filter and cleanse data to locate and correct source data issues.
• Design and development of ETL Framework to integrate the data from multiple source systems, which varied in content and format based on the country.
• Design and development of ETL framework to extract, validate and load 250+ standard table data in to a generic Anchor Model based table in IDW.
• Performance Tuning and Identifying Bottlenecks in ETL and DB to enhance the data load capabilities.
• Setting up the environment for Production, which included capacity planning for the Resource Disk and Resource Scratch disk.
• Trigger, Monitor the data load in production environment during the historic data loads.
• Performance Tuning the existing ETL job by changing the target database from DB2 LUW to Netezza DB and thereby show significant improvement in data load performance.
• Creation of UNIX and JIL scripts for scheduling the ETL jobs in production environment
• Involved in creating the change ticket and presenting the ticket to Change Management board for deployment in Production environment.

Confidential

Tools: & Technologies:IBM Websphere Datastage (8.7), UNIX, DB2 LUW

Module Lead

Responsibilities:

• Presented Design solutions in project kick off meetings to the AIG Chief Technology Officer and Architects
• As an offshore Module lead primary responsibilities included requirement gathering from Client.
• Design and development of Reusable components to validate the data quality in delimited flat files using the transformer looping techniques and control tables which is used across multiple projects in AIG
• Built generic dynamic sequencer to process and load the data from multiple pre-defined input file formats
• Designed ETL for validating file header, trailer and business validations applicable to the source systems.
• Designed ETL jobs to process data from Real time applications such as Message Queue in XML format.
• Mentored a team of 5 members to handle Code Review, Testing and Code handover to Non production and production environments

Confidential

Tools: & Technologies:IBM WebSphere Datastage (8.1), Oracle 11i,Unix, PEGA

Module Lead

Responsibilities:

• Involved in estimation, impact analysis and Data Modelling specific to reinsurance domain based on the internal application omega.
• Creation of HLD, LLD and Runbook for the project migration, support and maintenance phase.
• Creation of PEGA rules for data extraction from Pega DB through BIX utility.
• Implementation of SCD type1, type 2 and type 6 dimension tables.
• Troubleshooting various ETL issues and performance tuning to partition the data using appropriate partition techniques.
• Involved in the creation of Change Request documents and Production deployment document as per the client standards.
• Involved in performance tuning the COGNOS query, code reviewing the jobs and data validation using SQL queries.
• Creation of monthly reports using Open source ETL tool TALEND to generate Excel based reports from the SIGMA database.

Confidential

Tools: & Technologies:IBM WebSphere Datastage (8.1), IBM WebSphere Datastage (8.5), Oracle 10g,Unix,Toad, HP Quality Center

Technical Lead

Responsibilities:

• Designed the ETL flow for data extraction till target loading including the creation of low level design documents and attribute mapping documents
• Created UNIX script to validate the header /trailer information in the source files and also to trigger the ETL Jobs from UNIX
• Designed and developed framework to load data from fixed width and Delimited source files into the Staging tables using schema files.
• Effectively used Transformer, Lookup, Join, Funnel, Filter, Remove Duplicates, Sort, Change Capture, Pivot, Pivot Enterprise, Column Import stages.
• Troubleshooting various ETL issues and resolved performance related issues using appropriate partitioning techniques within Datastage.
• Creation of mapping documents and Data lineage documents based on the ETL requirements provided.
• Designed the ETL for Audit and data reconciliation to validate the file load on a daily basis.

Confidential

Tools: & Technologies:IBM WebSphere Datastage (8.1), Oracle 11i, HP Quality Center, Business Objects

Senior Software Engineer

Responsibilities:

• Extensively used Oracle Enterprise and ODBC Connector stages for database for extraction and loading.
• Effectively used Transformer, Lookup, Join, Funnel, Filter, Aggregator, Remove Duplicates, Sort, SCD, Pivot stages Involved in the development of Dimensions, Facts based on STAR schema.
• Involved in the development of Aggregate /Summary tables for BO reporting.
• Involved in Building sequencers for Daily load and History Load
• Troubleshooting various ETL issues within Datastage.
• Code reviewing the jobs and reviewing the Unit Test Case Document.
• Involved in data validation using SQL queries.

Confidential

Tools: & Technologies:IBM WebSphere Datastage (8.1), Teradata, DB2, IBM Fast Track

Senior Software Engineer

Responsibilities:

• Provided Proof-Of-Concept for the ETL jobs as per the Technical Design Document
• Design & Development for extraction, transformation and loading which included the Facts and Dimensions
• Automated ETL job creation using IBM FastTrack by transforming business logic directly into Datastage ETL jobs.
• Development of generic framework ETL jobs to load the master dimension table, Transactional Dimension, and Fact tables
• Extensively used Teradata and DB2 Connector stages for database extraction and loading
• Effectively used Transformer, Lookup, Join, Merge, Funnel, Filter, Aggregate, Remove Duplicates, Sort stages
• Creation of reusable components using Shared Containers to load the dimension lookup failed data in Fact table processing
• Creation of UNIX Scripts to perform validation of the Input Flat Files
• Code reviewing the jobs and reviewing the Unit Test Case Document

Confidential

Tools: & Technologies:IBM WebSphere Datastage (8.0.1), SAP R3, SAP BW, Oracle 10G, SQL, HP UNIX

ETL Consultant

Responsibilities:

• Created Technical Specifications, High Level & Low Level Design, Attribute documents based on the functional specification
• Design & Development for extraction, transformation and loading from SAPR3 source system into SAPBW Target tables using ABAP Extractor and SAP BW stages
• Create and Manage Oracle Tables, Views and Indexes
• Liaising with Business team in designing the functional specifications and Change requestsDesigned the Reject Reprocessing and the corresponding reconciliation process for data rejected due to dimension lookup failure
• Knowledge transfer to off shore teams and coordinating in Production Support
• Written Unit Test cases for the Quality Analysis and assisting the clients throughout the testing process.

Confidential

Tools: & Technologies:Datastage 7.5, Oracle 9i, SQL Server 2000,Mercury Quality Center 9.0

Software Engineer

Responsibilities:

• As a Fresher, trained in Java and Oracle during the initial assessment period.
• Worked in Agile methodology and had a thorough understanding of the Front End Loan Processing application which was migrated from Legacy System
• Development of ETL jobs based on the change requests and Testing front end Capital One Auto Finance Loan processing Application during the migration from SQL Server to Oracle DB.
• Support and monitoring of ETL jobs in production environment.
• Creation of SQL queries to validate the correctness of data loaded.
• Raised critical Bugs and provided support during UAT and Code migration.