Shubhankar Pinge
Data Analytics Lead
Specializing in developing and improving business intelligence solutions that turn raw data into strategic assets. This work delivers automated reports and intuitive dashboards, effectively replacing inefficient manual reporting and equipping stakeholders to make informed decisions that achieve key organizational outcomes. Passionate about what's next, there's a drive to integrate AI for smarter and efficient workflows.
6+
Years of Data Analytics Experience
1300+
Annual Reporting Hours Saved
#1
Ranked Telecom App Maintained
Projects
A selection of my coding projects and contributions.
View Full Portfolio
Developed a comprehensive data solution for telecom-related apps, scraping ratings, review statistics, and rankings from both the iOS App Store and Google Play Store. The collected data is securely stored in a PostgreSQL database and made accessible through a Flask web interface or an API.
Dynamic dashboard focused on App Store KPIs and providing actionable analytics on telecom app performance. This interactive and customizable dashboard leverages key metrics and visualization for comprehensive app rating insights, customer satisfaction trends, and competitive analysis.
Leveraging Puppeteer and Node.js, this project automates the login process for Spectrum.net to capture full-page screenshots of key account pages. This streamlines documentation and QA efforts by ensuring visual consistency and accurate records of the UI and page names across various the website.
Professional Experience
My journey and contributions in the world of data.
Program Analytics & Reporting Lead (Business Enablement)
- Reporting Automation & Data Governance: Spearheaded the development of scalable reporting frameworks, established data governance, and automated Excel and Power Apps dashboards to save program managers significant annual hours and provide real-time project tracking.
- Data Engineering for App Optimization: Engineered an ETL pipeline for app metrics, significantly reducing manual data collection hours annually, which supported the initiative to make My Spectrum App the #1 rated telecom support app.
- Business Intelligence & Strategic Recommendations: Led requirements gathering to create net-new reporting processes and delivered data-driven recommendations to senior leadership, influencing organizational outcomes and improving program management.
Project Delivery Analyst
- Data Analysis for Business Insights: Analyzed large datasets to extract customer experience insights, informing system and process improvements crucial for business intelligence.
- Data Quality & Model Enhancement: Improved data quality and accuracy by enhancing a Voice of Customer (VoC) classification model and data tagging, directly supporting more reliable business intelligence.
- Data Engineering for Specialized Analytics: Developed a specialized offensive lineman ranking metric using NFL Next Gen data on AWS, demonstrating data engineering capabilities for unique analytical needs.
Data Analyst (Voice of the Customer)
- Business Intelligence Metric Development: Developed a new metric to track the negative impact of defects on Customer Satisfaction Scores (CSAT), providing key business intelligence for improvement.
- NLP for Data Classification & Sentiment Analysis: Implemented and evaluated multiple Natural Language Processing (NLP) solutions for feedback classification and sentiment analysis, enhancing the automation and depth of customer feedback analysis for business insights.
Data Analytics Associate
- Early Data Analytics & Reporting Support: Supported data analytics initiatives, contributing to the foundational understanding and reporting of key data points.
Engineering Associate
- Data-Driven Engineering Support: Contributed to projects requiring data-driven approaches within an engineering context.
Skills & Expertise
A showcase of my technical capabilities and certifications.
Python
R
HTML/CSS
TypeScript
Angular
ReactNextJS
Tailwind
PuppeteerTableauPowerBI
MS Power AppsAWSSnowflakeDatabricksGit
FirebaseAcademics
My educational background and research contributions.
Formal Education
B.S. Industrial Engineering
M.S. Information Technology
Research Projects
Designing and implementing an RFID Personnel Tracking System within the Penn State: Learning Factory.
Tackled inefficiencies in outpatient procedures by analyzing causes of high Patient Length of Stay (LOS), developing solutions, and presenting findings at the MCREU Annual Conference.
Co-authored paper "Investigating Customer Needs for an Information Artifact for Emergency Department Patients" (Proceedings of Industrial Engineering Research Conference, May 2016).
Let's Connect
I'm always open to discussing new projects, creative ideas, or opportunities.