Gagan Singh

About Gagan Singh

Data Analyst with expertise in SQL, Python (Pandas, NumPy, Matplotlib, Seaborn), Power BI, Excel, and Data Analytics. Passionate about working in an organization that fosters growth, led by strong leaders in Data Analytics. Eager to learn new technologies, with a strong work ethic and a commitment to excellence in all projects. Explored data on social media activities on Twitter using Excel and Power BI.Perform the data cleaning and data wrangling activities using the inbuilt ETL tool query editor of Power BI. Modeling of different datasets using snowflake schema and designing different DAX functions for better visualization and understanding of insights.Statistical analysis of data using Pandas libraries to validate the data quality.Generated the trended visualization using Matplotlib.

Experience

1. Data Analyst

   Akn & Co. Chartered Accountants

   Jan 2023 — Present · New Delhi, IN

   Cleaning of unorganized raw data to get organized data for better data analysisand Basic troubleshooting of the Windows operating system.• Extracting, analyzing, and reporting financial and Sales data from a range ofsources and building up relevant analysis from data to drive meaningful insights.• Applied advanced data manipulation techniques to ensure high accuracy andintegrity in the data. Using data analytics in airline businesses can plan flightroutes more efficiently.• Utilized Python, SQL & Power BI to develop comprehensive reports of sales data,dump sale data, and employee and financial data, resulting in a 15% increase indata-driven decision-making efficiency.• Executed efficient transformation and wrangling of raw, unorganized data,resulting in a 35% improvement in data quality for enhanced visualization andanalysis.• Led the meticulous collection and analysis of monthly sales data, implementingrigorous quality assessments that improved data completeness, correctness, andconsistency to 99%, resulting in trend reports that led to a 10% increase in salesby identifying underserved market• Specialized in creating insightful visualizations using Power BI, driving data-driven decision-making within the organization.• Achieved enhanced efficiency and accuracy in data handling by implementinginnovative solutions, resulting in improved decision-making processes• Ensuring the sustained functionality of the BI is paramount. I monitor and guarantee that the published BI remains current and undergoes automatic refreshes as needed. Moreover, I employ an additional server for the efficient distribution of Power BI Dashboard access to other employees, ensuring seamless sharing and accessibility across the organization. My comprehensive approach spans data collection, processing, visualization, and distribution, contributing to the organization\'s data-driven decision-making processes.

Education

• Raj Kumar Goel Institute of Technology, Ghaziabad

  Bachelor of Technology - B.Tech, Mechanical Engineering

  2014 — 2018

• Janta Janardan Inter College Bhurkura Chunar, Mirzapur, U.P.-231304

  12, Science