PROFESSIONAL SUMMARY:

• 13 years of professional experience with Implementation, development and support experience in Oracle Applications e - Business Suite in Manufacturing, distribution and Finance Modules. Worked with Fortune 500 Clients Like GET ransportation, Confidential and Cisco for close to 10 years.
• Extensive experience in Oracle Inventory, Work in Process, Bills of Materials (BOM), Order Management (OM),Purchasing, Costing, Engineering Change Order (ECO), Order Management (OM), Account (AP),eBiz Tax, iProcurement, iSupplier, iExpense, General Ledger (GL), Projects & Fixed Assets (FA).
• Proficient inRICE (Reports, Interfaces, Customization, Enhancements) Components Was responsible for identifying the gap, providingwork arounds and designingcustomization requirements.
• Worked on the Design, Development and Integration of WebADI with R12 new features with different layouts
• Expertise in resolving production support issues, Integration between Team Center (Engineering requirements and Proficy - shop floor transactions )
• Trained on R11 Oracle Fusion Cloud Procurement & SCM (Material management, Purchasing, Self Service Procurement, Sourcing, OM, Receipt accounting, Suppliers, Supplier portal, Sourcing, IDM, APM, BPM, Data Conversion).

PROFESSIONAL EXPERIENCE:

Manufacturing and Distribution Track Lead

Confidential, Erie, PA

Responsibilities:

• Responsible for Implementing Manufacuring modules for Confidential Engine Manufacturing Plant located in Grove City, PA.Was part of Requirement gathering, Gap analysis, User, and go live Cut over activities.
• Responsible for identifying the customization requirement and preparing functional Design documents and coordinating with Offshore development team for development requirement.
• Was part of Upgradation projects for 12.1.3 to 12.2.3 and 12.2.5. Played kep role in working with oracle and DBA to identify critical issues and resolving them ontime before golive
• Item Activiation workflow for Material Planner (MP), Global Buyer & Material Technical Advisor (MTA) for organized way to update only their attributes through Oracle Application Framework (OAF) and Governance Risk Control (GRC)
• Worked with Oracle for functionality issues and applying patches as per their recommendation with DBA team

Environment: Oracle Apps R12.2.5, Advanced Pricing, Quoting, OM, Oracle 11g, SQL, PL/SQL, Windows 7, TOAD/SQL Developer, Visual Source Safe (VSS), HPPPM

Oracle FunctionalConsultant / Project Lead

Confidential, Houston, TX

Responsibilities:

• Confidential acquired Smith Bits in houston and worked as Manufacturing and Distribution track lead for roll outs / Implementation and Production support.
• Responsible to setup Internal Requisition and Internal Sales Order (IR ISO) between different Inventory Organizations between Confidential and Smith BitsInvolved in to add the triggers to change the system behaviour in IR-ISO to accommodate user requirements.
• Adding Freight cost while shipping and reflect same in Sales Ord.er, AR Invoice and AP Invoice.
• Personalization Oracle forms to pull the Item price from Price List instead of Item Standard Cost.
• Involved in the changes roll out process into Production through ALM process (Serena Business Manager).
• Coordinated and guided the onsite and offshore team for deliverables.

Environment: Oracle Apps 11i, Oracle 10i, SQL, PL/SQL, AP, AR, Windows 7, TOAD 10.6, Visual Source Safe (VSS).

Oracle Functional Analyst

Confidential, San Jose, CA

Responsibilities:

• Study the existing processes and prepared AS-IS documentation for Inventory, OM, PO modules during the upgrade from 11.5.10.2 to R12.1.3.
• Solution design to resolve issues and developed steps to correct the business processes.
• Resolved issues related to PO and requisition approval workflow and cleared the transactions stuck in the workflow.
• Conducted conference room pilot (CRP), system integration testing (SIT) and assisted end users during user acceptance testing (UAT).
• Extensively worked on User Productivity Kit (UPK) in developing user material and trained super users on the new R12 application.
• Prepared retrofit and BR100 documents to document all the work and explained the new changes to the daily end users
• Prepared test scripts and listed out all the End-to-End test scenarios across all modules as part of the system integration testing.
• Implemented Process employee allowances, advances, benefits and expense reimbursements to expatriate and local employees (iExpense)
• Resolved several issues associated with Inventory, Purchasing and OM during the upgrade process from 11.5.10.2 to R12.1.3.
• Assisted in identifying the upgrade tasks, patches required and completed all post-upgrade steps.
• Provided on-site functional post production support.
• Involved in supporting Oracle Apps 11i and R12 in AR, GL, iPayments, Inventory and OM modules.
• Working closely with Chase Paymentech for all Remittance and Settlement batches when programs are failing.
• Handing integrated issues between different applications
• Billing and Revenue Management (BRM) and Oracle Apps R12
• Billing Lifecycle System (BLiS) and Oracle Apps 11i
• Between Workflowone (3rd party vendor) and 11i Oracle apps for Invoice generation
• Delivery of Invoices on FTP server for Partner customers for easy accessing and billing to their clients (XML, Excel and PDF files)
• Month close process of 11i and R12 separately
• Working with Oracle by raising Service Request during Month close issues and Product related issues.
• Supporting daily activities of business related tasks by raising Remedy Tickets.
• Coordinating with Network admin and DBA to resolve production issues.
• Coordianting with Offshore team to support system 24x7.
• Creating Defects against production issues which will be routed to Solution and Dev team to fix it in future release based on priority.

Financials Functional Lead

Confidential, Burbank, CA

Responsibilities:

• Worked on the entire Procure to Pay business process.
• Performed all the setups for iProcurement, Fixed Assets, PO, AP and GL
• Developed several enhancements to the Business Processes on the Procure to Pay side.
• Worked on the setups for Oracle Fixed Assets module including the setups of the Tax Books and Corporate Books, defining of all the Key Flex Fields, Mass Additions Process, and Depreciation process.
• Pre-upgrade testing and Post upgrade production live support. Confidential Inc successfully had 3 upgrades (Linux Operating migration, Oracle 10G database and Oracle Apps Version 11.5.9 to 11.5.10.2 upgrade).
• Support Production issues on a day to day basis including month end closure p1 issues
• Implementation and support of Cash Management and Account Payable Module
• Functional Support for SOX and PWC Audit
• Integration and Implementation of Foreign exposure through FireApps external software with Oracle GL
• Hands on experience in designing and configuring Oracle EBS, Source to Pay, Quote to Cash
• Provide support/enhancements for the existing Oracle and Discoverer Reports (across AP, Fixed Assets, CM, and AR) and create new ones based on business requirements.
• Creation of Users, Responsibilities, Menu, Request Groups, Request Sets, Form Folders, Key / Descriptive Flexfield Segments / Values, Security Rules, Cross Validation Rules, Journal Sources, Categories, Document Sequence Assignment, Multi-org Setup, Profile Options
• Setup and Support of Markview170 System

Environment: Oracle Apps 11.5.9/11.5.10 e-Business suite (Purchasing,GL,Order Management, Shipping, Advance Pricing, Quoting, SQL*Loader, Data Loader, file loader, Toad

Financials Functional Consultant

Confidential, Schaumburg,IL

Responsibilities:

• Interaction with business users as a part of as - Is Study for client’s legacy application D3 Pick for (Oracle Purchasing, Oracle Payables, iProcurement, Order Management, Fixed Assets, General Ledger)
• Setup the Work Execution flow and Preventive Maintenance Flow in Enterprise Asset Management.
• Worked on the setups of Fixed Assets module, including the defining of the Asset Books, Tax Books, Key Flex fields, Depreciation process, mass additions process, etc.
• Worked on the Revenue Recognition process in AR including setting up the deferred revenue rules.
• Performed all the setups for P2P modules including iProcurement,Purchasing, Inventory and AP.
• Setup Modifiers/Qualifiers in Advance Pricing.
• Business Requirement, Scope Management Documents Preparation
• Fit Gap Analysis for (Oracle Purchasing, iProcurement, Oracle Payables, Order Management, GL, Service Contracts, Install Base, Inventory) & preparation for Fit Gap Document
• To Be High Level & Detail Documents Preparation
• Module Configuration Documents Preparation Oracle Purchasing, iProcurement, Oracle Payables, Order Management, GL, Service Contracts, Install Base, Inventorymodules setup
• User as a part of CRP1, CRP2, CRP3
• Data Migration requirement gathering for (BOM, Routings, Items, Open PO,Suppliers)
• Data Migration functional specification documents creation
• Design Creation & Validations
• Application testing w.r.t individual module
• Issues Tracking & Customer Sign off

Financials and Procurement Consultant

Confidential

Responsibilities:

• Understanding the existing business processes including iProcurement, Purchasing,Order Management, Shipping, Fixed Assets, Advance Pricing
• Preparing existing business process documents
• Discussing with business users and preparing BP80 for future To Be Process documents for PO, iProcurement,Fixed Assets, OM, INV, Shipping, Advance Pricing, Service Contracts, Install Base, iExpense
• Mapping the business processes with Oracle 11.5.10 standard functionalities and identifying the gaps.
• Giving demonstration of standard functionalities of Purchasing,iProcurement,Order Management, Shipping, Fixed Assets, Advance Pricing, INVto the Business Users.
• Proposing solutions and customization for gaps and getting the approval from business users.
• Working with Technical team closely and getting done development for customizations for Purchasing,iProcurement,Order Management, Shipping, Advance Pricing, INV Modules.
• Working closely with Business users to understand the criteria’s and filters for converting data from 11.0.3 to 11.5.10 for Purchasing,iProcurement,Order Management, Shipping, Advance Pricing, INV Working closely with developers to develop code for data migration using Oracle APIs and wrapper programs
• Preparing technical specification documents for Purchasing,iProcurement,Order Management, Shipping, Advance Pricingand INV modules.
• Preparing BR100 and Completing the Setups and configurations for iProcurement,Purchasing,Order Management, Shipping, Advance Pricing, INV
• Preparing and using dataloader script to load the data and completing setups for Service Request module.
• Preparing the test cases for Purchasing,iProcurement,Order Management, Shipping, Advance Pricing, INVmodules
• Conducting CRP1, CRP2 UAT1 and UAT2 and helping the user for going through all the test cases.
• Fixing the issues collecting during CRP1, CRP2 and UAT.
• Working 24 by 7 during cutover and down time
• Providing support to users after implementation is done and fixing all issues related to set ups
• Fixing the issues for converted data for Purchasing,iProcurement, Order Management, Shipping, Advance Pricing, INV modules

Environment: Oracle Apps 11.5.9/11.5.10 e-Business suite (Purchasing,iProcurement,Order Management, Shipping, Advance Pricing, INV SQL*Loader, Data Loader, file loader, Toad, Windows NT, HP UNIX

Financials Functional Consultant

Confidential

Responsibilities:

• Functional Consultant for implementation of Main Accounting System, responsible for implementation of GL, AP, AR, CE, Public Sector Financials
• Complete responsibility of Integration, Accounting & Reconciliation aspects with other modules viz. Payables, Purchasing, Inventory, AR, GL and Cash Management
• Super user, manuals: GL, AP, AR, GL and Cash Management
• Definition & Documentation of Business Requirements
• Business Requirements Mapping, Workshops:
• Managed phase wise roll out of Purchasing module to all locations, with user access control through Security Rules, Cross Validation rules
• Changed the 30-year old ‘Chart of Accounts’ bringing Oracle GL Key Flexfield benefits to client through Cross Validation Rules, Absolute Budgetary Control
• Integration / Interface with all revenue administration legacy systems in the country such as Income Tax, VAT, Excise & Customs, Road Transport.
• EFT, Bank Reconciliation Interfaces with all major banks in the country
• Acceptance Testing:
• Definition of test cases, scenarios
• Unit, System & Integration Testing
• Go-live Activities:
• System Set-up & Initialization
• Creation of Users, Responsibilities, Menu, Request Groups, Request Sets, Form Folders, Key / Descriptive Flexfield Segments / Values, Security Rules, Cross Validation Rules, Journal Sources, Categories, Document Sequence Assignment, Multi-org Setup, Profile Options
• Review set-up with Oracle Diagnostics Scripts
• Data Take on Strategy:
• Data Take Seminar for 100+ users explaining take on of static & dynamic data
• Upload of Trial Balance, Open Purchase Order, Invoices, Reconciled Payments / Receipts, Impress Balances using Oracle APIs, Dataloader Professional
• Data Take-on Reconciliation, Audit & Sign-off
• End user / manuals for 3 months for 300+ users
• Post Implementation Support:
• Handling user queries / clarifications
• Metalink support
• Oracle diagnostics tools
• Ad-hoc information needs using SQL
• Application Development / System Administration:
• User, Responsibility, Menu, Request Group, Application, Function Security, Request Set, Scheduling Concurrent Programs, Report Notifications, Value Sets, Key / Descriptive Flexield Segments / Values, Default Folders
• Quality Control:
• Version control of documentation, scripts, forms, reports etc.
• Review of mapping, documentation through Oracle Health-check Audits

Release 12.0.3 Impl, Upgrade from Release 11.5.9

Functional Consultant

Confidential, IL

Responsibilities:

• Actively Participated in collecting current business process requirements to map with new environment to Implementation purpose.
• Preparation of Set up Document (BR100) in various modules GL, AP,iProcurement, PO
• Defining Accounts Payable Setups financial options, payables options,payment terms Banks, based on new requirement.
• Defining Journal Line Types, Journal Entry Description, Mapping Sets, Account Derivation Rules, Supporting .
• Defining Purchasing Setups Purchasing Category Flex field, Purchasing Options, Receiving Options.
• Prepared few functional Design Documents for application extensions (MD.050)
• Defining Set Up Rules, Profile Options, and System Parameters.
• Preparation of Integration Test Script(TE040)
• Resolved Bugs that cropped up during the time of testing.
• Raised Technical Assistance Requests(TARs/SR) for issues where more clarity was required OR where there was a bug in standard functionality provided by Oracle. the Functional Users of the system to enable them to proceed with the User Acceptance Testing of the configured

Functional Consultant

Confidential, Santa Clara, CA

Responsibilities:

• Writing and executing detail manual test scripts in Mercury Test Director.
• Developed test scripts, input test data, and expected results for test plans.
• Assisted automation of scripts into QTP using manual scripts developed in the Quality Center.
• Reviewed requirement documents use cases, design specifications, and project plans to prepare test plans.
• Developed a library of automated test scripts to be executed in automation of regression test to reduce test cycle time.
• Researched testing errors for resolution and documented all defects in detail with attachments, before passing on to the senior business analysts for further review.
• Interacted with the end users to get necessary feed backs.

Functional Applications Consultant

Confidential, Fort Wayne, IN

Responsibilities:

• Documented research work and created power point presentations for business & economics-based research.
• Assisted and supported international student administration and recruitment.
• Created and maintained international student database based on MS excel spread sheet.
• Created and presented power point presentations on various business topics during monthly and quarterly international student conference meetings and gatherings.