Diana Dinshaw

ETL Reports for Data Driven Decision Making:

Data extracted from a database using SQL queries is transformed using python/pandas and then saved in json and csv format. The data is loaded on schedule through SFTP and archived on the server for ten days.

Responsibilities

• writing and testing the SQL queries
• transforming the data using python/pandas to be stored in csv and cascading json formats
• uploading the data through a SFTP on schedule

Tools and Technologies

• SQL, Pandas, Python, Jupyter, Task Scheduler, PyCharm

Reporting and Analytical Tool:

A tool built for internal users using Python and the Django web framework. The front end utilizes JavaScript, and uses Redux as a data store, and native web components for dynamic analytic dashboards.

Responsibilities

• adding features to the application using Python and JavaScript
• building visualizations using Plotly

Tools and Technologies

• SQL, Python, Jupyter, PyCharm, Django framework, Task Scheduler, Plotly

EXHIBITS AT THE MET:

Used the museums's open sourced API to randomly retrieve some information of an object exhibited at The Metropolitan Musem of Art.

Responsibilities

• writing the code in javascript
• presenting the information on a Bootstrap webpage

Tools and Technologies

• JavaScript, HTML/CSS (Bootstrap), VSC, API

Cycle Ridership:

Compared data from March 2018 with data from March 2019 to determine if there was an increase in overall ridership, in women riders and change in user type.

Responsibilities

• ETL (cleaning the data using MySQL)
• visualizing the data in Tableau
• plotting the bike stations using Leaflet
• creating a table using JavaScript
• presenting the information on a webpage using flask and deploying on Heroku

Tools and Technologies

• JavaScript, Leaflet, d3, Python, Pandas Flask, MySQL, Tableau, HTML, VSC, Jupyter

Software Engineer

Key Achievements

• Communication: Consult with the team for clarity and details on project needs and share code during code reviews. .
• Strategic Thinking: Evaluate applications to determine actions that can be automated for monitoring, reducing workload for the team.
• Result Oriented: Develop, and test application monitors in New Relic that alerts on-call team member of outages to take actions in a timely manner.

Software Developer

Key Achievements

• Communication: Consult with the client for clarity and details on project needs and performance. Analyze ongoing requirements of the clients to recommend modifications to the existing systems.Consulted with the client on project needs and performance.
• Strategic Thinking: Monitor and evaluate applications to improve performance to be prepared for the evolving needs of the client.
• Result Oriented: Designed, developed, and tested applications for clients that allows client to make data driven decisions.

Specialist - Exceptional Student Services

Key Achievements

• Communication: Developed standard operating procedures (SOP), which communicated best practice and expectations for 21 on site teams to maintain consistent results.
• Strategic Thinking: Initiated and designed a dashboard on SharePoint, which decreased navigation time and made for more efficient use of resources.
• Result Oriented: Spearheaded the automation of data collection and through manual testing ensured excellent usability of a professional development registration system on Qualtrics.