SUMMARY

• Seven years of experience in designing, implementing and supporting Data Mart applications using ETL tool INFORMATICA PowerCenter
• Experience in all aspects of project development life cycle in Data Warehousing
• Solid experience in Informatica PowerCenter (versions 9.1/8.1/7.1)
• Extensive experience in supporting Informatica applications
• Good experience in Performance Tuning of Informatica mappings
• Involved in Relational database design and development of data warehouse data feeds
• Very strong in Relational Databases (RDBMS), design and build the Data Warehouse, Data marts using Star Schema and Snow Flake Schema for faster and effective Querying
• Excellent skills in retrieving the data by writing simple/ complex SQL Queries
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, MS Access and Worked on integrating data from flat files and XML
• Worked with Stored Procedures, Triggers, Cursors, Indexes, and Functions
• Experience in UNIX shell scripting, CRON, FTP and file management in various UNIX environments
• Experience in using the Informatica command line utilities like pmcmd to control workflows in non - windows environments
• 24 * 7 on-call support
• Ability to work in-groups as well as independently with minimum supervision and initiative to learn new technologies and tools quickly
• Excellent in problem solving, logical and analytical abilities
• Good Communication and interpersonal skills

TECHNICAL SKILLS

ETL Tools: Informatica Power center 9.1/8.6/8.1.1/7.1.4

Operating Systems: Windows 7/XP/2000/98/NT, DOS, UNIX 5.0.5, RedHat Linux 8.x

Databases: Oracle 11g/10g/9i/8i/7.3, MS SQL Server 2000/7.0/6.5, MS Access

Languages: C, C++, SQL, PL/SQL

Scripting: PERL, SHELL Scripting

Data Modeling Tools: Erwin 3.5.2/4.0

Web Technologies: HTML, XML

PROFESSIONAL EXPERIENCE

Confidential, Lewisville, TX

ETL Developer

Responsibilities:

• Analyzed specifications and identified source data needs to be moved to Data Mart, Warehouse and ODS. Participated in the Design Team and user requirement gathering meetings
• Created ETL design document to load data from Source systems into staging tables, ODS, Warehouse and Data mart
• Worked with the Business Analyst team during the functional design and technical design phases
• Worked on Web services to populate data from Oracle and MS SQL Servers into Vendor Databases
• Created Design Documents, high and detailed level mapping documents, and used Quality Center (Test Director) to run the Test Plans
• Data sources and targets include Oracle, MS SQL Server, XML and Flat files
• Designed Mappings, Mapplets, Reusable Transformations, Sessions, Worklets and Workflows.
• Involved in performance tuning of mappings, transformations and sessions to optimize session performance. Tuned SQL Queries, used parameter files, variables and dynamic Caches and round robin, hash auto key, Key range partitioning
• Worked extensively on debugging invalid mappings using break points. Used Debugger sessions to debug sessions by creating breakpoints for better analysis of mappings
• Used scripts to execute the pre-session and post-session tasks and to run the workflows
• Developed and debugged SQL and PL/SQL Scripts, packages, stored procedures and functions
• Used PMCMD commands in Perl scripts to loop sessions and worklets
• Captured data errors into Informatica generated error tables for logging purpose
• Created Test cases for Unit Test, System Integration Test and UAT
• Created Applications using Cybermation Scheduling tool, scheduled it, configured it to generate overdue tickets and automated it to assign tickets without human intervention
• Executed hundreds of stored procedures using SQL transformation in a single session run
• Used Transaction Control transformation to control commit and roll back transactions
• Worked with Dynamic lookup and Persistent caches and loaded millions of records
• Tuned session performance by incrementing DTM buffer size to required size and tuned session advanced attributes to load large number of columns with huge precision
• Wrote Perl scripts to FTP files from source file share to Informatica file share
• Hands on experience in Informatica Data Quality (IDQ).
• Developed and supported 26 interfaces for the e-TRAC system
• Developed ETL to populate data for SSAS Data Cubes
• Provided 24x7 on-call support for e-Trac application on a daily basis in order to meet SLA and to provide consistent data to the users
• Handled Piccaso tickets, created CRQs, Service requests, e-forms. Created upgrade implementation plans.
• Provided Knowledge Transfer to the end users. Coordinated daily, monthly releases and reruns.
• Worked along with the DBA to resolve performance and tuning issues.
• Worked with System Analysts in designing, testing and implementing ETL solutions.

Environment: Informatica Power Center 9.1, 8.6.1 and 8.1.1, MS SQL Server 2005 and 2008, Oracle 11g/10g, Toad, IDQ, Perl scripts, ESP Cybermation Scheduler.

Confidential, CA

ETL Developer

Responsibilities:

• Developed and maintained central data warehouse and different applications/ interfaces associated with it to maintain the entire system such as Direct Sales and Chargebacks, Incentives and Payments, Membership and etc, which will help in analyzing the status quo of the company and in taking the business decisions for further development of the company
• Involved in requirements gathering, business analysis with the users for the development of new applications
• Preparation of technical specification for the development of Informatica Extraction, Transformation and Loading (ETL) mappings to load data into various tables in Data Marts and defining ETL standards
• Worked on different data sources such as DB2, Oracle, SQL, XLS, XML, Flat files, Teradata
• Optimized the existing applications at the mapping level, session level and database level for a better performance.
• Worked on partitioning, mapping variables, debugger, variable ports
• Scheduled jobs using Informatica Workflow Manager, scheduling tool Control-M enterpriser and Unix Shell Scripting
• Implemented slowly changing dimensions methodology and developed mappings to keep track of historical data
• Developed Dynamic Parameter files for the workflows
• Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance
• Extensively Wrote Stored procedures and & anonymous PL/SQL Scripts
• Converted all the stored procedures into Informatica mappings
• Worked on enhancements of the existing system applications
• Created recovery workflows in order to provide backup for the critical jobs
• Provided 24x7 on-call support for over 100 applications on a daily basis in order to meet SLA and to provide consistent data to the users
• Used Toad and SQL Plus for database analysis performance tuning and trouble shooting
• Documented System Architecture Design (SAD) Document, Mapping Document and Unit Test plans
• Worked on ClearQuest to track all the requests, assigned work

Environment: Informatica PowerCenter V8.6, DB2, Oracle 10g/9i/8i, SQL Server, Teradata, SQL Plus, PL/SQL, Windows 2000, TOAD 7.0, Flat Files, ClearQuest

Confidential, Mooresville, NC

Informatica Developer

Responsibilities:

• Involved in the requirement definition and analysis support for Data warehouse efforts
• Documented and translated user requirements into system solutions; developed implementation plan and schedule
• Designed dimension and fact tables for Star Schema to develop the Data warehouse
• Extracted the data from Teradata, SQL Server, DB2, Oracle, Files, and Access into Data warehouse
• Created dimensions and facts in physical data model using ERwin tool
• Used Informatica Designer to create complex mappings using different transformations to move data to Data Warehouse
• Developed mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Source Qualifier, Look up, Aggregator, Stored Procedure, Update Strategy, Joiner, Filter
• Scheduling the sessions to extract, transform and load data into warehouse database on Business requirements.
• Loaded the flat files data using Informatica to data warehouse
• Created Global Repository, Groups, Users assigned privileges Using Repository manager
• Setting up Batches and sessions to schedule the loads at required frequency using PowerCenter server Manager
• Handled common data warehousing problems like tracking dimension change using SCD type2 mapping
• Used e-mail task for on success and on-failure notification
• Used decision task for running different tasks in the same workflow
• Assisted team member with their various Informatica needs
• Developed and maintained technical documentation regarding the extract, transformation and load process
• Responsible for the development of system test plans, test case creation, monitoring progress of specific testing activities against plan, and successfully completing testing activities within the requisite project timeframes

Environment: Informatica PowerCenter 8.6/8.1, DB2, Oracle 9i/8i, SQL plus, PL/SQL, Toad 8.5.0, Windows 2000, ERwin

Confidential, Charlotte, NC

Informatica Developer

Responsibilities:

• Involved in Extraction, Transformation and Loading (ETL) of data by using Informatica PowerCenter 6.2 / 7.1.1
• Extensively worked with Repository Manager, Designer, Workflow Manager and Workflow Monitor
• Developed transformation logic and designed various Complex Mappings and Mapplets using Designer
• Implemented SCD methodology including Type 1, Type 2 changes to keep track of historical data
• Worked on various transformations like Lookup, Aggregator, Expression, Router, Filter, Update Strategy, and Stored Procedure
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters
• Used the Workflow manager to create workflows, worklets and tasks
• Created Cronjobs for automation of ETL processes
• Monitored production jobs on daily basis and worked on failed workflows to correct them
• Documented the entire process. The documents included the mapping document, unit testing document and system testing document among others
• Involved in creating BO reports like cross tab, Master-Detail reports.

Environment: Informatica Power Center 7.1.4/8.1, Oracle 9i, PL/SQL, SQL*Plus, Win 2000 and UNIX.

Confidential

Software Engineer

Responsibilities:

• Involved in the entire System study, analysis and Design
• Designed and developed all the tables, views for the system in Oracle
• Maintain all the transactions, which include Generating sales invoices
• Created indexes, sequences, constraints and snapshots
• Created Views and wrote Triggers for Stored procedures for implementing the business logic
• Developed Application programs using Oracle PL/SQL Packages, Procedures, Functions and Database Triggers
• Generated SQL and PL/SQL scripts to install create and drop database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms
• Worked with analysts, users, and other IT technical professionals to understand requirements
• Supported technical teams involved with ORACLE issues and operations
• Involved in Implementation and production Support of the system
• Responsible for unit testing and documenting the test results

Environment: Oracle 8i/7, Oracle forms, PL/SQL, SQL* Loader, UNIX Shell Scripts