Talk to sales Try for Free
Janto Janto

Janto Janto

Officer at MIS Division Budget & MIS Group - Finance Directorate

Followers of Janto Janto726 followers
location of Janto JantoJakarta, Jakarta, Indonesia

Connect with Janto Janto to Send Message

Connect

Connect with Janto Janto to Send Message

Connect

  • Timeline

  • About me

    Data Enthusiast

  • Education

    • SMU Santa Ursula BSD

      1996 - 1999

    • Universitas Padjadjaran (Unpad)

      1999 - 2004
      S1 Economics, Accounting

      - Lecturer Assistant of Information Management System (2001 - 2004)- Committee of several local and national event

  • Experience

    • LippoBank

      Nov 2004 - Nov 2007
      Officer at MIS Division Budget & MIS Group - Finance Directorate

      • Prepared and managed daily reports (Daily Public Fund, Daily Loan Position, Daily Funding Report per Branch) for management to monitor movement of public fund and loan on daily basis • Created Branch Score Card reports to monitor branch performance• Created Branch Profitability Reports to monitor branch performance• Download daily files to ensure the data availability for MIS Reporting• Maintain ad-hoc reports, assignment and analysis• Application used : Ms. Excel, Ms. Access, FoxPro, IBM AS400 Show less

    • Private Owned Company

      Jan 2006 - Jan 2013
      Business Owner

      Internet Service Provider, F&B Industry

    • PT. Bank CIMB Niaga, Tbk

      Dec 2012 - Jul 2014
      Assistant Manager at Data Governance and Management Divison MIS & Performance Management Group

      • Created and managed NPL’s matrix and data to analyze NPL of each Business Units and created NPL Movement for each account.• Prepared data and analyze reverse Income because of NPL and make forecast debtor that will be reversed.• Prepared data as external auditor requested • Provided ad-hoc data, reports and analysis as requested by Management / Business Units • Created and managed SQL Server scheduled job’s (daily, weekly, monthly basis). • Created loan movement analysis by segment, region, branch to analyze new booking, early termination, normal termination of loans. • Supported data for regulatory (BI / OJK / LPS) needs. Some of them are Top 50 Debtor, Top 100 Funding and Lending, Tiers for LPS, and also support LBU’s data for audit needs.• Created and analyzed NII movement for Corporate, Commercial Banking and SMME. • Application used : Ms. Excel, Ms. Access, SQL Server Show less

    • PT Bank UOB Indonesia

      Aug 2014 - Aug 2016

      • Create and manage monthly TTD reports for MSL (Mortgage Secured Loan) acquisition• Create and manage performance report for several MSL program• Prepare data and analyze monthly segmentation report for MSL Performance (30+DPD, 90+DPD, Disbursement, Flow-rate, Collateral)• Create and manage MSL database (portfolio, collateral, acquisition)• Provide ad-hoc data, reports and analysis • Application use : Ms. Excel, SAS, SQL Server

      • Secured Portfolio & System Analyst (Senior Manager) - Risk Analytics

        Apr 2016 - Aug 2016

      • Secured Portfolio & System Analyst (Manager) - Risk Analytics

        Aug 2014 - Mar 2016

    • Bank Mayora

      Aug 2016 - Sept 2017
      MIS Head - Accounting & MIS Division

    • Commonwealth Bank Indonesia

      Oct 2017 - Sept 2024

      • Business Intelligence Specialist

        Jan 2022 - Sept 2024

      • Business Productivity Specialist

        Oct 2017 - Jan 2022

    • OCBC Indonesia

      Sept 2024 - now
      Analytics Platform

  • Licenses & Certifications

    • BSMR Level 2

      LSPP