Summary
Overview
Work History
Education
Skills
Certification
Affiliations
Timeline
Generic

Kanishka Malhotra

Brampton,ON

Summary

Qualified Business Intelligence Analyst versed in data mapping and user acceptance testing to solve complex problems in high-pressure environments. Activates strong analytical skills to investigate trends in large amounts of data and formulate conclusions based on findings. Excels at cultivating, managing and leveraging client relationships to foster extended engagements and business opportunities.

Overview

1
1
year of professional experience
1
1
Certification

Work History

QE&A Analyst

Cognizant
Delhi
09.2022 - 02.2023
  • Write automation scripts using Selenium WebDriver and Java to automate test scenarios identified during the test case design phase.
  • Utilize frameworks like TestNG or JUnit for test case management and execution.
  • Integrate the automated regression testing suite with a Continuous Integration (CI) pipeline using tools like Jenkins.
  • Generate test scenarios, test cases, and automation scripts for future reference.
  • Conduct test result reviews with stakeholders and provide insights for improving the quality of the E-commerce website.

Programmer Analyst Trainee

Cognizant
Delhi
12.2021 - 08.2022
  • Collaborate with mentors to understand the requirements of the E-commerce website testing project.
  • Apply the knowledge gained in training to design test cases covering various functionalities.
  • Tested and implemented software programs using Java programming language.
  • Execute automated test scripts on different browsers and platforms to validate the functionality.
  • Practice documenting test scenarios, test cases, and automation scripts as per industry standards.
  • Learn how to communicate test results effectively to stakeholders and team members.

Education

Bachelors of Technology - Information Technology

Guru Nanak Dev Engineering College
Ludhiana, Punjab, India
07-2022

Post-Baccaleurate Diploma - Big Data Analytics

Lambton College
Mississauga, ON

Skills

  • SQL
  • Python Programming
  • Git
  • NoSQL Databases
  • Power BI

Certification

  • Power BI - Beginner

Affiliations

PROJECT ON MULTIPLE LINEAR REGRESSION, lambton college, mississauga, ontario July 2023 -August 2023

  • Developed a predictive model to forecast salary of a employee with respect to factors include
    age and experience Multiple Linear Regression the model was 70% accurate.
  • Conducted comprehensive data cleaning, including handling missing values and outliers,
    ensuring dataset quality by 30%.
  • Utilized Data Visualization techniques to acquire insights, identify patterns, and visualize
    relationships among variables about 50% of the project.
  • Accomplished Feature Selection to choose relevant independent variables, improving model
    accuracy and efficiency. Employed numpy and pandas for data manipulation and
    prepossessing, ensuring data readiness for analysis.
  • Trained a robust Multiple Linear Regression model using required libraries, optimizing for
    predictive accuracy was about 80% and perform employing matplotlib for clear visualization of results.
  • Created a Pickle file to store a trained model, facilitating seamless deployment and re usability of the project contribution was about 30%.

DATA INGESTION AND ANALYSIS PIPELINE WITH MYSQL, HDFS, AND HIVE USING SQOOP,
lambton college, mississauga,ontario

  • Constructed a robust script leveraging Scoop to seamlessly transfer data from MySQL to
    HDFS, ensuring compatibility and data integrity.
  • Defined Hive tables mirroring the HDFS data structure. Executed five complex Hive queries to extract insights, transforming and aggregating data efficiently.
  • Applied transformations within Hive to achieve valuable insights, uncover patterns, and support data-driven decision-making.
  • Networked efficient knowledge sharing by exporting analysis results derived from Hive back to MySQL, increasing accessibility for stakeholders.

Timeline

QE&A Analyst

Cognizant
09.2022 - 02.2023

Programmer Analyst Trainee

Cognizant
12.2021 - 08.2022

Bachelors of Technology - Information Technology

Guru Nanak Dev Engineering College

Post-Baccaleurate Diploma - Big Data Analytics

Lambton College
Kanishka Malhotra