SUMMARY:

• Over 6 of experience as an Oracle systems business Analyst with Oracle Applications Implementation, Rollouts, Upgrades, Enhancements, Testing, 3rd party system integrations and production support specialized in Oracle Distribution, Advance Pricing, Discrete Manufacturing, CRM modules and of part of financial modules.
• Extensive experience in all phases (SDLC) of Oracle EBS Implementation with major focus in SCM OM (Order Management), INV (Inventory), Advanced Pricing (QP), PO (Purchasing), BOM (Bills of Material), Work in Process (WIP), Install Base, Oracle Alerts and AOL (Application Object Library) modules.
• Hands on experience in creating a WebUI service - using Oracle ADF.
• Created various Audits and automated them for Pre-and Post-Payroll Process to verify Counts and amounts for processed employees.
• Experience in the preparation of Functional Design, Technical Design documents and System Test scripts for Extensions, Data Conversion/Migrations, Inbound / Outbound interfaces, Reports, Forms and Customizations.
• Strong team player with extensive Oracle ERP experience with successful implementations/Upgrade involving RICE objects after thorough technical analysis of user requirements.
• Hands on experience in supporting Oracle Applications Fixed Assets, Ebtax, iExpense and proficient in Procure to Pay (P2P) and Order to Cash (O2C) tracks.
• Experience Oracle Enhanced Retro Pay for managing distribute current payments to the period in which they were earned.
• Expertise in developing RICEF components (Reports, Interfaces, API's, Conversions & Extensions, OAF) in Oracle Applications E-Business suite 11i and R12.
• Resolved issues with fast formulas, Elements, setup, year-end processing, tax withholdings, balances conversion and maintenance, employee W2, 401k plans, online pay slips, Employee and Tax balances, involuntary elements, Payroll-Benefit related issues.
• Set up Payroll, Payment Methods, Event Groups, Elements with Earnings, Information, and Deduction classifications, Element Links, Element Entries, Element Set, Assignment Sets, Consolidation Sets, Retro Pay, Proration, Balance Adjustments, Batch Element, Costing, Payroll User Tables
• Experienced in middleware (Oracle SOA) integration between Oracle EBS and ASRS (Automatic Storage retrieval systems)
• Experienced in integrating Oracle ERP and custom picking engines to handle Inventory Catch weight challenges in Oracle.
• Experienced in implementation of Order to Cash, Shipping (Inter-plant & Cross Dock), and Finished Goods Receiving business processes.
• Proficient in Data retrieval using SQL queries and supporting the necessary service requested logged with oracle. Ability to assist and guide technical team in Technical Design and Development of business requirements.
• Excellent Analytical, Troubleshooting, Organization, and Presentation Skills. Experience working in a Dynamic, Cross-Functional Team, with excellent interpersonal communication and cross functional leadership skills.
• Functional and Technical expertise in Oracle Application modules such as Oracle Payables, Oracle Receivables, Cash Management, General Ledger, Order Management, Purchasing, Inventory and iProcurement.
• Knowledge in Oracle Application Framework (OAF) for extensions and customizations within Oracle EBS Suite.
• Oracle EBS Applications R12, R11i (financials, supply chain, order management, manufacturing, HRMS, Payroll, OTL, etc.)
• Functional and Impact analysis of Oracle delivered Patches including Yearend, Statutory and RUP patches for new functionality in US Payroll.
• Ensuring smooth closure of Payroll Year end and statutory reports.
• Experienced in MVC (Model View Control) Architecture using Oracle Application Development Framework (Oracle ADF) and JDeveloper. Good knowledge of ADF architecture and its components.
• Extensive knowledge with Order to Cash (O2C), Intercompany Transactions (IR-ISO) and Procure to Pay (P2P) cycles, RMA / Service Process (Return & Repair, Replacement, Advance Replacement)
• Expertise in designing, execution of training programs for business users and testing teams and coordinating with DBA's for solution development and proficient in both Agile and Waterfall methodologies.

PROFESSIONAL EXPERIENCE:

Sr. Oracle EBS Consultant

Confidential - Boston, MA

Responsibilities:

• Business Process Mapping between SFDC & Oracle using Modules - Configurator, Quoting, AME, Advance Pricing, BOM, OM, Service Contracts, Install base, Receivables, Inventory.
• Closely worked with the technical team and integrated SFDC and Oracle using web service and enabled Guided Selling for easy product configuration.
• Business process from Service Fulfillment (Custom module) mapped to Oracle using the following Oracle Modules BOM, OM, Service Contracts, Install Base, Advance Pricing, Receivables, AME and Inventory.
• Conducted CRP and explained the new process right from Quote to cash and periodic billing against product usage based on counter readings and counter Property
• Monitored functional teams with their configurations and testing teams to ensure proper test coverage in each business area.
• Worked on extension of seeded OAF pages in HRMS module by implementing new logic in Controllers
• Involved in developing PL/SQL stored procedures to meet the Interface and Conversion requirements.
• Working on enhancement in oracle application in oracle reports, oracle forms and oracle workflow and XML reports.
• Involved in fixing code issues raised during SIT (System Integration Testing) and UAT (User Acceptance Testing) and worked with oracle support team through Service Requests (SR's) on seeded performance Issues
• Identified areas of Improvements and changes wherever applicable to custom codes and development standards, in-order to mitigate gaps and thereby improving overall quality of deliverables.
• Actively Involved in Pre-and Post Go-live activities, including deployment.
• Worked on the Functional Mappings for data conversion from 11i to Release 12 for all Distribution and Financials modules.
• Involved on Retro Adjudication Epic Project, reviewing programming, found program defects, provided solutions
• Solution Designed for Core HR, Payroll, SSHR, OLM, iRecruitment and interface between third party payroll and finance system.
• Managed team for technical development for CEMLI and data migration scripts.
• Coordinated with business and vendors for procurement of service and oracle Forms Personalization for Accounts Payables supplier contact directory.
• Participated and actively led in thorough and requirement gathering sessions and detailed business mapping workshops running over multiple months in initial phase of the project.
• As a Senior Oracle EBS Techno-Functional Consultant, contributed in design and development of the Implementation of Oracle R12 Procure to Pay, from end to end.
• Involved in Pre-Analysis phase, Prototype phase, Global Design phase, CRP1 and CRP2 phases of R12 Upgrade Transformation Project.
• Working as Oracle apps Finance functional lead consultant responsible retro fitment and Fit Gap analysis of various Financials modules like Accounts Payable, Accounts Receivables, General Ledger, modules between 11.5.10 and R12.2.4 version of Oracle Apps,
• Developed new OAF Page in iProcurement to import BPA Item catalog images.
• Implemented Oracle Purchasing, iSupplier, iProcurement, Sourcing modules.
• Worked on OAF VO Extensions and CO Extensions on multiple pages in iProcurement and iSupplier modules.
• Working on Payroll and OAB like PTO, Oracle Enhanced Retro Pay, FLSA, Costing, Employee, Payroll and Balance Conversion, Benefit Program, Plan Types, Plans and Options.
• OAF Personalization done for numerous pages in iProcurement, iSupplier, iReceivables and Oracle Login Page.
• Developed Bank Reconciliation reports, Positive pay files and escheatment reports in Payroll and Finance streams for cheque payouts and escheatment processes for unclaimed checks.
• Creation of new Discoverer reports and implemented simple and advanced search functionality in ADF.
• Reviewed the Retro Adjustment Procedures and Applicant Review pages. Assessed Rotation Plans and developed detailed project plans, work plans, and procedures to ensure projects were consistently delivered on time and within budget.
• Involved in Configuration of Oracle I-Procurement (12.1.3) for Expense items & Configuration of Oracle Purchasing for Process Items.
• Retro fitting during upgrade for Pages, People code, Application engine and Customization on delivered Objects.
• Involved in iProcurement approval hierarchy setup and resolved approval hierarchy issue due to wrong approval management (AME) setup.
• Design and development of Interfaces & XML reports within Oracle EBS - Including preparation of Technical design document, Installation document, and test scripts.
• Developed multiple OAF pages to address specific requirements including Advanced Tables, Table-in-tables, Parent Child relationships, Search, Partial Page Rendering, File Uploads.

Sr. Oracle EBS Technical Consultant

Confidential - Bothell, WA

Responsibilities:

• Extensively developed multiple Oracle Application Framework (OAF) pages from scratch for Product Information Management (PIM) Module.
• Developed Custom PL/SQL Packages, Procedures, Functions, Views, Indexes and Triggers as per the client requirements.
• Processed P2P cycle with Requisition, Purchase Order, Receipt and AP Invoice Functions.
• Setup/CreateD a new Payment Method, Payment Format and Payment Process Profile.
• Worked on Quote to Cash, procure to pay, Inventory process flows.
• Involved in Price lists, Items, Customers, Suppliers and Buyers setups
• Developed and customized reports using XML Publisher in OM, PO, BOM, AR, AP and INV.
• Business requirements gathering, mapping, gap identification and workarounds.
• Developed an Order Import API program by using PL/SQL Script to load data from legacy System to Oracle seeded tables.
• Worked extensively on Advance PL/SQL using Bulk Collect, Bulk Binds and Table Types.
• Modified the existing Interface Program to import Invoices to AR.
• Created various Materialized views in external CATS Systems as per the Business requirements.
• Developed Unix Shell Script to copy the custom table data from CATS system to ALC system and ALC system to CATS system.
• Extensively worked in Procure to Pay (P2P) cycle Functional testing, which includes Creating Purchase Orders, Creating Suppliers, Creating Buyers, and Creating Receipts.
• Developed an Exception Report for Customer API.
• Converted all standard AR invoice printing reports to XML Publisher reports by adding a customer logo to the reports.
• Developed an Interface in Purchasing to transfer all open PO information from 3rd party legacy system.
• Oracle Time & Labor (OTL) R12 module new design customization with Java and JSP.
• Took part in Development, Testing, Implementation and Documentation of ALC, AUDITS Projects and PO, AP, AR, OM Oracle EBS Modules.
• Mapped the Legacy system functionality to what was available in the Oracle applications for iProcurement, Intercompany, identified gaps and offered solutions.
• Supported end-users in Finance, Accounting, and Administration for the maintenance of Oracle ERP. Involved in resolving functional issues related to financial modules like Fed Admin, GL, Accounts Payables, iProcurement, and Receivable.
• Configured Oracle EBS-HR/Payroll. Set up Key and Descriptive flex fields, Organizations (Business Groups, GRE, HR etc.), Locations, Payment Methods, Consolidation Sets, Payrolls, Salary Basis, Elements, Element Links, Retro Pay, BEE, Absence Management and PTO Accrual Plans, Values sets, Employer and Employee Tax Rules, Assignment Sets, Fast formulas, Balances, Dimensions, User Functions, Global Values, Responsibilities, Request groups, Users etc.
• Retrofitted several customized objects such as Pages, People Code, Application Package, Application Engine and Retro fitting for ESS and MSS base Customized and Delivered Page.
• Restructured, realigned and developed Oracle HCM application structure, payroll elements and integration points between other third-party system.
• Defined strategy for data migration, security and control, HR / Payroll cutover plan.
• Involved in the implementation of Voucher Management Application using Oracle ADF to create Pages, Task Flows and Page Fragments
• AME and workflow customization on the module for iprocurement and AP.
• Developed a new form to show Details of PO's with its respective receipts and invoice information.
• Worked on various iProcurement catalogues and Defect Management, Defect resolution within specified Timeframes.
• Involved in the post production support for the Procure to Pay modules (Purchasing, Iprocurement, Payables).
• Designed Qtest Application for EBS Upgrade project to run the test cases and open defects for test case failures to track and complete the project on time.
• Worked on Oracle backend objects like: Database Triggers, Stored Procedures, Functions, Collections, records, views, materialized views and Packages using PL/SQL.
• Created specifications for custom reporting requirements, worked with technical team for development & testing of the custom reports (Order Management, Inventory, Advanced Pricing, Procurement).
• Participated in AGILE meetings like daily Status Reports, Defect Meetings, Grooming, Planning and Retro sessions.
• Customized Account Payables (AP) Reconciliation Reports like Accounts Payable Trial Balance report, Posted Invoice Register, Posted Payment Register, Unaccounted Transactions report and consolidation journal report in General Ledger (GL).

Oracle EBS consultant

Confidential - Boston, MA

Responsibilities:

• Worked Confidential Client location, involved in requirements gathering, Client discussions and Knowledge sharing. Involved in the Interface scope of work and acted as key point of contact to offshore development team.
• Involved in developing complex objects in accordance with technical development standards and best practices. Involved in design and development of Interfaces and conversions.
• Advance control management, partner management, sales, service, revenue management, business plan, contract management, order management, supply orchestral, supply chain collaborator, supply chain planning, quality management costing, cost accounting, financial supplier portal, inventory management, project.
• Financial reporting compliance, pricing management, pricing administration, order management, WMS, finance, SCM, WMS, purchase order, pricing, procurement to pay (P to P), OTC, engineering, IM, logistics
• Involved in reviewing team deliverables i.e. Technical Design documents, WMS, build artifacts, order managements, Unit Test plan and Installation guide, and suggest the best practice methods for a quality deliverable.
• Retrofitted XML Publisher and D2k Reports, AMEX P-Card Spend Details, MD050 AMEX P-Card Invoice Load Details and R2P Reports Requisition Reseller Detailed Report
• Involved in designing the prototype, preparing MD60 technical specification, Unit Test cases document, coding and Unit Testing. Collaborating with business, operations, process, design, engineering and other key stakeholders to prioritize project tasks, collect requirements, develop schedule and deliver quality products in an agile environment.
• Developed data feed interfaces from Oracle HRMS to Java based applications used by Cisco Sales consultants for Commission payments.
• Involved in Customizing Invoice Approval Workflow to embed multiple approval Hierarchy and WMS.
• Work with DBA team and cross functional application teams for application change control and system performance Issues. Involved in Quarterly releases code deployment and post live support.
• Customization of business-critical Forms and Reports. Solution Designing for all technical tasks.
• Unit testing and Integration testing. Provide support for business-critical application problems and issues. Involved in deployment activities, and supported go-live migrations.
• Identify and Purpose best practice methods, order management, Coding standards, Standard for documentations.
• Timely resolution of incidents based on the estimate and agreed date/ time and delivering Objects with High Quality. Code review for offshore and onsite developers.
• Created test scripts for every level of testing from unit testing stage to integration testing.

Business Analyst

Confidential

Responsibilities:

• Created requirement Specification (SRS) and FRD/FDS capturing Process Flows, Use Case Document, Use Case Diagrams, Activity Diagrams, and Sequence Diagrams and Performed Gap Analysis and recommended solutions for better practice.
• Participated in Inception phase of multiple projects to identify the scope, high-level estimation and sprint planning.
• Facilitated JAD sessions with management, development team, users and other stakeholders to refine functional requirements.
• Supported maintenance efforts, which helped me, develop client interfacing and management skills.
• Engage client to gather software requirements/business rules and ensure alignment with development teams.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
• Working with business to gather Print shop requirements for cancellation/Non-renewal documents and policy Documents.
• Resolved client issues on a regular basis and Obtained accounts payable information, researched, and reported findings back to client
• Customized page layouts for standard/custom objects and assigned record types.
• Document the data tables, gap analysis, and work flow diagrams for the XML schema interfaces.
• Assisted in initial project planning with the management along with project scope, budget, timelines and other parameters.
• Acted as a liaison between users, business stakeholders and technical team to keep them in sync with the project progress.
• Support for an inventory management value assessment to improve financial performance and the customer experience by reducing working capitals and supply chain costs and improving on shelf availability.
• Assisted in the development of project definitions, project scope, cost/benefit and risk analysis, work plans, daily and weekly progress reports, and presentations.
• Have uploaded data using MS Add Ins for additions, deletions and changes within the database tables
• Assisted project managers with the development of project schedules. Developed requirements and preliminary design for client applications. Performed analysis and design projects using a system.
• Assisted project team in preparing Functional Specification Document (FSD), developed non-functional requirements, and documented Business Requirements Document (BRD).
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Worked with developers and designers of BPM System to make sure development understands business.
• Using Shared Containers and creating reusable components for local and shared use in the ETL process.
• Knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).