AARJAV KOTTARI
Mumbai
Summary
Dynamic Data Engineer with 3+ years of experience in building cloud-based data pipelines, data warehouses, and ETL workflows using Python, SQL, Azure Data Factory, Azure Databricks, and PySpark. Expert at optimizing large-scale data integration and transformation processes, delivering a 30% improvement in system performance and a 40% increase in data reliability. Passionate about leveraging modern data engineering practices to create robust, scalable solutions that empower analytics and business growth.
Overview
3
3
years of professional experience
1
1
Certification
Work History
Senior Data Analyst
Lumina Datamatics
Mumbai
01.2025 - Current
- Designed Power BI dashboards by integrating KPIs (operating margin, cost variance, revenue growth) with advanced data visualization techniques.
- Built SQL queries using CASE statements and CTEs to aggregate financial data monthly, improving reporting accuracy and reducing manual effort by 30%.
- Applied data modeling and MS SQL development best practices, optimizing joins and normalizing structures for enhanced query performance.
- Implemented Row-Level Security (RLS) in Power BI using Azure Active Directory to manage access to sensitive financial data.
- Conducted performance tuning by removing unused fields and optimizing SQL queries for faster Power Query refreshes.
- Managed ETL workflows using Azure Data Factory, ensuring efficient and secure data pipelines.
- Developed dynamic DAX measures to support financial reporting and decision-making.
Analyst
Sceniuz
Mumbai
08.2022 - 01.2025
- Performed data analysis using Python (Pandas, NumPy, PySpark) and built visualizations with Matplotlib and Power BI.
- Automated ETL tasks with MSSQL stored procedures, reducing manual workload by 30% and enhancing data accuracy.
- Built scalable data pipelines using Azure Data Factory, centralizing sources into Azure Data Lake and Azure SQL.
- Modeled and transformed data using dbt Core to improve data integrity and reporting efficiency.
- Led CI/CD deployments using Azure DevOps for agile project deliveries with built-in disaster recovery strategies.
- Developed and secured Power BI workspaces with Azure Active Directory group permissions.
- Optimized SQL transformations using window functions, UDFs, and indexing for high-performance data modeling.
- Implemented PySpark transformations in Azure Databricks, enabling large-scale structured data analytics.
Education
Bachelor of Engineering - Electronics and Telecommunications Engineering
University of Mumbai
Mumbai, India05.2021
Skills
- Python
- Power Query
- RDBMS
- SQL (MS SQL)
- DAX
- NumPy
- Pandas
- Power BI
- Row Level Security
- Microsoft Excel
- Power BI service
- Microsoft Azure
- Azure Data Lake
- Azure Data Factory
- Azure SQL
- Dbt Core
- MS Share Point
- Data Warehousing
- Data Modeling
- Azure DevOps
- Azure Active Directory
- PySpark
- Python programming
- Performance tuning
- Data modeling
- KPI tracking
- Problem solving
Certification
- Azure Fundamentals (AZ-900), Microsoft, 09/01/22
- Microsoft Azure Data Fundamentals (DP-900), Microsoft, 10/01/22
- Power BI Data Analyst Associate (PL-300), Microsoft, 01/01/23
- Azure Data Engineer Associate (DP-203), Microsoft, 10/01/23
Timeline
Senior Data Analyst
Lumina Datamatics
01.2025 - Current
Analyst
Sceniuz
08.2022 - 01.2025
Bachelor of Engineering - Electronics and Telecommunications Engineering
University of Mumbai
Similar Profiles
Arish SampathArish Sampath
Senior Executive at Lumina DatamaticsSenior Executive at Lumina Datamatics
Sunny BhattSunny Bhatt
SENIOR SOFTWARE ENGINEER, API INTEGRATION at Lumina DatamaticsSENIOR SOFTWARE ENGINEER, API INTEGRATION at Lumina Datamatics
Aysha RubeenaAysha Rubeena
Senior Testing Engineer at Lumina DatamaticsSenior Testing Engineer at Lumina Datamatics
Krupali GadhaviKrupali Gadhavi
Data Science & Business Analytics Internship Program at PlasmidData Science & Business Analytics Internship Program at Plasmid
Neel YagnikNeel Yagnik
Client Referential Officer (Associate Level 1) at BNP Paribas ISPLClient Referential Officer (Associate Level 1) at BNP Paribas ISPL