Larry Wang Email & Phone Number

Toronto, Canada Area

Design SSIS packages including master (parent) package and slave (child) packages to extract data from source to stageDesign the audit packages in professional methodCreate Stored Procedure, use cursor to check table

Beijing City, China

Worked as a BI consultant in Data warehouse and BI division, responsible for analyzing, designing, implementing and maintaining data warehouse, BI/ETL solutions for variety industry clients. Example project:Analyze, design and build an effective cigarette sales data mart for market analysis for following star schema methodology. Project includes collecting and analyzing business requirement, identifying measures, dimensions, attributes and hierarchies, mapping data from source to target, and creating dimension and fact tables in the sales data mart.Design, create and maintain Sales cube using SSAS. Project includes defining cube dimensions, generating attribute hierarchies and relationships, adding calculated members and processing cube.Design and implement ETL solutions for Sales data mart that extract market data from csv files and SQL Server database, load data to SQL Server database, as well as export data from Sales data mart to a third party FTP site that facilitates online reporting. Programs are developed with SSIS packages, stored procedures, stored procedures, views and functions. Configure, deploy and schedule jobs for SSIS packages to be executed automatically. Implement best practices to maintain optimal performance.Develop and maintain ETL modules for Activity Based Costing Distribution data mart that sources cigarette delivery volume data and user maintained account mapping data from Oracle database and merge into cube staging database using SSIS packages, stored procedures, views and functions. Optimize SSIS package design, troubleshoot and resolve performance issues.Design, code and test highly interactive SSRS reports for various sales metrics providing parameterized, drilldown and drill through features for sales and cost analysis. Create highly visual dashboards, scorecards, KPIs using SSRS and PerformancePoint. Work closely with marketing and sales team to determine report specifications.

Beijing City, China

Working for different projects:Example project:Performed data analysis and modeling for building an integrated multiservice access device and electric equipment, system management database used for real time monitoring and troubleshooting in a given network topology. Created database, including tables, indexes, views, stored procedures, user defined functions in SQL Server 2005. Developed SSIS packages to migrate data from Oracle to SQL Server database for historical data archiving and reporting. Configured, deployed and scheduled jobs for the SSIS packages for ETL automation. Wrote sophisticated stored procedures to aggregate data to address performance requirement.Developed and documented SSRS dashboards for device error status and connectivity monitoring. Generated Excel reports for device distribution, performance, network traffic analysis. Worked closed with DBA for performance turning and optimization.Performed conformance, functional, performance, stress test on a brand new Central Office product from its early stage to release.Configured SQL Server 2000 and Oracle SQL database parameter files to adjust the memory usage and file size.Created database tables with various constraints including primary key, foreign key, etc.