SUMMARY:

Around 10 years of experience in design, development & implementation, maintenance and production support of Data Warehouse/Data Mart and transformation of various complex software systems using Informatica 9.x, UNIX, Oracle and TERADATA in Life Sciences domains.

MANAGEMENT SKILLS:

• Working on multiple projects in parallel.
• Effective communication skills and coordination between client and offshore team.
• Meeting Project deadlines under stringent timelines and pressure.
• Conducting status meetings with client and business and walk through the project progress.
• Conducting call with offshore on issues and daily status.

TECHNICAL SKILLS:

ETL Tools: Informatica 8.6/9.1

Databases: Oracle, Teradata.

Languages: Shell Scripting.

Operating systems: UNIX, Windows.

Scheduling Tools: Autosys.

PROFESSIONAL EXPERIENCE:

Confidential

ETL Lead

Responsibilities:

• Involved in requirement analysis, design, development, unit testing.
• Estimating the efforts in the expected work.
• Understanding and verifying business requirements.
• Worked on System Analysis & Requirements gathering.
• Implemented re - usable components wherever common functionality was needed.
• Implemented re-usable scripts across work streams.
• Design documentation review, code review.
• Development of Informatica mappings during critical timelines.
• Status reporting, Risk analysis.

Environment: Informatica 9.1, Oracle, Veeva, IPM and UNIX

Confidential

ETL Lead

Responsibilities:

• Involved in requirement analysis, design, development, unit testing and post production support phases.
• Estimating the efforts and cost involved in the expected work.
• Understanding and verifying business requirements.
• Worked on System Analysis & Requirements gathering with the Business User Groups.
• Worked with Business Analyst and designed the system.
• Implemented re-usable mapplets wherever common functionality was needed.
• Implemented re-usable scripts across Subject areas.
• Delegation of work to offshore team, design documentation review, code review, performance tuning and test review.
• Actively involved with Data Architects and DBA’s for data modelling and db issues in Teradata.
• Development of Informatica mappings during critical timelines.
• Status reporting, Risk analysis and preparation of mitigation plans.
• Coordination with Business and IT stakeholders and communication of issues and resolution actions to downstream consumers.

Environment: Informatica 9.1, Teradata, Oracle, Veeva, Autosys and UNIX

Confidential

ETL Lead

Responsibilities:

• Understand and Support Requirements Gathering phase.
• Involved in analyzing various frameworks so as to use it in existing Project.
• Worked on System Analysis & Requirements gathering with the Business User Groups.
• Analyzing and Implementing Data Validation Engine (Oracle Package).
• Created Re-usable Error Handling Engine.
• Involved Physical and Logical Modelling.
• Solving issues and setting up the re-usable engines for other countries running in parallel development phase and modifying it as per country specific requirements.
• Monitoring, Reviewing, Coding, Unit Testing.
• Handling delegating coding work to the team.
• Assigning and allocating day to day task.
• Status Reporting.

Environment: Informatica 9.1, oracle, Visio and UNIX

Confidential

Support Analyst

Responsibilities:

• Involved in Remedy process for Incident, Problem, Change and Knowledge Management.
• Involved in Unit Pricing Billing for the project.
• Involved in proactively solving various issues and problems.
• Actively involved in Performance tuning.
• Supported around 100+ applications.
• Actively involved with multiple teams DBA, Business, UNIX Admin, Informatica Admin, Users and Cognos Team for coordinating and solving issues and problems proactively.

Environment: Informatica 8.6, oracle, Merckury/Remedy and UNIX

Confidential

ETL Developer

Responsibilities:

• Involved in Design phase.
• Developed Informatica mappings and UNIX scripts.
• Actively involved in Testing (Test plans) phase.
• Involved in performing Unit Testing.
• Involved in executing Test cases.
• Solving Reporting issue raised by BI team.
• Prepared documentation for the ETL Mappings/Transformations in a manner that it can be interpreted, maintained and enhanced by others.
• Preparing the IFS, IDD and IDM documents.
• Was responsible for the development of all the mappings, performance tuning of mappings and sql queries.
• Preparation of Unit test Plan and test case documents in Dev environment and testing in DEV, SIT.
• Coordinate and communicate with Business and downstream, upstream systems on the issues and working with them to resolve them.
• Written the shell scripts.
• Potential of handling multiple tasks easily and capable of meeting deadlines.

Environment: Informatica 8.6, oracle and UNIX

Confidential

ETL Developer

Responsibilities:

• Involved in Development phase.
• Developed Informatica mappings and UNIX scripts.
• Developed UNIX script for issue solving.
• Actively involved in Testing (Test plans) phase.
• Involved in performing Unit Testing and executing Test cases.
• Scheduled and ran Extraction and Load process and monitor sessions by using Informatica Workflow Manager and Workflow Monitor.
• Developed UNIX Shell Scripts.
• Performed Unit Testing and involved in performance testing on the workflows that have gone live on to UAT and Production environments.
• Prepared documentation for the ETL Mappings/Transformations in a manner that it can be interpreted, maintained and enhanced by others.
• Was responsible for the development of all the mappings, performance tuning of mappings and sql queries.
• Written the shell scripts to automate the manual tasks around the Project.
• Implementation of automated scripts for the project requirements.

Environment: Informatica 8.6, oracle and UNIX

Confidential

Support Analyst

Responsibilities:

• Involved in handling various business queries.
• Client interfacing for query resolution and status updates.
• Resolving tickets/incidents.
• Documentation of the new issues faced.
• Weekly status reports preparation.

Environment: Informatica 8.6, Oracle, UNIX, Control-M

Confidential

ETL Developer

Responsibilities:

• Involved in Coding.
• Involved in Testing.
• Involved in Maintenance Activities.
• Performing Unit Testing.
• Executing Test cases.
• Involved in development and enhancement work.

Environment: Informatica 8.6, Oracle and UNIX

Confidential

Support Analyst

Responsibilities:

• Involved in daily processing of Production Support activity (Account receivables reports).
• Involved in production monitoring.
• Involved in responding to user emails.
• Involved in acknowledging issue receipt.
• Perform Daily data loads.
• Check for aborted jobs.
• Involved in generating reports and bursting activity.

Environment: Datastage, Cognos