We provide IT Staff Augmentation Services!

Senior Oracle Apps Technical Ebs Consultant Resume

San Francisco, CA

SUMMARY

  • 8+ years of IT experience with expertise in Oracle Applications E - Business Suite R12/11i/10.7
  • Responsibility in most of the projects has been working as technical/techno-functional consultant and to work closely with End users/functional team. Experience working in full life cycle from Gathering requirements, Analysis, Design, Development, Testing, Go-live and Support Phases.
  • Expertise in Order to cash and Procure to pay flow. Experience in SCM and Financials modules like Order management, Shipping, inventories, Account Receivables, Account Payables, and purchasing general ledger {GL}, fixed assets, & Core HR pay with flexibility to work on any module.
  • Good blend of experience of Implementations/Roll-outs as well as Enhancements and Production support projects.
  • Expertise in development of conversions/Interfaces (PL/SQL) with extensive experience of API's.
  • Expertise in oracle reports, XML Publisher Reports with experience working on multilingual reports.
  • Experience working on data templates, XML bursting, Bar code printing.
  • Working knowledge of OAF customizations with experience in OAF personalization.
  • Experience in Workflow development and Oracle Alerts, working knowledge of AME for approval process.
  • Experience working on Oracle forms, forms personalization/Logical Apps for adding the functionality. Working knowledge of Custom. pll for forms customization.
  • Exposure to Oracle Discoverer reports, worked on discoverer report modifications and issues as per user's requirement.
  • Experience working on Unix Shell Scripts Programs as a part of Interface development.
  • Extensive experience in technical documentation for components using AIM, OUM as well as CMMI Standards with Involvement in CMMI appraisals.
  • Good Experience closely working with the end users during war room testing phases. 2 years of onsite co-ordination experience with effective team handling.
  • Excellent Communication skills with effective client facing/handling skills with experience in leading small teams.

TECHNICAL SKILLS:

Databases: Oracle 10g, 9i

Oracle Applications: R12, R11.5.X, 10.7

Software tools: Oracle Reports 10g/6i, Oracle Workflow 2.6, Oracle forms 10g/6iToad 7.6, Oracle XML Publisher, Oracle Discoverer 10g

Languages: C, SQL, PL/SQL

Version Control: CVS, VSS, Clear Case, SVN, Kintana

Support Tools: Service Desk, Service Now, HPQC

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, CA

Senior Oracle Apps Technical EBS Consultant

Responsibilities:

  • Project Involves Development/Enhancements of technical components with extensive use of PL/SQL, Oracle API’s, and XML Publisher Reports.
  • Worked on development of Several Interfaces like AP invoices, suppliers, GL Import with good experience in PL/SQL development.
  • Worked on development of SO Acknowledgment issues which sends email with HTML file to external customers and internal contacts.
  • Customization of legal reports in Italian language which was critical for its high cost.
  • Converted Several Reports from Oracle Reports to XML Publisher which involved extensive XML template development. Few of the reports are Asset Retirement Report, Asset Depreciation Report, and Asset Addition Report.
  • Worked on FA Tax book implementation project which involved development of FA tax book programs.
  • Month End Activity Support every month which involved handling issues in sales audit data to GL Interface which is critical activity for Gymboree.
  • Worked on production support incidents whenever required which involves changes/issues in technical components like changes in discoverer reports, forms personalization, alerts.
  • Technical Documentation like creation of technical Design (MD070), Installation and Migration Documents (MD120), Test Cases for Developed components using AIM and OUM methodology
  • Development of UNIX shell scripts required for Interface development.
  • Performing Code reviews of team members for high quality deliverable and managing the team of three developers.
  • Development of PL/SQL objects like creating triggers for resolving issues, DVR reports for users testing as per requirement.
  • Expertise in AOL tasks like creating concurrent programs, value sets, lookups whenever required.
  • Created Technical Documentation using MD70, MD120, UTP using AIM and DS140 using OUM methodology.

Environment: Oracle Applications R12 (Financials, SCM), CVS, Service Now

Confidential, Ontario, CA

Oracle Techno-functional Consultant

Responsibilities:

  • The project Involves supporting DPI users for all regions for production issues in their daily shipments.
  • Worked as a Techno-functional consultant for resolving P1 Production issues in daily shipping/Invoicing. This involved working under high pressure requiring quick turnaround to complete all shipments.
  • Independently Responsible for resolving issues in OM/Shipping/Invoicing which involved good experience in OM, Shipping, Receivables and WMS mobile application.
  • Good Experience working on Enhancements and Issue resolution in complex XML publisher Reports like Invoice reports.
  • Experience working on enhancement of several EDI interfaces like EDI894, EDI880, and EDI852 which involved extensive experience in PL/SQL.
  • Worked on Outbound interface using UTL File for generating the outbound files like for generating extract of invoice data.
  • Worked on code migration, maintaining the version control and technical documentation using AIM like creating MD70, MD120, and UTP.
  • Provided training to users after go-live for optimizing the process and to reduce the issue logging.

Environment: Oracle Applications R12 (OM, Shipping/AR), Service Desk

Confidential, USA

Oracle Technical Consultant

Responsibilities:

  • This Project was a Roll-out Implementation for DPI West with experience working in all the phases from Design, Development, various testing phases, Go-Live and post production support.
  • Handled team of 3 developers for delivering the technical components. This includes guiding junior members, doing code reviews, testing and maintaining the coding standards.
  • Developed Several Conversions as per requirement like Items, Customers using TCA architecture, AR Invoices, Item price match, price lists.
  • Created Unix Shell Scripts programs required for different conversions.
  • Experience in development of complex Oracle forms for their custom application.
  • Worked on forms personalization for customizing the delete button for Journal Entries screen, hiding and renaming of fields.
  • Created Project Accounting (PA) tasks and projects using API's. Handled complex requirement for passing this data for external system
  • Issue resolution during various testing phases and go-live like addressing CR's, handling bugs, checking missing functional setups.
  • AOL registration like creation of value sets, concurrent Programs, lookup's for developed components, Creation of LDT's for migration of objects.

Environment: Oracle Applications R12 (SCM), Oracle Forms 10g/Reports 10g, VSS, Service Desk

Confidential, Santa Clara, CA

Oracle Techno-functional Consultant

Responsibilities:

  • Worked Extensively on RICE components and handled all tasks independently from design, development, resolving technical and functional issues, and support during various testing phases and during production cut over and code migration.
  • Developed several data conversions like Internal Requisitions, Internal Sales Orders, Back to Back orders, Items using API's.
  • Developed Programs like Cancellation of Old SO's, Closing old IR's, ship set updates, Attachment updates as per requirement.
  • Development of Oracle Workflow from CRM Service module for case completion process. Created a trigger for populating the data required for case completion process.
  • Worked on customization of PO Account Generator workflow for generating expense charge account.
  • Developed Several DVR Reports to facilitate users for data validation after Conversions.
  • Actively resolved the issues during testing phases and during production cut over.
  • Worked independently in version control of all objects using clear case and created Kintana lines for Migration of all the files.

Environment: Oracle Applications 11.5.10(SCM), Oracle Workflow builder 2.6, Clear case, Kintana, HPQC

Confidential, Santa Clara, CA

Oracle Technical Consultant

Responsibilities:

  • As a technical consultant, I was responsible for handling the testing and production issues for several interfaces being having lot of interfacing between 10.7 and 11.5.9
  • Worked closely with business to understand the requirement and was a part of War room testing.
  • Supported several interfaces from OE/AR track like Order Import, Change orders, Customers and actively resolved the issues by effective root cause analysis.
  • Generated and maintained the resolution database (PRDB) for the issues encountered.
  • Experience in co-ordination with multiple teams effectively at onsite along with coordination with offshore team.

Environment: Oracle Applications 11.5.9, Oracle 10.7, Information Highways, Java Caps (Capps)

Confidential, Houston, TX

Oracle Consultant

Responsibilities:

  • Confidential is a growing organization which supports flight related information like weather, fuel, trip support.
  • As an individual contractor, I have worked on Gathering Requirements with direct interaction with client team to understand the requirement.
  • Development of complex Reports for pricing Department Users using PL/SQL, Oracle Reports 6i as per requirement for their custom application.
  • Creation and follow up’s on SR’s for the Issues with co-ordination with DBA team.
  • Worked on Development of Oracle forms 6i for UWA custom Application Development.
  • Migration of objects to the test instance and get it migrated to Production by DBA team.

Environment: PL/SQL, Oracle Forms6i /Reports 6i

Confidential, USA

Technical Analyst

Responsibilities:

  • Worked from design, development, testing, and documentation for technical components with big team of around 30 team members.
  • Worked with flexibility on different objects from modules like Financials, SCM and HRMS
  • Developed Oracle Forms using to implement postdated cheques (PDC) functionality in Account Receivables (AR).
  • Development of Inbound and outbound Conversions for loading data to DB and generate outbound files from HRMS Module.
  • Technical Documentation using AIM methodology for all components with strict adherence to process.
  • Peer reviews of other team members for bug identification for high quality of deliverable.
  • Taken Ownership of all the objects till it's migration across various instances using FNDLOAD

Environment: Oracle Applications R12 (Financials, SCM, HRMS), Oracle Forms/Reports 10g, SVN

Hire Now