AMIT KUMAR KHUSHWAHA
Data Analyst Product Analyst
Abu Road, Rajasthan, India Open to Remote +91-861******* ****************@*****.*** GitHub ; https://github.com/Amit-Product-Analytics LinkedIn ; https://www.linkedin.com/in/amit-kumar-khushwaha-238525416/ PROFESSIONAL SUMMARY
Data professional with a 6-month analytics internship and hands-on experience across Data Analytics, BI & Reporting, and Data Engineering. Skilled in SQL, Python/Pandas, Power BI, Excel, Databricks, MySQL and SQL Server, with practical experience in ETL automation, data warehousing, dimensional modeling, DAX, dashboard development and business analysis. Able to work across the complete data lifecycle—from raw data and transformation to analytical models, dashboards, reporting and business insights. TECHNICAL SKILLS
Programming & Data Analysis: SQL, Python, Pandas, NumPy, Microsoft Excel Data Visualization & BI: Power BI (Data Modeling, Power Query, DAX, KPI Dashboards, Row-Level Security) Database: MySQL, SQL Server, Databricks
SQL: Joins, CTEs, Window Functions, Subqueries, CASE Statements, Views, Stored Procedures, Bulk Loading Product Analytics: Funnel Analysis, Cohort Analysis, Retention, Churn, RFM, A/B Testing, Customer Segmentation Data Engineering: ETL, Data Cleaning, Data Validation, Automation, Bronze-Silver-Gold Architecture, Data Warehousing, Dimensional Modeling
Business Metrics: MRR, ARR, ARPU, Churn Rate, Retention Rate, Conversion Rate, CAC, CLV, AOV Version Control: Git, GitHub
SELECTED ANALYTICS & DATA ENGINEERING PROJECTS
Self-directed analytics projects June 2026 – Present SQL Data Warehouse & Analytics Engineering SQL Server T-SQL ETL
• Built Bronze, Silver and Gold warehouse layers integrating CRM and ERP source data with bulk-loading stored procedures, validation, transformations and error handling.
• Created customer/product dimensions and a sales fact layer for trend analysis, segmentation, AOV, cumulative metrics and customer/product performance.
Medi Flow — Automated Healthcare ETL Pipeline Python Pandas Stream lit MySQL Power BI
• Conceptualized an automated Upload Clean Transform Store Analyze workflow to reduce repetitive manual data preparation.
• Connected Stream lit, Python/Pandas, MySQL and Power BI using separate raw, clean and staging layers for controlled processing and downstream analytics.
Shop Stream — End-to-End Product Analytics MySQL Power BI DAX Excel
• Built an end-to-end product analytics workflow from raw transactional data to interactive dashboards and business insights.
• Applied Funnel, Cohort, Retention, Churn and RFM analysis to evaluate customer behavior, conversion, revenue and customer segments.
Power BI Data Modeling & Row-Level Security Power BI Star Schema DAX RLS
• Transformed operational tables into fact and dimension models and implemented user-based Row-Level Security
(RLS) with role testing and regional-access validation. Databricks Emissions Analytics Databricks SQL Dashboarding
• Analyzed U.S. county-level emissions data with Databricks SQL and built an interactive dashboard using KPIs, filters, maps, scatter analysis, rankings and detailed tables. OTHER PROFESSIONAL EXPERIENCE
Data Analyst Intern Last Mile Services Jan 2026 – Jun 2026
• Cleaned and validated logistics data, developed SQL queries for reporting and analysis, created interactive Power BI dashboards, prepared MIS reports and transformed operational data into actionable business insights. Independent Construction Project Manager 2024 – 2026
• Managed residential construction projects end-to-end — budgeting, vendor negotiation, and execution — reducing costs through structured resource planning.
Event Management Consultant 2023 – 2026
• Led cross-functional teams and vendor coordination for event planning, budgeting, and delivery, improving operational efficiency.
Admission Counselor & Network Marketing — eBIZ.com Pvt. Ltd. 2016 – 2020
• Built and managed a 75+ member network; elected Coordinator (2017–18) by peer vote for leadership and team building.
EDUCATION
Bachelor of Technology, Mechanical Engineering — Rajasthan Technical University, Kota 2021