Bharathi Veeraragavan
Carver,USA
Summary
A seasoned Test Lead and Business System Analyst at Tata Consultancy Services, I excel in transforming complex user requirements into actionable system specifications, ensuring seamless integration and functionality. My expertise in SQA methodologies, coupled with a strong ability to foster stakeholder collaboration, has significantly enhanced project outcomes. Proficient in SQL and Agile, my leadership has consistently delivered projects with improved efficiency and accuracy.
Overview
16
16
years of professional experience
1
1
Certification
Work History
Test Lead/Business system analyst
Tata Consultancy SERVICES
Minneapolis, USA
01.2021 - Current
- Company Overview: [Client-Ameriprise Financial] - Minneapolis, MN
- Worked as a Test Lead/Business system analyst on Key business metrics/Practice Reporting/Practice Management
- Key business metrics is the package business capabilities (PBC) which is integrated in multiple tools inside Ameriprise
- Agile methodology was used for this project
- Converting the user requirements to system requirements with technical details for the developers to understand and work effectively
- Writing system requirement and designing
- Creating JIRA stories and confluence documents
- Co-create solutions with stakeholders
- Preparing Test Plan and reviewing with the stakeholders
- Collaborate with development teams
- Monitor performance
- Business Process Transformation & Gap Analysis
- Understanding the existing business processes and services provided by organization
- Preparing Test Plan and reviewing with the stakeholders
- Test data preparation
- Coordinated with clients and prepared tests cases and ensured that all software applications were compatible with tests
- Testing the Power BI reports
- Analyzing the data coming from the source to the target system and making sure the power BI reports are accurate
- Participate ETL testing- validating source and target tables and corresponding reports
- Validating the reports generated against the ETL tables
- Testing front end and backend stories in Jira
- Preparing test data/data load for ETL testing using SQL queries
- Responsible for Test Strategy, Test plan, Test data, Test cases, onsite/offshore co-ordination, Defect tracking, following up and closing the defects
- Participate in Sprint planning and estimates the stories
- Review the test results with BA’s and show demo to all stakeholders
- Observed all test and identified defects in HP ALM and JIRA
- Webservice testing using postman
- Served as coordinator for all testing activities on the project
- Identifying the gaps in stories
- [Client-Ameriprise Financial] - Minneapolis, MN
Test Lead/Business system analyst
Tata Consultancy SERVICES
Minneapolis, USA
01.2019 - 01.2021
- Company Overview: [Client-Ameriprise Financial] - Minneapolis, MN
- Worked as a Test Lead/Business system analyst on Insurance eApplication Uplift and Legacy in Ameriprise Financial
- Insurance eApplication uplift project main goal is to uplift all non-mobile enabled tool to mobile enabled tool
- Agile methodology was used for this project
- Participate in UAT, End to End testing
- JIRA stories testing
- Preparing test data in Mainframe UI screens
- Preparing Test Plan and reviewing with the stakeholders
- Coordinated with clients and prepared tests cases and ensured that all software applications were compatible with tests
- Responsible for Test Strategy, Test plan, Test data, Test cases, onsite/offshore co-ordination, Defect tracking, following up and closing the defects
- Participate in Sprint planning and estimates the stories
- Review the test results with BA’s and show demo to all stakeholders
- Observed all test and identified defects in HP ALM and JIRA
- Webservice testing using postman
- Served as coordinator for all testing activities on the project
- Identifying the gaps in stories
- [Client-Ameriprise Financial] - Minneapolis, MN
Test Lead
Tata Consultancy SERVICES
Minneapolis, USA
01.2017 - 12.2018
- Company Overview: [Client-Ameriprise Financial] - Minneapolis, MN
- Worked as a Test Lead on Commission based Brokerage Uplift in Ameriprise Financial
- Commission based brokerage uplift project main goal is to uplift all non-mobile enabled tool to mobile enabled tool
- Agile methodology was used for this project
- Test data preparation
- Coordinated with clients and prepared tests cases and ensured that all software applications were compatible with tests
- Responsible for Test Strategy, Test plan, Test data, Test cases, onsite/offshore co-ordination, Defect tracking, following up and closing the defects
- Participate in Sprint planning and estimates the stories
- Review the test results with BA’s and show demo to all stakeholders
- Observed all test and identified defects in HP ALM and JIRA
- Webservice testing using postman
- Automated the flow in selenium for regression testing
- Served as coordinator for all testing activities on the project
- Identifying the gaps in stories
- [Client-Ameriprise Financial] - Minneapolis, MN
Business System Analyst
Tata Consultancy SERVICES
Minneapolis, USA
06.2016 - 01.2017
- Company Overview: [Client-Ameriprise Financial] - Minneapolis, MN
- Worked as a Business System Analyst on Third Party Retirement Tracking Account in Ameriprise Financial
- An Ameriprise Third Party Retirement Tracking Account is an account that is established on Ameriprise systems that allows the financial advisor a view into the client’s retirement assets held outside of Ameriprise
- Responsibilities: Converting the user requirements to system requirements
- Writing system requirement and designing
- Analyze business requirements and processes through document analysis, meetings, workshops, and workflow analysis
- API Testing
- Conduct 4+ levels of testing including functional, integration, regression, and user acceptance to verify the business needs are met
- Communicate business requirements by constructing easy-to-understand data and process models
- Provide input into developing and modifying systems to meet business needs and develop business specifications to support these modifications
- Liaise between business and technical personnel to ensure a mutual understanding of processes and applications
- [Client-Ameriprise Financial] - Minneapolis, MN
Senior Software QA Lead
Tata Consultancy SERVICES
Minneapolis, USA
05.2014 - 06.2016
- Company Overview: [Client-Ameriprise Financial] - Minneapolis, MN
- Worked as a Senior Software QA Lead on multiple projects within the Service Delivery & Operations organization in Ameriprise Financial
- Business Process Transformation & enhancement of the existing Money Movement platform for Brokerage & Managed Accounts to build a centralized & intuitive Payment Hub to support the Money Movement activities
- Agile methodology was used for this project
- Responsibilities: Business Process Transformation & Gap Analysis
- Understanding the existing business processes and services provided by organization
- Understanding of Payment Processing concepts including end-to-end life cycle of Checks, ACH & Paper Payments, Fed Wire etc
- In accordance with Industry standards
- Migration of manual business processes into a customized PEGA based BPM tool for automated service request management
- Developed and documented all test plans and specification for smooth integration into systems
- Coordinated with clients and prepared tests cases and ensured that all software applications were compatible with tests
- Participate in Sprint planning and estimates the stories
- Review the test results with BA’s and show demo to all stakeholders
- Responsible for Test Strategy, Test plan, Test data, Test cases, onsite/offshore co-ordination, Defect tracking, following up and closing the defects
- Observed all test and identified defects in HP ALM and JIRA
- Served as coordinator for all testing activities on the project
- Resolved all complex problems in programs and ensured that quality was maintained in facility
- Collected project information and submitted all reports to project manager
- Automated scripts using UFT
- Automation framework
- Identified defects in requirements which might have caused thousands of dollars’ loss
- [Client-Ameriprise Financial] - Minneapolis, MN
Lead QA Tester
Tata Consultancy SERVICES
Golden Valley, USA
01.2014 - 05.2014
- Company Overview: [Client- Allianz Insurance of North America] - Golden Valley, MN
- Worked as a Lead QA Tester
- Allianz Life Insurance Company of North America (Allianz) provides annuities, and life insurance policies in the United States
- Known for innovation, performance, and customer service, the company has become a leader in the North American life insurance industry
- Agent newly on boarded or if any new appointment/License is required, Allianz used to process through SIRCON
- We have tested all the process which was done by SIRCON with our new vendor NIPR (Nation Insurance Producer Registry)
- Waterfall methodology was used
- Responsibilities: Validating the web service calls using SOAP UI
- Writing SQL queries and checking the informatica ETL jobs
- Validating the source system and destination system
- Validating the jobs schedules
- Creating Test Plan, Test case and Test data
- Leading the team and managing offshore
- Coordinating with clients and Performing Test result review with business
- Preparing the daily execution status report
- Defect Logging, Reporting & Tracking using Test Management (HP ALM Quality Centre 11)
- Coordinating the defect triage call in resolving all defect related issues/concerns on a weekly basis
- Arrange weekly meetings with the stakeholders and sharing the metrics with the business
- Performing End to End testing
- Validating the downstream and upstream data flow without any issues
- Preparing Test Summary Report and Test Closure report
- [Client- Allianz Insurance of North America] - Golden Valley, MN
Lead QA Tester
Tata Consultancy SERVICES
Chennai, India
07.2010 - 12.2013
- Company Overview: [Client- Target corporation] - Chennai, Tamil Nadu, India
- Worked as a Lead QA Tester
- Worked as QA Lead in Migration Testing which involved migrating from Data Stage 7.5 to Data Stage 8.5
- All Target Data Stage application is migrated from DS7.5 to DS8.5
- Waterfall methodology was used
- Responsibilities: Analyze and understand testing requirements from business requirement document, technical requirement specs
- Analyze and review Datastage (ETL) mappings to understand the technical implementation of business rules
- Collaborated with back end and database testers
- Identified data streams and reviewed data models for testing strategies
- Conducted source to target data mapping
- Identified defects and errors in data prior to data processing
- Mitigated existing issues and provided solutions
- Design and document Data warehouse (EDW) testing strategy covering the test cases for validating the data completeness and correctness, system performances of the ETL processes etc
- Trained more than 10 people in learning ETL testing
- Wrote many SQL query to test the end-to-end testing
- Have minimal knowledge in crystal reporting and SSRS reporting
- Manage end to end testing work for the Corporate portfolio and lead the project team of 15 members to assign module/activity/tasks/deliverables
- Prepare test plan and work breakdown estimate
- Prepare the test cases for Summary/Detail testing, functional testing, regression testing, Stress, and End to End testing
- Construct test queries with multiple joins, indexes, temporary tables, analytical functions, and sub queries linking by unions, intersection, and minus operators etc
- Schedule and monitor the test cases execution
- Scheduling triage meetings to keep track and level of severity defects and communicating it Project Managers with Execution Score Card with defect Status
- Preparing Test Summary Report and Test Closure report
- [Client- Target corporation] - Chennai, Tamil Nadu, India
Web Developer/Tester
Tata Consultancy SERVICES
Chennai, India
03.2009 - 06.2010
- Company Overview: [Client- Target corporation] - Chennai, Tamil Nadu, India
- Worked as a Web Developer/Tester
- Promotional Signing applications is an upgrade to existing signing application for providing GUI access to building in-store promotion labels for different items based on the Promotional codes
- Iterative methodology was used
- Responsibilities: Designing and developing websites on Silverlight framework through iterative development methodology
- Providing purchase specifications regarding different hardware
- Designing and implementing user interface (UI)
- Devising and implementing user defined web services for web portals
- Testing websites for cross browser compatibility and fixing bugs and errors
- Consuming and Developing Windows Communication Foundation services (WCF)
- Creating WCF applications requiring Instance and concurrency management
- SQL Development, ability to write and troubleshoot SQL Code and design (stored procedures, functions, tables, views, indexes, constraints)
- Debugging code and performance tuning
- Testing the Web Services, Application
- Developing web parts using C#, Silverlight
- Source control tools such as Microsoft TFS
- [Client- Target corporation] - Chennai, Tamil Nadu, India
Education
Scrum Master Certified -
03.2018
Selenium-Java - Test NG
Trained in
01.2018
Foundation level certification -
International Software Testing Qualifications Board
01.2012
Application Development Foundation -
Microsoft .NET Framework
01.2010
Bachelor of Technology - Information Technology
Rajalakshmi Engineering college
Chennai, Tamil Nadu, India01.2008
Skills
- SQA Testing and Methodologies
- Test Plans, Cases, and Processes
- Translate the product vision
- Co-create solutions with stakeholders
- Excellent collaboration with stakeholders
- Collaborate with development teams
- Monitor performance
- Regression Testing
- Functional Testing
- Data Interface and Migration Testing
- End-User Testing
- DataStage/ETL Testing
- End to End Testing
- User Interface Testing
- Testing Strategies Development
- Data Preparation for Testing
- SQL
- API Testing
- Power BI
- Proficient in PEGA Tools
- Developer Tools
- Data Warehouse concepts
- JIRA
- HP ALM
- net
- DataStage
- ETL tools
- Rational Clear Quest
- Oracle
- Agile
- SoapUI
- REST
- C#
- VBScript
- HP-Unified Functional Testing
- Windows
- UNIX
- Microsoft Office
- Postman
Certification
- International Software Testing Qualifications Board- Foundation level certification, 2012
- Microsoft .NET Framework - Application Development Foundation, 2010
- Trained in Selenium-Java, 2018
- Scrum Master Certified, 03/11/18
Accomplishments
- Received Great Team Card Award from Target Corporation
- Received “Well Done” Card from Service Delivery head
- Received Appreciation Certification from Vice president for “Third Party Retirement Tracking System”
Timeline
Test Lead/Business system analyst
Tata Consultancy SERVICES
01.2021 - Current
Test Lead/Business system analyst
Tata Consultancy SERVICES
01.2019 - 01.2021
Test Lead
Tata Consultancy SERVICES
01.2017 - 12.2018
Business System Analyst
Tata Consultancy SERVICES
06.2016 - 01.2017
Senior Software QA Lead
Tata Consultancy SERVICES
05.2014 - 06.2016
Lead QA Tester
Tata Consultancy SERVICES
01.2014 - 05.2014
Lead QA Tester
Tata Consultancy SERVICES
07.2010 - 12.2013
Web Developer/Tester
Tata Consultancy SERVICES
03.2009 - 06.2010
Scrum Master Certified -
Selenium-Java - Test NG
Trained in
Foundation level certification -
International Software Testing Qualifications Board
Application Development Foundation -
Microsoft .NET Framework
Bachelor of Technology - Information Technology
Rajalakshmi Engineering college
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
Katelyn TheisKatelyn Theis
Club Care Paraprofessional at District 112Club Care Paraprofessional at District 112