Ankit Garg

About Ankit Garg

I am a Data Analyst with 2 years of hands-on experience in data analysis and 2 years of prior experience as an MIS Executive. I have worked extensively with SQL, Python, Power BI, and Advanced Excel to analyze data, build dashboards, and deliver actionable business insights.My MIS background has helped me build a strong foundation in data accuracy, reporting, and business understanding, which I now apply in my role as a Data Analyst.operational datasets• Strong SQL skills (joins, subqueries, CTEs, aggregations)• Python (Pandas, NumPy) for data cleaning and analysis• Power BI dashboards for KPI tracking and decision support• Advanced Excel (Pivot Tables, XLOOKUP, Power Query)• Experience in data validation, automation, and process improvement• Ability to translate business requirements into data-driven insights

Experience

1. Data Analyst

   Credgenics

   Feb 2024 — Present

   Handled large amount of data for multiple clients like Yes Bank, Mahindra Finanace, Idfc, etc. ensuring integrity and accuracy of client information. Continuously improved the data preparation process through scripting and automation, thereby decreasing the dispatch time by 60% Utilized SQL to query data from databases, extracting relevant information for analysis and reporting. Performed data quality checks to validate accuracy and completeness of information, ensuring data reliability. Built a robust dashboard to communicate key performance metrics and communicate insights to executives and shareholders, enabling effective data driven decision making.

Education

• Central Board of Secondary Education

  12th, PCM

• Delhi Institute Of Tool Engineering

  B.Tech, Tool and Die Technology/Technician

  2012 — 2016

• Central Board of Secondary Education

  10th