SUMMARY:

• ORACLE certified professional with 12+ years of hands - on experience in Oracle PL/SQL, DataModeling, Datawarehouse, ETL-Design, Informatica PowerCenter9.x, SSIS, SSRS and Oracle Forms & Reports.
• Strong Customer interaction skillsand excellent expertise in Requirements gathering, Analysis, Estimation and Resource Planning.
• Pretty good exposure in database design and extensive hands-on in handling ORACLE packages, collections, dynamic SQL, cursors, db links, Materialized view etc.
• Highly proficient in Oracle SQL Query Performance maintenance - tuning and PL/SQL optimization using SQL Trace, Explain Plan, Indexing and Hints.
• Highly skilled and shown eminence inall phases of a Software Life Cycle - Requirements, Analysis, Documentation, Design, Build, Testing/ Support and Comprehensive Deployment Planning.
• Sound Techno-Functional expertise in dealing a variety of Reporting Tools, Database Solutions and Business Problems.
• Extensively used SQL*Loader and EXP/IMP utility to load huge volume of data between databases and schemas.
• Participated in database administration activities like creation of database and database objects, users, privileges, data files, table spaces, storage allocation of various DB objects using TOAD, SQL*Plus etc.
• Involved in Data modelling activities like Generating Logical Design Model & Physical Design Model and ER Diagram using Microsoft Visio Tools and Erwin.
• Pretty good vertical experience in CRM, Life Sciences, Structure Finance, Materials, Production, Logistics.
• Involved in the data analysis for source and target systems. Pretty Good Knowledge in Data warehousing concepts, Business Intelligence, and Unix Shell Scripting and Scheduling Job Control-M.
• Experience in data extraction from heterogeneous sources usingInformaticaPower centerand SSIS.
• Experience working in agile delivery methodology.

TECHNICAL SKILLS:

Databases & Tools: Oracle 11g / 10g / 9i, PL/SQL, SQL*Plus, TOAD 9.6,SQL Server.

Programming Languages & Scripting: SQL, PL/SQL, Unix Shell Scripting.

ETL: Informatica8.6.0, SSIS,SSRS

Data Modelling Tools: MicrosoftVisio2010,ERWIN

Reporting Tools: Oracle Report 6i, Business Object 6.5.

Other Technical Skills: Oracle Apps 11i Technical

EXPERIENCE SUMMARY:

Confidential, Charlotte

Databases & Tools: Oracle 11G, PL/SQL, SQL Server, Teradata, SSIS,SSRS

Responsibilities:

• Designing and Developing SSIS packages.
• Extensive experience with T-SQL in constructing Triggers, Tables, implementing stored Procedures, Functions, Views, Data Dictionaries and Data Integrity.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using DTS and SSIS services.
• Data Loading Experience in SQL Server 2008 using SSIS ETL and Experience in developing packages in SSIS and DTS according to task.
• Expert in creating simple and parameterized reports and also complex reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs using SSRS in Business intelligence development studio.
• Developed complex SSRS reports using multiple data providers, Global Variables, Expressions, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Built ad-hoc reports using SQL Server Reporting Services (SSRS).
• Used Package Configurations to make use of same SSIS package in Dev/Testing/Prod Environments
• Scheduled the SSIS packages to run at different intervals to load the data.
• Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
• Created many Drill through and Drill Down reports using SSRS
• Deploying SSRS reports through report manager.
• Working with offshore to communicate requirements and mentoring the team.
• Creating Change Request to deploy code in production.

Confidential, Charlotte

Databases & Tools: Oracle 11G, PL/SQL

Responsibilities:

• Interact with Client for requirements gathering, Analysis, design and development of Confidential Reporting System.
• Worked on Hive SQL scripts to load daily participant transactional data into Reconciliation database through Hadoop batch Process.
• Developed new PL/SQL program units such as procedures, functions and packages to implement the business logic.
• Developed complex SQL and PL/SQL queries to extract data from database and spooling data through shell scripts.
• Developed various Technical specification documents based on the Business specifications Documents.
• Partitioning Strategies for very large tables.
• Actively involved in code reviews and adopted PL/SQL best practices in our code base.
• Actively involved in Database Performance Tuning using EXPLAINS PLAN, SQL TRACE, TKPROF, AWR reports.
• Experienced in Identifying performance bottlenecks on high volume transaction systems and improved the performance.
• Analyze SQL statement; reorganize database objects and design indexes, Table Partition to improve response of queries.
• Manage User Acceptance Testing of new applications and new versions of existing applications.
• Manage the packaging and release of applications to the training, UAT and production environments.

Confidential, New York

Databases & Tools: Oracle 11G, PL/SQL, Unix, Informatica 9.6.1

Responsibilities:

• Involved in gathering business requirements and worked closely with Business Analysts to develop Data Model, ETL procedures to design Data Warehouse.
• Experience in writing functional specifications, translating business requirements to technical specifications, created/maintained/modified data base design document with detailed description of logical entities and physical tables
• Designed and developed schema model for target database using Erwin Data modelling.
• Used packages to load the base tables in the Oracle database from the flat file sources and XML sources.
• Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.
• Schedule and Run Extraction and Load process and monitor sessions using Informatica Workflow Manager.
• Involved in identifying bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs so that they conform to the business needs.
• Involved in analyzing, resolving and providing temporary fix for the Data issues Also he had to interact with the business users to intimate and do the recovery steps if there is any problem in the process

Confidential, Indianapolis, Indiana

Databases & Tools: Oracle 11G, PL/SQL, Unix, Informatica 8.6.0

Responsibilities:

• Involved in Architecture and Design of ETL Loading Strategy.
• Experience in Data Warehouse/Data Mart design, System analysis, Database design, ETL design and development, SQL.
• Prepared High level design (HLD), LLD, Project functional Specification Document and Business Requirement documentation (BRD).
• Involved in the Logical and Physical design and creation of the ODS and data marts.
• Implemented mapping techniques for Type 1, Type 2 and Type 3 slowly changing dimensions.
• Developed ETLs for Data Extraction, Data Mapping and Data Conversion using Informatica Power Center.
• Performing Informatica support activities. If the job fails analysis is performed to understand the root cause of the same and the corrective action is taken in order to ensure the load is resumed and completed successfully.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Performance tuning has been done to increase the through put for both mapping and session level and SQL Queries Optimization as well.
• Monitor and troubleshoot batches and sessions for weekly and Monthly extracts from various data sources across all platforms to the target database.
• Data Validation has been done for various sources to target mappings.
• Migrated ETL objects from DEV to UAT to PRD environments using Repository Manager.
• Monitoring the Oracle jobs and if the job fails, analysis is performed to understand the root cause of the same and the corrective action is taken in order to ensure the load is resumed and completed successfully.
• Performed analysis to understand the data issues by drilling down the logic behind the sql server procedures and packages which supplies the data.
• Has good understanding of Control M through which the jobs are scheduled to run.

Confidential, Chicago

Databases & Tools: Oracle 11G, PL/SQL, Informatica 8.6.0,Unix

Responsibilities:

• Involved in requirements gathering, Analysis, design and development of CCAR Reporting Database.
• Involved in interacting with business analyst to understand the functional requirements and convert them into technical specifications.
• Understanding the legacy system based on requirements and structuring the CCAR report ing Data model.
• Extensively used all the features of Informatica including Designer, Workflow manager and Repository Manager, Workflow monitor.
• Involved in analyzing the legacy system and mapping the entities between legacy reporting system and CCAR Reports.
• Designing the staging area structure for capturing the extracted business data from the legacy system.
• Created Complex mappings using transformation like Filter, Expression, Joiner, Aggregator, Router and Stored Procedure transformations for populating target table in efficient manner.
• Loading the data from legacy reporting system database to staging table using the extraction logic and transfer of data to CCAR Database interface table through SQL.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes for Staging and CCAR reporting table population using Informatica power center.
• Involved in performance tuning of mappings, transformations and sessions to optimize performance.
• Involved in loading different entities into CCAR reporting database base tables.
• Worked on improving the performance of Complex SQL's and PL/SQL scripts by applying various performance techniques using hints, indexes and also looking queries explain plan.
• Involved in shell script creation for automating the Bulk data import process.
• Worked with trouble shooting the defects as well as performance issues.

Confidential, Chicago

Databases & Tools: Oracle 11G, PL/SQL

Responsibilities:

• Involved in Customizing PL/SQL code developed in the existing Application as per Oracle 11G standards.
• Actively involved in Database Performance Tuning and SQL Tuning.
• Involved in attending the customer calls/Business Meeting as when it is required.

Confidential, Chicago

Databases & Tools: Oracle 10G, PL/SQL

Responsibilities:

• Involved in Customizing PL/SQL code developed in the existing Application as per client requirement.
• Actively involved in Database Performance Tuning and SQL Tuning and also participate in code reviews.
• Involved in Data modelling for the New Requirement.
• Involved in interacting with business analyst to understand the functional requirements and convert them into technical specifications.
• Developed new PL/SQL program units such as procedures, functions and packages to implement the business logic.
• Developed new shell scripts to call database procedures from the database server to kick off data migration process.
• Developed shell scripts for inbound and outbound of data on the server.
• Bug fixing on existing system.

Confidential

Databases & Tools: Oracle 10G, PL/SQL

Responsibilities:

• Involved in the Table design & Impact Analysis on the existing system for the new requirements.
• Developed new PL/SQL program units such as procedures, functions and packages to implement the business logic.
• Involved in the Code optimization and performance tuning of various SQL and PL/SQL using Indexes, Hints and other basic tuning techniques.
• Exposed to database administration activities like Import & Exporting data using the utilities etc.
• Review the Code changes done by Team members.

Confidential

Reporting Tools: Oracle Reports 6i

Databases & Tools: Oracle 10g,PL/SQL, Oracle Forms 6i

Responsibilities:

• Involved in the Database Modelling & Impact Analysis for the requirements given.
• Prepared the High Level - Functional and Technical Design Document for offshore team to proceed with the Code Development.
• Involved in implementing business logic with Oracle Stored Procedures, Functions and Triggers using PL/SQL.
• Involved in Creating Indexes and Materialized Views for better performance.
• Performance tuning of SQL statements using SQL Trace and TKPROF.
• Hands on experience using Analytic functions other built in functions.
• Worked on Scheduling of Jobs using DBMS JOB packages.
• Conducted unit testing and fixed the reported bugs.
• Involved in Quality related activity like Metric collections.