Summary
Overview
Work History
Education
Skills
Websites
Certification
Projects
Languages
Timeline
Generic
Ramesh Pandey

Ramesh Pandey

Kanpur

Summary

Dedicated and detail-oriented Data Analysis enthusiast, eager to embark on a dynamic career in leveraging data for strategic decision-making. Armed with a solid foundation in SQL, Python, Excel, and Power BI. Bring a passion for transforming raw information into actionable insights. Adept at conducting comprehensive data analysis. Excited to contribute to projects that demand precision, analytical thinking, and a thirst for continuous learning.

Overview

1
1
Certification

Work History

Business Analyst Intern

KultureHire
01.2024 - Current
  • Developed and maintained data warehouses and data marts to support business operations.
  • Managed time efficiently in order to complete all tasks within deadlines.
  • Gained extensive knowledge in data entry, analysis and reporting.
  • Identified patterns and trends in large data sets and provided actionable insights.
  • Developed complex dashboard and reporting tools to track business performance metrics.
  • Leveraged SQL queries to extract relevant data from databases for further analysis and reporting purposes.
  • Analyzed data to identify root causes of problems and recommend corrective actions.

Data Analyst

Psyliq
01.2024 - 02.2024
  • Implemented robust quality control measures to minimize errors and improve reliability of analytical outputs.
  • Improved decision-making processes with accurate data analysis and visualization techniques.
  • Utilized data visualization tools to effectively communicate business insights.
  • Documented effective and replicable methods for extracting data and organizing data sources.
  • Generated standard and custom reports to provide insights into business performance.
  • Utilized data visualization techniques to present and explain complex data sets.
  • Analyzed data to identify root causes of problems and recommend corrective actions.
  • Extracted and interpreted data patterns to translate findings into actionable outcomes.

Education

Bachelor's in Computer Application - Information Technology

Maharana Pratap College of Management & IT
Kanpur, India
10.2015

Higher Secondary - Science

Kendriya Vidyalaya
Kanpur
04.2012

Secondary School -

Kendriya Vidyalaya
Kanpur, India
04.2010

Skills

    • Intelligence Analysis
    • SQL Proficiency
    • Data organization
    • Business Analysis
    • Microsoft Excel
    • Predictive modeling
    • Model Development
      • SWOT Analysis
      • SQL and Databases
      • Data Analysis
      • Financial Data Analysis
      • Requirements Analysis
      • Pivot tables
      • Data and Analytics

Certification

  • Google Data Analytics Certification by Coursera - Dec 2023
  • IBM Data Analysis with Python by Coursera - Feb 2024

Projects

Projects :


  • Diabetes Prediction: - Diabetes Prediction project, leveraging advanced analytics techniques to predict the likelihood of individuals developing diabetes. The primary objective was to build a predictive dashboard providing insights for healthcare professionals and individuals to take proactive measures.
  • Achieved a detection rate of 15% in identifying patients at risk of developing diabetes.


  • HR Analytics Dashboard: - HR Analytics Dashboard project, employing data analytics to enhance HR decision-making processes. The project aimed to create an insightful dashboard providing actionable information for HR professionals.
  • The HR Analytics Dashboard project significantly contributed to HR decision-making, fostering a data-driven culture within the organization. Notably, the project led to a 10% rise in employee satisfaction and a 12% improvement in performance metrics.


  • Employee Analysis Dashboard: - Employee Analysis Dashboard, utilizing data analytics to provide comprehensive insights into employee performance, satisfaction, and engagement. The primary goal was to empower management with actionable data for informed decision-making.
  • The Employee Analysis Dashboard significantly contributed to proactive human resource management, resulting in a 20% reduction in turnover and a targeted 15% improvement in employee engagement.

Languages

English
Advanced (C1)
Hindi
Bilingual or Proficient (C2)

Timeline

Business Analyst Intern

KultureHire
01.2024 - Current

Data Analyst

Psyliq
01.2024 - 02.2024

Bachelor's in Computer Application - Information Technology

Maharana Pratap College of Management & IT

Higher Secondary - Science

Kendriya Vidyalaya

Secondary School -

Kendriya Vidyalaya
Ramesh Pandey