Summary
Overview
Work History
Education
Skills
Websites
Certification
Timeline
Generic

Rupal Patel

Algonquin

Summary

Data engineer with a background in designing, testing, and maintaining advanced data management systems. Skilled in improving data retrieval processes and system performance, alongside strong capabilities in database design, data mining, and CI/CD pipelines. Strong knowledge in SQL, Azure and Power BI ensures significant improvements in database performance and streamlined ETL processes. Working within Agile environments to deliver impactful solutions.

Overview

6
6
years of professional experience
1
1
Certification

Work History

SQL Data Engineer

JPMorgan Chase & Co
Chicago
12.2022 - 05.2025
  • Worked on an internal project (LoanIQ) that records the entire bank loan and exposure to credit-related activity.
  • Worked on the enhancement and development of LoanIQ interfaces.
  • Responsible for updating the existing database through TOAD.
  • Set up repositories in Bitbucket, maintain the code, and set up the jobs.
  • Set up complete CI/CD pipelines with Jenkins to ensure that each code commit undergoes the standard SDLC process before testing and deployment to production.
  • Involved in the release to production and connecting with the DevOps team for a smooth deployment.
  • Working on the enhancement and development of Loan IQ interfaces.
  • Coordinate monthly releases in collaboration with various teams.
  • Developed and maintained code for production releases, including writing and updating stored procedures, creating batch jobs for daily execution, and conducting testing in development and UAT environments.
  • Participating in Agile practices, such as daily stand-ups, product backlog refinement, capacity planning, and sprint planning, contributes to project management, progress tracking, and ensuring alignment with project goals.

Senior SQL Server Power BI Developer

PLS Financial Services
Oak Brook
06.2021 - 11.2022
  • Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests
  • Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries
  • Gathered the requirements by discussing them with the Users and Team members
  • Responsible for building reports in Power BI from Scratch
  • Experience in publishing Power BI reports on dashboards in the Power BI server
  • Created hierarchies in Power BI reports using visualizations like Bar charts, Line charts, etc
  • Worked with both live and import data into Power BI for creating reports
  • Used different types of slicers available in Power BI for creating reports
  • Created reports with Analysis Services Cube as the data source using SQL Server 2017 Reporting Services
  • Designed SSRS reports with subreports, dynamic sorting, and defining data source and subtotals for the report
  • Experience in creating Tabular Reports, Matrix Reports, Parameterized Reports, and Sub Reports using SQL Server Reporting Services (SSRS)
  • Created power bi and paginated reports using Power BI desktop and deployed them to Power BI reporting server and Power BI Service
  • Used Azure Data Factory to schedule daily jobs and to create alerts on the status of the jobs
  • Used Azure data factory to pull everyday files from vendor repository and store them in Azure data lake
  • Used Logic Apps to read email attachments and store files in Azure Data Lake and used ADF to migrate data in ODS
  • Transformed and combined the data using Query Editor in Power BI
  • Designed and developed the Power BI solution to create reports, visualizations, and dashboards as per the business requirements
  • Scheduled the data to refresh for dashboards and reports to show the live data

MS SQL / SSIS Developer

Aetna Medicaid
Downers Grove
06.2019 - 05.2021
  • Install and configure MS SQL Server 2016 along with Visual Studio on a network domain system
  • Involved in Unit testing for SSIS Packages
  • Responsible for creating and scheduling Jobs for ETL (extract transform and load) operation
  • Providing support to the application developers on the application databases to identify and resolve defects
  • Files migration from 2008 old production server to 2016 new production server by using SSIS, SQL 2016 and C#
  • Used SSIS to manually transfer DTS packages from 2008 to SSIS packages 2016 using MS SSIS 2016
  • Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, Excel, Flat files to SQL Server
  • Created SSIS package to load data from Flat/Excel Files to SQL Server 2008 R2/SQL Server 2016 by using Lookup, Fuzzy Lookup, Derived Columns, Condition Split and Merge Join
  • Created a DTS package to get data from different sources, and consolidate and merge into one single source
  • Actively involved in Normalization & De - normalization of the database
  • Worked in agile methodology to discuss status and product backlog in scrum methodology
  • Involved in Data Extraction, Transformation, and Loading (ETL process) from Source to target systems
  • Deployed SSIS packages and Scheduled Jobs
  • Closely work with ETL SSIS to develop ETL jobs for extracting, cleaning, transforming, and loading data into data warehouses
  • Worked on Data Flow Task, Control Flow Task, Connection Manager, Parameters, and Error Handling to make sure the packages are not failed
  • ETL Transformation of various packages by the client's business needs
  • Created Log Files so that in case of Package failures the errors could be troubleshot
  • Created Script tasks to check for the existence of Source files for a specified amount of time
  • Developing SQL code for execution of packages to run in the QA database

Education

Master's - information technology

Florida Institute of Technology
Melbourne, FL
05.2024

Bachelor Of Science - Computer Science

University of Illinois at Chicago
Chicago, IL
05.2019

Bachelors - computer applications

Veer Narmad South Gujarat University
Surat, India
05.2010

Skills

  • Azure
  • Bitbucket
  • Jenkins CI/CD
  • Git Bash
  • IntelliJ
  • SDLC
  • Unix
  • Kafka
  • LLMSuite
  • Oracle PL/SQL
  • Python
  • ETL processes
  • SQL development
  • Data visualization

Websites

Certification

  • Microsoft Certified Azure Fundamentals, 2022-05
  • Microsoft Certified Azure Data Fundamentals, 2022-06

Timeline

SQL Data Engineer

JPMorgan Chase & Co
12.2022 - 05.2025

Senior SQL Server Power BI Developer

PLS Financial Services
06.2021 - 11.2022

MS SQL / SSIS Developer

Aetna Medicaid
06.2019 - 05.2021

Master's - information technology

Florida Institute of Technology

Bachelor Of Science - Computer Science

University of Illinois at Chicago

Bachelors - computer applications

Veer Narmad South Gujarat University

Similar Profiles

CREATE PROFILE