Summary
Overview
Work History
Skills
Timeline
Generic
Vuppalapati Raghu S

Vuppalapati Raghu S

Irving

Summary

Dynamic and results-driven Senior Business Systems Analyst with 8+ years of expertise across Unemployment Insurance, Paid Family Leave, Travel & Airline Industry, Telecommunications, Capital Markets, and Financial Services. Adept at translating complex business requirements into technical solutions, optimizing system performance, and leading cross-functional teams to deliver scalable, secure, and high-performing applications. Proficient in stakeholder management, business process mapping, system testing (UAT), and change management, ensuring seamless project execution and adherence to quality standards. Strong background in SQL, MySQL, data analytics, and cloud technologies (AWS & Azure) to drive process enhancements and system efficiencies. Deep expertise in regulatory compliance and financial frameworks, including AML, ASC 606, IFRS 15, 401k, FINRA OATS, BASEL I-III, CCAR, SOX, Dodd-Frank, BSA, and SAR, ensuring systems align with industry standards. Experienced in Agile (Scrum, SAFe) and Waterfall methodologies, with a strong grasp of SDLC, requirements elicitation, and backlog prioritization. Skilled in facilitating JAD sessions, SWOT analysis, GAP analysis, and process re-engineering to drive strategic solutions. Proficient in crafting BRD, FRD, SRS, RTM, Use Case Documents, Data Mapping Specifications, and Workflow Designs, along with wireframes & mockups using Visio & Balsamiq. Expertise in UML diagrams (Use Case, Activity, Sequence, Class, BPMN) for clear process visualization. Hands-on experience in API validation, REST/SOAP services (Postman, Swagger, SoapUI), microservices architecture, and three-tier system design. Strong background in ETL processes, Data Warehousing (Star & Snowflake Schema), OLAP operations, and BI reporting using Snowflake, Tableau, Cognos, and Power BI. A servant leader, fostering collaboration across teams, ensuring efficient requirement gathering, backlog grooming, sprint planning, and release management. Adept at writing User Stories, defining Acceptance Criteria (INVEST & 3 C’s), conducting test planning, and supporting UAT to drive successful project outcomes. Proven ability to bridge the gap between business and technology, delivering high-quality, data-driven solutions that enhance efficiency, compliance, and customer experience in dynamic, fast-paced environments.

Overview

9
9
years of professional experience

Work History

Sr. Business Systems Analyst

BSASPEC, INC
11.2023 - Current
  • Project 1: Geographic Solutions: The scope of the project was to build an Unemployment Insurance Website and Application that aims to develop a secure, user-friendly digital platform for claimants to file and track unemployment insurance claims. This system will automate claim submission, verification, adjudication, and payment processing while integrating with payroll systems and government databases for accuracy and compliance. The Key features include real-time status updates, fraud detection, and employer services for wage verification and compliance tracking
  • Project 2: The scope of the project was to build Paid Family Leave Website and Application that aims to develop a secure, user-friendly digital platform for claimants to file and track PFL claims
  • This system mainly focuses on Medical, Parental, Family and Pre-Natal Leave and also integrates with employer and government regulations in order for the claimant’s to receive benefits
  • Collaborated with multiple state agencies, employers, and claimants to gather and document business requirements for the Unemployment Insurance (UI) system and Paid Family Leave programs
  • Conducted comprehensive requirement elicitation sessions using Focus Groups, Joint Application Development (JAD) sessions, structured and unstructured interviews, process analysis, and business rules analysis
  • Gained in-depth expertise in state-specific UI and Paid Family Leave requirements across Washington DC, Arizona, North Dakota, Iowa, Louisiana, Nebraska, Pennsylvania, and Ohio
  • Developed user stories and facilitated Planning Poker sessions for sprint estimation during sprint planning and backlog grooming meetings.
  • Utilized the MoSCoW technique to prioritize user stories based on business value
  • Assisted in the design and implementation of AI-driven fraud detection tools to identify suspicious claims and mitigate risks.
  • Conducted gap analysis of existing UI systems to identify opportunities for process automation, increased efficiency, and faster claim resolution
  • Ensured system accessibility & user-friendliness for all claimants, including individuals with disabilities or limited digital literacy
  • Designed test scenarios, conducted User Acceptance Testing (UAT), and validated system functionalities to meet business and regulatory requirements
  • Verified SQL queries using SELECT statements, Views, Joins, Unions, Aggregate Functions, and performance tuning techniques to support reporting and data analysis needs
  • Environment: Waterfall-Scrum Hybrid, MS Visio, Snaggit, MS Office (MS Word, MS Excel, MS PowerPoint), MS SQL Server, MS SharePoint, HP ALM, Pivotal Tracker, Tableau
  • Led User Acceptance Testing (UAT), backlog grooming, and sprint planning to ensure timely delivery of features.
  • Leveraged AWS components (AWS Lambda, AWS SQS, AWS RDS) for backend processing, enabling efficient data flow and real-time claim tracking.
  • Integrated AWS Step Functions for workflow automation, reducing processing times and improving overall system scalability.
  • Utilized AWS EC2 instances for scalable server infrastructure, ensuring high availability and secure access to claims data.
  • Developed automated fraud detection systems using AWS tools, ensuring compliance with state regulations and preventing fraudulent claims.

Sr. Business System Analyst

BSASPEC, INC
03.2021 - 10.2023
  • Project: American Airlines: The project aims to enhance the American Airlines AAdvantage loyalty program by improving the member experience, integrating it with other American Airlines systems, and optimizing the rewards structure. The initiative will provide AAdvantage members with a seamless experience, including easier mile tracking, enhanced redemption options, and personalized offers. Additionally, the goal is to improve member engagement and loyalty through dynamic rewards, better communication, and data-driven personalization
  • Gathered and documented business requirements for AAdvantage program enhancements, ensuring alignment with stakeholder expectations and strategic goals
  • Partnered with Product Managers, customers, and cross-functional stakeholders to define requirements, manage the product backlog, and contribute to the development of the program vision, roadmap, and key features
  • Collaborated with architecture leads to design scalable technical solutions while staying ahead of industry advancements
  • Analyzed business processes, product functionalities, and system capabilities to assess the impact of program enhancements and drive strategic decision-making
  • Worked closely with technology teams to integrate AAdvantage with core American Airlines systems, including flight booking, customer profiles, and CRM platforms
  • Led requirements gathering and planning activities within a SAFe Agile framework, facilitating Program Increment (PI) planning, backlog refinement, and sprint execution
  • Evaluated and redesigned business processes related to mile accrual, redemption, and member engagement, improving program efficiency and customer experience
  • Developed process flow diagrams, swimlane diagrams, and context diagrams to visualize enhancements and ensure stakeholder clarity
  • Authored comprehensive Functional and Technical Specification Documents, bridging communication between business and development teams
  • Defined and refined user stories that adhered to the INVEST criteria, ensuring clear acceptance criteria, dependencies, and business value alignment
  • Collaborated with marketing and product teams to design personalized promotional campaigns based on customer behavior and engagement analytics
  • Drove backlog management and story prioritization, ensuring alignment with business objectives and feature dependencies
  • Enhanced the AAdvantage loyalty program, improving mile tracking, reward redemptions, and user engagement by 30%.
  • Led API testing and integration, optimizing system efficiency and ensuring a seamless experience for members.
  • Managed backlog refinement and sprint planning, ensuring the timely release of features and system improvements.
  • Integrated AWS components such as AWS Lambda and AWS EventBridge for real-time data processing and event-driven architecture, improving member experience.
  • Utilized AWS RDS to optimize database management, ensuring efficient handling of customer profiles and transaction data.
  • Worked closely with DevOps teams to streamline deployments using AWS tools, ensuring seamless integrations with American Airlines' core systems.
  • Applied AWS SQS for handling message queues, enhancing system communication and reducing delays in processing transactions.Created API documentation using Swagger, detailing request/response formats and integration guidelines
  • Conducted API testing using Postman and Insomnia, verifying REST API functionality through GET, POST, PUT, PATCH, and DELETE operations
  • Executed complex SQL queries to extract and validate data, leveraging joins, aggregate functions, and performance tuning techniques
  • Designed and executed test plans, test cases, and regression test scenarios, logging and tracking defects using JIRA
  • Led User Acceptance Testing (UAT) efforts, working with business users to validate system enhancements and resolve issues efficiently
  • Tracked and analyzed key performance indicators (KPIs), measuring the effectiveness of AAdvantage program enhancements, member engagement, and promotional campaigns
  • Environment: Safe 5.0, MS Visio, MySQL, AWS Step functions, AWS Lambda, AWS EC2 Instances, AWS Event Bridge, AWS SQS, AWS RDS, Jenkins, Swagger, Postman, Insomnia, Microservices, Tableau, JIRA, Confluence, and SharePoint

Technical Business Analyst / Scrum Master

BSASPEC, INC
06.2018 - 12.2020
  • Project 1: AT&T: The Scope of the project was to create Intelligent Customer Match (ICM) which will provide the capability to associate customer accounts across multiple billing systems and line of business
  • Defined and implemented multiple, iterative MVP releases for real-time, intelligent customer matching capabilities
  • Project 2: (Customer Graph): The scope of the project was to bring the data from disparate systems into one common place and build API’s to access and update the data in scalable way which meets the needs for the business
  • As a Technical Business Analyst, developed good understanding of multiple billing systems such as Wireless, Uverse, DTV, Watch TV, HBO Max, POTS/Telco, and line of Businesses such as Telegence, MPSYS, Enabler, Evergent, CRM & OMS
  • Worked on SAFe Architecture in which we followed 2-week cadence for the Sprints
  • Mainly focused on PI Planning activities which includes various objectives and goals pertaining to Pre-PI Planning and Post-PI Planning
  • Involved in creating Functional &Technical specification documents by interfacing with the customers &development team
  • Identified dependencies across CG internal and external teams and tagged the dependency by creating User stories
  • Gathered requirements which was in sort of features from Product Management Team by using different elicitation techniques such as Interviews (One on One), Questionnaire sessions and documented those in sort of User Stories
  • Created UML Diagrams such as Activity Diagrams, Sequence Diagrams, Use Case Diagrams & BPMN using MS Visio
  • Formulated User Stories adhering to INVEST criteria and made sure the User Stories are explained and are groomed in a detailed way to the developers and testers which abides the criteria of Definition of Ready and Definition of Done
  • Monitored project progress by tracking activity, resolving problems, and recommending changes when required
  • Facilitated & Participated in Daily Scrum Meetings, Sprint Planning, Sprint Review and Sprint Retrospective Meetings
  • Facilitated & captured the feedback from the Product Manager while demoing user stories in Sprint Demo sessions
  • Coached the entire development team on best agile practices and focused on driving solutions and customer satisfactions
  • Responsible to create RNT Document for IDP Platform Releases which included User Stories and Defects in T-Space
  • Used Jenkins to understand success and failure of the builds of the Microservices while deploying into different environments
  • Performed Documentation and specification for the request and response messages using MuleSoft Anypoint Platform
  • Maintained & Updated AID/WIKI with API/Microservice documentation including request/response details
  • Performed API testing using POSTMAN thereby using REST APIs to check the Request and Response body by using different calling methods such as GET/POST/PUT/PATCH/ DELETE operations on various Endpoints
  • Queried SOLR search engine to retrieve and store Customer’s data & Billing data upon different digital cores using different SQL Queries such select, group by, order by, views, joins, aggregate functions such Sum, Average, Min, Max
  • Assisted in gathering data requirements for the Initial Load from Solr & Azure Cassandra DB using Java Standalone ETL process to ICM Solr where in all billing accounts are matched with eCDW Vertica to check for duplicity & redundancy
  • Captured all the events and processed the logic using ICM Rules Engine Microservice and provided Audit logging facility to trace every event processing and every account to Customer ID association and it is stored an analytics platform called Snowflake so that it can used to analytics, reporting and also for better forecasting
  • Designed Test Plans, Test Cases, Test Scripts, and Test Scenarios to perform Functional Testing, Sanity Testing, and Regression Testing and logged down defects using I-Track and documented the results and shared on WIKI and SharePoint
  • Performed and Facilitated User Acceptance Testing with UAT cases and resolved issues with the business Users
  • ENVIRONMENT: Safe 5.0, MS Visio, Azure Cassandra, CG Solr, Java Standalone ETL, MySQL, Jenkins, Kafka Topics, MuleSoft Any Point Platform, Postman, Microservices, Snowflake, I-Track, Wiki, and SharePoint

Manual & API Tester

Pride Systems
06.2016 - 05.2018
  • Project: JP Morgan Chase: The scope of the project was to enhance the existing trading system and facilitate improved decision making for investors by creating and managing a holistic Dashboard
  • New dashboard would enable enhanced ad-hoc performance overview, dynamic indicators, current news and comments from Analysts and Hedge Fund Managers
  • This would facilitate improved trading experience, and enhanced performance tracking for the existing investors
  • Assisted Project Manager in creating Work Breakdown Structure, Project Plan Document and Project charter
  • Validated REST/SOAP APIs, ensuring seamless integration of real-time trading data, analyst comments, and market updates into the dashboard
  • Performed functional, negative, and performance testing on APIs, verifying response codes, data accuracy, and error handling
  • Automated API tests using Postman Collections and monitored response times, headers, and payloads for improved system performance
  • Conducted functional, regression, and integration testing of the trading dashboard, ensuring correct display of financial metrics, news feeds, and dynamic indicators
  • Identified, documented, and tracked defects using HP ALM while working closely with developers to ensure timely resolution
  • Developed test plans, & test cases aligned with functional and non-functional requirements
  • Ensured comprehensive test coverage for dashboard UI, data visualization components, financial calculations, and system workflows
  • Executed manual and automated test cases to validate trade execution flows and investor performance tracking
  • Collaborated with business analysts, traders, and investors to define UAT scenarios and ensured system functionality aligned with end-user expectations
  • Conducted UAT sessions, captured user feedback, and addressed gaps in performance metrics, usability, and data accuracy
  • Maintained test artifacts in HP ALM, including test scripts, test cases, execution results, and defect logs
  • Generated detailed test reports, defect matrices, and traceability matrices to assess system stability and readiness for production release
  • Analyzed system responsiveness under high trading volumes using Postman’s load testing features
  • Worked with performance engineers to assess latency, scalability, and throughput of financial data streams
  • Validated financial data consistency between the dashboard, market feeds, and backend databases
  • Wrote SQL queries to verify correct storage and retrieval of investment performance data
  • Prioritized and categorized defects based on impact, working closely with developers and business teams to ensure quick resolution
  • Re-tested resolved defects and updated test cases accordingly
  • Environment: Waterfall-Scrum Hybrid, MS Office (MS Word, MS Excel, MS PowerPoint), Postman, Swagger, HP ALM, MS SQL Server and JIRA

Skills

  • Agile (Scrum, SAFe, Kanban)
  • MS Visio
  • Balsamiq
  • JIRA
  • Confluence
  • MS SharePoint
  • HP ALM/QC
  • HP Load Runner
  • Postman
  • Swagger
  • SoapUI
  • Tableau
  • MS Office Suite
  • AWS (Step Functions, Lambda, EC2, EventBridge, SQS)
  • Azure (Cassandra, Cosmos DB, Synapse Analytics)
  • Salesforce Marketing Cloud
  • Service-Oriented Architecture (SOA)
  • Microservices
  • SQL
  • AWS RDS DB
  • Microsoft Azure Cassandra
  • Informatica PowerCenter
  • AWS Glue

Timeline

Sr. Business Systems Analyst

BSASPEC, INC
11.2023 - Current

Sr. Business System Analyst

BSASPEC, INC
03.2021 - 10.2023

Technical Business Analyst / Scrum Master

BSASPEC, INC
06.2018 - 12.2020

Manual & API Tester

Pride Systems
06.2016 - 05.2018

Similar Profiles

CREATE PROFILE
Vuppalapati Raghu S