NITESH KUMAR
******************@*****.***
Data Analyst with 3+ years of experience in analytics, dash boarding, and business intelligence. Skilled in Power BI, SQL, Excel, and Python, with a strong background in automating data workflows, building visualizations, and improving decision-making. Experienced in Agile delivery, requirement translation, and effort estimation with strong problem-solving and logical thinking skills. Professional Summary
+91-914******* LinkedIn
Software Engineer
Analytics Tools: Power BI, DAX, Excel (Advanced), Tableau Salesforce Programming: SQL, Python
Data Handling: ETL (Extract, Transform, Load), Data Cleansing, Power Query, Data Validation, Data Modeling, Data Profiling. DevOps & Cloud: Git, Docker, Azure.
Methodologies & Practices: Agile (Scrum), SDLC, Requirement Translation, Effort Estimation, Software Design Principles, Quality Processes Technical Skills
Work Experience
Futops Technologies India Pvt Ltd (Software Engineer) March 2023 - Present
Designed real-time Power BI dashboards for smart city surveillance and traffic monitoring using AI-driven detections. Developed dynamic KPIs and time-series analytics for object counts, detection accuracy, and congestion trends. Integrated AI vision data into structured formats using advanced SQL queries for actionable insights. Collaborated with AI/ML and traffic operations teams to enhance dashboard usability and relevance. Gathered business requirements and translated them into technical BI specifications, providing estimation inputs for delivery planning. Created drill-down visualizations and delivered insights on traffic patterns, translating requirements into BI solutions with accurate estimations. Followed full SDLC lifecycle from requirement gathering design development validation deployment for BI and reporting solutions. Worked in Agile sprints with daily stand-ups, sprint reviews, and iterative delivery of BI dashboards. Highlighted Projects
Developed Power BI dashboards to visualize real-time vehicle classification (bikes, cars, buses, trucks) using AI metadata from surveillance feeds. Enabled zone-wise and time-based filtering to support raffic analysis. Automated data preparation using Power Query and built custom DAX measures for KPI tracking. TB-Eye – AI-Based Traffic Intelligence
Awards & Achievements
Education
B.E. Computer Engineering, D.Y. Patil Institute,
Pune 2017–2021
CGPA: 7.4/10
Created a Power BI reporting solution to monitor vehicle counts and sensor data from edge-deployed traffic counters. Integrated near real-time data using Power Query and SQL pipelines. Built dashboards to track sensor health, data accuracy, and traffic flow patterns. Traffic Counter Edge – Edge Device Analytics
Design and develop of reporting data module for Monthly, Quarterly & Yearly sales & revenue Analysis. Developed several visualizations and drill through reports to state the project level utilization. Created Row level security with power bi and integration services with power bi services portal for different teams present in the in-line supply chain.
Supply Chain Analysis
Revenue Intelligence Dashboard
Built interactive Power BI dashboards to monitor pricing, event revenue, and guest engagement trends in the hospitality domain. Developed KPI-driven reports for pricing optimization and guest retention. Used Power Query and DAX for data modeling and ETL automation
Global Sales Dashboard (Power BI Capstone Project) Used Power BI & DAX to build regional insights and trend charts. Integrated multiple Excel sources using Power Query for analysis. Microsoft Power BI Certification, Pune — Mar 2022
Salesforce Tableau Data Analyst Ceritification -2025 Created a capstone global sales dashboard segmented by region and sector. Designed and deployed interactive Power BI dashboards to track event pricing, key business areas, and revenue opportunities. Built and monitored KPIs in Power BI to mitigate risks and improve strategic decision-making. Conducted data analysis on footfall, hospitality performance, and customer satisfaction to identify trends and improvement areas. Aamby Valley City, Pune, India ( Jr. Data Analyst ) Aug 2021 – Mar 2023