Bhushan Gosavi
Lead Business Functional Analyst
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.
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.
Work
Capita India Pvt. Ltd.
|Lead Financial Analyst
Pune, Maharashtra, India
→
Summary
Led data-driven process transformation and functional solution delivery within financial operations, specializing in automation, requirements gathering, and Agile project management.
Highlights
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.
Awards
Top Contributor
Awarded By
Capita India Pvt. Ltd.
Recognized 4 times for outstanding contributions and performance within the organization.
Star of the Quarter
Awarded By
Capita India Pvt. Ltd.
Awarded 3 times for exceptional performance and significant impact during a quarter.
Spot Award
Awarded By
Capita India Pvt. Ltd.
Received for demonstrating excellence and going above and beyond in specific tasks or projects.
Extra Miler Award
Awarded By
Capita India Pvt. Ltd.
Recognized for consistently exceeding expectations and delivering exceptional effort.
Certificates
SQL for Data Engineering
Issued By
Credly
ETL in Python and SQL
Issued By
Credly
Looker Studio for Beginners
Issued By
Credly
Financial Modeling & Forecasting
Issued By
Credly
Power BI with Excel
Issued By
Credly
Education
Savitribai Phule Pune University
→
Bachelor of Engineering
Electronics & Telecommunications