Data Analyst Power Bi

SUMMARY

Vikram Sai Pavan Beesabattini

Texas, USA +1-806-***-**** ******************@*****.*** LinkedIn Detail-oriented Data Analyst with 4+ years of experience interpreting complex data to drive business decisions across marketing, finance, and operations. I am skilled in Python, SQL, Tableau, Power BI, and R for building dashboards, cleaning data, and delivering statistical insights. Adept at A/B testing, regression modeling, and process automation. Proven ability to reduce reporting time, uncover trends, and improve data accuracy. Strong collaboration skills in Agile environments using Jira, Confluence, and version-controlled workflows.

TECHNICAL SKILLS

• Programming & Scripting: Python (Pandas, NumPy, Matplotlib, Seaborn), R (dplyr, ggplot2), SQL (Joins, CTEs, Window Functions)

• Data Wrangling & Analysis: Data Cleaning, EDA, Pivot Tables, Descriptive Statistics, Outlier Detection, Missing Value Treatment, Correlation Analysis

• Data Visualization: Tableau, Power BI, Looker Studio, Excel Dashboards, Plotly, Matplotlib, Seaborn

• Databases: MySQL, PostgreSQL, SQL Server, BigQuery, Oracle (basic), SQLite, SAP HANA

• Spreadsheets & Excel Tools: Advanced Excel (VLOOKUP, INDEX-MATCH, Pivot Tables, Power Query, Data Validation), Google Sheets

• Statistical Methods: Hypothesis Testing, A/B Testing, T-tests, Chi-square, Linear & Logistic Regression, Time Series Analysis

• Business Intelligence Tools: Tableau Desktop, Power BI Service, Looker Studio, Google Analytics

(basic), Excel Reporting Automation

• Data Sources & APIs: CSV/Excel Import, Google Sheets Integration, REST APIs (data retrieval only), JSON parsing

• Project & Collaboration Tools: Jupyter Notebooks, Google Colab, Git (basic), Jira, Confluence, Microsoft Teams, Slack

• Workflows & Methodologies: Agile/Scrum, Data Storytelling, KPI Tracking, Dashboard Design, Report Automation

Certification

Oracle Cloud Database Services 2025 Certified Professional WORK EXPERIENCE

Epsilon Jan 2025 - Present

Data Analyst TX, USA

• Automated Power BI dashboards using Excel sources, reducing manual reporting hours by 40% and enabling the marketing team to track campaign KPIs weekly without analyst intervention.

• Queried BigQuery with SQL Window Functions to identify churn trends, revealing 19% drop-off in week one, prompting onboarding content improvements for increased user retention.

• Connected REST APIs to Looker Studio dashboards, transforming live campaign data into accessible visuals that accelerated marketing optimization efforts by reducing reporting lag across departments.

• Conducted T-tests on product interface changes during A/B testing phases, confirming a 7% user engagement increase and assisting rollout decisions based on statistical validation.

• Created sales forecasts in R using ggplot2 and regression models, cutting quarterly revenue prediction errors by 13% and enabling more accurate planning for finance teams.

• Cleaned 250K+ records using Pandas in Jupyter, resolving missing values and standardizing inputs to improve data quality for marketing and operations reports shared with leadership. Hexaware Technologies Feb 2021 - Jul 2023

Data Analyst India

• Automated Excel dashboards using Pivot Tables and Power Query, reducing reporting time by 35% and allowing faster access to critical performance indicators by operations and sales teams.

• Queried MySQL databases with complex joins and CTEs, identifying 12M in inconsistencies across financial datasets and initiating corrective action with corporate finance.

• Designed Tableau dashboards to monitor drop-offs in marketing funnels, helping digital teams reduce bounce rates by identifying weak conversion paths across landing pages.

• Analyzed customer reviews using Pandas and Seaborn, discovering a 14% link between ratings and repeat purchases, supporting product enhancements based on user feedback.

• Built Google Sheets trackers with VLOOKUP and validation, improving warehouse stock accuracy and reducing inventory duplication errors by 31% over quarterly audits.

• Modeled lead behavior with logistic regression in R, enabling marketing to prioritize outreach efforts and improve conversion likelihood on high-value customer segments.

• Retrieved SLA metrics from REST APIs using Python, integrating status dashboards that helped reduce average ticket resolution delays across three internal service teams.

• Supported Agile development with Jira and Confluence, enhancing sprint planning visibility and accelerating task completion timelines by 18% through improved analytics collaboration. Intex Technologies May 2020 - Jan 2021

Data Analyst Associate India

• Standardized sales reports using Excel formulas like INDEX-MATCH and data validation, improving report accuracy and reducing entry errors for over 30 regional sales offices.

• Categorized NPS feedback in Google Sheets to surface recurring issues, leading to policy changes that improved service satisfaction scores by 16% in customer care departments.

• Created daily performance trackers using conditional formatting, allowing regional managers to identify performance drops within 24 hours and initiate immediate corrective actions.

• Built Tableau dashboards segmented by product and region, reducing manual reporting time by six hours weekly and improving visibility for sales leadership.

• Queried SQLite to identify mismatches between SKU pricing and promotional catalogs, uncovering 7%

• inconsistencies that were corrected before national marketing campaigns.

• Visualized festive season demand trends using Matplotlib, enabling product teams to align discount timing with peak customer engagement windows across three major campaigns.

• Managed Jira tickets across analytics and support teams, closing 45+ issues by resolving blockers and improving workflow visibility using shared boards.

• Documented routine analytics workflows in Confluence, reducing analyst onboarding time and standardizing reporting procedures across the business intelligence department.

• Leveraged SAP HANA to process and analyze real-time data sets for a logistics dashboard, enabling

• 20% faster decision-making for regional dispatch teams EDUCATION

Texas Tech University, Lubbock, Texas May 2025

Master of Computer Science

VIT University, Chennai, India Aug 2021

Bachelor's, Electronics and Communication Engineering

Contact this candidate