PROFESSIONAL SUMMARY:

• Over all 7+yrs of IT experience in Analysis, Design and Development in various business application as an ETL developer with major contribution in Informatica Power Center 8.x/7.x and knowledge in 9.0.1.
• Experience on DM Express Tool(ETL Tool).
• Extensive knowledge in Documenting, Developing and Implementing projects on various Domains: Tele - Communications, Insurance, Pharmaceutical, Health Care.
• Experienced in Kimball Methodology - Dimensional Modeling, SCD (Slowly Changing Dimension) Types- 1, 2, 3 and 6, Data Marts and data warehouses.
• Profound Knowledge in Informatica Power Center 8.6.1/8.1.1/7.1.4 Server and Client tools- Repository Manager, Designer (Source analyzer, Target designer, Transformation and Mapplet designer), Workflow Manager, Workflow Monitor.
• Experienced in analyzing Business and Functional requirements, studying the Source systems, thoroughly designing the Target by going through the Functional Specification Document and one- to- one interaction.
• Clear knowledge on OLTP and OLAP Systems, developing Database schema - Star and Snow flake schema (Dimensions and Facts), E-R Modeling- Logical and Physical Modeling Concepts.
• Expertise in integrating various source’s- Oracle, SQL Server, XML files and Flat files.
• Extensive usage of Reusable and Non reusable Transformations- Expression, Aggregator, Filter, Router, Normalizer, Sorter, Lookup- Unconnected and Connected, Update strategy, Sequence generator, Stored procedure, Joiner.
• Experienced in developing Complex Mappings, Mapplets (Re-usable Business Logic), Work lets, Tasks- Session, Command and Event wait, Workflows and Batch Processes.
• Profound knowledge in implementing different types of Caches for Lookup’s- Dynamic, Persistent and Static.
• Experience in creating Parameters and Variables.
• Implemented Pre-Session and Post-Session shell scripting to run workflows using pmcmd command.
• Extraction of data from Sources to Targets- Staging Area, Data Marts or Data Warehouses.
• Extensive use of Informatica Debugging in mappings and used Session Log File to trace the errors when loading into targets.
• Implemented Performance Tuning Techniques on Mappings, Session and Targets.
• Hands on experience in writing PLSQL- Procedures, Cursors, Triggers and Packages.
• Worked closely with Architects when designing the Data Marts and Data Warehouses, with Business Analyst in understanding the business needs and interacting with other team members in completing the task as scheduled.
• Experienced in working with Tools- TOAD, SQL Developer and SQL Plus.
• Extensive knowledge on Shell Scripting, experienced in using SED and AWK Commands.
• Experienced in Scheduling Meetings with Business Users and Coordinating with offshore team.
• Strong Analytical skills, Excellent Presentation, Communication with Good Listening and Interpersonal Skills.

TECHNICAL SKILLS:

Informatica Power Center 8.6.1/8.1.1/7.1.4.

Syncsort Product

Power Marts.

Data Modeling

Erwin 7.0/4.0/3.0., Visio.

Dimensional Modeling.

Star Schema.

Snow flake Schema.

Oracle 8i/9i/10g/11g

MS SQL Server 2000/2005/2008.

Flat files.

MS Access.

MS Excel.

SQL Utilities

Toad.

SQL Developer.

SQL Plus.

Query Analyzer.

C.

C++.

PL: SQL.

UNIX Shell Scripting.

Windows 95/98/2000/XP/NT.

UNIX.

MS Outlook/ Office.

Business Objects (Reporting).

Control: M/ Tidal Enterprise Scheduler (Scheduling Tool).

PROFESSIONAL EXPERIENCE:

Confidential, Louisville, KY

Onsite Coordinator/Informatica Developer

Responsibilities:

• Were pulled into couple of other projects. Simultaneously supported 3 projects.
• Coordinating with off-shore on daily basis.
• Analyzed the jobs in DM Express and converted into Oracle sql’s.
• Scheduling meetings with the Clients regarding the status of the project on weekly basis.
• Created almost 60 Oracle Sql Scripts when working on Conversion project, worked on Shell Scripting when FTP’ing and Tarring the files to Vendors.
• Created Staged tables to tune the Sql’s when the same scripts used multiple times with a process.
• Documented the SQL coding and used to interact with DBA’s before migrating the code into QA Environment.
• Learned many performance tuning techniques when interacting with DBA’s for Code Review’s.
• Tuned shell script to run for 3-4 hrs for Zipping 25 huge files which initially took 12-13hrs.
• Experienced on Dollar Universe Scheduling tool (ORSYP Product).
• Created Sessions, Uprocs, Tasks, Resources and Rule when scheduling the jobs.
• Documented all the Jobs individually with High Level Design and maintained the Versions of the process in Confidential Shared Server.
• Worked on Interface Contract and worked with business to make Sign offs on System Testing.
• Migrated all the converted Jobs in all Environments by handling unit testing and system testing at development Phase.
• Created many files during the process, fixed length record file was created in one of the process which is similar to the COBAL layout.

Confidential, Denver, CO

ETL (Informatica Developer)

Responsibilities:

• Worked with Business Users and Clients to understand the telecommunication domain and requirements of Business.
• Gained knowledge on SAP Financial module - PCM (Profit and Cost Management).
• Worked with the Clients to understand their needs and suggested them in what we can achieve for the best and helped them in choosing the better options.
• Worked extensively on Data Warehousing and Data Integration.
• Involved in all aspects of software development life cycle.
• Helped the Team in building the data model using the ER-win Tool.
• Designed complex new mappings on Informatica power center 8.6.1, reviewed the mappings developed by off-shore team and corrected them with respect to the performance.
• Worked closely with the Business Analyst, Data Modeler and Finance team.
• Coordinated with off-shore Team and helped them in understanding the business and project.
• Generated DDL queries of new database objects like tables, views, sequences, functions, indexes, triggers, packages, stored procedures.
• Worked closely with PCM team and loaded the data into their SAP-PCM model by following all their requirements and protocols.
• Made substantial contributions in simplifying the development and maintenance of ETL by creating Re-usable Transformation Objects and Mapplets.
• Extensive use of Persistence cache to reduce session processing time.
• Used Debugger in Mappings to debug the Complex mappings and fixed the Errors.
• Involved in Unit testing and created Test cases for those mappings.
• Worked with Offshore team and involved in meetings with them to complete the task on weekly basis.
• Had a call meeting daily with the off shore team to know the project updates.

Environment: Informatica Power Center 8.6.1, Oracle 10g/11g, Business Objects, PL/SQL, SQL Developer, Windows XP, UNIX, ERWIN r7, CONTROL-M.

Confidential, California, LA

ETL Developer

Responsibilities:

• Understanding of the business requirements and enhancing the existing data warehouse architecture design for a better performance.
• Involved with clients to understand the business needs and coordinated with the team to achieve the needs of the business.
• Used Informatica Designer to Create, Load, Update mappings using different transformations to move data to different data marts in Data warehouse.
• Identified and tracked the slowly changing dimensions, heterogeneous Sources and determined the hierarchies in dimensions.
• Successfully Loaded data into different targets from various source systems like Oracle data base, Flat files, ODS, SQL Server etc into Staging tables and then into Target Database.
• Involved in discussing Requirement Clarifications with multiple technical teams.
• Created users and user groups with appropriate privileges and permissions, folders and folder permissions in Repository Manager.
• Created Source, Target, Transformations, Sessions, Batches, and defines Schedulers for the sessions.
• Had helped our Architects in designing the Data Warehouse.
• Also Used Data Integrators to club data from different kind of Sources.
• Performed Incremental aggregation to load data into aggregate tables.
• Made substantial contributions in simplifying the development and maintenance of ETL by creating Re-usable Transformation Objects and Mapplets.
• Extensive use of Persistence cache to reduce session processing time.
• Used Debugger in Mappings to debug the Complex mappings and fixed the Errors.
• Created Task Session, Email and Workflow to execute the mappings. Used workflow monitor to monitor the jobs, reviewed error logs that were generated for each session, and rectified any cause of failure.
• Involved in moving Mappings, Sessions, and Workflows between development and production environments.
• Involved in Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.
• Scheduled Sessions and Batch Processes based on demand, Run on time, run only once using Informatica Server Manager.
• Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project development to testing and then to Production environment.
• Knowledge on Cubes when working on SSAS (SQL Server Analysis Services).
• Prepared and used test data cases to verify accuracy and completeness of ETL process.
• Worked with Offshore team and have scheduled meetings with them to complete the task on weekly basis.
• Had a call meeting daily with the offshore team to know the project updates.
• Any critical issues with significant impact to the project are highlighted to the management committee for rapid resolution.
• Actively involved in Production Support and helped other team members.

Environment: Informatica Power Center 8.6.1, SQL SERVER 2008, Oracle 10g/11g, Business Objects, PL/SQL, TOAD, Windows XP, UNIX, ERWIN.

Confidential, Cincinnati, OH

Informatica Developer

Responsibilities:

• Responsible for gathering suit of business requirements, Prepare source to Target Mapping specifications and Transformation rules.
• Involved in System study, analyze the requirements by meeting the client and designing the system.
• Worked with Architects to make the Warehouse more optimistic with few changes to the design.
• Developed Mappings/ Reusable Objects/ Transformation/ Mapplets by using mapping designer, transformation developer and mapplet designer in Informatica Power center.
• Extracted data from different Sources like Oracle, XML, Flat files and loaded into ODS.
• Designed and developed complex Aggregate, Join, Lookup Transformation rules (Business rules) to generate consolidated (Fact/ Summary) data identified by dimensions using Informatica ETL tool.
• Created connected and unconnected Lookup transformation to look up the data from the source and target tables, used Update Strategy transformation.
• Implemented SCD- Type 1 and Type 2 according to the business requirements in the dimension tables.
• Workflow Manager used for creating and maintaining the sessions, Monitor, edit, schedule, copy, abort, and delete session.
• Setting up Batches and Sessions to schedule the loads at required frequency using Power Center Workflow Manager, pmcmd and also using scheduling tools.
• Involved in Performance Tuning for sources, targets, mappings, sessions.
• Used Debugger to debug mappings by creating breakpoints to gain troubleshooting information about data and error conditions.
• Involved in migrating folders from Development to Testing and from Testing to Production Environments, creating the connect strings and synchronizing the connect strings and connection objects in Dev, Test and Prod environments.
• Involved in Unit testing and created Test cases for those mappings.
• Worked with testing team and helped in Testing at Integration Level.
• Extensively used various tasks like Session task, Event Wait Task, Decision task, Email task, Command task.
• Actively Participated in Team meetings and discussions to propose the solutions to the Problems.

Environment: Informatica Power Center 8.6.1, Oracle 9i,10g, MS SQL SERVER 2005, T-SQL, PL/SQL, Erwin, SQL Loader, Unix Shell Script, Win 2000/NT, Tidal Enterprise Scheduler.

Confidential, Camden, NJ

ETL Developer

Responsibilities:

• Involved in all the phases of project (Client Interaction, gathering requirements from business users, preparation of detail design, development, unit testing, and production support).
• Profound knowledge in Data Warehouse concepts and in Architecture design.
• Worked extensively on transformations like Source Qualifier, Aggregator, Expression, Lookup, Filter, Router, and Update Strategy.
• Extracted data from various heterogeneous sources cleaned the data before applying business logic and loaded them into central Target Data Warehouse.
• Proficient in using Informatica Client tools (Repository Manager, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager, and Workflow Monitor).
• Created Workflows and Work lets for designed mappings.
• Generated status reports using Workflow Manager.
• Used UNIX Shell Scripts for data extraction, running Pre-Session, Post-Session and PL/SQL procedures.
• Used debugger to test the data flow and fixed the mappings.
• Extensively used Performance tuning techniques to improve the session performance.
• Worked with various Sessions, Decision, Command, Email tasks in single workflows.
• Used Toad to analyze source data, applied various queries for testing.
• Worked with Onsite Off-shore team and daily reviews with Off shore team leads to check if there are any missing deadlines.
• Interaction with the development team and give quick decisions to ensure the success of the project.

Environment: Informatica Power Center 7.1.1, Oracle 8i, Business Objects, SQL, TOAD, MS Outlook.

Confidential

Data Warehouse Developer

Responsibilities:

• Created Dimension Tables and Fact Tables based on the warehouse design.
• Involved in creating Logical and Physical design of databases using Erwin.
• Participated in build of the Data Warehouse, which includes the design of Data Mart using Star schema.
• Created ETL detail design document and ETL standards document.
• Created Repository using Informatica Power Center - Repository Manager.
• Extracted data from Flat files and Oracle, applied Business Logic to load them in the central Oracle database.
• Involved in Extraction, Transformation and Loading (ETL) Process.
• Worked extensively with complex mappings using expressions, aggregators, filters, lookup and procedures to develop and feed in Data Warehouse.
• Created Re-usable transformations and Mapplets and used them in mappings.
• Worked on SQL- queries and tuned them to improve performance.
• Used DTS processor to the usage of SSIS and implemented ETS process using SSIS.
• Extensively used Shell Scripting to automate the Pre-Session and Post-Session Processes.
• Modified Universes and generated reports using Business Objects.
• Designed and developed reports, Drill down reports using Business Objects Reporter.
• Designed reports with Slice and Dice, Drill down operations.

Environment: Informatica Power Center 7.1, Oracle 9i, SQL Server 2000, ERWIN 3.5, Business Objects5.1, UNIX, Windows NT, SSIS.

Confidential

ETL Developer

Responsibilities:

• Driving the technical design along with customer team, preparing design specifications, functional specifications and other documents.
• Involved in all aspects of software development life cycle.
• Generated DDL queries of new database objects like tables, views, sequences, functions, indexes, triggers, packages, stored procedures.
• Produced SQL reports, data extractions, data loading, and scripts for various schemas.
• Involved in performing backend testing by writing SQL queries to extract the data from SQL database using oracle.
• Worked on Linux Environment.
• Performed Testing using Selenium IDE.
• Wrote DDL, DML scripts for Schema, Table space, Cluster creation and Alteration.

Environment: Oracle 8i, Linux, TOAD, SQL SERVER 2000, PL/SQL, SDLC, Selenium IDE.