RAHUL NAILWAL
Mumbai
Summary
Highly organized and detail-oriented worker, with a drive to exceed expectations. Ability to analyze data, develop strategies, and provide solutions to complex problems. Seeking to leverage skills and knowledge to contribute to team success.
Overview
2
2
years of professional experience
5
5
Certification
Work History
Data Analyst
Deloitte
12.2023 - Current
- Worked as a Data Engineer in the Backend Team of Net Revenue Management-LATAM project of one of the leading FMCG giants, Unilever Global where I used Pyspark and SQL for data manipulation and processing in Azure Databricks Platform. I have hands-on working experience in Azure Data Factory and Azure Devops for working with CICD pipelines and data migration across various branches and environments.
- Integrate Azure Data Factory with Git Repository along with developing and maintaining ETL pipelines using Azure Data Factory, processing over 3 TB of data with a 95% success rate.
- Led the comprehensive migration process for all Business Units (BUs) from legacy ITSGs to a new infrastructure, involving environment configuration, code conversion from Scala to Python, data owner approvals, and deployment tasks. Additionally, rectified code scripts within Azure Data Factory (ADF) pipelines to optimize data processing workflows and enhance system efficiency.
- Delivered Knowledge Transfers and worked closely with new developers joining the team.
- Developing complex SQL and python scripts for data processing as part of ETL operations in Azure Databricks to make sure they adhere to standards and efficiency.
- Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
- Worked closely with PBI developers to design and develop interactive dashboard that get details of the ETL operations and execution details.
- Conducted comprehensive data validation across backend and frontend outputs, including Power BI (PBI) dashboards, ensuring data metric accuracy and consistency
- Successfully delivered EDITH retrofit in the current NRM LATAM project. This involved the changes in the data source and fitting the newly pointed data source to undergo similar transformations as per the previously pointed data source.
- Was a part of the Project L0-L2 Handover to Devops team which involved delivering KTs, seeking approvals and readying the documents as part of the handover.
- Worked on the L3 build from scratch involving the data modelling, KPI calculations and code creation.
Education
Bachelor of Engineering - BE - Information Technology
Vivekanand Education Society's Institute of Technology
Chembur, Mumbai, Maharashtra04-2023
SE Coordinator -
Institute of Electrical And Electronic Engineers (IEEE)
04-2021
Skills
- PySpark/ SQL/ Python
- Azure Stack **(Databricks, Data Factory, Azure Devops)
- Cloud Technologies: Azure, Amazon Web Services (AWS), GCP
- DB Technologies: MySQL, MsSQL, Delta Lake Storage, MongoDB
- Programming Languages: Python, Scala, Java, C, C
- Big Data Tools: Hive, Apache Spark, Hadoop
- Program Management: SDLC (Github, CI/CD Deployments), Jira, Agile Methodologies
Accomplishments
- Received appreciation and bonuses multiple times for accountability as a dependent resource (Data Analysis).
- Collaborated across functional teams consisting of BAs and stakeholders by suggesting and developing unique business intelligence solutions to meet complex requirements.
Certification
Certifications:
- AZ-900 (Microsoft Fundamentals)
- AI-900 (Microsoft AI Fundamentals)
- DP-900 (Microsoft Data Fundamentals)
- PL-900 (Microsoft Power BI and Power App Fundamentals)
- Cloud Digital Leader (GCP)
- Apache Spark Scala (Udemy)
- Data modeling and data cleaning (Udemy)
- Advance SQL for data science (Udemy)
Languages
English
Hindi
Marathi
Hobbies
- Swimming
- Karate
- Music
Timeline
Data Analyst
Deloitte
12.2023 - Current
Bachelor of Engineering - BE - Information Technology
Vivekanand Education Society's Institute of Technology
SE Coordinator -
Institute of Electrical And Electronic Engineers (IEEE)