Shelly-Ginelle Sicat

Data Scientist & Software Engineer
HomeAboutportfolioCOntact
Close
HomeAboutPortfolioContact
Back to Portfolio
Work Experience

Script Automation

Automating data input, calculations and output to reduced time spent on reoccurring reports

Status:

Categories:

Data Engineering, Data Science, Data Analysis

Technology:

Python, Adobe Analytics, TeamCity

Links:
TEAM:
  • Critical Mass

Overview

  • There exists multiple reports that client expects on a daily, weekly or monthly cadence which makes up 2-3 analyst's time.
  • ~20 hours is spent on reoccurring reports each week.

Solution

  • Implemented python scripts to handle retrieving data inputs, perform tedious calculations and provide a formatted output for reporting purposes.
  • Managed existing ones and migrated them to a TeamCity implementation or centralized them on a remote desktop for easy team handoff.

Results

  • Reduced 60% of time spent on data collection, calculations and dissemination.

Learnings

  • Limitations on Team City limit what you can automate.
  • Database management and maintenance is crucial.

You might Also Like

Development, Research

Human-Robot Collaboration

A wizard-of-oz experiment that incorporates the drama exercise, mirror game, to observe human-robot collaboration

Read More
Development, Data Analysis, Research

Wearable Technology for Ride Safety Evaluation

Developing a set of wearables to record g-force exerted on a ride participant exposed to 8 degrees of freedom

Read More
Data Analysis

Data Science for a Non-Profit Organization

Volunteering as Manager of Analytics & Insights at Chic Geek

Read More