Business Systems Human Resources

SIDDHARTH SAVANI

LinkedIn Tableau Public Portfolio

***************@*****.***

EDUCATION

Sacred Heart University, Jack Welch College of Business and Technology Fairfield, CT Master of Science in Business Analytics [Cum GPA: 3.3] May 2023 Relevant Coursework: Database Management, Applied Statistics, Data Visualization, AI for Business, Pricing & Revenue Analytics, Cloud Computing

University of Mumbai India

Master of Accounting (Financial Accounting and Taxation) May 2020 University of Mumbai India

Bachelor of Business Administration May 2017

WORK EXPERIENCE

Erie Hospitality LLC, Cheektowaga, New York August – October 2023 Business Systems Analyst

• Implemented, organized, and administered business systems including Information Technology, Human Resources and Accounting.

• Presented reports to stakeholders with prescriptive data analysis improving operational efficiency by 15%

• Developed business strategies for revenue maximization by performing EDA.

• Managed and directed a team of 4 for operational tasks. Horizons at Sacred Heart University, Fairfield, Connecticut June – August 2022 Teaching Consultant

• Leveraged advanced Excel functionalities to analyze complex classroom performance data, enabling tailored pedagogical strategies that improved student learning outcomes by 20%

• Managed & assisted in teaching (English & Math) class of 25 primary school children. Ernst & Young LLP, Mumbai, India April – September 2021 Tax Analyst

• Calculated monthly Goods & Services Tax liability for Netflix using Microsoft Excel.

• Researched Online Information Database Access and Retrieval services and GST that levies upon sale.

• Conducted data analysis using advanced Microsoft Excel -VBA Macros and Pivot Charts. Rajiv N. Shah and Associates (CPA), Mumbai, India January 2020 – April 2021 IT & Accounting Analyst

• Conducted comprehensive technical assessments for 10+ clients, identifying system architecture improvements which led to a 15% increase in overall operational efficiency.

• Researched and recommended innovative technology solutions for departmental direction, resulting in a 20% increase in efficiency and enhanced customer- and agent-facing systems.

• Maintained books of accounts for clients, including data entries using Tally ERP software PROJECTS

New York Health Club Survey (Revenue Analytics)

• Performed Linear Regression to compute single optimum price for personal training for all members.

• Demonstrated Discreet choice modelling, Multinomial, and Logit model of regression to compute optimum PT price for each category of members – flexible schedule workers, fixed schedule workers and students.

• The club witnessed ~90% increased revenue when charged categorically as compared to blanket price for all members. East – West Airlines (Data Mining & Machine Learning)

• As part of Marketing campaign, airlines wants to incentivize their customers based on their travelling history.

• Performed Hierarchical & K-Means clustering on customers dataset using python - discovered 3 clusters of customers based on Ward Linkage Method

• Indulging in Pandas, NumPy, Seaborn, SciPy, Scikit-Learn Libraries. Database Management (SQL)

• Solved queries using SQL - using (Select, From, Where, Inner/Outer Join, Group by, Order by) Clauses

• Demonstrated experience using Unions, Subqueries, simple totals & aggregation, filtering grouped data, updating & inserting sets of data, deleting data, conditional logic.

• Developed and maintained detailed technical documentation, including process flows and data mapping, resulting in a 25% reduction in troubleshooting time and improved application architecture understanding. SKILLS & CERTIFICATES

Software: Microsoft Office Suite, Tableau, Tally ERP, Power BI, SPSS, SAS, SSRS Programming Language: Python, MySQL, MS-SQL

Concepts: Data Analysis, Data Wrangling, Data Mining, PCA Analysis, Machine Learning, Predictive analysis, Prescriptive analytics, dynamic automated scripts (SQL)

Certifications: Data Manipulation with pandas [Datacamp], Accenture [Data Analytics & Visualization Internship] Competition: Kaggle’s RSNA Abdominal Trauma Detection (using PyTorch for CT Scan analysis and lesion detection)

Contact this candidate