Jennifer Bills Email & Phone Number

Working as a Senior Data Analyst for the state of Wisconsin Department of Health Services, on the COVID Response & Recovery Team

Greater Milwaukee Area

Eight years of Business Intelligence experience designing applications used to collect department program data, with dashboards and KPIs used to fuel leadership decisions.Seven years of data analytical experience designing advanced reports using SQL, SQL Server, SSRS and data warehouses.15+ years of designing databases to support applications and reports.• Created BI applications, that contain dashboards, KPIs, summary visualizations, and detailed data tables. The use of each self-serve application eliminated the need for multiple SSRS reports required by leadership and other customers.• Designed wireframe mockups of potential BI applications for customer approval, thereby aligning customer expectations, and decreasing misunderstandings.• Design data models and SQL based subject area data marts in the data warehouse.• Performed data validation, application design reviews, and SQL based code reviews.• Created templates for BI Application design, that cut application creation time by two days.• Documented company design standards, which allowed the BI developer team to create applications that shared an aligned look and feel.• Created BI documentation templates to standardize information on all production applications.• Started an internal BI developers user group, to facilitate knowledge sharing and comradery.

Greater Milwaukee Area

• Created BI visualizations including dashboards, KPIs, summary graphs and detailed data tables, as well as BI applications that collect and process user data, using relational data models, and star schemes.• Used ETL processes to automate importing data of assorted types, from multiple data sources.• Created SSRS reports using a data warehouse, source marts and subject area data marts.• Write SQL queries that fuel reports, dashboards, and database automation.• Create user stories and design requirements by listening to the customer’s needs. Provide excellent customer service including troubleshooting and creatively solving customer problems.• Provide excellent customer service

Greater Milwaukee Area

• Improved weekly report processing time of Excel reports by 403% through the use of macros.• Designed, implemented and maintained stable Access database applications with SQL Server backends, that were used to collect and analyze data for the agency; including dashboards, KPI’s, and compliance reports used by over 100 staff and leadership.• Collaborated as technical project manager and communication liaison with internal customer and outside vendor to create a new data collection module.

Research grant opportunities for start up company and assistin applying for these grants. Search for applicable grantopportunities, summarize requirements, maintain andorganize documentation, design databases, preparespreadsheets, Gantt charts and proposals.

Greater Milwaukee Area

Systems Administrator for a 22 machine computer with an 11 machine computer cluster. The lab contained computers that ran Mac, Sun and Red Hat Linux operating systems. Responsibilities included software installation, backups, new user accounts, etc. I was also responsible for designing and implementing strategies for automatic daily backups, and information recovery.

Greater Milwaukee Area

Data Base & Information System Manager• Design, implement, modify, document, and maintain internal databases• Provide technical support and training for all computers & software• Design, layout, and produce company literature, education materials, forms and newsletters

Masters

Bs