RJ Wang SSIS
No reviews yet

• Over 10 years of experience in database development, data modeling using SSIS, ADF, SSMS, ERWIN, Azure Data Studio, TFS, Oracle SQL Developer, Power Designer. Support of Azure SQL database, MS SQL Server ********* 012/2008R2 in production, test, and development environments.
• Expertise in database developer designing and creating database objects including tables, views, stored procedures, triggers and functions.
• 5 years Enterprise Data Warehouse, BI development experience using BIDS/SSDT including star schema design, ETL solution using SSIS package, SSAS cube design and development and building reports using SSRS.
• 3 years SQL Server administration experience including installation, configuration, maintenance and optimization of SQL Server HA/DR solution including Failover Clustering, Log Shipping, Database Mirroring, Replication and Always-on.
• 1+ years Oracle admin experience with Oracle Database 11g OCP certification.
• Excellent analytical, communication and interpersonal skills.

Subjects

  • SQL Server Expert

  • ETL SSIS Beginner-Expert

Experience

  • Software Engineer (Oct, 2018–Present) at TD Bank Group,Toronto,Canada
    • Designed and developed the canonical layer data models of the CDS project (Central Data Store) using ERWIN.
    • Built some of the ETL solutions using SSIS/ADF.
    • Involved in design and development the ETL solution using Microsoft SSIS for the data migration project and cooperated with BA, QA and DBA solve the problem of testing and deployment in different environment of DEV, UAT, PROD including creating for each containers, parameterized flat file connecting, data flow tasks, script tasks, xml configuration files, logging setting in SSIS and tables, views, synonyms and store procs in SQL Server 2016 database.
    • Developed Analysis Services Project. Responsible for identifying and defining Data Source and Data Source views. Created cubes and defined the dimensions.
    • Designed and developed SQL Server Analysis Services (SSAS) databases and OLAP cubes used in ad-hoc analytic research and automated reporting using Snowflake
    • Defined attribute properties in a Parent Child Dimensions. Responsible for hiding and disabling attributes hierarchies. Sorting attributes members based on a secondary attribute.
    • Defining relationships between Dimensions and Measure groups. Involved in the design and development of the SSAS cubes and MDX queries
    • Managed index, statistics and optimizing queries by using execution plan for tuning the database.
    • Responsible for performance tuning and optimization of store produces by enhancing the database instance, improving the SQL Queries, index and data modeling.
    • Created and enhanced ETL solutions transfer data from different source like Oracle DB, Other SQL Server DB, flat files, Excel files by using SSIS packages, BCP command, store procedures, ad-hoc.
    • Involved in the BI project which calculate and visualize around 20 KPIs base on collection and call center data using SQL Server 2017/SSAS/Power BI. My responsibility including develop star schema data model of the data warehouse and store procs/script populate these tables, design and dimensional modeling using SSAS cubes, Created Hierarchies, Aggregations, partitions, calculated members and KPIs in Dimensional Modeling.

Education

  • Master's Degree in Computer Science (Sep, 2003–Jul, 2006) from University of science and technology of china

Fee details

    CA$60–90/hour (US$41.67–62.50/hour)

Reviews

No reviews yet. Be the first one to review this tutor.