Avanigadda Prasanna

Business Analyst

Bangalore, India 1+ yrs exp 82 · Excellent

About

Business Analyst with about 1 year of experience at Asset10 Software Private Limited - BlueCopa (FinTech), building analytical frameworks to streamline operations, identifying process gaps, and delivering KPI-driven insights to stakeholders. Skilled in SQL, Python (Pandas, NumPy), Power BI, and Excel for large-scale data extraction, trend analysis, and reporting. Proven ability to define metrics, translate business requirements into structured reports, and resolve data issues proactively.

Skills & Expertise (20)

SQL Intermediate

7.0/10

Years Exp

MySql Intermediate

7.0/10

Years Exp

Postgresql Intermediate

7.0/10

Years Exp

Excel Intermediate

7.0/10

Years Exp

Google Sheets Intermediate

7.0/10

Years Exp

Python Intermediate

6.5/10

Years Exp

Power BI Intermediate

6.5/10

Years Exp

Pandas Intermediate

6.0/10

Years Exp

CSV Intermediate

6.0/10

Years Exp

Process Gap Analysis Intermediate

6.0/10

Years Exp

Anomaly Detection Intermediate

6.0/10

Years Exp

Reconciliation Intermediate

6.0/10

Years Exp

Data Validation Intermediate

6.0/10

Years Exp

Trend Analysis Intermediate

6.0/10

Years Exp

KPI Definition Intermediate

6.0/10

Years Exp

NumPy Intermediate

5.5/10

Years Exp

REST APIs Beginner

5.0/10

Years Exp

JSON Beginner

5.0/10

Years Exp

Git Beginner

5.0/10

Years Exp

SAS Beginner

4.0/10

Years Exp

Work Experience

Business Analyst / Junior Data Engineer

BlueCopa

Sep 2025 - Mar 2026

Defined analytical frameworks to streamline operational reporting across multiple financial client accounts, processing 40K–50K+ records per run. Identified process gaps by analysing operational and financial datasets; liaised with finance and operations teams to implement fixes, improving data accuracy and report consistency. Wrote and optimised SQL queries (MySQL, PostgreSQL) for KPI tracking, trend analysis, and ad-hoc reporting — enabling data-driven decisions for business stakeholders. Built dashboards in Excel / Google Sheets and Power BI to monitor transaction trends, flag anomalies, and enable self-serve analytics for business teams. Performed end-to-end data validation and reconciliation — null checks, row count verification, duplicate detection — ensuring accuracy of reports delivered to internal teams. Translated stakeholder requirements into metrics, KPIs, and structured reports; documented workflows in runbooks to reduce manual effort and improve consistency.