Piyush Chandra Prasad

Business Analyst, Data Analyst, Data Scientist , AI engineer

[email protected] +91 7210361466

Resume

Hello, I am

Piyush Chandra Prasad.

2

Python
Projects

About Me

Hi, I’m Piyush.

I have 7+ years of experience in business operations and category management, where I’ve worked on solving operational challenges, improving processes, managing performance, and working with different teams to drive business outcomes.

At Urban Company, I worked closely with Product, Engineering, Finance, and Operations teams, which gave me a strong understanding of how businesses operate and how decisions made at an operational level can impact customers, partners, and overall business performance.

Over the years, I became increasingly interested in the role data and technology can play in solving these problems. That interest led me to build my skills in Python, SQL, Data Analytics, Machine Learning, and Generative AI.

Today, I’m combining my business and operations experience with these technical skills to explore how data and AI can be used to solve practical business problems. I enjoy working with data, finding patterns, understanding the story behind the number

My Projects

Expense Tracking System

Domain/Function: Personal Finance

Credit Card Loan Data Analysis & A/B Testing

Domain/Function: Data Analytics / A/B Testing

My Experience

UrbanCompany, Gurgaon | Category Manager | Jan 2019 – Present

•AI Automation & KPI Improvement: Led cross-functional collaboration with Product and Engineering to deploy AI chatbots for the Partner Help Center, reducing contact rate from 12% to 5.5% over Gross Requests — a key KPI tracked at leadership level. Managed training data SOPs and prompt optimization using GPT.

•Data-Driven Process Improvement: Audited 5,000+ support calls to refine issue triaging frameworks, increasing accuracy to 80% and resolution rate to 75%. Built real-time dashboards in Redash/Superset using SQL to enable data-driven decision making across 53 cities.

•Large-Scale Operations & SLA Management: Oversaw AC Service & Repair and Appliances categories across 53 cities; managed 200+ third-party agents and managers ensuring SLA adherence and operational excellence during peak seasonal demand.

•Stakeholder Management & Cross-Functional Collaboration: Primary operations lead for escalated partner issues, coordinating resolutions across Business, Product, Engineering, Finance, and Training — with consistent OKR alignment across teams.

•Partner Quality & Compliance: Executed partner profile archival processes per SOPs to maintain service quality, manage churn, and meet business standards.

Awards & Certificate

Python: Beginner to Advanced For Data Professionals

SQL for Data Science

Math and Statistics For AI, Data Science

Master Machine Learning for Data Science & AI: Beginner to Advanced

Deep Learning: Beginner to Advanced

Natural Language Processing

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

Mail Me

[email protected]

https://www.linkedin.com/in/piyush-chandra-prasad/

Call Me

+91 7210361466

GitHub

https://github.com/Piyushp02

Python Project

Expense Tracking System

Domain/Function: Personal Finance

A full-stack expense tracker with a Streamlit frontend and FastAPI backend, backed by MySQL. Users can add/update daily expenses by category and view interactive analytics — bar charts and percentage breakdowns — for any custom date range.

Add/Update Expenses tab showing daily entries with amount, category (dropdown), and notes fields

Analytics — bar chart view: Analytics tab displaying category-wise expense breakdown as an interactive bar chart

Project Details

Built an end-to-end Expense Tracking System with a Streamlit frontend and a FastAPI backend connected to a MySQL database. The app has two main modules: an Add/Update tab where users can log expenses (amount, category, notes) for any selected date, with existing entries pre-filled for easy editing; and an Analytics tab where users pick a date range to get a category-wise spending breakdown, visualized as a bar chart alongside a detailed table showing totals and percentage share per category. The backend exposes REST APIs (GET/POST for expenses, POST for analytics) built with FastAPI and Pydantic for data validation, while db_helper.py handles all MySQL queries using context-managed cursors. Custom logging was added to track database operations. This project demonstrates full-stack development skills — API design, database integration, and interactive UI/UX — beyond just data analysis

Python Project

Credit Card Loan Data Analysis & A/B Testing

Domain/Function: Data Analytics / A/B Testing

Performed exploratory data analysis on credit card customer data and ran A/B testing to evaluate marketing strategies. Uncovered the 18–25 age group as an underpenetrated, high-potential segment for targeted credit card offers

Bar chart comparing payment method usage across age groups — shows the 18–25 segment has notably lower credit card adoption than older groups, highlighting the growth opportunity

Comparison of average income, credit limit, and credit score across age groups — demonstrates the 18–25 segment's creditworthiness despite lower current product usage

Project Details

This project analyzed credit card customer data to uncover behavioral and demographic patterns, followed by A/B testing to evaluate the effectiveness of different marketing approaches. Using Python (pandas, matplotlib/seaborn) and statistical testing, I segmented customers by age, spending, and engagement, identifying the 18–25 age demographic as an untapped segment with strong growth potential. The A/B test compared response rates across customer groups to validate targeting hypotheses with statistical significance. Deliverables included visualizations of key trends and a data-backed recommendation to prioritize younger customers in future acquisition campaigns

Already have an account? Sign in