Professional Overview

• 10 years of experience as a Data Analyst, Data Modeler, DB Consultant, Application DBA and Database Developer
• Worked in all facets of software development life cycle - requirements gathering, design, development, database maintenance, data migration, warranty production support and team leading
• Excellent analysis and design skills
• Strong communication skills
• Able team worker with strong work ethics and environmental adaptation
• Good experience in client handling and requirements gathering.
• Design and develop data models.
• Analyze data sources and create data migration templates.
• Data migration from other Databases to Oracle.
• Develop and deploy back End Stored Procedures, Functions, Packages Triggers in PL/SQL.
• Performance tuning of PL/SQL packages and procedures.
• Data migration using SQL Loader and Perl.
• Hands-on training in Informatica, Talend and ODI.
• Given seminars on various Oracle-related topics to the Database team.
• Excellent knowledge in handling TOAD.
• Strict adherence to DB standards and processes in every task.
• Design and develop Forms Reports, Construct/Code Integrate Form Level External Validation Interface.

Skills

• Languages : PL/SQL, Perl, UNIX
• Backend : Oracle 8i,9i,10g, 11g, Teradata, Ingres, SQL Server
• Utilities : TOAD, SQL Plus, ErWin, SQL Developer, Informatica
• Interface/Report Design : Oracle 9i/10g Forms and Reports, Crystal Reports

Projects

Confidential

Tools - ERwin, Toad, SQL Developer

Role - Data Analyst, Data Modeler

The State of Utah is replacing the existing Healthcare system with eCAMS Medicaid Management System, developed by CNSI. As part of the revamp, CNSI is developing the new data warehouse system and data marts.

Responsibilities - The roles involved are of a Data Analyst and Data Modeler. As part of PRISM, I designed the data model for new subsystems added to eCAMS OLTP system. Propagated OLTP changes to the data warehouse. Converted Oracle specific data warehouse model to Teradata. Currently, I am designing the various data marts for generating adhoc reports for PRISM. I have a very good understanding of the Medicaid management process.

Confidential

Tools - ERwin, Toad, SQL Developer

Role - Data Analyst, Data Modeler

The State of Maryland is replacing the existing Healthcare system with eCAMS Medicaid Management System, developed by CNSI. As part of the revamp, CNSI is developing the new data warehouse system and data marts.

Responsibilities - The roles involved are of a Data Analyst and Data Modeler. As part of MERP, I designed the data model for new subsystems added to eCAMS OLTP system. Propagated OLTP changes to the data warehouse. I have a very good understanding of the Medicaid management process. As part of the MERP team, I initiated and oversaw conversion of data models from ERwin version 4.1 to ERwin version 8.2.

Confidential

Back-End - Oracle 10g, SQL Server, PL/SQL

Tools - ERwin, Toad, SQL Developer, SQL Server Management Studio

Role - Data Analyst, Data Modeler, Database Consultant, PL/SQL Lead

The Data Engineering Practice Group in EDS is a centralized team of database experts. It provides assistance to various projects under multiple accounts. The main function of this team is to provide a complete set of DB solutions to the clients. Whenever the development or support teams are faced with a tough situation, the DE team steps in and helps resolve the issue.

Responsibilities - The roles involved were of a Data Analyst, Data Modeler, PL/SQL Lead, DB Consultant and ADBA for various clients like General Motors, World Bank, Ally Financials, Telstra, Mazda, Viterra to name a few. The job function involved helping development teams gather requirements, design data models, provide storage and resource estimates, create databases and maintain them, assisting them with database coding etc. As part of this team, I was responsible to evaluate various ETL and Data modeling tools like Oracle Data Integrator, Talend, Embarcadero etc.

Confidential

Back-End - SQL Server 2012

Tool - ERwin, SQL Server Management Studio

Role - Lead Data Modeler, Onsite Coordinator

AEGIS is a mutual insurance company and an eligible surplus lines insurer in the United States. AEGIS offers a full range of sophisticated insurance and risk management products and services for companies like gas and electric utilities, related energy companies, oil gas exploration and production companies, water utilities, and transmission distribution companies.

Responsibilities As lead data modeler, I was responsible for requirements analysis, design and implementation of the enterprise-wide data warehouse. I had to analyze and design the data model for various business processes like Underwriting, Claims, Earnings, Plan Data etc. I interacted regularly with the ETL team to assist them with their extraction, transformation and load logic in SSIS. I held regular sessions with Cognos and SSRS reports teams to assist them with the framework model designs.

Confidential

Back-End - Oracle 11g, PL / SQL

Tool - SQL Developer

Role - PL/SQL Lead, ADBA

General Motors being a manufacturing giant has multiple software applications catering to its different business units. The current release of the GQTS project was aimed at automating integration between multiple existing applications.

Responsibilities As ADBA, my main responsibility was to assist the front-end development team with their coding efforts, consolidation and deployment of scripts in various environments such as development and pre-production, preparing implementation and back-out plans and scripts for production deployment. I designed and created various DB objects such as Packages, Procedures, Functions and Triggers to facilitate synchronization between two of the existing systems Part Grouping Tool and Run Rate. I lead the performance tuning initiative of all major queries used in the project.

Confidential

Back-End - Oracle 11g, PL / SQL

Tool - Toad, SQL Developer

Role - Data Analyst, Data Modeler, PL/SQL Lead, ADBA

The Metrics And Reporting System Logistics Operations project is a data warehousing project in the factory model of project management. It captures the everyday functioning of GM logistics system and displays them as MIS reports for the higher management. The day-to-day transactions of the division are stored in multiple information warehouses from where the data is consolidated and moved to a data warehouse. The transfer of data is performed in an ETL process which utilizes a number of PL/SQL stored procedures and UNIX jobs that invoke the procedures.

Responsibilities As data modeler for this project, my role was to discuss and identify business requirements for the project, define entities and attributes needed for the business function, create conceptual, logical and physical data models, create data dictionary for the model, assist the development team with their ETL and Reports coding.

As data analyst for this project, my job was to study and analyze data from various source systems and decide on data cleansing to be done to migrate them into the newly designed data model. As part of this job, I create data templates to be sent to the various stakeholders for them to provide data.

Confidential

Back-End - Oracle 11g

Tools - Toad, ERwin

Role - Onsite Coordinator, Tech Lead, Data Analyst, Data Modeler

The AT2FWR was a Proof-of-Concept project for generating reports, mapping the numerous applications functioning for General Motors with their respective host systems. The POC was a complex project involving the study of the various sub-systems that track the different levels of networking and combining them to create a new functioning data model that simplified the application reporting. My performance in this project was highly appreciated by the clients as well as the onsite and offshore teams.

• Responsibilities - As the onsite coordinator for this project, I interacted with the clients at various levels, gathered the requirements, identified and documented the problem areas and provided technical solutions for the data model and reports. I coordinated the various development activities of the offshore development team. I interacted with the different onsite teams to provide an optimal development environment for the offshore development team.
• As data analyst and data modeler of this project, I studied the existing data models of the various source systems and designed the new data model for reporting, analyzed the different source data and created templates to be used by the different stakeholders to input data into the new system.
• As tech lead of the project, I coordinated the various technical aspects of development like data migration, reports etc. I provided quick solutions to the development team as and when they had questions regarding the project.

Confidential

Back-End - Oracle 10g, PL / SQL

Tools - Toad, SQL Developer

Role - Data Modeler, PL/SQL Lead, UNIX Developer, ADBA

The Ease Oscar Reporting Project and NAO Cognos 8 Reporting Project are a set of similar data warehousing projects where the everyday functioning of Ally is displayed as MIS reports for the higher management. The day-to-day transactions of the bank are stored in an information warehouse from where the data is consolidated and moved to a data mart. The transfer of data is performed in an ETL process which utilizes a number of PL/SQL stored procedures and UNIX jobs that invoke the procedures.

• Responsibilities - As a PL/SQL Lead in Ease Oscar Reporting, I am responsible to validate and advise the development team of the right logic behind the various stored procedures used for extracting, transforming and loading the data according to the client requirement. As the UNIX developer I create UNIX scripts to invoke the different procedures in the right order to ensure the smooth loading of the right data.
• As Data modeler for the sustain team of NAO Cognos 8 Reporting, my responsibilities included the complete study of the existing data model and advise changes to optimize performance of ETL Processes. As ABDA for this project, I attended to various sustain activities that affected the database. The key responsibilities included DB maintenance activities and synchronizing the Data Mart with data in the Information Warehouse. The crucial aspect of this project was the minimal turn-around time involved to identify the issue and come up with a solution.

Confidential

Back-End - Oracle 10g, PL / SQL, ERWIN

Role - Data Modeler, Data Migration Lead, ADBA

The STIMS system is an IT project in the Global Product Development IS S organization of General Motors to develop and deploy a new IT system for Global Product Development GPD Engineers for the Safety Test Information Management. The project maintains the safety equipments like vehicles, cameras, channels, electronic equipments etc. and tracks the progress of a safety test.

Responsibilities - As the data modeler and Application DBA for this project, I studied the existing data model, updated the logical data model, created the physical data model, the schema creation scripts. I was also responsible for creating and maintaining the development database and the data dictionary.

Confidential

Back-End - Oracle 10g, PL / SQL, ERWIN, Perl, UNIX

Role - Data Analyst, Data Modeler, ADBA, Data Migration Lead

• ATDVMS system was an IT project in the Global Product Development IS S organization of General Motors to support Safety Test Information Management System. The system helps maintain the health of the ATDs Vehicle Test Dummies and in performing verification tests.
• Responsibilities - As data modeler and application DBA for this project, I interacted with clients to understand requirements, maintained requirement traceability matrix, created logical physical data models, schema creation scripts. I created and maintained the development database, assisted the development team in development activities and in understanding the database schema, created the data dictionary and worked on the database part of other documents such as the SDD, ADD. I was also responsible for creating the data migration strategy, studying and creating data migration scripts to migrate data from the legacy system to the current system.

Confidential

Back-End - Oracle 10g, PL / SQL

Role - PL/SQL Developer, ADBA

• The Connected Vehicle enterprise IT CVeIT system is a project to support the Connected Vehicle program of General Motors. The project allows GM to meet objectives like utilizing telematics for GM internal benefits, remote vehicle health management, and to enhance customer experience facilitate the remote identification and correction of issues and improve quality develop a measurement system that predicts future warranty issues by understanding failure rates and frequencies.
• Responsibilities - As PL/SQL developer and Application DBA for this project, I designed and developed the various backend procedures, functions and packages needed for the functioning of the CVeIT application. I developed 50 backend objects using the latest Oracle functionalities. I maintained the various versions of the development schemas and assisted the development team in understanding and effectively using the database objects.

Confidential

Front-End - Oracle 10g Forms and Reports

Back-End - Oracle 10g

Role - Reports Developer, PL/SQL Developer

• PREMIA - Profitable Relationships through Effective Management of Insurance Activities, a product of 3i-Infotech Ltd. is an enterprise-class insurance management and control system, which is backed by comprehensive financial accounting, reporting and analysis.
• Responsibilities - As a developer in the accounts team of this project, I was responsible for generating the various reports used in the day-to-day activities of the client. I was responsible for designing and generating high profile reports such as the General Ledger and Trial Balance and the various backend packages, procedures and functions that were used in the reports. I worked on designing and generating the front-end forms used to invoke the reports. I had single handedly designed and developed the automation of bulk policy generation concept for Oriental Insurance Company Limited.