Joseph Musto Email & Phone Number

United States

• Lead a scrum team of 10 analysts and developers utilizing agile methodology to deliver new features for an analytics system that calculates the variable profitability of each vehicle sold by GM• Oversaw the development of a Power BI dashboard that leverages accessory sales data sourced by a PySpark script to display monthly accessory billing revenue and cost for the U.S. Pricing Team• Created a Power BI dashboard that enables users to effectively stock EVs in regional fulfillment centers to optimize dealer inventory resulting in a $2,000 per vehicle reduction in incentive spend• Managed integration of new SAP S/4 Hana incentive claims processing and payment system for all U.S. vehicles into data lake enabling incentive spend analysis critical to downstream applications• Provide technical support as the subject matter expert for 200 finance users in the U.S. and Canada through quickly resolving bugs and updating country-specific reports boosting user confidence

Austin, Texas, United States

• Developed a Power BI dashboard that identified where to stock electric vehicles based on demand and profitability allowing GM to grow its EV market share while ensuring customer availability• Led 5 teammates throughout the integration of a new SAP S/4 Hana EV billing and incentives system into the company’s data lake establishing profitability analysis essential to GM’s EV growth• Implemented DevOps methodology for BI Development Team through leading weekly on-call rotation and creating troubleshooting documentation resulting in 100% bug closure before SLA

United States

• Created a proof-of-concept Power BI dashboard that determined where electric vehicles with specific configurations should be stocked and demonstrated the dashboard to the Global CIO and IT SLT• Improved user experience through optimizing financial reports by moving SQL executed in Cognos to the database as materialized views decreasing report run times by an average of 10 minutes• Built a Power BI dashboard for the Pricing Team that analyzed regional sales trends through allowing users to input 20,000 vehicle ID numbers and see exactly where those vehicles were sold on a map

Austin, Texas Area

• Migrated assets such as tables, views, and ETL jobs from the legacy reporting database Teradata to a new open-source solution Greenplum saving the company $20 million in subscription fees• Developed an automated batch processing job using Hive SQL and IBM DataStage allowing finance partners from the Andean region of South America to analyze revenue data for every vehicle sold

Atlanta, Ga

Indianapolis, Indiana Area

Master Of Science - Ms, Information Systems

Certificate in Business and Technology

Economics

Activities and Societies: Mens Lacrosse Team

Executive Mba