Sangjun Rattanee

MIS at Krungsri Auto
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Bangkok, Bangkok City, Thailand, TH

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
You need to have a working account to view this content.

Credentials

  • SAS Programming3
    SAS
    Mar, 2019
    - Oct, 2024
  • DataRobot Essentials
    DataRobot
    Jan, 2019
    - Oct, 2024
  • SAS Programming2
    SAS
    Jun, 2018
    - Oct, 2024
  • SAS Macro Language1
    SAS
    Sep, 2018
    - Oct, 2024

Experience

    • Thailand
    • Banking
    • 200 - 300 Employee
    • MIS
      • Feb 2018 - Present

    • Thailand
    • Information Technology & Services
    • 1 - 100 Employee
    • ETL Developer
      • Jul 2011 - Feb 2018

      Data warehouse Developer, Accellence & NTT Data. 2011-Present GSB Credit Card  ETL Developer  Develop create function, procedure for fixed defect and support user requirement.  Mock up data for support Unit test, SIT, UAT.  Develop and maintain documentations and metrics to improve operational efficiency.  Provide customer support and assistance in issue troubleshooting and resolution. Fleet Card Report  System Analyst  Analyst user requirement.  Designing reports and data base applications for the purpose of providing personnel with information customized to their specific needs.  Create and maintain Management reports including end-of-month, quarterly.  Communicates with various groups for the purpose of resolving problems and assisting in the coordination of activities and processes.  Coordinates a variety of programs and activities for the purpose of delivering services in conformance to established guidelines.  Developer  Generate ad hoc reports as needed.  Modify function, procedure for fixed defect and support user requirement.  Mock up data for support Unit test, SIT, UAT.  Develop and maintain documentations and metrics to improve operational efficiency.  Provide customer support and assistance in issue troubleshooting and resolution.  Monitoring data entry and ETL process. BI Project  Developer  Analyst user requirement and developer design.  Provide and prepare data source for support data mart.  Create, modify script of SQL report and fixed defect when data difference between EDW(production) and EDWBIM(New Mart).  Create, modify batch window and set schedule SQL report.  Monitor run jobs monthly for support BI report and SQL report.  Impact analysis and fixed defect when job aborted.  Create, deploy job DataStage for support case rerun historical data.  Responsibility for UAT stage; cooperate with user, design test script. Show less

    • Thailand
    • Motor Vehicle Manufacturing
    • 300 - 400 Employee
    • IT Staff
      • Nov 2009 - Jul 2011

      1. Coordinate. Between the Company and customers. The department to department within the company. Project to work smoothly with a good customer. 2. Test system was developed after the finish. Was the car is real or not, and meets the needs of the user or not. 3. Design of application programs to be distributed to the developer.(JSP,Java,Oracle) 4. Develop application for ALC system(Production Line). 1. Coordinate. Between the Company and customers. The department to department within the company. Project to work smoothly with a good customer. 2. Test system was developed after the finish. Was the car is real or not, and meets the needs of the user or not. 3. Design of application programs to be distributed to the developer.(JSP,Java,Oracle) 4. Develop application for ALC system(Production Line).

    • Mobile Test
      • Nov 2008 - Nov 2009

      1. The Pretest, UAT, Posttest. Promotions that will enable new services 12Call. 2. To test the new service (New service) such as Download SMS, MMS, IVR, WAP communications with a second system, Postpaid, Prepaid. 3. Check the CDR (Call detail record) on the date base. 4. The test of the rating services. Correct or not. And forwarded to the Billing back to the Bill following page. 5. Make sure, problems that arise with customers such as are not content. 6. Coordination with other agencies involved. To monitor and Problems arising from service. 7. Retest the service or services that have to be closed. To verify accuracy. 8. Prepare the Summary Report from working. 9. Check Application, Web application, a New Project and contact the team of AIS to Develop a New Program to System for AIS. Show less

Education

  • King Mongkut’s University of Technology Thonburi
    Master’s Degree, Engineering (Electrical and Information Engineering)
    2012 - 2015
  • Mahasarakham University
    Bachelor of Science, Computer Science
    2004 - 2008

Community

You need to have a working account to view this content. Click here to join now