PRAVEEN KUMAR JAMPALA

Bengaluru

Summary

Results-driven Data Analyst with 14 years of experience in telecom and insurance sectors. Specialises in data validation, KPI/MIS reporting automation, and business analytics. Utilises Teradata, SQL, Python, Power BI, and Excel for data profiling and transformation, delivering actionable insights to support leadership reporting and operational decisions. Knowledgeable in Azure for data applications.

Overview

years of professional experience

Work History

Business Analyst / Lead Sales Reporting & Analysis

Mobily InfoTech Pvt. Ltd.

09.2016 - Current

Analyzed and validated business data using Teradata SQL, Python/Pandas, Excel and Power BI to support KPI reporting, dashboards and management insights.
Performed data quality checks including missing records, duplicate checks, count mismatches, wrong mappings, date issues and source-to-target reconciliation.
Prepared clean and structured datasets by applying SQL joins, business logic validation, data cleansing, formatting and transformation rules.
Automated recurring validation and reporting tasks using Python and Excel, reducing manual effort and improving report turnaround time.
Built and maintained Power BI and Excel dashboards for KPI monitoring, trend analysis, target tracking, filters and management reporting.
Supported daily, weekly, monthly and MTD reports with SLA/KPI tracking, daily load monitoring, report checks and business support.

Executive, Process & BI/MIS

IFFCO TOKIO General Insurance

02.2011 - 08.2016

Collaborated with business heads and metric owners to ensure consistency in reporting definitions and process documentation, enhancing clarity and accuracy.
Supported teams in understanding key performance measures and their implications, driving alignment on performance goals.
Prepared MIS and ad hoc reports for marketing and underwriting teams using Toad, facilitating informed decision-making.

Education

B.Tech -

Nimra Institute of Science & Technology

Vijayawada

01-2010

Skills

Power BI

Data Visualisation
Sales reporting
KPI tracking
Analytical Techniques
Teradata SQL

Python automation
Data Governance
Analytical Techniques
Stakeholder analysis
Sales reporting

Languages

English

Hindi

Telugu

Kannada

Custom

Automated daily sales reporting and validation workflows for leadership and business teams, improving speed, consistency and repeatability of recurring reports.
Built Power BI and Excel dashboards for KPI monitoring, trend analysis, target tracking, revenue reporting and management presentations.
Applied SQL/Python validation checks for completeness, accuracy, transformation logic and mapping correctness across large-scale telecom datasets.
Created structured exception outputs to highlight rejected, duplicate, missing and mismatched records for faster issue resolution.

Timeline