Summary
Overview
Work history
Education
Skills
WORK EXPERIENCE IN SOFTWARE TESTING
Timeline
Generic
Arunakumari Kilaparthi

Arunakumari Kilaparthi

Hyderabad,India

Summary

Experienced Senior Software Test Engineer committed to enhancing software quality and performance. Skilled in leading teams to identify and resolve complex issues, streamlining testing processes, and ensuring seamless software deployments. Delivered significant improvements in software reliability and user satisfaction, driving project success and client confidence.

Overview

16
16
years of professional experience

Work history

Senior Software Test Engineer

Brainware Infotech
Hyderabad, India
05.2020 - Current
  • A Competent professional around 4+ years of experience in Software Testing.
  • Extensive experience Manual Testing and Functional Testing and Understanding different Business flows.
  • Extensive experience in Data warehousing technologies like ETL/DWH Testing and writing complex SQL queries, deriving the functional requirements by discussing with Business Users and Business Analysis.
  • Experience in SDLC and STLC process.
  • Worked on Oracle Data base.
  • Following Agile software development process.
  • Extensive experience in all the levels of Testing life cycle including Requirement Analysis, Test Strategy preparation, Test Planning, Test Scenarios, Test cases preparation, and reviewing, Test Data preparation, Test execution, Defect handling which includes reporting, analyzing, prioritizing the defects, Status Reporting, Project Closure.
  • Proficient in all the ETL (Extraction, Transformation & Load) techniques, Dimensional Schema Models (Star, Snow-Flake schemas).
  • Exceptional knowledge in Product testing which includes, Sanity testing and smoke testing, functional Testing, System integration testing, Regression testing and database testing.
  • Strong experience in the field of Investment Banking.
  • Interacting with Business Analysts, Clients for getting the required inputs and parameters for testing the application.
  • Good exposure on Stored Procedure and Data Validation.
  • Good exposure on HP Quality Centre, Jira, Microsoft TFS etc.
  • Good Knowledge on CRM and ERP systems
  • Have experience in SAPBO4.0, J reports, Web focus, Power BI Reports validation.

Generating reports and interacting with the development team to resolve problems and track results.

Design Engineer

ANEWA (Group of DIALOG) Pvt Ltd
Hyderabad, India
10.2011 - 08.2014
  • Analysis and design of RC and Steel buildings, ware houses, sheds.
  • Analysis and design of Gas compressor shed and Detailing of pipe supports structure, Pump house, DG building, concrete structure and Fire water reservoir. Drawing checking, RFI”s like load data and clashing Preparing the excel spreadsheet for RCC beam design.
  • Analysis and design of Loading pump station, pipe supports, Jetty side steel platforms. Analysis and Design of Crossover platforms, Operating platforms, pipe rack, pump & vessel foundations.

Design Engineer

Ramboll India Pvt Ltd
Hyderabad, India
06.2009 - 10.2011
  • Optimised structural design processes through the adoption of innovative technologies and methodologies, driving efficiency and reducing project timelines.
  • Designed structural components for commercial buildings, adhering to industry standards and client specifications.
  • Managed the preparation of structural engineering documents, including calculations, drawings, and specifications.
  • Conducted accurate calculations and assessments of load-bearing components using Stadd Pro.
  • Facilitated communication between project stakeholders to resolve structural design conflicts and streamline project execution.

Education

Bachelor of Engineering - CIVIL

Pydha College of Engg & Tech

Skills

  • Informatica 10
  • Data Stage 113
  • Oracle 11g
  • SQL Server 2005
  • HP Quality Centre
  • HP ALM
  • SAP BO 40
  • SSRS
  • Tableau
  • Logi Analytics
  • Webfocus
  • Power BI
  • JIRA
  • Microsoft TFS
  • Version 1
  • Windows XP
  • Windows 7
  • Windows 8
  • UNIX
  • Autosys
  • Control M
  • GIT
  • Jenkins
  • AWS
  • REDSHIFT
  • Azure
  • Snowflake

WORK EXPERIENCE IN SOFTWARE TESTING

Currently working in Brainware Infotech as Senior Software Test Engineer from May 2020 to till date.


Project #1  :  Investment Banking. Client :  UBS, UK. Domain : Banking. Role : Senior QA Tester. Duration :  20 Months (Apr 2023 –Till Date).
Description: Project #2  :  Data Analyses System. Client :  Home Retail Group, UK. Domain : Banking. Role : QA Tester. Duration :  10 Months (May 2022-March 2023).
Description: Project #3 :  Charter Mobile & Communications. Client :  Charter Communications, Inc. Domain : Communications. Role : QA Tester. Duration :  21 Months (May 2020 to Feb 2022). Description:

Currently working in Brainware Infotech as Senior Software Test Engineer from May 2020 to till date.

PROJECT SUMMARY:

IB (Investment bank) work’s in between corporate client and investor. Client needs investment to expand their business. Banker Portal is an application widely used in IBDIT division bankers of UBS as a one stop application for tracking all the functional areas of IB.

The process starts from opportunity and ends with filing documents. Working with opportunity and client will create opportunity and after save and initiate approval from different security group. While creating opportunity, nuggets data will change depend on the selected value. There is a feature for search opportunity using opportunity code or name and edit option to add additional information after save opportunity. The other functional areas tied to Banker Portal are client coverage, client interactions, booking a deal, tracking a deal, booking revenue, tracking the expense, Dashboard for tracking client information, tracking the loans issued to a client, etc.

My Responsibilities: Involved in the following activities and execution of testing activities.

  • Understanding and deriving the Customer Requirement which will be posted in JIRA.
  • Interacting with the client and development team for specifications.
  • Generation of Test Cases, Test Scenarios and Test data.
  • Setting up testing environment for testing.
  • Preparing test result document and summarization of results.
  • Execution of Test Cases and raising the Defects.
  • Defects were tracked and reviewed using QC.
  • Detecting bug and classified them based on Severity and Priority.
  • Involved in Sanity testing, Functionality Testing, Database testing, Integration testing, System testing, Regression testing and UAT testing.

· GUI and Back End Testing.

· Executing the Stored Procedures and comparing the data.

· Generating the Power BI and web focus Visualizations Comparing and Data validation.

  • Defect Tracking.
  • Participated in Daily Status Meeting with client.

Brought the team up to the speed by conducting multiple sessions on both technical and functional.


Home Retail Group Retail Food Stores, which is one of the organizations that sells various numbers of products. Home Retail Group has various stores, which maintains Database has lots of historical data. This project was to create Sales Data Warehouse and generate reports using Business Objects.

The aim of sales data Warehouse is to analyze sales of major brands varying with different promotional schemes. The system has a database which stores information about sales, profits and contacts of customers. Using this existing database, the system should analyze the sales and profit and generates reports for Sales and Profits in month wise and year wise. The resulting model gives us an idea about growth in profit, prediction about increase in sales.

My Responsibilities:

Involved in the following activities and execution of testing activities.

  • Understanding and deriving the Customer Requirement which will be posted in TFS.
  • Interacting with the client and development team for specifications.
  • Generation of Test Cases, Test Scenarios and Test data.
  • Setting up testing environment for testing.
  • Preparing test result document and summarization of results.
  • Execution of Test Cases and raising the Defects.
  • Defects were tracked and reviewed using QC.
  • Detecting bug and classified them based on Severity and Priority.
  • Involved in Sanity testing, Functionality Testing, Database testing, Integration testing, System testing, Regression testing and UAT testing.

· GUI and Back End Testing.

· Generating the Webfocus Visualizations Comparing and Data validation.

  • Defect Tracking.

Participated in Daily Status Meeting with client.


Charter Communications, Inc.is an American telecommunications and mass media company with services branded as Charter Spectrum. Spectrum Mobile Portal is an application widely used in Charter Mobile & Communications as a one stop application for tracking all Issues and connections.

The process starts from Issues and ends Escalating to Respective Assignee. Working with Issues and client will create Issues and after save and initiate approval from different security group.

My Responsibilities: Understanding the customer requirements

  • Designed High level test scenarios and test cases
  • Run the Workflows/Jobs for ETL Process
  • Validated data in Target database according to business rules
  • Prepared SQL queries to validate the ETL processed data in target database.
  • Verifying the column mapping between source and target databases
  • Executed test cases in QC
  • Defect Tracking in QC and Daily Status Reports.



Timeline

Senior Software Test Engineer

Brainware Infotech
05.2020 - Current

Design Engineer

ANEWA (Group of DIALOG) Pvt Ltd
10.2011 - 08.2014

Design Engineer

Ramboll India Pvt Ltd
06.2009 - 10.2011

Bachelor of Engineering - CIVIL

Pydha College of Engg & Tech
Arunakumari Kilaparthi