Guanghe Chen

Experience

• 

  HELM360

  Feb 2016 - Nov 2016

  SSAS Cube/BI Developer

  • Collaborated with business users and analysts to collect requirements for the development of a data mart utilizing JRD and JAD sessions.• Developed logical and physical data models for data mart with Erwin. • Created multiple fact tables with varying granularity levels and maintained fact table relations with dimensions.• Created stored procedures, user defined functions, views, and TSQL scripts for implementing business logic.• Wrote complex queries utilizing joins, sub queries, CTE, and set operators involving multiple tables.• Analyzed execution plans to optimize queries; created proper indexes to improve query performance.• Designed SSAS cubes with multiple dimensions and measure groups.• Managed cubes objects such as KPIs, perspectives, aggregations, and translations.• Partitioned cubes to improve performance; assigned proper storage mode as needed.• Debugged and resolved errors within cubes on the production system• Implemented usage based optimization on cubes to improve the latency of cubes.• Implemented drill through, linked, and sub report functionality in SSRS reports.• Deployed multiple reports to the report server in native and SharePoint Integrated modes.• Created dashboards using Power View to identify KPIs.• Developed canned/ad hoc reports and complex dashboards utilizing Tableau Desktop.• Created dashboard utilizing geographic maps, pie charts, bar charts, heat maps, tree maps, dual axis chart, line charts in Tableau desktop.• Collaborated with other team members utilizing TFS. Show less

• 

  Rabobank

  Nov 2016 - Feb 2018

  SQL/BI Developer

  • Collaborated with customers and analysts to collect requirements for the cube development. • Documented business requirements and assimilated them to functional requirements.• Optimized the performance of slow running TSQL queries by implementing appropriate index• Created cube with multiple facts and dimensions from oracle database in tabular mode.• Designed and created f_view in Oracle database to utilize the view in developing cube.• Customized fact tables and dimension tables in cubes to meet the requirements of the users.• Wrote MDX scripts to understand existing cube data in SQL Server Management Studio (SSMS)• Utilized various processing modes of the cube to refresh data and structure of cubes. • Partitioned fact table for incremental processing to handle future volume of the data in the cube.• Created complex measures or derived columns in fact table and dimension table.• Validated cube data against data warehouse, validated logic in calculated columns and measures.• Managed security of the cube for DW and UAT users.• Deployed cube to test environment and UAT environment and supported testing process.• Debugged and resolved errors within cubes on the UAT and production environments.• Created data dictionary for various cube objects such as measure groups, dimensions, KPIs etc.• Created complex SSRS reports with row groups, column groups, tables, charts.• Created dashboard and detailed reports using drill through, sub report options.• Customized report parameters and remove unwanted data for improved report performance.• Validated report data against data warehouse and other cosmetics such as logo, fonts, colors. • Deployed report to test or UAT server, managed report using report manager.• Collaborated with other team members utilizing TFS. Show less

• 

  Boyd Gaming

  Apr 2018 - Dec 2018

  BI developer

  •Collaborated with customers and analysts to collect requirements for the development of a cube and report. •Created BRD- Cube Mapping document.•Created MDX cube with multiple facts and dimensions from Tsql database in Multi-dimensional mode.•Created calculated members to implement complex business logic per report requirements.•Create database for PNK Project, migrated data from previous database to PNK database.•Populated sample data into database.•Created stored procedures to manipulate tables.•Created SSIS Package to load and verify data, defining delta marker in each source system.•Collaborated with other team members utilizing TFS. Show less

• 

  Ascension

  Mar 2019 - Jan 2021

  ETL Developer

  •Optimized existing SSIS packages, turned transformations and tasks into stored procedures which called in a generic package to reduced code volume.•Created complex stored procedures with multiple database objects like cursor, CTE to implement business rules.•Created unit testing project and scripts in SSDT for Dev team's CI process.•Created and modified python scripts to implement file and folder operations.•Communicated with front-end team and built a process to validate data between portal and database.•Designed and implemented process for on-going validation to validate the front-end data continuously.•Developed C# console application that will load file into SQL Server and meet or exceed target performance metrics. Show less

• 

  PwC Acceleration Center Shanghai

  Mar 2021 - Mar 2022

  Senior Associate
• 

  L'Oréal

  Mar 2022 - now

  IT-Custodian Assistant Manager