G V Saicharan
Bangalore
Summary
Accurate Quality Assurance Specialist with 7+ years of experience in Health/banking/Transport/Parma/E-Commerce QA. Sound decision-making and performance analysis talents. Collaborates with groups or work independently with minimal supervision. Proficient in ETL,BI & SQL Testing methodology. Adept at training new hires and retraining employees and managing the accuracy of all products.
Overview
10
10
years of professional experience
Work History
Senior QA Consultant
Artech Private Limited
BENGALURU
05.2023 - Current
- Client – Conduent Business Services India LLP Project - US Government Health Care - Data Migration (New Jersey Health Care Analytics)
- Developed and documented test plans, test cases and test scripts for functional, regression, integration, system and user acceptance testing.
- Performed database validations by writing SQL queries to validate data integrity in back-end tables.
- Analyzed business requirements documents, technical specifications and use cases to develop detailed test scenarios.
- Monitored bug tracking systems and provided feedback on issues reported by users.
- Identified potential risks associated with software development projects.
- Provided guidance to junior QA personnel regarding processes and procedures related to quality assurance activities.
- Reported project status updates regularly at various meetings with stakeholders.
- Collaborated with developers during the design phase of new products in order to provide input on usability issues before coding begins.
- Organized weekly review sessions with stakeholders from all departments involved in the QA process.
- Participated in customer reviews as a representative of the Quality Assurance team.
- Documented results of tests performed including screenshots for reference purposes.
- Developed reports summarizing quality metrics such as defect density, pass and fail rates., which were used by management for decision making purposes.
- Monitored QA procedures for adherence by employees, notifying personnel of non-compliance issues.
- Prepared reports to communicate results of quality inspection activities to management.
- Analyzed quality assurance data to identify trends and develop and implement corrective action plans.
- Collaborated with management to discuss effective plans for resolving major quality problems.
Senior Test Engineer
HiLabs Private Limited
BENGALURU
03.2023 - 04.2023
- Project – Provider Data For Insurance
- Developed and maintained test plans, strategies, procedures, and scripts for manual and automated tests.
- Performed functional, system, integration, regression, load and performance testing of software applications.
- Analyzed requirements documents to ensure proper coverage of testing activities.
- Identified root causes of defects found during software testing cycles.
Senior Test Engineer
GermanTown Technology Private Limited
BENGALURU
09.2022 - 03.2023
- Projects – Imagine Pediatrics & Evergreen Nephrology
- Created detailed documentation of all findings from ETL application tests performed.
- Provided technical support to users during UAT phase of development life cycle.
- Monitored daily production job runs to ensure successful completion without errors or exceptions.
- Developed test plans and scripts to validate ETL jobs.
- Performed data analysis and validation on source and target data sets for accuracy of transformation rules in ETL processes.
- Conducted unit, integration, system, regression, and performance testing for ETL applications.
- Identified discrepancies between source and target systems during ETL process testing cycles.
- Ensured that the ETL process is running as expected by troubleshooting any issues encountered during the testing cycle.
- Collaborated with developers in resolving issues identified during testing phases of projects.
- Documented results from various types of tests conducted on the ETL environment including system integration tests, user acceptance tests.
Technical Lead – ETL Tester - DB Tester
CitiusTech Healthcare Technology Private Limited
03.2022 - 09.2022
- Client – Own Product
- Developed and maintained technical documentation for software systems.
- Identified opportunities to improve system performance, scalability, and reliability.
- Created detailed project plans with timelines, deliverables, and resources needed.
- Provided technical guidance on development projects as well as implementation of new technologies.
- Assisted in the design and development of application architecture components.
- Trained technical personnel according to company and industry standards.
- Troubleshot and resolved problems with programs and systems.
- Developed test plans and strategies for ETL testing processes.
- Identified issues related to ETL process and provided recommendations for improvement.
- Analyzed requirements documents to determine the scope of testing activities.
- Developed detailed test cases based on functional and non-functional requirements.
- Documented all defects found during testing phases and tracked them until closure.
- Worked with business users to ensure that their expectations are met through successful implementation of projects.
- Reviewed test reports prepared by team members and ensured that they meet quality standards set forth by the organization.
- Worked with Agile and Scrum methodologies to accomplish project milestones and meet demanding timelines.
Senior Test Engineer - ETL Tester
Nous Info System
BENGALURU
11.2021 - 03.2022
- Client – LyondellBasell
- Created detailed documentation of all findings from ETL application tests performed.
- Provided technical support to users during UAT phase of development life cycle.
- Developed test plans and scripts to validate ETL jobs.
- Performed data analysis and validation on source and target data sets for accuracy of transformation rules in ETL processes.
- Conducted unit, integration, system, regression, and performance testing for ETL applications.
- Identified discrepancies between source and target systems during ETL process testing cycles.
- Ensured that the ETL process is running as expected by troubleshooting any issues encountered during the testing cycle.
Test Analyst
Threpsi Solutions Private Limited – PharmEasy
BENGALURU
02.2021 - 10.2021
- Client – Own Product
- Developed test plans, strategies and scope to ensure quality objectives were met.
- Created detailed test cases and scripts based on business requirements.
- Performed functional, system, regression and acceptance testing.
- Identified software defects and reported them in bug tracking systems.
- Analyzed results from various types of tests to determine the efficacy of the product under test.
- Created detailed documentation of all findings from ETL application tests performed.
- Ensured that the ETL process is running as expected by troubleshooting any issues encountered during the testing cycle.
- Collaborated with developers in resolving issues identified during testing phases of projects.
ETL Analyst
Ani Technologies Pvt Lmt -OLA CABS
BENGALURU
07.2019 - 01.2021
- Client – Own Product
- Created detailed documentation of all findings from ETL application tests performed.
- Monitored daily production job runs to ensure successful completion without errors or exceptions.
- Developed test plans and scripts to validate ETL jobs.
- Performed data analysis and validation on source and target data sets for accuracy of transformation rules in ETL processes.
- Conducted unit, integration, system, regression, and performance testing for ETL applications.
- Identified discrepancies between source and target systems during ETL process testing cycles.
- Ensured that the ETL process is running as expected by troubleshooting any issues encountered during the testing cycle.
Senior Software Engineer – Test Engineer
Capgemini
BENGALURU
05.2014 - 04.2017
- Client – Royal Bank of Canada
- Created detailed documentation of all findings from ETL application tests performed.
- Provided technical support to users during UAT phase of development life cycle.
- Monitored daily production job runs to ensure successful completion without errors or exceptions.
- Developed test plans and scripts to validate ETL jobs.
- Performed data analysis and validation on source and target data sets for accuracy of transformation rules in ETL processes.
- Ensured that the ETL process is running as expected by troubleshooting any issues encountered during the testing cycle.
Education
PG Diploma - Data Sceince
Manipal Academy of Higher Education
Bangalore01.2018
B. Tech - E.C.E
Intell Engineering College
Ananthapur01.2013
IPE - MPC
IPE Board-Sri Chaitanya Jr College
Hyderabad01.2009
SSC - SSC
SSC Board-Montessori High School
Kurnool01.2007
Skills
- ETL Templates Maintenance
- ETL Processes
- ETL Testing
- DB Testing
- SQL Testing
- BI Testing
- Manual Testing
- Test Planning
- Test Review
- Test Script Execution
- Test Design
- Test Strategies
- Data Warehouse
- Data Analysis
- Data Validation
- Database Design Validation
- Product Testing
- Troubleshooting
- STLC Lifecycle
- Defect Lifecycle
- Agile Methodology
- Agile Testing
- Data Quality Engineer
- Data Warehouse Testing
- User Acceptance Testing
- Correction Action Planning
- Documentation and Reporting
- Team Collaboration
- Performance Monitoring
- Problem-Solving Skills
- Collaboration Skills
- Test Results Analysis
- Test Cases
- Defect Tracking
- Warehouse Operations
- Technical Documentation
- Project Management
- Analytical Thinking
- Standards Interpretation
Technical Skills
- ETL Tools : SSIS, Informatica, HEVO,Azure Data Factory - ADF
- Operating System : Unix, Windows
- Databases : Oracle, SQL Server, AWS
- SQL Tools : SSMS, DBeaver-AWS Redshift, Snowflake
- BI Tools : Tableau, Power BI
- Test Management Tool : JIRA,Azure DevOps (ADO)
- Languages : SQL
Declaration
I hereby declare that the details and information given above are complete and true to the best of my knowledge
Place – Bangalore Signature
Date – NA G V Saicharan
Timeline
Senior QA Consultant
Artech Private Limited
05.2023 - Current
Senior Test Engineer
HiLabs Private Limited
03.2023 - 04.2023
Senior Test Engineer
GermanTown Technology Private Limited
09.2022 - 03.2023
Technical Lead – ETL Tester - DB Tester
CitiusTech Healthcare Technology Private Limited
03.2022 - 09.2022
Senior Test Engineer - ETL Tester
Nous Info System
11.2021 - 03.2022
Test Analyst
Threpsi Solutions Private Limited – PharmEasy
02.2021 - 10.2021
ETL Analyst
Ani Technologies Pvt Lmt -OLA CABS
07.2019 - 01.2021
Senior Software Engineer – Test Engineer
Capgemini
05.2014 - 04.2017
PG Diploma - Data Sceince
Manipal Academy of Higher Education
B. Tech - E.C.E
Intell Engineering College
IPE - MPC
IPE Board-Sri Chaitanya Jr College
SSC - SSC
SSC Board-Montessori High School