Business Data Analyst - KPI Dashboards & Forecasting

VENKATA SAI VEERENDRA GUBBALA

Atlanta, GA +1-417-***-**** **********@*****.*** LinkedIn

PROFESSIONAL SUMMARY

• Business Data Analyst with 4+ years of experience delivering KPI dashboards, performance monitoring, and decision-support reporting using SQL, Power BI, Tableau, Excel, and Looker Studio across Finance, Marketing, and Operations teams.

• Reduced manual reporting effort by 80% by automating analytics workflows integrating Salesforce NPSP, financial systems, and relational databases into executive reporting dashboards.

• Built forecasting models and variance analysis frameworks to improve short-term revenue visibility and campaign performance tracking for leadership planning decisions.

• Translated stakeholder requirements into scalable Power BI data models and automated reporting solutions using SQL, Python, and Google Analytics 4 to improve reporting accuracy, metric governance, and decision timelines. TECHNICAL SKILLS

Data Analysis & Querying: SQL, Advanced Excel (Pivot Tables, Power Query, VLOOKUP/XLOOKUP), Python (Pandas, NumPy). Data Visualization & BI Tools: Power BI (DAX, Star Schema Data Modeling), Tableau, Looker Studio. Business Analytics & Reporting: KPI Development, Dashboard Design, Trend Analysis, Variance Analysis, Forecasting Models, Data Storytelling, Executive Reporting.

CRM & Web Analytics: Salesforce Analytics (NPSP Reporting), Google Analytics 4. Statistical & Predictive Analytics: Regression Analysis, A/B Testing, Predictive Modeling, Scenario Analysis. Data Integration & Transformation: Power Query, API-based Data Integration, Reporting Automation. Business Documentation & Requirements: Requirements Gathering, BRD, FRD, Gap Analysis, Use Case Documentation, Process Mapping. Data Platforms & Databases: PostgreSQL, MySQL, Microsoft SQL Server, Oracle. Workflow Automation & Collaboration Tools: JIRA, Git, Power Automate, Zapier. Cloud Analytics Environment: Microsoft Azure (Azure Data Factory, Azure Data Lake), AWS (Amazon S3). PROFESSIONAL EXPERIENCE

Business Data Analyst Feb 2025 - Present

World Changers Church International, GA Atlanta, GA

• Developed Power BI executive dashboards using star schema data models to centralize donor, revenue, and campaign KPIs, improving leadership reporting turnaround time by 60%.

• Integrated Salesforce NPSP and Sage Intacct datasets using Power Query and API-based data consolidation workflows, enabling Finance teams to reconcile contribution tracking with 100% record alignment across systems.

• Designed KPI tracking frameworks in collaboration with Finance and Marketing stakeholders to standardize weekly campaign performance monitoring across multiple reporting channels.

• Automated recurring donor analytics reporting using Python and Zapier workflows, reducing manual spreadsheet processing effort by 80% across operations teams.

• Built Looker Studio dashboards leveraging Google Analytics 4 traffic insights to help Marketing evaluate engagement trends and improve campaign conversion visibility.

• Delivered short-term revenue forecasting models using regression-based historical contribution trends, supporting leadership budget planning with a 4-month forward outlook.

• Strengthened data validation controls between Classy, GoFundMe, and Salesforce integrations through structured reconciliation logic that improved reporting governance and reduced reporting mismatches by 35%.

• Coordinated cross-functional reporting requirements with Finance, IT, and Communications teams to translate business questions into automated dashboards supporting weekly executive review meetings. Graduate Assistant - Library IT Data Analytics Aug 2023 - Jul 2024 Missouri State University Springfield, MO

• Maintained PostgreSQL reporting datasets supporting circulation analytics and inventory monitoring workflows, improving dataset reliability to 99.9% accuracy for operational reporting.

• Automated Python-based data collection scripts using API integrations that reduced manual data preparation workload by nearly 50% across library reporting processes.

• Created Excel dashboard solutions using Pivot Tables and Power Query transformations to help administrative staff monitor usage trends and resource allocation patterns.

• Implemented automated alerting logic for anomaly detection within reporting tables, improving issue identification speed by 30% during weekly circulation tracking reviews.

• Prepared structured reporting documentation and SOP guides to support continuity of analytics workflows after project completion across departmental stakeholders.

• Collaborated with Library Operations leadership to translate stakeholder reporting requirements into performance metrics dashboards used for planning service coverage schedules. Data Analyst - Data Platforms & Reporting Nov 2018 - Dec 2020 Cognizant Technology Solutions India

• Optimized SQL-based reporting queries across enterprise data environments to improve dataset retrieval performance by 30% for business intelligence consumption layers.

• Developed Azure Data Factory workflows supporting structured dataset integration across reporting environments used by downstream analytics teams.

• Validated enterprise reporting datasets using structured quality-check frameworks that strengthened cross-system data consistency across multiple operational sources.

• Supported dashboard-ready dataset preparation through transformation logic applied within SQL Server and Oracle environments for analytics consumption readiness.

• Collaborated with cross-functional delivery teams to translate reporting requirements into structured data validation rules supporting production analytics environments.

• Enhanced reporting dataset accessibility by implementing role-based access controls aligned with enterprise governance and compliance expectations.

• Produced technical documentation describing reporting dataset logic and transformation rules supporting handover readiness across analytics support teams.

• Assisted analytics delivery stakeholders in supporting scheduled reporting refresh cycles to ensure stable dataset refresh cycles supporting business reporting timelines.

PROJECTS

Customer Retention Analytics Dashboard

• Built cohort-based retention dashboards in Power BI using SQL-transformed lifecycle datasets to help stakeholders track repeat engagement patterns across customer segments.

• Developed regression-driven churn-risk indicators that improved early identification of high-risk users and supported targeted retention interventions increasing repeat interaction rates by 26%.

• Performed variance and A/B testing analysis across campaign-driven vs organic retention channels using DAX measures to strengthen marketing decision-making on customer re-engagement strategies. Financial Variance Monitoring & Forecasting Dashboard

• Designed Power BI variance monitoring dashboards comparing budget vs. actual performance across reporting units, improving financial review transparency during quarterly planning cycles.

• Developed short-term forecasting models using historical expenditure trends to support finance teams in evaluating spending behavior across multiple scenario assumptions.

• Standardized departmental KPI definitions using Excel Power Query transformations, improving consistency and reliability of financial performance reporting by 35%.

Digital Engagement Intelligence Dashboard

• Developed interactive Looker Studio dashboards using Google Analytics 4 (GA4) data to track user acquisition, engagement, and traffic performance across weekly reporting cycles.

• Analyzed key metrics such as sessions, bounce rate, session duration, and user behavior trends to identify engagement patterns and potential drop-off points across top-performing pages and channels.

• Delivered actionable insights on channel performance, user demographics, and device usage, enabling stakeholders to optimize marketing strategies and improve audience targeting efficiency. EDUCATION

Master of Science in Information Technology Aug 2023 - Aug 2024 Missouri State University Springfield, MO

Postgraduate Diploma in Data Science and Analytics Jan 2021 - Sep 2022 Royal Holloway University London

Bachelor of Engineering in Electronics and Communication Engineering Mar 2014 - May 2018 KL University Vijayawada, India

CERTIFICATIONS

• Microsoft Certified: Azure Data Engineer Associate - Microsoft

• IBM Applied Data Science Specialization - Coursera

• Linux Shell Scripting - Udemy

• Certified Senior System Architect in PRPC v7.2, PEGA Systems Inc.

• Microsoft Power BI Data Analyst Professional Certificate - Coursera

• Google Business Intelligence Professional Certificate - Coursera

Contact this candidate