SUMMARY

• Over 7 years of total IT experience and over 4 years of Data Warehousing experience using the ETL Tool Informatica.
• Worked in Oil and Gas, Retail and Banking domains. Worked with fortune 500 clients like BP, CVS and Ameriprise Financial.
• Proficient in all phases of the Software Development Life Cycle (SDLC) including Requirements Gathering, Analysis, Design, Development, Unit Testing, Implementation, warranty support and maintenance.
• Extensive experience with Informatica client tools like Power Center Designer, Workflow Manager, Monitor and Power Exchange.
• Experience in developing complex mappings and workflows which incorporate complex business logic and interdependencies, including Slowly Changing Dimension Mappings of Type I, Type II
• Experience with different source and target systems like Relational Databases, Flat Files, XML Files and Mainframe files.
• Well experienced in Performance Tuning of Informatica (sources, mappings, sessions and targets)
• Extensively worked on relational databases like SQL Server, Oracle, Sybase and used tools like Toad, SQL*Plus.
• Excellent skills in retrieving/manipulating data by writing simple/ complex SQL Queries and optimizing SQL and PL/SQL.
• Extensive experience in Reporting tools like SSRS (SQL Server Reporting Services)
• Experience in Control –M (scheduling tool)
• Developed Test Scripts, Test Cases to perform Unit testing.
• Experience in Waterfall and Agile methodology and project life cycle.
• Combines a superior work ethic with excellent communication, team work and interpersonal skills. Willing to learn and constantly adjusting skill set to the cutting edge technology in the market place.
• Ability to meet deadlines, handle pressure, co-ordinate multiple tasks in a project environment.
• Experience in Onsite/Offshore Management.

TECHNICAL SKILLS:

• Environments : Windows XP/2003, DOS, UNIX
• ETL Tools : Informatica Power Center V8x/V7x, Informatica Power Exchange, SSIS
• Databases : SQL Server 2008 R2, Oracle 8i/9i/10g/11g, MS Access, Sybase
• Data Management : Toad, SQL*Plus, SQL Server Management Studio
• Tools
• Reporting Tools : SSRS
• Schedulers : Control - M
• Languages : SQL, PL/SQL, UNIX shell scripting, Windows batch
• scripts, Visual Basic
• GUI Tools : Visual Studio

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX
Position: Lead ETL Developer/ Module Lead Mar 2011 – Till Date

Roles & Responsibilities

• ETL and Informatica developer on a Data Warehouse project utilizing Informatica PowerCenter 8.6.1
• Responsible for designing and developing mappings, mapplets, sessions and work flows for loading the data from source systems to target systems
• Built complex Informatica mappings using transformation logic such as Update Strategy, Lookup, Aggregator, Filter, Normalizer, Stored Procedure, Sorter, Joiner, Sequence Generator, Router
• Developed complex mappings with Slowly Changing Dimensions Type I and II
• Extracted data from various sources like SQL Server, Flat Files, XML Files and loaded it into SQL Server database.
• Used Variables and Parameters in mappings and workflows to pass the values between sessions
• Tuned mappings and SQL queries for better performance and efficiency.
• Created workflows, with multiple worklets and sessions having complex interdependencies as per the business requirements.
• Extensively used tasks like Timer Event Raise, Event Wait, Decisions, and Email in the workflows
• Used Workflow Manager for scheduling and running the workflows
• Created VB scripts for converting source files into a format readable by Informatica. Used the Command Tasks in the workflow, and the pre and post session commands to execute scripts.
• Performed Unit Testing and validated the data. Involved in Testing and Test Plan Preparation, Process Improvement for the ETL development.
• Created numerous reports using SQL Server Reporting Services – well versed with SSRS features
• Experience with deploying SSRS reports on Sharepoint and creating subscriptions for the reports.

Confidential, Woonsocket, RI
Position: ETL Developer Feb 2009 – Nov 2010

Roles & Responsibilities

• ETL and Informatica developer in a project replacing mainframe jobs with Informatica jobs utilizing Informatica PowerCenter 8.1.1
• Used Informatica Power Exchange extensively to read from and write to mainframe files
• Replicated the complex business processing logic in the mainframe jobs in the Informatica mappings using transformations like Lookup, Aggregator, Filter, Normalizer, Stored Procedure, Sorter, Joiner, Sequence Generator, Router
• Extracted data from Oracle databases and flat files in addition to mainframe files.
• Loaded data to Target systems like Oracle tables and mainframe files
• Worked with Variables and Parameters in mappings to pass the values between sessions.
• Created Unix scripts to do basic processing and then execute the Informatica workflows.
• Created Unix scripts to FTP files
• Used Control–M (scheduling tool), to schedule the Unix jobs based on their interdependencies and business requirements.
• Performed Unit Testing and validated the data.
• Performed tuning for Informatica mappings,and PL/ SQL procedures.
• Worked directly with non-IT business analysts throughout the development cycle and gathered and analysed business requirements for ETL development.
• Involved in System Testing, User Testing and Test Plan Preparation
• Monitored production runs and provided support for issues.

Confidential,
Position: Module Lead/ETL Developer May 2008 – Jan 2009

Roles & Responsibilities

• Module Lead for an ETL Maintenance project utilizing Informatica PowerCenter 8.1.1
• Provided support for production runs of Informatica jobs
• Worked on bug fixes and enhancements to existing Informatica mappings.
• Performance tuning of the existing Informatica mappings and PL/SQL procedures.
• Worked with Informatica Debugger to debug the mappings in Designer.
• Involved in Analysis, Review, and development of Informatica mappings, its corresponding sessions and Workflows
• Performed unit testing and validated the data
• Involved in Testing and Test Plan Preparation, Process Improvement for the ETL developments.
• Managed a team of 3 – delegated work, performed reviews and co-ordinated with onsite resources.
• Experience with HP Request IT application – performed tool customisations as per business requirements using application properties as well as custom Java code.

Confidential,
Position: Developer July 2005 – Apr 2008

Roles & Responsibilities

• Developer in a maintenance and support project for a financial company
• Was responsible for supporting and maintaining multiple applications and their interfaces.
• Extensive experience in debugging, design, development, testing and implementation of interfaces with Visual Basic, Oracle, Sybase, Access, and SQL Server in a Windows NT environment.
• Experience in creating batch scripts for supporting the interfaces.
• Involved in all stages of software life cycle including requirement analysis,design, development, unit testing, system testing, implementation and warranty support.

EDUCATION:

Bachelor of Technology - Computer Science
TRAINING & CERTIFICATIONS:

• Open Systems Certifications – Unix, C++, Software Engineering
• Quality certifications