Rebekah Russell

Data Analyst

Patch Monkey•  March 2022 - April 2023

● Junior data analyst role working on project collecting cattle data on an individual level throughout the agricultural feeding, treatment, and harvest processes ● Coordinated with head data analyst and client to translate business needs into data solutions ● Collaborated with developers to create data movement and database objects to be implemented in web reports and application pages ● Aided in early development of dbt implementation ● Developed, optimized, audited, peer-reviewed, and refactored new and existing SQL queries based on principles of data accuracy, integrity, and relevance to client Tools, Skills, and Languages Used: Advanced PostreSQL, independent research, collaboration with cross-functional teams, data presentations, Basecamp, Pivotal Tracker, dbt, Sublime Text, Datagrip, Heroku, Git, Github

Database Progammer

Metro Technology Centers•  November 2018 - February 2022

● Started in enterprise application management role and was promoted to position working with district databases; basic duties included enterprise application management, basic database maintenance, general data solutions, ad-hoc reporting, basic application server maintenance, data visualization ● Created ad-hoc reports or database structures and movement to meet the data needs and requirements of cross-functional teams, coworkers, some state data reporting, and to create data visualization dashboards for IT help desk performance monitoring and for marketing, finance, and student services departments using SQL, Oracle APEX, and Sisense/Periscope ● Some troubleshooting, updating, and maintenance of Oracle packages, procedures, and functions ● Some work with Excel macros and VBA - a portion of these that required collaboration moved to using Google Sheets, Excel online and Google Apps Script/Office Scripts/Power Apps solutions I created ● Created and maintained data automation and integration solutions via SSIS, Microsoft Power Apps, Visual Studio, SQL Server Agent, SSMS, SFTP transfers, and some Python ● Assisted with projects such as database migrations, student information system development, and automated district-wide daily health screenings and alerts to aid the district’s pandemic safety efforts Tools, Skills, and Languages Used: Intermediate T-SQL, Intermediate PL/SQL, PHP, HTML, Python, MariaDB, Advanced Excel, Linux, SQL Server Management Studio, SQL Developer, TOAD for Oracle, installing new SQL Server instances, creating new database users with appropriate permissions for application use and data automation processes, Google Apps Script, Microsoft Office Scripts, Google for Education, Sisense/Periscope, Oracle APEX, SSIS, Tortoise SVN, Zapier, working with legacy on-premises databases, Linux servers, and Windows Servers, Notepad++, Visual Studio, Microsoft Access, Stripe, Rave Alert, Microsoft Dynamics, Microsoft Power Apps, working with cross-functional teams, extensive documentation of resources and data automation processes

University of Oklahoma

Information Science, BA•  August 2013 - August 2018

Tools, Skills, and Languages Used: MySQL, Apache, PHP, Academic Research, Academic Presentation, Technical Writing, Statistics, Sublime Text, HTML, CSS, Javascript, R, R Studio, Excel