David Ee Email & Phone Number

Drove comprehensive design and implementation of a new data warehouse process for data consumption regarding organizational data warehouse standards and regulations. Collaborated with ETL developers to cement specifications, documentation, and development of data migration mappings and transformations. Assisted with establishment of coding and process standards, driving code review and automation of ETL processes as needed. Created and implemented SSIS packages to migrate data from DB2/Oracle Servers to SQL Servers as well as scheduling SSIS packages. Utilized proven and demonstrated knowledge of SQL Server Job Agent to schedule lengthy jobs to better process during off hours and reduce server traffic during peak business usage. Successfully implemented SCD standard processes for data warehouse and business needs.Ensured proper documentation management of all aspects of development for team reference on Confluence including dataflow, jobs, and tables. Built and sustained strong relationships between multiple departments and organizations to better address user technical issues and concerns during development and testing.

Phoenix, Arizona, United States

Designed and implemented comprehensive database models for cube structure utilizing SQL Server Analysis Services. Drove underlying dimensions and fact tables based on business and user requirements. Effectively optimized dimensions and fact tables through clustered and non-clustered indexes. Cemented cube optimization through creation of partitions and calculated members enabling faster query returns. Implemented SSIS packages to better migrate data from DB2 servers to SQL Servers including scheduling of SSIS packages as needed. Successfully participated in cube development and testing through active meetings with business users. Ensured proper documentation of cube development for user reference including dimensions, attributes, hierarchy, and fact table measures.