A Successful Data Analytics Practicioner
requires two components: Technical Aptitude and Business Acumen. I am of the few that excel at both. With 14+ years experience on both the Development and Analyst/Reporting sides, I am experienced taking a BI project from Inception to Actionable Insights. I love running a team, coding SQL, and creating dashboards. Helping organizations evolve from reactionary to proactive data-driven decision making is what drives me. I’m Andrew Lloyd and I have a passion for data.
My Experience
Education
Rochester Institute of Technology
B.S. Management Information Systems
Graduated Magna Cum Laude from one of the top ranked MIS programs in the nation. This foundation of technical aptitude and business acumen makes me uniquely qualified for the BI field. When I wasn't managing a floor of freshman as a Resident Advisor you could find me working for the ResNet tech lab.
Georgia Tech
M.S. Analytics
In progress, graduation anticipated 2024.
Work History
Scientific Games
Manager of Analytical Systems
See resume for details.
Thinkful
Data Analytics Technical Expert
Serve as a formal mentor to students, meeting 2x per week. Conduct and grade students' capstone projects and presentations. Conduct mock interviews to help students prepare for upcoming career search. Serve as a formal technical coach for students that require additional curriculum help.
HD Supply
Lead Data Analyst
Work primarily with the Marketing department to analyze customer behavior, report on campaign efficacy, and derive actionable insights therein. Daily tasks include complex SQL scripting and data manipulation, data discovery and visualization with Tableau, presenting findings to executive management, and mentoring the analysts on the team. See resume for more details!
Ballard Designs
Sr. Programmer Analyst, Manager
Developed and managed their Data Analytics department. Created over 75 different reports and dashboards utilizing SQL Server and SSRS. Implemented and managed JIRA, their issue and project tracking system. Worked with data from all departments including Marketing, Inventory, Merchandising, and Finance. See resume for more details!
Cherry Aerospace
MRP Systems Analyst
Project Lead for TOC, a complex manufacturing flow visualization and planning tool. Developed and Implemented Perishable Tool Reorder System. See resume for more details!
Toyota Motor Engineering
Supply Chain Systems PM
Project Lead on EMS-R, a North American, web-based, engineering change management system. Project Lead on EKPI, a North American logistics performance analysis and reporting system. Assistant Project Lead on ePipe, a multi-million dollar global supply chain logistics initiative. See resume for more details!
Certifications and Training
- All
- Certifications
- Badges
Testimonials
I had the distinct pleasure of leading Andrew as part of a team of analysts, data scientists, web analysts and data architects at HD Supply. Without a doubt, Andrew was the strongest coder on the team consistently leveraging his expertise in SQL, VBA, and Tableau to complete complex analysis and reporting in a less than ideal data environment. Further, he has the capability to ingest complex requirements and navigate highly complex data in the pursuit of business answers. Coupling this expertise with his innate preference for mentoring people, Andrew was a critical part of advancing the team's skills and value. His mentor-ship lead directly to the advancement of one of his team mates who had no previous experience in SQL. His skills and accomplishments alone would be enough for someone to recommend him, but there is one other quality that shines through Andrew. He is absolutely dependable. I recommend Andrew with no reservations.
”
Andrew and I worked together at Ballard Designs and, as the "go-to" guy for business intelligence, he was a great asset to the organization. He supported many users with varying skill sets across all departments, and was always excited to help them solve their problems and improve their daily productivity. I think what makes Andrew unique is his mix of strong technical, analytic, and people skills, as well as his proactive approach to his job; if he sees room for improvement in any process, he will seek out the user to discuss, rather than waiting for them to approach him for help. Andrew would be a great addition to any organization.
”
Have you ever met a person who knows a little bit about EVERYTHING? Well, that's Andrew! He's super intelligent, highly analytical and because of his teacher's spirit, he is always willing to help others. Andrew is just an all around good guy. He will be an asset to any company.
”
Andrew and I worked together at Ballard Designs and, as the "go-to" guy for business intelligence, he was a great asset to the organization. He supported many users with varying skill sets across all departments, and was always excited to help them solve their problems and improve their daily productivity. I think what makes Andrew unique is his mix of strong technical, analytic, and people skills, as well as his proactive approach to his job; if he sees room for improvement in any process, he will seek out the user to discuss, rather than waiting for them to approach him for help. Andrew would be a great addition to any organization.
”