Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Timeline
Generic

Anil Karnati

Hyderabad

Summary

Around 11 years of experience specializing in testing, analysis, and implementation of ETL testing. I have a profound understanding of the software development life cycle, Software Testing Life cycle and extensive experience with various testing methodologies within the banking sector with strong analytical abilities, leadership skills, and a keen eye for detail, I manage complexities effectively, deliver quality solutions, and ensure high client satisfaction.

Overview

11
11
years of professional experience
1
1
Certification

Work History

CITI BANK – CRM Analytics
Hyderabad
01.2020 - Current
  • CRM Analytics project focusing on Sales, Implementation, Infrastructure & all other modules reporting
  • Evaluated end user and functional requirements to define test plans and scenarios.
  • Conducted a detailed analytical review of functional requirements while testing
  • Resource planning and determining roles and responsibilities
  • Designed and developed comprehensive test plans and cases to ensure software quality and functionality align with user requirements and company standards
  • Involved in Talend ETL Tool exit process by introducing SP System in Oracle DB
  • Handling Daily Scrum calls, Defect Triage calls to address the concerns quickly to the point
  • Execute manual and automated tests, analyze results, identify defects, and document issues in JIRA reporting tool
  • Works with other team members in execution of automated test cases during Regression Testing
  • Participate in technical discussions within QA team with other groups associated with assigned projects
  • Capable of working independently and/or with developers
  • Involved in ETL Tools process migration from Informatica to Talend efficiently
  • Coordination of project goals with other managers, including QA, Development Managers
  • Preparation of JIRA status reports to track all the Test cases, bugs across all the modules and Publishing to application and Client partners

Senior Software Engineer

Virtusa Consulting Services
Hyderabad
10.2014 - Current
  • Evaluating end user and functional requirements to define test plans and test scenarios
  • Representing the end user to ensure that all the requirements are met
  • Conducting a process oriented and detail level analytical review of functional requirements while testing the products
  • Implementing automation scripts for Analytics Health Check Reports for CRM analytics
  • Coordination and interaction with the team on modules and reports testing process
  • Managing daily scrum calls, Weekly calls, Design review calls Exit criteria calls
  • Developing test results and errors detected while supporting activities to maintain the quality of solutions
  • Process streamlining and detecting and proposing improvements in the Quality control process
  • Preparation of Daily Status Report and Prepare the Test data for Test execution.
  • Involved in Sanity testing, Functional, Regression testing and E2E Testing
  • Good working knowledge of SQL and Object Oriented Databases like Oracle and MS SQL
  • Experience in Data analysis, data validation and data quality assurance.
  • Worked on prompts, Reports, graphs, tables validations
  • Tracking Defects through JIRA
  • Initiating DEFECT TRAIGE Calls with Applications teams to close the defects on priority basis
  • Provided artifacts for project management review and managing effort logging/resource management

Consultant

CITI BANK – GIW DA, GSD Migrate US Custody
Chennai
10.2014 - 12.2019
  • Migration from US Custody Cash from Intra-GIW to GSD GIW
  • Interact and adapt to the Business Analyst, Technical Leads, System Architects etc.) to understand the requirements in detail
  • Coordination and interaction with the team on requirements and testing process
  • Prepare Technology Test plan Documents
  • Understand the required architecture, environment set-up and prepare hardware and software requirement list for the Test Environment
  • Handled daily scrum and defect triage calls.
  • Executed tests as per plan, documented results and logged defects.
  • Processing and validating data in FLAT and CAMT052, CAMT053 files as well as in DB tables
  • Test Process, Extract (Feed Vs Staging), Transform (Staging Vs Warehouse), Load (Warehouse Vs Mart), GSD SWIFT Message generation MT900, MT910, MT940 and MT950 and PIP Front end reports (Account summary, Debit Advise Credit Advise.)
  • Map defects to test cases in JIRA , Retest the Defect fixes, Track the defects to closure

CITI BANK – Enhance Application for Brazil
Chennai
03.2016 - 10.2017
  • BZTE project aimed at enhancements for various applications serving the Brazil region.
  • Administrated the implementation and enhancement of applications for Brazil region.
  • Prepared integrated test plans and executed test strategies.
  • Performed data validation across multiple reporting modules.
  • Coordination and interaction with the team on modules testing process
  • Managing daily scrum calls, Weekly calls, Design review calls Exit criteria calls.
  • A Lead role for 1 year with 3 members track in Global Information Warehouse (GIW) team and handling the deliverables in various modules
  • Analysis the Test requirements and Preparing, Execution of the Test Scenario & Test cases
  • Prepare the Technology Test plan Documents
  • Preparation and review of Test Data, Test scenarios and SIT Test Cases
  • Functional gathering and working closely with the developers
  • Provided artifacts for project management review and managing effort logging/resource management
  • Prepared Traceability Matrix for the requirements logged and tracked the Defects through QC

CITI BANK – ALTO Payments Brazil
Chennai
10.2014 - 02.2016
  • Focused on ALTO Payments Brazil project ensuring compliance with banking regulations.
  • Analyzed test requirements and prepared execution plans.
  • Tracked defects and provided detailed documentation for project management reviews.
  • Involved in end-to-end testing, ensuring compatibility across systems.
  • Technology/Tools Used: SQL Developer, UNIX and Autosys WCC CA Console, Application Life cycle Management 12.01, JIRA, ETL Testing, GATES (Automation Tool), SQL Server, UNIX, Tectia.

Education

MCA - Master of Computer Applications

Osmania University
Hyderabad
07.2008

Skills

  • DW ETL Testing
  • Functional Testing
  • Automation - Selenium with Java
  • JIRA
  • Oracle
  • SQL
  • CORE JAVA
  • STLC
  • Manual Testing Concepts
  • VBA Scripts for Macros
  • GATES tool
  • Automation testing
  • SQL querying
  • ETL processes

Certification

  • ISTQB Foundation Level Certification
  • SCJP - Sun Certified Java Programmer

Accomplishments

  • Client Appreciation and Awards: Received client appreciation for managing the successful migration testing and contributions to various CITI BANK projects with zero defects.
  • GEM & SPOT Excellence Award: Received Gem and Spot awards for exceptional handling of the CITI GIW Projects

Timeline

CITI BANK – CRM Analytics
01.2020 - Current

CITI BANK – Enhance Application for Brazil
03.2016 - 10.2017

Consultant

CITI BANK – GIW DA, GSD Migrate US Custody
10.2014 - 12.2019

Senior Software Engineer

Virtusa Consulting Services
10.2014 - Current

CITI BANK – ALTO Payments Brazil
10.2014 - 02.2016

MCA - Master of Computer Applications

Osmania University

Similar Profiles

CREATE PROFILE
Anil Karnati