Data Analyst Sales

Joshua G. Kennedy

McFarland, WI ***** ********@*****.*** Cell Phone 563-***-****

Business Data Analyst

Meticulous and insightful business data analyst with extensive experience developing custom spreadsheets and specializing in complex analysis and data mining. Expert at providing recommendations to field leadership based off data driven occurrences.

VALUES OFFERED

Data Analytics Project Management Analytics Automation Performance Metrics Sales Operations Statistical Modeling

Strategic/Tactical Planning Data Visualization Dashboards Team Building

Core Skills: Power Bi, Tableau, SAP Business Objects, SQL Database Queries, Excel, Outlook, Power Point, IBM Watson Analytics Certified Trainer, Word, VBA, SPSS, R, Epic Data Warehouses, Windows 10, Internet Explorer, and Firefox.

Professional Experience

UnityPoint Health-Meriter, Madison, Wisconsin, December 2016 – July 2020

UnityPoint Health-Meriter is the nation's 13th largest nonprofit health system and the fourth largest nondenominational health system in America.

Business Analytics Analyst II:

•Lead the creation and deployment of Tableau analytics dashboards for the ER, Operating Room, and Perinatal service lines which provided hospital leadership KPI insights into business and demographic occurrences that were previously not tracked and managed. Presented these findings in weekly, monthly, and quarterly cadence meetings.

•Primary focal for obtaining and mining healthcare data from the EPIC EHR data sources that were used for improving patients’ care coordination and experience.

•Obtained and statistically modeled LABS claim and provider data that were used for hospital rate setting and identifying payer mix profitability.

•Gathered and documented business requirements for physicians on various adhoc analytic requests to improve clinical outcomes and experience. Conducted interviews and prepared prototypes to get requirements from these stakeholders.

•Performed GAP analysis for the Central Scheduling team by producing Tableau dashboard productivity metrics to improve call center response times.

•Validated SAP Business object queries with knowledge of SQL to automate data extractions for analysis on behavior health providers.

•Automated financial reporting for the ER/OR/ Perinatal service lines by using statistical trending in Excel and Tableau.

SELECTED ACHIEVEMENTS:

•Became thought leader of Finance and Analytics department by proactively learning Optum One and obtaining patient data which was used for patient outreach decisions for the Meriter Foundation Fundraiser which increased revenue by $25,000.

•With VBA in Excel, automated the data calculations for my ER, Operating Room and Perinatal Service Line data feed into PowerBI and saved the company .5 FTE.

•Built Tableau heat maps on ER patient volume that provided ER management more cost-effective methods for staffing.

American Family Insurance, Madison, Wisconsin, January 2016 – December 2016

American Family Insurance is a Fortune 500 insurance company and its core values focus on honesty and customer centricity.

Sales Performance Analyst:

•Produced monthly reports on competitive insurance market index by United States zip code.

•Performed transfer attrition reporting that was used in the monthly sales business review that determined values of agent book of business transfer between retired and terminated agents and subsequent attrition rates by month.

•Delivered sales ad-hoc analysis and reports in timely and accurate fashion.

SELECTED ACHIEVEMENTS:

•Used statistical formulas in Tableau to automate 500 agent sales scorecards into one consolidated dashboard and saved company .2 FTE.

•Performed analysis that determined historical perspective on agent book of business transfer for district consolidated and presented to senior management, which resulted in determining production in districts that no longer exist.

IBM, Dubuque, Iowa, November 2011 – December 2015

IBM leads in the invention, development, and manufacture of the industry's most advanced information technologies.

Delivery Analyst:

•Created and executed numerous Excel data queries for diverse business requirements to help management maximize knowledge of operations and forecast future needs and activities.

•Analyzed workload data across 43 customer accounts for four delivery teams to drive quality improvement with Defect Prevention techniques, such as Root Cause Analysis (RCA), Service Level Agreement analysis (SLA), and Problem Code Mapping. Also utilized advanced text analysis tools and extrapolated methods to identify common themes for continual improvement.

•Applied problem solving techniques such as Value Stream Mapping (VSM) to identify waste in processes and work with teams to develop project action items for solution, prepare metric and process behavior updates for executives. From there, constructively tracked project plans to drive solutions for improved business results.

•Actively share client value success stories to senior leadership using Microsoft PowerPoint.

•Lead weekly cadence meetings with senior leadership to discuss pool productivity and key performance indicators and project status of team continual improvement efforts.

•Produced Value Stream Mapping analysis and workflows to identify waste and reduce process cycle times to improve SLA resolution of incident tickets.

SELECTED ACHIEVEMENTS:

•Proactively learned Watson Analytics and then worked with key leadership, stakeholders, and executives to develop an automated dashboard for 3rd line managers’ key business efforts and workload forecasts focusing on project status by dollar and project hour. This automated solution saved senior management .5 FTE.

•Identified tool issue through common cause Pareato Analysis. Engaged all applicable stakeholders and collaborated with team to map end to end project process. Identified all wait and touch times, budgets, and pain points. Collaborated with team and identified training issue with team and engaged the customer to pay for training that resulted in bringing up the overall project time by 7.33 days per project with savings of an estimated $55,000.

US Cellular, Dubuque, Iowa, October 2009 – November 2011

US Cellular is the fifth-largest wireless telecommunications network in the United States, serving 4.76 million customers.

U.S. Cellular, Service Technician

•Diagnosed and resolved complex data wireless issues for in-store customers within a timely manner.

•Utilized cellular inventory database for tracking customers repaired phones, and ensured inventory was accounted for auditing purposes. Also followed company policy for maintaining data information confidentiality.

•Communicated daily with agent locations on the best customer problem resolutions and updated software on merchandise to be sold.

•Proactively designed an analysis method to track parts and inventory, and communicated those results weekly to management.

SELECTED ACHIEVEMENTS:

•Identified cyclical trends in inventory and parts usage. Engaged management and based on analysis encouraged them to order the needed items at the right time, ahead of time. This resulted in a 45% increase in having the needed parts available for repairs.

•Proactively installed needed phone upgrade software on all store computers to have software installation stations at all locations in store. Improved store technician surveys by 10% during the software release.

EDUCATION AND CERTIFICATES

UNIVERSITY WISCONSIN - PLATTEVILLE,

Bachelor of Science, Business Administration: JULY 2009

Paul Tourley, Power BI Expert Level Certified: APRIL 2017

IBM Watson Analytics Expert: SEPT 2015

Contact this candidate