Mohit Khanna

Contact No: +91-947*******

EMAIL ID : adf0jh@r.postjobfree.com

To get a challenging project that offers professional growth, being innovative and inquisitive. My aim is to work with a company which believes in teamwork, respects talent, rewards and performance.

Seasoned IT professional with comprehensive Technical skill set in Data Warehouse Testing.

Expertise in Requirement Analysis, Framing Test Scenarios, Designing Test cases, Executing Test cases, and tracking defects till closure

Good experience in Data Warehouse testing (ETL Testing), Database Testing, Functional Testing,SQL Development and Maintenance, OLAP,OLTP,QUERY SURGE, UNIX, Shell Scripting, Informatica 9.0.1, SSIS Tool, ODI,OBIEE, TOAD, Manual Testing, Quality Centre, TFS, RDBMS and STLC.

Hands of experience as a Database Migration / ETL Tester on an Implementation of a HealthCare System (MMM) at client location Puerto Rico, USA

Experience in Defect Management and Tracking.

Experience in Test Planning, Test Design, Test Execution.

Expertise in ALM, QC.

An effective communicator with good written & verbal communication skills with strong analytical abilities.

9.4 years of professional IT experience.

Valid B1 Visa till 2026.

Course

Period

Institute

University/Board

%

B.Tech (Biotech)

2006-2010

U.I.E.T

Punjab University

67.25

Higher Secondary School

2006

Moti Ram Arya Senior Secondary School, Chandigarh

C.B.S.E.

83.4

Senior Secondary School

2004

Moti Ram Arya Senior Secondary School, Chandigarh

C.B.S.E

70.6

IT Skills:

Operating System : Windows 7, Windows Vista, Windows XP.

Language : C, C++, Java, RDBMS Essential

RDBMS : Oracle 10, UNIX, Informatica

Project Management Tools : MS Office, Excel, Access

VIRTUSA POLARIS LTD – TEST LEAD 20 Nov 2019 – Present

Project 1:-

Account: - RBS Nov 2019- Till now

Project Title: Data Warehouse Migration Testing (RRE)

Tools Used : - TOAD, SQL, UNIX, and Informatica

Abstract: The Rainbow rules Engine application is built using Informatica. RRE extracts the transactional data

From the different upstream systems like AI propay, International, Wall street, and other OLTP legacy sytems,the static data is extracted from the

Different systems like GRDM, AI, Walker, CUST DB, ORG MODEL, RMP and KHALIX using informatica. The Transactional data is processed and enrichment is done with the static data and the data is sent to the various

Downstream systems like Prosper, Walker, RCube, Bancware, Trade Finance, and GRDW ( OLAP systems )

Informatica does the extraction, transformation and loads into the RRE datastore, which is then processed

And send extracts to the downstream systems.

Responsibilities:

oInvolved in Business analysis and requirements gathering.

oAssisted in creating fact and dimension table implementation in Star Schema model based on requirements.

oValidating the data files from source to make sure correct data has been captured to be loaded to target table

oExtensively used Informatica to load data from Flat Files to Oracle, Oracle to Flat Files and Oracle to Oracle

oReviewed Informatica mappings and test cases before delivering to Client

oDesigned, Created and Executed manual Test Cases

oTest Cases execution and Test Optimization - Identify missing scenarios and update and executed test cases accordingly.

oDeveloped ETL Automation Framework using Query Surge to Run, Schedule, Execute Test Scripts and notify the results over an email to validate Daily, Weekly and Monthly Loads.

oPrepared daily status reports with details of executed, passed, and failed test cases and defect status.

oTested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads.

oWritten Test Cases for ETL to compare Source and Target database systems.

oDefect Analyzing and Reporting in QC

oOBIEE is used to create flash reports, report templates, and ad-hoc reporting for end users.

GENPACT--- TEST LEAD 20 Aug 2018 to 18 Nov 2019

Project 2 Feb 2019 – Nov 2019

Account: RBS – UK

TMS to TRS – Treasury reporting system

Architecture involves the migration of the oracle warehouse builder to the ODI tool .Extracts as per the business requirements are generated and end to end validation of the extracts were done as per the business rules.

Extracts involves the generation of the Intraday and EOD messages which are further processed to generate the ISO mxml and are reported to DTCC to check the ACK/NACK

Tools Used: JIRA, ODI, Oracle

Project 1

Account: Genworth – USA Aug 2018 - Jan 2019

Genworth Financial is an S&P 400 insurance company.

The architecture involves the data migration from hdfs to datawarehouse and then to posting tables and then to spot fire. End to end validation is done as per the business rules

Tools Used: PG admin III, QC, Informatica

Roles and Responsibilities:

oDeveloping the test plans and test cases and executing the test cases.

oDeveloping the complex sql queries to validate end to end testing

oBug fixes validation in prod, dev and Qa environment.

oPreparing the test plan and test strategies for ETL application.

oDefects identified in test cases are communicated to developers using Quality center.

oMaintaining daily status reports with complete information like passed, failed and executed test cases.

oPerformed all test cases like Unit Testing, Regression Testing, and User Acceptance Testing.

oExperience in creating various reports using crystal reports according to end user requirements

CIGNITI TECH LTD--- TEST LEAD BENCH 09 Apr 2018 to 17 Aug 2018

TESTINGXPERTS --- TEST LEAD 18 July 2016 to 06 Apr 2018

Project 1:-

Account: - MMM Healthcare LLC, Innvocare Group July 2016 – June 2017

Project Title: - InnovaMD Healthcare portal

Tools Used : - SQL Server, TFS, MTM, SSIS Tool, Query Surge

Abstract: MMM ETL is based on healthcare domain and is built on SSIS tool. This project has been tasked with acquiring files from the source system. The purpose is to present the ETL Design for implementation of the Data Acquisition and publish process to the target system. The QA will involve requirement analysis, test case preparation & execution to validate the data quality and data correctness being moved from these source systems to the target system (SQL Server).

Responsibilities:

oRequirement gathering and understanding.

oPrepare Test cases as per Business requirements written in User Stories.

oReview test Cases already prepared and add new if required.

oExecute Test Cases.

oFunctional testing, Retesting, Regression and E2E Testing.

oLogging bugs in bug tracking tool TFS and MTM.

oAttending daily scrum call.

oClient Interaction in USA and attending daily meetings

Project 2:-

Project Title : - Sybase Remedition July 2017 – Mar 2018

Tools Used : - Sybase Database to Oracle Database

Abstract: SGL Team is mainly consuming data from upstream through various routes, processing them, creating contracts, applying rules and saving them in Database so that various extracts and reports can be generated and provided to end users. In Bonds project the route of trade flow was migrating from Traditional route (TDW) to new route (ARE) so all testing was done that while changing the route there is no impact on existing functionalities, Extracts and Reports. The migration was done in 6 phases with a fix number of books migrating in each phase

Responsibilities: :

• Through Comparison of Tables Structures

• Generation & Comparison of Extracts

• Writing Test Cases and executing them

• Bug Reporting

• Preparation of documents like RTM, TIC and TCR while providing signoff

INFOSYS LTD – TEST ANALYST 07 Mar 2011 to 15 July 2016

Project 4:-

Account: - BARCLAYS, UK July 2014 – June 2016

Project Title: Data Warehouse Migration Testing (IMCC)

Tools Used : - TOAD, UNIX, Mainframe, and ODI

Abstract: The Scope of IMCC includes delivering functional requirements addressing the data Integration processes to receive, validate, transform and generate output data based on inputs supplied by source systems of record .In a pre-defined formed that can be consumed by the rendering engine before generating the desired form of customer communication . This project has been tasked with acquiring files from the source system. The purpose is to present the ETL Design for implementation of the Data Acquisition and publish process to generate the letters which will be used by the customers. The QA will involve requirement analysis, test case preparation & execution to validate the data quality and data correctness being moved from these source systems to the target system (Oracle).

Responsibilities:

oInvolved in knowledge transfer related to the tools being used even across the projects.

oCapable of raising the criticalities to the client.

oBusiness requirement gathering.

oPreparation of Test Cases.

oInvolved in Test Execution and analysis of reports.

oDeveloped UNIX scripts to validate the flat files and to automate the manual test cases.

oUnderstanding of the source system (Oracle database) and target systems (flat files).

Project 3:-

Account: - BARCLAYS, UK Jan 2013 – July 2014

Project Title: Data Warehouse Migration Testing (BASEL)

Project Type : - Quality Assurance

Tools Used : - MS Excel, UNIX, and Informatica

Abstract: This project has been tasked with acquiring files from call credit and making it available to users. These files are predominantly used for Basel Models. The purpose is to present the ETL Design for implementation of the Data Acquisition and publish process for the Basel Advanced Reporting project under data Acquisition resume. The QA will involve requirement analysis, test case preparation & execution to validate the data quality and data correctness being moved from these source systems to the target system (Oracle).

Responsibilities:

oInvolved in knowledge transfer related to the tools being used even across the projects.

oCapable of raising the criticalities to the client.

oBusiness requirement gathering.

oPreparation of Test Cases.

oInvolved in Test Execution and analysis of reports.

oUnderstanding of the source system and target systems (flat files).

Project 2:-

Account: - DEUTSCHE BANK, Sydney

Project Title : DODD FRANK PROJECT Jan 2012 to Jan 2013

Test Management Tool: HP ALM

Environment: Informatica (Version-10.6.1), Oracle (Version-10)

Description : The Dodd Frank is a US regulation applicable to all the Banks. As per Dodd Frank Regulation all the DF eligible trade messages has to be reported to DTCC. The solution reports the trades as listed below:

Real Time Reporting: The project involves developing a Real time Informatica solution to read trade messages (FpMLs) from Upstream JMS Queue, store it in the TDW data warehouse, Identification of DF Eligible trades, Generate a USI (Unique Swap Identifier) and Generate the Target FpML to be reported to DTCC MQ Series. The solution is designed to run in real time using Intermediate JMS Queues.

End of Day Reporting: End of day reports has to be generated are: Continuation, Valuation and ODRF. These reports are uploaded to DTCC for last day trades

Responsibility :-

Understanding & clarification of business requirement document and functional specifications.

Involved in Client interactions to understand and analyze system requirement.

Team member in the manual testing team as well as responsible to cater to all issues coming up from the client.

Knowledge Transition: Involved in studying the requirements, understanding of the business logic and acquiring sufficient domain knowledge required for the project.

Preparation of Test Cases - Analyzing business requirements and designing test scenarios and prepare test cases accordingly.

Extensively involved in Test Case Execution for System Test and System Integration Testing

Extensively involved in Test Case Execution for GUI Testing, Smoke Testing and Functional Testing

Test Cases execution and Test Optimization - Identify missing scenarios and update and executed test cases accordingly.

Test case updating whenever any new requirement or any functionality change.

Involved in the Integration testing for various changes and requirements across teams.

Interacted closely with the development team for requirement analysis and updating test cases in Quality Centre.

Verifying Data through SQL Queries.

Ensuring complete testing coverage.

Defect Verification and Reporting, entering the bugs in Defect Tracking Tool.

Managing Daily Status Report and Weekly Status Report.

Project 1:-

Account: - WELLPOINT, U.S June 2011 to Nov 2011

Project Title : Middleware testing (IAS)

Domain : Healthcare/Insurance Life Sciences

Tool : SOAP UI, ALTOVA XML SPY

Description : WellPoint is the USA’s leading health benefits company serving the needs of approximately 35 million medical members nationwide. WellPoint is a Blue Cross or Blue Cross Blue Shield licensee in 14 states. WellPoint is included in the S&P 500 index.

IAS (Integration, Architecture & Services) is the middle tier solution for WellPoint IT business units that will allow for seamless information connectivity and transformation to and from all corporate information systems. IAS is the middleware application that processes and transforms the data into the required format.

Responsibility :-

Requirement Understanding.

Test scenario and Test case Preparation and Test case execution.

Infosys Training: March 2011 to Aug 2011

Undergone 3.5 months extensive training at Infosys Mysore Campus, covering various aspects of IT, and programming languages such as Java (Basic), RDBMS, PL/SQL, UNIX, and SDLC.

Successfully completed 1.5 months training on advanced Java.

Present Address: 2180, Sector:-50/c, Pepsu Society, Chandigarh

Father’s Name: Mr. Ashok Khanna

DOB: 14th August, 1988

Languages known: English, Hindi, Punjabi

Passport Details: Passport No: K3396434

Career Objective

Professional Profile

Educational Profile

Professional Experience

Personal Details

Contact this candidate