UTKARSHA BHOIR

ABOUT ME

I turn messy data into decisions and bullseyes. I’m a data- and product-minded analyst who builds clean, self-serve dashboards, builds scalable, automated workflows, and designs KPIs and experiments that move real metrics, not just slide decks. My toolkit spans SQL, Python, and BI (Tableau, Power BI, Looker), backed by a habit of documenting definitions so product, ops, and leadership stay aligned on a shared, objective definition of success. I love the full loop: find the signal, ship the insight, test the change, and tell the story so teams act fast. I’m curious and steady under pressure, shaped by a competitive student-athlete background that sets me apart. I’m obsessed with clarity and am seeking data, BI, product, and entry-level AI roles where I can blend analysis, UX-minded storytelling, and automation to turn “interesting” into “improved.”

EDUCATION

Northeastern University, Boston, MA

MS, Information Systems

Rodrigues Institute of Technology, Mumbai

B.E, Electronics and Telecommunication

PROFESSIONAL WORK EXPERIENCE

Data Engineer and Business Intelligence Analyst Intern

Fiora Online Limited, A Tata Enterprise, Mumbai, India

Performed market analysis by extracting and analyzing product pricing data using Python and SQL from competitor websites, leading to a 0.5% increase in revenue through price adjustments and changes in business processes
Built a report on Tableau highlighting the top 10 products by department & category, which informed the leadership of pricing trends and helped drive decision making conversations that support pricing strategies
Collaborated with the CRM team and generated weekly/monthly documentation and Excel reports to track key performance metrics (KPIs) like sales per customer, frequency, basket size, and retention rates at different levels
Contributed to the UI team to improve the offers section of the product display page, resulting in a 15% increase in conversions and a 10% increase in average order
Redesigned layout of offers section in an innovative way to highlight promotional discounts, added graphics to highlight recommendations, and A/B tested different versions of the offers to improve digital engagement by 10%

Project Management Intern

Boru, Bhujbal Daily Solutions Pvt. Ltd, Navi Mumbai, India

Delivered timely ad hoc insights with effective communication, fostering teamwork and leveraging advanced analytical skills. Investigated TMS rating issues and identified best practices to drive a 15% process efficiency
Successfully pitched and implemented a vendor wholesaler application with a monthly subscription method, resulting in an increase of 5% in monthly customer repeat rate and a projected retention rate of 15%
Conducted performance testing for adding shops on the Boru app resulting in an improvement in app rating from 3.8 to 4, as per the feedback from the test users making continuous improvements
Developed ETL pipeline on a distributed system and coordinated in weekly analysis, and provided meaningful insights to the company about issues faced by shops and customers, leading to an increase in the NPS by 3 points
Investigated user behavior through extensive research and evaluated feedback to identify pain points and areas for improvement, leading to a more user-centered app design by leveraging 10 principles of UI/UX design

PROJECTS

UI/UX Design Projects

Indian Bank App Redesign

Enhanced the Indian Banking App by improving usability, functionality, and brand consistency. Designed over 20 ADA-compliant wireframes and a prototype with a focus on UX design, ensuring accessibility through alternative text for images, captions for videos, and keyboard functionality

Data Science Projects

Patient Treatment Classification

Devised a patient treatment classification model with 95% sensitivity through advanced feature engineering and model optimization, enhancing data-driven healthcare decisions

Stock Market Database Management

Built a conceptual EER model, a relational database on MySQL, and a data pipeline for stock price prediction using historical market data. Conducted EDA, preprocessing, and visualization using SQL, Python, and Tableau to inform enhanced investment strategies