Joshua T. Boike

*** ****** **. ******** **, *****

+1-248-***-**** # adz4c5@r.postjobfree.com ï linkedin.com/in/joshuaboike Education

University of Pennsylvania March 2022

Master of Computer and Information Technology Philadelphia, PA University of Michigan, Stephen M. Ross School of Business April 2017 Bachelor of Business Administration, Specialization in Analytics Ann Arbor, MI Technical Skills

Tools: Tableau, Power BI, Looker, Qlik Sense, QuickSight, Snowflake, AWS, Azure, Informatica, Power Automate Languages: Python, SQL, DAX, Java, C++, VBA

Experience

ArcX DataWorks April 2021 – Current

Contract Business Intelligence Developer Detroit, MI

• Acted as full data life-cycle partner to over 12 clients (incl. Square, Tidal, Carl Jr.’s), leading enterprise BI development projects from conception to deployment, creating reports with >90% stakeholder utilization and realizing up to $2M in financial benefits

• Recruited and led a multi-disciplinary team of developers, data engineers, QA engineers, UI/UX designers and graphic designers to ensure functional area expertise across all project dimensions; using technologies such as Tableau, Power BI, QuickSight, SQL, and Snowflake

• Leveraged billions of rows of transaction data to create next generation of reporting products for NY-based insights firm, helping client bring in over $100,000 in new revenue from selling product licenses

• Helped medical marijuana start-up implement BI infrastructure and strategy in AWS and QuickSight to create a series of KPI dashboards to track financial performance

City of Detroit March 2022 – December 2022

Advisor & BI Developer, Special Data Projects Detroit, MI

• Led requirements gathering and development of special data initiatives, coordinating with over 20 different departments to develop city-wide data governance policies, PII policies, data inventories, and key KPIs

• Acted as the city’s internal advisor for data visualization projects, as well as other automation pipeline and ad hoc analytics requests

• Managed team of developers to create impactful Tableau, QuickSight, and Power BI reports, both for public and internal use, using SQL, Python, Snowflake, and AWS Deloitte Consulting LLP April 2017 – April 2021

Sr. Business Intelligence Consultant Chicago, IL

• Spearheaded Deloitte’s internal HR analytics initiative, guiding a cross-functional team to develop database management requirements, ETL pipelines, key metrics and dynamic Tableau dashboards to empower executive decisions around national talent sourcing

• Created series of executive-level Power BI reporting dashboards and underlying SQL and Snowflake ETL pipelines for a $7 billion food distributor to isolate key drivers of revenue and volume change by branch

• Developed Python and Tableau model for the calculation and reporting of a $100 million-dollar financial benefit, continuously improving calculation methodologies to increase accuracy of reported benefit figures by millions of dollars

• Created suite of VBA automation scripts to enable automated reporting for a New England hospital system Apple, Inc. April 2016 – Oct 2016

Finance Analytics Program Cupertino, CA

• Built bridging models in Tableau to isolate key drivers of variance between actual and forecasted shipping costs for new products, allowing users to understand what proportion of cost variance was explained by changes in different inputs Visa, Inc. May 2015 – August 2015

Project Analyst Intern Foster City, CA

• Designed VBA scripts for Ops & Infrastructure team to automatically update and track server migration processes