Summary:

• Over 9 years of work experience in Database Design, Coding and Testing of various Oracle DWH Projects. Complete understanding of Software Development Lifecycle and Core area of experience in to validate end-to-end business scenarios of B2B (Business to Business) applications, Enterprise Applications developed expertise in Informatica, Business Objects, Oracle SQL and Forms and Reports in Banking, Insurance and Supply Chain Domain Applications
• Detail-oriented Database Development with experience in leading teams working on concurrent projects to an on- time within budget resolution.
• Committed to team environment dynamics with the ability to contribute expertise and follow leadership.
• Strong Interpersonal, organizational skills and ability to interact effectively and efficiently with Project Managers, Client Managers and stake holders to complete the job in time.

Technical Summary:

• Solidexperience in Data warehousing field specifically Data Modeling, Informatica Power Exchange / Power Center and Cognos BI.
• Experience in Financial and Health Care Domains.
• Expert in Creating Data Models with Kimball and Bill Inman methods.
• Experienced indevelopment and providing supportfor major as well as minor releases Solid experience in analyzing and fixingProduction issuesin the current Informatica Applications and back end applications.
• ExcellentData Modeling, Analysis, Data Miningskills.
• Designed STAR Schema, created PL/SQL Procedures, functions, Triggers, generated reports using Business Objects.
• Used Informatica to extract data from Legacy systems to Staging to ODS using Informatica Transformations with in mappings.
• In-depth understanding of Data warehousing concepts such asKimball’s methodology, OLAP, SCDs (type1, type2 and type3), starschema and snowflake schema
• Expert in Oracle database servers 7.x/8.0/8i/9i/10g/11g
• Strong programming and debugging skills inPL/SQL, SQL and Unix shell scripting
• Experienced in developing complex Pl/Sqlpackages, procedures, functions, triggers, views.
• In-depth understanding ofObject Oriented Programming concepts
• Experienced increating Data Modelsusing data-modeling toolErwin
• Experience with Oracle Designer for data modeling
• Extensive experience in entireSDLC
• Proven track-recordin trouble shooting of database applications

Technical Skills:

Programming Languages: SQL Scripts, UNIX programming, VB Scripts
Testing Tools: Mercury Quick Test Professional 9.2, BPT with QTP8.2, WinRunner8.2
Test Management Tool: Quality Center 9.2
Databases: Oracle 8i/9i,10G, SQL Server 2008.
Software: TOAD, PL/SQL Developer, Forms4.5
ETL Tools: Informatica5.x/6.x/7.x/8.0, AbInitio
Reporting Tools: Business Objects, SQL Reports, D2k Reports
Desktop Languages: Windows98/2000/XP/7, Ms Office (Word, Excel, Access, PowerPoint)

Professional Experience:

Confidential, Alpharetta, GA
Datawarehouse Consultant

Client: Confidential, London, UK Aug 2008 to Till Date
Environment: PL/SQL, Oracle 9i, Toad, DB2, SQL Server 2005, Informatica 8.0, Ab Initio, Teradata, Business Objects, .Net,Unix,Chron(Jobs).

Confidential, has different departments, under which Sales and Central belongs to Ab Initio development projects to extract data from multiple source systems and to produce reports for end users and business stake holders like Guaranteed funds movement, Transitional arrangements, Master Agent fixes, Data Scrambling of Sensitive production data, FSA Manual Submission, FSA Improvements, Protection and Annuity reinsurance and wealth management information. The different modules within the scope under this engagement are Ab Initio, BI, BO, Teradata, .NET and SQL. It is managed from both on-site and off-shore.

• Designed the ETL processes using Informatica to load data from DB2, Flat Files(Fixed Width), and Excel files to staging database and from staging to the target Data Mart.
• Involved in cleansing and extraction of data and defined quality process for the warehouse.
• Implemented the best practices for the creation of mappings, sessions and workflows and performance optimization.
• Developed standard and re-usablemappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup Connected/Unconnected, and filter.
• 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.
• Involved in performance tuning of the mappings,sessions and workflows.
• Query Optimization for improving the performance of the data warehouse.
• 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.
• Used session parameters and parameter files to reuse sessions for different relational sources or targets.
• Created documentation on mapping designs and ETL processes.
• Maintain Development, Test and Production mapping migration Using Repository Manager.
• Documented ETL test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for unit testing, system testing, expected results, preparing test data and loading for testing, error handling and analysis.
• Involved in Unit testing, User Acceptance Testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
• Involved in production support working with various mitigation tickets created while the users working to retrieve the database.
• Understand the requirements from the Functional specifications.
• Closely interacted with the Client and Functional consultant as creation of Technical Design Document.
• Created PL/SQLStored procedures, packages, functions for data upload, bulk loading, Incremental loading.
• Created Triggers to capture the Data manipulation transactions on the Fact tables and Fact history tables.
• Implemented the best practices of SQL usage within the project to improve the performance of the SQL.

Client: Confidential, Munich, Germany Nov 2007 to Jul 2008
Environment: Oracle9i, PL/SQL Developer, Informatica 6.2, Business Objects 5i,Unix.
Infineon Technologies is divided intoQimonda Memory products & Infineon Semiconductors. Qimonda is looking forward to implement solver-based solution that handles more complexities in the memory products business with relative ease. The new solver based solution removes most of the manual work being done by planners currently and also handles varieties of Business scenarios currently not handled. The new solution includes DPL (Demand Planner) and IPL (Inventory Planner),MPL (Manufacturing Planner), and SPL (Sales and Operations Planner), which has micro-details in terms of time and Business scope. The project involves the analysis, design, development, and testing using i2 SCM Product. It involves the data migration from Infineon database to Qimonda and from Qimonda to staging database and carrying out the data transformation at staging and loading the data into ODS, from where the i2 applications will use the data.

• Understand the functionality of the existing system.
• Extract the data modeling and the business rules, which are being used.
• Designed STAR Schema for Memory Products of Sales and Operations Plan Data Ware House
• Development of oracle PL/SQL functions and procedures to Populate the Dimension and Fact table of STAR Schema
• Designed Entity Relationship (E-R Diagram) diagrams for Memory Products Sales and Operations Planning Reporting Module using Oracle Designer
• Technical Design documentation for Sales and Operations Planning Reporting Module.
• Prepared Release Documentation for Sales and Operations Planning Reporting Module.
• Suggest functionality enhancements in the existing system.
• Design of the data migration between the Demand Planning and staging schema through ETL Tool Informatica to improve the speed and quality of loading process.
• Design of data migration between Operational Data Store and Sales and Operational Planning Staging schema through Informatica to improve the speed and quality of loading process.
• Used Informatica Transformations while creating the mappings to load data from one schema to other schema
• Used mapping variables, session variables while creating mappings and Sessions.
• Used Work flow manager for sequential and parallel loading of data from logistics database to staging to Target Database.
• Given guidance to end users during the Installation of Business Objects 5i for Sales and Operations Planning module.

Confidential, Singapore Dec 2004 to Oct 2007
Database Engineer – (Database Developer, PL/SQL Programmer, Data Analyst)

Client: Confidential, Norwich Union, UK Feb 2007 – Oct 2007
Environment: PL/SQL, Oracle 9i, Toad, DB2, SQL Server 2005, Informatica 8.0, Ab Initio, Teradata, Business Objects, .Net,Unix,Chron(Jobs).

Confidential, has Billing and Collections department. Billing and Collections (B&C) is a part of SIP (Single Insurance Platform) Program and involves implementation of a B&C function for Personal lines business in NUGI. The Scope of the project is to deliver Accounts Receivables, Cash Management and Advance Collections functionality to NUI along with Payables for Refund and General Ledger for Financial Reporting and to deliver the interfaces with Policy Admin Systems, Credit Card authorization systems and Direct Debit System.

• Understand the requirements from the Functional specifications
• Development of oracle PL/SQL functions and procedures to carry out the data transformation for Account Receivable and Financial Reporting Module
• Technical Design documentation for Account Receivable and Financial Reporting Module.
• Involved in Build activities of Account Receivable and Financial Reporting Module
• Prepared Release Documentation for Account Receivable and Financial Reporting Module.
• Providing technical support to the onsite team.
• Leading the technical team and involved in the performance evaluation of the resources
• Suggesting functionality enhancements in the existing system.
• Preparation of Unit test cases, Integration test cases
• Uploading the test cases into Quality Center.
• Executing the test plan and completing the same in number of cycles.
• Defects logging using Quality Center
• Defects Reporting using Quality Center Live analysis.
• Sharing the Project Progress with All Stake holders on weekly basis.
• Played a challenging role as build manager.

Client: Confidential, Milwaukee, WI Oct 2005 to Dec 2006
Environment: Oracle Apps 11.5.10
The Project involved in automation of the GEHC Test Cases with the help of Business Process Testing [Mercury] for OPM module. It involved creation of reusable components in Quick Test Pro 8.2 and designing of the Test Cases as per the requirements.

• Understand the requirements from the Functional specifications
• Development of oracle PL/SQL functions and procedures for OPM Module
• Building of custom based Forms for OPM Module.
• Technical Design documentation for OPM Module.
• Involved in Production support activities on urgent basis to resolve the L1 (Priority) tickets.
• Providing technical support to the onsite team.
• Preparation of Unit test cases, Integration test cases
• Uploading the test cases into Quality Center.
• Executing the test plan and completing the same in number of cycles.
• Defects logging using Quality Center
• Defects Reporting using Quality Center Live analysis.

Client:Confidential, Singapore Jan 2005 to Sep 2005
Environment: JAVA, Oracle 8i, DB2

Touch point Suit of customer interaction solution is available in modules which help financial institution to enhance sales and service through all delivery channels including branch, contact center, the internet and through your network of relationship managers. Teller is one of the modules which compliments the traditional teller needs by automating all monetary transactions, inquiries and administrative functions while providing a reliable store-and-forward environment to ensure transactions are not lost. It also addresses governmental issues with an enterprise-wide Currency Transaction Report (CTR) system that aggregates cash in and cash out transactions across the entire organization. It incorporates customer and account servicing, sales and branch management functions in an intuitive desktop design and Delivers “careful efficiency” that enables fast monetary transaction processing and thorough customer sessions on the same desktop, provides single window work area.

• Understanding the Business Requirements.
• Preparing the Technical Design Document/Low Level Design Document as per the High Level Design Document
• Created PL/SQL Procedures, Functions
• Created one time SQL scripts to execute in PRODUCTION for data correction
• Created Database Triggers, indexes.
• Created and used External Tables
• Involved in SQL Performance tuning.
• Created unit test cases and Integration test cases.

Confidential, (San Infotech, Singapore) Apr 2004 - Dec 2004
Backend (Oracle) Developer
Environment: Visual Basic 6.0 with Oracle 8i and Windows 2000
Resource Digit will provide information to track any of the guests in clubs. Resource Digit will provide the complete solution for the need of small medium accommodation management. It is designed for front desk to handle reservation, track guests, and preparing invoice and generate confirmation letters.

• Understanding the Business cases
• Gathering the requirements as per Scope of project
• Preparing the Technical Design Documents for the given requirement
• Developing PL/SQL Stored procedures to upload the data from Staging DB to Target DB
• Creation of AFTER and INSTEAD OF Triggers for INSERT/UPDATE and DELETE transactions on FACT Tables
• Preparing the SQL scripts to execute the Test Cases
• Performed UNIT Testing, INTEGRATION Testing
• Involved in Business Acceptance Testing and User Acceptance Testing.
• Interaction with the client managers, project managers as and when required.

Confidential, Bangalore, India Aug 2001 - Feb 2004
Oracle DW Developer
Environment: Informatica 6.2, Business Objects XI, Oracle Designer 6i, RCS, Microsoft Visio, SQL, PL/SQL, SQL Loader, Shell Scripting

Infineon is looking forward to upgrade from its current strategy- based to solver-based solution that handles more complexities in the Semi conductors business with relative ease. The new solver based solution removes most of the manual work being done by planners currently and also handles varieties of Business scenarios currently not handled. The upgrade is from SCM suite version 4 to 6.1. The proposed new solution includes Demand Manager (DMAN) and Corporate model (CM), DM(Divisional model) for Operations and Manufacturing and FM(Facility model) which has micro-details in terms of time and Business scope. The project involves the analysis, design, development and upgrading the existing i2 modules

• Development of oracle PL/SQL functions and procedures to carry out the data transformation for Corporate Model, Demand Manager applications
• Designed Entity Relationship (E-R Diagram) diagrams for Corporate Model, Demand Manager, Reporting using Oracle Designer
• Preparation of Technical Design documents for Corporate Model, Demand Manager.
• Prepared Release Documentation for Corporate Model, Demand Manager.
• Providing technical support to the onsite team.
• Extract the data modeling and the business rules, which are being used.
• Understand the functionality of the existing system.
• Suggest functionality enhancements in the existing system.
• Extraction of data using Informatica from Demand Manager to Staging schema, the Corporate Model to staging schema and from Staging to ODS to facilitates migration of data across the systems with high level of accuracy and speed.
• Involved in Installation of Informatica,Business Objects, ODS, Oracle.
• Trained the Client team on the enhanced.
• Prepared UNIX shell scripts for automation

Confidential, Bangalore, India May 2000 - Apr 2001
Oracle Developer
Environment: Oracle8i, Developer 2000 Forms and Reports, Window98/NT Dates

Nutrine Confectionery Ltd was using for inventory ,Sales an adhoc system which was replaced by inhouse development of Inventory module, Sales module on oracle 8i and user reports where generated by using Oracle reports.

• Understanding the Requirements
• Writing PL/SQL Stored procedures, functions for Inventory Module
• Creation of Database Triggers for Sales Module.
• Designing user entry Screens and Writing Event driven Programming in Forms 2.5
• Creating Reports like Master/Detail, Matrix etc using Reports 2.5
• Involved in Design of database schema with DBA