OBJECTIVES:

7 plus years of experience in Information Technology with progressive development of various Data Warehousing and Business Intelligence projects.

EXECUTIVE SUMMARY:

• 7 Plus Years of Good Experience in Data Warehousing and Business Intelligence projects.
• Experience in ETL and Information Technology with progressive development of various Data Warehousing and Business Intelligence projects.
• I have worked extensively in Talend TIS and Open Studio, SAP BODI\BODS, Informatica 8.6 and above, Oracle Warehouse Builder 10g R1, ODI (Oracle Data Integrator) and have basic knowledge in other ETL tools like Ab Initio, Datastage etc.
• Also extensively worked in PL/ SQL.
• Has been part of developing several POC for multiple customers using Talend Open Studio at Mindtree Limited.

EXPERTISE IN SOFTWARE TECHNOLOGIES:

ETL Tools: Talend TIS 4.1.1, SAP BODI\ BODS, Informatica 8 & above, OWB and basic knowledge in other ETL tools like Ab Initio, data stage etc.

Operating System: Windows 98 and above

Language: SQL, PL/SQL

PROFESSIONAL EXPERIENCE:

Confidential

Environment: SAP BODI\ BODS, Oracle 10g, SQL Server.

ETL Architect. Data Modeler, Database Designer

Responsibilities:

• Playing the role of the ETL Architect and Data Modeler by interacting closely with the Data architects and Business users at Confidential and analyzing the different source systems in place at Confidential to design the optimal data model for the Data - Warehouse.
• Coding up and/or generating database scripts to create databases to contain the data models designed.
• Coordinating with DBAs (Database Administrators) at Confidential to create the databases in the Test and Production environments.
• Designing the Extraction, Transformation and Loading (ETL) logic to load the Data-warehouse from different source systems.
• Ensure accurate understanding of the offshore development of the ETL logic to enable them to build optimal ETL procedures.
• Testing the completed ETL artifacts at offshore to ensure their correctness.
• Maintaining project standard processes.
• Bug tracking and management using specialized bug-tracking tools.
• Monitoring the daily jobs that load the Data-warehouse for the phases of the project that have already been implemented and implementing quick-fixes (if required) in the production environment if required or passing them on to members of the offshore team.
• Receiving and implementing change requests from client personnel for enhancements to be made to the Data-warehouse in production for the phases already implemented

Confidential

Environment: Talend 4.1.1 TIS and Oracle 11g.

ETL Architect & Developer

Responsibilities:

• Interacting with Client directly at Onsite and gathering requirement.
• Part of Source system analysis.
• Designed complete ETL dataflow for Fact and Dimension Load including Reject Handling and Reject Reprocessing of transaction data.
• Understanding and Design the ETL specifications based on the requirement.
• Creating the mappings and PL/ SQL according to the ETL Design specifications.
• Ensure accurate understanding of the offshore development of the ETL logic to enable them to build optimal ETL mappings.
• Creating, Validating and running the jobs and PL/ SQL procedures.
• Reviewing and testing the completed ETL mappings to ensure their correctness.
• Maintaining project standard processes.
• Did Performance tuning for all the Existing and newly developed Jobs.
• Carry out the Unit test for the jobs and procedures developed.
• Responsible for maintaining and reviewing requirement and design documents.

Confidential

Environment: Informatica 8.6 and Oracle 10g.

ETL Architect & Developer

Responsibilities:

• Understanding and Design the ETL specifications based on the requirement.
• Creating the mappings according to the ETL Design specifications.
• Creating, Validating and running the mapping.
• Carry out the Unit test for the mappings and procedures developed.
• Interacting with the Client during the project tenure.

Confidential

Environment: ODI and Oracle 10g.

ETL & PL/ SQL Developer

Responsibilities:

• Requirement gathering from the onsite coordinator and client
• Understanding and Design the ETL specifications based on the requirement.
• Creating the mappings according to the ETL Design specifications.
• Developing PL/ SQL procedures.
• Creating, deploying and running the mapping.
• Carry out the Unit test for the mappings and procedures developed.
• Interacting with the Client during the project tenure.

Confidential

Environment: Informatica 8, Oracle 10g and PL/ SQL.

ETL Designer & Developer

Responsibilities:

• Understanding and Design the ETL specifications based on the requirement.
• Creating the mappings according to the ETL Design specifications.
• Creating the Tasks (Sessions etc.), Validating and running the Sessions.
• Carry out the Unit test for the mappings developed.
• Interacting with the Client during the project tenure.
• Creating Test cases.

Confidential

Environment: Informatica 8.6, Oracle 10g, PL /SQL

ETL Developer

Responsibilities:

• Understanding Client requirements and gathering the information from the client.
• Understanding and Design the ETL specifications based on the requirement.
• Creating the mappings according to the ETL Design specifications.
• Creating the Tasks (Sessions etc.), Validating and running the Sessions.
• Carry out the Unit test for the mappings developed.
• Performance tuning.
• Interacting with the Client during the project tenure.
• Creating Test cases.

Confidential

Environment: Oracle Warehouse Builder, Oracle 9i & 10.2 and PL/ SQL

Developer

Responsibilities:

• Continuous and consistent production support for daily and monthly data load
• Providing data to the client for ad-hoc requests.
• New objects moving from QA to Production
• Prepared the scheduler for daily, monthly and yearly data load
• Interacting with client as required in accomplishing the task.