Home

ruthvik - Sr. Business Analyst

[email protected]

Location: Ackerly, Texas, USA

Relocation: Yes

Visa: GC

Resume file: Ruthvik_Sr_Business_Analyst_12+_1786993548346.docx Please check the file(s) for viruses. Files are checked manually and then made available for download.

RUTHVIK REDDY Senior Business Analyst | Healthcare, Finance, Retail | Agile & Data-Driven Solutions Professional Summary: Results-driven Senior Business Analyst with 12+ years of experience leading requirements gathering, documentation, and solution delivery across Healthcare, Finance, Retail, and eCommerce domains. Adept at bridging business and technology teams, analyzing data with SQL, and supporting enterprise-scale projects involving digital banking, risk compliance, healthcare claims, and supply chain systems. Proven expertise in Agile and Waterfall methodologies, ensuring business goals are met with regulatory compliance, data integrity, and process efficiency. Experienced in conducting workshops, stakeholder interviews, and cross-team discussions to drive consensus, manage expectations, and ensure smooth adoption of business solutions. Strong track record in supporting projects from ideation through post-implementation, including requirements gathering, testing, training, and production support, ensuring minimal disruption to business operations. Skilled in SQL, data analysis, and business process re-engineering, enabling informed decision-making and performance improvement. Strong background supporting projects in digital banking, healthcare claims, risk & compliance, and supply chain management systems. Experienced in Agile, Scrum, and Waterfall methodologies, ensuring on-time, high-quality deliverables aligned with business and regulatory goals. Conducts stakeholder interviews, JAD sessions, and cross-functional workshops to elicit requirements, define scope, and manage stakeholder expectations. Adept at creating BRDs, FRDs, user stories, process flows, and data mapping documents to translate business needs into actionable technical requirements. Collaborated closely with product owners, QA teams, and developers to ensure solution accuracy, traceability, and alignment with business objectives. Hands-on experience in UAT coordination, training, and post-implementation support, ensuring smooth system adoption and minimal business disruption. Skilled in using tools like JIRA, Confluence, MS Visio, Excel, Power BI, and Tableau for documentation, workflow visualization, and performance reporting. Demonstrated success in identifying process optimization opportunities, reducing turnaround time, and improving operational efficiency. Strong communicator with a reputation for driving consensus, managing complex stakeholder environments, and ensuring seamless project execution. Technical Skills: Business Analysis & Methodologies: Requirements Gathering, BRD/FRD, User Stories, Use Cases, Process Flows, GAP Analysis, UAT, Traceability Matrix, Agile (Scrum, SAFe), Waterfall, SDLC Data & Databases: SQL (Oracle, SQL Server, Snowflake), Python, R, Data Warehousing, ETL Testing & Validation, Data Mapping, Data Governance, Master Data Management (MDM), Reporting & Analytics Tools & Platforms: JIRA, Confluence, Rally, ServiceNow, MS Visio, Lucidchart, MS Office Suite (Excel Pivot, VLOOKUP, Macros), Power BI, Tableau, SharePoint Documentation & Collaboration: Business Process Documentation, Functional Specifications, Standard Operating Procedures (SOP), Test Cases, Traceability Matrix, User Guides, Workshop Facilitation, Stakeholder Management Testing & Quality Assurance: UAT Coordination, Test Planning, Test Case Design, SIT Support, Defect Triage, Data Validation using SQL Professional Experience: Humana, Louisville, KY. Oct 2022 to present Senior Business Analyst Project Description: Worked on healthcare data integration and analytics projects to improve claims processing, patient engagement, and care management. Partnered with payer and provider stakeholders to modernize legacy systems, ensure compliance with HIPAA/CMS regulations, and deliver business value through data-driven insights and reporting. Responsibilities: Partnered with business leaders to define requirements for healthcare data integration and analytics projects, supporting claims processing, care management, and patient engagement initiatives. Led end-to-end JAD sessions with healthcare payor SMEs (claims, enrollment, benefits, provider data) to gather and refine business and system requirements. Conducted stakeholder workshops to translate complex healthcare needs into actionable requirements, driving the development of payer-provider solutions. Participated in business process reengineering initiatives to streamline healthcare claims and provider data workflows, reducing manual processing and improving turnaround time. Built and maintained advanced Excel models (pivot tables, lookups, data validation) to support claims analysis, reporting accuracy, and operational tracking. Authored BRDs, user stories, and functional documentation in JIRA/Confluence, ensuring traceability throughout the development lifecycle. Performed SQL-based validation and ETL testing for healthcare data pipelines, improving accuracy of patient claims and provider data in enterprise data warehouse. Ensured solutions complied with HIPAA and CMS regulations, protecting patient privacy and enabling audit readiness. Worked closely with developers, testers, and SMEs in Agile sprints to deliver incremental releases, ensuring value delivery matched business priorities. Supported SIT testing by validating system behavior, identifying defects, and ensuring alignment with defined business rules across payer system. Managed backlog items, user stories, and sprint tracking using Azure DevOps, ensuring traceability from requirements through testing and release. Used SharePoint to manage requirements documentation, UAT artifacts, project deliverables, and cross-team collaboration. Coordinated UAT with healthcare operations teams, preparing detailed scenarios that reflected real-world business cases and ensuring flawless go-live transitions. Delivered executive-level dashboards and KPIs that provided visibility into claims accuracy, patient outcomes, and operational efficiency. Environment: JIRA, Confluence, SQL Server, Snowflake, Data Warehouse, ETL pipelines, Tableau, HIPAA, CMS regulations, Agile Scrum, Healthcare Data (Claims, EHR, Provider, Member). Goldman Sachs, New York, NY. Nov 2019 to Aug 2022 Senior Business Analyst Risk & Regulatory Reporting Project Description: Contributed to the design and delivery of risk and regulatory reporting platforms to ensure compliance with Basel III and CCAR mandates. Collaborated with compliance, audit, and technology teams to improve transparency in trade reporting, automate workflows, and enhance data accuracy for global regulatory submissions. Responsibilities: Led requirements gathering for risk and regulatory reporting platforms (Basel III, CCAR), enabling compliance with global banking regulations. Collaborated with compliance, audit, and risk management teams to document detailed functional requirements and system workflows for enterprise-wide reporting. Partnered with data architects to design data models and mapping documents, ensuring transparency and traceability from source systems to reporting layers. Conducted SQL-based data reconciliation and root cause analysis for trade mismatches, preventing compliance breaches and regulatory penalties. Supported Agile delivery through scrum ceremonies (standups, sprint reviews, backlog grooming), ensuring stakeholders remained aligned with delivery timelines. Used advanced Excel for reconciliation analysis, variance reporting, and validation of regulatory datasets. Delivered interactive dashboards and compliance KPIs in Power BI/Tableau to give senior leadership real-time insights into regulatory posture. Oversaw UAT execution across multiple teams, tracking and resolving defects to guarantee readiness for regulatory deadlines. Coordinated backlog refinement sessions and sprint planning activities using Azure DevOps dashboards. Maintained project documentation, governance artifacts, and audit evidence in SharePoint, ensuring traceability and compliance. Ensured all deliverables adhered to enterprise data governance, audit trails, and information security policies, protecting organizational and client interests. Environment: JIRA, Confluence, SQL (Oracle, SQL Server), Power BI, Tableau, Data Governance, Regulatory Reporting (Basel III, CCAR), Agile Scrum, Risk & Compliance, Investment Banking Domain. JPMorgan Chase, New York, NY. June 2016 to Oct 2019 Senior Business Analyst Project Description: Played a key role in digital banking and payments transformation initiatives, modernizing customer onboarding, payment processing, and transaction monitoring systems. Focused on gathering requirements, performing GAP analysis, and ensuring systems complied with SOX and OCC regulations while improving customer experience. Responsibilities: Led requirement gathering for digital banking transformation initiatives, ensuring alignment with customer experience goals while meeting security and compliance standards. Created epics, user stories, and acceptance criteria in JIRA to facilitate Agile delivery of payments and customer onboarding systems. Conducted requirement workshops and GAP analysis with compliance, operations, and IT teams to identify process inefficiencies and propose system enhancements. Wrote and executed complex SQL queries to validate data consistency across payment processing and account management systems, directly reducing financial reconciliation errors. Supported the implementation of regulatory compliance measures (SOX, OCC), ensuring systems adhered to mandated reporting and auditing standards. Designed process models, system interaction diagrams, and workflow documentation to communicate business logic to development and testing teams. Tracked user stories, defects, and release progress using Azure DevOps boards. Managed requirements, workflows, and testing documentation using SharePoint, enabling transparency across distributed teams. Facilitated UAT execution with business users, logging and tracking issues through defect triage meetings until resolution. Played a key role in system migration activities, conducting impact assessments and ensuring continuity of core banking operations post-cutover. Environment: JIRA, Rally, MS Visio, SQL (Oracle, SQL Server), Data Warehousing, SOX Compliance, OCC Regulatory Standards, Agile (Scrum/SAFe), Core Banking, Payments Domain. Target, Minneapolis, MN. Oct 2013 May 2016 Business Analyst Project Description: Worked on retail supply chain and inventory management systems, integrating vendor systems with Target s ERP to improve order fulfillment, inventory visibility, and in-store operations. Supported BI initiatives by ensuring accurate reporting and analytics for inventory and sales trends. Responsibilities Partnered with supply chain managers and IT teams to define requirements for inventory management and vendor integration systems, which improved product availability and reduced stock-outs across retail stores. Created detailed process flows, mockups, and wireframes that aligned business expectations with technical implementation, reducing rework and miscommunication. Drafted BRDs, user stories, and SOPs to standardize requirements in Agile sprints, enabling clear visibility for developers and testers. Conducted data mapping and SQL validation between point-of-sale systems and the enterprise data warehouse, ensuring accuracy of inventory and sales reporting. Used Excel (pivot tables, VLOOKUPs, reporting templates) to analyze inventory, sales trends, and vendor performance. Supported QA efforts by defining comprehensive UAT scenarios and establishing a traceability matrix, guaranteeing that requirements were validated before release. Coordinated with third-party vendors to resolve system integration issues, ensuring seamless synchronization between supplier systems and Target s ERP. Assisted BI teams in designing data-driven dashboards and reports in Excel/Power BI, giving business users real-time insights into product performance and vendor efficiency. Ensured compliance with SOX and internal retail governance standards, reducing operational and audit risks in supply chain operations. Environment: MS Visio, JIRA, SQL Server, Data Warehouse, Excel (Pivot, VLOOKUP), Power BI, Vendor Integration, Supply Chain Systems, Retail Domain, Agile & Waterfall. Amazon, Hyderabad, India. Aug 2012 - Sep 2013 Business Systems Analyst Project Description: Supported the enhancement of order management systems within Amazon s rapidly scaling eCommerce platform. Focused on documenting business requirements, validating backend data, and coordinating with offshore development teams to ensure seamless order processing and customer satisfaction. Responsibilities Collaborated with business stakeholders to analyze eCommerce order management workflows, documenting BRDs/FRDs that ensured scalability to support Amazon s growing customer base. Developed use cases, workflow diagrams, and functional specifications to bridge gaps between business requirements and system capabilities, directly improving order fulfillment accuracy. Participated in Agile ceremonies (backlog grooming, sprint planning, retrospectives) to refine requirements into actionable user stories and acceptance criteria, ensuring smooth development cycles. Performed SQL-based backend data validation to confirm accuracy of order, shipment, and inventory transactions, helping reduce reconciliation issues during integration testing. Coordinated daily with offshore developers, clarifying requirements and ensuring timely delivery of enhancements for critical order processing functions. Supported the QA team by preparing test cases, traceability matrices, and UAT scripts, ensuring end-to-end coverage of all business scenarios. Participated in defect triage meetings to prioritize issues based on business impact, minimizing production disruptions. Authored user training documentation and supported knowledge transfer sessions, enabling smooth adoption of new features across operations teams. Environment: Agile Scrum, BRD/FRD Documentation, SQL Server, Oracle DB, Confluence, JIRA, MS Visio, eCommerce Domain, Order Management Systems, Testing Support (UAT, SIT). Keywords: quality analyst business intelligence database rlang information technology golang microsoft mississippi Kentucky Minnesota New York