Experience

• 

  Swami brahmanand pratishthan

  May 2023 - Jun 2023

  Analyst intern

  • Conducted an in-depth analysis of financial data of the past 5 years, employing advanced statistical methods• Utilized pivot tables, VLOOKUP, and conditional formatting to systematically highlight critical financial trends and pattern• Evaluated key financial indicators, translating complex data into actionable strategies• Ensured data integrity and accuracy through meticulous cross-referencing and validation techniques• Compared yearly financial sheets to highlight spending and income trends, aiding in budget optimization• Created visually engaging financial reports using charts, graphs, and dashboards to represent complex data. Show less

• 

  Accenture

  Nov 2023 - Dec 2023

  Accenture data analytics job simulation on forage

  • Completed a simulation focused on advising a hypothetical social media client as a Data Analyst at Accenture• Cleaned, modelled and analyzed 7 datasets to uncover insights into content trends to inform strategic decision• Prepared a PowerPoint deck and video presentation to communicate key insight for the client and internal stakeholders

• 

  Pehchaan the street school (trust)

  Jan 2024 - Mar 2024

  Content writer
• 

  Nectar lifesciences limited

  May 2024 - Jul 2024

  Data analyst intern

  During my tenure as a Data Analyst intern, I received comprehensive training in data analytics, which allowed me to refine and enhance my proficiency in Python, Google Sheets, Looker Studio and Apps ScriptKey Responsibilities:• Supported the development and automation of four key management systems (HR, production, inventory, and supply chain) using Google Sheets and App Scripts, working closely with senior team members to enhance data processing efficiency and streamline operation• Performed Exploratory Data Analysis (EDA) with Python to dig into various datasets, revealing important trends and patterns. This analysis provided valuable insights that guided the development and automation of the management systems, ultimately supporting more informed and effective decision-making.• Applied Prescriptive Analytics techniques to track and engage disengaged customers, setting up automated notifications for the marketing team. This approach helped in proactively addressing customer concerns and contributed to a noticeable improvement in customer retention rates.• Designed and maintained several interactive dashboards in Looker Studio to keep track of key performance indicators. Show less

• 

  Ey

  Sept 2024 - now

  Insurance analyst intern