Uploaded File
add photo
Cedric
cspratley_2006@yahoo.com
757-585-4418
Glen Allen, VA 23058
SAP ERP | Data Modeling | Analytics | Process Mapping and Documentation | AP AR Reconciliation | Incentive Compensation
10 years experience W2
0
Recommendations
Average rating
1
Profile view
Summary

Data management and analysis professional with 8 years of experience as a SAP user and administrator. Skilled in data mining, analysis, and finance and technology compliance, I serve to effectively improve quantitative, and qualitative data integrity and standards for system end-users.

Experience
Sales Compensation Analyst
Apr 2018 - Apr 2020
Richmond, VA
-Prepare ‘Sales Performance Incentive Fund’ data packages and invoices using reporting capabilities in Optymyze and Msft Excel to distribute to suppliers for review and approval, on a quarterly basis. Scope of review includes data validation, dispute management, data approval, and payment processing. -Utilized the Peoplesoft and WorkDay databases to service employee payroll inquiries related to incentive payouts, prepare internal reporting, and manage data integrity. -Worked cross-functionally with the MMS supplier marketing team, product category managers, supplier reps, sales managers, sales executive, representatives, and external vendors to manage shared data and improve dashboard and reporting metrics. -Collaborated with a project SME to test and implement a system enhancement in Optymyze that served to reject or place on-hold/take off-hold invoice transactions that impact sales rep spiff earnings. A successful testing phase proved that monthly/quarterly sales rep earnings, supplier earnings, and payroll earnings were in alignment after enabling or disabling incentive-eligible invoice transactions. -Worked with a software developer to create, test and implement a data extrapolation solution for our spiff item setup table in Optymyze. This new enhancement enables the system to extrapolate the data and feed it directly to the spiff item setup table. The original process of extrapolating the data involved using MSFT Access to extrapolate the item template data, and then manually upload the output into Optymyze. -Coordinated, facilitated, and documented the conversion of our Non-PO check request process from a paper-based medium to a digital medium – Ariba Spend Management. This process is necessary to fund a US Bank focus cash card account in time to push payroll dollars to sales rep cardholder accts, via an online bank portal -Conduct end-user training for sales reps and managers on the spiff portal in the Optymyze application.
Microsoft Excel Sales Data Validation Peoplesoft Workday Data Integrity
Remove Skill
Finance Commissions Analyst
Nov 2016 - Nov 2017
Richmond, VA
  • Oversees commission payments to sales representatives on behalf of capital equipment projects, and parts and services, for all of Suez North America including Canada (Ancaster).
  • Create and submit journal entries for new project accruals, and correct erroneous entries to expense and accrual accounts in SAP ECC 6.0
  • Create and maintain project summaries, accrual ledgers, and commissions payment schedules in Excel to keep track of projects that are opened and closed, customer and vendor data, change orders, customer invoices and cash receipts, sales orders, and commissions owed
  • Evaluate and maintain sales rep accounts per terms and conditions set forth by a contractual agreement between the business and the client
Microsoft Excel SAP SAP ECC Sales
Remove Skill
Commercial Analyst
Feb 2015 - Nov 2016
Richmond, VA
· Manage the Commercial Print Service Allowance Rebate process from receipt of data to payment. Scope includes validation, analysis, dispute management, approval processing, reporting, and agreement administration. · Customized a Microsoft Excel database to maintain Pricing Deviation Requests outside of Lotus Notes, and slashed 95% of time off of the customer debit memo validation process · Work closely with global Commercial and Customer Service teams to improve pricing documentation, pricing policies, and procedures · Issue a Monthly Service Allowance Credit report extracted from SAP to our Pricing Administration and Accounts Payable teams · Facilitate the distribution of price-increase letters and maintain a customer contact distribution list
Microsoft Excel SAP Lotus Notes Documentation Customer Service Analysis
Remove Skill
SAP Master Data Analyst
May 2013 - Feb 2015
Richmond, VA
· Created and maintained database queries in Msft Access using SQL · Troubleshoot and administer technical master data management solutions in SAP using many transaction codes that include MM01, CS01, CA01, ME11, SQVI and SQ01 · Created and maintain ZCON, HALB, ZCMV and FERT material master records, their bill of materials, routing assignments, and production versions to facilitate order entry and planned production for our customer service team, production schedulers, and mill engineers in SAP MM-MRP, using Winshuttle, Microsoft Excel, Access, and Lotus Notes · Develop, test, and run mass data management scripts compatible with SAP ERP, using the Winshuttle application · Utilized Winshuttle to revamp a process step in our New Product/Material Grade Creation Workflow. I reduced the overall process completion time by 85%, and subsequently saved our product development team two weeks of turnaround time for new grades created. · Led and participated in the system-process implementation of a new third party, poly-coating converting facility, Sustainable Fiber Solutions, and configured over 40 material masters to function properly for this despite existing, customized SAP functional requirements · Built data queries in SAP using transaction SQVI using MARA, MAKT, MARC, MBEW, etc. tables · Managed material mater data that interfaces with the SAP Logistics (LO), Materials Management (MM), Warehouse Management (WMS), Financial Accounting (FI), Controlling (CO), Production Planning (PP), Plant Maintenance (PM), Logistics Execution (LE), and Sales and Distribution (SD) modules · Performed root cause analysis and implemented permanent corrective actions to resolve business data discrepancies in a timely manner · Create and extend material masters to subcontractor and warehouse locations, then maintain their transportation lanes (PIRs) in SAP MM/WM, to facilitate the proper movement of goods on order
Data Analysis Microsoft Excel SAP SAP EBP SAP Functional SAP MM SQL Analysis Data Management Warehouse Management Sales Materials Management Lotus Notes Logistics Fiber Optics ERP Database Maintenance Customer Service
Remove Skill
Corporate Security Analyst Intern
Feb 2012 - May 2013
· Processed intra-company requests for access to production based SAP ERP modules · Utilized Virsa Compliance Calibrator to identify, remove, and prevent access control discrepancies in SAP ERP · Prepared quarterly restricted access and segregation of duty reports that recognize employees who possess critical access for auditing purposes · Analyzed data to estimate time, money, resources, and labor required for ERP role reconfiguration · Assisted with the implementation of SAP GRC 10 software that operates, and allows user assignment provisioning through SAP, Oracle, and JD Edwards ERP systems · Standardized, automated, and managed certain aspects of the audit process using Sarbanes AutoAudit
Compliance Provisioning Security Analyst SAP Oracle Employ Auditing SAP GRC
Remove Skill
Intern
Jun 2011 - Feb 2012
-Engaged prospective clients via telephone in financial planning -Managed clientele using Bill Good Marketing System -Compiled, categorized, and tabulated data in order to document daily reports on performance -Sparked the opening of two client accounts
No skills were added
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Finance
Virginia Commonwealth University, 2009 - 2012
Skills
Microsoft Excel
2020
6
SAP
2017
5
Sales
2020
4
Analysis
2016
3
Customer Service
2016
3
Lotus Notes
2016
3
Data Integrity
2020
2
Data Validation
2020
2
Peoplesoft
2020
2
Workday
2020
2
Auditing
2013
1
Compliance
2013
1
Data Analysis
2015
1
Data Management
2015
1
Database Maintenance
2015
1
Documentation
2016
1
Employ
2013
1
ERP
2015
1
Fiber Optics
2015
1
Logistics
2015
1
Materials Management
2015
1
Oracle
2013
1
Provisioning
2013
1
SAP EBP
2015
1
SAP ECC
2017
1
SAP Functional
2015
1
SAP GRC
2013
1
SAP MM
2015
1
Security Analyst
2013
1
SQL
2015
1
Warehouse Management
2015
1
C++
0
1
Data Mining
0
1
Data Modeling
0
1
Derivatives
0
1
Financial Analysis
0
1
GSAP
0
1
Java
0
1
Master Data Management
0
1
Microsoft Office
0
1
Microsoft PowerPoint
0
1
Microsoft Word
0
1
Quantitative Analytics
0
1
Risk Management
0
1