Lukas Johnson Email & Phone Number

Minnetonka, Mn, Us

Minnetonka, Mn, Us

Greater Minneapolis-St. Paul Area

Plymouth, Mn, United States

Greater Minneapolis-St. Paul Area

Greater Minneapolis-St. Paul Area

• Consolidated multiple budget reports to build a dashboard view of key metrics across several business units• Extract membership and claims data using SAS SQL code and communicate results internally and to external providers• Automate SAS programs to increase report creation time• Improve existing reporting to include interactive data visualization capabilities to better communicate with senior leadership

Greater Minneapolis-St. Paul Area

• Communicate with executive client stakeholders to design, build, and maintain reporting models while providing consultative support to interpret results and provide action steps as needed• Centralize multiple data sources using PowerBI, PowerQuery, and PowerPivot to create visually appealing dashboards that provide KPI’s and savings opportunities to Fortune 500 clients• Maintain compliance of data quality by working closely with local operations teams to identify and correct issues• Improve processes for monthly recurring reports to automate manual jobs creating more time available• Solve business problems by delivering complex analytical projects investigating key drivers in areas such as policy compliance, demand management, and supplier management

• Lead an organization wide analytics project analyzing over 36,000 coaches and athletes to provide insights on how to improve participant retention and decrease expenses• Created a college internship program and manage two interns that support several event management functions• Manage 33 teams with over 1,500 athletes to communicate and organize essential information • Organize and train over 5,000 event volunteers to execute over 20 Special Olympic Games per year

Greater Minneapolis-St. Paul Area

• Performed third party information security assessments for a Fortune 500 bank resulting in regulatory compliance• Analyzed multi-million dollar network circuit invoices versus a third party contract resulting in process updates that saved the client thousands of dollars• Conducted information security assessments providing guidance on how to improve current state maturity for a Fortune 500 restaurant to protect the environment from threats and vulnerabilities• Created an integrated compliance framework synchronizing multiple information security frameworks (ISO 27001, NIST 800-53, and PCI 3.1) into a single work program to improve testing efficiency• Executed IT control and SOX testing around user access and provisioning for a Fortune 500 utilities company to produce external audit regulation compliance

Minneapolis

• Analyzed large data sets and utilized predictive analytics to recommend future risk mitigation strategies• Conducted IT risk management assessments and processed results in a gap analysis• Tested client document controls and created process maps accordingly• Created and customized an interactive website using Microsoft Sharepoint

University Of Minnesota Twin Cities

• IDSC 3001 introducing 400 undergraduates to various Information System Concepts• Hold weekly office hours aimed to provide a resource to answer any and all questions• Introductory Engineering course required for all incoming freshmen• Responsible for a class of 40 students to complete an assortment of engineering projects

Hopkins, Mn

• Prepared monthly meetings consisting of 24 CEO members producing meeting summarizations• Distributed necessary reports and key metrics to all members and notify them of future events and opportunities

• Taught various analytical concepts to division I athletes with maximum efficiency