Tushar Ahlawat

Human Resources Analyst @ Ocube Services

About

I am a Data Engineer with strong hands-on experience building end-to-end cloud data pipelines on Azure, working with Azure Data Factory, Azure Databricks (PySpark), Delta Lake, ADLS Gen2, and Azure Synapse Analytics. I have designed and implemented Lakehouse and Medallion Architectures (Bronze → Silver → Gold) to process and transform large-scale datasets (41M+ records) using distributed Apache Spark on Azure Databricks. My work focuses on converting raw, unreliable data into analytics-ready datasets that support business reporting, forecasting, and decision-making. Coming from an analytics background, I bring strong SQL, Python, and business understanding, allowing me to design data models and pipelines that are not only technically sound but also aligned with real business use cases. What I work with: • Cloud & Data Platforms: Azure Data Factory, Azure Databricks, ADLS Gen2, Azure Synapse Analytics, Snowflake • Big Data & Processing: Apache Spark, PySpark, Spark SQL, Delta Lake, ETL/ELT • Databases & Modeling: SQL Server, PostgreSQL, MySQL, Star Schema, Fact & Dimension Modeling • Programming & Tools: Python (Pandas, PySpark), SQL (Advanced), Git, Docker (basic), Power BI Projects highlight: • NYC Taxi Big Data Pipeline: Processed 41+ million records using Spark on Azure Databricks with Medallion Architecture • AdventureWorks Azure Platform: Built enterprise-style end-to-end Azure data pipelines from ingestion to BI-ready datasets • SQL Data Warehouse: Designed and implemented complete analytical data warehouse with optimized ETL pipelines • Retail Analytics Pipeline: Automated data processing and dashboards for customer and revenue analysis 📍 Based in Berlin, Germany 🎯 Seeking Junior Data Engineer / Data Engineer roles where I can contribute to building scalable, data-driven solutions. 🔗 GitHub: github.com/tusharahlawat29 (complete projects with code & documentation)

Country

Germany

City

Berlin

Industry

Information Technology & Services

Skill

SQL queries, CTEs, Window Functions, Python, Databricks , Azure Data Factory, Apache Spark, ETL & ELT, Apache Kafka, Apache Airflow, Linux, NoSQL Databases, Shell Scripting, Object-Oriented Programming (OOP), Data Structures & Algorithms, File Handling & Data Processing, API Integration / Web Scraping, Software Engineering Principles, Automation / Scripting, Problem Solving with Python

Experience

Human Resources Analyst

Ocube Services

2024-8 - 2025-5 · 10 mos

Noida, Uttar Pradesh, India

• Managed payroll and HR data analytics for 950+ employees, ensuring data accuracy and compliance across multiple HR systems • Developed complex SQL queries using CTEs, Window Functions, and Joins to extract, transform, and analyze employee data for KPI tracking and reporting • Built interactive Power BI dashboards tracking 15+ HR KPIs including attrition analysis, employee cost metrics, performance tracking, and compliance monitoring • Created dynamic Excel models using Power Query, Pivot Tables, advanced formulas (XLOOKUP, INDEX-MATCH), and Macros for automated HR reporting and compensation analysis • Applied Python (Pandas, Scikit-learn) for predictive modeling including attrition risk prediction (87% accuracy), performance trend analysis, and workforce planning • Created data pipelines consolidating data from Zimyo HRMS, attendance systems, and performance tools into unified analytics database

Human Resources Executive

Aarvi Encon

2023-5 - 2023-8 · 4 mos

Noida, Uttar Pradesh, India

• Managed HR operations for 500+ employees at Bechtel India, ensuring seamless payroll processing and compliance • Automated candidate documentation and background verification processes through KPMG and A-Check Global • Implemented data-driven exit interview processes to analyze feedback and improve retention strategies • Maintained and updated HRIS data systems, ensuring 100% accuracy in employee records management • Conducted initial candidate screenings and coordinated interviews, improving hiring efficiency • Developed standardized onboarding processes that enhanced new employee experience • Analyzed employee data to identify trends and support disciplinary and retention decisions

Human Resources Associate

Yazaki India Private Limited

2021-12 - 2023-3 · 1 yr 4 mos

• Managed HR operations for 2,800+ employees (2,500 contractual + 300 on-roll), ensuring seamless payroll and compliance management • Automated payroll processes by transitioning from manual Excel to Keka and Ascent software, improving efficiency by 35% • Led a team of 6 members to resolve employee grievances, reducing escalation cases by 25% through proactive monitoring • Implemented data-driven recruitment strategies that improved hiring efficiency for contractual and engineering roles • Developed employee engagement initiatives based on feedback analysis, enhancing workplace satisfaction metrics • Maintained 100% statutory compliance (PF, ESI, TDS) for all 2,800+ employees through rigorous data audits • Optimized vendor management processes, ensuring timely payments and adherence to compliance standards • Analyzed attendance and overtime data to identify trends and support operational decision-making