Back to Developers
Deepak Gautam

Deepak Gautam

Data Analyst

Chirag Delhi, New Delhi
80
Profile Score

About

Data Analyst with 5 years of experience in data analysis, reporting, and dashboard development. Strong expertise in Advanced Excel (including Macros), SQL, and Power BI to extract, analyze, and visualize data for actionable insights. Proven ability to automate reports, improve data accuracy, and streamline workflows to enhance operational efficiency. Adept at working with large datasets, identifying trends, and translating complex data into clear, decision-ready insights. Collaborates effectively with cross-functional teams to understand business requirements and deliver data-driven solutions that support strategic objectives.

Skills & Expertise (18)

Advanced Excel Advanced
8.6/10
4
Years Exp
Power BI Intermediate
7.8/10
2
Years Exp
SQL Intermediate
7.6/10
3
Years Exp
Project Presentation Pivot Tables VLOOKUP Data Analyses Innovative and Critical Thinking Effective Communication Project Management Teamwork & Collaboration Google Ads MySql Looker Studio Google Workspace MS Office Suite Power Query Macros

Work Experience

Project Assistant

CDFD || Government Autonomous

Oct 2024 - Jan 2026

Managed and analyzed data for 90+ R&D projects using Advanced Excel and SQL, ensuring accuracy and timely reporting. Generated daily, weekly, and monthly MIS reports by consolidating data from multiple departments. Automated reporting processes using Advanced Excel (Pivot Tables, VLOOKUP, Macros) and Power Query to improve efficiency. Created interactive dashboards and analytical reports to track project performance and financial data. Performed data validation, exception analysis, and troubleshooting to maintain data quality. Coordinated with finance, accounts, and project teams for data collection and reporting. Presented insights through Power BI reports and visual dashboards for management decision-making.

UDC

THSTI || Government Autonomous

May 2022 - Sep 2024

Developed and maintained Excel dashboards and reports to track project status, fund disbursement, and compliance with government guidelines. Managed and analyzed project data, preparing financial summaries, budget trackers, and allocation reports for planning and audit readiness. Performed data verification and documentation for project closure, ensuring compliance with financial and audit standards. Assisted in preparing draft notes, financial analysis, and supporting documents to support decision-making and fund allocation. Supported administration of DBT-funded projects (including ZBSA) by managing documentation, coordination, and data tracking. Collaborated with internal teams to improve reporting accuracy, streamline processes, and enhance coordination.

Management Assistant

DBT| NABI Project || Government Autonomous

May 2021 - Jan 2022

Analyzed research data, project outcomes, and program performance, preparing detailed reports for senior management and government reviews. Developed data-driven dashboards and presentations using Advanced Excel and PowerPoint to visualize key metrics, funding distribution, and project progress. Maintained project timelines and master tracking sheets, ensuring accurate and consistent reporting. Managed the end-to-end funding lifecycle of DBT-funded R&D projects, including annual grant releases and compliance monitoring. Coordinated with Principal Investigators (PIs) from leading research institutes and hospitals to ensure smooth project execution.

Education

NIELIT 'O' Level - NIELIT

2022 - 2023 · Afghanistan

Master of Arts - IGNOU

2020 - 2022 · Afghanistan

Bachelor of Arts - University of Delhi

2014 - 2019 · Afghanistan

Diploma in Hardware & Networking (IT Tools & Business Systems, Networking) - Delhi Institute of Computer Science

- · Afghanistan

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 5/15
💰 Rate 0/5
🏆 Certs 0/5
Verified 5/5
Total Score 80/100

Profile Overview

Member sinceMar 2026

Availability Details

Relocation

Open to Relocation

Skills (18)

Advanced Excel Power BI SQL Project Presentation Pivot Tables VLOOKUP Data Analyses Innovative and Critical Thinking Effective Communication Project Management +8 more