Yogesh Kumar

Data Analyst

Kimbal Technologies•  September 2023 - Present•  Greater Noida

Spearheaded Excel data cleaning initiatives, including removing duplicates, handling missing values, and standardizing formats, resulting in improved data accuracy and reliability. Led data collection efforts from various sources, ensuring comprehensive and up-to-date datasets for analysis. Integrated data from multiple Excel sheets using advanced formulas and functions such as INDEX-MATCH, VLOOKUP, HLOOKUP, and IF statements, enhancing data coherence and accessibility. Utilized PivotTables and Pivot Charts to summarize and analyse complex datasets, providing valuable insights for decision-making processes. Designed and created visually appealing graphs and charts to represent trends, patterns, and outliers in data, facilitating easy interpretation for stakeholders. Developed and automated macros to streamline repetitive tasks, reducing manual effort and increasing efficiency in data processing. Established automated data fetching mechanisms to transfer data between sheets, enabling real-time updates and synchronization of information. Created interactive dashboards in Excel to visualize key performance indicators (KPIs) and metrics, enabling stakeholders to track performance and make informed decisions. Facilitated documentation processes and format implementation, ensuring compliance with organizational standards and guidelines. Liaised with the IT department to address IT-related requirements, submitting requests through email and coordinating resolution of technical issues. Managed documents printing and distribution, ensuring timely availability of necessary materials for meetings and presentations.

Mis Executive

Neha Enterprises•  January 2021 - August 2023

Generated detailed reports and dashboards using advanced software tools to provide insights on operational efficiency and areas for improvement. Conducted regular data analysis to identify trends, patterns, and anomalies, helping to optimize business processes and enhance overall performance. Managed and ensured the accuracy and integrity of data inputs and outputs, guaranteeing the reliability and relevance of MIS reports and analytics. Proficient in creating and maintaining complex Excel spreadsheets for data analysis and reporting purposes. Skilled in developing automated MIS reports using advanced Excel functions and formulas. Experienced in data visualization using charts, graphs, and pivot tables in Excel. Conducted data cleaning and validation procedures to ensure accuracy and reliability of financial data used in forecasting and budgeting activities. Combined data from various sources to create comprehensive financial models and reports. Designed and maintained Excel templates for financial analysis, scenario planning, and variance analysis. Assisted in the development of automated reports and templates to streamline repetitive tasks and improve team productivity. Utilized advanced Excel functions such as VLOOKUP, HLOOKUP, INDEX-MATCH, and IF statements to perform data analysis and manipulation.