SUMMARY:

• Fifteen years of professional experience in Enterprise Data Warehouse architecture design and deployment experience using industry best practices and a broad knowledge of Database Systems. Expert in Oracle database administration, Performance tuning, SQL and PL/SQL.
• 15 years of experience in building ODS, Enterprise Data Warehouse and Data Marts.
• 15 years of experience in Data Integration, Data Migration, Data Conversion, Data Quality, ETL and Master Data Management .
• 8 years of experience in designing Oracle HealthCare System at Oracle Corp.
• Experience working with MS SQL Server, Oracle 11g, Oracle APEX, BIG Data, Oracle NoSQL and Oracle Exadata.

CONFIDENTAIL

Accomplishments:

• Designed and developed Oracle Healthcare Transaction Base platform HTB at Oracle USA.
• Designed and developed ODS Operational Data Store , Data Marts, MDM, Data Governance and ETL for Lab Information Systems at Ameripath.
• Designed Data Marts and extensively worked on performance tuning which includes Partitioning and other techniques to improve the query performance of reports at Texas Instruments.
• Designed and developed ODS Operational Data Store , Data marts, MDM, Data Governance for Mortgage model at Bank of America. Extensively worked on BIG DATA Analytic tools Oracle Endeca , Hadoop and MapReduce to integrate data from Data Warehouse and Big Data.

PROFILE:

• Expert Enterprise Data Modeler with a deep understanding of developing transactional enterprise data models that strictly meet normalization rules, as well as enterprise data warehouses using Kimball and Inmon data warehouse methodologies.
• Expert in Oracle database administration tasks, SQL and PL/SQL.
• Extensive experience translating business requirements into Conceptual, Logical and Physical data models.
• Expert knowledge of Oracle Application Express.
• Extensive hands on experience using Oracle, SQL server, Sybase and DB2 databases.
• Expert at implementing physical data structures in order to achieve maximum database performance.
• Experience working with Teradata, BIG Data, Oracle NoSQL and Oracle Exadata databases.
• Extensive experience in ETL architecture and development using Informatica Powercenter.
• Proven ability to interface and coordinate with cross functional teams and cultures, analyze existing systems, wants and needs, design and implement database solutions.
• Efficient in the execution of all assignments, eager to take on new challenges.
• Provided best practices and methodologies to data analysts, database administrators, application developers, and QA/testing teams.
• Excellent communication skills with trouble shooting and problem solving capabilities. Highly successful in meeting customer needs.
• Excellent leadership skills, guidance and mentoring developers in the design solutions.
• Excellent knowledge of performance tuning with real life expertise which includes database partitioning and indexing strategies.

TECHNOLOGY:

• Design: Enterprise Data Warehouse Design, Operational Data Store Design, Data Mart Design, Metadata Management and XML Schema Design.
• Databases: Oracle 10g, 11g , Oracle APEX, MS SQL Server, IBM DB2,Teradata, BIG Data and Oracle NoSQL. Modeling Tools : ERWIN, Embarcadero ER Studio, Sybase Power Designer, Oracle Modeler.
• ETL Tools: Informatica, Oracle Data Integrator ODI , Ab initio. BI Tools: OBIEE, MicroStrategy
• Query Tools: Oracle SQL, MS SQL, Toad
• Performance : SQL and PL/SQl Tuning, Oracle Database Tuning.
• Languages: SQL, PL/SQL, Java.
• General, MS Office, Visio, MS Project and other document tools.

EXPERIENCE:

Data Architect,

• Built Conceptual, Logical and Physical Operational Data Store for the Mortgage industry based on MISMO reference model Bank industry standard using ERWIN modeling tool.
• Extensively used Oracle Application Express to develop web applications for the Mortgage model.
• Wrote SQL and PL/SQL scripts for the ETL process and extensively worked on Oracle performance tuning to fine tune the applications and database.
• Responsible for maintaining Data Quality, Data Governance, Data Profiling and versioning of Master Data.
• Responsible for maintaining centralized metadata repository using ERWIN.
• Built Data marts for Bankruptcy, Pre-Sales, Foreclosure, Delinquency, Loss Mitigation, Document Management, Mortgage Resolution Team subject areas using Kimball Methodology .
• Worked on defining the information architecture strategies for Bank of America Mortgage services, application systems, and the data that flows between them.
• Worked extensively on XML schema design of Mortgage Services. Also, worked on wsdl files and converted them into data model using Sybase Power Designer.
• Designed Information security model for Mortgage services.
• Responsible for maintaining Database standards and best practices within the team.
• Worked on Teradata, Oracle Exadata and DB2 databases.
• Worked and mentored Data Analysts, ETL developers, DBAs and QA team.

Data Architect,

• Extensively used ERWIN tool to create Conceptual, Logical and Physical models for the Data Marts.
• Responsible for maintaining and governing the Master Data for the data marts. Responsible for maintaining the metadata repository.
• Extensively wrote Sql and PL/SQL scripts for maintaining the Master Data Management for EMPI Enterprise Master Person Index .
• Extensively wrote PL/SQL scripts ETL process to load data from ODS to Data Marts.
• Responsible for SQL tuning using SQL traces and Explain plans. Done extensive analysis of usage of indexes, histograms and also worked on tuning volume databases. Worked on Partitioning strategy for fast retrieval of data in reports. Excellent knowledge of oracle 11g and 10G new features like Data Pump, Automatic Management, Automating tasks using scheduler, Flashback, Space Management, SQL tuning advisor etc.

Data Architect,

CONFIDENTAIL. is a leading national provider of anatomic pathology, dermatopathology and molecular diagnostic services to physicians, hospitals, clinical laboratories and surgery centers across the CONFIDENTAIL

.

Key Accomplishments:

• Designed normalized data model for Operational database.
• Worked on the Conceptual, Logical and Physical models of Lab Information system LIS using
• ERWIN designer tool.
• Extensively worked on Oracle application performance tuning and wrote PL/SQL stored procedures
• to validate data coming from multiple source systems.
• Responsible for maintaining and governing the master data of all the labs.
• Responsible for maintaining the data dictionary and metadata of all tables in Erwin.
• Extensively worked on Oracle APEX to build web applications and reports.
• Implemented Oracle Partitioning techniques and indexing techniques for fast retrieval of data.
• Designed Schema architecture for the ODS databases.
• Designed ETL architecture to extract, transform and load data coming from different labs into the
• ODS.
• Designed Data Marts for reporting purposes.
• Wrote pl/sql code to load data from ODS to Data Marts.

Principal Applications Engineer

I started as senior applications engineer and grown into Data Architect in Daily Business Intelligence, Oracle Health Care and Oracle GIT teams. I worked 7 years at Oracle USA Redwood Shores Head Quarters and then transitioned to Oracle India for one year.

Key Accomplishments GIT Team:

• Designed OLAP model for Blended Reporting project and lead a team of 2 people in the development of the project which integrates Oracle, Siebel and Peoplesoft service request data.
• Designed MeTeR Data Mart using Kimball methodology which integrates the Oracle, Siebel and Peoplesoft SR data.
• Responsible for redesigning the MeTeR data mart by integrating with the conformed dimensions in Quality Data Model. With the new design the estimated time to load into fact table reduced from 4hrs to an hour.

Key Projects and Accomplishments Health Care Team:

• CONFIDENTAIL is a comprehensive data repository and service infrastructure that provides Independent Software Vendors, System Integrators, and provider organizations with a state of the art software platform that lets them build robust and scalable healthcare applications. The HTB platform supports industry standards, such as HL7, HIPAA privacy regulations, and standard terminology sets such as SNOMED, CPT4, and ICD9.
• Worked as a data architect to build the healthcare transaction base system based on Reference Information Model that was developed for version 3 of the HL7 messaging standard and the corresponding vocabulary sets.
• Responsible for designing Conceptual, Logical and Physical models of Oracle Healthcare Transactional system.
• Responsible for maintaining the Metadata repository in Oracle Designer.
• Worked in the analysis of the Oracle eBIZ products like TCA Trading community Architecture , HR, Financials, AOL and DBI DataBase Intelligence as part of integration of healthcare system eBIZ.
• Responsible for application tuning for healthcare modules using SQL traces, Explain plans and SQL Analyze OEM . Done extensive analysis of usage of indexes, histograms and also worked on tuning volume databases. Worked on Partitioning strategy for the healthcare modules. Excellent knowledge of oracle 9i and 10G new features like Data Pump, Automatic Management, Automating tasks using scheduler, Flashback, Space Management, SQL tuning advisor etc.
• Designed Healthcare business intelligence product using Kimball methodology.

Key Projects and Accomplishments DBI Team:

• CONFIDENTAIL is an integrated out-of-the-box reporting application that enables senior managers and executives to see timely information using self-service dashboards.
• Worked extensively in the discoverer 10g development of Order Management, Advanced Pricing and Shipping products. Responsible for migrating the EUL layer from discoverer 4i to discoverer 10g.
• Worked in the development of DBI Transportation Management dashboard by adding new features such as Multi Delivery consolidation deliveries in reports. Wrote pl/sql procedures to avoid double counting of child deliveries in the case of Multi Delivery consolidation of deliveries. Created MVs on top of Fact tables for rolling up of Fact tables to a particular level of granularity. Extensively used 9i/10g new features in sql and pl/sql code

Key Tasks and Accomplishments Public Sector Applications:

• Worked as a Release engineer and DBA.
• Extensively worked on Oracle internal procedures for release activities.
• Extensively worked on cloning databases and monitoring the space usage of different PSA databases.
• Good knowledge of Shell script.

ETL Developer/Data Analyst

CONFIDENTAIL is a leader in the design, marketing and distribution of premium lifestyle products in four categories: apparel, home, accessories and fragrances.

Key Projects and Accomplishments:

Responsible for the Logical and Physical design of ODS, Data Warehouse and Data marts for Polo's Retail warehouse Industry using ERWIN.

• Responsible for tuning applications design, SQL and PL/SQL programs, memory usage, data storage and manipulation, physical and logical storage and optimizing network traffic.
• Extensively used ETL tools Informatica to Extract, Transform and Load data from AS400 systems to Oracle database.
• Responsible for transferring the data from AS400 to ODS using Power Center 1.5 Informatica and automated the process so that it will transfer the daily data in the nights.
• Wrote Pl/Sql Scripts to load data from ODS to Dimensional tables.
• Optimized SQL scripts using Explan Plan, Sql Analyze
• Done database tuning for better performance on Server including SGA memory allocation, I/O distribution, Fragmentation, Row Chaining.