SUMMARY

• A proactive, self - driven IT professional with almost 8 years of experience including Full life cycle of Software Development (SDLC) including Business Requirement Gathering & Analysis, System Study, Application Design, Development, Testing, Implementation, System Maintenance, Support and Documentation.
• Proficient in Data warehouse design and modeling including, Star and snowflake schema design, Facts and Dimensional modeling.
• Experience working in Informatica Master Data Management (MDM) Developer/Informatica IDQ Analyst.
• Very good at working independently as well as in a team.
• Have very extensive hands on experience in using various Informatica Power Center components like, Designer, Workflow Manager, Workflow Monitor, Repository manager.
• Worked extensively with scheduling tools like Cisco Tidal and UNIX CRONTAB Scheduler and AUTOSYS.
• Has a good noledge of various Teradata utilities like SQL Assistant, Fast Export, Fast Load, Multiload, BTEQ
• Worked exclusively with various types of source and target systems like EBS, Flat File (including XML, CSV, and DAT), relational data sources like Oracle, Teradata and DB2.
• Worked very well in Performing Unit testing, regression testing, sanity testing, and system integration testing
• Very extensive noledge of migration process to different environments and in preparing teh migration documents. Worked very closely with deployment team to deploy code in different environments.
• Has very strong Knowledge of OLTP and OLAP Concepts and very proficient at understanding and usage of Ralph Kimball and Bill Inmon data warehousing methodologies.
• Hands on experience Informatica IDQ Tool for correcting teh addresses and Cleansing teh source data & standardize of Data
• Very good at designing and developing complex mappings, mapplets, transformations, workflows, worklets.
• Expert at Error Handling and Troubleshooting techniques using various methods.
• Very good at Performance Tuning tasks like, identifying and resolving performance bottlenecks at various levels.
• Very good team facilitator and good experience in mentoring teh other team members wherever necessary.
• Possess excellent written and oral communication skills with a very good ability to communicate and work with people appropriately in business and technical situations at all levels.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 10.1/9.5/9.1/8.6 , IDQ

Data Modeling Tools: Erwin data modeler ¾

EIM Tools: Informatica MDM

Scheduling Tools: Cisco Tidal, Control-M, Autosys, Crontab, Informatica Scheduler

Reporting Tools: Knowledge of OBIEE 10G

RDBMS: Oracle 11g/10g/9i/8i, SQLServer2005/2008, MS Access, Teradata

RDBMS Utilities: TOAD, SQL Loader, SQL* PLUS, SQL Developer

Operating Systems: Windows NT/98/95/2000/XP, UNIX (Sun Solaris)

Scripting/Programming Languages: SQL, PL/SQL, C, expose to Java/J2EE, Unix Shell scripting

PROFESSIONAL EXPERIENCE

Confidential, Nashville, TN

Sr. Informatica Developer/Lead

Responsibilities:

• Involved in identifying all teh Data Models for all teh applications.
• TEMPEffectively worked on Healthcare Data Repository.
• Work closely with teh Business Analyst to come up with teh source - target document to map teh data to teh existing data structures.
• Work closely with teh project management to come up with a detail task list needed to support teh development work.
• Involved in creating reusable control table driven ETL Architecture.
• Created Technical Specifications document based on functional specifications.
• Developed complex ETL mappings that involve parallel processing of multiple instances basing on certain parameters in control table.
• Created complex Mappings using different Transformations like Filter, Router, Joiner, Connected & Unconnected Lookups, Sorter, Aggregator and Sequence Generator to pipeline data to Data Warehouse.
• Extracted data from heterogeneous sources like flat files, Oracle, db2 and loading teh same into oracle and flat files.
• Experience working on Informatica MDM to design, develop, test and review.
• Implemented various match and merge rules based on teh requirement to generate master data.
• Created post-sessions and pre-sessions for all teh sessions to update teh etl process table which is used to understand teh current status of ETLs.
• Involved in performance tuning on Informatica ETL mappings analyzing them thoroughly.
• Involved in identifying various bottle necks at different levels (database, mapping, session, and workflow) and came up with solution to improve teh performance.
• Created table partitions for each of teh country, operating company and period combination which enables faster retrieval of data.
• Used Informatica Power Center, Informatica Data Quality (IDQ), Informatica analyst tool, Oracle Views, Oracle Stored Procedures, Oracle complex quires and UNIX to provide teh solution.
• Created Oracle Stored Procedures to implement teh ETL Process control logic.
• Designed Oracle views that generate these extracts for upstream applications and created ETLs to read these views and drop them in a file.
• Documented all teh ETL and Oracle Procedures developed.
• Used Informatica ETL Power Center 9.6 for migrating data from various OLTP databases to teh data mart.
• Created Unit Test plans for various ETLs developed.
• Performed Unit Testing and Integration testing for teh ETL’s.
• Reviewed teh Code, Design and Test plans as appropriated throughout project lifecycle.

Environment: Informatica Power Center 9.5, Informatica MDM, Oracle 11g, Toad for Oracle, Surveyor for DB2, Cisco Tidal Scheduler, SQL, PL/SQL, Windows7/XP, UNIX

Confidential, Austin, TX

Sr. Informatica Developer

Responsibilities:

• Extensively used Informatica Data Quality (IDQ) profiling capabilities to profile various sources, generate score cards, create and validate rules and provided data for business analysts for creating teh rules.
• Involved in source profiling and data analysis.
• Involved in identifying all teh Data Models for all teh applications.
• Involved in performance tuning of existing SQL queries.
• Involved in performance tuning of Informatica mappings.
• Developed complex ETL mappings that involve parallel processing of multiple instances basing on certain parameters in control table.
• Created complex Mappings using different Transformations like Filter, Router, Joiner, Connected & Unconnected Lookups, Sorter, Aggregator and Sequence Generator to pipeline data to Data Warehouse.
• Extracted data from heterogeneous sources like flat files, Oracle, db2 and loading teh same into oracle and flat files.
• Extensive experience in integration of Informatica Data Quality (IDQ) with Informatica PowerCenter.
• Extensively used Informatica Data Quality transformations - Labeler, Parser, Standardizer, Match, Association, Consolidation, Merge, Address Validator, Case Converter, and Classifier
• Implemented various match and merge rules based on teh requirement to generate master data.
• Involved in performance tuning on Informatica ETL mappings analyzing them thoroughly.
• Involved in identifying various bottle necks at different levels (database, mapping, session, and workflow) and came up with solution to improve teh performance.
• Created table partitions for each of teh country, operating company and period combination which enables faster retrieval of data.
• Used Informatica Power Center, Informatica Data Quality (IDQ), Informatica analyst tool, Oracle Views, Oracle Stored Procedures, Oracle complex quires and UNIX to provide teh solution.
• Extensively used in-built reference data such as - token sets, reference tables and regular expressions and created new set of reference tables to identify teh noise data and standardization of input data
• Created Oracle Stored Procedures to implement teh ETL Process control logic.
• Designed Oracle views that generate these extracts for upstream applications and created ETLs to read these views and drop them in a file.
• Created a model for Audit mechanism and included teh Audit counts in each of teh ETLs to verify teh source and target counts and sums.
• Identified various extracts needed for upstream reporting applications and planning applications and designed structures for teh same.
• Documented all teh ETL and Oracle Procedures developed.
• Used in-built reference data such as - token sets, reference tables and regular expressions to and built new reference data objects for various parse/cleanse/purging needs.
• Used Informatica ETL Power Center 10.1 for migrating data from various OLTP databases to teh data mart.
• Created Unit Test plans for various ETLs developed.
• Performed Unit Testing and Integration testing for teh ETL’s.
• Reviewed teh Code, Design and Test plans as appropriated throughout project lifecycle.

Environment: Informatica Power Center 10.1, IDQ, Oracle 11g, Toad for Oracle, Surveyor for DB2, Cisco Tidal Scheduler, SQL, PL/SQL, Windows7/XP, UNIX

Confidential, Nashville, TN

Sr. Informatica Developer

Responsibilities:

• Involved in identifying all teh Data Models for all teh applications.
• TEMPEffectively worked on Healthcare Data Repository.
• Involved in creating reusable control table driven ETL Architecture.
• Created Technical Specifications document based on functional specifications.
• Developed complex ETL mappings that involve parallel processing of multiple instances basing on certain parameters in control table.
• Created complex Mappings using different Transformations like Filter, Router, Joiner, Connected & Unconnected Lookups, Sorter, Aggregator and Sequence Generator to pipeline data to Data Warehouse.
• Extracted data from heterogeneous sources like flat files, Oracle, db2 and loading teh same into oracle and flat files.
• Experience working on Informatica MDM to design, develop, test and review.
• Implemented various match and merge rules based on teh requirement to generate master data.
• Created post-sessions and pre-sessions for all teh sessions to update teh etl process table which is used to understand teh current status of ETLs.
• Involved in performance tuning on Informatica ETL mappings analyzing them thoroughly.
• Involved in identifying various bottle necks at different levels (database, mapping, session, and workflow) and came up with solution to improve teh performance.
• Created table partitions for each of teh country, operating company and period combination which enables faster retrieval of data.
• Used Informatica Power Center, Informatica Data Quality (IDQ), Informatica analyst tool, Oracle Views, Oracle Stored Procedures, Oracle complex quires and UNIX to provide teh solution.
• Created Oracle Stored Procedures to implement teh ETL Process control logic.
• Designed Oracle views that generate these extracts for upstream applications and created ETLs to read these views and drop them in a file.
• Created a model for Audit mechanism and included teh Audit counts in each of teh ETLs to verify teh source and target counts and sums.
• Identified various extracts needed for upstream reporting applications and planning applications and designed structures for teh same.
• Documented all teh ETL and Oracle Procedures developed.
• Used Informatica ETL Power Center 9.6 for migrating data from various OLTP databases to teh data mart.
• Created Unit Test plans for various ETLs developed.
• Performed Unit Testing and Integration testing for teh ETL’s.
• Reviewed teh Code, Design and Test plans as appropriated throughout project lifecycle.

Environment: Informatica Power Center 9.5, Informatica MDM, Oracle 11g, Toad for Oracle, Surveyor for DB2, Cisco Tidal Scheduler, SQL, PL/SQL, Windows7/XP, UNIX

Confidential, Phoenix, AZ

Sr. Informatica Developer

Responsibilities:

• Responsible for requirement definition and analysis in support of Data Warehousing efforts.
• Performed data analysis on teh source data which was in SQL Server and Teradata.
• Developed ETL Mappings, Transformations using Informatica Power center 9.5.1
• Extensively used Informatica client tools source Analyzer, Warehouse Designer, Mapping Designer, Transformations Developer, Informatica Workflow Manager.
• Extensively used ETL tool to load data from Flat Files, Oracle, Teradata and DB2.
• Developed Data mappings between source system and Target system using Mapping Designer.
• Worked extensively on different transformations like Source qualifier, Expression, Filter, Aggregator, Router, Update Strategy, Lookup, sequence Generator.
• Worked on different Cashes in Cashable Transformations.
• Worked on Migration strategies between Development, Test, and Production Responsibilities.
• Prepared UNIX Shell Scripts and these shell scripts will be scheduled in Autosys for automatic execution at teh specific timings.
• Created teh sequence diagram and scheduled teh jobs using Autosys.
• Extensively worked with Slow Dimensional Types Type 1, Type 2, and Type 3 for Data Loads.
• Extensive use of Informatica Debugger to debug teh ETLs.
• Supported teh IDD console access for teh end users while maintain teh master data.
• Extensive use of Joins in teh Sql queries to transform teh data as per teh requirement.
• Setting up batches and sessions schedule teh loads of required frequency using Power Center Workflow Manager.
• Created and Executed JIL script for scheduling mapping.
• Extensive Data Modeling experience using Dimensional Data Modeling, Star Schema and Fact and Dimensional Tables.
• Worked closely with business analysts and gathered functional requirements, Designed Technical Design Documents for ETL process.
• Worked closely testing team for teh validation of data.
• Involved in teh Code review meetings with teh support team for teh Code review of ETL’s and Naming Standards, locking teh CR, and Moving teh ETL and DB objects into teh Production Environment.
• Worked on Pre-Production and Post-production issues.

Environment: Informatica - Power Center 9.5.1 in SQL Server, Oracle 10 G, Teradata, DB2, UNIX Shell Script, Windows NT/2000/XP. ER/ Studio, Pac 2000, SVN, JIRA, Autosys.

Confidential, Palm Desert, CA

Informatica ETL Consultant

Responsibilities:

• Analyzing business requirements and preparing technical documentation and application process and writing test cases.
• Working on Designing and Creating tables for new setup database, writing sub routines as per teh business requirement.
• Analyzing and evaluating data sources fields to match teh target fields for moving teh data from denormalized legacy system to normalized New Setup database.
• Developed mappings to load teh date from different sources like oracle, flat files
• Gather and/or clarify requirements directly from teh users or PM and developing new Informatica process for automating various new ETL activities.
• Writing UNIX scripts to ftp files, cleaning teh data, other required functionalities and place them in teh proper source/target directories for processing.
• Enhancement of existing complex ETL processes to support additional design, development and deployment of new and enhanced ETL processes to production and support new load strategy.
• Created variables in Expression transformation to compare current record with teh previous record and combine teh data for these records based on teh same claim numbers
• Responsible for creating shared and reusable objects in Informatica shared folder and update teh objects with teh new requirements and changes.
• Responsible for providing consolidated daily and weekly status reports to teh management and team.
• Responsible for coordinating teh Offshore and Onsite team and resolve all teh issues faced by teh team.
• Used FileZilla and WINSCP tool to create and view teh parameter files and other source files in UNIX in DEV, Testing and Production Environments.
• Extensively used pmcmd commands on command prompt and executed Unix Shell scripts to automate workflows and to populate parameter files
• Worked on Change Data Capture data sources.
• Prepared ETL low level and high level design documents.
• Debugging invalid mappings using break points, testing of stored procedures and functions, testing of Informatica sessions, batches and teh target Data.
• Wrote SQL, PL/SQL codes, stored procedures and packages for dropping and re- creating indexes, to generate oracle sequences, procedures that cleans up teh base automatically in case teh mapping already ran, teh procedure that will logically expire existing records and update specific Code, packages to in corporate business rules to sometimes eliminates transformation dependency
• Improving teh SQL query performance, and updating teh technical documents.

Environment: Informatica Power Center v 8.6, Oracle 9i/10g, CSV Files, Excel files, SQL,PL/SQL, Unix Shell scripting, Windows XP and, SQ Developer, Toad, Microsoft Visio.

Confidential

Database PL/SQL Developer

Responsibilities:

• Integrating functional noledge of teh client’s Business with technical requirements.
• Perform database tuning, monitoring, loading and back up.
• Used SQL LOADER to load data from csv files into Oracle tables.
• Creating prototype reporting models, specifications, diagrams and charts to provide direction to system programmers.
• Developed procedures and functions using PL/SQL.
• Created number of database Triggers according to business rules using PL/SQL.
• Developed SQL for loading Meta data from Excel spread sheet to teh database using SQL LOADER.
• Extensively used PL/SQL to implement cursors, triggers and packages.
• Developed SQL script for loading data from existing MS Access tables to Oracle.
• Create record groups for manipulation of data, Perform unit and system integrated testing.
• Involved in database design, development of database, tables and views.
• Provide support during User Acceptance Testing (UAT) of project.

Environment: Oracle 8i, PL/SQL, TOAD, SQL*Loader, MS Access, Excel spread sheet, Windows NT.