Andy Philips Email & Phone Number

Prosper, TX, US

Dallas, Texas, United States

• Assumed responsibilities for the Design and Development of ETL solutions for internal company project
• Designed a Comprehensive Performance Checking (CPC) process that eliminated over 10% of operational expenses by inspecting queries, procedures, and scripts, identifying bottlenecks, and boosting performance.
• Invented parametrized procedures to automate the creation of complex SQL scripts based on metadata and text inputs, saving over 500 hours for developers and improving the error… Show more
• Invented parametrized procedures to automate the creation of complex SQL scripts based on metadata and text inputs, saving over 500 hours for developers and improving the error tolerance of the whole system.
• Proposed and implemented several system improvements, some of which became development standards within the team, driving continuous improvement.
• Provided internal trainings for Team Developers about best practices and Performance Development, which drove up the overall team performance by around 15%

Plano, TX

• Assumed responsibilities for the Design and Development of ETL / BI solutions for company management and board reporting in the service domain
• Optimized monthly snapshot process for a 20-billion-row fact table, improved load efficiency, bringing it down from 18 to 12 hours and saving 3 GB of monthly storage.
• Developed a revolutionary algorithm for Trip Calculation, integrating fragmented data points into a cohesive source, creating an important data source for board-level… Show more
• Developed a revolutionary algorithm for Trip Calculation, integrating fragmented data points into a cohesive source, creating an important data source for board-level analysis.
• Modernized procedure for a Data Mart load, which significantly increased data accuracy and boosted the performance by 50%.
• Designed a High-Performance SQL row data parsing method, reducing load duration from 100+ hours to 3 minutes for a table with hundreds of millions of rows.

Plano, TX

contract

Austin, Texas Area

• Assumed responsibilities for SSRS and SSIS development for business solutions in the service domain
• Implemented Incremental load process with SSIS for a table (hundreds of millions of rows) that does not have any timestamp
• Led the training of a new developer to improve his abilities in T-SQL and SSRS strongly
• Designed SSIS package for finding deleted rows in a source table and deleting them in the destination
• Developer parametrized reports that customers could configure… Show more
• Developer parametrized reports that customers could configure for their needs

Plano, TX

• Assumed responsibilities for SQL database development on MS SQL 2016 for client’s solutions
• Using triggers created complicated data check and validation to dozen of crosslinked related tables
• Created complex built-in Data warehouse tables (like balance) for complex front-end application reports. All these tables were updated on-flight with control of negative balance
• Remodeled indexes, and statistics to increase the performance of application reports
• Designed and… Show more
• Designed and implemented a new database working with the remote application development team Show less

Moscow, Russian Federation

• Assumed responsibilities for designing and developing business solutions for the company’s clients, leading development teams, inspiring and mentoring team members
• Designed and implemented a parametrized discount system, calculating discounts on-flight for the front-end application.
• Led design, development, and implementation of the build of the whole BI system (Data warehouse, ETL, Reports) from scratch for multiple clients, working closely with business owners and/or management