SAP
Matthew Hill
Covington,GA
Summary
Versatile with department resource background, successfully executing diverse and multiple project tasks to meet deadlines with a high degree of accuracy. Always a positive attitude. Willingness to take on added responsibilities to meet individual and team goals. Highly skilled at communicating with colleagues, monitoring status and achieving key milestones including Revenue Recognition reporting goals. Enthusiastic problem solver and talented team player with superior planning and decision-making skills with an ability to handle multiple projects simultaneously with a high degree of accuracy.
Professional Project Management Specialist with experience working with teams to accomplish short- and long-term project goals. Managed budgets and monitored project costs as well as a detail-oriented team player with strong organizational skills. Attentive to detail with experience in coordinating projects, programs and improvements.
Overview
4
4
years of professional experience
4
4
years of post-secondary education
Work History
Project Coordinator II/SAP B1 SME
Wuxi AppTec
Philadelphia, PA
1 2021 - 4 2024
- SAP B1 Super User – useful to each department for data retrieval
- Created a KPI dashboard for Revenue Recognition weekly for Finance, and CEO, CFO, Regional Manager, report for current and past status of department A/R
- Developed a new program for project managers, finance, and accounting to invoice for every line item of Pass-Through Costs
- Created report for every item or chemical used in over 200 projects was invoiced or credited
- Crucial asset in the update of SAP B1 version 9 to version 10 for client delivery, project management, client organization, project organization, logistic planning, product expiration, product reorder, revenue recognition, AR Management, Accounting journal entries
- Created new process for new SOP – Pass-Through and Testing Costs.
- Supervised multiple projects from project start through delivery by prioritizing needs and delegating assignments
- Developed comprehensive project plans, outlining scopes, timelines, deliverables, and milestones
- Kept projects on schedule by managing deadlines and adjusting workflows with coordinating departments, if postponements were eminent, it was communicated immediately.
- Excellent communication skills, both verbal and written between departments
- Self-motivated, with a strong sense of personal responsibility for strong points as well as weaknesses
- Coordinated efforts with IT professionals to troubleshoot technical issues promptly, minimizing disruption in daily operations.
- Improved interdepartmental communication through the implementation of collaborative tools and clear guidelines.
- Proactively identified potential risks or challenges within the organization, developing action plans for mitigation before they could adversely impact business outcomes.
- Evaluated existing technology infrastructure, proposing upgrades or replacements when necessary to support business growth effectively.
- Implemented data-driven strategies for better decision-making processes within the organization.
- Played an integral role in the successful launch of multiple company-wide projects, meeting deadlines, and staying within budget constraints.
- Developed comprehensive training materials for efficient onboarding of new employees and existing for software updates plus data management tools. Held brief Excel tips sessions
- Optimized workflows to increase efficiency within the corporation for SAP B1 and Microsoft Excel + B1
- Supported project managers with resource allocation decisions based on priority tasks and overall company goals.
- Championed process improvements that led to more streamlined operations throughout the organization.
Financial Analyst
Highmark Health (Contract Position)
Camp Hill, PA
11.2019 - 08.2020
- Aided Highmark under contract with PeopleSoft to Oracle migration.
- PeopleSoft, Oracle Cloud, and PCM in Smartview query capabilities.
- Accrual Accounting, Reconciliation for A/R and expenses, JE back ups, BlackLine back ups, and Oracle.
- Oracle Cloud Fusion Account Receivable processing.
- Communication & Coordination with other departments, divisions, and 3rd parties to solve invoicing/reporting problems.
- Performed Inter and intra-company invoicing.
- Performed monthly reconciliations for revenue and expense accounts and flux analysis.
- Use of Coupa to pull vouchers.
- Managed corporate watch lists and insurance files.
- Worked flexible hours across night, weekend, and holiday shifts.
- Excellent communication skills, both verbal and written.
- Used strong analytical and problem-solving skills to develop effective solutions for challenging situations.
- Proven ability to learn quickly and adapt to new situations.
- Skilled at working independently and collaboratively in a team environment.
- Proved successful working within tight deadlines and a fast-paced environment.
- Worked under contract effectively in fast-paced corporate environments.
Data Analyst
FedEx Genco Supply Chain
05.2019 - 10.2019
- Use of PowerBI to create dashboards to compare budget variance daily, weekly and monthly
- Pull raw data using Cognos and then create digestible reports in Excel
- Utilize Microsoft Dynamics to pull payment and inventory data and create reports and dashboards
- Helped in creating controls for business processes
- Creating reports and spreadsheets with forecasting and demand capacity for 3PL supply chain logistics warehouse fulfillment management
- Responsible for all ADP hourly, weekly and monthly reporting, companywide
- Extensive Kronos, COFI, SCI, Cognos training-ability to create and customize reports from each system
- Labor sharing and planning for attrition, temporary labor, FTE, overtime planning
- Created macros using VBA development to automate reports in Excel.
- Designed and developed data pipelines to acquire, clean and process data.
Corporate Senior Internal Auditor
Bel Fuse Inc.
06.2017 - 04.2018
- Reported directly to the Director of Internal Audit, CFO, Audit Committee Board
- Excellent communication and relationships with entity Controllers and Accounting Managers for reporting and reception of important documents
- Communicated with external auditors including KPMG, E&Y, Deloitte, and Protiviti
- Provided provide process maps, quick reference guides and training documents
- Organized and detail-oriented with a strong work ethic
- Passionate about learning and committed to continual improvement
- Worked well in a team setting, providing support and guidance.
- Strengthened communication skills through regular interactions with others.
- Worked flexible hours across night, weekend, and holiday shifts.
- Excellent communication skills, both verbal and written.
- Proved successful working within tight deadlines and a fast-paced environment.
- Paid attention to detail while completing assignments.
Senior Accountant and Business Analyst (Contract)
AmeriHealth Caritas
03.2017 - 06.2017
- Responsibilities: Reconcile Data with nVision & Excel Software to balance for 7 different companies under the Healthcare Company
- Recognizing all financial funds transferred in and out of each account and bank
- Updating previous and current KPI for top managers
- Extensive reconciliations in BlackLine Software for Internal and External Audit
- Gather and organize raw data from a variety of sources to formulate necessary documentation
- Conduct data collection via different qualitative and quantitative modes and provide historical, current and future trends/projections
- Work collaboratively with other analysts and subject matter experts in all phases of research
- Requires flexibility to adapt research strategies to take into account data limitations and time constraints
- Identify source, collect and analyze data, to include increased workload, increased level of effort, Acceptable Performance Level (APL) changes, clarifications, or policy requests
- Identify, develop and brief Organizational Staffing Requirements/Plans
- Develop plan capacity models for the core functions or value streams such as Claims, Prescriptions, Credentialing, Appeals, Payment Requirements, Beneficiary Notices, State Contract Compliance Requirements, forecast staffing requirements based on plan capacity, a process standard, and available work hours
- Utilize systems such PeopleSoft, Oracle, SQL, SAS, Visual Studio, Cobalt, Citrix, EXP, Facets, Data Warehouse, SQL Database Configuration for various reporting, auditing and accounting needs.
Functional Analyst Secret Clearance
Unity Tec Consultant to Defense Logistics Agency
New Cumberland, PA
01.2017 - 03.2017
- Responsibilities: Develop Charter documents for assigned project initiatives for Care of Stock in Storage (COSIS)
- Utilize systems such as DSS – DLA’s warehouse, LDG, WebFLIS, EDMS (DACSRM)
- Conduct data collection via different qualitative and quantitative modes and provide historical, current and future trends/projections
- Work collaboratively with other analysts and subject matter experts in all phases of research
- Requires flexibility to adapt research strategies to take into account data limitations and time constraints
- Identify source, collect and analyze data, to include increased workload, increased level of effort, Acceptable Performance Level (APL) changes, clarifications, or policy requests
- When applicable, shall provide process maps, quick reference guides and training documents
- Identify, develop and brief Organizational Staffing Requirements/Plan for multiple scenarios Attend working meetings providing input to working group deliverables
- Gather and receive raw data from a variety of sources to formulate necessary documentation
- Develop plant capacity models for the core functions or value streams such as Receiving, Stowe, Pick, Pack, Issue, Transportation, Inventory, PPP&M and Stock Readiness for each of the DLA Distribution centers that will be used to forecast staffing requirements based on plant capacity, a process standard, and available work hours
- Financial and IT Auditing - Assessed audit and test program and security controls using organization IT Security Policy Handbook and NIST Special Publications to provide information necessary to determine their overall effectiveness.
Education
Bachelor of Science in Accounting - Accounting
Pennsylvania State University
Middletown, PA 09.1996 - 05.2000
Skills
Project Coordination and Multi-operations Management
Attention to Detail for 200 Projects CELL Therapy and Viral Vector
Workload Management with addition of Old and New Projects
Performance monitoring Monthly, Weekly, Daily
Data Collection with Spreadsheet Tracking/Dashboard KPI for all major ERP Systems
Customer Management when needed
Project Timeline Scheduling/Conflict Resolution
Documentation Oversight for Compliance and Item Breakdown
Cost Management and Budget Coordination for Inventory item for each Project
Project Scope and Lifecycle Management using Regulatory and Accounting Compliance
Project regulations FDA & OSHA
Meeting facilitation and Status Reporting AD HOC
Product & Software Development Migration UAT Testing
Organizational Project Performance Reporting
Business Systems Programming and Training Optimization
Cost Control of all Inventory and Expenses for all Projects
Financial Analysis Aid for EOM
Regulatory and Accounting Compliance
Revenue Recognition Growth Reporting
Software
SAP B1
Excel KPI Dashboard
Power BI Dashboard Management
Oracle and add ons
BEAS and other SAP add ons
AWS Database
Azure
Microsoft ERP and Add Ons
Timeline
Financial Analyst
Highmark Health (Contract Position)
11.2019 - 08.2020
Data Analyst
FedEx Genco Supply Chain
05.2019 - 10.2019
Corporate Senior Internal Auditor
Bel Fuse Inc.
06.2017 - 04.2018
Senior Accountant and Business Analyst (Contract)
AmeriHealth Caritas
03.2017 - 06.2017
Functional Analyst Secret Clearance
Unity Tec Consultant to Defense Logistics Agency
01.2017 - 03.2017
Bachelor of Science in Accounting - Accounting
Pennsylvania State University
09.1996 - 05.2000
Project Coordinator II/SAP B1 SME
Wuxi AppTec
1 2021 - 4 2024