NAGASREE UPPU, OCP, MBA

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

Pickerington, OH 43147

( 614 ) 856 - 2071

abmqh4@r.postjobfree.com

OBJECTIVE

Mutually rewarding professional affiliation in which I may apply and

expand my expertise in Systems Technology Consultant or information

management that will offer me a challenge and advancement career.

PROFILE

Over 12 years of increasingly responsible experience in all aspects of

Oracle Database Administration in fast growing environment. I am US

citizen, motivated, personable business professional with multiple

college degrees and a successful track record of work ethics. Talent for

quickly mastering technology, trouble shooting, problem solving tactful

with professionals and non-professionals at all levels. I am also

flexible and versatile, able to maintain a sense of humor under pressure,

poised and competent with demonstrated ability to easily transcend

cultural differences, thrive in deadline-driven environments and

excellent team-building skills.

Skills Summary

Oracle 7i, 8i, 9i & 10g Standby/Failover ERWin

Database Administration SQL*Plus TOAD

PL/SQL IGNITE

Performance Tuning & SQL Tuning Project Management

Capacity Monitoring OEM Unix Shell Scripting

Data Security Data Guard Secured FTP

RMAN Backup & Recovery Visio ETL

Oracle Partitioning Oracle STREAMS

Project Management

o DEVELOP THE ARCHITECTURE ROADMAP FOR ALL ASPECTS OF PROJECT LIFE CYCLE.

o SDLC METHODOLOGIES

o GATHER BUSINESS REQUIREMENTS

o ANALYZE AND DESIGN PROBLEM OR NEW REQUEST RESOLUTION

o CODE MODULES ACCORDING TO SPECIFICATIONS AND CLIENT STANDARDS

o DEVELOP PROGRAM AND SYSTEM DOCUMENTATION

o CONDUCT PROGRAM AND SYSTEM IMPLEMENTATION

o MAINTAIN APPLICATION PRODUCTION ENVIRONMENT

WORK EXPERIENCE

3/2010 to Present Chase Works

. Analyzing existing infrastructures and processes and provide

solutions to customer's vision, needs and goals

. Responsible for identifying, analyzing and translating business

needs into specifications.

. Make recommendations, consultation and advice regarding

system/business process enhancements.

. Leading the team in reverse engineering and rewriting database

processes.

. Responsible for the accessibility, usability and maintenance of the

Oracle databases

. Re-engineering, data modeling and managing Oracle 11i databases

. Accountable for database creation, performance testing, tuning and

benchmarking.

. Design and development of Application & Admin Modules

. Rewriting PL/SQL stored procedures

. Rewriting nightly, cut-off dates and monthly batch processes (ETL --

Extract, Transformation, and Load)

. Establishing and enforcing database and security standards

. Responsible for program design, coding, testing, debugging, and

documentation.

3/1998-3/2010 NATIONWIDE Insurance Columbus, OH

Consultant, Data Eng/Admin

o Worked as team leader in database design

o Managed data center migration project (Database portion) from

Cleveland to Columbus.

o Involved in migrating databases from AIX/Lunix to Sun Solaris

Platforms and upgrading databases from 9i to 10g

o Participated in architectural planning and making recommendations

regarding structure, capacity management, security and operations.

o Developed, maintained, enhanced, and executed database extraction,

database loading and data purging activities.

o Wrote shell scripts to extract data from trigger files and loaded into

tables on a daily basis by scheduling jobs in Unix environment and

ensured the general health of all such scheduled processes.

o Identified potential issues or areas of opportunities for future

process improvement projects.

o Collaborated and coordinated on the project development with PM and

Management to deliver the proper product/service on schedule and

within the budget.

o Utilized SQL*Plus, SQL*Loader, data pump, exp/imp, TKPROF, Oracle

scheduler, advanced queues, object management as needed to meet the

development needs.

o Accountable for database creation, performance testing, tuning and

benchmarking.

o Documented all database problems.

o Provided database problem diagnosis and resolutions in development and

production environments.

o Monitored database performance, involved in database tuning,

maintenance and recovery.

o Gathered database and object level statistics.

o Ensured that all databases met architecture standards and

specifications, and development methodologies and associated

deliverables are maintained and followed for database projects.

o Provided capacity planning required in creating and maintaining the

databases.

o Established standards and procedures for database systems.

o Provided leadership in solving problems with database migration and re-

engineering.

o Headed several independent projects including database installs,

upgrades, rewrites, and optimization.

o Served as technical representative and responsible for architecture

and feature definitions.

o Involved in project life cycle including requirements, specifications,

development, implementation and maintenance.

o Responsible for project planning, requirement analysis and technical

specifications.

o Analyzed and assessed the impact of production system changes to

existing analytic and implemented changes to ensure consistency and

accuracy.

o Developed database backup and recovery plan using RMAN

o Worked with IT management team in developing database backup and

recovery plan and corporate database security policies.

o Worked with application teams to support the front end.

o Constructed entity relationship diagram (ERD) for data modeling using

ERWin and Visio.

o Documented logical database design and physical database design using

ERWin.

o 24/7 On-call responsibilities.

o Involved in Requirement Analysis, Design, Development and

implementation during datacenter migration and projects.

o Performed all aspects of database administration including installs,

builds, upgrades, object sizing, object creation, backup/recovery,

patches, monitoring, export/imports, and materialized views.

o Rebuild entire database in Oracle 8i, 9i & 10g

o Performed SQL tuning using Ignite and OEM

o Involved in root cause analysis and proactively identified alternative

corrective solutions.

o Monitored database performance and 24/7 availability.

o Monitored storage availability.

o Design and development of Application & Admin Modules

o Monitored space usage of application objects using TOAD

o Involved in capacity and resource planning. Estimated the size of data

files and redo log files considering transactions rate, transaction

records size, transaction type, and volatility of the data, recovery

time allowed etc.

o Identified performance bottlenecks like queries utilizing high CPU,

internal lock waits, row locks, redo log buffer waits and etc using

OEM and Ignite.

o Responsible in recovering from user and application errors.

o Monitored database at system and application level using TOAD.

o Implemented many stored procedures, packages and triggers for

extracting data to the warehousing database.

o Data modeling and daily management of schema objects.

o Involved in system/application/user level auditing.

o Unix shell scripting.

o Server / Database consolidation to save costs.

01/97-03/98 AMERICAN FAMILY INSURANCE Madison, WI

Programmer Analyst

* Maintained Oracle databases

* Dealt with third party software vendor

* Maintained vendor database in Access

* Programmed in Natural, Cobol and JCL

* Personal Oracle 7.3, Mainframe, Windows NT, MS Office

* Little bit involvement in developing Oracle Reports and

Forms

05/96 - 1/97 WINNEBAGO MENTAL HEALTH INSTITUTE Winnebago, WI

Internship, LTE 3

* Responsible for updating old spread sheets, data base and

word processing files into

related MS Office

* Created MIS Inventory by using Access

* Assisting users with software and hardware related problems

* Provided more organized programs without any redundancy or

no need of retyping

* Setting up follows up and survey program for recovering

patients

EDUCATION University of Phoenix - Phoenix, AZ

MBA, JUNE 2009

UNIVERSITY OF WISCONSIN OSHKOSH Oshkosh, WI

Bachelor of Science, Computer Science, December 1996

NAGARJUNA UNIVERSITY Vijayawada, A.P.

Bachelor of Science, Physics, May 1989

CERTIFICATES FROM ORACLE EDUCATION

. Introduction to Oracle: SQL & PL/SQL Using Procedure Builder

. Database Administration

. Backup and Recovery

. OCP 8i Certified, 2004

OTHER CERTIFICATES ( Classes offered by Nationwide Insurance Enterprise )

. Understanding TCP/IP

. Shell Programming

. PL/SQL

. Advanced JAVA Programming

. Hypertext Markup Language ( HTML )

AVAILABILITY Open

REFERENCES Available upon request.

Contact this candidate