Sign in

Data Project

Toronto, ON, Canada
March 05, 2019

Contact this candidate



Email: Phone:+1-647-***-****


QA/Testing with 5 years of cumulative hands-on experience as QA Analyst in software quality assurance processes, manual and automated testing, requirements elicitation, business analysis, configuration management, release management, test cycle management, defect management, independent verification and validation services.

●Proven expertise in defining Test Strategy, writing Test Plans, Test Scenarios & Test cases based on business requirements, functional specifications, Use cases to support quality deliverables.

●Strong experience in Black box/White box tests, Unit, Alpha, Integration, GUI, Functionality, Regression, Performance, Volume, Stress, Configuration, User Acceptance Testing (UAT), adhoc and Risk based testing.

●Experienced in analyzing Test Results, Test Metrics and Performance Graphs in identifying bottlenecks and creating Reports using Test Director, Rational Test Manager.

●Can Create Automation Scripts from scratch with automation tools Selenium and QTP.

●Proficient in data driven testing using SOAP UI.

●Experience on testing on mobile platforms Android and iOS.

●Involved in Requirement gathering, End-user training, specifications and documentations including RTM (Requirement Traceability Matrix).

●Experience in working with Software Development teams in resolving Defects, conducting defect root cause analysis, and resolving requirement and design inconsistencies observed.

●Developed and presented Testing Status Reports including testing progress, defect status, and any issues, risks to Management in weekly project status meetings.

●Hand on prototype data source management.

●Involved in all phases of the QA Life Cycle and SDLC, with timely delivery against aggressive deadlines, with QA methodologies such as ISO, CMM, Agile, Scrum, Rapid application development and Six Sigma.

●Experience with manual testing, including: functional, smoke, regression, and load testing

●Proficient in Testing of Database applications developed with Green screens DB2, Oracle, Microsoft SQL Server and Microsoft Access using DDL, DML and DCL commands.

●Experience in Windows /UNIX /Linux Mainframe environments and back end applications using SQL and PL/SQL for data validations and data migrations.

●Excellent knowledge and experience in web testing techniques and performing cross browser testing.

●Capable of working under tight project deadlines with multiple projects, using agile methodology techniques, presentations as and when required.

●Experience with POSTMAN.

●Domain knowledge in Healthcare, Retail, Financial and Insurance companies and Federal (DEA and DOD) environment.

●Proficient on HARDWARE TESTING and checking the performance before submitting the final product to the client.

QA Analyst - October 2016 – December 2018


Job Title: Project Lead

Project Name: Customer Information Billing System (POS)

Project Description: Integration of FIS (Financial information system) to CIBS (Customer information billing system). Conversion of billing system and porting the database to Oracle, all the data from different data sources are converted and loaded into target databases using Conversion and Transformation requirements. Specific UI screens are built for each billing type, which are connected to backend billing system.


●Test Strategy preparation, test plan execution.

●Created detailed test cases and mapped the test data for test execution.

●Used MTM tool for organizing test scripts.

●Created automated scripts from scratch with different data types and executed test using Selenium

●Reported defects using bug-reporting tool JIRA.

●As the part of the project also worked on multi-user support. Safety and security measures and management of multiple threads in the Web API.

●Supported end users during UAT testing by creating UAT test cases and scenarios

●Prepare and present reports, results and findings of executed load tests with Load Runner

●Performed Regression testing of the web portal Using Selenium web driver which is connected to the backend billing system by which user can adjust for incorrect bills.

●Supported end users during UAT testing by creating UAT test cases and scenarios

●The front-end testing was done using ETL methodologies

●The complete testing of GUI was the main concern in the project.

●Performed System, Integration, Data Mapping, Data Validation, Data Integrity, End to End and User acceptance testing

●Used SQL and PL/SQL for data validations and data migrations.

●Configured Data maps and used EAI Data map engine business service to map external service fields to internal fields.

●Complete back-end testing on different data bases was coded and tested using SQL and PL/SQL

●Generated test execution reports and presented to the project manager.

●Implemented complete HARDWARE TESTING by deploying the POS on the client machine and sorting its defects.

●Sorting out the required specifications of the machine by performing the HARDWARE TESTING

Technology: Selenium, JIRA, ETL, PL/SQL, Python, WebLogic, HTML, XML, SOAP, SQL, Toad,Abi Intio, UNIX/Linux and Microsoft Visio

QA Analyst - October 2014 - September 2016

Client Name: E NETWORKING, Alberta

Project Name: Claims Conversion Project

Project Description:

The claims and medical benefits data for each customer has been downloaded into E Networking network. It eventually undergoes data transformation and finally gets loaded into target tables. Reports and queries are conducted on the oracle tables for data analysis and calculation purposes.


●Responsible for analyzing the Business requirements, developing test cases from functional requirements using Selenium.

●Responsible for writing the test scripts using C# for testing the GUI.

●Developed test cases from functional requirements using Selenium.

●Efficient use of TFS for the extraction and modification of source code in fast achievements of deadlines.

●Conducted PL/SQL queries on Oracle database to test data integrity and confirming that there is no data loss.

●Invoked test scripts to be run in HP QTP by connecting with HP ALM

●Performed regression testing of the application using HP QTP 10.0.

●Performed root cause analysis for every test scenario to deduct the cause of the defect and to avoid regression testing.

●Conversion of file formats, data load testing.

●ETL testing for data load in different stages

●Comparison of file layout s with actual data load.

●Verifying FACTS tables and Dimensional tables.

●Responsible for test execution and defect reporting.

●Used the Tidal job schedule for calling the ETL Informatica purposes.

●Responsible for testing UNIX script, calling procedures.

●Used the Microsoft Project for project planning purposes.

●Conducted SQL queries on Sybase database to test data integrity and confirming that there is no data loss.

●Responsible for test execution and defect reporting.

●Utilized Microsoft Project for project planning purposes.

●Excellent management skills with team members and business group, management.

Technology: Quick Test Professional, Quality Center, Root cause analysis, Tidal, Informatica ETL, Abi Intio,UNIX/Linux, TOAD, Rapid SQL Guidewire, Java, Java Script, J Unit, IBM Web Sphere, MQ Series, XML, SOAP,MS Visio.

QA Analyst - January 2013 - October 2014

National Bank, Quebec

Project Description:

Pricing Strategies (Credit card): The merger project deals with National Bank credit card features while integrating and adopting a united approach towards handling both the customers according to their terms and conditions. Pricing strategies project defines the criteria for charging, re-pricing the credit card accounts like AMEX, VISA, and MASTER cards.


●Built the QA process from the scratch for the pricing systems group.

●Defined the test strategies as per the project requirements.

●Using requirements and use cases in preparing the test scenarios & test cases manually.

●Created test scenarios for testing based on the requirements and submitted to the BA for coverage signoff.

●Generated automation scripts from scratch using SELINIUM and performed regression testing

●Understood the end-to-end credit card transactions for National Bank customers as per the design and architecture document.

●Designed, Created and implemented functional Regression Testing scripts including Account Balance Inquiry/Deposit/ Withdrawal/Transfer/Payment on Chequing/Saving/Credit Card/Mortgage accounts etc. in Personal E-Banking Services project with Data Driven Framework through Excel Object Model(EOM) by writing Descriptive Programming(VBScript) in Expert View of HP QTP

●Enforced SQL Server security using TDE (Transparent Data Encryption), SSL, Policies and SQL Audits, achieving PCI DSS compliance (Payment Card Industry Data Security Standard).

●Assisted in migration of data from Flat file, Excel, BCP, and SSIS.

●Validated messages and scripts according to the fix protocol and exchange of information relating to securities and markets.

●Measured my work progress by constantly updating testing work breakdown structure.

●Performed Data querying on SQL and DB2 database to validate backend database functionality.

●Used Mainframes CICS screens to understand the existing application functionality.

●Validating the application functionality and maintained traceability matrix.

Technology: Quality Center 9.2, Quick Test Pro 9.0, Java, Open text, Ab-Initio, SAP, Java Script, XML, CSS, SOAP, Oracle 9i, SQL, TSYS, Mainframes, UNIX/Linux, db2, and MS Office

Technical Skills

Testing Tools: Microsoft TFS (Team Foundation Server), Microsoft Test Manager, Quality Center ALM, Atlassian JIRA, Bugzilla, Quick Test Pro 11 (UFT), Selenium web driver, J-meter, J Unit

Programming: MS VB, Active Server Pages (ASP), HTML, CSS,VB, VB script, Python, Java,C++

Database: DB2, VSAM, CICS, TSYS, MS SQL Server, SQL, PL/SQL, Oracle, SQL, TOAD, AS/400,SQL Navigator

Operating System: Mainframe, MS Windows Professional/Server/Advanced Server, Windows NT Server/Workstation 4.0, Windows, LINUX, UNIX.

Other tools: Ab-Initio, SOAP, Informatica, OpenText, Microsoft Project, Microsoft Visio, Promart, MS-Visual Source Safe for Configuration management, Data stage


●ISTQB Certified Professional

●Bachelor of Science In Computers (JNTUH INDIA) …2008

●Maters in computers (Seneca college) ….2011

Contact this candidate