John Mollhoff
Data Analyst at DaVita Medical Group- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Experience
-
DaVita Medical Group
-
Hospitals and Health Care
-
200 - 300 Employee
-
Data Analyst
-
May 2019 - Present
Utilizing Business Analyst and Reporting experience to aid in developing People Services/Human Capital Data Analytics to create solutions in Workday reporting and Tableau visualizations. • Streamlined and converted weekly and monthly reporting decks from Excel to live Tableau visualizations. • HR Subject Matter Expert for Workday reporting. Developed monthly and ad hoc reports utilizing Workday reporting tools. • Team development and training of additional analysts in reporting functions utilizing Workday and Excel. Show less
-
-
-
IDR, Inc.
-
United States
-
Staffing and Recruiting
-
200 - 300 Employee
-
Contractor - HR Reporting Analyst
-
Feb 2019 - Apr 2019
Focus on ad hoc reporting in Workday. Provided People Services teammates insight into recruiting and retention data and trends. Data extractions to support on-going People Services projects. Increased efficiency in various monthly reporting initiatives by leveraging Workday Report Writer functionality and process improvement implementation. Aided team members in expanding and better utilizing Workday Report Writer functionality. Focus on ad hoc reporting in Workday. Provided People Services teammates insight into recruiting and retention data and trends. Data extractions to support on-going People Services projects. Increased efficiency in various monthly reporting initiatives by leveraging Workday Report Writer functionality and process improvement implementation. Aided team members in expanding and better utilizing Workday Report Writer functionality.
-
-
-
People2.0 USA
-
United States
-
Staffing and Recruiting
-
1 - 100 Employee
-
Reporting Analyst
-
Nov 2017 - Mar 2018
Reporting analyst tasked with providing final monthly summary and detail for IHS Markit employee data. Provided Finance department leadership with point-in-time snapshots each month of employee headcount and salary data broken out by global region, country and finance department; accounting for all changes to all headcount and financial data month over month. Filtered data and reviewed trends to identify problems with data capture and design. Created ad hoc reports on demand for senior level HR and Finance directors. Show less
-
-
-
Level 3 Communications
-
Telecommunications
-
700 & Above Employee
-
Sr. HRIS Analyst
-
Apr 2011 - Aug 2015
Senior analyst providing HRIS and compensation support, SQL report development, and SQL database maintenance. Created and maintained extensive reporting library to meet needs of fiscal year end, compensation review cycle and ad hoc reporting needs of Compensation and Benefits departments using Oracle SQL and Microsoft SSRS tools to allow users access to data on demand. Transformed existing Access tool for emailing annual employee compensation statements into full-fledged, stand-alone sandbox environment with MS SQL Server back-end. This database housed all compensation and job data to allow the Compensation department to budget and plan entire company’s existing salary, bonus, stock and merit increases. Developed and maintained reporting library of 300+ reports using Microsoft SQL Server Reporting Services (SSRS) to provide Compensation, Benefit and HR Analytics data. Partnered with internal leadership, corporate business partners, and external vendors to provide tools appropriate to support the organization’s employees and goals. Show less
-
-
-
ALTA COLLEGES INC.
-
United States
-
Higher Education
-
1 - 100 Employee
-
IT Business Analyst
-
2007 - Mar 2009
Test lead on multiple successful projects upgrading back end databases and PeopleSoft Student Financials and Administration modules. Database upgrade from Microsoft SQL Server 2000 to Microsoft SQL Server 2005. Database upgrade from Microsoft SQL Server 2005 to Oracle 10g. Front end upgrade from PeopleSoft Student Administration 8.0 SP1 to 9.0. Production Support Created, performed and documented testing of customizations to PeopleSoft modules: Student Administration and Student Financials, and quarterly PeopleSoft Service Packs. Configured and tested year-end tax reporting functionality. Using Microsoft SQL Server, PeopleSoft Query and Cognos reporting tools, created reports for business users. Show less
-
-
-
DaVita Kidney Care
-
United States
-
Hospitals and Health Care
-
700 & Above Employee
-
Sr. Business Analyst
-
Aug 2004 - Jul 2007
Functional test lead during PeopleSoft Human Capital Management system upgrades, customizations, business process improvements, establishment and maintenance of third party interfaces, application of PeopleSoft service packs and import/export of data to accommodate acquisitions and divestitures. Accomplished balanced parallel payroll cycles across multiple environments leading team of 15+ through PeopleSoft HCM North American Payroll upgrade of version 8.8 to 8.9. Directed daily testing from configuration to parallel testing through go live. Created SQL reports designed to run across multiple environments to audit accuracy of data and configuration in each environment. Created and documented business process flow and trained staff in execution of bi-weekly payroll. Created MS SQL and PeopleSoft Query reports to provide all HR and Payroll related data to business during two year period while the company structured and staffed in-house HRIS organization. Show less
-
-