Avadh Bihari

Data Visualization and Reporting Specialist with 7+ years of experience in SSIS and SQL Server environments. Expertise in ETL production support, incident management, root cause analysis, performance tuning, and job monitoring. Proficient in Power BI, Python, and SQL optimization. Adept at collaborating with cross-functional stakeholders and ensuring data reliability and SLA adherence. Ready to contribute to DWM's data visualization and reporting needs.

Senior Data Analyst / ETL Production Support (SSIS) at Happily Trade Exim (2025-05 – Present)

Provided end-to-end production support for SSIS ETL pipelines, ensuring high availability and data integrity. Monitored and supported scheduled SSIS jobs, resolving failures, performance issues, and data inconsistencies. Conducted root cause analysis (RCA) for production incidents and implemented permanent fixes to prevent recurrence.

Optimized SSIS packages and SQL queries to improve data load performance and reliability. Managed country-wise data integration for India, Indonesia, Malaysia, and Bangladesh. Automated ETL and data validation processes using Python and SQL Server.

Maintained ETL documentation, data mappings, and operational runbooks. Collaborated with business and technical teams to translate requirements into stable ETL solutions.

• Provided end-to-end production support for SSIS ETL pipelines, ensuring high availability and data integrity
• Monitored and supported scheduled SSIS jobs, resolving failures, performance issues, and data inconsistencies
• Conducted root cause analysis (RCA) for production incidents and implemented permanent fixes to prevent recurrence
• Optimized SSIS packages and SQL queries to improve data load performance and reliability
• Managed country-wise data integration for India, Indonesia, Malaysia, and Bangladesh
• Automated ETL and data validation processes using Python and SQL Server
• Maintained ETL documentation, data mappings, and operational runbooks
• Collaborated with business and technical teams to translate requirements into stable ETL solutions

Assistant Manager – BI & ETL Production Support at Pramerica Life Insurance (2024-02 – 2025-02)

Owned production SSIS pipelines supporting enterprise Power BI reporting across 5 regions. Handled production incidents, job failures, data refresh issues, and SLA-driven escalations. Performed performance tuning of SSIS packages and SQL queries to reduce refresh time and failures. Automated ETL workflows using SSIS and SQL Server, ensuring data accuracy and consistency. Implemented data quality checks and validation rules within ETL pipelines. Supported on-call production issues and coordinated with stakeholders during critical incidents.

Designed

Power BI dashboards with Row-Level Security (RLS) for secure data access.

• Owned production SSIS pipelines supporting enterprise Power BI reporting across 5 regions
• Handled production incidents, job failures, data refresh issues, and SLA-driven escalations
• Performed performance tuning of SSIS packages and SQL queries to reduce refresh time and failures
• Automated ETL workflows using SSIS and SQL Server, ensuring data accuracy and consistency
• Implemented data quality checks and validation rules within ETL pipelines
• Supported on-call production issues and coordinated with stakeholders during critical incidents
• Designed Power BI dashboards with Row-Level Security (RLS) for secure data access

Data Analyst – BI & ETL Support at Tally Solutions (2022-05 – 2023-11)

Supported ETL and reporting systems in production environments. Performed data extraction, transformation, and validation using SQL and SSIS. Designed and maintained Power BI dashboards for sales and retail analytics. Conducted EDA and data quality analysis to identify anomalies and trends. Optimized report and query performance for large datasets. Collaborated with cross-functional teams to align analytics with business objectives.

• Supported ETL and reporting systems in production environments
• Performed data extraction, transformation, and validation using SQL and SSIS
• Designed and maintained Power BI dashboards for sales and retail analytics
• Conducted EDA and data quality analysis to identify anomalies and trends
• Optimized report and query performance for large datasets
• Collaborated with cross-functional teams to align analytics with business objectives

MIS Analyst at Nestlé (Team Lease pvt ltd) (2021-08 – 2022-05)

Supported production MIS and reporting systems for e-commerce and retail analytics. Analyzed customer behaviour, market trends, and sales data to deliver actionable insights. Developed and maintained MIS dashboards in Excel and Power BI. Ensured data accuracy, consistency, and timely reporting for business stakeholders.

• Supported production MIS and reporting systems for e-commerce and retail analytics
• Analyzed customer behaviour, market trends, and sales data to deliver actionable insights
• Developed and maintained MIS dashboards in Excel and Power BI
• Ensured data accuracy, consistency, and timely reporting for business stakeholders

MIS Executive at OSIM India (2017-05 – 2019-03)

Supported production MIS dashboards and reporting systems. Designed and maintained Excel and Power BI dashboards for sales and performance tracking. Automated reporting processes using Excel VBA and SQL. Analyzed customer behaviour and market trends to support data-driven decisions. Collaborated with cross-functional teams to convert data insights into business actions.

• Supported production MIS dashboards and reporting systems
• Designed and maintained Excel and Power BI dashboards for sales and performance tracking
• Automated reporting processes using Excel VBA and SQL
• Analyzed customer behaviour and market trends to support data-driven decisions
• Collaborated with cross-functional teams to convert data insights into business actions

Master of Computer Applications (MCA) in Data Science – Vivekananda Global University (2024 – 2026)

Bachelor of Science (B.Sc.) in Science – Dr. Bhimrao Ambedkar University (DBRAU) (2011 – 2014)