Profile Summary:
7+ years of IT experience in design, analysis, development, documentation, coding and implementation including but not limited to Databases, Data Warehouse, ETL Design, Oracle, PL/SQL, SQL, Business Objects (Designer, Web Intelligence, Supervisor), Informatica 9.x/8.x/7.x/6.2/5.1

• Experienced in Full life cycle of Data warehousing involving Business Requirement gathering and analysis, Design, Development, Testing, Documentation and Support using Informatica Power Center (7x/ 8x/9x).
• Experience in Data Modeling, ETL Design, Development, Programming, Testing, Performance tuning, Implementation and Troubleshooting and error handling in the field of Data warehousing and gathering Business User Requirements.
• Strong Data warehousing experience specializing in RDBMS, ETL Concepts ETL procedure to load data from different sources into data warehouse using Informatica Power Center (Repository Manager, Designer, Workflow Manager and Workflow Monitor).
• Expert in the ETL Tool Informatica. Have had extensive experience in working with various Power Center Transformations using Designer Tool.
• Proficient in using Workflow Manager Tools like Task Developer, Workflow Designer and Worklet Designer.
• Developed several complex Mappings, Mapplets and Reusable Transformations to facilitate one time, Daily, Monthly and Yearly Loading of Data.
• Extensive Knowledge and Implementation skills in SSIS, SSRS and SSAS.
• Experience in integration of various data sources with Multiple Relational Databases like DB2, Oracle, SQL Server 2000, 2005 and 2008 R2, MS Access and Worked on integrating data from Flat Files.
• Experienced in writing, testing and implementation of Stored Procedures, Triggers, Functions and Packages at database level and form level using T-SQL.
• Experienced in tuning PL/SQL Procedures for better performance.
• Experience in extracting and loading data from Oracle, and SQL Server using SQL *Loader and External tables.
• Extensive Data modeling experience in Star Schema/Snowflake schema design, Fact and Dimensions tables and Physical and Logical data modeling.
• Have had extensive experience working with databases like IBM UDB DB2, Oracle, MS SQL Server 2005 and 2008 R2.
• Expertise in data modeling using Erwin with Ralph Kimball\'s dimensional modeling techniques and Bill Inman\'s 3NF modeling techniques.

RDBMS

Oracle11g/10g/9i/8i, SQL Server2005/2008,Teradata V2R5,DB2 UDB 8.1

ETL Tools

Informatica PowerCenter9.1/8.1/8.5/8.6/7.x / Power Exchange / Power Connect.

BI Tools

Business Objects XI R2/R1/6.x,Cognos.

Operating System

UNIX,IBM AIX 4.3/4.2, Windows NT/2000/XP

Job Scheduling Tools

Control-M7.0,TIDAL Scheduler, Autosys4.5

Defect Management tools

HP Quality Center 9x, Test Director 7x, Remedy 7x

Languages

SQL, PL/SQL, TSQL, Unix Shell Scripting, XML, C, C++, C#, Cobol, JavaScript, NZSQL,

Modeling Tools

ER Studio, Erwin 4.1,UML

Database frontend tools

Oracle SQL Developer, Aqua Data Studio 8.0.7, Quest Toad for Oracle, DB Artisan.

Professional Experience:

Confidential, Palo Alto, CA Nov \'11 - Present
Informatica Developer

The goal of this project was to build a reporting warehouse that provides integrated views of information that can be verified with respect to historical as well as present data.
Responsibilities:

• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle. Worked on gathering, analyzing and documenting business req
• Worked with enterprise architects to develop the new logical and physical ER data models in line with corporate standards and guidelines.
• Created the necessary documentations like High Level Design document (HDD), Detail Design Document (DD) with the ETL Mapping Matrix for the new data marts.
• Created Informatica Mappings to load data and used transformations like Stored procedure transformation, Connected and Unconnected lookups,Source Qualifier, Expression,Sorter, Aggregator, Joiner, Filters, Sequence, Router and Update Strategy transformations.
• Architected and developed Fast Load and MLoad scripts, developed BTEQ scripts to process the data in staging server.
• Worked on Variables, Parameters, Parameter files and File list on Informatica.
• Implemented slowly changing dimensions (Type 1 and Type II) for customer Dimension table loading.
• Extensively used Stored Procedures,Functions and Packages using PL/SQL for creating Connected and Unconnected Stored Procedure Transformations.
• Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions and scheduling them to run at specified time and as well to read data from different sources and write it to target databases.
• Involved in writing Automation Testing scripts using Shell and worked on Maestro to schedule these scripts in DEV and QA environments.
• Extensively used Toad during development and testing to ensure data quality and investigate data issues.
• Performed Unit and System Testing as per the test plan and documented the test results as per the corporate standards.
• Monitored the data loads during UAT tracked and resolved the defects raised by the business users.
• Involved in development of programs for Extraction and Transformation, Fast Load and MLoadscripts, developed BTEQ scripts to process the data in staging server.
• Created documentation such as Run Books, Technical Architecture Specifications, Source to TargetMappings, Data Flow Diagrams for the users and the support team.
• Weekly status meeting with the client to communicate the development progress and any issues arising during Design, Development and Testing phases.
• Ensured that the documentations comply with the corporate stand.

Environment: Informatica Power Center 9.1, power Exchange,Oracle10g, DB2, SQL Server 2008,MY SQL, XML, HP Quality Center 9.0,Toad, SQL Developer, Control - M,PL/SQL (Stored Procedures, Triggers, Packages),Erwin, MS Visio, UNIX shell Scripting, AIX, Windows XP.

Confidential, Santa Clara, CA Aug \'10 - Oct \'11
Informatica ETL Developer
The goal of the project is to develop the ETL process involved extracting the data from SQL Server and Oracle sources and loading them into an Oracle target. The data was used to analyze customer opinions, loyalty, customer profiles and customer satisfaction.
Responsibilities:

• Business Requirements gathering and analysis provided by the client, preparation of functional specifications and design documents.
• Actively involved in gathering requirements and acquiring application knowledge from Business Managers & Application Owners.
• Performed extensive data analysis along with subject matter experts and identified source data and implemented data cleansing strategy.
• Prepared technical specifications for the development of Informatica (ETL) mappings to load data into various target tables and defining ETL standards.
• Worked with various Informatica client tools like Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, TransformationDeveloper, InformaticaRepositoryManager and Workflow Manager.
• Developed standard and re-usable mappings and mapplets using various transformations like expression,aggregator, joiner, source qualifier, router, lookup Connected/Unconnected, and filter.
• Created Mapplets, reusable transformations and used them in different mappings.
• Created Workflows and used various tasks like Email, Timer, Scheduler, Control, Decision, and Session in the workflow manager.
• Involved in Performance Tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volume of data.
• Used Informaticadebugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.
• Created, Tested and debugged the Stored Procedures, Functions,Packages, Cursors and triggers using PL/SQL developer.
• Used the feature EXPLAIN PLAN to find out the bottlenecks in a given Query, thus improving the performance of the job.
• Involved in Unit testing, System testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Migrated repository objects, services and scripts from development environment to production environment
• Prepared the Standard Operating Procedure (Knowledge Transfer) document, which provides necessary information, required for the Maintenance and Operation of the application.
• Actively involved in production support. Implemented fixes/solutions to issues/tickets raised by user community.

Environment: Informatica Power Center 8.6.1, SQL server, Oracle 10g, DB2, Teradata Utilities, Flat Files, Windows, UNIX, Maestro, TOAD, Erwin 7.3

Confidential, North Brook, IL Dec \'08- July \'10
Informatica ETL Developer
Confidential, and homes in the U.S. and is one of the leading life insurer\'s. Allstate Roadside Services is a division of Allstate Insurance. ARS provides services to a wide array of industries including BMW, Mercedes Benz, and Verizon wireless. The goal of this project was to build a reporting warehouse that provides integrated views of information that can be verified with respect to historical as well as present data.
Responsibilities:

• Prepared technical specifications for the development of Informatica (ETL) mappings to load data into various target tables and defining ETL standards.
• Worked with various Informatica client tools like Source Analyzer,Warehousedesigner,Mapping designer, Mapplet Designer, TransformationDeveloper, Informatica RepositoryManager and Workflow Manager.
• Developed standard and re-usable mappings and Mapplet using various transformations like expression, aggregator, joiner, source qualifier, router, lookup Connected/Unconnected, and filter.
• Involved in analysis, requirements gathering, functional/technical specification, and development, deploying and testing.
• Involved in designing Oracle schemas for specific functional areas.
• Provided back-end support for customized forms for customer, supplier maintenance, bill, receipt, letter of credit, invoice, debit and credit notes.
• Doing unit testing on reports, PL/SQL stored procedures, functions, triggers, packages, views and cursors.
• Implemented archiving process on huge FACT table, which included creating of stored procedures for adding and dropping Partitions on table based on the Business requirements.
• Analyze, design and develop stored objects in PL/SQL to improve the performance of data load
• Scheduled ETL loads using CRONTAB and provided monitoring using Workflow Monitor
• Design and develop relevant triggers, stored procedures,sub-programs and packages with advanced PL/SQL programming techniques such as ref cursor, collections, and bulk operation.
• Code and test Oraclestored procedures using PL/SQL.

Environment: Informatica 8.1, Oracle 9i, HP-UNIX, Flat Files, IBM DB2, PL/SQL Developerand TOAD.

Confidential, WestPoint, PA Dec \'07 - Nov \'08
Informatica Developer
The objective of the Central DW project was to support business executives to take quick decisions. Merck stores pharma trials data in various databases. The data from these databases, which were in form of Flat files, SQL Server, Oracle and Excel files were loaded into Oracle. All the sources in different formats were centralized in Oracle database. Informaticawas used to extract the data from different systems.
Responsibilities:

• Involved in the requirement definition and analysis support for Data warehouse efforts.
• Documented and translated user requirements into system solutions; developed implementationplan and schedule.
• Designed dimension and fact tables for Star Schema to develop the Data warehouse.
• Extracted the data from Teradata, SQL Server, 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 a 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, StoredProcedure, 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 assignedprivileges Using Repository manager.
• Setting up Batches and sessions to schedule the loads at required frequency using Power Center 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 Power Center 7.1, Oracle 9i, UNIX, Sybase, MS SQL Server 2004, Windows 2000

Confidential, Portland, OR Aug \'06 - Nov \'07
Informatica Developer
The EDW project was created to enable management to better leverage information collected within Nike's current operational systems to help in their decision-making process to analyze the sales product wise, sales team\'s performance and sales promotions etc. The system aimed to provide continuity of knowledge about customers and facilitates proactive sales management techniques for customer-centric teams.
Responsibilities:

• I was involved in the regular maintenance of the Data mart monitoring the data loads regularly and address any disruptions in their daily run
• Addressing Informatica load failures identifying the issue and executing auxiliary loads to load the missed data into the Data warehouse
• Handling change requests to change the mappings and strategy to include the changes in business rules
• Co-coordinating with the source teams to ensure timely transfer of source files and intimating them in case of any delays
• Optimizing/Tuning mappings for better performance and efficiency.
• Attending the Weekly status calls with client explain the weekly status of the loads and any issues
• Handling change requests to change the mappings and strategy to include the changes in business rules
• Involved in Design Review and preparation of ETL/Reporting Design Documents.
• Worked on Creation of mappings using Informatica 6 and Performance tuning of backend SQL generated for BO reports for faster Report Output
• Testing - unit testing, integration testing & performance testing.

Environment: Informatica Power Center 6, Oracle 9i, SQL, DB2, PL/SQL, Windows NT.

Confidential, Nodia India Jun \'05 - July\'06
Oracle Developer
Responsibilities:

• Involved in analyzing the business rules and preparing the respective design document.
• Responsible for creating the technical design document and user documentation.
• Wrote SQL, PL/SQL scripts and built some complex queries using SQL and wrote storedprocedures using PL/SQL.
• Extensively used Cursors, REF Cursors, Composite data type and Collections in writing the backend PL/SQL code.
• Involved in the design, development and testing of the PL/SQL stored procedures, packages and triggers.
• Developed Various Complex SQL queries, stored procedures, functions, Packages and Databasetriggers.
• Involved in writing Unix Shell Scripts.
• Involved in Query optimization using SQL Trace, TKPROF and Explain Plan.
• Involved in Data Loading and Data Migration. Used SQL*Loader to load data from Excel file into temporary table and developed PL/SQL program to load data from temporary table into base Tables.
• Developed numerous programs using PL/SQL and many packages to do the validations as per requirements.
• Used Dynamic SQL (DBMS_SQL, DBMS_DDL) in function and procedure.
• Wrote test scripts for different modules of the system.
• Carried out Unit Test and Integration Testing.

Environment: Oracle 9i/8i, PL/SQL, SQL, Windows 2000, TOAD.

EDUCATION: Bachelor's of Engineering