Accounting Data

Manmeet Kalsi

************@*****.*** https://www.linkedin.com/in/manmeetkalsi/ 973-***-****

EDUCATION & RELATED PROJECTS

Rutgers University, New Brunswick, NJ September 2016 – May 2020 B.A: Economics Minor in Business Administration

Relevant Coursework: Financial Economics, Business Analytics, Econometrics, Money Theory and Policy, Financial Accounting Econometric Models – 2018

Performed data analysis on variables such as GDP, bond yields, unemployment rates, and S&P prices to determine potential relationships to see if individuals should withdraw or maintain respective investments.

Provided an understanding of potential issues involved in underlying conditions for testing how relevant or irrelevant they were to the long run investments of individuals.

Utilized a statistical/econometric computer package (GRETL) to estimate a model with correlation matrixes and OLS estimators to verify if relationship between variables was present.

Applied the GRETL model to then group individuals based on their similar metrics (OLS Estimators) to write a report to explain the research.

Optimization Modeling/Forecasting – 2019

Used linear programming to determine optimal solutions for business problems as well as developed linear and non – linear mathematical models.

Collaborated in groups of 5 to forecast future hypothetical data with respect to how a company must decide its product mix via the Excel Solver Tool.

Performed sensitivity analysis test with what-if questions related to various input coefficients/variables to understand how different projections would affect outcomes. PROFESSIONAL EXPERIENCE

Order Menu Online, Iselin, NJ July 2019 – September 2019 Accounting Intern

Utilized various Text, Statistical, and Lookup functions via Excel for data organization and for recording and maintaining accurate and complete financial records.

Contributed to 15% uptick in user activity with Google Analytics by helping website redesign project by utilizing Canva.

Created spreadsheets and utilized them for market research for data including weekly order details, contact information, timelines, catering needs, etc. and then presented to senior management. Varsity Tutors, Montville, NJ May 2018 – Present

Tutor (Remote)

Prepared educational help to students of all ages in subjects such as Calculus, Microeconomics, Macroeconomics, Financial and Managerial Accounting, and Biology along with standardized tests such as the SAT and ACT.

Grouped resources together such as Khan Academy and Barron’s to enhance lessons and improve test scores by 15%

Confirmed with each student that interactions were understandable and adjusted teaching methods and techniques with respect to each student’s academic level and knowledge. LEADERSHIP & VOLUNTEER EXPERIENCE

Association of Punjabis at Rutgers University, New Brunswick, NJ September 2016 – May 2020 Executive Board Member

Attended biweekly club meetings to discuss prospective board members’ leadership opportunities, upcoming events, and general operations to potentially market recognition around 40,000 student campus. Morristown Medical Center, Morristown, NJ May 2013 – October 2016 Volunteer

Delivered items such as flowers, gifts, and meals to patient rooms as well as accompanied patients to various appointments within the hospital.

SKILLS & CERTIFICATIONS

TECHNICHAL SKILLS: NON-TECHNICAL SKILLS:

Proficient in Excel (VLOOKUP), Tableau, Attention to Detail, Creative Problem SQL Queries, Google Analytics Solver, and Efficient Multi-Tasker CERTIFICATIONS

AT&T Summer Learning Academy Externship

Excel Skills for Business: Intermediate Macquarie University 2020

Contact this candidate