Dharmendra Dudi
Analytics Engineer from quantitative background.
Expertise in Data Engineering & Analytics
Seeking new challenges to continue growing and making an impact.
Open to work as
About Me
Data Analyst
Hi, I'm Dharmendra, an Analytics Engineer with 2 years of experience in the data engineering & analytics domain.
Coming from a quantitative background, I have tuned myself to be a data analyst with a diverse skill set including Business Intelligence, Data Prep & Analysis, Data Governance, Reporting & Visualization and Stakeholder Management. I have proficiency in dbt, Python, Airflow, Snowflake, Looker, Tableau and Statistics.
I am seeking new challenges & opportunities to develop and implement my diverse skills to extract impactful results for the organizations.
Technical Skills
Python: Data Structures, OOP, NumPy, Pandas, API Integration, ETL Pipelines, Logging, Unit Testing
Airflow: DAGs, Task Orchestration, Reverse ETL, ELT, XComs, Sensors, Operators
Snowflake: Warehousing, Query Performance Tuning, Dynamic Tables, Stages, Snowpipes, Time Travel
Looker: LookML, Explores, SQL Runner, Data Modelling, Table Calculations, Reporting and Dashboards
Tableau: Data Modelling, Parameters, Table Calculations, LODs, DZV, Reporting and Dashboards, Tableau Public
PostgreSQL: DQL, Stored Procedures, Window Functions, Data Analysis, Query Performance & Optimization
Excel: Pivot Tables, Power Query, Visualization, Forecasting, Statistical Analysis, and Dashboards
Projects
I invite you to go through my projects in various domains using different tools.
Hover and click the associated link icon to explore more about a particular project.
- All
- Tableau
- Python
- SQL
- Excel
Work Experience & Education
Professional Experience
Analytics Engineer
March 2024 - Present
Analyttica Datalab, Bengaluru, IN
- Developed a reverse ETL process for Zendesk Sell, enhancing operational efficiency by 20% by automating data export, validation, and imports with dbt models and Airflow DAGs, while leveraging S3 and Snowflake for data storage and ingestion.
- Created scheduled Airflow DAGs to automate the removal of duplicate profiles in Braze, decreasing duplicates from 80,000 to 4,000 by utilizing dbt models and Braze APIs for efficient data management.
- Collaborated with different business teams to understand and maintain the organization dbt project. Facilitated the migration of 10 Tableau dashboards to Looker, implementing LookML data models and preparing required views and explores for effective data visualization.
- Established workflows for ingesting Google Sheets data into Snowflake, improving data accessibility in Looker for the Ops team and reducing manual update time by 40%.
Analyst - Site Reliability Engineering
May 2023 - Dec 2023
DeCurtis Corporation, Jaipur, IN
- Worked with the Engineering team to set up an internal monitoring tool for the SRE team using Python, PostgreSQL & ElasticSearch.
- Automated data reporting & RCA tasks using Pandas runbooks and SQL, boosting efficiency by 40%.
- Contributed to the development of Tableau dashboards for incident analysis, achieving 20% improvement in SLA compliance and 15% cost savings in resolution expenditure.
Project Associate Intern
Jul 2022 - Apr 2023
RGAVP, Jaipur, IN
- Employed statistical methods to assess impact of SHG membership on income, finding a 32% increase in income after joining SHGs.
- Created a survey to gather more insights on income-loan gaps of SHG members and trained over 10 CBM teams to carry out surveys
Education
Master of Science - Mathematics
2021 - 2023
Malaviya National Institute of Technology Jaipur
CGPA: 8.45/10
- Played an integral role as Placement Committee Member in the Training & Placement Cell of MNIT Jaipur (2022-23), successfully organised and facilitated smooth placement process for over 200 companies.
- Led the Placement Club of the Department of Mathematics to conduct held career development seminars.
Bachelor of Science (Hons.) - Mathematics
2018 - 2021
Aryabhatta College, University of Delhi
CGPA: 8.72/10
Certificates
dbt Labs
dbt Labs
Udemy
Trailhead by Salesforce
Coursera, Meta
Codebasics
Coursera
Jovian
IIBA
IIBA