PROFESSIONAL SUMMARY:

• Over 8 years of professional experience in IT Industry including 5 years of expertise in Development and Implementation of Data Warehouse applications.
• Extensive experience in development and designing of ETL methodology for supporting data transformations and processing in a corporate wide environment using Informatica PowerCenter 5.x/6.x/7.x/8.6 and Siebel EIM Methodologies.
• Involved in creating data maps using Informatica Power Exchange 5.2.2.
• Involved in the Softwarefull development lifecycle ( SDLC) from requirements gathering through development and support for Financial, Insurance, Banking and Communications industries using Informatica PowerCenter, Repository Manager, Designer, Server Manager, Workflow Manager, and Workflow Monitor.
• Knowledge of data warehousing techniques, Star / Snowflake schema, ETL, OLAP and Report delivery methodologies.
• Experience in integration of various data sources like SQL Server, Oracle, Flat Files, and XML files.
• Installation and configuration of Informatica servers and client environments.
• Experience in writing, testing, and implementation of the triggers, cursors, procedures, and functions at database level using PL/SQL.
• Experience in debugging and performance tuning of sources, targets, mappings and sessions.
• Expertise in DAC sequencing.
• Experience in high-end programming using SQL, PL/SQL, SQL * Loader.
• Excellent communication, interpersonal, analytical skills, and strong ability to perform as part of a team, and got certified by Brain bench as one among the best in RDBMS Concepts.

CERTIFICATIONS:

EDUCATION:
M.S in Micro Systems (Electronics) Engineering

B.S in Electrical and Electronics Engineering

TECHNICAL SKILLS:

Databases: Oracle 9i/8i/8.0, SQL server 2000, PL/SQL, Teradata, DB2, Java

Operating Systems: Windows NT/2000/XP, UNIX/ SUN SOLARIS and MS-DOS

Languages and Scripts: SQL, PL/SQL and UNIX shell scripting, Perl Scripting, SFTP

Reporting Tools: Business Objects 5x, Crystal Reports

Other Methodologies: Data Modeling, Logical and Physical designing and Analysis, Loading data, ERWIN 4.0

PROFESSIONAL EXPERIENCE:

Confidential, January 2009 - Till Date
Informatica ETL /Siebel EIM Consultant
Project:
Confidential,leads the industry in insuring specialty products such as mobile homes, motor homes, travel trailers and specialty dwellings. Farmers choose to develop NWCS project to achieve market leadership by driving innovation and operational excellence to provide the best value and experience for every customer.

Responsibilities:

• Created Technical Design documents and ETL process using Informatica 8.6 for NWCS Data project. The source systems were ORACLE, Siebel, flat file and legacy systems; the targets systems were ORACLE, Siebel & ZURICH (XML).
• Implemented End-to-End NWCS project (Worked on both Release 1 & Release 2 with Business).
• Created lot of mappings using various active and passive transformations like Source Qualifier, Lookup, Router, Normalizer, Aggregator, Filter, Joiner, and Expression using Informatica 8.6.
• Extracted data from Siebel system and generated XML's as per Vendor Review system requirement.
• Worked with different External Vendor systems like Zurich, PMSI to provide the required claim extract data in XML files, sending the Bills for review, loading Bill Review status Feedback and processing the Bill Recommendations provided by Vendors into Siebel system as per requirement.
• Created EIM process to load the Claim status, Bill Feedback data from EIM tables to Siebel base tables and also created activities for missing data.
• Designed and developed pre and post session UNIX scripts (Extraction and loading scripts) and batch execution routines.
• Used debugger and breakpoints to view transformations output and debug mappings.
• Tuned the mappings to enhance performance after the mappings functionality was validated.
• Created ETL process to generate Zurich Claim Extract and PMSI Claim extract XML files for Vendors from Siebel Base tables using Informatica 8.6.
• Enhanced the Informatica Code (Mappings & workflows) to improve the performance by Performance Tuning.
• Created re-usable workflows, sessions, and also other tasks like event wait, event raise, and email to run the workflows with the logic embedded in the mappings.
• Used Informatica scheduler to create and run the Jobs in respective environments.
• Created and worked on configure/ run/ debug ETL/EIM process.
• Created documentation for the projects (TDD & Data Mapping documents) as per the Use Case documents.

Environment: Informatica 8.6, Oracle 9i-PL/SQL, TOAD, Siebel 8.0, UNIX, WINDOWS XP.

Confidential, Charlotte, NC Feb 2007 - Dec 2008
Informatica ETL/Siebel EIM Developer
Project:
Confidential, the leading provider of Teachers Insurance and Annuity Association, College Retirement Equities Fund insurance to different universities and medical entities. In 2000 TIAA-CREF selected the Informatica data integration platform because of its flexibility in providing pre and post-session support, ease of use, and industry leadership position. TIAA-CREF Financial Services realizes cost savings by using Informatica data integration software over a custom integration solution.

Responsibilities:

• Created ETL process using Informatica 8.6 as per Technical Design Document. The source systems were ORACLE, Siebel, flat file and legacy systems; the targets systems were ORACLE, Siebel.
• Implemented End-to-End different datawarehouing projects like RMS (Service Desktop Phase 1,2,3, & 4), worked on Mutual fund Projects, and Telephone Revenue reports.
• Created various active and passive transformations like Source Qualifier, Lookup, Router, Normalizer, Aggregator, Filter, Joiner, Expression and standard/reusable logic using Informatica.
• Developed, tested Stored Procedures, Cursors, Functions and Packages using PL/SQL for Data ETL.
• Extracted data from different external vendor source systems (oracle, mainframes, flat files, .csv files, XML files and DB2), transformed and loaded data into EIM tables from where loaded data into Siebel base tables using IFB files.
• Extracted data from XML files and loaded into Siebel Base tables.
• Created EIM process to load the data from EIM tables to Siebel base tables.
• Involved in designing and development of pre and post session routines and batch execution routines.
• Used debugger and breakpoints to view transformations output and debug mappings.
• Tuned the mappings to enhance performance after the mappings functionality was validated.
• Created ETL process to generate XML files from Siebel Base tables using Informatica.
• Worked on configuring the Java classpath in the session properties while using third-party Java packages, built-in Java packages, and custom Java packages in a Java transformation and also in Java SDK Custom transformation.
• Used session partitions, dynamic cache memory, and index cache to improve the performance.
• Used Power Center Workflow Manager to create sessions, and also used various tasks like session, event wait, event raise, email to run with the logic embedded in the mappings.
• Created JCL's and Endeavor package to create and run the Jobs in all environments.
• Independently worked on configure/ run/ debug ETL process, DAC sequencing.
• Created documentation for the projects (TDD & SDLC) as per SOX compliance requirements.

Environment: Informatica 8.6, Oracle 9i-PL/SQL, SQL Loader, TOAD, JAVA, Siebel Call Center 7.7, DAC, UNIX, WINDOWS 2000/ XP, JCL.

Confidential, Chicago, IL May 2006 - Jan 2007
ETLDeveloper
Project:
Confidential, the 7th largest U.S. commercial insurance provider with more than 1 million business and professional customers throughout the world. CNA Information Technology (CNA IT) partners with the business to deliver innovative solutions and services that enable CNA to be a leading competitor in the insurance industry. The goal of CNA IT is to focus on projects that deliver maximum business value and help the enterprise realize sustained profitable growth. CNA IT has been using Informatica as a data integration platform from quite a long time because of its flexibility, ease of use, and industry leadership position.

Responsibilities:

• Created ETL processes using Informatica 7.1.2. The source systems were ORACLE and legacy systems; the targets systems were ORACLE.
• Created various active and passive transformations like Source Qualifier, Lookup, Router, Normalizer, Aggregator, Filter, Joiner, Expression and standard/reusable logic using Informatica.
• Developed, tested Stored Procedures, Cursors, Functions and Packages using PL/SQL forData ETL.
• Created Datamaps using Power Exchange to extract the data from mainframes using copybooks.
• Worked on Power Exchange CDC (Change Data Capture) to capture the real time data.
• Involved in designing and development of pre and post session routines and batch execution routines.
• Extracted data from DB2, Mainframes, EXCEL files and Relational databases and loaded into Oracle database and into XML files using Informatica.
• Used debugger and breakpoints to view transformations output and debug mappings.
• Tuned the mappings to enhance performance after the mappings functionality was validated.
• Used session partitions, dynamic cache memory, and index cache to improve the performance.
• Used UC4-Global for automatic scheduling of sessions.
• Used Power Center Workflow Manager to create sessions, and also used various tasks like session, event wait, event raise, email to run with the logic embedded in the mappings.
• Created documentation for the project.

Environment: Informatica Power Center 7.1.2, Informatica Power Exchange 5.2.2, Oracle 10g-PL/SQL, TOAD, DB2, Mainframes, Java, WINDOWS 2000/ XP, UNIX, UC4-GLOBAL Job Scheduler, SFTP.

Confidential, Birmingham, AL Feb 2005 - April 2006
InformaticaDeveloper
Summary:
Confidential, has always been a leader in the financial services industry and is over 12,000 employees strong. The scope of this Project is to capture the data from various data sources and to construct a data warehouse to maintain clients, customers' history and current data.
Data from Operational Source System was extracted, transformed and loaded into data warehouse using Informatica.

Responsibilities:

• Analyzed the specifications and identified the source data that needs to be moved to data warehouse.
• Extracted data from XML, flat files and oracle databases and loaded it into Oracle using Informatica 6.2.
• Developed number of Complex Informatica Mappings, Mapplets and Reusable Transformations to facilitate initial, weekly and monthly loading of data.
• Used workflow monitor to monitor the workflow and reviewed error logs that it generates for each session.
• Used parameters and variables at mapping and session levels to improve the performance of Mappings.
• Worked on Performance Tuning of various mappings and sessions to identify and remove Bottle Necks.
• Used Informatica PowerCenter workflow manager to create sessions, workflows and worklets to run with the logic embedded in the mappings.
• Used debugger to test the mappings and fixed the bugs.
• Documented functional specifications and other aspects for the development of ETL mappings used.

Environment: Informatica 6.2, Oracle 9i-PL/SQL, TOAD, DB2, WINDOWS XP, UNIX, Java.

Confidential, Hyderabad, India Jan 2001 - Aug 2003
Oracle Developer
Summary:
The main objective of this project is to provide the senior and the middle level management of the organization with a query reporting and analysis tool. The system provides analysis on Key Performance Indicators used in the Organization.
Responsibilities:

• Involved in the design of the overall database using Entity Relationship diagrams
• Designed and developed all the tables, views for the system in Oracle
• Developed Database Triggers in order to enforce complicated business logic and integrity constraints and to enhance data security at database level
• Created indexes, sequences, constraints and snapshots
• Designed and developed several complex mappings involving Lookups, filters, expressions, aggregators and Stored procedures.
• Wrote stored procedures and functions in PL/SQL
• Involved in developing interactive forms and customization of screens
• Helped in writing proposals, documentation and training
• Involved in building, debugging and running forms
• Involved in Data loading and Extracting functions using SQL*Loader
• Designing and developing forms validation procedures for query and update of data.
• Shell scripting for daily scheduled task using VI editor

Environment: Informatica 5, Oracle 8.0, SQL*plus, SQL*Loader, PL/SQL, Reports 2.5.

Confidential, Hyderabad, India Jul 1999- Nov 2000
Oracle Programmer
Summary: Shipment Management System was a comprehensive system for a large exports company. The company involved in exports and transportation of cargo both on sea and land across the globe. Provided an online "Help Service Counter" as a part of the project servicing.
Responsible for System analysis, understanding of business requirements, expertise in understanding the complete information flow, database concepts, Normalization and creation of Database objects.

Responsibilities:

• Developed Procedures, functions, packages and Triggers for enforcing the business rules using PL/SQL.
• Designed the user interface screens using Oracle Forms 4.5 and generated reports using D2K reports 2.5.
• Developed Program Libraries for storing of Procedures that were used frequently in the System and user security package, integration and user acceptance testing. Prepared technical documentation and user specification.

Environment: Windows, UNIX, Oracle 7.0, PL/SQL, Sql *Plus Reporting, Sql *Loader, Forms & Reports