Summary
Overview
Work History
Education
Skills
Accomplishments
Projects
Timeline
Generic

Priyanka Shekhawat

Mississauga,ON

Summary

10+ years of experience as a Data Engineer and Data Analyst, with 5 years of expertise in Snowflake and Cloud Platforms such as AWS and Azure. Currently working as a Data Engineer and Data Analyst, proficient in Snowflake, AWS, Azure Data Factory, and Databricks. Extensive experience in SQL databases such as SQL Server, MySQL, AWS Redshift, DB2, and Snowflake. Hands-on experience in data migration from Hive to Snowflake. Skilled in data analysis, ETL development, and complex SQL queries. Proficient in database development, including stored procedures, functions, views, triggers, and complex sub-queries. Strong analytical skills, with a knack for problem-solving and innovation. Experienced in Agile methodology, project management tools like JIRA, and version control systems like SVN and Git. Knowledgeable [Desired Position] with robust background in data architecture and pipeline development. Proven ability to streamline data processes and enhance data integrity through innovative solutions. Demonstrates advanced proficiency in SQL and Python, leveraging these skills to support cross-functional teams and drive data-driven decision-making. Results-driven data engineering professional with solid foundation in designing and maintaining scalable data systems. Expertise in developing efficient ETL processes and ensuring data accuracy, contributing to impactful business insights. Known for strong collaborative skills and ability to adapt to dynamic project requirements, delivering reliable and timely solutions. Results-focused data professional equipped for impactful contributions. Expertise in designing, building, and optimizing complex data pipelines and ETL processes. Strong in SQL, Python, and cloud platforms, ensuring seamless data integration and robust data solutions. Known for excelling in collaborative environments, adapting swiftly to evolving needs, and driving team success.

Overview

8
8
years of professional experience

Work History

Data Engineer

Pitney Bowes
07.2021 - Current
  • Designed and developed data pipelines using Snowflake, AWS, and Azure Data Factory for internal reporting and data analysis projects
  • Optimized multiple Snowflake pipelines and reduced warehouse sizes from medium to small, leading to cost savings
  • Reduced the size of AWS S3 buckets for cost optimization
  • Created and maintained Power BI reports and provided insights into product sales and financial comparisons for management decision-making
  • Improved the performance of Snowflake dashboards by optimizing queries written in JavaScript and SQL
  • Provided data solutions that influenced the compensation structure for salespeople and contributed to the financial optimization of the organization
  • Collaborated with system architects, design analysts and others to understand business and industry requirements.

Big Data Developer

GroupM Media
06.2019 - 07.2021
  • Wrote ETL operations using Spark SQL, Hive, and MySQL for digital marketing projects
  • Processed data using AWS S3 and Amazon Redshift, migrating data from Hive to Snowflake
  • Wrote PHP code to retrieve data from APIs and used shell scripting to automate ETL scripts
  • Delivered reports on KPIs like impressions, clicks, video views, and conversions across digital marketing channels
  • Enhanced data processing efficiency by designing and implementing big data solutions using Hadoop ecosystem tools.

Big Data Developer

Innovaccer
11.2018 - 06.2019
  • Developed ETL processes using AWS S3 and Amazon Redshift for healthcare-related data processing
  • Increased accuracy in data analysis by creating robust, reusable ETL pipelines to clean and transform raw data into usable formats.
  • Collaborated closely with stakeholders to deliver project documentation, including Data Flow Diagrams and High-Level Designs (HLD)
  • Evaluated and recommended big data tools, frameworks, and platforms to support business requirements, ensuring the highest return on investment.

Big Data Developer

Lucideus Tech
12.2017 - 10.2018
  • Managed the development of a tool to assess IT security scores for clients by analyzing Hive data and generating reports based on historical data
  • Designed algorithms for generating security scores based on aggregated reports from multiple endpoints

Database Developer

ATCS Inc.
06.2016 - 05.2017
  • Designed and implemented database objects such as tables, procedures, functions, triggers, and indexes for Mercedes-Benz USA
  • Optimized SQL queries and improved access plans for performance tuning

Education

GED -

JECRC
India
05.2014

Skills

  • MySQL
  • IBM UDB DB2
  • AWS Redshift
  • Snowflake
  • SQL
  • Azure Data Factory
  • Azure Databricks
  • Hive
  • Spark
  • Hadoop
  • AWS
  • MS Office
  • Tortoise SVN
  • Assembla
  • JIRA
  • Git
  • AWS S3
  • Glue
  • Agile Methodology
  • Project Management Tools
  • Data Modeling
  • Data Warehousing
  • ETL development
  • Data Pipeline Design
  • Data Migration
  • Big Data Processing
  • Scripting Languages
  • Spark Framework
  • Performance Tuning
  • SQL Expertise
  • Data Quality Assurance
  • Data integration
  • SQL and Databases
  • SQL Programming
  • Data Analysis
  • Business Intelligence
  • Data Analytics
  • Data Visualization

Accomplishments

  • Awarded Employee of the Quarter for outstanding contributions to Mercedes-Benz USA at ATCS.
  • Received Thumbs Up Award twice at Pitney Bowes for exceptional performance.

Projects

Sales Data Analysis & Reporting, Pitney Bowes, 09/01/22, Present, Created Snowflake pipelines and Power BI reports to analyze sales performance, providing insights for compensation and financial analysis. Cost Optimization, Pitney Bowes, 07/01/21, Present, Optimized Snowflake queries and pipelines, reducing operational costs by minimizing warehouse sizes and S3 bucket usage. CDW & CFA & ASU & Commvault, GroupM Media, 06/01/19, 07/01/21, Wrote ETL operations on data by using Spark SQL and Hive and MySQL. Wrote PHP code to get data from APIs. Used shell scripting to process ETL scripts in Hive. Managed data migration from Hive to Snowflake and generated digital marketing reports using AWS Redshift. BluePi, Innovaccer, 11/01/18, 06/01/19, Processed reporting data by using Azure Blob and Amazon Redshift. SAFE, Lucideus Tech, 12/01/17, 10/01/18, Stored the data in Hive from various resources. Analyzed the data using Hive to get aggregated reports from the collected data over the years to create an algorithm to generate a security score. Warranty, After Sales Audit, LMS, ATCS Inc., 06/01/14, 11/01/17, Designed and implemented database objects (tables, procedures, functions, triggers, indexes, cursors) in a Windows environment. Optimized and tuned SQL queries and access plans.

Timeline

Data Engineer

Pitney Bowes
07.2021 - Current

Big Data Developer

GroupM Media
06.2019 - 07.2021

Big Data Developer

Innovaccer
11.2018 - 06.2019

Big Data Developer

Lucideus Tech
12.2017 - 10.2018

Database Developer

ATCS Inc.
06.2016 - 05.2017

GED -

JECRC

Similar Profiles

  • Charles Hughes-Sykes

    Charles Hughes-SykesCharles Hughes-Sykes

    Warehouse Packer at Pitney BowesWarehouse Packer at Pitney Bowes

    View Profile
  • HIBA ALZUBAIDY

    HIBA ALZUBAIDYHIBA ALZUBAIDY

    Trainer and Coordinator at Pitney BowesTrainer and Coordinator at Pitney Bowes

    View Profile
  • Beth Beattie

    Beth BeattieBeth Beattie

    Administrative Assistant at Pitney Bowes Presort ServicesAdministrative Assistant at Pitney Bowes Presort Services

    View Profile
Priyanka Shekhawat