Analyst Intern Financial

Sakshi Thakur

P: 774-***-**** LinkedIn E: **************@*****.***

Summary:

I am a highly skilled and detail-oriented finance graduate with a keen interest in financial modeling, financial analysis, accounting, cash- handling, and investment banking. I have experience in analyzing financial data using Excel, SQL, and Tableau and am committed to helping companies develop strategic plans based on financial modeling and findings. I have programming expertise in R, strong database SQL skills, and experience with cloud management such as AWS. I have proven ability to evaluate business processes and develop strategic recommendations to reduce expenses and improve efficiency. Additionally, I have experience with file management systems, servers, and databases, and have expertise in increasing company revenue and productivity through cost analysis, budget forecasting, and financial reporting skills. I am also innovative in professional modeling for clients of various domains such as retail, e-commerce, banking, and healthcare, along with an interest in entrepreneurship and making the world a more unified and connected place. Education:

• Clark University, Worcester, MA: Master of science in Finance GPA: 3.26 Anticipated May 2023

• Relevant Courses: Investment, Financial Accounting, Financial Econometrics, Investment Strategies, Mergers & Acquisitions, Computational Finance, Derivative and Corporate Cases

• Shri Vaishnav Vidyapeeth Vishwavidyalaya, India: Master of Business Administration (Finance) GPA:3.8 July 2019-July 2021

• Rani Durgavati Vishwavidyalaya, India: Bachelor of Commerce (Accounting & Finance) Grade: A- July 2016-July 2019 Technical Skills:

• Languages: SQL, AWS, R.

• Databases: MySQL, NoSQL, MongoDB, SQL, SQLite, PostgreSQL and pgAdmin

• Statistical Methods: Revenue Analysis, Regression Analysis, Statistical Analysis, Budget analysis.

• Tools: Power Bi, Tableau, QuickBooks, Excel (HLOOKUP, VLOOKUP, PIVOT TABLES/CHARTS, IS, IF Functions), Salesforce PostgreSQL.

• Technologies: Power BI, Excel, Business Intelligence, Predictive & Statistical Modeling, Data Visualization (Tableau, Matplotlib, Seaborn, Cloud Computing, looker), Hypothesis Test.

• Interpersonal Skills: Analytical, Creative, Excellent Verbal, Written and Quantitative Skills, Time Management and Prioritization Abilities, Effective Presentation, Problem Solving and Negotiation Skills Work Experience

Financial Analyst Intern, SparkzIT, Columbus, OH March 2023 – Current

• Collected & analyzed quantitative and qualitative data from business operations and performed market analyses and research on completion using excel and SQL

• Prepared financial forecasts and budgets and executed financial analyses on client’s data using excel (Pivot tables)

• Produced promotional presentations and supported team in daily administrative tasks using power BI and Tableau

• Managed and updated database customer relationship management systems using NetSuite and Salesforce Budget Analyst & Cashier, Sodexo- Clark University, Worcester, MA January 2022 – Current

• Collected payment cash/card and balance cash drawer along with maintaining an excel file and book-keeping for accounting & billing.

• Calculated weekly total payment receipts and record transactions and reconcile with total sales and investments using excel and SQL to form table for tableau and power Bi visualizations for supervisor & updated the balance sheets weekly.

• Solved billing problems and create budget model for auditing payroll, taxes, inventory, and sales records. Financial Analyst, Sky Technosoft Pvt. Ltd, India April 2020 – July 2021

• Executed monthly reconciliations of the company's finances, and prepared financial reports including balance sheets, audit reports, income statements, and cash flow statements using excel, QuickBooks, NetSuite and Power BI.

• Assisted with the preparation & presentations of monthly reports on the budget, financial analysis and operations of the department using excel (Pivot tables) SQL, Tableau and Power BI for stakeholders’ understanding.

• Collected data through reports and tables and digitalized them to upload in cloud to reduce paperwork and analysis through SQL.

• Collaborated with the data analytics team to implement financial forecasting using python and SQL in PyCharm and PostgreSQL.

• Monitored financial trends and provided support on the development of excel-based forecasting models and monitored budget performance through processing the large & complex audit reports with statistical outcomes for optimal performance & solutions of the statistical algorithms and used Docker, Jenkins, Git and AWS, to deploy. Others

Certifications: Completed 15+ projects & certificates in Financial Analyst, Financial Modeling & Valuation, Bloomberg Market Concepts, SQL Academic Projects: Mergers and Acquisitions, Mutual Fund Analysis, Stock Valuation & Technical Analysis. Financial Analysis Financial Modeling Data Analysis Book-keeping & Accounting Auditing NetSuite SQL Payroll

Contact this candidate