Objective:

Seeking a challenging position in ORACLE apps projects by contributing my knowledge to the position this will exercise and further sharpen my analytical Skills

Experience Summary:

• Having 7 years of experience in Techno Functional areas of business including Enhancement and Testing of ORACLE ERP Manufacturing and Distributing. Experienced in R12 and 11i.
• Strong Functional and Technical knowledge in financials modules GL, AP, AR and PA , Oracle Manufacturing Modules OM, INV, Shipping, BOM, WIP, PO, CRM , Service Contracts and Pricing
• Experienced in Relational Database Management Systems in Client/Server environment involving design, development and testing of application software/tools using Oracle SQL, PL/SQL.
• Expert in development of Forms, Reports, Alerts, Data Conversions, Interfaces and Discoverer reports development facilitating the implementation of Oracle Financials and Manufacturing modules.
• Strong knowledge and understanding of Order to Cash and Procure to Pay life cycles.
• Very good experience in preparing functional and technical design documents using AIM.
• Technical expertise and strong background in RICE and CEMLI components.
• Strong knowledge in design and development of interfaces inbound and outbound using API'S and open interfaces for integrating other applications with Oracle Applications.
• Expertise in design and development of Interface/Conversion programs to import data from legacy systems and integrate it into Oracle Applications using open interfaces and APIs.
• Extensive experience in developing reports using XML/BI publisher 5.6.3/5.6.2, Reports 10g/6i/2.5 and Discoverer 10g/4i.
• Experience in supporting CRP, UAT, Go live planning and execution, production system, day-to-day issues and end user training.
• Extensive experience in customizing standard reports as well as developing custom reports in Oracle Applications using Oracle Reports 6i/10g.
• Excellent communication Verbal / Written and presentation skills, Quick in grasping client's business requirements and good at adapting to new work environment.

Experience Summary:

Confidential

Role : Techno Functional Consultant

Environment : Oracle Applications 11i, Release 12.1.3, Advance Pricing, Inventory, Oracle Finance Modules AP, AR, GL, PO , OM, Oracle Database 10g

Responsibilities:

• Actively participated in client interaction and meetings for understanding the requirements.
• Gave sessions to explain the business flow to the technical team.
• Handled functional and technical related issues by investigating and applying solutions to specific problems.
• Created new Oracle Alerts to enable alerts for providing report to track PO changes.
• Prepared the SQL scripts for creating the concurrent programs, executable and parameters in Oracle applications.
• Involved in Upgrade processes, document review and code review and testing.
• Involved in Custom.pll and form personalization.
• Creation of Value sets in various Modules of the application.
• Prepared TE 50's for the components.
• Prepared TAC documents for each and every upgraded CEMLI.
• Validated test scenarios and test cases to ensure that the delivered unit is valid after incorporating the changes.
• Worked on rdf, xml and discoverer reports also on forms.
• Involved in code move, CRP and UAT.

Confidential

Role : Techno Functional Consultant

Environment : Oracle Applications 11i, Release 12.1.3, Oracle Receivables, INV, SCM, Finance modules, Oracle Database 10g

Responsibilities:

• Created a custom XML Publisher PDF report for Order Acceptance using XML BI Publisher to include the sales order, pricing data from OM, and customer details from TCA and include company logos, Terms and Conditions.
• Review of technical design documentation and code walkthrough of the developed components.
• Interacted with Users to gather requirements/Changes.
• Responsible for code moves to the production on behalf of the team.
• Monitoring and maintaining the open issue status for the team.
• Participating in discussions with the Client for Change Requests and guided the team to complete the same and to meet the dead lines.
• Helping the team members in understanding the technology and have guided them to learn troubleshooting.
• Worked on SQL, PL/SQL and Reports 6i
• Developed a Sql report to check overall PO amount details.
• Developed the interfaces as per the requirements.

Confidential

Role : Techno Functional Consultant

Environment : Oracle Applications 11i, Release 12.1.3, Oracle SCM, Finance Modules, Oracle Database 10g

Responsibilities:

• Gave sessions to technical team on the business flow.
• Developed pl/Sql custom reports and register as Concurrent Programs, reports like GL natural account dump report etc.
• Developing testing strategy and test plans after reviewing High level Design and Requirement Documents to simulate various business scenarios
• Working with the team of business analysts and identifying the changes required in the functional specs.
• Providing Technical and Functional Support to End users in various modules like AP, PO, GL, AR and Alerts.
• Define bank setup using different currency in AP module.
• MD050 and MD070 Functional and Technical Design documents.
• Setting up their system and financials options
• Defining Intercompany customer in AR and AP.
• Involved in Code move, CRP and UAT.
• Wrote shell scripts for code move.
• Review of technical design documentation and code walkthrough of the developed components.
• Technologies: Oracle SQL, PL/SQL, XML ,Reports 6i.

Confidential

Role : Techno Functional Consultant

Environment : Oracle Applications 11i, Release 12.1.3, Oracle Finance, Order Management, INV, SCM, Oracle Database 10g

Responsibilities:

• Responsible for resolving day to day issues, maintaining the issue log along with other members of support team. Replicating the issues for Root Cause Analysis. Interacting with the users, resolving issues. Researching resolution on Metalink, logging TAR with Oracle support, obtaining resolution.
• Communicating with Business users for understanding of the requirements
• Preparing scripts for Data Fixes Data Pulls
• Actively participated in client interaction and meetings.
• Understanding the legacy systems and its conversion to Oracle Applications.
• Upgraded database objects to R12
• Upgraded rdf reports to 10g.
• Worked on SQL, PL/SQL and Reports 6i
• Worked on PA to AR interface.
• Developed a Sql report to check overall PO amount details.
• Created new Oracle Alerts to enable alerts for providing report to track PO changes.
• Created new Oracle apps lookups to support alerts at runtime.
• Providing Technical and Functional Support to End users in various modules like AP, PO, GL, AR.
• Review of technical design documentation and code walkthrough of the developed components.
• Technologies: Oracle SQL, PL/SQL, XML ,Reports 6i

Confidential

Role : Techno Functional Consultant

Environment : Oracle Applications 11i, Release 12.1.3, Oracle Process Manufacturing, SCM, Oracle Finance Banking and Tax , Oracle Database 10g, Discoverer 11g, Report Builder 10g.

Responsibilities:

• Upgraded database objects to R12
• Upgraded rdf reports to 6i.
• Upgraded Discoverer reports to 11g
• Creating the value sets
• Prepared Test Case Documents
• Coordinated with onshore team to plan and prioritize delivery schedules.
• Interaction with the team members for their technical query resolution.
• Ensure development follows coding standards and quality processes.
• Prepared TE 50 and TAC documents for the upgraded components.
• Review of technical design documentation and code walkthrough of the developed components.
• Involved in the requirement analysis with functional team and providing solutions.
• Technologies: Oracle SQL, PL/SQL, XML, Reports 6i

Technical Skills: