fan y

Datawarehouse Designer - 7 Years of Experience


Datawarehouse Designer

Education Level:


Will Relocate:



Summary of Qualifications 9 years+ of experience in ETL/DW design and Report development Experience Summary Job Title: Sr. Data Warehouse Developer Employer: Western Dental Service Service Period: 09/2016 - 10/2017 * Used TALEND ETL tool to import data from outside website and MSSQL (2014). * Used Tableau (10.4) to generate graphic report for stakeholders. * Used PowerBI and designed few reports on MS AZURE cloud platform. * Created stored procedures, SSIS packages, and used other methods to import/translate/manipulate data. * Analyzed potential data quality issues to determine the root cause, and creating effective solutions. * Optimized processes involving large data sets to improve performance. * Worked with stakeholder to understand their business, and make recommendations to help solve problems or improve processes. * Delivered high quality projects on time and budget in fast paced environments Job Title: BI Specialist Employer: Newegg Inc., Industry, CA Service Period: 08/2009 - 07/2015 * BI ETL/DW Backend Architect. * Experience in database design using Stored Procedure, Functions, Triggers and strong experience in writing complex queries for MSSQL Server. * Experience with COGNOS 8, developed many Crystal reports and web reports. * Worked on overall functionality of the projects including internal logic, data integration and internal build process development using T-SQL. * Data Architecture (Conceptual, Logical, Physical) experience involves building 3 Normal form & Star Schema {Dimension (Slowly Changing, Snowflake, Conformed Dimensions), Fact, Metrics, and KPI}. * Complete ETL schedule and flow to fit SLA, mapping design, Error handling and Workflow Design on SSIS (2008) and TALEND. * Worked on Databases like SQL Server 2005, SQL Server 2008. * Designed Data Warehouse with 2+ TB of Compressed Data and ETL layer loading 80 million records for one adapter with multiple batch size. Job Title: BI Team Leader