Jack Monger

Experience

• 

  Textron Aviation

  May 2018 - Aug 2018

  Business Analyst Intern

  • Developed an individual project involving demo flight schedules with Power BI, used by the VP of Sales and Marketing.• Collaborated with other interns to create a company-wide IT One-Stop-Shop utilizing SharePoint.• Discussed implementation of IT One-Stop-Shop with senior leadership, resulting in greater communication skills.• Reviewed strengths and weaknesses with manager through biweekly meetings. • Implemented a research matrix used to evaluate software for multiple internal departments. Show less

• 

  South Bend Community Schools Corporation

  May 2019 - Aug 2019

  IT Intern

  • Analyzed the use of, made changes to, and suggested improvements for newly implemented help desk and work order ticketing system called Incident IQ.• Worked in a team to generate ideas and communicate with stakeholders at SBCSC and the developers of Incident IQ.• Created a dashboard visualization tool to display parts, price, and information for items purchased, using Power BI.• Performed imaging on various computers for different departments of the company.

• 

  IU Health Methodist Hospital

  Jul 2020 - Oct 2022

  • Update and support a COVID-based nurse reallocation application through which over 20,000 shifts were assigned and additional payment was distributed to team members across 19 locations throughout IU Health over the period of 1 year.• Create, implement, and maintain automated Python scripts that connect to an internal data warehouse and use SFTP to send travel nurse hours to contract agencies in order to bill an average of $1.4M on a weekly basis.• Work in a team to develop a system-wide permissions management process for internal Power BI reports using security groups that resulted in correct permissions given to 6 different groups composed of 1,642 employees.• Write complex SQL queries from IU Health’s EDW for several Power BI Reports to support ERP Conversion Process.• Implement features to an internal application, resulting in a 92% decrease in tickets processed by timekeepers.• Managed tickets from Cherwell, an ITSM tool and frequently communicated with customers on those tickets. Show less

  • Data Analyst

    Oct 2020 - Oct 2022

  • Data Analyst Intern

    Jul 2020 - Sept 2020
• 

  Tire Rack

  Dec 2022 - now

  Data Engineer