Prapruet Hengpraprom

Reinsurance Project

-Auto Extract/Receive/Feed Data Reinsurance data from Panda 7.2 by Monthly(1st Setup Comm, Fac-inward, Fac-outward, Treaty-inward, Existing Treaty outward, Existing Retention (XoL)

-Automate Calculation from Manual Calculation by Logic same as sample Excel (SOA of Treaty-inward, Treaty-outward, Retention XoL)

-Setup GROUP of Reinsurance contract by Panda 7.2 Contract Type and Risk Type based on Reinsurance Non

-Proportional and Proportional-Define/Create Treaty Code i.e. MOQS21 to the all Setup GROUP 2.1 both side Reinsurance Automate system and Panda 7.2 & Oracle ERP with same Treaty Code and same Setup% Commission

-Setup 2nd Commission (Adj.) as received by Reinsurer Quota Share

-Book /Cash / Paid or Received Clearing of Existing Treaty from Earlier years and provide the final SOA with Quota Commission as promised with each Reinsurer

-Else Define/Create XoL Proportional bases on the sample Excel then create result to final SOA Create system integration interfaces files "in/out" and "from/to"

-Panda 7.2 (as/400) Reinsurance screen

-Oracle ERP Cloud (Including Insurance Analyzer)

-WTW ResQ/FR Enterprise for Actuarial Report

-Create reinsurance report to data reconciliation as following:

- SOA Report

- Performance (STAT) Report

- Bordereaux Report

- OIC 13 Reports

- Facultative inward and Facultative Outward Report

- Treaty inward and Treaty Outward Report

- Treaty Booked balance Report

- Treaty Cash balance Report

- XoL Report

IFRS17 Project and ERP Data Transition with IFRS17 Ledger

-E2E Insurance cycles processes improvement

-Monitoring the daily weekly monthly progress of projects IFRS17&ERP

-Providing detailed updates to project managers or other stakeholders each workstream leads (Accounting, Actuarial, IT, MIS, Product, Benefit)

-Ensuring each workstream team members have the supplies and resources their need to complete their assigned tasks on time and within their budget limits also within expected milestones

-Organizing Financial Reports, Actuarial Report, Vendor Invoices, Vendor Contracts, and Other financial files for easy access and proceed the payment process actions

-Planning daily, weekly, monthly meetings and organizing project logistics and lots of deliverable items.

-Performing received billing and bookkeeping tasks then coordinator with all stakeholders

-Ordering necessary office supplies and support all material things for project team

-Gathering requirements from users-Develop business requirement specification, functional specification, and user story to analyze and design Use case

-Perform Test case / Test scenario / Test UAT with IT vendors and users

-Analyzing and understanding the current state processes-Designing a solution that will meet business needs

-Identifying the sources of requirements.

-Coordinating with vendors to develop systems that meet end-user requirements

-Communicate with technical team leads, and developers and users to assure an extensive understanding of system requirement, project status, and implementation

-Monitoring all staff concerning the project to ensure its timeliness

-Assist Finance Manager in preparing information and materials to update status to the Project Steering Management committee on regular basis

-Needed Competencies Requirement gathering/ Requirement analysis Functional Design Business Process Design Solution architecture Software fundamentals

-Database management Experience in projects on workflow

-based digitization projects

IFRS9 and IFRS17 Financial Consultant Banking Project with IFRS9 (TFRS9+PSA) accounting standard- Assist clients in applying IFRS and QA, lead UAT, conversions,implementation of new standards, accounting opinions, etc.

- Advise and support clients in the preparation of IFRS financial statements and improving their financial reporting to investors (including all types ofdisclosure reports).

- Assist clients in improving and implementing efficient IFRS9 (TFRS9 + PSA)reporting processes (C&M, ECL reports).

- Deliver added value services to clients by providing industry insight,“Calculation method for improving the quality of system computation”

- Manage client relationships with on the job training both functionality and non-functionality.

- Professionalism in servicing clients.

- Ensure that engagements are executed in accordance with the firm'smethodologies and guidance, professional standards and local legal and regulatory requirements.

- Assist clients landing in to the final phase of system Go-live and deliver alldecks on plan.

• Perform E2E testing Oracle Financials Cloud with GL, FA, FAH for standardfunctions and custom reports align with COA mapping and data migration.

• Perform E2E testing according to core and non-core insurance systems (e.g.Policy admin system, claim system, compensation system, etc.) enhancementto serve Aptitude IFRS 17 Solution requirement.

• Experience in Testing of regulatory implementations like IFRS 17 or IFRS 9 or IFRS 4, ERP (SAP or Oracle).

• Using knowledge of Software Testing Lifecycle (STLC), SoftwareDevelopment life cycle (SDLC), Testing Models &Methodologies.

• SIT/UAT Test standard and customization functional specification andprovide test result explanation to BAU team.

• Log issue(s) and defect(s) in defect management tools like HP ALM, Jira, andetc.

• Facilitates the test preparation, and do the readiness checking with all related parties before starting test execution.

• Co-ordinate all testing tasks among internal teams and other vendors.

• Prepare readiness of test environment related to the testing strategy/testing approach/test plan.

Responsible for new digital lending initiatives of unsecured lending products(LINEBK-KASIKORN)

- Understanding and explain the knowledge of aging calculation of unsecured lending products to team members and Business stakeholders.

- SIT/UAT Test leader will specialize as a subject matter expert in testing andvalidating that Product Policy, FSD, BPD and Miscellaneous documents havebeen implemented as required prior to project go-live.

- SIT/UAT planning, test case specification, test execution, defect managementand test status reporting activities.

- Participate in the daily defect meetings and provide status.

- Lead and explain in the review SIT/UAT test result meetings and provide status.

- Coordinate SIT/UAT events to test and verify that solutions and tools meet the requirements set out by Business stakeholders for successful project delivery.

- Deliver high quality SIT/UAT testing events that support and enable successful project deployment.

- Manage/Monitor progress of test scenarios on SIT/UAT plan for each SIT/UAT events then generate daily report on progress through daily status calls to Business stakeholders.

- Identify and manage risks, issues, mitigations and action items to closure, as they pertain to SIT/UAT.

- Define SIT/UAT entry/exit criteria and contribute to the on-going development of SIT/UAT process and KPIs.

- Source and manage the appropriate resources (people, tools, equipments) to successfully deliver high quality SIT/UAT events.

- Lead and manage quality focused SIT/UAT test execution events, in alignment with UAT entry/exit criteria, timeline, and resourcing constraints.

Oracle EPR Cloud Project : la Rinascente in Italy, the department store under Central Group.

Integration Tasks:

- Cooperate with ACN offshore team to design data mapping and document of all integration interfaces.

- Define integration plan, daily check-up and assign tasks to developer team.

- Review and follow-up the status of each objects to meet the deadline.

- Help Integration Lead to prepare a Powerpoint Presentation slide ie. dailymeeting and weekly meeting.

- Co-work with Business team to review and sign-off the documents.

- Update the integration inventory items to align on the Business RequirementDocument (SOW and RICEW).

- Help Integration Lead to setup/invite the integration meeting sessions.Testing Tasks:

Preparation Testing Strategy including:

-Define Test Objective and Test Scope.

-Define Entry/Exit criteria for SIT and UAT test phases.

-Prepare Test Approach/Principle.

-Prepare Test Plan.

-Prepare Test Environment Plan.

-Prepare Testing Timeline/Testing Phases.

-Prepare Testing Methodology/Activity.

-Defect Testing Role/Responsibility.

-Configure Defect management tools ie.JIRA and Test Script Template.

-Define Test Governance Structure.

-Prepare Sign-off Document for SIT and UAT.

- Generate leads for all Direct Marketing campaigns (Retail Banking) especially Lending products and send the output to multiple platforms (Ex. SMS,Outbound Call Centre, CRM Salesforce, and TMB Touch Mobile App.) to generate higher profits for TMB Bank PCL.

- Designed and implemented the Waterfall Criteria for Daily, Monthly, and Quarterly of direct marketing campaigns using Portrait Dialogue/R Program/Oracle SQL Developer programs, Breakdown the multidimensional criteria, Boost efficiency using multi-step, multi-phase dialogue automation, Loggingand Report Tracking.

- UAT Proof checking of new data initialization/new database design.

- Created Monthly Reports and Adhoc Analytical Reports using R Program/Oracle SQL Developer, Formatted the report layout for the requirement of Team Head and export Raw Data to the Excel PowerPivot for the end users to pivot by themselves.

- Generate all SMS/Campaign Tracking Reports and all Fulfillments of all Lending campaigns to show the Campaign Performance.

- I have about 30 Looping Campaigns, 3 Adhoc Analytical Reports, and 4Adhoc Campaigns per month on my responsibilities, and it feels good.

- IT-Banking project management and Biz/Tech experience

- Develops and Maintains Test Strategy and Plan for Functional and NonFunctional Requirements Testing

- Handles Test Case Design, Test data mining & Test Execution for Functional and Non Functional Tests

- Plan, document, track and coordinates Testing, handles requirements trace ability, Metrics, Defect, Issue and Risk Management

- Proven relationship management/engagement skills and ability to communicate effectively with different audiences

- Capable of working in a fast-paced environment with the ability to prioritize work and meet deadlines

- Effectively communicates with managers, peers, business partners at all levels of the organization

- Demonstrates passion for quality and strives for continuous improvements to deliver a better quality product in a cost effective way and faster

- Strong organizational skills with attention to detail, the ability to prioritize requests and workload accordingly, and meet deadlines.

Wealth System - Customer Relationship Management (CRM) and PortfolioManagement System (PMS)

- Prepare RTM Version, Test Script/Test Case and Test Documentation.

- Discuss with Product Owner and Vendor about BRD, FSD and relateddocuments.

- Control Quality Assurance - raise defects, retest and close defects.

- Manage defects with HPALM Quality Center.

- Identify the root cause of defects to solve all defects with Vendor.

- Report defects and issues to Product Owner/Project Manager/Regional Test Manager.

- Progress and defect closing meeting discussion via Video Conference with Regional in CIMB HQ Malaysia and Vendor in Singapore (every Wed, Fri).

- Split and manage daily tasks with Junior Tester.

- Interrupt the critical urgent case from time to time and swap the daily tasks.

- Prepare daily summary report/ Sprint1-5 summary report to all stakeholders.

Team : Data Migration (TrueOnline) Projects :

CCBS Billing Consolidate Data Migration, CCBS Surrounding, MicroBilling, Amdocs Ensemble.Products :

1) CCBS One Bill

2) Micro BillingResponsibilities :

• Experience in Software Quality Assurance and Testing in differentenvironments and platforms including Data Warehousing, Client-Server and Legacy Mainframe applications.

• Experience in reviewing Business Requirement Documents, SoftwareRequirement Documents.

• Preparing Testing documentations, including Test Scripts, Test CasesDesign, Test Scenarios, Test Tool Usage, Test Scripts and Execution, and Defect Management.

• Executing Test Result Reporting.

• Experience in Black Box Testing with a complete QA cycle - from testing, defect logging and verification of fixed bugs.

• Performing test cases, identify problems and help with problem analysis, debug and resolutions.

• Excellent Communication, Analytical and Interpersonal skills.

• Good command of written and spoken English.

• Experience in Functional testing, Integration/System testing, Regressiontesting and User Acceptance testing.

• Well versed in GUI application testing, Database testing and Front-endtesting.

• Extensively used methodology for testing and supporting data extraction,transformations and loading processing.

• Experience in testing and writing SQL, PL/SQL statements, Store Procedure,Query and Oracle Client-Server.

• Ability to interact with developers and product analysts regarding testingstatus and to maintain detailed QA documentation.

• Excellent in testing Excel files and validating the data loaded to stagingtables.

• Experience in automated testing suites of HP ALM.

• Experience in enterprise email client of IBM Notes.

• Excellent in application testing, software testing or system testing.

• Knowledge of software development life cycle.

• Excellent in IT Project management skills.

• Understanding in IT best practice Agile/CMMI Level 5.

• Team : PMS (Cognos BI Report)Projects & Products :
• 1) Huawei RAN 13 CELL & RNC Performance, and Troubleshooting
• 2) Huawei UMTS 3G RAN 15 CELL & RNC Performance, and Troubleshooting
• 3) Huawei RAN LTE CELL & ENODEB Performance
• 4) Huawei UTRAN CELL & RNC Performance, Troubleshooting, and Capacity
• 5) Huawei EUTRAN CELL & ENODEB Performance, Board, Transmission,License
• 6) Ericsson RAN LTE P1 CELL & ENODEB Performance
• 7) Ericsson UTRAN CELL & RNC, Troubleshooting, and Capacity
• 8) Ericsson EUTRAN CELL & ENODEB Performance, Board, Transmission,License
• 9) Ericsson UMTS
• 10) Ericsson 3G
• 11) Ericsson LTE P3
• 12) Ericsson Simple Dashboard
• 13) UE Throughput
• 14) Troubleshooting Responsibilities :
• Experience in Software Quality Assurance and Testing in different environments and platforms including Data Warehousing, Client-Server and Legacy Mainframe applications. Experience in reviewing Business Requirement Documents, Software Requirement Documents, and preparing Test Cases, Test Scripts, and Execution.
• Experience in Black box testing with complete QA cycle - from testing, defect logging and verification of fixed bugs.
• Experience in IBM Cognos 8 or 10 for BI Reports testing.
• Excellent Communication, Analytical and Interpersonal skills.
• Experience in Functional testing, Integration/System testing, Regression testing and User Acceptance testing.
• Well versed in GUI application testing, Database testing and Front-end testing.
• Extensively used methodology for testing and supporting data extraction, transformations and loading processing.
• Experience in testing and writing SQL and PL/SQL statements.
• Ability to interact with developers and product analysts regarding testing status and to maintain detailed QA documentation.
• Has expertise in Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Experience in testing Excel files and validating data loaded to staging tables.