Aimee Guffey
Technical Business Analyst
Belle,MO
Summary
Technical Business Analyst with 10+ years of experience supporting business solution software and analyzing business operations within large, corporate environments. Broad experience partnering with software developers and business teams on various global applications. Strong technical background includes creating SQL scripts from scratch, querying databases.
Extensive experience leading Agile-based ceremonies, sprints, backlogs, and process flows throughout the project lifecycle.
- Responsive expert experienced in monitoring database performance, troubleshooting issues and optimizing database environment. Possesses strong analytical skills, excellent problem-solving abilities, and deep understanding of database technologies and systems. Equally confident working independently and collaboratively as needed and utilizing excellent communication skills.
Overview
13
13
years of professional experience
Work History
Data Engineer / Infrastructure Analyst
Thermo Fisher Scientific
05.2021 - 11.2021
- Requirement gathering for deploying security patches to enterprise environment for 1,200 Linux Server (Red Hat, Ubuntu, CentOS) during Prod, Non-Prod patch cycles
- Created T-SQL queries by exporting Jira data and reconciling in Excel, using Pivot tables and interactive dashboards
- Created stories, issues and tasks, created workflow processes and worked on backlog issues in Jira
- Built strong relationships with Server Application Owners to deliver initiatives on time and within budget
- Worked with Delivery Team in software, BMC Truesight to schedule and deploy patches
- Exported data out of Jira into excel, reconciled and uploaded reconciled data to SQL server for Asset Management team.
Data Analyst
Washington University
02.2020 - 11.2020
- Performed comprehensive data analyses for “Workday Project,” which led to migration of 1,500 reports from legacy systems to new reporting platform for HR and finance
- Enhanced speed of data collection and analysis upon identification of patterns and ways to reduce or combine information
- Created automation of manual processes to aid stakeholders.
- Collaborated with stakeholders to identify business needs and data sources
Business/Data Analyst
Charter Communication
08.2019 - 02.2020
- Identified business requirements, and prepared functional analysis in aid of system design for customer service portal
- Completed more than 300 Jira backlog issues that had been previously incorrectly assigned, were out of scope, or were put on hold
- Worked with customer service portal for adding data elements to application (Java-based application)
- Served as a liaison between Java Developers and business owners throughout project
- Created test SQL data validation queries using Window functions (First Value, Lag, Aggregates and Rank
- Attended and led Agile meetings for multiple teams for customer service portal
- Incorporated systems changes, by updating APIs and tested using SOAPUI
- Updated API mapping documents, ensuring documentation was updated in GitHub.
Business/Data Analyst
Cushman & Wakefield
09.2018 - 03.2019
- Managed a team of offshore Software Developers to develop system processes for a survey web-based portal
- Responsible for data validation received from major clients prior to commencing data analysis and final deliverable release
- Successfully implemented over 30 clients to the new portal, which enabled clients to see results through Power BI graphs and charts
- Worked with offshore Software Developers to create web application portal for survey results
- Created test SQL data validation queries using functions such as Date, Nulls
- Distinct, Case Statements
- Led Agile meetings with offshore developers and business teams.
Enterprise Data Steward (Contractor)
Bayer
07.2016 - 08.2018
- Served as a lead data analyst for a revenue and pricing optimization project for the global sales team
- Applied various data validation methods to ensure the accuracy and quality of collected business intelligence
- Reviewed company documents to identify areas to improve security compliance
- Facilitated meetings with data stewards from other countries with the goal of automating a global solution for the pricing application
- Worked on pricing application using Java
- Worked with two development teams (back-end and front-end)
- Data experience includes common table expressions (CTE), pivot, creating, altering drop and delete tables as needed
- Led Teams in Agile / Kanban and created process workflow processes and built dashboards in Jira
- Bullet about source control and source code repository in this role (if so, what specific repository used?)?
- For source code repository used SwaggerHub to document processes.
Data Analyst
Nestle Purina
03.2015 - 07.2016
- Performed data analysis and mapping processes in order to provide functional business intelligence to the design, testing, and implementation of new business operational processes
- Reviewed the company’s operations to identify areas for improving compliance with local, federal, and industry regulations
- Worked on Pricing application for Walmart pet food data using VBA
- Attended standup daily meeting and led as needed
- Provided analytical support to various projects involving the integration of automated systems into the Consumer-Packaged Goods Sales Reporting system for Walmart.
Data Analyst
US Bank Home Mortgage
02.2014 - 03.2015
- Oversaw Business Intelligence Analyses with keen focus on improving compliance with regulatory agencies and provided compliance visualizations for the leadership team
- Led meetings with Business, Architects, Developers and Management on sprint activities
- Collaborated with architects creating the information architecture for data warehouses
- Worked with Star and Snowflake data modeling and used dimension and fact tables to query
- Reviewed new data elements before sending to reporting team.
Sr. Data Analyst
Midwest Employers Casualty Company
08.2008 - 02.2014
- Led the data analysis process for the company’s data business intelligence for claims, payment, and medical implementation
- Created source to target mapping document for EDI collection
- Created systems and processes for the underwriting, actuarial, finance, predictive analytics, and claims departments focusing on standardizing data collection processes
- Upload of monthly client data reviewed and researched for pass/fail security.
Education
BS - Data Analytics
2023
No – currently pursuing with estimated completion in, Year completed
Varsity Tutors - Advanced SQL, Python, Business Analysis
AAS - Computer Information Systems
2022
Maven Analytics
Tableau, Power - undefined
2022
Advanced Excel
Office 2019: Microsoft Office Specialist: Excel Expert - undefined
2022
Level & Concentration - undefined
2021
Skills
- Data extracting
- Data analyzation
- Analyzing data
- Data reconciliation reporting
- Data-driven decision-making
- Data quality controls
- Data analysis and assessments
Timeline
Data Engineer / Infrastructure Analyst - Thermo Fisher Scientific
05.2021 - 11.2021
Data Analyst - Washington University
02.2020 - 11.2020
Business/Data Analyst - Charter Communication
08.2019 - 02.2020
Business/Data Analyst - Cushman & Wakefield
09.2018 - 03.2019
Enterprise Data Steward (Contractor) - Bayer
07.2016 - 08.2018
Data Analyst - Nestle Purina
03.2015 - 07.2016
Data Analyst - US Bank Home Mortgage
02.2014 - 03.2015
Sr. Data Analyst - Midwest Employers Casualty Company
08.2008 - 02.2014
- BS, Data Analytics
Southern New Hampshire University - AAS, Computer Information Systems
- Tableau, Power,
- Office 2019: Microsoft Office Specialist: Excel Expert,
Tyler Jr. College - Level & Concentration,