Accounting, data analysis, query design

(Carl) Tanner Selinger

Lewisville, Texas ***** 214-***-**** **************@*****.***

OBJECTIVE:

Contribute my expertise and skills in financial analysis that will benefit management decisions for company operation.

EXPERIENCE:

Accounting Analyst: Southwest Automated Security, Dallas, TX, 40 hours/week 06/2023-12/2023

Provide reports to multiple Vice Presidents on branch profitability.

Provide reports to assist managers in product sales and margin analysis.

Generate a server to automate daily, weekly and monthly reports.

Provide users training on A/R, A/P and Inventory software entries to reduce reconciling errors.

Controller: CAZ Creek Holdings, LLC, Carrollton, TX, 40 hours/week 10/2022-02/2023

Karum Group, LLC, Dallas, TX, 40 hours/week 01/2022-09/2022

Chippenhook Corporation, Lewisville, TX, 40 hours/week 05/2004-12/2017

Oversee and save $80K annually by installing Navision software sales tax program.

Oversee and save by 50% in sales order shipment and reporting time in implementing new procedure.

Reduce costs by $10K annually in printing and copying through contract negotiations with suppliers.

Generate reports that showed fluctuations in inventory showing COGS variances.

Improve, enhance and reduce manpower cost by enhancing the efficiency of JetReports.

Oversee accounts receivable and accounts payable for cash planning.

Supervise, monitor, and manage finance, accounting, and human resource personnel.

Monitor monthly journal entries and prepare income tax documents for tax filings.

Oversee upgrade projects for accounting systems from Navision 3 to Navision 4 to SAP R/3.

Create a separate entity for elimination entries and consolidated financial statements.

Create cash flow statements for company-wide expense reports.

Review and approve payroll processing and general ledger postings.

Perform monthly, quarterly and annual sales tax returns for several internal entities.

Manage various accounting reports such as monthly finance functions, budget, and compliance with accounting policies and procedures.

Assist users on how to find data in the system using filters and data queries.

Train users on how to perform Navision software duties.

Perform monthly closing procedures for multiple companies and consolidations.

Controller: Health Care Interiors, Carrollton, TX, 40 hours/week 03/2021-10/2021

Create process changes to allow the cost of goods sold to be reconciled.

Create reports and scripts for inventory and shipment reporting.

Create dashboard reports to show order backlog, manufacturing performance and other key indicators.

Created processes and procedures to account for non-manufactured items to pass through inventory with the correct costs.

Maintain all accounting records and bank reporting.

Develop a process to reconcile employees credit card receipts to vendor.

Accounting Data Analyst: Toyota Financial Services, Plano, TX, 40 hours/week 08/2020-03/2021

Create custom queries in Snowflake to verify reports from HEPM, SAP Analysis for Office and Smart View.

Perform programming in Visual Studio to gather, scrub and populate SQL tables with data from various sources.

Analyze for missing data and work with various departments to get the data reconciled.

Analyze data for automating various tax reports by sourcing reports from Hyperion, Smart View and data warehouse information.

Perform many Account Reconciliations with varying types of subledgers.

Run biweekly Dealer Reports for private label business.

Reconcile to subledger and troubleshoot data anomalies and field questions.

Senior Financial Analyst: Haag Engineering, Flower Mound, TX, 40 hours/week 12/2018–05/2020

Place posting locks on accounts receivable, accounts payable, fixed assets and cash for reconciliation.

Calculate information to move from Cash to Accrual method of sales tax reporting.

Utilize Jet Reports and SQL queries to create marketing and sales invoice reports.

Utilize Nav to help craft application with timesheet use.

Provide assistance and knowledge to create timesheet application to run on smartphones.

Senior NAV Consultant: Computer Business Solutions, Plano, TX, 40 hours/week 01/2018-12/2018

Troubleshoot problems in NAV Financials and Supply Chain modules.

Troubleshoot issues in NAV with various add-ons.

Utilize SQL for SSRS and query creation for reporting and system corrections.

Perform migrations for companies into current versions.

Create Power BI dashboards and score board reports.

Upgrade customers on 2017 and 2019 to Business Central.

Support clients in several different versions of NAV software up to version Business Central.

Consult with various customers for accounting treatments or processes.

TECHNICAL SKILLS: Skilled in MS Excel, Access, SQL, QuickBooks and Great Plains

EDUCATION: BBA in Accounting, Texas Tech University, Lubbock, TX, 1987

Contact this candidate