ANKIT RAJ MISHRA

Business Analyst

Gurugram, Haryana, India4 yrs 9 mos experience
AI EnabledAI ML Practitioner

Key Highlights

  • Over 2 years of data analysis experience at IndiGo.
  • Expert in SQL, Power BI, and data visualization.
  • Proven track record in data cleaning and validation.
Stackforce AI infers this person is a Data Analyst with expertise in Aviation and Data Analytics.

Contact

Skills

Core Skills

Data AnalysisData VisualizationLeadership

Other Skills

SQLMicrosoft ExcelPower BISnowflakeData CleaningData ValidationSQL Server queryingData wranglingStatistical analysisCommunicationWritten CommunicationData InterpretationTransportationHighway engineeringStructure

About

-------------------------------------------------------------------------------- BIRD EYE VIEW - PROFESSIONAL EXPERIENCE AND SKILLSET SUMMARY -------------------------------------------------------------------------------- • Employment: IndiGo: Offer Customer Dashboard Analysis using Power BI • Core Technologies: MS-Excel, SQL, Python, Power BI, Tableau, Google Data Studio, Statistics • Soft Skills: Solved complex challenges by analyzing data patterns and implementing solutions & delivered impactful presentations to management --------------------------------------------------------------------------------- Portfolio Work:- YouTube:- https://www.youtube.com/@ankitrajmishra01 Peerlist:-https://peerlist.io/ankitrajmishra GitHub:- https://github.com/0111rajankit Tableau Public:- https://public.tableau.com/app/profile/ankitrajmishra/vizzes -------------------------------------------------------------------------------- As a seasoned Data Analyst with over 2+ years of experience at IndiGo Airlines, I bring a dynamic blend of technical expertise and analytical prowess to the world of data. Leveraging my skills in SQL, Microsoft Excel, and Power BI, I have consistently driven data-driven decision-making, unraveling hidden insights within complex datasets. In my current role as a Data Analyst at IndiGo, I manage the end-to-end data analysis process. After gathering data from various sources—such as Excel sheets, SQL Server, team inputs, and Power BI reports—I clean and validate it to ensure accuracy. Based on business requirements, I then design and develop dashboards that present meaningful insights for informed decision-making My analytical skills come to the forefront during the analysis and interpretation phase. I identify key trends, uncover hidden correlations, and translate these insights into actionable solutions for informed decision-making across various business functions. Visualization and communication are integral to my role, and I excel in presenting findings through compelling data visualizations and reports tailored to diverse audiences. I am passionate about extracting hidden value from information and contributing to data-driven decision-making. I look forward to leveraging my skills and experience to drive success in the dynamic field of data analytics.

Experience

Indigo (interglobe aviation ltd)

Data Analyst

Dec 2024Present · 1 yr 3 mos · Gurugram, Haryana, India · On-site

  • 𝐊𝐞𝐲 𝐑𝐞𝐬𝐩𝐨𝐧𝐬𝐢𝐛𝐢𝐥𝐢𝐭𝐢𝐞𝐬:
  • → Collaborate with cross-functional teams and senior management to gather reporting and dashboard requirements for the 𝐂𝐮𝐬𝐭𝐨𝐦𝐞𝐫 𝐃𝐚𝐭𝐚 𝐏𝐥𝐚𝐭𝐟𝐨𝐫𝐦 (𝐂𝐃𝐏)
  • → 𝐃𝐞𝐬𝐢𝐠𝐧 𝐚𝐧𝐝 𝐝𝐞𝐯𝐞𝐥𝐨𝐩 𝐢𝐧𝐭𝐞𝐫𝐚𝐜𝐭𝐢𝐯𝐞 𝐚𝐧𝐝 𝐢𝐧𝐬𝐢𝐠𝐡𝐭𝐟𝐮𝐥 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 𝐝𝐚𝐬𝐡𝐛𝐨𝐚𝐫𝐝𝐬 tailored to business needs, focusing on customer data and performance metrics.
  • → Connect and manage datasets using 𝐒𝐧𝐨𝐰𝐟𝐥𝐚𝐤𝐞 𝐚𝐧𝐝 𝐒𝐐𝐋 𝐒𝐞𝐫𝐯𝐞𝐫 𝐦𝐚𝐧𝐚𝐠𝐞𝐦𝐞𝐧𝐭 𝐒𝐭𝐮𝐝𝐢𝐨 (𝐒𝐒𝐌𝐒) as the primary database management system.
  • →𝐖𝐫𝐢𝐭𝐞 𝐨𝐩𝐭𝐢𝐦𝐢𝐳𝐞𝐝 𝐒𝐐𝐋 𝐪𝐮𝐞𝐫𝐢𝐞𝐬 𝐭𝐨 𝐞𝐱𝐭𝐫𝐚𝐜𝐭, 𝐭𝐫𝐚𝐧𝐬𝐟𝐨𝐫𝐦, 𝐚𝐧𝐝 𝐚𝐧𝐚𝐥𝐲𝐳𝐞 𝐥𝐚𝐫𝐠𝐞 𝐯𝐨𝐥𝐮𝐦𝐞𝐬 𝐨𝐟 𝐜𝐮𝐬𝐭𝐨𝐦𝐞𝐫-𝐫𝐞𝐥𝐚𝐭𝐞𝐝 𝐝𝐚𝐭𝐚.
  • → 𝐏𝐞𝐫𝐟𝐨𝐫𝐦 𝐝𝐚𝐭𝐚 𝐜𝐥𝐞𝐚𝐧𝐢𝐧𝐠, 𝐯𝐚𝐥𝐢𝐝𝐚𝐭𝐢𝐨𝐧, 𝐚𝐧𝐝 𝐩𝐫𝐞𝐩𝐫𝐨𝐜𝐞𝐬𝐬𝐢𝐧𝐠 to ensure accuracy and consistency before visualization.
  • → 𝐏𝐮𝐛𝐥𝐢𝐬𝐡 𝐚𝐧𝐝 𝐦𝐚𝐢𝐧𝐭𝐚𝐢𝐧 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 𝐝𝐚𝐬𝐡𝐛𝐨𝐚𝐫𝐝𝐬 on the server for stakeholder access and regular usage.
  • → Occasionally utilize 𝐌𝐒 𝐄𝐱𝐜𝐞𝐥 for quick data checks, ad-hoc reporting, and preliminary analysis.
  • → Ensure timely delivery of analytics solutions while maintaining data integrity and report performance.
SQLMicrosoft ExcelPower BISnowflakeData CleaningData Validation+2

Uber

Data Analyst

Oct 2024Dec 2024 · 2 mos · Gurugram, Haryana, India · Hybrid

Infosys

2 roles

System Engineer

Nov 2022Jul 2024 · 1 yr 8 mos · Remote

  • Extracting actionable insights and driving data-driven decision-making.
  • I leverage my expertise in data analysis to unlock hidden trends and patterns within complex datasets. My primary focus lies in:
  • Data Acquisition: Gathering data from diverse sources, including team inputs, Excel sheets, SQL Server queries, and Power BI reports.
  • Data wrangling and cleansing: Ensuring data accuracy and integrity through meticulous cleaning and preparation.
  • Analysis and interpretation: Utilizing robust analytical techniques to identify key trends, uncover hidden correlations, and translate insights into actionable solutions.
  • Visualization and communication: Effectively communicating findings through compelling data visualizations and reports, tailored to various audiences.
  • Skilled in:
  • SQL Server querying
  • Data wrangling in Excel and Power BI
  • Statistical analysis and trend identification
  • Data visualization and storytelling
SQL Server queryingData wranglingStatistical analysisData visualizationData AnalysisData Visualization

Internship Trainee

Feb 2022Nov 2022 · 9 mos · Remote

  • Working with relational databases, like SQL, to extract and manipulate data for analysis
  • Experience in data exploration and analysis, identifying patterns and trends
  • Familiarity with data cleaning and wrangling techniques through test case creation, ensuring data accuracy
  • Ability to communicate insights clearly through presentations, which is similar to creating test reports
SQLData AnalysisCommunication

Indian institute of technology (banaras hindu university), varanasi

Departmental Post-Graduate Committee (DPGC)

Jul 2020May 2022 · 1 yr 10 mos · Varanasi, Uttar Pradesh, India · On-site

  • Bridging the gap between the M.Tech cohort and the college, I wear the dual hat of communicator and advocate. As their elected representative, I navigate the corridors of academia, amplifying student voices and championing their concerns. From gathering feedback and securing positive changes to fostering a vibrant community through engaging events, I'm committed to shaping a fulfilling and successful academic experience for my peers.
Written CommunicationLeadership

Education

Indian Institute of Technology (Banaras Hindu University), Varanasi

Master's degree — Transportation and Highway Engineering

Jul 2020May 2022

Cambridge Institute of Technology Ranchi

Bachelor's degree — Civil Engineering

Aug 2016Aug 2020

Stackforce found 100+ more professionals with Data Analysis & Data Visualization

Explore similar profiles based on matching skills and experience