Quality Assurance Life Cycle

IMRAN AHMED

** ****** **** **.

Markham ON – L*S 2Z2

Phone: 416-***-****

Email: *******@*******.***

SUMMARY

●Over 18 years of experience in Quality Assurance and support of business applications in Cloud, Mobile, Web Services, RESTAPI, Web, Client/Server and Mainframe environments.

●Extensive experience in both Manual and Automated testing.

●Extensive experience in Credit Card, Mortgage, Line of Credit (PLOC, HELOC), Insurance and TSYS Applications.

●Expertise in QA Costing/Sizing, Test Strategy, Test Plan, UAT Plan, Test Cases, Data Preparation, Test Execution, Test Documentation, Defect Tracking and Traceability Matrix preparation.

●Excellent performance in Functional, System Integration, End to End, Interface, Regression, Conversion, Migration, Compliance, User/Business Acceptance (UAT/BAT), Load, Performance and SOX testing.

●Experience working on data intensive projects in the Banking,Transit and Insurance domains.

●Active role in Requirements review, Test Strategy/Plan/Case document reviews.

●Expertise in QA Methodologies, Quality Assurance Life Cycle, Defect Management Life Cycle, Software Development Life Cycle (SDLC) and CMMI methodologies.

●Strong testing Quality Assurance experience within Agile environment.

●Experience in Mobile and Web services Automation using ParaSoft SOA Test tool.

●Created Test Cases using HP ALM and logged defects in JIRA.

●Experience in testing warehouse in ETL environment with skills to build and execute complex queries for data mining and conditioning using SQL.

●Excellent analytical, problem solving, decision-making and presentation skills with ability to co-ordinate activities in a fast paced team environment.

●Strong Team player, Ability to work productively and effectively in a team as well as individually.

●Strong communication and interpersonal skills.

●Earned reputation for meeting demanding deadlines and delivering critical solutions on various levels of Quality Assurance.

●Experience with CA TDM tool, Bit Bucket, Jenkins and familiarity with Delphix.

WORK EXPERIENCE

Jan 21 – Present. Senior Quality Assurance Analyst

Longview Systems

Clients: Royal Bank, Equitable Bank, Crosslinx Transit Solution, HydroOne, FCT, Calgary parking Authority, CPPIB, Extendicare, IGM and OMERS.

Recent Projects: RBC Payedge Azure Migration, Eglinton Crosstown LRT, OMERS - MIP and Records Retention, Extendicare - Microsoft Teams Phone System, EQB Laptop Deployment, EQB Windows Virtual Desktop Rollout, EQB Azure AD Redesign, IGM Cloud Monitoring and Alerting.

●Participated in creation of SOW and WBSdocumentsfor Transit, Cloud Migration, Banking, Long-Term care and Utility applications.

●Created Test Plan, Test Cases, Test Signoff, Defect and Final Test report.

●Performed Factory Acceptance Test (FAT), Site Acceptance Test (SAT), Post Implementation Checkout Test (PICO), Functional, System Integration test (SIT), Regression, End to End, Migration, User Acceptance (UAT).

●Prepared Test Data, Executed Test and validated the Test Cases adhering to quality standards.

●Documented software defects using bug tracking system and reported defects involving program functionality, output, online screen and content to software developers.

●Develop parameter driven ETL process to map source systems to target data warehouse.

●Participated in End to End Testing activities and interacted with business and technical stakeholders for clarifications and issues.

●Worked closely with Development, Environment, Business and interface application teams.

●Facilitated & Moderated both internal and external reviews of Test Plan, Test Cases and UAT.

May 18 – May 20. Senior/Lead Quality Assurance Analyst

TD Bank.

Project: IRM (International Remittance Market Place)

●Served as Senior QA in fast paced Agile environment with Multiple Upstream, Downstream and third-party financial software applications.

●Review stories in backlog to estimate the refined stories in the sprint based on QA team capacity.

●Participated in Daily scrum, backlog refinement, sprint planning, retrospective and review/walkthrough sessions.

●Chaired daily QA status meeting with onshore and offshore team members to assign and track daily test activities and execution status.

●Coordinated with various teams Western Union, Visa, CITI bank, FIS, Fraud, Sanctions and Service virtualization teams to test Functional, E2E, Edge and Error Scenarios.

●Create Test Plan, Test strategy, Test cases and Automated Test scripts using Parasoft SOA Test, Postman and SOAPUI.

●Scheduled and chaired Test Plan, Test case review sessions, Test Closure and Sprint end reports.

●Planed and created automated scripts for REST-API testing and Integrated features to regression and smoke suites after each release.

●Test data was fetched from the test set using CA TDM tool and created/updated on host (CIF, DAS & TDW systems) to meet the test data requirements.

●Performed Web Services and Rest API Test execution using Parasoft SOA Test tool and logged execution artifacts on Jira.

●Chaired defect triage meetings and followed them through closure.

●Prepared and presented DEMO to the entire team after each Sprint completion and Showcase to the executives after each release.

●Supported Easyweb, Mobile, E2E, BAT and PAT teams.

Oct 17 – Apr 2018 Senior ETL / Quality Assurance Analyst

IBM / CIBC Bank.

Project: Claims Resolution Service

●Served as an ETL QA lead for data migration between CRS, EDH and DSE/Netezza applications.

●Developed Test Plan based on technical specifications/Data design documents and source to Target mappings.

●Chaired daily Team and Defect meeting for defect Tracking, Execution status and work assignments.

●Developed and Documented Test scenarios and Test cases in HP ALM in accordance with the Business Requirements Documents.

●Performed Functional, System Integration, Regression and User/Business Acceptance (UAT).

●Performed Raw Readable Extract Validation for data extracted from CRS (Pega PRPC) into 6 XML files.

●Developed complex SQL queries against EDH Hive tables using HUE editor for data verification process.

●Data Validation was performed between EDH to DSE/Netezza Staging tables and Netezza Master (20 tables) using Aginity workbench.

●Extracted source XML files were patched for negative and historical test scenarios.

●Escalated issues and coordinated with CRS, EDH and DSE/Netezza teams to schedule Autosys Jobs.

Mar 17 – Sep 17 Senior Quality Assurance Analyst

IBM / CIBC Bank.

Project: Cheques and Remittances – PSH (Payment Services Hub)

●Performed Functional, System Integration, Regression and User/Business Acceptance (UAT).

●Coordinated with the offshore team on a daily basis for status and work assignments.

●Developed and Documented Test scenarios and Test cases in HP ALM in accordance with the Business Requirements Documents.

●Performed Batch level and Payment level validations for various Payment Types sent by the client (ACH, EFT, Wire, Standalone Remittances and Cheques) to PSH.

●Prepared Test data in XML and Flat file formats for Credit and Debit (real time and near real time) transactions in various currencies for all Payment types.

●Prepared Test data using integrated file which provided the ability for clients to send multiple Transactions of different Payment types in single file.

●Verified File level and Payment level details in various Tabs and Fields on PSH application after loading the files to Landing zone using WinSCP in FTS and SCA channels.

●Raised and tracked Defects using ALM.

Nov 16 – Feb 17 Test Data Manager

TD Bank Mississauga ON.

●Managed Test Data across project teams within the shared Release test environments.

●Created and Maintained Test Data in the restricted access PAT environments for Easy Web, Web Broker, OSO, IOL, TDI, CIP, Mobile, Smartphone & Tablet teams.

●Performed Back end Testing-using SQL queries, generating reports to ensure data integrity and validate the inserted and updated data.

●Created and managed large volumes of data for Performance group (PCoE) in PAT environment.

●As a Test Data subject matter expert, provided guidance to testing teams to Create/Maintain test data in the pre-PAT environments (SYS, DEV & BAT).

●Processed Cobol/JCL jobs for posting Financial Transactions and Setup test data on CICS, IMS DB/DC, VSAM Files and DB2 tables.

●Worked closely with PMs, Test Managers, IT specialists and Architects of project teams to support their initiatives.

●Identified, developed and implemented improvements and standards to enhance test data management and test data creation efficiencies.

●Worked effectively in a team environment and interacted with all levels of personnel from various functional areas.

July 16 – Nov 16 Senior Quality Assurance Analyst

IBM / CIBC Bank

Project: Fraud System Replacement

●Performed Functional, System Integration, Regression and User/Business Acceptance (UAT)

●Coordinated with the offshore team on a daily basis for status and work assignments.

●Developed and Documented Test scenarios and Test cases in HP ALM in accordance with the Business Requirements Documents and the Functional Requirements Specification documents.

●Prepared Test Data, Executed test, Validated the test cases documented defects in ALM.

●Posted various Monetary and Non-Monetary transactions through Visa Test System (VTS), Master Card Simulator (MCS) and TSYS Screens.

●Verified the Newly created Near Real Time (NRT) Feed an XML file layout, Hierarchy structure, TAG names, data values and sequences are correct.

●Verified newly created daily CardGuard file from TSYS into the Mainframe Landing Zone for the transactions coming through various inputs.

●Created a formula based excel spreadsheet to convert the Flat file in to Excel by field length.

●Verified DSE/Netezza tables and daily reports generated.

Aug 15 – July 16 Senior Quality Assurance Analyst

TD Bank

Projects: ATM Cheque Imaging, Visa Tokenization Services (VTS), Mobile Investment Transformation (MIT) and Digital Data Repository (DDR).

●Developed and Documented Test scenarios and Test cases in HP ALM in accordance with the Business Requirements Documents and the Functional Requirements Specification documents.

●Coordinated with the Project Managers, Business Analysts and Developers, analyzed requirements needed for successful Test Plan and Test Case creation.

●As a member of the Agile (Scrum) team participated in daily standup meetings, project status meetings and reviews.

●Created SOA test scripts using Parasoft SOA Test web services automation tool.

●Responsible to verify Web services API request, Response data validations in REST, SOAP protocols.

●Performed Functional, Regression, System Integration and Business Acceptance Testing of the application.

●Performed Manual test by submitting Cobol/JCL jobs for posting ATM and POS Real time transactions for frontend Mobile application.

●Setup test data and Verified Data on CICS, IMS DB/DC, VSAM Files and DB2 tables.

●Prepared Test Data by setting up Accounts for transaction posting using SQL queries and developed SQL queries to test the data after executing various transactions processing and check processing.

●Executed test cases and documented bugs found during the process of testing.

●Detected and Classified defects based on the severity and Reported defects in JIRA defect tracking tool.

Feb 14 – Feb 15 Test Data Manager

TD Bank Mississauga ON.

●Managed Test Data across project teams within the shared Release test environments.

●Created and Maintained Test Data in the restricted access PAT environments for Easy Web, Web Broker, OSO, IOL, TDI, CIP, Mobile, Smartphone & Tablet teams.

●Performed Back end Testing-using SQL queries, generating reports to ensure data integrity and validate the inserted and updated data.

●Created and managed large volumes of data for Performance group (PCoE) in PAT environment.

●As a Test Data subject matter expert, provided guidance to testing teams to Create/Maintain test data in the pre-PAT environments (SYS, DEV & BAT).

●Processed Cobol/JCL jobs for posting Financial Transactions and Setup test data on CICS, IMS DB/DC, VSAM Files and DB2 tables.

●Worked closely with PMs, Test Managers, IT specialists and Architects of project teams to support their initiatives.

●Provided estimates for each project based on BRD/SRS reviews, Team meetings and analyzing Test Data requirements.

●Participated in yearly PAT refresh activities.

●Identified, developed and implemented improvements and standards to enhance test data management and test data creation efficiencies.

●Worked effectively in a team environment and interacted with all levels of personnel from various functional areas.

June 13 – Dec 13: Senior Quality Assurance Analyst

Equitable Bank Toronto ON.

●Performed Functional, System Integration, Regression and User/Business Acceptance (UAT) of Mortgage Only, Standalone HELOC and Combined Mortgage & HELOC components.

●Performed System Interface testing between Portfolio Plus (PPlus), Fidelity Information Services (FIS), Clarity and Fidelity National Finance (FNF) systems.

●Prepared Test Scripts for Adjudication/Underwriting, and Funding of Mortgage, HELOC and Combined Mortgage & HELOC components.

●Created Calculators using MS Excel for GDS, TDS, LTV and Mortgage and HELOC Interest Calculations.

●Prepared Test Data, Executed test and Validated the test cases adhering to quality standards.

●Documented and reported defects with severity and critical pieces of information/artifacts.

●As a Data Manager Created, Maintained and Managed Loans through Filogix and Direct entry to PPlus for Functional and Business User groups (12 members).

●As a Data Manager Created, Maintained and Managed Access Card Accounts (Visa) in FIS for Functional and Business User groups (12 members).

●Identify Test scripts, Setup Test data and Supported Business User testing.

May 05 – April 13: Lead/Senior Quality Assurance Analyst

Bank Of Montreal Toronto ON.

Recent Projects: MACH2 (TSYS), CIS2, E-Statements, Mobile Pay Pass Sticker, TSYS Conversion, CHIP phase1 and phase2, Online Banking Bonus Points, Transaction & Payment processing, Cost of Borrowing, Life & Disability Insurance.

●Created Costing, Sizing, Test Strategy, Test Plan, Test Signoff, Defect and Final Test report.

●Documented Test scenarios and Test cases in HP ALM in accordance with the Business Requirements Documents and the Functional Requirements Specification documents.

●Worked with Project Managers to schedule and monitor testing resources for projects.

●Create a batch processing schedule and coordinated with the Environment team for each release.

●Monitored the progress of the team member’s work through weekly status meetings to ensure that deadlines are met.

●Performed Functional, System Integration, Interface, Regression, End to End, Conversion, Migration, Compliance, Regulation, User/Business Acceptance (UAT/BAT).

●Prepared Test Data, Executed test and validated the test cases adhering to quality standards.

●Documented software defects using bug tracking system and reported defects involving program functionality, output, online screen and content to software developers.

●Develop parameter driven ETL process to map source systems to target data warehouse.

●Developed SQL Queries and Artifacts to validate the Completeness, Integrity and Accuracy of Data within an ETL process testing cycle.

●Participated in End to End Testing activities and interacted with business and technical stakeholders for clarifications and issues.

●Extensive data base (DB2) testing using SQL queries.

●Processed Cobol/JCL jobs for posting Financial Transactions and Setup test data on CICS, IMS DB/DC, VSAM Files and DB2 tables.

●Wrote SQL Statements to extract Data from Tables and to verify the output Data of the reports.

●Managed and executed SOX test for various complex ITACS for past 6 years.

●Worked closely with Development, Environment, Business and interface application teams.

●Provided training through Orientations, Presentations and system walkthroughs to new staff.

●Created and shared three complex Calculators using MS Excel for Interest Calculation, Time To Pay and Insurance Premium Calculation.

●Facilitated & Moderated both internal and external reviews of Test Plan, Test design and UAT.

Jan 05 – March 05: Quality Assurance Analyst

Bank Of Montreal, Toronto ON.

GCMS 5.1(MasterCard international)

●Perform Functional, System Integration and Regression testing of MasterCard International mandatory release under Mainframe environment.

●Prepare Test Data, execute Test Plan, setup test environment and define Test Cycles.

●Ensure end-to-end testing including documentation, internal/external interfaces, and code promotions.

●Performed Back end testing using SQL queries to access the database (DB2).

●Track and raise defects using work order system and follow up with development. Verify fixes for reported defects when the fixes are provided.

●Verify outgoing / incoming interface files and reports of MCI international and DOL system.

May 04 – Oct 04 Quality Assurance Analyst,

IBM /Bank Of Montreal Toronto ON.

CDF Conversion & Calgary Phase II

●Perform Functional, End to End and MasterCard International Certification testing of Corporate Credit Card Application under Mainframe environment.

●Determine and set up test data, Execute test plan, Set up test environment and Define test cycles to perform DOL, CDF E2E conversion and MCI certification testing.

●Perform Manual and Back-end testing using SQL in DB2 database.

●Track and raise defects using work order system and follow up with development. Verify fixes for reported defects when the fixes are provided.

●Download the new XML file after each cycle end to Internet Explorer and verify XML file layout, Hierarchy structure, TAG names, data values and sequences are correct.

Feb 03 – June 03 Quality Assurance Analyst

IBM/Bank Of Montreal, Toronto ON.

Pumpkin (Phase II)

●Perform Functional, System Integration and Regression testing of Credit Card Application under Mainframe environment.

●Prepare Test Data, execute Test Plan, setup test environment and define Test Cycles that test the system through all facets of time.

●Ensure end-to-end test documentation, internal/external interfaces, and code promotions.

●Created and executed new test packages for Daily, Weekly, Monthly and On request outgoing interface files.

●Performed Back end Testing-using SQL queries, generating reports to ensure data integrity and validate business rules.

●Verify Reports, Statements, Audit file, Activity log and online screens.

Sept 02 – Jan 03 Quality Assurance Analyst,

Sunlife Financial / Clarica, Waterloo ON.

Clarica to CI Conversion

●Develop test cases to cover end-to-end testing throughout the project lifecycle to ensure delivery of quality product.

●Identify test data and ensure adequate coverage for all scenarios based on Application Risk Assessment.

●Develop a risk-based testing approach to help meet tight deadlines and avoid over testing.

●Prepare and maintain problem logs.

●Extensive database testing on DB2, IMS, SQL Server and MS Access.

●Developed techniques to scan voluminous data and verify correctness of data being transported.

Jan 02 – July 02 Quality Assurance Analyst

Price WaterHouseCoopers/ Bank Of Montreal)

Pumpkin

●Perform Functional, System Integration, Regression and User acceptance testing of Credit Card Application under Mainframe environment.

●Prepare Test Data, execute Test Plan and define Test Cycles.

●Ensure end-to-end testing including documentation, internal/external interfaces, code promotions and converted data are successfully completed from business requirement definition.

●Tested backend databases using SQL Queries.

●Track and raise defects using work order system and follow up with development. Verify fixes for reported defects when the fixes are provided.

●Verify Reports, Statements, Audit file, Activity log, fulfillment files and online screens.

July 99 – Mar 01 Programmer Analyst

McDowell Tucker & Co. Inc. Dallas, TX.

LightYear

●Manage the development, organization, and execution of automation scripts using Silk Test 5.0, including code reviews.

●Create Macros using MS Visual Basic for applications, to help facilitate captures data stored in the Excel spreadsheet and exports it to a series of data files facilitating the automated testing efforts.

●Plan various test permutations and influence the testing of software applications, and related technical documents.

●Performed Integration (Structural and Functional) and System (Installation, Operational, and Performance) testing for nine individual Client-Server applications.

June 98 – July 99 Greater Southern Life

Programmer

●Coded programs after analyzing the program specifications in detail using VS COBOL II.

●Migrated IMS DB/DCsystemto VSAM file structure underMVS environment, Determined record layout of datasets using FILE AID.

●Converted DLI calls to VSAM file structure by coding batch and online CICS COBOL programs.

Dec 96 – May 98 Vetri Software India Ltd. Chennai, India.

Programmer,

Feb 96 – Dec 96 Software Solutions Integrated, Hyderabad, India.

Programmer

TECHNICAL SKILLS

●LANGUAGES: COBOL, CICS, JCL, SQL, Visual Basic

●WEB APPLICATIONS: Mobile, Online Banking & Capital Markets applications.

●DATABASE : MVS, DB2, H62, IMS DB/DC, VSAM, Oracle (7.x), SQL Developer.

●TESTING TOOLS: Parasoft SOA, HP QC, HP ALM, SOA, JIRA, CA TDM tool, JMeter, WinRunner

●Tools: TSO/ISPF, Catalog Manager, SQL, File Aid, Expeditor, QMF, Query Analyzer, INSYNC, SPUFI, PVCS, SharePoint & StarTool.

●Office Tools: MS-Office, Visio

EDUCATION:

●MS in Computer Science, Osmania University, India.

●BS in Computer Science, Osmania University, India.

REFERENCE: Available upon request.

Contact this candidate