Philip White
Senior Data Engineer at Kornerstone Administrative Services, LLC- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Credentials
-
Database Design Specialist
CIWcertifiedApr, 2015- Sep, 2024 -
CIW JavaScript Specialist
CIWcertifiedDec, 2013- Sep, 2024 -
CIW Web Design Specialist
CIWcertifiedSep, 2013- Sep, 2024 -
CIW Web Foundations Associate
CIWcertifiedApr, 2013- Sep, 2024 -
CompTIA A+ ce
CompTIAMay, 2013- Sep, 2024 -
CompTIA Network+
CompTIANov, 2014- Sep, 2024 -
CompTIA Security+
CompTIAJan, 2015- Sep, 2024
Experience
-
Kornerstone Administrative Services, LLC
-
United States
-
Motor Vehicle Manufacturing
-
1 - 100 Employee
-
Senior Data Engineer
-
May 2023 - Present
- Performance tune SQL Server and queries - Performance tune SQL Server and queries
-
-
-
Adobe
-
United States
-
Technology, Information and Internet
-
1 - 100 Employee
-
Senior Business Intelligence Developer
-
Dec 2021 - Apr 2023
- Develop MSSQL database objects that support PowerBI dashboards - Support the Compensation Management platform development - Encouraged use of best practices in database development, architecture, and task management - Develop MSSQL database objects that support PowerBI dashboards - Support the Compensation Management platform development - Encouraged use of best practices in database development, architecture, and task management
-
-
-
InMoment
-
United States
-
Software Development
-
500 - 600 Employee
-
Senior Database Engineer
-
Sep 2019 - Dec 2021
- Saved over 10 TB of disk space, with no decrease in performance, by implementing standardized indexing - Deployed a login tracking system to the SQL servers using Extended Events and PowerShell - Created a Power BI Dashboard for the Login tracking system, making it easy to identify the busiest clients - Code reviewed SQL and database design to ensure design best practices, performance, and SQL coding best practices were maintained - Saved over 10 TB of disk space, with no decrease in performance, by implementing standardized indexing - Deployed a login tracking system to the SQL servers using Extended Events and PowerShell - Created a Power BI Dashboard for the Login tracking system, making it easy to identify the busiest clients - Code reviewed SQL and database design to ensure design best practices, performance, and SQL coding best practices were maintained
-
-
-
Edge by Ascential
-
United Kingdom
-
Software Development
-
100 - 200 Employee
-
Senior Database Engineer
-
May 2018 - Sep 2019
- Identified bottlenecks in our three 50+ TB MySQL databases and worked with development team and SRE team to implement solutions enabling us to improve performance by 10x with virtually zero downtime - Tuned MySQL’s configuration for improved performance on Azure’s largest instances - Prototyped an improved database schema that would have improved performance by another 10x - Wrote stored procedures, SQL-based user-defined functions, and utilized temporary tables and CTE’s to load data into the new database - Designed and built table structures for Snowflake Data Warehouse - Championed better data architecture planning as the company grew into their Snowflake Data Warehouse Show less
-
-
-
Spring Mobile
-
United States
-
Wireless Services
-
500 - 600 Employee
-
Data Architect / Database Developer / DBA
-
Sep 2015 - May 2018
- Architected the vision for the database and combined reporting solutions for three companies with over $1 Billion in revenue - Developed stored procedures and ETL jobs that combined diverse data sources, significantly increasing the reliability of the data, and keeping costs of data acquisition low - Recommended BI tools to the business and built robust data models to service those tools - Led a team of SQL developers that built and maintained the imports and helped with reporting requests - Built a data warehouse that powered all sales reporting across three companies - Designed, built, and implemented an EAV database. The EAV reduced the time required to ingest new data sources and make that data available in the reporting warehouse by over 50% - Standardized SQL code and code reusability in the EAV database ecosystem using dynamic SQL which reduced SQL development time by 80% Show less
-
-
-
Zions Bancorporation
-
United States
-
Banking
-
700 & Above Employee
-
Qlikview Developer/Financial Analyst
-
Jan 2014 - Aug 2015
- Develop highly analytical and detailed Qlikview dashboards dealing with data such as loans, delinquencies, commitments, and other credit related metrics - Provide data modeling and SQL expertise and assisted in the creation of efficient data models - Define, develop, and champion friendlier UI/UX of Qlikview Dashboards - Develop highly analytical and detailed Qlikview dashboards dealing with data such as loans, delinquencies, commitments, and other credit related metrics - Provide data modeling and SQL expertise and assisted in the creation of efficient data models - Define, develop, and champion friendlier UI/UX of Qlikview Dashboards
-
-
-
C.R. England
-
United States
-
Transportation/Trucking/Railroad
-
700 & Above Employee
-
Qlikview Developer/Business Intelligence Analyst
-
Apr 2013 - Dec 2013
- Pioneered sustainable Qlikview data architectures and data management practices through standards-based SQL and Qlikview development - Provided guidance to the team and business on Qlikview data modeling and data architectures. - Build new, and migrate existing, Qlikview dashboards and SSRS reports - Pioneered sustainable Qlikview data architectures and data management practices through standards-based SQL and Qlikview development - Provided guidance to the team and business on Qlikview data modeling and data architectures. - Build new, and migrate existing, Qlikview dashboards and SSRS reports
-
-
-
MarketStar
-
United States
-
Outsourcing and Offshoring Consulting
-
700 & Above Employee
-
Senior SQL Developer and Reporting Team Lead
-
Aug 2012 - Apr 2013
Maintain, manage, and create reporting for internal and external clients and be a subject matter expert for other Data Specialists and Market Analysts.- Train new Data Specialists in best practices and in internal work processes- Assist in the management of team priorities- Communicate to analysts, managers, and directors on task progress and roadblocks- Utilize Microsoft SQL Server, Microsoft SQL Server Reporting Services, and Qlikview to process and create reports that present data accurately, efficiently, and aesthetically- Integrate reporting and web applications to improve the user experience- Create and design data models and dynamic dashboards using Qlikview- Look-and-Feel design implementation of Qlikview dashboards and Microsoft SQL Server Reporting Services (SSRS) Reports- Use Microsoft SQL Server Integration Services (SSIS) to retrieve, clean, and import data into the database Show less
-
-
SQL and Reporting Developer
-
Apr 2007 - Aug 2012
Maintain, manage, and create reports for internal and external clients.- Use Microsoft SQL Server and Microsoft Reporting Services to create reports that present data accurately, efficiently, and aesthetically.- Create and design data models and dynamic dashboards using Qlikview.- “Look and Feel” design implementation of Qlikview dashboards and Reporting Services Reports.- Use Microsoft Integration Services (SSIS) to retrieve, clean, and import data into the database.- Communicate to analysts, managers, and directors on task progress and roadblocks. Show less
-
-
Education
-
2013 - 2017
Western Governors University
Bachelor of Science (B.S.), Information Technology-Software -
2006 -
New Horizons Computer Learning Center
-
2005 -
Davis Technical College
Community
