SUMMARY:

• 12+ years of experience in different modules of oracle E - Business Suite (APS-ASCP, APCC, Demantra, GOP, EBS - OM, PO, INV).
• Experience in implementing oracle procurement solutions using oracle cloud (R13).
• Contributed as well as lead multiple oracle ASCP implementation which include multi instance planning.
• APICS Certified supply chain Professional.
• Expertise in different modules of oracle in 11i as well as R12
• 12+ years of experience in implementing different order cycles (Standard, Back to Back and Drop Ship) and ASCP (Manufacturing plan, MPS plan, ATP Plan).
• Expertise in Software Development and Production support.
• Knowledge in designing and setting s up seeded as well as custom Advance planning suite, customers, transaction types (Order and line types), Costing, pricing and items/products.
• Knowledge in setting up instances (centralized and de centralized), data collections (legacy and standard) and plans in ASCP module.
• Knowledge in ATP collection and GOP (on transaction data and plan data)
• 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.
• Expertise in integrating different entities to oracle cloud.
• 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.
• Expertise in capturing the configuration changes in BR100.
• 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)
• Extensive experience in oracle workflow development.
• Hands on experience in PL SQL Tuning.
• Development and production support experience in Oracle 11i, 11.5.10.2 and R12 .
• Experience in Oracle BRM
• In depth understanding of Software Development Life Cycle and Testing Life Cycle.
• 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 AND TECHNICAL SKILLS:

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

Functional Areas: Oracle ASCP, Oracle procurement cloud, Oracle Order Management/Order to cash (O2C), GOP, APCC, Oracle Demantra, P2P, BOM, INV

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

Databases: Different versions of oracle data base.

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

PROFESSIONAL EXPERIENCE:

Confidential

Technology Lead

Responsibilities:

• Senior Analyst responsible to lead deliverables and releases.
• Configure ASCP to do multi instance collections, planning and releases.
• Set up VCP to collect and plan for multiple plants which reside in different servers.
• Design dashboards for the user to validate planning exceptions.
• Conduct POC’s to identify the impact of running multiple plans cycles.
• Resolve the defects raised by the users during UAT.
• Test and make sure that existing ASCP and Demantra solutions are not impacted by 12.2.7 oracle upgrade.
• Manage go live for releases effectively and support users in different time zones.
• Design the appworx run to make sure that multiple planning cycles are automated without any issues.
• Provide infant care support after go live.
• Transition the design to support team.
• Create MD 50’s and BR 100.
• Work closely with functional excellence, stake holders from different plants and development team to deliver and test the designs.
• Design and test all integration changes.
• Work closely with oracle through service requests to address issues faced for seeded functionalities.

Tools: used in for development: SQL, PL/SQL, OAF, forms and reports Demantra Work flowsOracle EBS version used: R12 (12.2.5 and 12.2.7)

Confidential, Columbus, Indiana

ERP IT - Solution Analyst Senior

Responsibilities:

• Senior Analyst responsible to work closely to deliver oracle procurement cloud solution with the implementation partner.
• Design as well as configure the procurement contracts. Capture them in MD 50 and BR 100.
• Design the item integration into cloud from multiple legacy sources. Capture the design as MD 550.
• Working closely with stake holders of contracts as well as item integration to make sure that the design is tested properly and signed off.
• Working closely with development team to make sure that item integration is working as expected.
• Working with functional excellence team to capture the requirements and data flow diagrams in elicitation templates.
• Support supplier as well as employee integration to cloud.
• Transition the design to production support team
• Creating configuration documents (BR 100) for purchasing cloud.
• Discuss and resolve all design gaps in seeded procurement functionalities with oracle using service requests and enhancement requests.

Tools: used in for development: SQL, PL/SQL, web services, xml

Confidential, Columbus, Indiana

ERP IT - Solution Analyst Senior

Responsibilities:

• Senior Functional and Technical Analyst for Global ERP.
• Working with business folks regarding the requirement of different manufacturing sites and prepare BR100’s in case of using standard oracle functionality and configurations and MD 50’s where ever customizations are required.
• Implementing oracle purchasing cloud for business units.
• Creating functional design documents to handle item, supplier and employee integration to cloud.
• Creating configuration documents (BR 100) for purchasing cloud.
• Designing the flow of Plan track.
• Creating and Implementing ASCP Manufacturing and ATP plans.
• Review plan output using oracle planners work bench
• Resolving issues related to oracle GOP
• Designing the custom collection and external collection.
• Setting up de centralized planning environment, ATP collection and ATP process.
• Helping business in creating committed demand plans in Demantra which will be fed to ASCP
• Implementing Demantra and bringing sites up to speed to use the full capability of Demantra in demand planning.

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

Oracle Database Version Used: Oracle 10g

Confidential, San Jose, California

Senior Oracle Functional Consultant

Responsibilities:

• Senior Functional and 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 the flow of plan, make and deliver cycles.
• 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.
• Designing the custom collection and plan cycle in oracle ASCP.
• Setting up centralized planning environment, ATP collection and ATP process.
• Development of PL SQL Packages and procedures.
• Implementing oracle workflows.
• 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.
• Implementing Cisco Royalty calculation using Oracle BRM.
• Oracle Modules Used: Order Management (O2C/OM, INV), Oracle ASCP, Oracle Purchasing.Oracle BRM.

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

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.
• Setting up data collections and ASCP plan (Manufacturing).
• Implementing customization over collected data.
• Monitoring the entire planning cycle from DATA COLLECTION till PLAN COMPLETION.
• Fixing technical as well as functional issues during the planning cycle. This includes issues with respect to DATA COLLECTION, PLAN and different customized solutions specific for the client.
• Implementing change requests after release testing in production.
• 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.

Oracle Database Version Used: Oracle 10g

Oracle EBS version used: Oracle 11i

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.

Oracle Modules Used: ASCP, Order Management

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

Oracle Database Version Used: Oracle 10g

Oracle EBS version used: R12