Summary
Overview
Work History
Education
Skills
Timeline
Generic

AKSHATHA SUBBANNA SHETTY

Sydney,NSW

Summary

  • Experienced Software Tester with over 11 years of strong experience in Data Warehouse/ETL testing over various projects including Banking, Wealth, Superannuation, and Insurance domain.
  • Strong analytical, technical, and problem-solving skills, also excellent communication, stakeholder management.
  • Expert in analysing Functional & Business Requirement Documents, Technical Specifications and apply these business rules and logic to data transformations.
  • Experience in V Models, waterfall, and Agile Methodologies.
  • Strong experience in Data analysis, requirement gathering, drafting and implementation of Data warehousing business rules, extraction of data and reports generation and validation.
  • As part of Test Project management, involved in organising Test Strategy , Master Test Plan and Test Summary report walkthroughs with stakeholders , Daily standups, Defect triage, technical change approval meetings with the technical team and business, Status meetings and co-ordination with various Vendors involved and PIR meetings.
  • Mentoring new team members, resolving technical queries and preparation of Knowledge Transition documents.
  • Involved in business analysis, Gathering, validating, and documenting business requirements.
  • Modelling business processes and identifying opportunities for process improvements.
  • Identifying issues, risks and benefits of existing and proposed solutions and outlining business impacts.
  • Experience in delivering various compliance and regulatory projects including Australian Taxation Office Reporting, Foreign Account Tax Compliance Act, Anti Money Laundering, Common Reporting Standard and Australian Prudential Regulation Authority reporting.
  • Involved in Data migration and decommission projects and reporting to 3rd party.

Overview

11
11
years of professional experience

Work History

Senior Associate

Cognizant Technologies
08.2022 - Current
  • Worked for " WESTPAC " Client.
  • Analysis of Overall business impact and work with Business Analyst and project manager to understand the requirement.
  • Requirement Analysis and review of detailed business requirement documents.
  • Involved in requirement discussion with project BA's and drafting functional specification document.
  • Providing technical recommendations and options based on solution designs which can be cost effective.
  • Involved in Data analysis and documentation.
  • Detailed analysis of the impact and design recommendation for the CR's.

Technical Test Lead

Infosys Limited
01.2022 - 08.2022
  • Worked for " MLC "and " IOOF " Client.
  • Managing ST and SIT team, preparation of Master Test plan and Test Summary Report and walkthrough the test deliverables to stakeholders and follow up for sign off for production implementations.
  • Generating test effort estimations and validating test scope and project risks.
  • Involved in preparation of Technical Verification Testing (TVT) and Business Verification Testing (BVT) queries during project implementation.
  • Creation of user stories and estimating them using a point-based approach.
  • Identifying and logging of issues and risks throughout the delivery.
  • Managed the offshore team while working with all the stakeholders.
  • Involved in cost estimations for CRs within the project.
  • Requirement analysis and review of detailed business requirement document.
  • Preparing test scenarios for business requirement
  • Coordinate among the various asset teams to validate the data migration scenarios across all the integration points.

Test Analyst

Infosys Limited
08.2017 - 01.2022
  • Worked for "National Australia Bank (NAB) " Client.
  • Worked in Global data warehouse and Enterprise Data warehouse.
  • Creation of production like test data across various environment to fulfill the test data requirements.
  • Writing complex SQL queries in production like database to validate the business requirements.
  • Optimizing efforts using existing regression suit.
  • Batch execution of Mainframe and UNIX jobs.
  • Involved in Pre and Post Implementation tasks.
  • Experience in Metasuite and UNIX coding and using version controls tools such as Harvest, GitHub.
  • Preparing test data model to ensure test data coverage of all products across different portfolios.
  • Experience in migrating artifacts from development environments to the testing environment and to production environment.

Test Analyst

Infosys Limited
11.2015 - 08.2017
  • Worked for "National Australia Bank (NAB) " Client.
  • Preparing test data and scenarios and executing test cases, raising defects and, following it up with the development team and track the end to end testing to closure ( Included test execution status reporting).
  • Involved in automation test scripting.
  • Involved in overall UI testing, functional testing, regression testing, System testing and System integration testing.
  • Involved in GDW (Global data warehouse )production support and BAU profile. This task involves monitoring and providing support for scheduled automated jobs.

Senior Software Engineer

NTT Data
06.2012 - 11.2015
  • Worked for " BCBS North Carolina, USA " client.
  • Involved in Development, Unit testing and Deployment of ETL code using Ab Initio and UNIX.
  • Extensively involved in the development of Ab initio ETL process for extracting data from different data sources, data transformation and loading the data into data warehouse for data mart operations.
  • Involved in code migration from DEV to SIT, UAT and Production Environment and Debugging and Fixing the Issues raised by Testing Team during the SIT Phase.
  • Involved in Production Support to Operation Team during Initial runs and presenting KT Sessions.
  • Involved in Test Case Development, Test Case Review, Test Execution, Regression Testing, following up defects with all project stake holders, assisting team members in test execution.

Education

Bachelor of Technology (Electronics & Communication Engineering) -

Visvesvaraya Technological University (VTU)
05.2011

Higher Secondary Board Course -

Mahatma Gandhi Memorial College Udupi
05.2007

Secondary Board Course -

Mahalakshmi English Medium School. Uchila
03.2005

Skills

  • Database worked on: MainframeDB2, Oracle(9i,10g), Teradata, SQL Server, and Redshift
  • MS Office (Word, Excel, Power point)
  • Proficient in PL/SQL, Basics of SF –SOQL, VB Script, Basic of UNIX scripting and C, Metasuite
  • Expertise in Mainframe, Client Server Applications and Salesforce CRM System
  • Tools and frameworks worked on : ALM - Quality Center, qTest, TOAD, SQL Developer, Putty, Eclipse, Ab initio 326, Control-M, Harvest, JIRA with Zephyr, Jenkins, Artifactory, AWS, GitHub, Remedy, MetaMap, MetaStore, WinSCP, Visio, DataLoader, DataStage , SAS Data Integration Studio, SAS EG, Lotus Notes, Control-M (Batch Job Scheduler), Business Objects, XML SpyJIRA, Confluence
  • Software Documentation
  • Design Reviews
  • Quality Assurance
  • Testing, Debugging and maintenance
  • Dataflow Design
  • Development Lifecycles
  • Big Data Analysis
  • Project Management
  • Resource Allocation
  • Project Planning
  • Automation Scripting
  • Internal Quality Assurance Management
  • Database Query Planning
  • Test Planning
  • Manual Test Analysis
  • Test Script Engineering
  • Risk Identification and Mitigation
  • Usability Testing
  • Selenium
  • Tableau
  • Quicksight
  • System Validation
  • Automated Test Analysis and Testing Frameworks
  • Test Scheduling
  • Scenarios and Use Cases
  • Results and Deadline-Driven
  • Test Program Development
  • Test Plans and Test Methodologies
  • Decision-Making
  • Time Management and Organization
  • Test Procedure Documentation
  • Defect Tracking and Reporting
  • Strong Problem Solver
  • Software Release and Versioning
  • Manual Test Case Preparation
  • Root Cause Analysis
  • Project Documentation
  • Workflows and Queries
  • Technical Analysis
  • Team Reporting
  • Performance Testing
  • Team Mentoring
  • Continuous-Integration Testing
  • Scrum Methodology
  • Defect Monitoring
  • Teamwork and Positive Attitude
  • Software Documentation Reviews
  • Documentation Skills
  • Design Specifications
  • Training and Onboarding
  • Version Control Systems: Git

Timeline

Senior Associate

Cognizant Technologies
08.2022 - Current

Technical Test Lead

Infosys Limited
01.2022 - 08.2022

Test Analyst

Infosys Limited
08.2017 - 01.2022

Test Analyst

Infosys Limited
11.2015 - 08.2017

Senior Software Engineer

NTT Data
06.2012 - 11.2015

Bachelor of Technology (Electronics & Communication Engineering) -

Visvesvaraya Technological University (VTU)

Higher Secondary Board Course -

Mahatma Gandhi Memorial College Udupi

Secondary Board Course -

Mahalakshmi English Medium School. Uchila

Similar Profiles

CREATE PROFILE
AKSHATHA SUBBANNA SHETTY