PARTH SHAH

ad0l88@r.postjobfree.com 315-***-**** https://www.linkedin.com/in/parth-shah-su/

EDUCATION

Syracuse University, MS in Information Systems Specialization in Data Science May 2023 Relevant Coursework: Scripting for data analysis, Database Management Systems (SQL), Data Analysis and Decision Making, Data Warehousing, Cloud Management (AWS), Strategic Management Mumbai University, BE in Information Technology Oct 2020 Relevant Coursework: Statistical Modelling using R, Project Management (SDLC, Agile), Data Mining and Business Intelligence PROFESSIONAL EXPERIENCE

Product and Business Operations Intern Lenovo, North Carolina Jun 2022 – Apr 2023

• Developed and automated real-time Power BI dashboards to analyze market trends and track KPIs, reducing report generation time by 40 hrs per month for product managers

• Increased 11% market share by analyzing competitive pricing, performance and forecasted sales using Python and Excel to informed product roadmap and strategy

• Modeled data into star schema by extracting, transforming and loading 7 million rows from data lake using optimized SQL queries

• Spearheaded implementation of new KPI (Attached rates), into Power BI dashboards and track metrics leading to 12% YoY increase in sales for top products combinations

• Automated manual report generation process by migrating data reports into Power BI, resulting 8% reduction in workload

• Composed and finalized technical specifications of 3 laptops (ThinkPad P16, P1) by incorporating feedback and collaborating with cross-functional teams, resulting in high-quality products Data Analyst Consultant iConsult Collaborative, New York Oct 2021 – Oct 2022

• Improved user engagement by using Google analytics and Tableau to track KPIs, increasing website traffic by 16%

• Extracted data from 10+ sources and converted into 1 combined source for reporting purposes using ETL Techniques

• Collaborated closely with business and data teams to build data warehouse using snowflake and integrate with Tableau to create weekly reports for making strategic data-driven decisions

• Performed ad-hoc analysis on business trends, and presented insights to senior executives and key stakeholders Business Analyst Orient Technologies Pvt. Ltd., India Jan 2021 – Apr 2021

• Automated tiered approval workflow process using Power Automate, improving efficiency by 25%

• Executed Extract, Transform and Load (ETL) on existing database with 4 million records and exported data through SQL Server Integration Services (SSIS) package

• Built decision-support data dashboard using Power BI for visualizing fiscal sales to provide high-level business visibility

• Led development of application using Power Apps that assisted in search for project specifics, saving 30 minutes of search time

• Coordinated with business teams to develop serverless website hosted on AWS service (Amazon S3) for language translation TECHNICAL SKILLS

Programming: SQL (MySQL, SQL Server), Python (Pandas, NumPy, Matplotlib, Scrapy), R, C Visualization: Power BI, Tableau, Looker

Tools: Snowflake, Google Analytics, SSIS, SSRS, MS Excel, Github, Jira, MS Project, MS PowerPoint Platform and Services: Amazon Web Services (S3, EC2), Microsoft Azure, Salesforce, Power Apps, Power Automate PROJECTS AND PUBLICATION

Hotel Cancellation and Insights

• Developed predictive model using Association Rule mining, SVM, and linear regression with 83% accuracy

• Performed EDA (Exploratory Data Analysis) and visualized data in form of charts, maps, boxplots using ggplot2 and ggmap Data Warehouse & Business Intelligence – Northwind Traders

• Constructed relational database leveraging ERD with SQL and categorized data as per requirements keeping data normalized

• Implemented Extract Transform Load operations using SSIS toolbox to transport 50,000 rows of data from source to destination

• Collected real-time data and deployed SQL server on Azure Cloud to perform CRUD operations, Triggers, and Procedures Cloud-Based Smart Parking System with ALPR Algorithm and App Integration

• Designed Python ALPR algorithm to alleviate road congestion caused by parking using image processing

• Integrated dynamic database management system to store information in real-time using Firebase

• Published paper in International Research Journal of Engineering and Technology (IRJET), April 2020, Volume 7, Issue 4 LEADERSHIP EXPERIENCE

• Appointed as Assistant Operations Head of Computer Society of India committee, lead a team of 5

Contact this candidate