Summary
Overview
Work History
Education
Skills
Personal Information
Disclaimer
Timeline
Generic

Ansar Syed

Bengaluru,Karnataka

Summary

A passionate and self-motivated professional with 4.6 years of experience in testing domain. Keen for interesting and challenging opportunity that helps me to use my knowledge and enable me to apply my skills, talent & team spirit for symbiotic growth.

Having 4.7 years of experience in ETL, Reporting, BI Report testing and Functional testing. Hands on experience in ETL/DWH Testing. Hands on experience in writing the SQL queries. Hands on experience in Tableau BI Report testing. Strong knowledge on DWH Concepts and DWH testing. Strong knowledge in Informatica ETL tool (Workflow Manager, Workflow Monitor & Workflow Designer). Hands on experience in Toad database management tool. Basic knowledge on Tidal scheduling tool. Hands on experience in functional testing of Web applications. Hands on experience in Security, Database and Regression testing techniques for Web applications. Experienced in working with SDLC models- Agile Methodology. Work exposure in various phases of SDLC – Requirement Analysis, Test Design, Implementation, Testing and UAT. Hands on experience in writing SQL Queries in Oracle/MySQL databases. Worked on the DB migration. Experienced in gathering and analyzing requirements and preparing the Test Analysis in X-mind document. Experienced in preparing the TAD analysis. Preparation of Test Designs and mapping the Test Designs for the user-stories. Experienced in reporting the defects(bugs) based on the priority.

Overview

5
5
years of professional experience

Work History

Analyst

Deloitte
01.2022 - Current
  • Project Name: Fresenius Medical Care
  • Key skills: Database testing and Manual testing
  • Data base: Oracle SQL, AWS Athena, My SQL Server
  • Role: Analyst
  • Description: The Client is a leading provider of Dialysis/ Kidney care across US and Canada and a major prescence in Western Europe
  • The project involves assisting the client in their IT Business across multiple platfroms including Clinical Applications/ Oracle/ SAP and Salesforce
  • Multiple independent towers are tasked with delivery across their different product suites and an independent QA tower which assists with testing activities across each of these layers.
  • Role & Responsibilities: As a QA Analyst working on the Data and Analytics track, primary responsibility in supporting the client with testing tasks related to support and discretionary projects that have been approved by client leadership
  • Directly exchanging information on requirements and modifications with the client
  • Possessing Agile methodology experience
  • Strong skills in understanding the data analysis and query writing
  • Worked under fast-paced and high-pressure environments with multiple projects
  • In charge of estimating testing effort, requirement analysis, creating and executing test cases, tracking defects, regression testing, and status reporting
  • Using SQL scripts to validate the ETL business logics
  • Testing the data warehousing from beginning to end in accordance with business needs
  • Verifying the information in flat files and tables using transformation logics
  • Checking that the linked databases and BI reports are valid in accordance with business requirements
  • Root cause analysis and defect detection for the defects
  • Uploading the test cases into the test management tool and running them after the validations are finished.

Software Test Engineer

Ionidea
09.2019 - 01.2022
  • Project 1: Direct Carrier Billing
  • Key skills: Functional testing, API Automation and Application Security testing
  • Data base: Oracle SQL, MySQL
  • Role: Software Test Engineer
  • Description: Direct Carrier Billing (DCB) is an online payment method
  • It allows users to pay for their mobile phone bills, games, themes & songs which are purchased
  • This Payment method is applicable to all smart phone users and functional mobile users
  • The only requirement for confirming the payment is the device with SIM card
  • Prepaid or post-paid users can purchase digital content and charge it to their mobile bill or prepaid balance for one-off, subscription or in-app payments
  • Direct Carrier Billing is different from the other mobile payments (mobile wallet, NFC solution) because it does not rely on the bank infra-structure.
  • Role & Responsibilities: Involved in the requirement walk through meetings
  • Prepared the Test analysis in XMIND, test case design for the business requirements
  • Experienced in executing the test cases and reporting the bugs
  • Involved in story testing, smoke testing, functional testing, security testing, Regression testing with good quality
  • Prepared and ran the SQL Queries
  • Analyzing the defects and reporting the defects in TMSS (DTS Huawei)
  • Reporting the daily testing status report through the email
  • Involved in daily review meetings
  • Defect detection as well as the root cause analysis for the defects.

Associate Software Test Engineer

IonIdea
09.2019 - 08.2021
  • Project 2: Ring Back Tone Portal
  • Key skills: Functional testing, Application Security testing
  • Data base: Oracle SQL
  • Role: Associate Software Test Engineer
  • Description: This RBT Portal manages the features such as downloading RBTs, subscribing to the RBT service, managing accounts, and charging, express copy, end of call SMS messages, DO IT YOURSELF
  • So, user can customize Ring Back Tone by replacing beep tone with a piece of music or greetings that can be played for Called Parties
  • RBT can also provide VXML service script according to the requests from the IVR (Interactive Voice Resource)
  • All the RBT services and announcements (like ring tones) on the File System
  • The VP regularly synchronizes the RBT files and announcements from the File System to the local disk
  • Users can use RBT Services by subscribing to RBT; Charges can be applied based on the Brand selected
  • Role & Responsibilities: Involved in the requirement walk through meetings
  • Prepared the test case design and estimates for the business requirements
  • Experienced in executing the test cases and reporting the bugs
  • Involved in story testing, smoke testing, functional testing, security testing, Regression testing with good quality
  • Experienced in the Application Security Testing using the Burp suite tool
  • Prepared and ran the SQL Queries
  • Analyzing the defects and reporting the defects in TMSS (DTS Huawei)
  • Reporting the daily testing status report through the email
  • Involved in daily review meetings
  • Defect detection as well as the root cause analysis for the defects.

Education

Bachelor of Science -

Brindavan Institute of Technology And Science
Kurnool, India
05.2018

Skills

  • ETL/DWH
  • BI Reporting
  • Application Security
  • Oracle
  • MS SQL Server
  • AWS Athena
  • Snowflake
  • Toad
  • Jira/Confluence
  • Test Rail
  • Python
  • Data Migration

Personal Information

Title: Analyst

Disclaimer

I do here by declare that all the particulars mentioned above are true to the best of my knowledge & belief.

Timeline

Analyst

Deloitte
01.2022 - Current

Associate Software Test Engineer

IonIdea
09.2019 - 08.2021

Software Test Engineer

Ionidea
09.2019 - 01.2022

Bachelor of Science -

Brindavan Institute of Technology And Science

Similar Profiles

CREATE PROFILE
Ansar Syed