Objective: Positions as Senior QA/BA/ QA Lead
Highlights of Qualifications
Over 16 years’ in Business Analysis, Software Quality Assurance and Application Support experience
Experienced in developing systems test plans, test cases and test scripts, scheduling and resource planning
Experienced in business analysis, documenting functional/business requirements and writing use cases, based on information gathering sessions with clients/stakeholders and technical team members
Developed complete testing and business documentation and performed various types of testing: functional, non- functional, regression, integration, system and more.
Co-ordinated User Acceptance testing in the UAT environment for business users prior to Production stage.
Tested applications in Waterfall and Agile development processes
Experienced in creating appropriate test data and automated test scripts
Experienced in projects involves an online application designed for Portfolio management and Customer Access System for the end User
Led teams in QA Projects Testing Onsite /Offshore
Good knowledge and experience in Automation tools and Defect tracking tools
Hands on experience in databases, writing SQL queries, data manipulation
Knowledge and experience of all phases of the Software Development Life Cycle (SDLC)
Extensive experience in ETL/ Data warehouse backend testing and BI Intelligence reports testing
Extensive experience with Financial, Health and Business Intelligence (Cognos BI) applications
Excellent analytical and problem-solving skills
Self-motivated team player with proven leadership skills
Testing Tools: HP QC/ALM, Jira, QTP/UFT, Silk, TFS, Rational ClearQuest, Test Complete and Loadrunner
Environment: WINDOWS, UNIX, SharePoint, MAINFRAME, XML, Web Services, HL7,
Team Foundation Server, SQL, C/C++, VBScript, Computer Aided Software Engineering (CASE) tools UNIX, Linux, ITIL, HTML, C#, JAVA, XML, NETSCAPE/ iPLANET, ASP, COGNOS BI Reports, SIEBEL CRM, MS-IIS, WebSphere Portal, APACHE, .NET, JCL, ETL, DATA WAREHOUSE Client/Server, MS Visio, MS PowerPoint
Databases: ORACLE, MS SQL Server, MS-Access, SYBASE, DB2, INFORMIX, MySQL
Employment History and Related Experience
Socan, Toronto ON
Senior QA/BA Analyst 03/2017-11/2017
Environment: MS SQL Server, ETL/Data Warehouse. Team Foundation Server (TFS),Cognos BI
Worked across multiple functional projects to understand data usage and implications for data migration.
Assisted in designing, planning and managing the data migration process.
Created Use Cases and Activity Diagrams thus defining the Business Process Model.
Performed source system data analysis to manage source to target data mapping.
Performed migration testing of data in source and target systems using SQL.
Autodata Solutions, London ON 08/2016-02/2017
QA Team Lead
Environment: ETL/Data Warehouse, Web Services, SQL Server, Jira, Dynamics CRM, SaaS, Azure, Mongo
Managed QA Onsite/Offshore QA team for various Autodata projects.
Coordinated meetings with Project Managers to understand projects schedules to set QA priorities.
Created QA estimates, Test Plans and Test Strategies.
Promoted to serve as lead QA tester, overseeing quality-assurance testing and teams for client software and systems development projects. Performed system, regression and data interface testing.
Managed test execution status for all phases in testing process and conducted knowledge transfer sessions.
Facilitated Defect Triage meeting. Informed senior management of risks / issues discovered while testing.
Lead the UAT effort and arrange/facilitate UAT testing sessions.
Ministry of Health and Long-Term Care, Toronto, Canada 09/2015-04/2016
Projects: Self Reporting Initiative (SRI), ItelliHealth (Data Migration)
Environment: ETL/ Data Warehouse/SQL, Cognos, Informatica, SharePoint, Oracle, Toad, Rational ClearQuest
Developed documentation for Ministry SRI and ItelliHealth (data migration) applications.
Developed complex SQL queries for querying data against different data bases for data validation.
Developed ETL test scripts based on technical specifications, design documents and data mappings.
Performed Dimensional and Statistical Analysis and Data Quality Validation in Data Migration.
Extensively tested various Cognos financial reports for data quality.
Cancer Care Ontario, Toronto Canada 11/2014-06/2015
Senior QA/BA Analyst
Project: Ontario Renal Reporting System (ORRS)
Environment: TFS, C#, SQL Server, Data Warehouse, Siebel CRM, DataStage, Agile
Created and executed test cases for various testing such as functional, system, regression, UAT and more.
Defined the processes and procedures required to ensure an acceptable level of application and clinical data. quality and worked well with the business / stakeholders and users to gather and prepare testing requirements.
Tested DataStage jobs for moving the data to multiple databases and transforming the data.
Created Test Strategy & Test Plans, prepared test data for a complete set of Test Cases.
Created SQL scripts and automated programs to verify reports and back end database of all pre-dialysis, acute dialysis and chronic dialysis patients in Ontario.
Reviewed Data Models and Business Requirements Definition (BRD) document for Renal Reporting System.
International Financial Data Services (IFDS), Toronto, ON Canada 09/2004-12/2005 & 06/2014-11/2014
Senior Quality Management Analyst/Business Analyst/Application Support
Project: iWeb plus
Environment: iFast, SharePoint, HP ALM/QC, HP QTP, API, XML, SQL, ETL, Soap UI, BI, Siebel CRM, Agile
Prepared business and testing documentation for Mutual and Segregated Funds complexity for Portfolio management and Customer Access System for the end User using iFast.
Created API XML requests and analyzed response files.
Coordinating the document controls of technical submittals, drawings.
Executed functional, non-functional, integration and regression testing. Logged defects and verified fixes.
Provided testing status report to the project.
Performed integration and implementation of application configuration changes.
Researched, analyzed, tested, debugged applications and provided support to clients.
Ministry of Education Ontario, Toronto ON 03/2014-06/2014
Senior IT Consultant
Environment: .Net, SharePoint, XML, SQL, Visio, HP QC, MS Project, QTP 10.0, COTS, Cognos BI
Project: Enhanced Data Collection.
Developed and documented business rules for Application (EDU) functionality.
Implemented the automation of new and existing testing scripts using Quick Test Pro.
Created used cases, test cases and test scenarios.
Performed functional, regression, performance and security testing and reported defects.
Tested and maintained software applications to ensure compliance with all provincial regulations.
Accenture, Toronto ON 11/2013-02/2014
HL7 integration Analyst/Coordinator
Environment: SharePoint, HL7, EHR, XML, MS SQL Server, .NET, BizTalk, TFS, Agile
Project: WRIS-Wait Time Information System for Cancer Care Ontario.
Provided input into test plan and approach.
Coordinated HL7 integration – prepared HL7 messages and interpreted response.
Manipulated data directly in a database using TSQL queries.
Created test cases, identified, triaged defects and verified defect fixes using TFS.
Tested the solutions in terms of functionality, performance, reliability, stability, documenting and communicating any issues or risks identified during testing.
Performed accessibility testing, used to test the application by different roles to test the access to different kinds of users for different modules/links in the application.
M&T Bank, Buffalo, NY, USA 04/2013-11/2013
Business Analyst/Application Support Analyst
Project: Banking Mobile Application
Environment: SharePoint, .NET, Microsoft CRM, Cognos BI, ETL, RUP, UML, SQL, QTP 10.0, MS PowerPoint
Gathered software and systems requirements from business owners and presented to development staff. The Projects involves an online application designed for Portfolio management and Customer Access System for the end User
Involved in the creation and maintenance of the business requirement documents and use cases.
Created Use-Case Models in various Business Processes.
Consistently provided application and system support for several internal departments.
Developed, coordinated, and maintained process mapping activities and documentation.
Created and executed manual and automated test cases and scripts for functional and non-functional testing, SIT, UAT and more
Coordinated the activities of an offshore development team.
Alberta Health Services, Calgary AB 01/2012-09/2012
Senior Quality Assurance Coordinator/Application Support Analyst
Environment: UNIX, HL7, EHR, Cognos BI, XML, COTS, ETL, Jira, Silk, HP QC/ QTP, MS Dynamics CRM
Project: Clinical Critical Care Information System
Coordinated smoke, security, integration, functional, system, regression, usability, user acceptance, release
testing and managed the defect lifecycle on Jira.
Dedicated in functional testing for MS Dynamics CRM and web-based applications.
Tested Portal Enhancements application integrated with COTS ministry applications.
Interacted with business, development, testing, and project management team.
Conducted risk analysis, verification and validation testing to confirm to industry and government regulations
Reviewed and supported Clinical Data testing process. Installed or deployed the CSC and CCCIS.
Created and updated test scripts for automation testing using Silk Test.
Supported in the entire software development life cycle.
Canadian Tire, Toronto ON 04/2011-10/2011
Senior QA/BA Analyst
Environment: Win 7, .NET, MS SQL Server, HP QC, ETL, DataWarehouse, BI Reports, SharePoint, Team Foundation Server, CASE, SQL, Siebel CRM, MS PowerPoint, POS, Rational ClearQuest, Agile
Project: Canadian Tire’s Loyalty Card Program for Retail stores
Worked in a test environment with a team of Developers, Business Analysts and QA testers.
Participated in gathering the system requirements for several releases of application.
Participated in Evaluation, Functional, Regression, Stress, Load, Integration, Installation, UAT and System Testing for Client / Server, web-based and Front-end GUI s applications.
Davis + Henderson, Toronto ON 02/2010-03/2011
Quality Assurance Product Analyst/Support Analyst
Environment: .NET, HP QC, SQL, TFS, XML, MS CRM, Oracle, ETL, Crystal Reports, SharePoint, QTP
Participated in Data Conversion Testing for Warehouse Management System.
Was involved in Business Workflow analysis, writing Test Plans and Documentation for them.
Supported procurement data entry activities in the project procurement database for all projects.
Designed and executed Test Cases and reported Defects using HP Quality Centre and MS Visual Studio.
Signifi Solutions Inc., Toronto ON 10/2009-12/2009
Senior QA Specialist Team Lead
Environment: .NET, Microsoft SQL Server, Jira, XML, QTP, Web Services, WebSphere, Card readers, Agile
Tested the Signifi specific hardware to insure compatibility and integration with the software applications.
Designed and wrote automation test scripts.
Performed Web Application and Web Services testing using SOAP UI tool.
Involved in Gap, Feasibility and Risk analysis of Vendor / Third Party Tools.
Proposing consolidation of templates.
Aviva Insurance, Toronto, ON Canada 12/2008/-08/2009
Senior QA/BA Consultant
Environment: Web-based, HP QTP, .Net, XML, Guidewire, RUP, UML, BI Reports MS Visio, Linux, CASE, ITIL.
Participated in gathering the system requirements for several releases of application
Performed Functional and Integration tests for Underwriting, Claims and Billing modules.
Validated the policy data and the acceptance of policy data by various peer systems.
Prepared high level and low design documents with class / sequence diagrams.
Ministry of Health and Long-Term Care, Kingston, ON Canada 11/2007-10/2008
Senior System Tester
Environment: Client/Server, Mainframe, TSO/ISPF, JCL, DB2, SQL Queries, Batch Processing, HL7, DW
Projects: THAS Download Systems Response, Update Primary Care Clinical Data Communication Routings
Created test plan, test scenarios and test cases using STS methodology and support system changes.
Executed batch testing in IBM mainframe DB2/IMS test environment.
Debugging the application in TSO and made changes to the values per Test Cases.
Reviewed and analyzed the Use cases.
Performed Gap Analysis.
Honda Financial, Toronto, ON Canada 06/2007-10/2007
Senior Quality Assurance Analyst/Business Analyst
Environment: Client/Server, Mainframe, ETL Batch Processing, HP Quality Centre, HP QTP, MS Visio, SQL
Performed various types of testing: regression, integration and system.
Updated test documentation and logged defects using Quality Center.
Participated in the BRD (Business Requirement Document) review with the QA Team.
Developed Test Plan and Test cases to meet functional requirements.
Navantis Inc, Toronto, ON Canada 10/2006-05/2007 QA Project Lead
Environment: Visual Studio(TFS), .NET, ASP.NET, ADO.NET, VB Script, SQL Queries, SharePoint Complete, QTP, HL7, VBScript, XML, Data Warehouse, ETL, Cognos BI Reports, Client/Server, LoadRunner
Project: Clinical Information System
Responsible for managing software QA for UHN and LHIN.
Supervised onsite QA team of 3 and outsourced testing team in Sri Lanka.
Verified that all the requirements mentioned in Business Requirement Documents are covered.
Provided user access level maintenance and support to enable system availability and reliability.
Cognos Inc (IBM), Ottawa, ON Canada 03/2001/-12/2002 & 05/2004- 09/2004
Senior Quality Assurance Analyst/Lead
Environment: SQL, MS-Access, MS Visio, Windows/Unix/Mainframe, WebSphere Portal, HTML, XML, APACHE, UNIX, iPLANET, ASP, COGNOS BI, MS SQL Server; SYBASE, DB2, ORACLE, ETL, DW, Client/Server
Acquired product knowledge of new Web-Based Cognos products and features.
Led teams in QA Projects and participated in UAT testing.
Martware, Inc. Toronto ON Canada 03/2003-03/2004
Quality Assurance Analyst/Business Analyst
Environment: Java, ORACLE, XML, SQL Queries, C/C++, Web Sphere Portal, MS Visio, WinRunner, LoadRunner
Performed Functional, GUI, Regression and UAT testing of new Stock Market Simulator.
Wrote functional requirements for interactive web sites based on information gathering from stakeholders.
Communicated and documented gaps, risks, anomalies of concern and escalate to manager as required.
Bank of Montreal, Toronto, ON Canada 10/2000- 04/2001 & 02/2006-06/2006
Quality Assurance Analyst
Environment: Client/Server, .Net, SQL Queries, IBM Web Services, Windows XP, Mainframe, Back-end /Front-end.
Tested applications designed for deployment at the Retail Branch level.
Executed Mainframe, System Testing in Software application involves Banking & Credit Cards.
Master’s Degree in Engineering (Communications and Informatics)
Available upon request.