• Built a data warehouse from scratch, integrating on-chain data (Ethereum, Tron, Matic..etc) via APIs to streamline transaction tracking.• Managed near real-time and offline data warehousing for large datasets, enhancing system reliability.• Developed and optimized ETL pipelines using Airflow and AWS Glue, boosting efficiency by 30%.• Produced BI reports for multiple departments, improving insights by 20% and aiding data-driven decisions.• Led data integration projects and… Show more • Built a data warehouse from scratch, integrating on-chain data (Ethereum, Tron, Matic..etc) via APIs to streamline transaction tracking.• Managed near real-time and offline data warehousing for large datasets, enhancing system reliability.• Developed and optimized ETL pipelines using Airflow and AWS Glue, boosting efficiency by 30%.• Produced BI reports for multiple departments, improving insights by 20% and aiding data-driven decisions.• Led data integration projects and mentored team members, increasing team productivity by 15%. Show less

Build Nginx with lua to proxy event data streaming to Google Pubsub.Build cloud dataflow pipeline with Apache Beam to subscriber events data from pubsub to Mixpanel server.

Design BI / DW and ETL Structure to support Web/ APP base product. Data model and schema design to support business decisions.Work with product leaders to ensure all development on the right way. Docker CI/CD with Drone on AWS EC2. Experience in custom ETL design, implementation and maintenance.

• Collect customer data from various channels and extract valuable information to build ad recommendation models• Cleaning TV logs to analyze customer behavior and building key metrics to analyze • Construct data flow to manage big data ingestion from upstream application to Hadoop Distributed File System• Familiar with BI visualizations and dashboards with interactive views and alerts to present business metrics• Building data warehouse from scratch and using Hadoop, Hive… Show more • Collect customer data from various channels and extract valuable information to build ad recommendation models• Cleaning TV logs to analyze customer behavior and building key metrics to analyze • Construct data flow to manage big data ingestion from upstream application to Hadoop Distributed File System• Familiar with BI visualizations and dashboards with interactive views and alerts to present business metrics• Building data warehouse from scratch and using Hadoop, Hive, Impala, Python to solving data process issue. Show less

• Conducted customer segmentation and pricing simulation to provide insights into the relationship among selling channels, customer groups, and product characteristics• Built a predictive model which identified customers at risk of churn and allowed the customer service department to respond promptly to retain customers, reducing the churn rate by five percent• Created automated dashboards to facilitate the process of sales performance analysis for the management team• Developed and… Show more • Conducted customer segmentation and pricing simulation to provide insights into the relationship among selling channels, customer groups, and product characteristics• Built a predictive model which identified customers at risk of churn and allowed the customer service department to respond promptly to retain customers, reducing the churn rate by five percent• Created automated dashboards to facilitate the process of sales performance analysis for the management team• Developed and maintained a SMS system that delivered real-time reports on sales performance on an hourly basis• Re-built data models to streamline queries and improve overall data structure Show less

• Developed SQL procedures and functions for ETL, extracting data from multiple source systems to be loaded into the staging area and to the target database• Constructed both logical and physical data models according to business requirements using All Fusion ERwin • Optimized the performance of the mappings through various tests on sources, targets, and transformations

• Generated financial reports with Tableau Desktop and Server and made appropriate suggestions on various services to meet the development efforts• Developed ETL programs using Microsoft SQL Server, including T-SQL, DTS, and SSIS, and deployed reports using SSRS 2012 in Business Intelligence Development Studio (BIDS)• Created SSIS packages to obtain data from different sources, consolidate, and merge into one single source to optimize data and log capacity and throughput• Cleaned… Show more • Generated financial reports with Tableau Desktop and Server and made appropriate suggestions on various services to meet the development efforts• Developed ETL programs using Microsoft SQL Server, including T-SQL, DTS, and SSIS, and deployed reports using SSRS 2012 in Business Intelligence Development Studio (BIDS)• Created SSIS packages to obtain data from different sources, consolidate, and merge into one single source to optimize data and log capacity and throughput• Cleaned and prepared data during staging using various SSIS tasks such as Conditional Split, Derived Column, etc.• Extensively involved in client interaction and translated business requirements to technical specifications• Maintained database, including monitoring, troubleshooting, and performance tuning Show less

• Obtained data from CRM system and provided BI solutions for end users• Created and maintained SQL agent jobs for scheduling SSIS packages and SSRS reports and alerts

• Successfully load the data from different database experiment to SQL Server2012 and analyze and explain the result using SQL Server 2012 and Access as an important tool. • Retrieve and modify data using SQL Server2012 and BIDS and acquire information from different database. • Created ETL packages using SQL Server 2012 SSIS Designer to extracted data from flat file, reformat the data, and insert the reformatted data into fact table, loaded different types of dimension and fact tables… Show more • Successfully load the data from different database experiment to SQL Server2012 and analyze and explain the result using SQL Server 2012 and Access as an important tool. • Retrieve and modify data using SQL Server2012 and BIDS and acquire information from different database. • Created ETL packages using SQL Server 2012 SSIS Designer to extracted data from flat file, reformat the data, and insert the reformatted data into fact table, loaded different types of dimension and fact tables into data warehouse, deployed SSIS packages and solutions into production system using SQL Server Business Intelligence Development Studio (BIDS).• Developed projects using SQL Server 2012 SSAS, created data source/data source view/cube with measure and dimensions, configured attributes of dimension table with hierarchy relationships; modified cube and dimensions. Show less