Swaraj Singh Sethi

Spearheaded process improvement and automation across passenger revenue and operations reporting, integrating Six Sigma to reduce manual interventions by 80%.
Designed and implemented automated workflows using Power Automate and Python, driving a 95% efficiency gain in recurring reporting cycles while ensuring seamless planning, execution, and delivery of Contact Center and Airport Operations (AO) initiatives.
Conducted deep-dive analysis into FDM trends and provided actionable insights for leadership and enabled 15% faster decision-making for leadership.
Led a cross-functional analytics and automation team of 3 members, collaborating with leadership, technical, Safety, and OCC teams to drive process improvements and reporting automation initiatives.
Utilized Python (Pandas) to automate repetitive data-cleaning tasks and perform exploratory data analysis, reducing manual effort and ensuring quicker turnaround for ad-hoc leadership requests.
Translated analytical insights and business requirements into visual narratives and detailed user stories, driving Agile sprint delivery and iterative improvement of analytical frameworks aligned with evolving business strategies.
Leveraged SQL for large-scale data extraction, transformation, and validation, developing complex queries and reusable data models that streamlined multi-source reporting across revenue, performance, and operational metrics.
Developed a centralized data catalog integrated with Power BI dashboards, enhancing cross-departmental data accessibility, visualization, and reporting efficiency across key business units.
Digitized a manual data collection process by building an automated workflow using Power Automate, Microsoft Lists, and Power BI, eliminating manual entry, enabling real-time data capture, and setting up nightly dashboard refreshes for seamless reporting.

Spearheaded process improvement and automation across passenger revenue and operations reporting, integrating Six Sigma to reduce manual interventions by 80%., Designed and implemented automated workflows using Power Automate and Python, driving a 95% efficiency gain in recurring reporting cycles while ensuring seamless planning, execution, and delivery of Contact Center and Airport Operations (AO) initiatives., Conducted deep-dive analysis into FDM trends and provided actionable insights for leadership and enabled 15% faster decision-making for leadership., Led a cross-functional analytics and automation team of 3 members, collaborating with leadership, technical, Safety, and OCC teams to drive process improvements and reporting automation initiatives., Utilized Python (Pandas) to automate repetitive data-cleaning tasks and perform exploratory data analysis, reducing manual effort and ensuring quicker turnaround for ad-hoc leadership requests., Translated analytical insights and business requirements into visual narratives and detailed user stories, driving Agile sprint delivery and iterative improvement of analytical frameworks aligned with evolving business strategies., Leveraged SQL for large-scale data extraction, transformation, and validation, developing complex queries and reusable data models that streamlined multi-source reporting across revenue, performance, and operational metrics.

Led end-to-end process automation projects for leading banking clients (Paytm Payments Bank, Jana Bank, SBI), driving measurable improvements in reconciliation accuracy and report turnaround times.
Applied Lean Six Sigma Green Belt principles to eliminate redundant workflows and streamline reconciliation, reducing manual effort by 70%.
Designed and delivered dashboards in Power BI utilizing advanced DAX for financial KPI tracking.
Designed and maintained ETL workflows integrating SQL, Python, and Hive for financial data extraction, transformation, and validation.
Built Selenium-based automation pipelines to extract data from government portals and transformed JSON outputs into business-ready CSV datasets for seamless integration into reporting frameworks.
Utilized SQL and Hadoop (Hive) for daily large-scale data extraction, transformation, and analysis, supporting regulatory reporting and financial analytics for banking clients.
Led knowledge base development, end-user training, incident identification, workarounds, and remediation efforts.
Led GST 2A/2B Reconciliation Project for major banking clients, leveraging SQL, Hive, and Python automation.
Reconcile records between two Databases on various fields.
400 plus different Categories to be submitted on Govt website for ITC claims.
Abstract data from GST website using SELENIUM Extracted various Data points from Website.
Convert Json Files to Ms-Excel (CSVs) Converted Nested/Non-Nested JSONs files downloaded from GST Govt Website to CSVs for further Analysis.

Led end-to-end process automation projects for leading banking clients (Paytm Payments Bank, Jana Bank, SBI), driving measurable improvements in reconciliation accuracy and report turnaround times., Applied Lean Six Sigma Green Belt principles to eliminate redundant workflows and streamline reconciliation, reducing manual effort by 70%., Designed and delivered dashboards in Power BI utilizing advanced DAX for financial KPI tracking., Designed and maintained ETL workflows integrating SQL, Python, and Hive for financial data extraction, transformation, and validation., Built Selenium-based automation pipelines to extract data from government portals and transformed JSON outputs into business-ready CSV datasets for seamless integration into reporting frameworks., Utilized SQL and Hadoop (Hive) for daily large-scale data extraction, transformation, and analysis, supporting regulatory reporting and financial analytics for banking clients., Led knowledge base development, end-user training, incident identification, workarounds, and remediation efforts.

Created standardized data structures and reporting templates to improve stakeholder communication, reducing manual workload by 50%.
Analyzed large datasets to identify environmental impact patterns and business opportunities, improving data retrieval efficiency by 30%.

Created standardized data structures and reporting templates to improve stakeholder communication, reducing manual workload by 50%., Analyzed large datasets to identify environmental impact patterns and business opportunities, improving data retrieval efficiency by 30%.

Designed automated Excel-based dashboards for MIS, enabling leadership visibility into financial and operational KPIs.
Coordinated User Acceptance Testing (UAT) and ensured successful rollouts of reporting tools across teams.
Supervised a 15-member team managing national data operations for compliance and revenue reporting; achieved 100% audit compliance (RBI, KPMG, PWC).

Designed automated Excel-based dashboards for MIS, enabling leadership visibility into financial and operational KPIs., Coordinated User Acceptance Testing (UAT) and ensured successful rollouts of reporting tools across teams., Supervised a 15-member team managing national data operations for compliance and revenue reporting; achieved 100% audit compliance (RBI, KPMG, PWC)