SUMMARY:

• Improved data quality by migrating operation information from Sharepoint to more secure location
• Reviewed data for any discrepancies between Hoovers and customer websites
• Provided pricing estimates through data analysis of customer licenses for account team using Pivot tables with Microsoft Excel
• Customer support for customers regarding their licenses
• Created Bill of Materials in Salesforce.com based on final price estimates which were Microsoft Excel worksheets
• Trained employees how to create Bill of Materials and Price Estimate worksheets
• Created Bill of Materials Standard Operating Procedure
• Pulled queries from 360 IB View and extract data for licenses
• Used SAP BI to extract license information

TECHNICAL SKILLS:

• Microsoft Excel, PowerPoint, Word with experience of 22 years
• SAP ECC 6.0 with experience of 9 years
• Cransoft (Material and Vendor systems) with experience of 9 years
• Microsoft Access with experience of 8 years
• Walker accounting system with experience of 8 years
• Solomon Accounting Software with experience of 6 years
• BPCS accounting system with experience of 6 years
• ADP with experience of 6 years
• PeopleSoft with experience of 6 years
• SAP BI with experience of 3 years
• Winshuttle with experience of 2 years
• SAP APO with experience of 2 years
• MYOB accounting with experience of 2 years
• Salesforce.com with experience of 1 year
• Smartsheet with experience of 1 year

EXPERIENCE:

Confidential, Raleigh, NC

Consultant, Operations

• Improved data quality by migrating operation information from Sharepoint to more secure location
• Reviewed data for any discrepancies between Hoovers and customer websites
• Provided pricing estimates through data analysis of customer licenses for account team using Pivot tables with Microsoft Excel
• Customer support for customers regarding their licenses
• Created Bill of Materials in Salesforce.com based on final price estimates which were Microsoft Excel worksheets
• Trained employees how to create Bill of Materials and Price Estimate worksheets
• Created Bill of Materials Standard Operating Procedure
• Pulled queries from 360 IB View and extract data for licenses
• Used SAP BI to extract license information

Consultant, Inventory Management

• Provided Inventory analysis to Inventory Manager, Vice President Inventory management and analysis using Vlookups, Pivot Tables, If/Then Statements for Microsoft Excel
• Purchasing of parts for various distribution channels
• Distribution Center Product Transfers
• Ran Supplier Fill Rate, Open Purchase Order, and Customer Back Order Reports downloaded weekly from Oracle utilizing If/Then Statements, Vlookups, & Pivot tables in Microsoft Excel
• Created database for replacement of obsolete part numbers with new ones in Access

Supply Order Management, Associate Master Data Analyst

• Worked with project implementation team leads to establish project requirements, scope, and objectives
• Acted as point of contact during stabilization period for SAP MDG Implementation for 12 locations for plants, Procurement, Finance, and project owners
• Reported on implementations’ progress and issues to project manager
• Acted as point of contact for issues for acquisitions as well as providing time frame for resolution to project owners
• Escalated issues to management when needed
• Created and maintained comprehensive project documentation regarding status and progress
• Researched and corrected vendor issues during implementation projects
• Set up vendors in Cransoft for three new plants
• Awarded Employee of Month for work on projects implementing acquisitions to SAP
• SAP MDM Vendor Subject Master expert
• Worked with terms standardization project with Finance, Procurement, and IT team leads to establish project requirements, scope, and objectives
• Consolidated large vendors through Cransoft
• Identified invalid communication methods to reduce churn on creation of purchase orders
• Reduced number of remit addresses based on activity and duplication to limit churn
• Provided expertise of vendors to various departments
• Researched blocked invoices, pricing, and Purchasing Information Records without Materials

Data Management Organization, Master Data Coordinator

• Assisted with various acquisition implementation’s objectives
• Acted as point of contact for vendor and customer SAP MDG Implementation for 3 locations
• Analyzed vendor master data and collaborated with internal business partners to ensure submissions are accurate and compliant with internal audit requirements through Cransoft
• Streamlined materials’ approval process in the approval of materials through Cransoft
• Completed master data requests for material and vendor within established service level agreements
• Conducted Vendor Training Sessions for Plant Rollouts in Cransoft software
• Created Rejection Tracking Access Database to prevent future errors
• Ensured data accuracy and integrity in both Cransoft programs for material and vendor
• Maintained knowledge of the data impact on business partners for data quality and integrity
• Prepared mass uploads for material and vendor to the SAP system
• Proposed way to streamline and simplify Cransoft to become more efficient, which became the groundwork for the Just In Time project

SAP MDM Vendor Implementation Project, Project Analyst

• Worked with project team leads to establish project scope and objectives
• Acted as point of contact with project team and leaders
• Escalated issues to management when needed
• Led five to twenty temporary workers during the SAP MDG Implementation project for 40 plants
• Approved, maintained, and monitored temporary workers’ hours
• Trained co - workers and temporary workers how to consolidate and cleanse vendors
• Created and maintained project documentation for project’s progress for project owners
• Verified requests to add new vendors for plants to prevent duplication and ensure accuracy
• Reported to project owners on progress of the cleansing and consolidation phases
• Formulated plan with project manager to continue vendor consolidation after mass consolidation was completed
• Conducted meetings to discuss strategies in correcting vendor errors
• Corrected vendor errors in SAP during stabilization period
• Developed proactive solutions of vendor errors for future stabilizations to prevent bad checks
• Taught co-workers how to use Cransoft and the most efficient scenarios
• Maintained and distributed files of vendors to be cleansed by multiple departments
• Corrected vendor error files during the cleansing process
• Awarded Employee of the Month (October 2007) due to efforts and dedication during the consolidation effort

Accounts Payable Problem Solving Analyst

• Tested Cransoft databases for SAP MDM Vendor Implementation
• Reviewed vendor data for accuracy and impact on accounts payable
• Maintained Access database for Accounts Payable’s vendor issues
• Resolved accounting and approval issues
• Worked with Retail group by providing them payment information for their vendors

Fixed Assets, Contractor

• Maintained Assets worksheets at month end
• Asset retirement worksheets into Oracle
• Researched data regarding physical assets

Accounting Analyst

• Entered vendor invoices into Solomon
• Closed accounts payable and created Journal Entries for month end
• Applied deposits in Solomon for accounts receivable
• Maintained Invoice Log Spreadsheet for accounts payable vendors for accrual at month end
• Entered and reviewed Employee’s Expense Reports

Advisor to Board of Directors, Finance, Operations

• Advised company president on annual budget and setting up pop up stores
• Consulted on direction of company
• Provided business advice to CEO and COO
• Provided and shipped inventory to stores in Nantucket and Cambridge
• Led production department in screen-printing and the assembly of hats, visors, and belts
• Maintained quality control of all products before they shipped out to the customer
• Saved money by using the most cost effective carrier for product shipped to customers
• Ordered all supplies for raw materials and once product was received
• Oversaw process of hiring of new employees
• Implemented and integrated all accounting functions
• Maintained a list of delinquent accounts and managed debt collections

Accounts Payable/Receivable Specialist, Financial Analyst

• Recorded and processed customer invoices in an accurate and timely manner
• Reviewed and approved employee expense reports for payment
• Entered and processed bank wires
• Streamlined the preparation and processing of the weekly vendor check run
• Entered Purchase Orders into the accounting system
• Performed the Accounts Payable close on a monthly basis
• Handled customer inquiries regarding payment schedule
• Maintained tracking of sales of computer products, then reconciled with the vendor at month end
• Prepared, maintained, and performed financial transactions, including cash applications and invoicing
• Reconciled accounts receivable detailed aging balances to the general ledger on a monthly basis
• Maintained all fixed assets schedules and monitored depreciation expense

Confidential, Cambridge, MA

Payroll Accountant

• Maintained and processed weekly and semi-monthly payroll for four hundred employees
• Approved and reviewed employee expense reports
• Handled consultant inquiries regarding paid leave policies
• Prepared and entered journal entries into Solomon