SUMMARY

• Around 10 years of experience in Business Requirements analysis, Data Analysis, Application Design, Dimensional Data Modeling, Designing, Coding, Development, Testing and implementation of business applications with RDBMS, Data Warehouse/Data Mart, ETL, OLAP, Client/Server environment applications for Financial, Pharmacy and Insurance Verticals
• Experience in data extraction, transformation and loading using Informatica PowerCenter 8.6/8.5/8.1.1/7.1.1/7.0 (Source Analyzer, Repository Manager, Data Warehousing Designer, Mapping Designer, Mapplet Transformation), Informatica Power Exchange and Power Connect
• Good experience in Dimensional Data Modeling, Star Schema/Snowflakes schema, Fact and Dimension tables, Physical & logical data modeling using Erwin 4.5 /4.x/ 3.0 and Visio
• Extensive experience with Data Extraction, Transformation, and Loading (ETL) from disparate data sources like Multiple Relational Databases. Worked on integrating data from flat files, CSV files, and XML files into a common reporting and analytical Data Model
• Strong understanding of RDBMS concepts and experience in writing PL/SQL and SQL statements in databases
• Good experience in using Oracle 10g/9i, DB2 8.0/7.0, MS SQL Server 2008/2005/2000 , Teradata 12.0, TSQL, MS Access 7.0/2000, XML, PL/SQL (Functions, Procedures, Triggers and Cursors), SQL*Plus, SQL*Loader.
• Experience in integration of various data sources like Oracle, SQL server, VSAM and sequential files into staging area
• Worked with Oracle and SQL Server Stored Procedures, Index, Table Partitions and experienced in loading data into Data Warehouse/Data Marts using Informatica, SQL*Loader, Well Versed with different tools for accessing Databases and development in databases like TOAD, PL/SQL Developer
• Developed Slowly Changing Dimension Mappings of type I, II and type III (version, flag and time stamp)
• Used Incremental Aggregation to update the values in flat table
• Tuning of SQL Queries, Database leading to significant improvement in system response time and efficiency using Execution Plan and Trace File
• Expertise in implementing complex Business rules by creating complex mappings/mapplets, shortcuts, reusable transformations and Partitioning Sessions
• Good Exposure to Reporting tools such as Business Objects XIR3/XIR2
• Strong Experience to TOAD & ODBC interfaces to Oracle.
• Strong knowledge in ODBC Connections to Oracle database and expertise in connecting to SQL server using ADO.NET
• Proficient in estimation and determination of the level of effort required for the implementation and integration testing.
• Excellent in communicating at all levels of management with experience in coordinating various client meetings, seminars, presentations and group discussions
• Good team player with excellent trouble shooting skills

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 8.6/8.5/8.1.1/7.1.1/7.0 , Designer, Repository Manager, Repository Server, Workflow Manager & Workflow Monitor, Informatica Data Quality 8.5,Informatica Data Explorer 8.5,power Exchange, Power Connect, Star Schema, Snowflake Schema, OLTP.

Reporting Tools: Business Objects XIR3/XIR 2/6.0/5.1/4.1

Data Modeler: ERWIN 4.5/3.0, Visio, Star Join Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling.

Operating Systems: Windows 95/98/2000/XP/NT/Vista, Unix

Languages: C, SQL, PL/SQL

Databases: Oracle 10g/9i/8i/8.0/7.x,MS SQL Server 2008/2005/2000 , SQL*Loader, SQL*Plus, IBM DB2 8.0, TOAD, Teradata 12.0.

Database Tools: SQL,SQL*plus, TOAD, PL/SQL Developer

Packages: MS Office and Front Page 98/2000

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Sr. Informatica Developer

Responsibilities:

• Performed data analysis on the source data coming from point of sales systems (POS) and legacy systems.
• Involved in data migration from legacy systems to ERP systems(SAP CRM)
• Involved in the design phase of logical and physical data model using Erwin
• Designing and creation of complex mappings using SCD type II involving transformations such as expression, joiner, aggregator, lookup, update strategy, filter.
• Involved in designing the Workflows, Worklets, Mappings, Sessions and configuring the Informatica Server using Informatica Power Center 8.6
• Experience in optimizing the Mappings and implementing the complex business rules by creating re - usable transformations, Mapplets.
• Extensive experience in full cycle implementation of Informatica.
• Used various transformations like lookup, update strategy, router, filter, sequence generator, source qualifier, joiner on data extracted according to the business rules and technical specifications.
• Involved Migration activities from development and pre-production environments.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Load balancing of ETL processes, database performance tuning and Capacity monitoring.
• Worked with the MLOAD, TPUMP and FASTLOAD utilities of Teradata for faster loading and to improve the performance
• Worked extensively on Source Analyzer, Mapping Designer, Mapplet designer and Transformation Developer.
• Used UNIX to create Parameter files and for real time applications.
• Extensively involved in testing the system from beginning to end to ensure the quality of the adjustments made to oblige the source system up-gradation.
• Optimized SQL queries using hints and indexes.
• Performed scrubbing and cleaning of the data.
• Performed Unit Test and Integration Test for the ETL Processes.
• Integrated query reporting, iterative analysis and investigative workflow were provided to the end users by using Business objects.
• Generated Reports using BO tool.
• Created sessions and workflows to run with the logic embedded in the mappings using Power center Designer.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Extensively developed Informatica mappings & tuned them for better performance.
• Used Business Objects free hand SQL to generate Adhoc reports
• Responsible for weekly status updates showing the progress of the ETL process.
• Documented Process Flow for mappings and session.
• Improved session run times by partitioning the sessions. Was also involved into database fine tuning (creating indexes, stored procedures, etc), partitioning oracle databases.
• Developed mappings in Informatica Designer tool to extract data from source system, transform and load to the data warehouse.
• Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions. This led to better session performance
• Involved in monitoring the workflows and optimizing the load times.
• Extensively used Informatica debugger to validate mappings and to gain troubleshooting information about data and error conditions.
• Documenting the entire process. The documents included the mapping document, unit testing document and system testing document.

Environment: Informatica PowerCenter8.6.1 (Source Analyzer, warehouse designer, Mapping Designer, Maplet Designer and Transformations), Teradata 12.0, Oracle 10g/9i, MS SQL Server 2008, TOAD, PL/SQL, Business Objects XI R3, Erwin 4.5,Windows XP, HP-UX.

Confidential, Charlotte, NC

Informatica Developer

Responsibilities:

• Responsible for performance tuning ETL process to optimize load and query Performance
• Created complex transformations using connected / unconnected lookups / procedures
• Performed analysis of the data transformations and data types for transforming business rules into transformation logic to be used in the ETL process
• Added and modified Informatica mappings and sessions to improve performance, accuracy, and maintainability of existing ETL functionality.
• Provided suggestions to improve existing mappings
• Wrote SQL overrides in source qualifiers with appropriate schema names for extracting only the required rows for optimal performance.
• Implemented complex expressions in expression transformations. Tested the queries thoroughly in SQL navigator for integrity and identifying data errors
• Preparation of Unit Test Plans and verification of functional specifications and review of deliverables
• Setting of Error Logic for streamlining and automating the data loads for cleansing and trapping incorrect data on staging servers and then loading it to the data warehouse
• Scheduling and Loading data process and monitoring the ETL Process
• Used various data Sources like Flat Files, Relational Tables and COBOL Copybooks
• Extensively used Stored Procedures for Pre Session and Post Session Data Loading Process
• Debugged the mappings using the Debugger facility in Informatica. Used the target load order feature for loading tables with constraints
• Provided production support by monitoring the processes running daily
• Identified the bottlenecks and improved overall performance of the sessions

Environment: Informatica Power Center 8.6, Erwin 4, Oracle 9i/10g, PL/SQL, PVCS, SQL*Loader, TOAD, MS SQL Server 2005/2008,Business objects XI R2, DB2 8.0, Windows XP

Confidential, NY

Informatica Consultant

Responsibilities:

• Worked closely with the business experts to understand the source data in OLTP system
• Designed Logical and Physical models for staging, transition and production using Erwin
• Interviewed Subject Matter Experts, Business Managers to understand the data in OLTP system
• Designed Star Schema based on data model with Dimensions and Facts
• Created reusable mapplets, transformations and mappings using Informatica Designer
• Optimizing Query Plan, Performance Tuning
• Designed and developed complex mappings using various transformations in Designer to load data from Flat files, Cobol files in DB2 environment into the target Oracle 9i data warehouse
• Extensively used Stored Procedure, Functions and Triggers
• Worked on performance tuning of the complex transformation like SCD type 1 & 2
• Tuned mappings to achieve faster data loads to the data warehouse
• Tuned Databases, Stored Procedures, Transformation, Mapping, Sessions and SQL queries to enhance Response Time
• Created Unix Shell scripting for scheduling the workflow
• Extensively used debugger to troubleshoot logical errors

Environment: Informatica PowerCenter 8.5/8.1, Oracle 10g/9i, Erwin 4.1, MS SQL Server 2005/2008, DB2 7.0, Business Objects 6, windows XP, Unix, Erwin.

Confidential, NJ

ETL DEVELOPER

Responsibilities:

• Member of warehouse design team, assisted in creating fact and dimension table implementation in Star Schema model based on requirement documentation
• Interacted with business community and gathered requirements based on end user business needs and incorporated identified factors into Informatica mappings to build Data Warehouse
• Involved in the data migration from COBOL Files from Mainframe-AS 400 to Oracle 8i
• Loaded operational data from Oracle, SQL server into the data warehouse Oracle 8i
• Created, Monitored and Debugged tasks and workflows using designer
• Designed and created complex source to target mappings using various transformations including SCD type I and II, Aggregator, Look Up, Joiner, Source Qualifier, Expression, Sequence Generator, and Router Transformations
• Developed stored procedures, Triggers and functions on Oracle 8i databases to impart business logic for calculations into mappings and trigger pre/post session activities through UNIX shell scripts
• Designed complex mappings involving target load order and constraint based loading
• Improved session performance by batch processing and monitored sessions using Workflow Manager
• Involved in enhancements and maintenance activities of the data warehouse including performance tuning, creating aggregate tables, and modifying target tables
• Scheduled several Workflow USING PMCMD COMMANDS sessions

Environment: Informatica PowerCenter 8.5/8.1, Oracle 10g/9i, Erwin 4.1, MS SQL Server 2005/2008, DB2 7.0, Business Objects 6, windows XP, Unix, Erwin.

Confidential, Berkeley, CA

Informatica Consultant

Responsibilities:

• Implemented Security features on different domain folders by giving appropriate privileges
• Used Repository manager to create groups and users, and managed users by setting up their privileges and profile
• Analysis was done using existing transactional database schema and designing star schema model to support user need for reporting
• Created the mappings in the Informatica for extraction, transformation and loading from Source to Targets
• Developed the ETL procedure to ensure conformity, compliance with standards and lack of redundancy, translate business rules and functionality requirements into ETL procedure in PL/SQL
• Implemented complex mapping such as Slowly Changing Dimensions Type 2 using Flag.
• Developed number of complex Informatica Mappings, mapplets and reusable transformations for other mappings
• Extensively used Transformations like Router Transformation, Aggregator Transformation
• Source Qualifier Transformation, Joiner Transformation, Expression Transformation and Sequence generator Transformations
• Designed and developed Oracle PL/SQL Procedures
• Developed stored procedures using PL/SQL to backfill the data in production environment
• Used PMCMD command to trigger the workflow through command line in the UNIX environment

Environment: Informatica PowerCenter 7.1.1(Informatica Server, Informatica Repository Server, Repository Manager, Designer, Work Flow Manager, Work Flow Monitor), Erwin 4.0, Oracle 10g/9i, SQL, PL/SQL, SQL*Loader, TOAD, MS SQL Server 2000, Flat files, UNIX

Confidential

Programmer Analyst

Responsibilities:

• Worked on several data mart projects with data warehouse architect, was involved in complete system development life cycle, starting from requirement specifications to delivering the tested product
• Designed and developed transformations based on business rules to generate comprehensive data using Oracle Warehouse Builder
• Data Extraction, Transformation & Loading with Oracle Warehouse Builder
• Designed data warehouse and data marts from scratch and fine-tuned existing data warehouses
• Extensively used all the features of Oracle Warehouse Builder like Pivot, Unpivot, and Joiner etc
• Worked extensively with mappings using expressions, aggregators, filters, lookups, pre mapping and post mapping transformations

Environment: Oracle Warehouse Builder 8i, Oracle 9i, PL/SQL, SQL*Plus, SQL*Loader, Erwin 3.0, Windows XP Professional