Guru Pradeep

Data Engineer

QubeRoot Analytics•  April 2022 - Present•  Bengaluru, KA

Redesigned reporting logic for legacy SQL Server stored procedures, replacing outdated functions to enhance performance and data quality, resulting in a 25% reduction in query execution time. Transitioned manual Excel-based reports to Power BI dashboards, enabling data refresh from SQL Server and reducing report generation time by 50%. Created Power BI dashboards delivering insights into foster care home placements, integrating both active and historical data to support better decision-making. Deployed MSSQL transactional replication, mitigating performance bottlenecks by 80% by offloading resource-heavy queries to a secondary server. Automated recurring reporting tasks with Python and Windows Task Scheduler, saving an estimated 3 hours per week in manual efforts. Developed a Flask REST API for generating reports in xlsx, csv, and pdf formats, enhancing report accessibility and customization for stakeholders. Optimized advanced SQL queries with index utilization and sargable conditions, achieving significant improvement in query execution time, and executed DBA activities such as performance monitoring, backup management, and query optimization.

Data Engineer Intern

QubeRoot Analytics•  December 2021 - April 2022•  Bengaluru, KA

Built interactive dashboards using Microsoft Excel, incorporating data cleaning techniques to ensure accuracy and actionable insights, improving reporting efficiency by 30%. Formulated data extraction processes from emails using VBA scripts, reducing manual effort by 40% and ensuring higher data collection accuracy.