SUMMARY

• 6 years of IT industry Experience mainly in Data warehousing as ETL developer - design, development, unit testing and implementation of enterprise data warehouse.
• Expertise in providing end-to-end Data Warehousing solutions by effective data modeling and ETL concepts and evaluate design solutions objectively. Strengths include object-oriented software development, problem solving, and a diverse base of functional and technical knowledge.
• Possess strong Technical knowledge on development of Database and ETL based applications and thorough understanding of Data Modeling in data warehouse environment such as star schema and snow flake schema.
• Extensive knowledge on design patterns, architecture, development and testing. Ability to work single handedly and delivered quality solutions to complex applications in Healthcare and life science domain.
• Experience in development of ETL Mappings using Informatica, load the database using Teradata utilities (TPT, Fastload, Mload, BTEQ and TPump) and scheduling the jobs using UNIX shell scripts in Autosys.
• Good knowledge on writing SQL queries across different databases and worked with various development and database tools (Oracle SQL Developer, Teradata SQL Assistant, Toad)
• Experienced in Batch System Scheduling using UNIX shell scripts.
• Worked on various platforms including Windows NT, 2000, XP and UNIX.
• Designing reusable, scalable and maintaining ELT templates and experienced in developing Data Mapping, Performance Tuning and Identifying Bottlenecks of sources, mappings, targets and sessions.
• Extensive knowledge of managing development team and providing technical support from onsite and offshore.

TECHNICAL SKILLS

Database: Oracle 10g,Oracle 11, Teradata 12, Teradata 14, MS-SQL Server, My SQL

ETL tools: Informatica Powercenter 9.1, Informatica Powercenter 8.6, Abinitio

Reporting Tools: Cognos, Discoverant 4.0

Database Tools: Teradata SQL Assistant, Oracle SQL Developer, Toad

Scripts: Unix shell Scripting, Teradata loader (Fastload, Mload and BTEQ) scripts.

Operating Systems: Windows XP, Windows 7, Windows 8, Unix

Testing Tool: HP Quality Center

ALM: PTC Integrity

Other tools: Informatica Data Transformation studio, Putty, WinSCP, Core FTP, Rational Rose, Microsoft Visio, UML

PROFESSIONAL EXPERIENCE

ETL Developer

Confidential, Waukegan, IL

Responsibilities:

• Analyze the existing process and evaluate design solutions objectively and facilitate conflict resolution to streamline with the existing processes.
• Setup new ftp process to pull the new files containing the new line sortimat assembly machine data.
• Develop new ETL mappings/sessions as per the requirements.
• Creation of new UNIX scripts for updating the job control and audit tables.
• Document the software design enhancements and design analysis document for the project.
• Perform Unit testing for the ETL mapping using HP Quality center.
• Maintain source code version control using PTC Integrity client.
• Validate the parameters in the configuration document and sign off the data reports created through Discoverant reporting tool.
• Maintain the business requirement tracker to streamline the client requirements and project tracker to trace the progress of the project and to deliver the project on time.
• Manage offshore work allocation, review and monitoring to ensure delivery quality.

Tool: Teradata 14, Informatica 9.1 Powercenter, Discoverant, Unix, HP Quality Center, PTC Integrity client, Putty, WinSCP, Teradata SQL Assistant, Windows 8, Notepad ++

Confidential, Waukegan, IL

Responsibilities:

• Data Transformation studio is used to parse the unstructured data files and convert into a formatted comma separated files.
• Document the parsing done through DTD.
• Prepared the software design document and source to target mapping sheet for the project.
• Develop new ETL mappings and workflows as per the business requirement.
• Big challenge with the project is to load the test data comprising of huge number of xml files without affecting the performance which is achieved by defining primary and partition by range index on teradata tables and employing several performance tuning techniques of multiple xml reader and session partitioning in Informatica.
• Creation of new unix scripts to configure FTP, update the job control /audit tables and provide confirmation of the successful execution of the Informatica jobs.
• Perform Unit testing for the ETL mapping using HP Quality center.
• Maintain source code version control using PTC Integrity client.
• Manage the Offshore and lead the team in deliverables.
• Coordinate deployment of project related modules to Production.
• Validate the parameters in the configuration document and sign off the data reports created through Discoverant reporting tool.
• Proactively recorded the changes in project scope to keep track of the change in business requirements.

Tool: Teradata 14, Informatica 9.1 Powercenter, Informatica Data Transformation Studio, Discoverant, Unix, Microsoft SQL Server, HP Quality Center, PTC Integrity client, Toad, Putty, WinSCP, Teradata SQL Assistant, Windows 8, Notepad ++

Confidential, Waukegan, IL

Responsibilities:

• Discussion with Business Analyst to gather the requirements for the Creation of HLD and LLD documents using Microsoft Visio.
• Validate the parameters- new data entry fields and data types enhanced in the Vetter application using MDCT tool.
• Develop ETL mappings and review the code. Allocate tasks to offshore team to ensure timely delivery.
• Perform unit testing for the new mappings and record the test results in HP Quality center.
• Coordinate with the team to move the code to Production.
• Maintain the business requirement tracker and code tracker to trace the progress of the project.

Tool: Teradata 14, Informatica 9.1 Powercenter, Discoverant, Unix, HP Quality Center, PTC Integrity client, Putty, WinSCP, Teradata SQL Assistant, Windows 8, Microsoft Visio

Confidential

Responsibilities:

• Played a key role in the project and involved in all the phases of the project.
• Perform impact analysis on the existing RDM process and provide solutions to effectively merge the new claims with existing claim process.
• Develop graphs in Abinitio to pull necessary data from MEDCO datasource and load into Oracle tables.
• Enhance the impacted ETL mappings in Informatica to load the new client data into Reporting Datamart built on Teradata.
• Build summary tables using BTEQ script to produce monthly/quarterly/annual reports.
• Develop wrapper script to integrate the multiple BTEQ scripts and ETL mappings to schedule in Tivoli.
• Perform unit testing of graphs in Abinitio, mappings in Informatica and Unix shell scripts.
• Coordinate with the reporting team and drawn unit test plan for reload of complete existing system.
• Provide necessary design documents and operational manuals using Microsoft Visio.
• Prepare Knowledge transfer plan and provide KT to facilitate new-entrants into the project and also preparation and maintenance of training materials.

Tool: Informatica 9.1 Powercenter, Abinitio, Teradata 12, Unix, Putty, WinSCP, Teradata SQL Assistant, Windows 7, Microsoft Visio

Confidential

Responsibilities:

• Involved in Design, coding and testing phase of the project.
• Teradata Macro is written to determine the closest pharmacies based on the latitude and longitude of the current pharmacy of the members using geospatial SQL functions.
• Develop ETL mappings and BTEQ scripts to implement the business requirements.
• Created operational manual document for the support team explaining the steps to execute the project with failure and recovery options.
• Perform unit testing and drawn test case documents.
• Created release notes for the project to migrate to Production.

Tool: Informatica 9.1 Powercenter, Teradata 12, Oracle 10g, Unix, Putty, WinSCP, Teradata SQL Assistant, Oracle SQL developer, Windows 7, Microsoft Visio

Confidential

Responsibilities:

• Create an understanding document of the existing Legacy ESI Rebate External Claim process.
• Enhance the impacted ETL mappings to support Medco POS claims.
• Teradata unix shell script is written to implement the business logic.
• Perform unit testing of the impacted and new mappings developed for the project.
• Provided support to QA team in UAT/System testing.
• Record minutes of meeting with the onsite coordinator and send out an email on a daily basis.

Tool: Informatica 9.1 Powercenter, Teradata 12, Unix, Putty, WinSCP, Teradata SQL Assistant, Windows 7, Microsoft Visio

Confidential

Responsibilities:

• Involved in understanding of requirement specification and Design.
• Develop Teradata Fast export scripts to export the prescriber data into comma delimited files.
• Created ETL mappings/workflows in Informatica using the delimited files as source to implement the business logic.
• Develop unit test case scripts for the new mappings.
• Provide support to Functional testing team and prepared documents for implementation of the system.

Tool: /Technologies: Informatica 8.6 Powercenter, Teradata 12, Oracle 10g, Unix, Putty, WinSCP, Teradata SQL Assistant, Oracle SQL developer, Windows 7, Microsoft Visio

Confidential

Responsibilities:

• Perform the role as ETL developer for the project.
• Create Technical design document, ETL source to Target mapping sheet based on the business requirements.
• Develop ETL mappings and workflows in Informatica Powercenter to implement the business logic.
• Worked as Defect Prevention Coordinator and prepared a detailed root cause analysis at the end of each phase.

Tool: Informatica 8.6 Powercenter, Teradata 12, Unix, Putty, Core FTP, Teradata SQL Assistant, Windows XP, Microsoft Visio

Confidential

Responsibilities:

• Analyze technical requirements of the project and gather source system information.
• Develop ETL mappings and workflows to implement the business logic based on souce target mapping sheet.
• Prepare technical documents and unit test cases for the project.

Tool: Informatica 8.6 Powercenter, Teradata 12, Unix, Putty, Core FTP, Teradata SQL Assistant, Windows XP, Microsoft Visio

Confidential

Responsibilities:

• Understand the requirements (both functional and non-functional) by going through the specifications and develop a code based on the requirements.
• Document artifacts including unit test plans and ensure that the output is as per the given specifications.

Tool: Informatica 8.6 Powercenter, Teradata 12, Unix, Putty, Core FTP, Teradata SQL Assistant, Windows XP