Query PostgreSQL database to create bespoke and routine reports.
Automated report generation in Excel using Visual Basic with four input worksheets.
Streamlined invoice creation process, saving accounting team up to 40 hours weekly.
Utilized VBE to automate import routines for new lines, services, equipment, and locations.
Boosted process efficiency through spreadsheet development to enhance tracking and reporting procedures.
Robotic Process Automation Lead
Brightstar
Libertyville
09.2019 - 02.2021
Created RPA program enhancing efficiency within Finance department.
Wrote and updated manual test cases for team use, maintaining optimal organization for maximum productivity.
Designed automation bots to enhance operational efficiency.
Performed regular maintenance checks on existing automated systems.
Financial Systems Analyst
Brightstar
Libertyville
12.2014 - 07.2015
Developed precise process diagrams in Microsoft Visio to enhance process optimization, evaluate automation potential and facilitate necessary audit functions.
Analyzed financial data, identified discrepancies, and provided resolutions for errors.
Collaborated with diverse teams to collect business operations requirements, aimed at enhancing system efficiency.
Captured requirements to facilitate transition to public reporting.
Education
Bachelor of Science - Supply Chain Management Technology
Purdue University
08.2019
Skills
Dashboard creation and data visualization
Data warehousing and management
SQL proficiency
Process optimization
Robotic process automation
Excel and Visual Basic expertise
Zendesk support
Office Suite proficiency
Automated reporting and Excel macros
Hobbies and Interests
Financial Markets
Securities Trading
Computer Building
Technology
Timeline
Reporting Analyst
MarketSpark
06.2021 - 12.2022
Robotic Process Automation Lead
Brightstar
09.2019 - 02.2021
Financial Systems Analyst
Brightstar
12.2014 - 07.2015
Bachelor of Science - Supply Chain Management Technology