Jonathan Allen Email & Phone Number

Madison, Wi, Us

Madison, Wisconsin, United States

(this was originally a change of position in Dean Health Plan in 2020, and then Dean was acquired by Medica in 2021)• Automated base tables utilized by the team for all analysis work using SQL stored procedures andcontinually updated code to incorporate needs.• Developed and maintained self-service dashboards for customers in Power BI.• Collaborated with customers to understand reporting needs and explored the best options to meetthem.

Madison, Wisconsin Area

(initially hired as a contract position through KForce, then hired as a FTE in 2019)-Plan and develop reporting solutions using BusinessObjects and SAS based on requirements and standards within an Agile framework-Build and maintain SAP BusinessObjects universes to coordinate with DHP initiatives and needs-Teach and support report developers and users across the organization to better leverage the available reporting tools-Fulfill duties as administrator of SAP BusinessObjects and SAS

Madison, Wisconsin Area

-Create reports in Business Objects, SAS, and SQL to support Sales, Marketing, and Underwriting-Improve process efficiency and accuracy by automating data crunching using R-Document new and existing processes and procedures such that they could easily be reproduced

Madison, Wisconsin Area

-Supported our software and SQL database remotely using GoToMeeting and GoToAssist. -Used SQL Server Management Studio and Microsoft Access to run queries to maintain database and complete requests. -Designed and troubleshot reports that pull from the database (either in Access or Report Designer)

Madison, Wisconsin Area

-Organized preparations for credit unions we served to be ready for product implementations-Communicated effectively with designated staff at customer credit unions, from CEOs to front-end lending staff via email, phone, and WebEx-Tracked progress of implementations using SharePoint and MS Excel to pull out useful data-Worked with sales teams and development teams to balance the implementation schedule and meet the unique needs of each credit union

Madison, Wisconsin Area

-Leveraged knowledge of SAP in order management and reporting -Spearheaded the processing and delivery of over $50 million in orders in a year -Managed the SAP side of 45 different customer accounts; my largest being Kohl’s and Macy’s -Obtained Kohl’s Supply Chain Certification for accuracy and fulfillment of orders within our team, allowing for fast-tracked shipments and lower costs

Madison, Wisconsin Area

-Supported Kaiser Permanente NCal (Northern California) with 4 other team members; a region with over 3 million health plan members -Equipped Premier Health Partners (Dayton, Ohio) for an upgrade to EpicCare 2007 -Troubleshot software issues both on client side and system (cache) side -Completed an extensive clean-up of items for Clarity Reporting, with 5 other team members, allowing for much more accurate data analysis

Data Analyst Nanodegree, Data Analysis

2-term online course where I learned to use Python, R, SQL, and Tableau to explore data, find insights, communicate my findings.

Ba, Mathematics And Physics

Activities and Societies: Choir, Physics Club, Outreach, Campus worship, Ultimate Frisbee, worked at the climbing wall.