SUMMARY:

• IT: Over 13 years of experience in Software industry out of which around 10 years in data warehousing with ETL and OLAP technologies in Analysis, Design, Development, Testing, and Implementation of business application systems for Confidential, Health Care and Supply Chain Verticals
• DW Informatica: 10 Years of strong Data Warehousing ETL experience of using Informatica Power Center 9.6.1/9.1/8.6/7.1/6.2/5.1.2/4.7, Informatica Power Mart 6.2/5.1.2/5.0/4.7 (Source Analyzer, Repository Manager, Data warehousing designer, Mapping Designer, Mapplets, Transformations), Power Connect, Power Analyzer, MS SQL Server 2005, Mappings, Mapplets, Transformations, OLAP, Autosys, Control M, OLAP, OLTP, MOLAP, ROLAP, ETL, Datamarts, Data Transformation Studio 9.0(DT Studio)
• DW SSIS: Tremendous knowledge on MS SQL Server Integration Services (ETL) by implementing high performance data integrate solutions includes incremental load packages and made extensive use of Visual Source Safe to store packages
• ETL: 11 years of Data Warehousing ETL experience in working with Data extraction, transformation and loading using Business Objects Data Integrator XI and Informatica Power Center.
• Dimensional Data Modeling: 5 years of Dimensional Data Modeling experience using Data modeling, Erwin Modeling (ERwin 4.0/3.5.5/3.5.2, Oracle Designer) Star Join Schema/Snowflake modeling, FACT & Dimensions tables, Physical & logical data modeling. Hands on experience in Star and Snowflake schema design in relational, dimensional and multidimensional modeling and De - normalization techniques. Thorough understanding of Kimball and Inmon methodologies.
• Database: 12 years of experience using Oracle 11i/10g/9i/8i/8.0/7.0/RAC, MS SQL Server 2005/2000/7.0/7.0, MS Access 7.0/2000, SQL, XML, XSL, PL/SQL, SQL*Plus, SQL*Loader and Developer 2000, Win 3.x/95/98/2000, Win NT 4.0. Extensive experience on Performance tuning and writing SQL Scripts and shell scripts.

TECHNICAL SKILLS:

Data Warehousing: Informatica Power Center 9.6.1/9.0.1/8.6/7.1/6.2/5.1.2/4.7, Informatica Power Mart 6.2/5.1.2/5.0/4.7 (Designer, Workflow Manager, Workflow Monitor, Repository Manager, Data warehousing designer, Mapping Designer, Mapplets, Transformations), Data Transformation Studio 9.0, Power Connect, Power Analyzer, MS SQL Server 2005, Mappings, Mapplets, Reusable sessions, Workflows Transformations, OLAP, Autosys, Control M, Harvest 12.1(CA software change manager workbench) OLAP, OLTP, MOLAP, ROLAP, ETL, Datamarts, Datamining, Tivoli, Power Exchange v 5.2

Dimensional Data Modeling: Dimensional Data Modeling, Erwin Modeling (ERwin 4.0/3.5.5/3.5.2, Oracle Designer) Star Join Schema/Snowflake modeling, FACT & Dimensions tables, Physical & logical data modeling, Star & Snowflake schema Relational, dimensional and multidimensional modeling and De-normalization techniques, Kimball & Inmon Methodologies.

Databases: Oracle 11i/10g/9i/8i/8.0/7.0/RAC, SQL, PL/SQL, SQL*Plus, SQL*Loader MS SQL Server 2005/2000/7.0/6.5, MS Access 7.0/2000, SQL Developer 3.0.04,TOAD 9.0.1/10.6

Business Intelligence Tools: Business Objects5.1, Cognos 5.0, BRIO 6.0

Programming: SQL, PL/SQL, ISQL, ANSI SQL, Transact SQL, SQL*Plus 3.3/8.0, Visual Basic 6.0/5.0, HTML, DHTML, C, C++, Unix Shell Scripting

Environment: HP-UX 10.20/9.0, MS DOS 6.22,Win 3.x/95/98, Win NT 4.0

Others: HTML 4.0, DHTML, ODBC

PROFESSIONAL EXPERIENCE:

Confidential, Madison, WI

Programmer Analyst

• Extensively worked with the business and data analysts in requirements gathering and to translate business requirements into technical specifications.
• Knowledge in designing and developing data marts, data warehouse using multi-dimensional models such as Snow Flake schema and Star schema
• Expert in working on all activities related to the development, implementation and support of ETL processes for large-scale data warehouses using Power Center
• Develop Informatica technical design documentation to load data from legacy systems into Staging and Data warehouse tables.
• Tune existing Informatica mappings and SQL queries for better performance.
• Build Informatica mappings, workflows to process data into the different dimension and fact tables.
• Used Informatica Designer to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various sources.
• Developed transformation logic, Identifying and tracking the slowly changing dimensions, heterogeneous sources and determining the hierarchies in dimensions.
• Developed complex mappings using Informatica Power Centre Designer to transform and load the data from various source systems like Flat files, XML, Oracle to Oracle target database.
• Used look up, router, joiner, filter, source qualifier, aggregator, sequence generator, sorter and update strategy transformations extensively load the data from Flat Files, Tables and Excel sheets.
• Used Debugger wizard to remove bottlenecks at source level, transformation level, and target level for the optimum usage of sources, transformations and target loads.
• Developed Mapplets and Worklets for reusability and to improve performance
• Worked extensively on SQL, PL/SQL using WINSQL and SQL Developer
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Used Oracle performance tuning techniques to optimize SQL queries used in nformatica.

Environment: Informatica Power Center 9.0.1, Flat files, Oracle 10g/9i RAC, SQL Devloper V 3.0.04, Putty, Windows XP professional, Erwin 4.0, Toad, Tivoli, DT Studio, WinZip 9.0

Confidential, Madison, WI

Informatica Developer

• Participates in activities such as design reviews, problem solving, gap analysis, and configuration resolution.
• Worked on Informatica Power Center 9.0.1 tool - Source Analyzer, warehouse designer, Mapping Designer, Mapplets, and Reusable Transformations.
• Creating /Modifying UNIX scripts.
• Test synchronization mappings and compare results with SAP outcome results to verify both results are in sync.
• Data cleansing, Validations, data transformations and calculations in Data flows/ Work flows
• Responsible for generating Reports from Central Server, using Business Objects Tool.
• Creating oracle objects like Object Types, Object Views, Packages, Stored Procedures, Functions and Sequences in Oracle 11i.
• Extracted data from different sources like flat files, oracle and SQL server.
• Tuned the Informatica ETL processes for optimum performance by integrating ETL processes based on common sources and optimizing the source SQL to use the correct indexes.
• Create Change control and promote code into production environments with help of Informatica Administrators.

Environment: Informatica Power Center 9.0.1, Flat files, Oracle 10g/9i RAC, SQL Developer V 3.0.04, Putty, Windows XP professional, Erwin 4.0, Toad, Tivoli, DT Studio, WinZip 9.0

Confidential,Brookfield, IL

Sr. Informatica/DW Developer

• Requirement gathering, Business Analysis and documentation Functional, Technical, Integration Documents, low level and high level design documents .
• Solution for new requirements, Participate design and development phases of Algo Analytics.
• Documented the business data flow from multiple sources to Algo Analytics.
• Worked with DBA's closely to optimize and distribute workflow across multiple networked CPU nodes
• Worked on Informatica Power Center client tools - Mapping designer, Workflow manager, Workflow monitor, Repository manager, Mapplet designer and Transformations.
• Identify source systems, connectivity, and captured data using CDC techniques, tables, and fields, ensure data suitability for mapping.
• Developed complex mappings with transformations like lookup, Union, router, aggregator, expression, update strategy and joiner confirming to the business rules and documented.
• Implemented error handlings in mappings.
• Performance tuning of mappings, transformations and sessions to optimize session performance.
• Created various database objects, including tables, indexes, synonyms, complex PL/SQL stored procedures, functions and packages using aggregate and analytical functions and optimized performance by providing partitions, index and analyzing the table.
• Raised CCR (Change Control Request) and deployed the mappings and scripts between various environments like the Development, QA and production.
• Interacting with UNIX, Informatica and Data base administrators, if any issues/concerns occurred.
• Created session tasks (Session, Event Wait, Command etc.) and managed database connections and scheduled workflows.
• Hands on experience in writing UNIX scripts for various purposes FTP, Creating Parameter Files, Automation and running Informatica workflows .
• Created UNIX shell script for processing data files from source system, for archiving and running the workflows.
• Sending emails to users and production support through Informatica session on success or failure. Sending error email attachments through UNIX script to the User if the there are error records.
• Developed and documented Data Mappings/Transformations, and Informatica sessions as per the business requirement.
• Monitored Algorithmic Workflows and Batch Jobs for successful completion and restarted them if they failed.
• Tuned the Informatica ETL processes for optimum performance by integrating ETL processes based on common sources and optimizing the source SQL to use the correct indexes.
• Designed and developed the Informatica Workflows for Daily, Weekly, Monthly and Initial Loads.
• Provided data to the reporting team for their daily, weekly and monthly reports.

Environment: Informatica Power Center 8.6, Flat files, Oracle 10g/9i RAC, Putty, Windows XP professional, Erwin 4.0, Toad, Tivoli, Unix scripting, Win SCP

Confidential, Richmond, VA

Sr. Informatica/DW Developer

• Established Informatica platform at client location.
• Worked with business analysts for requirement gathering, business analysis, and testing and project- coordination.
• Prepared technical specifications to develop Informatica ETL mappings to load data into various tables confirming to the business rules.
• Developed complex mappings with transformations like lookup, router, aggregator, expression and joiner confirming to the business rules.
• Performance tuning of mappings, transformations and sessions to optimize session performance.
• Created session tasks (session, command etc.) and managed database connections and scheduled workflows.
• Designed high performance mappings by using iterative variable logic in Expression Transformation.
• Used DT Studio component "parser" to load HL7 formats.
• Good knowledge about DT Studio components like Mapper, Serilazer and Splitter.
• Used Unstructured Date Transformation to integrate DT Studio components with Informatica
• Used SQL*Loader for loading the stage tables.
• Created SQL scripts for views, synonyms
• Performed unit and integrated testing.
• Prepared documentation for business data flow from source to mart.
• Move the mappings and scripts between various environments like the Development, QA and production.
• Creating /Modifying Batch scripts.
• Attend to day today maintains of the loading process.

Environment: Informatica Power Center 7.1/6.2, Flat files, Oracle 9i/8i, Control M, DB2, UNIX (SunOS 5.8), PL/SQL, SQL * Loader, MS SQL Server 2000, SQL Navigator, Windows NT 4.0 Erwin 4.0, Micro Strategy 8.0.2, Mainframes, Toad 8.6, Tera Term Pro, Win SCP

Confidential,Chicago, IL

Sr. Informatica/DW Developer

• Understand the Confidential business requirements and data model for SRE, PNL, M & R and ESTR applications.
• Support activities for SRE, PNL, M & R and ESTR applications like monitoring daily loads, Defect fixes, Schedule new jobs and application checkouts.
• Gathering new business requirements, Solution for new requirements, Participate design and development phases of Confidential applications.
• Co-ordinate testing activities for new BNR’s (Business New requirements), Unit Testing and Regression testing.
• Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and filter Data cleansing, Validations, data transformations and calculations in mappings.
• Executes performance tuning of initial and incremental loads.
• Scheduling mappings for automation by using Control-m.
• Scheduling, running and monitoring mappings.
• Document HLD, LLD, ETL Design and test results.
• Providing estimates for new BNR’s and CR’s and Provide on-going directions to the team
• Creating /Modifying UNIX scripts.
• Monthly Presentation to Business

Environment: Informatica PowerCenter 7.3, Power Exchange V 5.2, Flat files, Oracle 9i, UNIX (IBM / AIX), Windows NT, Erwin 4.0, SQL Developer 2000, PL/SQL, Business Objects 6.5, Mainframes, Toad, Unix scripting

Confidential, Harrisburg, PA

Programmer Analyst

• Understand the existing business system, business exchanges information and Dimensional Data Model of the eCIS.
• Prepare the conversion document plans, synchronization documents plans and design appropriate mappings for conversion and synchronization.
• Test synchronization mappings and compare results with SAP outcome results to verify both results are in sync.
• Schedule mappings using OPCONS scheduler.
• Error Out invalid data and analyze the root cause for errors.
• Maintain Envelope tables to identify the data loads.
• Written DOS scripts to Copy/ Delete the flat files in appropriate folders and initiate scripts from Informatica sessions.
• Data cleansing, Validations, data transformations and calculations in Data flows/ Work flows.
• Created complex Data Flows to load the data mart and monitored them.

Environment: Informatica PowerMart /Power Center 7.2, ETL, Business Objects 5.0, Oracle 9i, DB2 (UDB), Autosys, Teradata V2R5/V2R4, UNIX Shell Scripting, ERWIN 3.5.2, Windows NT 4.0