SUMMARY

• Extensive experience in IT industry in ETL Data Warehouse and Business Intelligence Tools.
• Over 8 years of professional experience in Data Warehouse, Relational Database and System Integration. Proficiency in gathering and analyzing user requirements and translating them into business solutions.
• Help Desk Support Level 2 Data Warehouse
• Expertise in development and design of ETL (Extract, Transform and Loading data) methodology for supporting data transformations and processing ETL Solutions using Informatica Power Center (9.x/8.x/7.x). provide technical support for computer systems to individuals or corporations. In order to assist customers, help desk professionals must possess both technical knowledge required for troubleshooting and customer service
• Extensively worked on Informatica Designer Components - Source Analyzer, Target Designer, Transformations Developer, Mapplet and Mapping Designer.
• Strong Experience on Workflow Manager Tools - Task Developer, Workflow and Worklet Designer.
• Experience in designing and developing complex mappings from varied transformation logic like Connected and Unconnected look ups.
• Involved in Data Analysis for source and target systems and good understanding of Data Warehouse concepts, Staging Tables, Dimensions, Facts and Start, Snowflake Schemas.
• Expertise in performing tuning of Informatica mappings.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, DTS and SSIS services.
• Experience in working with Data Warehousing Concepts like Ralph Kimball Methodology, Bill Inmon Methodology, OLAP, OLTP, Star Schema, Snow Flake Schema, Fact Table, Dimension Table, Logical Data Modeling, Physical Modeling and Dimension Data Modeling.
• Installation and configuration of Informatica Server and Informatica Repository in Windows - UNIX Operating Systems.
• Experience in Integration of various data sources like Oracle, SQL Server, Teradata and Flat file into staging area.
• Experience in writing database scripts such as SQL queries, PL/SQL Stored Procedures, Indexes, Functions, Views and Triggers.
• Proficient in using pmcmd and pmrep commands.
• Used Teradata Utilities like fast load, multi load and fast export.
• Performed data validation by Unit testing, Integration testing and System testing.
• Experiences in managing teams/On shore-Off Shore Coordination/Requirement Analysis/Code Reviews/Implementing standards.
• Excellent Analytical, Interpersonal and Communication Skills. Effective team player with great ability to grasp newer technologies. Self-starter and result oriented team player with an ability to manage multiple tasks simultaneously.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center/Power Mart 9.x/8.x/7.x, Power exchange, SSIS, Data Exchange.

BI Tools: Cognos, Business Objects XI R3/R2/R1, SSRS, SSAS, Crystal Reports and OBIEE 11g.

Tools: SQL*Plus, SQL*Loader, TOAD, Eclipse, CISCO, VM Ware, Visual Studio, HP Quality Center, ALM and Rational Clear Quest.

Scheduling Tools: Autosys.

Data Bases: Oracle 11g/10g/9i/8i, MS SQL Server 7.0/2005/2008 , DB2 and Teradata V2R6.

Data Modelling: Star/Snow Flake Shema Modelling and ER Studio.

Packages: MS Office (Word, Excel, Access and PowerPoint).

Environment: UNIX, MVS, HP-UX, IBM AIX, Sun-Ultra, Sun-Spark, Sun Classic and SCO.

PROFESSIONAL EXPERIENCE

ETL Developer

Confidential, Tampa, FL

Responsibilities:

• Involved in requirement analysis, ETL design and development for extracting data from the source systems like Oracle, flat files, XML files and loading into EDW (Enterprise Data Warehouse).
• Responsible for design and implementation needed for loading and updating the warehouse.
• Worked with analysts and data source systems experts to map requirements to ETL code.
• Developed complex mapping logic using various transformations like Expression, Lookups (Connected and Unconnected), Joiner, Filter, Sorter, Router, Update strategy and Sequence generator.
• Converted functional specifications into technical specifications (design of mapping documents).
• Worked on developing UNIX Scripts for job automations.
• Used Autosys, CRON to schedule jobs.
• Created deployment groups to deploy objects.
• Worked with Session logs and Work flow logs for Error handling and troubleshooting in Dev environment.
• Efficiently used Informatica Workflow Manager, Workflow monitor to create, schedule and control Workflows, Tasks, and Sessions.
• Created scripts for better handling of incoming source files such as moving files from one directory to another directory and extracting information from file names, such as date, for continuously incoming sources.
• Efficiently worked data modeling, data mappings and data integration.
• Performance tuning, maintain and fix production issues of existing code. Modify existing code as per the new business requirements.
• Wrote complex SQL scripts to avoid Informatica joiners and Look-ups.
• Coordinated with DBA's in resolving the database issues that lead to production job failures.
• Used Debugger to test the mappings and fixed the bugs.
• Fixed the Issues that come out of Integration Testing.
• Migrated code/objects from the development environment to the QA/testing environment to facilitate the testing of all objects developed and check their consistency end to end on the new environment.
• Involved extensively in Unit testing, integration testing, system testing and UAT.

Environment: Informatica Power Center 9.5, Informatica Power Connect SAP R/3, OBIEE 11g, Oracle 11g, SQL server 2010, PL/SQL Procedures, TOAD, Perl scripts, Rational Clear case, Autosys, MKS Integrity Client, MS Visio, ALM, Mainframes, Unix, Putty.

ETL/Data warehouse Developer

Confidential, Washington DC

Responsibilities:

• Involved in integration of data sources like flat files, SQL server, DB2, Oracle for IP Science project to the Enterprise Data warehouse (EDW).
• Developed ETL Specifications, Mappings for ExIm Online (EOL) data source according to the Bank’s data warehousing coding guidelines.
• Worked with Shared holder/ application team for different project implementations and provided technical strategies, directions and mentored offshore developers.
• Extensively developed various mappings using different transformations like Source Qualifier, XML Generator, XML Parser, Expression, Connected Lookup, Un-connected Lookup, Update Strategy, Stored Procedure, Filter, Router, and Joiner.
• Developed, documented and executed unit test plans.
• Fine-tuned sources, targets, mappings, and sessions to improve the performance.

Environment: Informatica 9.1, Oracle 11g, SQL Server 2005, Linux, Business Objects 3.1, Toad10.1, WINSQL, Agile Scrum.

Informatica ETL Consultant

Confidential, Mclean, VA

Responsibilities:

• Involved in requirement gathering, Design, testing, project coordination and migration.
• Used most of the transformations such as the Aggregators, Filters, Routers, Sequence Generator Update Strategy, Rank, Expression, lookups (connected and unconnected), Mapping Parameters, Session parameters, Mapping Variables and Session Variables.
• Created mappings using transformations such as source qualifier, aggregator, expression, lookup, and router, filter and update strategy.
• Implemented Slowly Changing Dimensions (SCD) - Type I & II in different mappings as per the requirement.
• Scheduled and Run Extraction and Load process and monitor workflows using workflow monitor.
• Responsible for Creating workflows and worklets. Created Session, Event, Command, Control, Decision and Email tasks in Workflow Manager.
• Maintain the unit test cases and system testing on the mappings, sessions and finally observe the execution of workflows from the workflow monitor.
• Created requirement specifications documents, user interface guides, and functional specification documents, ETL technical specifications document and test case.
• Understanding the Business requirements, Source system and as part of understand the different logical models, and then get the knowledge of the Extract, Transformation, Loading specifications of the project.
• Used ETL to standardize data from various sources and load into data stage area, which was in oracle and stage to different Data Marts.
• Extensively used ETL to load data from various source like Oracle, flat files and SQL Server to Target warehouse Database on Oracle DB.
• Error log design, data load strategy, unit and system testing, system migration and job schedules.
• Fine-tuned ETL processes by considering mapping and session performance issues.

Environment: Informatica Power Center 8.x, SQL, PL/SQL, Teradata, Unix, Shell Scripting, HP Quality Center 10.

Informatica Developer/ Analyst

Confidential, San Diego, CA

Responsibilities:

• Worked with Informatica Power Center 9.1 - Mapping Designer for developing mappings consisting of wide range of transformations based on the business logic.
• Worked extensively on different types of transformations like normalizer, expression, union, filter, aggregator, update strategy, lookup, stored procedure, sequence generator and joiner.
• Worked on scheduling operations using Autosys.
• Worked on Performance tuning techniques to optimize the execution time of the Informatica workflows when converted to different environments.
• Worked extensively on pmcmd commands for processing workflows.
• Worked on different data sources such as Oracle, SQL Server 2008 and Flat Files.
• Worked with PL/SQL to rewrite stored procedures/ Functions as part of migration tasks.
• Analyzed the requirements and involved in preparing documents containing Functional and Technical Details of project.
• Developed various mappings and workflows which involved in building the fact and dimensional tables for Point-of-Sale data.
• Involved in Data Cleansing by developing various validation techniques during Data staging.
• Created different parameter files and changed Session parameters, mapping parameters and variables at run time.
• Developed UNIX shell scripts which were eventually used in workflows serving the purpose to build the Data mart.
• Responsible for creating business solutions for Incremental and full loads.
• Worked on PVCS Version Manager to deploy the necessary code and database archives to support distributed environment.
• Involved in Unit testing and developed Unit test documents.
• Involved in end-user training and providing the production system support.

Environment: Informatica Power Center 9.1, SQL Server 2008, Autosys, Business Objects, Windows NT, Unix, Toad 7.6, PVCS Version Manager.

Sr. ETL Developer

Confidential, Saint Paul, MN

Responsibilities:

• Involved in all phases of the project SDLC planning, design, construction.
• Involved in rewriting the whole ETL design for better performance and redundancy of data.
• Used Industry standard best practices for the company and streamlining the entire process for mapping development and test cases.
• Reviewing the code as per the Review Checklists and preparing the Release Documents for different environments.
• Worked with management in project origination & helped in creating some POC’s for testing the performance of the new servers and analyzed the source system for handling the physical deletes of the records.

Environment: Informatica 9.1, Oracle 11G, IBM AIX, Toad 9.0, Clear Quest, Cognos 8.4.

Sr. ETL Developer

Confidential, Saint Paul, MN

Responsibilities:

• Worked with offshore partners like Accenture and PWC for different project implementations and assigned them work on regular basis.
• Used Industry standard best practices for the company and streamlining the entire process for mapping development and test cases.
• Expertise in performance tuning by identifying bottlenecks at sources, targets, Power Center transformations and sessions using techniques such as Explain plans, Oracle hints and re-designing mappings. Collecting performance data for sessions and performance tuning by adjusting Informatica session parameters.
• Wrote PL/SQL and shell scripts as needed.
• Involved in the Conceptual, Logical and physical modeling of the project using Norma.
• Designing and developing the universe in BO over the Oracle 11g DWH.
• Preparing the build and migrating the code to QA and subsequently to PROD.
• Discuss the issues and projects status in status call on weekly basis.

Environment: Informatica 8.6, Oracle 11G, IBM AIX, Toad 10.0, Global Workflow, Business Objects XI R2 and SharePoint, Agile Scrum.

Sr. ETL Developer

Confidential, Saint Paul, MN

Responsibilities:

• Involved in all phases of the project planning, design, construction, and implementation.
• Involved in converting business requirements into technical specifications.
• Drilled out each of the data flows on a page to plan which tables to work on and for sequencing the transformations within each dataset.
• Setting up environments, installations and Hotfix patching.
• Extensively developed various Mappings using different Transformations like Source Qualifier, Expression, Lookup, Update Strategy, Aggregator, Normalizer, Stored Procedure, Filter, Router, and Joiner.
• Developed Pre-Session and Post-Session UNIX scripts to automate the data load processes to target data warehouse.
• Managed PVCS Tracker to resolve previously opened SCRs; opened new SCRs for any changes in Business Requirements and updated them until resolved.
• 24x7 production support on rotation basis among the team members.

Environment: Informatica 8.5, Oracle 10G, IBM AIX, Toad 9.0, PVCS Tracker, DAS, Microsoft.

Informatica Developer

Confidential

Responsibilities:

• Extensively involved in studying the business requirements and developed the mapping specifications from the business requirements and the data model.
• Developed Informatica Mappings and Sessions based on mapping specifications to load data from source flat files and RDBMS tables to target tables.
• The project source data (flat files, relational databases) is extracted from all the HCA operational systems and loaded into the data warehouse, which is the union of all the constituent pieces of the business.
• Distributed the data from Worktables to many stage tables using Informatica.
• Extensively developed various mappings using different transformations like Source Qualifier, Expression, Lookup, Update Strategy, Aggregator, Stored Procedure, Filter, Router, and Joiner.
• Worked the design and development of the data acquisition process for the data warehouse including the initial load and subsequent refreshes.
• Fine-tuned sources, targets, mappings, and sessions to improve the performance.
• Used Workflow Manager for creating, validating, testing, running sequential, concurrent sessions and scheduling them to run at specified time and as well as to read data from different sources and write it to target databases.
• Developed Pre-Session and Post-Session UNIX scripts to automate the data load processes to target data warehouse.
• Developed Fast Load and MultiLoad scripts to load data from various source systems to Teradata.
• Involved in extracting of data from Teradata, writing to flat files using BTEQ, and loading data into Teradata from flat files using Mloads.
• Provided Production Support for the workflows which run at different times in the day.
• Created shell scripts to automate existent manual processes in the daily production batch.
• Experience in creating the migration documents to migrate the Informatica, UNIX, and PL/SQL code using PVCS.
• Performed unit testing at development and QA Level, Source code migration, and documentation creation.
• Used NEXUS/ SQL Assistant to access the oracle/ Teradata database and for easy PL/SQL manipulations.
• Closely interacted with the reporting team, which uses Business Objects to explain the tables and relationships between the tables.

Environment: Informatica Power Center 8.1.1, Teradata V2R6, SQL Server 2005, PL/SQL, SQL*Plus, NEXUS, Unix Shell Scripting, Windows NT/2000, DB2, Business Objects XI R2, Microsoft Visual SourceSafe.

PL/SQL Developer

Confidential

Responsibilities:

• Initial system study and design.
• Normalized the database to remove data redundancy.
• Prepared Entity Relationship diagrams.
• Created database objects like tables, views, synonyms, indexes and sequences.
• Used SQL *Loader and Export, import utilities to load the data.
• Extensively used Database triggers, PL/SQL procedures, packages and functions while developing the scripts and reports.
• Calculated and monitored size and space for tables, clusters and indexes.
• Wrote procedures to replicate data from one table to another.
• Involved in generating SQL Reports.
• Debugging system application tuning by identifying long running reports.
• Developed/modified PL/SQL code like stored procedures, packages for interface.
• Involved in Unit testing, Integration testing and Load testing of the interface.
• Involved in documenting the modifications and intended functionalities of the interface.
• Helped in creating technical specifications by mapping the interface tables with the base tables.

Environment: Oracle 9i, PL/SQL, SQL*Plus, Windows2000/NT, SQL*Loader.