Data Analyst And Administrative Consultant
• Monitored current business practices, identified points of opportunity, and built customized Excel tools to automate processes for various roles across multiple teams.• Built dashboard files for planning leaders to track and analyze total business across multiple datasets, giving the ability to act on insight, and easily produce automated scorecards.• Compiled data surrounding urgent one-off issues, helping to identify root causes, and generate meaningful stories to drive action from… Show more • Monitored current business practices, identified points of opportunity, and built customized Excel tools to automate processes for various roles across multiple teams.• Built dashboard files for planning leaders to track and analyze total business across multiple datasets, giving the ability to act on insight, and easily produce automated scorecards.• Compiled data surrounding urgent one-off issues, helping to identify root causes, and generate meaningful stories to drive action from relevant company sectors.• Built, automated, and analyzed interactive chart tools, showing instant visual representation of chosen data in a highly intuitive format.• Received Advanced Certification in Retail Solutions Inc. (RSi) business intelligence tools, and trained relevant employees on pulling and manipulating data.• Facilitated the transition of production for national in-store product displays from manual planning to a new internal forecasting tool on a very strict time-line, working closely with Process Leaders at P&G HQ to strategize proper execution of the roll-out. • Built macro add-ons to existing forecast trackers that automatically extract relevant upload data for team members, and set up data validation checks on all display production, comparing original forecasts, DAT, and SAP data. Show less