SUMMARY:

• Having 9+ years of experience in Information Technology with a strong background in Data warehousing and Business/Data Analysis, ETL Design, Development and Application Support
• Extensively worked on projects with Informatica Power Center, Teradata, Datastage and Abinitio and reporting tools like Cognos, Business objects and OBIEE.
• Extensive experience in Informatica, carried out tasks such as analysing,designing and developing of Mappings, Testing, debugging of data and CDC implementation for Real time data capture
• Good Exposure on Informatica power exchange to connect SAP with using BAPI, IDOC transformations.
• Solid knowledge in Informatica performance tuning at Target, Source, Mapping, Session, System level environment and Database level
• Hands on experience in guiding teams towards the successful fruition of project delivery. Conversant with maintaining high standards of ETL Solution development by coaching and mentoring. In depth knowledge of managing large teams by ensuring best practices and analytic skills
• Good knowledge on Scheduling tools like Informatica scheduling, Cronacle and control - M
• Excellent Stakeholder management skills and experience in working on Business, Data, Application and Technology domains
• Expertise in performance tuning of ETL code and Oracle, Teradata queries.
• Extensively worked with Teradata utilities like BTEQ, Fast Export, Fast Load, and Multi Load
• Exposure to working with multi cultural team setup and effective in fast learning of new Technologies and Concepts.
• Project Management skills across all SDLC phases blended with technical expertise and experience in successfully implementing large on-site/offshore model and requirement-gathering through implementation & support.
• Hands on ability to direct complex projects from concept to deployment.
• Experience in complete execution of the project in Agile Methodology by estimating the user stories (requirements), Mentoring and providing technical support to the Team.

TECHNICAL SKILLS:

ETL Tools: Informatica, Teradata Utilities

Operating Systems: UNIX, Windows

Languages: C, SQL, PL/ SQL

Data Bases: Teradata,Oracle,SQL server

Teradata Utilities: BTEQ, Fast Load, Multi Load

PROFESSIONAL EXPERIENCE:

Confidential

Tools: & s/w: Informatica 9x, Oracle, Teradata, Redwood Cronacle, Business Objects, Cognos

Data Architect, Team Lead

• Actively involved in requirements gathering discussions with functional users.
• Involved in Business Analysis and design reviews for process flow.
• Involved in ETL design, developing implementation plan and schedule.
• Developing Teradata Bteq Scripts & Developing Informatica mappings, sessions and workflows.
• Involved in debugging of the mappings and in preparation of test cases.
• Involved in Unit testing and Integration testing.
• Involved in regression testing after each modification of the existing application.
• Effectively coordinated with the users and development team.

Confidential

Tools: & s/w: Informatica 9x, Oracle, Teradata, Redwood CronacleTeam Lead, Sr. ETL Developer

• Requirement Gathering and Analysis
• Design and development of ETL data loads
• Guiding the offshore team functionally/technically for the project deliverables
• Fixing critical bugs in the application and performing unit/integration on the application
• Tracking the project status and updating to client on timely basis

Confidential

Tools: & s/w: Informatica 9x, Teradata, Redwood CronacleSr. ETL Developer

• Requirement Gathering and Analysis.
• Developing the technical specifications documents and designing the ETL Strategy
• Developing ETL code and Teradata Scripts (BTEQ) to re-use across the source system
• Developing the BI Job chains using Cronacle scripts and schedule the Jobs in Cronacle
• Following up with the Review teams (Migration team, DBA team and Production support team) to sign off for the code migrations.
• Integration testing of all the components in Preprod environment.
• Interacting with the business for the UAT sign off on the deliverables.
• Issues Tracking and Providing Project status reporting to the business.
• Communicate Requirements, Development and Data related issues to concerned teams

Confidential

Tools: & s/w: Informatica 9.1, Teradata, OBIEE

Sr. ETL Developer

• Interaction with the users/analysts to understand the business of the application, gather requirements and put into technical design documents.
• Involved in Design phase of the project and prepared High level Design Specifications for ETL Coding and mapping standards
• Participated in team meetings and proposed ETL Strategy
• Involved in developing the technical documents from functional specifications.
• Suggested ETL performance tuning techniques to reduce the CPU usage of the highly skewed queries.
• Coordinating the team by conducting periodic knowledge sharing sessions among the team as a offshore Lead.
• Interacting with the business for the UAT sign off on the deliverables.
• Interacting with the Release Manager to migrate the Code to production during the releases as part of GEHC process.
• Developing generic Teradata Scripts (BTEQ) to re-use across the source system.
• Developing the BI Job chains using Cronacle scripts and schedule the Jobs in Cronacle.
• Following up with the Review teams (Migration team, DBA team and Production support team) to sign off on the Releases.
• Integration testing of all the components in Preprod environment.
• Provide 24*7 supports during warranty support period for the changes made in production as a part of GEHC Release cycle.
• Providing Project status reporting on weekly basis to the customer and to the internal Management team.
• Issues Tracking and Risk management activities.
• Monthly Metrics report to the Management and the VMO.

Confidential

Tools: & s/w: Informatica 8.6, Teradata, Business Objects

ETL Developer

• Analyzing and clarifying the requirements sent by the client.
• Creating the ETL Design.
• Involved in developing the technical documents from functional specifications.
• Developing/ Optimizing the ETL code & Unit Testing
• Consolidating the Source system changes by coordinating the ERP Support Team and the DBA Teams.
• Impact analysis: Documenting the Impacted Informatica Objects (other ETL Objects and Reporting objects) in BI by querying the Informatica Repository Metadata database.
• Developing generic Teradata Scripts (BTEQ) to re-use across the source system.
• Developing the BI Job chains using Cronacle scripts and schedule the Jobs in Cronacle
• Remediating the Impacted Objects by applying the appropriate fixes.
• Scheduling and monitoring the ETL jobs in Redwood Cronacle.
• Performing Unit Testing, System Testing and Integration Testing
• Preparing the Technical Specification Mapping document for the impacted Objects.
• GEHC Process document for the Project Release.
• Involved in the Post Go Live Support (for 45 days) of the entire system
• Fixing the issues faced after go-live by raising the Change control

Confidential

Tools: & s/w: Informatica 8.6.1, SQL Server 2005, Oracle

Sr. Software Engineer

• Data migration from one environment to another environment using ETL Informatica tool, Informatica Power Exchange Using SAP-BAPI and IDOC Transformations
• Extracting, Transforming and Loading the data from Source to Staging and Staging to Target according to the Business requirements.
• Conduct data quality analysis on various source data systems.
• Communicate Requirements, Development and Data related issues to concerned teams.
• Development of reporting module using Ms Access & Excel reports.
• Presentation of Issues and findings to subject matter experts.
• Prepared Unit test cases for the mappings.
• Involved in Performance tuning by optimizing the sources, targets, mappings & sessions.
• Worked extensively on Oracle and flat files as data sources.
• Used Mapping Parameters and Session Parameters
• Used Target Load Order for populating various targets within the same mapping.
• Performed integrated testing for various mappings. Tested the data and date integrity among various sources and targets.