Oracle Management

TONY ESGUERRA

ORACLE APPS FINANCIALS FUNCTIONAL

HOME ADDRESS (TEMPORARILY) 42931 HOMEWOOD STREET

FREMONT, CALIFORNIA 94538

HOME PHONE: 510-***-****

CELL PHONE: 209-***-****

SUMMARY

Seeking a Functional consultant position for Oracle E-Business Suite environment in a growing company where I can be a part of positive change using my Functional Purchasing and Project Management Skills.

SPECIFIC EXPERTISE

• Work experience as Functional resource for core Oracle Financials modules i.e., Purchase Order, General Ledger, Accounts Payables, Account Receivables, Order Management, Inventory Management.

• Expertise in Procure to Pay Cycle. I Procurement Punch-out setup with Cxml transmission.

• Oracle Applications implementations including upgrades from 10.6, 10.7, 11i (11.5.8), 11i (11.5.10.2) to R12.

• Acquired responsibility for Sysadmin in order to manage Oracle Applications activities like managing concurrent managers, application user setup, defining responsibilities, value sets, Flexfields, registering menus, concurrent programs, providing support to apps user for any functional issues.

• Experience in all phases of full life-cycle Oracle Financials implementation i.e. Requirements Definition, GAP Analysis, Application Configuration, System Testing, and User Training.

• Experience in using Oracle AIM of project implementation methodologies particularly Business Requirements Document (MD.050), TO-BE Document (BP.080), Business Requirement Mapping Document (BR.030) and Application Setup Documents (BR.100) for AP, AR and GL modules.

• Documentation skills as per AIM methodologies.

• Self-motivated with excellent communication skills.

• Also played key role in P2P area with specialized management skills

TECHNICAL SKILLS

ERP: Oracle Applications 11i and R12

Functional Modules: PO, iProc, iExp, PA, AR, AP, GL, FA, INV, OM, Workflow etc…

Database: 8i/9i/10g/11g

Documentation: AIM Methodology

Others: MS Office, MS Project, Quick Books

PROFESSIONAL EXPERIENCE

• Work starting as Contract officer to understand their business requirements then was to document after going through procurement.

• Worked in Peoplesoft 8, for planned implementation to Peoplesoft 9 for the Contract and Procurement department.

City of North Las Vegas, North Las Vegas, NV

Designation: Assistant Purchasing Manager

(Primary Job: Oracle Functional/Business Analysis) October 2006 to December 2011

Worked as an Oracle Functional/Business Analyst to upgrade Oracle Applications from version 11i (11.5.10) to R12 (ReL. 12 ready Patching)

Roles and Responsibilities (Functional and Business Front)

• Worked as an Oracle Applications analyst– PO, PA, AP, AR and GL, iProc., iExp

• Include implementation and support of Oracle e-Business suite.

• Worked with Business users to gather requirements.

• Implementation of setups and configurations of Oracle Financials PO, PA, AR, AP, GL.

• Provided first level support for the Financial Applications, interacting daily with the end users. Duties include, but not limited to: User/responsibility maintenance.

• Provided solutions to the defects.

• Created solution document to the defects.

• Ensured that any Oracle integration into other systems meets functional requirements, system compliance, interface specifications and is in direct correlation with overall IT strategy.

• Analyzed gaps between taxes in 11.5.10 and 12 and provided recommendations on E-Business Tax Setup.

• Configured E-Business Tax-Tax ware. Setting up of Tax Users-responsibilities, Tax Regimes, Taxes, tax Jurisdictions, Tax Registrations and Tax Exemptions.

• Defined Tax exemption reasons to monitor customer applications for exemptions.

• Determined factor classes and Tax condition values. Setup Regime determination Set.

• Configured the tax condition sets to group together the tax conditions that constitute a tax rule.

• Worked on BR100 (Business Requirement Document), MD050 (Functional design Document), AS-IS Document, BR.080 (To-Be Document), BR.030 (Business Requirements Mapping Document)

• Configuration of withholding taxes in Accounts Payables options to withhold taxes from employee expense reports and supplier invoices.

• Debugging and issue resolution during Data Conversion, Reporting and Post Production support with Oracle Applications Financial module configuration and use.

• Standard PO Requisition workflow was customized for building approval list, customized notifications, added new attributes and used them for new post-notification functions.

• Resolved user printer issues, Purchase Order approvals & cancellations, opening & closing purchasing and inventory periods.

• Worked on System Administrator Module, registering applications, creating users and defining responsibilities.

• Involved in troubleshooting of concurrent programs (production job failures) like Item, structure, Requisition, Demand and import.

Business Front (SENIOR BUYER CORE PROCURE TO PAY LEAD):

Supervise, plan, direct, prepare and evaluate City purchasing requirements for both CIP and General Fund Purchases, direct and supervise all buyers, develop and training on Oracle ERP modules , monitor and direct contract awards, bid awards, bid proposals, purchase requisitions , plan, review and direct the work of department staff, perform evaluations and recommendations, work with internal departments for purchasing requirements, develop training for purchasing policies, requisition on line training, safety training, and P-card training programs. Improve communications with internal departments on purchasing requirements, and planned purchase dates. Manage and recommend implementation of information technology applications relating to purchasing and inventory control. Implemented risk management policies on cost recovery for annual recovery of $250,000.00, processed City claims for accuracy, validity and determine resolution, purchase both excess general liability and property insurance for the City, verifying accuracy and audit. Develop cost savings initiatives by cooperative purchasing, joinder contracts within government agencies, bidding opportunities for shared services within the region, and standardization of commodities.

Environment: Oracle 8i, SQL, Oracle Financial Applications 11i (11.5.8), R12 – GL, PA, AR, AP, PO.

Stanislaus County - August 2006 to October 2006 , CA

Contractor

(Primary Job: Oracle Functional/Business Analysis) August 2006 to October 2006

Worked as a Functional Analyst to upgrade Oracle Applications from version 11i (11.5.8)

Roles and Responsibilities:-

• Worked as Oracle Applications Procure to Pay Functional Consultant.

• Worked with the Business users to gather requirements and come up with BRD’S.

• Documented business requirements BR100, MD050, MD020, and MD060.

• Worked with business leads for process design, design finalization, configuration of Oracle applications, assisting with training, design review, status review and reporting, implementation and post go-live support for OTC modules –AR, Project Billing.

• Conducted financial process/ software gap analysis, process design, mapping, re-engineering and documented processes using AIM Methodology.

• Ensured that any Oracle integration into other systems meets functional requirements, system compliance, interface specifications and is in direct correlation with overall IT strategy.

• Implementation of setups and configuration of Oracle Financials R11i PO, AR, PA, AP, OM, INV.

• Worked on the Functional Mappings for data conversion from 11i to Release 10.7 for all Distribution and Financials modules.

• Worked on setting up the Approval Hierarchies in Purchasing Module.

• Worked with team member on the Auto Lock Box process in AR.

• Collaborating with other members of IT team to trace and escalate application bugs, problem analysis and resolution, applying fixes and Patches as applicable.

• Provided Business Process best practice advice and training on the use of Accounts Receivables, Fixed Assets and General Ledger to enforce common best practices and gain efficiencies through maximizing the functionality available within the ERP.

• Performed the functional setups for Project Accounting.

• Analyzed the defects, bugs and raised oracle SR’s for data fixes and resolutions.

• Proactive review and recommendation on Workflow improvements in the system to achieve the required business processes.

• Troubleshoot extensively to analyze the business logic for trapping errors in system testing and User Acceptance Testing (UAT) testing.

• Standard PO Requisition workflow was customized for building approval list, customized notifications, added new attributes and used them for new post-notification functions.

• Worked on System Administration Module, registering applications, creating users and defining responsibilities.

• Involved in troubleshooting of concurrent programs (production job failures) like Item, structure, Requisition, Demand and import.

• Prepare and develop all contracts and bids for services and supplies. Working with all 18 departments within the County for cost reductions and cost avoidance savings.

• Combine all commodities and work with internal departments on standardizing suppliers and services.

• Assisted In setting up Order Management and utilizing test scripts during integrated testing cycles. Familiar with the purpose of Order Management, ASN, and other features but did not use at this site.

Environment: Oracle 8i, Oracle Financial Applications 11i – GL, AR, PA, AP, OM, INV.

Modesto Irrigation District

Functional Analyst January 1992 – August 2006

Worked as a Functional Analyst on implementation of Oracle ERP Application 11.0.3 AR, AP, GL, FA, INV, OM modules. Met with customers to understand their system and Service requirements. Writing Functional Specification and coordinating with the technical team to develop various interfaces and reports Assist in the regression testing of Oracle Modules as required

Roles and Responsibilities:-

• Implemented Oracle Financials 11 AR, AP, GL ,INV

• Worked on functional specifications and test scripts for EPB (Enterprise Planning & Budgeting) module.

• Worked with the Purchasing group to design and implement complete Requisition through Receipts process that would fit with payables payments to suppliers.

• Worked with the AR, GL, Projects and FA groups to make sure setups and processes for Payables would fit other modules.

• Worked with the technical team to complete payables systems with EFT, interface to non-Oracle systems for invoice import, eliminate duplicate entry of invoices in foreign currency in Citibank's World Link system by allow invoices in foreign currency in AP and send payment file to Citibank for payment in three methods to international suppliers.

• Developer technically Configured Asset Key, Asset Category and Asset Location flex fields and captured Asset information from both systems and mapping of Asset categories

• Provided business process best practice advice in managing 11i E-Business Suite to avoid cumbersome process and thereby achieving effective control.

• Developed reference manuals for business users for effective management of month ends, quarter ends and fiscal year closure.

• Troubleshooting and debugging to fix issues during data conversion of Projects, Suppliers and Assets.

• Resolved user printer issues, Purchase Order approvals & cancellations, opening & closing purchasing and inventory periods.

• Worked on System Administration Module, registering applications, creating users and defining responsibilities.

• Involved in troubleshooting of concurrent programs (production job failures) like Item, structure, Requisition, Demand and import.

• Documented business requirements BR100, MD050, MD020, MD060, technical design documents and change management requests for data conversions.

• Configured expenditure types and conversion of Projects and Budgets into Grants using the Activity Management Gateway.

• Execution of Reports and reconciliation of converted projects and creation of accounting entries in case of unbalanced journals with the help of Techical Business Analyst

• Mapped Suppliers, Supplier Sites anc contacts information from Uniform Statewide Accounting System to Oracle BIS and requested technical support to created staging tables to populate data from leagacy system.

•

Environment: Oracle 8i, Oracle Financial Applications 11i, AR, AP, GL, FA, CE, INV, PO, OM and Cash Management Modules, Oracle Workflow.

Education

• Graduated High School

• I have taken several courses for Business Administration as well as Public Administration.

• I am working toward the AA then, my BA, and am currently enrolled at Colorado Technical University.

• Worked most of my life and currently taking courses to advance my education and join Purchasing Associations.

• I have obtained my CPM Lifetime Certification from the National Association of Purchasing Manager Association, currently the Institute of Supply Management.

Contact this candidate