Dengwei Yang

FAQ About Dengwei Yang

• What is Dengwei Yang's address?

  Dengwei Yang is located at
  Acton, Massachusetts, United States

• What is Dengwei Yang's job title?

  Dengwei Yang is a
  u2022 Implanting a date warehouse using a cloud based data warehouse tool called Birst. Fully in charge of the full development cycle: data extracting from CRM database, ETL design, data model design and report building. u2022 In charge of Sql Server 2008 R2 database projects maintenance and deployment. Perform daily database status monitoring using ignite 8 and newrelic. Trouble-shot and fix database performance issues. u2022 Create stored procedures, UDFs, triggers etc. to support business logic. Handle daily service request. u2022 Create SSIS packages to extract information from system and generate reports for both internal and external users. u2022 Works in an agile team to deliver product in a faster and more efficient way.u2022 In charge of database re-structure to support better performance. With pushing business rules into tables, pre-calculating most of the summary data, achieved 75% reports performance improvement compared to existing system. u2022 Query performance monitoring and tuning, indexes managing and table partitioning (MS SQL Server and oracle 10g/11g/Exadata). u2022 Built and maintaining data infrastructure and ETL to support business analysis using various data sources. u2022 Worked on all phases of data warehouse development lifecycle: Cognos server deployment, ETL, Model design, report design. u2022 Participated online support, end user training and business rules/working flow documentation.production release. Closely worked with other developers to identify the business entity. u2022 Designed and implemented a web crawling/Spider system to collect college information from various sources. Built C# utility tools to facilitate the data de-duplication, normalization, and transformation process. u2022 SQL Server 2008 maintenance, stored procedures design and performance tuning according to application business requirement. u2022 Implemented an Auto PDF Filling/Exporting feature.u2022 Successfully migrated applications to the production environment while providing both technical and functional support to internal customers. u2022 Database design for an e-commerce site using SQL server. Coded hundreds of stored procedures to support the business logic (Searching, listing, update shopping cart etc.).Perform database maintain, backup and restore. u2022 Managed multiple simultaneous projects, successfully meeting all budgets and time-frames. Arrowstreet Capital

• What industry does Dengwei Yang currently work in?

  Dengwei Yang currently works in the
  Arrowstreet Capital

• What is Dengwei Yang's area of expertise?

  Dengwei Yang specializes in
  u2022 Implanting a date warehouse using a cloud based data warehouse tool called Birst. Fully in charge of the full development cycle: data extracting from CRM database, ETL design, data model design and report building. u2022 In charge of Sql Server 2008 R2 database projects maintenance and deployment. Perform daily database status monitoring using ignite 8 and newrelic. Trouble-shot and fix database performance issues. u2022 Create stored procedures, UDFs, triggers etc. to support business logic. Handle daily service request. u2022 Create SSIS packages to extract information from system and generate reports for both internal and external users. u2022 Works in an agile team to deliver product in a faster and more efficient way.u2022 In charge of database re-structure to support better performance. With pushing business rules into tables, pre-calculating most of the summary data, achieved 75% reports performance improvement compared to existing system. u2022 Query performance monitoring and tuning, indexes managing and table partitioning (MS SQL Server and oracle 10g/11g/Exadata). u2022 Built and maintaining data infrastructure and ETL to support business analysis using various data sources. u2022 Worked on all phases of data warehouse development lifecycle: Cognos server deployment, ETL, Model design, report design. u2022 Participated online support, end user training and business rules/working flow documentation.production release. Closely worked with other developers to identify the business entity. u2022 Designed and implemented a web crawling/Spider system to collect college information from various sources. Built C# utility tools to facilitate the data de-duplication, normalization, and transformation process. u2022 SQL Server 2008 maintenance, stored procedures design and performance tuning according to application business requirement. u2022 Implemented an Auto PDF Filling/Exporting feature.u2022 Successfully migrated applications to the production environment while providing both technical and functional support to internal customers. u2022 Database design for an e-commerce site using SQL server. Coded hundreds of stored procedures to support the business logic (Searching, listing, update shopping cart etc.).Perform database maintain, backup and restore. u2022 Managed multiple simultaneous projects, successfully meeting all budgets and time-frames.

• Which languages does Dengwei Yang speak? 

  Dengwei Yang speaks the following languages:
  No languages available.

• Which industries has Dengwei Yang previously worked in?   

  Dengwei Yang has prior experience in the following industries:
  Lumira , Virgin Pulse , Ma Department Of Elementary And Secondary Education , Massachusetts Education Center , Yinxiangpai

• What is Dengwei Yang’s work experience?  

  Dengwei Yang has the following professional experience:
  Arrowstreet Capital , Lumira , Virgin Pulse , Ma Department Of Elementary And Secondary Education , Massachusetts Education Center , Yinxiangpai .

• How can I find Dengwei Yang on LinkedIn?  

  You can view Dengwei Yang’s
  LinkedIn profile at LinkedIn URL.

• What are Dengwei Yang’s work email addresses?  

  Dengwei Yang’s work email addresses are
  [email protected] .

• What company does Dengwei Yang work for?  

  Dengwei Yang works at
  Arrowstreet Capital