Michael Gospodarek Email & Phone Number

Arlington Heights, Il, Us

Arlington Heights, Il, Us

Lake Forest, Illinois, United States

Financial Analyst in the Financial Development Program:Year 1: Internal Audit- Performed the following audits as a part of the IT Audit Team: Identity Access Management, License Compliance, Purchasing-Card, Electronic Data Interchange, and Officer Travel & Expense- Identified various deficiencies/gaps in controls across these audits- Recommended action plans that mitigate company risk exposure through: --> prioritizing identity access integration based on system criticality--> resolving a password configuration error--> renovating software vendor risk assessments--> improving license compliance monitoring--> enforcing customer upload of specific pricing files--> updating relevant company policies--> investigating more efficient customer pricing exchanges--> refining necessary validations for customer pricing--> building live feed view of spend on provisioned cards

West Lafayette, In

- Took a semester off during the COVID-19 pandemic.

Lake Forest, Illinois, United States

- Streamlined the monthly labor capitalization journal entry preparation and reporting process to increase efficiency and save time in subsequent months- Transitioned a previously 4-6 hour monthly process down to a 1-3 hour process (Power Query)- Automated the clean, merge, and calculate phases of a process across 8 files (Power Query)- Implemented a custom function to clean name data to achieve data consistency (DAX)- Improved matching algorithm with custom lookup logic (DAX)- Learned how to create custom dashboards (Power BI) using table connections and cardinalities

Chicago, Illinois, United States

- Processed customer information, transactions and updates- Input collected data into company systems- Generated reports as required by the department in accordance with outlined standards- Maintained confidentiality of all information- Confirmed, corroborated, and removed unnecessary data, or combined data from several sources- Worked collaboratively with others in the department- Met productivity metrics as assigned by the department

Racine, Wisc

- Accurately handled cash transactions from daily operations- Operated lawn machinery to increase the physical appeal of the park grounds

Bristol, Wisconsin

- Created, organized, and managed simulation activities for players- Effectively distributed responsibilities with coworkers to operate the field