SUMMARY:

• 12+ years of progressive experience in Oracle Applications such as Supply Chain, Financials, Procurement, Inventory and Order Management. Worked as a Functional Consultant and Sr. Business Analyst.
• SME in Oracle eBS, Retek, Material and Data Management with experience in full SDLC and Support.
• Specialized resource in SCM Suite including Inventory Management, Order Fulfillment and Orchestration.
• Excellent knowledge in Fusion Procurement and underwent training in Fusion Core HCM.
• Experience in Fit/ Gap Analysis, Design, Development, Implementation, Integration Testing, Tech Support on Oracle eBS applications including such versions as 10.7SC, 11.0.3, 11.5.5, 11.5.10, R12, 12.1.3.
• Experience in Technical Upgrade project from 11i to R12 including remediation of CEMLI objects.
• Involved in 7 full life cycle implementation, 3 process re - engineering solutions on Oracle platform
• Involved in implementation of system integrations between legacy systems and Oracle eBS in sprints.
• End to End integration of Order flow process from Oracle to PKMS including custom flows.
• Custom solution implementation for monitoring and handling of interface errors, resolution and corrections.
• Worked on integration of Oracle Projects, Accounting distributions, Time and Labor.
• Experience in reports, interfaces, conversions and extensions (RICE) integrated into different modules.
• Industry experience in Telecom, Manufacturing, Engineering, Healthcare, Retail and Public sector domain.
• Very well experienced in multi-org, multi-currency, multi operating units, intercompany transfers.
• Engaged with business users to perform CRP of solutions, POC and process flow modelling in Oracle eBS.
• Extensive experience in analysis, design, development, integration and implementation of custom solutions.
• Very sound knowledge in development using RAD concepts and Agile methodology. Good experience in post-implementation technical support and red-hat period systems support including patch application.
• Experience raising SR for workaround solutions or one off solutions from Oracle and manage those requests.
• Excellent documentation skills that goes into building solutions, including BR100, MD050, CV040, MD070.
• Excellent communication, analytical, interpersonal, presentation and writing skills including training users.
• Extensive documentation skills like writing technical and functional specifications for multitude of solutions.
• Excellent application troubleshooting skills coupled with extensive technical knowledge. Have developed a few solutions using various technologies like SQL, BI Publisher and tools like Kintana, SVN and SharePoint.
• Proactively engage with off-shore teams to monitor and produce deliverables and facilitating corrective measures arising out of slippages. Provided some level of support in estimation of work involved.
• Received excellent feedback, honorable mention and recommendations on work done from different clients.
• Active associate member Confidential professional organizations like OAUG, APICS and PMI.

SKILL SET:

• Client facing
• Excellent communication
• Requirements gathering
• Conference Room Pilot
• Setups and configuration
• Solution prototyping
• Mentoring and coaching
• SOP and POC
• Gap Analysis
• User training
• Off-shore team
• Documentation

PROFESSIONAL EXPERIENCE:

Confidential, WI

Environment: Oracle e-biz suite modules - EAM, PO, AP, INV, AME.

Responsibilities:

• Requirements gathering and analysis of business functions, documented SOP and ‘to-be’ processes related to asset maintenance and management. Designed template screens for mass allocation of equipment to a project.
• Worked with users to define and schedule preventive maintenance of assets based on run time parameters extracted from external sources. Configured new assets, asset groups, categories and asset meters using EAM responsibility. Utilized Maintenance Super User responsibility to correct equipment usage data set.
• Designed and developed solution for import of legacy supplier invoices into Payables and EDI transactions.
• Set up approval rules for POs and auto sourcing rules for items required for maintenance of critical equipment.
• Configure meters to assets for preventive maintenance work orders. Created custom process for PO approvals.

Confidential, MA

Environment: Oracle e-biz suite modules - OM, WSH, PO and AR modules.

Responsibilities:

• Performed complete SDLC on integration of 3PL systems to Oracle R12 including reports and dashboards.
• Elicited requirements from business users and analyzed process flows between Oracle and PKMS.
• Setup of warehouse transaction activities lookups and integrate R12 with PKMS for inventory transactions and put-away. Solution design and implementation of complete O2C cycle including shipments and ASN by EDI.
• Created process documentation on customizations, analytical reports and facilitated user training sessions. Provided technical support to update specifications documents pertaining to custom business processes.
• Configured sourcing rules and maintained ASL from Lawson to Oracle Confidential . Assisted in testing the solution.
• Identified process pain points, supported re-engineering and implemented improvements to eliminate inefficiencies. Helped support end-to-end process flow and testing of re-engineered processes.

Confidential, Dallas, TX

Environment: Oracle e-biz suite modules - OM, INV, WSH, AR, AP and P2P modules.

Responsibilities:

• Gathered requirements and analyzed process flows between Oracle and PKMS. Transformed the requirements to functional specification for vendor managed inventory which improved order fulfillment by 25%.
• Provided POC for different format definitions and customer grouping for ASN. Managed complete life cycle implementation of custom solution for ASN generation to customers from planning, execution and handover.
• Conducted CRP sessions and GAP analysis for import of POs, supplier and sites with attributes. Implemented enhancements for pick ticket slips with barcoding and logics for price adjustments. Customized interface applications between OM and PKMS. Developed custom UI to correct interfaced shipment data from PKMS.
• Designed components for customer import from legacy system Shiva/ CIM into Confidential and personalization of collections workbench. Defined custom analytical reports and dashboards for regional sales, aging invoices.
• Designed custom solution and specifications for workflow events and remittance advice to vendors. Facilitated remediation of custom objects for Vertex Tax Engine.
• Implemented R12 Technical Upgrade and supported remediation of 2500+ custom objects. Allocating and overseeing roles and duties of off shore team members. Customization on DRP and MRP processes.

Confidential, Richardson, TX

Environment : Oracle e-biz suite modules - AR, INV, SLA and GL modules.

Responsibilities:

• Solicited and gathered requirements from users to design a custom application for reconciliation of inventory transactions and posting to GL through SLA. Designed custom application to scrub and mask sensitive customer data. Customization and importing of service contracts and designed custom templates.

Confidential, Plano, TX

Environment : Oracle e-biz suite modules - INV, OM, P2P, BOM, AR, FA & PA modules, TelcoBuy, CATS, AME.

Responsibilities:

• As lead consultant, was responsible for prototyping custom application and implementation of Direct Fulfillment project that integrated the TPA and CATS transactions with Oracle ERP modules INV, OM, PO, FA, PA and AR. Managed a team of offshore consultants to implement the application per schedule.
• Designed and analyzed custom interfaces and business data flow between Oracle 11i (11.5.10) and other third party tools like Telcordia and VIPS/ VMI and mirrored transactions into CATS and Red Prairie. Created business and analytical reports to verify data consistency and integrity between legacy systems.
• Design and specifications of custom application for error handling of order conversions in OM and interface to downstream systems like OTIVA. Configured auto sourcing rules and supplier rankings for item procurement and distribution. Customization of receiving process and integration with inbound ASNs via EDI.
• Gathered and analyzed BR to design and implement an application to do away with use-up items and substituted for items within the EPL system. The solution helped reduce the inventory of use-up items.
• Implementation of applications using RUP concepts and tools like SharePoint, ClearCase and ClearQuest.

Confidential, Plano, TX

Environment : Oracle e-biz suite modules - PA, AP, AR, OTL, HRMS and UA Solutions.

Responsibilities:

• Gathered requirements, analyzed process flows and SOP to design custom application for diversity spending categorized as WBE, DVBE and MBE and reporting against total revenue. Implemented customization for business process logics/ restrictions in Element Entries, List Employees by Element, and Persons forms.
• PO, Invoice importing from UA system into Oracle and custom reporting for Oracle Time and Labor. Importing WON orders to PA and solution design for mapping OTL costs to project expenses in Costing. Mapping of legacy transactions into project costs, expenses, burden costs and miscellaneous transactions.

Confidential, Dallas, TX

Environment: Oracle e-biz suite modules - PO, OM, WSH, INV and BOM modules.

Responsibilities:

• Reviewed existing systems and completed functional analysis of legacy system for data mapping between SAM and HEC to Oracle 11i modules. Gathered requirements, determined the gaps and provided enhancements to the interfaces in consultation with business users.
• Implemented custom application and enhancements to Shipping Execution on Oracle 11i (11.5.9 and 11.5.10) platform. Customized personalization of applications and facilitated Enterprise Application Integration.
• Trained end users and helped test the functionality implemented. Participated in integration testing of shipping execution end-to-end and issues resolution. Mentored a team of 4 developers to drive and complete the project.

Confidential, Dallas, TX

Environment : Oracle e-biz suite modules - FA, AP, PA, INV, OM, PO and BOM modules.

Responsibilities:

• As lead consultant, I was responsible for implementation of Network Error Handling application and integration between systems. Managed a team of 6 consultants to implement the application per schedule.
• Analyzed the custom interfaces and business data flow between Oracle 11i (11.5.9) and other third party CATS, TelcoBuy, Red Prairie and EPL tools. Designed, developed custom solution for sourcing optimization.
• Suggested process improvements to minimize errors occurring out of the custom interface between applications. Provided a means to identify and synchronize assets between SCM organizations.

Confidential, Irvine, CA

Environment: Oracle e-biz suite modules - AP, GL and Retek ( Confidential and RPM).

Responsibilities:

• Interfaced with end users to plan the flow process.
• Functional design and setup of warehouse locator system for receiving and picking of goods and prepacks that reduced the turnaround time for dispatch by 35%.
• Provided batch support and enhanced the markdown pricing user interfaces for Confidential .
• Redesigned the logic for deal promotions to effectively download the price changes to stores per style/ SKU combination.
• Development for invoice import from Retek/ Stock Ledger to AP/ GL modules of Oracle 11i. Defined style analysis reports.

Confidential, Irving, TX

Environment: Oracle e-biz suite modules - GL and Retek

Responsibilities:

• Reviewed existing business processes and gathered requirements for generating GAP analysis. Analysis of sub-applications and modules requiring changes and rewriting for the HYBRID project to enhance Supply Chain Management.
• Designed and developed custom interfaces for warehouse transfers and direct transfers from DCs within Retek Confidential . Designed look ups and interfaces for currency conversion. Developed batch processes to map and load recollections, stock ledger and warehouse-store revenue data to GL interface for accounting.
• Developed interfaces for stock allocations, shipping schedules and SKU conversions.

Confidential, MI

Responsibilities:

• Actively participated with a highly spirited team of child support specialists to help achieve Federal Certification by the state and developed the web-enabled child support enforcement system.
• Defined journal entries and interfaced GL module of Treasury with CSES for distribution and disbursement accounting. Defined and generated specific reports for interstate and intrastate collections, disbursements.
• Business reports generation facilitated improved collections. Also developed applications for receipts handling and EFT transactions through congruent screens. Provided production support and migrate Forms to 9i.

Confidential, Santa Clara, CA

Responsibilities:

• Created data mapping between existing 10.7SC and 11i for the Financials module up gradation.
• Defined invoice/ journal entries, recurring journal, journal approval and reversal processes. Also defined auto invoicing, lockbox and set up dunning letter generation. Merged different inactive sites for many customers.
• Designed and developed a business model for supply chain (SCM) and unified customer (UCV). Facilitated JAD sessions to derive the approach to prototype the application. Created a process for standardization of Project Management, change controls and procedures for software development.

Confidential, San Jose, CA

Responsibilities:

• Interacted with end-users to create user requirements and analysis for automation of data matching and mapping. Designed and developed a CRM application for global hierarchy of customers.
• Designed required UI and a search and match (ESP) engine for current and potential customers. This facilitated the customer merge process and improved user productivity by 20%.
• Designed web reports for the productivity of automated ESP matching process and facilitate decision support for business managers. Processing of data also involved mapping of sites to Dun & Bradstreet db.
• Designed and developed an application for definition of Global accounts to each of the account manager and his team and assignment of sales credit to individual teams. Developed UI to define Global Accounts as defined by business rules and create a global hierarchy. Created reports for field performance and decision support for the management.