SUMMARY:

• 9.5 years of experience in analysis, design, development, testing and implementation as ORACLE Database DWH Architect
• Expert in multiple RDBMS including Oracle 11g/10gr3/9i/8i/8.x/7.x with PL/SQL, Microsoft SQL Server 2000, 2008 , Teradata.
• Worked on Informatica 7.x/8.x OWB 10g/11g.
• Expertise in Information Engineering and Object Oriented principles and techniques with OLAP and reporting tools.
• Expertise in using tools such as TOAD, SQL Plus, SQL developer, PL/SQL developer.
• Expertise in understanding Slowly Changing Dimensions Type1, Type2 and Type3.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, MS Access and Flat Files.
• Worked on advanced PL/SQL constructs like Oracle supplied packages, Nested Tables, Varrays, Records, Types, Dynamic SQL and Analytical functions.
• Worked on Forms and Reports 6i 9i.
• Created indexes on tables for fast retrieval of data.
• Experience in PL/SQL collections, Bulk collections and Exception handling.
• Worked in SQL, PL/SQL development and database support as well as maintenance.
• Experience in using SQL Loader for loading data from flat files into Oracle tables.
• Performance tuning using Explain Plan, SQL-Trace, TK-Prof oracle utilities and creating relevant system and user documentation.
• Experience in Data modeling tools like Erwin, Visio and Oracle designer.
• Good understanding of Oracle Data Dictionary, RDBMS and Normalization techniques.
• Substantial development experience in creating Procedures, Packages, Functions, Triggers and other database objects using SQL, PL/SQL.
• Created and tested PL/SQL blocks and UNIX shell scripts.
• Developed shell scripts for inbound and outbound of the data on servers.
• Used UNIX shell scripts to automate day-to-day operations.
• Strong working experience in the Gathering the Requirements, Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading ETL
• Strong interpersonal skills, ability to interact with individuals at all levels, excellent communication and presentation skills.
• Experience in Data ware Housing BI Applications.

PROFESSIONAL EXPERIENCE:

Confidential

Data Warehouse Architect ETL Lead

Responsibilities:

• Involved in SDLC gathering requirements from end users.
• Creating the functional and technical design documents.
• Defining and designing the test plan and test cases.
• Created ETL documents detailing the ETL database navigation and data transformation logic used by developers as coding specifications.
• Designed the ETL Specification for STG and DW Areas.
• Designed the ETL processes using OWB 10gR2 to load data from multiple sources into the staging area.
• Developed mappings using OWB for data loading. Created Process flow, scheduled monitored session.
• Extract Data Requirements from process oriented Requirements Documents
• Created Dimension and Fact tables.
• Developed mappings for Demographics.
• Performed Business Analysis, Data Analysis and Dimensional Data Modeling
• Analyzed business requirements and interfaced with vendors for development and enhancement of a system to support multiple business areas including Asset Management, portfolio management and risk management.
• Involved in migration of mappings / workflows from Development to Testing and to production.
• Created shell scripts and updated the scripts as per the requirement.
• Developed scripts for inbound and outbound of the data on servers.
• Efficiently managed disk by deleting old log files.
• Creating cron jobs in UNIX.
• Experienced in data integration, metadata management, ETL, data modeling tool sets
• Developed Reports and Graphs to present the results to the management.
• Identified, tracked and resolved performance problems. Made recommendations on potential functional and technical improvements to planned or existing system components and applications.

Environment: Oracle 11g, OWB 10g/11g, Data ware Housing, OBIEE 11g, Subversion, MS Suite MS Access, MS Excel, MS PowerPoint, MS Visio , Share Point, Windows.

Confidential

Database Module Lead

Responsibilities:

• Involved in SDLC gathering requirements from end users.
• Creating the functional and technical design documents.
• Defining and designing the test plan and test cases.
• Developed views to facilitate easy interface implementation and enforce security on critical customer information.
• Developed stored procedures and triggers to facilitate consistent data entry into the database.
• Written Stored Procedures using PL/SQL and functions and procedure for common utilities.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
• Created programming code using advanced concepts of Records, Collections, and Dynamic SQL.
• Developed Database Triggers for audit and validation purpose.
• Used Advanced Queues functions for faster data accessibility.
• Writing validation packages using PL/SQL package.
• Used PL/SQL to validate data and to populate billing tables.
• Used advanced Bulk techniques to improve performance.
• Developed Installation scripts for all the deliverables.
• Performed functional testing for the procedures and packages.
• Created and manipulated stored procedures, functions, packages and triggers using TOAD.
• Wrote heavy stored procedures using dynamic SQL to populate data into temp tables from fact and dimensional tables for reporting purpose.
• Extensively worked on Quality test plans and reviewed the Quality System Test Plan Test cases.
• Fine-tuned for performance and incorporate changes to complex PL/SQL procedure / Packages for updating the existing dimension tables using PL/SQL Developer on Oracle RDBMS.
• Extraction of data from different sources using ODI.
• Writing shell scripts to automate the process.
• Creating cron jobs in UNIX.
• Creating and executing SQL queries to perform Data Integrity testing on an Oracle Database to validate and test data using PL/SQL developer.
• Performed data Validation and comparison for data loads and migrations in different applications.
• Provide requirements around data quality as it pertains to ETL.
• Worked for data ware house BI reports.

Environment: Oracle 11g, Informatica, Data ware Housing, ODI, SQL Server 2005 / 2008, MS Suite MS Access, MS Excel, MS PowerPoint, MS Visio , HP Quality Center 10.0, Share Point, Windows.

Confidential

Module Lead / System Analyst / Sr. Data Quality Analyst

Responsibilities:

• Mentoring the team with team building activities.
• Involved in SDLC gathering requirements from end users.
• Creating the functional and technical design documents the changes required.
• Requirements Gathering.
• Meeting with Stake holders.
• Defining and Designing the test plans.
• Designing and defining test cases in HP Quality center.
• Coordinating with Other Planning tracks for executing Integration testing and User Acceptance testing.
• Coordinating and managing the team activities.
• Coordinating with the clients for System Test and User Acceptance Test.
• Issue tracking and Status Reporting.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
• Performed functional testing for the procedures and packages.
• Extensively worked on Quality test plans and reviewed the Quality System Test Plan Test cases.
• Creating and executing SQL queries to perform Data Integrity testing on an Database to validate and test data
• Performed data Validation and comparison for data loads and migrations in different applications.
• Provide requirements around data quality as it pertains to ETL.
• Worked for data ware house BI reports.

Environment: Data ware Housing, SQL Server 2005 / 2008, Teradata V2R6, Teradata SQL Assistant, , T-SQL, SQL, MS Suite MS Access, MS Excel, MS PowerPoint, MS Visio , HP Quality Center 10.0, Cognos 8.0 / 10 , Share Point, Windows, Cognos.