Kevin Lamp
Hoffman Estates, IL 60192
****.*******@*****.***
Professional Experience
• Professional and articulate IT-focused Analyst with a passion for utilizing technology to create insightful Business Information Analytics that maximize organizational and/or systems level optimization
• Offers an educational and professional background that is concentrated in data analysis, data warehousing, database development, reporting, data virtualization and data analytics
• Certified Microsoft Office Specialist in Microsoft Access, Word, PowerPoint and Excel
• High level of proficiency with various statistical platforms, including Minitab, JMP and Tableau Technical Skills
• SQL Server (SSMS, SSRS, SSIS, SSAS) • Microsoft Access • SQL, T-SQL
• Microsoft Visual Studio • VBA coding • HTML coding
• Advanced Microsoft Word & Excel • Microsoft PowerPoint • IBM SPSS Modeler
• Minitab Tableau JMP • Lingo • Salesforce
Professional Experience
Links Technology Solutions, Inc., Schaumburg, IL January 2017 – Present IT Analyst
• In an effort to combat childhood obesity, Links partnered with Alexian Brothers to develop an app that monitors physical activity. Responsible for user testing, general set-up and administration of permission controls on all Verizon Wireless units that were provided to youths participating in the program.
• Conduct user testing to assess the overall performance and functionality of Florida PGA’s mobile app and cross-reference staffing page data from their current website to ensure alignment with the app.
• Work in conjunction with Links’ Website Business Development team to provide analytical insights to existing customers, Reflejos (a Chicago Newspaper outlet) and Chicago Haymarket Center (drug/alcohol addiction rehabilitation center). Created reports designed to analyze trends in current website traffic and determine the drop-off points in terms of user engagement. JMP, Tableau, MS Word.
• Work with Links’ Creative Director to analyze performance analytics related to various email marketing blasts in order to determine the efficiency of each campaign. Excel, JMP, Links proprietary software.
• Complete service performance reports to determine overall health and performance of Links’ Windows servers and to identify potential opportunities for optimization.
• Wrote complex SQL queries to analyze real estate market activity in various Southern California areas in order to evaluate individual real estate agents’ performance as compared with overall market performance. SQL, Visual Studio, SQL Server, JMP, Minitab, Tableau.
• For the Denver Police Dept., worked with a team to complete data virtualization and data analysis to determine whether there was a marked increase in crime-related activities when Denver Broncos played games at home. MS Access, Excel, JMP.
Kevin Lamp
1362 Caribou Lane
Hoffman Estates, IL 60192
****.*******@*****.***
2
Professional Experience (continued)
Links Technology Solutions, Inc., Schaumburg, IL June 2014 – December 2016 Intern
• After obtaining an in-depth understanding of the product, I served as Level I support for the company’s cutting-edge eTariff submission software Tariffshark. Tariffshark allows oil and electric companies to import all their quarterly records in order to comprise an entire portfolio of transactional data that can be submitted to the Federal Government.
• Served as a liaison to new clients, offering support to company employees and attorneys in submitting records or migrating vast amounts of data into Tariffshark Fabbrini’s Flowers, Hoffman Estates, IL June 2011 – December 2014 Sales Representative
• Assist customers in placing in-store and phone-based orders, manage storefront watering schedule, design floral arrangements and coordinate event set-up for graduations, weddings, dance recitals, etc.
• Create and maintain Excel spreadsheets designed to monitor inventory, log pricing for arrangements and to generate annual reminder calls to past customers to inquire about interest in repeating previous orders Education
• Bachelor’s Degree in Business Information Analytics, University of Denver, Denver, CO – 2017
• Additional coursework included: Evolutionary Biology, Accounting, Finance, Statistics, Management, Spanish, Economics, and International Studies
Additional Information
University of Denver Club Baseball September 2013 – June 2017 Member
As a member of the club baseball team at the University of Denver, actively involved in coordination of fundraising events. Our club hosted bake sales, wiffle-ball tournaments and, perhaps the most important fundraising event for the club, The Joe Lubar Memorial Golf Tournament. This tournament is held every year by the team in order to honor a former player who tragically passed away in a skiing accident. Southeast Denver Baseball League April 2017 – June 2017 Head Coach
On a completely voluntary basis, served as Head Coach for Southeast Denver Little League baseball team for the 10-12 year old age division.