Prajakta Iyer

I am a recent graduate from the University of Illinois at Chicago. I completed my masters in Management and Information Systems. I have 3+ years' experience in software engineering and am transitioning into a career in Data Analytics. I am passionate about working with huge datasets and uncovering valuable insights from them. I am proficient in SQL, Python, R and Tableau and am currently looking for full-time work opportunities.

Email / Resume / LinkedIn / Github

Education

University of Illinois at Chicago
M.S. in Management and Information Systems
August, 2019 - May, 2021 (Expected)

Relevant Coursework:

Data Visualization, Data Mining, Big Data Analytics, Graph Databases, Advanced Database Management, Cybersecurity, Statistics for Management

University of Mumbai
B.E. in Computer Engineering
August, 2011 - July, 2015

Relevant Coursework:

Analysis of Algorithms and Design, Data Structures, Database Management System, Computer Networks, Data Mining, Software Engineering, Operating System, System Security, Compiler Construction.

Professional Experience

ADA Great Lakes University of Illinois at Chicago
Graduate Research Assistant
January, 2020 - Present
Technologies: Google Analytics, .NET MVC, Entity Frameowork, SQL Server, AWS EC2

Implemented modules for screen reader- friendly web applications for specially-abled users.
Integrated Twitter API to dynamically manage social media feed of Great Lakes ADA enhancing social media engagement.
Designed and deployed Python scripts using NumPy and Pandas to automate attendance management of webinars which reduced processing time by 50%.

OntoAdaptive
Data Analyst Consultant (Intern)
January, 2021 - May, 2021
Technologies: TigerGraph, Neo4j, Bloom

Conducted comparative analysis of the performance of two vendors, TigerGraph and Neo4j using Synthea dataset.
Designed GSQL and Cypher scripts to perform ETL, built a data model and established traversal through all medical events of a patient.
Developed patient trajectory and event-based models to observe trends in disease and patterns in treatment.
Built visualizations using Bloom and Graph Studio to identify influential nodes and traverse graphs with user-controlled path expansion.

Tata Consultancy Services
Systems Engineer
August, 2015 - October, 2018
Technologies: ASP.NET, .NET WebAPI, Entity Frameowork, SQL Server

Implemented modules for workflow management software to manage over 300K visa processing requests per month using .Net and SQL
Designed migration and data aggregation scripts for multiple production databases.
Managed regular Backup and Restoration activity of databases hosted on multiple servers
Prepared Microsoft SSRS reports integrated with stored procedures to study business trends.
Developed modules for GST integration automating tax calculations using .NET Web Forms with SQL Server.
Designed complex SQL queries to automate the Health Insurance policy generation process to improve efficiency by 30%.
Implemented SQL Server jobs to automate the processing of claims, reducing process time by 50%.
Monitored and presented findings of Database traffic and reduced server load by 25%.
Conducted regular training sessions for team members.

Projects

These are some of the academic and personal projects that I have really enjoyed working on.

	Data Cleaning in SQL on Nashville Housing data SQL In this project, we clean the "Nashville Housing" data in SQL Server.
	Covid Data Exploration in SQL SQL In this project, we explore Covid-19 data in SQL Server.
	Tableau Visualizations Tableau Contains some of my data vizualization dashboards.
	Correlation in Python using the Kaggle Movie Industry dataset Python, Tableau Cleaning, formatting the dataset to test correlation between different variables and visualizing the results.

Updated 07/2021
(borrowed from here)