SUMMARY:

• 7+ years of experience as Functional/ Technical/ Techno - Functional Consultant in Oracle E-Business Suite Applications
• Functional, Implementation and Technical expertise in Oracle Applications R12/11i, across the Financials, SCM and CRM modules such as General Ledger (GL), Payables (AP), Receivables (AR), Sub Ledger Accounting (SLA), Fixed Assets(FA), Purchasing Order (PO), Inventory (INV), Order Management (OM), Bill of Materials (BOM), Work in Progress (WIP), Quoting and System administration (AOL), Service Contracts(OKS), Field Service (FS), Tele Service, Territory Management, Assignment Manager, Depot Repair and Install Base respectively(IB) .
• Worked on OAF personalization’s and view extensions for standard pages in Oracle Applications.
• Experience in Configuring setups, requirements gathering, gap mappings and worked on System Design Document to integrate the requirements in applications.
• Experience in designing, coding, testing custom applications with an integration to Oracle Applications or other custom applications.
• Experience in developing inbound and outbound Interfaces for Oracle Service Contract, Accounts Receivables, Purchasing, Quoting, Order Management and Inventory modules.
• Experience in developing custom Oracle Forms using Oracle Forms 10g/6i. Used CUSTOM.pll and Form personalization to customize the standard oracle Forms.
• Extensive experience in creating Stored Procedures, Functions, Packages, Triggers and other database objects using SQL and PL/SQL.
• Strong knowledge of SQL, PL / SQL, Forms 10g/6i, Oracle Workflow and XML Publisher
• Experience includes exposure to all the phases of Software Development Life Cycle including Analysis, Design, Development, Testing, Implementation, Production Support and Maintenance.
• Prepared System Requirement Document, Solution Design Document and Technical Design Documents for business customizations.
• Excellent problem solving skills with an ability to identify problems and implement connective solutions.
• Extensive experience in providing Level 2 support to resolve high priority production and support tickets.
• Experience in development projects and involved in requirement analysis form Clients/BSA and was involved in designing/testing/implementing the custom requirement in Oracle Apps, PL-SQL, and Forms.

TECHNICAL SKILLS:

Database Tools: Toad, PL-SQL developer, SQL *Plus RDBMS Oracle 10g/9i/8i, SQL Server 6.5/7.0/2000

Oracle Tools: Forms 10g/9i/6i Oracle Workflow Builder 2.6.3.5, Developer 2000, XML Publisher Other Languages C/C++, UNIX

Operating Systems: Sun Solaris UNIX Version 5.8 Server, Windows XP, 7, 10 for the Client. Other Tools IBM Lotus Notes

WORK EXPERIENCE:

Confidential, Webster, NY

Oracle Apps Techno-Functional Consultant

Responsibilities

• From the beginning of this project I was Involved in Functional review meetings of the new requirements with Clients/BSA's.
• Worked extensively on functional side on General Ledger, Service Contract, Account receivable, Account Payables, Install Base, Fixed Assets, Field Service, OM, Inventory and Purchasing.
• Designed the Solution and Technical design documents of the requirements to meet the business requirement in Oracle Apps ERP.
• Participated in New Requirement gathering, design, documentation, setup and configuration.
• Developed and designed the critical Functional/Technical Components and successfully implemented it in Production after movement from Development, Quality Assurance and Volume Testing instances.
• Worked on OAF personalization of Standard Customer page in Oracle Apps.
• Worked on view extensions of OAF pages for custom application in R12.
• Analyzed Business Requirement and worked on System Design Document to integrate the requirements in applications.
• Analyzing existing setup and extending the same as per requirement.
• Developing new solution as per the change in the Business.
• Have performed many gap analysis to identify the gaps in the Business Process and Applications.
• Involved in functional testing of various bug fixes.
• Addressed and fixed the issues raised by business during Business testing.
• Resolved Functional/Technical Issues in Burn in phase of the Project.
• Created Multiple Packages, Functions and Stored Procedures.
• Created a custom form and integrated in Oracle apps to meet the business customization.
• Developed interfaces and Oracle client extensions to accommodate complex business requirements.
• Prepared move sheets to migrate the code's to multiple instances.
• Prepared fix sheets to resolve the issues.

Environment: Oracle Apps R12, AOL, AR, PO, INV, OM, OKS, IB, FS, PO, AP, GL, FA, TOAD, PL/SQL, OAF, Forms 10g/9i/6i.

Confidential

Oracle Apps Functional Consultant

Responsibilities:

• Study of the R12 Environment and Feasibility check for the efficient use of new features.
• Involved in doing various setups and preparing mapping document and setup document.
• Testing of various test scenarios of Quote to Cash, Requisition to Purchase Order cycle in Oracle Purchasing, Contract creation, install base integration with Inventory and Order Management and integration of Filed Service/Tele Service, Depot Repair with other SCM and Finance Modules.
• Participated in New Requirement gathering, design, documentation, setup and configuration.
• Analyzed Business Requirement and worked on System Design Document to integrate the requirements in applications.
• Doing impact analysis of the upgrade.
• Analyzing existing setup and extending the same as per requirement.
• Developing new solution as per the change in the Business.
• Have performed many gap analysis to identify the gaps in the Business Process and Applications.
• Involved in functional testing of various bug fixes.
• Exhibited good coordination with Technical team for Design and Development.
• Working on Change Requests (Understanding the requirement, prepare understanding document, prepared technical design document, preparing test cases and UAT).
• Post production support activities.
• Working with Oracle in Service Requests.
• Daily status meetings with the client project manager and review the project status.

Environment: Oracle Apps R12, AOL, AR, PO, INV, OM, OKS, IB, FS, PO, AP, GL, FA, TOAD, PL/SQL, Forms 10g/9i/6i.

Confidential

Oracle Apps Functional Consultant

Responsibilities:

• Worked as a functional consultant in implementation and testing of Oracle Applications R12.
• Involved in requirement gathering and analysis and design of the application.
• Worked with the client team to understand the current Business Process.
• Developed test plans and scripts and conducted testing for quality assurance.
• Involved in Configuring Accounting Setups in General Ledger (4C), Accounting Flex Field Setup in Fixed Assets. Also Involved in Configuring Setups in Inventory, Purchasing and Order Management Modules.
• Worked on requirements gathering, gap mappings, and various functionalities in Supply Chain.
• Determined business requirements for integration of modules and data flows.
• Design custom integrations between SCM, CRM and Finance Modules.
• Working on post upgrade support and interacting with Business users on Issue resolutions.
• Working with the developers on developing conversions, interfaces, reports
• Prepared System design and Module design Documents for Customizations.
• Created custom responsibilities to which were attached specific menus, forms and reports for restricted user access.

Environment: Oracle Apps R12, AOL, AR, PO, INV, OM, OKS, IB, FS, PO, AP, GL, FA, TOAD, PL/SQL, Forms 10g/9i/6i.

Confidential

Oracle Apps Techno Functional Consultant

• The DMOERP project supports end to end business process operations and enhances the business customization for Latin America geography.
• DMO ERP business has been implemented on Oracle SCM, CRM and Financial modules. It includes Manufacturing, Supply Chain Operations, Service Support, Customer Account Management and finally Financial Management.
• The ERP solution provides integrated and coherent processes, in order to facilitate the restructuring and profitability objectives like: Simplification and standardization of business process and also increased reliance on distributors and remote operations and Reducing current costs (IM & Business), Maximizing Legacy System Retirement and use of Established standard financial rules for effectiveness of the finance organization.
• Developed interfaces and Oracle client extensions to accommodate complex business requirements in PL-SQL, Forms and Reports.
• Addressing and Solving production issues which were Business Critical, Major and Normal in nature and required deep understanding of custom business process and end to end knowledge of various modules of oracle apps like CRM, SCM and Finance to resolve it within the pre-specified business SLA(Service Level Agreement).
• Improved and stabilized CRM integration with financial business process by implementing number of permanent solutions like Code improvement, Form Personalization, Setup change, Standard Oracle patch application and adding new improved customizations.
• Worked on various Customizations for Change Controls and created multiple package, function and stored procedure to support it.
• Functionally discussed the requirement with Business and worked on all Major Oracle Apps ERP functional modules like CRM, SCM and Finance.
• As part of day to day support activity monitored scheduled concurrent programs, looked the log of time taking jobs and did performance tuning.
• Resolved almost more than 450+ production Functional/Technical Issues.
• Code change and code improvement as part of production issue or based on client requirement.
• Client reporting on production issues and accelerating the resolution time on demand basis.
• Created repository for recurring issues so that it can be tracked by others and if any issue comes the first place to check is the repository. Later on improved the process to completely nullify the recurring issues by code improvement, Set up change or by new change control.
• Prepared move sheets, fix sheets to move the custom components to other and production environment.

Environment: Oracle E-Business Suite R12/11i; GL, AP, AR, FA, SLA, PO, OM, WIP, BOM, Quoting, INV, Advanced Pricing, AOL, Service Contract, Field Service, Tele Service, Territory Management, Assignment Manager, Depot Repair and Install Base, Toad, PL-SQL developer, SQL *Plus, Oracle Workflow 2.6.