Professional Data Analyst

Faith Pack

***********@*****.*** Birmingham, Alabama 205-***-****

https://www.linkedin.com/in/faith-l-pack

Professional Summary

Perceptive and logical data analyst with ability to communicate with stakeholders, technical professionals, and end users. Experienced in curating and translating business requirements, managing data through the ETL pipeline, organizing and modeling data for analysis, and producing reports and dashboards for supplying analytical results and recommendations for actions backed by data. Offering over fourteen years of experience in data modeling, data governance frameworks and policies, and data management processes. Analytical and statistical data professional using modern statistical methods in analysis. Established leader of cross-functional teams to develop improved processes to meet business goals.

Professional Experience

McLeod Software Birmingham, AL

Director of Enterprise Analytics March 2022 – Currently Employed

Coordinating all corporate-wide efforts for internal reporting, deployment, and use of connected data sources in development of enterprise data models, governance, analysis, and designing understandable and actionable dashboards, using Power BI, R and R Studio, Excel, and, Tableau, for internal stakeholders and management were target metrics of this position. Team engagement through effective communication and collaboration using Agile method and managed using Jira and Confluence.

Developed and implemented enterprise data governance policies to control access, integrity, reliability, and availability of data and systems

Produced executive analytical reports utilizing data visualization techniques through Power BI and RStudio

Managed cross-functional team of six formed of data analysts, architects, and BI developers for enterprise analytics

Developed and implemented enterprise KPI’s aligned to company business goals making these available for all levels of management for the first time, prompting conversations and data driven decisions

Interpreted data, analyzed results using statistical techniques and provided ongoing reports using SQL, R, Power BI, and Excel

Developed and implemented databases, data collection systems, data analytics and other strategies that optimized statistical efficiency and quality using SQL Server and Azure

Acquired data from primary or secondary data sources and supported databases/data systems

Identified, analyzed, and interpreted trends or patterns in complex data sets using Excel, Power BI, and R

Filtered and “cleaned” data by reviewing computer reports, printouts, and performance indicators to find and correct code problems

Collaborated with executive staff to prioritize business and information needs resulting in unified data reporting

Located and defined new process improvement opportunities leading to increased data integrity, completeness, and efficiency

Divurgent Virginia Beach, VA (Fully Remote from Alabama)

Financial Data & Reporting Analyst August 2021 – February 2022

Data analysis and designing understandable and actionable dashboards, using Power BI and DOMO, for internal stakeholders and management is the focus of this position. To compile data for analysis and visualization, multiple tools were used including SSMS, SSIS, Visual Studio, Azure SQL database and data warehouse, Excel, and Azure Data Studio. Success in this position required team engagement through effective communication, collaboration and using the SCRUM agile method for dashboard development.

Performed in-depth data analysis using R/RStudio and SQL to facilitate strategic decision making for management

Analyzed marketing efforts brand promotion through conventional(email) and non-conventional digital marketing

Built trend analysis models to watch profit and loss, gross margin, A/R aging, and sales revenue forecasting to guide strategic planning across the organization

Managed team of six responsible for gathering periodic and ad-hoc reporting requirements for internal and external stakeholders

Established and implemented KPI’s to measure company performance in Revenue, COGS, Expenses, Net Income, Sales Revenue, Actual vs. Budget, and Cash Flow

Conducted business requirement analysis for multiple projects leading to resource optimization

Developed corporate data governance policy, procedures, and implementation processes

Analyzed and communicated reporting results to stakeholders making recommended courses of action

Designed ETL processes to migrate and transform data from Salesforce, Paycom, and QuickBooks in an Azure SQL enterprise data warehouse

Merged and transformed data from QuickBooks, Paycom and Salesforce using Excel functions (X-Lookup, V-Lookup, PowerPivot, and Power Query)

Oversaw sales pipeline beginning with marketing/lead acquisition up to deal closing utilizing KPI’s from different channels (Google AdWords, Google Analytics Tools, and Social Media efforts)

Process Equipment, Inc. Pelham, Alabama

Data Analyst August 2017 – August 2021

Accurately communicating the insights SQL derived through data analysis was primary goal of my in this position. Visualizing these insights depends on the use of specific data analysis tools as an advanced user. Tools include MS SQL Server, SSMS, SSAS, SSIS, SSRS, Python, MS Excel, MS Power BI. The ability to mine data from multiple sources, Salesforce, MS Dynamics GP 2018, and data warehouse, is crucial in presenting an exact snapshot of performance in KPI's. Effective team leader who supports growth opportunities of team members to drive a culture that values creative problem solving, collaboration, and communication leading to increased efficiency and productivity. Being an effective communicator is crucial to all stages of the analytical process.

Saved $145,000+ in subcontracting and overtime costs by integrating data from Salesforce and MS GP Dynamics ERP to analyze quotes, bookings, backlog, and shop capacity/person-hours

Designed, built, and deployed Domo self-service data dashboards reporting the KPI’s of overall corporate performance, sales, accounting, manufacturing, and supply chain

Increased On Time Delivery performance from 71% to 82%, exceeding target KPI goal, using Gap Analysis to supply insights

Saved ~$132,000+ in raw material procurement costs using a time-series analysis allowed buying ahead of predicted price increases

Team leader in GIS mapping project incorporating customer location, plant location, and sales order amount used to target new sales opportunities using ESRI GIS

Found and documented detailed business rules, user stories, and use cases based on requirements analysis

Presentations to key stakeholders highlighting insights and providing recommendations for strategic data-driven decisions

Designed systematic processes improving data standardization, data integrity, data validation, and data quality, decreasing errors in data duplication, data entry, and data degradation

Implemented training process in Microsoft Dynamics GP ERP, increasing data quality for workflow processes

Project manager for implementing training process for Office 365, MS Teams, SharePoint, One Drive for Business, and MS Planner, increasing employee engagement and collaboration of remote and on-premises employees

Coordinated the collection, input and reporting of company-wide inventory, supply chain and sales data

Used statistics for inferential, predictive, prescriptive, causal, descriptive, and exploratory data analysis producing valuable insights into the data

Shelby County School System Columbiana, Alabama

Data Manager/Trainer November 2009 – March 2017

As the District Data Manager for over 32,000 student records, holding data on demographics, enrollment history, health data, grades, and transcripts, I took on a variety of roles to meet the needs of the district. Leadership, management, problem solving, collaboration, and communication skills were key components in this position due to the various levels of stakeholders who make important data-driven decisions.

Project Manager for the implementation process and data migration for the newly adopted Student Information System (INOW, now PowerSchool)

Designed processes to increase data quality, validation, and integrity for delivering error free system-wide reporting to the State Board of Education with a 100% approval rating

Created original SQL Queries, stored procedures, data views, and triggers using SSMS to supply real-time data reports to stakeholders

Project manager for the creation of GIS (ESRI GIS) map to plot current student data (location and key demographics) to use in student enrollment trends, future school sites, and improving transportation model

Lead staff development for educators in the use of ESRI ArcGIS for classroom use with students

Utilized a help-desk approach, using Zendesk, to support district-wide staff in the user interface of state-adopted Student Information System (SIS)

Conducted monthly SIS user group meetings for training and standard procedures

Conducted "just in time" training plan to support current and future projects

Team leader for the system-wide data dashboard, for all levels of district stakeholders; Used Power BI (2011) to create a real-time “scorecard” that included KPIs leading to insightful data-driven decisions

Managed athlete eligibility status for school athletic directors

Project lead for implementation process of adopted e-transcripts software

Leader for conversion to Google Groups for school listserv communications

High School computer science instructor for JavaScript

Educational Background

University of Alabama

Birmingham, Alabama

Master of Science in Mathematics

Honors Graduate with 3.9 GPA

Endorsements in Educational Leadership and Instructional Technology

Skills

Data Analysis Statistical Data Analysis Data Mining Data Visualizations Data validation Data Insights Presentations User Requirements & Use Cases Domo AWS Jira Confluence Zendesk Instructional Design &Development Technology Training Technical Writing Technology Support and Troubleshooting Effective Communication Creative Problem Solving Collaboration Critical Thinking Growth Mindset Flexibility Team Leadership

Certifications

Microsoft Certified Data Analyst (PL-300) Google Professional Data Analyst Certification Certified MS 365 Fundamentals Certified Online Instructor Proficient in MS SQL Server and services Microsoft Certified Educator Trainer Certified Associate Microsoft Office 2016/365 Alabama Certified Secondary Mathematics Teacher

Scheduled Certifications:

AZ-900 – MS Azure Fundamentals

AWS Solution Architect

Mo-201: MS Excel Expert

CAP: Certified Analytics Professional

Contact this candidate