Justin Thomas Email & Phone Number

Melbourne, Victoria, Australia

● Assigned to work on an ERP systems project for Dnata catering to build and test new solutions to make current business processes more efficient for internal stakeholders nationwide● Collaborate and communicate effectively with various stakeholders to gather requirements and translate functional and technical requirements into a working product for end users● Conduct testing of new system implementation to ensure functionality and quality as per business requirements● Generated an automated stock status report that saved labour time and cost for the procurement team at Dnata Catering● Built an internal tool using Power Apps and integrated it with Power Automate and Power BI ● Configure Power automate workflows to automate business processes and data migration tasks● Create interactive data visualization dashboards using Power BI and incorporate DAX to create calculated columns● Write and execute SQL queries using MySQL to retrieve data that provide business insight● Apply an ETL process through Microsoft SQL Service Integration Services to collate data from various sources (Excel file, databases) and clean data to make it ready for data analysis● Perform data management and data validation to ensure data accuracy for reporting purposes● Design conceptual, logical and physical data models that meet business requirements● Create star schema databases using Microsoft SQL Server to create a source/destination of data entries

Melbourne, Victoria, Australia

● Collaborated closely with the CFO and the company’s appointed Actuary to identify any trends in the insurance claims● Utilized a visual method in RStudio called "Correspondence Analysis" to identify any relationships between service groups and the method claims were made● Built data visualization charts in R to show that dental based services had lots of variation in claims benefits across states● Identified 4 service groups that generated the most claims as Dental, Optical, Physiotherapy and Chiropractic

Melbourne, Victoria, Australia

● Led a consulting team, identified business issues and delivered solutions to help our client establish its presence in a competitive market● Recommended strategies to lower the barriers to entry by lowering product prices to reduce customers' bargaining power and lower their switching costs● Researched different types of product lines that Classy Tails can incorporate into their existing product range to increase variety of products on offer● Analysed competitor's websites to understand the current market trends and identified ways our client can differentiate themselves through logo designs and product differentiation● Redesigned the company logo and activated an Instagram account to improve user interaction which increased customer traffic by 10%

San Francisco, California, United States

● Built a Cash Flow model to project financial performance by applying SaaS metrics and real time data gathered from ProfitWell● Produced a cost-benefit analysis report on different payment methods and uncovered a transaction exposure. We switched payment methods, and I helped the company save $2.3K a month● Assessed what kind of funding will derive the most value to the company's growth by comparing revenue-based loans, straight line loans and venture debt● Analysed financial statements to calculate the profitability, liquidity and efficiency ratios and determine the impact on our cash flow cycle● Reconciled Pro forma statements with actual expenses by performing a budget variance analysis and implementing key excel functions such as Pivot table and VLOOKUP● Conducted industry research to evaluate the range on EV/EBITDA multiples used to value both private and pubic SaaS companies● Retrieved data from P&L, Balance Sheet and Cash Flow statements using software such as QuickBooks and ProfitWell to determine MRR, ARR and churn rate

Chicago, Illinois, United States

● Focused primarily on the buy side of a Mergers & Acquisition's deal ● Analyzed a Confidential Information Memorandum (CIM) to gather data; applied it to a DCF model and determined a purchasing price for the company● Projected the next 5 years of a company’s financial statements to determine its overall financial health● Conducted research on 50 companies and 10 industries using PitchBook and D&B Hoovers to find more about the industry size and market growth ● Performed due diligence on 3 companies to determine if they are a potential target for a platform acquisition● Prepared investment teaser materials for PE conferences, communicated with 20 C-level executives and set up over 15 meetings between PEGs and executives so they can be informed of current deals and work together● Reviewed and edited 7 NDAs to ensure changes made are in the best interest of our client

La Porte, Indiana, United States

● Researched 5 major insurance companies to assess which protection coverage best fits a client's needs● Determined clients' eligibility to obtain mortgage protection insurance by analyzing their financial information and other sensitive data● Connected with clients by meeting with them personally

West Lafayette, Indiana, United States

● The only leader in the entire course responsible for facilitating sessions in Applied Calculus II through a fun, creative and collaborative working environment● Guided over 100 students through tough, complex problems and encouraged them to find solutions through critical thinking and analysis● Followed Dale's Cone of Learning to enhance students’ learning ability by letting them challenge their thought process and engage with their peers

Purdue University

● Delegated to the Director of Recruitment position in one of Krannert's leading Professional Business Honor Organizations● Recruited 25 interested candidates after socializing with them at 4 Club Expo events ● Guided candidates through the candidacy process in order for them to become inducted members into this International Honor Organization

Master Of Business Analytics, Data Analytics, Forecasting, Wam: 81.56 Gpa: 3.44/4.0

● Learned R programming language to implement data wrangling and data visualization techniques to discover valuable insights that can.

Bachelor Of Science In Accounting With A Minor In Finance, Accounting And Finance, Gpa: 3.83/4.0

Activities and Societies: Supplemental Instruction Leader, Beta Alpha Psi, 3DS, National Society of Leadership and Success, Beta Alpha Psi.

High School Diploma

Activities and Societies: - House Captain (2014-2015) - National Level Business Entrepreneurship Competition (BUBA) (2013-2014) - Make.