Data Analyst Oracle
Resume:
Michael S. Price
Canonsburg, PA 15317
412-***-**** Mobile
(Voice Only, Do Not Text)
*********@*******.***
Experienced ERP Business Analyst serving as the liaison between users, management and technical staff, gathering business requirements, designing and configuring solutions, SQL queries, documenting process flows and coordinating implementation, testing and startup of ERP and business systems. Understands the integration across process areas and modules including general ledger, accounts payable, accounts receivable, and projects.
Professional Experience
May 2016 – October 2019
Worked on various short to mid-term consulting projects with responsibilities, as follows:
Administered Concur expense reporting solution and interfaces to Oracle Financials applications; communicated results to team, and recommended updates
Created Concur Standard reports using Concur Query Studio and Concur Report Studio
Provided Data Cleansing to identify reasons for record failure and implemented necessary corrective actions
Initiated EDI correction to ensure error-free transfer of information
Tested upgrade of webMethods v9.0 and interfaces to ERP systems
Identified and troubleshot system wide access issues and implemented corrective actions
Ensured functionality of On-Board computer-based testing software
Compiled functional detailed reports and communicated session metrics to all concerned parties
IT Consultant
November 2015 – May 2016
Ajilon Staffing, Pittsburgh, PA
Data Analyst
Created, compiled and generated multiple field service reports utilizing FX Service Center service management software
Provided various bidding, scheduling and invoicing reports utilizing Corrigo Field Service Management software
Extracted and prepared data for software conversions
June 2015 – September 2015
PTC Alliance, Alliance, OH
Functional Analyst
Created and updated functional implementation documents Oracle 12.1.3 using Oracle AIM methodology
Acted as a functional liaison between business users and developers
Diagnosed configuration issues and provided a pathway for the implementation of solutions
Coordinated and conducted requirements gathering sessions
Provided data ETL via SQL and creation of Excel spreadsheets with extracted data
November 2010 – June 2014
KForce, Inc., Pittsburgh, PA
Oracle Payables Functional Analyst
Created design documents for custom processes and reports in Oracle 12.1.2 using customer standards for improved functionality
Created and generated reports and report components in Oracle FSG
Acted as a liaison between business users and developers
Led and managed a data extraction process using ETL via SQL*Plus
Provided Ad Hoc reporting utilizing SQL*Plus
Expertise in the diagnosis of configuration issues and recommendation of solutions
Developed test scripts and scenarios for new functionality
Reported map process flows using Visio
Managed various functional documents utilizing SharePoint Server
Compiled and created training documentation
May 2009 – November 2010
Walgreens Specialty Pharmacy, Carnegie, PA
Oracle Applications Analyst
On-going maintenance and improvement of Oracle 11.5.10 applications
Created of custom menus and user responsibilities to achieve streamlined functionality
Configured Payables, General Ledger, Assets and Cash Management in Oracle R12.3 and demonstrate new functionality in Oracle R12, communicate with end-users to document their requirements
Provide functional design for legacy system interfaces
Provided data extraction processes utilizing ETL via SQL*Plus
Created various Ad Hoc reporting functions with SQL*Plus
Conducted End-user training and creation of user documentation for Oracle 11.5.10 and R12
Designed interfaces with third-party systems
Utilized SharePoint Server to manage and distribute functional documents
Coordinated transfers of information to multiple off-shore resources
June 2007 – May 2009
Oracle Corporation, Redwood Shores, CA
Principal Consultant
Provided pre-implementation requirements gathering and fit/gap analysis
Coordinated project team members to achieve timely completion of tasks
Planned and documented implementations using the Oracle AIM methodology
Implemented Oracle Financials AP and Internet Expenses in Release 12.06
Created and executed SQL queries to test design assumptions
Provided post-implementation support and configuration update of Oracle Payables, General Ledger, Purchasing, Receivable, Oracle Internet Expenses and Project Costing modules in 11.5.10.2
Conducted End-user training and creation of user documentation
March 2004 – February 2007
N.A. Water Systems LLC, Moon Township, PA
Business Applications Specialist
Administration, maintenance and configuration of Oracle Financials Receivables, Payables, Purchasing, General Ledger, Fixed Assets, iExpense, iTime and Projects applications on application version 11.5.6
Assisted with ERP conversion from Oracle to JD Edwards Xe version 8.0 – extracted data for conversion from Oracle database using SQL*Plus
Created new reports and maintained existing reports using Oracle Financial Statement Generator
Responsible for JD Edwards user security, menu customization, worked with address book and object management workbench
Administered Concur Expense Reporting Solution, managed user security, configuration, audit and validation rules, created custom reports
Coordinated transfer of hosted applications to new service providers
Administered Concur Expense Reporting application
Conducted user-training for Oracle Financials, JD Edwards and Concur Expense Reporting
January 1995 – March 2004
GENCO Distribution System, Inc., Pittsburgh, PA
Accounting Manager
Provided oversight of accounting process for Fulfillment, Logistics and Value-Added Services business units
Responsible for general ledger, P&L, budget preparation, budget variance analysis, and month-end closing reports
Coordinated assimilation of multiple acquired companies
System Administrator responsibility for Oracle Financials software using Receivables, Payables, Purchasing, General Ledger and iExpense on application versions ranging from 9.4 to 11.5.7
Configured Oracle Applications as necessary for upgrades, new modules and/or maintenance
Created new reports and maintained existing reports using Oracle Financial Statement Generator
Developed user-training materials for Oracle Financials
Coordinated implementation of Oracle iExpense
Implemented Positive Pay through Oracle Financials
Responsible for identifying necessary patches and coordinating installation
Participated in upgrades of Oracle Financials to versions 10.6, 10.7, 11.5.3 and 11.5.7
Education
Community College of Allegheny County, Pittsburgh, PA, A.A.S. degree in Business Administration
Robert Morris College, Pittsburgh, PA, B.A. degree in Business Administration
California University of Pennsylvania, MBA program – currently attending
Contact this candidate