Summary
Overview
Work History
Education
Skills
Certification
Websites
References
Timeline
Generic

Karan Patel

Brampton,Canada

Summary

Quality Assurance Consultant with a strong history at CIBC, recognized for enhancing software development testing through advanced ETL and Azure platform capabilities. Expertise in Selenium WebDriver has led to significant reductions in manual testing efforts, while mentoring teams to foster collaboration and efficiency. Specializes in data migration and Power BI reporting, showcasing exceptional problem-solving skills and a commitment to delivering high-quality results.

Overview

8
8
years of professional experience
1
1
Certification

Work History

Quality Assurance Consultant

CIBC
Toronto, Canada
01.2022 - Current
  • Showcased expertise in software development testing.
  • Directed analysis and conversion of business needs into test cases.
  • Coordinated detailed end-to-end testing efforts to ensure project success.
  • Delivered ongoing feedback, support, and mentoring to team members.
  • Proactively detected potential issues across test phases.
  • Analyzed project risks impacting timeline and success.
  • Worked closely with BA to close requirement gaps
  • Evaluated test plans while adding constructive feedback.
  • Communicated daily progress updates to project team members.
  • Engaged in QA execution status discussions and provided feedback.
  • Extensive testing ETL experience using Informatica 8.1/7.1/6.2 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager)
  • Knowledgeable in data warehouse concepts and various database systems like Oracle servers and SQL server.
  • Developed extensive SQL scripts to validate database tables for backend testing.
  • Created ETL test scripts from technical specifications, Data design documents, and Source to Target mappings.
  • Facilitated communication among developers and stakeholders for comprehensive project understanding.
  • Developed various Power BI reports using both desktop and online service, ensuring regular refresh schedules.
  • Assist end users with problems installing the Power BI desktop, installing and configuring the Personal and On-Premises gateway, connecting to data sources and adding the different users
  • Experienced in developing Power BI reports and dashboard from multiple data sources
  • Reduced manual testing efforts by utilizing Tricentis TOSCA tools to automate test cases.
  • Collaborated with the team to deliver customer solutions on the Microsoft Azure platform with a specialized focus on Azure capabilities specific to security, virtualization, migration, and automation.
  • Assisted in the testing, and migration of various on-premise solutions to the cloud using industry best practices.
  • Proficient in using a range of data migration tools like Azure Databricks, Azure Data Factory, Storage Accounts, Function App and App Insights.
  • Led POC for migrating Data Warehouse to showcase Azure capabilities.
  • Environment: Oracle 10g/11g, Informatica Power Center 8.1 (Power Center Designer, workflow manager, workflow monitor), Power BI Reports and Dashboard, SQL developer, TOAD, SQL and PL/SQL, Web Services, Azure Data Factory, Azure Databricks, App Insight, Function App, SQL MI, Storage accounts and containers.

Quality Assurance Specialist

Apotex Inc
North York, Canada
09.2016 - 01.2022
  • Interacted with the Business Clients, Product Owners, Developers and QA Manager for clear exposure to trickle down the technical/functional User Requirements & Change Requests to Test Plans and Test Scenarios
  • Written Automation Test Scripts using Java, TestNG, and Selenium WebDriver and used MAVEN Build tool to run the Automation
  • Experience in creating strategy test plans, test cases and test estimation requirement traceability matrix
  • Created Automation framework with Page Object Model (POM), built the function libraries, executed parallel browser testing and modified the automation scripts by inserting the check points to verify the object properties
  • Performed Regression suite and smoke Suite Testing
  • Tested webservices using SoapUI
  • Reviewing Business Requirements and functional specification document
  • Develop test cases
  • Configured Selenium WebDriver, TestNG, Maven tool and created automation scripts in java using TestNG prior to agile release
  • Responsible for writing and testing the test cases
  • Reported bug using Project Tracking tool JIRA
  • Used Git to maintain automation code repository
  • Performed data driven test to test application for multiple scenarios with different verities of data
  • Performed white box testing for the Web based application
  • Conducted weekly review meeting with management, users and technical team members
  • Participated in Requirements, Design, and Release Readiness review sessions
  • Coordinated and managed testing activities as per the agile methodology followed by project team members
  • Participated in the QA Meetings, Bug Review Meetings, Go/No-Go Meetings & responsible for updating & verification of the Project Checklist during the Deployments/Releases
  • Environment: Win7, Selenium WebDriver, AWS, SQL Server, XML, JSON, JAVA, JIRA, TestRail, SoapUI, Jenkins, JavaScript, TestNG, Maven, Agile Methodology, Eclipse

Education

Diploma - Computer Networking and Technical Support

Seneca college
North York, ON, Canada
04.2016

Skills

  • Selenium IDE
  • Selenium WebDriver
  • Selenium Grid
  • SoapUI
  • JMeter
  • Cucumber
  • Appium
  • Junit
  • TestNG
  • Data driven
  • Page Object Model
  • BDD
  • Unit Testing
  • Functional Testing
  • Performance testing
  • Regression Testing
  • Black Box Testing
  • Smoke Testing
  • UI Testing
  • Integration Testing
  • API Testing
  • Agile Testing
  • Cross browser Testing
  • Java
  • C
  • JavaScript
  • HTML5
  • CSS3
  • XML
  • VB Script
  • Oracle
  • SQL
  • MySQL
  • Relational Database
  • Eclipse
  • NetBeans
  • Dreamweaver
  • IntelliJ
  • Adobe Photoshop
  • Windows
  • Mac OS
  • LINUX
  • Android
  • IOS
  • Git
  • SVN
  • ANT
  • Maven
  • Jenkins
  • Jira
  • Quality Center
  • Bugzilla
  • Test link
  • TestRail
  • HP ALM
  • MS office
  • Ajax
  • JSON
  • JQuery
  • Firebug
  • Fire path
  • Putty
  • Toad
  • ETL testing
  • Problem solving
  • Reporting tools
  • Effective communication
  • Team collaboration
  • Mentoring skills
  • User acceptance testing
  • Data migration
  • Power BI reporting
  • Azure power BI integration
  • Azure data factory
  • Azure storage solutions
  • Azure key vault
  • Azure monitor
  • Azure migration planning
  • Azure SQL database
  • Azure virtual machines

Certification

  • Award of Achievement for Programming in Java, Oracle's Workforce Development program at NIIT, Ahmedabad, India, 07/21/13
  • Certified in successful completion of HTML and C++ Programming, NIIT, Ahmedabad, India, 2013
  • Certification in fulfillment of the course titled Developing Advanced Applications with MySQL and PHP, NIIT, Ahmedabad, India, 2013

Websites

References

References available upon request.

Timeline

Quality Assurance Consultant

CIBC
01.2022 - Current

Quality Assurance Specialist

Apotex Inc
09.2016 - 01.2022

Diploma - Computer Networking and Technical Support

Seneca college

Similar Profiles

CREATE PROFILE
Karan Patel