Data Analyst - SQL, Power BI, AI-Enhanced Analytics, Advanced Excel

ASHISH SINGH

+91-976******* *.*********@*****.*** Noida, Uttar Pradesh

Professional Summary

Detail-oriented Data Analyst with over 8 years of experience in data analysis, business intelligence, and performance reporting across development, government, and private sector environments. Strong expertise in SQL, Power BI, MIS, and statistical analysis, with proven ability to transform complex datasets into actionable insights. Experienced in AI-assisted analytics, prompt engineering, and data literacy, enabling faster analysis, smarter reporting, and improved decision-making for leadership and program teams. Adept at cross-functional collaboration, data governance, and automation of reporting systems. Core Skills

SQL & Databases: Complex Joins, Window Functions, CTEs, Subqueries, Views, Stored Procedures, Query Optimization.

Data Analysis & Statistics: Trend analysis, anomaly detection, KPI measurement, EDA, SPSS, STATA.

Business Intelligence & MIS: Power BI dashboards, DAX, data modelling, advanced Excel, report automation .

AI & Emerging Skills: Prompt Engineering, AI-aided Data Analysis, AI Integration in Reporting, Data Literacy & Insight Communication.

Tools & Platforms: Power BI, Excel, SQL Server, MySQL, SPSS, STATA, R (Basic), Salesforce, KOBO, SurveyMonkey, Google Analytics, Magpi.

Soft Skills: Stakeholder Communication, Requirement Gathering, Documentation, Training & Support.

Professional Experience

1) Data Analyst (M&E Officer) Brooke India, Noida August 2021 – March 2026

Lead end-to-end data analysis for multi-location programmes using advanced SQL, ensuring high data accuracy and integrity.

Design, develop, and maintain Power BI dashboards for KPIs, trend monitoring, management reviews and donor reporting.

Automate recurring MIS and analytical reports, reducing manual workload by 40% and improving turnaround time.

Apply prompt engineering to leverage AI tools for rapid data exploration, indicator interpretation and report drafting.

Integrate AI-helped analytics into workflows for data cleaning logic, trend detection, and dashboard narration.

Strengthen data literacy across program and field teams by translating complex datasets into actionable insights.

Collaborate with program, operations, and IT teams to define data requirements and deliver analytical solutions.

Conduct UAT, troubleshoot data inconsistencies, and support continuous improvement of data systems.

Support monitoring frameworks, restricted fund reporting, and evidence generation for internal and external stakeholders.

2) Data Analyst (M&E Assistant) National Health Mission, U.P. Govt. July 2018 – July 2021

Analysed large-scale HMIS and RCH datasets using SQL, ensuring validation and data quality across districts.

Prepared divisional and district-level analytical bulletins, dashboards, and performance reports.

Tracked key health indicators and identified trends, anomalies, and data gaps for corrective action.

Conducted statistical analysis using SPSS and STATA to support programme monitoring.

Supported field monitoring, data audits, and capacity building of district-level staff Technical Skills

Languages: SQL, R, Basic Knowledge of Python & C#

BI & Analytics Tools: Power BI, Advanced Excel, SPSS, STATA, Crystal Reports.

Platforms: Salesforce, KOBO, Survey Monkey, Google Analytics, Magpi, Microsoft 365

Database: SQL Server, My SQL

Technical Projects

Power BI KPI Dashboard Project

Designed an interactive Power BI dashboard to monitor operational KPIs, donor indicators, and programme performance.

Implemented DAX calculations, drill-down reports, and automated refresh schedules.

Enabled leadership teams to track trends, regional performance, and target achievement in real time. SQL Data Validation & Reporting Automation

Developed SQL scripts for automated data extraction, transformation, and validation.

Created reusable SQL views and reporting templates for recurring MIS reports.

Reduced manual data processing and improved reporting accuracy. Healthcare Data Analytics Project

Analysed HMIS datasets to identify trends, reporting gaps, and district-level performance issues.

Built comparative reports and dashboards supporting healthcare programme monitoring. Education

PG Diploma in Information Technology – Symbiosis Centre for Distance Learning, Pune (2013)

Bachelor of Science – Dr B.R. Ambedkar University, Agra (2008) Achievements

Led district-level evaluations and supported successful donor reporting.

Organized field assessments and academic/professional events.

Recognized for team contributions and analytical problem-solving skills. Certifications

Microsoft Power BI Data Analyst – Coursera

Data Science Foundations using R – Coursera

SQL for Data Science – Coursera

Lead Management in Salesforce – Coursera

Cybersecurity Awareness & Digital Safety – Udemy Declaration

I hereby affirm that the information provided above is accurate and complete to the best of my knowledge and belief.

Date:

Place: Noida [ASHISH SINGH]

Contact this candidate