Career Synopsis
Seasoned Oracle Fusion, EBS R** professional with several full-lifecycle, multi-million dollar implementation experiences over 18 years, including 3 years at Strategic Accounts division in Oracle Consulting.
Project Manager/Functional Consultant/Techno-Functional Consultant/Project Lead/Technical Consultant/Onsite-Offshore Coordinator for multiple Oracle EBS implementation at PepsiCo, Panasonic, State Street, JC Penney, Michaels, Ionics, Arbonne International and may other clients.
Proven success in influencing adaption to global standard processes; aligning process with technology, business goals with IT strategies; communicating effectively with people at different levels of hierarchy and expertise
Solution-focused, business-value-driven, self-motivated and quick-learning team player excellent at skills of requirements engineering, presentation, documentation, organization, interpersonal and time management
Experience in business flow accelerators, global blended delivery, project management, analysis, design, development, testing, and post go-live support.
Experience in process flows: Fusion Financials, Procure to Pay, Order to Cash, Advanced Pricing, iProcurement, Supply Chain Management, Logistics, Asset Management, Warehouse Management, Manufacturing & HRMS
Extensive on hand experience in Custom Interfaces, EDI and B2B solutions across modules.
Extensive on hand experience in development using Oracle Technologies including SQL, PL/SQL, Forms, Reports, Workflow,BI Publisher, XML DB, XML Gateway, Oracle Express (APEX), ADF, UNIX Scripting, OBIEE
Management of People, Processes and Performance to drive excellence; problem-solver and change-catalyst with exceptional skills in strategic action, implementation, scalability and sustainability
Skill Sets
Applications : Oracle E-Business Suite 11 / 11i / R12 / Fusion
Modules : GL, AP, AR, FA, PA, Advanced Collections, HRMS, INV, BOM, OM, Advanced Pricing,
Purchasing, Warehouse Management, Shipping, Enterprise Asset Management, Purchasing,
Process Manufacturing, Cash Management, Bill Presentment, Oracle Fusion Financial
Accounting Hub
Databases : Oracle 7/ 8i / 9i / 10g / 11g /12c
GUI : Oracle Forms 3.0/Developer 2000 /6i / 9i / 10g, J Developer, OAF, ADF
Languages : SQL, PL / SQL, Pro*C, UNIX Scripting
Tools : SQL Plus, Oracle Workflow, SQL Loader, TOAD, BI Publisher, XML DB, Oracle XML
Gateway, APEX(Oracle Express),Oracle Forms/Reports, Oracle e – Commerce
Gateway, OBIEE, Data Loader
Methodologies : Oracle Application Implementation Methodology, IBM Ascendant Oracle ERP Method
(RICEW)
Productivity : Excel, Word, Visio, PowerPoint, Microsoft Projects and Access
Awards
Oracle Corporation - Bravo Award for best employee (2003 – 2004)
Oracle Corporation - QOOL - Oracle Most Consistent performer Award (2004 – 2005)
Professional Experience
Oracle EBS Consultant at State Street (Contractor) from April 2016 to Present
State Street is a leading American worldwide financial holding company and I am placed there as a contracting Oracle EBS Consultant.
Responsibilities
Custom Billing Application implementation & Integration with Oracle Receivables.
Transforming business and stakeholder needs into practical requirements
AIM Documentation - MD50 & MD70
Accomplishments
Successful Implementation of a Custom Application (Fund Connect Billing & Institutional Billing) in Oracle R12 to process data from State Street online trading portals.
Interface Data from global on line trading Portals to Oracle EBS
Forms & BI Publisher reports to review interfaced data
Processes to apply cash & calculate revenue
Interface pricing data from external system to EBS
Generate Invoices & Statements for customers
Create Invoices & Cash Receipts in Oracle Receivables and apply cash
AIM Documentation - MD50
ABeam Consulting from April 2007 to 2016
ABeam Consulting is the leading Japanese consulting firm with world HQ in Tokyo and US division out of Irving, Texas.
Responsibilities
Project Manager
Functional Consultant
Techno – Functional consultant
Technical Consultant
Oracle R12 Implementation
Transforming business and stakeholder needs into practical requirements
11i to R12 upgrade
AIM Documentation - BR100,MD50, MD70 & MD120,CV40,CV60
Accomplishments
Participated in implementation of Oracle 11i AR & Advanced Collection modules for Canada and US at PepsiCo
Successful Implementation of Oracle R12 GL,AP,FA & PA modules for Canada and US at PepsiCo
Upgrade from Oracle 11i to R12 (AR & Advanced Collection) at PepsiCo
Implemented a fully automated custom solution for generating, distributing & archiving statements for PepsiCo’s 50000+ customers
Provided solution to capture and maintain PepsiCo’s customers with complex hierarchical structure which can have up to 5 levels of parent child relationship between those 50000 + customer accounts
Led a team to successful upgrade from 11i to R12 for Panasonic Electrical Works America
Designed and implemented a fully automated B2B process to interact with Panasonic’s trading partner (Kintetsu World Express) to interface PO, Receipts, Shipping Requests & Advices between them using XML Gateway
Successful integration of Oracle R12 with a 3rd party toll - IBM AR Collect a workflow driven collection tool as part of PepsiCo’s global rollout
Designed a custom solution to eliminate the financial overheads & risks involved in PepsiCo drivers collecting money on delivery at stores which helped PepsiCo to save millions of dollars
Defining Process Manufacturing Organizations, Item & Formula conversion from legacy system
Provided a solution to interface 1 Million lines of AR invoice lines worth 45 Million dollars with excellent performance on a daily basis which is highly critical for PepsiCo’s cash flow.
Designed and developed Inbound and Outbound EDI – 810, 812, 850,860 using Oracle Edi Gateway
Designed and developed a custom solution to generate Late Fee’s for overdue AR transactions which allows PepsiCo to generate revenue worth couple of millions of dollars annually. Where the late fee can be calculated & posted at Top Account or Child Account level.
Top Clients
PepsiCo – Pepsi Bottling Company
Panasonic Electrical Works America
IBM (Contractor) from June 2006 to April 2007
Employed to System Guru and was placed as a contractor for IBM Global.
Responsibilities
Techno – Functional consultant
Oracle R12 Implementation
Business Process Re-engineering
RICEW documentation
Post Production Support
Accomplishments
Successful Implementation of Oracle R11i
oDesigned and implemented a THROTTLE process where deliveries of new Orders will be grouped together with back orders for the same customers. So that Arbonne will be saving millions of dollars every year.
oImplementation of interfaces for Item, Item On Hand, Customers, Sales Orders, Delivery, Picking & Shipping from other system to Oracle R12
oDesign & development of a custom solution for reporting & handing of daily interface error’s
Top Clients
Arbonne International – Irvine, CA
Oracle Consulting from June 2003 to June 2006
OC’s Strategic Account division caters to the topmost clients of Oracle Corporation.
Responsibilities
On Site – Off Shore Coordinator
Techno – Functional consultant
Senior Technical Consultant
Associate Technical Consultant
Oracle R12/11i Implementation
Business Process Re-engineering
AIM documentation – BR100, MD50, MD70, MD120, CV40, CV60, CV70
Post Production Support
Accomplishments
Led a team to successfully migrate legacy data from General Binding Corporation which was merged with ACCO to form the new company ACCO Brands
Identified affected processes, interfaces and related data that will exist by migrating GBC’s legacy system (BPCS) onto ACCO’s Oracle system, and both define critical gaps and high level solutions available to resolve these gaps when implementation begins
Successfully implemented conversion/interfaces (Invoices, Purchase Orders, Receipts and Items) at Michaels handle the conversion of legacy data and also to interface data on a daily basis from the other systems to Oracle Application to handle the data in millions
Worked as On-Site Off-Shore coordinator
Designed and developed a single Match (2-way or 3-way) process at JCPenny for both Merchandise and Non-Merchandise items to be implemented in Oracle Application and it needs to be capable of meeting the goal of achieving close to 98% match in an automated manner.
Successfully designed and developed conversion/interface of data across application modules for multiple clients
As a Technical consultant I was involved directly with the client for designing, development, document and code reviews, testing, Installation, object release management and different acceptance stages
Top Clients
JCPenny Salt Lake City, UT
Michaels Stores Irving, TX
ACCO Brands Chicago, IL
McCarthy Construction St. Louis, MO
Buzzi – Unicem Bethlehem, PA
Ionics Boston, MA
UT Star Alameda, CA
1800Flowers Carle Place, NY
Mascon Global Limited from Mar 1998 to June 2003
Mascon Global Limited (MGL) is a global provider of IT and ITES services with offices and software development centres across USA, Mexico, Europe, and Asia
Responsibilities
Technical Consultant
Oracle 11i Implementation
Business Process Re-engineering
AIM documentation – BR100, MD50, MD70, MD120, CV40, CV60, CV70
Post Production Support
Accomplishments
Successful consolidation of data from two different 10.7 instances and upgrade to 11.5.6 at Telefonica Movie Star
Resolved severe performance issues at Group Saltillo which was due to a memory leakage bug in Forms & fragmentation in Shared Pool. The whole application was tuned to give excellent performance
Successfully implemented a custom ERP/MRP solution called IMAS – Integrated Manufacturing System (Owned by Mascon) for L&T and Bharath Electronics Limited
Participated in the stream lining of AVALON (ERP product) at Wockhardt Pharmaceuticals
Writing scripts to port data from the two different instances, consolidate, modify and port to 11.5.6
Developed scripts to generate new Account code combinations with validation of all segment values.
Developed Purchase Requisition Interface
Top Clients
Grupo Industrial Saltillo, Mexico
Telefonica Movie Star, Mexico
PSEG India, Chennai, India
L&T (Larson & Toubro), Chennai, India
Wockhardt Pharmaceuticals, Mumbai, India
Bharath Electronics Limited, Bangalore, India
Education
Masters in Computer Science, Technical University, Sofia, Bulgaria
Bachelors in Mathematics, MG University, Kerala, India