rOhit Jain

Results-driven Data Analyst with hands-on experience in Advanced SQL, Power BI dashboard development, ETL/ELT processes, and Python automation for operational analytics. Proven ability to extract, transform, and validate large datasets, monitor database performance, design KPI reporting frameworks, and deliver data-driven insights to cross-functional stakeholders. Experienced in supporting data pipelines, implementing query optimization techniques, and collaborating with IT and operations teams to improve data governance and process efficiency.

IT Executive / Data Analyst - BLS International - Delhi, India

(2025-02)

• Developed and deployed interactive Power BI dashboards to monitor ticket resolution performance, SLA compliance, and operational KPIs — supporting management-level reporting and faster decision-making.
• Performed Advanced SQL queries (JOINs, CTEs, subqueries, aggregations) to extract, transform, and analyze operational datasets, ensuring data accuracy and consistency across reporting cycles.
• Supported ETL processes by designing data extraction, transformation, and validation workflows, improving data pipeline reliability and reducing reporting errors.
• Optimized SQL queries and reporting workflows, reducing manual reporting effort by ~40% through automation and streamlined data pipelines.
• Monitored database performance metrics and collaborated with IT teams to identify bottlenecks, perform root cause analysis, and implement process improvements.
• Implemented data validation and data cleaning procedures to ensure integrity of operational datasets prior to dashboard publishing.
• Collaborated cross-functionally with IT and operations stakeholders to improve reporting accuracy, data governance practices, and workflow efficiency.
• Delivered KPI dashboards tracking utilization rates, performance trends, and SLA breach patterns — enabling proactive issue escalation and capacity planning.

Bachelor of Engineering - Computer Science Engineering - HMR Institute (2020 - 2024)