Shivam Mandhan

Experience

• 

  Man Ki Udaan

  Apr 2022 - Jan 2023

  Event Coordinator

  - Led the team of 10-15 volunteers to plan & organize events at the local shelter home- Collaborated with different NGOs & executed new campaign ideas- Designed posters, certificates, & social media posts

• 

  Gwalior Smartcity (GSCDCL)

  Jan 2023 - May 2023

  ICT Intern

  - Built a Power BI dashboard to visualize important KPIs for e-challan system- Discovered insights that could increase the revenue of the organization- Created multiple reports and presentations for stakeholders meetings & government expos

• 

  LTIMindtree

  Feb 2023 - May 2023

  Intern

  - Got introduced to the important concepts of big data such as distributed computing, data warehouse- Gained hands on experience in using technologies such as JAVA, Python, Hive, Apache Spark- Learned about cloud services such as GCP BigQury & Cloud Storage

• 

  Vaco Binary Semantics LLP

  Nov 2023 - now

  Associate Software Engineer

  Developing and Maintaining ETL Pipelines:Responsible for the end-to-end development and maintenance of ETL (Extract, Transform, Load) pipelines customized for Google Search categories like esports and automobiles. This entails designing, implementing, and refining pipelines to ensure seamless data flow and processing, addressing the specific needs of each category.Working with Data Lake and Data Warehouse Infrastructure:Actively working with the data lake and data warehouse infrastructure within our data ecosystem. Tasks encompass data ingestion, storage, retrieval, and analysis. Specializes in utilizing graph databases to efficiently handle complex data relationships, ensuring high performance and scalability.Utilizing Python for Data Operations:This includes leveraging Python's extensive libraries and functionalities for data manipulation, encompassing tasks such as filtering, sorting, aggregating, and preparing the data for further processing.Leveraging SQL for Data Extraction and Querying:Crafting efficient SQL queries to extract relevant data from diverse sources. utilizing SQL for data aggregation and filtering for further processing, analysis, and building dashboards for better decision-making.Employing JavaScript for Automation and Web Development:Active involvement in automation efforts and internal web application development using JavaScript. Utilize JavaScript's capabilities to automate repetitive tasks, enhancing operational efficiency and the development of internal web applications. Show less