Bhushan Gosavi

Lead Business Functional Analyst

Email | Phone

[email protected]

+91 8793266398

Pune, IN

About

Highly accomplished Lead Business Functional and Process Analyst with 7+ years of expertise in driving data-driven process transformation and functional solution delivery within financial services. Proven ability to automate complex workflows saving 7000+ manual hours till date by leveraging RPA, VBA, and GenAI to significantly improve efficiency, accuracy, and compliance, including resolving £233K VAT discrepancies and automating 35,000+ invoices. Adept at requirements gathering, Agile methodologies, and stakeholder management to deliver scalable, high-impact solutions.

Work Experience

Lead Financial Analyst

Capita India Pvt. Ltd.

May 2018 - May 2024

Pune, Maharashtra, IN

Led data-driven process transformation and functional solution delivery within financial operations, specializing in automation, requirements gathering, and Agile project management.

  • Led comprehensive business analysis, gathering requirements and authoring BRD/FRD for critical RPA workflows across invoice approval, self-bill, and vendor onboarding processes.
  • Translated complex process gaps into user stories and 'As-Is/To-Be' models using BPMN and SIPOC, directly supporting Blue Prism solution design and automation feasibility.
  • Automated self-bill mailbox processing for over 900 weekly invoices, saving 3-5 hours/week and achieving 100% accuracy, while defining use cases for a Contract Split Invoice tool that automated 35,000+ invoices.
  • Spearheaded the migration of manual Excel macros to UiPath and VBA automation for invoice backups, reducing audit prep time by 23% (from 13 to 10 minutes) and saving 20-50 hours/month per team.
  • Performed SQL-based root cause analysis on 36,000+ invoice lines, resolving £233K VAT discrepancies with 97% accuracy, and built consolidation rules for 175,000+ vendor invoices to enhance traceability and data quality.
  • Designed SOPs and integrated GenAI-based templates in Gmail for escalations, improving communication quality by 70%, and created UML diagrams to support RPA logic development for legacy workflows.
  • Facilitated Agile sprint planning, backlog grooming, and reviews, maintaining JIRA and Confluence for end-to-end BA traceability, and coordinated UAT planning, test script writing, and defect resolution with QA and RPA teams.
  • Developed and deployed interactive dashboards using Power BI and Tableau to support vendor-level forecasting and compliance reporting, enhancing data-driven decision-making.

Education

Electronics & Telecommunications

Savitribai Phule Pune University

Aug 2014 - May 2018

Pune, Maharashtra, IN

Certificates

SQL for Data Engineering

Credly

Jan 2025

ETL in Python and SQL

Credly

Jan 2025

Looker Studio for Beginners

Credly

Jan 2024

Financial Modeling & Forecasting

Credly

Jan 2023

Power BI with Excel

Credly

Jan 2022

Awards

Top Contributor

Capita India Pvt. Ltd.

Jan 2023

Recognized 4 times for outstanding contributions and performance within the organization.

Star of the Quarter

Capita India Pvt. Ltd.

Jan 2023

Awarded 3 times for exceptional performance and significant impact during a quarter.

Spot Award

Capita India Pvt. Ltd.

Jan 2023

Received for demonstrating excellence and going above and beyond in specific tasks or projects.

Extra Miler Award

Capita India Pvt. Ltd.

Jan 2023

Recognized for consistently exceeding expectations and delivering exceptional effort.

Skills

Requirements Gathering & Documentation

  • Business Requirements Document (BRD)
  • Functional Requirements Document (FRD)
  • Requirements Traceability Matrix (RTM)
  • User Acceptance Testing (UAT)
  • User Stories
  • Functional Specification

Data Analysis & Visualization

  • SQL
  • Python (Basics)
  • Power BI
  • Tableau
  • Excel
  • Databricks
  • Data Modeling
  • Dashboarding
  • Root Cause Analysis

ETL & Data Warehousing

  • Data Marts
  • Business Rules
  • Transformation Logic (Conceptual)

Financial Services Operations

  • Invoicing
  • Reconciliation
  • Audit Readiness
  • Forecasting Models
  • VAT Discrepancy Resolution

Stakeholder Management & Collaboration

  • Cross-functional Collaboration
  • Solution Implementation
  • Communication
  • Global Stakeholder Engagement

Process Optimization & Automation

  • BPMN
  • SIPOC
  • RACI
  • As-Is/To-Be Mapping
  • Workflow Automation
  • Robotic Process Automation (RPA)
  • Power Automate
  • UiPath
  • Excel VBA
  • GenAI Integration
  • Process Design
  • Deployment & Optimization

Quality Assurance & Testing

  • Data Validation
  • Automation Testing with RPA & VBA
  • Defect Resolution
  • Audit templates for Operations

Agile & Scrum Methodologies

  • Sprint Planning & Backlog Grooming
  • Daily Stand-ups (Scrum Meetings)
  • Iterative & Incremental Delivery
  • User Story & Acceptance Criteria Definition
  • Sprint Review & Demo
  • Retrospectives
  • Jira, Confluence, Kanban