UVU• Built Power BI reports that pulled data from SQL server which had a copy of the Ellucian Banner database• Converted thousands of lines of Oracle SQL to Microsoft T-SQL for an Azure database migration project. This dramatically lowered Oracle support and infrastructure costs• Wrote complex T-SQL based upon end user requirements• Edited and wrote SQL to build custom solutions for the Ellucian Banner platform (an Enterprise resource planning (ERP) system) in Oracle & Azure• Learned the Ellucian Banner database data model• Worked on Python code to could convert Oracle SQL to Azure T-SQL• Wrote DAX formulas inside of Power BI• Pulled in multiple tables/views from multiple database into Power BI and built data models• Used Jira to track progress of projects • Build detail data dictionaries for tables/views for the Ellucian platform.• Build detail data flow diagrams in VisioPPG• Built Power BI reports that pulled data from SQL server that contained a mirrored copy of the QAD database & then blended the data with Kronos (UKG) data which came from a Google BigQuery cloud database• Pulled in multiple tables/views from multiple database into Power BI and built data models• Wrote DAX formulas inside of Power BI• Wrote complex T-SQL based upon end user requirements• Converted QAD (an Enterprise resource planning (ERP) system) reports into SQL Server SQL code• Learned the QAD, & Kronos UKG data models• Used Azure DevOps to track progress of projects • Build detail data dictionaries for tables/views for Google BigQuery and QAD. These were extremely helpful as no documentation had been created by the team• Build detail data flow diagrams in Visio

Data Visualization - Tableau• 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)• 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 serverDatabase 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• Wrote Python code to automate work

Data Visualization - Excel• Created and generated daily, weekly, monthly, quarterly, and yearly reports on CDMA and EVDOtechnologies 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-monthcomparisons• Developed and documented KPI (key business goals), & systems performance metrics (operational)• Created ad-hoc emergency reports for management as needed, including nights and weekendsProgramming 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• Automated the building of Excel reports that contained charts and graphs showing daily, weekly, yearly stats.• 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 serversDatabase and Web server admin• Developed, administered, and supported a Microsoft SQL server, web server, and file server for theEast Region Engineering Department