Bhanusri Punukollu
LinkedIn: https://www.linkedin.com/in/bhanusripunukollu/
Email: **********@*****.*** ****************@*****.***
Phone No: 945-***-****
PROFESSIONAL SUMMARY
Versatile IT professional with 5 years of progressive experience as a Business Analyst, delivering business-critical solutions across domains such as Banking, Financial Services, Property & Casualty Insurance, Mortgage Origination & Servicing, and EdTech. Demonstrated expertise in end-to-end requirements gathering, enterprise data warehousing, and information systems design translating complex stakeholder needs into robust, compliant, and scalable technical solutions.
Extensive experience in the Financial Investment Banking sector with deep conceptual and practical understanding of capital markets, including equities, bonds, fixed income instruments, derivatives, and structured products.
Proven ability to support front-to-back-office processes across asset and portfolio management workflows, enabling data-driven investment strategies and regulatory compliance.
Worked with team to document existing and end state model, reporting requirements and phasing.
Extensive knowledge of Software Development Life Cycle (SDLC) methodologies including Waterfall and Agile (Scrum), with hands-on experience driving project execution across all phases.
Proficient in end-to-end requirements engineering eliciting, documenting, validating, and managing functional and non-functional requirements in alignment with business and technical stakeholder needs.
Strong background in authoring key business artifacts including Business Requirements Documents (BRD), Functional Requirements Documents (FRD), Statements of Work (SOW), and Requests for Proposal (RFP), ensuring traceability and regulatory compliance.
Worked closely with teams across the business which includes developers, QA, and leadership to keep everyone aligned, informed, and moving toward shared project goals.
Demonstrated success in planning and executing User Acceptance Testing (UAT), including test case creation, scenario mapping, and defect triaging for enterprise insurance applications.
Advanced expertise in Agile Scrum methodology, with a strong command of writing user stories, managing product backlogs, and conducting sprint ceremonies using tools such as JIRA and Rally.
Skilled in designing and delivering data-driven business insights through Power BI and Tableau dashboards, enabling executive-level decision-making and operational reporting.
Proficient in writing and optimizing SQL queries, leveraging joins, subqueries, and data transformations for reporting, validation, and ad-hoc analysis.
SKILLS
Data Analysis & Visualization: SQL, Power BI, Tableau, Advanced Excel, Python (Pandas, NumPy, Matplotlib)
Cloud & Big Data: AWS (S3, Redshift, EMR), Microsoft Azure
Business Intelligence: Data Modeling, Dashboard Development, Reporting Automation, KPI Tracking
Programming: Python
Tools: Microsoft Power Platform, Git, Jira, Confluence.
Analytics Techniques: ETL, Data Pipeline Optimization, Customer Targeting, Ad Technology Trends
Soft Skills: Stakeholder Communication, Cross-functional Collaboration, Problem-solving, Critical Thinking
PROFESSIONAL EXPERIENCE
Client: Wells Fargo, Dallas, Texas, United States Oct 2023 – Present
Role: Senior Business Analyst
Responsibilities:
Worked closely with business stakeholders and SMEs to gather, clarify, and document requirements across customer support, CRM systems, and operational workflows.
Developed Business Requirement Documents (BRD), Functional Specifications (FSD), and Software Requirements Specifications (SRS), ensuring alignment with business goals and technical feasibility.
Performed gap analyses between legacy systems and enterprise platforms like Guidewire to support seamless transitions and drive digital transformation.
Translated complex business processes into Business Process Models, Use Case Diagrams, and data flow charts using UML and Rational Unified Process (RUP) methodology.
Defined and prioritized user stories, managed product backlogs, and facilitated Agile ceremonies including sprint planning, retrospectives, and daily stand-ups.
Led and coordinated User Acceptance Testing (UAT), including test case development, defect triaging, and end-user training for enterprise applications in banking.
Collaborated with business, engineering, QA, risk, and compliance teams to deliver solutions that were scalable, user-friendly, and aligned with regulatory standards.
Mapped data between internal systems and third-party APIs using ACORD XML/XSD schemas and metadata rules, enabling structured and interoperable data exchange.
Collaborated with compliance and legal teams to align product capabilities with regulatory frameworks such as PCI-DSS, HIPAA, and GDPR.
Supported implementation of fraud analytics dashboards and monitoring tools, enabling real-time detection of anomalous transactions and improving investigative response times.
Contributed to merchant onboarding strategy and integration of POS, mobile, and online payment gateways with secure, scalable architecture.
Created and maintained detailed project plans, covering budgeting, resource management, timeline tracking, and risk assessment using Microsoft Project.
Developed RFPs and SOWs to guide vendor evaluation, support procurement activities, and enable integration with third-party platforms.
Worked closely with both business and technical teams during JAD sessions to ensure everyone had a shared understanding of the goals and requirements.
Designed and automated dashboards in Power BI, Tableau, and Quick Sight to support KPI tracking, executive reporting, and operational optimization.
Automated recurring reports and streamlined ETL processes, saving over 30+ hours per month and reducing data delivery SLAs by 40%.
Applied Agile SAFe 5.1, DevOps, and Test-Driven Development (TDD) frameworks to improve project velocity and software quality.
Hands-on experience with JIRA and Rally to manage Agile sprints, write and refine user stories, and track development and QA activities throughout the lifecycle.
Proficient in writing advanced SQL queries for data validation, transformation, and analysis, including multi-join and subquery logic for reporting.
Environment: Agile Methodology, Restful APIs, AWS (Lambda, RDS, S3), Data Analytics, Data Pipelines, PCI-DSS, GDPR Compliance, Secure APIs, Core Banking Solutions, SQL, Tableau, JIRA, Confluence and UML (MS Visio).
Client: Byjus - The Learning App, Hyderabad, India June 2021 - Aug 2023
Role: Business Analyst
Responsibilities:
Led business requirement gathering initiatives through JAD sessions, stakeholder interviews, and functional workshops to support large-scale product and campaign enhancements.
Translate stakeholder needs into well-structured functional requirements and specifications, directly influencing analytics product roadmaps and operational tools.
Played a key role across the SDLC using Agile methodologies, managing sprint backlogs, facilitating sprint planning, and continuous delivery of data-driven solutions.
Mapped and redesigned business processes to improve forecasting, streamline inventory planning, and boost user engagement efficiency.
Involved with Sales, Marketing, and Channel Operations teams to identify business process gaps, streamline operational flows, and quantify ROI for proposed system solutions.
Facilitated requirement validation with SMEs and translated user stories into detailed functional specs, driving better team alignment and reducing rework.
Worked with engineering teams to implement and configure data integrations across systems using REST APIs, enabling seamless flow of student activity and campaign performance data.
Designed data models and created entity-relationship diagrams (ERDs) to support scalable reporting infrastructure and downstream analytics.
Created and validated predictive models to support campaign targeting, retention strategies, and cohort analysis using historical performance and behavioral data.
Developed detailed test strategies and executed scenario-based testing to validate platform enhancements prior to production deployment.
Defined ETL requirements and supported QA testing of data pipelines used for tracking campaign performance and user engagement dashboards.
Applied Agile SDLC practices to iterate quickly on data products and user-facing dashboards, driving fast feedback loops and continuous improvement.
Designed Use Case, Activity, and Data Flow Diagrams in MS Visio to articulate system behaviors and facilitate cross-team understanding.
Developed FRDs and UAT documentation aligned with UML standards, improving handoff quality to development and QA teams.
Designed and executed UAT test scripts to validate analytics features and campaign delivery workflows across critical user touchpoints.
Defined KPIs for inventory optimization, course subscription conversion, and learner engagement across sales funnels and personalized campaigns.
Developed and maintained Power BI dashboards for executive reporting, allowing leadership to monitor conversion trends, student activity, and campaign ROI in real time.
Supported the project manager in defining task dependencies, tracking milestone progress, and ensuring cross-functional alignment on key deliverables.
Environment: JIRA, Confluence, Microsoft Visio, Microsoft Project, Rational Rose, SQL, Power BI, RESTful APIs, JSON,
XML, ETL, Agile (Scrum), SDLC
Client: Unacademy, Hyderabad, India May 2020 - May 2021
Role: Associate Business Analyst
Responsibilities:
Collaborated with business stakeholders and academic teams to gather and document analytical requirements supporting course performance, subscription behavior, and operational efficiency.
Developed and optimized complex SQL queries for data extraction, transformation, and validation across multiple datasets to support reporting and decision-making.
Contributed to Agile project execution by tracking milestones, identifying delivery risks, and ensuring the successful completion of data and product initiatives.
Partnered with engineering teams to enhance data flows within learning platforms and integrated third-party services such as payment gateways, assessment tools, and user analytics providers.
Designed and maintained real-time dashboards using Power BI and Amazon QuickSight, enabling leadership to monitor engagement, retention, and revenue KPIs.
Managed user stories, backlog refinement, and sprint planning using JIRA and Confluence, aligning data product delivery with business priorities
Acted as a central liaison between analytics, engineering, and product teams to ensure end-to-end clarity on data definitions, reporting logic, and project deliverables.
Conducted User Acceptance Testing (UAT) for dashboard and platform enhancements, ensuring accurate data delivery, business alignment, and timely deployment.
Environment: Jira, Confluence, SQL, Agile Methodology, Microsoft Office Suite, JIRA, SQL
EDUCATION:
Bachelor of Science and Engineering from Koneru Lakshmaiah Educational Foundation.
Master’s in business Analytics from University of Texas at Arlington.