Data Engineer

• Feb 2023 - Present

▪ OneModel is a people data analytical cloud platform that integrates data from multiple HR systems. ▪ Data modeling, creating, optimizing, and testing data processing logic scripts for multiple clients from different industries. ▪ Configure system settings including data source and data file definitions, and ETL schedules. ▪ Monitor and debug the data processing. ▪ OneModel is a people data analytical cloud platform that integrates data from multiple HR systems. ▪ Data modeling, creating, optimizing, and testing data processing logic scripts for multiple clients from different industries. ▪ Configure system settings including data source and data file definitions, and ETL schedules. ▪ Monitor and debug the data processing.

Business Intelligence Developer

• Nov 2022 - Jan 2023

Data Analyst

• Oct 2021 - Sep 2022

▪ Maintained and developed credit card interest payment verification jobs between the production systems and Snowflake data warehouse. Used Yaml/SQL/Python to define the verification logic. Schedule and run the job monthly in an internal cloud computing platform. ▪ Conducted ad-hoc data analysis or process tasks using Python, SQL query, Linux Shell, Airflow, and AWS S3. ▪ Developed dashboards showing the macro economy for the management team using Tableau. ▪ Maintained and developed credit card interest payment verification jobs between the production systems and Snowflake data warehouse. Used Yaml/SQL/Python to define the verification logic. Schedule and run the job monthly in an internal cloud computing platform. ▪ Conducted ad-hoc data analysis or process tasks using Python, SQL query, Linux Shell, Airflow, and AWS S3. ▪ Developed dashboards showing the macro economy for the management team using Tableau.

Business Intelligence Analyst

• Sep 2020 - Sep 2021

▪ Analyzed business requirements and built tailored dashboards using Power BI. ▪ Performed various data processing and analytical tasks using Python, and Excel. ▪ Build ETL pipelines from CSV files held in FTP to a database feeding to the dashboards. ▪ Analyzed business requirements and built tailored dashboards using Power BI. ▪ Performed various data processing and analytical tasks using Python, and Excel. ▪ Build ETL pipelines from CSV files held in FTP to a database feeding to the dashboards.

Business Intelligence Developer

• Aug 2020 - Sep 2020

* Gathered and analyzed requirements, designed and developed data tables and data visualizations using Power BI, based on databases in different information systems. * Performed statistical analysis on client data capturing courses attended, services and financial aid received, etc. resulting in improved knowledge of program participants and their needs. * Gathered and analyzed requirements, designed and developed data tables and data visualizations using Power BI, based on databases in different information systems. * Performed statistical analysis on client data capturing courses attended, services and financial aid received, etc. resulting in improved knowledge of program participants and their needs.

Data Virtualization Developer

• Aug 2020 - Sep 2020

▪ Built reports to illustrate the property market in various dimensions, with different influencers and levels of periods. ▪ Solely performed data collecting, cleansing, transforming and visualization using Power BI with DAX formulas, utilizing cross tabs, maps, scatter plots, pie, bar, and density charts. ▪ Edited the JSON files for Power BI shape maps. ▪ Built reports to illustrate the property market in various dimensions, with different influencers and levels of periods. ▪ Solely performed data collecting, cleansing, transforming and visualization using Power BI with DAX formulas, utilizing cross tabs, maps, scatter plots, pie, bar, and density charts. ▪ Edited the JSON files for Power BI shape maps.

Information Technology Technical Support

• Oct 2017 - Jul 2020

▪ Solely provided IT support for 50 employees onsite and overseas, resulting in high availability, effective data backups, robust information security, and smooth network connections. ▪ Automated daily sales performance report using Python and Excel. ▪ Solely provided IT support for 50 employees onsite and overseas, resulting in high availability, effective data backups, robust information security, and smooth network connections. ▪ Automated daily sales performance report using Python and Excel.

Fixed Asset Manager and Data Analyst

• Oct 2013 - Oct 2017

 Collected and cleaned data from Databases and information systems with SQL, APIs and other data sources.  Designed and implemented dashboards, multiple chart types, trends, and KPIs using Excel and Tableau for senior management providing analysis and visibility of business performance to support decisions for constant improvement operational efficiency.  Generated ad-hoc reports in Excel power pivot and VBA on a regular basis for internal users and external stakeholders.  Close worked with system development and data center teams for designing, configuring and improving the information systems used by the department. Show less

Software Engineer

• Jan 2006 - Sep 2012

* Programmed, debugged and supported applications for in-house information systems. * Imported, exported and cleaned data for user departments. * Analyzed and transformed business requirements. * Conducted end-user and training. * Programmed, debugged and supported applications for in-house information systems. * Imported, exported and cleaned data for user departments. * Analyzed and transformed business requirements. * Conducted end-user and training.

Software Developer

• Feb 2003 - Jun 2005

Programming using Informix DB and Informix 4GL for a insurance business system. Version control management using Visual Source Safe. Programming using Informix DB and Informix 4GL for a insurance business system. Version control management using Visual Source Safe.