Objective: Senior System Analyst-QA Specialist

Senior QA Specialist with extensive experience on Information Technology industry; successfully managed highly complex quality assurance assignments through various projects’ and programs’ lifecycles for large organizations

Summary

Solid experience in Information Technology with emphasis on Software Testing/Quality Assurance.

Strong hands on experience with the Quality Assurance Life Cycle process, Quality Assurance metrics, Software Development Lifecycle (SDLC) through various tests: Functional, Integration, User Acceptance Testing (UAT) in Waterfall and Agile environments.

Excellent experience in defining testing methodologies, QA estimates, designing Test Strategy, Test Plans and Test Cases, verifying and validating web based and client server applications and effective QA implementation in all phases of SDLC.

Lead/Hands-on testing for End-to-End tests of manual and automation projects for online, client server and web based applications, web services, batch jobs and reporting solutions.

Professional experience in Analyze, Plan, Design, Build, Implement, Run, Maintain new and existing automation testing frameworks & scripts as required for building up test suites using QTP and QC.

Strong knowledge of UNIX and Windows platforms, relational databases, such as Oracle, Microsoft SQL Server 2005/2000, DB2

Solid experience in database integrity testing by writing and executing complex SQL statements.

Extensive experience in developing and testing web services using SoapUI/Ready API, and Restful Client tools.

Solid experience in analyzing data mapping specifications, HL7 V2/V3 specifications and queries.

Remarkable experience in performing Black Box, Smoke, End to End, Functional(FIT and SIT), Back End, Cross Browser, Cross Platform, Regression, API and UAT testing.

Hands-on experience in AAA protocol security and certificates x509 using Ready API. Created user roles (SuperUser, Provider, System, Adopter) for testing Masking policies within PCR/PR/PPR projects – this is based on SAMLs. Performed security and penetration testing – Web GUI application or through web services.

Great experience in testing COTS (Commercial Off-The-Shelf) applications.

Hands-on experience with data migration: Ontario Provincial Provider Registry project – data validation between source (DB2/Mainframe and SQL server) to IBM MDM solution on Oracle.

High expertize in designing test coverage matrix, test scenarios, test cases and quality acceptance criteria. Experience on walkthrough QA deliverable with business stakeholders and sign-offs processExceptional liaison abilities with business analysts, developers and technical support to assist in resolution of technical issues.

Excellent interpersonal skills, ability to work independently or as a productive team player, great oral and written communication skills, presentation skills, negotiation skills, problem-solving, decision-making, motivational, analytical skills, strong attention to details and a quick learner.

Technical Summary:

Tools:

SoapUI Pro 4.5.1 - 5.2 (XML & REST messages)/Ready API 1.9,Postman, Altova XML Spy, 7Edit, IBM Rational Quality Manager/CCM 5.0 Jazz Platform, IBM Rational ClearQuest 7.1.2, MS TFS 2010, MS Visual Studio, Mercury’s Test Director/QualityCenter, HP QTP 10, Bugzilla, Jira, MS TFS 2008, IBM Rational Team Concert, Informatica 8.6.1, 7.1.1,, Data Stage, Office 2016, 2013, 2010, 2007, 2003, 2000, ’97, '93, Lotus Notes, MS Word, MS SharePoint, MS Excel, BrowserStack

SOA, Web Services & ESB and Applications:

DataPower XI52 (IBM WebSphere DataPower SOA Appliances-Gateway & Backbone), IIB (IBM Integration Bus), WSRR (IBM WebSphere Service Registry and Repository), IBM MQ Explorer, forCare IHE (forView, forAudit), XDS (Cross Enterprise Document Sharing), DICOM

RDMBS/ Databases/SQL Tools:

Oracle9i/10g, MS SQL 2005 and 2008, Oracle SQL Developer, Toad for Oracle9i, IBM Data Studio, MS Access, DB2, SQL Navigator, MS SQL Server Management Studio

Operating Systems:

Windows NT/2000/XP/2003/7 Enterprise, Windows XP, UNIX (AIX, HP/UX, SUN OS, Linux)

Other Technologies

J2EE, .NET, COM, Putty, WinSCP, Citrix, WebSphere, JBoss, Tomcat, WebServices, SFTP,

Alfresco, ORION (COTS – application), Forcare (COTS application), HIPAAT (COTS solution)

Healthcare Standards:

OCAN, RAI MH, RAI-MDS, RAI-CHA, DATIS (Addictions), EMPI, HL7 V2, HL7 V3, HL7 FHIR, IHE standards, DICOM images, CDA, Document Repository, Document Registry

Experience Programming

in :

C/C++, COBOL, PRO*C, PL/SQL, SQL, Java, VB, HTML, XML, Java Script, C#, ASP.NET, Perl, XML, XPath

Professional experience

HBC, Toronto, ON May 2018 – Present

Role: Senior QA Specialist

Projects Delivered:

Tulip Retail is the first mobile platform built exclusively for store associates. Leading retailers like Saks Fifth Avenue, Coach, and Chanel believe in enabling the next generation of store associates with mobile technology using Tulip.

Responsibilities:

• Conduct thorough manual testing of mobile and web applications

• Performed cross-platform testing. Executed test cases on mobile and android devices as well as on different OS systems

• Maintain and execute the regression suite

• Design exhaustive functional, end-to-end and integration test scripts from User Stories and other technical specifications

• Test the underlying API web services using Postman

• Log and track defects in Jira

• Provide input to project plans and estimates

• Prepare test artifacts such as test plan, test strategy, test cases, and test status reports

• Proactively participate in improving the QA methodologies and processes

• Conduct test coverage demo with internal and client teams

eHealth Ontario,Toronto, ON March 2012 – May 2018

Role: Senior System tester/QA Specialist

Projects Delivered:

Integration Facility/PCIS QA activities for Data Power integrations with enterprise wide high volume transactional systems, web services, applications, databases in Service Oriented Architecture, being involved in HIAL, DICS, PPR, PCR/EMPI/Pubsub, SR, Data Power upgrades, forCare Upgrade, cSWO RCV, MCTP, CMTA, HIAL CDR and HIAL Enhanced Reporting Projects

Responsibilities:

• Analyze business requirements, creating Test Strategy, Test Plan, and Traceability matrix for functional and non-functional requirements, identifying and communicating gaps in design solutions; suggest improvements and enhancements

• Effective & efficient high level test scenario identification followed by detailed test case

writing for functional, form validation and security testing considering boundary value, data integrity, backward compatibility and negative test scenarios (IBM RQM)

• Test cases/scripts execution, defect reporting and bug fix testing using IBM RTC.

• Create manual and automation soap ui scripts in XML format (HL7) for multiple eHealth projects

• Write complex SQL queries to validate the data transformations in staging and integration schema

• Performed functional testing, system integration testing, UAT and performance testing for Ready API web services (SOA) applications on multiple healthcare projects

• Validated data flows from different applications through service oriented middleware (SOM) - flat files, data mapping, and data transformations

• Perform testing for web-applications ran on WebSphere application server

• Provide testing activities for PCR V3, PIX/PDQ V2 through FHIR based RESTful web services using XML and JSON formats

• Perform Security, Functional, Integration, System Integration, Conformance, Regression, UAT, SOA, Failover, and Roll Back/Forward testing, provide support to Performance activities

• Participate in UAT, providing expertise, support and troubleshooting for the connectivity with multiple adopters (DI, pcCDR, HIAL CDR, PCR/EMPI Legacy, Pubsub).

• Provide support with onboarding process of OACCAC client (integration of CHRIS with PCR)

• Perform Regression testing, maintaining integrity of the test scenarios, and identifying missing information

• Responsible for all IF Pre and Post Landing testing activities create test data, artifacts and reports in ITE, PST and PPE environments.

• Provide troubleshooting within the IBM Data Power XI50 appliance.

• Validated DataStage ETL transformations and jobs through multiple stages: College file to Landing Area (MS SQL), Landing to PPR MDM database (Oracle). Created test scripts for PPR Data Acquisition (LA to PPR MDM Oracle db, HL7V2 Oracle db, Panorama reporting).

• Performed load and performance tests for Pub Sub notification using LOAD UI tool.

• Tested AAA protocol security and certificates x509 using Ready API. Created user roles (SuperUser, Provider, System, Adopter) for testing Masking policies within PCR/PR/PPR projects – this is based on SAMLs.

• Analyze the trail of audit events that are generated by the applications and IF.

• Develop Testing Artifacts: End-to-End test scenarios, regression test suites, Test Status reports

• Upload Business requirements, test scenarios, test cases, test artifacts and defects to SharePoint.

• Track and analyze production issues

CCIM,

Ministry of Health & Long Term Care, Toronto Dec 2011 – March 2012

Role: Senior QA Analyst

Project Delivered: Quadrant HRIS project

Responsibilities:

• Reviewed requirements, release notes and design documentation.

• Created comprehensive Test Strategy, Test Plan and Exit Reports for SIT/UAT/PPT test phases as well as Requirements Traceability Matrix.

• Participated in project Gate meetings for SIT/UAT/PPT test phases.

• Planned and scheduled functional testing, regression testing and automated testing.

• Developed / updated and executed test cases for new and existing projects and reported on all type of testing including technical and business functional validation and application regression testing.

• Utilized JIRA as a defect management tool.

• Supported other analysts by reviewing project documentation and test cases and provided feedback.

CGI, Markham June 2011 – Dec 2011

Role: Senior QA Analyst

Project Delivered: Diagnostic Imaging Repository (Di-r) eHealth project

Responsibilities:

• Provided Subject Matter Expertise (SME) on eHealth testing activities,

• Designed and developed end to end project testing effort (including, but not limited to integration, system, and regression testing), reporting and escalation

• Responsible for creation of project Test Strategy, Test Plans, Test Cases, Scripts and Test Reports

• Estimated effort for test case design, development and test execution

• Provided oversight and reviews all project test deliverables

• Lead, coordinated and assisted with functional, system, integration, and performance testing in accordance with CGI, and IHE standards and processes

• Ensured coverage of testing as per the functional and non functional requirements (requirements traceability)

• Worked closely with Build and Infrastructure teams to ensure that the test environments are setup and ready for test execution

• Ensured Test Data Requirements are defined

• Recommended testing tools to be used (7Edit, ClearCanvas, DVTk, XDStoolkit)

• Participated in walkthroughs and reviews

• Raised issues and risks on a timely manner and helped identify mitigation plans

• Facilitated daily test defect review meetings and coordinate the implementation of defect resolutions across the various processing components/applications

• Prepared and provided test status updates (test progress reports, metrics, etc) from the QA perspective

• Documented assumptions, lessons learned and risk analysis on each test phase

• Ensured entry/exit criteria for each test phase is fulfilled

• Provided recommendations based on best practices and help implement test solutions

• Managed team of 3-6 testers, including hiring process and daily activities

• Prioritized and delegated tasks to team members, reviewed their work and provided feedback

• Trained testers and other team members in usage of different testing tools

• Supported to client testing activities (UAT, Post Prod, etc)

CCIM,

Ministry of Health & Long Term Care, Toronto June 2010 – June 2011

Role: QA Analyst/Tester

Project Delivered: Integrated Assessment Record (IAR)

Responsibilities:

• Applied Quality Assurance processes and methodologies at each phase in the SDLC of the Integrated Assessment Record (IAR) initiative, which allows Health Service Providers to view a client's previous assessment information, from the Pilot version to the Provincial Solution

Analyzed business requirements for the Provincial Solution, performed Gap Analysis, created detailed Test Cases and the Traceability Matrix; developed a comprehensive Test Plan.

Defined testing priorities, estimated testing effort, scheduled and allocated resources for UAT of the Provincial Solution.

• Created test cases for UAT and PPT deployments

• Prepared OCAN/RAI/DATIS test data in XML format and executed test cases to evaluate Manual, SFTP, and Web Service upload (WSDL)

• Prepared test data (HL7 messages) and performed both unit and system-integrated testing of EMPI (The Enterprise Master Patient Index) - a tool that stores and links demographic and selected personal information used by eHealth Ontario (http://www.ehealthontario.on.ca/programs/clientRegistry.asp).

• Conduct data testing within ETL process testing cycle

• Documented and managed defects in Jira, prepared reports for Triage meetings

• Maintained close communication with the development team, actively contributed towards building a vision for best outcome for the project

• Developed Java program for automated creation of large XML data files

• Created SQL scripts to generate metrics reports directly from the IAR application database

• Performed regression and sanity tests after each application release in SIT, UAT and PPT environments

• Tested Web Services, providing required input data to request XML and validated response XML

Simulated thousands of concurrent users for load scenarios to determine response times and bottlenecks

Analyzed and reported the load test results with necessary graphs, reports and PPT presentations

IBM., Markham Aug 2008- June 2010

DB2 Functional Verification Tester/Developer

Responsibilities:

Developed functional automated test cases (JAVA script, PERL) for testing a new functionality of DB2 by using a variety of languages including Java, C, SQL, ODBC, Perl, and XML.

Performed automated Integration and System testing (Regression) on AIX, Linux, Windows, Sun, and HP platforms.

Analyzed critical test failures and optimized Defect Tracking procedures by administering Rational ClearQuest..

Created Master Test Plans, Functional Test cases in accordance with Business Requirements, Use Cases and Design Specifications (RUP-UML).

Identified and analyzed problems/defect reports and recommending preventive and corrective actions.

Architected and developed (SQL queries/scripts) benchmark, functional, security, business cycle testing for conversion procedures.

Optimized Bug loading procedure by using Rational ClearQuest, monitored Bugs attributes as status, severity and priority to validate completeness of corrective actions during the Testing flow.

Conducted inspection of documentation required for User Acceptance testing (Acceptance Test Results, User Guide) and validated usability, Established and maintained test cases and test data in Rational Quality Manager.

Nightingale Informatix Corp., Markham Oct 2006 – July 2008

Quality Assurance Analyst

Responsibilities:

Designed detailed Requirements, Test plans, Test Scenarios and Test cases according to the Business/Functional requirements.

Performed GUI, Functional and Regression tests for the Web-based application (ASP .NET).

Developed and generated SQL queries to verify data integrity (Database integrity testing).

Participated in code reviews with developers to assist with problem investigation.

Performed automated testing process of transformation Heath Care HL7 system via ALTOVA mapping and by iNTERFACEWARE Chameleon toolkit.

Conducted data base testing of delivery-guaranteed data synchronization, data mapping and data transformation between existing systems based on HL7 and custom XML messages.

Managed Defect Management process (Mercury/HP Quality Center 9.0) as identification and reporting of defects for development team acknowledgment, analysis of the process in which a defect originated to identify ways to improve the process to prevent future occurrences of similar defects.

Medgate,Toronto, Canada Dec 2005 – Sep 2006

Developer/QA Analyst

Responsibilities:

Participate in all stages of SDLC: review documentation, test plans creation during static testing; re-development enhancements application according to customized requirements, test cases execution, defects identification/escalation/resolution during dynamic testing.

Participated in Mercury’s QTP automated test scripts development and execution as regression test procedure.

Reviewed and analyzed technical documentation and customer requirements in order to provide comprehensive testing coverage based on Equivalence classes.

Developed complex PL SQL procedures for validation and verification of data transaction from front-end application to different Data Bases (MS ACCESS, ORACLE, SQL Server).

Conducted development and execution of complex SQL store procedure for generating Health Care Reports, and testing conversion DB and improvement of test process based on health care tables and calculations.

Verified the Results of Testing by performing Technical Reviews, participating in Inspection and Walkthrough, escalating variances to outsourcing vendor by using Mercury’s TestDirector defect management tool.

.

NATIONAL BANK Oct 1999– Nov 2005

DB Software Developer/Tester

Project Delivered:

Compubank – enterprise Core Banking Management system include Retail Banking operations, Accounting Services, Risk Management, Management and Control modules, as well as a Customer Profile Information base, which supports CRM capabilities of the system. The system includes external software, such as: cheque clearance, interfaces to ATM’s, credit card systems, investment systems and direct debit and direct credit transactions.

Standing Order – WEB-based application which allows performing financial transactions through internet (using XML and CLOB objects)

Responsibilities:

Developed, implemented and supported several financial applications using COBOL, C/C++/PL SQL/ XML/CLOB/ORACLE for bank branches in Windows and UNIX environment.

Developed and tested financial projects (end-of-day, end-of-month and end-of-year) using C/Embedded SQL for processing and Centura(GUPTA) for on-line processing of banking transactions.

Developed SQL scripts, PL/SQL Stored Procedures, External Procedures for database-integrity testing.

Evaluated performance and reliability of different business applications and ATM banking machines by development and execution C++ simulator.

Created test plans based upon business requirements, designed and developed test cases.

Performed extensive Integration (GUI, functional, security, business-cycle, database-integrity), System (performance, robustness) and Regression testing.

Conducted development of White box testing of existing modules, with subsequent enhancements and re-designed (UNIX scripting, C/C++, SQL ) where required.

Performed User Acceptance Testing (UAT) and provided training for the customer.

Resolved complex customer issues (incident management procedure), maintained communication with customer regarding technical issues and requirements evaluation.

Education

Toronto College of Technology 2008

Software Enterprise developer program

Certified Courses: Data Warehouse with SQL Server 2005/Otacle 11g, Business Intelligence with Cognos Report/Crystal Report/Cognos Metrics Studio, Informatica ETL, SAS, LoadRunner and performance testing

Software Engineering, .NET 2003

John Bryce Training Center College of Computers Technologies

Automated Test Engineering 1998

Hi-Tech College of Computers and Information Technologies

Quality Assurance and Software Testing 1996

Hi-Tech College of Computers and Information Technologies

Software Engineering, 1995

C, C++, Visual C, SQL, PL/SQL, Developer 2000, Java, UNIX

John Bryce Training Center College of Computers Technologies

Bachelor of Engineering 1993

Technological university

REFERERENCES AVAILABLE UPON REQUEST

Contact this candidate