Data analyst

Shubham Kumar Jha

+91-801******* ************@*****.***

LinkedIn Portfolio

PROFILE

Data Analyst skilled in collecting, cleaning, and analyzing large datasets to uncover business trends and optimize operations. Proficient in SQL, Excel, and Power BI for data visualization, dashboard development, reporting automation, and business intelligence solutions. Experienced in KPI development with a strong focus on transforming raw data into actionable insights that drive strategic decision-making. SKILLS

Programming & Analysis: SQL, Statistics, Data Cleaning, Data Transformation

Visualization & BI Tools: Power BI, Excel, DAX, Power Query, Dashboard Development, KPI Reporting

Data Processes: ETL, Reporting Automation, Business Intelligence, Predictive Analytics, Data-Driven Decision Making

Cloud & Platforms: Microsoft Azure (AI, Data, Security, Fundamentals) WORK EXPERIENCE

Cognizant – Programmer Analyst

May 2022 – Jun 2025

Monitored and ensured optimal performance and availability of infrastructure systems, including servers, networks, and databases.

Responded promptly to alerts concerning infrastructure issues, taking proactive and corrective actions to resolve them efficiently.

Collected, cleaned, and transformed large datasets using SQL and Excel to identify business trends and optimize operations.

Designed and developed Business Intelligence dashboards in Power BI, automating reporting processes and delivering actionable insights that reduced SLA breaches by 30% in monthly incident reports.

PROJECTS

Power BI Dashboard for E-Commerce Sales

Developed an interactive sales dashboard to track and analyze online sales performance, improving reporting efficiency by 40% and enabling real-time monitoring.

Utilized advanced and customized visualizations (bar, pie, donut, clustered bar, scatter, line, area, maps, slicers) to provide stakeholders with clear insights, increasing decision-making speed by 25%.

Implemented complex parameters, filters, and drill-down analysis, reducing manual analysis time by 35% and enhancing user adoption.

Live Weather Forecast Dashboard (API Integration)

Built a real-time weather forecast dashboard in Power BI by integrating live API data

(temperature, humidity, wind speed, forecast metrics).

Automated data refresh using Power Query and applied DAX for custom KPIs and time-series analysis.

Reduced manual reporting by 45% and enabled 100+ users to access up-to-date environmental insights for faster decision-making. CERTIFICATIONS

Microsoft Certified: Azure AI Fundamentals

Microsoft Certified: Azure Fundamentals (AZ-900)

Microsoft Certified: Azure Data Fundamentals

Microsoft Certified: Azure Security Fundamentals EDUCATION

Oriental College of Technology, Bhopal, India

Bachelor of Engineering – Mechanical Engineering 2016 – 2020

Contact this candidate