CAREER:
Over 7 years of professional software development experience in the IT industry. Worked over 6 years
on ETL Tools developing Data warehousing environment and real-time environment using Informatica Tool (Designer, Workflow manager, Workflow monitor, Repository Manager), providing solutions for Domains Financial, Pharmaceutical, HealthCare, Industrial and Insurance.

TECHNICAL EXPERTISE:

• Strong working experience on Data Warehousing concepts, directly responsible for the Extraction, Transformation and Loading of data from multiple sources into Data Warehouse.
• Expertise in Data warehouse/Datamart implementations including project scoping, requirements gathering, dimensional modeling (Star Schema design and snowflake), FACT and Dimensions Tables, Physical and Logical Data Modeling.
• Extensive experience in Extraction, Transformation and Loading of data using Informatica from heterogeneous sources like Relational database, Flat Files, XML Files, COBOL Files, Excel into Data warehouse and Data Mart.
• Experience with ETL process design, architecting the flow of data from various sources to target.
• Developed Complex mappingsfrom various transformations like Unconnected /Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more.
• Designed complex mappings using Stored Procedure’s, Lookup, Update Strategy, Normalizer, XML, MQ’s, External Procedure.
• Implemented performance tuning on sources, mappings, sessions and targets.
• Solid Experience with SQL Query Tuning on DB2 UDB/Sybase/SQL Server/Oracle.
• Experience in working with UNIX Shell Scripts.
• Used Informatica Power Connect for SAP to pull data from SAP R/3.
• Experience in Creating ABAP Mapping in Power center with PowerConnect for SAP.
• Proficient in data warehousing techniques for Data cleansing , Slowly Changing Dimension phenomenon’s (SCD’s), Change Data Capture (CDC).
• Extensive development, support and maintenance experience working in all phases of the Software Development Life Cycle (SDLC) especially in Data warehousing.
• Analyzed the existing database and designed the Packages using Cognos frame work manger.
• Created number of standard Cognos reports and queries based on the Business requirements.
• Strong experience in database development skills using Oracle PL/SQL to write stored procedures, functions, packages, and triggers. Loaded data into Database using SQL* Loader, Exported and Imported databases and Troubleshooting/Problem solving skills.
• Experienced team player with good interpersonal and communication skills.

EDUCATION
Bachelor of Technology

CERTIFICATION:
Microsoft Certified Technology Specialist: SQL Server 2005.

TECHNICAL SKILLS:

Informatica Power Center 9.1, 8.x, 7.x, 6.x and 5.x, Data Integrator, SSIS, Business Objects 5.1, 6.5,Cognos 8.3, Crystal Reports 7.0, 8.0, 9.0, 10.0.

Databases / RDBMS

Oracle 9i/10g/11g, MS SQL Server 2008/2005/ 2000,Teradata V2R5.0/V2R6.0, SAP R/3, XML, SIEBEL.

Tools

Erwin, MS Visio, PL/SQL Dev, SQL Dev, Toad.

Microsoft Suite

Excel, Word, PowerPoint.

Operating Systems

AIX UNIX, Unix (HP-Unix), Windows 95 to XP, Windows NT,

Scripting Languages

DTS Scripts, Unix Shell scripting, Korn Shell Scripting (Kshell)

Programming Languages

C, C++, java, SQL, PL/SQL, T-SQL, PHP.

Domain Knowledge

Banking and Finance, Insurance, Pharmaceutical and Health Care, Retail Industry, Telecom

Professional Experience

Sr. Informatica Developer, Jun 2009 to Till Date,Confidential,Carlsbad, CA

Life Technologies provides products and services that support Pharmaceutical and Biotech companies worldwide in their efforts to improve the human condition. The company provides essential life science technologies for disease research, drug discovery and commercial bio-production. ABI/Invitrogen is using Informatica, Cognos Data Manager and Cognos Decision Stream as main ETL tools and Cognos8 BI Suite as the main reporting toolset.
Project Names: - 1) GOS Procurment
2) JDE1-Informatica-SIEBEL interface
3) Production Support
4) Convergence (Comergent)
Responsibilities:

• Involved in gathering requirements from Business and converted them it into Technical documents.
• In EDW we load the consignment related data based business rules, this data we extract from SAP source system.
• Extensively worked on Power Center Designer, Workflow Manager.
• Involved in extracting data from ERPs like SAP, JD ENTERPRISE 1 into EDW (Oracle) and developed Transformation logic using Informatica.
• Developed ETL technical specs, ETL execution plan, Test cases, Test scripts etc.
• Created ETL mappings and mapplets to extract data fromERPs like SAP, ENTERPRISE 1 (Oracle) and load into EDW (Oracle 10g)
• Knowledge of various transformations like Source Qualifier, Lookups, Expression Editor, Update Strategy, Filter, Router, Joiner and Sequence generator, SQL, java and etc.
• Used the Aggregator transformation to load the summarized data for Sales and Finance departments.
• Knowledge of connected and unconnected lookups.
• Developed Error handling process incase Fact record gets submitted without corresponding dimension record.
• Developed two real-time interfaces for Data Management.
• Converted typical PL/SQL code and DTS packages to Informatica.
• Created multiple sessions for all the existing mappings.
• Scheduled Informatica Workflows/Sessions to execute on a timely basis and create backup for source files.
• Supported BODI for production jobs.
• Modified the queries in the jobs of BODI.
• Used Cognos Reporting studio and frame work manger.
• Developed Cogons reports for Business users based on the requirements using with Cognos 8.3.
• Developed UNIX shell scripts to control the parameter files and copy dates from one parameter file to other

Environment: Informatica 9.1, 8.6/8.1, SAP R/3,SAP BWH, SIEBEL, Cognos 8.3, Windows 2000 professional, SQL Server 2008, Oracle 9i/10g/11g, DTS Scripts, PL/SQL, BODI, Toad, Batch Files .

Informatica Developer Sep 2008 to May 2009,Confidential, Boston, MA

Pioneer Investments provides a wide range of investment solutions including mutual funds, alternative investments and structured products to clients that include institutions, corporations, intermediaries and private investors around the world. The information from various OLAP sources had to be extracted to have a unified view of the life history of each and every claim so as to enable the management make better and quicker decisions.
Responsibilities:

• Involved in customizing data models for Data warehouse supporting data from multiple sources on real time.
• Involved in Logical and Physical data models that capture current/future state data elements and data flows using Erwin.
• Used advanced techniques of Informatica to load data from MS SQL Server, Db2, Flat files into the target Teradata database.
• Designed and developed complex Mappings using Informatica PowerCenter Designer.
• Designed reusable transformations and mapplets.
• Extensively worked with transformations Lookup, Update Strategy, Expression, Filter, Stored Procedures, Router and others.
• Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions.
• Implement best practices to maintain optimal performance.
• Capture the change stream by using the Informatica Power Exchange.
• Extensively Used Informatica Power Exchange tools to capture the data change (CDC) for DB2.
• Imported external data (flat files) into Oracle tables using SQL*Loader.
• Implemented changes in slowly changing dimension tables.
• Created and ran workflows using Workflow Manager to load the data into the Target Database.
• Optimized/Tuned mappings for better performance and efficiency.
• Developed mapping parameters and variables to support SQL override.
• Created ABAP Mapping in Power center with PowerConnect for SAP.
• Used debugger to test the data flow between source and target and to fix the invalid mappings.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Used session partitions, dynamic cache memory and index caches for improving performance of Informatica services/ server.
• Queried target database using Teradata BTEQ to validate the data in the Data Warehouse.
• Designed and developed table structures, stored procedures and functions to implement business rules.
• Tested the data and data integrity among sources and targets using Unit Testing.
• Associated with Production support team in various performances related issues

Informatica Developer Jan 2007 to Aug 2008,Confidential, Atlanta, GA.

Cingular Wireless provides outstanding Wireless and DSL services to their customers. The main objective of the project is to integrate customers of the ATT wireless into the Cingular systems by developing and maintaining Customer Information Data Mart. It included extraction of data from different source systems such as Relational, Flat files, Excel files and application databases like Access. ATT wireless has information such as Orders, Billing, Remedy and Communications information, which is integrated with Cingular wireless information and stored in the Data mart.
Responsibilities:

• Conducted System study to understand the requirements and integration issues for data marts of Cingular and ATT wireless.
• Based on the requirement analysis, built the high-level business flow diagrams using Erwin.
• Imported data from Relational databases, Legacy Systems, XML files and Flat files to Oracle database using Informatica Power Connect.
• Designed Informatica mappings and reusable mapplets to extract data from SQL-Server and Oracle source systems.
• Created Informatica mappings to load one time Excel file (Communications) Data into Data mart.
• Used Type 2 Slowly Changing Dimension Mapping to insert new dimensions and update dimensions in the Target Data mart.
• Wrote stored procedures for scheduling the Informatica session using the session manager to automate the loading process.
• Conducted performance tuning of Informatica mappings and sessions.
• Developed Adhoc reports using Business Objects reporting tool and designed universes to support reporting.
• Developed INTEC scripting.
• Version control of PL/SQL SQL scripts, documents and Informatica mappings using Microsoft VSS.
• Worked with Pro*C and Executed SQL Statements in it.
• Designed and Developed highly customized applications using Pro*C and written shared server application.
• Used WinSCP to connect server.
• Used PUTTY to run the command on the unix box.
• Worked with QA team in System Integration Testing and User Acceptance Testing.

Environment: Informatica Power Center 7.1, Teradata, Oracle 8i, DB2, XML, excel, INTEC scripting, Toad, Sybase, Perl, Pro* C, WinSCP, Putty.

Dw Etl Informatica Developer Feb 2006 to Sep 2006,Confidential,Philadelphia, PA

The project involved in the maintenance and enhancement support activity of the customized ETL Application developed for the customers. Designed and tested 3 modules developed on Informatica 7.1. The Feed files were Flat Text files and used to convert them into the Informatica mappings with the required transformations and load them into related OLAP tools like Business Objects.

• Analysis of the specifications provided by the clients.
• Design of the ETL mappings as per the Users requirement.
• Used various transformations like Source Qualifier, Expression, filter, Aggregator, Lookup and SQL stored procedures.
• Was involved in Unix Shell scripting.
• Created transformations, sessions and workflows.
• Used Teradata as the Database and loaded the data for Analysis.
• Scheduling of the Informatica workflows and sessions.
• Maintained the Data Model using Snowflake schema.
• Involved in Debugging and Performance Tuning of mappings and sessions.
• Involved with the reporting team and created OLAP reports using Business Objects and Cognos.

Environment: Informatica 7.x and 6.x, Business Objects 6.5, Oracle 8.1, ERWIN, Toad and UNIX Shell Scripting.