Sonia Sun

Experience

1. Data Architect

   Wesco

   Oct 2022 — Present

   Wesco is a major supply chain company in the U.S. It focuses on commercial markets means we are ready and able to solve your challenges. Our knowledge and experience in serving specific industries enables us to meet needs better with the right expertise, and by supplying solutions to keep business advancing.\\\\n\\\\n• Created complex SQL script in Teradata and SQL server such as stored procedure, T-SQL, Dynamic SQL script, function, tables, views, joins.\\\\n• Responsible for creating, debugging, and modifying stored procedures using T-SQL.\\\\n• Analyzed existing SQL quires/procedures for performance optimization and troubleshooting issues.\\\\n• Prepared documentation and specifications for database objects like stored procedure and tables.\\\\n• Created ad-hoc queries to provide information requested by business users.\\\\n• Worked on MS Excel like pivot tables, v-lookup, functions, and formula.\\\\n• Created and developed complex reusable ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.\\\\n• Designed and developed packages to Extract, transform and load data using SSIS which utilized tasks and transformations such as Execute SQL Task, Data Flow, Sequence container, Conditional Split, Data Conversion, Derived column and Multi casting etc.\\\\n• Extensively experience with SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints and scripting.\\\\n• Responsible for creating reports based on requirements using Power BI and Tableau.\\\\n• Designed and built inter active dashboard using MS Power BI and Tableau, provided comprehensive data visualization and analysis.\\\\n• Used power query, power pivot and DAX function for ETL operation in Power BI and Tableau.\\\\n• Created measure in power BI and Tableau.\\\\n• Responsible for Data testing and validating Power BI and Tableau DASHBOARD with the database and source data.\\\\n• Experience in Database Backup, Recovery and Disaster Recovery procedures.\\\\n \\\\n\\\\n \\\\n \\\\n\\\\n \\\\n