SUMMARY

• 5 + years of IT experience in Analysis, Design, Development and Deployment of technical solutions to business requirements.
• Extensively worked on Data Warehouse Full Life Cycle Projects for Health Care, Financial, Retail and Insurance industries.
• 5 + years of Strong Data Warehousing ETL experience using Informatica Power Center 9.5/9.1/8.6/8.1/8.0/7.1 (Workflow Manager, Workflow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer, Informatica Server, Repository Manager)
• Experience in all the phases of ETL such as Extraction, Cleaning, Transformation and Loading using Informatica.
• Experience in using Oracle 11g for performing ETL functions using stored procedures.
• Extensive experience and exposure on several areas of the data warehousing and Business including requirements gathering, data warehouse architecture design, development, quality planning & assurance, data analysis and implementation.
• Working knowledge with Teradata utilities ( Multiload, Fastload, T - PUMP and BTEQ Scripts ).
• Excellent understanding of the System Development Life Cycle. Involved in analysis, design, development, testing, implementation, and maintenance of various applications.
• Extracted data from various sources ranging from various RDBMS like Oracle, MS SQL Server, DB2, Teradata and Sybase, and Flat Files to load data into data marts and data warehouse.
• Expertise in working with TOAD for creation of Tables, Materialized views and normal views.
• Proficiency in working with PL/SQL stored procedures, packages, and triggers.
• Actively involved in Performance Tuning, maintaining Staging area, Backup and Recovery process, product support on various platforms.
• Effective implementations of change data capture using Power Exchange for daily loads.
• Performed data quality checks using data quality tools.
• Good experience working with large databases and performance tuning.
• Efficient in Optimizing, Debugging and testing SQL queries and stored procedures.
• Excellent working knowledge of Shell Scripting and job scheduling on platforms like UNIX.
• Able to interact effectively with other members of the Business, Quality Assurance, Users and other teams involved with the System Development Life cycle.
• Excellent analytical, functional, design and development skills with excellent communication skills and the ability to interface with the executives and perform independently as well as team environments.

TECHNICAL SKILLS

Data Warehousing / ETL: Informatica Power Center 9.X/8.X /7.1, Tera Data 13.X/12.X.

Database: Oracle 11g/10g/9i/8i, MS SQL Server

Database Tools: TOAD, SQL Developer.

Languages: SQL, PL/SQL, HTML, XML

Operating Systems: IBM Z/OS,Windows 95/98/NT/2000/XP and UNIX

Web Development: .NET, PHP, CSS, Javascript

Software Packages: MS-Office- Power Point, Word, Excel, Outlook, MS Visio, Lotus Notes

PROFESSIONAL EXPERIENCE

Confidential, Pasadena, CA

Informatica Developer

Responsibilities:

• Involved in analysis of the requirements.
• Developed various medium and complex mappings for Loading Data in to Target tables Using Informatica.
• Implemented Complex logic, Error Handling logic.
• Testing - Involved in Unit and System Testing, reviewing the mappings to check the data consistency.
• Preparing High Level Design Document, Detailed Design Document.
• Developing the ETL Code using Informatica Performing Unit Testing of ETL Code.
• Responsible for reviewing Business Requirement document
• Translated user requirements into system solutions.
• Involved in Logical Data Modeling and Database design.
• Designed and developed Oracle Star Schema Datamart
• Involved in Data Analysis of the OLTP system to identify sources data elements
• Worked with Oracle, Flatfiles,Teradata and SQL Server source systems
• Prepared Technical Specification Document
• Prepared Source to Target ETL mapping Documents
• Designed and developed Informatica Mappings, Reusable Sessions, Worklets, Workflows, Dynamic Parameter files
• Designed and implemented Audit control and Exception control strategies
• Provided solutions for various performance bottle necks in Informatica Mappings
• Designed and Developed Autosys jil scripts to Schedule Informatica workflows
• Developed various shell scripts using Korn Shell to Integrate various components
• Created test cases and pseudo test data to verify accuracy and completeness of ETL process
• Involved in Unit testing, System Integration testing, User Acceptance Testing
• Used slowly changing dimensions (SCD) like Type 1 and Type 2 to handle the delta loads and to update slowly changing dimension tables.
• Onsite Coordinator for entire Data Migration team, responsible for requirements gathering, preparing mapping specifications, analysis on requirement gaps and data model.
• Building ETL strategy to ensure proper migration.
• Developed complex ETL jobs using informatica.
• Knowledge Transfer sessions to offshore team.
• Worked on projects in Agile (Scrum) and Waterfall development methodologies for Informatica.
• Conducting code review which is been developed by the team. Communicate test progress, test results, and other relevant information to project stakeholders.

Environment: Informatica Power Center 9.5.1, Informatica power exchange 9.5, Oracle 11G, SQL Server, Flat files, PL/SQL, SQL*Plus, TOAD 9.1, UNIX, Shell Scripting, Tivoli, Erwin, Microsoft Visio Oracle 8i, 9i, 10g, Informatica 8.X, Erwin, Windows, UNIX.

Confidential - Dallas, TX

Informatica Developer

Responsibilities:

• Understand the Requirements and Functionality of the application from specs
• Involved in the development of Informatica mappings and tuned existing mappings for better Performance.
• Develop required Unix shell scripts to automate ETL processes.
• Responsible for testing the mappings and ensure that the mappings do the transformation as proposed.
• Develop Check list & SOP’s of all developed processes in HP required templates.
• Developed Mapplets and Worklets for reusability.
• Created mappings using different transformations like Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, data masking and Sequence Generator etc.
• Involved in Unit Testing, create test cases to check whether the data loads into target.
• Prepared technical specifications for the development of Informatica (ETL) mappings to load data into various target tables and defining ETL standards.
• Scheduling daily, weekly and monthly loads for the managers according to the business specs.
• Develop workflows, sessions used command task in workflow manager.
• Involved in The ETL process is handled by defining and deploying mappings. OWB gives the user a highly graphical and easy-to-use interface.
• Configure the Driving tables according to the variation of data and maintain CSV documents as per that.
• Implemented Performance tuning in Mappings and Sessions by identifying the bottlenecks and Implemented effective transformation Logic.
• Effectively communicated with Informatica Support team and BAs on Informatica bugs & issues.

Confidential, Columbus, OH

ETL Developer

Responsibilities:

• Actively involved in gathering requirements and acquiring application knowledge from Business Managers & Application Owners.
• Prepared the High - level Design document to provide an overview of the technical design specification system required for Application Enhancements.
• Involved in designing the process flow for extracting the data across various systems interacting.
• Extensively worked with ETL tools to extract data from various source including Oracle, Flat files, XML
• Troubleshoot the issues by checking sessions and workflow logs.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Developed procedures to populate the customer data warehouse with transaction data, cycle and monthly summary data, and historical data.
• Optimize SQL queries for better performance.
• Written and used UNIX shell scripts extensively for scheduling and pre/post session management
• Involved in the performance tuning process by identifying and optimizing source, target, mapping and session bottlenecks.
• Prepared the Standard Operating Procedure (Knowledge Transfer) document, which provides necessary information, required for the Maintenance and Operation of the application.
• Provided data loading, monitoring, system support and general trouble shooting necessary for all the workflows involved in the application during its production support phase.

Confidential, Brea, CA

Responsibilities:

• Actively involved in designing and developing of Extraction, Transformation and Loading Process.
• Scheduling meeting with the business users to gather the business analysis reporting requirements.
• Involved in designing and creating mappings and mapplets using informatica source, warehouse, and transform and mapplet designers.
• Scheduling the workflows using informatica scheduler as per business needs.
• Enhancing the data mart as per business needs.
• Ftping the XML files to source directories.
• Recovering the failed sessions.
• Involved in writing Unix parameter files for informatica jobs
• Creating trigger file to create indicator files for continues workflows using command task.
• Used all transformations such as Expression, Filter, Router, Update, Union, Lookup, Rank, Connected Stored Procedures, Aggregator, and Sequence Generator. Sorter, Joiner Transformation.
• Maintained both development and production environments since a long time using Power Center, Oracle (PL/SQL) under Unix and NT.
• Monitoring the load jobs, checking the error log files for regular load and interacting with users were my primary focus areas

Environment: Windows XP, Informatica 8.1.1 (PowerCenter), Business Objects XIR2, Oracle 10g, MS SQL Server 2005, TOAD, ERWIN,Shell Scripts, PERL, Autosys scheduling