Theron Smith
Analytics Manager at Bish's RV, Inc.- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Experience
-
Bish's RV, Inc.
-
United States
-
Retail
-
200 - 300 Employee
-
Analytics Manager
-
Aug 2021 - Present
-
-
-
MWI Animal Health
-
United States
-
Veterinary Services
-
700 & Above Employee
-
Decision Support Analyst
-
Feb 2020 - Present
* Improve processes to increase productivity and accuracy* Utilize Tableau and SQL to provide supply leadership with meaningful reporting* Map processes to learn the activity and locate bottle necks*Created automated updating of Tableau & SQL reports to reduce manual processes*Utilize Tableau to help management visualize large amounts of information quickly*UAT testing new data bases for logic and Performance*Developed Forecasting and Regressions Analysis models*Preform team training in SQL, Excel and Tableau*Liaison between IT and the business to help both understand what is need and possible. *Utilize data to implement new initiatives: - Identify down accounts, target them with new initiatives to gain revenue - Group items to target with discount programs to drive sales - Track profitability and growth of initiative
-
-
Business Analyst
-
2018 - Present
My Primary functions it to create and provide SQL, Tableau and Excel analysis on how the business is doing. * Create Tableau reporting to track the growth of different programs.* Provide self sustaining reports to provide up to date information.* Create SQL Quarries to pull data fro 1 time reports.* Writing and maintaining custom SQL quarries to gain more visibility on business entities in Tableau.
-
-
-
Cognizant
-
United States
-
IT Services and IT Consulting
-
700 & Above Employee
-
Team Lead
-
Sep 2015 - Dec 2018
Working in Inventory accounting maintaining inventory balances, Margins and shrink. Accounting * Reconcile and maintain multiple accounts within the Oracle general ledger* Responsible for all general ledger entries effecting inventory accounts.* Inventory & margin accountant for large grocery retailer.* Creating & publishing Accounting reports for external and internal uses. * Worked closely with auditors to supply support information. * Preform Month end account reconciliations for ledger accuracy.* Analyzing large amounts of data to find actionable trends specifically in inventory. * Phone helpdesk resolving procedural issues and research accounting questions.* Research issues with upstream distribution and direct deliveries. * Coordinate with multiple departments to correct and resolve issues.* Review and correct margin and shrink rates for reasonability. * Working with large amounts of data in Excel and consolidating it into usable information.* Liaison between Client and service provide on scheduling and billing related issues. * Basic SQL scripts* Creating Excel macro enabled work books for search ability and reduction of repetitive tasks.Team Lead* Mentoring and guiding peers while maintaining personal volume and quality.* Facilitates discussions between all necessary parties to drive resolution* New employee training and mentoring after training* Creating and maintain SOP documentation on processes. * Preparing reviewing and approving General ledger entries primarily with Oracle * Communicating expectations and requirements to on and off-site teamsProcess Improvements* Improving processes to increase productivity and accuracy* Mapping processes to learn the activity and locate bottle necks* Automated several manual processes using Excel macros. - A system to track Inventory schedules and changes. - Improved the process of receiving, validating and paying invoices.
-
-
-
SUPERVALU
-
United States
-
Wholesale
-
700 & Above Employee
-
Department Specialist II/III
-
Sep 2013 - Sep 2015
Working in Inventory accounting maintaining inventory balances, Margins and shrink for a large grocery chain. * Creating new Accounting reports for external and internal uses. * Publishing weekly reports accurately and quickly* General Ledger entries primarily Oracle* Reconciling multiple ledgers and fixing discrepancy’s* Reconciling physical inventory counts with book inventory* Researching discrepancy’s in inventory* Creating monthly and year end reports* Creating and reconciliation of cash transactions* Attention to detail when proofing and reading reports. * Assisting in account collections and escalations* Basic SQL scripts* Researching pricing issues* Creating documentation on process
-
-
-
Volt
-
United States
-
Staffing and Recruiting
-
700 & Above Employee
-
Customer Service Representative
-
Oct 2012 - Aug 2013
worked as a customer service rep for the maintenance desk and vendor service group.* Worked with stores to create work orders to fix equipment*Deployed vendors to fix equipment issues*work under quick turn around times to deploy time sensitive issues. *Resolved issues between stores and vendors worked as a customer service rep for the maintenance desk and vendor service group.* Worked with stores to create work orders to fix equipment*Deployed vendors to fix equipment issues*work under quick turn around times to deploy time sensitive issues. *Resolved issues between stores and vendors
-
-
Education
-
Boise State University
B.B.A., Accountancy -
ITT Technical Institute
A.S, Computer Networking Systems