James Chen Email & Phone Number

Macao, Macao Sar

Macao, Macao Sar

1. Setup Central Databases Monitoring Mechanism.  Design, Coding, Deploy it. (All by myself.) Automated Statistics Collection Automated Database Alert if Critical Situations Visualization and Insight Database Changes Prediction and Risk Control2. Central Casino Application (Bally) Expansion Project Grand Lisboa Palace expanded into Gand Lisboa and Casino Lisboa. And Oceanus is coming soon. Accurately Identify Risk and Predict What will happen. Providing… Show more 1. Setup Central Databases Monitoring Mechanism.  Design, Coding, Deploy it. (All by myself.) Automated Statistics Collection Automated Database Alert if Critical Situations Visualization and Insight Database Changes Prediction and Risk Control2. Central Casino Application (Bally) Expansion Project Grand Lisboa Palace expanded into Gand Lisboa and Casino Lisboa. And Oceanus is coming soon. Accurately Identify Risk and Predict What will happen. Providing Solution and Resolved it in time. It prevented the project failure.3. Databases and Data Warehouses Support across SJM Group including production, QA, and UAT environments. Show less

Macao, Macao Sar

 Online Gaming Databases' Monitoring and Performance Tuning. Installing, Configuration, Setup database environment. Incl. MySQL and SQL Server in land base machines or Cloud. Maintain Data Warehouse that pull data from gaming system to warehouse (ETL)

中国澳门

Achievements & Professionalism：1. Design, develop (including coding), and maintain the Central DB Performance Statistic Collection system for Galaxy Entertainment Group. It collects hundreds performance counters from 200 servers automatically to provide a mechanism of monitoring overall DB status and proactive actions.2. Based on my strong analytic skill, database knowledge and experiences to resolve a lot of DB performance issues in Casino and Hotel management application. Specialized… Show more Achievements & Professionalism：1. Design, develop (including coding), and maintain the Central DB Performance Statistic Collection system for Galaxy Entertainment Group. It collects hundreds performance counters from 200 servers automatically to provide a mechanism of monitoring overall DB status and proactive actions.2. Based on my strong analytic skill, database knowledge and experiences to resolve a lot of DB performance issues in Casino and Hotel management application. Specialized in find the root cause of High CPU issue, Long Running Issue, High I/O Issue, Lack SQL Memory Issues, Storage Issues then provide the solution to resolved them. Not only workaround but also resolve problem permanently.3. Observes database behaviors and provide the forecast for the capacity plan and budgeting.4. Proficient at use statistic to show and explain the complex problem to managers and teammates. 5. Co-work with team members, guide junior DBAs, and share knowledge to the team.6. SQL Server, MySQL, Oracle production support.7. Replication, Log Shipping, Column Store, In-Memory database, Clustering, Backup & Restore, ETL (Extract-Transform-Load), SQL Server Integration Service(SSIS), SQL Server Reporting Service(SSRS), Strategic of Rebuild Index and Update Statistic, Loading Balance, Archive & Purge, SAS, and so on.8. Familiar the Casino Operation and strong knowledge in Macau Casino and entertainment industry. Show less

Macao

• Responsible for ensuring availability and performance of the databases that support the system.• Manage global QA, UAT, Training, and Production database environments• Work to ensure that the associated hardware resources allocated to the databases and to ensure high resilience and performance tuning.• To proactively monitor the database systems to ensure secure services with minimum downtime (SQL Server 2005/2008, Oracle).• Responsible for providing trend analysis to… Show more • Responsible for ensuring availability and performance of the databases that support the system.• Manage global QA, UAT, Training, and Production database environments• Work to ensure that the associated hardware resources allocated to the databases and to ensure high resilience and performance tuning.• To proactively monitor the database systems to ensure secure services with minimum downtime (SQL Server 2005/2008, Oracle).• Responsible for providing trend analysis to management team to enable them to make informed decisions regarding resource management.• Responsible for troubleshooting and problem solving of SQL development.• Establish, ensure and document standards and procedures to support database operation and development• Establish new database and update/ensure existing database to meet the changing needs of the database• Manage internal and external data feeds• Database Backup, Recovery and keep DBs at high availability• Being liaison between various department and teams• All other responsibilities as assigned Show less

Macao

• Analyze user's requirement, help develop functional and technical requirements.• Developing, maintaining, and usit testing application program code.• Researching, interpreting, and building knowledge of application and program code.• Create reports for vertical organizations• Suport daily, month-end, and year-end operational activities• Participating in any and all reasonable work activities as may be deemed suitable and assigned by management• Maintain the IFS ERP… Show more • Analyze user's requirement, help develop functional and technical requirements.• Developing, maintaining, and usit testing application program code.• Researching, interpreting, and building knowledge of application and program code.• Create reports for vertical organizations• Suport daily, month-end, and year-end operational activities• Participating in any and all reasonable work activities as may be deemed suitable and assigned by management• Maintain the IFS ERP application, Data WarehouseOffer world-wide Finance and Account team to get reports from multi business application system include ERP and Data Warehouse.• B2B System:Set up the B2B Data Integration with Samsung.• Programming – SQL Server Reporting Service(SSRS), SQL Server Integration Service(SSIS), Oracle PL/SQL, Stored Procedure, and so on Show less

Macao

• Design, Manage, and Maintain the Business Integrated System (Oracle Discoverer) for ad-hoc reporting and analysis propose• Assist managers and business owners to enhance business flows, internal controls, and achieve the MBO at the Corporation Level• Maintain, Trouble Shooting, Production Support of the Oracle ERP System• Including those modules – Sales Orders, Purchasing, Inventory, Manufacture(BOM/WIP/OSFM), Payables, Receivable, General Ledger• Customize programs thru… Show more • Design, Manage, and Maintain the Business Integrated System (Oracle Discoverer) for ad-hoc reporting and analysis propose• Assist managers and business owners to enhance business flows, internal controls, and achieve the MBO at the Corporation Level• Maintain, Trouble Shooting, Production Support of the Oracle ERP System• Including those modules – Sales Orders, Purchasing, Inventory, Manufacture(BOM/WIP/OSFM), Payables, Receivable, General Ledger• Customize programs thru Oracle PL/SQL, Developer 2000 (Form and Report)• Internal lecturer to train up staff in Macao, Taiwan, Shanghai• Analysis business and proactive give the suggestion to enhance the business thru IT, final the requirements for development, co-work with out-sourcing vendor to done the project• Traveling to headquarters in Silicon Valley, America 3 times to attended the Oracle ERP upgrade Project Show less

Taiwan And China

 IT Section Manager in the ShenZhen subsider. The Supervisor to lead team to implement the Oracle ERP with consultants, and attended another 2 subsidiaries’ ERP implement project. Familiar with Oracle ERP modules – Sales Orders, Purchasing, Inventory, Receivable Building up the reporting/analysis tool of Oracle Discoverer As the company’s only one Oracle Database Administrator for 2 years, base on Unix / Windows, SAN storage, and clustering server to keep it runs at… Show more  IT Section Manager in the ShenZhen subsider. The Supervisor to lead team to implement the Oracle ERP with consultants, and attended another 2 subsidiaries’ ERP implement project. Familiar with Oracle ERP modules – Sales Orders, Purchasing, Inventory, Receivable Building up the reporting/analysis tool of Oracle Discoverer As the company’s only one Oracle Database Administrator for 2 years, base on Unix / Windows, SAN storage, and clustering server to keep it runs at 7x24x365 DB Server’s performance tuning, backup and recovery Oracle ERP patching release and deployment Develop the Electronic Signature and Documents Management System thru the Lotus Notes Develop the Web based application –Assets Management System, & Purchasing and Inventory Management System. (PHP&MySQL) Show less

Advanced Diploma, Gaming Management, 3.2

Master, Business Administration

Bachelor'S Degree, Business Management

Gaming Teaching And Research Centre

Independent Course, Oracle Database, Erp, Business Intelligence

Diploma, Computer Programming