Piyanuch Athan Email & Phone Number

Thailand

- Responsible for US migration sync project for mutual fund characteristic information.This project is a plan to migrate users to use only new application(Oracle Database) for better experience and maintenance, it’s also designed to support backward compatibility by syncing data back to old application, so it can still send out the mutual fund feed to our customers.One of the designs I had done, is a story to sync back the data between Oracle to Sybase by making use of the CDC(Capture Data Changes) to capture data changes then I also designed a transform process by making use of PL/SQL for transforming data logic and OGG(Oracle Golden Gate) to replicate data to Sybase.- Responsible for working closely with project leads to extract business requirements and make them into smaller pieces which I will assign to my team members in Mexico, India and Thailand. Usually I will design a high level of the solution, keep it documented in Confluence and assign it to team members via Jira.- Responsible for code review process and deployment plan&execution.- Responsible for resolving production issues, involved in all processes such as root cause investigation, supporting customers/other team members, making hotfix changes for urgent cases, also designing&fixing the issues permanently.

- Responsible for Mutual fund back-end development of integration project. This project is about merging companies and existing systems must be developed to support the functionality of both companies. My job is developed and validated transactions from our customer and implemented reports follow by business requirement.- Responsible 2 Factor Authentication project. Designed and Developed for supported OTP function and send the messages notification to customer’s mobile for authentication trading funds.- Investigated, supported and fixed production issues.

Perform analysis, design, coding, testing, deploying and maintaining for assigned project.Results:- Designed and developed new system from scratch for new project about automation testing. This system use PostgreSQL for storing data. Also responsible for migration process and develop stored procedures for our front-end team.- Developed sync process using PL/SQL and CDC to process data and validate business requirements in staging database. After process finished, sync correct data to production database.- Developed and maintained backend system of an application. This application is for content editor to store fund data in our platform. My job is to validate data from users and generate reports from these data.- Investigated, supported and fixed production issues using PL/SQL and problem solving skills.

Use the same principle as ETL to process consumer data and deliver to clients. Write simple andefficiently query for creating a report to clients.Results:- Serve our retailers with different data types. Process data by writing a query for storing data to designed tables, VAT calculation and transaction calculation, for instance. Export files to user desire format. Upload files to our system. Each step has been tested by query scripts.- Ad hoc project monthly. I have responsibility to correct datas that other teams make them incorrect by using PL/SQL with Oracle SQL*Plus.- Serve our retailers by creating reports. Each report has different requirements depend on retailers. I create many SQL scripts for serving different requirements. For instance, pivot table and graph.