Oracle Senior Procurement Analyst Resume
SUMMARY:
- Over 15 years in ERP Design/Functional Analysis and Support experience in the areas of Oracle EBS 11i and R12 and three tier applications.
- Good working experience in Agile work environment
- Experience with Agile tools such as JIRA and Confluence
- Experience in extending/re - engineering, implementing self-service modules like iSupplier Portal, Iexpenses, iProcurement, isourcing, IReceivables related to procure to pay and Order to cash business process
- Experience with creating and executing automated test scripts using OATS, UFT and Defect Management
- Expertise in Functional configuration of Oracle Financials Modules - AP, AR, GL, FA, CM, PA
- Expertise in Defining future business processes around Order Management modules and Order to Cash, Procure to Pay process based on Oracle AIMS methodology
- Excellent Understanding of major OM workflows (generic, drop ship, back-to-back, IR-ISO, etc
- Expertise in functional analysis of order to cash, Procure To Pay, receipt to Issue business processes
- Identifying and testing application patches prior to promotion to production
- Extensive experience in relational data modeling, normalization, de-normalization and physical database design in Oracle database including Oracle 9i and 9iAS.
- Experience in Sarbanes - Oxley compliance
- Tech lead of the MIS team supporting financial analysis by implementing Oracle Discoverer 3.1/3.3/4.1. 5/4.1. x/9.0.4(10g)
- Migrated Discoverer3.1 Workbooks and reports to Discoverer 4.1 in apps mode along with MLS option
- Oracle Discoverer 10g, Oracle OBIEE -
- Oracle UPK 3.1, Noetix expert
- Expertise in EDI gateway - EDI 856, EDI 950
FUNCTIONAL/TECHNICAL SKILLS:
ERP’s: 11.5.10, R12 Procure to Pay Process - Oracle Procurement Suite, including self service modules -iProcurement, Iexpenses, isupplier portal, Purchasing Contracts, Service Oracle Financials 11.0.3/ 11.5.7/11.5.8 Modules-AP, AR, GL, CM, Sys Admin. Daily business Intelligence - Procurement dashboards, Financials dashboardsSelf Service Modules iProcurement, Iexpenses, isupport, isupplier, iReceivables, isourcing
CRM: Oracle Install Base, Oracle Sales, Oracle Incentive Compensation
Database: Oracle 7.3.
ORDBMS: Oracle 8.0/8.1.6/8.1.7 i/9ias, Repository 6i.
Development Tools: Developer 2000 (Forms 4.5/5.0/6.0/6 i), Toad, UPK3.1
CASE Tools: Oracle Designer 2000/6.06i, ERWIN, rational suite
BI Tools: Reports2.5/3.0/6I, OBIEE, including siebel Analytics, Discoverer 3.1/3.3/4.1. x/9i/10g, Oracle Financials Analyzer, Oracle Warehouse builder, Hyperion Essbase, Noetix tools, UPK 3.1, FSG reporting
Operating Systems: MS DOS, Windows 9x / NT / 2000,UNIX, Citrix
Web/App. Servers/Middle ware: Oracle 9iAS, Oracle web DB, Oracle Portal 9i, Apache HTTP, PDK, WEBSQL
Languages: Java J2EE,PL/SQL
WORK EXPERINCE:
Confidential
Oracle Senior Procurement AnalystSkill Domain: Oracle Accounts Receivables, Oracle Accounts Payable Oracle General Ledger, Order Management
Responsibilities:
- Troubleshooting of Oracle AR/AP monthly close process in R12
- Created Functional documents for Different AR Processes
- Provided various analysis, functional design, solutions in AP invoice approval process in
- Creating various Auditing Procedures for Procure to Pay and Order to Cash Process
- Creation of Test Scripts and Materials using UPK
- P2P process flow testing using OATS
- Created and Automated Testing using Jira
- Managing Client’s Prod and Test Defects
Confidential, NJ
Oracle Financials /Procurement Subject Matter Expert
Skill Domain: R12 Oracle Purchasing, Oracle Accounts Receivables, Oracle Accounts Payable Oracle General Ledger, Order Management
Responsibilities:
- Common Data Model setup involving Oracle P2P / Order to Cash / GL and SAP FI/CO
- Troubleshooting of Oracle AR/AP monthly close process in R12 Cloud
- Configuring Adjustments in Account Receivables as per Client Requirement
- Provided various analysis, functional design, solutions in AP invoice approval process in Cloud
- Creating various Auditing Procedures for Procure to Pay and Order to Cash Process
- Creation of Test Scripts and Materials using UPK
- P2P process flow testing using OATS
- Created and Automated Testing using OATS methodology
- Administered BI answers for out of the box OBIEE reports and dashboards
- Created and administered reports on Smartview
- Supporting Confidential clients with their SLA, p2p and Order to Cash issues
- Strong understanding of Sarbanes Oxley compliances
- Managing Client’s Prod and Test Defects
Confidential, Cambridge, MA
Oracle Financials Consultant
Skill Domain: R12 Purchasing, General Ledger, Oracle AR, P2P cycle, Iprocurement, Order Management and Inventory
Responsibilities:
- Troubleshooting monthly Period Closing in AR, AP and GL
- Managing Bugs and Defect Management after upgrade to 12.1.6 users on Oracle AP and Purchasing
- Creating User Materials
- Managing user setup Documents like BR100, RD50, RD60
- Supporting Managers with Oracle Data patch fix implementation
Confidential, NJ
Oracle Financials /Procurement Subject Matter Expert
Skill Domain: R12 Oracle Purchasing, Oracle Accounts Receivables, Oracle Accounts Payable, AME, Iprocurement, Order Management
Responsibilities:
- Configured AME setup for Payables Invoice approval
- Configured Iprocurement Account Generator workflow
- Troubleshooting of AR close process
- Configuring Adjustments in Account Receivables as per Client Requirement
- Administration of Catalogs and stores in Oracle Iprocurement and Purchasing
- Created Attributes, rules and conditions based on the Invoice approval requirement.
- Created BR 100 of AME setup and configuration
- Provided various analysis, functional design, solutions in AP invoice approval process
- Created and Administered OBIEE dashboards
- Created Dimension Data modelling for OBIEE .rpd files
- Administered BI answers for out of the box OBIEE reports and dashboards
Confidential, Atlanta
AME - AP/P2P implementor
Skill Domain: R12 Oracle Purchasing, Oracle Accounts Payable, AME
Responsibilities:
- Configured AME setup for Payables Invoice approval
- Configured Iprocurement Account Generator workflow
- Administration of Catalogs and stores in Oracle Iprocurement and Purchasing
- Created Attributes, rules and conditions based on the Invoice approval requirement.
- Created BR 100 of AME setup and configuration
- Provided various analysis, functional design, solutions in AP invoice approval process
- Created and Administered OBIEE dashboards
- Created Dimension Data modelling for OBIEE .rpd files
- Administered BI answers for out of the box OBIEE reports and dashboards
Confidential, NYC
Oracle Senior Procurement Analyst
Skill Domain: R12 Purchasing, GL, OM, Inventory,, Advanced Pricing, AP,AR, R12 iProcurement, isourcing, isupplier Portal, Daily Business Intelligence - iProcurement, Financials Intelligence, OBIEE (Siebel Analytics), Discoverer 10g, Hyperion Essbase, Dataload and Toad
Responsibilities:
- Creating high level specifications, Gap analysis for self service modules like IProcurement, isupplier.
- Created Discoverer 10 g EUL
- Lead the Conference Room Pilots for Order to Cash and Procure to Pay process and Documented setup of Organization structure, UOM conversions, item templates, item catalogs, item categories and item category sets, Transaction types/source, ATP rules, PO templates, Requisition templates
- Created Oracle Financials Reports using Discoverer 10g and OBIEE
- Configured AME setup for Purchasing and Payables.
- Implemented UPK and created Materials for Procure to Pay modules
- Provided various analysis, functional design, solutions in Oracle Procure to pay, Order to Cash, Receipt to issue.
- Fix issues with Oracle Payables and Purchasing monthly closing
- Troubleshooting tickets relating to GL,CA, AP, PO, Iprocurement, Isupplier (P2P) issues.
Confidential, Johnstown, PA
Oracle Senior Procurement Analyst
Skill Domain: R12 Purchasing, GL, OM, Inventory,, Advanced Pricing, AP,AR including Services, R12 Procurement Contracts R12 iProcurement, isourcing, isupplier Portal, Daily Business Intelligence - Procurement, Financials Intelligence, Discoverer 10.1.2 OBIEE (Siebel Analytics), Hyperion Essbase, UPK3.1, Toad
Responsibilities:
- Provided various analysis, functional design, solutions in Oracle Order to Cash, Receipt to issue,
- Creating high level specifications, Gap analysis for self service modules like IProcurement, isupplier.
- Requisition to Receipt - Indirect
- Requisition to Receipt - Direct
- Sourcing Requirements
- Customer Invoice to Cash
- Contract Templates.
- Click to Requisition
- Implemented Revenue, P & L Analytics using OBIEE (Siebel Analytics) reporting
- Helped them reach their goal to automate 75% of their sourcing and Procurement Process
- Creating high level specifications - MD 50’s, MD 70, Gap analysis for self service modules like IProcurement, Isupplier.
- Implemented iProcurement
- Trained users on Discoverer Desktop, Discoverer Viewer
- Created Supply chain Discoverer Reports
- Involved in forms persolization
- Configured AME setup for Purchasing and Payables.
- Lead the Conference Room Pilots for Order to Cash and Procure to Pay process and Documented setup of Organization structure, UOM conversions, item templates, item catalogs, item categories and item category sets, Transaction types/source, ATP rules
- Involved in Supplier Collaboration Using R12 Oracle Sourcing, Isupplier Portal
- Automated the Procurement Process.
- Trained users and Managers on using sourcing Rules, Auto invoice
- Trouble shooting of their P2P and Order to Cash business process
- Created Materials using Oracle UPK 3.1
- Trained users on Discoverer Admin 10G, Plus and Viewer.
- Developed procurement reports using Discoverer 10g
- Created Discoverer EUL for Dev and Prod instances to run on Oracle Apps
- Fine tuned Existing Discoverer EUL and the Business areas
Confidential, Basking ridge, NJ
Oracle Procurement
Skill Domain: R12 Purchasing, Om, Inventory, WIP, BOM, Advanced Pricing, AP,AR, Toad including Services, R12 Procurement Contracts R12 iProcurement, isourcing, isupplier Portal, Daily Business Intelligence - Procurement, Financials Intelligence, UPK3.1, Discoverer, OBIEE dashboards, Siebel Answers
Responsibilities:
- Provided analysis, functional design, solutions in Oracle Order to Cash, Receipt to issue, Procure to pay Process
- Involved in forms persolization
- Creating high level specifications, Gap analysis for self service modules like IProcurement, Isupplier.
- Lead the Conference Room Pilots for Order to Cash and Procure to Pay process and Documented setup of Organization structure, UOM conversions, item templates, item catalogs, item categories and item category sets, Transaction types/source, ATP rules
- Created MD50 and MD 70 technical and Functional documentation
Confidential, Boston MA
Oracle Procure to Pay Implementer
Skill Domain: R12 Purchasing core including Services, R12 Procurement Contracts R12 iProcurement, isupplier Portal, isourcing Daily Business Intelligence - Procurement, Financials Intelligence, Discoverer, UPK3.1, AP, AR, GL
Responsibilities:
- Super users on R12 IProcurement, R12 Iexpenses, R12 supplier Portal and R12 Procurement Contracts and isourcing
- Created Data flow and data modeling using IBM Rational Rose
- Integrated Lawson with Oracle Financials R12
- Created KPI’s for the First Church used and mapped it with Oracle DBI
- Administered DBI for Financials
- Created Implementation Considerations for Payables Management and Status Pages
- Trained users on Discoverer Admin 10G, Plus and Viewer, Toad
- Developed Procurement reports using Discoverer 10g
- Created UAT and Test cases for in-dept Unit Testing of Self service modules
- Created materials for R12 Procurement for the organization using Oracle UPK 3.1
- Full life cycle of R12 Procure to Pay implementation
- Documented RD 50, BR 100, MD 50, MD 70 for Procurement
- Implemented Daily Business Intelligence for Financials Intelligence Dashboards - Profit and Loss and Profit and Loss by Manager Dashboards, Procurement Dashboards and Payables Management dashboard.
Confidential, IL
Oracle Business Analyst Lead
Skill Domain: Purchasing, iProcurement, isupplier Portal, isourcing, Daily Business Intelligence - Procurement, Financials Intelligence
Responsibilities:
- Support the Implementation of Oracle OM, Purchasing, iProcurement, isupplier portal and created business Process documentation on the basis of Oracle AIMS methodology( MD 50, MD 70
- Performance Tuning and Migration of Discoverer 10g Reports
- Architected Specifications for Discoverer 10g reports
- Creating high level specifications, Gap analysis for self service modules like IProcurement, Isupplier and Isourcing
- Implemented Daily Business Intelligence for Order To Cash, Procure to Pay modules OM, Inventory and Procurement
- Created and Tested Functional scripts for Oracle Workflows
Confidential, Seattle, WA
Oracle Apps11i Lead
Skill Domain: Oracle Order Management, Isupplier, Purchasing, iProcurement, Oracle, Daily Business Intelligence - Discoverer Lead
Responsibilities:
- Documented setup of Organization structure, UOM conversions, item templates, item catalogs, item categories and item category sets, Transaction types/source, ATP rules
- Provided analysis, functional design, solutions, and user acceptance testing and in Oracle Order To Cash, Receipt to issue, Procure to pay Process
- Developed User friendly Order Management Reports using Oracle Discoverer 10g.
- Migrated Discoverer 4.1.6 Business Area’s into Discoverer 10g
- Enabled supplier punch outs using Oracle Exchange in Oracle iProcurement 11i
- Involved in the set up of Purchasing option, Receiving option, Position hierarchies, Approval Hierarchies, control groups, Approved Suppliers List, line types, transaction reasons, standard notes, Auto sourcing rules in Oracle Purchasing 11i
- Involved in configuration of Oracle isourcing
- Involved in Set up of Order cycles, order types, holds, payment terms, navigation ps Holds, Shipping information, Credit check rules, Standard value rule sets, payment terms and Discount, Customer profiles/classes.
- Support the Implementation of Oracle iStore and created business Process documentation on the basis of Oracle AIMS methodology
- Implemented Daily Business Intelligence for Order To Cash modules: OM, Inventory and Procurement.
- Conducted knowledge transfer sessions and assisted client with compilation of materials on Order Management Noetix Views
- Opening Tars and Working closely with Oracle support for Various OM issues
- Performance tuning of their Present Discoverer Reports
- Implemented Globalization and Multi-Org Architecture pertaining to Inventory, Order Management
- Facilitated development and testing of order Management 11.5.10 customizations of Noetix Views for all major OM workflows (generic, drop ship, back-to-back, IR-ISO)
Confidential, NJ
Oracle Apps11i LeadSkill Domain: Oracle Order Management, Procurement 11.5.10 Functional Implementer (Lead)
Responsibilities:
- Led the Implementation of Oracle Order Management 11.5.10, Purchasing, iProcurement 11.5.10
- Designed interface/conversion mapping, pre production testing, and related documentation and deliverables based on Oracle AIMs methodology
- Designed Replenishment Interface in Oracle Inventory based on data sent from warehouse in flat file.
- Provided analysis, functional design, solutions, and user acceptance testing and in Oracle Order To Cash Process
- Created Functional design of customized Oracle Forms
- Involved in configuration of Oracle isourcing
- Implemented DBI for Order Management, Procurement
- Led the integration testing efforts for OM that included testing of all major OM workflows (generic, drop ship, back-to-back, IR-ISO, etc
- Opening Tars and Working closely with Oracle support
- Performance tuning of their Present Discoverer 10g Reports
Confidential
Oracle Apps 11i Business Analyst / Functional Lead
Skill Domain: Oracle 8.1.7, 9iAS, 10g Oracle Portal 3.1 Forms 6i/10g, Oracle Reports 6i/10g, Toad, Discoverer 3.1/4.1.5/4.1.6 /5 i/9.0.4 (10g), Noetix views
Responsibilities:
- Functional Lead for Implementing Oracle Purchasing 11.5.10
- Performed fit/gap analysis, pre-production business testing, conference room pilot support, interface/conversion mapping, and related documentation/deliverables
- Architecting of complex Oracle Discoverer 4i and Oracle Reports 6i reports for CRM and Order To Cash Modules: Oracle iStore, Sales, Contracts, Order Management 11i, Oracle Inventory, isourcing and Purchasing
- Resolving functional and technical issues in iStore, Install base, Order Management, PO, CA.
- Implemented DBI for Order Management 11.5.10
- Installed Oracle Discoverer 10 g to map with Oracle Apps 11i in Apps Mode
- Responsible for Study, Analysis, Design, Development/Customization and Testing/debugging of the reports
- Customized Invoice print Selected Invoices by changing layout and printing with additional columns using Oracle Reports 9i.
- Developed user Friendly Procurement Reports Using Oracle Discoverer 4.1.6.
- Created EUL’S in Oracle Discoverer 4.1.6 for Various Departments like Planning, Purchasing, Projects, and Quotation so that it was easy to identify Reports for the Particular Departments.
- Knowledge Transfer on using the Oracle Discoverer 4.1.6 Desktop edition
- Opening Tars and Working closely with Oracle support
Confidential
Oracle apps 11i Techno Functional and Oracle Discoverer 4.1.6 Administrator (Tech Lead)
Skill Domain: Oracle 8.1.7, 9iAS, Forms 6i, Oracle Reports 6i, Toad, Discoverer 3.1/4.1.5/4.1.6
Responsibilities:
- Responsible for Study, Analysis, Design, Development/Customization and Testing of the reports.
- Reporting on their Customized Oracle Discoverer 4i Business Areas.
- Created Reports on GL to give reports relating to GL SET OF BOOKS using Oracle Reports 6i and Oracle Discoverer 10g and Noetix views
- Provided analysis, design, installation, and rollout of Oracle 11i General Ledger, Accounts Payable, and Purchasing
- Implemented System Administration including Responsibilities, Functional Security, Flex fields Security Rules, Descriptive Flex fields, Document Sequencing and simple Alerts
- Expertise with AD utilities (E.g. ad patch, ad clone, adadmin, adaimgr, adctrl etc.)
- Expertise in Patch testing and Patch application
- Responsible for Technical writing the whole Applications
- Used rational rose for Data modeling
- Responsible for migrating data from Access to Oracle using pre defined PL/SQL
- Developing system Triggers and stored Procedures to implement complex business rules.
- Developed user Friendly Procurement Reports Using Oracle Discoverer 4.1.6. Made a Business Area for the Procurement Officer using 17 Tables
- Created EULS in Oracle Discoverer 4.1.6 for Various Departments like Planning, Purchasing, Projects, and Quotation so that it was easy to identify Reports for the Particular Departments.
- Knowledge Transfer on using the Oracle Discoverer 4.1.6 Desktop edition To Managers of the Various Departments.
- Created Functional Scripts for Oracle Financial Modules like AP,AR,GL