Jacob Shoemaker Email & Phone Number

Omaha, Ne, Us

Chicago, Illinois, Us

Associate Business Services Analyst, Business Intelligence & Analytics (July 2022-Present)Presented expert-level Power BI training to 20 financial analysts and recommended individualized solutions as neededFunctioned as company-wide SME for Power BI to consult for business users and find resolutions to complex business requests Developed fully interactive transportation finance tool using PowerApps to visualize and implement cost-saving measuresCollaborated within Agile development team to provide Power BI dataset configuration related to strategic investmentsEstablished documentation for legacy finance tool in order to guide process improvement with development teamAutomated delayed shipment reporting in SAP in order to promote cost saving measures within transportation financeAssociate Business Services Analyst, Data Management Organization (July 2021-July 2022)Directed 8+ offshore IT contractors as functional escalation point and SME to facilitate solutions, lead training sessions, and proactively identify process improvement opportunities Translated raw transactional data into interactive Power BI report to drive monthly discussion with internal audit and other stakeholders regarding unauthorized changes to critical data fields within SAP Reduced payment reporting errors by automating data extraction from multiple systems, saving 100 resource hours/year Constructed 12 real-time, in-tool guidance systems to replace traditional tutorial documentation and increase digital adoption using WalkMeOrganized department wide training for tools and data validation standards reaching 120+ business users over 12 months Created standardized ETL method to display data for 40,000+ products at a brand level to aid business decisions related to divestiture activitySelected to join 5-member Global Business Services and IT rotational program to gain business exposure, transitioning to the Business Intelligence & Analytics organization

Lincoln, Us

Created interactive Tableau dashboard to visualize trends in performance over 2021 season for women’s basketball team• Prepared Tableau visualizations of offensive efficiency for 14 Big Ten teams and presented insights to inform team strategy• Implemented linear and logistic regressions to quantify shot quality and determine significant variables in offensive success• Debugged and improved web scraper to integrate with updated website, produced 30+ scouting reports for coaching staff• Automated data ETL activities with R to increase quantity of baseball scouting reports produced daily by 300%

San Francisco, California, Us

• Coordinated presentation to management regarding application of data reliability in high-risk analytics• Facilitated communication and documentation with line of business for $11 million financial remediation• Evaluated SQL and SAS code to ensure accurate population identification of home loan customers

Lincoln, Ne, Us

Louisville, Kentucky, Us

• Created Excel-based dashboards to monitor performance of ticket sales team throughout the summer• Produced 30+ fan activation campaigns to collect data-driven insights about potential ticket buyers• Supported SeatGeek SRO database operations consisting of CRM information, reports, and access codes

Kansas City, Missouri, Us

• Completed conversion of 250+ server nodes from Red Hat to Oracle Linux to meet licensing regulations• Developed and tested various KornShell automation scripts to eliminate 75+ JIRA requests per quarter• Conducted audit of cron to reduce sway across all Tier 1 environments and ensure control

Falls Church, Virginia, Us

• Coordinated the Agile business requirement elicitation process with representatives from the client, QA, and development• Analyzed current processes being used for company’s Agile development and provided documentation and recommendations• Executed metadata transfer using Excel to be used for continuous web based application development

• Performed daily tasks of running an after-school childcare operation such as indoor and outdoor activities• Resolved interpersonal conflicts between children on a regular basis and reinforced positive behavior• Volunteered 11 hours of extra time to further skill development

• Created and executed weekly practice plans, individual game tactics, and time management strategies• Oversaw and contributed to the basketball development and sportsmanship skills of each player• Evaluated individual and team performance to determine playing positions and team combinations

Master Of Arts In Business, Intercollegiate Athletic Administration, Business Analytics

Bachelor Of Science - Bs, Management Information Systems, Data Science

Business/Commerce, General

High School Diploma