Gaining intensive experience in modern data stacks like SnowFlake, Google Big Query, DBT, Looker, Tableau, Spectacles... in order to consult and deliver data platform end-to-end to clients which make client's business becomes more data-driven.

- Ownership of conceptualizing, developing & delivering high-quality, actionable dashboards and visualizations of BeSmitten's product, users, sales & marketing activities, including funnel analysis, user segmentation, and behavior, and channel analyses using BlotOut.- Comunicating with stakeholders(Product Owner, Sales & Marketing Lead & CEO) regulary to collect business requirements.- Managing MongoDB & data lake, creating some ad-hoc analysis using AWS Athena.- Corporate with… Show more - Ownership of conceptualizing, developing & delivering high-quality, actionable dashboards and visualizations of BeSmitten's product, users, sales & marketing activities, including funnel analysis, user segmentation, and behavior, and channel analyses using BlotOut.- Comunicating with stakeholders(Product Owner, Sales & Marketing Lead & CEO) regulary to collect business requirements.- Managing MongoDB & data lake, creating some ad-hoc analysis using AWS Athena.- Corporate with Blotout team to integrate MailGun, Google Ads, and Tiktok Ads into the data pipeline(using DBT) to build intensive marketing dashboards so businesses can see the efficiency & ROI of different marketing channels/campaigns. Show less

- Create, develop and own the APAC BI reporting and analytical environment of micro-lending, micro-investment & credit scoring locate on AWS.- Lead the development and provision of BI reporting through the deployment of self-service reports & dashboards.- Lead the development and provision of advanced analysis through the use of classical statistical and machine-driven techniques.- Working on PII data masking to guarantee data security and compliance.- Track & Analyze user… Show more - Create, develop and own the APAC BI reporting and analytical environment of micro-lending, micro-investment & credit scoring locate on AWS.- Lead the development and provision of BI reporting through the deployment of self-service reports & dashboards.- Lead the development and provision of advanced analysis through the use of classical statistical and machine-driven techniques.- Working on PII data masking to guarantee data security and compliance.- Track & Analyze user behavior & product analysis using Google Analytics & Amplitude to help businesses understand the customers as well as improve the products better over time.- Collaborate with Data Scientists and work on EDA(Exploratory Data Analysis) for them to use for their Credit Scoring models.- Consult core development team on transaction database architecture & design, database standardize & provide training query performance tuning best practices to developers. Show less

- Administering and managing PostgreSQL OLTP database system in various AWS regions which have around 600 tenants per instance.- Database monitoring using Datadog & pgwatch2 to view query metrics, use for performance tuning, blocking & deadlock issue troubleshooting.- Optimizing ETL which is run by cron jobs to transform data to Clickhouse data warehouse. It took around one hour for the batch job to run then after optimizing the time down to half-hour then the final is 15 minutes.-… Show more - Administering and managing PostgreSQL OLTP database system in various AWS regions which have around 600 tenants per instance.- Database monitoring using Datadog & pgwatch2 to view query metrics, use for performance tuning, blocking & deadlock issue troubleshooting.- Optimizing ETL which is run by cron jobs to transform data to Clickhouse data warehouse. It took around one hour for the batch job to run then after optimizing the time down to half-hour then the final is 15 minutes.- Building almost real-time, intuitive, actionable dashboards/reports to provide intensive recruitment processes, KPIs, conversion rate...etc using Logi Analytics.- Working closely with clients all over the world to migrate their existing database system to our system using Pentaho & SSIS. Show less

- Working as an application DBA to review and approve developers' code before committing to git-repo or working on the complex business requirements using user-defined functions and stored procedures.- Responsible for monitoring & troubleshooting all SQL Server database-related issues such as performance tuning, and deadlock resolving in DEV/TEST/QA/UAT & production environment.- Provide database design & query optimizing best practices training to developers and working intensively on… Show more - Working as an application DBA to review and approve developers' code before committing to git-repo or working on the complex business requirements using user-defined functions and stored procedures.- Responsible for monitoring & troubleshooting all SQL Server database-related issues such as performance tuning, and deadlock resolving in DEV/TEST/QA/UAT & production environment.- Provide database design & query optimizing best practices training to developers and working intensively on optimizing long-running/cursor nested stored procedures which took hour to run or caused timeout for application down to 1-2 seconds which got big reputation from colleagues.- Implement version control & CICD using Redgate SQL Source Control, git & Jenkins/TeamCity.- Sanitizing the production database to bring data to UAT to simulate the similar-production environment for testing purposes (both business logic & performance).- SSIS packages monitoring & performance tuning.- Implement load & stress testing for database servers using SentryOne. Show less

Responsibilities included management of the mining database and development of requested additional database and reporting tools.• Coordinate with Australian Superintendents, Managers to understand requirements for designing and implementing databases, reports.• Provide database to MDA (http://mdacorporation.com/) consultants and support on database documents and presentation when they were onsite.• Provide development environment for testing, implement testing new features… Show more Responsibilities included management of the mining database and development of requested additional database and reporting tools.• Coordinate with Australian Superintendents, Managers to understand requirements for designing and implementing databases, reports.• Provide database to MDA (http://mdacorporation.com/) consultants and support on database documents and presentation when they were onsite.• Provide development environment for testing, implement testing new features performanceand update them all in production database once all test are going well.• Building procedures as a part of data transformation and audit data. The procedure incorporates many T – SQL features such as dynamic SQL, error handing, temp tables. The systems processes over 40 data types each run time within 30 seconds.• Maintain database application performance by rebuilding/reorganizing indexes within speed up complicate procedure performance from 8 minutes to 2 seconds.• Building desktop database application for tracking database import process: speed, bugs thus take action to fix issues as fast as possible. Creating GUI for data entry and reporting purpose (two apps to manage on job training hours of expat to train Vietnamese and equipment isolation registration information) using Lazarus-Free Pascal. Show less

• Manage database administrative tasks: database security, monitoring, writing script to monitor & alert on database issues, performance monitoring and tuning.• Backup & recovery of production database using SQL backup tool of Redgate ensuring minimum downtime & maximum recoverability.• Diagnosing the database issues and taking corrective actions to ensure database availability and security.• Analyze user reporting requirements and design, code, test, and document all new reports… Show more • Manage database administrative tasks: database security, monitoring, writing script to monitor & alert on database issues, performance monitoring and tuning.• Backup & recovery of production database using SQL backup tool of Redgate ensuring minimum downtime & maximum recoverability.• Diagnosing the database issues and taking corrective actions to ensure database availability and security.• Analyze user reporting requirements and design, code, test, and document all new reports using SSRS.• Using SQL Server Agent, database mail to automate regular tasks: sending daily/weekly/monthly reports.• Helping Australian senior supervisors to fix their access databases, excel macros issues as require. Show less