Abhishek Verma - 647-***-**** / adhafu@r.postjobfree.com

Toronto

Professional Summary:

•QA/PM and BA with 5 years as ETL tester, and 14 years of extensive hands-on experience in all stages of the SDLC, Requirements gathering, Quality Assurance Process & Test Driven Development

•Extensive know-how in manual and automated testing for Web Based Client/Server applications, stand-alone applications, data validations, database querying and mobile testing.

•Good domain knowledge of banking, finance, telecommunication, insurance, Ecommerce/online payment processing terminology and processes.

Technical Summary

Automation

HP UFT, Selenium, Query Surge

Business Analysis Tools

MS Visio, Adobe Photoshop, Jira, draw.io

Scripting Languages

SQL, Unix, VB Script, Java, C#, C, C++

DBMS

Microsoft SQL Server (SSIS, SSAS), IBM Mainframe, MongoDB, Hadoop, Kafka, Aqua Data Studio, TOAD for Oracle

Defect Management

Rational Clear Quest, QC/HP ALM, JIRA, Bugzilla, VersionOne

Requirement Management

HP ALM, Rational RequisitePro, JIRA, Confluence, VersionOne

Software Lifecycle Management Methods:

Scrum, Agile, Waterfall

Presentation and General Business Tools:

Microsoft tools, JoinMe, Slack, Talend

Education

Bachelor of Science in M.I.S, Southern Illinois University, Carbondale, IL USA(2006)

Master of Business Administration, Globe University, Minneapolis, MN USA (2016)

Professional Experience:

TD Bank, Toronto, ON May ‘18 – June ‘20

Role: QA Tech Lead

Worked with TD Bank as a QA Lead in their Testing department. ETL-based projects. Led projects from testing perspective and did Managerial role, including test effort, test strategy, plan, resource and budget estimations, automation and manual testing approaches

Responsibilities:

•Selenium used for UI validation + mobile testing

•Hive/Beeline used interchangeably to query into Apache Hadoop system

•Hosting internal QA status calls, as well as participating in multi-team group calls with QA status as well as bugs, issues & concern

•ALM used to track SIT/UAT testing cycles, document test cases, test case runs, defects

Environment:

SQL, HIVE/Beeline, Selenium, Jira, ALM, Apache Hadoop

TCF Bank, Plymouth, MN Jan ‘18 – Mar ‘18

Role: ETL Tester/Data Management

Worked with TCF Bank on a short-term project called “Oracle-To-Hadoop” for Retail Banking. Goal was to ETL all 8 million customer records, from Oracle database to Hadoop database. After 3 months, project scope reassessment done. Only dev's remained, everyone else was let go.

Responsibilities:

•Used SQL Oracle to query into Oracle database. Study the data, and write requirements & test cases for migration of data to Hadoop database.

•Used Ambari for accessing Hadoop database, for data transformation rules and post-migration tesing

•Talend was being used as the ETL tool

Environment:

VersionOne, Jenkins, Talend, Slack, SQL, Hadoop, Kafka

Taylor Digital, Hopkins, MN Apr ‘17 – Dec ‘17

Role: Lead QA Analyst

Taylor Digital is a printing based technology and innovation company. I worked on the launch of a new application called KLIC. It’s a B2B application that specializes in sale of wholesale merchandise for business consumers.

Responsibilities:

•Test Driven development - whenever a new release was detected in any environment (Dev, Test, Staging or Prod), both front-end TestComplete UI scripts and back-end Ready API scripts would be run to sanity test the code

•Coordinated testing with inventory systems and billing systems

•MongoDB was used as a database for all records.

Environment:

Postman API, Soap UI, TestComplete, VersionOne, Slack, MongoDB, .NET framework

Allianz, St Louis Park, MN Jan ‘17 – Feb ‘17

Role: QA Analyst

Allianz Life is a leading provider of retirement and protection solutions, including fixed and variable annuities, and life insurance for individuals. My Project - “Starpoint”. An externally sourced app that our in-house insurance representatives use for daily client transactions. Project ended due to budget cuts

Responsibilities:

•HP UFT was used for automation testing. Pre-created scripts for both input of data and post-batch cycle validation were present in framework by dedicated automation testing team.

•Participated, lead and presented QA metrics & inputs in daily defect meetings, business requirement meetings, semi-weekly progress meetings and “Go/No Go” decisions.

Environment:

ClearQuest, Bugzilla, Lotus Notes, HP UFT, HP ALM, Waterfall, XML

State of MN, St Paul, MN Sept ’16 – Dec ‘16

Role: QA/BA

Minnesota IT Services (MNIT), the State of Minnesota’s central IT organization, provides IT programs and services to agencies, boards and councils.I worked on the Microsoft Program. The aim was to successfully launch the Microsoft Government Community Cloud (GCC) and shift all current server level programs, solutions and environments, into completely cloud based GCC.

Responsibilities:

•Setup many processes from scratch - templates for BA documentation, ETL and Data reading and extraction testing, progress reports and metrics around success criteria.

•Created documentation on existing solutions, converted them to requirements. Then created trace-ability matrices to have a 1:1 relation between requirements and test cases.

•Presented BA/QA reports, metrics, timelines, approach & success criteria for phases that were part of the steering committee presentation.

•

Environment:

Office ‘10/’13/’16,Windows 7/8/10, Sharepoint, .NET Framework

Wells Fargo, Minneapolis, MN Feb ’15 – Aug ‘16

Role: QA Lead

Wells Fargo is the world's largest bank by market capitalization and the third largest bank in the U.S. by assets. My role as a QA was to work on both big and small projects, from the Wholesale QA team of 16 QA’s.

Responsibilities:

•Worked on IBM Mainframe (using SQL) to query back-end tables and data validation

•Many ETL projects, as we have upstream and downstream applications, so had to validate pre-processing and post-processing data, both in front end GUI and back-end data tables.

Environment:

ALM, SQL, Microsoft excel, Microsoft word

Target, Minneapolis, MN Aug ’14 – Jan '15

Role: Automation Tester/QA Lead

Target Corporation is an American retailing company. Worked on 2 projects – 1) RaRe. This stood for Ratings & Reviews and Recommendations. 2) Incubation and development of in-house tool called ‘SIFT’ to display product recommendations based on different strategies,

Responsibilities:

•Test driven development - with code access, QA's were able to create SIT test data and automation scripts prior to code deployment, based on code scenarios.

•JSON & API Testing using automation tools

Environment:

Jira, Windows office applications, Confluence, Chrome, Agile, HTML/XML, API’s

Time off (visited India) Dec ‘13 – July ‘14

JP Morgan Chase, NYC, NY Aug ’11 – Nov '13

Role: QA Lead / BA

The project I worked on was ‘Phoenix’ in the Operational Risk Technology department. A widely used in-house application used exclusively by JPMC employees, the primary goal is to calculate the risks associated with day-to-day trading. We enhanced the application, built a BI module, and did survey for end-of-life for the application

Responsibilities:

•BI Reporting - built and tested, from scratch. A whole new BI reporting module

•Requirements gathering sessions with clients, defect management and BA related daily activities

•Used Microsoft SQL Server for SQL query into the relational databases.

•Project decommissioned March ’13. Upper management wanted to move to .NET framework, and transfer all legacy data & business logic into a new application.

Environment:

HP ALM, HP UFT, Microsoft SQL Server, .NET Framework, Waterfall/Agile

Bank of New York Mellon, King of Prussia PA Jul ’10 – Aug ‘11

Role: QA/BA

BNY is a global financial services company established in June 9, 1784, making it the oldest bank in the USA. The projects I worked on are AdvisorPort, BPM and PNCI-HIL conversion.

Responsibilities:

•Extensive Regression Testing, System testing & Sanity check pre-UAT

•Instead of manul testing with code deployment or data load ingestion, Implemented QTP automation stability testing daily as part of Test Driven development.

Environment:

QTP, SQL Server, Excel, Lotus Notes, Quality Center/ALM, Waterfall

AT&T, Chicago IL Oct ‘08 – June ‘10

Role: QA/BA

In business for more than 100 years, AT&T is the largest communications company worldwide. The projects I worked on were Threat Management Solution, SolutionFit and Palm Pre emulator.

Responsibilities:

•Setup the 'rules of engagement' document with client, for implementation of SSIS as the data warehousing tool to import/export (ETL) SSIS packages.

•Mobile requirements, analysis & testing was done on network connectivity, fluctuation in signal based on location, notification testing, Interface and Service testing.

•Using SQL-based Aqua Data Studio, we tackled back-end and front-end testing for SolutionFit.

Environment:

SQL, SSIS, UNIX, Aqua Data Studio, AIP Ticketing System, Agile

Rydex Investments, Rockville MD Apr ‘08 – Aug ‘08

Role: Business Analyst/QA Tester

Rydex Investments manages more than $16 billion in assets via more than 80 mutual funds and exchange traded products. My Project - MarketWatch Replacement Pages (MRP), required us to replace all the pagescsupported by an outside vendor called MarketWatch, to internal server.

Responsibilities:

•Used UML/Rational Rose to make an Object Oriented model

•Migrated data from external repository to internal data warehouse (SQL Server 2000) & tested.

Environment:

Quick Test Pro, ALM, SQL Server, Windows XP, ClearQuest, Rose, MS Visio, Agile

Verizon Wireless, Herndon VA Nov ‘06 – Apr ‘08

Role: Performance Engineer

Verizon Wireless is the largest wireless communications provider in the U.S. is the largest mobile network operator in the United States, providing wireless services to 119.4 million subscribers. The project I was working on was called FTS Inventory/iMigrate

Responsibilities:

•Created/modified data in TOAD for Oracle 9.5 using SQL scripts (back-end) and verified on front-end

•ETL migration testing, old-to-new db, including batch jobs and millions of records of data migration

Environment:

QTP, TOAD for Oracle 9.5, Windows XP, SQL, ClearQuest, Waterfall methodology

Contact this candidate