FINANCE COORDINATOR Highlights Microsoft Excel, Word, Access, PowerPoint, MS Outlook, SAP, Marketing Funds System, Siebel, AS400/Mainframe, Baan ERP, SharePoint, Salesforce.com, SAP CRM Experience 05/2014 Current Company Name － City State Finance Coordinator SUMMARY Dedicated accounting finance professional proficient analytical, budget processing, supporting researching experience includes general ledger reconciliation, data management analysis, auditing, accounts payable accounts receivables. Successful managing multiple assignments meeting tight deadlines. Adept building productive, cross-functional team relationships, leveraging relationships gain cooperation resolving issues. 02/2012 05/2014 Company Name － City State Master Data Specialist Accurately created customer master data records sales hierarchies SAP. Served subject matter expert Warehouse Direct (WD) accounts, addressing escalated issues answering questions business regarding WD processes. Involved SharePoint project reduced WD account create change work flow process time half. 12/2008 02/2012 Company Name － City State Financial Analyst Worked closely pharmaceutical client CFO controller generating reports reconciliations assist cash flow forecasting. Performed reconciliations utilizing Excel techniques including V-lookups pivot tables. Consistently managed completed month end close process within five business days. Processed client approved write-offs, accruals, journal entries posted transactions general ledger. Assisted account analysts collection past due open accounts receivables. Participated recommendation, development, testing implementation department automated AR Reconciliation tool, significantly reduced manual matching work performed department Financial Analysts. Received several recognition awards commitment teamwork, initiative, process improvements customer service. 08/2006 07/2008 Company Name － City State Financial Analyst Maintained accurately loaded multi-million dollar marketing budgets forecasts Marketing Funds sub-ledger. Supported brand marketing managers providing analysis weekly reporting marketing spend actual results versus forecast SAP Marketing Funds. Met quarterly brand managers ensure activity based spend in-line forecasted budget. Assisted finance manager period end yearly close functions. Documented tracked forecast changes brands programs Marketing Funds system Access database; quarterly reconciling budget dollars within two systems. Assumed lead role reporting inventory status brand managers assisting resale overstock items; analysis researched variances. Coordinated annual Accrual process. Audited payment requests excess 75k correct general ledger coding adherence GAAP guidelines. 02/2000 08/2006 Company Name － City State Trade Promotion Specialist Accounting Pre-audited processed trade marketing bottler coop reimbursements conform GAAP guidelines. Analyzed adjusted trade budgets actual facilitate year-end close process. Prepared period year-end close journal entries multiple general ledger cost center combinations. Created customized reconciliation forms reports, using Excel techniques including macros, V-lookups, pivot tables. Led executed department training; trained new hires Marketing Funds System, SAP reconciling procedures. Participated development, testing documenting department reconciling tool. Oversaw department records retention/retrieval system; received "What Outstanding Work" (WOW) award initiative independent effort. Received "Shooting Star" award individual contribution team's overall successful accomplishments. Education 2016 Columbia Southern University City State B.S Business Administration/Finance Business Administration/Finance Skills Accounting, accounts payable, accounts receivables, accruals, Accrual, AR, AS400, auditing, Baan, brand marketing, budgets, budget, cash flow, com, controller, CRM, client, customer service, data management analysis, drivers, ERP, finance, Financial, forecasting, forms, functional, Funds, general ledger, inventory, ledger, macros, Mainframe, managing, marketing, Access, Access database, Microsoft Excel, Excel, MS Outlook, PowerPoint, SharePoint, Word, month end close process, pivot tables, processes, coding, promotion, reconciling, reporting, researching, sales, SAP, Siebel, simulation, Six Sigma, teamwork, year-end