EXPERIENCE SUMMARY:

• 9years of experience in IT industry with proficiency in requirements gathering, designing, development, testing, production implementation and production support.
• Over 4 years of experience in leading Multiple ETL projectswith team of3 - 6members.
• Worked extensively in anOnsite and offshore modeland lead the team.
• Good experience in the design, development and implementation of Informatica based projects.
• Good hands on experience inPerformance tuningof Data Stage mappings andquery optimization.
• Good knowledge on various data modelling techniques including dimensional data model using star and snowflake schema.
• Good knowledge withInfosphere DataStage Quality Stage.
• Excellent hands on experience in writing complexSQL queriesin Oracle database.
• Good hands on experience inUNIXshell scripting.
• Vast experience inschedulingETL jobs through Autosys.
• Excellent knowledge on Incident Management & Change Management tools.
• Excellent domain knowledge onInsurance.
• Expertise on project management activities including planning, estimation, resource management.
• My main area of experience has beenin the fields ofData Warehousing, Data Integration, Data Virtualization, Data Visualization and Data Migrationand Developing Client server application using
• IBM Infosphere DataStage (9.1, 8.7, 8.5/8.1.1/7.5.2/7.5.1 ), Oracle, PL/SQL, DB2 UDB, Sybase, SQL
• Server, Netezza, CIS, Qlikview, IBM Quality Stage, Info Analyzer, Fast Track and Shell Scripts,Informatica MDM.
• Have a strong Industry experience in Insurance. My current role is an ETL onshore lead in a development project for Confidential .
• IBM Infosphere DataStage & Quality Stage (9.1, 8.7, 8.1, 7.5)
• Informatica MDM v10.0
• Composite (CIS) v7.0
• Qlikview V11.0
• Basics in Big Data (Hive, Hbase etc)
• Ab-Initio
• IBM WebSphere
• ORACLE 10G
• Netezza
• DB2
• Sybase, SQL Server
• MS SQL Server
• PEGA (Basics)
• Experience in all the phases of the Data warehouse life cycle involvingData analysis, design, and development and testing using ETL, Data Modeling, Online Analytical Processing & reportingtools.
• 8 + years of ETLand data integration experience in developing ETL jobs usingDataStage 8.x/7.x (Designer, Director, Administrator)and developing Parallel jobs using various DataStage stages such asLookup, Join, Merge, Transformer, Aggregator, Funnel,
• Remove Duplicates, Surrogate key Generator, Change Capture, DB2, Sequential file.
• Good understanding ofRDBMSlikeOracle,Sybase, DB2andSQL Serverand extensively worked on data Integration using DataStage for the Extraction transformation and loading of data from various database source systems.
• Experience in data warehousing concepts, ETL programming usingIBM DataStage Parallel, cleansing, transforming, debugging/testing, and data loading across source systems.
• Has workedextensively with SQL&PL/SQL,including performing query optimizations.
• ToStandardizeand cleaning the data usingQuality Stage.
• Experience in developing complexJobs, Sequencesandre-usablejobs/containers.
• Expert knowledge ofperformance tuningsource, mapping, target and sessions.
• Knowledge of fulllife cycle development in Data Warehousing.
• Knowledge on Administrative activities like maintaining jobs logs, setting environment variables, assigning Infosphere DataStageuser rolesusingweb consoleand administrator, creating the projects, configuring project, handling trace files andconfiguration file, unlockthe ETL jobs, etc.
• Experience working inInformatica MDM Huband completed a Master Data Management project in Informatica MDM software.
• Good Knowledge in Composite(CIS) - Cisco Information Server - Data Virtualization Platform
• Working Knowledge in Qlikview (v10.0) - Data Visualization Platform.
• Basic Knowledge in Big data Concepts like (Hbase, Hive, Node configuration etc)
• Extensive knowledge in data warehousing concepts likeOLTP, OLAP, ODS,Star Schema,
• Snow Flake Schema, Dimension and Fact tables.
• Experience working with MS Office Suite (Word, Excel, Access and PowerPoint skills).
• Hands on experience in analyzing and troubleshooting issues atfunctional and technical levels.
• Good functional knowledge to interface withend-usersand to identify the information needs and business requirements.
• Possess good communication and interpersonal skills and ability to work in a team as well as individually.
• Innovative in approach, enjoys learning new methods and ideas and putting them into daily practice.

TECHNOLOGY:

Software: Cobol, JCL, PL/SQL, MQ Series, PEGA,UNIX

Database: ORACLE,DB2,Sybase 12, SQL Server

ETL & BI: IBM Infosphere DataStage 7.5, Infosphere DataStage 8.1IBM Quality Stage, IBM Info Analyzer, CIS(Cisco Information Server), Qlikview, COGNOS,Ab-Initio(High level concepts & working knowledge), Big Data Concepts.

ETL Architecture: Stone soup architecture, Insurance Application Architecture(IIA), Insurance Information Warehouse (IIW)

Hardware: IBM OS 390,Windows, Sun Solaris

Domain Experience: Insurance

PROFESSIONAL EXPERIENCE:

Confidential, Berkeley Heights, NJ

ETL Lead (Onsite)

Responsibilities:

• Analyse multiple source and provide Input mapping for the source system with respect to the target.
• Analyse & come up with a design to accommodate multi character set languages into Worker DataStore.
• Design and prepare specification document for build and test phase.
• Continuous tracking of business requirements from users and documenting the same.
• Assigning individual modules for ETL development to offshore team and tracking it to closure.
• Design and tracking the changes of Components and check for Error free code build across various instances throughout the project.
• QC,UAT and Implementation Support
• Reconciliation report generation at the end of every month processing to tally out charges calculated.
• Building UNIX Scripts to perform various ETL tasks like Archiving, Multiple File processing, FTP, SFTP, Triggering automated mails based on various conditions.
• Code Review and testing of the all the Jobs developed as part of Confidential .
• Debugging the Infosphere DataStage Components using Infosphere DataStage director, whenever problem occurs
• Defect tracking and Resolutions
• Onsite and offshoreco-ordination.

Environment: DB2, Infosphere DataStage 8.7, 9.1, Informatica MDM.

Confidential, Berkeley Heights, NJ

CIS (Composite) and Qlikview developer

Responsibilities:

• Analyse the existing time taken forWeb-servicecalls from different countries (Japan, Malaysia, UK) etc.
• Design and build Application Specification document explaining the problem statement and the intended solution with Composite - CIS.
• Build various Qlikview dashboards connecting CIS to extract data & generate report to attract business.
• Design and tracking the changes of Components and check for Error free code build across various instances throughout the project.
• Analyse the mapping document provided for foreign country processing.
• QC, UAT and Implementation Support
• Reconciliation report generation after each cache refresh.
• CIS Script scheduling using Autosys.
• Code Review and testing of the all the Jobs developed for ODS migration.
• Debugging the CIS and Qlikview components, whenever problem occurs
• Onsite and offshoreco-ordination.

Environment: Composite v 7.0(Cisco Information Server), Qlikview v11.0, Big data (basics)

Confidential, New York City, NY

ETL Onshore Lead

Responsibilities:

• Analysis of various source system and design single extraction layout forIn-boundprocessing.
• Interact with business directly to validate the data loaded in IBM- RDM platform.
• Build Autosys scripts to schedule the Jobs in production.
• Preparing Design specification documents for Cost Center - Confidential .
• Continuous tracking of business requirements from users and documenting the same.
• Assigning individual modules for ETL development to offshore team and tracking it to closure.
• Design and tracking the changes of Components and check for Error free code build across various instances throughout the project.
• Analyse the mapping document provided by business to integrate various source systems.
• QC, UAT and Implementation Support
• Reconciliation report generation after each batch cycle.
• Code Review and testing of the all the Jobs developed as part of Confidential .
• Debugging the Infosphere DataStage Components using Infosphere DataStage director, whenever problem occurs
• Defect tracking and Resolutions
• Onsite and offshoreco-ordination.

Environment: DB2, Infosphere DataStage 8.7, IDM - RDM, COGNOS.

Confidential, Berkeley Heights, NJ

ETL Senior Developer

Responsibilities:

• Analysis of the existing System to enhance its capabilities to support multiple countries
• Preparing Design specification documents for financial processing and enhancements MONET and Guaranty Fund.
• Continuous tracking of business requirements from users and documenting the same.
• Assigning individual modules for ETL development to offshore team and tracking it to closure.
• Design and tracking the changes of Components and check for Error free code build across various instances throughout the project.
• Analyse the mapping document provided for foreign country processing and the guaranty fund feed processing.
• QC, UAT and Implementation Support
• Reconciliation report generation at the end of the month processing to tally out the charges calculated.
• Building UNIX Scripts to perform various ETL tasks like Archiving, Multiple File processing, FTP, SFTP, Triggering automated mails based on various conditions, Performing file validations based data present in oracle table.
• Code Review and testing of the all the Jobs developed as part of Financials.
• Debugging the Infosphere DataStage Components using Infosphere DataStage director, whenever problem occurs
• Defect tracking and Resolutions
• Onsite and offshoreco-ordination.

Environment: ORACLE, Infosphere DataStage 8.1, COGNOS.

Confidential, Jersey city, NJ

ETL Lead

Responsibilities:

• Analysis of the existing System to identify the possibilities of performance tuning.
• Preparing Design specification documents for financial processing and enhancements of the existing ODS and RDW ETL jobs.
• Continuous tracking of the XSD structure change in Front End and incorporating the same in Infosphere DataStage Jobs.
• Assigning individual modules for ETL development to team and tracking it to closure.
• Design and tracking the changes of Components and check for Error free code migration across various instances throughout the project.
• Analyze the mapping document provided for Financials and converting the same into Infosphere DataStage Jobs.
• QC, UAT and Implementation Support
• Migration of existing claims from OCFE front end to accommodate the additional columns that are mapped to ODS and RDW.
• Reconciliation report generation for ODS and RDW for financials
• Code Review and testing of the all the Jobs developed as part of Financials.
• Debugging the Infosphere DataStage Components using Infosphere DataStage director, whenever problem occurs
• Defect tracking and Resolutions
• Onsite and offshoreco-ordination.

Environment: DB2 (Mainframe), SQL, Infosphere DataStage 8.1, COGNOS.

Confidential, Jersey city, NJ

Infosphere DataStage Developer

Responsibilities:

• Data analysis of the source Coventry, ASD and Employee/Location feed.
• Preparation of mapping documents for various modules from source (Coventry, ASD and Employee/Location) feed to target FNI IAA tables.
• Design of XSD structure for source feed files.
• Design and tracking the changes of Components and check for Error free code migration across various instances throughout the project.
• Design of specification and design document for individual modules.
• Stage In and Stage Out data model design for FNI data migration along with the ETL Job development to populate the staging tables.
• XML generation via DataStage with the migrated data for employee and location feed.
• Involved in creation of Infosphere DataStage Jobs to efficiently reuse the existing Front End SP’s to load migration data.
• Reconciliation and audit reports creation for the migrated claims between source and target.
• Code Review and testing of individual data migration module.
• Debugging the Infosphere DataStage Components using Infosphere DataStage director, whenever problem occurs
• Managing the Unit and System testing activities.
• Delivery of System test plan
• Defect tracking and Resolutions.
• QC,UAT and Implementation Support

Environment: Oracle, DB2 (Mainframe), SQL, Stored Procedures, Infosphere DataStage 8.1

Confidential, Jersey city, NJ

Infosphere DataStage Developer

Responsibilities:

• Data analysis of the source GOALD and FLIC DB.
• Continuous tracking of the XSD structure change in Front End and incorporating the same in Infosphere DataStage Jobs.
• Development of individual modules such as ID Population and mapping layer in Claims data Migration Construction.
• Design and tracking the changes of Components and check for Error free code migration across various instances throughout the project.
• Analyze the mapping document provided for migration and converting the same into Infosphere DataStage Jobs.
• Stage In and Stage Out data model design for CDM migration along with the ETL Job development to populate the staging tables.
• Involved in creating Sybase SPs creating for extraction, and testing the same.
• QC, UAT and Implementation Support
• Reconciliation and audit reports creation for the migrated claims between source GOALD.FLIC and target one Claim.
• Generate Claims XML with migrated data via Infosphere DataStage and test for its schematic perfection by consuming the claims via one claim Front End.
• Code Review and testing of the contacts data migration module.
• Debugging the Infosphere DataStage Components using Infosphere DataStage director, whenever problem occurs
• Defect tracking and Resolutions

Environment: Sybase, SQL Server, DB2 (Mainframe), SQL, Stored Procedures, Infosphere DataStage 8.1

Confidential, Jersey city, NJ

Infosphere DataStage Developer

Responsibilities:

• Source GOALD and FLIC Data Analysis.
• Generating profiling reports for the source GOALD and FLIC Database to identify the quality of the data to be migrated.
• Owner for the Development and testing of Policy Instruction module.
• Approach and Mapping Document preparation.
• Preparation of data model design forStage-InandStage-Out tables.
• Preparation of test scripts for the migrated data.
• Coordinating with the Front end and Interface teams to check for the integrity of the Migrated Master data in one claim Front End. Ensured complete support to the testing team.
• QC, UAT and Implementation Support
• Generation of Reconciliation and audit reports for the migrated data.
• Defect tracking and Resolutions

Environment: Sybase, SQL Server, DB2 (Mainframe), SQL, Stored Procedures, Infosphere DataStage 8.1

Confidential

Developer

Responsibilities:

• Source DB Analysis.
• Approach and Mapping Document preparation
• Construction, Testing and delivery

Environment: Infosphere DataStage, Sybase Stored Procedures