SUMMARY

• Extensive experience with 8+yrs IT Industry in Analysis,Design, Development, Testing and Maintenance ofBusiness Intelligence,Data Warehousingand Telecomprojects. Excellent Analytical and Problem Solving Skills.
• Experience in Full Life Cycle Implementation of Data warehouses.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star - SchemaModeling, Snowflakes Modeling, Change data capture methodologies..
• Good understanding of Software Development Life Cycle (SDLC) and Project Life Cycle.
• Used Informatica as an ETL to extract data from source systems to target system. Experience in understanding & creating source and target definitions, mappings, transformations and working with sessions.
• Worked with Informatica transformations such as source qualifier, joiner, connected/unconnected lookups, expressions, routers, aggregators, update strategy, filters, normalizers, sequence generators, etc.
• Experience in implementing Slowly Changing Dimensions.
• Hands on experience in performancetuning of mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions.
• Extensive experience in using various Informatica Designer Tools like Source Analyzer, Transformation Developer, Mapping Designer, Mapplets Designer and Warehouse Designer.
• Practical knowledge of Data warehouse concept, Data modeling principles (Kimball/Inmon approach)
• In-depth understanding of Star Schema, Snow Flake Schema, Normalization, 1st NF, 2nd NF, 3rd NF, Fact tables, Dimension tables.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, and DB2 and worked on integrating data from flat files like fixed width and delimited.
• Experience in implementing Slowly Changing Dimensions (Type1, Type2 and Type3) mappings.
• Strong experience in coding using SQL, SQL*Plus, PL/SQL Procedures/Functions, Triggers and Packages.
• Extensively executed SQL queries on Oracle using Toad and SQL Server tables in order to view successful transaction of data and to validate data.
• Experience in technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Experience in using the Informatica command line utilities like pmcmd to execute Workflows in non-windows environment.
• Extensively worked on Oracle, SQLand PL/SQLprogramming.
• Developed Stored Procedures using PL/SQL.
• Worked in onsite and offshore model, Coordinated Offshore development activity, and reviewing development work and resolving the issues.
• Experience in UNIX shells scripting.
• Responsible for interacting with business partners to identify information needs and business requirements for the project.
• Flexible and Versatile who can adapt to any new environment and learn fast with strong communication &interpersonal skills.
• Ability to perform well in a group or individually and can cope well in a high intensity work environment.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center8.x/7.x/6.x/5.x

Databases: Oracle 10g/9i/8i, DB2, MS SQL Server 2005, MS Access 97/2000

Languages: SQL, PL/SQL, SQL*Loader, SQL*Plus, C, C++

Scheduling Tool: Autosys, Tivoli

Operating Systems: Windows 98/2000/XP/Vista, UNIX

Office Tools: MS Office, Microsoft Visio, MS Visual Source Safe

Other Tools: Toad, Rapid SQL

PROFESSIONAL EXPERIENCE

Confidential, GA

Production Support

Responsibilities:

• Monitoring the Jobs and sever space availability and CPU Process.
• On call Production support and preparing procedures/documentation whenever necessary.
• Preparing standard operating Procedures for related Informatica issues.
• Extensively used Informatica Power Center 8.1.1 to extract data from various sources and load in to staging database.
• Extensively used transformations such as Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Joiner, Transaction Control and Stored Procedure.
• Developed Informatica mappings and mapplets and also tuned them for Optimum performance, Dependencies and Batch Design.
• Extensively worked with Informatica - Source Analyzer, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager, Workflow Manager, Workflow Monitor, Repository server and Informatica server to load data from flat files, legacy data.
• Designed the mappings between sources (external files and databases) to operational staging targets.
• Worked with pre and post sessions, and extracted data from Transaction System into Staging Area. Knowledge of Identifying Facts and Dimensions tables.
• Tuned sources, targets, mappings and sessions to improve the performance of data load.
• Wrote Teradata SQL queries according to Process need.
• Used Teradata SQL Assistant & Manager for database.
• Implemented Slowly Changing Dimension methodology.
• Created Several Informatica Mappings to populate the data into dimensions and fact tables.
• Maintaining the bugs in the bug tracker tools based on their severity.
• Analyzing and tracking the Test Results document and Bug reports using Quality Center 9.0.
• Developed Perl Script for loading of Data from Source to Target.
• Maintained Versions of Mappings, Mapplets, Sessions, and Workflows etc using StarTeam/Accurev.
• Worked cooperatively with the team members to identify and resolve various issues relating to Informatica and other database related issues.
• Designed and Developed Oracle PL/SQL Procedures and UNIX Shell Scripts, Data Import/Export and Data Conversions
• Fine-tuning of PL/SQL Stored Procedures.
• Preparing weekly and monthly progress report.
• Maintain all necessary updates and/or patches for the ETL environments.
• Monitors and tunes ETL repository and system for performance improvements.
• Ability to perform root cause analysis, performance monitoring and application related issues.
• Handle user access / security role requests for new developers and projects.
• Coordinate deployments that include Informatica deployments as well as probably Unix Shell Script and Database DDL deployments.
• Resolved the issues Remedy Tickets on Priority basis.
• Extensively used Calculations, Variables, Drill Down and Slice and Dice for creating Business Objects reports
• Analyzed the Fulfillment requests (FR) and Change request (CR) as per requests from HPPM.
• Worked on Informatica PowerCenter components Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Designed/developed/maintained BusinessObjects Universes.
• Developed Business Objects Reports based on the new business Specifications and Report Standards.
• Plans and implements backup and recovery of the Oracle database.

Environment: Source- Oracle, Mainframes,Target- Oracle Database, Teradata,Tools- Informatica8.6, Toad, Tivoli Mastro Scheduler

Confidential, OH

ETL Developer

Responsibilities:

• Worked on the mappings for both history and incremental loads. As an ETL developer,
• Ensured that all the naming conventions, formats are strictly followed. And also worked for preparing test cases.
• Initiated and drivethe JAD Sessions to understanding the details of the initiated requirement.
• Documented user requirements, translated requirements into system solutions and develop implementation plan and schedule
• Identified data source systems integration issues and proposing feasible integration solutions.
• Worked with Data modeler in developing STAR Schemas and Snowflake schemas.
• Extracting data from Oracle and Flat file, XML and COBOL sources 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.
• Scheduled the workflows at specified frequency according to the business requirements and monitored the workflows using Workflow Monitor.
• Involved in performance tuning of Source and Target databases, Mappings and Sessions, improved performance by identifying performance bottlenecks.
• Fixing invalid Mappings, Debugging the mappings in designer, Unit and Integration Testing of Informatica Sessions, Worklets, Workflows.
• Extensively used TOAD for source and target database activities.
• Involved in the development and testing of individual data marts, Informatica mappings and update processes.
• Involved in writing Unix shell scripts for Informatica ETL tool to run the Sessions
• Used various debugging techniques to debug the mappings
• Unit tested the maps by running SQL queries on source and target
• Involved in preparation of user manual and knowledge transfer
• Unit tested the maps by running SQL queries on source and target
• Tested data necessary to validate ETL code using positive and negative scenarios
• Created Test cases, Test data and involved in Unit Testing to find the business rules applied correctly.

Environment: Source- Symix,Target- Oracle Database,Tool- Informatica8.6

Confidential, Texas

ETL Developer

Responsibilities:

• Worked on Power Center client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer
• Used most of the transformations such as the Source qualifier, Aggregators, lookups, Filters, Sequence Generator and Update strategy
• Developed transformations, mappings, sessions and workflows in Informatica to load target database and tuned mappings for improving performance
• Involved in Data Extraction from heterogeneous source systems like Oracle, DB2 and flat files
• Used mapping parameters and variables to meet the business requirement
• Wrote UNIX shell scripts to execute Informatica Workflows
• Worked on Informatica tools like Designer, Workflow Manager, and Workflow Monitor.
• Worked mostly on Lookup, Aggregator, and Expression Transformations to implement complex logics while coding a Mapping.
• Worked with Memory cache for static and dynamic cache for the better throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations.
• Monitoring the Jobs, observing the performance of the individual transformations and tuning the code(Performance Tuning)
• Migrating objects between different Environments using XML Export/Import (using Repository Manager).
• Developed code to load the data from Flat File to stage and stage to ODS.
• Developed mappings with XML as target and formatting the target data according to the requirement.
• Designed and developed Informatica mappings for data loads and data cleansing.
• Created mappings to in corporate Incremental loads.
• Developed reusable Mapplets to include the Audit rules.
• Developed universe and reports using Business objects
• Worked on Business Objects reports like drill down reports, master detail reports, etc
• Worked on enhancing the reports according to business rules
• Created the Test cases for Unit Test and involved in Unit testing

Environment: Informatics Power Center 8.6 Business Objects 6.1, Oracle 8i, DB2, UNIX, SQL, PL/SQL, Toad

Confidential, NJ

ETL Informatica Developer

Responsibilities:

• Prepared Functional/Technical Specification documents from BRD (Business Requirement Document) / Customer Requirements
• Involved in giving the estimate for the project
• Worked on Informatica Power Center components Designer, Workflow Manager, Workflow Monitor and Repository Manager
• Involved in creation of data warehouse star schema using Data modeling tool Erwin
• Involved in Data Extraction from heterogeneous source systems like Oracle, DB2 and flat files.
• Created Informatica mappings, sessions and workflows to populate data into Fact and Dimension tables
• According to the business logic created various transformations likeSource Qualifier, Lookup, Sequence Generator, Router, Filter, Aggregator, Joiner, Expression, Normalizer and Update Strategy
• Created reusable transformations and used in various mappings
• Performance tuning of targets, sources, mappings and SQL queries in the transformations
• Developed mappings to implement type 1 and type 2 slowly changing dimensions
• Used mapping parameters and variables to meet the business requirement
• Used various debugging techniques to debug the mappings
• Developed Informatica parameter files
• Involved in doing reviews
• Involved in creation of Stored Procedures using PL/SQL
• Wrote UNIX shell scripts to execute Informatica Workflows
• Mentored and guided the junior developers
• Created JIL scripts using the job scheduling tool Autosys
• Performed extensive SQL querying on Oracle database for data validation
• Unit tested the maps by running SQL queries on source and target
• Tested data necessary to validate ETL code using positive and negative scenarios
• Created Test cases, Test data and involved in Unit Testing to find the business rules applied correctly.

Environment: Informatica Power Center 8.x, Oracle 10g, SQL, PL/SQL, DB2, Stored Procedures, UNIX, Autosys, Rapid SQL, ERWIN 4.0

Confidential

ETL Informatica Developer

Responsibilities:

• Interacted with onsite team to gather the new requirements and working with existing issues.
• Designed ETL process usingInformaticaTool to load from Sources to Targets through Transformations
• Developed various Mappings using transformation like Aggregator, Joiners, Lookups, Filters, Router and Update strategy.
• Unit testing, Function Testing, System Testing and Performance Testing performed on Mappings.
• Optimized various Mappings, Sessions, Sources and Target Databases
• Used Debugger for debugging Mappings.
• Designed and configured sessions with effective caching and logging
• Monitored workflows and collected performance data to maximize the session performance.
• Involved in ETL Scripts to call the job and XCOM to window server for Trillium Address validation and deduplication.
• Designed Trillium project for address validation and De-duplication.
• Developed projects for different countries using various process like Transformer, CDP (Customer Data Parser), Postal Matcher, WinKey Generation, Transformer Address Re-construction, Relationship Linker.
• Testing performed on this (Trillium) project.

Environment: Informatica8.1, Oracle 10g, Trillium Software System 11.5, Windows, UNIX.