Resume

Sign in

Data Analyst Oracle

Location:
Canonsburg, PA
Posted:
April 21, 2020

Contact this candidate

Resume:

Michael S. Price

*** **** ******** ****

Canonsburg, PA 15317

412-***-**** Mobile

(Voice Only, Do Not Text)

adcwnt@r.postjobfree.com

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