Uploaded File
add photo
Balaji
vtbala36@gmail.com
904-487-9830
Jacksonville, FL 32290
Sr. QA Analyst
17 years experience W2
0
Recommendations
Average rating
174
Profile views
Summary

  • Organized, detail oriented, results-driven, and highly motivated IT professional offering more than 13 years of experience in project management, technical operations, quality assurance, software management, and project delivery. Served in different roles as a Test Manager , Project/Test Coordinator ,Test Lead and System Analyst acquiring vast experience/knowledge in Agile/Scrum, V-Model and waterfall frameworks through various software development, project and testing life cycles.
  • QA work experience on Functional, Product (SAP ECC 6.0,Siebel and ODI), ETL and BI Testing on various domain such as Health care, Banking, Insurance and Telecom.
  • Managed the large testing team and worked on Test Plan, Test design/SQL Scripts, Test review, test estimation, maintained traceability between requirement and test design/evidence, update and discuss test status with project stakeholders including issues, risk and mitigation plan.
  • Performed ETL Testing by generating complex SQL queries to validate data between source data target such as EDW (Enterprise Data warehouse) and validated data against BI reports.
  • As a ETL QA worked on Informatica, ODI and BODI ETL tools to run and monitor job workflow in test environment and as a BI QA worked on Reporting tool such as OBIEE, Cognos, BO, Hyperion and SAP BI.
  • Good experience on SDLC (Waterfall, Agile and V-Model), STLC, SQA Process in Data warehouse projects and Methodologies such as BlackBox
  • Strong script writing experience on SQL, PL/SQL.
  • Validated the data based on data transformation rules and also processed data sourced from Flat files and relational databases such as SQL Server, Oracle 10g.
  • Good experience on Data Warehouse concepts and its different components.
  • Performed SAP MM testing based on client requirement and knowledge on SAP TM9.0.
  • Collaborated with SME’s, Data Modeler and DBA team frequently on scope of optimization and on continuous improvement of the Test process to ensure quality of data.
  • Worked on QTP and LoadRunner Automation tool as a shadow tester.
  • Supported Automation Testing COE team by providing SQL scripts to perform regression testing and also reviewed manual test scripts and SQL scripts.
  • Worked various testing on Manual Web Application testing, Product testing, Functional, Regression and Integration testing
  • Experienced in software test management tools like HP ALM Mercury Quality Center 11.52.
  • Monitored team across all phases of assigned testing projects.
  • Worked along with Quality Assurance Pre-Sales team to provide necessary information on DWBI.

Certifications:

ISTQBSoftware Testing Certified

ISO/CMMI Internal Audit Trained

TECHNICAL SKILLS

Testing

Functional, ETL/BI Testing, SAP Testing

ETL Tools

Informatica 9.5, ODI and BODI

BPM/BI Tools

OBIEE, Hyperion, BO, Cognos and SAP BI.

ERP

Languages

SAP ECC6.0, BI and TM 8.0.

C,C++,Java, VB,XML, VBScripting

RDBMS

Oracle 10/11g, MS SQL Server 2008, TOAD, SQL.

Operating Systems

Windows and UNIX

Testing Tools

Tivoli,QTP,LoadRunner, Sharepoint

Test Management Tool

HP ALM QC 11.52,JIRA, Microsoft Project suite, TFS

SDLC, STLC

Agile/Scrum,Waterfall,V-Model

Experience
Project Lead - QA
Healthcare
Sep 2014 - present

Responsibilities:

  • Understand and analyze the requirements to identify the testable requirements.
  • Prioritize the requirements based on the time required. Create the traceability matrix. Create requirement query tracker (or clarification document) to track any clarification.
  • Identify gaps in the requirements and take actions to close the same. Create ambiguity document (or clarification document) to track any clarification.
  • Review test data, screen flow documents etc Evaluate and identify various tools to aid test execution based on the understanding of the requirement.
  • Create the test strategy (that includes release date, type of testing, scope of the project, detail explanation of particular release, risk, critical defects) for small and medium projects.
  • Seek review from the onsite team and seek sign off from the client on the same. Create/Review test plans (covering scope, risk, responsibility, timelines, resource (Man /Machine), deployment, exit/entry criteria etc).
  • Seek review inputs from different stakeholders (Business Sponsors, Development Leads, Business Analyst, and Project Managers).
  • Communicate testing phase timelines to the team and seek approval from the Project Manager.
  • Identify & create Test data required for the testing activity. Review the test scenarios and seek review as required. Review the test cases and traceability matrix to ensure total coverage of requirements.
  • Review the test results and clarify doubts/query raised by team during execution.
  • Track the root cause of the review comments and take actions to resolve them. Support the team/ client in conducting UAT/BUT if applicable.
  • Review the daily deliverables and share it with the stakeholders appropriately. Create and share weekly status reports and daily status reports with the team/ relevant stakeholders.
  • Have performed testing on Medical claims, Enrollment and Pharmacy source data against Oracle Data base.
  • Facilitate calls between onsite and offshore teams to discuss the project status.
  • Coordinate with the release manager to keep abreast with the various activities in the test environment (eg build schedule) and to ensure the right components move to the production.
  • Review all deliverables to ensure Test process protocols/ internal quality processes are meticulously followed in project. Take appropriate actions on NCs/Obs reported (if any)
  • Follow-up with the team to ensure that all metrics have been recorded correctly and at the right frequency for the audits conducted internally. Identify deviations and alert Test Manager on risks. Report reasons for deviations.
  • Provide periodic update on the metrics to the client via Daily Status Reports/Weekly Status Reports/Monthly Status Reports.

Environment: Oracle10 g, SQL, QA, TOAD, SharePoint, TFS, MS Project Plan, HP ALM QC

SQL Test Case Preparation Test Planning UAT Quality Assurance HP ALM TOAD MS SharePoint Project Management Oracle MS Project MS TFS Business Analysis Auditing HP QC NCS
Remove Skill
Test Manager
Healthcare
Nov 2013 - May 2014

Responsibilities:

  • Have good experience on project delivery and management and Responsible for people Management, staffing, performance management, and development /coaching of team member
  • Managed customer Satisfaction, resource utilization, project profitability and quality and Process management. Provided direction for a project team in all the project phases.
  • Closely monitors of critical aspects of project critical paths and Good understanding of the domain to suggest alternatives to customers
  • Review the requirements documents to ensure alignment in terms of signed off scope.
  • Reach out to client stakeholders and document the KT plan including the artefacts, applications to be captured, milestones and process to be followed.
  • Guide the team to identify the critical requirements / defect etc Seek clarifications on requirements.
  • Create / review the test strategy (that includes release date, type of testing, scope of the project, defects delivered, detail explanation of particular release, risk dependencies, critical defects, scheduling, volume of test data, exit and entry criteria, team structure roles and responsibility) as required.
  • Create and review test plans. Seek review and signoff from internal and external stakeholders as required.
  • Clarify any major issues with the client and guide team to implement mitigation plans.
  • Set up defect triage meetings. Create solutions based on understanding of the industry pain points and review of different research sources.
  • Design recommendation based on the analysis of the test summary report. Review daily/weekly metrics on schedule as prepared by the test lead.
  • Create test closure reports and seek signoff from relevant stakeholders.
  • Document the lessons learnt and the best practices adopted for the next project.
  • Perform gap analysis in order to deliver outputs as per the expected standards.
  • Conduct weekly review with Test Lead. Identify mitigation strategies including escalating the issues to the relevant stakeholder to ensure resolution.
  • Performed and ensured all ETL Test deliverables works as per Business and End user need.
  • At the end of the project, review the entire project and identify areas of strength and improvement.
  • Conduct and Participate in audit at various stages, as required. Review NCs and observations and monitor till closure.
  • Participate in status calls weekly/ monthly with internal / external stakeholders to review status, highlight issues, derive action points.
  • Coordinate meetings to go over Defect Prevention / Leakage retrospection between the customer and execution team. Review Defect prevention plan and implementation status at defined intervals. Review the root cause analysis to identify reasons leading to defect leakage.

Environment: SQL, QA, HP ALM QA, XML, MS Project Plan, SharePoint, Oracle 10G and Informatica

SQL MS Project Performance Management Quality Assurance Auditing HP ALM MS SharePoint Oracle Informatica Gap Analysis ETL Delivery Management Project Management Stakeholder Engagement Project Planning
Remove Skill
Lead ETL Test Engineer
Information Technology
Aug 2012 - Sep 2013

Responsibilities:

  • Prepared test cases based on DWBI Physical Solution Design documents and ETL Specification documents.
  • Performed analysis on ETL workflow developed, Validation of data transformation and Perform E2E Validation on ETL and BI systems.
  • Involved in writing Test plan, Test cases and responsible for executing the Test Scripts using Quality Center.
  • Have good experience on SQL and write complex SQL queries for validating business rule using Oracle.
  • Run and monitor ETL jobs using Informatica workflow Monitor.
  • Responsible for designing, developing test plans, use cases and executing test scripts.
  • Performed Smoke, Integration, functional and Regression testing.
  • Have a periodic discussion with Business team and Technical team on ETL requirement to meet business expectation.
  • Worked closely with developers and Business Analysts to understand the requirements and confirm the defects. Tracked defects using HP Quality Center and generated the bug reports at the end of the testing cycle.
  • Maintained test traceability such as Test plan, Test Design, Test evidence and Defects in HP ALM / HP QC.
  • Involved in validating data from multiple stages of data by generating complex SQL queries wherever is required.
  • Performed Manual functional, System integration testing, Regression and UAT testing.
  • Have periodic discussion with project stakeholders on issues,risk and mitigation plan to arrive solution.
  • Performed regression testing as and when changes made based on Change Request (CR).
  • Have good experience on Problem solving and Debugging, Client facing, Presenting the deliverables with Project Stake holders.

Environment: Oracle 10g, Informatica, OBIEE, Windows XP, SQL, TOAD and HP QC.

SQL Test Case Preparation Test Planning UAT Integration Testing Regression Testing TOAD ETL REST HP QC HP ALM Business Analysis Informatica OBIEE Oracle Database Design Windows
Remove Skill
Sr. QA Analyst
Telecommunications
Aug 2010 - Jul 2012

Responsibilities:
• Prepared test cases based on DWBI Physical Solution Design documents and ETL Specification documents.
• Performed analysis on ETL workflow developed, Validation of data transformation and Perform E2E Validation on ETL and BI systems.
• Involved in writing Test plan, Test cases and responsible for executing the Test Scripts using Quality Center.
• Have good experience on SQL and write complex SQL queries for validating business rule using Oracle.
• Managed testing activities like ETL Testing, BI Testing according to the testing schedules and scope.
• Involved in full STLC, coordination with onshore team, Reporting updates to management on Testing status, Test metrics and Defect Metrics making test Strategy/plan.
• Led a testing team of 20 members that were divided between 10 tracks i.e. ETL and BI Report Testing.
• Performed ETL integration testing using TOAD tool.
• Performed BI Testing using reporting tool OBIEE.
• Analyzed Requirement documents, Design documents and Business Rules.
• Aligned and tested each build based on MS TFS updates
• Performed regression testing on existing QTP Automation framework as a shadow tester
• Participated in hiring test professionals for own internal testing team as well as global testing Team.

Environment: Oracle 10g, Informatica, OBIEE, J2EE, TFS Windows XP, SQL, TOAD and JIRA.

SQL Test Case Preparation Test Planning Integration Testing Regression Testing SDLC HP QC Quality Assurance JIRA HP QTP J2EE Informatica MS TFS OBIEE TOAD Analysis Oracle ETL Testing STLC
Remove Skill
Consultant - Testing
Information Technology
Apr 2010 - Aug 2010

Responsibilities:

  • Managed and performed testing activities like ETL and BI Testing to the testing based on mapping document.
  • Responsible for developing strategic testing plans to achieve performance quality by coordinating with the project manager.
  • Handled the tasks of reviewing testing documentation to ensure that it meets the software development and testing standards.
  • Performed responsibilities of evaluating defect metrics data and updated the finding report to the management.
  • Responsible for examining the level of testing process to ensure product quality.
  • Handled the tasks of providing recommendations to improve testing process for supporting quality assurance initiatives.
  • Escalated unresolved problems to senior staff and provided guidance to less experienced testers.
  • Performed SAP Functional Business scenario data validation on SAP ECC modules such as MM, SD
  • Performed ETL data validation using TOAD tool.
  • Performed BI Testing using reporting tool OBIEE against SAP BI.7.0 reports.
  • Validated the OBIEE reports for its data accuracy and functionally, validated them with the SAP BW reports.
  • Validated OBIEE reports based on test scenario which was provided by client using Oracle BI Dashboard and Answers.
  • Validated fields and its values present in the reports are same as in SAP BW standard reports.
  • Validated reports using Drill-down and filter features.

Environment: SAP ECC 6.0, Oracle 10g, ODI, OBIEE, Windows XP, SQL, TOAD and HP QC.

SQL UAT HP QC Quality Assurance SAP BI SAP Windows XP SAP ECC Project Management Oracle OBIEE Documentation Data Validation SAP Functional SAP BW TOAD
Remove Skill
Test Lead
Information Technology
Nov 2009 - Mar 2010

SCM Release 4 - The scope of this project was to provide implementation services to Verizon to migrate the reporting functionality in the existing SAP BW reports (99 Release 4 reports) into OBIEE (Oracle Business Intelligence Reporting tool). The content of the SAP BW reports considered for the scope is from SAP R/3 versions ECC 6.0 and SAP BW version 3.5. The OBIEE reports would be developed on top of the OBIA (Oracle Business Intelligence Application) covering the Supply Chain and Order Management Analytics and Procurement and Spend Analytics modules) Responsibilities:
• Analyzed the Technical Requirements Document and Technical Requirement Specifications.
• Understood different transform logic/business rules according to requirement.
• Designed and developed Test cases as per the requirements and Mapping document.
• Performed ETL data validation using SQL Developer tool.
• Performed backend testing on Oracle 10g.
• Performed BI Testing using reporting tool OBIEE against BAP BI reports.
• Validated OBIEE reports based on test scenario which was provided by client using Oracle BI Answers.
• Validated fields and its values present in the reports are same as in SAP R/3 standard reports.
• Performed SAP testing on functional scenario for SAP MM, SD and FICO modules as customized by functional consultant to ensure test data matches against BI reports.
• Validated OBIEE ad-hoc reports against SAP MM, SD and FICO data.
• Validated reports using Drill-down and filter features.

Environment: SAP ECC 6.0, Oracle 10g, OBIEE, Windows XP and HP QC.

SQL Test Case Preparation HP QC Backend Testing SAP MM SAP ECC Windows
Remove Skill
Lead Integration Tester (ODI-SAP)
Oct 2009 - Nov 2009
No skills were added
Remove Skill
Jul 2007 - Oct 2009
The main purpose of this project is to enhance the ODI - Oracle Data Integrator to support SAP R/3 and SAP BW data extraction. To enable ODI to support SAP ERP and BW/BI data extraction ODI Knowledge Modules were implemented. Responsibilities:
• Understood the Test Environment and Project Requirement from SRS Document.
• Performed ETL data validation using TOAD tool.
• Performed BI Testing using reporting tool OBIEE.
• Participated in identifying test scenarios with client.
• Participated in identifying test data.
• Developed the Test cases based on the Design document.
• Executed the test cases and identified the bugs.
• Posted and tracked the bugs through BugDB.
• Performed Regression testing for new releases.
• Involved in installation of ODI, Creation of master repository, Creation of Work repository.
• Involved in creation of ODI security settings (User creation, assigning of necessary scenarios and other objects to respective users).
• Performed ODI Topology settings (Creation of Data servers, Physical servers, Logical schema).
• Performed ODI Designer (Creation of Models, Projects, Packages, Interfaces, Procedures, scenarios.
• Deployed scenarios in the execution Repository.
• Involved in preparing performance comparison report between ODI and Informatica.
• Involved in Trouble shooting and setting up Lib and JCO files in Oracle Home (Oracaldi) folder. Environment: ODI, TOAD, SAPR/3 and Oracle10g. Project: Oracle Hyperion BI Tools and SAP BW Integration
No skills were added
Remove Skill
ETL/BI Tester
Jul 2006 - Jun 2007
workspace and Interactive Reporting are the reporting tools of Oracle Hyperion Business Intelligence Suite. These reporting tools deliver powerful, intuitive, Web-based interactive analytics to all corners of the enterprise. A highly graphical and easy-to-use interactive interface, it enables users to view their data in a way that makes sense to them. The objective of this project is to enhance the above mentioned reporting tools to support SAP BW data extraction. Responsibilities:
• Understood the Test Environment and Project Requirement from SRS Document.
• Developed the Test cases based on the Design document.
• Performed ETL data validation using TOAD tool.
• Performed BI Testing using reporting tool OBIEE.
• Posted and tracked the bugs through BugDB.
• Participated in Identifying test scenarios with client.
• Prepared test scripts.
• Performed Regression testing for new releases.
• Performed Hyperion Web application and GUI testing on Web Analysis, Work space.
• Validated accessibility of different SAP BW data sources i, e.Infocube, Infosets, ODS, Multiprovider, Virtual providers in to the reports.
• Validated accessibility of SAP BW Query cubes and structures created using BEx designer in to the reports.
• Validated fields and field values presented in the reports were same as in SAP BExreports.i, e. Text, Hierarchy and Attributes.
• Validated reports for Drill-down features.
• Created LoadRunner scripts and correlated them.
• Executed scripts and identified response time for different users and prepared detailed comparison report using MS-Excel.
• Prepared performance test report and send the status reports to the client and project manager.
• Involved in Trouble shooting and setting up JCO files in Hyperion home. Environment: SAP BW3.5/BI 7.0, Web Analysis, Workspace, Interactive Reporting tool and UNIX.
Business Intelligence Data Validation ETL OBIEE Oracle Regression Testing TOAD HP Loadrunner Test Case Preparation Project Management SAP Performance Testing SAP BW Data Lakes
Remove Skill
Jun 2004 - Apr 2006
Project: Nielsen - eSpec - Reports Role: Test Analyst Responsibilities:
• Coordinated with Manager on assignments and planned out the task schedules.
• Planed and Coordinated the Testing and QA activities.
• Managed QA deliveries to the client on a daily basis.
• Responsible for mentoring junior testers in the team.
• Created Test cases according to the functional specification.
• Prepared test Data for respective reports and executed test cases.
• Prepared of test results.
• Prepared Defect Tracking Report.
• Performed Functional Testing, Regression testing and System Testing.
• Coordinated and communicated with the Offshore and Onsite team.
No skills were added
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Project Plan, HP ALM
Health net Inc 2014
Oracle 10G and Informatica
Equinix Inc 2013
not provided 2003
PROJECTS EXPERIENCES
not provided 2000
Certifications
ISTQBSoftware Testing Certified
ISO/CMMI Internal Audit Trained
Skills
Oracle
2021
7
SQL
2021
7
Test Case Preparation
2021
7
HP QC
2021
6
NCS
2021
6
TOAD
2021
6
Quality Assurance
2021
5
Test Planning
2021
5
HP ALM
2021
4
Informatica
2014
4
MS TFS
2021
4
OBIEE
2013
4
Project Management
2021
4
Regression Testing
2013
4
Auditing
2021
3
Business Analysis
2021
3
ETL
2014
3
Integration Testing
2013
3
MS Project
2021
3
MS SharePoint
2021
3
UAT
2021
3
Analysis
2012
2
ETL Testing
2012
2
HP QTP
2012
2
J2EE
2012
2
JIRA
2012
2
SDLC
2012
2
STLC
2012
2
Windows
2013
2
Backend Testing
2010
1
Business Intelligence
2007
1
Data Lakes
2007
1
Data Validation
2010
1
Database Design
2013
1
Delivery Management
2014
1
Gap Analysis
2014
1
HP Loadrunner
2007
1
Performance Management
2014
1
Performance Testing
2007
1
Project Planning
2014
1
REST
2013
1
SAP
2010
1
SAP BW
2010
1
SAP ECC
2010
1
SAP MM
2010
1
Stakeholder Engagement
2014
1
Agile Methodology
0
1
Automated Testing
0
1
CMMI
0
1
Cognos
0
1
Data Modeling
0
1
Data Warehousing
0
1
Documentation
2010
1
ERP
0
1
Java
0
1
Manual Testing
0
1
PL/SQL
0
1
SAP BI
2010
1
SAP Functional
2010
1
Scrum
0
1
Siebel
0
1
SQL Server
0
1
System Analysis
0
1
Waterfall
0
1
Windows XP
2010
1