Summary
Overview
Work History
Education
Skills
Certification
Awards
Accomplishments
Extracurricular Activities
Software
Hobbies
Timeline
Generic

Ankit

Business Analyst
Bengaluru

Summary

Dynamic Business Analyst with expertise in Excel, Python, and SQL, skilled in creating interactive visualizations using Power BI. Known for client engagement, problem-solving, and providing strategic insights. Proven track record in streamlining data processes and supporting product development with data-driven solutions.

Overview

1
1
year of professional experience
5
5
Certifications

Work History

Business Analyst

SIM ADVISORY MANAGEMENT CONSULTING
12.2023 - Current

Key Responsibilities and Achievements:

  • Data Analysis: Utilized Excel, Python, and SQL for comprehensive data analysis and maintained sophisticated Excel dashboards.
  • Visualizations: Created interactive dashboards using Power BI for clear and effective data presentations.
  • Client Engagement: Delivered tailored solutions by understanding client challenges and presenting findings effectively.
  • Communication and Collaboration: Strong communication skills with a proven ability to solve problems and collaborate with cross-functional teams.
  • Strategic Insights: Identified trends and provided actionable insights to improve business strategies.
  • Process Optimization: Streamlined data collection processes, enhancing efficiency and data accuracy.
  • Advanced Excel: Analyzed large datasets, cleaned data, and created reports and dashboards.
  • Python Projects: Applied Python for data analysis, and did one project .i.e. Bundle Analysis.
  • SQL Expertise: Managed database queries and optimized stored procedures.
  • Product Collaboration: Worked with product managers to support product development with data-driven insights.

Delivered high-quality analytical solutions that drove business success and client satisfaction.

Education

Bachelor's of Technology(BTECH) - Civil Engineering

Amity University
Lucknow, India
04.2001 -

Masters of Technology(MTECH) - Industrial Engineering

Indian Institute of Technology Kharagpur
Kharagpur, India
04.2001 -

Skills

    Data Analysis

    SQL Proficiency

    Microsoft Excel Mastery

    Python Programming

    Machine Learning

    Power BI Tools

    Consulting

    Product Management

Certification

Automate the Boring Stuff with Python Programming | Udemy

Awards

  • Among 145064 students of civil engineering secured 77.31 percentile in the GATE CE 2019
  • Among 115270 students of civil engineering secured 96.67 percentile in the GATE CE 2021
  • All India Rank 360 in Graduate Aptitude Test in Engineering (GATE) PE 2022
  • Mentorship: School Head boy, Guided students during making assembly line and Volunteered them in school functions.

Accomplishments

  • Secured a 77.31 percentile among 145,064 civil engineering students in GATE CE 2019 and a 96.67 percentile among 115,270 students in GATE CE 2021. Achieved All India Rank 360 in GATE PE 2022.

Extracurricular Activities

Mentorship: School Head boy, Guided students during making assembly line and Volunteered them in school functions.

Software

Power BI

MS Excel

Python

SQL

Hobbies

  • Watching and playing cricket
  • Playing badminton
  • Sometimes reading books

Timeline

Business Analyst

SIM ADVISORY MANAGEMENT CONSULTING
12.2023 - Current

Bachelor's of Technology(BTECH) - Civil Engineering

Amity University
04.2001 -

Masters of Technology(MTECH) - Industrial Engineering

Indian Institute of Technology Kharagpur
04.2001 -
Automate the Boring Stuff with Python Programming | Udemy
Python for Data Science and Machine Learning Boot camp | Udemy
English and Communication Skills | Amity School of languages
Behavioral Science | Amity Institute of Behavioral &Allied Science
Data Visualization: Empowering Business with Effective Insights | TATA (Forage)
Ankit Business Analyst