SUMMARY:

• 8+ years of experience as oracle apps consultant working with multiple clients for ERP implementations, Business Process Reengineering (BPR) and enterprise system enhancement projects.
• Excellent at requirement gathering, communicating details with stakeholders, business users, SMEs and IT team.
• Strong functional knowledge on business processes related to supply chain management, inventory management, logistics and distributions.
• Experience in multiple phases from project initiation, planning, business analysis, functional design, build, test, User Acceptance testing (UAT), GO - Live and Post-Production Support.
• Supply chain and distribution modules expertise: Order Management(OM), Shipping, Inventory (INV), Purchasing(PO), Advanced pricing, iProcurement, iSupplier, BOM, Warehouse Management (WMS), Work In Process (WIP), Service Contracts, Install base, MPS/MRP,ASCP and Costing.
• Financial modules expertise: Accounts Payables (AP), Accounts Receivables (AR), iReceivables, iExpenses, Sub Ledger Accounting (SLA), Fixed Assets (FA), Cash Management (CM) and General Ledger (GL).
• Strong knowledge on Oracle EBS ERP architecture (11i and R12),multi-org structure.
• Extensive experience in providing functional design of CEMLI(Customizations, Modifications, Localization and Integration).
• Worked on data migration and cutover plan design.
• Extensive experience in requirements gathering, As-Is, To-Be and gap analysis, scope validation.
• Technical knowledge on Oracle SQL/PLSQL, Oracle Application Framework (OAF), Shell Scripting, Oracle Forms/Reports Builder and Oracle XML/BI Publisher.
• Successfully completed full life cycle implementations. Strong experience in global rollouts and implementation, upgrade, post implementation support and enhancement projects.
• Worked in Agile, Waterfall, Oracle AIM methodologies with ON-shore/OFF-shore model and followed required documentation.
• Worked on multiple global rollouts to North Americas (US, Canada), Europe and Middle East (EMEAand Asia Pacific (APAC).
• Business process Expertise: Order to Cash (OTC) and Procure to Pay (P2P) business processes, Oracle apps configuration and tight integration with third party systems.
• Excellent critical thinking skills, mapping requirements to the standard functionalities of Oracle EBS applications in best way possible.
• Strong business analysis and interpersonal skills, communicating with stake holders, SMEs, providing solutions in explained presentations (PPTs) and conducting conference room pilot (CRPs) sessions.
• Documentation: Configurations/setups (BR100s), Authored multiple business requirements (RD050s), Functional design (MD050s) and testing (TE040s).
• Worked on setup profile options, Multi Org Access Control (MOAC), responsibilities, data and definition access sets, document security, inventory org access, grants and roles.
• Technical Expertise: Good understanding of different Oracle developer tools. Engaged in data conversions/migration, reviewed PL/SQL packages, OAF page customizations, form customizations, worked on Reports, Interfaces, Conversions, Extensions and Workflows (RICEW) and CEMLI components.
• Worked on complex upstream and downstream integration with Oracle and third party products like Oracle Hyperion, Oracle PIM, Oracle IDM, and Revstreamrevenue recognition applications and cloud based mobile expense tool CONCUR.
• Completed 2 implementation projects with physical Inventories for P2P and OTC business flows with
• IR-ISO and Back to back order flow setups.
• Provided solution design for form customizations, report customizations, profile options, defaulting rules, processing constraints, functional setups and descriptive flexfields (DFF) setups.
• Testing and Training: Functional testing, preparing test plan, test cases, automate testing using Oracle Application Testing Suite (OATS), System Integration testing (SIT), train users on User Acceptance Testing (UAT) and Business Acceptance Testing (BAT).
• Lead system design, managed deliverables to keep project on schedule and report managers and stakeholders.

PROFESSIONAL EXPERIENCE

Confidential - Raleigh, NC

Oracle EBS functional Consultant

Responsibilities:

• Responsible for Business analysis, requirement gathering, solution documentation and quality assurance of Oracle ERP systems, other integrated systems, covering all business requirements, interacting with stake holders and building complete testing framework.
• Discussing and understanding pain areas, bottle necks with various Business processes and recommending cost effective solutions as per defined scope as process improvements/feature enhancements.
• Provided solution on enhancement of Oracle OTC modules, Order management, Shipping, inventory, Oracle Receivables and Oracle Projects.
• Redesigned and implemented Oracle Advanced pricing setting up qualifiers, modifiers, price lists.
• Worked on processing constraints, defaulting rules, customers, master items and multi org functionalities.
• Provided functional design on integrations between CONCUR Cloud application and Oracle EBS applications.
• Responsible for managing functional documents test deliverables aroundsupply chain modules- Purchasing (PO), OM, INV modules.
• Redesigned the current complex Pricing structure and reduce the number of modifiers drastically, this also improved the performance of order entry.
• Setup Order to cash modules which includes OM Transaction types (Order types), Release management Schedules, Line types, OM workflows, Order Booking, Order Scheduling, Order release, Pick pack & ship, interfacing to receivables.
• Provided client with Application extensions functional design(MD 50).
• Worked on the setups of OM Module - defining Processing constraints, Credit check rules, setting up defaulting rules, Transaction Types, Header and Line workflows, etc.
• Conducted daily scrum standup meetings. Conducted biweekly sprint planning which includes team retro, analyze backlogs, updates on grooming.
• Written Use Cases and functional specifications to enable design and solution.
• Working closely with Business and IT for documentation RD050 (Gather business requirements), BR100 (Application setups), BRD, FRD, FSD, Change Request, Mapping, Work Flows of requirements.
• Performed functional setups in OM, INV, AR, AP, Oracle project costing and GL including profile options, Customers, TCA setups, credit checks, processing constraints, defaulting rules.
• Log, View, access, monitor, follow up and Close Service Requests and Oracle Applications Patch management.
• Created read only roles for iExpenses after CONCUR go live.
• Worked on QA activities in implementation of Concur mobile expenses cloud based application. Performed functional testing, integration testing and End to end business testing including Oracle Projects and other related modules.
• Conducted business scenario meetings for demoing and implementation of Trading Community
• Architecture (TCA).
• Coordinated with analytics team in providing data source for creating repositories related to report generation based on development requirements.
• Provided complete solution on building test strategy, documentation, test execution and functional setups in Testing and UAT Demo instances.
• Involved in migration of historical data, month end closing process, and reconciliation.
• Participated in code and design reviews for Inbound and Outbound interfaces for Concur integration with Oracle Payables.
• Worked on Agile methodology. Extensively used Rally (CA Technologies) to coordinate with PMO and team. Presented project status in detail to project sponsors.
• Tested Auto Lock Box and ACH Payment process to automate customer receipts and supplier
• Payments.
• Prepared TE040 testing document including test cases and test scenarios for all functionalities related to Order to Cash and Procure To Pay process including functional setups and customizations and performed End to End testing and integration testing.
• Worked on managing QA Environment including the QA staff and QA Labs.
• Coordinated with analytics team in providing data source for creating repositories related to report generation based on development requirements.
• Responsible for reviewing and updating Test Plan Preparation, Test Strategy Preparation, Team
• Meetings Facilitation, Defect Tracking Facilitation, etc.
• Wrote complex sql queries using TOAD, joining multiple tables for testing and data validation
• Communicated and interacted on a regular basis with the project manager and development team during different stages of the project.
• Maintain and update issues log for reporting the status of the issues and conducting issue status meetings with users on weekly basis for post-production support.

Environment: Intel Server with Linux OS, Oracle Applications R12 (AP, CONCUR, AR, SLA, GL, OM, Advanced Pricing, INV, PO, BOM, AOL) Oracle 9.x, 10g, Oracle, Web Server, Oracle Developer 10g (Forms and Reports) and SQL Loader.

Confidential - Los Angeles, CA

Sr. Oracle Functional Consultant

Responsibilities:

• Two teams were involved in implementation of Oracle EBS and customization in different (Oracle AIM and Agile SCRUM) methodologies with Onshore/offshore model.
• Responsible for gathering business requirements, providing best practices, interacting with stake holders, gap-fit analysis, provide solution design of gaps and UAT.
• Lead the UAT, driving test script execution for OM, Pricing and inventory modules.
• Documentation: Authored Application configuration/setup (BR100), Functional Design (MD050) and document business procedure (BP090).
• Responsible for area of analysis for Bills of materials, provided business process improvements with new customized subscription based product bills and tight integration with Order management (OM) for continuous orders with different product bills each term.
• Implemented iProcurement module - worked on category hierarchy, content zone creation, creating stores.
• Responsible for assisting business users, stake holders, business analysts on user story grooming.
• Worked on user story allocation for each sprint to avoid conflicts and to run smooth sprints.
• Utilized JIRA efficiently proving prompt updates such as holds and blockages. Helped run short and efficient SRUM stand ups and excellent coordination with SCRUM master and IT teams.
• Demoed user stories during Sprint review at end of each sprint to business users explaining each story points in detail.
• Created Use Cases, Use case diagrams, Activity Diagrams.
• Developed Requirement Traceability Matrix (RTM) for maintaining/updating current and new system requirements using MS Excel.
• Performed setups related to suppliers, requisitions, RFQ setups, PO setups, PO agreements, and payment terms, receipt routings, invoice tolerances, invoice holds and expense report templates, aging periods.
• Worked on the setups of the e-Commerce gateway setups - defining the data file directories, trading partner data, defining code conversions and e-Commerce profile options, etc.
• Created Vacation rules in iProcurement, viewed and maintained Vacation rules and transaction approvals for workflow notifications.
• Validated the complete P2P and OTC cycle, all related functionalities, customizations and respective accounting entries before demoing the same to stakeholders and Business users.
• Provided detailed presentations (PPTs)and Conference Room Pilots (CRPs) explaining Oracle R12 standard functionalities, features and look and feel of customizations for all major business flows.
• Validated the complete Procure ToPay cycles and all related functionalities, customizations and respective accounting entries before demoing the same to stakeholders and Business users.
• Involved in migration of historical data, month end closing process, generating reports and reconciliation.
• Prepared TE040 testing document including test cases and test scenarios for all functionalities related to Procure to Pay andOrder to Cash process including functional setups and customizations and performed End to End testing and integration testing.
• Coordinated with analytics team in providing data source for creating repositories related to report generation based on development requirements.
• Worked on developing test strategies, test cases and test plans, Requirement Traceability Matrix, reviewed test cases and design documents and facilitated User Acceptance Testing. Responsible for training the end users on the new processes and facilitated on-the-job training.
• Communicated and interacted on a regular basis with the project manager and development team during different stages of the project.

Environment: Intel Server with Linux OS, Oracle Applications R12 (AP, AR, GL, OM, Advanced Pricing, INV, PO, BOM, AOL), JIRA, ALM Oracle 9.x, 10g, Oracle, Web Server, Oracle Developer 10g (Forms and Reports) and SQL Loader.

Confidential - Minneapolis, MN

Sr. EBS SCM Consultant

Responsibilities:

• Acted as functional consultant managing business requirements gathering, functional setups of
• Oracle SCM and manufacturing modules.
• Deliverables: Perform GAP analysis, extensions functional design(MD050), perform functional setups (BR100) and assist in testing document creation (TE040).
• Lead the UAT, driving test script execution for OM, Pricing and AR modules.
• Conducted Conference Room Pilot (CRP) sessions providing detailed explanations of solutions through presentations (PPTs) and variations to the existing business processes. Answered business regarding time and resource involved in implementation.
• Worked on the setups for the flows of Return Material Authorization (RMA) process for Reverse Logistics.
• Designed conversion strategy for Suppliers, Customers, Customer Open Balances and Supplier and Customer Bank accounts.
• Conducted Business Scenario meetings for TCA, OM, PO and AR. Participated in Service contracts scenario meetings. Worked on the Conversion and Cut-off Procedures, to bring legacy data into the future systems.
• Worked on the implementation of Inventory module - defining the Master and Child Orgs, setting up Sub Inventories, defining locators, lots, serial control, worked on setup of catalogs and categories.
• Setup deferred COGS in Costing. Validated deferred COGS for all business flows including return flow with Return Material Authorization (RMA).
• Implemented Standard Costing. Setup cost category codes, defined WIP accounting classes, resources, overheads, expenditure types with cost elements
• Worked on the Return to Vendor Process, return with Repair, return with Exchange, Return for Credit, Bulk Return, etc.
• Implemented WIP module for ATO model - setup ATO model, ATO model class, WIP jobs, WIP supply types, profile options, WIP parameters and costing setups.
• Log, View, access, monitor, follow up and Close Service Requests and Oracle Applications Patch management.
• Performed Bill Of Materials (BOM) setups: profile options, standard bills, routing, department classes, overheads, alternative BOM, and change order types.
• Warehouse Management (WMS) implementation from scratch to build for a Manufacturing client (Picking/Put Away/Cost Group Assignment/Bar Code Label.)
• Designed and defined and bar coded label for WMS warehouses (Pick slips/pack slips).
• Design, define and setup Work in process parameters, profile options, define production lines, associate lines and assemblies, employees, labor rates, shop floor statuses, define job and operation documents.
• Worked on all the setups for theINV, OM, WIP, PO,BOM,EDI e-Commerce gateway for inbound and outbound transactions.
• Monitoring of Scheduled Jobs to identify if any job is aborted or stuck. In such cases analyzing the cause of job being stuck and manually running the job as a workaround.
• Implemented the Available to Promise (ATP) business process based on the collected data from planning.
• Transformed business requirements for Order Management, Purchasing, shipping, Inventory, and
• Install Base/Field service into test requirements.
• Lead mapping and validation of Projects data.
• Participated in code and design reviews for Inbound and Outbound interfaces using Oracle EDI.
• Created new responsibilities with limited access and full access. Provided training on using them to business user group.
• Played major role during cutover and rollout of Oracle R12 applications to production.
• Worked on bug fixes at short time period during post UAT fixes and worked on testing complete procurement process including setups, customizations and extensions.
• Worked on Deployment and Post Production Support plan including KT Sessions, User Experience and
• Lessons learned and solutions to complex issues using Oracle METALINK.
• Created training documents for user training and helping in business training.
• Maintain and update issues Log for reporting the status of the issues and conducting issue status meetings with users on weekly basis for post-production support.

Environment: Intel Server with Linux OS, Oracle Applications R12 (AP, AR, GL, SLA, OM, Advanced Pricing, INV, PO, WIP, BOM, AOL) Oracle 9.x, 10g, Oracle, Web Server, Oracle Developer 10g (Forms and Reports) and SQL Loader.

Confidential - Atlanta, GA

E-business Functional Consultant

Responsibilities:

• Study and analysis of the existing systems and business processes to create AS-IS document. Understanding the highly customized Oracle apps functionalities with custom Roll-up of funds at different levels from assets to portfolio for the investors.
• Worked with Business and IT teams to design solutions for future business process and automation of procedures.
• Conducted conference room pilot (CRP), training and testing sessions for business champions super users.
• Performed all the setups for Cash management, Payables, Receivables, General ledger, Fixed Assets, iProcurement, Purchasing (PO).
• Created category mapping, purchasing category assignment, smart forms as part of iProcurement implementation.
• Prepared FIT-GAP analysis document (BR150) and identify the RICEW components.
• Worked on the data mappings, fixing errors, design specifications around the e-Commerce gateway including the following mappings - EDI 810 Invoice inbound, 850 Inbound Purchase Order, EDI 852
• Product Activity Data for transmitting POS Data, EDI 832 Price/Sales Catalog, 843 Inbound Response to RFQ, 856 ASN (Shipping) inbound and outbound
• Configuration, enhancement and prod support of Oracle payables, Financial Statement Generator (FSG) reports, Account payables, and General Ledger and Inventory modules.
• Ensured defect-free product functioning by performing extensive testing of various test scenarios.
• Designed several inbound and outbound interfaces for transfer of Data into Property Tax Management System.
• Involved in Conversion of Sourcing Rules, Assignment Sets and Approved Supplier list.
• Worked on Processing Constraints, Validation Templates, Record Sets and corrected the setups according to the business needs in Purchasing and Accounts Payable module.
• Setup various Functional designs for Accounts Payable module.
• Setup the Approval Hierarchies in Oracle Purchasing module.
• Worked on i-Expense configuration - setting up the expense report templates, expense reporting rules for approvals, defining the per diem policies, policies for various expense categories. Etc.
• Worked on the setups for AME including the AME Rules, Actions, Attributes, Conditions, etc.
• Preparing BR100, MD050, TE40, TE50, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• Delivered product functionality clarifications to clients to maximize productivity.
• Provided timely reports and drove steering committee meetings to update on the direction needed to solve the issues.
• Responsible for Test Plan Preparation, Test Strategy Preparation, Team Meetings Facilitation, Defect Tracking Facilitation, etc.
• Conducted CRP 1 Testing and CRP 2 Testing to super users and UAT.
• As part of AIM implementation, provided client with Application extensions functional design (MD 50), Unit Test Script (TE 20), System Test Script (TE 40) and User guide (DO 70).
• Written standard test scripts for Supply Chain Modules of PO, INV, Oracle Financials (AP, AR, GL, FA and Cash Management) and Project Accounting (Costing, Billing).
• Documented and communicated test results to the Test Management and Business Management Team. Worked closely with Developers team for different issues.
• Resolve Production issues on a day to day basis and provide Level 1 Support for Business Users.
• Provide Post production support in different projects that involved interaction with end users and provided them with effective solutions or workarounds.
• Support Production issues on a day to day basis including month end closure p1 issues
• Created/Maintained Business process Documents BP-80,RD-20,BR-30,BR-100,MD-50,TE-40,CV-40 for requirement gathering, process design, system configurations, custom reports, discoverer reports and conversions (RICE) and test scripts in AIM methodology as part of project implementation task.
• Prepared Cut- over Plan, Listing down all Pre & Post Go- live tasks. Involved in Post-Production support.

Environment: Intel Server with Linux OS, Oracle Applications R12 (AP, AR, GL, SLA, OM, Advanced Pricing, INV, PO, BOM, AOL) Oracle 9.x, 10g, Oracle, Web Server, Oracle Developer 10g (Forms and Reports) and SQL Loader.

Confidential

Oracle functional Consultant

Responsibilities:

• Involved in interviewing business users, SMEs, end users and gathering requirements, reviewing and then documenting them in a standard template.
• Took part and gave input on implementation of Oracle ASCP, Demantra, OM, Advance Pricing, Shipping (Logistics), Reverse Logistics, PO, INV, WIP, BOM modules.
• Defined transaction types for order processing such as standard order, RMA - Credit Only and RMA - Credit after receipt.
• Created the BRD (Business Requirement Document) and then wrote the Functional specifications based on the high level requirements which were documented into the FRD (Functional Requirement Document) to help the developers better visualize the planned enhancements.
• Developed standard and integration Test Cases for OM, AR, AP, GL, FA, PO, INV and BOM modules.
• Worked on Auto Invoice, AR invoice creation, RMAs, Credit Memos, COGS, ATOs, PTOs, pricing, modifiers, qualifiers, Freight cost, Global Order Promising, etc. Implemented LIFO costing.
• Created Use Cases, Use case diagrams, Activity Diagrams to help IT and QA get a better understanding of the application.
• Developed automated scripts and executed them using Win Runner.
• Performed all phases of end-to-end testing which includes Functionality testing, Regression Testing, GUI testing, boundary testing, negative testing, system testing, unit testing and Smoke testing of the Application, its interfaces and Client-Server Utilities using Mercury Interactive Tools.
• Configured and performed functional setups for Oracle Purchasing (PO), Trading Community
• Architecture (TCA), and Accounts Payables (AP) and Cash Management (CM) modules.
• Performed Performance Testing, Stress Testing using Load Runner.
• Used Mercury Suite (Winrunner, Test Director) for test script and defect management.
• Responsible for creating Dataflow diagrams use cases and use case diagrams using MS-Visio and
• Rational Rose.
• Tested all RICE components which include all shipping documents like ASN, Shipping manifest, Bill of Lading etc.
• Tested auto sourcing rules for Suppliers.
• Handled IR-ISO process for internal order process.
• Executed SQL queries as per requests to collect, analyze and report ad-hoc metrics to the management.
• Involved in troubleshooting issues on Transaction Import Program in Oracle INV module.
• Closely assisted the QA team in writing and executing SQL Queries to validate the data in the SQL- Server database for backend testing.
• Performed UAT (User Acceptance Testing) on the various enhancement releases.
• Played an active role in training users and providing support on any issues by providing user manuals, training guides etc.
• Prepared status and activity reports for management review and notified management of issues and problems requiring immediate attention.

Environment: Intel Server with Linux OS, Oracle Applications R12 (AP, AR, GL, SLA, OM, Advanced Pricing, INV, PO, WIP, BOM, AOL) Oracle 9.x, 10g, Oracle, Web Server, Oracle Developer 10g (Forms and Reports) and SQL Loader.

Confidential

Oracle EBS Systems Analyst

Responsibilities:

• Developed a process to import data from legacy system into staging tables using SQL*LOADER, perform validations prior to transferring data into OM Open Interface tables.
• Used standard Order Import to load the Open Orders from the interface tables to the standard OM tables.
• Conducted meetings with Super users/SME's to gather requirements for Procure to pay and Order to Cash cycles and documented in BR-30.
• Analyzed systems design specifications and developed Test Plan, Test Cases to perform overall QA testing.
• Worked on INV module configuration - defining the Inventory Master and Child Orgs, Sub Inventories, Locators, Lots, Min Max Planning, Re-Order Point planning, cycle counting, physical inventory, etc.
• Developed PL/SQL programs and scripts. Registered concurrent programs, request groups for reports.
• Used Test Director to track and report system defects and bugs, involved in writing modification request for the bugs in the application and helped developers to track the problem and resolve the technical issues.
• Worked in onsite as well offshore as per business need.
• Worked on creation of Users, Responsibilities, Menu, Request Groups, Request Sets, Form Folders, Key / Descriptive Flex Field Segments / Values, Security Rules, Cross Validation Rules, Journal Sources, Categories, Document Sequence Assignment, Multi-org Setup, Profile Options.
• Facilitate Segregation of Duties in Oracle Applications. Customize various roles and responsibilities as per the SOD Document in System Administration.
• Worked on setup configurations including Flex Field Values & Value Sets, OM Order Types & Workflows, Pricelist Shipping/Picking parameters, Release rules, profile options, lookups & module specific shared entities & objects and their integration.
• Performed Functionality, Integration, GUI, Regression, Usability, System and Testing of installation.
• Actively involved in automating test cases using Quick Test Pro.
• Configured and performed functional setups for Order Management (OM), Oracle Purchasing (PO), Trading Community Architecture (TCA), and Accounts Payables (AP) and Cash Management (CM) modules.
• Executed performance tests using Mercury Interactive Load Runner Scripts, wrote custom functions and programs to support the load testing efforts.
• Extensively performed Manual Testing process to ensure the quality of the software.
• Participated in QA reviews and audits during various phases.
• Assessed the testing progress and issues to be resolved by conducting walkthroughs.
• Worked closely with project manager in project planning and execution of test plans and test cases.
• Documenting and communicating test results using Test Director

Environment: Oracle e-business Suite 11.5.10, Quick Test Pro, Load Runner, Test Director, Windows 2000