SUMMARY

• Over 6+ years of experience in IT industry with expertise in Analysis, Design, Development, Implementation, Modeling, Testing, and Support for Data Warehouse applications
• Expertise in working with Informatica Power Center 9.1.0/9.0.1/8.6/7.1 (Designer, Repository manager, Repository Server Administrator console, Server Manager, Work flow manager, workflow monitor)
• Well acquainted with Informatica Designer Tools like Source Analyzer, Transformation Developer, Mapping Designer, Mapplet Designer, Schedulers and Warehouse Designer
• Well versed with Relational and Dimensional Modeling techniques like Star Schema, OLAP, Fact and Dimensional Tables
• Expert - level mastery in designing and developing complex Mappings using transformations like Source qualifier, Aggregator, Expression, Connected &Unconnected lookup, Filter, Joiner, Sequence generator, Sorter, Router, Normalizer and Update Strategy
• Experience with high volume datasets from various sources like Oracle, Flat files, SQL Server and Xml
• Expertise in Tuning the DW environment including Oracle SQL query tuning, Database tuning and in Informatica Power center to identify bottlenecks, tune and remove bottlenecks
• Used Debugger to test the data flow and Optimized the Solution by using the performance tuning methods in the Oracle SQL queries like Indexing techniques, Hints, Partitioning and Parallel execution process
• SCD Management including Type 1, 2, De-normalization, Cleansing, Conversion, Aggregation, and Performance Optimization
• Design Source to Target maps, Code Migration, Version control, scheduling tools, Auditing, shared folders, data movement, naming in accordance with ETL Best Practices, Standards and Procedures
• Thorough knowledge of the Data Warehouse Development Life Cycle. Performed all dimensions of development including Extraction, Transformation, and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Power Center
• Hands on experience in writing, testing and implementation of the triggers, stored procedures, functions, packages at database level and form level using SQL, PL/SQL, SQL PLUS
• Involved in the Migration process from Development, Test and Production Environments
• Extensive database experience using Oracle 11g/10g/9i, MS SQL Server 2008/2005, MySQL, SQL, PL/SQL, SQL*Plus
• Excellent communication, analytical and interpersonal skills
• Quick learner and adaptive to new and challenging technological environments
• Highly motivated to take independent responsibility as well as ability to contribute and be a productive team member

TECHNICAL EXPERTISE

Data Warehousing/ETL: Informatica Power Center 9.0.1/8.6/8.1/7.1, Informatica Power Exchange 8.x

Data Modeling: Dimensional Data Modeling, Star Join Schema Modeling, Snowflake Modeling, FACT and Dimension Tables, Physical and Logical Data Modeling, Erwin 7.1.3, MS-Visio

Databases: Oracle 11g/10g/9i, MS SQL Server 7.0/2008/2005, My SQL, DB2, MS-Access

Programming: SQL, PL/SQL, SQL Plus, MS SQL, UNIX Shell Scripting

Environment: Win 2000, Win XP, UNIX, Sun Solaris

Other tools & Utilities: SQL*Plus, Business Objects 6.5, Teradata, SQL Navigator, Toad, SQL tools, Autosys, Quest, MS-Office

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Sr. Informatica Developer

Responsibilities:

• Complete understanding of Data in various sources, so as to support Business Intelligence (BI) Team
• in creating SDLC
• Supported BI team to create Logical and Physical Data Models for Data Warehousing
• Created Incremental Iterative ETL releases using an Agile Process
• Supported and Createed Source to Target Documentations, along with Business Analysts
• Supported and Fixed ETL bugs, Reporting bugs identified by QA Team using Agile Methodology
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in
• back-end testing and worked with data quality issues
• Performed all aspects of Verification, Validation including Functional, Structural, Regression, Load
• and System Testing
• Createed ETL Codes based on Source to Target Documentations, so as to serve the need of EDW
• Data to create various reports and dashboards using Microstrategy
• Created ETL code to support data flow from Source to Staging and Staging to EDW, so as to standardize ETL coding for various SDLC
• Created ETL code with various Incremental Logics (Slowly Changing Dimensions - 1, 2) based on requirements
• Created Stored Procedures, Cursors and Triggers, to load, test and validate data in EDW Database
• Verified the data load in critical and non-critical columns based on the ETL updates or inserts
• Created various Parameters in Informatica Server, to support connections for Source, Target and Look Up Tables
• Wrote several command tasks scripts using UNIX Korn shell for file transfers and cleanup process
• Tuned ETL Codes/scripts, SQL queries to improve the system performance
• Created or Dropped Indexes to improve the Load Performance
• Migrated ETL Codes from Development Environment to Test Environment and Deploy ETL codes to Production Environment after QA (ETL TESTING)
• Scheduled and Monitored Workflows in Production Environment under various circumstances and create event wait and event raise tasks as per the need
• Supported ETL Testing (QA Team) in writing various Test Cases and validate data in Test Environment
• Supported and Fixed ETL bugs, Reporting bugs identified by QA Team using Agile Methodology
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues
• Performed all aspects of Verification, Validation including Functional, Structural, Regression, Load and System Testing
• Identified bottlenecks through performance Testing and Applied SQL performance tuning techniques extensively, working with DBA’s to resolveperformance and tuning issues
• Attended Daily status meetings with the BI Team and updated the status of the Project under Agile Methodology
• Attended BI-Weekly meeting to Update, Plan iterations with the BI Team
• Extensively used Version 1 software (Agile Methodology software), to update, track the task that is being worked on and to plan Back logs for future projects or enhancements
• Used Longview Khalix, People Soft, VM Ware and many other software as Source while creating ETL codes to load data into DFW EDW

Environment:Oracle 11g, INFORMATICA 9.0.1,XML,FlatFiles,SQL DEVELOPERSQL*Plus, Windows, UNIX, HP Quality Center, Longview Khalix, People Soft, VM Ware, DAC

Confidential, Pittsburg, PA

Sr. Informatica Developer

Responsibilities:

• Participated in data modeling (logical and physical) for designing the Data Marts for finance, Sales, Billing
• Developed standards and procedures for transformation of data as it moves from source systems to the data warehouse
• Created Technical design specification documents based on the functional design documents and the physical data model
• Developed mappings to extract data from Oracle, Flat files, XML files and load into Data warehouse using the Mapping Designer
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Warehouse
• Involved in versioning the whole process and retiring the old records using the built-in's DD UPDATE, DD DELETE, and DD INSERT
• Worked on Informatica Power Center 8.6 tool - Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager, Mapplets, and Reusable Transformations
• Optimized Query Performance, Session Performance and Reliability
• Extensively used Normalizer (for COBOL source files ), Router, Lookup, Aggregator, Expression and Update Strategy Transformations
• Translation of Business processes into Informatica mappings for building Data marts
• Involved in the Migration process from Development, Test and Production Environments
• Used SQL tools like TOAD to run SQL queries and validate the data
• Wrote stored procedures and triggers in Oracle 10g for managing consistency and referential integrity across data mart
• Debugging invalid mappings using break points, testing of stored procedures and functions, testing of Informatica sessions, batches and the target Data
• Developed shell scripts, PL/SQL procedures, for creating/dropping of table and indexes of performance for pre and post session management
• Implemented various Performance Tuning Techniques on Sources, Targets, Mappings, and Workflows
• Identified bottlenecks in sources, targets, mappings and sessions and tuned them to improve performance
• Tuning the Mappings for Optimum Performance, Dependencies and Batch Design
• Scheduled the batches to be run using the Workflow Manager

Environment: Informatica Power Center 9.0.1/8.6, DB2, Oracle 10g, SQL, PL/SQL, SQL SERVER 2008, T-SQL,SQL Navigator, Mercury Quality Center

Confidential, Brookfield, WI

Sr. Informatica Developer

Responsibilities:

• Involved in full life cycle development including Design, ETL Strategy, Troubleshooting, Reporting, and Identifying facts and dimensions
• Prepared the required application design documents based on functionality required
• Designed the ETL processes using Informatica to load data from Oracle, Flat Files (Fixed Width), and Excel files to staging database and from staging to the target database
• Implemented the best practices for the creation of mappings, sessions and workflows and performance optimization
• Created mappings using transformations like Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator
• Designed and developed the logic for handling slowly changing dimension table, loaded data by flagging the record using update strategy for populating the desired
• Involved in cleansing and extraction of data and defined quality process for the warehouse
• Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volume of data
• Documented ETL test procedures, assumptions, and validations based on design specifications for unit testing, system testing, expected results, preparing test data and loading for testing, error handling and analysis
• Used Debugger in troubleshooting the existing mappings
• Developed shell scripts, PL/SQL procedures, for creating/dropping of table and indexes of performance for pre and post session management
• Used DTS package to import and export data to from the database
• Involved in various testing activities like database testing, unit testing, system testing, performance testing and was also responsible for maintaining of testing metrics, defect tracking
• Involved in migration of mappings and sessions from development repository to test repository and tan to production repository
• Involved in Unit testing, User Acceptance Testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
• Created Stored Procedures to transform the Data and worked extensively in PL/SQL for various needs of the transformations while loading the data.

Environment: Informatica Power Center 8.6, Oracle 10g, DB2, TOAD, Erwin 4.5, SQL, PL/SQL, SQL*Plus, XML, Windows XP, UNIX, Toad, Autosys

Confidential, Des Moines, IA

Informatica Developer

Responsibilities:

• Involved in designing the process for getting the data from all systems to Data Warehousing systems.
• Extensively Designed, Developed, Tested complex Informatica mappings, mapplets and Reusable Transformations to load data from various sources
• Extensively used all the transformations like source qualifier, aggregator, filter, joiner, Sorter, Lookup, Update Strategy, Router, Sequence Generator etc. and used transformation language likes transformation expression, constants, system variables, data format strings
• Created Informatica mappings with PL/SQL procedures/functions to build business rules to load data.
• Extensively used PL/SQL programming in backend and front-end functions, procedures, packages to implement business rules
• Designed and developed complex mappings using Mapping Designer to load data from various sources, using different transformations like Source Qualifier, Expression, Lookup (Connected and Unconnected), Aggregator, Update Strategy, Joiner, Filter and Router transformations
• Extensively created mapplets for reusable business rules
• Used the update strategy to effectively migrate data from source to target
• Involved in Data Quality Assurance, created validation routines, unit test cases and test plan
• Created tasks, workflows and worklets using workflow manager
• Used Workflow monitor to monitor workflows
• Involved in identifying bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing bugs so that they conform to the business needs
• Performed Unit Testing and validated the data

Environment: Informatica Power Center 8.1.1/7.1.1, Power Connect, SAP R/3, Business Objects 5.1.3, Oracle 8i, PL/SQL, SQL*Plus, SQL Server, MS Access, XML files, UNIX Shell Scripting, Windows NT/2000.

Confidential, Philadelphia, PA

Informatica Developer

Responsibilities:

• Extracted data from various heterogeneous sources like Oracle, SQL Server, Sybase, MS Access and Flat files
• Worked with power center tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager
• Worked on Designer tools like Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer and Mapping Designer
• Extensively used Informatica Transformation like Source Qualifier, Rank, Router, Filter, Lookup, Joiner, Aggregator, Normalizer, Sorter and all transformation properties
• Solid Expertise in using both connected and unconnected Lookup Transformations
• Extensively worked with various Lookup caches like Static cache, Dynamic cache and Persistent cache
• Extensively worked with Joiner functions like normal join, full outer join, master outer join and detail outer join in the Joiner transformation
• Worked with Session logs and Work flow logs for Error handling and troubleshooting in Dev environment
• Used Debugger wizard to troubleshoot data and error conditions
• Responsible for Best Practices like naming conventions, and Performance Tuning
• Extensively used Various Data Cleansing and Data Conversion Functions in various transformation
• Responsible for migrating the code using deployment groups across various Instances
• Responsible for Unit Testing of Mappings and Workflows
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD
• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter Files
• Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning

Environment: Informatica Power Center 8.1.1, Toad 9.7, Erwin 4.2,Oracle 10g, SQL server, Access, Flat files, SQL/PLSQL, UNIX shell scripting, Windows XP

Confidential, Houston, TX

Informatica Developer

Responsibilities:

• Worked with various active transformations in Informatica Power Center like Filter Transformation, Aggregator Transformation, Joiner Transformation, Rank Transformation, Router Transformation, Sorter Transformation, Source Qualifier, and Update Strategy Transformation
• Extensively worked with various Passive transformations in Informatica PowerCenter like Expression Transformation, and Sequence Generator.
• Extensively worked with Slowly Changing Dimensions Type1, Type2, and Type3 for Data Loads
• Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level, and the Target Level
• Extensively worked with Source Qualifier Transformation to join the homogeneous sources
• Extensively worked with Joiner Transformation to join the heterogeneous sources
• Responsible for the Data Cleansing of Source Data using LTRIM and RTRIM operations of the Expression Transformation
• Extensively worked with both Connected and Un-Connected Lookups
• Extensively worked with Look up Caches like Shared Cache, Persistent Cache, Static Cache, and Dynamic Cache to improve the performance of the lookup transformations
• Worked with re usable objects like Re-Usable Transformation and Mapplets
• Extensively worked with aggregate functions like Avg, Min, Max, First, Last in the Aggregator Transformation
• Extensively used SQL Override function in Source Qualifier Transformation
• Extensively used Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in the Joiner Transformation
• Responsible for migrate the workflows from development to production environment
• Extensively worked with Incremental Loading using Parameter Files, Mapping Variables, and Mapping Parameters
• Responsible for Performance in Informatica PowerCenter at the Target Level, Source level, Mapping Level, Session Level, and System Level

Environment: Informatica PowerCenter 8.1.1/7.1.3, Toad 7.2, Teradata, Oracle 9i, Flat Files, UNIX, Windows XP

Confidential, Pittsburgh, PA

Informatica Developer

Responsibilities:

• Helped the ETL testing team for effective testing of transformed data and defining the test procedures.
• Performed ETL performance tuning with modifying Index and Data Cache size, DTM Buffer size, Pipeline Partitioning, defining additional partition points and modifying partition types.
• Developed Oracle 9i Stored Procedures, Database Triggers and Functions and Packages.
• Designed and developed UNIX shell scripts as part of the ETL process to compare control totals, automate the process of loading, pulling and pushing data from & to different servers.
• Wrote documents for ETL mapping design, error log design, and data load strategy, unit and system testing, system migration and job schedules.
• Resolved data and process support Issues
• Defined and deployed QC process to halp the Business Team to cleanse the source data
• Experienced in using lookup transformations, including the use and configuration of different types of cache like Static, Dynamic and Persistent.
• Developed re-usable transformations, mappings and mapplets confirming to the Business rules.
• Used Debugger to test the mappings and fix the bug.

Environment: Informatica Power Center 8.1.1, Oracle 9i, SQL Server 2005, Toad 9.2, SQL, PL/SQL, Cognos 8, Windows XP, HP Unix, MS Excel, Tivoli.

Confidential

Jr. IT Consultant

Responsibilities:

• Provided advice and support to all users including printing, software and hardware related issues and assisted with the implementation of new systems
• Involved in installation, maintenance, update and support of all applications, systems and communications software
• Involved in the process design documentation of the Data Warehouse Dimensional Upgrades
• Extensively used database for loading the historical data from various sources for different departments like grants and aids, monthly levy from executive committee, membership fees and sale of publication
• Involved in gathering business requirements, logical modeling, physical database design, data sourcing, data transformation and data loading
• Created Stored Procedures to transform the Data and worked extensively in PL/SQL for various needs of the transformations while loading the data
• Created indexes, sequences and constraints
• Utilized SQL*Plus for SQL coding of DDL statements for creation of the required database objects and DML queries for data retrieval
• SQL and performance tuning

Environment: Oracle 9i, SQL, PL/SQL, Windows 98