SUMMARY

• Total 11+ Years of Information Technology experience in Banking, Insurance and Automobile domain.
• Good knowledge of Data - Warehousing concepts (Dimensional Modeling).
• Extensively worked in due-diligence for scoping, source system analysis, target system requirements, volume analysis, business requirements etc.
• Responsible for interacting with Client to identify information needs and business requirements for end users.
• Experience in High-Low level ETL design, data migration/integration methodology, developing strategies for Extraction-Transformation-Loading (ETL) mechanism, development, unit-testing and integration testing using various ETL tools and techniques.
• Good exposure to Data Validation and Data Cleansing activities.
• Good knowledge of database architecture and concepts; proficient in Oracle, SQL, PL/SQL and UNIX Shell Scripts.
• Worked on Data Migration and Tool Migration projects as ETL developer.
• Exceptional analytical and problem solving skills.
• Team player with the ability to communicate effectively at all levels.
• Experience to work cohesively with onsite-offshore model project.
• Full life cycle experience including requirement analysis, design, development, testing, implementation and documentation.
• Involved in Testing and Test Plan Preparation, Process Improvement for the ETL developments.
• Worked on Unix/Linux/Windows platforms. Have good knowledge of Unix Shell scripting.
• Working exposure to Bigdata Technologis, Hadoop, Spark.

TECHNICAL SKILLS

ETL Tools: IBM web sphere Data Stage (PX and MVS Editions) 7.5/8.0.1/8.5/11.3, Informatica 8.x/9.x

Operating systems: UNIX, AIX, OS-390 Mainframe, MS-DOS, Windows XP, NT Server 4.0, 2000/98

Database: Oracle 8i, Oracle 9i, DB2 UDB, Sybase, Teradata, Casandra

Programming Skills: Oracle PL/SQL, UNIX Shell Scripting

Certification: IBM Certified Solution Developer - WebSphere DataStage v7.5

Big Data: Technologies, Hadoop, Spark

PROFESSIONAL EXPERIENCE

Confidential

BI Technical Architect

Responsibilities:

• Create High Level - Low-level ETL design.
• Review and finalize design guidelines for ETL developers, design documents.
• Involved in the process of data modeling.
• Development of ETL Jobs
• Owner of all the Unix scripting required for the project.
• Unit Testing, Integration Testing

Environment: /ETL Tools: UNIX, AIX, Mainframe, IBM DB2, Shell Scripting, Informatica 9.0, Teradata, Control - M Scheduler

Confidential

BI Technical Architect

Responsibilities:

• Create High Level - Low-level ETL design.
• Review and finalize design guidelines for ETL developers, design documents.
• Involved in the process of data modeling.
• Development of ETL Jobs
• Owner of all the Unix scripting required for the project.
• Unit Testing, Integration Testing and UAT Support

Environment: /ETL Tools: UNIX, AIX, Mainframe, IBM DB2, Shell Scripting, Informatica 9.0, Teradata, Control - M Scheduler

Confidential

BI Technical Architect

Responsibilities:

• Create High Level - Low-level ETL design.
• Review and finalize design guidelines for ETL developers, design documents.
• Involved in the process of data modeling.
• Development of ETL Jobs
• Owner of all the Unix scripting required for the project.
• Unit Testing, Integration Testing and UAT Support

Environment: /ETL Tools: UNIX, AIX, Mainframe, Teradata, IBM DB2, Shell Scripting, Informatica, Control - M Scheduler

Confidential

BI Technical Architect

Responsibilities:

• Create High Level - Low-level ETL design.
• Review and finalize design guidelines for ETL developers, design documents.
• Involved in the process of data modeling.
• Development of ETL Jobs
• Owner of all the Unix scripting required for the project.
• Unit Testing, Integration Testing and UAT Support

Environment: /ETL Tools: UNIX, AIX, Mainframe, Teradata, Sybase, IBM DB2, Shell Scripting, Informatica, Control - M Scheduler

Confidential

ETL Architect/Developer

Responsibilities:

• Create High Level - Low-level ETL design.
• Review and finalize design guidelines for ETL developers, design documents.
• Involved in the process of data modeling.
• Development of large chunk of the ETL Jobs
• Owner of all the Unix scripting required for the project.
• Unit Testing, Integration Testing and UAT Support

Environment: /ETL Tools: UNIX, Mainframe, IBM DB2, Shell Scripting, Informatica

Confidential

ETL Consultant

Responsibilities:

• Analysis of the Informatica Mappings
• Development of Datastage PX Jobs using Datastage 8.0.1
• Consolidation of Job Designs and Fixing Jobs as per Informatica Jobs.
• Unit Testing of the Datastage PX Jobs

Environment: /ETL Tools: UNIX, Mainframe, IBM DB2, Shell Scripting, Oracle 9i, IBM web sphere Data Stage Parallel Edition 7.5

Confidential

ETL Consultant

Responsibilities:

• Analysis of the Business Rules and Mappings.
• Analysis of the source data from DB2 and Oracle databases.
• Designing Datastage PX jobs for monthly and daily flows for wholesale and retail.
• Creation of sequence jobs for extract, load and transform jobs.
• Unit Testing of the Datastage PX Jobs through running queries on DB2 and oracle databases using aqua studio.

Environment: /ETL Tools: UNIX, Mainframe, IBM DB2, Shell Scripting, Oracle 9i, Flat Files, IBM web sphere Data Stage Parallel Edition 7.5

Confidential

ETL Consultant

Responsibilities:

• Participated in due-diligence for scoping, source system analysis, target system requirements, volume analysis, migration window determination, data quality analysis etc.
• Review Hi level - Low level ETL design.
• Analysis of the Business Rules and Mappings and the source data.
• Designing Datastage PX jobs using the mappings.
• Unit Testing of the Datastage PX Jobs

Environment: /ETL Tools: UNIX, Mainframe, IBM DB2, Shell Scripting, Oracle 9i, Flat Files, IBM web sphere Data Stage Parallel Edition 7.5

Confidential

ETL Consultant

Responsibilities:

• Analysis of the Informatica Mappings
• Established a testing process suitable for the project.
• Development of Datastage PX Jobs using Datastage 8.0.1
• Consolidation of Job Designs and Fixing Jobs as per Informatica Jobs.
• Unit Testing of the Datastage PX Jobs
• Involved in Preparing Issue Documents

Environment: /ETL Tools: UNIX, Mainframe, IBM DB2, Shell Scripting, Oracle 9i, Flat Files, Informatica

Confidential

Offshore Technical Lead

Responsibilities:

• Coordination of the Off Shore team
• Participate in meeting with part-project leads and solution architect to discuss and resolve the issues.
• Review High Level - Low level ETL design.
• Review and finalize design guidelines for ETL developers, design documents.
• Involved in Migration of Transactional data from the Source system VE of DBV to target system ZI of AXA
• Development of the Preparation module (Changing the Source IMS data sets into format which can be operated easily), Transformation Module (Actual transformation from source to target using the DB2 tables as temporary storage), DDLZ and SDLZ modules (Identifying the periods without cover in the source data and splitting them depending on legal covers)
• Supported in creation of test cases and test data for the above modules.
• Providing support and changes in the program during the Client Test runs

Environment: /ETL Tools: UNIX, Mainframe, IBM DB2, Shell Scripting, Oracle 9i, Flat Files, Complex Flat Files, IBM web sphere Data Stage MVS Edition

Confidential

ETL Developer

Responsibilities:

• Participate in meeting with part-project leads and solution architect to discuss and resolve the issues.
• Review Hi level - Low level ETL design.
• Involved in Migration of NUD Claims from Huon mainframe system to Exceed Mainframe system
• Involved in Extensive interactions with system experts to understand the Business Requirements.
• Development of the Financials module of the claims stream, which included the transformation of data from HUON to EXCEED through the use of DB2 tables as temporary storage. Also involved in the implementation of Motor stream of Policy Module.
• Providing support and changes in the program during the Client Test runs and Production runs

Environment: /ETL Tools: UNIX, Mainframe, IBM DB2, Shell Scripting, Oracle 9i, Flat Files, Complex Flat Files, IBM web sphere Data Stage MVS Edition

Confidential

ETL Developer

Responsibilities:

• Involved in the development of the modules Extraction of data from the Operating offices and Packet transfer of the data to the Regional offices
• Involved in the implementation of the package at the Operating office and support during that period
• Monitoring and insuring smooth transfer of data from the Operating offices to the regional office
• Understanding the reporting requirements of the client and generating the reports using the Oracle Discoverer

Environment: /ETL Tools: UNIX, Shell Scripting, Oracle 9i, Flat Files, PL/SQL, Oracle Forms, Oracle Discoverer