Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Disclaimer
Skills - Technical Expertise
Timeline
Generic

Srujana Kandula

Edmonton,Canada

Summary

Highly motivated and dedicated professional with 11+ years of extensive experience in Analysis, Testing, and the use of various tools. In-depth knowledge of Software Development Life Cycle, Software Test Life Cycle, and Bug tracking. Expertise in Data Inspection reports, Test Plans, Detailed Test Cases, and Test summary documents. Hands-on experience in Test-Driven Development environment. Strong skills in Data warehouse Concepts, Data completeness testing, ETL Job setup validations, End-to-end testing, ETL testing, Database testing, Functional Testing, Integration testing, System testing, and Regression testing. Strong team player with excellent interpersonal skills and ability to build relationships across organizational levels. Successful collaboration with local and off-shore team members. Proficient in Oracle, Teradata, Microsoft SQL Server, Google Cloud Platform, BigQuery, Azure Data Lake, and data bricks. Skilled in debugging and finding alternative solutions or workarounds. Created ETL test data for all ETL mapping rules. Extensive experience in writing complex SQL Queries and Power BI Report Testing. Theoretical knowledge on data modeling and data mining techniques. Proficiency in HP-ALM, TFS, Test Rail, and JIRA for test repository maintenance and bug tracking. Quick learner and excellent team player with strong analytical and problem-solving abilities. Effective communication skills and ability to meet tight deadlines.

Overview

1
1
Certification

Work History

QA Analyst

Reitman’s Canada Limited RCL
  • Company Overview: Migration of MicroStrategy on-prem to MicroStrategy cloud project that enables Improved business performance with better analytics capabilities (more fact-based business decisions), One source of truth, Improved user experience, and much more which is used for decision-making and strategy planning
  • Create, optimize, and execute SQL queries to validate transformation rules used in source to target mappings and to verify the target data
  • End-to-end ETL testing should be done when a new source is added
  • Ensured that data was loaded in the data warehouse within prescribed and expected time frames to confirm improved performance and scalability
  • Implement Micro strategy testing strategy for dashboards
  • Implement Data quality checks on Dashboards
  • Set up rules and guidelines to ensure data consistency and accuracy
  • It plays a crucial role in maintaining high-quality data
  • Validated all report functionalities, Report parameters, data mapping, and UI (Fonts, Alignments, data mapping, Header, and footer) adhere to the checklist and as per BI standards
  • Implement a testing strategy to validate KPIs at the source level and the dashboard level
  • POC in progress on Data quality component in Informatica
  • Migration of MicroStrategy on-prem to MicroStrategy cloud project that enables Improved business performance with better analytics capabilities (more fact-based business decisions), One source of truth, Improved user experience, and much more which is used for decision-making and strategy planning
  • Technology: Snowflake, Micro Strategy cloud, Informatica

QA Analyst

ATB financials
  • Company Overview: This project is about ATB’s new modern data platform called Data Exposure Enablement Platform (DEEP) which is Hosted on the Google Cloud Platform that Enables data delivery teams to build and deploy enterprise data solutions consumable by all users across ATB
  • ELT testing between different DEEP layers using Big Query, it is Google’s fully managed, serverless, highly scalable, and cost-effective cloud enterprise data warehouse
  • Verifying the Data Conversion Strategy
  • Validating Data Classification rules based on Collibra
  • Security view testing based on Collibra
  • Using automation strategy for data validation
  • Creating test cases in the query surge
  • Identify sample data by doing data profiling to test the DML logic
  • DAG validation
  • Tested various maps for Extraction of Data from various source systems and loading into ERAW layer from RAW layers
  • Create Test cases using Stored procedure creation
  • Create, optimize, and execute SQL queries to validate transformation rules used in source-to-target mappings and to verify the target data
  • Ensured that data was loaded in the data warehouse within prescribed and expected time frames to confirm improved performance and scalability
  • This project is about ATB’s new modern data platform called Data Exposure Enablement Platform (DEEP) which is Hosted on the Google Cloud Platform that Enables data delivery teams to build and deploy enterprise data solutions consumable by all users across ATB
  • Technology: Google cloud platform and BigQuery

QA Analyst

HCL Canada Client: Air Canada
  • Company Overview: This project aims to deliver analytics solutions (data lake/EDW/Reports) that support the new Loyalty Program at Air Canada (Aeroplan)
  • Implement Power BI testing strategy
  • After solution review as a QA we need to develop test strategy
  • Validate DAX metrics, Checklist of the report and security testing
  • Create Power BI report which includes the regression testing test results
  • Validated all report functionalities
  • Worked in campaign POD to test data transformations from Source to snowflake table
  • Create, optimize and execute SQL queries to validate transformation rules used in source to target mappings and to verify the target data
  • Ensured that data is loaded in data warehouse within prescribed and expected time frames to confirm improved performance and scalability
  • This project aims to deliver analytics solutions (data lake/EDW/Reports) that support the new Loyalty Program at Air Canada (Aeroplan)
  • Technology: Power BI, Snowflake, Data Bricks

QA Analyst

Canadian Western Bank
  • Company Overview: This project is about all external sources (unstructured data) that are integrated across the enterprise with the current data warehouse (DDS/Datamart)
  • Implement Test driven development strategy
  • After solution review as a QA, we need to develop test strategy
  • Creating PBI’s in TFS
  • Identify sample data by doing data profiling to test the mapping logic
  • Worked with developers who extensively used SAS data integration tool, ETL tool to design mappings to move data from source to the target database
  • Tested various maps for Extraction of Data from various source systems and loading into Target SQL server Data warehouse and tested ETL Jobs
  • Create test data in TDD environment
  • Create Unit Test cases which include stored procedure creation
  • Run test cases in TDD environment
  • Create, optimize and execute SQL queries to validate transformation rules used in source to target mappings and to verify the target data
  • This project is about all external sources (unstructured data) that are integrated across the enterprise with the current data warehouse (DDS/Datamart)
  • Technology: Microsoft SQL server

QA Analyst

Wells Fargo India Pvt Ltd
  • Company Overview: Enterprise Technology Asset Management (ETAM) group is responsible for managing/governing all infrastructure technology assets (software and hardware) and the lifecycle processes that support them
  • Right from requirement phase QA is part of discussion and this gave me good insights about the project
  • Gathered and understood the Data Conversion Strategy
  • Once the design walkthrough is completed, prepare test plan document and walkthrough was given to entire team
  • Participated in testing the ETL mappings/Jobs, based on the customer requests
  • Provided and reviewed the Test Coverage Matrix and Test cases with the Business users, Business analyst and Development groups and requested their approvals
  • Defects are raised and discussed in triage meeting for resolving identified issues
  • Performed UI testing for the reports and forms
  • Performed Smoke, Functional, System Integration, Performance, End to End and User Acceptance testing
  • Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse
  • Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables
  • Post implementation testing was performed
  • Good at giving test strategic walkthroughs and published best practices
  • Prepared all kinds of Data inspection reports and Test plan document
  • Designing test cases and test scenarios from all the available inputs
  • Prepared Status Reports on weekly basis
  • Prepared Test Summary Report after ensuring completeness of testing
  • Bug Tracking and Reporting through HP ALM
  • Excellent collaboration with all the stakeholders
  • Enterprise Technology Asset Management (ETAM) group is responsible for managing/governing all infrastructure technology assets (software and hardware) and the lifecycle processes that support them
  • Technology: Teradata

ETL Test Analyst

Capgemini India Pvt.Ltd
  • Company Overview: Farmers Insurance Group of Companies is the USA's third-largest insurer of both private Personal Lines Insurance and homeowners Insurance and also provides a wide range of other insurance and financial services products
  • Analysed the Business and Functional requirements
  • Designing test cases and test scenarios from all the available inputs
  • Verified that data is transformed correctly according to various business requirements and rules
  • Ensured that all projected data is loaded into the data warehouse without any data loss and truncation
  • Experience with HP LoadRunner and Apache JMeter
  • Bug Tracking and Reporting through Quality Center
  • GUI testing, Smoke testing and regression testing was performed on regular basis
  • OBIEE report testing based on the requirement document
  • Performed user interface testing that includes functional and integration
  • Customer Survey end to end was performed which includes creating a claim in front end application making changes in processing application, Running ETL job ad there by triggering the survey
  • In Survey User interface testing was done and made sure that responses are correctly loaded into databases
  • Aggregation and visualization were also done on all the reports based on the business requirements given
  • Had good exposure to insurance domain, based on the claims registers we do aggregations and report to the business team which would help them to suggest few functionalities and report same to the customer
  • Farmers Insurance Group of Companies is the USA's third-largest insurer of both private Personal Lines Insurance and homeowners Insurance and also provides a wide range of other insurance and financial services products
  • Technology: Siebel Financial, Mainframe, Oracle

Education

Bachelor of Technology - Computer Science and Engineering

CBIT, Osmania University

Skills

  • Oracle
  • Teradata
  • SQL Server
  • Informatica Power Center
  • Ab initio
  • SAS
  • Azure Data Lake
  • Data Bricks
  • Google Cloud Platform
  • BigQuery
  • OBIEE 111
  • Tableau
  • Power BI
  • Collibra
  • HP Quality Centre
  • Jira
  • Team Foundation Server
  • Microsoft Test Manager
  • Cross Browser
  • Browser Stack
  • Data quality assurance
  • Data profiling
  • ETL testing

Certification

  • Executive Program in Business Analytics (EPBA), Indian Institute of Management Calcutta (IIMC)
  • ISTQB Certified
  • Teradata 14 certified professional

Accomplishments

  • Worked as Quality Assurance Specialist for 10 years.
  • Awarded achieving excellence award for demonstrating excellence in contributing shared goal.

Disclaimer

I hereby declare that the information furnished above is true to the best of my knowledge.

Skills - Technical Expertise

Oracle, Teradata, SQL Server, MySQL, Windows, Informatica Power Center, Ab Initio, SAS, Azure Data Lake, Data Bricks, Google Cloud Platform, BigQuery, OBIEE 11.1, Tableau, Power BI, Collibra, HP Quality Centre, JIRA, Team Foundation Server, Microsoft Test Manager

Timeline

QA Analyst

Reitman’s Canada Limited RCL

QA Analyst

ATB financials

QA Analyst

HCL Canada Client: Air Canada

QA Analyst

Canadian Western Bank

QA Analyst

Wells Fargo India Pvt Ltd

ETL Test Analyst

Capgemini India Pvt.Ltd

Bachelor of Technology - Computer Science and Engineering

CBIT, Osmania University

Similar Profiles

CREATE PROFILE
Srujana Kandula