Uploaded File
add photo
Patrick
patrick.w.wheeler@gmail.com
636-399-1855
Jacksonville, FL 32246
IT Business System Analyst
10 years experience W2
0
Recommendations
Average rating
21
Profile views
Summary

Data and Business Analyst professional with 10 years of technology experience. Most recently, spent 6 years supporting and working with relational and dimensional databases along with requirement gathering, analysis, dashboard design and reporting. Natural communicator who takes pride developing relationships, internally and externally. Service oriented personality who enjoys assisting customers and clients. Enjoys knowledge sharing with management and teammates. Strong data background, including the development of SQL queries, jobs, reports, views, data manipulation and data scrubbing.

Experience
Contractor
Information Technology
Feb 2020 - present
  • Provides database support and testing by using T-SQL to identify data issues and then reporting out to peers and management
  • Develops several dashboards in Power BI showing the status on infrastructure that was coming to end of life, grouping by different dimensions
  • Assists middleware (Biztalk) developer with analysis and testing on changes to invoice and purchase order tables. (Header and Detail)
  • Leads and executed on L2 integration mapping effort (Visio), including order to cash through supply chain and logistics. This included all databases, applications, API's and EDI document types.
  • Managed workflow with the use of JIRA, creating and managing epics, stories and task.
No skills were added
Remove Skill
IT Business System Analyst
Insurance
Sep 2019 - Jan 2020

  • Models Continuous improvement data into understandable summarized sets of information for organization design and optimization.
  • Facilitates requirements capture and knowledge sharing between multiple IT and business teams in order to establish agreement on supporting documentation, such as business requirements documents and instruction guides
  • Works with strategy team to ensure tactical work effort is in alignment with strategic vision
  • Enhances Digital Asset Management Tracking Access database, including custom SQL queries for updates, adds, deletes and views.
  • Creates and manages dashboards in Power BI to reflect progress of the project using key performance indicators
  • Analyze sales and enrollment data, monitoring the flow of information from EDI files and internal systems
  • Creates, manages and collaborates in JIRA leveraging Epics, Stories and Task
BSA SQL System Analysis
Remove Skill
Senior Field Sales Analyst
Healthcare
Dec 2018 - Feb 2019

  • Creates interactive sales dashboards and reports using Business Objects and Tableau
  • Provides reporting for all sales consignment medical surgical materials
  • Reviews and investigated sales discrepancies using SQL on large data sets
SQL
Remove Skill
Senior Business Intelligence Analyst
Manufacturing
May 2017 - Dec 2018

  • Responsible for reporting and analyzing sales, marketing, and customer operations data for the 2nd largest cable provided in the United States, accounting for 24 million sales annualized, at a rate of 2 million month over month
  • Mines and interrogates Teradata and Microsoft data warehouse and data marts with SQL to uncover insights into database tables and views identifying trends, patterns and quality issues
  • Works with business units to model external disparate data sources for ETL into business intelligence data marts
  • Participates in requirement gathering sessions, discussing and capturing requirements for reporting dashboards
  • Designs test plans for assigned projects, including data intake, fact table transformations and dashboard design
  • Creates reports in MicroStrategy for internal team and key stakeholders. Allowing users to slice and dice data, aggregate and customize their own look and feel.
  • Managed workflow with the use of JIRA, creating and managing epics, stories and task.
Business Intelligence Data Warehousing ETL MicroStrategy Requirements Gathering SQL Teradata
Remove Skill
Senior Business Analyst
Chemicals/Pharmaceuticals
Aug 2014 - May 2017

  • Manages Group Purchasing Organization (GPO) data warehouse that accounts for ~13 billion in spend, averaging over 200 million, month over month
  • Participates in requirement sessions gathering, discussing and capturing requirements for online catalog and supplier portal
  • Investigates and solves data issues within drug pricing catalog including price discrepancies, data integrity issues and data integration feeds
  • Designs and develops reports in Business Objects and Power BI, including supplier reporting, accounts receivables, spend, volume and auditing
  • Mines and interrogates Microsoft SQL Server data warehouse and data marts with SQL to uncover insights into database tables and views identifying price discrepancies, quality issues and additional opportunities
  • Acted as the product owner for an in-house catalog system, which provided our participants an interface into our pricing catalog.
Business Analysis SQL
Remove Skill
Business Analyst
Hospitality and Entertainment
May 2013 - Jul 2014

  • Responsible for creating reports for management and operation teams, utilizing Microsoft Excel linked to Microsoft SQL Server
  • Provides QA testing, data management, troubleshooting and data validation on Microsoft SQL relational databases for several in-house built applications
  • Leverages SQL to uncover insights for marketing and operation teams, including the construction of key performance indicators and operational metrics
  • Develops and modifies VBA scripts to assist operations and marketing team, automated tasks driving down resource utilization time and overall work effort
Business Analysis Microsoft Excel SQL
Remove Skill
Asset Management Analyst
Healthcare
Feb 2013 - Apr 2013

  • Quality assures several asset management databases validating data to ensure the fit for ETL into new asset management database
Asset Management
Remove Skill
Service Delivery Lead
Biotechnology
Mar 2011 - Jan 2013

  • Reports to senior management on the performance of the operation including key performance indicators and service level agreements
  • Provides service desk support
  • Responsible for managing any new initiative that related to the service desk or desk top support teams including charter design facilitation and status updates to all interested parties
No skills were added
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Master's in Business Administration
Western Governors University
Bachelor's in Administration
Missouri State University
Certifications
Teradata Database Certified Associate
461 Querying Microsoft SQL Server 2012/14
CSM Certified Scrum Master
Essential Design Principal for Tableau - Coursera
Fundamentals of Visualization with Tableau - Coursera
Visual Analytics with Tableau - Coursera
Skills
SQL
2020
6
Business Analysis
2017
3
Business Intelligence
2018
1
Data Warehousing
2018
1
ETL
2018
1
Microsoft Excel
2014
1
MicroStrategy
2018
1
Requirements Gathering
2018
1
Teradata
2018
1
Asset Management
2013
1
BSA
2020
1
System Analysis
2020
1