SUMMARY

• 7 years of IT experience in analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehousing/Data mart design, ETL, OLAP client /server applications
• Experience in using Informatica Client tools: Power Center Designer, Workflow Manager, Workflow Monitor, Repository Manager
• Experienced with all phases of Software Development Life Cycle (SDLC) such as developing, testing, migrating, administrating, and production supporting on various platforms like UNIX, Window XP/7.
• Experience in gathering, analyzing and documenting business requirements, functional requirements, designing and developing the mapping based on the requirements.
• Experienced in implementing the business rules by creating transformations (Expression, Aggregate, Unconnected and Connected Lookup, Router, Update Strategy, Filter, Joiner, Union), and developing Mappings.
• Strong knowledge on Data warehousing concept, Data mart, Star Schema and Snow Flake Schema modeling, Fact tables and Dimensional tables.
• Implemented Slowly Changing Dimension methodology for accessing the full history of accounts and transaction information.
• Experience in the concepts of building Fact Tables, Dimensional Tables, handling Slowly Changing Dimensions and Surrogate Keys.
• Experience in Migration of objects between environments, from Local (DEV) to Test (QA)
• Experience in writing complex SQL queries, simple stored procedures and Unix Shell Scripting.
• Good experience in developing complex reports using Crystal Reports from different Data Sources.
• Excellent experience in Performance tuning in Informatica Power Center and query optimization.
• Strong knowledge on Relation databases like Oracle 9i/10g/11g, SQL SERVER, TERADATA on different platforms like Windows/Unix Linux using GUI tools like TOAD, SQL DEVELOPER, SQL PLUS, SQL*PLUS, MICROSOFT VISUAL
• Experience in OLAP tools such as Business Objects, Crystal Reports (Designer and Reporter).
• Analytical and Technical aptitude with the ability to solve complex problems; Can work very well in a team as well as independently under minimum supervision.
• Strong interpersonal skills with ability to interact with end - users, managers and technical personnel.
• Trained and assisted End Users in developing Ad Hoc reports.
• Involved in Unit Testing, Integration testing and QA Validation

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 9.x/8.x, Informatica Power Exchange 9.1

Reporting Tools: Crystal Reports XI-R2/2008, Business Objects XI-R3

Programming Language: C, SQL, PL/SQL, UNIX Shell Scripting

RDBMS: SQL Server 2008/2005, Oracle 11g/10g/9i, MS-Access 2003/2007/2010 and Teradata

Operating Systems: WINDOWS 7/Vista/XP/2003/2000/NT/98/95, MS-DOS, Unix/Linux

Office Applications: Microsoft Word, Excel, Outlook, Access, Visio, Project, Power Point ( 2003/2007/2010 )

Clients: TOAD, Visual Basic5.x/6.0, SQL DEVELOPER, SQL PLUS, SQL * PLUS, SQL LOADER,ALTERIS, Putty, Winscp

PROFESSIONAL EXPERIENCE

Confidential, NASHVILLE - TN

Sr. ETL Developer

Responsibilities:

• Involved in interacting with Business Analyst in analyzing the requirements
• Involved in documenting the Technical and Functional Documents like High Level Design, Low Level Design and System Specification Document.
• Developed ETL mappings, Transformations and Loading using Informatica Power Center 8.6.2/9.1
• Extensively worked on Informatica Designer components Source Analyzer, Target Designer, Transformation Developer, Mapping Designer and Mapplet Designer.
• Developed various mappings to load data from various sources using different Transformations including Router, Aggregator, Joiner, Lookup, Update Strategy, Stored Procedure, Sorter, Filter, Source Qualifier, Expression, Union and Sequence Generator to store the data in target tables.
• Developed mapping based on the mapping specification document that indicates the source tables, columns, data types, transformation required, business rules, target tables, target columns and data types.
• Involved in Unit Testing, Integration Testing and End-End Testing
• Captured the Unit Test Results and documented the test results
• Used workflow manager to create workflows, sessions, and also used various tasks like command, email.
• Created Workflows, Worklets and Tasks to schedule the loads at required frequency using Workflow Manager.
• Scheduled the jobs automatically using Autosys tool.
• Developed Stored Procedures and modified some of the procedures based on the requirement
• Modified existing Unix Shell Scripts as per the requirements.
• Defined Target Load Order Plan for loading data into different Target Tables.
• Involved in database level optimization by creating Indexes, Hints and Query Optimization.
• Involved in fixing the defects that are issued by the testing team in JIRA and then Unit Tested the defects once fixed.
• Used debugger extensively to identify the bottlenecks in the mappings.
• Extensively worked with various Lookup caches like Static cache, Dynamic cache and Persistent cache.
• Worked on performance tuning and optimization of the Sessions, Mappings, Sources and Targets.
• Used Informatica Power Center 9.1 for mapping and workflow design including the use of mapplets, reusable transformations and worklets.
• Developed mapping using different source systems like Database, Flat Files
• Migrated Objects, mappings, workflows from Dev environment to QA environment.
• Created Informatica supported source definition for IMS log files using cobalt copy book in Informatica Power Exchange tool.
• Replicated operational tables into staging tables, to transform and load data into one single database using Informatica.

Environment: Informatica PowerCenter 9.1/8.6 (Repository Manager, PowerCenter Designer, Workflow Manager, Workflow Monitor), Oracle 10g, Unix, Window 7/XP, JIRA, AUTOSYS, SQL Developer 3.0, TOAD 9.7, Flat Files, SQL, PL/SQL, Informatica Power Exchanger, IMS logfiles, Microsoft tools, Putty, Winscp

Confidential - PALO Alto, CA

Sr. Informatica Developer

Responsibilities:

• Involved in interacting with Business Analyst/Users in gathering the requirements
• Extensively used Informatica Client tools - PowerCenter Designer, Workflow Manager, Workflow Monitor and Repository Manager
• Extracted data from various heterogeneous sources like Oracle, SQL Server, Flat Files, Teradata
• Developed complex mapping using Informatica PowerCenter tool.
• Extracting data from Oracle and Flat file, Excel files and performed complex joiner, Expression, Aggregate, Lookup, Stored procedure, Filter, Router transformations and Update strategy transformations to extract and load data into the target systems.
• Created Sessions, Tasks, Workflows and worklets using Workflow manager.
• Worked with Data modeler in developing STAR Schemas
• Involved in performance tuning and query optimization.
• Used TOAD, SQL Developer to develop and debug procedures and packages.
• Involved in developing the Deployment groups for deploying the code between various environment (Dev, QA)
• Created pre sql and post sql scripts which need to be run at Informatica level.
• Worked extensively with session parameters, Mapping Parameters, Mapping Variables and Parameter files for Incremental Loading
• Used Debugger to fix the defects/ errors and data issues.
• Expertise in using both connected and unconnected Lookup Transformations.
• Extensively worked with various Lookup caches like Static cache, Dynamic cache and Persistent cache.
• Created Reusable Transformations, Worklets, and made use of the Shared Folder Concept using shortcuts wherever possible to avoid redundancy.
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD
• Monitored and improved query performance by creating views, indexes, hints and sub queries
• Extensively involved in enhancing and managing Unix Shell Scripts.
• Executed the workflows using Unix Shell scripts.
• Developed workflow dependency in Informatica using Event Wait Task, Command Wait.

Environment: Informatica PowerCenter 8.6, Oracle 10g, SQL Server 2008, MS Access 2010, SQL*Loader, Unix, Winscp, Putty, Erwin, SQL, PL/SQL

Confidential - MADISON, WA

Informatica Developer

Responsibilities:

• Worked closely with the business analyst and Data warehouse architect to understand the source data and need of the Warehouse.
• Involved in designing of star schema based data model with dimensions and facts.
• Created mappings with heterogeneous sources like flat files, MS Access, Oracle databases and created targets in Oracle data warehouse using Informatica PowerCenter 8.6.2.
• Created Source to Target mapping from design and requirement documents.
• Built reusable transformations for recurring business logics using mapplets and used them in multiple mappings.
• Designed and developed mappings using Source qualifier, Aggregator, Joiner, Lookup, Router, Sequence generator, Expression, Filter and Rank transformations.
• Designed and developed test cases for unit and system testing.
• Developed Unix Shell Scripts for executing the Informatica workflows.
• Created aglobal schema with common source and target tableto be used across different data marts and implemented shortcuts to the objects within each mart folder so that it is easy to maintain and control the changes to the source and targets.
• Created parameters and variables for incremental data loading effectively using Informatica workflow manager.
• Created ETL job flow design.
• Created event raise, event-wait tasks for maintaining dependencies between workflows.
• Worked on Informatica SQL overrides in Source Qualifier, look up cache, pipeline partitions to improve ETL performance.
• Efficiently interacted with UAT team and supported system testing and fixed bugs in mappings during QA phase.
• Optimized or tuned mapping/ sessions during load testing in QA environment.
• Designed, developed, and tested various enhancements.

Environment: Informatica Power Center 7.1, Oracle 9i, Autosys 4.5, XML, SQL Plus, PL/SQL, SQL, Shell Scripts

Confidential - CHARLOTTE, NC

Data warehouse Developer

Responsibilities:

• Involved in Dimensional modeling of the Data warehouse and used Erwin to design the business process, grain, dimensions and measured facts.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Developed number of complex Informatica mappings, mapplets, and reusable transformations to implement the business logic and to load the data incrementally.
• Worked on performance tuning of SQL and mappings by usage of SQL Overrides in Lookups, Source filter in Source Qualifier and data flow management into multiple targets using Router transformations.
• As per the requirement of the business users to manage change data capture, implemented slowly Changing Dimensions type I and type II.
• Worked with Persistent Caches for Conformed Dimensions for the better performance and faster data load to the data warehouse.
• Used Debugger by making use of Breakpoints to monitor data movement, identified and fixed the bugs.
• Used PowerCenter Workflow manager for session management, database connection management and scheduling of jobs to be run.
• Troubleshoot workflows and sessions for daily and monthly extracts from various data sources across all platforms to the target database.
• Developed Static and Dynamic Parameter Files for reusability and database connection management among Development/Testing/Production environments.
• Created List, Crosstab, Chart type reports for the sales data using Cognos7.3
• Wrote various shell scripts for pre-processing of data and scheduling of jobs.
• Worked on Test Director for Unit and Integration testing.

Environment: Informatica Power Center 7.1.1, Erwin 7.2, Oracle 9i, SQL Server 2005, SQL*Loader, SQL, TOAD, UNIX, Autosys, Test Director 7.2, MS Office.

Confidential, DEARBORN, MI

Jr ETL Developer

Responsibilities:

• Designed, developed and documented multiple interfaces using the Informatica Power Center.
• Developed many complex mappings and mapplets using various transformations (Source Qualifier, Joiner, Update Strategy, Lookup, Rank, Expressions, and Aggregator) for loading the data into Data Warehouse.
• Optimal utilization of object-reusability features like reusable transformations, mapplets, copying objects from other repositories, using variable/parameters for simplifying complex mappings.
• Involved in designing the procedures for getting the data from all systems to Data Warehousing system. The data was standardized to store various Business Units information in tables.
• Created and used Reusable Transformations to improve maintainability of the Mappings.
• Created various Reusable and Non-Reusable tasks like Session and other tasks like Decision and email tasks.
• Performed data manipulations using various Informatica Transformations like Joiner, Expression, Lookup, Aggregate, Filter, and Update Strategy.
• Responsible for monitoring sessions that are running, scheduled, completed and failed.
• Used Informatica Server Manager to create, schedule, monitor sessions and send pre and post session emails to communicate success or failure of session execution.

Environment: Informatica 5.x/6.x, Oracle 8i, MS-Access, Windows NT.

Confidential

Oracle - SQL Developer

Responsibilities:

• Involved in Software Development Life cycle starting from requirements gathering and performed object oriented analysis and design to implementation & maintenance.
• Involved in designing the database schema and ER diagram depicting relationships between various tables in the database.
• Designed the relationship between the data to enforce business logic as a part of Data Modeling.
• Used the SQL tables and records in transaction processing in the backend.
• Created the database trigger for the complex data validations and for security.
• Wrote PL/SQL procedures and triggers to carry out database maintenance tasks
• Developed Oracle database triggers, stored procedures and PL/SQL scripts per system requirements
• Created and used views for different business needs.
• Worked with Sub-queries/Correlated Sub-Queries in Different areas of the database.
• Extensively Used JOINS writing views in the Database.
• Created and used different type of Indexes.
• Created and used Sequences.
• Worked with Oracle Optimizer and Explain Plan for better performance of queries.
• Involved in Performance Tuning and Query Rewrite.

Environment: Oracle 8i, SQL, PL/SQL, SQL*Plus and SQL*Loader.