SUMMARY

• 8+ years of IT experience with expertise in analysis, design, development and implementation of Data warehousing using ETL, BI tools with Oracle, DB2, MS SQL server and Teradata databases on windows/Unix platforms.
• Experience in Data Integration and Data Warehousing using ETL tool Informatica Power Center/7.x/8.x/9.x. Knowledge of Informatica tools Power Exchange, Power Center, Data Analyzer, IDQ and Meta Data Manager.
• Expert - level mastery in designing and developing complex mappings to extract data from diverse sources including flat files, RDBMS tables, legacy system files, XML files, Applications, Mainframe Sources.
• Proficient in implementing Complex business rules by creating re-usable transformations, workflows/work lets and Mappings/Mapplets.
• Expertise in design and implementation of SCD - Slowly changing dimensions types (1, 2 and 3) and CDC - Change data capture.
• Experience in Performance Tuning of mappings and sessions.
• Thorough knowledge of database management concepts like conceptual, logical and physical data modeling and data definition, population and manipulation.
• Experienced in writing Unix Shell Scripts for the automation of ETL processes and using schedulers like Autosys, Ctrl-M, and TWS.
• Good Hands on experience with Data Masking.
• Strong expertise in Relational data base systems like Oracle, SQL Server, Teradata, MS Access, and DB2 design and database development using SQL, PL/SQL, SQL PLUS, TOAD, and SQL-LOADER.
• Highly proficient in writing, testing and implementation of triggers, stored procedures, functions, packages, Cursors using PL/SQL.
• Experience in Task Automation using Power Shell Scripts, Job scheduling (Tidal), Autosys, TWS and Communicating with Server using pmcmd.
• Extensive experience in Siebel CRM platform and OBIEE.
• Proven record in both technical and functional applications of RDBMS, Data Mapping, Data management and Data transportation.
• Did the performance tuning of user queries by analyzing the explain plans, recreating the user driver tables by right primary Index, scheduled collection of statistics, secondary or various join indexes.
• Strong problem solving, analytical, interpersonal skills, communication skills and have the ability to work both independently and as a team.
• Self-motivated person with excellent communication and interpersonal skills.

TECHNICAL SKILLS

ETL Technologies: Informatica Power Center 9.x/8.x/7.x./6.x, IDQ/IDE 9.x, Power Exchange

Databases: Oracle 11g/10g/9i/8x/, SQL Server 2000/2005, DB2, Teradata V2R6, MS Access 2000.

CRM: Siebel Tool 7.5, 7.8, 8.1, OBIEE

Operating Systems: Windows 2000/NT, UNIX, DOS.

Languages: SQL, PL/SQL

DB Tools: SQL plus, SQL Loader, TOAD, Quest Central, Erwin 4.1

Scheduling Tool: Informatica Workflow Manager, Autosys, Control-M, TWS

Data Modeling: E/R Modeling, Dimensional Modeling (Star, Snowflakes Schema Modeling).

PROFESSIONAL EXPERIENCE

Confidential, CO

Senior Informatica Developer

Responsibilities:

• Involved in the Analysis of the end user’s business requirements.
• Involved in Designing the ETL piece, Development and Testing of the project.
• Extensively worked with Source Qualifier, Aggregator, Sorter, Normalizer, Rank, Joiner, Union, SQL, Sequence Generator, Transaction Control, Lookup, Router, Expression, Filter, Update Strategy, Data Masking and Stored Procedure transformations.
• Worked in the Power center Sales force in order to pull the data from the cloud database.
• Designed tables required for the execution of the ETL processes using Erwin.
• Modified existing/Developed new complex Informatica PowerCenter Mappings to extract and pull the data according to the guidelines provided by the business users and populate the data into Target Systems.
• Extensively performed Data Masking for preserving the referential integrity of the user data.
• Data Generation included New and ADHOC set of rules for the tables created and data generation rules implemented to create the number of rows in Test Environment, Data Masking is masking the prod data in Test, and Subset includes filtering the Prod data based on ideally date to minimize the amount of data.
• Moving the data from source systems to different schemas based on the dimensions and fact tables by using the slowly changing dimensions type 2 and type 1.
• Worked on Change data Capture (CDC) using CHKSUM to handle any change in the data if there is no flag or date column present to represent the changed row.
• Involved in identifying the bottlenecks of the Informatica mappings and tuned the mappings and increased the performance of the mappings.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Used Pushdown Optimization, Incremental Aggregation and Persistent Cache in order to increase the performance of the jobs.
• Worked with member enrollment data, claim data, inbound files, outbound files generated after HIPPA Gateway.
• Experienced on handling Rxclaim feeds, RxClaim Heirarchy data, Member data, and Member Eligibility data and extensively worked with HIPPA standards
• Involved in tuning the lots of oracle queries and increased the performance to a greater extent.
• Experienced in writing complex SQL and PL/SQL in oracle.
• Worked extensively on the Oracle External Tables which will help us to read the flat file in the form of table without loading them into the table.
• Worked in the Informatica Repository tables to identify the run statistics, dependency, etc. of the Informatica objects.
• Worked extensively in Informatica Data Profiling which will help us to understand the nature of the source data
• Involved in the continuous enhancements and fixing of production problems.
• Performed Data Quality checks, and developed ETL and Unix Shell Script processes to ensure flow of data of the desired quality.
• Involved in Unit Testing, System Testing, User Acceptance Testing to check whether the data load into target are accurate which was extracted from different source systems according to the user requirements by generating several SQL test scripts, validating against test cases based on the pre-defined test plans.
• Prepared all documents necessary for knowledge transfer such as ETL strategy, ETL development standards, ETL processes.
• Familiar with Agile software methodologies (scrum).

Environment: Informatica Power Center 9.6.1, Power Exchange, Oracle 10g/9i, SQL, PL/SQL,SQL Server, TOAD 11.0.0, Tableau, Erwin, UNIX, Autosys, Oracle External Tables.

Confidential, NY

ETL Informatica Developer

Responsibilities:

• Analyzed the existing mappings which are affecting during rollout.
• Worked with Business Analysts and identified the mappings which need to modify to load international operating units data into EDW system.
• Involved in designing Logical/Physical Data Models (Star Schema), forward/reverse engineering using Erwin.
• Developed new mapping to inactivate International customers from customers dimension and load customers from Oracle EBS.
• Developed new Informatica mappings to load the international data into existing EDW system
• Developed the Informatica mappings to load the Sales Orders, Purchase Order details from Oracle EBS tables to ODS tables and EDW.
• Developed the Informatica mappings to load the Receivables Invoices, Revenue Information and Ledger details from Oracle EBS tables to ODS tables.
• Developed number of complex Informatica mappings, mapplets, and reusable transformations to implement the business logic and load the data incrementally.
• Worked on Change Data Capture (CDC)
• Have very good exposure on Change Data Capture using PowerExchange for Oracle.
• Prepared the automation script which identifies the data gap between source and target systems.
• Used various Transformations like Joiner, Aggregate, Expression, Lookup, Filter, Union, Update Strategy, Stored Procedures, and Router etc. to implement complex logics while coding a Mapping.
• Involved in performance tuning of the ETL process by determining the bottlenecks at various points like targets, sources, mappings, sessions or systems. This led to a better session performance.
• Involved in identifying bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs so that they confirm to the business needs.
• Performed extensive unit testing, system testing, Regression testing to check the proper and timely flow of data.
• Written SQL Queries, PL/SQL Procedures, functions, Packages to apply and maintain the Business Rules.
• Created and maintained various project related documents like high level design documents etc.
• Proficient in handling production incidents (critical issues) and production related issues involving multiple stakeholders/vendors.

Environment: Informatica Power Center 9.1, Power Exchange, Oracle EBS R 12/11.5.10.2 , Oracle 10g, Teradata, PL/SQL, SQL, SQL*LOADER, ERWIN, TOAD, Control-M, Unix Shell Scripting

Confidential

Informatica Developer

Responsibilities:

• Involved in designing and development of informatica jobs.
• Data Modeling (Star Schema-dimensional fact tables) using Erwin.
• Extensively worked with Aggregator, Sorter, Normalizer, Rank, Joiner, Union, Sequence Generator, Data Masking, Transaction Control, Lookup, Router, Expression, Filter, Update Strategy, and Stored Procedure transformations.
• Created reusable transformations, mapplets, parameter files and variables for better re-usability.
• Usage of data masking transformation logic including Key, Expression and Substitution.
• Extensively worked on the ETL mappings, analysis and documentation of requirements.
• Excellent knowledge and experience in creating source to target mapping, edit rules and validation, transformations, and business rules.
• Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals. Excellent written and verbal communication skills including experience in proposal and presentation creation.
• Extracted data from various sources like Flat files, Oracle and loaded it into Target systems using Informatica.
• Worked with tables, indexes, constraints, views, Materialized views and synonyms.
• Experience in Performance tuning of targets, sources, mappings and sessions.
• Created views, functions, procedures and triggers in PL/SQL

Environment: Informatica 8.1.1, Oracle 9i, 10.g, PL/SQL, Erwin, Control-M, Unix

Confidential

Informatica / Siebel CRM Developer

Responsibilities:

• Working with business analyst to understand requirements.
• Preparing design documents based on the functional specs.
• Preparing Data Mapping Sheets according to the requirements.
• Worked on Data loads for various Siebel entities.
• Extracting data from Flat files and Loading data into the EIM Tables
• Designing EIM configuration files (IFB file) for Import, Export and Delete processes
• Involved in running the EIM Jobs & analyzing log files for proper data migration from EIM tables to Siebel base tables..
• Monitoring Production Jobs daily, weekly and monthly Automated Siebel EIM data loads in the Production environment and Recovering amended jobs immediately.
• Worked with various Siebel entities like Assets and Service Request apart from various others.
• Used Informatica Designer Tool to develop mappings for Extraction, Transforming and Loading required data into the OLTP System and then OLTP data into the Data Warehousing.
• Extensively used Informatica Power Center tools like the Source Analyzer, Transformation Developer, Warehouse Designer, Mapping Designer and Mapplet Designer.
• Worked extensively on different types of Transformations like Source Qualifier, Expression, Filter, Aggregator, Rank, Update Strategy, Lookup, Sequence Generator, Router and Joiner to design mappings.
• Developed UNIX Shell scripts for File Manipulation, FTP, Executing DB2 SQLs and archiving log files.
• Handling the inflow of tickets raised by the users responding them back with appropriate required details and successfully resolved tickets before SLA breach.
• Worked closely with the TWS Scheduling team to schedule Informatica jobs.
• Created effective Test data and developed thorough Unit test cases to ensure successful execution of the data loading processes.
• Used Update Strategy to effectively migrate data from source system to target Database.
• Extensively worked on Informatica to extract data from Db2 and Flat files from Mainframe System, and to load the data into the target database.
• Hands on experience with TWS scheduling.
• Successful upload of the daily batch load. This includes recovery of batch in case of failures (which may be of several reasons), communication with host teams in case of any missing files.
• Writing Db2 batch jobs to extract data from tables into files based to client requirements.
• Raising CRs for any Production Level changes according to IBM standards.

Environment: Siebel CRM 8.1,Informatica 8.5.1, DB2, Oracle 10g,OBIEE, Flat files, FTP Quest Central, SQL, SQL/PLSQL,UNIX, Mainframes (JCL Jobs), Quality Center 9.0, TWS