Headline

Data Analyst | SQL · Python · Power BI · Tableau · Advanced Excel | ETL Automation | Turning Messy Data into Decisions | Reduced Report Time 50% | Open to Relocate

About

I don't just build dashboards—I find the number that changes the decision. Two years into my analytics work, I analyzed 45,839 B2B invoice transactions for a real business and found a 65.6% payment delay rate that nobody had quantified before. I identified three root causes and proposed fixes projected to cut delays by 15–20%. That's the kind of work I'm here to do: not reporting what happened, but explaining why and what to do next. My day-to-day has been building end-to-end: writing SQL queries against messy transactional data, transforming it through Python (Pandas and NumPy), and shipping Power BI and Tableau dashboards that stakeholders actually use. I automated ETL pipelines that cut reporting time from 6 hours to 3 — not because it looked impressive, but because the team needed faster decisions. I've also applied ML where it adds real value. I built a food safety scoring model for 51,717 Zomato restaurants using Random Forest, balancing precision with interpretability so the output was usable, not just accurate. What I work with: SQL · MySQL · Python · Pandas · Power BI · DAX · Tableau · Advanced Excel · VBA · Scikit-learn · Git Certifications: AMCAT Certified Data Analyst · HackerRank 5-Star SQL · Cisco DevNet · Deloitte Forage (Data Analytics Simulation) MCA graduate, 9.27 GPA. Based in Bhopal—open to relocating to Hyderabad, Pune, Bangalore, or remotely. If you're hiring for a Data Analyst, BI Analyst, or Analytics Associate role and need someone who can own the full pipeline from raw data to decision, let's talk. 📧 harshdubey1970@gmail.com | 🔗 github.com/harshdubey1918

Location

Gurugram

Work experience

Data Analyst at SAI DHAM CABLE, Sep 2023 - Present · 2 yrs 10 mos, Gadarwara, Madhya Pradesh, India, Designed and maintained Power BI and Tableau dashboards tracking subscriber viewing habits and package adoption across [500] customers, enabling channel optimization decisions that reduced underperforming package retention costs. Integrated Microsoft SQL Server with EMM, ECM, and CAS operational systems to create a unified data layer; reduced manual cross-system reporting from [1 hr] to [2 hrs] per cycle. Built automated ETL pipelines in Excel/VBA for subscriber data extraction and transformation, cutting reporting turnaround time by 50% (6 hrs → 3 hrs). Developed KPI tracking framework for business operations; flagged [specific issue—e.g., churn patterns, billing anomalies] to lead back to customers

Education

Master of Computer Applications - MCA, Computer Science, LNCT Group of Colleges

Bachelor of Science - BSc(CA), Dot net. ,java, Rani Durgavati Vishwavidyalaya