Dhruv Singla

Experience

• 

  Dot - Design Club

  Aug 2019 - Jun 2022

  Member

  - Designed 30+artworks (both personal and work-related).- Organized 2 events and 1 workshop- Plausible Secretary for the club

• 

  Alfaaz (Literature Fest of IIITV)

  Feb 2021 - Apr 2021

  Design Co-Head

  - Designed the logo, main poster, jury poster and the result declaration brochure of the fest.- Responsible and assisted in the designing of 8+ posters of the fest within 3 weeks.

• 

  CEREBRO - The Technical Fest

  Feb 2022 - Mar 2022

  Convener

  - Invited Mr. Om ChinchWankar (YouTube channel : 'Graphic Design Hindi Mein' with over 3Lakh+ subs) as a pro-bono.- Managed the event by guiding a team of 4.- Set-up proposals, organized meets, built problem statements as required by the event.

• 

  Blackboard Radio

  May 2022 - Jul 2022

  Data Analyst

  - Integrated Facebook advertising revenue data into Google Sheets using Google Colab for streamlined analysis.- Created interactive dashboards with Matplotlib and Google Data Studio to aid financial decision-making.- Collaborated with Senior Data Analysts to assess customer behavior trends through marketing funnel analysis in Google Analytics.

• 

  Sigmoid

  Jan 2023 - Jun 2023

  Data Engineer

  Worked with 8+ technologies, including Docker, PySpark, Airflow, Snowflake, and AWS, to build scalable data solutions.Key Contribution: Data Pipeline Development - Developed an end-to-end PySpark data pipeline to extract, transform, and load (ETL) data from AWS into MongoDB and Snowflake, using YAML-based configurations for dynamic transformations. - Optimized extraction by replacing file-based ingestion with direct connectors/JDKs, eliminating issues related to text encoding and file handling. - Containerized the pipeline using Docker, enabling seamless execution with a single terminal command. - Normalized data using PySpark for better consistency and usability. - Designed data models in Snowflake, ensuring efficient dashboard creation and analytical querying. Show less

• 

  Sigmoid

  Nov 2023 - now

  - Automated Financial Reporting – Reduced manual effort by 30% by building data pipelines with PySpark, Azure Databricks, and Azure Data Factory for a Fortune 500 company.- Proactive Collaboration & Issue Resolution – Worked across teams to identify and resolve issues, delivering effective solutions with actionable outcomes.- Ownership & Efficiency in KPI Delivery – Managed 40% of KPIs, ensuring early completion with zero client complaints through a results-driven approach.- Optimized Data Quality Framework – Developed a PySpark and SparkSQL-based framework performing 6 quality checks on large datasets, improving accuracy with partitioning, broadcast joins, and window functions.- Efficient Data Ingestion & Code Optimization – Designed Azure Data Factory pipelines for reliable data flow and reduced code duplication by 50% with a config-driven, incremental PySpark framework. Show less

  • Data Engineer

    Feb 2024 - now

  • Data Engineer

    Nov 2023 - Jan 2024