• Conduct SAP system resolution/enhancement testing for rebates, contract maintenance, chargebacks, accounts payables, and accounting areas. Prove appropriate changes resolved the defect or verification that upstream/downstream system modifications do not alter existing functionality. • Responsible for loading and verifying accuracy of international trial balance data into BPC. Maintain related GL account conversion files as part of the international consolidation. Coordinate close process with accounting teams in Netherlands and China.• Create monthly bank reporting packet for Treasury department. Includes Consolidated North America Balance Sheet and Income Statements. • Write reports and perform ad-hoc reporting and analysis using BPC and SAP Business Objects. Modified reports to allow for streamline updates resulting in reducing monthly reporting time by approximately 4 hours.• Implemented use of Excel VBA macros for general rebate calculation formatting reducing nearly 10 hours computational time each quarter.

• Coordinate providing documentation to external auditors during quarterly, preliminary and year-end audits. Main testing areas are revenue, cut-off & recognition, and inventory cost testing. Required Cross-functional coordination with Supply Chain, AR, AP, Sales and Customer Service. Revenue - provide sales order, proof of shipping, invoice, and evidence of payment from end customer. Inventory Cost – proof of ending inventory balance through goods receptions. Cost contracts with suppliers and/or invoices from suppliers.• Perform general accounting duties with accuracy and efficiency. Intercompany and account reconciliations, operating expense accruals, and monthly journal entries.

• Assembled and provided input on annual OPEX budget for the entire organization.• Generated monthly forecasting of operational and capital expenses using SAP Business Objects and BPC for entire organization. Included in depth analysis of OPEX results to Senior Leadership Team of the Distribution Centers (7), IT, Merchandising, and Marketing departments. Discover and explain drivers of areas with significant variances to current budget/forecast. • Prepared and distributed weekly commission reporting to directors and managers of sales team. Leveraged Excel VBA to expedite the reporting process from 1 hour to 1 minute.

• Blue-printing and testing of volume rebate calculations for SAP/Vistex system implementation. Included verifying timing and accuracy of FI postings. Ensure accuracy of imported/maintained contracts and final calculation of rebates. • Automated rebate reporting by recording and writing VBA macros in Microsoft Excel. Reduced completion time from 2 weeks to 2 hours.

• Specialized in volume rebate calculation and collection of related receivables.• Reduced related average aged receivable days from 93 to 34 days by leveraging connections made with supplier partners during the AP Resolution Analyst role.