Brandon Rawl
Saint Paul,MN
Summary
Experienced business intelligence professional with expertise in data management, analysis, and reporting. Skilled at fostering team collaboration and adapting to evolving business needs for impactful results. Exceptional analytical skills and a steadfast commitment to data-driven decision making.
Overview
18
18
years of professional experience
1
1
Certification
Work History
Manager, Business Intelligence
SICK Inc
03.2023 - Current
- In this role, I manage the business intelligence team that takes data and transforms it into information
- We utilize the ERP, CRM, and Distribution data and tie it all together to get valuable insights for the company and its internal and external customers
- I also partner with global colleagues from all over to create company-wide tools that push analytics to everyone
- I manage the existing data warehouses and am building a new global one use Iceberg, Trino, Python, and DBT
Sr. Manager of Business Analytics and Data Quality
SICK, Inc
05.2019 - Current
- I am responsible for all things related to business analytics and data quality for our subsidiary in North America
- I manage the development of our data warehouses (MS SQL), analytics cubes (SSAS) and visualizations (Tableau)
- I have pivoted from the Finance function to the Sales function in order to enhance the data that is available to our sales staff and management and provide valuable insights in a timely manner
- I also consult with the other functions in our organization on a project basis as the SME for our systems and development techniques
- In the past year I have built a new application and database to house the data that we get from our distribution partners to replace a legacy system and save the company a significant amount of money on an annual basis
- I have also created reporting in Tableau that allows our sales staff to only see data on accounts that they own in a push vs pull environment to allow them to get the data they need in a weekly e-mail vs having to search for it to increase their productivity and keep them informed
Business Intelligence Architect
SICK, Inc
09.2015 - 05.2019
- I am currently responsible for all of the data for North America
- I work with our global partners in Canada and Germany to ensure transparency in creating a single source of truth in our reporting
- I also work as the DBA for our SQL Server databases
- I handle the ETL going from our ERP (SAP), our CRM (Microsoft Dynamics) and various other source systems into a data warehouse that I built to consolidate our different data
- I report to our local management board (CEO, CFO & President) frequently as well as other business partners and stakeholders on the state of our business intelligence and strategic initiatives
- I built a data warehouse from scratch using all of the various data sources available to us in order to consolidate data for reporting and dashboards
- I designed our Tableau Server environment for reporting and build dashboards for end user consumption
- I helped implement other software by acting as a consultant or developer in order to migrate data
- I took ownership of our major projects related to business intelligence and now serve as the project manager for them
Senior Manager Business Systems Analysis
Ameriprise Financial
06.2014 - 09.2015
- I was the only project member in the asset management finance group to take source documents for all of our products, analyze and optimize them, then bring them into a consolidated warehouse
- Met with key stakeholders and business partners on progress of the project and performed analysis on the challenges that offered up potential resolution paths
- I routinely worked as the representative of my department with other functional areas on tool selection, updates and training for our business intelligence and reporting tools
- The role is that of a Business Analyst, Project Manager, Solutions Architect and Database Designer all wrapped into one
IT Reporting and Business Analyst / Project Manager / Data Management Supervisor
Cargill
01.2013 - 01.2014
- Project Manager for Business Unit Implementations into SAP for Credit and Cash Management Department
- Maintenance and upgrading of reports from Oracle, Crystal Reports, MS Excel, SAP, Business Objects BI, SharePoint, and MS Access
- Fully Documented the Reporting Analyst Role using SharePoint task list synced with Outlook
- Consolidated data from multiple sources (listed above) for enterprise level reporting, supporting ~ 90 employees
- Redesigned VBA modules for flexibility in connecting with our Oracle DB
Sr. Reporting Specialist
LPL Financial
01.2012 - 01.2013
- Absorbed other two Sr
- Reporting Specialist duties into one role
- Rebuilt and created new front end applications using MS Access to MS SQL Server backends for financial/stock monitoring, batch processing, performance monitoring/analysis, as well as automation of existing manual processes
- Used API's for screen scraping data into access for batch approvals, then used the same API to write the changes back to the green screen application
- Development of Use Cases, testing, and projects for SDLC in Agile environment primarily using SQL, SharePoint, and VBA via Access (Pass-Throughs)
- Removed objects from front end and re-built in code to create/delete as needed for cleaner architecture
- This allows for an easier translation of the coding for future implementations or sharing workspaces
- Built system admin tables in our Access db's so that the end users could assign a super user to handle simple user roles, views, etc
Database Developer Analyst - Contractor
Robert Half Technology
01.2012 - 12.2012
- Developed and Maintained Foreclosures Database to track across all US owned foreclosures by the bank
- Developed auditing database to link to and reference 50,000+ clients' invoices
- Made adjustments to existing databases for increased optimization and modified existing procedures into callable functions for re-use
Data/Logistics/Business Analyst
CEVA Logistics
01.2007 - 12.2012
- Primary Analyst for the PM team on the Target Corp
- Account, supporting operations for 100+ employees
- Monitored data quality for all systems for client and 5 operations
- Advanced SQL querying for smarter reporting
- Developed and maintained reporting systems to feed into a designed dashboard that monitored the KPI's for all 5 operations
Education
M.S. - Business Intelligence and Data Analytics
St Mary's University
Minneapolis, MN08.2023
Bachelor's - Management
Metropolitan State University
Saint Paul, MN12.2020
AAS - Computer Technology
Normandale College
Bloomington, MN01.2010
Skills
- Proficient in dbt
- Proficient in Python
- Database Development with SQL Server
- Advanced Excel Proficiency
- Tableau Proficiency
- Data Analysis
- Microsoft Dynamics Expertise
- SQL Proficiency
- Stakeholder Needs Assessment
- Data Warehouse Development
- Data Integration Expertise
- Agile Methodologies
- Data Administration
- Data Analysis Expertise
- Data-Driven Insights
- Business intelligence systems
- Data quality management
- Business intelligence development
Accomplishments
Developed numerous data warehouses and data marts for multiple departments (Sales, FICO, Marketing) using many different tools and platforms.
Certification
Querying Microsoft SQL Server 2012 70-461, 06/01/15, Present
Personal Information
Work Permit: Authorized to work in the US for any employer
Groups
American Mensa, 09/01/09, Present
Timeline
Manager, Business Intelligence
SICK Inc
03.2023 - Current
Sr. Manager of Business Analytics and Data Quality
SICK, Inc
05.2019 - Current
Business Intelligence Architect
SICK, Inc
09.2015 - 05.2019
Senior Manager Business Systems Analysis
Ameriprise Financial
06.2014 - 09.2015
IT Reporting and Business Analyst / Project Manager / Data Management Supervisor
Cargill
01.2013 - 01.2014
Sr. Reporting Specialist
LPL Financial
01.2012 - 01.2013
Database Developer Analyst - Contractor
Robert Half Technology
01.2012 - 12.2012
Data/Logistics/Business Analyst
CEVA Logistics
01.2007 - 12.2012
Bachelor's - Management
Metropolitan State University
AAS - Computer Technology
Normandale College
M.S. - Business Intelligence and Data Analytics
St Mary's University
Similar Profiles
Jascinth Palmer-ReidJascinth Palmer-Reid
Certified Nursing Assistant at Nursing Sisters of the Sick PoorCertified Nursing Assistant at Nursing Sisters of the Sick Poor
Ria ColasRia Colas
Assistant at sick kidsAssistant at sick kids
Sara SalehSara Saleh
Summer Camp Instructor at Camp Kivita -Sick Kids HospitalSummer Camp Instructor at Camp Kivita -Sick Kids Hospital
Mohamed HassanMohamed Hassan
Senior Software Engineer at MedtronicSenior Software Engineer at Medtronic
Ashley BerryAshley Berry
Support Team Manager-Animal Emergency Vet Clinic at Animal Emergency and Referral CenterSupport Team Manager-Animal Emergency Vet Clinic at Animal Emergency and Referral Center