Table of Contents

Data Migration

Problem Statement

Required to consolidate data from three different systems and migrate to CRM

Method and Solution

I cleaned and processed the data from all three different systems in R (Programming Language).

Stored the processed data in three different data frames and then built a function to rename column names from all the data frames so that they are consistent.

Then it was finally time to merge data frames into a single data frame and export it.

Process Flow Schema

Final Result

Once it is all done the exported data was able to migrate to CRM successfully.

Auto Bidding

Problem Statement

I wanted to automate the online bidding process for time efficiency.

The process of online bidding is; where you bid and wait for others to bid and if the others do not bid within the duration you win the bid. So it is very time-consuming.

Method and Solution

So I created two Python scripts one for the main automation and one for pulling the data from the auction site both of the scripts work concurrently.