SUMMARY:

• Extensive Quality Assurance/Business and Risk Analyst experience with Global and Canadian Finance/Banking Treasury &Risk Management, Regulatory Capital, Retail Credit Risk, Basel II & III - Implementation Trading Room WorkStream, Credit Cards, Payments, Insurance, Sales/Marketing, CRM, ERP, Data Governance, Master Data Management, and Government Custom Development projects with multiple stakeholders across multiple LOBs
• Detail oriented with strong analytical computer skills: QA/Business Analysis of Client/Server, Web-based, Mobile Applications in Cloud, E-Commerce applications in different browsers, on multiple platforms
• Strong QA Leadership; leading projects, coordinating and reporting testing process
• Strong working experience in Quality Management, Enterprise QA Transformation Models, quality framework deliverables and debugging/defect processes at all layers of applications using troubleshooting technics, g at he ri ng da t a creating das hboa r d r e por t s, and reporting performances
• Solid understanding of Business, Development and QA processes methodologies and IT standards (Agile, SCRUM, Kanban, DevOps, Waterfall, SDLC, PDLC, PMLC, ISO, CMMI etc.)
• Effectively analyzing Business and Technical Documentation, monitoring design and business processes, BRD, Architecture, Data Models, Gap Analysis, translating stories into Business and Test scenarios, and developing Business/Test Strategy, Business/Test Plans, Release Management Reports, Business Scenarios, Business Transformation Rules, Traceability Metrics, Business/Test Cases and Test Scripts, Business/Test Closure Summary Reports, and executing Functional, Non-Functional, UI, Database, Performance, Load, Security, Accessibility, Regression and End-to-End Manual and Automation tests in DIT, SIT, UAT, BAT, PAT, and in production environments
• Strong knowledge and experience of ETL/DW/BI methodologies, and techniques using ETL/Data Warehouse/Business Intelligence Solutions: Master Data Management, Data Steward, Data Modeling, Data Flows, Data Aggregation, RDBMS, big data validation/verification, data mapping/data conversion using UNIX/Linux, Oracle, Netezza, Hadoop, IBM(MDM), Informatica, SAS, IBM Cognos, Microstrategy and other tools and techniques
• Hands-on proficient experience with Data Preparation, Data Analysis, SQL, PL/SQL, Database/Tools (MS SQL, Oracle v.8i-11i, Netezza, TOAD 10.0, MS Access, DB2)
• Familiar with different web development platforms and programming languages and deep understanding of frameworks: Java/J2EE, JavaScript etc.
• Strong skills with Operating, Automation and Defect Tracking tools: TSYS/TS2, Selenium, HP UFT 12, QTP, Jira, Confluence, HP ALM 11, HP QC 9.2, Mercury Quality Centre, Rational Quality Manager (RQM), Rational Suite (TestRobot, TestManager, ClearQuest), WinRunner 6x-7x, Test Director etc.)
• Web Services (WSDL, XML, SOAPUI, RESTful etc.)
• Mainframe (ADP, ICBS/AS 400, Tandem, CL)
• Strong knowledge and technical skills for providing cross training: Atlassian Jira, Confluence, Agile, SCRUM, Kanban, ETL, DW, SQL, Informatica, Cognos etc.
• Excellent academic background in business and computer science. Strong team player attitude and ability to take initiative to manage multiple activities with multiple teams, and properly escalate problems and issues

TECHNICAL SKILLS:

Operating Environment: Windows NT 4.0/9x/2K/XP/Vista, UNIX, MS Office 9x/2K/XP Pro, PowerPoint, SharePoint, ADP and IBM Mainframe, Visual Studio 6.0, 7.0, 8.0, VSTS 2010, C/C++, DB2, Java, J2EE, JSP, ASP, TSYS/TS2 Oracle, VB, VBScript, JavaScript, HTML, SOX/XML, Websphere MQ

Database and Tools: MS-SQL SQL Query Analyzer, Oracle v7-11g-TOAD v 10.0, 10.6.1.3, Oracle Developer, SQL Navigator 5, Netezza-AQT v 8.2.7, Tecsys Elite v8.0, MSAccess v.7, 2000, 2003

Development Tools and Languages: J2EE, SAS, IBM Cognos, Informatica v 9.1.0, Microstrategy v10, Microsoft Visual Studio 6.0; IIS 5.0, ASP, JavaScript, VBScript, DHTML, HTML, XML, HTTP, TCP/IP, MSSQL Enterprise Manager, SQL, PL/SQL,VB v6.0

Testing Tools: Jira (6.3.12), Confluence (5.4), ALM QC, HPQC, QTP, MQC, Test Director, WinRunner 6.x,7.x, Rational TeamTest 7.5, Suite TestStudio, Rational ClearQuest Web Client 7.1.1, SOAP UI

PROFESSIONAL EXPERIENCE:

Sr. QA Consultant

Confidential

• environment and tools: DB2, SQL Developer, Admin Portal, Payee Portal, API/Postman, Java, C#, XML/ XSD/WSDL/JSON, Agile(Jira), Confluence, SOAP UI, IE, Firefox, Chrome, SharePoint Environment (SIT, UAT, PAT)
• Collaborating with System Analysts, Development Primes and business stakeholders for successful delivery of Dream Payment Northbridge Insurance Project
• Responsible for Business and QA analysis, developing and maintaining Data Modules, Business and Functional/System requirements, and Traceability Matrix, developing Business/Test Plan, Cases, Test Data for all phases of Dream Payment to gain content knowledge to fulfill single point of contact role for their domain on behalf of team, for Business and QA framework deliverables using Agile principles
• Creating and translating stories into Business and Test scenarios in Jira, and monitoring test team progress during planning and execution phases for Dream Payment project to ensure they meet standards and content requirements
• Assessing Change Requests and reporting to Product Owner and Project Manager on daily pr oc esse s
• Attending cross-functional team sprint meetings, walkthroughs and quality reviews of deliverables, and enforcing Agile methodology
• Performing Web/Mobile Functional manual and automation testing in cloud client’s application using Admin Payee and Payment Portals, Android Mobile, SQL Developer, API/Postman, SOAPUI, facilitating daily defect reporting in Jira, and planning/assisting UAT and BA team
• Providing support to Business/ Operations Teams for User Acceptance Testing and/ or Operational/ Business Testing as required
• Building relationships and working collaboratively to identify solutions and resolve variances from product/application specifications, and providing test status updates to Test Manager
• Recommending and supporting development and implementation of process improvements to increase effectiveness and efficiency of Quality Assurance controls

Sr. Test Lead

Confidential

• environment and tools: Java/J2EE, Oracle WebLogic Server, DW, ETL, UNIX, Oracle v11g, SQL Developer, MS Access, XML, SoapUI, API, HP ALM v12, ISO, CMMI, Agile(Jira), Confluence, IE, Firefox, Chrome, SharePoint Environment (SIT, UAT, BAT, PAT)
• Interacting with members of Confidential teams and providing support for all aspects of QA activities on EPC Confidential Project and Project Enhancements in DIT, SIT UAT and PAT environments
• Reviewing Confidential EPC Project Portal: Performance Information, Cloud Information, Confidential Performance, Acceptance Testing (PAT) Web Service Requests
• Creating and updating documentation: FSD, CRs, Business Rules, Test Plans, Test Cases, Test Scripts and Webservices according to Agile SCRUM methodology
• Preparing data validation/verification in DW/Oracle database, data analysis with SQL scripts in SQL Developer, creating and testing Crystal Reports
• Manual and automation testing, functional and performance test execution Web Services using SOAP UI
• Performing PTE Baseline with existing 4.5 code: Functional, Regression, PTE Load Tests - High Freq
• Running ETL processes and performing ma test analysis using SOAPUI, SQL Developer
• Reporting and tracking issues in Jira( Confidential ), HP ALM ( Confidential ), and updating Resolution Action Plan
• Participating in daily sprint standup meetings, walkthroughs and quality reviews of deliverables

Sr. Business Analyst

Confidential

• environment and tools: IBM MDM, Data Steward, TD MM FF files, IBM MDM, EDPP servers, DW, ETL, Java, Oracle, MS Access, WDS, IBM Cognos v.9.0, CL, CODS, XML, HP ALM v11, Excel, PowePoint SharePoint, Tableau, Visio, CRM, PDLC, Waterfall Environment (SIT, UAT, BAT, PAT, Prod)
• As a member of ECIM Business team interacting product owner and members of IT Team, and providing support for all aspects of BA/QA activities, on MDM Silver Phase2, US Phase2/FY16 Projects Enhancement BAT in SIT(v9), BAT in PAT Silver and Gold (v11) components of customer relationship management CRM and enterprise resource planning ERP
• Supporting projects, creating and updating MDM Operations Manual, Business Test Plan/Test Scenarios, Closure Summary Reports within Requirements Package, Business Acceptance Test Strategy/Test Plan, Business Workflows, Traceability to Business Use Cases using Excel, SharePoint, PowerPoint, Tableau etc.
• Testing and delivering Data Governance processes according to MDM methods and standards: MDM-ETL reject files, MDM end dated Person/ Organization Customer to Account relationships including required data to link to source (WDS) data, Silver and Gold downstream reconciliation
• Creating and executing E2E BAT and PAT Business and Test Scenarios covering all source to target DSUI Business Rules outlined in PDLC, BRD, SRS, Silver Phase2 and US Phase2/FY16 Profile BAT Test Strategy/ Test Plans, simplifying Governance by creating consistent standards and values for Enterprise elements, LoB-specific view customer data, new LoB-level TDW Silver and TDCT Golden Customer Profiles, Enterprise Customer Status for each LoB, Match and Merge, Combine/De-combine, E2E Split, Collapse, Entity type change from person/non-person and vice-versa, Grouping, Accessibility and performing real time customer/end user (English/French) testing once exit criteria have been met and remaining BAT/PAT defects are according resolved
• Creating and modifying data-sets (TDAF, ACBS, LOAN IQ etc.), and testing Modules on transaction level
• Verifying Detailed and Summary Reconciliation Reports in Cognos, Consistent Reporting and Reconciliation of customer record counts
• Testing transaction, payment and reconciliation processing with customers’ TDCT/MBNA/CUETS Credit Cards, and identifying and reporting issues in HPQC ALM
• Testing Migration of all existing data to new Silver instance (MDM v11Oracle) and decommission MDM v9 to support CRM loan adjudication process and regulatory reporting requirements for US and Canada (TDCT, MBNA & CUETS)

Sr. QA Analyst

Confidential

• environment and tools: Java/J2EE, WCAG 2.0 AA/JAWS , Informatica v 9.5, Hadoop v2.7.0, Netezza v7.0 - AQT, Oracle v11g-TOAD v10.6.1.3, UNIX/LINUX, API/Postman, Microstrategy v10, REST, SoapUI, Elite, PWT, HP ALM v11, HP QTP v12, HP UFT, Selenium, Agile (Jira), Confluence, IE, Firefox, Chrome, Excel, PowerPoint, Visio, SharePoint
• As a member of Sales/Marketing Critical Business team interacting with customers, stakeholders, members of Business, and Retail Rewards Support teams for Risk Management control during execution and successful delivery of BMO AIR MILES, Orphan miles, Vendor Payment, Recon Processor and other projects across multiple LOBs with tickets assigned to me in Jira using Agile and identifying business needs
• Participating in daily sprint standup meetings, walkthroughs and quality reviews of deliverables. Translating stories into Business and Test scenarios
• Providing RDBMS processes of all products by combining business and technical approach to improve database visibility, delivery and management according to DLM standards
• Working under minimal supervision on ETL side with Data Integration team and managing all QA aspects of projects according to Agile Kanban methodology
• Creating documentation and artefacts: Test Plans, Test Metrics, Test Cases, Test Scripts using Confluence, Run book, Business Requirements, Use Cases, Functional and System Specifications etc.
• Analyzing Data Models, Flows, Database Schemas, CSV flat files, Data Sources, Source to Target Mappings based on Aggregation Rules
• Creating and modifying sample data, developing transformation, metadata injection through ETL steps for multiple supplier files, running and testing results for eVoucher application
• Running ETL processes, jobs for data validation/verification on all ETL stages for AIR MILES project: analyzing data using UNIX shell scripts and extracting data from data sources, transforming and storing data in proper format using Informatica, loading data in Data Warehouse in Oracle (or Netezza) databases, and preparing data analysis with SQL queries: staging to target verification
• Testing Big Data applications using Hive-QL for Hadoop ecosystem associated with SQL for ETL processing to prevent risk of unexpected data loss for Jiffy Lube ESD and TCP GRM projects
• Preparing Integration, Functional, Accessibility, Regression manual and automation test analysis, custom E2E Order Processing, Vendor Payment, Recon Processor, SPU I/SS, UI Expiry Java Applications, Reports in DIT, SIT and UAT environment, using UNIX, ELITE, Oracle/TOAD, Mobile, SOAPUI, API/Postman, Selenium and QTP
• Testing OMS Automate Cleanup Common Recon Errors in SPUI/SSUI Expiry Java Applications with Java process
• Identifying defects and reporting test results in HP ALM and Jira, and participating in testing activities and defect fixes
• Reporting all test conditions have been executed and test results signed-off by QA on time
• Sharing knowledge and skills of standards and methodologies, ETL, DW, SQL, Atlassian Jira, Confluence etc., and participating in cross training activities: Agile, SCRUM, Kanban, ETL, DW, SQL, IBM Apache, Hadoop, Apache Spark, Microstrategy etc.

System Testing/QA Specialist

Confidential

• environment and tools: ONBIS APP Server, DW, Oracle, OneSource ONBIS Portlet, Admin Portal, Java, WebSphere, ISIM, ESB, WSIB, CRA, XML Web Services, WSDL, SOAPUI 4.5.1, Web browsers: IE 8.0, Firefox, Chrome, Quality Centre, Rational Quality Manager (RQM), ClearQuest, MS Project 2010, SharePoint 2010
• Providing support for all aspects of QA activities, on behalf of Government Services Cluster with SIT focusing on portal implementation system based on software packages implemented in Service Ontario Deployment Platform (SODP) environment
• Analyzing Governance standards, ONBIS Business Registration for Corporations Use Case Specifications, Supplementary Business Requirements, Corporation and BNLP Transaction Output Document Specification, CRs, ONBIS Web Service Technical Specification, ONBIS Application, ONBIS Web Services and providing support for all aspects of SIT and UAT activities
• Developing Test Scenarios, Test Cases, Test Scripts to cover all possible conditions
• Creating and testing English and French versions of New & Updated Entities, Transactions, Output Documents, Real Time Integration PC Lookup, CCPAY services with Master Cards/Visa/ Credit Cards, NUANS Reports, Protocols, ONBIS Search etc. in ONBIS Application, ONBIS Web Services for Authenticated Government Organization, Internal, Public and Service Provider Users with Authority to Entity in different browsers in DEV and SIT environment
• Creating XML scripts using ONBIS Web Service Technical Specification and service interface (set of WSDL), provided along with each Web Service and testing XML files request/response in SOAPUI
• Automation Testing XML data format for authentication and authorization data and identifying Identity Provider s and Service Provider s in different browsers
• Executing frontend and backend, Functional, Performance and Regression and Accessibility testing is part of the system testing process and is somewhat similar to usability testing using systems for individuals with disabilities
• Identifying defects, reporting test results in ClearQuest defect tracking system, and investigating defects in order to reduce risk of defects appearing on implementation stage
• Providing Data Flows, mapping analysis to migrate all relevant data from legacy ONBIS system to database of new ONBIS Solution, creating and testing Reports
• Communicating with business and development teams to exchange and verify information and participating in walkthroughs and quality reviews of deliverables

Sr. BA/QA/Test Lead

Confidential

• environment and tools: Basel II program, RCDW databases, SAS 9.3 server, Oracle 10g UNIX Servers, Cognos 8.0, Java/J2EE, IIS Webserver, WebLogic, CMDB, MS.NET, SQL Navigator 5, TOAD, SAS EG, ETL, MS Access, SQL, PL/SQL, OSFI, IFRS, XML, IE7.0, 8.0, Firefox, SharePoint 2010, ALM HPQC v11, Excel, CRM, PowerPoint, Visio, SDLC
• Leading projects, coordinating testing processes and providing business, technical and analytical support for RCDW Data Warehouse modules across 12 LOBs by analyzing BR, Technical specifications, BCAR, NCR, RQ, CRs’ Enhancements, Technical Design Documents, Data Modeling for RDBMS process according to SDLC m
• Analyzing data sources, data flows, database schemas, producing source to target mappings, creating field mappings of BTRs with SAS Business Intelligence components
• Developing Risk Assessment, Test Strategies, Test Planes, Release Management Reports, Business/Test Scenarios, Traceability Metrics, Test Cases, SQL Test Scripts by following Governance standards, risk and compliance, architecture documents TAD from RCDW external/internal design to cover all possible conditions
• Verifying batch/ETL jobs successfully completed and loaded in ETL Enterprise Gide and Oracle DW, and performing ETL/DW testing and validating record counts, amounts and attributes values, data preparation framework, calculations with SQL queries using Aggregation Rules
• D elivering RCDW Data Management processes using DLM policy-based approach throughout its lifecycle
• Preparing analysis with SQL queries in Oracle RCDW: source to target, new tables, created/updated and comparing that data results match against Production Data Warehouse and validating output results against production outbound in Cognos Reports, cubes, and Web Admin (Java) Reports according to IFRS
• Identifying variances and reporting test results in ALM HPQC defect tracking system
• Executing SIT, UAT, BAT Functional, Regression manual and automation tests and investigating variances in order to reduce risk of defects appearing on implementation stages
• Communicating with development and business teams and colleagues to exchange and verify information and participating in walkthroughs and quality reviews of deliverables