Harshil Shah
*******.****@*******.*** 857-***-**** LinkedIn Brighton, MA
Analytical and results-driven Data Analyst with a Master of Science in Business Analytics from Suffolk University, specializing in data visualization, enhancing data accuracy, and process optimization. Eager to leverage technical expertise, supply chain management knowledge, and a strong foundation in project management to advance data-driven decision-making in a dynamic environment. EXPERIENCE
Suffolk University Boston, MA
Graduate Fellow - Graduate Admission Department September 2023 - May 2024
• Manage student records using Slate CRM, executing queries to rectify inaccuracies like incorrect international country entries and address discrepancies. Developed mock-ups for reporting, performance dashboards to management.
• Applied analytics techniques to optimize data quality and streamline operations, resulting enhanced efficiency in overall process.
• Assisted in strategic data initiatives and provided data-driven insights for business reviews. Jenisha Overseas Company Mumbai, India
Data Analyst April 2021 - September 2023
• Led data cleansing initiatives, significantly improving data accuracy and consistency, improving database reliability.
• Utilized advanced data analysis tools to generate over 150 + detailed reports annually, supporting strategic decision-making
• Transformed complex datasets into visually appealing formats, increasing comprehension and stakeholder engagement.
• Designed custom data visualization frameworks that transformed complex datasets into clear, actionable insights
• Worked on supply chain management concepts including forecasting, planning, and optimization. SKILLS
Data Analysis and Reporting: Proficient in SAS, Power BI, MySQL, Tableau, and Microsoft Excel. Expert in statistical analysis, predictive modeling, and quantitative analysis. Skilled in creating interactive dashboards, complex graphs to present insights. Technical Skills: Skilled in Java, Python (Basics), C++, HTML, CSS, and JavaScript. Experienced in SQL querying, database design, management using MySQL and Microsoft Visio. Experienced in front-end web development, using HTML, CSS, JavaScript, Project & Process Management: Proficient in Agile and Scrum methodologies to manage and optimize project workflows and demonstrated expertise in process reengineering and efficiency improvements using SAP ERP, Business Intelligence Tools. Campaigns and Initiatives: Skilled in planning and executing business campaigns and initiatives. Presentation Skills: Adept at creating wireframes, mock-ups, presenting performance reports & dashboards to identify business impact. CERTIFICATIONS
Power BI Essential Training - Issued by National Association of State Boards of Accountancy (NASBA) Ethical Hacking: Introduction to Ethical Hacking - Issued by International Institute of Business Analysis™ (IIBA®) SAS - Specialization in Business Analytics - Issued by SAS EDGE Tableau Workshop - Issued by Suffolk University, Center for Continuing and Professional Education PROJECTS
Integrated Analysis of Transit Operations, Infrastructure, and Urban Population Dynamics April 2024
Utilized SAS to analyze transit data, revealing urban trends crucial for optimized planning.
Demonstrated the importance of analytics in urban planning through comprehensive transit data analysis. Customer Churn Analysis Using Power BI April 2024
Created comprehensive dashboards to visualize churn rates by various dimensions (e.g., state, age, senior status).
Highlighted key churn reasons, revealing that competitor offerings were the leading cause of churn at 44.82%.
Identified customer segments with higher churn rates, such as customers aged over 80 with a churn rate exceeding 50%. IBM HR Analytics Employee Attrition and Performance November 2023
Utilized SAS Enterprise Miner to analyze employee attrition, identifying key predictors and developing a logistic regression model with an AUC of 0.86, cleaned & preprocessed a dataset comprising 9,471 observations and 35 variables, ensuring no missing values.
Key insights included the impact of commute distance, job level, and work-life balance on attrition, leading to actionable recommendations for reducing turnover.
Prediction of Diabetic Retinopathy using Data Mining Techniques March 2022
Utilized deep learning and image processing techniques for automatic diabetic retinopathy detection.
Employed SAS programming for data management and analysis.
Leveraged pre-trained VGG-16 models and Convolutional Neural Networks to advance early detection and management DR. EDUCATION
Suffolk University, Sawyer Business School Boston, MA Master of Science in Business Analytic, GPA: 3.78 September 2023 – May 2024 Relevant Courses: SAS Programming, Solving Business Problems using Adv. Excel, Data Management & Modelling, Data Analytics, Predictive analytics
NMIMS University Mumbai, India
Bachelor of Technology in Information Technology, GPA: 3.80 September 2019 - May 2022 Relevant Courses: Database Management Systems, Data Structures and Algorithm, Data Warehouse Management, Software Testing, Management Information Systems, Business Visualization, Software Project Management Shri Bhagubhai Mafatlal Polytechnic Mumbai, India
Diploma in Computer Science, GPA: 3.68 August 2016 – Jan 2019