Harit Prem Rajput

Business Analyst

Gurugram, Haryana, India2 yrs 5 mos experience
Most Likely To Switch

Key Highlights

  • Led team analysis across 245K tower sites.
  • Achieved 4% YoY improvement in Alarm Quality Index.
  • Developed interactive dashboards for real-time tracking.
Stackforce AI infers this person is a Data Analyst with expertise in Telecommunications and Data Visualization.

Contact

Skills

Core Skills

Data AnalysisData VisualizationDatabase Development

Other Skills

AccountingAccounting SoftwareAlteryxAnalytical ReasoningAnalytical SkillsAnalytical SupportAnalyticsBusiness AnalysisBusiness InsightsBusiness Intelligence (BI)CollaborationCritical ThinkingData CleaningData IntegrityData Manipulation

About

As a detail-oriented Data Analyst with hands-on experience in Python, SQL and advanced Excel, I specialize in turning raw data into actionable insights. My proficiency in data analysis tools like Pandas, NumPy and Scikit-learn allows me to perform in-depth exploratory data analysis (EDA) and statistical modelling. I am highly skilled in data visualization tools like Tableau, Power BI and Seaborn, creating dynamic dashboards that drive business decisions. I have hands-on experience leading a team to analyze critical operational metrics across 245K+ tower sites, driving actionable insights for process optimization. Achieved a 4% YoY improvement in the Alarm Quality Index and a 3% increase in site uptime through root cause analysis. Identified inefficiencies in diesel consumption across 143K sites, extending battery backup duration by 15% and reducing variance by 8%. Throughout my experience with PwC and other organizations, I’ve developed and maintained databases, reduced processing times and collaborated across teams to ensure data integrity and efficiency. With expertise in VBA, Power Query and ETL processes, I handle data wrangling and preparation to streamline workflows. Key Skills: Data Analysis (Python, SQL, Excel) Data Visualization (Tableau, Power BI, Matplotlib) Statistical Modeling and Regression Data Wrangling and Integration (VBA, Alteryx, Power Query) Project Management and Problem Solving I am passionate about leveraging data to improve decision-making processes and continuously refining my skill set to stay ahead in the evolving field of data analytics.

Experience

Indus towers limited

Associate (Data Analyst)

Aug 2024Present · 1 yr 7 mos · Gurugram, Haryana, India · On-site

  • Led a team of 6 to Analyze critical metrics including Alarm Quality Index, Battery Duration, Diesel Variance, Uptime and Outage Reduction across 245K tower sites, driving actionable insights for operational improvements.
  • Improved Alarm Quality Index by 4% YoY (from 84% to 88%) and increased site uptime by 3% through root cause analysis and process optimization.
  • Analyzed diesel consumption variance across 143K diesel-powered sites, identifying inefficiencies and extended battery backup duration by 15% by analyzing consumption patterns, reducing variance by 8% using Python (Pandas, NumPy).
  • Developed interactive dashboards using SQL, Power BI and Excel enabling real-time performance tracking and data-driven decisions.
PythonSQLExcelData VisualizationPower BIRoot Cause Analysis+1

Pwc

Associate (Data Analyst) (Fixed Term Hire)

Nov 2023Apr 2024 · 5 mos · Kolkata, West Bengal, India · Remote

  • Analyzed financial transactions for PwC clients to ensure audit accuracy
  • Scrutinized general ledger entries, resolved discrepancies and collaborated with the Assurance Team to provide analytical support
  • Maintained data integrity through effective quality checks
  • Compiled detailed reports on findings for process improvement
Data IntegrityAnalytical SupportQuality ChecksData Analysis

Daps

Database Developer

May 2023Oct 2023 · 5 mos · Noida, Uttar Pradesh, India · Remote

  • Developed and maintained a web application database, resulting in an 80% reduction in response time to enhance performance
  • Executed data manipulations and queries using SQL Server, processing an average of 100 records daily.
  • Addressed data requirements and resolved issues with the Frontend development team, ensuring quicker glitch resolution
SQL ServerData ManipulationWeb Application DevelopmentDatabase Development

Trainity

Data Analyst Intern

Apr 2023May 2023 · 1 mo · Mumbai, Maharashtra, India · Remote

  • Conducted a case study of Instagram users’ data to identify the oldest users, most common hashtags and bots/fake accounts
  • Implemented rewards based on defined criteria
  • Created dynamic visualizations like charts and graphs to enhance data understanding leading to increased stakeholder engagement and improved decision-making efficiency.
Data VisualizationDynamic VisualizationsData Analysis

Ineuron.ai

Data Analyst Intern

Mar 2023Apr 2023 · 1 mo · Bengaluru, Karnataka, India · Remote

  • Performed data cleaning and analysis using tools such as Excel, Python, and Tableau
  • Collaborated to decrease the time required to access key insights, contributing to informed decision-making
Data CleaningData AnalysisCollaboration

Education

Indian Institute of Technology Madras

PG Diploma — Data Science

May 2024Present

Dr. Bhim Rao Ambedkar University, Agra

Master of Science - MS — Mathematics

Apr 2021Jan 2023

Dr. A.P.J. Abdul Kalam Technical University

Bachelor of Technology - BTech — Mechanical Engineering

Aug 2012Jun 2016

Stackforce found 100+ more professionals with Data Analysis & Data Visualization

Explore similar profiles based on matching skills and experience