As a member of the company’s Finance department, I provide insights and support optimal business decision making. I regularly design, create, and run effective financial reports in addition to being responsible for monthly submission of board package reporting to parent company. My role is integral to budget setting and analyzing key financial indicators (profit margins, sales by industry and product type, etc.).• Develop financial models in Power BI to support decision making across the organization.• Worked with regional managers to create zero-base annual budget and regularly review actuals against budget to conduct variance analysis. Effectively communicate analytical findings and insights to executives.• Ad hoc financial reporting as requested by management and parent company.• Designed reporting package to submit to the Board of Directors, submitted monthly.• Weekly cash reporting to CFO.• Collaborate with accounting and operations to automate manual processes, using Power BI and Power Query. Examples include creating parts dashboard in Power BI to replace Excel reports, automating calculations and data collection of incentive compensation for HR, automation of cash reporting.

• SAP and Power-BI Subject Matter Expert within organization, working across all departments to promptly resolve questions/issues and bridge communication gaps between internal users and third-party consultants• Collaborate with department managers to plan, prepare, and present annual budget to President. Re-designed budget input parameters in Workday Adaptive to improve accuracy and efficiency of budget process from three months to one month•Assess variances between budget and actuals and provide comprehensive flux explanations to management and parent company based on analysis.• Prepare monthly and quarterly P&L forecasts to submit expected bookings, revenue, COGS, functional costs, and EBIT to parent company. Develop tools and procedures to increase forecast accuracy, including implementing monthly calls with managers to measure and encourage progression toward forecast commitments• Collaborate with department managers to develop Power BI reports to monitor KPIs. Examples of reports developed include On-Time-Delivery Report, Project Margin Report, and Warranty Cost Report.• Leadership role in ERP migration of newly acquired company. Responsible for mapping and setting up chart of accounts, set up of item groups, transactional testing, and importing and reconciling opening GL balances, inventory subledgers, sales orders, and AR and AP invoices. Built relationships and work closely with new users to ensure smooth transition.•Ad-hoc analysis and presentations as required by executive management to provide and effectively communicate input on new initiatives

• Designed and implemented SQL queries in SAP for group reporting of sales, COGS, and inventory, post-acquisition by our parent company, which resulted in reduction of monthly financial close by two days.• Worked with project managers to prepare and journalize accounting entries for Percentage of Completion Revenue (POC) for large projects. Re-engineered POC process from manually tracking each project in excel to utilizing Power-BI to automatically populate data and calculations directly from SAP, resulting in real-time visibility of project status for Finance and Project Managers, as well as time-savings of 24 hours per month• Responsible for monthly reports to management and parent company, including Executive Management Summary, Sales Statistics by industry and product line, and In-for-Out report analyzing book-to-turn times for each product group• Developed P&L and other financial templates in Workday Adaptive/Office Connect, requiring simple refresh each month to submit to CFO and other stakeholders for P&L statement snapshot• Partnered closely with Accounting department to review and challenge monthly financial results. Analyzed product group gross margins, adjustments to COGS, and functional costs to ensure accurate monthly reporting• Collaborated with Accounting department to develop procedures to track and capitalize labor for Operations, in an effort to provide more visibility of labor efficiency to management. Analyzed and calculated labor costs to set annual labor rates.•Ad-hoc analysis as required by management, sales, and operations to assist in business decision making. Examples include analyzing bookings and sales data to facilitate restructuring of regional sales territories, assessing profitability and sales initiatives for individual product lines, and evaluating departmental expenses to identify potential cost savings

•Reconciled perpetual inventory subledgers to month end balance sheet, researched discrepancies, and implemented effective process changes to prevent future variances• Excess and Obsolescence (E&O) inventory management. Worked with Houston inventory and operations managers in the effective management of inventory. Periodic review of min/max levels, usage rates, months on hand and inventory turnover for each of the product lines/item groups to minimize inventory risk. • Ensured product costing practices and procedures were consistently applied to avoid incorrect costing of products sold and to ensure proper valuation of on hand inventory• Provided direction and support to the Inventory Control Manager to ensure the company’s inventory practices and procedures are updated to mitigate risk and abide by regulatory compliance, loss, waste, or growth of excess and obsolete inventory.•Created and maintained SAP SQL queries and reports to assist sales, operations, and finance with analysis and other business support functions•Collaborated with operations and sales functions on SAP and Power BI process improvement opportunities resulting in increased reliability of data and process efficiency. Examples include setting up purchasing and shipping dashboards in Power BI, and creating automated alerts based on SQL queries to monitor aging backlog•Lead the successful migration of asset data from Sage to SAP. Prepared the SAP capital expense module for import of assets by setting up depreciation methods, useful lives, capitalized dates, asset classes, and GL determination for each asset. Imported and reconciled assets’ purchase value and net book values to ensure no variances. Trained Accounting Manager and Capex Accountant for successful utilization of SAP module.•Prepared, journalized, and posted month end entries to general ledger (including but not limited to month end revenue and expense accruals, capitalization of labor, E&O reserve, and warranty reserve).

•Job costed sales orders to confirm inventory/costing transacted accurately through SAP•Set up customers and monitored customer credit limits•Created monthly cash-flow reports to submit to controller to monitor incoming and outgoing cashflow•Worked with customer service, regional sales managers, & sales representatives to ensure various product line commissions for internal and external reps were accurately recorded in SAP•Provided support & system maintenance to ensure transactions were correctly set up in SAP•Worked with operations & sales to improve and document SAP processes, resulting in greater accuracy and efficiency•Created SQL queries and reports in SAP to assist sales, operations, and finance with analysis and other business support functions•Prepared documentation for Ernst and Young (EY) external audits

• Provided guidance, insights, and recommendations to successfully migrate ERP system from QuickBooks to SAP Business One• Sole accounting professional and subject matter expert at plant location, responsible for ERP training across multiple departments and overseeing ERP process implementation for the plant•Held monthly accounting meeting for the plant to promote dialogue across departments and ensure communication on finance related questions and issues clear and effective•Entered accounts receivable invoices for shipments, processed milestone orders, and collected past due payments from customers•Processed purchase order invoices, coded and processed service invoices, ensuring allocations to correct GL accounts •Set up biweekly payment batches, reviewed vendor statements, and responded to vendor payment status requests

• Provide weekly statements after compiling and calculating freight data to ensure accurate account settlement for all inbound and outbound shipments for top tier oil services firm• Process incoming deposits ranging up to two million dollars • Research accounts receivables and work in conjunction with customer and operations to resolve any discrepancies• Monitor revenue and expenses for the warehouse to ensure enough funds to pay vendors• Collaborate with team to reengineer settlement procedures to increase efficiency and accuracy

•Process customer invoices for the South Central Region; research accounts receivables and resolve billing discrepancies•Process payments for all cash accounts and create weekly deposits; work with District Sales Leaders and Account Executives to overcome any issues arising because of unpaid invoices, payments lost in transit, terms discrepancies•Calculate and process promo reimbursements for distributors •Reconcile inventory each quarter, creating journal entries to offset balances•Assist with AP processing by coding invoices and researching billing discrepancies•SAP Goods Receiver for vendor invoices; Also familiar with other SAP processes (i.e. entering expense reports, creating puchase orders, and populating various SAP reports)

•Organized and maintained corporate books as well as all employee and client records•Assisted with startup procedures including opening corporate bank accounts, putting together corporate resolutions, and applying for EINs•Attended meetings with potential investors and maintained corporate minutes•Tracked all incoming and outgoing funds using QuickBooks•Maintained company’s accounts payable schedule and issued checks•Managed calendar for executive officers•Proofread and edited subscription agreements

•Entered and maintained high volume of numerical and text data into ADP database, including new hires, rate changes, direct deposit information and tax withholding. Ensured data input was accurate, complete, and timely. •Interacted closely with merchandisers and field management to complete the necessary paperwork required for payroll processing.•Created and maintained employee records. Designed a virtual filing and retrieval system for record keeping.•Provided outstanding customer service to merchandisers and District Supervisors by communicating with them on a regular basis to assist with payroll related questions and to communicate errors on I-9’s, W-4s, direct deposit, pay cards and much more. •Oversaw the implementation of pay cards to replace paper checks for 5,000+ employees. Solved issues arising in the process.•Performed other related duties as required and assigned.