Summary:

• Around 9 years of IT experience with expertise in analysis, design, development and implementation of Data warehousing and Business Intelligence applications using ETL and BI tools with Oracle, MS SQL server and Teradata databases on windows and UNIX platforms.
• Expert level experience in Data Integration and Data Warehousing using ETL tool INFORMATICA PowerCenter/PowerMart 6.x/7.x/8/9.0.1 (Source Analyzer, Warehouse Designer, Mapping/Mapplet Designer, Sessions/tasks, Worklets/Workflow Manager). Knowledge of Informatica tools Power Analyser, Power Connect, Data Mart, OLAP and OLTP.
• Highly proficient in Data Modeling retaining concepts of RDBMS, Logical and Physical Data Modeling and Multidimensional Data Modeling Schema (Star schema, Snow-Flake Modeling, Facts and dimensions). Complete knowledge of data ware house
• Expert-level mastery in designing and developing complex mappings to extract data from diverse sources including flat files, RDBMS tables, legacy system files, XML files, Applications and Teradata.
• Proficient in implementing Complex business rules by creating re-usable transformations, workflows/worklets and Mappings/Mapplets.
• Experience in Performance Tuning for targets, mappings and sessions.
• Thorough knowledge of database management concepts like conceptual, logical and physical data modeling and data definition, population and manipulation. Expertise in logical and physical database design and Data Modeling using data modeling tools like Erwin.
• Experienced in using Business Objects 5.x/6.x to build user defined queries and reports to enable drill-down and slice and dice analysis on multiple databases. Thorough knowledge of Software Development Life Cycle including Planning, Analysis, Design, Implementation, and Maintenance.
• Strong expertise in Relational data base systems like Oracle, SQL Server, MS Access, TeraData and database development using SQL, PL/SQL, SQL PLUS, TOAD, SQL-LOADER. Highly proficient in writing, testing triggers, stored procedures, functions, packages, Cursors using PL/SQL.
• Experience in Task Automation using UNIX Shell Scripts, Job scheduling and Communicating with Server using pmcmd.
• Domain Data warehousing experience including Investment banking, Credit card, and Pharmaceutical. Proven ability to implement technology based solutions for business problems.
• Excellent analytical, problem solving, and communication skills, with ability to interact with individuals at all levels.

Education:

• M.Sc in Computer Science, India..
• Oracle Certified Associate (OCA) in oracle 9i.
• Informatica Certified Developer in 7.x

Technical Skills:

ETL Tools: Informatica Power Center 9.0.1/8.x/7.x/6.x/5.1(Source Analyzer, Data Warehouse designer, Mapping Designer, Mapplet Transformations, Workflow Manager, Workflow Monitor, Worklets) , Data Stage, Sap Informatica Power Connector.
Analysis/Reporting Tools: Business Objects 5.2.1/6.1b/XIR2, Micro strategy 7.2.4. Web Intelligence 2.6/6.x and Informatica Power Analyzer.
Databases: Oracle 9i/8i, MS SQL Server 7.0/2000, DB2, Teradata, MS Access, Excel.
DB Tools: SQL*Plus, SQL* Loader, TOAD.
Environments: Sun Solaris, UNIX, HP-UX, IBM-AIX, WINDOWS XP/NT/ 2000/98/95.
Languages: C, C++, SQL, PL/SQL, T-SQL, UNIX, Shell Scripting, Visual basic, , XML Data Modeling: Visio.

Professional Experience:

Confidential Nov'10 to till date
Senior Informatica developer
Description: Siebel - RMS (crm) data Integration : Aim of the project is to integrate all the master data elements like customer, Vendor, products, contracts, Territory and organization information from various Nationwide segments like Nationwide Insurance and Nationwide Financial data into Siebel CRM (RMS) system. It is a alone hub have all information about particular Customer, Producers etc.

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.
• Developed, documented and executed unit test plans for the Informatica jobs.
• Extensively worked on the Informatica Designer Workflow Manager and Workflow Monitor
• Created pre-session and post-session shell scripts and mail-notifications
• Employed performance tuning to improve the performance of the entire system
• Used Netezza, Oracle for Data loads.
• Ensured the Business Rules and Data Validation
• Developed Stored procedure to use in Pre and Post SQL command to archive drop of Stage tables.
• Implemented change detection process to send only incremental loads
• Responsible for maintaining different process documents like mapping status document, Issue log, Defect detection log etc.

Environment: UNIX, Windows XP, Informatica 9.0.1, Oracle 10g, Netezza, Toad, MS SQL.

Confidential Nov'09 to Nov'10
Senior Informatica developer
Description: Customer Service Management
The scope of the project was to provide Case Management capabilities for HSCS Contact Centers in Radcliff and Little Rock, AR in the Pharmaceutical Distribution Centers and Sales. The support centers handle Pharmaceutical and Medical equipment related calls. These centers are hubs for customer interactions; while peripheral units such as Distribution Centers, FSS, Sales, etc form a support mechanism to cases opened by the CSR (Customer Support Representative).Existing environment did not have Case Management solution. This results in severe lack of communication between CSR's and a Case Management solution across the board between different business units eliminated the communications gaps between various teams and help to improve the customer level interaction.

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.
• Developed, documented and executed unit test plans for the components
• Extensively worked on the Informatica Designer, Workflow Manager and Workflow Monitor
• Created pre-session and post-session shell scripts and mail-notifications
• Employed performance tuning to improve the performance of the entire system
• Used Teradata Mload in Data loads.
• Ensured the Business Rules and Data Validation
• Developed Stored procedure to use in Pre and Post SQL command to archive drop of Stage tables.
• Implemented change detection process to send only incremental loads
• Implemented SAP/R3 tables extraction and SAP BW load mappings.
• Supported 24/7 support for warranty period.
• Responsible for maintaining different process documents like mapping status document, Issue log, Defect detection log etc.

Environment: UNIX, Windows XP, Informatica 7, Oracle9i, TeraData 6.2.2, Toad.

Confidential Apr'07 to Oct'09
Senior Informatica developer & Support Analyst
Description: SFA (Sales Force Automation)
Cardinal Sales force automation (SFA) software is a SAP program that automates business tasks such as inventory control, sales processing, and tracking of customer interactions with territories, as well as performance. Informatica is used to pull data for SFA from Various Business Units across Cardinal. Informatica jobs developed to create a flat files for various interfaces like Customers information (MDM), Territory Management for accounts & Employees from BU's, Sales information from Data marts , Territory X-Reference information and Products information (MDM) which can be easily load to SAP CRM and SAP BI Interfaces.

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.
• Translated requirements into business rules & made recommendations for innovative IT solutions
• Worked with the various enterprise groups to document user requirements, translate requirements into system solutions and produce development, testing and implementation plan and schedule.
• Used transformations like Joiner, Expression, Connected and Unconnected lookups, Filter, Aggregator, Store Procedure, Rank, Update Strategy, Router and Sequence generator.
• Developed, documented and executed unit test plans for the components
• Collected performance data for sessions and performance tuned by adjusting Informatica session parameters.
• Created pre-session and post-session shell scripts and mail-notifications.
• Involved in analyzing scope of application, defining relationship within & between groups of data
• Employed performance tuning to improve the performance of the entire system.
• Worked with the various enterprise groups to document user requirements, translate requirements into system solutions and produce development, testing and implementation plan and schedules
• Ensured the Business Rules and Data Validation.
• Developed Stored procedure to use in Pre and Post Sql command to archive & drop of Stage tables.
• Used TOAD to verify data loads.
• History updates for new enhancements.
• On call Support provided when productions issues arises.
• Extended support for Data issues with Business.
• Extensively worked on the Informatica Designer, Workflow Manager and Workflow Monitor.
• Implemented change detection process to send only incremental loads for Customer, Territory Managements and Employee.

Environment: UNIX UP-UX, Windows XP, Informatica 7.1.2 (Power Center), Oracle9i, Veispan Toad, Sap R/3, And BW.

Confidential, Lake Forest, CA June'06 to Mar'07
ETL - Informatica Developer
Description: This project maintains the Products, Property, Accounts, Brokers, Exception values and transaction detail information. LBMLOS has XML sources called payloads. Data is extracted and transformed from various system landing, STGM, RPTDM, flat files and XML sources loaded into various Data Marts using data model using INFORMATICA. The data transformations is done at Pre stage , Stage and finally data load into Data mart, HI, RL, GM. HI, RL and GM Data for downstream Applications.

Responsibilities:

• Actively involved in designing and developing of Extraction, Transformation and Loading Process.
• Scheduling meeting with the business users to gather the business analysis reporting requirements.
• Involved in designing and creating mappings and mapplets using informatica source, warehouse, and transform and mapplet designers.
• Scheduling the workflows using informatica scheduler as per business needs.
• Enhancing the data mart as per business needs.
• Ftping the XML files to source directories.
• Recovering the failed sessions.
• Involved in writing Unix parameter files for informatica jobs
• Creating trigger file to create indicator files for continues workflows using command task.
• Used all transformations such as Expression, Filter, Router, Update, Union, Lookup, Rank, Connected Stored Procedures, Aggregator, and Sequence Generator. Sorter, Joiner Transformation.
• Maintained both development and production environments since a long time using Power Center, Oracle (PL/SQL) under Unix and NT. Monitoring the load jobs, checking the error log files for regular load and interacting with users were my primary focus areas

Environment: UNIX UP-UX, Windows XP, Informatica 7.1.2 (Power Center), Oracle9i, Veispan and Toad.

Confidential, Parsippany, NJ Apr '04 to Jun '06
ETL - Informatica Developer
Description: The goal of this project is to enhance and automate the current manual MS Access based Agent Productivity Tracking System (APTS). This project is divided into 4 tracks. The goal of the tracks is to build the new dimensions, fact and mini fact tables for Agent and its hierarchies in operations data mart based on the data available in Total view (APTS application). These dimension data can be linked with Central Reservation System booking data already available in Operations data mart to produce booking reports using INFOXCHANGE and these tables will be used for all other tracks of this project.

Responsibilities:

• Involved in taking requirements from business users
• Interacted with SBA's to understand the feasibility.
• Prepared ETL Design Documents.
• Created the Informatica Mappings, Sessions and workflows.
• Scheduled workflows using Informatica scheduler.
• Created alert mails to support group in case fails.
• Configuration sources, targets.
• Ensured the Business Rules and Data Validation.
• Involved in writing Unix parameter files for informatica jobs
• Creating trigger file to create indicator files for continues workflows using command task.
• Used all transformations.
• Enhanced the existing Dimensions and Fact tables.
• History updates for new enhancements.

Environment: UNIX, Windows XP, Informatica 7.1.2 (Power Center), Oracle9i, DB2 UDB.

Confidential- Bristol, UK Jun' 03 to Apr' 04
BI - Business Objects Developer.
Description: Process receives accounts for processing, from various sources such as Mainframe Queues in FDR & GE - Host session, File-Net & Emails. All the records received irrespective of source reprocessed on the mainframe One of the process associates downloads the records from the mainframe manually and consolidates the work queues into an excel sheet. The records are downloaded on the daily basis for all the queues and reports some are except for reports for which reports are downloaded on a weekly basis. These records, which are downloaded, are distributed to associates based on simple rule i.e., called “EQUAL DISTRIBUTION”. Each user is trained to work on all the queues. Currently, there is an application tool being used by the process for scraping the records from Queues and doing equal distribution of work for the associates. This does not take care of all the queues handled by the process. Prioritization and Allocation in the Absence of the team member are not taken care of. Associates access the respective mainframe queues to work on the records. After processing, user will either PEND a record or RESOLVED it. Associate after processing a record will put the query in a PENDED state, if there is not enough information available on the mainframe to process it. Once the resolution from the client is received, the associate accesses the Pended record and processes it, otherwise s/he will put it back in PEND state. After processing of any record user will go the web tool and update it for the record.

Responsibilities:

• Involved in taking requirements from business users and project planning
• Deployment of Business Objects on clients as well as server products
• Developed Universe using Designer module in Business Objects
• Developed and created classes with Dimension, Detail & Measure Objects and specified the hierarchies
• Specified the Joins and checked the cardinalities
• Resolved loops by creating Aliases
• Performed the Integrity check and finally exported to the repository
• Ad-hoc reports were used for Business Objects User modules for various Portfolios using the Universes as the main Data Providers
• Involved in Creation of Tables, Views, Database Links and Stored Procedures
• Created thin/full client reports using Web Intelligence

Environment: Windows 2000, Oracle9i, Business Objects 5.1.2, WebI 2.6

Confidential Bristol, UK Nov' 02 -June' 03
Role: BI/ Business Objects Developer
Description: Workshop Management System is developed for UMP & Strategic Enhancements of Automobiles and Locomotives. The objective of this Data Warehousing project is to enable effective decision-making on the level of inventory to be maintained in the workshop, minimizing the storage cost. Data is available in from of Oracle, MS Access and Excel. The data is extracted and loaded into Oracle by using Informatica. Predefined performance reports are built using Business Objects; universes built using Designer including predefined conditions. Created OLAP System (Star Schema) Using Designer module in Business Objects. Adding Drill down/Drill up capabilities to the Universe. Created List, Cross tab reports.

Environment: Business Objects 5.1, Oracle 8i, Windows 2000.

Confidential, Bristol, UK Jan' 02 - Oct' 02
ETL - Informatica Developer
Description: Confidential is a privately held company providing home infusion services, clinical respiratory services, home medical equipment, home health services and specialty pharmacy services in the European country. “Inveresk” was developed for Inveresk healthcare to project their Services, Goals, available resources and suggestions. It provides a report of the current and future financial situation/needs based on the information received from the Data Warehouse.

Responsibilities:

• Designed the data-warehousing database.
• Prepared ETL and Reporting Design Documents.
• Created the Informatica Mappings, Sessions and Batches.
• Configured sources, targets.
• Ensured the Business Rules and Data Validation.

Environment: Informatica - Powermart 5.0 (source analyzer, Data warehousing Designer, Mapplet, Transformations), Business Objects 5.1, Windows NT Server 4.0, Oracle 8i, Windows 2000.