SUMMARY

• Over 7+ Years of IT Experience in designing, developing, implementing and delivering Full life cycle of Datawarehousing project. Result oriented professional in analyzing the Business requirements Analysis, Data Modeling, Development using Informatica, Oracle, MS SQL server, Implementations and Testing of Data Warehousing and Database Business systems for Health Care, Pharmaceutical, Financial, Insurance and Network Marketing Corporation.
• Eight years of Development and Design Experience with Informatica Power Center 9.5/9.1/8.6/8.1/7.1/6.x. Informatica Power Mart 6.2/5.1/4.7, Informatica Power Connect, Informatica Power Analyzer, ETL, OLAP, OLTP and Data Mining.
• Experience in all phases of development including Extraction, Transformation, and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Server Manager, Workflow Manager, and Workflow Monitor).
• More than Four years (4) of experience in Data Analysis, Data profiling, and data Cleansing using Informatica tools like
• Informatica Data Quality and Data Analysis.
• Extensive experience in Relational Database Systems design likes Oracle, SQL Server, MS Access; Multi - dimensional application and database development experience with SQL, SQL PLUS, Stored procedures.
• Experience with Oracle PL/SQL programming, stored procedures, creating triggers, sequence generator on the target table
• Experience in implementing complex Business rules by creating robust mappings using various transformations, mapplets, and reusable transformations, starting concurrent batch processes in server and doing backup recovery and tuning of sessions and developing strategies.
• Experience in Performance Tuning at various levels such as Source, Target, Mapping, Session, System and Partitioning.
• Experience in handling data extraction from multiple source platforms like Flat files, Oracle, XML files, XLS files, Oracle to target areas like Data Marts and Data Warehouse.
• Experience in creating Entity Relational & Dimensional Relational Data Models with Kimball and Inman Data warehousing methodologies (StarandSnowflakeschema architectures, Fact/dimension tables), Star Schema/Snowflake modeling, and FACT & Dimensions tables.
• Experience with Data Modeling using Erwin 4.0 Data Modeler.
• Experience with Initial & Incremental loading to Target databases using SCD Type1/Type2 loads
• Proficient in working on production and development environment in different RDBMS (in Oracle 8i/9i/10g, MS SQL Server 2000/2005,IBM DB2) and strong troubleshooting skills.
• Experience in writing SQL queries and PL/SQL (Stored Procedures, Functions and Triggers).
• Proficient in using DB tools like Toad, SQL*Plus, SQL*Loader Query Analyzer and SQL Assist.
• Experience in Oracle8i/9i/10g database, UNIX & NT operating system.
• Actively involved in Performance Tuning and support on various platforms. SQL Tuning and creation of indexes for faster database access and better query performance
• Self-motivated and able to work independently and as a member of a team.
• Excellent communication, interpersonal and analytical skills.

TECHNICAL SKILLS:

Databases/Databases Tools: Oracle 8i/9i/10g, SQL Server 2007, MS Access, DB2, Teradata 13.0, TOAD 8.6, SQL plus, ERwin 4.0, Query Analyzer, SQL Assistant, SQL Server Integration Service (SSIS), SAP Data Services

ETL/Reporting Tools: Informatica Power Center 8.6/6.2/5.1, Power Mart 6.2/5.1. Power Exchange9.0, IDQ, DVO// Cognos, Business Objects, Oracle BI tools, SSAS MethodologiesStar Schema, Snowflake Schema, Fact and Dimension Tables.

Operating Systems: Windows XP/NT/95/98/2000, UNIX, LINUX, MS- DOS.

Languages/Utilities: SQL, PL/SQL, Unix shell scripts, HTML, XML.

Query/Reporting: SQL, TOAD 6.5, SQL*Plus, Business Objects 5.1/5.0.

PROJECT EXPERIENCES:

Confidential, FL

Informatica Developer

Environment: Informatica Power Center 9.5, Oracle 11g, Informatica DVO, Teradata 13, Oracle 10g and Sql Server.

Responsibilities:

• Involved in Creating Test cases for both 8.6 and 9.5 Informatica.
• Worked closely with Business and Architect to understand the requirements and environments.
• Worked with Informatica Architect to set up Grid system with 4 nodes and two integration services.
• Involved in creating new connections in workflow manager and updating the ODBC.ini and Parameter files accordingly TNS entries for Teradata 13, SQL-Server and Oracle 10g.
• Worked with Informatica DVO tool to configure Regression Testing for 5000+ Tables using Power Center to create appropriate mappings, sessions, and workflows, to compare Table pairs.
• Involved in running several Workflows for each business to load data separately for 8.6 and 9.5 for regression testing.
• Used UNIX scripts to run Workflows to run test maps in 8.6 and 9.5 environment.
• Developer detailed DVO reports and TDD of the end results.
• Generated several table compare reports for both 8.6 and 9.5.
• Worked closely with Business and Architect to understand the requirements.
• Responsible to convert the Business Requirements into Data Mapping Sheet.
• Involved in creating the test cases.
• Working on Dimension as well as Fact tables, developed mappings and loaded data on to the relational database.

Confidential

Informatica Developer

Environment: Informatics Power Center 9.1, SQL, PL/SQL, Linux, Oracle 11g, SQL Developer, DB2 (AS400), Teradata 12.0

Responsibilities:

• Requirements gathering from Business users and prepared a TDD.
• Involved in Rollback Strategy from Oracle back to DB2 for insurance purposes.
• Extracted data from AS400 DB2 to load oracle every 2 hours using PWX CDC and Power center Informatica tool..
• Worked closely with Business team to understand the requirements to convert BRD into Informatica code.
• Worked closely with Architect and Data warehouse team to Integrate for smooth flow of data.
• Involved in creating Shared and Re-usable Objects in the shared folder and update the objects with the new requirements and changes.
• Developed a total of 1600 mapping in combination of COPY and CDC mapping.
• Deployed the maps, workflows, and all dependent objects from development to testing, testing to QA and from QA to production.
• Used Debugger to check the errors in the mapping and made appropriate changes in the mappings to generate the required results
• Developed Mappings, Mapplets, and Reusable Transformations to extract, transform and load the data.
• Used PMCMD UNIX Scripts to Run and check the Status of the job.
• Migrated code to Functional and performance environment using Deployment groups by creating labels.
• Heavily involved in Performance Tuning of Informatica mappings to reduce the time taken for bactch jobs.
• Prepared a detail Technical Design Document.

Confidential

Informatica Developer

Environment: Informatics Power Center 9.1, SQL, PL/SQL, UNIX, Oracle 9i, Win 2000, TOAD 5.0.:

Responsibilities:

• Collection of requirements from business users and analyzed based on the requirements.
• Extensively used XML files to Design and develop complex Informatica mappings using expressions, aggregators, filters, lookup and stored procedures to ensure movement of the data between various applications
• Worked with TOAD to create and Alter Tables, Triggers, Sequences, and other DDL, DML and
• DCL utilities of Oracle 9i and 10g
• Used Debugger utility of the Designer tool to check the errors in the mapping and made appropriate changes in the mappings to generate the required results.
• Worked on identifying Mapping Bottlenecks in Source, Target and Mappings to Improve performance
• Monitored workflows and session using Power Center workflow monitor.

Confidential

Informatica Developer

Environment: Informatica Power Center 9.1, Oracle 10g, PL/SQL, TOAD, Flat Files, Windows XP, UNIX, Tidal TES v6.0

Responsibilities:

• Involved in meeting with business to gather, Designed the target load process based on the requirement documents.
• Optimized the performance using Informatica Performance Concepts.
• Developed Mappings and Workflows to generate Staging Files.
• Developed Mappings and Workflows to load the data into Oracle tables.
• Developed various transformations like Source Qualifier, Update Strategy, and Lookup transformation, Expressions and Sequence Generator, Stored Procedure for loading the data into target table.
• Created Workflows, Tasks, Database Connections using Workflow Manager
• Developed Complex Informatica mappings and tuned them for better performance
• Created sessions and batches to move data at specific intervals.
• Responsibilities include creating the Sessions and Scheduling the sessions
• Recovering the failed Sessions and Batches.
• Involving in extracting the data from Oracle and Flat files
• Implemented performance tuning techniques by identifying and resolving the Bottlenecks in source, Target, Transformations, mappings and sessions to improve performance Understanding the Functional Requirements.
• Developing, Testing and debugging the mappings in Informatica.
• Data Validation Testing.
• Preparing the documents for test Data Loading

Confidential, Ohio

Informatica Developer

Environment: SQL Server Integration Service (SSIS), Sql Server 2000, Netezza, Toad 6.5, PL-SQL.

Responsibilities:

• Worked on Dimensional modeling to Design and Develop STAR Schemas and SNOWFLAKE Schemas, used ER-win 4.0, identifying Fact and Dimension Tables.
• Part of documenting and testing all the ETL connections at the time of migration from Old to New Netezza box.
• Used Informatica to transform Flat files, Relational tables from Oracle to Netezza Box.
• Designed the ETL processes using Informatica to load data from Flat Files, Excel files to Staging Area.
• Designed and developed Data Flow Transformations like Aggregate, Merge Join, Lookup transformation rules (business rules) to generate consolidated (fact/summary) data identified by dimensions
• Interacting with Users and participating in Gathering the Requirements.
• Developed Data Flow diagrams to Create Mappings and Test plans from OLTP systems to staging to Data warehouse.
• Worked on change data capture for slowly changing dimensions (SCD-2) to update a target table to keep full history.
• Implemented Performance Tuning Logic’s wherever possible to provide maximum efficiency and performance.
• Involved in creating Shared and Re-usable Objects in the shared folder and update the objects with the new requirements and changes.
• Designed and developed Efficient Error Handling while loading in Staging Area.
• Performed Unit testing and System testing of Mappings. Efficient documentation was done for all mappings and sessions.
• Extensively used SCD’s (Slowly Changing Dimension) to handle the Incremental Loading for Dimension and Fact tables.

Confidential

Informatica Developer

Environment: Informatica Power Center 8.6, Win 2000, Flat Files, PL/SQL, Erwin 3.0, Toad 5.0.

Responsibilities:

• Analyzed the business requirements and framing the business logic for the ETL process.
• Extensively used ETL to load data from both fixed width as well as Delimited Flat files.
• Worked extensively on different types of transformations like expression, union, filter, aggregator, update strategy, lookup, stored procedure, sequence generator joiner and normalizer.
• Designed and Developed complex mappings, reusable Transformations for ETL using Informatica Power Center 8.6.
• Developing and testing all the Informatica mappings involving complex Router, lookups and update strategies.
• Created workflows and work lets for designed mappings.
• Implemented variables and parameters in the mappings.
• Setting up batches and sessions to schedule the loads at required frequency using Power center workflow manager.
• Generated completion messages and status reports using workflow manager.
• Working on Dimension as well as Fact tables, developed mappings and loaded data on to the relational database.
• Involved in writing ETL specifications and unit test plans for the mappings.
• Performed Developer testing, Functional testing, Unit testing for the Informatica mappings.
• Designed the ETL processes using Informatica to load data from SQL Server, Flat Files, XML Files and Excel files to target Oracle database.
• Performed data manipulations using various Informatica Transformations like Joiner, Expression, Lookup, Aggregate, Filter, Update Strategy, and Sequence Generator etc.
• Written SQL overrides in source Qualifier according to business requirements.
• Created reusable transformations and mapplets.
• Redesigned some of the mappings in the system to meet new functionality.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent batches and Sessions and scheduling them to run at specified time with required frequency.
• Used workflow Monitor to monitor the performance of the Jobs.
• Extensively worked in the performance tuning of the ETL process.
• Extract the data from relational source (Oracle), Flat Files & perform mappings based on company requirements and load into Oracle tables. Used unconnected lookup transformation, aggregator transformations, Update Strategy, Filter, Normalizer and Router Transformations.
• Extensively used Informatica functions LTRIM, RTRIM, IIF, DECODE, ISNULL, TO DATE, DATE COMPARE in Transformations.
• Worked extensively on Informatica repository manager, Designer, workflow manager to create, sessions, workflows and monitor the results and validate them according to the requirement.
• Performance Tuned Informatica Targets, Sources, mappings and sessions for large data files by increasing data cache size, sequence buffer length and target based commit interval.
• Tested the target data against the source system tables by writing the SQL queries and documented the results in the excel sheet.
• Participated in Migration of Informatica Code and workflows from development to testing, testing to QA and from QA to production.
• Used Debugger to check the errors in the mapping and made appropriate changes in the mappings to generate the required results.
• Worked with tools like TOAD and SQL tools to write queries and generate the results.
• Interactions with various business users / Source contacts, DBA’s and system administrators for production issues.
• Documented the mapping strategies and transformations involved in the extraction, transformation and loading process.
• Worked with ETL lead to prepare the documentation for the whole Extraction Transformation and Loading process for EPM (Enterprise Performance Management)

Confidential, Rochester, NY

Informatica Developer

Environment: Informatics Power Center 7.x Designer, Informatica Repository Manager, PL/SQL, Unix, Oracle 9i, Win 2000, TOAD 5.0.

Responsibilities:

• Extract the data from relational source (Oracle), Flat Files & perform mappings based on company requirements and load into Oracle tables. Used unconnected lookup transformation, aggregator transformations, Update Strategy, Filter, Normalizer and Router Transformations.
• Extensively used Informatica functions LTRIM, RTRIM, IIF, DECODE, ISNULL, TO DATE, DATE COMPARE in Transformations.
• Worked extensively on Informatica repository manager, Designer, workflow manager to create, sessions, workflows and monitor the results and validate them according to the requirement.
• Performance Tuned Informatica Targets, Sources, mappings and sessions for large data files by increasing data cache size, sequence buffer length and target based commit interval.
• Tested the target data against the source system tables by writing the SQL queries and documented the results in the excel sheet.
• Migrate the maps and workflows from development to testing, testing to QA and from QA to production.
• Used Debugger to check the errors in the mapping and made appropriate changes in the mappings to generate the required results.
• Worked with tools like TOAD and SQL tools to write queries and generate the results.
• Interactions with various business users / Source contacts, DBA’s and system administrators for production issues.
• Documented the mapping strategies and transformations involved in the extraction, transformation and loading process.
• Worked with ETL lead to prepare the documentation for the whole Extraction Transformation and Loading process for EPM (Enterprise Performance Management)

Confidential, Miami, FL

Project Engineer

Environment: Windows NT, Oracle 9i, Informatica 6.1, Power center RT, Erwin 3.5.2, and SQL Server 2000.

Responsibilities:

• Understanding the requirements and the elements required for the reporting.
• Analyzed the data coming from different sources and their relationships and created configuration tables.
• Interacted with business community and gathered requirements based on changing needs and incorporated identified factors into Informatica mappings to build Data Marts.
• Responsible for the physical and logical design of the Datamart (Oracle9i) on Windows NT.
• Updating existing ER diagram, database schema and table definition as per client requirements.
• Involved in creating dimension and fact tables in the database.
• Identified, imported the sources and targets into shared folder and created shortcuts.
• Extensively used mapplets, lookups, Expressions, aggregators, filters, sequence generators and other transformations in the mappings.
• Written pre and post SQL in the source qualifier and target instance as required.
• Created sessions and workflows and populated the data mart with the development data.
• Used debuggers to detect bugs in the mappings with the development data.
• Performed partitions on the sources to improve the performance.
• Enabled incremental loading in fact table mappings and made required changes to the mappings to populate the production data.
• Improved the performance of the mappings by indexing and tuning.