David Hao Email & Phone Number

Burlington, MA

• Providing SQL BI/data warehouse consulting service to multiple clients for their marketing campaign solutions.
• Design from scratches, maintain, and add new features to existing DW/BI systems for multiple clients. Communicate with clients collecting new requirements, translate into technical design, document data modeling and.
• Write complex store procedures and functions, work on performance tunings, review index usage, and work on large table partitioning (sliding windows scenarios). Stay tuned in new database technologies.
• Create SSIS to load multiple source data (flat, xml, excel files) to staging tables, and process them into data warehouse. Worked on loading decrypted data between different database platforms (SQL Server and Netezza).

Leading a team maintaining and upgrading the company’s real-time data warehouse system by providing clean, accurate, and up-to-date data to main product of APM portal. Maintain ETL framework to guarantee data warehouse in a low-latency from operational data system. Researched into the existing design to identify the ETL bottle neck and provide solution.