Bala Kumar

6+ years of diverse experience in Software Quality Assurance with a thorough knowledge of System, Functional, ETL and Regression testing methods. Good product knowledge in Canadian banking, insurance, and mobile domains. Over 5 years utilizing Agile/Scrum methodology in managing projects. Proven ability in handling different phases of Software Testing Life Cycle (STLC) from Test Analysis, Test Planning and strategy, Test Environment Setup and Test Case Design, Defect Life Cycle, Test Execution, End of Test Case. Comprehensive knowledge of data warehouse design methodologies and industry standards. Skills in quickly understanding the requirements from End Users, existing systems, demo systems, Scope Documents and Business Requirement Documents (BRD). Good experience in creating and executing Test Plans, Test Cases, Defects by following best QA Methodologies for both Manual and Automated Testing environments. Expertise in Manual Testing and Database (ETL) testing. Designed the ETL processes using SSIS to load data from Oracle, SQL Server, Flat Files and Excel files to target SQL Server staging databases. Designed, developed and implemented ETL framework using SSIS, stored procedures, functions for Oracle extractions into SQL Server dimensional model. Involved in troubleshooting and debugging of ETL, SQL stored procedures and reports. Managed package configuration to efficiently deploy ETL packages from development environment to Production environment. Validating the load process of ETL to make sure the target tables are populated according to the data mapping provided that satisfies the transformation rules. Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing, in a corporate - wide-ETL Solution. Exclusively worked with the ETL team to analyze the source and Target Database systems. Exclusively worked on ETL test case scenarios with business functionality and generated the reports for business users. Expertise in analyzing and designing automated as well as manual procedures for the verification, validation, and implementation of accurate testing strategies for the successful deployment of real-time solutions. Good experience in understanding of Business & Testing requirements and writing detailed Test Plans, Test Cases, and Test Scripts. Ability to handle multiple tasks and work independently as well as in a team, having strong analytical and problem-solving.