Summary:

• Over Seven years of experience in analysis, design, development, testing and deployment of mission critical software applications using Oracle, PL/SQL, SQL, Business Objects (Designer, Web Intelligence, Supervisor),Informatica 9/8.x/7.x.
• Extensive experience in Data warehousing, Data Analysis, Reporting, ETL, Data Modeling, Development, Maintenance, Testing and Documentation.
• Involved in functional and technical system analysis & Design, System Architectural design, Presentation, process data flow design, system impact analysis, Gap analysis and documentation.
• Experience in the development of data warehouse, data mart and transactional models.
• Proficiently rendered services in Informatica ( Power Center Tools and Metadata Reporter), Oracle 10g/9i/8i, SQL, PL/SQL, Oracle Warehouse Builder, SQL Server and Analysis Services
• Expertise in deriving Analytical, Logical, Physical, Dimensional and Statistical Data Models.
• Expertise in Web Intelligence and Business Objects such as Supervisor, Designer and Reporter.
• Involved in Unit Testing, Integration testing and Performance Testing.
• Experienced in interacting with Business users, Business Analysts, IT leads and developers in analyzing business requirements and translating requirements into functional and technical design specifications.
• Expertise in creating databases, schema objects, optimizing SQL statements.
• Has very good analytical, communication and inter-personnel skill.

Education Qualifications:

Bachelors of Computer Science Engineering

Professional Experience:

Confidential,CA Feb 2011 to Till Date
ETL / Informatica Developer

Plantronicsis world leader in producing audio communications equipment for business and consumers. It is a publicly held company (NYSE: PLT) headquartered in Santa Cruz, California with offices in 20 countries, including major facilities in China, England, Mexico, and the Netherlands. Our products are sold and supported through a worldwide network of Plantronics partners, including resellers, systems integrators, retailers and mobile carriers .This project is intended to provide the developers with the design, which will be used to build Informatica and test the ETL components required.This includes Informatica mapping design, data transformation, field-level data mapping and derivation rules.

Responsibilities:

• Involved in the Design, Development, Testing phases of the Data warehouse
• Analysis, Requirements gathering, function/technical specification, development, deploying and testing.
• Formalization of user requirements and creation the formal subject area description based on functional sets and binary adjacency matrixes, functional specs and technical specs, metadata for the data warehouse, database naming convention and PL/SQL coding convention using Microsoft Word, Excel.
• Involved in Design and Data Modeling using the Star schema.
• Logical database modeling using Erwin includes definition of business entities and their relationships.
• Logical & Physical Database Layout Design. Created Informatica mappings for initial load and daily updates.
• Extensively used Transformations like Lookup, Router, Aggregator, Normalizer, Source Qualifier, Joiner, Expression, Update Strategy etc.
• Modified mappings as per the changed business requirements.
• Developed mapplets and worklets.
• Generated flat files using Informatica power center.
• Designed reusable transformations and shortcuts to share different mappings.
• Developed, tested Store procedures, Functions and packages in PL/SQL for Data ETL.
• Performed Data conversions.
• Involved in fixing, testing of store procedures and functions, unit and integration testing of Stored Procedures and the target data.
• Designed Audit Strategy to audit the data between Source System, Target System and Other Parallel Reporting Systems.
• Designed Security Strategy to ensure the restricted access to the Users based on their profiles.
• Involved in troubleshooting the load failure cases, including database problems.
• Analyzed the query performance and designed the load process schedules.
• Involved in Performance Tuning including queries generated by Siebel Analytics.
• Involved in Bug Fixing and P1 Issues.
• Involved in Production Deployment and Support.

Environment: Oracle 10g, SQL, PL/SQL, XML, Informatica 9/8.6, OLAP, AIX, UNIX, TOAD, Flat file and XML Sources.

ETL Developer
Project: Portfolio Management DW

Citi Bank is one of the leading Financial Service Company which includes trade life cycles in the USA, with $ 280 billion in assets and over 24 million customers. This data warehouse is developed for Auto Finance Group, involved in loans and leases of new and pre-owned cars. Citi Bank maintains its huge operational databases on a variety of platform. The data from various sources is Extracted, Transformed and Loaded into OLAP using Informatica. Business analysis reports were generated using OBIEE and deployed on intranet web.

Responsibilities:

• Involved in the design, data modeling, development and testing phases of various projects and enhancements.
• Analysis, requirements gathering, functional/technical specification, development, deploying and testing.
• Created Informatica mappings for initial load and daily updates.
• Extensively used Transformations like Lookup, Router, Aggregator, Normalizer, Source Qualifier, Joiner, Expression, Update Strategy etc.
• Modified mappings as per the changed business requirements.
• Developed mapplets and worklets.
• Generated flat files using Informatica power center.
• Designed reusable transformations and shortcuts to share different mappings
• Developed, tested Store procedures, Functions and packages in PL/SQL for Data ETL
• Developed shell scripts for job scheduling and logging.
• Informatica Metadata Reporter installation and Configuration
• Generated Reports using Metadata Reporter
• Reports were developed and enhanced using Business Objects and Web-Based reports using Web-Intelligence .
• Created Universes, Groups, Users and gave privileges using Supervisor.
• Debugging the BO reporting problems and providing the solutions.
• Created Aliases and Contexts to resolve loops.
• Day-to-Day Production support.
• Recovering failed jobs.
• Issue permanent Resolutions.
• Root Cause Analysis and Fixing mapping problems.
• Involved in the new server migration.
• Oracle Performance Tuning.
• Tuning of Informatica mappings.

Environment: Oracle 9i, Informatica 8.6, Business Objects , PL/SQL, ERWin, TOAD and HP Unix

ETL Developer
Project: WW Bookings (Enterprise Bookings) Program

WW Bookings (Enterprise Bookings Cubes) were designed for Sales Finance Analysts. JMP required Multidimensional Reporting of Orders, Forecast, Opportunity/Commit Management Data, Sales Channel Information, Conditional Sales and Backlog tracking on Ad –Hoc basis by various dimensions like Sales Hierarchy, Technology Market Segments, and Customer Market Segments.

Responsibilities:

• Interacted with the investment brokers, advisors, analysts and account executives and understood the business requirements by analyzing and defining key issues related to the earlier work system.
• Involved in the design, data modeling, development and testing phases of various projects and enhancements.
• Analysis, requirements gathering, functional/technical specification, develop -ment, deploying and testing.
• Logical & Physical Database Layout Design. Created Informatica mappings for initial load and daily updates.
• Created Informatica mappings for initial load and daily updates.
• Extensively used Transformations like Lookup, Router, Aggregator, Normalizer, Source Qualifier, Joiner, Expression, Update Strategy etc.
• Modified mappings as per the changed business requirements.
• Developed mapplets and worklets.
• Generated flat files using Informatica power center and extracted XML and Flat file Designed reusable transformations and shortcuts to share different mappings.
• Implemented Slowly Changing dimensions Type 1, Type 2, and Type 3 methodology for accessing the full history of accounts and transaction information.
• Developed, tested procedures, Functions and packages in PL/SQL for Data ETL
• Developed shell scripts for job scheduling and logging.
• Informatica Metadata Reporter installation and Configuration
• Generated Reports using Metadata Reporter
• Created Aliases and Contexts to resolve loops.
• Day-to-Day Production support.
• Involved in fixing, testing of store procedures and functions, unit and integration testing of Stored Procedures and the target data.
• Developing Unix shell scripts and scheduling Unix Scripts by using scheduling tools.
• Worked with end users to develop and collect feedbacks in the User Acceptance Testing (UAT)
• Involved in Production Deployment and Support.

Environment: Oracle 9i, Informatica 8.1, PL/SQL, ERWin, TOAD, XML and Flat file Source Data and HP UNIX, AIX

Confidential,NewDelhi, INDIA Jan 2006 – Sept 2007
PL/SQL Developer
Project: Indian Customs EDI System (ICES)

National Informatics Centre (NIC) of the Department of Information Technology provides network backbone and e-Governance support to Central Government, State Governments, Administrations, Districts and other Government bodies. ICES is a software package which accepts customs documents electronically from the Custom House Agents, Importers and Exporters for processing by the customs officers. The Bills of Entry and Shipping Bills can be submitted by EDI in the service center which is a facility for further processing.

Responsibilities:

• Created database objects such as tables, views, indexes, sequences using Oracle8i
• Developed PL/SQL stored procedures, functions and packages in TOAD
• Created PL/SQL program units to include DML, DDL statements using dynamic SQL
• Fine tuned procedures for maximum efficiency in various schemas across databases using Oracle Hints, execution plan
• Optimized and tuned PL/SQL subprograms to reduce the loading process
• Trapped errors such as INVALID_CURSOR, VALUE_ERROR using exception handler
• Developed row level and statement level triggers for auditing tables in PL/SQL
• Created partitions on the tables to improve the performance
• Wrote complex SQL queries to retrieve information from the databases depending on the requirement
• Generated sequences that can be shared by multiple users to generate unique integers
• Implemented PL/SQL scripts in accordance with the necessary business rules and requirements
• Wrote complex queries involving multiple-joins to generate user reports
• Participated in the ongoing process enhancements and modification requests
• Used UTL_FILE package to check if the flat file existed before the SQLLDR script was executed, and also to check the log file to find the number of bad row inserts
• Developed scripts in UNIX for daily backup using Cron tab
• Coordinated with the offshore support team in resolving critical issues
• Tested, installed, documented and provided on call support for the applications

Environment: Oracle 8i, SQL, PL/SQL, SQL*Plus, PL/SQL Developer, TOAD 8.0, UNIX, Shell programming