Oracle Project

Dedicated IT professional with exceptional data warehouse, database, and

business intelligence experience

Summary:

Over 12 yrs. of diversified experience in Oracle in various domains

including State Government Elections, Utility services and Print

media.

Worked on all phases of data warehouse development lifecycle, from

gathering

requirements to testing, implementation, and support.

> Proficient in Oracle Warehouse Builder 11g/10g/9i and Oracle Data

Integrator - ODI, Developer 2000/6i, Designer2000/6i, Quest TOAD,

SQL*PLUS, PL/SQL

> Experienced in Oracle Data Integrator Enterprise Edition.

High expertise in the Extraction, Transformation and Loading(ETL).

Expertise on Oracle Database 8, 8i, 9i, 10g and 11g.

Experience in Database Modeling using Designer 6i for Rapid

Application development.

Front end business application development using Oracle Developer

6i/Developer 2000.

Worked in 24*7 production support projects.

Excellent presentation and technical documentation skills.

Creating Table Spaces, Users, Roles, Synonyms.

Implement and maintain Database security (users, roles, Assign

Privileges)

Experience in Export, Import and SQL Loader (data conversion) and

Toad.

Loading external Data into oracle Databases.

Implementing Database Triggers.

Created Database Links and Materialized Views.

Experience in Oracle Performance Tuning.

Experince in Unix Shell Scripting.

Project Resource planning and allocation

Proficiency in creating business and technical project documentation

Ability to work as a strong team leader to ensure quality and timely

project execution

Technical Skills:

Operating Systems : Win NT/XP/2000/95/98, DOS, IBM AIX, Sun OS

Languages : PL/SQL, T-SQL,Perl

GUI : Developer 6i, OEM 10g Grid

RDBMS : Oracle v.10g/9i/8i/7, SQL Server 2000/7/6.5

Tools : OracleWarehouseBuilder,OBIEE, ODI,

Developer2000/6i,Designer2000/6i,

Quest TOAD, SQL*PLUS, PL/SQL,

SQL*Loader, SQL*Net,

Export/Import

Education:

Bachelor of Engineering in Electronics and Communication

Post Graduate Diploma in Management Information Systems and Computer

Applications

Professional Appreciation / Training(s) Attended:

. Oracle Client Server Technology Training from RAM Informatics Limited,

India

. Letter of Appreciation by the Director of eSEVA, INDIA for the

Excellent work and Support for the eSEVA project.

Professional Experience

Credit Acceptance Corporation, Southfield. MI

May 2010 - Present

Lead Datawarehouse Developer

Description: Credit Acceptance Corporation provides vehicle loans to

consumers regardless of their credit history. Credit Approval Program

provides dealer-partners with the opportunity to deliver credit

approvals to consumers within 30 seconds through the Internet using

patented Credit Approval Processing System (CAPS).

Roles & Responsibilities:

Installation of Oracle Data Integrtor on vista.

> Creation of Master Repository, Work Repositories .

> Created Agents, Physical Architecture, Logical Architecture and

Contexts.

> Created Models and Projects.

Creation of Dimensions, Facts for the Star schema design.

Experienced in creating Multi-hierarchy Dimensions.

Staging of Legacy data into Oracle using ODI.

Creating maps for Extraction, Transformation and Loading process in

Oracle Warehouse Builder and Oracle Data Integrator - ODI.

Design and develop configuration files, tables, views, functions

procedures and

complex Dynamic insert or update scripts using Toad;

implemented best practices to Maintain optimal

performance.

Created system for capturing, reporting, and correcting error data.

Creating Entities and relationships using Oracle Designer for all the

Structure changes.

Generating the scripts using Data modeler.

Generating Unix Shell Scripts.

Performed Performance Tuning tasks.

Interacting with the Business teams and executing the changes in the

data.

Review peer documentation.

QA Testing and Preparing the assumptions and Exceptions Document.

Provide on-call support to production system to resolve any issues.

Technologies: ODI 10.1.3.5,ODIEE, SQL Loader, ORACLE 9i/10g, Windows

Vista/XP, SQL*Plus, Toad, PL/SQL.

Chicago Housing Authority, Chicago, Illinois USA

2009- May 2010

Charts Project (State Government)

Lead Data Migration

Description: The Chicago Housing Authority (CHA) is the second largest

public housing agency in the continental United States. With a mission to

"ensure the provision of affordable housing opportunities in viable

communities for lower-income households," CHA is transforming itself from

being an owner and manager of public housing to a facilitator of housing

opportunities. As such, CHA is in deep need of actionable information

about the various factors involved in this facilitation. Grappling with

consolidating information about its assets, customers, communities,

finances, regulatory and compliance requirements, CHA is seeking an

adaptive data mart solution which will allow them to meet their most

pressing, immediate needs, while also affording the flexibility of changing

as future needs arise.

Roles & Responsibilities:

Installation of Oracle Warehouse Builder on vista.

Creation of Workspaces, Workspace users and Locations .

Creation of Dimensions, Facts for the Star schema design.

Experienced in creating Multi-hierarchy Dimensions.

Staging of Legacy data into Oracle using OWB.

Creating maps for Extraction, Transformation and Loading process in

Oracle Warehouse Builder and Oracle Data Integrator - ODI.

Design and develop configuration files, tables, views, functions

procedures and

complex Dynamic insert or update scripts using Toad;

implemented best practices to Maintain optimal

performance.

Created system for capturing, reporting, and correcting error data.

Creating Entities and relationships using Oracle Designer for all the

Structure changes.

Generating the scripts using Data modeler.

Generating Unix Shell Scripts.

Performed Performance Tuning tasks.

Interacting with the Client and executing the changes in the data.

Review peer documentation.

QA Testing and Preparing the assumptions and Exceptions Document.

Provide on-call support to production system to resolve any issues.

Technologies: ORACLE Warehouse Builder 11g/10g/9i,ODI10g,ODIEE, SQL Loader,

ORACLE 9i/10g, Windows Vista/XP, SQL*Plus, Toad, PL/SQL.

EDS an HP company, USA

April'2005 - Dec'2008

Electus Maintenance (State Government)

Lead Data Migration

Description: Project Elections Practice, which includes Election

Management, Centralized Voter Registration, and the Duplicate Voter

Exchange, has been developed from the ground up to assist states in

implementing the Help America Vote Act (HAVA). This project ensured to

automate virtually every aspect of election office operations to reduce

risk and costs, maximize productivity, increase efficiency, and standardize

election workflow, all while meeting HAVA compliance. This includes a

support program that provides dedicated onsite application and end-user

(counties and towns) support.

Roles & Responsibilities:

Staging the Source Data from Text, Access and Excel into Oracle

Database.

Cleansing and Transforming the data.

Creating maps in Oracle Warehouse Builder and Oracle Data Integrator -

ODI.

Creating functions, procedures and complex Dynamic insert or update

scripts using Toad.

Interacting with the Client and executing the changes in the data.

QA Testing and Preparing the assumptions and Exceptions Document.

Creating Entities and relationships using Oracle Designer for all the

Structure changes.

Generating the scripts using Data modeler.

Technologies: ORACLE Warehouse Builder 11g/10g/9i, SQL Loader, ORACLE

9i/10g, Windows XP, SQL*Plus, Toad, PL/SQL.

Secretary of State, Missouri

Aug'2006-Jan'2007

Electus

Data Migration

Description: The project involves the migration of Voters Information for

the 114 counties of Missouri. The process also involves the preparation of

Address libraries using a function which takes the street file, street

types as input.

Roles & Responsibilities:

Staging the source data using SQL LOADER into the Oracle Database.

Cleansing the Data using Toad.

Creating the Maps to Load the data into the target Database using

Oracle Warehouse Builder.

Preparing dynamic sql scripts using Toad to insert and update.

Creating Procedures and functions.

QA testing and preparing Assumptions/Exception Reports

Technologies: Oracle Database 10g/9i,ORACLE Warehouse Builder, SQL

LOADER,SQL PLUS and Toad

Secretary of State, MS July'2006-Aug'2006

Migration of DMV signatures

Data MIgration

Description: The project involves the migration of 10 million signatures

and associating to corresponding voters. The source data is divided into

several folders/sub folders in zip format.

Roles & Responsibilities:

Coordinating with the DBA team to manage the database to accommodate

the 80gb data.

Created Database links and sequences for the process of Migration

Staging the signatures using a complex process of script generation,

pl/sql and SQL LOADER .

Analyzing the data and preparation of the Exception reports for those

signatures, which are duplicate and those which do not associate to

the voters

Creating the maps for Loading the signatures in to the target

database.

QA testing and final Exception/Assumption reports.

Technologies: Oracle Database 10g/9i, SQL LOADER, Oracle Warehouse Builder

SQL*Plus, PL/SQL, Win XP, TOAD

Secretary of State(MS) Jan' 2006 - June'2006

Electus

Data Migration

Description: The project involves the migration of 82 counties of voter

information from the Legacy system to the Oracle database. The process also

involves the preparation of Address libraries using a function which takes

the street file, street types as input. Finally, it also involves the

migration of Election and Voting histories information.

Roles & Responsibilities:

Staging the legacy data to Oracle Database using SQL LOADER.

Cleansing the data.

Creating Maps to load the data into the target Database using the

Oracle Warehouse Builder.

Creating complex dynamic scripts to insert and update the data.

Creating Procedures and functions.

QA testing and Preparation of Assumptions/Exception reports.

Technologies: Oracle Database 9i/10g, SQL LOADER, Oracle Warehouse

Builder, SQL*Plus, PL/SQL,Toad.

Secretary of State(IOWA) APR' 2005 -

JAN'2006

Electus

Data Migration

Description: The project involves the migration of 99 counties of voter

information from the Legacy system to the Oracle database. The process also

involves the preparation of Address libraries using a function which takes

the street file, street types as input. Finally, it also involves the

migration of Election and Voting histories information.

Roles & Responsibilities:

Staging the legacy data to Oracle Database using SQL LOADER.

Cleansing the data.

Creating Maps to load the data into the target Database using the

Oracle Warehouse Builder.

Creating complex dynamic scripts to insert and update the data.

Creating Procedures and functions.

QA testing and Preparation of Assumptions/Exception reports.

Technologies: Oracle Database 9i/10g, SQL LOADER, Oracle Warehouse

Builder, SQL*Plus, PL/SQL,Toad.

American Insurance, Houston TX Jan 2005-Apr 2005

Customer Information Management

Description: Worked on a Customer Information Management (CIM) project with

Developer 6i as Front end and ORACLE as backend. The system is designed to

store all customer information with a common point of entry for different

lines of business. Involved in writing stored Procedures & triggers which

involves searching customer, adding and editing current customer info

across different database tables across the system for multiple lines of

business. Backup, recovery, server maintenance and production support.

Roles & Responsibilities:

Interaction and meeting with clientele and understanding the

requirements.

Preparation/Presentation of Technical proposals, Design documents.

Database Administrator activities

Installation and Configuration of Oracle Database. Daily tape

backups.

Creating Tables, Views, Synonyms, Triggers and Procedures.

Tools:

Developer6i,Oracle8i, Designer6i, pl/sql

Ram Informatics Limited,INDIA 1996-2004

Eseva(http://www.esevaonline.com), State Government of ANDHRA PRADESH,

INDIA

Oracle Team Lead

Description: This project consists of computerizing the services like

payment of water and power bills, state and city taxes, telephone bills,

booking of bus, rail tickets etc. This project comprises around 30+

services including issuing of drivers licenses and various certificates of

the state agencies. This consists of large backbone database with

distributed data processing spread across a wide geographical area.

Team Lead activities

Interaction and meeting with clientele and understanding the

requirements.

Preparation/Presentation of Technical proposals, design documents.

Implemented the CRM module using JSP/JavaScript and JAVA.

Implemented email notification for complaints in all departments using

MS Exchange server and SMTP Server.

Database Administrator activities

Installation and Configuration of Oracle Database. Daily tape backups.

Creation of Users, Privileges, Roles to Clients Requirement,

performance monitoring and tuning.

Creation of Tables, Database links, Synonyms, Procedures and Database

Triggers using PL/SQL. Connecting to 15 Departmental servers using

Database Links.

Environment/Tools : Java, Jsp, Oracle8i, Oracle9ias, JavaScript

Digite Inc, SanJose, CA (USA) Oct 2000 - Jul 2001

Electronic Bill Presentment and Payment

Description: The Prospective Buyers and Sellers who are registered at

Digite can come to an agreement to Transact Business. The actual Business

Transactions like generating Purchase Orders, Invoices and recording

payments are part of the Application.

Responsibilities:

As a Team Leader I was involved in the following activities:

Interaction and meeting with clientele and understanding the

requirements.

Preparation/Presentation of Technical proposals, design documents.

Preparation of Design Documents, conversion of MS Access database to

Oracle database using SQLLOADER. Creating Tables, Synonyms, views,

Database Triggers using PL/SQL.

Environment/Tools:

Developer2000, Oracle App server 9i, PL/SQL, JSP, Oracle 9i, Designer 2000

and Windows NT.

APTS, Govt. of AP,india. Jun1999-Oct 2000

TWINS

Description: This is a pilot project in the first step of computerization

of all utility services under one roof concept. This project was started in

Banjara hills, Hyderabad. The project was very successful and the project

is fine tuned with latest java technology to the latest eSEVA project.

Responsibilities:

Interacted with the officials of the organization, observed and

analyzed the information needs and limitations in the manual system.

Involved in design, development of the process using Developer 2000.

Prepared User manuals and design documents.

Defined procedures and triggers using PL/SQL.

Developed forms and reports. Actively involved in User Training and

regular user interaction.

Software/Tools:

Developer2000 (Forms5.0, Reports3.0), PL/SQL, Oracle Application Server,

HTML, JAVA2.0, Servlets, JSP.

AGA Publications, Hyderabad. AUG1998-MAY1999

Integration of Financial Accounting System

Description : This project involves the Integration of Financial

Accounting System with the other modules of Payroll and Hrms, Circulation,

Advertisements, Purchase and Stores and Administration modules.

Role:

Interaction with the officials of the organization, to observe and

analyze the information needs and limitations in the current manual

system.

Preparation and presentation of requirement specifications and

functional specifications.

Designed templates forms for the entire system.

Involved in creating of Database links, synonyms and Integration of

System using Developer 2000 and Oracle7.3

Prepared User Manuals and Design Document.

Developed forms of Financial Accounting System Pertaining to Cash

payments, Cash Receipts of Hrms, Administration, Production and

Purchases & Stores modules.

Software/Tools:

Designer, Developer 2000(Forms 4.5/Reports2.5), Oracle 7.3,and PL/SQL.

Client: AGA Publications, Hyderabad. Jul97-Aug98

Financial Accounting System

Description : This project covers all the financial aspects like cash

receipts, cash payments, advances payed and the expenditures incurred along

with the allotment of funds to all the departments in the company.

Role:

Interaction with the officials of the organization, to observe and

analyze the information needs and limitations in the current manual

system.

Preparation and presentation of requirement specifications and

functional specifications.

Involved in creating of Database links, synonyms and Integration of

System using Developer 2000 and Oracle7.3

Software/Tools:

Designer, Developer 2000(Forms 4.5/Reports2.5), Oracle 7.3,and PL/SQL.

Client: AGA Publications,Hyderabad Jan96 - Jun97

Production System

Description: This project involves the main aspect of the AGA publication

that is production. Production comprises of collecting the reports from the

concerned departments of circulation and advertising and issuing a note to

the purchase order department which in turn starts the production process.

Role:

Interaction with the officials of the organization, to observe

and analyze the information needs and limitations in the current

manual system.

Preparation and presentation of requirement specifications and

functional

specifications.

Designed templates forms for the entire system.

Involved in creating of Database links, synonyms and Integration

of System

using Developer 2000 and Oracle7.3

Prepared User Manuals and Design Document.

Software/Tools:

Designer, Developer 2000(Forms 4.5/Reports2.5), Oracle 7.3 and PL/SQL.

Awards:

* Certification of Appreciation by the Director, eSEVA (AP govt) - 2001

* Certification of Appreciation by the Director, eSEVA (AP govt) -

2002Services Management Excellence Award by the Director, eSEVA (AP

govt) - 2003.

Contact this candidate