Kushagra Kumar Email:adg6o3@r.postjobfree.com
Ph: +91-971*******
Objective: Looking for a long-term association with an organization having dynamic work environment where my skills could be enhanced and grow in the hierarchy of the company.
Professional Synopsis
Total 4 years of experience in Software Testing, especially in ETL and SQL development.
Experience in team handling from 2 to 11 resources at various point of times.
Trained and hands on various ETL tools like Informatica PowerCenter and Query Surge.
Hands on experience on TOAD, PLSQL, Informatica, BO Reporting, Intellimatch.
Trained in Automation tool like UFT (QTP).
Good experience in SQL Query preparation in Oracle.
Worked with HP Quality Center and JIRA for Defect management and Bug Reporting.
Experience in all types of Test Documentation: Test Plan, Test Scenarios, Test Cases and Understanding documents etc.
Good knowledge of SQL queries, ETL concepts and process and UNIX commands.
Good exposure to Software Development Life Cycle and Testing Life Cycle.
Excellent Team Player possessing Good Communication and Interpersonal Skills.
Joined as a fresher in Wipro Ltd and was trained for six months in
Core Java and ETL with QTP.
Career Profile
Dates
Organization
Designation
June 2016 – Till Date
Wipro Limited
Senior Project Engineer
Educational Qualifications
Batch (IT) from Galgotia’s College of Engineering & Technology (Greater Noida) in 2016.
Technical Skills
Database
Oracle, Toad Data Point, Teradata, PLSQL
ETL Tools
Informatica, Unix
Test Management Tool
HP Quality Center, JIRA
Automation Tool
Query Surge, Trained on UFT
Programming Languages
Core Java,J2EE, HTML,VBA for excel Macros, SQL, CSS, PL/SQL
Operating Systems
Windows XP/Vista/7
Project Experience
Project # 1
Project Title : KYC
Client : US Bank
Domain : Banking
Testing Type : Data Warehouse Testing
Testing Tools : Query Surge, Toad Data Point
Test Management Tool : HP Quality Center 11.0(ALM)
Team Size : 11
Dated : Jan, 2017 – Dec, 2017
Description: Know Your Customer (KYC LRD) is a regulatory project. Data is moved from multiple source system to RAW layer and from RAW layer to HM Layer and from HM to LR Layer. All these layers are on HADOOP file system. We do ETL Validation and Business Transformation check between HM to LR layer.
Responsibilities:
Preparation of Test Cases from Mapping Document.
Execute Test cases and report defects using defect management tool, HP Quality Center.
Coordinating with Development Team to discuss about Defects.
Coordinating with the client on some issues.
Track the raised defects till their closure.
Validate schema of the tables like column names, data type length, nullability etc.
Validate the data from the source system to final staging area.
Build SQL queries to validate the business transformation logics.
Project # 2
Project Title : RFDAR(RISK FINANCE DATA and RECONCILATION)
Client : Credit Suisse
Domain : Banking
Development Tool : Informatica Power Center
Testing Tools : Oracle SQL Developer, PLSQL Developer, Intellimatch, BO Reporting
Test Management Tool : HP Quality Center 11.0(ALM) and JIRA
Team Size : 08
Dated : Jan, 2018 – May, 2019
Description: FARR is a reconciliation project which deals with Risk and Finance Data. We receive data in the form of flat files from the normalization layer after which it is loaded into Intellimatch and further processed. After which data flows to Business Objects which is the business intelligence layer. Project is made to understand the consistency between Risk and Finance side data. Daily a report will be generated which will show how many records matched between the two sides upon which analysis can be performed.
Responsibilities:
Develop and review Test Scenarios, Test Conditions and Test cases based on Business and Technical requirements.
Develop informatica flows to validate the business requirements.
Develop Test Scenarios to test different matching rules as per the requirement.
Create Test data to test difficult scenarios.
Coordinate with developer and BA for all clarifications.
Involved in SQL queries used for test execution.
Defect Monitoring and Bug tracking.
Documentation and presentation of test results at various phases of testing life cycle.
Ensures quality product delivery and client satisfaction.
Project # 3
Project Title : ACVA(Advanced Credit Valuation Adjustment)
Client : Credit Suisse
Domain : Banking
Testing Type : Data Warehouse Testing
Testing Tools : Oracle SQL Developer, UNIX
Test Management Tool : HP Quality Center 11.0(ALM)
Team Size : 03
Dated : June, 2019 – Dec, 2019
Description: ACVA takes into account any change in credit risk when reporting the fair value of any derivative position and is by definition the difference between the risk-free portfolio and the true portfolio value that takes into account the possibility of counterparty default.
Currently, the PB Uncollateralized Derivatives Portfolio utilizes standard exposure method in order to calculate CVA. The change which the project is bringing here is the calculation of PB Uncollateralized Derivatives Portfolio exposure using the more advanced Internal Model Method (IMM).
Responsibilities:
Develop and review Test Scenarios, Test Conditions and Test cases based on FSD provided by the BAs.
Upload the feeds from different source systems using TECTIA.
Create Test data to cover all the scenarios.
Coordinate with developer and BA for all clarifications.
Involved in SQL queries used for test execution.
Defect Monitoring and Bug tracking.
Documentation and presentation of test results at various phases of testing life cycle.
Managed two other people of the team with task allocation and queries.
Project # 4
Project Title : EUC(End User Computing)
Client : CITI Bank
Domain : Banking
Development Tools : Oracle SQL
Test Management Tool : JIRA
Team Size : 11
Dated : Jan, 2020 – Till Now
Description: EUC remediation project is all about automating the manual process done by the CITI customers using Appian as UI and Oracle SQL as the backend.
FRSS Citi team have different input systems from which they have the inputs to download and then we have to perform all the calculations on those input files and create the output to post on their different portals.
Responsibilities:
Develop the data model as per the information given by the CITI SMEs.
Prepare the FRD for all the EUCs so that anyone in future can understand the flow easily.
Assign work to the resources according to their experience and expertise.
Prepare queries to manipulate the input data and generate output as per the requirement set by SMEs.
Track the whole EUC from Dev till UAT sign off.
Attend the meeting with the stakeholders and management to provide the team progress.