RONAK DESAI

adwsop@r.postjobfree.com (***) *** - **75 LinkedIn Boston, MA

EDUCATION

Master of Science in Business Analytics Suffolk University, MA Dec 2022 Relevant Courses: Python, Advance Data Management, Data Warehousing and Business Intelligence, Enterprise Data Management, Project Management, Predictive Analytics, Data Analytics, Data Management and Modelling Master of Business Administration Veer Narmad South Gujarat University, India Sep 2020 Relevant Courses: Quantitative Methods, Research methodology, Organizational Behavior, Business Policy & Strategic management, Global Business Management, Consumer Behavior, Sales & Supply chain management, Management of retail business Bachelor of Business Administration Veer Narmad South Gujarat University, India Apr 2018 TECHNICAL SKILLS & CERTIFICATES

Programming Languages: Python, SQL, R, VBA, Shell Scripting, Java, HTML, CSS

BI and Data Visualization: PowerBI, SAS, SAP Hana, Tableau, R-Shiny, SPSS, MS Excel

Soft Skill: Communication, Problem Solving, Time management, Collaboration, Adaptability, Attention in Detail, Leadership

Database ETL: SQL Server, HIVE, AWS RedShift

Tools: MS Office, JIRA, GitBash, Google Analytics, HubSpot(CRM) Apricot

Certificates: SAS Suffolk University Academic Specialization in Business Analytics issued by SAS

Certificates: Project Management Professional (PMP) certification in progress. PROFESSIONAL EXPERIENCE

Data Analyst Moakley Centre for Public Management, Boston, MA Sep 2021 - Jun 2022

Conducted data cleaning and warehousing in Apricot for over 1M records of residents, ensuring data accuracy and integrity.

Developed insightful quarterly reports for the Massachusetts Municipal Association using SPSS, presenting key findings & trends.

Applied NLP techniques to analyze professor's feedback & recommendations for enhancing the undergraduate coursework design.

Built business intelligence solutions for executive level stakeholder’s strategic operating plans which includes live reports and monthly scorecards for strategic performance modeling. Business Analyst Radhey Krishna Terene Pvt. Ltd. Sep 2018 - Aug 2021

Developed an interactive dashboard in PowerBI for comprehensive analysis of production, sales, and supply chain data, providing valuable insights to support business decisions.

Accurately forecasted sales, purchase trends, and adjusted for seasonal demands, resulting in a 18% reduction in lead time and improved supply chain efficiency.

Provided actionable insights to senior management by conducting market research on competitor products, leading to improvements in our own product offerings.

Analyzed customer sales patterns and implemented strategies, resulting in a $53K increase in sales in the following quarter.

Conducted in-depth niche market analysis to support the marketing team in developing a targeted campaign for product launch. ACADEMIC PROJECTS

Real Estate Predictive Price Forecasting Python, Scikit-learn, Matplotlib

Carried out data manipulation using NumPy on multidimensional datasets acquired from Warren Group. Expanded Exploratory data analysis operating Pandas, NumPy, Seaborn on various features and finished predictive modeling.

Devised Neural Networks, Applied Gradient Boosting, XG Boost machine learning models to predict future real estate prices by demographics and gained 86% accuracy. Leverage matplotlib for generating visual analytics. Customer Retention Dashboard Python, BeautifulSoup, PowerBI

Carried out web scrapping of user reviews of amazon product using Python’s BeautifulSoup library and performed EDA of data.

Produced PowerBI dashboard featuring word clouds, bar graphs to understand customer behavior.

Suggested Recommendations for stakeholders for improved customer service.

.

Marketing Risk Analysis Python, Matplotlib

Conducted SWOT analysis of marketing policies and identified business KPIs. Developed insightful visualization using python’s matplotlib on market research data.

Leverage statical models and trend analysis to evaluate potential impact of risk and developed a risk management plan to mitigate these risks.