Post Job Free

Resume

Sign in

Data Migration Business Analyst

Location:
Indianapolis, IN, 46202
Posted:
October 19, 2023

Contact this candidate

Resume:

RIDDHI VORA

ad0hvw@r.postjobfree.com www.linkedin.com/in/riddhivora23/ Contact Number: 774-***-**** EDUCATION

Northeastern University, Boston, MA. Expected: May 2024 Master of Science in Information Systems

Focus Area: Business Analyst, Data Visualization, Data Engineer Thakur College of Engineering and Technology, India. Aug 2017 - May 2021 Bachelor of Engineering in Electronics & Telecommunication Engineering Focus Area: Database Management Systems, Data Compression and Encryption WORK EXPERIENCE

IT Intern, Business Analyst Department, Bista Solutions, India July 2019

• Worked on large dataset and performed data cleaning in Talend, resulting in an 18% improvement in data quality

• Modified process of Automation Tips and Tricks using Talend Open Studio for ETL, resulting accurate data by reducing errors

• Developed a data visualization in Tableau and PowerBI that improved Stakeholder’s understanding by 40% Intern, Vividh Bharati Service, All India Radio, India June 2019

• Trained in Networking and communication, Department Intern

• Attained in and out of radio communication and transmission, like broadcasting of signals

• Developed insights about modulation of signals, transformation of data and Antenna design PROJECTS

Analysis of restaurant performance Feb 2023

• Staged the data to a local database and established a profiling process to investigate the data and identify irregularities using Alteryx

• Created and carried out data cleansing procedures to detect and manage instances of missing values, outliers, and conflicting data entries, leading to an improvement in data quality by 23%

• Designed ETL pipelines in Talend for loading the data from the stage table to the warehouse and constructed a dimensional model for the warehouse

• Executed with Tableau and PowerBI to visualize the data based on the inspection results to identify the restaurants with the worst and best results

Analyze Kaggle Dataset using Auto Machine Learning (Dataset: Bank Personal Loan) Jan 2023

• Gained knowledge for creating and analyzing the predictive models using AutoML library like H2O.ai. also found a significant correlation in the data (random dataset picked from Kaggle) for each algorithm in python.

• Performed Exploratory Data Analysis by identifying missing values, outliers, and inconsistencies in the data

• Analyzed the dataset with Model Interpretability using SHAP with unified and consistent way to interpret the predictions of machine learning models.

Revenue Generation of the Massachusetts Bay Transportation Authority (MBTA) Nov 2022

• Developed a logical database that is normalized to the 3NF Form, then transformed it into a physical database for implementation

• Encrypted using the AES algorithm and an encryption key, and triggers and stored procedures were created to effectively log the data and produce the desired reports TECHNICAL EXPERTISE

• Programming Languages: Java, HTML, C, C++, CSS, Python, R

• Database: SQL, MYSQL, Oracle, SQL Server, PostgreSQL, MongoDB

• Tools and Applications: Lucid Chart, AutoCAD, Terraform, GitHub, Docker, AWS, MATLAB, Smith V.4, AutoCAD, Scilab, Hadoop, Minitab, GitHub, Windows, Linux, PowerShell, Google Colab, Visual Studio

• Data Visualization: Tableau, Microsoft Power Bi, Microsoft Excel, Google Analytics, BigQurey

• Data Modelling and Engineering: ER Studio, Navicat, Alteryx, Talend, Tableau Prep, Informatica, Redshift, Minitab, Databricks, AWS EMR

• Other: Strong Data management, Data visualization, Problem Solver, System thinker, Self-directed



Contact this candidate