Paaventhan 91

BI / Reporting Analyst with 3.8+ years of experience in SQL (MySQL), Power BI, and Jaspersoft Studios. Hands-on experience in developing and optimizing complex MySQL queries, stored procedures, CTEs, and window functions for large-scale reporting systems. Strong expertise in designing, scheduling, and maintaining enterprise reports using Jaspersoft Studio and JasperReports Server, including parameterized and sub-reports.

Experienced in building Power BI dashboards with efficient data models, DAX measures, and visuals to support business and management decision-making. Skilled in handling fiscal year logic, YTD calculations, reconciliation, and variance analysis across financial and revenue datasets. Proven ability to troubleshoot data mismatches, improve report performance, and provide reliable production support under tight deadlines.

Data Analyst - Tata Consultancy Services (TCS)

(2022-04 - 2024-02)

• Designed, developed, and maintained highly complex MySQL stored procedures and SQL queries supporting large-scale airline revenue, finance, and operational reporting systems.
• Built and enhanced enterprise-grade Jaspersoft reports (tabular, summary, parameterized, and sub-reports) used by business, management, and compliance teams.
• Implemented complex airline business logic including fiscal year handling, revenue thresholds, credits/debits adjustments, fare category rules, and station-level reporting directly within stored procedures.
• Performed root cause analysis on data mismatches between reports and source systems by analyzing SQL joins, aggregations, window functions, and transformation logic, ensuring high data accuracy.
• Developed Power BI dashboards and analytical reports using MySQL data sources to provide clear visibility into airline revenue metrics, operational KPIs, and performance trends.
• Optimized slow-running queries and reports through query tuning, index optimization, and logic refactoring, improving report execution times by 30–40%.
• Supported UAT and Production environments for business-critical airline reports, resolving defects, validating data accuracy, and ensuring minimal downtime and SLA compliance.
• Worked closely with onsite coordinators, airline business stakeholders, analysts, and QA teams to gather reporting requirements and deliver enhancements within tight timelines.
• Actively participated in incident management and production support, ensuring data integrity, audit readiness, and reliable report delivery for airline operations.

Data Analyst - Infinite Computer Solutions

(2024-06)

• Designed, developed, and maintained complex MySQL stored procedures and SQL queries supporting enterprise financial, revenue, and operational reporting systems.
• Worked extensively on farebox, ticketing, and transactional datasets, generating balance sheet summaries, passenger statistics, reconciliation, and variance reports.
• Implemented advanced SQL logic including CTEs, window functions, fiscal year and fiscal YTD calculations, and category-based revenue adjustments aligned with business rules.
• Refactored legacy SQL code to comply with strict database standards such as ONLY_FULL_GROUP_BY and sql_require_primary_key = ON, improving data integrity, performance, and maintainability.
• Performed root cause analysis to debug complex report mismatches by analyzing multi-table joins, aggregation layers, and transformation logic.
• Optimized query and stored procedure performance through index tuning, logic simplification, and efficient aggregation strategies, reducing execution time by ~25–35%.
• Developed interactive Power BI dashboards using MySQL datasets and DAX measures to visualize revenue trends, fiscal YTD performance, and operational KPIs for business stakeholders.
• Supported UAT and Production environments, resolving data issues, validating report outputs, and ensuring timely delivery of business-critical reports.
• Collaborated closely with business analysts, QA teams, and stakeholders to implement enhancements, manage change requests, and support monthly and fiscal reporting cycles.
• Ensured high reliability of reporting systems by proactively monitoring data accuracy and resolving production issues within SLA timelines.

Bachelor of Engineering (B.E) - Thiagarajar College Of Engineering (2017 - 2021)