1-4 times per year I manage a team of 5-9 at a polling facility for the Milwaukee elections; registering and assisting voters through the voting process for my districts and validating poll end totals. Chief 2021-presentInspector 2018-2021

My wife and I wanted to have a booth for local festivals in 2020, however the coronavirus led to most festivals being cancelled. The solution for 2020 was to create an Etsy shop (CraftsMKE) that we manage together, to gauge what sells going into 2021. The Etsy shop turned out to be more successful than we initially thought and has proven to be a lucrative business/hobby.Started selling earrings and shea butter soaps- 2020

Power BILed the design and implementation of Power BI as a self-service business intelligence ecosystem. I created training and documentation resources to support 130 corporate power-users as we migrated out of Cognos. Held office hours to help users with dax, system limitations, best practices, and using certified data models created and maintained by my team.Data EngineeringHelp maintain a SQL reporting environment (views, SPs, schema changes) that feeds into Power BI and SSRS reporting. My team are working to migrate our reporting data sources out of SQL (AWS hosted) and into DataBricks to support the integration of a wider variety of self-service data for business users.Operational SupportWork with our pricing team to automate parts of our pricing process to allow for more a granular and accurate workflow, this has saved the team several weeks each year in providing updated pricing. Work with sales compensation teams to update/create reporting to support sales initiatives and accurate payout for staff.-SQL, Power BI, Python, DataBricks, Terraform, Agile

Developed database architecture (SQL-Synapse) and pipeline (PolyBase) for government housing data including data models to empower machine learning (python & R), self-service analytics, and reporting teams.Updating M-PIRe's Power BI front-end for better performance, fine-tuning DAX and migrating calculations to SQL-Synapse allowing PowerBI to be more "cube" driven and not having complex calculations within the application (dramatically improving UX- reducing front end load times by 90%).Developed python applications to supplement Azure & AWS blob implementations and automate internal administrative tasks-SQL (Azure Synapse, PolyBase), Power BI, Data Modelling, Python, SSIS, Azure Data Factory, Red Shift (AWS)

Database:I built a SQL data lake/warehouse (DLW) with central IT to support internal audit testing and internal reporting. The server current incorporates 10 automated feeds (SSIS & SFTP) with ~133 tables to support corporate audit functions. Product data is segmented in a separate container firewall, and requires physical authentication before data can be processed, there are 3 databases in the DLW that work this way and they are used for scripted-procedural testing of a product's data assets. Internal Reporting:I have rebuild internal audit reporting from manual processes to fully autonomous, using SMTP & Power BI as delivery methods. Reporting consists of 42 stored procedures, 31 SMTP stored procedures, and 5 Power BI reports (updated via PBI gateway) that provide management custom alerts as well as static email and dynamic Power BI reporting for everything from timesheets, project milestones, and individual user contributions. This also supports bi-monthly company-wide and quarterly audit committee reporting of open audit issues.Audit Support:Aside from my data access- I also import, normalize, join, aggregate, and summarize data provided to me by audit teams to fulfill more complex "big data" testing or provide answers to have more meaningful conversations with management. Where applicable I serve as a subject matter expert and train staff on self-service access to data and tools. My access and expertise has led me to supporting 23 audits in 2019 (~22% of all audits in 2019) in this fashion. I've also automated data entry with Powerapps (& Flow) and Power BI inventorying with PowerShell, and help other teams throughout FIS.-SQL, Power BI, Data Modelling, Data Analysis, DBA, DevOps, SSIS, PythonSpecialist 2020, Senior 2017 - 2020

I Developed and managed 14 data models and cubes for reporting, validation, and research ranging in Qlik Sense from tax records, underwriting, claims, storms, and data collection/generation. I also developed an application in Qlik for the Building Cost Database that improved product development team performance by 15%. I also updated an application used in validating monthly closes which was more in tune with what the users needed and lead to a more than doubling the productivity over the previous Qlik application.I researched industry trends and explain anomalies within our database for RFIs from clients like Liberty Mutual and All State, my research also lead to product roll-out decisions regarding data integrity for national updates for commercial underwriting.I helped founded and moderate the corporate engagement committee that plans and hosts office events throughout the year where I developed a mobile app with MS Power BI for budgeting.-Qlik, SQL, Power BI, Data Modelling, Data Analysis

I opened an Amazon store front because I had gotten involved with Chinese and American wholesalers and wanted to see how the other half of Amazon operated.I started out with 24 pins, I was dissatisfied with selection currently listed and wanted a higher quality product that could still be sold competitively. Within 2 weeks I sold all of my entire inventory. After some distribution limitations I stepped away from selling products.

I freelance to keep my MS Excel skills current and to see what other users are demanding and how I can best utilize and implement these demands.I work with international clients and help them find solutions in MS Excel. Projects predominantly include vlookups, nested if statements, text format functions, user form controls and VBA macros.I have created a budgeting spreadsheet that uses user forms and VBA marcos to help the user input income and expenses. The spreadsheet also uses ActiveX drop-down menu controls for the user to cycle through expenses report charts. Other noteworthy project include a roulette odds calculator, gauge charts, a time card tool bar, a retirement calculator, an excel proficiency exam, and a stock short trade revenue calculator.-MS Excel

I create reports using SAP Crystal Reports and SQL server management studios to retrieve data from our SQL servers, I use custom formulas and cross tabs to create reports and fulfill ad hoc requests.I am currently in the process of creating dashboards (in Tableau) for the Uniform Crime Reporting (UCR) major crime categories, as well as officer activity. These boards are interactive and used for self-service data. They are supported by SQL queries automated through a batch file.I designed, automated, and manage the Complaint Statistics (CompStat) reports that are used by administrative command staff every week to discuss crime trends and focuses on violent crime and proactive activity. This report contains over 84 charts and graphs that are linked to an excel file where data can be pasted from a Crystal Report cross tab, this excel file contains VBA macros and formulas that automate the formatting of all of the custom chart designs. The macros are also used to link Powerpoint files to new Excel files as well as prepare the Excel document for new data. These meetings cost tax payers between $300,000 and $750,000 annually.I automated officer performance measure reporting system in MS excel using VBA macros, this code creates Johari windows using an algorithm that assigns officers based on their metric's deviation from the median of the data. I also created an algorithm that unbiasedly rates officer activity based on the statistical deviation of their performance metrics.I reengineered an Aoristic Analysis algorithm that is used by other police departments that captures time of day, day of week data for crimes that do not have explicitly recorded time of occurrence but rather a range: such as burglary and auto theft.Specific projects and reports may be confidential to the public.-MS Excel, Crystal Reports, SQL, Cartography, Data Analysis, Tableau, MS Publisher

I generate and distribute reports for regional sales management in order to maintain sales quotas and customer consideration. I also extract and reformat data from our SQL servers for data mining which is utilized by our sales teams and management. I created a QR code inventory system that increased inventory management efficiency by providing a standardized process for internal usage; this system reduced manual inventory from weekly physical counts to monthly control counts.I created a market analysis looking at countries within the BRICS and MIKT with a focus on NAFTA countries, the analysis focused on future growth prospects for the agriculture and construction industry.I created a projection model for sales quantities for core equipment categories using a linear model and historic fluctuation potential. Core equipment categories were based on key customer purchase pattern statistics.-Marketing analysis, research, MS Excel, SQL, Tableau

I use geospatial analysis to help clients find the optimal location for their business as well as more efficient marketing strategies that better target their demographic. I also appraise commercial and residential real estate, base on weighted average cost of land and home value, for individuals and private investors.-Cartography, research, appraisal, MS Excel, spatial analysis, and real estate analysis

I performed in a music ensemble that played for sporting events, on the Carthage College campus, as well as various campus events. I manage band members, musical repertoire, and aid in finalizing payroll and staffing for this organization. I typically managed between 20 and 60 instrumentalists during any given performance.-Management, organization, and performance

Probit and OLS regression analysis of the health effects of income and wealth in the US between 1999-2011.Final research was be presented at the National Conference of Undergraduate Research in April 2014. and publish in the 2014 Carthage Vanguard (Volume 1 Issue 1 pg 131) found at http://carthagevanguard.com/wp-content/uploads/2013/10/Vanguard_Volume1_Issue1.pdf.-Research, data analysis, MS Excel, Stata

Training employees as well as taking and completing orders. I also worked in a management capacity during high volume and when working at newly opened locations.-Customer service, management, and teaching