Summary
Overview
Work History
Education
Skills
Certification
References
Personal Details
Timeline
Generic
Aayushi Goyal

Aayushi Goyal

Indore, M.P,India

Summary

Detail-oriented professional with hands-on experience in Google Sheets, SQL data analysis, and advanced Excel proficiency. Demonstrates strong business acumen and strategic financial planning capabilities, complemented by effective communication skills. Committed to leveraging analytical and technical skills to drive data-driven decision-making and support organizational growth.

Overview

5
5
years of professional experience
5
5
years of post-secondary education
1
1
Certification

Work History

Automated Reconciliation Analyst

Crowe LLP
09.2023 - 11.2023

· Ensured the accuracy and validity of healthcare financial information regarding unapplied cash by investigating and tracking cash

balances to the bank deposits, lockbox and credit card transactions, patient accounting system, and the general ledger to prevent

write-offs of millions of dollars for hospitals throughout the country.

· Worked within the finance and reimbursement solutions team to monitor, report, analyze, and troubleshoot the discrepancies and

errors in the Crowe NetSuite Account Reconciliation software to get an average match rate of above 95%.

· Tracked, transferred, and recorded cash deposits to the appropriate entities to help provide an audit trail with supporting documents.

· Used Excel pivot tables, VLOOKUP, XLOOKUP, and various SUM functions extensively to manipulate large datasets and create charts.

· Conducted regular status meetings with with clients to provide updates on project progress and address issues proactively.

Data Analyst

Webmobilo
01.2021 - 12.2021
  • Coordinated project planning, resource allocation, and risk management activities to ensure project milestones were met.
  • Managed confidential databases, ensured secure handling of sensitive information.
  • Collected and analyzed complex datasets for business strategy enhancement.
  • Utilized SQL to extract relevant information for reporting purposes.
  • Developed project documentation including project plans, schedules, and status reports.

Data Research Analyst Intern

Kingland Systems
01.2019 - 08.2019
  • Conducted extensive market research and completed data entry on corporations and investment vehicles, with strict compliance to company standards to identify relationships and provide credible data.
  • Enhanced data quality over time on new and existing data through continual data clean-up efforts.
  • Monitored system performance using recognized and agreed criteria.
  • Identified current inefficiencies and recommended changing functionality or behaviors to eliminate concerns.

Education

Master of Science - Finance

University of Illinois Urbana-Champaign
USA
01.2022 - 05.2023

Bachelor of Science - Finance and Management Information Systems

Iowa State University
USA
08.2016 - 12.2019

Skills

  • Effective communication
  • Machine learning basics
  • Business acumen
  • Big Data analytics
  • Structured Query Language (SQL) data analysis
  • Advanced excel proficiency
  • Microsoft Office Suite
  • Strategic financial planning
  • Knowledge in python
  • Google sheets experience

Certification

Currently pursuing Google Data Analytics Professional Certificate.

References

References available upon request.

Personal Details

Languages: English, Hindi, Malay

Date of Birth: 13/07/1996

Gender: Female

Marital Status: Single

Nationality: Indian

Notice Period: Available Immediately

Ready to Relocate: Yes

Timeline

Automated Reconciliation Analyst

Crowe LLP
09.2023 - 11.2023

Master of Science - Finance

University of Illinois Urbana-Champaign
01.2022 - 05.2023

Data Analyst

Webmobilo
01.2021 - 12.2021

Data Research Analyst Intern

Kingland Systems
01.2019 - 08.2019

Bachelor of Science - Finance and Management Information Systems

Iowa State University
08.2016 - 12.2019

Currently pursuing Google Data Analytics Professional Certificate.

Aayushi Goyal