Experience Summary :

• Overall 19 years of consecutive Information Technology experience on a wide variety of platforms, operating systems and business domains. Also worked on a range of OLAP and OLTP based applications in Retail Product Sales, Health care and Energy Efficiency.
• Worked on data warehousing projects from inception to implementation and delivered high quality solutions in a timely manner meeting and exceeding the business requirements. This involved working with the executives, business sponsors and IT department.
• Managed the evaluation of ETL and OLAP tools and recommended the most suitable solutions depending on business needs. Worked as a DW/BI Architect for the last 10 to 12 years building highly scalable reporting and adhoc solutions.
• Built MDM/Governance layer supporting Medical Mgmt, portal and Claims System.
• Designed a dimensional EDW for supporting Medical Management Product Suite. This also involves data and ETL design and development of EDW and Data Marts for Reporting. This also involves integrating with other applications like Claims Processing. Currently building EDW to support all of CSG's reporting on Amazon Cloud using the columnar data warehouse service AWS RedShift.
• Extensive experience with Performance Tuning using the conventional Oracle methodologies which also includes talking through some of the DB configuration details and best practices. Also serving as Oracle DB specialist mentoring developers on the importance of using best practices for better scalabilty/reusability and maintenance.
• EDW/BI specialist in Oracle designing Enterprise wide applications and specialized in analyzing and performance tuning. Worked on DB size ranging from 600GB to 10 TB.

Technical Summary :

Data Modelling : ERWin, Sybase Power Designer, ER Studio, SQL developer

ETL Tools : Oracle Warehouse Builder, Informatica, ETI-Extract, ODI

OLAP tools : Microstrategy, Webfocus, Cognos and Jaspersoft

Database : Oracle 7.X, 8.X, 9i, 10g, 11g , Informix, AWS Redshift and MongoDB

DB Tools : SQL Developer, PL/SQL developer, DB Artisan, TOAD, SQL Workbench

Unix Tools : AWK, Sed, Syncsort, Korn Shell, Perl .

Experience Summary :

Confidential

Position : Chief DB Architect

Responsibilities :

• layer using Jaspersoftmultitenancy.
• from various external applications/sources.
• Model for each application with in AWS Redshift.
• an supportable EDW format based on the star schema model.
• maintain multiple schemas for each energy program/utility providers.
• Functionality with no changes to any of the depending interfaces applications.
• between different functional components.
• Cross functional support among multiple teams on the data design and integration
• Consolidating all program schemas into one core schema and support all the existing
• Building the multi-tenancy to support cross functional teams and avoiding having to
• Providing administrative support on the Oracle and AWS redshift in terms of authorization and performance monitoring , tuning and maintenance .
• Monitoring the DB for resource bottlenecks and providing solutions .
• Data governance through the inhouse built DB layer before the data gets to the EDW.
• Logical and Physical modeling for any new functional layers on the application.
• Mentoring the team on the best DB practices by having frequent group sessions.
• Building on a reverse approach to bring all the shoe reporting applications into
• Working with the business groups to put together the logical and physical data
• Working with the team on building an efficient ETL path for the data transfers
• Building the multi-tenancy with in Redshift and controlling the security and access
• Working on complex db issues and provide resolutions to challenging problems.

Environment : Amazon RDS AWS redshift, Jaspersoft, Oracle PL/SQL.

Confidential

Position : Principal DB Architect 2008-2014

Responsiblities :

• Working with the Oracle/SQL DBA on Capacity Planning and helping them coordinate requests from the development team to setup priorities.
• Building the Star Schema EDW for Medical Mgmtthrough out the SDLC until reports delivery. Using the internal MDM layer, data is governed through various steps before it is consumed by the end user.
• Mentoring the DB team and setup the standards and have them follow the best practices. Implementing the split architecture for the product.
• Writing Packages/Procedures , functions and Triggers when required.
• Facilitating the data integration between ikaClaims and other products for the data flow and maintaining the common data repository for handling and sharing master data.
• Monitoring the TOP sql's on all production instances and identify/consolidate and tune them for performance.
• Having weekly meetings with the team and answering any questions they may have on Oracle DB or Architecture.

Environment :

Oracle 10, 11g , Linux , Korn Shell, Perl , PL/SQL

Confidential

Position : Database Architect/DBA

• Data modeling changes to handle the dimension attributes and currencies for globalization and also the changes to the existing table columns to store languages.
• Database creation/configuration and maintenance.
• Trouble shooting the database issues.
• Extensive object development packages/procedures/funtions and PL/SQL blocks.
• Fixing the performance issues on the existing processes by rewriting the processes and adding the missing components for faster query response and reporting.
• Designed and developed a packaged solution for the Transaction/fact table movements along with other dimension/Master tables between different databases for a given vendor as a part of load balancing. This could take care of moving the entire data base from one db to an otherdb through the network db links automatically without having to intervene manually for the DBA's.
• Also created and configured Streams environment for the data replication from the control center database which handles the metadata and etl processing and data stores database which contains the vendor/retailer dimension and fact data . Streams are configured for homegenous and hetrogenous data movement and propagation between different database instances.

Environment :

Oracle 10g R2, Linux , HP-UX, Korn Shell

Confidential

Position : Database Architect

• Work with the business users and data architect team for creating the logical/physical model for the EDW and the Data Mart.
• Building the business process model and process flow for different processes and reviewing the logical and physical data models.
• Creating the ETL mapping documents for processing data from different external and internal sources.
• Developing ETL mapping interfaces using Oracle Warehouse Builder .
• Writing Oracle packages/functions for the data cleansing/validation through EDW.
• Creation of schemas for EDW , Staging and Campaign Management data marts using Erwin.
• Batch scheduling Oracle Scheduler.
• Korn shell scripting for data processing and validation.
• Building packages and necessary oracle objects and PL/SQL blocks.

Environment :Oracle 10g RAC, Oracle Warehouse Builder, Sun Solaris, Korn Shell , PL/SQL, WebFocus

Confidential

Position : Tech Lead

Responsibilities :

• Creating the logical/physical data model for different processes in the data hub.
• Creating the technical mapping/process documents from the requirements provided by the business support group.
• Interacting with the users on a daily/weekly basis to come up with the model and for creating the data mapping documents from different sources.
• Writing Shell scripts for the data validation,movement and processing.
• Creation of ETL interfaces using ETI-Extract and developing all database related objects like procedures/views.
• Creation of database schemas/tables and other database objects and developing oracle database packages/objects.
• Developing stored procedures and packages required.
• Object and data standardization to support integration among different applications.