We provide IT Staff Augmentation Services!

Oracle E-business Suite Ebs architect Resume

Oracle E-business Suite Ebs, ArchitecT

SUMMARY:

  • Over 10 years of extensive experience in designing, configuring, Implementation, Enhancement,Migration, Customization, Up gradation, Rollout and Support of various modules in Oracle Applications with major focus in Supply Chain Modules Purchasing (PO), Inventory (INV), Order Management, Work In Process (WIP), Bill Of Materials (BOM), Shipping and Finance Modules Payables (AP), General Ledger (GL), Accounts Receivables (AR), Oracle Lease Management (OLM) , Application Object Library (AOL).
  • Have worked on End to End R12 implementation, R12 migration/upgrades . Worked on 11.5.10 to R12.1.3 Implementation, Upgrade and extension, Support Projects.
  • Technically proficient in implementing RICE (Reports, Interfaces, Conversions, Extensions), BI Reports like XML Publisher Reports, Oracle Discoverer Reports and PLSQL packages.
  • Experience in using Oracle tools like SQL*Loader, SQL* Plus , SQL developer, TOAD, WEBADI , UTL FILE, OAF, Oracle packaged APIs etc.
  • Worked with Oracle Support (Metal ink) and logged several oracle service requests ( SRs) .Having working knowledge on Oracle Forms, Oracle workflows, OAF Frame work, Customized OAF pages.
  • Having complete understanding and Experienced in Procure to Pay (P2P), Order to Cash (O2C ), Record to Report(R2R ) business flows.
  • Substantial Oracle PL/SQL Development experience in creating stored Procedures, Packages, Functions, Triggers, Tables, Flex fields, Profiles, Value sets, lookups, Indexes and Views.
  • Extensively used the advanced features of PL/SQL like Records, Tables, and Object types and used BULK COLLECTS, BULK BINDS in PL/SQL objects for improving the performance.
  • Worked on Version Control software tools to check - in codes and integrated with KINTANA, Serena 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.
  • Preparing Logical and Physical Data Model Diagrams , 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 Technical design documents ( MD070 ), Technical Test documents ( TE020 ), Conversion ( CV040& CV070 ) and Migration documents ( MD0120 ) using AIM Methodologies, Agile methodology and DevOps 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 closings .
  • 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.

TECHNICAL SKILLS:

ERP: Oracle E-Business suite EBS R12/11i/ 11.0.3/11.5.10.2 and 12c versions. OracleApps Modules worked on Purchasing ( PO ),General Ledger ( GL ), Accounts Receivables ( AR ), Accounts Payables ( AP ), Order Management ( OM ), Inventory ( INV ), Project Accounting ( PA ),Shipping, Fixed Assets( FA ), Cash Management( CM ),Oracle Lease Management ( OLM ), Work In Process ( WIP ), Bill Of Materials ( BOM ), 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, SQLDeveloper, SQL*PLUS, SQL*Loader, UTL FILE ,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.

PROFESSIONAL EXPERIENCE:

Confidential

Oracle E-Business suite EBS Architect

Responsibilities:

  • Have worked on End to End R12 implementation, R12 migration/upgrades . Worked on 11.5.10 to R12.1.3 Implementation, Upgrade and extension, Support Projects.
  • Technically proficient in implementing RICE (Reports, Interfaces, Conversions, Extensions), BI Reports like XML Publisher Reports, Oracle Discoverer Reports and PLSQL packages.
  • Experience in using Oracle tools like SQL*Loader, SQL* Plus, SQL developer, TOAD, WEBADI, UTL FILE, OAF, Oracle packaged APIs etc.
  • Worked with Oracle Support (Metal ink) and logged several oracle service requests ( SRs) .Having working knowledge on Oracle Forms, Oracle workflows, OAF Frame work, Customized OAF pages.
  • Having complete understanding and Experienced in Procure to Pay (P2P), Order to Cash (O2C ), Record to Report(R2R ) business flows.
  • Substantial Oracle PL/SQL Development experience in creating stored Procedures, Packages, Functions, Triggers, Tables, Flex fields, Profiles, Value sets, lookups, Indexes and Views.
  • Extensively used the advanced features of PL/SQL like Records, Tables, and Object types and used BULK COLLECTS, BULK BINDS in PL/SQL objects for improving the performance.
  • Worked on Version Control software tools to check - in codes and integrated with KINTANA, Serena PVCS management tool, CVS for file migration and well versed with Defect trackingusing 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.
  • Preparing Logical and Physical Data Model Diagrams, 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.

Hire Now