Learn Data Skills
Beta
Aprilia Evans

Aprilia Evans

Data Analyst

Gadjah Mada University | Tennessee

Technologies

My Portfolio Highlights

My New Course

Introduction to Python

My New Course

Introduction to Python

Analytical innovator, pushing the boundaries of what data can reveal.

My Work

Take a look at my latest work.

course

Exploratory Data Analysis in SQL

course

Functions for Manipulating Data in PostgreSQL

course

Exploratory Data Analysis in Python

DataLab

Course Notes: Exploratory Data Analysis in SQL

DataLab

Investigating Netflix Movies and Guest Stars in The Office

course

Exploratory Data Analysis in SQL

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python
Introduction to SQL
Introduction to Power BI
Intermediate SQL

My Work Experience

Where I've interned and worked during my career.

PT Bank Jago Tbk | Apr 2022 - Present

Senior Business Intelligence Analyst

Subject Matter Expert in data analysis for marketing team • Give insight to marketing team related customers behavior using various data source such as Mixpanel, Appsflyer, Braze and Google Analytics • Build dashboard for OKR measurement, campaign performance, tax and finance reporting, and Customer Performance Analysis using Google Data Studio, Looker and Bigquery • Collaborate with Data Engineer to develop Customer Segmentation Platform and Data Transformation using Airflow and DBT • Documenting all tasks and projects using Confluence and Jira
Show More

PT Bank Mandiri (Persero) Tbk. | Aug 2020 - May 2022

First Senior Manager - Management Information Systems (SME & Micro Risk Segment)

• Reviewing SME portfolio credit monthly across branches all over Indonesia (12 branches) including identify which branch will give negative impact to portfolio quality using risk parameters • Create and maintain Risk Clustering Model based on demographic data, deposits, loan and debtor’s assets • Produce portfolio quality report monthly and daily using Tableau Server and Tableau Desktop • Benchmarking analysis on each SME sectors based on internal and external data • Collaborate and synergize with other business group, accounting group, collection group, and data engineering group • Explore various database using SQL for data cleaning and preparing, Talend as ETL tools, Oracle/Hive to proceed data warehouse and python to produce prediction modeling

PT Bank Mandiri (Persero) Tbk. | Jul 2019 - Aug 2020

Manager Credit Risk, Policy, Process & Assurance in Digital Lending Risk Department

• Collaborate with IT group and Business group to build seamless and robust end to end digital loan processing system • Coordinate and cooperate with external e-commerce partners, payment gateway companies and peer to peer lending companies to build digital loan acquisition model • Assess partner’s end to end business process and produce Risk Acceptance Criteria for each partner based on its business process and data availability • Reviewing quality portfolio monthly and fine-tuning Risk Acceptance Criteria for each partner

PT Bank Mandiri (Persero) Tbk. | Nov 2016 - Jun 2019

Assistant Manager - Micro Risk and Portfolio Management

• Produce Risk Acceptance Criteria, Loan to Value, and other policy for Micro loan segment • Create quality portfolio reporting monthly • Collaborate with business group to improve end to end process and catch business opportunity in Micro Level segment (segment with gross income up to Rp 200 million) • Processing and cleaning data using SQL and report the data using Power Point and Spreadsheet dashboard • Assessing retail store eligibility before accepting loan application • Collaborating cross functions with other group to define requirements for Business Process Re-Engineering Bank wide project

PT Infomedia Nusantara | Apr 2016 - Nov 2016

Corporate Strategy Officer

• Analyze management report’s subsidiary and projects using financial parameters based on its profitability, feasibility and portfolio and give recommendation to strategic decision maker • Creating report to Board of Directors related to company’s capital expenditure • Collaborating with other department to produce Company’s Budget Plan monthly and yearly • Benchmarking analysis to other companies in the same Business Process Management business

PT. Gudang Garam Tbk | Jan 2016 - Apr 2016

Management Trainee

• Assess branches end to end internal process and creating pain points report and offer solution • Report directly once in a month to Board of Directors (BoD) presenting pain points and solution ideas that been found in branches.

PwC | Jan 2015 - Nov 2015

Associate

• Business processes mapping, testing internal controlling environment, assessment of risks • Review information system and data migration • Testing of IT general control’s clients and application controls in cooperation with the financial audit team • Data analysis to address business risks for clients • Assistance to achieve compliance with various regulatory framework • Perform end to end audit procedure and produce auditor’s report

Universitas Gadjah Mada | Feb 2014 - Jun 2014

Assistant Lecturer

- Give additional lessons and quizzes - Recapitulate student's score

My Education

Take a look at my formal education

Bachelor of Economic, AccountingUniversitas Gadjah Mada (UGM) | 2014
SMA Negeri 8 Jakarta

About Me

Aprilia Evans

Highly motivated person. Passionate in data and analytics. A fast and active learner, self-taught several programming languages and big data architecture. Having high passion in processing data and turn it into more powerful decision-making strategy.

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free