Shivali Rajkule
Data Engineer
About
Data Engineer with 2+ years of experience designing and building SQL-based data pipelines, ETL processes, and enterprise data transformations using Python and SQL. Proven ability to understand complex data relationships, translate business requirements into scalable data models, and deliver analytics-ready datasets that support operational and strategic decision-making. Experienced with Azure Data Factory, Azure Data Lake, SQL Server, Snowflake, and Power BI. Strong foundation in data quality, pipeline monitoring, incremental load strategies, and cross-functional collaboration.
Skills & Expertise (23)
Work Experience
Data Engineer
Aspen Systems and Software
Nov 2025 - Present
Re-architected legacy SQL Server schemas across HR and payroll modules, normalizing 30+ tables to reduce data redundancy and improve query performance by ~40%. Implemented Slowly Changing Dimension (SCD Type 2) logic for employee master data, enabling accurate historical tracking of role changes, department transfers, and salary revisions. Built automated Python reconciliation scripts to cross-validate payroll outputs against source HR records, proactively catching discrepancies and reducing manual audit effort. Developed a modular SQL transformation framework using reusable stored procedures and parameterized queries, streamlining onboarding of new data sources. Partnered with HR and finance teams to define KPI logic for headcount, attrition, and payroll variance reporting, translating business rules into auditable SQL transformation layers.
Analyst
Docebo
Feb 2025 - Oct 2025
Engaged with Business Analysts to gather requirements and built SQL transformations supporting day-to-day analytics and reporting workflows. Developed complex SQL scripts using joins, CTEs, and window functions to process large-scale datasets for analytics consumers. Implemented incremental load strategies, improving data processing efficiency by ~30% and eliminating redundant reprocessing cycles. Built reusable SQL views and transformation layers to standardize reporting across multiple business units. Monitored daily pipeline runs, proactively diagnosing and resolving failures to ensure timely data delivery and minimize business disruption.
Technical Analyst
Aspen Systems and Software
Feb 2021 - Dec 2022
Designed and managed SQL Server databases with 100+ tables supporting HR, payroll, attendance, leave, and overtime processes. Performed end-to-end ETL operations — extracting data from SAP SuccessFactors, transforming it using Python and SQL, and loading into analytical datasets. Collaborated with business stakeholders to translate HR and payroll workflows into scalable data models and SQL transformation logic. Developed Power BI dashboards for KPI tracking and senior management decision-making, covering headcount, attrition, and payroll metrics. Built a Python-based sales forecasting model using time series analysis to support inventory and demand planning. Optimized database query performance and restructured datasets, improving overall system efficiency and report load times.
IT Software Tester & CRM Analyst
Byju's
Jun 2020 - Jan 2021
Executed functional and regression testing and performed data validation across CRM systems. Successfully conducted end-to-end testing for the CRM system, leading to a 20% improvement in customer data accuracy. Participated in weekly status meetings, presenting testing progress and insights, which contributed to on-time software releases. Assisted in configuring SAP SuccessFactors EmployeeCentral module, gaining foundational knowledge of SAP data structures and HR source system architecture.
Education
Post Graduate Degree – International Business Management - Sheridan College
- · Afghanistan
Bachelor of Engineering – Computer Engineering - Pune University
- · Afghanistan
Certifications
No certifications added yet
Interested in this developer?
Profile Score Breakdown
Profile Overview
Skills (23)
Click a skill to find developers with the same skill
