Uploaded File
add photo
Keith
hudsonkn@gmail.com
678-994-7316
Douglasville, GA 30133
404-994-7316
Data Analyst
12 years experience W2
0
Recommendations
Average rating
57
Profile views
Summary

  • Self-driven with a track record of continuous process improvement initiatives.
  • Automated task for several reports using Visual Basic Application (VBA).
  • Developed a user interface (UI) application using VBA in Excel auto correcting inventory part number discrepancies, improving inventory accuracy.

Experience
Data Analyst
Information Technology
Jun 2018 - present

  • Data Analyst - Contractor at Delta Air Lines
Data Analysis
Remove Skill
Data Analyst - Contractor
Banking/Financial
Nov 2017 - Mar 2018
  • Developed a Tableau Inventory Dashboard analyzing +20M in inventory for 3 divisions and recommended inventory at offsite facility be liquidated resulting in a cost out opportunity of 20k
  • 25% of total inventory was obsolete based on logic of no demand the prior year and no forecasted demand the following year
  • 30% of obsolete inventory had a reserve dollar value and 10% of the obsolete inventory had no financial impact on the books
  • 4+ filters Inventory Dashboard enabled real time filtering by vendor, customer, and commodity using heat, bar, and pie charts
  • 10% of the obsolescence was due to cancelled purchase orders, contract terminations and supplier Economic Order Quantities
  • Reengineered Crystal Reporting logic into Tableau to develop data visualizations based on SQL logic from the Infor platform
  • Created tree maps in Tableau to compare commodities to specific market opportunities for liquidating of inventory nationally
  • Developed 3+ workflows in Alteryx blending multiple datasets to clean data to connect to Tableau for obsolescence analysis
  • Partnered with the SME of Ops implementing the use of digital scales for washers and bolts to increase inventory accuracy The Home Depot 4 years 1 month
Data Analysis Data Visualization SQL Tableau
Remove Skill
Night Auditor - Front Desk Sales
Information Technology
Mar 2013 - Nov 2013
  • Surpassed monthly enrollment quotas of Intercontinental Hotel Group (IHG) Rewards Club adding value to guest stay enabling them to earn and redeem points towards a free stay.
  • Supervised OPERA Property Management System software (PMS) effectively decreasing user errors implementing methods increasing work productivity, guest check-in efficiency, and final bill accuracy.
  • Performed 14-day availability reports forecasting hotel room availability and corrected errors in room inventory.
  • Motivated team members to perform at high standards achieving enrollment quotas and guest satisfaction.
  • Completed shift reports balancing cashier's drawer to properly track and record cash sales transactions.
  • Performed audits verifying accuracy of financial records and identified improvements of the financial process.
  • Settled batches of credit cards and filed reports verifying funds were deposited in the bank.
Auditing Sales
Remove Skill
Intern - Administrative Assistant
Information Technology
Feb 2013 - May 2013
  • Co-coordinated the DeKalb Chamber of Commerce 75th Annual Luncheon 100+ attendees.
  • Managed logistics preparing shipping labels for invoices via Word for shipment increasing efficiency and accuracy.
  • Organized data in Excel to more effectively keep track of account receivables, payable's, and the budget.
  • Created Power Point presentations comparing forecasted and actual revenues to measure organization's performance.
No skills were added
Remove Skill
Intern - Research Analyst
Information Technology
Oct 2012 - Dec 2012
  • Researched private businesses analyzing ownership, annual revenues, and number of employees implemented solutions to drive sales and increase profit margins such as: website development and social mediums to elevate exposure in the market.
No skills were added
Remove Skill
Cashier
Information Technology
May 2009 - Aug 2009
  • Greeted customers and offered assistance when necessary
  • Satisfied customer needs through quality service Collected revenue and processed orderly transactions
No skills were added
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Bachelor's in Economics/Finance
Benedict College 2012
Study Abroad
Al Akhawayn University 2012
Skills
Data Analysis
2021
2
Data Visualization
2018
1
SQL
2018
1
Tableau
2018
1
Auditing
2013
1
Microsoft Excel
0
1
Process Improvement
0
1
Sales
2013
1