Oracle Apps DBA/Developer Resume

Title
Oracle Apps DBA/Developer

Primary Skills
Oracle apps,finacials,10g,9i,8i,pl/sql, Oracle Database 10g Installation, Upgrade, Administration,Installation

Location
US-CA- (will consider relocating)

Posted
Jan-29-09

DESIRED ROLE
Looking for a Role where I can demonstrate my skills to manage Oracle Applications Implementation, including installation, maintenance, upgrades, performance tuning and providing end user support in resolving technical and functional issues.

EXPERIENCE SUMMARY
Total 11 years of I.T. experience. 8 years as an Oracle Applications DBA R12/11i.

EXPERTISE
• Oracle Applications R12 / 11i Installation, Upgrade, Patching, Administration (AD Utilities), 24x7 Support.
• Oracle Database 10g Installation, Upgrade, Administration.
• Oracle 10g Application Server, Installation, Upgrade.
• Performance Tuning, PL/SQL Tuning, Indexes.
• Oracle DataGuard Setup.
• Database Backups, Export/Imports, and Disaster Recovery.
• TOAD, Oracle Enterprise Manager, SQL*Loader.
• UNIX Shell Scripting.
• Customization and some functional knowledge of GL, AP,AR,FA,PO, OM, and CM for Rel. R12 / 11i / 11.0.3 / 10.7 and Rel. 9.4 with 10g/9i/8i RDBMS.
• Strong experience in designing and development of interfaces of legacy system with Oracle Apps. for FA, GL, AP, AR, OM & Cash Management modules.
• Good knowledge and experience of testing methodology.
• Operating System Used Linux 3.0, Sun Solaris 2.x, 5.8, Unix, Windows 2000, Windows NT, Windows 98.
• Active participation in Oracle Forum on Metalink.

CAREER HIGHLIGHTS
• Single handed upgrade of 11.0.3 to R12 with RDBMS upgrade to 10g for Building and Construction Authority (BCA), Singapore, including planning of hardware, defining systems strategy, developing systems requirements, testing, training, resolving post upgrade functional and technical problems.
• Excellence award for Oracle Applications Upgrade from 11.0.3 to R12 at Building and Construction Authority.
• Five complete Implementations Cycles of Oracle Applications Financials and Supply Chain.
• Four Migrations/Upgrades Projects experience in Oracle Applications.
• Experience in Workflow Customization.
• Have strong analytical skills, willing to learn and adapt to new challenges. Ability to interact with end-users, managers, technical personnel, self-motivated a quick learner and team player.

ACADEMIC QUALIFICATION
Post Graduate Degree -- Master of Computer Science and Applications (M.C.A) (MS -- Computer Applications).

PROJECTS SUMMARY
CYPRESS SEMICONDUCTOR CORPORATION, SAN JOSE, CALIFORNIA, U.S. FEB'08 -- DEC'08
DESCRIPTION: IMPLEMENTATION Cypress Semiconductor Corporation is a manufacturer of Lighting, Buffers, Controllers, Electronic Electric Motor Controllers, Liquid Crystal Display (LCD) Glass, Meter Design, Modems, Motor Controls, Programmable Logic Devices (PLD), Temperature Controllers, Universal Serial Bus (USB) Accessories, Programmable Clocks, Lighting with Ballast, Programmable Read Only Memory (PROM), Embedded Controllers etc.

Oracle Applications 11i /Oracle 10g (10.2.0.3)
Team Size 10
Operating System Sun Solaris
Location San Jose, CA
Role and Responsibilities: I worked as DBA / Module Lead, Providing 24x7 troubleshooting and support for the Oracle Applications, Installation, maintenance performance tuning, configuring environment files, Running AutoConfig, Patching. Resolving User Functional and Technical Issues, SR creation and follow-up to resolve the issues.

I also supported Development team in designing and writing interfaces, Data Migration of Sales Orders, Quotes, Customer Master & Price List etc.,Tuning of Stored Procedures / interface programs.

BUILDING AND CONSTRUCTION AUTHORITY (BCA), SINGAPORE JUN'07 -- JAN'08
DESCRIPTION: UPGRADE OF APPS 11.0.3 TO R12
Building and Construction Authority (BCA) is a Government Organization under the Ministry of National Development, championing the development of an excellent built environment for Singapore. Safety, Quality, Sustainability and User-Friendliness are four key areas where BCA has a very significant influence on the built environment and they distinguish Singapore's built environment from those of other cities.

Oracle Applications Release R12 / 11.5.10.2 (GL, AP, AR, FA, PO, ASC Planning and CE), Release 11.0.3
Team Size 1
Operating System Sun Solaris
Database Oracle 10g (10.2.0.3)
Role and Responsibilities: I completed this project alone, without any support of DBA, Technical Developer or Functional Consultant; Activities included defining system upgrade strategy, developing systems requirements, designing, testing, training, defining support procedures for Upgrade of Apps 11.0.3 (RDBMS 8.1.7) to Apps 11i, Installation of Apps 11i, Upgrade of RDBMS 8.1.7 to 10.2.0.3, Upgrade of Apps 11.0.3 to Apps 11i, Providing 24x7 troubleshooting and support for the Oracle Applications, Resolving User Functional and Technical Issues, SR Creations and follow-up to resolve the issues, Patching, DR Server Setup using Oracle DataGuard, Cloning, Migration of custom reports, forms and Stored Procedures/Packages from 11.0.3 to R12, Performance tuning of Stored Procedures / Reports.

FUJI XEROX ASIA PACIFIC PTE LTD. CORPORATE HEADQUARTER NORWALK, CT, USA AUG'04 -- MAY'07
DESCRIPTION: IMPLEMENTATION AND MIGRATION FOR 11.5.9
Headquartered in Norwalk, CT, USA and Tokyo, the Fuji Xerox organization includes more than 200 sales locations throughout USA, Japan and 13 overseas subsidiaries, as well as manufacturing, research and development facilities in strategic sites.

Oracle Applications Release 11.5.7 (GL, AP, AR, FA, OM, INV, PO, CRM, CONS Module and Planning), Release 11.0.3, Oracle 9i
Team Size 12 + 4 DBA
Operating System Solaris (5.8)
Role and Responsibilities: Technical Lead / DBA
Fuji Xerox currently migrated from 11.0.3 to Oracle Applications rel. 11.5.9 for GL, AP, AR, FA, OM, INV, PO, and Planning. Migration of custom reports, forms and Stored Procedures/Packages from 11.0.3 to 11.5.9, Providing 24x7 troubleshooting and support for the Oracle Applications, Shell scripting to automate various job scheduling, interface, backup etc., Design/Development of New Stored Procedures/Packages, Performance Tuning of PL/SQL Procedures/Packages, GL, AP, AR ,OM, CRM, CONS Module and Pricing Support

CONTAINER CORPORATION INDIA LIMITED OCT'03 -- JUL' 04
DESCRIPTION: IMPLEMENTATION AND DATA UPLOADING FOR 11.5.7
The company was set up by Indian Railways with the objective of developing multi modal logistics support for India's International and Domestic containerized cargo and trade. The task was to provide customers with the advantages of direct interaction and door to door services that formed the backbone of road transport, while capitalizing on the robust and more economical option of rail movement on the Indian Railways network.

Oracle Applications Release 11.5.7 (GL, AP, AR and FA), Oracle 8i
Team Size 6
Operating System Solaris (5.8)
Role and Responsibilities: Oracle Apps DBA / Technical Lead
CONCOR currently switching over to Oracle Applications rel. 11.5.7 for GL, AP, AR & Assets, My responsibilities included Trouble shooting of Oracle Applications Rel. 11i (11.5.7) on Sun Solaris, Trouble shooting for Web Logic Server issues, Technical Specs for uploading the Data in FA from legacy system, Uploaded 40,000 Assets data from legacy system in to Oracle Assets, Defining and load balancing of Conc. Managers, Disks Space management, Registration and Troubleshooting of the reports and other database issues.

PTTEP (THAILAND) SEP'02 -- SEP'03
DESCRIPTION: DEVELOPMENT / CUSTOMIZATION OF REPORTS FOR APPS.11.5.3
PTTEP is Thailand's only fully integrated Gas Company with a dominant position in oil marketing and trading. PTTEP is determined to operate business in an efficient manner rendering utmost satisfaction to customers, public and stakeholders. PTTEP Currently using the Oracle Applications Rel. 11.5.3 (GL, AP and AR) and need some new reports to meet their requirements.

Oracle Applications Release 11.5.3 (GL, AP and AR), Oracle 8i
Team Size 3
Operating System Solaris (5.8)
Role and Responsibilities: Technical Consultant / Team Leader
Requirement gathering, end-user interactions, Development of Functional Specs., Development of Technical Specs., Development of Reports., PL/SQL Tuning, Registration and Troubleshooting of the reports and other database issues.

CADENCE DESIGN SYSTEM INC. -- SAN JOSE, CA, USA DEC'01 -- JUL'02
DESCRIPTION: MIGRATION OF ORACLE APPS 9.4 TO 11I
Cadence is the largest supplier of electronic design automation products, methodology services, and design services.
Cadence currently using Oracle Applications Rel. 9.4 and wants to migrate the same to Rel. 11i. This project is divided into two phases.
Phase I: Migrate the Rel. 9.4 to Rel. 10.7.
Phase II: Migrate Rel 10.7 to Rel. 11i.

Oracle Applications Release 9.4 / 10.7, 11i on Sequent / Sun Sparc Solaris, Oracle 8i, 7.3.2.2.0
Team Size 10
Operating System Sun Sparc Solaris
Role and Responsibilities: Oracle Apps DBA / Technical Consultant
As an Oracle Application DBA, I am responsible for performing the Pre Migration Steps, Perform AutoUpgrade, and Post Migration Steps.
Identified and analyzed customizations in Oracle Applications Rel. 9.4 for GL, AP, AR, PO, PA modules at schema level with respect to the functional specifications and design specifications given by Cadence, Identified the customized concurrent programs / forms / menus / responsibilities in Oracle Applications Rel. 9.4, Migration of Oracle Applications Rel. 9.4 Database Objects to Oracle Applications Rel. 10.7 and then 11i, Troubleshooting ADAIMGR driver files during migration, Installation of Oracle Applications Rel. 10.7/11i on Sun Solaris.

VCUSTOMER CORPORATION, WASHINGTON, USA JUN'00 -- NOV'01
DESCRIPTION: IMPLEMENTATION OF ORACLE FINANCIALS 11.0.3
VCustomer is a global services company with offices located in the United States and India.

Oracle Applications Release 11.0.3, Oracle 8i
Team Size 7
Operating System Windows 2000/NT
Role and Responsibilities: Technical Consultant / Oracle Apps DBA
Migrated the Oracle database from 8.0.5.0 to 8.1.6.,Upgraded the Operating System from WindowsNT on Compaq-Proliant machine to Windows2000 on HP-SureStore machine, Moved the Database files across multiple disks for performance enhancement., Developed the script for taking Hot backup., 24x7 Support, Patching, Cloning

DLF UNIVERSAL LTD., NEW DELHI. JAN'00 -- MAY'00
DESCRIPTION: DLF Universal Ltd. is one of the largest construction groups in India, and it has the business in Sales/Purchasing of properties, housing societies. For these reasons the company had to communicate with the bank no. of times for the reconciliation of the statements, so there was a need to develop the automated reconciliation between the bank and the Oracle Application.

Oracle Applications Release 10SC General Ledger, Accounts Payables (Oracle 8.0)
Team Size 4
Operating System Windows NT
Role and Responsibilities: Technical Consultant
Responsible for requirement analysis and identification of Business process of DLF Universal Limited, for Customization, Responsible for uploading the data from Bank to the Cash Management Module, Responsible for implementation of the complete Solution for reconciliation purpose, Created New Reports and Forms in Oracle Cash Management.

MAKESS (ERP) AUG'97 -- DEC'99
DESCRIPTION: DEVELOPMENT OF ERP SOFTWARE
Eastern Software Systems (ESS) Limited is developing its ERP software called 'MakESS' a software with 13 modules to cover overall functioning of an organization.
HR & Payroll Module: It covered all the functioning of any Human Resource and finance department for its Payroll generation. The software can be interfaced with the punch card or swipe card machine for attendance to be uploaded.
System Administration Module: The 'MakESS' software was Equipped with the System Administration Module, which took care of the specific database access to the authorized user. The Administrator could Enable or Disable the particular menu option or form for the different users.

Team Size 4
Operating System Windows NT
Languages & Tools PL/SQL, Developer/2000(Forms 4.5, Reports 2.5)
Database Oracle 7.3
Role and Responsibilities: Senior Software Engineer
Information gathering, Database design, Development of Payroll software, Customization, Training to the user, Implementation of Payroll s/w And developed various reports and the interface between Attendance recording system &Payroll s/w., Developed the Income Tax module and integration with Payroll s/w., Creation of Database, Tablespaces, Datafiles and Users Before Installation of the Software.

IGNOU-REGIONAL CENTRE OPERATION SYSTEM (RCOS) AUG1997-DEC1998
DESCRIPTION: Indira Gandhi National Open University (IGNOU) is a distance education imparting University in India.

Team Size 8
Operating System Windows NT
Languages & Tools PL/SQL, Developer/2000(Forms 4.5, Reports 2.5)
Database Oracle 7.3
Role and Responsibilities: Programmer
Information gathering, development of System Requirement Specification (SRS) Document, involved in designing of the database, Wrote the PL/SQL scripts and procedures, which enable user/authority to interact/modify the database, development of various forms and reports.

TRAINING AND CERTIFICATIONS
• Brain Bench certified Oracle Professional.
• Attended training on Oracle 9i.
• Attended training on JAVA.
• Attended training on Quality Testing & Reviews.

Certifications
- Brain Bench certified Oracle Professional.
- Attended training on Oracle 9i.
- Attended training on JAVA.
- Attended training on Quality Testing & Reviews


You must be logged in and have a current resume access subscription. Login or Register »

| Resumes in California

View other Oracle Apps DBA/Developer resumes, Database Administrator resumes