Havovi Jehangir Jilla

Havovi Jehangir Jilla

Senior Data Analyst
India
[email protected]
+91 7660968611
Open to Offers
Full-time Work from Home

About Me

Highly analytical Senior Data Analyst with extensive experience in architecting and maintaining
complex SQL-based ETL pipelines, analytical datasets, and business analytics initiatives.
Proven ability to build scalable d…

Experience

Integration Analyst — Data & Business Analytics

Amazon · Hyderabad, India
Feb 2026 - Present · 8 months

<p>Maintain ownership of complex SQL-based ETL pipelines, analytical data models, and large-scale business analytics initiatives.</p><p> Construct scalable analytical datasets utilizing intricate joins, aggregations, window functions, ranking logic, and implementing validation and deduplication controls.</p><p> Develop and manage Amazon QuickSight/Tableau dashboards and KPI frameworks to support operational, program, and leadership decision-making.</p><p> Collaborate with BI/BIE, program, and operations stakeholders to translate complex business requirements into scalable data solutions and actionable insights.</p><p> Investigate data quality and reporting issues, pinpoint root causes, and enhance the reliability of downstream analytical outputs.</p><p> Leverage generative AI tools (Amazon Q, Claude, ChatGPT) to accelerate SQL development, data validation, documentation, root-cause analysis, and analytical workflows.</p>

Data Quality Analyst - Performance & Operational Analytics

Amazon · Hyderabad, India
Jun 2025 - Feb 2026 · 8 months

<p>Delivered complex quality and operational analytics, performance frameworks, and outlier analysis using SQL and Amazon Redshift.</p><p> Developed analytical datasets and reporting logic to support quality reviews, performance management, and business decisions.</p><p> Applied data validation, aggregation, and analytical methodologies to identify performance trends and operational opportunities.</p>

Learning Analyst — BI & Data Engineering

Amazon · Hyderabad, India
Jan 2024 - May 2025 · 1 year 4 months

<p>Expanded responsibilities into advanced SQL, ETL, data pipeline development, and data modeling, building upon a foundation in reporting automation and BI.</p><p> Engineered SQL-based analytical datasets and ETL transformations to support large-scale operational and performance analytics.</p><p> Created Python-driven data consolidation and Tableau/QuickSight reporting solutions for training and new-hire performance analytics.</p><p> Spearheaded a comprehensive revamp of the program-level New-Hire Performance Dashboard across 6+ performance metrics, integrating business entities, line-of-business metrics, and automated alerting.</p><p> Designed an automated proficiency-curve and performance-goal framework utilizing historical performance and percentile benchmarking, with a methodology approved by senior leadership.</p>

Senior MIS Specialist

Amazon · Hyderabad, India
Sep 2021 - Jan 2024 · 2 years 4 months

<p>Automated 4-6 recurring reporting workflows using Python, Power Query, VBA, and ETL, reducing manual reporting effort from 4.5-6 hours to 15-20 minutes (approximately 93-96% efficiency gain).</p><p> Migrated manual daily/weekly/monthly reporting processes to self-service dashboards with automated refresh capabilities, enhancing speed, consistency, and stakeholder accessibility.</p><p> Constructed reporting and training dashboards from inception, covering post-training evaluation, attrition, assessment performance, training effectiveness, and training duration.</p><p> Developed reporting solutions to support weekly, monthly, quarterly, and annual business reviews.</p>

Amazon Operations Analyst / QA Analyst

Amazon · Hyderabad, India
Oct 2019 - Sep 2021 · 1 year 10 months

<p>Executed operational and quality analysis, reporting, audit controls, and performance reviews across customer service operations.</p><p> Contributed to quality improvement initiatives and interim QA training, receiving recognition as a Top Performer in 2021.</p>

Amazon Customer Service Associate

Amazon · Hyderabad, India
Feb 2017 - Oct 2019 · 2 years 8 months

<p>Provided comprehensive customer support and issue resolution across various Amazon processes, including assuming Step-up responsibilities for Amazon Echo and Account Change issues.</p><p> Awarded the Achiever Top 100 Club Award for Excellence.</p>

Technical Support Agent

Tech Mahindra · Hyderabad, India
Apr 2015 - Jan 2017 · 1 year 8 months

<p>Delivered technical troubleshooting and customer support services, while also contributing to new-hire training and subject matter expert (SME) activities.</p>

PROJECTS

Handle Time Analytics & Agent Outlier Framework

Amazon
Duration : 16-Jun-2026 - 22-Jul-2026

<p>Designed and delivered an end-to-end analytics solution for large-scale handle-time performance analysis across global operations. Built 3 SQL-based ETL pipelines and analytical datasets covering 56M+ records, using complex joins, window functions, aggregations, volume-weighted calculations, percentile-based benchmarking, and dynamic ranking logic. Developed an agent outlier framework with fixed and configurable ranking thresholds, goal variance tracking, and network-level impact analysis to identify performance opportunities and support resource allocation. Implemented data-quality controls, deduplication logic, and validation checks, including identification and resolution of a 209-row discrepancy caused by duplicate record IDs. Delivered interactive analytics and KPI views through Amazon QuickSight/Tableau.</p>

Certifications

AWS Certified Cloud Practitioner

Amazon Web Services · Hyderabad , Telangana , India · 2023

Skills

SQL ETL Data Transformation Data Modelling Data Quality Data Validation Complex Joins Window Functions Aggregations Tableau Amazon QuickSight Dashboard Development KPI Frameworks Data Visualization Self-Service Analytics Executive Reporting Python Excel Power Query VBA Macros VB.NET Amazon Redshift AWS SharePoint Amazon Q ChatGPT Claude Amazon PartyRock Kiro Generative AI Business Analytics Root Cause Analysis Requirements Gathering Stakeholder Management Process Improvement Cross-Functional Collaboration
Report this Profile?