Radhey P. Middle Data Engineer

Experience

Data Engineer

Mar 2021 - Present (10 months +)
Responsibilities:

• Worked with Clients like Air Canada and Nova Scotia Health Authority in their Data Engineering projects.

Developer

Aug 2020 - Present (1 year 5 months +)

Data Specialist

Sep 2018 - Apr 2020 (1 year 8 months)
Responsibilities:

• Drove Inventory Accuracy project in which the data from various sources like Momentis ERP, Raymark POS, Magento E-commerce, and other flat-files was integrated using SQL Server Integration Services.
• Played a key role in migration project of SQL Server to Azure SQL Database(offline) using Data
• Migration Assistant (DMA)
• Developed and administered stable, reliable and effective databases for eCommerce websites in Azure SQL Database.
• Developed SQL stored procedures for retail sales, wholesale sales, retail product ranking and used this data for effective visualization using Tableau.
• Developed an internal ordering application using Django and SQL Server which takes the latest available to sell (ATS) data and allows flawless wholesale ordering for the sales department.
• Developed and implemented front-end and backend changes for pointzero.ca, nicolebenisti.com, and liveatencore.com
• Performed SQL queries, data transfer extracts and developed stored procedures for business intelligence reports using Tableau, SAP Crystal Reports & Python
• Generated dynamic reports for flexibility and ease using cascading parameters and filters in SAP Crystal Reports
• Implemented automation for syncing Available to Sell data across different selling seasons using SSRS.
• Created scheduled Jobs and alerts using SQL Mail for database Backups.
• Designed SQL Server Database Backup and restore strategy.

Senior System Engineer

May 2015 - Aug 2016 (1 year 4 months)
Responsibilities:

• Drove the Data Analysis using Python project for optimization of Change Management Process.
• Actively contributed to hybrid IT Infrastructure migration projects (AWS, Azure, Linux, Python) for Vodafone Europe and Vodafone New Zealand.
• Windows Server Administration - group policy management, decommissioning tasks, user access
  management, change implementation, patching, troubleshooting storage, hardware, and network issues. (Remedy, Windows Server 2012, HP iLO, Citrix)
• Virtual Server installation, administration, troubleshooting storage, hardware, and network issues (VMWare vSphere)
• Extensively worked on Azure SQL Database during the Vodafone Europe migration project.
• Experience in working with Azure Active Directory Services during internal IAM migration projects.
• Created maintenance plans to perform index defragmentation, re-indexing, and updating the index
  statistics.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying, and executing the packages in Development, QA, and Production Environments.
• Negotiated schedule for changing windows with the change management board, cross-functional departments, and technical resources across the entire organization for smooth implementation of
  the requested change.

System Engineer

Sep 2014 - Jul 2015 (11 months)
Responsibilities:

• Developed control and monitoring application for high current filament power supply (LabVIEW, Python and front end web technologies)
• Developed Data extraction and manipulation scripts using SQL
• Developed scripts in python to transform data from flat-file and automate the scheduled transformation using bash scripting on windows server.

Software Development Intern

Dec 2013 - Apr 2014 (5 months)
Responsibilities:

• Developed control and monitoring application for high current filament power supply (LabVIEW, Python, and front end web technologies)

Education

Concordia University, Graduate, Computer Science
Data Structures, Files and Database, Operating System, Computer Architecture, Discrete Structures
and Formal Languages, Advanced Programming Practices, Quality Methodologies for Software,
Software Project Management, Software Design Methodologies, Total Quality Project Management,
Total Quality Methodologies in Engineering
2017 - 2018

Dharmsinh Desai University, Bachelor of Technology (B.Tech.), Engineering
2010 - 2014

Certifications

• Operating Systems and You: Becoming a Power User - Google
  2YX8N9WU2BK8
• The Bits and Bytes of Computer Networking - Google
  8968YZKTG8M6
• Technical Support Fundamentals - Google
  VLCU3P8MG7UK
• System Administration and IT Infrastructure Services - Google
  HX3LWAQS2R6D
• IT Security: Defense against the digital dark arts - Google
  7GESTHS52YJB
• Google IT Support Professional Certificate Specialization - Google
  AUPB6F9AL7GP
• Tableau - 365 Data Science
  cert_z5zp7hj7
• Oracle Autonomous Database Cloud 2019 Certified Specialist - Oracle
• Oracle Cloud Infrastructure 2019 Architect Associate - Oracle
  https://www.youracclaim.com/badges/7c534a5a-43fd-4ad8-a2bc-1b67a08a2beb/linked_i
• Javascript - GUVI Geek Networks, IITM Research Park
  Q14F91991j5h9g14eE
• Complete Python Programming - Basics to Advanced Concepts - Unwired Learning
  PYBA-42157771
• Git and Github: Mastering the Modern Workflow - Unwired Learning
  GGMW-42157771
• Django Development Bootcamp: Build & Deploy Web Application - Unwired Learning
  DJWB-42157771
• React: Creating and Hosting a Full-Stack Site - LinkedIn
• The IBM Way - IBM
• IBM Automation: Compass - IBM
• Microsoft Certified: Azure Fundamentals - Microsoft
• Microsoft Certified: Data Analyst Associate - Microsoft
  Issued Apr 2021 - Expires Apr 2023
• Microsoft Certified: Data Analyst Associate - Microsoft
  Issued Apr 2021 - Expires Apr 2023
• Microsoft Certified Data Analyst Associate - Microsoft
• Microsoft Certified: Azure Developer Associate - Microsoft
  Issued Apr 2021 - Expires Apr 2023
• Microsoft Certified: Azure Developer Associate - Microsoft
• Python for Data Science - IBM
• SnowPro Core Certification - Snowflake
  Issued Apr 2021 - Expires Apr 2023