Work as a Team and Have Good Communication

Time Management and Flexibility

Problem Solving and Cricital Thinking

Education

Bachelor of Information System, Pontianak, Tanjungpura University, West Kalimantan, 2024

Cumulative Grade Point Average (CGPA): 3.80 of 4.00

Honors: Cumlaude

Saint Paul Senior High School, Pontianak, West Kalimantan, 2020

Major: Mathematics and Natural Sciences

Hello, My Name is Andre Hartoyo

A passionate data analyst with a strong drive to uncover valuable insights from data. With an educational background in Information Systems from Universitas Tanjungpura and a GPA of 3.80 (Cum Laude), I have experience in processing data using Excel, SQL, and Power BI. Skilled in teamwork, effective communication, time management, adaptability, and problem-solving Let’s collaborate to create innovative, data-driven solutions!

Work Experiences

Previous Work Experiences

February – March 2023

Grade Studio

PT Inti Teknologi Berdikari

Graphic Design, Content Creator, Marketing Intern

February – March 2023

Betukang.id

PT Betukang Sejahtera Indonesia

Marketing Analyst and Research Intern

February – May 2023

Saharaku

Merdeka Belajar – Kampus Merdeka: Entrepreneurship Program

UI / UX Designer

January – August 2024

PT. M-150 Indonesia

Marketing Intern

Present Work Experiences

November 2024 – Now

PT. Clipan Finance Indonesia

Corporate Data Analyst – Staff

Corporate Strategy Department

Dashboard Development (Power BI & SQL):

  • Developed dashboards from scratch for Sales, Risk, AR Management, and Project Monitoring.

  • Executed SQL queries, performed data modeling, cleaning, and established table relationships.

  • Designed contract classifications (Current, OD, NPL, Repo, WO, Paid-off) for risk analysis.

  • Monitored sales target vs. actual performance across regions, branches, and product channels.

  • Conducted contract and dealer risk analysis to support management decision-making.

Ad-hoc Reporting & Strategic Analysis:

  • Produced reports on contract quality, profitability, and branch/regional performance.

  • Conducted risk analysis based on down payment levels, car brands, customer profiles, and debt ratios.

  • Provided insights to improve contract quality and mitigate non-performing loans (NPL).

Incentive Validation (Multi-Division):

  • Verified incentive calculations for Marketing, Risk, Collection, and dealer programs in line with company policies.

  • Reviewed data accuracy, weightings, and formulas to ensure consistency and compliance.

  • Supported transparency and fairness in incentive distribution.

Portfolio

My Data Projects

Here are some of the projects and dashboards I developed in my role as a Data Analyst, focusing on business performance monitoring, sales analysis, and data-driven insights.

Certifications

A collection of professional certifications that strengthen my expertise in data analysis, business intelligence, and cloud fundamentals.

Analyst is Life

I Develop Skills Regularly to Keep Me Updated

The tools that I Use Commonly in Analyzing data to generate insight

Microsoft Excel
0%
Structured Query Language (SQL)
0%
Microsoft Power BI
0%

My Publications

Application of TOPSIS for Determining Employee Salary Increases at Alpha Company

Published in the Journal of Information Technology and Management, Department of Information Technology, Merdeka Malang University, Vol. 8, No. 2 (2022): December 2022. Indexed by DOAJ, SINTA (3) and Google Scholar. Authors: Andre Hartoyo, S.Kom. ; Renny Puspita Sari, S.T., M.T.

Abstract:

Employee salary increases are common and have become a right of employees that must be fulfilled by the company if they do their job well. However, in this matter, it is not easy for companies to determine which employees will receive their salary increases. One of them is the Alpha company which has problems in determining employee salary increases which are still carried out without a calculation process so that there is a gap between employees. Therefore, an effective and fast Decision Support System is needed to determine decisions by applying the TOPSIS method as the basis for calculating the decision results.  To assess this system, functional testing has been carried out on the Alpha company and obtained a result of 84.67% showing transparency in determining employee salary increases.

An Analysis M-Paspor Application Service Quality Using Mobile Service Quality And Importance Performance Analysis Method

Published in the Journal of Information Systems, Sriwijaya University, Vol. 16, No. 2 (2024): 31 October 2024. Indexed by DOAJ, SINTA (4) and Google Scholar. Authors: Andre Hartoyo, S.Kom. ; Nurul Mutiah, S.T., M.T. ; Ibnur Rusi, S.Kom., M.M.

Abstract:

The M-Paspor application was a platform used by Indonesian citizens to apply for passports. However, users reported complaints about the application’s slow response times and frequent errors. This study aimed to evaluate the service quality of the M-Paspor application from the user’s perspective using Mobile Service Quality and Importance Performance Analysis methods. Data were collected through questionnaires with a sample of 100 respondents and 25 questions covering 14 dimensions, namely Efficiency, System Availability, Content, Privacy, Fulfillment, Responsiveness, Compensation, Contact, Billing, Satisfaction, Design/Ease of Use, Compatibility of Mobile Service, Tangibles, and Technical Reliability. The results of the study indicated that the average performance level of the M-Paspor application was 3.87, which fell into the “Good” category, while the average importance level was 4.47, categorized as “Very Important.” The average value of the suitability analysis was 86.69%,, indicating that the M-Paspor application had not fully met user expectations. The IPA quadrant analysis showed there were 4 indicators in Quadrant I, which were the main priorities for improvement, namely C1, F2, H1, and J1. A total of 9 indicators were in Quadrant II, whose performance needed to be maintained, namely B1, B2, C2, D1, D2, E1, I1, L1, and M1. Meanwhile, 8 indicators were in Quadrant III as low priorities for improvement, namely A1, A2, A3, F1, G1, G2, I2, and K1. Finally, there were 4 indicators in Quadrant IV that could be disregarded for improvement, namely N1, J2, K2, and L2.

Contact Me

I Want To Hear From You

Address

Jakarta, Indonesia

Phone

+62 852- 3171-5353

Scroll to Top