Varad Desai

Data Science Co-op / Data Engineer Co-op

• Designed a complex medical database on SQL server 2019 using Azure data studio and SQL which would be able to integrate data from multiple existing databases of the company.
• Wrote JSON schema definitions for embedding outlier data points present in the medical and non-medical data of the company.
• Added database-level security to the database by generating multiple roles and creating sample users for each role.
• Programmed ETL processes using the Elixir programming language to transform and load data from the pre-existing databases into the new database.
• Implemented WEB APIs using C# language and .NET framework for pulling out data from every table from the new database and providing a JSON data output on a URL click on a browser.
• Implemented DAO functions using Python language which will use the Web APIs and output the data in the form of Python dictionaries.
• Wrote complex SQL validation queries that can validate and find mistakes in the data present in the pre-existing database.
• Documented each and every work of mine using Markdowns and Word documents in a way that the person who will work after me on this project can start from where I have left.

Software Engineer / Data Engineer

• Automated distributed database process like export, truncate and import into a single workflow using Bash scripts.
• Optimized batch-jobs by transitioning to parallel execution from a linear approach and improved the run time from 7 hours to 30 minutes.
• Migrated almost 500 GB of text-based data into Oracle database of a multi-state beverage distributor.
• Wrote complex SQL to queries for customized customer requirements and developed processes to sync data between multiple landscapes.
• Developed JavaScript code to extract data in JSON form and present it in UI.
• Successfully managed a synchronized Autosave activity wherein 5000 Price Structures were divided among entire team of 11 individuals and the activity was expected to get completed in in stipulated period of time.
• Documented Backend processes for future use and reference and integrated these documents alongside the code files in the system and in SVN making it easy for other developers to understand the processes flow of the system.
• Performed successful Drop Deployment for all the newly developed builds on AWS cloud servers using Linux on PuTTY. Maintained a clean File System containing all the processes, documents, code files.
• Performed weekly data backup activity on our Linux system by synchronizing with the team and client usage timings of the system.
• Interacted with multiple teams within the company to keep all the teams working for the project on the same page which maintained the balance of project work.

Northeastern University