PROFESSIONAL SUMMARY:

• Extensive experience in IT industry in ETL Data Warehouse and Business Intelligence Tools.
• Over 9 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, halp desk professionals must possess both technical noledge 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. TEMPEffective 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.

WORK EXPERIENCE:

ETL/Informatica Developer

Confidential, Tampa, FL

Responsibilities:

• Involved in requirement analysis, ETL design and development for extracting data from teh 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 teh 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 teh new business requirements.
• Wrote complex SQL scripts to avoid Informatica joiners and Look-ups.
• Coordinated with DBA's in resolving teh database issues that lead to production job failures.
• Used Debugger to test teh mappings and fixed teh bugs.
• Fixed teh Issues that come out of Integration Testing.
• Migrated code/objects from teh development environment to teh QA/testing environment to facilitate teh testing of all objects developed and check their consistency end to end on teh 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 teh Enterprise Data warehouse (EDW).
• Developed ETL Specifications, Mappings for ExIm Online (EOL) data source according to teh 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 teh 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 teh transformations such as teh 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 me & II in different mappings as per teh 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 teh unit test cases and system testing on teh mappings, sessions and finally observe teh execution of workflows from teh workflow monitor.
• Created requirement specifications documents, user interface guides, and functional specification documents, ETL technical specifications document and test case.
• Understanding teh Business requirements, Source system and as part of understand teh different logical models, and tan get teh noledge of teh Extract, Transformation, Loading specifications of teh 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 teh 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 teh execution time of teh 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 teh requirements and involved in preparing documents containing Functional and Technical Details of project.
• Developed various mappings and workflows which involved in building teh 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 teh purpose to build teh Data mart.
• Responsible for creating business solutions for Incremental and full loads.
• Worked on PVCS Version Manager to deploy teh necessary code and database archives to support distributed environment.
• Involved in Unit testing and developed Unit test documents.
• Involved in end-user and providing teh 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 teh project SDLC planning, design, construction.
• Involved in rewriting teh whole ETL design for better performance and redundancy of data.
• Used Industry standard best practices for teh company and streamlining teh entire process for mapping development and test cases.
• Reviewing teh code as per teh Review Checklists and preparing teh Release Documents for different environments.
• Worked with management in project origination & halped in creating some POC’s for testing teh performance of teh new servers and analyzed teh source system for handling teh physical deletes of teh records.

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

Informatica Developer

Confidential, Nashville, TN.

Responsibilities:

• Extensively involved in studying teh business requirements and developed teh mapping specifications from teh business requirements and teh data model.
• Developed Informatica Mappings and Sessions based on mapping specifications to load data from source flat files and RDBMS tables to target tables.
• Teh project source data (flat files, relational databases) is extracted from all teh HCA operational systems and loaded into teh data warehouse, which is teh union of all teh constituent pieces of teh business.
• Distributed teh 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 teh design and development of teh data acquisition process for teh data warehouse including teh initial load and subsequent refreshes.
• Fine-tuned sources, targets, mappings, and sessions to improve teh 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 teh 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 teh workflows which run at different times in teh day.
• Created shell scripts to automate existent manual processes in teh daily production batch.
• Experience in creating teh migration documents to migrate teh 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 teh oracle/ Teradata database and for easy PL/SQL manipulations.
• Closely interacted with teh reporting team, which uses Business Objects to explain teh tables and relationships between teh 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 teh 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 teh data.
• Extensively used Database triggers, PL/SQL procedures, packages and functions while developing teh 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 teh interface.
• Involved in documenting teh modifications and intended functionalities of teh interface.
• Helped in creating technical specifications by mapping teh interface tables with teh base tables.

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