IMRAN AHMED

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

Markham ON – L*S 2Z2

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

Email: ad3d55@r.postjobfree.com

SUMMARY

Over 18 years of experience in Quality Assurance and support of business applications in Cloud, Mobile, Web Services, REST API, 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, 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 WBS documents for 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 under MVS 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