Business & Data Analyst with QA Testing

Vasamsetti Teja Krishna

***************@*****.*** 317-***-****

MS Computer Science – Purdue University 5+ Years Business & Data Analysis Experience

PROFESSIONAL SUMMARY

Results-driven Business Analyst with 5+ years of experience conducting complex analytical functions, documenting business rules and processes, and translating operational requirements into system-level solutions. Proven ability to develop and execute test plans, identify system defects and workarounds, coordinate with IT and business stakeholders, and maintain detailed documentation of findings. Experienced leading analytical work across financial services, healthcare, and higher education environments. Skilled at bridging the gap between technical teams and business users to ensure systems meet operational needs.

CORE COMPETENCIES

Business Process Analysis: Requirements gathering, process documentation, business rules analysis, gap identification

System Testing & QA: Test plan development, test script execution, defect tracking, UAT coordination, issue resolution

Documentation: Business requirements docs, process flows, findings reports, system change documentation

Stakeholder Coordination: IT/programming staff liaison, business team collaboration, cross-functional project support

Data & Reporting Tools: SQL (T-SQL, Databricks), Python, Power BI, Excel, Tableau, SSRS

Education: MS Computer Science, Purdue University (Dean's Scholarship)

PROFESSIONAL EXPERIENCE

Northern Trust Bank Jan 2025 – Present

Business/Data Analyst — Operations & Compliance

•Conduct complex analytical functions across marketing and actuarial operations, identifying system and process gaps and recommending solutions to IT and business leadership.

•Develop and maintain structured SQL queries and Power BI dashboards to analyze financial and operational datasets, ensuring system outputs meet defined business requirements.

•Collaborate directly with IT programming staff and business stakeholders to implement system changes, validate data accuracy, and resolve processing discrepancies.

•Document business rules, data definitions, and analytical findings in standardized reporting frameworks used for regulatory and leadership review.

•Identify data reconciliation issues between source systems and reporting layers; analyze root causes, recommend workarounds, and track resolution through to completion.

•Coordinate cross-functional initiatives requiring alignment between technical teams and business operations, ensuring system changes meet operational needs.

Optus May 2023 – Dec 2024

Business/Data Analyst — Healthcare Systems & Reporting

•Analyzed healthcare claims and operational datasets to assess system performance, identify processing anomalies, and support reporting requirements for program oversight.

•Developed and executed analytical scripts to test system outputs against defined business rules, documenting findings and recommending process improvements.

•Built interactive dashboards (Power BI, SSRS) tracking operational KPIs and quality metrics; validated outputs against source data to ensure accuracy and integrity.

•Supported ETL processes (AWS Glue, Athena) to identify and resolve data transformation issues, documenting workarounds and coordinating fixes with technical staff.

•Applied NLP and Python-based text analysis to process ~3,000 open-ended survey responses, translating unstructured data into structured findings and actionable business recommendations.

•Maintained detailed documentation of system issues, analytical findings, and resolution steps to support continuity and institutional knowledge.

Accenture (Client: BMS) Jan 2021 – Dec 2022

Business/Data Analyst — Financial Operations

•Conducted business process analysis across finance and operations teams, identifying inefficiencies and documenting requirements for system and process improvements.

•Built structured reporting templates and automated Excel dashboards to standardize outputs and reduce manual effort by 40%.

•Performed variance analysis and KPI tracking, identifying discrepancies between expected and actual system outputs and escalating findings to leadership.

•Supported new business initiatives by gathering requirements, analyzing operational data, and delivering findings in clear documentation for stakeholder review.

SELECTED PROJECTS

Healthcare Claims System Analysis & Performance Reporting

Tools: SQL, Python, Power BI, AWS Athena

•Analyzed 250K+ claims records to identify system-level drivers of processing anomalies; built SQL-based test queries to validate business rules and flag defects for IT resolution.

•Developed Power BI dashboard serving as primary reporting artifact for operational and compliance review committees.

Banking Operations Reporting & Data Validation Pipeline

Tools: SQL, Snowflake, Power BI, Excel

•Built end-to-end SQL pipeline to extract, validate, and aggregate 1M+ financial records; identified and documented data integrity issues between source and reporting systems.

•Reduced manual reporting effort by 35% through automation; documented business rules and transformation logic for IT handoff and ongoing maintenance.

EDUCATION

Master of Science, Computer Science Jan 2023 – Dec 2024

Purdue University Dean's Scholarship

Contact this candidate