SUMMARY

• Senior Oracle ERP Analyst with 12 years of cross functional IT experience
• Expertise in Oracle Supply Chain Management (SCM), Order to Cash (OTC), Procure to Pay (P2P) and Quote to Cash (QTC) cycles
• Expertise in Reports, Interfaces, Conversions and Extensions (RICE components)
• Expertise in leading Design, Implementation and Customization of Oracle EBS (R12 and 11i) and functional knowledge of integration of EBS with SOA and webMethods utilizing an event - based architecture
• Experience in successful implementation of Six Sigma process improvements using DMAIC methodologies.
• Expertise in working with business users from different cross tracks and performing Business Process Analysis, preparing As-Is and To-Be process flows, Business Process Mapping, Fit-Gap Analysis, defining Use Cases, preparation of Functional and Technical Design Documents MD50 and BR100, Data Mapping and Defect Management
• Experience working in both Waterfall and Agile SCRUM development models
• Experience working and coordinating in an Onsite-Offshore model.
• Experience in managing and delivering multiple, parallel initiatives
• Highly motivated individual with strong interpersonal, analytical and trouble-shooting skills.
• Recognized as one of the key players in current role with extensive knowledge of business architecture

TECHNICAL SKILLS

• OM, WSH, INV, BOM, QP, SC, IB, TCA, AR, AP, GL, HRMS, AOL, FND, PDH, CDH, OAF, Discoverer, Reports, Workflow, JDeveloper
• Oracle 9i, 10g, 12c
• SQL, PLSQL, Java, XML, C, C++
• JIRA Cloud, Git Bit Bucket, Flex Deploy, Service Now, Quality Center, Kintana, PVCS, ClearCase
• Windows, UNIX

PROFESSIONAL EXPERIENCE

Senior Oracle EBS Analyst

Confidential

Responsibilities:

• Expertise in leading functional and technical solutions across Oracle ERP R12 Supply Chain Management (SCM) modules.
• Functional expertise in integrating Oracle EBS with middleware systems like SOA and webMethods
• Worked on multiple projects in Order-to-Cash (OTC), Procure-to-Pay (P2P) cycles and managed several mid-sized initiatives while reporting to the senior delivery manager in an Agile SCRUM development model.
• Experience in Order Management ( OM), Inventory ( INV), Bills of Material ( BOM), Work in Process ( WIP), Warehouse Management System ( WMS), Purchasing ( PO), Shipping ( WSH), Accounts Receivables ( AR), Accounts Payables ( AP), Advanced Pricing ( QP), Costing ( CST) and EDI
• Experience defining systems strategy, gathering and documenting business requirements, performing fit-gap analysis, as-is and to- be business process designs, configurations, testing, authoring MD50 and BR100, user training, troubleshooting and issue resolution
• Experience working with Consigned and Vendor Managed Inventory (VMI) models
• Experience working with items under lot and serial control
• Experience presenting functional solutions to senior IT and Business stakeholders
• Experience working in a collaborative environment with internal IT teams across Arrow and with external vendors
• Experience working with Git Bit Bucket version control system
• Defect management using ServiceNow, JIRA Cloud, HP Quality Center and FlexDeploy
• Part of the team responsible for Arrow’s successful transition from legacy mainframe system to Oracle R12
• Lead Change Management and tracking of deliverables for the Global Oracle ERP and EDI Integration teams.
• Experience generating EDI 830,830R,844,846,849,850,855,856,860,865,867,870 reports from Oracle
• Expertise in designing and solutioning dashboards to capture various metrics for higher level IT and Business executives.
• Strong presentation and communication skills.
• Authored multiple functional and technical design documents, test plans and go-live plans
• Worked closely with cross functional teams both here in the US and in offshore locations (EMEA, Asia Pacific) to implement various IT projects to support business functionality

IT Analyst

Confidential, California

Responsibilities:

• Worked in Cisco’s New Product Introduction (NPI) Team
• Involved in development and support of Oracle EBS (R12 and 11i) with focus on Supply Chain Management (SCM) modules like Order Management (OM), Inventory (INV), Bills of Material (BOM), Advanced Pricing (QP), TCA, Service Contracts (SC), Install Base(IB), Accounts Receivables (AR), Accounts Payables (AP)
• Involved in design and development of custom service pricing logic to support Cisco’s portfolio of Subscription products (Term Licensing).
• Improved the performance of the BOM explosion program by re-writing and tuning queries
• Migrated service pricing information from 11i to R12.
• Involved in supporting custom Contract Management system based on Oracle Service Contracts and Install Base modules.
• Personalized an OAF page and developed new page based on base tables as well as custom tables to support custom service pricing functionality.
• Implemented Six Sigma process improvements using DMAIC methodologies in support of Offer Setup Optimization project.
• Authored multiple functional and technical specification documents like MD50, MD70 based on requirements listed out in BRDs
• Worked with and managed multiple teams of analysts and developers in an onsite/offshore model
• Worked with internal and external SOX auditors to develop reports related to customers, payment terms, OM transaction types, credit profiles, and user accounts.
• Defect Management using HP Quality Center

Business System Analyst

Confidential, California

Responsibilities:

• Implemented and supported Oracle Quote to Cash process.
• Involved in development and support of multiple Oracle EBS (11i) modules like Order Management (OM), Inventory (INV), Bills of Material (BOM), Advanced Pricing (QP), TCA, Service Contracts (SC), Install Base(IB), Accounts Receivables (AR), Accounts Payables (AP), HRMS, iExpense and Siebel 7.0
• Supported Quarter End processes.
• Developed custom reports using Oracle Discoverer in OM, INV, AR, SC, IB, and HRMS modules.
• Authored documents like MD50, MD70, BR100
• Developed custom code to perform OE validations and book sales order by invoking Oracle API.
• Developed custom conversion code to re-assign categories for some inventory items through Item Category Assignment Open Interface program.
• Developed an interface to download currency exchange rates from Bloomberg using shell script, apply a daily conversion rate and load it into the GL DAILY RATES table.
• Created an alert to monitor the Service Fulfillment Manager Queue.
• Monitored the table CSI TXN ERRORS for failed instances and processes the same by submitting the program Resubmit Interface Process.
• As part of iExpense Project, did setups like defining Expenditure Types, Expense Report Templates, Pay Groups, and setting up Signing Limits and Card Programs etc.

IT Developer

Confidential

Responsibilities:

• Implemented and supported Procure to Pay process.
• Involved in development and support of Oracle EBS (11i) Supply Chain Management (SCM)modules like Order Management (OM), Inventory (INV), Bills of Material (BOM), Purchasing (PO), Shipping (WSH), Accounts Payable (AP)
• Developed a custom package to book sales orders using Oracle API.
• Developed a custom package to generate Purchase Releases out of Sales Orders against a Blanket Purchase Agreement.
• Developed a custom package to generate an outbound PO.
• Developed scripts to validate and load inbound ASN files into custom tables.
• Developed a custom package to create locators for items based on serial numbers.
• Developed a custom package to perform Sub-Inventory Transfer, Auto Create Delivery and Ship Confirm of items.
• Developed program to import AP invoices through Payables Open Interface Import program.
• Developed custom code to validate imported AP Invoices against Blanket Purchase Agreements by invoking the Invoice Validation program.
• Developed workflow functions, attributes and notifications and made packages eligible for the workflow process by invoking standard workflow APIs
• Customized the order lines workflow as per business requirement