Pete Watcharawit

• Translated documents from Thai to English and vice versa.
• Enabled smoother communication for foreign visitors by offering support for real-time interpretation.
• Interpreter & facilitator for John C. Maxwell Beyond Success.
• G12 Asia Conference interpreter for the Thai language.

• Create & Manage BigQuery database.
• Create & Manage data dashboard using Looker Studio.
• Maintain backend Java Applications, Elasticsearch, Node.js, and MongoDB database.
• Produce administrative and POI shape files with distributed population count using QGIS and Python.
• Develop Python scripts for data transfer, distribution of population count per block, and handling shapefiles.
• Managed multiple projects simultaneously while maintaining strict deadlines and high-quality standards.

Specification:

• Software Tools: Python, Java, Node.js, Looker Studio, BigQuery, Elasticsearch, MongoDB
• Development Tools: Jira, Git
• Operative System: Windows, Ubuntu

• Shared knowledge and work experience with web and game developers. Also responsible for the docker learning workshop.

Specification:

• Software Tools: Docker
• Operative System: Windows, Ubuntu

• Translated a book from Thai to English.
• Reviewed final work to spot and correct punctuation, grammar, and translation errors.

• Responsible for system operations such as SonarQube, Docker, and PostgreSQL and setting up, installing, and maintaining cluster machines. Had responsibility for system architect, documentation and development that merges software codes from Git with SonarQube to evaluate software quality using code complexity metrics and store the results in PostgreSQL then sends them back to the core system using Kafka messaging for data scientists to use.
• Responsible for setting up Docker containers of applications and documentation.
• Responsible for maintaining node.js and react.js applications for prediction results from machine-learning algorithms for possible upcoming error reports of other systems within 5G technology.
• Responsible for developing interface functionalities and web application documentation with Swagger UI.

Specification:

• Software Tools: Python, MySQL, PostgreSQL.
• Development Tools: Toad Edge for PostgreSQL, Hypervisor, SonarQube, Docker, Kafka, Jira, Git,
• node.js, react.js, Swagger UI
• Operative System: Windows, Linux.

• Worked as Individual Tutor and Course Instructor for High-School students on many occasions.
• Responsible for university entry national math exams course and regular high-school courses.

• Proof of Concept, in an attempt to merge two systems into one. Worked as the main responsible developer & tester. A possible solution is to implement multi-threading code on an existing billing engine that handles all customer service bills. The goal is to observe the test running time and whether it lies under
• an acceptable time frame of 4 hours given that there are 3 times more bills than before. Another task is to detect the bug from upgrading Java 1.4 to Java 1.9. The bug was found on the Gregorian calendar class which behaves differently on each version which coincidentally is the same minor bug the billing engine has had for over 10 years. The test running time went down from 30+ hours to 2.30 hours only on a test laptop.
• The billing engine could potentially be faster on a server having more powerful CPU cores. The result is very satisfying so the company decides to replace an existing billing engine code with the new multi-threading version which reads and processes data simultaneously with a selectable number of threads and read chunks.

Specification:

• Software Tools: Java, Oracle SQL.
• Development Tools: Eclipse, Git, Gerrit, Oracle SQL Developer.
• Operative System: Windows, Linux.

• Database and system development of Telenor’s new platform for a call service operation. The platform is integrated with Contact Center, Telenor’s client databases, IMS (IP Multimedia Core Network Subsystem), broadcasting network system, and billing system. Working agile according to Scrum. Responsible for MongoDB’s replica set of three database servers as the main database for internal messages and calendar system for each telephone operator and client. Also responsible for email & SMS integration with REST API and writing tests such as REST API tests, and integration tests according to Test Driven Development principle.
• Development of Hadoop cluster and its related tools and platforms to store& merge large data (data processing) and extract relevant information and value from it (data mining). The project is thought to have the potential of negotiating a business case of one million Swedish krona per year.
• Deployment of the TCS system’s side change functionality (switcher). Responsible for debugging and testing of integrated code between Java and Node.js to successfully transfer data using REST API.
• Development of the BOB website which fetches all SMS and email history from the EMP MySQL database. Responsible for all search functions, REST API, and interfaces. Also responsible for creating an administrative webpage for registering new user accounts and documentation.
• One of the main responsible persons for system maintenance and updates for UI. Also responsible for error analysis, unit test, performance test, and upgrading of database security (SSL) with authentication and authorization mechanism using an SSL certificate with Iteration AB as CA.
• Development of Angular Unit Test for frontend system to check, and update the UI with minimum risk for errors. The factories, controllers, and directives are included in the test suits.
• Development of the TCS system’s side change functionality (switcher). The functionality should be able to manage the main side and the reserve side automatically without conflicts.
• ES201 database design schema. Responsible for visualizing an overview of the database tables and their keys and parameters based on system documentation of each table.

Specification:

• Software Tools: javascript, node.js, NoSQL, mocha unit-test, karma unit-test, CSS3, HTML5, angular.js, Java, SQL, MySQL, OracleSQL, python, JUnit, Java EE 7, JDK glassfish, apache, jasmine, JQuery.
• Development Tools: Eclipse 7.5, Brackets, Git, Atlassian-JIRA, Bitbucket, Jenkins, MongoDB, Hadoop.
• Operative System: Windows, Linux/CentOS/Ubuntu.

• Introduction to Big Data. An attempt to discuss a business case solution to replace an old data-lake platform with Hadoop for data mining and a new database with integrated REST API.

Specification:

• Software Tools: Hadoop, java,
• Development Tools: Hadoop, Eclipse
• Operative System: Windows, Linux/CentOS/Ubuntu