Visweswara Rao Pilla

Data Scientist

Hyderabad, Telangana, India3 yrs experience

Key Highlights

3.5 years of experience in data analysis and business intelligence.
Expert in Power BI with advanced DAX and SQL skills.
Proven track record in automating reporting solutions.

Stackforce AI infers this person is a Data Analyst specializing in Business Intelligence and Data Engineering.

Contact

Skills

Core Skills

Data AnalysisBusiness IntelligenceData Engineering

Other Skills

Power BIDAXSQLVBAData ModelingData VisualizationExcelDashboard AutomationTrend AnalysisReporting & AnalysisData TransformationPythonETL TestingDatabase ToolsData Import/export

About

Experienced Data Analyst with 3.5 years of hands-on expertise in Power BI, DAX, SQL, Advanced Excel, Tableau, and VBA. Specialized in designing scalable data models, developing interactive dashboards, and delivering enterprise-level business intelligence solutions that drive strategic decision-making. Proficient in Power BI Desktop and Power BI Service, with strong experience in data modeling (Star Schema), writing complex DAX measures (CALCULATE, ALL, FILTER, SUMX, time intelligence functions), and optimizing report performance. Skilled in implementing Row-Level Security (RLS), creating reusable datasets, and publishing and managing reports in Power BI Service. Experienced in ETL processes using Power Query (M language) for data transformation, cleansing, and integration from multiple sources including MySQL, SQL Server, Excel, and cloud platforms. Adept at handling large datasets, improving data refresh performance, and ensuring data accuracy and consistency. Strong ability to translate complex datasets into actionable insights through KPI dashboards, drill-through reports, dynamic measures, and advanced visualizations. Proven track record of collaborating with cross-functional teams to gather requirements, automate reporting solutions, and implement data-driven strategies aligned with business goals.

Experience

3 yrs

Total Experience

9 mos

Average Tenure

Current Experience

Johnson controls

Data Analyst

Mar 2022 – Dec 2023 · 1 yr 9 mos · Bengaluru, Karnataka, India · Hybrid

Collaborated closely with business stakeholders to gather and understand functional reporting requirements.
Imported and integrated data from diverse sources such as Excel, SharePoint, Salesforce, and SQL Server using Power BI Desktop.
Performed data transformation and cleansing in Power Query Editor to prepare data for reporting and analysis.
Designed robust data models using DAX, calculated columns, and measures to drive accurate reporting.
Generate interactive dashboards and visualizations including maps, hierarchical views, and stacked charts to enable data-driven decisions.
Utilized advanced DAX functions (e.g., table, aggregation, iteration functions) for dynamic and in-depth reporting.
Published and scheduled reports in Power BI Service, implementing gateway configurations for live data refresh.
Identified and optimized performance issues in slow-running reports and dashboards.
Shared dashboards via Power BI Mobile App for on-the-go data access by leadership and field teams.
Delivered financial, HR, Audit Reports and Employee performance dashboards for profit and trend analysis.
Supported business updates and insights using Excel-based reporting and analysis.
Automated repetitive tasks and report generation using VBA (e.g., CIS Automation, APAC Automation, Bit task creation).
Developed custom tools like the Fast-To-Market (FTM) proposal tracker with version-based Excel/VBA enhancements.

Power BIDAXSQLVBAData ModelingData Visualization+2

Razorpay

Management Information System Analyst

Oct 2021 – Mar 2022 · 5 mos · Bangalore Urban district, Karnataka, India · Hybrid

Developed and maintained CSAT, DSAT & NPS dashboards with automated daily/weekly/monthly updates.
Delivered trend analysis and insights for leadership on customer satisfaction metrics.
Generate team productivity reports (Agent, TL, QA-wise) to support performance reviews.
Prepared BQM reports to track low performers and drive improvements.
Designed scorecards for QAs and Trainers aligned with agent OKRs.
Built escalation & RCA dashboards highlighting key trends and root causes.
Working Escalation, RCA (Root Cause Analysis) Dashboard Maintain the Dashboard to show them Monthly & weekly Trends

Dashboard AutomationTrend AnalysisReporting & AnalysisData AnalysisBusiness Intelligence

Knoema it solutions india private limited

Data Engineer

May 2021 – Oct 2021 · 5 mos · Bangalore Urban, Karnataka, India · Hybrid

Transforming complex public data into ready-to-analyze formats for clients using Knoema’s platform.
Generated interactive time-series datasets using templates (line, bar, scatter, etc.) with custom dimensions, units, and frequencies.
Prioritized and managed datasets across portals, public sources, and repositories using tools like Data Finder, Data Mapper, and DMT.
Automated data transformation processes using VBA macros and Python web scraping for efficient data ingestion and updates.
Ensured timely data uploads and updates based on NRD/PUB standards, enhancing accessibility for both technical and non-technical users.

Data TransformationVBAPythonData Engineering

Ola (ani technologies pvt. ltd)

Management Information System Analyst

Sep 2019 – Mar 2020 · 6 mos · Bengaluru, Karnataka, India · Hybrid

Created daily and monthly sales and performance reports by region, product, and lead source.
Built dashboards to monitor policy sales, renewals, lead flow, product visibility, and customer engagement.
Pulled and analysed data from SQL (Hue), Google Sheets, and internal systems to track agent performance and revenue.
Used R Studio for maintaining MIS reports and preparing weekly business review (WBR) summaries.
Managed IVR hot leads and supported dialer operations for better sales conversion.
Published reports for various insurance types like Motor, Trip, Rental, Outstation, RSA, and HospiCash.
Monitored banner clicks and opt-in/opt-out trends for products like Ola Money and Acko Insurance.
Coordinated with teams and insurers for policy issues, renewals, claims, and cancellations.
Shared regular insights and dashboards with management for reviews and planning.

Reporting & AnalysisSQLData VisualizationData Analysis