Oracle Developer

Kavitha Katakam

**** ****** *****

Gaithersburg, MD 20878

Tel: 240-***-****

E-mail: ********@*******.***

[pic]

Summary

. 10 Years of experience in all phases of life cycle development, and over

3 Years of experience as an Oracle DBA with the Department of Defense.

. Specific strengths in analyzing customer requirements, business

processes, and their development into practical current technology with

computer systems.

. Business Process Reengineering and migration of legacy systems to

relational architectures.

. Excellent experience in Database design, data modeling, conversion,

tuning and database administration programming and optimization.

. Excellent knowledge and experience in writing complex stored procedures,

stored functions, database triggers and packages using PL/SQL.

. Excellent functional knowledge with the Department of Defense, public

safety and real estate services.

. Excellent Knowledge in Tax reporting, analysis, Federal, State, School,

City taxes and property taxes.

. Effective analytical, organizational and communication skills

. I have an Oracle 9i, 10g Certified Associate Database Administrator, and

Forms 9i Developer Certified Professional.

. I am a good team player and can excel in any environment.

. I am a US Citizen.

Clearance Held: Top Secret (SSBI): Department of Defense.

Education

. Oracle Database Certified Associate - Oracle 10g; 2008

. Oracle Database Certified Associate - Oracle 9i; 2005

. Oracle Forms 9i Developer Certified Professional - Oracle 9i; 2004

. Trained Oracle Professional 6i - Oracle University; 2002

. M.A. in Economics - Osmania University, India; 1991

. B.A. in Econimics - Osmania University, India; 1989

. Post graduate diploma in Computer Applications, National Computing

Council, India.

Technical Skills

Hardware/Software: Windows 95,98,NT,2000, 2003, XP; Microsoft Office

Professional for Windows 95,97,2000, 2002, 2003, 2007;

Microsoft Project; Lotus Notes 4.5, 5.1; PVCS Version

Tracker; Microsoft SourceSafe; Visual Slick Edit.

Databases and Languages: Oracle7, 8, 8i, 9i, 10g; Developer/2000, R6.0,

6i (Forms 4.5, 5, 6.0; Reports 2.5, 3, 6.0, 6i, 10g; Graphics 2.5);

Designer/2000, R6.0; SQL; SQL*Plus; PL/SQL; Native Dynamic SQL; PL/SQL

Web Toolkit; Oracle 9iAS Application Server; Oracle HTTP Server for 10g;

Oracle 10g Reports Server; Oracle Enterprise Manager; Oracle Text; SQL

Loader; SQL Net; Migration Workbench; TOAD DBA Version; Crystal Reports; MS

Access; Business Objects; HTML; Javascript.

Professional Experience:

DBA/Developer

SOFTWORLD Inc

Jan2010 - Present

Serving as DBA and as Developer for the Department

of Energy Budget Office. Working on Legacy migration, converting reports

from COBOL to Oracle 10g. Developed numerous reports for Funding

Distribution System.

DBA/Developer

Universal Hi-Tech Development, Inc./ SERCO Inc

Oct-2003 - Jun- 2009/ Jun-2009 - Dec - 2009

Served as DBA and as Developer for the Program Budget Office of

the Army Research Laboratory. Managed storage and security for databases

and wrote scripts to automate DBA duties. Involved in the architecture and

design for new development, test and production databases. Installed,

patched and configured web servers and Oracle 9i, and Oracle 10g RDBMS

databases. Developed and implemented a comprehensive backup process for PBO

databases including HOT and COLD backups and full database exports.

Configured Oracle Text for file search capabilities in BLOBs. Created new

databases and refreshed development, test databases from production

periodically. Loaded data from outside sources through SQL Loader.

Implemented database refresh using IMPORT/EXPORT utilities.

Programmed and developed PL/SQL web pages using database procedures,

functions, packages, PL/SQL Web Toolkit and Html for applications.

Functioned as a team lead. Developed numerous Oracle Reports as per

customer specifications. Designed and incorporated methodologies for

dynamic generation of report parameter forms and web spreadsheets.

Responsible for the entire life cycle development of the project

requirements gathering to deployment. Supported customers and assisted

coworkers with PL/SQL and Oracle reports and DBA responsibilities.

City Of Pittsburgh, Pittsburgh.

June 2000-Sep2003

Senior Systems Analyst

I was involved in developing Incident Management, it is a comprehensive web

based search software system designed for public safety department of city

of Pittsburgh as well as outside agencies. Incident Management consists of

multiple search modules and CRIMES data can be searched on

Offense/Person/Vehicle/Location/Firearm/Property etc. CRIMES Data entered

into the system is stored on an Oracle 9I based Data Warehouse. Performance

is a key factor when searching such huge volumes of data. The data

retrieval and data transferring techniques designed accomplished this.

Application was developed on Oracle 9i database using PL/SQL- Stored

Packages, Procedures, Functions, Database Triggers to populate the data

mart tables and Forms 6i tool for front end GUI interface using SSL

technology for security.

I was Responsible for entire life cycle development of the project

requirements gathering to deployment and developed PL/SQL- Packages,

Procedures, Functions, SQL Scripts, and Database Triggers.

Developed and maintained Oracle databases in a large warehouse environment.

Responsible for reviewing, analyzing, and modifying programming systems

mainly in SQL and PL/SQL and Developed complex Oracle Reports and Oracle

Forms with Graphic features, Implemented DBMS_JOB and scheduling those jobs

at night and electronic data load using SQL*LOADER scripts.

I also developed Stored Procedures to send e-mails to the users depending

upon failure or successful completion of jobs using UTL_SMTP package and

Developed Security Packages

utilizing DBMS_OBFUSCATION_TOOLKIT for data encryption.

Extensively used Designer 6i to generate Forms, Reports and Data Modeling.

Developed a Complaint tracking system to the City of Pittsburgh MSC is City

department, which handles complaints from city residents. Complaints

usually come in via telephone. These complaints cover a very broad

spectrum of items over 600 "categories" of problems. In the system these

are items are known as problem categories, which are further broken down

into problem types. The call taker speak to the person complaining, and

gather a variety of information about the complaint. This data is then

saved into the MSC database via the application program used by the call

takers. Once the data is saved, then complaint is then sent to the entity

via auto-populated E-mail to the concerned departments that is responsible

for resolving the complaint. Reports were generated such as percentage

reports, complaints completed, resolved etc., using oracle reports 6i.

The Warrants and Complaints module is designed to generate and track

criminal complaints initiated by a police officer and other legal

documents/reports related to those complaints. The warrant (or the summons)

instructs the defendant to appear before the magistrate at the Municipal

Court Building at a specified date and time, for a preliminary hearing on

the charges listed in the document. Application developed on Oracle8i

database using PL/SQL- Stored Packages, Procedures, Functions, ETI tool to

populated the data mart tables and Developer 2000, Forms 6i, Reports 6i,

for reports.

I was Responsible for gathering of business requirement and developing

specifications for an application. Developed PL/SQL- Packages, Procedures,

Functions, SQL Scripts. Wrote technical specifications for data extracts,

transformations, and loading data (ETL) to dimensional data warehouse

structures,

Wrote Oracle Stored Procedure to send mails within the application using

Oracle UTL_SMTP Packages. Developed SQL*Loader programs to load data from

flat files to Oracle. Developed about 30-40 complex Oracle Reports with

Graphic features for Web Deployment. Involved in Performance and tuning all

the Applications for the best performance. Developed Specifications, Test

Plans, test Cases and performed Unit, System and Integration testing.

I was involved in developing Section 8 Addresses is a comprehensive web

based search system designed for the dept of Housing Authority for section

8 Housing. In this search module an Officer try to locate an address for

section 8 to see any offenses (CRIMES) related to that address exists.

CRIMES Data entered into the system is stored on an Oracle 9I based Data

Warehouse. Application was developed on Oracle 9i database using PL/SQL-

Stored Packages, Procedures, Functions, Database Triggers to populate the

data mart tables and Forms 6i tool for front end GUI interface using SSL

technology for security.

I was responsible for gathering of business requirement and analyzing

existing systems,

Creation of a new database in Oracle and Generation of Reports for all the

addresses and related offenses. Work with Oracle utilities (UTL_FILE,

FTP) used to load the data from flat files to Oracle. FTP can be directly

done from the application.

As a Senior systems analyst developed PARS (Performance Analysis and Review

System) for

public safety department to closely track its police officers their

training, performance evaluations, use of force, work on special units and

more. Meanwhile, using the software, the chief of police and commanders

also gleaned insights into the causes of accidents, vehicle management, and

other gritty police issues. It became a management tool and a cost-saver.

Used Oracle designer/ERWIN to model, reverse engineer and design effective

business data model. Responsible for overall design, development and

administration of the database. Responsible for implementation of a

replication strategy using Advanced Oracle Replication. Extensive PL/SQL

and UNIX CRON shell programming was used to facilitate data transfer.

Established guidelines on merging data from various data sources into one

central repository.

Programmer

THK Consulting, Inc

1998 - 1999

As a Programmer developed Inventory Tracking System, Oracle Apps was

implemented to enhance proper planning and scheduling in their various

manufacturing units. The main modules are Inventory control and Production

Planning. Comprehensive modules were developed to keep track of sales and

inventory and this system automatically generates ordering of items based

on optimized analysis of re-order level and re-order quantity. This system

also handles pricing policy, discounts, pending orders and reduced

inventory before tax time. A financial module was also developed for

handling the billing functions of the Material Management System.

References: Available upon request.

Contact this candidate