SUMMARY

Data Warehouse Architect, Design & strong in database administration with over 17 yearsof broad based experience in leading complex, scalable IT Industry. Hands on practitioner utilizing

TECHNICAL SKILLS 

ORACLE Database& ETL Tools, and other consulting tools (ORACLE, SQLSERVER, Teradata, Erwin, ERStudio, SQL Modeler, OWB,INFOMATICA, DATASTAGE, PLSQL, SQL,) resulting in significant quality and customer gratification. Specific areas

PROFESSIONAL EXPERIENCE

Confidential

Principal ETL Consultant

Responsibilities Included:

• Supported and contributed to the Architect, Design and Development of an Enterprise Data Warehouse for afinancial company related to the Signature Dispute and Card Fraud subject area.
• Performing database designing, ETL Designing & Development.
• Database Administration and ETL Administration.
• Data Integration, Data Analysis, Data Cleansing and Data Profiling for various source systems.
• Developing and maintaining Metadata Repository

Senior Consultant

 Responsibilities Included:

• The purpose of SBSS Decommission is to reduce the complexities of the SBSS data management acrossLogistics Information Management System (LIMS) -Engine View (EV)
• Reduce the troubleshooting effort due to multiple instances of SBSS data in the data warehouse.o Achieve consistency across the tools by using a single instance of SBSS data ando Streamlining and positioning the data marts for easier applications mapping to the new ERP (ECSS) data source.
• Served as Data Analyst in defining, developing and enhancing Data Warehouse system for SBSS
• Decommission project. Primary responsibility include but were not limited design logical and physical data model using Erwin.
• Database Design and develop various key initiatives for Data Warehousing.
• Design and Develop Informatica Mappings/Workflows.
• Preparing Test Cases and Deployment Artifacts

BI Architect 

Responsibilities included:

• Database Design and develop various key initiatives for Data Warehousing.
• Data warehouse Architect.
• Data Profiling and Data Analysis in various source systems.
• Developing and maintaining the Metadata repositorySetting up user roles and security to access reports.
• Design and Developing DR for BI databases (BCP).
• Creating and managing primary objects such s tables, view, indexes, materialized views, dimensions, facts,partitions, storages etc.
• Maintaining Development, INT and UAT database environments.
• Production Support for Inbound & Outbound Data warehousing.
• Discoverer Administration

BI Architect

Responsibilities included:

• Consulting with business to develop recommendations that address difficult and complex business informationneeds and opportunities.
• Data warehouse Architect.
• Leading requirement sessions.
• Requirement Gathering, defining scope, Panning, Designing and developing multi-dimensional data model
• using the Ralph Kimball methodology
• Determine and develop approaches to solutions.
• Resolves project data issues and data issues for span subsystems..
• Assess objectives, use cases, information requirements and data specifications.
• Assess opportunities to use and enhance enterprise data model.

Confidential

BI Architect & Senior Data Analyst -

Responsibilities included:

• Involved in developing several data models and all the components into the data modeling tool and controldifferent versions.
• Designing, Planning and Executing
• Creating/Maintain users and objects,Partitioning tables.
• Developing Stored Procedures, Packages and Functions for Data warehouse.
• Developing prototypes according to business functionalities.
• Developing and executing installation scripts in development, test and UAT.

Database Administrator 

Responsibilities included:

• Performed Oracle Database Administration activities such as Installation of software, creating databases for all(Development, Testing, UAT and Production), upgrading the existing databases.Cloning Databases.
• Planning and Implementing the Backup and Recovery strategies for the Production databases.
• Configure RMAN Backup (Cold & Hot Backups) for Test and Production.

Database Administrator

Responsibilities included:

• SQL Servers, and flat files. I aided in the development of the delivery mechanism, which utilize MS Analysis
• Services cubes, COGNOS Power play and Crystal Reports.
• Cloning databases
• Configure Oracle Gateway for SQL SERVER.
• Configure Oracle ODBC (Heterogeneous) to access SQLSERVER Databases.
• Configure RMAN Backup (Cold & Hot Backups) for Test and Production.
• Create and Maintain Tablespaces
• Reorganize the Tablespaces
• Performance tuning instances, memory and application.
• Creating/Maintain users and objects.

Confidential

Database Administrator 

Responsibilities included:

• Troubleshoot databases, applications, performance & tuning, backup and recovery issues for several clients.
• Production Database Clone Refreshes.
• Perform ongoing tuning of the database instances.
• Configure Oracle Gateway for Sybase.
• Importing / Exporting.
• Monitoring and Tuning.
• Listener TNSNAMES Configuration and tuning.
• SQL and PL/SQL utilities development for administration purposes.
• SQL SERVER database to Oracle conversation