Dilan Marfatia

ad3gtn@r.postjobfree.com 201-***-**** Englewood, NJ

WORK EXPERIENCE

Mercer Feb 2023 – Oct 2023

Government Consulting Analyst Remote

Analyzed Financial and Actuarial Data for the Physical and Behavioral Health Medicaid team of Pennsylvania o Responsible for over 3 million people and over $30 billion yearly.

Worked on 100+ projects in the areas of Financial Forecasting, FP&A, Revenue Allocation, Budget Management, Rate Setting, Efficiencies, Risk Mitigation, Base Data Adjustments, Data Modeling, Project Management, Trend, and Program Changes for these teams.

Most projects required reducing large amounts of data to the most relevant information using SAS or SQL and calculating the data into financial and rate summaries in Excel for easy interpretation by clients. o The final summaries for each project would be divided into a set of standard deviations, where the rate change would differ based on the county and program and final approval would go through the state. ARC Jul 2022 – Oct 2022

Financial Accountant Hackensack, NJ

Scanned and sent daily checks, cash, and credit transactions along with past transactions and open invoices then logged them on Traverse or Quickbooks through multiple accounts including operational, investment, mortgage, petty cash, payroll, development, etc.

Calculated and logged weekly and monthly Remittance and Medicaid billing into each program account.

Made financial statements from the differing accounts and sent them to the state and counties.

Posted end-of-month bank reconciliation forms and balanced the books at the end of each month and fiscal year.

Magic Mike DJs Jun 2016 – Aug 2019

DJ/Data Entry Jamaica, NY

DJ’d and Emceed 100+ events in front of large audiences and for a variety of crowds.

Managed the social media and website of the business.

Met with clients to form a cost revenue structure based on their wants and needs for each event. EDUCATION

Purdue University 2018-2022

Bachelor of Science in Finance West Lafayette, IN

Notable classes include Portfolio and Investment Management, Financial Data Analysis and Modeling, Advanced Corporate Finance, Operational and Strategic Management, International Finance, Venture Capital and Private Markets, Futures and Options, and Financial Markets and Institutions.

Part of many clubs throughout my tenure at Purdue including the Financial Investment Club where we would take place in case study competitions and bring in guest speakers with reputable experience. SKILLS & INTERESTS

Program Skills: Excel, Office, SAS, R, SQL, Access, QLIK, Bloomberg, Python, Minitab, Quickbooks, Traverse, etc.

Skills: Strategic planning; revenue modeling & forecasting; bookkeeping, communication skills, problem-solving abilities, organizational know-how, attention to detail, budget management, critical thinking, able to work well in a team; can speak multiple languages like English, Gujarati, Hindi, and some Spanish

Interests: Investing, sports (mainly football and basketball), video games, music, cooking, traveling, etc.