Sangjun Rattanee
MIS at Krungsri Auto- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Credentials
-
SAS Programming3
SASMar, 2019- Oct, 2024 -
DataRobot Essentials
DataRobotJan, 2019- Oct, 2024 -
SAS Programming2
SASJun, 2018- Oct, 2024 -
SAS Macro Language1
SASSep, 2018- Oct, 2024
Experience
-
Krungsri Auto
-
Thailand
-
Banking
-
200 - 300 Employee
-
MIS
-
Feb 2018 - Present
-
-
-
Accellence
-
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
-
-
-
Mitsubishi Motors Thailand
-
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).
-
-
-
Professional CallCenter
-
Thailand
-
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) -
Mahasarakham University
Bachelor of Science, Computer Science