Pradeep N
Summary
Proven Data Engineer with a track record of optimizing data processes , enhancing data quality and reporting efficiency through expert SQL skills and innovative automations using python. Excelled in database administration and development, showcasing strong analytical abilities and a commitment to driving data-driven decisions.
Overview
2
2
years of professional experience
1
1
Certification
Work History
Data Engineer
QubeRoot Analytics
04.2022 - Current
- Designed and optimized complex report logic for MSSQL Server, ensuring efficient query performance and accurate data analysis for business intelligence.
- Fine-tuned query performance and optimized database structures for faster, more accurate data retrieval and reporting.
- Enhanced data quality by performing thorough cleaning, validation, and transformation tasks.
- Developed and implemented comprehensive visualization dashboards in both Excel and Power BI, providing actionable insights and enhancing data-driven decision-making processes for stakeholders.
- Automated reporting tasks using Python and Power Automate, and migrated report logic from Java to Python to enhance performance and efficiency.
- Built and set up MSSQL Transactional Replication to replicate data from the production database to a secondary server, enabling the execution of resource-intensive queries separately to optimize performance.
Data Engineer Intern
QubeRoot Analytics
12.2021 - 03.2022
- Built Dashboards using Microsoft Excel and Data cleaning
- Data extraction from emails using VBA
- Fixing the SQL report's Data quality
Education
Bachelor of Science - Mathematics
K.S.R College of Arta And Sciences
Tiruchengode, India2020
Skills
- Data Modeling
- Python
- Microsoft Power BI
- Power Automate
- Microsoft Excel
- Microsoft Azure
- Azure Data Factory
- Performance Tuning
- SQL and Databases
- Database Administration
Certification
- Databricks lakehouse Fundamentalsmy
Languages
Tamil
Advanced (C1)
English
Intermediate (B1)
Timeline
Data Engineer
QubeRoot Analytics
04.2022 - Current
Data Engineer Intern
QubeRoot Analytics
12.2021 - 03.2022
Bachelor of Science - Mathematics
K.S.R College of Arta And Sciences
Similar Profiles
Pooja SinghPooja Singh
Software Engineer at Quberoot Quberoot Analytics (Saint Franics Minstries,US)Software Engineer at Quberoot Quberoot Analytics (Saint Franics Minstries,US)
ONKAR BELGAMWARONKAR BELGAMWAR
Architect at Fractal Analytics, Formerly Neal AnalyticsArchitect at Fractal Analytics, Formerly Neal Analytics
Ankush CHAUHANAnkush CHAUHAN
Subject Matter Expert at Optima Technology (Payroll on Optima Technology (Payroll on Proziod Analytics) Analytics)Subject Matter Expert at Optima Technology (Payroll on Optima Technology (Payroll on Proziod Analytics) Analytics)
Srishti SmitaSrishti Smita
Data Engineer at Maersk Global Service CenterData Engineer at Maersk Global Service Center
Rithuik YerrabroluRithuik Yerrabrolu
Data Engineer at GSK Consumer Healthcare (Haleon)Data Engineer at GSK Consumer Healthcare (Haleon)