Oracle Management

HIMABINDU PENIKALAPATI

*****.****@*****.***

248-***-****

Over 10 years of extensive experience in Oracle EBS designing, configuring, Implementation, Enhancement, Migration, Customization, Upgradation, Rollout and Support of various modules in Oracle Applications with major focus in Financials Modules (Accounts Payables (AP), iProcurement, iPayables, General Ledger (GL), Accounts Receivable (AR), Projects Accounting (PA)), Fixed Assets (FA), Cash Management(CM) Manufacturing Modules (Purchasing (PO), Order Management (OM), Shipping, Inventory (INV), TCA, SLA and Application Object Library(AOL).

Have worked on End to End R12 implementation, R12 migration/upgrades.

Technically proficient in implementing RICEW (Reports, Interfaces, Conversions, Extensions, Workflows), BI Reports like XML Publisher Reports, Discoverer Reports, OAF and PLSQL packages.

Having complete understanding and Experienced in Procure to Pay (P2P), Order to Cash (O2C), Record to Report(R2R) business flows.

Experience in using Oracle tools like SQL*Loader, SQL* Plus, SQL developer, TOAD, WEBADI, UTL_FILE, OAF, Oracle packaged APIs etc. and good knowledge on Record to Report(R2R).

Worked with Oracle Support (Meta link) and logged several SRs.

Substantial Oracle PL/SQL R12/11i Development experience in creating Stored Procedures, Packages, Functions, Triggers, Tables, DFF & KFF Flex fields, Profiles, Value sets, Lookups, Indexes, TYPE Objects, Cursors, Parameterized Cursors, Views, Materialized Views, PL/SQL Collections, Object Types, Global Temporary Tables.

Extensively used the advanced features of PL/SQL like Records, Tables, Object types such as Collections, VArray, objects and PL/SQL tables and used BULK COLLECTS, BULK BINDS in PL/SQL objects for improving the performance.

Worked as DP (Defect Prevention) Anchor to Review defects and hold triage meetings and find out the possible solutions and action items to prevent those defects from recurring.

Worked on Version Control software tools to check-in codes and integrated with KINTANA, Sarena PVCS management tool, CVS for file migration and Well versed with Defect tracking using spread sheet and testing tool such as HP Quality Center (QC) and requirement tracking tool such as Project Portfolio Management (PPM).

Worked on Onsite-Offshore Software Testing Model, code review/self-review Checklists and Impact Analysis documents to prevent the defects from reoccurring with the learning’s from previous releases.

Working closely with Oracle, Sys-admin & DBA teams for regular Patch Applications, Outages, data fix, code fix, Scheduling of several scheduled requests.

Expertise in requirement Analysis, Data Flow Designs, Support, development, testing [UTS, UAT and STS], documentation and design reviews and Performance Tuning.

Expert in developing Functional design documents (MD050), Technical design documents (MD070), Technical Test documents (TE020), Conversion (CV050) and Migration documents (MD0120) using AIM Methodologies, Agile methodology.

Excellent knowledge on project life cycles (i.e.) SIT, CRP/CAT, Go-Live activities and provided on-call and day-to-day Production Support and worked as a part of team in 24x7 production environment especially during month end and year end Period closure activities by running different GL reports like Trial Balance, Account Analysis etc.

Ability to handle user defined errors by developing Error-Handling Package using PL/SQL. Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

CERTIFICATIONS:

Oracle 11i (1Z0-007, 1Z0-147) SQL, PL/SQL Developer Certified Associate.

Oracle Partner Network certified for Oracle E-Business suite Essentials for Implementers.

ACHIEVEMENTS:

KUDOS for providing efficient efforts and support at all times.

POB (pat on back) award twice for GLOBAL enhancements.

Appreciation for high quality deliverables within time lines.

Awarded Associate of the Month for completion of development for Supplier conversion before schedule and successful Go-Live.

TECHNICAL SKILLS:

ERP: Oracle E-Business suite EBS R12/11i/11.0.3/11.5.10.2 and 12c versions. Oracle Apps Modules worked on Purchasing (PO), General Ledger (GL), iProcurement, Accounts Receivables (AR), Accounts Payables (AP), Order Management (OM), Inventory (INV), Project Accounting (PA), Shipping, Fixed Assets(FA), Cash Management(CM), TCA, SLA, AOL, System Administrator, Application Developer, RICE (Reports, Interfaces, Conversions, Extensions), Procure to Pay (P2P), Order to Cash (O2C), Record to Report(R2R), AIM methodology and Agile methodology, Production Support, Performance Tuning, Cloning, Error-Handling, Defect Prevention Anchor, SDLC, Onsite – Offshore Model.

Application Tools: D2k Reports 6i/10g, Oracle Reports 6i/10g, Oracle Forms, Oracle Workflows, Oracle BI Tools like XML Publisher Reports 5.6.3/5.6.2, Discoverer Reports, Bursting and Oracle OAF.

Databases & Tools: Oracle R12 (12.1.3, 12.2.3),11g/10g/9i/8i,12c, Logical Data Model Diagrams, Advance Collections, Defect Prevention, TOAD, SQL Developer, SQL*PLUS, SQL*Loader, UTL_FILE, FND_LOAD, WEB ADI, QC tool, HP Quality Center, WINSCP, Kintana, PVCS, Shell Script, Service now, HPSD.

Operating Systems: Windows NT/XP/2000/98, UNIX/LINUX.

Others: PowerPoint, MS-Word, MS-Excel, MS-PowerPoint, Visio.

Languages: SQL, PL/SQL, C, Core Java.

Education Qualifications:

2005, Bachelor of Technology in Electronics and Communications Engineering, JNTU, India.

Contact this candidate