Vara Prasad
Sr Business Analyst
Hyderabad
Summary
Results-driven Data Analytics professional with strong expertise in data querying, cleaning, and transformation using Snowflake and SQL, coupled with hands-on experience in building dynamic Power BI dashboards for large-scale business teams. Adept at developing complex data models, DAX measures, and automated reporting solutions that reduce manual effort and improve data reliability. Recognized for bridging the gap between technical data processes and business strategy through effective stakeholder collaboration and clear technical documentation.
Overview
8
8
years of professional experience
2
2
Certifications
3
3
Languages
Work History
Sr Business Analyst - Data
ServiceNow
05.2022 - Current
- Designed and developed enterprise-wide Certification Compliance Dashboards in Power BI to monitor role vs certification completion across the organization, enabling ServiceNow to increase certification completion rates by 20% within one quarter.
- Built and automated a Guided Segment Management dashboard for a 400+ member team, tracking 50+ KPIs on productivity, utilization, and operational metrics — improving leadership visibility and data-driven decision-making.
- Collaborated with the Time-to-Value team to create a KPI-driven performance dashboard, reducing reporting turnaround by 40% and providing actionable insights into customer onboarding timelines.
- Partnered with the Technical Accelerators team to design a regional performance analytics dashboard, evaluating associate performance and customer engagement across geographies — improving transparency and recognition processes.
- Queried, cleaned, and transformed large-scale datasets in Snowflake using SQL and advanced data manipulation techniques, ensuring high-quality, analysis-ready data pipelines for downstream dashboards.
- Performed deep-dive data analysis to identify trends, anomalies, and improvement opportunities based on business requirements — delivering insights that directly supported strategy and operations teams.
- Created detailed Technical Requirement Documents (TRDs) and data flow specifications to standardize analytics processes and improve cross-team collaboration.
- Led stakeholder requirement gathering sessions with business, operations, and product teams to translate ambiguous needs into measurable analytics outcomes and visualization requirements.
- Built data models and complex DAX measures in Power BI to deliver accurate and interactive dashboards tailored to business functions.
- Automated repetitive Excel and Power BI reporting processes using Power Query and Power Automate, saving 15+ hours per week in manual effort.
- Ensured data accuracy and consistency through validation checks, improving reporting reliability and reducing reconciliation errors by 25%.
- Presented data insights and visual stories to senior leadership, influencing decisions related to workforce training, process efficiency, and customer success.
Senior Associate
Cdk Global Pvt LTD
03.2020 - 02.2022
- Perform Adhoc reports and data analysis as requested.
- Daily, Weekly, and Monthly CTA individual tracking including the number of daily interactions, time in calls, time in chats, % of one call resolutions
- Worked on Different tools likes salesforce, Proclarity, SQL, Decision manager and vision to extract the data
- Experience in creating different visualizations using Bars, Lines and Pies and Highlight tables Using Tableau.
- Lookup functions like V Lookup, Hlookup, Xlookup and Logical Functions Such as Sum and Average are Used to populated The Report Data Based On the Exiting Data. Recording the Macro and using it when needful.
- Used Data Blending, Filters, groups, Parameters, Sets, Bins to compare and analyze data in different perspectives. Having experience in developing end-to-end Business Intelligence solutions in accordance with standard methodologies using Tableau
- Cost Control: Free onsite & virtual training. T&E costs and averages. Average cost per install and average install per associate.
- Roles and Responsibilities
Analyst
Optum Global Solutions (UHG)
06.2017 - 07.2019
- I am associated with a team where we are generating reports on daily basis and published as a newsletter
- Functional abilities in creating and maintaining Daily Production Reports, Daily Audit Report, Production Trend Report, Audit trend Report
- Roles and Responsibilities
Education
Master of Pharmacy - Master of Pharmacy
Jawaharlal Nehru Technological University
Hyderabad, India08.2019
Skills
Microsoft PowerBI
Snowflake
Data Models
DAX & Power Query
Data Cleaning & Manipulations
Data Visualization
SQL
Data Management
Stakeholder Management
Technical requirement gathering and Documentation
Certification
Microsoft AI Product Manager
Timeline
Microsoft Certified: Power BI Data Analyst Associate PL 300
11-2025
Microsoft AI Product Manager
07-2025
Sr Business Analyst - Data
ServiceNow
05.2022 - Current
Senior Associate
Cdk Global Pvt LTD
03.2020 - 02.2022
Analyst
Optum Global Solutions (UHG)
06.2017 - 07.2019
Master of Pharmacy - Master of Pharmacy
Jawaharlal Nehru Technological University