Sandeep P R

Senior Business Analyst / Data Analyst with 9+ years of experience in data analytics, business intelligence, ETL, data harmonization, MIS reporting, and business requirements analysis. Experienced in supporting global FMCG, retail, e-commerce, healthcare, marketing analytics, and banking environments. Hands-on experience with SQL, MS SQL Server, SSMS, Pentaho Kettle (PDI), Sisense, Power BI, and Advanced Excel.

Skilled in requirements gathering, BRD/FRD documentation, gap analysis, data validation, dashboard development, data quality, stakeholder management, and translating business requirements into analytical and reporting solutions.

Manager - MIS at AU Small Finance Bank (2026-02 – Present)

• Manage collection, consolidation, validation, and analysis of Micro Business Loan (MBL) portfolio data from multiple regional branches.
• Design and maintain high volume MIS reports using Advanced Excel, including data cleaning, reconciliation, validation, and recurring reporting.
• Analyze branch-level operational data to identify performance trends, data gaps, and efficiency patterns for management reporting.
• Collaborate with cross-functional stakeholders to understand reporting requirements and deliver structured, data-driven solutions.

Plant Manager at LionCircuits (2025-04 – 2026-01)

• Managed high-volume production operations while monitoring workflow efficiency, quality validation, compliance, and operational performance.
• Analyzed production data and operational logs to identify bottlenecks, process anomalies, and improvement opportunities.
• Developed internal tracking reports and performance dashboards to monitor production activities, KPIs, and process efficiency.

Freelance Business Analyst at Modha Infotech (2024-03 – 2025-03)

• Gathered business requirements from stakeholders and prepared Business Requirements Documents (BRDs) and Functional Requirement Documents (FRDs).
• Conducted gap analysis between existing systems/processes and proposed business requirements.
• Translated business requirements into functional specifications and supported alignment between business and technical stakeholders.

Senior Business Analyst at Kantar / Analytics Quotient (2019-11 – 2023-12)

• Integrated and harmonized large, multisource datasets supporting global FMCG and consumer analytics projects using Data Warehouse Builder and Advanced Excel.
• Developed SQL scripts and validation controls for data processing, quality checks, and reporting workflows.
• Automated repetitive data-handling activities, improving processing efficiency and reducing manual reporting errors.
• Generated daily, weekly and monthly Marketing Mix Modelling (MMM), MROI, and TMROI diagnostic reports for business and executive decision support.
• Managed international stakeholder communication, project updates, requirements, and feedback cycles across major analytics initiatives including Furniture MROI, Broadband MROI, Beauty & Health MROI, Airline TMROI, CPW, and Waitrose MROI/TMROI.

Data Analyst at Kantar / Analytics Quotient (2017-01 – 2019-11)

• Developed and maintained ETL data integration pipelines using Pentaho Kettle (PDI) for complex multi-channel marketing datasets.
• Performed data extraction, transformation, integration, validation, and preparation for downstream reporting.
• Developed interactive Sisense dashboards to monitor sales trends, customer conversions, campaign performance, and business KPIs.
• Performed SQL query verification and data validation using SQL Server Management Studio (SSMS) and tracked defects through JIRA.

Master of Computer Applications in MCA – Sahyadri College of Engineering & Management (2016)

Bachelor of Computer Application in BCA – Vivekananda Degree College (2013)