Pranshu Shah Email & Phone Number

Boston, Ma, Us

Parsippany, New Jersey, United States

Parsippany, New Jersey, United States

Parsippany, New Jersey, United States

Boston, Massachusetts, United States

• Led a team of 3 while playing an integral role to be aware of the business and identify the business problems for the sponsors. Performed Exploratory Data Analysis to understand the data and observe hidden trends.• Assisted in dealing with multiple cross-platform datasets and took responsibility to implement data cleaning methodologies using python.• Individually implemented FuzzyWuzzy string matching package in python to categorize more than 50% of unclassified categories. Automated the process of appending the categorical values by reviewing and setting a threshold of match percentage over 75%.• Prepared the data for data visualization and drew business insights for the sponsors to visualize hidden trends. Mapped the data by generating state and region vise dashboards to identify different customer preferences towards product categories.• Designed an interactive executive-level dashboard and story using Tableau to highlight the KPIs and product category inclinations and presented a final report supporting the findings and a working model.

Boston, Massachusetts, United States

• Applied Data Wrangling concepts such as Label Encoder, One-Hot Encoding, and splits to clean the data and performed EDA to understand the business practices.• Communicated and assisted with my team of 3 to set actionable tasks that would help the clients understand their business more. Worked independently on developing interactive dashboards to represent their revenue management.• Assisted in preparing the data by slicing it into required features. Designed and implemented models like Arima modeling and Logistic Regression to forecast sales and revenue generation with an overall accuracy of 68%. • Collaborated with the team and stakeholders to identify and highlight the Key Performance Indicators. Demonstrated a working model of the dashboards with the reports to provide business insights.• Suggested business planning solutions that can reduce their inventory stock for lesser sold items and attract more customers by offering discounts to loyal customers.

Pune, Maharashtra, India

• Contributed to web scrapping activities using Visual Basic Scripts and python to extract data from open-source platforms. Transformed and loaded the data into Microsoft SQL Server for quantitative analysis.• Took initiative to improve the process by suggesting and assisting during the process of transition from multiple technologies to entirely on python.• Reviewed and optimized the SQL queries to reduce 5 minutes of runtime per batch. Provided additional support to the QA team to improve efficiency over 150 batches per day. Generated reports for the client to meet the daily requirements and support their business planning.• Built detail-oriented dashboards for investors using Tableau to visualize region-specific reports. Highlighted Key Performance Indicators to understand trends in price variations.

Pune Area, India

• Modernizing admin web application by adding new features using Php for backend and Html and bootstrap for frontend development.• Identifying and rectifying bugs, enhancing modules, granting permission of features based on assigned roles, and collaborating with software testers to ensure the expected deliverables.

Vadodara Area, India

• Based on requirements gathered, developed a web application with personalized UI using user role identification and personalized notification.• Admins get control over verifying users by their document uploaded and either accepting or revoking their access to the system.• Customized admin panel(dashboard) to KPIs such as number of active users, number of active roles.

Masters, Analytics (Concentration: Informational Design), 3.84 Gpa

Master Of Science - Ms, Information Technology, 8.57/10 Cgpa

Bachelor’S Degree, Bachelor In Computer Application, 5.72/10 Cgpa