SUMMARY

• Over five years of experience in Oracle ERP. Experienced in Design, Solution and Implementation of Oracle Applications, with core expertise on GAP Analysis, Process Mapping, Defining Business Requirements, Implementation and Configuration of Oracle
• Oracle Certified E Business Suite Implementation Specialist in Oracle Financials: Accounts Receivables R 12.
• Worked on both AIM (Application Implementation Methodology) and OUM (Oracle Unified Methodology) for different projects.
• Expert in the functional aspects of Oracle E - Business Suite/ Applications R12 deployment Requirements, UAT and SOP sessions
• Played key role in application set-ups, implementation, interface development, testing and end-user training.
• Good knowledge in debugging issues and resolving defects
• Extensive functional and business experience in Procure-to-pay, Order-to-cash
• Knowledge on development and analysis of the code and can provide root cause to the developer which drives to the faster resolution of defects
• Experienced on Project go-live and post-implementation support. Proficient in providing workarounds if any issue arises in production
• Proficient in corporate finance, financial systems evaluation, design and implementation.
• Interacted with Business users and the client for providing testing and Production Support as Functional Consultant after GO Live.
• Responsible for driving UAT for components and getting they delivered/deployed into production in a scheduled release.
• Troubleshoot data related issues, Fixing bugs and issues with concurrent programs.
• Developed functional Specifications (AN100), Setup Document(BR-100) based on Business user requirements using Application Implementation Methodology
• Worked extensively with development and testing team members in resolving issues.

PROFESSIONAL EXPERIENCE

Oracle EBS Financial Functional Consultant

Confidential - Atlanta, GA

Responsibilities:

• Oracle Applications: R12.1.3 Implementation Project (INV,OM,AR,GL,CM,AP) for a complex project with good number of customizations
• Worked in OUM (oracle Unified Methodology)
• Gathering business requirements, analyzing the existing system and providing optimum solutions.
• Design the solution, test the solution/processes and drive UAT sessions to get the acceptance of the component from end Business users.
• Helping to close the month end with support in various month end activities and processing the pending transactions if any for the month end.
• Designing functional design document AN100 for the new component based on Business Requirements.
• Worked on the design of customizations to settlements for large external clients which derives most of the business to the client (Consignors).
• Good knowledge in SQL that helps in providing potential solution to the developer for the components and also helps in analyzing the issue when found.
• Supporting the daily production activities and helping Business users by providing workaround when issues are found.
• Partnered with DEV leads in design of Technical Specification (DS140) for the new components
• Configure System to reflect changes for the new component. Update BR100 to record change if the design requires a config change with the code change.
• Worked with various third party vendors and tools like Next gear, Deal-shield, CDT, UVIS and PEGA systems.
• Worked on Deal-shield returns solution by integrating Macola ERP to Oracle.
• Design API’s when needed an API to meet the Business requirements and decides the input and Output parameters needed to call API by providing procedures of GET/POST/UPDATE
• Partnered with other teams in designing Contract decisions of API’s between Oracle and the calling Applications.
• Highly proficient in debugging the issues and provide root cause analysis to the developer which helps in quick resolution to the defects/issues.
• Analyzing and fixing the issues/bugs that were found in QA testing and responsible for the delivering the component in provided time.
• Responsible for creation of SOP (Standard Operating Procedures) for the new components.
• Involved in training the End Users on new components and supporting production activities for the components in the initial days after GO LIVE.
• Worked on the gate pass rules for vehicle release from lot with PEGA systems where all Gate pass rules are housed.
• Identifying the functional requirements for custom programs and communicating required updates to developers.
• Execution of change management using end user training and consultation to align business with the new designed process.
• Testing and Implementing solutions including communicating with a wide number of customers, partners and suppliers.
• End to end Oracle Applications (OM, AR, CM) implementation project from assessment to production support as a functional analyst.

Confidential - Charlotte, NC

Oracle EBS Financial Functional Consultant

Responsibilities:

• Led numerous requirement gatherings, designing, documenting and functional testing of various RICE components for R12 Customizations.
• Worked on Supply chain area using Oracle Apps R12 (Order Management, Inventory, Accounts Receivables, Accounts Payables and Cash Management).
• Worked as a Receivables Functional Analyst with designing components and supporting production.
• Responsible for implementation tasks including Requirements Gathering, Solution Design, System Configuration, Data Migration, Testing and Post Production Support.
• Analyzed the current and new business process using Business Requirements Document (RD050) and Solution Design (MD050) using Oracle AIM methodology.
• Responsible for Configuration of Inventory item master with data loader scripts
• Involved in defining Lookups, Transaction Types, Organization Parameters and Sub inventories
• Worked with development team to provide expertise and ensured successful delivery of extensions, reports and interfaces.
• Worked on different EDI interfaces to provide custom solution to receivables interfaces
• Worked with various Cross Functional Tracks to resolve technical and data issues.
• Responsible for BR100 updates when there is a configuration change involved for new components or change in existing components
• Coordination with offshore team to enable them to understand the process and to familiarize them with the issues that normally generate and the probable ways of resolving them.
• Participated in ongoing Process Enhancements and Change Management meetings and deep dive sessions with Business and Doing impact analysis.
• Worked on Defects logged in HPQC, and ensured that they were fixed on time with the technical team.
• Created Test Plans as per business scenarios and planned testing strategies.
• Wrote Test Cases and Test Scripts (TE040) for functional testing.
• Tested and implemented the requested changes in existing environment.
• Performed Root Cause Analysis of Month end related issues and provided a solution to reduce the month end services.

Confidential

Oracle EBS Financial Functional Consultant

Responsibilities:

• Wrote Functional (MD50), Technical (MD70) design document and Conversion Mapping Document (CV40) for Item Import, Supplier Open Interface and Order Import Interface
• Developed Conversion programs, Staging Tables and Customized PL/SQL API for Item Import and Open Sales Order Import.
• Developed a customized report to show different project activities.
• Developed Custom forms and registered concurrent programs, request groups for reports.
• Created Customized Invoice report for client by modifying standard Invoice Report provided by Oracle
• Created custom Auto Invoice request set with a whole lot of customized requests in the request set to support business process
• Enabled the descriptive flex fields on Sales orders and Invoices to facilitate additional information
• Responsible for development of Purchasing & Inventory Control Modules for implementing security based roles, created users in Oracle also involved in development of Financial Accounting System, production, Dispatch & Maintenance System.
• Created Tables & Views and referential integrity constraints using SQL.
• Analyzed requirement of client and worked on developing and designing reports.
• Implemented Security by creating different users/roles and assigning roles to users forms.
• Performed extensive defect fixing and support during the client pre-production testing phase, identifying issues and tracking them through HP quality center.
• Successfully provided Technical and Functional support to the users, testers and Business SystemAnalysts.