Oracle DBA Resume

Summary

Up to 9 years of strong IT experience in requirement analysis, Functional design and development involving Oracle Database Applications which includes full life cycle implementation, migration and testing of Oracle Financial Applications 10.7 / 11i.
Modulesgained expertise in include PA, AP, AR, GL, FA, CE, OM, Advancing Pricing, I-Receivables, OTL, I-Expense, HRMS, BPA, PO, PM, GMS,SYSADMIN and AOL.
Conducted Functional planning, analysis, design, testing and implementation of medium to large scale RDBMSincluding installation of Oracle8i/9i and Oracle Apps 10.7/11i.
Experienced in Functional Design and Implementation in Large Scale Upgrade and Migration of Oracle Applications suite 10.7 to 11i.
*Expertise in Functional Design, Development and coding Interface Programs as well as Conversion Routines using SQL*Loader and PL/SQL procedures to load data into the interface tables from legacy sources with a thorough knowledge of Oracle API's.
*Functional Experience in creating BR-100 and Application Implementation Methodology (AIM) Documentation standards such as MD.050 and MD.070 with an In-depth grasp of full Project Life Cycle in a structured development environment.
*Extensive Implementation Experience in the Functional Designand deployment of 11i TCA in a Multi-Org environment.
Comprehensive experience in activities concerning all phases of Implementation cycle including Gap Analysis, RICE Object design specs, Application Setup & Configuration both for new & existing functionalities, System Testing, month end closing, etc.
Validated financials processes and application configuration. Worked with end users in mapping Financials standard processes to the business needs, as requirements change/evolve.
Experienced in Tracking Production support tickets and other metrics. Prepared data and test scripts, conducted thorough application testing, documented and resolved gaps, etc.
Experienced also in Operations and Maintenance aspects including Period end Closing and Reconciliation processes.
Experienced in creation of functional test plans and test scripts, detailed design documents, Requirements Matrix documentation, and test execution during requirement, design, Integration and testing phases.
Proficient in applicationperformance tuning and Query optimization techniques.
Proficient in writing Complex SQL Queries as well as developing PL/SQL Packages, Stored procedures, Triggers and in using Export, Import and SQL* Loader utilities.
Proficient in Developer 2000 suite/Oracle Forms 9i/6i/5.0/4.5, Reports 9i/6i/3.0/2.5 and Discoverer 3.1/4i (User & Administration additions) and coding Unixshell scripts.
Expertise in Extraction, Transformation and Loading (ETL) External Application Data into Base Systems using Oracle Warehouse Builder, Informatica.
Hard working and self-driven with a strong willingness to excel. Add to that, a Pleasing Personality and excellent communication skills.

Technical Skills

Databases

Oracle 9i/ 8i/8/7.3 and MS Access 97 / 2000.

GUI's

Developer/2000(Forms 6i & Reports 6i)

Languages

SQL, PL/SQL, C, Shell Scripts, Java, HTML and COBOL (85).

Tools

Oracle Enterprise Manager (OEM), MS Office, TOAD, SQL*PLUS, SQL*LOADER, SQL*NET,Reflection X, Test-Director 7.2,Kronos, USD, Lotus Notes, PVCS,Discoverer 4i,Informatica6.0, Power Plant 9, Remedy (Action Request), Data Loader, Quick Place, CMIS, Vertex, Mark-view, Timekeeper, Hyperion

Oracle Application Modules

Project Accounting (PA), Oracle Time & Labor (OTL), Oracle i-Expense (OIE), Oracle HRMS, Grants Accounting (GMS), General Ledger (GL), Account Payables(AP),Account Receivables(AR),BPA, i-Receivables, Fixed Assets (FA), Cash Management (CE),Purchasing(PO), OM, INV,Oracle Advanced Pricing, Property Manager (PM), Public Sector Modules, Oracle Alerts, Application Object Library (AOL) & Sys Admin.

Operating Systems

Windows NT/2000/XP/98/95, SCO UNIX, Sun Solaris, IBM AIX, HP-UX 11, MSDOS 6.22.

Netware

TCP/IP, FTP

Hardware Platforms

IBM PC Compatibles, SUN / SPARC, Mac.

Project Experience will be provided upon further request…

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship