Weidong Ding, Data Warehousing Developer in Vaughan, ON, Canada
Weidong Ding

Data Warehousing Developer in Vaughan, ON, Canada

Member since August 16, 2019
Weidong Ding has proven experience as a senior data/integration architect, recently focusing on SAP Data Services. He's detailed, hands-on, and efficient with comprehensive background planning, designing, and implementing information systems for leading organizations in the banking, transportation, retail, and government sectors. He leverages strong communication and customer service skills, working with clients and colleagues to achieve success.
Weidong is now available for hire

Portfolio

Experience

Location

Vaughan, ON, Canada

Availability

Full-time

Preferred Environment

Microsoft SQL Server, Oracle, IBM DB2, Windows, Linux

The most amazing...

...thing I've done was design the data model and build ETL jobs for the staging database as part of reporting solution for a major bank in Canada.

Employment

  • Senior Integration Architect/Consultant

    2016 - PRESENT
    People’s Data Consulting Inc.
    • Designed SAP Data Services solution to extract data from SAP Successfactors, and load the transformed information into SAP BW.
    • Designed Source-Based CDC and Target-Based CDC logic to generate delta data set, including new, update, and delete records.
    • Designed and developed SAP Data Services jobs to migrate legacy data to SAP systems, include master data and transaction data objects from EAM, HCM, R2R, and S2P.
    • Designed and developed ETL Data Services jobs to extract data from various data sources, transform that data into something useful and then load it into SAP CRM.
    Technologies: SAP ECC, SAP BW, SAP SuccessFactors, SAP BusinessObjects Data Service (BODS)
  • SAP Data Services Consultant

    2010 - 2016
    IBM Canada
    • Led development team for a financial management system upgrade by migrating 20+ data services / FIM jobs from Data Services V3.2 and FIM 7.5 to Data Services 4.2 and FIM 10.0, achieving project deadline.
    • Enhanced financial management solution for one of the major Canadian banks by leading a team of SAP Data Services developers, designing and developing major components, providing the client with data services best practices.
    • Migrated legacy data to SAP ECC for a manufacturing company using BODS. Established BODS development standard for the team, fixed all BODS historic technical issues, and migrated the data services development environment from V4.0 to V4.1.
    • Shortened testing cycle and improved application quality by quickly identifying and pinpointing the root cause of defects during quality assurance (QA) testing for SAP BW, Bex reports, and BODS components of liquidity risk management (LRM) solution.
    • Managed a team of seven business object data services developers, including local and offshore resources, building WSB interfaces, creating an efficient, consistent ETL global delivery team.
    Technologies: SAP ECC, SAP BW, SAP, SAP BusinessObjects Data Service (BODS)
  • Senior Data Architect

    2005 - 2016
    IBM Canada
    • Designed and built a staging database as part of QRM solution for one of the major Canadian banks by gathering business requirements, leading the development team, and delivering multiple releases for QRM solution within a 2-year timeline.
    • Completed the migration of a tax auditing business intelligence solution, including data mining, cubing services, Alphablox reporting, and ETL, for one of the provisional finance ministries in Canada.
    • Built logical data model (LDM) for one of the largest Oracle EBS implementations in Ontario, covering 50 Oracle modules based on customer business service areas and identifying key entities for each service.
    • Delivered one of the largest global resource (GR) programs in Canada by establishing a trusting customer relationship and building stronger DBA/DA teams with improved professionalism and processes, enhancing delivery quality and customer satisfaction.
    • Migrated 10TBytes data warehouse from 10g RAC/Redhat to 11g/AIX.
    Technologies: Data Architecture, IBM InfoSphere, PowerDesigner, Erwin, IIS, Microsoft SQL Server, IBM DB2, Oracle
  • Senior DBA

    1999 - 2004
    IBM Canada
    • Designed and developed SQL stored procedures to populate Tax Processing Data Warehouse and control mechanism by writing 40+ SQL stored procedures to fulfill ETL and controlling requirement, and tuned performance of both application and database.
    • Led DBA team to develop SQLs for UMI project, coordinating SQL team with design team and Java team, working on DB2 performance tuning, problem diagnosis and timely resolution of problems.
    • Designed and developed a web portal system. Used Erwin as a data modeling tool, DB2 Warehouse Manager as an ETL development tool, and built a history database.
    Technologies: Oracle, IBM DB2

Experience

  • Career Zone to BI Project (Development)

    Task Performed:

    • Analyzed data gaps between SAP SF and existing BI platform, performed data profiling on SF data model.
    • Designed SAP Data Services solution to extract data from SAP Successfactors, and load the transformed information into SAP BW.
    • Designed Source-Based CDC and Target-Based CDC logic to generate delta data set, including new, update and delete records
    • Enhanced Bell’s existing SAP Data Services Framework
    • Developed SAP Data Services jobs to load 40 entities to BW

  • Aurora Project (Development)

    Task Performed:

    • Designed and developed SAP Data Services jobs to migrate legacy data to SAP systems, include master data and transaction data objects from EAM, HCM, R2R, and S2P, e.g. WBS element, project definition, task list, equipment, payroll, open reservation, in-progress capital contribution, holdbacks, etc.
    • Created IDocs to direct load into SAP, or flat files to be used by LSMW or ABAP programs.
    • Analyzed data sources and target SAP data model to build data mapping spreadsheets.
    • Built data validation and cleansing rules using Information Steward.
    • Designed sensitive data masking solution for SuccessFactors test systems to mask sensitive personal information, including birthdays, personal emails, SINs, salary info, etc., using OData API and SFAPI (SOAP).
    • Built project delivery reports using Webi.

  • Data Transformation Program (Development)

    Task Performed:

    • Designed and developed ETL Data Services jobs to extract data from various data sources, transform that data into something useful and then load it into SAP CRM.
    • Used PowerDesigner to build DMM models that are used to build initial Data Services jobs.
    • Extracted data from about 30 heterogeneous source systems including RDMSs, flat files, Cobol files, XML files and ECC, BW.
    • Transformed and loaded into the SAP HANA based SAP CRM and IDE server.
    • Created IDocs to load into SAP CRM and HANA IDE. IDE is an integrated data environment, providing near real-time reporting and a 360-degree financial view of customers and partners.
    • Used SAP Information Steward for data quality control and data cleansing.
    • Documented data source inventory, enhanced DS framework design.

  • QRM MR Development (Development)

    Task Performed:
    • Designed the data model and built ETL jobs for the staging database as part of the QRM liquidity risk management solution, to provide regulatory reports for OSFI.
    • Conducted workshops with a business owner from the treasury group to gather, review and clarify business requirements, corporate architecture strategies and directions, data requirements, and business information needs, devising data structures to support them.
    • Built high-level architecture design to confirm integration solution with customers, participating and providing input for data and metadata architecture refinement and complying with corporate data architectures, strategies, and frameworks, including enterprise data warehouse activities and corporate directions relating to time-variant data.
    • Built detailed data mapping, led the development team in building the staging database.
    • Designed and developed a data model that followed the bank’s best practices.

  • TACS Migration Project (Development)

    Task Performed:

    • Completed the migration of a tax auditing business intelligence solution for one of the provisional finance ministries in Canada.
    • The BI solution is based on SOA architecture.
    • Assessed and updated documents for the old environments, include applications, databases, and OS, built the migration plan, obtained the consensus with the customer regarding the role and responsibilities
    • Successfully completed the migration of the solution to InfoSphere Warehouse Server 9.7.3 and Information Server 8.7, including components for data mining, cubing services, Alphablox reporting, and ETL jobs

  • IFIS Baseline Architecture (Development)

    Task Performed:

    • Led a data model team of four data architects.
    • Upon review of existing corporate architecture strategies and directions, worked with the architect team and client stakeholders to devise new data structures to support new strategies, directions, data requirements and BI needs to improve the corporate architecture.
    • Designed, developed and maintained the Logical Data Model (LDM) and Conceptual Data Model (CDM) for one of the largest Oracle e-Business Suite (EBS) implementations in Ontario using SAP PowerDesigner.
    • Complied with the corporate repository metadata directions while creating and documenting.
    • Provided team members with technical assistance and expertise in the use and optimization of data modeling techniques, guidance and direction in terms of data analysis and modeling through team meetings and one-on-one sessions.
    • Worked with stakeholders at all levels within the organization including senior managers and data architects, and facilitated business and process model sessions to aid in the development of data modeling and metadata policies and procedures
    • Facilitated workshops with SMEs, provided guidance to the team members with data modeling best practices.

  • Contact Center Reporting Solution (Development)

    Task Performed:

    • Worked on the complete life cycle of project planning, requirement collection, solution design, development, and implementation. Adopted DevOps in supporting period.
    • Led a DBA team; designed, developed and implemented the contact center reporting solution.
    • Performed source system analysis, data profiling and data quality assessments.
    • Designed, developed, enhanced and maintained data models for staging, operational data store (ODS) and reporting data mart using Erwin.
    • Provided guidance, direction and technical assistance to team members and report developers in the use and optimization of data analysis and data modeling techniques through one-on-one sessions, team meetings, and online conferences.
    • Liaised with senior management and technical team leads in order to fully define the organization’s data access strategies.
    • Performed data and meta-data architecture refinement, mapping exercises and data analysis because of updated requirements and participated in the development of data modeling for staging, operational data store and reporting data mart using Erwin Data Modeller as well as participated in the development of meta-data policies and procedures.

Skills

  • Languages

    SQL, C, C++
  • Paradigms

    ETL
  • Platforms

    Oracle, AIX, Windows, Linux, SAP HANA, Hortonworks Data Platform (HDP), Apache Pig
  • Storage

    Database Management, IBM DB2, SQL Server 2010, Microsoft SQL Server, Apache Hive
  • Other

    Data Architecture, Data Warehousing, Data Modeling, SAP Data Services, Data Analytics, InfoSphere Data Architecture, WebSphere Information Integrator, SAP BusinessObjects Data Service (BODS), SAP ECC, SAP, IIS, IBM InfoSphere, SAP BW
  • Tools

    PowerDesigner, Erwin, SAP SuccessFactors, IBM InfoSphere (DataStage), IBM SPSS, Sqoop
  • Frameworks

    Spark, Hadoop

Education

  • Bachelor of Science degree in Applied Physics
    1985 - 1990
    Tsinghua University - Beijing, China

Certifications

  • HDP Certified Spark Developer
    SEPTEMBER 2017 - PRESENT
    Hortonworks
  • HDP Certified Developer (HDPCD)
    AUGUST 2017 - PRESENT
    Hortonworks
  • SAP Certified Application Associate – SAP HANA 1.0
    JUNE 2013 - PRESENT
    SAP
  • Oracle Database 10g Administrator Certified Professional
    MARCH 2005 - PRESENT
    Oracle
  • Certified DB2 Administrator
    MAY 1997 - PRESENT
    IBM

To view more profiles

Join Toptal
Share it with others