Data Analyst
Work History
Contact
https://www.linkedin.com
/in/adam-diekhoff-91851762
Skills
Adam Diekhoff
Forward thinking Data/Operations Analyst driven to develop streamlined operational processes. Dynamic, data driven, out of the box thinker, focused on successful results and effective solutions. Committed to providing accurate, consistent, useful, and professional quality dashboards and reporting for all clients. Client Analyst
Plus Relocation Services Inc., Saint Louis Park, MN Produced monthly activity, financial, and ad-hoc reports using Microsoft SQL Management Studio for clients with annual relocation budgets greater than $100 million.
Created and improved intelligence resources to facilitate consistent and accurate data by automating dashboards and scheduled reports using Microsoft SSMS reducing 25%/month in payroll dollars spent.
Automated invoicing process utilizing SSMS and saving 20%/month in payroll dollars spent and greatly reducing any potential for error.
Created, customized, and automated reporting work queue using Microsoft Sharepoint and provided live productivity dashboards.
Evaluated consistency and importance of different business intelligence data against business needs to determine optimal courses of action.
2019-08 -
2020-07
Relocation Coordinator/Analyst
Coldwell Banker, Edina, MN
Performed system analysis, testing, implementation and user support for platform transition from Move Track to Orion Mobility.
Uncovered over $2 million in revenue by standardizing multiple sub-sources, operational processes, and effectively merging reporting processes from two departments using separate CRM tools.
Produced monthly revenue, activity, and ad-hoc reports for senior leadership using advanced Excel spreadsheet functions.
Reduced payroll costs by 25%/month by streamlining workflow processes and automating all invoice functionality. Increased revenue by 10% by automating fees charged to 2016-12 -
2019-08
Address
Burnsville, MN, 55337
Phone
************@*****.***
Microsoft SSMS and SSRS
SQL
Salesforce
Microsoft Office
Strategic planning
Sales forecasting
Analytics and SEO
Data quality assurance
processes
Communications management
Certifications
clients based on Relocation Policy.
General Manager
Laser Quest, Arlington Heights, IL
Forecasted sales and schedule to best accommodate store traffic, payroll guidelines, and operational efficiency. Created customized reports to best visualize profitability and maintain clear understanding of P&L reports.
Teamed with local businesses to create and execute marketing plans which increased sales by 22%.
Lead team building workshops for corporations and provided follow up calls and photos for all events.
2015-08 -
2016-11
General Manager
Sephora Inside JCP, Maple Grove, MN
Created operational reports to analyze data and proactively plan to meet business needs by utilizing advanced Excel processes.
As Project Manager to oversee construction of new store and lead team to ensure construction, store set, and new hire training was completed as effectively and efficiently as possible.
Maintained yearly store Net Promoter Score of 98% by effectively training and coaching staff.
2013-01 -
2014-07
Co-Manager
Ulta Beauty, Maple Grove, MN
Lead teams nationwide to execute store remodels and store sets for new construction.
Utilized Kronos to effectively forecast sales and schedule staff while adhering to strict payroll guidelines.
Utilized Excel to create revenue reports and organize data to effectively analyze product sales and placement.
Chosen as one of 1,500 managers to act as brand
ambassador and partake in leadership development program. 2010-10 -
2013-01
2019-09 Microsoft - Querying Data with Transact-SQL