We provide IT Staff Augmentation Services!

Senior Oracle Functional Consultant Resume

3.00/5 (Submit Your Rating)

San Jose, CaliforniA

SUMMARY

  • 8.1 years of experience in different modules of oracle E - Business Suite (EBS-OM,PO,INV).
  • Expertise in different modules of oracle in 11i as well as R12
  • 7.11 years of experience in implementing different order cycles (Standard, Back to Back and Drop Ship)
  • 7.9 years of experience in Software Development and Production support with various clients
  • Worked extensively on implementation of SCM modules Oracle Order to cash (O2C) and Oracle Advance supply chain planning (ASCP) module for various clients in manufacturing industry.
  • Knowledge in setting up customers, transaction types (Order and line types), Costing, pricing and items/products.
  • Have done margin and margin% set ups in order to protect the profit margin of a product.
  • Experience in designing custom order flows by introducing custom nodes in the oracle order management work flows.
  • Experience in Production support for Oracle Order Management (O2C) and Oracle Advance supply chain planning module (ASCP) for various clients in manufacturing industry.
  • Knowledge in 11i and R12 inventory, BOM, Purchasing modules of oracle
  • Proficient in creating the functional specifications (MD 50/RD50), writing technical documents (MD 70/RD 70) and writing testing plans.
  • Experience in designing the different order cycles based on the client business by customizing the standard order flows.
  • Deep Knowledge in technical flow of different types of oracle Order to cash (O2C) cycle.
  • Deep knowledge in the technical flow of ASCP PLAN CYCLE.
  • In depth knowledge regarding ASCP and Order Management standard tables.
  • Expertise in technologies including PL SQL, Oracle Forms, Reports and Discoverer reports and UNIX.(RICE Components)
  • Expertise in developing PL SQL packages, procedures, functions, triggers, cursors etc.
  • Knowledge in oracle forms development and migration.
  • Knowledge in report development and calling reports from forms.
  • Hands on experience in PL SQL Tuning.
  • Development and production support experience in Oracle 11i, 11.5.10.2 and R12.
  • In depth understanding of Software Development Life Cycle and Testing Life Cycle.
  • Extensive use of SQL queries for various production support activities.
  • Excellent verbal and written communication skills with an eye for detail.
  • Highly conceptual and innovative problem solver with excellent organizational skills
  • Experience in analyzing requirements and do knowledge sharing among Development, business, management and offshore teams to make sure requirements are met.
  • Functional knowledge in various orders to cash cycles and their customizations.

TECHNICAL SKILLS

Operating Systems: Windows Vista/95/98/2000/XP/XP Pro/7, DOS, UNIX

Functional Areas: Oracle Order Management/Order to cash (O2C), Oracle ASCP

Technical Skills: C, PL/SQL, UNIX Shell Scripting, Oracle Forms, Oracle Reports

Databases: Different versions of oracle data base.

Packages & Tools: MS Office, MS Word, MS Excel, MS PowerPoint, VISIO, Toad.

PROFESSIONAL EXPERIENCE

Confidential, San Jose, California

Senior Oracle Functional Consultant

Responsibilities:

  • Senior Technical Consultant of the project.
  • Requirement gathering, Understanding the functional requirement, working along with offshore and functional consultants in developing the functional documents (MD 50), developing the technical specifications (RD 50).
  • Designing customized back to back order flow and BTS flow for different products.
  • Designing the introduction of custom nodes in the order management work flows.
  • Designing the solution, developing the solution, testing and deployment into production.
  • Coordinating with offshore team.
  • Development of PL SQL Packages and procedures.
  • Managing the middleware team (OSB and TIBCO) who were in charge of integration between EBS - OTM and EBS - Partners.
  • Ensuring effective coordination between oracle EBS, OTM and partners.

Tools: used in for development: SQL, PL/SQL, Oracle Forms, Oracle work flow.

Confidential, San Jose, CA

Technology Lead

Responsibilities:

  • Technology lead for the planning production support (Oracle ASCP).
  • Requirement gathering by client interaction, functional analysis of the requirement, estimation, development, testing and implementation of customized solutions. Most of the developments are done using PL SQL.
  • Involved in requirement gathering, analysis, design, development, testing, implementation and review.
  • Involved in the designing of order to cash flow which involved internal requisitions, internal order, invoicing between two orgs and invoicing between an org and the supplier.
  • Fixed the day to day functional and technical issue for the order cycle implemented.
  • Authoring Functional and Technical and specification.
  • UAT for various requirements.
  • Modification of already implemented functionalities as per the client change request. Most of the customized functionalities are developed using PL SQL.
  • Development of PL SQL Packages and procedures.
  • Created many Tables, Stored-procedures and Triggers on Oracle Database
  • Associated with DBA in monitoring performance related issues using Explain plan, SQL Trace and TKPROF utility.
  • Coordination of offshore and onsite activities.
  • Proficient in Toad

Tools: used in for development: SQL, PL/SQL, Oracle Forms and Reports (Basics), UNIX.

Confidential

Technology Analyst

Responsibilities:

  • Technology Analyst for oracle ASCP implementation team.
  • Understanding the business requirement.
  • Authoring Functional and Technical Specification.
  • Development of PL SQL Packages and procedures.

Tools: used in for development: SQL, PL/SQL, Oracle Forms.

Confidential

Senior Software Engineer

Responsibilities:

  • Senior Software Engineer of production support team.
  • Requirement gathering for change requests raised by client.
  • Preparing technical design documents.
  • Modifying Programs as per the change request.

Environment: SQL, PL/SQL, Oracle Forms, Oracle Reports, Discoverer Reports.

Confidential

Software Engineer

Responsibilities:

  • Requirement Gathering.
  • Preparing technical design documents.
  • Development of Discoverer Reports.

Tools: used in for development: SQL, PL/SQL, Discoverer Reports, Toad

Confidential

Software Engineer

Responsibilities:

  • Member of ASCP Team.
  • Developing functionalities as per the requirement using PL / SQL.

Tools: Used: SQL, PL/SQL, Toad

Confidential

Software Engineer

Responsibilities:

  • Member of production support team.
  • Monitoring ASCP Plan Cycle.
  • Coordinating with onsite in fixing issues related to plan run.

Tools: used in for development: SQL, PL/SQL, Oracle Forms and Reports, UNIX

Confidential

Software Engineer - (QA team member)

Responsibilities:

  • Member of QA team.
  • Manual testing of the new functionalities and modifications.

Tools: used in for development: Oracle Forms, Microsoft Excel, Toad

We'd love your feedback!