Business Analyst Public Health

Venkata Sai Nikhil Pasupuleti

Virginia +1-910-***-**** *****************@*****.*** LinkedIn

CAREER SUMMARY

Business Analyst with over 3 years of experience delivering data-driven solutions across public health, advertising, and IT consulting sectors. Adept at translating complex business requirements into actionable insights through stakeholder collaboration, structured documentation, and visualization. Proven ability to manage end-to-end analysis cycles from data collection and transformation to dashboard reporting and user acceptance testing (UAT), using tools like Salesforce, SQL, Tableau, Power BI, and Excel. Skilled in designing CRM workflows, conducting gap and risk analysis, modeling business processes with UML, and enabling agile delivery through user stories and sprint planning. Demonstrated success in streamlining campaign performance, public health reporting, and B2B product modernization by integrating business acumen with technical tools such as Python, R Studio, and geospatial analytics platforms like QGIS and ArcGIS. Committed to enhancing data integrity, reporting accuracy, and cross-functional alignment through collaborative enablement, documentation, and performance monitoring. PROFESSIONAL EXPERIENCE

Data Evaluation Intern Horton's Kids Washington D.C, USA June 2025 – Present

• Gathered, cleaned, and processed youth engagement and program data using Excel and Salesforce CRM to ensure high data integrity, resulting in a 40% reduction in manual corrections and a 25% improvement in reporting efficiency for quarterly impact assessments.

• Designed and delivered Salesforce training sessions for cross-functional staff, developed user-friendly documentation to standardize CRM workflows, and increased platform adoption by 35%, thereby strengthening internal program tracking and grant reporting accuracy.

• Built dynamic visual dashboards using Excel and Google Data Studio to analyze attendance trends and participation across demographics, enabling leadership to present clear, data-backed progress updates to donors and align outreach strategies to underserved communities.

• Collaborated with program evaluation teams and contributed to continuous learning initiatives in data analysis, risk identification, and reporting best practices, enhancing the accuracy of grant submissions, reducing audit data retrieval time by 20%, and fostering informed decision-making through real-time insights. Business Analyst Vitra.ai Bangalore, India March 2022 - July 2023

• Elicited campaign performance requirements through structured stakeholder workshops with Amazon and Flipkart teams, translating complex business needs into actionable insights that reduced scope ambiguity by 30%.

• Analyzed advertisement engagement patterns using SQL to identify underperforming creatives, guiding optimization strategies that led to a 12% increase in click-through rates (CTR) across high-traffic campaigns.

• Designed and managed structured A/B testing protocols to compare ad versions across targeted segments, enabling evidence- based enhancements that improved conversion rates by 15%.

• Conducted detailed risk analysis by identifying potential bottlenecks in campaign rollouts and collaborated with QA and product teams to align testing efforts with mitigation strategies, proactively resolving vulnerabilities and increasing defect detection rates while ensuring stable, scalable ad-deployment during high-volume events.

• Integrated Salesforce CRM to centralize campaign data and client feedback, streamlining lead tracking and improving client engagement reporting accuracy by 22%.

• Visualized campaign metrics using Tableau and Excel, delivering interactive dashboards and weekly reports that empowered clients to make insight-driven budget reallocation decisions, increasing ROI by 20%.

• Modeled end-to-end ad campaign workflows using UML diagrams (Use Case and Activity), which improved interdepartmental understanding and reduced onboarding time for new developers by 25%.

• Facilitated and managed User Acceptance Testing (UAT) with business stakeholders by designing test scripts, validating feature behavior, and gathering feedback, which led to a 50% first-cycle approval rate for ad optimization features.

• Documented business requirements, functional specs, and testing artifacts using JIRA and Confluence, enabling version control and enhanced transparency throughout the project lifecycle.

• Maintained system compliance and uptime targets by embedding security and performance checkpoints into test cycles and documenting requirements through BRD and FRD, achieving platform stability during major ad campaign launches. Business Analyst Zensar Bangalore, India June 2020 - March 2022

• Queried and analyzed application performance data using SQL to uncover key functionality gaps based on user interaction logs, enabling stakeholders to prioritize defect resolution and contributing to a 20% drop in client-reported incidents.

• Visualized operational trends and performance metrics in Power BI, producing interactive dashboards that facilitated real- time decision-making by business stakeholders and improved sprint planning efficiency by 18%.

• Developed comprehensive RTMs, gap analysis documents, and UML diagrams (Use Case, Sequence, Activity) using Excel and modeling tools to bridge functional gaps between legacy systems and new B2B enhancements, streamline modernization roadmaps, and accelerate solution sign-off by reducing rework and clarification cycles.

• Performed Risk Analysis by identifying data bottlenecks and process vulnerabilities in cross-functional handoffs; shared mitigation strategies with delivery teams which reduced production rollbacks by 12%.

• Synthesized client requirements into user stories and acceptance criteria through stakeholder interviews and market research; enabled agile teams to deliver increments that better aligned with business value.

• Collaborated with QA and client-side teams to validate requirements during UAT, using structured Excel test cases and defect logs; ensured solution alignment and increased first-round approval rates by 10%.

• Created and disseminated business and functional documentation that served as the single source of truth for internal and external teams, resulting in reduced communication gaps and enhancing stakeholder satisfaction.

• Monitored sprint outcomes against business KPIs using Excel-based performance trackers and Tableau charts, helping project managers and product owners make data-driven course corrections throughout the release cycle.

• Utilized Jira for user story management and sprint planning, and Confluence for maintaining centralized project documentation and decision logs, enhancing team collaboration and improving traceability across agile ceremonies. CORE SKILLS

• Business Analysis: Requirement Gathering, Gap Analysis, Risk Analysis, User Stories, UAT, SWOT Analysis, Cost-benefit analysis, Road Mapping, Process Mapping

• Tools & Platforms: Salesforce CRM, JIRA, Confluence, Google Data Studio, QGIS, ArcGIS

• Visualization & Reporting: Tableau, Power BI, Excel Dashboards, Interactive Reporting, KPI Monitoring, GeoPandas, Matplotlib (implied), GIS Shapefiles Export

• Documentation: BRD, FRD, UML Diagrams, Requirement Traceability Matrix (RTM), User Manuals

• Collaboration & Process: Cross-functional Coordination, Agile Ceremonies, Stakeholder Communication

• Programming & Analytics: Python (Data Processing), SQL

• Geospatial Analytics: Sentinel-1 SAR Processing, Flood Detection Modeling, Raster Data Analysis

• Project Management & Compliance: Sprint Planning, Backlog Refinement, Delivery Timelines Optimization, Data Governance, Compliance Monitoring, Uptime Maintenance EDUCATION

George Mason University MS in Data Analytics Engineering Aug 2023 - May 2025 SRM Institute of Technology B. Tech in Electrical and Electronics Engineering July 2016 -April 2020 PROJECTS

Flood Detection System Using Sentinel-1 SAR Imagery Python, QGIS Jan 2025 - May 2025

• Built an automated flood detection pipeline using Sentinel-1 SAR imagery with decibel-based thresholding and change detection, generating GIS-compatible shapefiles for real-time disaster response in QGIS.

• Validated results (70% accuracy) using NOAA imagery and Copernicus flood data, improving emergency planning and resource allocation in hurricane-affected regions. Sales Performance Dashboard Power BI April 2022 - July 2023

• Defined and documented key sales KPIs (revenue, lead conversion, region-wise performance) and designed wireframes for Power BI dashboards to align stakeholders on critical metrics, enabling leadership to monitor real-time sales trends and improve strategic decision-making efficiency by 70%.

• Validated dashboard prototypes through UAT sessions and collaborated with data engineers to establish transformation rules for inconsistent CRM, ERP, and Excel data, ensuring accuracy of insights and contributing to a 15% increase in quarterly sales.

E-commerce Website Checkout Experience Enhancement SQL April 2021 - Mar 2022

• Analyzed customer journey data through web analytics and surveys to identify pain points such as lengthy checkout forms and limited payment options, enabling the design of guest checkout and additional gateways that reduced cart abandonment by 25%.

• Collaborated with UX designers and developers to prioritize and implement streamlined checkout enhancements while ensuring PCI DSS compliance, which shortened checkout time by 45% and boosted overall revenue by 18% within three months.

Contact this candidate