Senior Data Engineer
GIC Private Limited
Keywords
Skills
SUMMARY
► Over 10 years working in computer software, specialized in Data Engineering and Analytics Platform solutions
► Solid knowledge in BI/data analytics architecture design, data governance processes of the acquisition, storage, delivery and analytics services
► Experienced with cloud computing platforms, cloud-based services and traditional on-premises systems
► Experienced with Agile development framework; traditional approach of the Waterfall
***TECHNICAL HIGHLIGHTS
► Data integration solutions (ETL, ELT) - implementation used Python, dbt, SQL Server Integration Services (SSIS), C#; familiar with data transfer through APIs (REST, GraphQL API)
► Database, data warehouse design and implementation (Postgres, Synapse Analytics, Redshift, BigQuery, SQL Server; Oracle)
► Semantic data modeling in Power BI; SQL Server Analysis Services (SSAS)
► Power BI: Data analysis and visualization; Governance and deployment approaches
► Applied knowledge in advanced analytics: Linear Regression, K-mean Clustering, Hierarchical Clustering, Decision Trees and Association Rules
► Well understanding of the data warehouse modeling techniques: The Kimball approach; Data Vault 2.0
► Knowledge on Big Data frameworks (Apache Spark - PySpark; Hadoop - HDFS, YARN, MapReduce; Microsoft APS - BLOB, DMS, MPP, PolyBase)
TECHNICAL SKILLS:
► Over 10 years working in computer software, specialized in Data Engineering and Analytics Platform solutions
► Solid knowledge in BI/data analytics architecture design, data governance processes of the acquisition, storage, delivery and analytics services
► Experienced with cloud computing platforms, cloud-based services and traditional on-premises systems
► Experienced with Agile development framework; traditional approach of the Waterfall
***TECHNICAL HIGHLIGHTS
► Data integration solutions (ETL, ELT) - implementation used Python, dbt, SQL Server Integration Services (SSIS), C#; familiar with data transfer through APIs (REST, GraphQL API)
► Database, data warehouse design and implementation (Postgres, Synapse Analytics, Redshift, BigQuery, SQL Server; Oracle)
► Semantic data modeling in Power BI; SQL Server Analysis Services (SSAS)
► Power BI: Data analysis and visualization; Governance and deployment approaches
► Applied knowledge in advanced analytics: Linear Regression, K-mean Clustering, Hierarchical Clustering, Decision Trees and Association Rules
► Well understanding of the data warehouse modeling techniques: The Kimball approach; Data Vault 2.0
► Knowledge on Big Data frameworks (Apache Spark - PySpark; Hadoop - HDFS, YARN, MapReduce; Microsoft APS - BLOB, DMS, MPP, PolyBase)
TECHNICAL SKILLS:
- Python
- dbt (data build tool)
- Power BI
- Database (SQL, NoSQL)
- Data Integration (ETL, ETL)
- Cloud Data Warehouse
- C# .NET Core
- SSIS/ SSAS/ SSRS
- SQL Server (T-SQL)
- Oracle (PL/SQL)
- Data Modeling (OLTP, OLAP)
- Business Intelligence
- Effective communicating
- Task management
- Leadership
- Mentoring
- Logical thinking
- Problem solving
Project history
05/2019
-
08/2020
Project: Join GIC data operations team via Collabera as a consultant and playing role of Senior Data Engineer to involve in development and operations support for data warehouse-based analytic platforms. The tech stack is based on Python, C# .NET Core, Web APIs (REST, GraphQL) and Microsoft SQL Server (Database, SSIS, SSAS).
Team Size: 11
Technologies used: .Net, Web APIs, SQL Server, SSIS, Python, Control M
Work Location: GIC Private Limited, Capital Tower, Singapore
Team Size: 11
Technologies used: .Net, Web APIs, SQL Server, SSIS, Python, Control M
Work Location: GIC Private Limited, Capital Tower, Singapore
01/2018
-
04/2019
Principal Data Engineer
emporio analytics
Project: Join emporio analytics team as a data engineer who is responsible for aspects of the data warehouse architecture, modeling, implementation and governance. As well, working with analyst team to build semantic data layers in BI/Analytic tools, and coordinating with data scientists to perform configurations and performance management of the ML services which is to integrate Python and R scripts for data analytics.
Prosperously, I contributed heavily and learnt a lot also with emporio analytics's startup journey, as to successfully building up a very first core and principal project from pilot to rolling out to serve its world-wide customers.
Team Size: 9
Technologies Used: AWS, .Net, SQL Server, SSIS, Tableau, R, Python
Work Location: emporio analytics, MapleTree Business City, Singapore
01/2016
-
12/2017
Lead BI Developer; BI Technical Assistant (Remote)
Rieckermann GmbH
Project: Join global IT group of Rieckermann and be in charge of developing and maintaining a DW/BI ecosystem which used SQL Server for Data Warehouse; SQL Server Integration Services (SSIS) for ETL process; and BOARD business intelligence for semantic and front-end layers.
Since April 2017, after successfully playing the role of a lead BI developer, I decided to go for freelance and remote work. On this period, I will have to provide technical assistance in integrating new features as well as being available if any BI technical queries from IT head as to improve Rieckermann BI system.
Team Size: 5
Technologies Used: SSIS, SQL Server, BOARD business intelligence
Work Location: Rieckermann GmbH Representative Office, Ho Chi Minh City, Vietnam
09/2013
-
12/2015
Oracle Development DBA
IMT Solutions
Project: Join a Scrum team and take role of a member who is responsible for database development and administration of an outsourcing project from U.S. client. This project is consisted of a Windows-based application called pAudit and a web application called pNet. Technologies used are Oracle 11g database, .Net Framework and
SQL Server Reporting Services (SSRS). The module is integrated with a healthcare information management system (HIM) that helps auditors to perform auditing based on data entries (data elements) for each visit.
Team Size: 7
Technologies Used: Oracle 11g, .Net Framework
Work Location: IMT Solutions, Ho Chi Minh City, Vietnam
SQL Server Reporting Services (SSRS). The module is integrated with a healthcare information management system (HIM) that helps auditors to perform auditing based on data entries (data elements) for each visit.
Team Size: 7
Technologies Used: Oracle 11g, .Net Framework
Work Location: IMT Solutions, Ho Chi Minh City, Vietnam
01/2013
-
08/2013
BI Operations Engineer
IMT Solutions; StarHub through FPT Software
Project: Join a BI operations team of StarHub to maintain and enhance a BI system that using an Oracle 11g data warehouse and a whole spectrum of SAP Business Objects - including the Data Foundations modeling, Business Elements modeling, Business View modeling, Crystal Report and InfoView.
Team Size: 9
Technologies Used: Oracle 11g, SAP Business Objects
Work Location: StarHub Green Building, Singapore; FPT Software, Vietnam
Team Size: 9
Technologies Used: Oracle 11g, SAP Business Objects
Work Location: StarHub Green Building, Singapore; FPT Software, Vietnam
03/2012
-
12/2012
Business Intelligence Developer
FPT Software
Project: Join a Business Intelligence (BI) team to develop and maintain an end-to-end BI process using ETL Tools (Lawson BPW Designer, SSIS), SQL Server 2008 data warehouse and a whole spectrum of Cognos 8/10 including Framework Manager modeling, Cognos Administration and Cognos Reports.
Team Size: 7
Technologies Used: ETL Tools (Lawson BPW Designer, SSIS), SQL Server 2008, IBM Cognos
Work Location: FPT Software, Ho Chi Minh City, Vietnam
Team Size: 7
Technologies Used: ETL Tools (Lawson BPW Designer, SSIS), SQL Server 2008, IBM Cognos
Work Location: FPT Software, Ho Chi Minh City, Vietnam
Local Availability
Only available in these countries:
Vietnam
Other
CERTIFICATIONS
- Analyzing and Visualizing Data with Microsoft Power BI
- Developing a SQL Server Analysis Services Tabular Data Model with SQL Server 2016
- Microsoft Business Intelligence Stack in Depth
- Microsoft Business Intelligence Stack Fundamentals
- Database Management Essentials
