Summary
Overview
Work History
Education
Skills
Languages
Timeline
Generic

Kajal Prajapati

Brampton,ON

Summary

Responsive expert experienced in monitoring database performance, troubleshooting issues and optimizing database environment. Possesses strong analytical skills, excellent problem-solving abilities, and deep understanding of database technologies and systems. Equally confident working independently and collaboratively as needed and utilizing excellent communication skills.

Overview

6
6
years of professional experience

Work History

Data Engineer

CIBC
04.2022 - Current
  • Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
  • Designed compliance frameworks for multi-site data warehousing efforts to verify conformity with state and federal data security guidelines.
  • Generated detailed studies on potential third-party data handling solutions, verifying compliance with internal needs and stakeholder requirements.
  • Built databases and table structures for web applications.
  • Designed and implemented effective database solutions and models to store and retrieve data.
  • Analyzed complex data and identified anomalies, trends, and risks to provide useful insights to improve internal controls.
  • Explained data results and discussed how best to use data to support project objectives.
  • Communicated new or updated data requirements to global team.
  • Contributed to internal activities for overall process improvements, efficiencies and innovation.
  • Prepared documentation and analytic reports, delivering summarized results, analysis and conclusions to stakeholders.
  • Designed data models for complex analysis needs.
  • Monitored incoming data analytics requests and distributed results to support strategies.
  • Used GDP on validation protocols, test cases and changed control documents.

Data Engineer

Rogers Communications
01.2020 - 04.2022
  • Working closely with our data science team to help build complex algorithms that provide unique insights into our data
  • Use agile software development processes to make iterative improvements to our back-end systems
  • Model front-end and back-end data sources to help draw a more comprehensive picture of user flows throughout the system and to enable powerful data analysis
  • Build data pipelines that clean, transform, and aggregate data from disparate sources
  • Develop models that can be used to make predictions and answer questions for the overall business
  • Help streamline our data science workflows, adding value to our product offerings and building out the customer lifecycle and retention models

Data Engineer

Equitable Life Insurance
04.2018 - 12.2019
  • Assisted with the design to simplify method for consolidating inventory of projects within Planview and integration of time records to update work plans with actual effort and progress to-date.
  • Functioned as liaison between Business Partners and Corporate IT leaders for IT portfolio collection and data analysis by engaging project leads from all business units to assist with providing an inventory of all IT spend.
  • Defined, developed, and generated management data reporting on portfolio investments and Centers of Excellence by developing and providing executive management presentations, which included detailed analyses from project inventory data.
  • Developed and implemented dashboard financial charts for service offerings.
  • Assumed accountability for the Business Request (BR) receipt to the routing process, successfully maintaining and improving metric turnaround commitments by routing BRs within 0.8 days vs. previous target of 1.0. Successfully managed and processed 23% increase in BR inflow.
  • Develop new Tableau and Excel dashboards that provide greater visibility into critical areas such as Cybersecurity, Business Impacting Events, and Project and Portfolio Management.

Education

Bachelor of Science - Data Science

Fleming College
Peterborough, ON
04.2018

Skills

  • Data Curating
  • Real-time Analytics
  • Project Management
  • Spark Framework
  • Cloud Computing
  • Data Visualization
  • API Development
  • Hadoop Ecosystem
  • SQL
  • Data Governance
  • Net
  • Data Warehousing
  • Data Quality Assurance

Languages

English
Professional Working

Timeline

Data Engineer

CIBC
04.2022 - Current

Data Engineer

Rogers Communications
01.2020 - 04.2022

Data Engineer

Equitable Life Insurance
04.2018 - 12.2019

Bachelor of Science - Data Science

Fleming College

Similar Profiles

CREATE PROFILE
Kajal Prajapati