Bill Wunsch Email & Phone Number

Chicago, Illinois, United States

● Work closely with the Client Success team to understand client needs and map data elements from reports to data models● Researching data issues to find and correct root cause using various data analysis and data profilingtechniques.● Created Python script to connect to a SQL database and extract data, aggregate, and summarize it across the client organizational hierarchy into Excel reports saving the Client Success team 6-10 hours of work.● Work closely with senior leaders to generate internal KPI reporting dashboard using SQL and Power Query.● Built ETL process in SSIS to load client files from SFTP sites and track changes in the files over time.

Chicago, Illinois, United States

● Automate client and internal reports and processes using a variety of technologies including SQL, SSIS,Excel VBA, Power Query, Access VBA, and SPSS syntax.● Work closely with Client Success team to design, test, and implement reporting solutions within online reporting platforms.● Design data pipeline to ingest, clean, update, and load client files into online reporting platforms using SSIS and SQL.● Design and generate online reports used by Client Sucess and Field Operations teams to monitor project progress and KPIs.

Chicago, Illinois

• Build efficient tools and processes in SPSS, Python, Access and Excel VBA used to reduce time and effort required to generate survey reports and data QA.• Create SPSS and Python syntax to reduce the need for eight separate survey report creation processes into one.• Handle competing tasks on the same timeline while still maintaining a high level of quality and ensuring data accuracy and reliability.

Rolling Meadows, Il

•Managed several Fortune 500 companies’ Employee Engagement surveys on concurrent timelines. Served as the primary point of contact for clients during project planning and execution. Responsible for maintaining timeline, ensuring projects stayed on budget, and within scope. •Utilized SPSS, Access, and Excel to increase accuracy and efficiency in report processing and quality assurance. Reduced time to QA reports from 2 days to ½ day. Developed SPSS with Python syntax and Excel VBA to produce and format 5,000 reports in 4 hours, reduced from standard processing time of 10 hours. •Organized and analyzed large and complex data sets with over 250,000 cases to create reports for senior leaders. Built Access database to translate, clean, and process 400,000 comments.•Hired as an Associate Client Advisor and promoted to current position within 2 years.

Bloomington, Indiana

• Facilitated nation-wide survey for the Strategic National Arts Alumni Project obtaining satisfaction information from alumni of 160 high schools, colleges, and universities. Transformed written questionnaire into survey programming specs and tested skip logic, version control, and accurate information merge. Upon survey completion, transferred data from SQL Server to SPSS data file.• Managed Indiana University UITS Web Survey across five IU campuses, measuring student, staff, and faculty IT satisfaction. Created survey project plan and acted as liaison to the Director of IT Services. Provided weekly status updates, addressed ongoing project concerns, and clarified survey requirements.• Developed phone questionnaire and designed sampling strategy for Cumberland County Schools to determine parent satisfaction. Created training documents for phone interviewers, detailing how to administer the survey and the goals of the project.• On various timelines, managed and sent out survey invitations for 80 law schools participating in the Law School Survey of Student Engagement. Created and trained project assistants on how to appropriately respond to law school student email responses.

Full Stack Web Development Coding Boot Camp, Web Development

A six month, full stack web development certificate program through Northwestern University. Focused on the MERN stack using Mongo.

Master'S Degree, Sociology

Bachelor Of Science (B.S.), Sociology, Magna Cum Laude