Business Intelligence Information Systems

SAARTHAK VIJAY JOSHI

*******@***.*** • +1-680-***-**** • linkedin.com/in/saarthak-joshi-24878b187 • github.com/Saarthakj EDUCATION

Syracuse University, School of Information Studies, Syracuse, NY May 2025 Master of Science Information Systems (GPA: 4/4) Coursework: - Data Administration and Database Management, Business Analytics, Data Science, Information Systems and Analysis. University of Mumbai, India. June 2023

Bachelor of Engineering Information Technology

Coursework: - Data Management and Analysis, DBMS, Data Mining and Business Intelligence, Big Data Analysis, Data Warehouse. TECHNICAL SKILLS

Skills: Analytical Decision-Making, Data Analysis & Interpretation, Data Modelling & Visualization, Quantitative Analysis. Programming Languages: SQL, Python, R, C, C++.

Database Management: MySQL WorkBench, NoSQL, Azure Data Studio, Docker, Adminer. Software: Power BI, Tableau, MS Excel, MS Access, Google Analytics, AWS, MS Powerapps, Microsoft Office suite. AWS: Lambda, Datalake, Athena, Sagemaker, S3, EC2, RDS, Elastic. EXPERIENCE

Business Intelligence Intern, AIESEC, Mumbai Nov 2021 - June 2022

● Designed Power BI dashboards with precise SQL queries on Snowflake data, enabling stakeholders to make data-driven decisions.

● Identified 20+ cost-saving business opportunities through data-guided market analysis, aligning with organizational growth goals.

● Collaborated with other departments to understand data needs, resolve uncertainties and help organization reduce expenditures.

● Quantitatively analyzed 1000+ financial transactions in Azure Data Studio and R studio, boosting data governance by 20%. Data Analyst Intern, RAIT-ACM (Association of Computing Machinery), Mumbai Oct 2021 - June 2023

● Employed MySQL and Tableau for data manipulation and visualization, leading to improvement in interpreting data nuances.

● Automated routine database tasks, including backups, updates and data cleaning, achieving a 10% increase in system up-time.

● Implemented robust data integrity checks to detect and prevent anomalies, enhancing data confidentiality and integrity.

● Leveraged Excel for dynamic visualization of large datasets, contributing to a 15% improvement in confident decision-making. PROJECTS

EcoSmart-Advanced Analytics for Efficient Energy Use ( R, MS Excel, R shiny, Predictive Modeling): (Link) Jan 2024 - May 2024

● Guided GLM and SVM predictive models for optimizing energy consumption patterns, achieving low errors and high accuracy.

● Engineered Shiny apps for dynamic energy usage visualization, empowering stakeholders to make data-informed decisions.

● Executed advanced data integration techniques on diverse datasets, resulting in a 40% increase in data processing efficiency.

● Demonstrated how data-driven analytics enhance operational efficiency and sustainability without substantial capital investment. Insight-Hub - Social Media Analysis (Power BI, MS Azure Data Studio, MS Powerapps, MS Excel, MySQL): (Link) Sept 2023

● Developed a Microsoft Power application featuring interactive Power BI dashboards yielding end-to-end social media analysis.

● Conceptualized and built a relational database of 12 tables from scratch, leveraging ERD and adhering to constraints.

● Designed and engineered 4 interactive Power BI dashboards, delivering insights into user engagement and hashtag analysis.

● Executed SQL queries to pinpoint top 3 most active users by geography and assess post frequency, delivering key insights. Fake Face Detector system (Python, R, Tableau, MYSQL, MS Azure, Amazon S3, Machine Learning, Docker): Oct 2022

● Processed a dataset using Python and R containing 35,500 photos, converting raw data into meaningful insights and strategies.

● Applied caret package in R to partition data into training, development, and test sets to optimize detection models.

● Deployed Azure and SQL for predictive analytics, identifying patterns and analyzing future trends with data-driven insights.

● Improved system scalability by 20% through optimized storage on Amazon S3, ensuring swift data access and efficient analytics. Content-Based Movie Recommendation System - Copyrighted (Content based filtering, Python, MS SQL): (Link) July 2022

● Utilized user profiles and movie content attributes to create personalized recommendations, enhancing user engagement.

● Managed user profiles and movie attributes with Microsoft SQL Server, using ad-hoc analyses to meet business needs.

● Integrated MS SQL with Python to optimize data preparation for recommendation algorithms within database itself.

● Maximized user engagement and satisfaction while minimizing costs by 30%, through the implementation of an efficient system. PUBLICATION

Publication (IEEE): S. V. Joshi, "Development of Critical Information Framework by Big Data Analytics and Artificial Intelligence to Prevent Cyber Attacks in WSN," 2023 International Conference on Artificial Intelligence and Smart Communication (AISC), Greater Noida, India, 2023, pp. 1089-1093, doi: 10.1109/AISC56616.2023.10085465. (Link)

Contact this candidate