PRAGUN KUTLEHRRIA
Decision Scientist
Bangalore
Summary
Experienced data scientist specializing in data analysis, machine learning, and statistical modeling. Known for fostering team collaboration, generating actionable insights, and achieving impactful results in dynamic settings. Proficient in Python, SQL, Excel, Power BI, Tableau, machine learning, and generative AI. Adept at solving intricate problems and addressing evolving business requirements.
Overview
2
2
years of professional experience
Work History
Decision Scientist 1
MU SIGMA
07.2023 - 07.2024
- Analyzed user transaction data (FREE and PAID) using SQL across multiple products to uncover usage patterns and behavioral trends.
- Defined and tracked primary and secondary KPIs and product metrics in collaboration with business stakeholders to drive data-informed product growth and strategic decisions.
- Applied knowledge of the product lifecycle and funnel analysis techniques to optimize conversion rates, improving funnel efficiency by 15%.
- Performed A/B testing and built predictive models that reduced customer churn by 12-15% and increased user retention by 10-18%.
- Calculated DAU, WAU, and MAU metrics to monitor user retention, achieving a monthly retention rate improvement of 8% over six months.
- Utilized Python (Pandas) to clean, preprocess, and transform large-scale datasets for accurate and efficient data analysis.
- Developed Python-based machine learning models to predict customer churn with 85% accuracy and conducted sentiment analysis to extract actionable user insights.
- Created interactive dashboards in Microsoft Titan to visualize user trends, regional engagement, and payment behavior.
- Conducted churn rate analysis and detected fraudulent user behavior, reducing fraud incidents by 20% through proactive monitoring.
- Assessed and forecasted business risks to evaluate long-term app sustainability and guide mitigation planning.
- Executed a targeted user retention strategy that increased engagement in the North American market by 25% within 12 months.
- Collaborated closely with stakeholders to uncover churn drivers and design data-driven interventions that decreased user drop-offs by 15%
Decision Scientist 2
Mu Sigma Business Solutions
08.2024 - 02.2025
- Designed and automated ETL pipelines using RapidMiner to clean and preprocess large datasets, enhancing data quality and operational workflows.
- Developed and deployed demand forecasting models leveraging time series analysis with ARIMA and XGBoost, improving forecast accuracy by 20% and enabling precise resource planning.
- Built predictive models for supply chain risk assessment, such as forecasting potential stockouts and supplier delays, which reduced stockout incidents by 25% and improved on-time delivery rates by 15%.
- Applied advanced SQL techniques including JOINs, window functions, subqueries, CTEs, and managed creation and updates of dimension and fact tables to support robust data warehousing.
- Executed complex API calls and data integration workflows to extract tables from SAP HANA into SQL Server, establishing reliable cross-platform data connections.
- Implemented prescriptive analytics and logistic inventory analysis to optimize inventory levels, reducing holding costs by 15% and increasing supply chain efficiency by 18%.
- Utilized Power BI Desktop and Power BI Service to build interactive dashboards featuring Row-Level Security (RLS), dynamic slicers, and real-time data updates; deployed dashboards to the cloud using Power BI Gateways for seamless data refresh.
- Collaborated with business stakeholders to align analytical models and visualizations with key performance indicators, driving strategic production decisions.
- Extracted, transformed, and integrated multi-source data using SQL operations and RapidMiner workflows to generate actionable insights supporting operational improvements.
- Optimized SQL stored procedures and queries in partnership with the database team to reduce API response times by 30%, enhancing data accessibility and system performance.
- Synthesized multi-source datasets into unified, accurate reports that increased SABIC’s production efficiency by 12% and cut operational costs by 10% over 12 month
Decision Scientist 2
Mu Sigma
07.2024 - 02.2025
- Designed and implemented LLM-based solutions using LangChain, OpenAI API, and Hugging Face models to extract structured data from MSSQL Server via natural language processing (NLP).
- Fine-tuned large language models (LLMs) leveraging custom datasets and OpenAI fine-tuning APIs to improve accuracy and reduce errors in data extraction workflows.
- Developed Retrieval-Augmented Generation (RAG) chatbots utilizing Pinecone vector databases and RAFT technology to minimize hallucinations and deliver reliable, context-aware responses.
- Experienced with LlamaIndex for efficient indexing and retrieval of large documents to enhance LLM query performance.
- Proficient in using Jupyter Notebook and Google Colab for rapid prototyping, experimentation, and deployment of AI and machine learning models.
- Applied advanced machine learning techniques including supervised/unsupervised learning, regression, and NLP to enhance predictive analytics and data modeling.
- Contributed to Mu Sigma’s Mu-Talos product, integrating vector databases and generative AI for actionable business insights.
- Collaborated with AI innovation teams to build executive-level chatbots for CEO Dhiraj Rajaram, enhancing strategic communication through LLM-driven automation.
Education
Bachelor of Technology - Computer Science Engineering
Chandigrah Group of Colleges
Mohali, India 04.2001 -
Skills
SQL
Python
Excel
Power BI
Tableau
Communication
Client Handling
Agile
SAS
ETL
Generative AI
Machine Learning
Chatbots
Data Visualization
Predictive Modeling
Sentiment Analysis
NLP
Feature Engineering
Statistical Modeling
Time Series
Big Data
Problem Solving
Team Building
Analytics
Interpersonal Skills
Data Mining
Research Methods
SAS Programming
Regression
Data Cleaning
ML Algorithms
Product Analyst
Risk Analyst
Supply Chain Analyst
Inventory Analyst
Customer Analytics
Fine-tuning
RAG
LLM
MLLM
Accomplishments
- Mu Sigma
- Received Spot Award and Client Appreciation at Mu Sigma for consistently delivering high-quality work within tight deadlines.
- Conducted knowledge-sharing and business orientation sessions for new team members to accelerate onboarding.
- Initiated client discussions to explore the adoption of emerging technologies aligned with business needs.
- Pitched AI-driven solutions to clients, demonstrating value through innovation and data-driven insights.
- Served as Scrum Master for 3 months, leading agile ceremonies and ensuring effective team collaboration and sprint delivery.
- College, Demonstrated leadership skills during academic tenure by co-authoring a research paper with Dr. Gagandeep Bhullar, showcasing initiative and collaboration in academic research.
Timeline
Decision Scientist 2
Mu Sigma Business Solutions
08.2024 - 02.2025
Decision Scientist 2
Mu Sigma
07.2024 - 02.2025
Decision Scientist 1
MU SIGMA
07.2023 - 07.2024
Bachelor of Technology - Computer Science Engineering
Chandigrah Group of Colleges
04.2001 -