Rohit Duggal
Data Analytics Engineer
New Delhi
Summary
Highly skilled and results-driven data professional with over 7 years of experience specializing in Tableau, SQL, Python, and ETL (Extract, Transform, Load). Proficient in transforming complex datasets into actionable insights and interactive visualizations to drive data-informed decision-making. Demonstrated expertise in designing and implementing efficient ETL processes to ensure seamless data integration and accuracy.
Overview
7
7
years of professional experience
4
4
years of post-secondary education
Work History
Associate
Deutsche Bank
Mumbai
02.2023 - Current
- Troubleshoot existing workflows involving data sources like Oracle/Hive/Impala via Alteryx and Tableau Prep.
- Supporting the team with various technical aspects of Tableau Desktop/Prep/Server and Alteryx.
- Review and improve existing systems by collaborating with various teams for Tableau Extensions/Extract APIs.
Software Engineer
Airtel X Labs
Gurugram
12.2021 - 02.2023
- Responsible for tableau server Setup and administration (Authorization, Authentication & Maintenance).
- Developed efficient SQL workflows and tableau dashboards using best practices.
- Utilize tableau’s REST and EXTRACT/Hyper APIs to invoke extract refreshes remotely and create/replace/delete existing data extracts published on the server.
- Utilize TabPy to run trained Machine Learning models in Tableau.
- Build multi-arch docker images for airflow,postgres,plotly(orca),metabase,nifi.
- Dockerize various solutions and processes for easy distribution and deployment.
- Build efficient and fault tolerant data pipelines (incremental,batch,upsert) using apache nifi/airflow, Tableau Prep and Alteryx.
- Convert existing CRON jobs into airflow DAGS for efficient monitoring and debugging.
- Deliver reports to managers/team leaders via telegram/slack via headless servers using plotly(python).
- Integrate tableau server with airflow, allowing users to publish data sources via simple API calls.
- Utilize telegram/slack APIs to deliver reports and logs to stakeholders.
Developer
Skybird Travel Solutions
New Delhi
05.2016 - 12.2021
- Automated report generation containing customer feedback using python(xlsxwriter).
- Developed SQL workflows for reporting(tableau/plotly/D3/bokeh) and data processing requirements.
- Setup Postgres database to store customer data across multiple schemas for better data management.
- Developed front-end for dynamic web pages (Jinja Templates) and their backend using flask/html/css/bootstrap.
- Developed and deployed efficient data pipelines to extract data from multiple sources using Tableau Prep Builder.
- Developed scalable tableau dashboards using best design principles (LOD Expressions, Late and Context Filters etc).
- Developed tableau extensions (Extensions API) from scratch using javascript (nodejs) and python to facilitate single button download of dashboards in xlsx(excel) format.
Education
Bachelor of Science - Mathematics
University of Delhi
New Delhi 07.2013 - 07.2016
Diploma - Big Data Analytics
NIIT
New Delhi 08.2016 - 07.2017
Skills
Tableau (Prep, Desktop, Server)
undefinedTimeline
Associate
Deutsche Bank
02.2023 - Current
Software Engineer
Airtel X Labs
12.2021 - 02.2023
Diploma - Big Data Analytics
NIIT
08.2016 - 07.2017
Developer
Skybird Travel Solutions
05.2016 - 12.2021
Bachelor of Science - Mathematics
University of Delhi
07.2013 - 07.2016
Similar Profiles
Dnyaneshwar BhogilDnyaneshwar Bhogil
Trade and Transaction Analyst at Deutsche Bank Group, Deutsche BankTrade and Transaction Analyst at Deutsche Bank Group, Deutsche Bank
PRADEEP KUMARPRADEEP KUMAR
Assistant Vice President at Deutsche India Private Limited (Deutsche Bank Group)Assistant Vice President at Deutsche India Private Limited (Deutsche Bank Group)
Manoj Singh SolankiManoj Singh Solanki
Senior Analyst at Deutsche India Pvt. Ltd- Deutsche Bank GroupSenior Analyst at Deutsche India Pvt. Ltd- Deutsche Bank Group
Amit KulkarniAmit Kulkarni
Vice President at Deutsche India Pvt. Ltd, Deutsche Bank of India, DBOIVice President at Deutsche India Pvt. Ltd, Deutsche Bank of India, DBOI
Manvendra KumarManvendra Kumar
Manager- Finance & Costing at Genpact India Private LimitedManager- Finance & Costing at Genpact India Private Limited