Aaron Smith
Tampa,FL
Summary
Proficient tester, designer and debugger with an in-depth understanding of building and running automated systems for Jira. Well-versed in the full project lifecycle, technical support needs and project coordination functions. Excellent communication, organizational and interpersonal skills.
Overview
10
10
years of professional experience
1
1
Certification
Work History
Business Automation Specialist
The Mellick Group
Tampa
03.2023 - Current
- Utilize API connections for diverse applications, enhancing data integration and automation efficiency for management team members to review over 100+ employees performance quickly.
- Spearhead automation of data extraction and manipulation processes using SQL, streamlining reporting and analysis workflows to ensure accounting team members has up-to-date data to report out to C-Suite level management.
- Expert in handling CSV files, transforming and automating data for enhanced efficiency
- Facilitated seamless communication with non-technical team members and leadership, translating technical concepts
- Leverage PowerBI integration for optimized reporting solutions for multiple teams including accounting, C-suite level executives, and customer success.
Decision Support Analyst II
Masonite International
Tampa
07.2021 - 03.2023
- Continuously implementing Jira Service Management solutions to provide a better user experience for 10+ orgs and 10K+ users
- Utilize frequent inter-departmental communication and escalations within the Application, Web, and Configuration Development teams for quicker resolution of issues
- Successfully launched 4 service management projects including a service management portal, knowledge base, and a project plan template for future project implementations
- Performed Data Mining and reporting for internal and external communication purposes using SQL, JQL, Excel, and Power BI
- Designated as the dedicated subject matter expert and trainer on Masonite's proprietary pricing, tool and for Jira Service Management
- Created technical documentation and FAQ guides for distribution to customers and internal stakeholders on all tools supported.
Support Analyst
Masonite International
Tampa
04.2018 - 07.2021
- Connected with our customers weekly to go over open issues, feedback, and overall engagement/adoption of the Max and eMerge tools
- Communicated with developers and product owners to understand the root cause of an issue and possible solutions
- Utilized JQL to retrieve relevant data to Jira Dashboards for management and extracted data into CSV files and imported the data into Power BI
- Designed visual reports in Power BI utilizing Jira data, based on stakeholder requirements, to assist in business decisions such as deciding to have an SME from USA Wood Door available on live chat
- Applied logical techniques to describe and illustrate data for customers and stakeholders to evaluate using Power BI
- Collaborated with external marketing team to showcase KPIs for eMerge tool, with Power BI dashboard
- Developed SQL queries that brings in back quotes/orders, utilization, and product mix for various data being used by management for insight into Max
- Led a team of 5 including developers and QA analyst to identify and remediate issues, including archiving over 1 million records in a SQL database, which resulted in a performance increase of over 70% increase to all of our Max users
- Configured Jira Service Desk for our Customer Support team and Customers, with input from stakeholders and executives
- Automated JIRA ticket assignments and notifications for Support Representatives and improved workflow for our Support team with the goal of improved support request response times.
Technical Developer
Electronic Data Inc
St. Petersburg
08.2015 - 01.2018
- Created daily, weekly, and monthly Ad Hoc reports using SQL queries for various departments in the client's organization
- Updated client data using update statements in SQL when the issue couldn't be resolved on the UI
- Taught administrative classes on best practices and debugging issues to external clients
- Wrote detailed instruction documents on how to implement fixes and/or upgrades into a Production environment, which included risk, level of effort, downtime estimate, and steps to rollback.
Developer
BNY Mellon
New York
01.2014 - 02.2015
- Led a team of 10 through the development process of an InfoPath application, which was recognized and implemented by C Suite-level management
- Created and explained various workflows developed in Visio, to ensure understanding for BNY clients with projects in the pipeline
- Assisted in the gathering and analysis of data for developing and modifying IT systems
- Normalized raw data through the use of charts, pivot tables, and slides with Microsoft Excel, Visio, and PowerPoint to ensure team consensus regarding project prioritization
- Utilized the Agile software development lifecycle in order to develop applications that were used by thousands of internal clients
- Developed and tested six unique InfoPath applications that provided key solutions for BNY clients.
Education
Business Administration -
Post University
01.2017 - 01.2017
Computer and Information Systems - undefined
Post University
Skills
Microsoft SQL Server
Technical Support
Data Collection
Test cases
Testing scripts
Automation design
Customer Relations
Automation
Solution development
Power BI
APIs
Certification
Project+, CompTIA - July 2021
Timeline
Business Automation Specialist
The Mellick Group
03.2023 - Current
Project+, CompTIA - July 2021
07-2021
Decision Support Analyst II
Masonite International
07.2021 - 03.2023
Support Analyst
Masonite International
04.2018 - 07.2021
Business Administration -
Post University
01.2017 - 01.2017
Technical Developer
Electronic Data Inc
08.2015 - 01.2018
Developer
BNY Mellon
01.2014 - 02.2015
Computer and Information Systems - undefined
Post University