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