Balaji Kothandapani

• Project Name : EDO Commercial BI
• Team Size : 24
• Role : QA Manager
• Duration : August 2021 – Till date
• Tools Used : Snowflake, PowerBI, MySQL, Oracle, Informatica
• Description : Commercial BI operates on data from various sources irrespective of different lobs where segregate customer’s insurance premium, and portfolios yearly and send report on insurance claimed, renewed or cancelled, project is all about collecting these data from existing RDBMS and maintaining it in SNOWFLAKE and provided reports in POWER BI
• Managing team of 24 member across 3 different ARTs
• Performing as Manager and offshore SME for Customer and clients
• Involves in Project Management, Resource Management and Costing
• Improved overall efficiency of the QA department through strategic planning and resource allocation.
• Perform test planning, test execution along with team and test artifacts preparation & reviews
• Managed cross-functional teams to ensure seamless coordination between QA, development, and support departments
• Collaborated with stakeholders to establish key performance indicators for the QA team, driving continuous improvement efforts throughout the organization.
• Conducted root cause analysis on recurring defects, implementing corrective measures to prevent future occurrences.

• Project Name : IFFE2E Internal Feedstock Program
• Team Size : 6
• Role : QA Test Lead
• Duration : April 2020 – Aug 2021
• Tools Used : Snowflake, PowerBI, MySQL, Oracle
• Description :IFFE2E is project to provide customers with crisis management, risk analysis and to understand stock demand or alternate stock during crisis
• Testing activities involved creation of various test scenarios, test cases and test scripts to validate data from existing systems to our current E2E systems where data will be flowing from Oracle, MySQL, AWS S3 and Snowflake regions
• Validation done on source to S3, S3 to Staging and Staging to Curated and finally on BI Reports both Angular and PowerBI reports
• As part of QA Offshore Lead involved in project planning activities, estimations, task allocations, test executions, weekly status updates, resource management and defect triage
• Creation of test reports (Daily and weekly) & owning daily status call and client engagement
• Mentored junior testers in best practices for software testing methodologies while fostering a collaborative team environment
• Identified critical defects early in the development process through meticulous code reviews and static analysis tools usage
• Maintained detailed documentation of all executed tests, identified defects, root cause analyses, and corrective actions taken for future reference purposes.

• Project Name : Cognos to Power BI Migration
• Team Size : 10
• Role : QA Team Lead
• Duration : July 2019 - April 2020
• Tools Used : Amazon Web Service (S3, Athena, Data pipeline, EMR), MS SQL Server, JIRA
• Description : EDM is data management project which involves handling of assets modules which are created from Salesforce and converting those modules as data warehouse as DIM & FACTS, data from Salesforce are moved into AWS Bucket layer as parquet files, those are converted as physical tables through AWS-Athena, from their data will be processed using Informatica delivered as final product in Client warehouse
• Creating tables and scripts for converting business into logic
• Comparison of data between Cloud layer and Databases
• Creation of test reports and defects in JIRA
• Created stories, handled scrum meetings and prepared JIRA Report

• Project Name : Enterprise Data Management
• Team Size : 10
• Role : Senior Software Engineer
• Duration : Jan 2018- July 2019
• Tools Used : Amazon Web Service (S3, Athena, Data pipeline, EMR), MS SQL Server, JIRA
• Description : EDM is data management project which involves handling of assets modules which are created from Salesforce and converting those modules as data warehouse as DIM & FACTS, data from Salesforce are moved into AWS Bucket layer as parquet files, those are converted as physical tables through AWS-Athena, from their data will be processed using Informatica delivered as final product in Client warehouse
• Creating tables and scripts for converting business into logic
• Comparison of data between Cloud layer and Databases
• Creation of test reports and defects in JIRA
• Created stories, handled scrum meetings and prepared JIRA Report

• Project Name : FCT Automation
  Role : Test Analyst
• Duration : Feb 2017- Jan 2018
• Team Size : 10
  Tools Used : Oracle, Teradata, JAVA, TOSCA, JIRA
• Description : FCT automation is framework developed to automate query building and triggering of test cases in HP ALM and TOSCA. Framework is built to generate query dynamically with minimal user inputs and with keywords and input received framework will build queries for data comparison and it also pulls test cases from HP ALM and dynamically stores those test cases in databases and compare data based on inputs. It also hosts to trigger test cases in TOSCA for both TOSCA BI and TOSCA UI modules. This framework will reduce overall user intervention in query creations, avoid syntax error and reduce time taken for data comparison
• Creating test suites for automation
• Creation of JAVA project for modules creation and automation
• Creation of test data and managing same for data analytics

• Project Name : AML Cards Transaction Monitoring
• Team Size : 5
  Role : QA Test Analyst
• Duration : May 2015- Feb 2017
• Tools Used : HIVE, Impala, TOAD, HP ALM
• Description : AML CARDS TM is designed to watch transactions happening in CREDIT Cards and to create scenarios to show fraudulent transactions, cross border transaction and so on by creating rules engines and to filter customer and their transaction based on risk score. Under AML anti money laundering data are processed to prevent fraudulent claims, transactions and cross border activities these are noted as flag and raised as alerts, which in turn taken as cases and processed further.
• Managing team as offshore point of contact.
• Preparing test approaches, strategies, test case
• Creating test beds for automation
• Compare reports generated with HIVE Database

• Project Name : PRISM MBM
• Team Size : 2
  Role : QA Tester
• Duration : Nov 2014–May 2015
• Tools Used : Toad, Oracle, HP Quality Center, Informatica
• Description : PRISM is an application to enable user to choose their policy plans, overages, sales details, rating premiums and this enables user to have a track of their policy and coverages and premium amounts need to be paid
• Written SQL queries
• Analysis of Test cases
• Checking Transformations, Mapping and Monitor jobs
• Compare reports generated with Database
• Reporting defects in Quality Centre and getting them fixed and day to day onsite co-ordination

• Project Name : Enterprise Claim Operating System (ECOS)
• Team Size : 13
• Role : DW Tester
• Duration : Mar 2014 - Nov 2014
• Tools Used : Toad, Oracle, HP Quality Center
• Description: Project is to create complete guide ware application for claims operations from front end to reports, to create an enterprise level management system for Claims, and for handling large volumes of claim data from its initiation to report, thereby replacing old and existing claim handling.
• Create Project documents, Test Plan, Test Strategy, ROM, Signoff document
• Designed and created test cases based on business requirement and mapping document
• Written SQL queries and analysis of Test cases
• Preparation of Test Results Documents
• Present Test result documents with BA

Reporting the defects in Quality Centre and getting them fixed and day to day onsite co-ordination

• Project Name : Web logic Upgrade
• Team Size : 4
• Role : QA Tester
• Duration : Mar 2013 – Feb 2014
• Tools Used : Toad, SOAP UI, Quality Center
  Description : Project is for up gradation of application in Web services which was following existing services, nearly 14 application were upgraded and scenarios was created to understand DW impact, load changes and accessing multiple users
• Create Project documents, Test Plan, Test Strategies, Signoff document
• Designed and created test cases based on business requirement and mapping document
• Analyses Old application URL creates cases and compare them in New Upgraded URL
• Compare results obtained in Application in DW

• Project Name : THPA GBD
• Team Size : 4
• Role : QA Tester
• Duration : July 2012 – Feb 2013
• Tools Used : Toad, Informatica, Webi, Quality Center
• Description : This project will help employers meet the challenges of managing their workforce when faced with increasing complex leave legislation and compliance requirements, loss control challenges and overall productivity concerns with this project employers can gain access to this data through an integrated service experience across all of these products, supported by a comprehensive set of reports that combine data for multiple employee leave activities
• Create Project documents, Test Plan, Test Strategies, Signoff document
• Designed and created test cases based on the business requirement and mapping document
• Preparation of Test Results Documents

• Project Name : Wellpoint Data Exchange
• Team Size : 6
• Role : DW Developer
• Duration : March 2012 - Jun 2012
• Tools Used : Toad, Teradata, HP Quality Center
• Description: Project is to create a complete data warehouse exchange for healthcare products and related process in EDM and where legacy source systems are combined to make a single DataMart for all applications
• Build Data modelling sheet which is used for data mart coding
• Develop test cases to verify whether code works are per requirement
• Frame procedures, modelling scripts in Teradata

• Learned new materials, processes, and programs quickly
• Attended training courses to build understanding of processes, techniques, and industry
• Participated in on-the-job training, working closely with supervisors and coworkers and asking appropriate questions
• Established lasting relationships with peers, leadership and customers using strong communication and interpersonal skills