Senior Oracle Developer and Database Administrator

Anoop Pandra ***********@*****.*** (Phone: 720-***-****)

Objective:

Pursue a career as a Oracle Developer, Technical Lead, Oracle Database Administrator, or a Data Architecture in a dynamic environment, which makes full use of my Oracle systems development experience, expertise in Architecture, Design, Development and Deployment of wide variety of applications.

Summary: with over 17 years (11 years in US) of experience as a Database Architect/Project Lead/Systems Analyst/Programmer for a wide variety of applications.

12+ years Strong experienced in Oracle Database Design and Development using Oracle tools and related products SQL, PL/SQL and PERL, C, Unix Shell (Ksh) Programming.

2+ years as ORACLE DBA (Production Staging, SQT Test and Development environments) on Windows NT platform/Unix/Linux.

1+ years of experience in DATA Modeling (Extensively used Rochade a Data Modeling Tool, BPWin, Designer/2000 and Rational rose)

Technical skills: Windows NT, UNIX, VM Ware, Shell Scripts, Pro*C, C, PERL, Oracle 10g, PL/SQL, SQLPLUS, SQL*Loader, Oracle Enterprise Manager, Rational Rose, Rochade Data Modeling, SQL*Navigator, Developer/2000, Designer/2000, TOAD, Visual Basic, Oracle 11i E-Business Suite, Oracle 10G Application Server.

CMM & Deployment Tools: PVCS, Configuration Management.

AWARD: Received award best Team from Client for the year 2004 and 2005 - (DFAS Denver).

Educational:

• Master of Science - (Information Technology), Colorado Technical University - 2002, Colorado. (3.8 GPA)

• Bachelor of Accounting – Majors in Cost Accounting/Taxation – Osmania University –Andhra Pradesh, India - 1988

• Associated Diploma- Computer Programming and Applications - United Kingdom 1990.

Certification:

Oracle Database 10g Administrator Certified Associate (OCA)

Oracle Financial - 11i System Administrator Certified Expert (Oracle Certified Expert)

Training: Oracle University

• 11i Install Patch and Maintain Oracle 11i Applications – Oracle University.

• 11i System Administrator Fundamentals - Oracle University.

• 11i E-Business Suite Essentials for Implementers – Oracle University.

DETAILED CAREER HISTORY:

COMPUTER SCIENCE CORPORATION (CSC) : June’2000 to Till Date.

Senior Oracle Developer

Oracle 11i E-Business Suite (6 Months Experience)

• Installed Oracle 11i E-Business Suit (single node, multi node), configuration 11i on Linux Operating System, and applied patches using AD Utilities.

• Assigned Users, Functional responsibilities, and profile for Oracle applications.

• Maintained and configured Oracle products (i.e. E-Business, Database, IAS) on various platforms, and performed cloning for test environment.

• Initiated and participated in troubleshooting of errors, bugs found by Development team and customers service requests using Oracle technical support (Metal ink).

Project Description – Departmental Cash Management System May’2003 - to date.

DCMS manages and reconciles all Air Force cash disbursements, reimbursements, collections, and receipts department-wide.

Key Achievements:

• Created Design and technical specifications using the Business requirements and lead team in Full life cycle development.

• Created Oracle security for password encryption using Oracle 10G Wallets feature.

• Lead SQT/CMM/Development Team to do regression testing, resolve global issue and perform the release management strategy for product delivery.

• Played a leading role to create innovation process to remove the Cogons Impromptu report tool for entire DOD system by using Oracle PL/SQL, SQL, and Incorporated failure over process using Oracle Standard Email.

• Optimization of load process, PL/SQL validation for development and production environment.

• Created an innovative process improvement methodology using PL/SQL, Perl and shell scripts for Production and SAT environment.

• Resolved global problem during system Deployment/Support directly interacting with end users in real time. Developed PL/SQL usage standards, data naming standards, security standards, reporting standards, user access standards and procedures.

Environment: Oracle 10g, SQL*Loader, UNIX Shell Scripts, PVCS, Perl DBI/DBD ______________________________________________________________________________

Architect/Database Administrator for (DOD–DFAS Denver) Feb’2002 – May’2003

Project Description: Metadata repository for (Military pay system)

Responsibilities:

• Repository file space, access control, access availability and determine security, User profile granting / restricting access to the Metadata Repository.

• Assesses and assigns appropriate level of security for each Metadata Object.

• Ensures backup and recovery of repository contents on a predetermined basis.

• Monitors the repository contents for completeness and accuracy.

• Implemented, monitors batch processes for metadata load process and data validation.

• Administers the Metadata Repository for (DFAS-Denver), test, maintains repository software components, Monitors vendor website for upgrades and patches.

Environment: Erwin, Rational Rose, Rochade Data Modeling Tool, Windows NT. ______________________________________________________________________________

Oracle Database administrator for (DOD–DFAS Denver) Sept'2001 - Feb'2002

Project Description: Database Administration for DBA Support Group for DOD - DFAS Denver.

Responsibilities:

• Oracle upgrade from 8.1 to Oracle 9i.

• Performance Tuning and Remote sessions tracing, Daily Backup.

• Altering the Database objects and files maintenance during system development.

• CRON jobs scheduling, troubleshooting and maintaining the databases.

• Setting Oracle Password, PL/SQL Coding, regression testing, Production, SAT deployment, maintenance and other DBA activities.

• Oracle database space requirements, created database objects on various schemas, prepared data models and perform tuning activities for existing software.

Environment: Oracle 7/8/9i/10g, Windows NT 4.0, Oracle Enterprise Manager, shell, Perl. ______________________________________________________________________________

Mercury Technologies – TX (Sub Contractor to CSC) May’98-Sept’2001.

CSC – June 2001. System Analyst/Programmer for (DOD – DFAS Denver)

Project Description:

a) DIFS-R is a centralized finance and accounting for (DOD Agency - DSCA).

b) Voucher processing system (VPS) for DOD Mar’99- Mar‘00

Responsibilities:

• As Team lead the developing team of 2 programmers.

• Prepared Logical and Physical Design for DOD - DSCA project using Designer/2000.

• Prepared critical design review, impact analysis, and strategic plans on how to use MS Help Generator for all Oracle forms 4.5 and reports 2.5, incorporated MS Help in 32 forms and reports.

• Developed Oracle Menus, Forms and reports for the project and implemented the Oracle Security Password Management using oracle wallets.

• Created various reports using Oracle Report Server and Schedule the report using Perl and shell programming.

• Designed Client Server methodology using Oracle Designer/Developer 2000, PL/SQL, Perl, Shell Scripts and libraries.

• Download the flat file from the old system and convert the flat file using sqlloader and load the data into an oracle tables and generate report.

• Customized Forms and Reports to improve the performance of the Existing system by writing new procedures, functions and libraries.

• Optimized the user interface objects and fine-tuned the application to obtain maximum efficiency of the system.

Environment: Designer/2000,PL/SQL,WindowsNT4.0,Oracle Enterprise Manager, shell, Perl.

Worked with IBM – New York, Optum Inc – North Carolina, and Cybernet Solutions Inc – TX. (July 1998 - March 1999 as Systems Analyst/Programmer)

Project Description:

• Developed a Proto-type application Time and Attendance using Oracle Forms 4.5 and reports 2.5 and Customized and modified an existing project for cybernet and Optum.

________________________________________________________________________

NexWave Info Systems - Project Leader - July 1997-April 1998

Project Description: Sales, Inventory, Management Information and Material Procurement system FOR (BHARATH DYNAMICS LIMITED (DOD - INDIA)

Responsibilities:

• As project leader managed developing team of 10 programmers.

• Maintained Development database, Reengineered PL/SQL objects and fine-tuned the application to obtain maximum efficiency of the system.

• Assisted in the migration team and manual conversion of more than 50 forms and reports to the latest version of Oracle forms and Optimized the user interface objects.

• Implemented modules for System testing / Production and deployment.

Environment: ORACLE 7.i PLSQL, UNIX, USING ORACLE FORMS 3.0 AND REPORTWRITE 1.1. _________________________________________________________________ Informatics and Intrax Technologies as Analyst/Programmer (May 1990-June 1997):

Experience with Healthcare/Data Warehousing /Chains of Stores/Financials Domains and other industries experience.

Contact this candidate