Power Bi Business Process

Paul Pitcher

Orem, UT 801-***-**** ***********@**.***

LinkedIn: https://www.linkedin.com/in/paul-pitcher-6861652/

Accomplished Business Process Analyst with experience spearheading the design and deployment of data driven solutions, reduction in data retrieval times and a substantial increase in organizational efficiency. Adept at creating dynamic Tableau & Power BI dashboards and reports, achieving a rise in user adoption and a marked improvement in strategic decision-making for senior management. Recognized for driving significant enhancements in ETL, data processing speeds, and data quality allowing executives to be able to make data driven decisions.

EXPERIENCE

Insight Global (Dec 2023 - Dec 2024)

Business Process Analyst

Insight Global is a global staffing and services company specializing in sourcing IT and engineering professionals.

Built Power BI reports & Data models that blended data from multiple databases (SQL server, Ellucian Banner database, QAD database, Kronos (UKG) Google BigQuery cloud database).

Weekly calls with end users to make sure Power BI reports meet end users needs.

Built data models, DAX formulas, data dictionaries & data flow diagrams

Built reports that monitored the health of the data

Daily calls with junior developers training them in best practices, and review of projects

Converted thousands of lines of Oracle SQL to T-SQL. Task required mapping Oracle functions to their T-SQL equivalents. SQL queries often pulled data from 5–9 tables, requiring clear join structures to maintain readability and accuracy. Common Table Expressions (CTEs) were used for readability and simplification of complex logic.

Proficient in T-SQL, with SQL Server Management Studio (SSMS) as the preferred development environment.

Power BI visualizations highlighted key metrics such as employee hours worked and parts produced. Anomalies were also discovered such as employees logging over 200 hours per week, working while on vacation, and receiving pay without producing products in the factory.

Provided weekly analysis highlighting key trends and anomalies for management focus.

Used Jira & Azure DevOps to track progress of projects

T-Mobile (Aug 2011 – Nov 2023) 12 years

Business Intelligence Analyst

T-Mobile is a cell phone provider with about 99 Million U.S. customers

Developed/Supported 1,400+ detail and summary reports, trend analysis reports and sub-reports according to end user business requirements using Tableau

Developed and published Tableau reports that pulled data from over 500+ tables, 5+ billion rows of data, & 8 different database platforms (Azure, SQL server, Oracle, Maria DB, and MySQL, Hadoop, Netezza, & Teradata)

Managed and trained onshore and offshore contractors and vendors for database migrations, ETL mediation, troubleshooting data flow issues, and best practices for data visualizations.

Built reports for engineers and managers that condensed 11,144 parameters and 100+ million rows of data into simple data visualizations

Developed SON opportunity dashboard providing 6.6 Million opportunities for engineers across the country to work on over a 2 months’ time frame that would improve cell site performance.

Developed a sleepy cell report that highlighted 7,243 non-compliant sites across the country over a 7-week time frame

Created & repaired 140+ Tableau data extracts. Tableau server admin for 1000+ users. Migrated 100+ reports & data extracts to a new Tableau server Database development & programming

Used SSIS to build ETL packages to import 70,000+ Cisco csv files into department data warehouse

Wrote T-SQL queries. Identified, researched, & repaired breakpoints in data flow (raw files, ETL, SQL, python, tables, views, & reports). Identified, tested, & optimized billions of rows of data migrated from SQL server to Azure data warehouse.

U.S. Cellular (Mar 2004 – Aug 2011) 7 years

Business Intelligence Developer

U.S. Cellular is a cell phone provider with about 5.8 Million customers

Created daily, weekly, monthly, quarterly, and yearly reports on CDMA and EVDO technologies on the activity of 1.5 million customers

Created detailed monthly reports and dashboards based upon Nielsen’s drive test data of Verizon, AT&T, T-Mobile, & U.S. Cellular

Created exception reports using 3 standard deviations, year-over-year, and month-over-month comparisons

Developed and documented KPI (key business goals), & systems performance metrics (operational)

Created ad-hoc emergency reports for management as needed, including nights and weekends Programming experience (VBA - Visual Basic for applications)

Developed code that automated work flow that saved department over $200,000 per year in labor cost

Pulled cell site stats from an Oracle database and then to send this information hourly to engineers via text messages

Build an ETL (extract transform load) that imported excel files into a database

Developed code to Automate add hock engineering projects. Wrote code to zip & unzip files, creating and send emails with attachments, saving attachments from emails to file servers, and moving files between servers Database and Web server admin •

Developed, administered, and supported a Microsoft SQL server, web server, and file server for the East Region Engineering Department

EDUCATION

High School Diploma

Contact this candidate