Charlie Law
5.0
(3)
Studied at Mendoza College of Business
Works at Walmart
Successful clients at
Not currently taking new clients
Work Experience
Senior Financial Analyst, AFDP
Walmart
February 2024 - Present
• Gaining accounting- and finance-related work experience toward 1-year requirement for CPA licensure • Owning weekly forecast for new, start-up business within Walmart, including weekly report to team • Improved (and still improving) forecast accuracy through new methodology • Leading finance in a cross-functional pilot program related to Walmart’s supply chain • Delivering weekly presentation materials to senior leadership; built Looker dashboard to automate data refresh for those materials, saving ~4 hours every week for the team • Built Power BI dashboard, using SQL to query data from numerous tables, for visibility into Walmart Business subscriptions • Generated insights on how to improve traffic and conversion numbers for Walmart Business • Analyzed impact of potential pilot program on existing infrastructure's capacity; helped inform senior decision-making on pilot program Forecasting, Financial Modeling and +4 skills
Senior Financial Analyst, AFDP
Walmart
August 2023 - February 2024
• Gained accounting- and finance-related work experience toward 1-year requirement for CPA licensure • Led the Management Incentive Program (MIP) process for all of Walmart US Supply Chain (15 Networks), including managing and validating data to ensure proper payout of thousands of managers' bonuses, modeling EOY payouts, regularly working with VP-level leadership, and aligning on data and processes with over a dozen teams • Improved the MIP process by automating Excel sheets for easier updating, reducing clutter for greater understandability, and adding metrics and graphics for analysis • Ran the month-end close for Walmart Supply Chain, including managing updates to the P&L, communicating information to various teams, and drafting emails with key information to leadership • Planned all of Walmart US Supply Chain Utilities for the company's AOP (annual operating plan), along with assisting Managers, Senior Managers, and Directors with their planning and loading of AOP packages • Created a new forecasting view to increase understanding of drivers • Piloted two Excel certification exams for the AFDP program office as a SME before roll-out to the rest of the program Financial Planning and Analysis (FP&A), Project Management and +6 skills
Teaching Assistant
University of Notre Dame
January 2023 - May 2023
• TA for Master’s of Accountancy and undergraduate course in accounting analytics, including Excel functionality and statistical methods such as Monte Carlo simulation • Graded assignments and tests, communicated feedback to the students, met regularly with the professor, and proctored exams Microsoft Excel, Statistics and +3 skills
Teaching Assistant
University of Notre Dame
August 2022 - December 2022
• TA for a core accounting course in the Mendoza College of Business • Graded exams, gave feedback to students, and held weekly office hours to assist in students' learning of the financial statements and related issues, such as sales returns and revenue recognition Leadership, Accounting and +1 skill
AFDP Intern
Walmart
May 2022 - August 2022
• Created a Power BI dashboard to centralize information, automate tasks, and increase visibility of trends for the central finance merchandise team at Sam’s Club • Analyzed and forecast on an ad-hoc basis in Excel and PowerPoint, identifying risks and opportunities for the company • Built slides and presented insights to a Vice President of finance at Sam's Club, who ultimately used those slides for the Sam's Club's CMO & CEO • Won team case competition following presentation to and Q&A with Finance Senior Directors • Helped other interns and full-time AFDPs with Excel and Power BI Microsoft Power BI, Microsoft Excel and +4 skills
Research Assistant
University of Notre Dame
May 2021 - April 2022
• Worked on research aimed at ending poverty • Pioneered and laid the groundwork for LEO's use of the Marginal Value of Public Funds, an economic measure of the efficiency of government dollars spent on public programs, by building a program in Stata alongside Professor Patrick Turner • Created surveys in Qualtrics, cleaned data in Stata, and built graphs that will end up in published research papers • Worked on the administrative and organizational side of projects as well, often taking that on as extra responsibility outside of my main projects Econometrics, Microsoft Excel and +3 skills
Teaching Assistant
University of Notre Dame
August 2020 - May 2021
• TA for Excel- and PowerBI-focused analytics course • Taught Excel, including formulas, formatting, VBA, Macros, and Solver (among other topics), as well as basic SQL • Attended class three days a week and helped students learn the material, responded to their emails and assisted them outside of class as needed • Graded homework, quizzes, and tests Leadership, Microsoft Excel and +4 skills
Education
Mendoza College of Business
Bachelor of Business Administration - BBA, Accountancy
2019 - 2023
Grade: 3.95, Summa Cum Laude Activities and societies: - Board Member for MoneyThink ND: Provided financial education to local high schools - Beta Alpha Psi: Accounting honor society - Beta Gamma Sigma: Business honor society - Tax Assistance Program: Provided free tax services to low-income people in South Bend - Deloitte Scholars Program: Group for discussion and debate around ethics in business - Student International Business Council: Collaborated to construct cases for accounting and consulting
University of Notre Dame
Bachelor of Arts - BA, Economics
2019 - 2023
Grade: 3.95, Summa Cum Laude
3 Reviews
Overall Rating
5.0
Charlie has helped clients get into these companies: