Haris Prawira

Experience

• 

  Bina Nusantara University

  Jun 2007 - Dec 2007

  Education Counselor

  Build relationship with clientsMaking Marketing StrategyGiving Product Presentation

• 

  Duta Ursula School

  Jan 2008 - Jul 2009

  Computer Trainer

  Prepared the material for school curriculum Managed payroll system and school administration Built the computer lab to be connected to the internet and school networkMaintained the Database server Responsible for data migration and back-up recovery

• 

  PT Anugrah Argon Medica

  Jul 2009 - Jul 2010

  IT System Analyst – ETL Developer – DWH Administrator

  Anugrah Argon Medica is an IT-based distribution company, relies on IT as the backbone of its business process as well as to create its competitive advantage.My responsibilities ranging from constructing strategic IT planning based on business directions,• Planning for system deployment and operations including resources and capacity. • Create a system that can generate high quality report and send automatically through system.• Ensure the quality of Report that generate by the system by doing a Data Quality analysis• Deployed the system to the server.• Comprehensive database management and migration from SQL Server to Oracle.• Trained the End user and the Principal• Debug and Maintain Data Warehouse server (Debug, Recovery, Backup, Deploy, Creating Tablespace, user access, and Performance Tuning ) • Technical Consulting, Relating to Oracle Data Warehouse Technical issue and the implementation from business process to the system.I Directly involved in business process improvement activities and project implementation in requirement analysis, design, build and delivery for Data Warehouse System.Project : Data Warehouse Migration Achievement:- Improve Data Warehouse System performance by doing Performance Tuning scheme and successfully reduce the time consume from 12 hours to 4 hours for generating managerial report.- Developed a complex system that could automatically generate business report, converted into file, compressed, sent, and integrated it into principal database environment with in 4 hours. therefore principal can automatically analyze their business performance faster.Skill Related to this job:Applications: Oracle Warehouse Builder 11g, PL/SQL Script, Toad 9.0, UNIX, Oracle Database Server 11i, VB.Net 2003, Oracle Form, Oracle Report, Putty (Telnet), Hyperion Designer.Database: SQL Server, MySQL, Oracle Database 10g, 11g, Tuning Database Show less

• 

  University of Technology, Sydney

  Aug 2010 - Sept 2012

  Postgraduate Student

  Master Business AdministrationMajoring in Finance and Accounting Information System

• 

  CPM Australia Pty Ltd

  Dec 2010 - Mar 2011

  Sales Representative

  Role: Selling Gas And Electricity on Behalf of Australia Gas and Light (AGL).• Proactively obtain customers for the company • Aligned services through planned visit and cold calls surrounding appointments• Sell the AGL product (Gas And Electricity)• Responsible for achieving set sales targets in an ethical manner.Achievement:15 sales per week with zero cancellation and received a good feedback from the customer

• 

  PT Inter Pan Pasifik Futures

  Dec 2011 - Jan 2012

  Futures Trader ( Summer Internship Program)

  Role:• Helping superiors managing clients portfolio• Forecasting the movement of markets (Stock indices Futures, Foreign Currency Futures) Achievements : • Understanding how future market and trading works • Learning about many trading strategies and how to do short-term and long-term technical and fundamental analysis and to know when to use which to make an accurate prediction learning different characteristics of various markets

• 

  Citibank, N.A.

  Sept 2012 - Dec 2013

  Risk Analyst

  • Preparing comparison between projected foreclosures and estimated costs and losses associated with loss mitigation alternatives for collection strategy.• Responsible to develop NCL and LLR Forecast model for Retail Card Portfolio.• Perform complex Risk Policy Analytic in terms of sizing the impact of credit/business/regulator policies on loss performance and figure out a way of incorporating them into standard forecast methods.• Participate in corporate-wide stress testing projects based on firm-wide scenario.• Perform Economic based Analysis to estimate the impact of changing macro econometric trends on portfolio loss and delinquency performance (Stress Test).• Work closely relate with cross functional teams and other collection policy teams.• Influencing the collection strategy planning for entire organization by driving accurate forecasts.• Developed delinquency/NCL performance material and participating in discussion with senior management regarding risk management.• Lead/participate in several small and large analytical ad-hoc projects to identify underlying portfolio performance driver and level of risk.Responsibility:• Maintain more than 3 portfolio product of Unsecured loans and Cards which worth billions of dollar each.• Conduct complex analysis using internal and external (Central Bank) data to mitigate risk opportunity by improved previous collection policy.Skill Related for this Job:Financial Forecasting and Modelling, Microsoft Excel, Microsoft Access and SAS Analytics Software Show less

• 

  Ayam Jago Rawit

  Jan 2014 - Feb 2019

  Business Owner

  AJR is a food service business which specialize in providing cooked & frozen soft-boned chicken and Chinese food. Today, majority of AJR sales come from online application such as Gojek, Grab, and Tokopedia. It also provides catering services for corporate events ( such as Citibank, NA and MHE Demag, Mawar Sharon Church, GBI Wisma AKR).• Managed to breakeven within the first six months with initial capital of 50K AUD, and successfully opened up new outlet in the ninth months.• Managed to open up five new distribution sales channels within a year and successfully renegotiate the agreement to be more profitable for both sides after the first year.• Negotiated and developed good professional relationship with five different vendors as well as obtained the most competitive pricing on necessary ingredients.• Designed economical marketing programs such as coupon promotion, Member Card, and vendor participation at local community events (HYPE, Jakarta Street Karnaval, Festival Karang Tengah)• Developed reasonably accurate revenue, expenditure and profit forecast which drive the strategic decision-making such as opening a new outlet. • Managed the performance of 10 staffs (includes two managers) by establishing sustainable accountability and motivating sales incentive (e.g. cash bonuses and movie tickets) and created properly documented training programs for each roles. Show less

• 

  Monk's Hill Ventures

  Aug 2017 - May 2019

  CRM Manager

  Monk's Hill Ventures is one of Southeast Asia's leading VC funds. The firm raised $80-million-dollar fund from major companies like Temasek,Telstra, and Cisco and invested in growing startups such as NinjaVan, C88/cekaja, KKDay, and goquo. Our professionals have assessed close to 3,000 deals within Southeast Asia, region and made investments towards a variety of ecommerce enablement, SaaS, fintech, artificial intelligence and robotics companies at primarily the Series A phase.In this company, I am the primary point of contact for the investment team with regards to deal flow and data on startups & fundraising purposes. I am responsible for managing the database, reporting on upcoming opportunities, and providing analytics on our deal flow, deal sourcing and deal execution capabilities. This includes leading a quarterly meeting (new market opportunities and latest business insights) with limited partners (Itochu). Key Responsibility:Automation, Database Optimization, Management, Analysis, Business Insight and Reporting.Skill Acquired: Programming (Python, Perl, Node, JSON,etc)Understanding about Start-Up EcosystemAnalyzing Company Business Model (Churn, GMV, TAM Analysis, etc). Deal Sourcing ( Crawler - Node JS, Phyton)Search Engine Optimizer (Google Console, Google Adsword, Google PageSpeed, Google Analytics, PPC Analysis)Marketing Performance (KPI, Marketing Optimizer, Mailchimp Campaign, CRM - Insightly) Show less

• 

  Oriflame Cosmetics

  May 2019 - Oct 2021

  Regional IT Business Solution (Product & Business Project Manager)

  Key Roles:Product Ownership of Personal Beauty Online Store (Social-Commerce Concept) • Increased conversion rate from 1% into 20% within four months via PBS targeted vouchers, WhatsApp connectivity, and gamification which eventually contributed to 10% of National Oriflame SalesProduct owner of Payment • Increase #Online Payment Trx from 7% to 33%; Reduced payment processing lead time from 5 days to 3 days and transaction fee from 2.4% to 0.7% delivering annual cost reduction of 150T.EUR by implementing universal QR code (QRIS), E-Wallets, and Virtual Accounts as payment methodCRM Project – Marketing Automation • Increased social media impression by +80% via automated consultant recognition campaign, member activity by +20% via success plan reminder • By automating the reminder for abandoned basket, increased conversion rate by 15%Warehouse & Logistics Project (TMS/WMS)• API Integration Project with six major logistics courier providers with different framework of systems (e.g. Ninja Express, JNT, and etc) • Increased NPS from 1.4 to 3.4 (out of 4.0) by providing real-time order status and tracking visibility to customers.• Warehouse Management System (WMS) - Location Control & Product Tracking ProjectSupport testing, create the process flow and parameter setupKey Responsibility:Business Analysis, Growth Hacking, CRM Marketing Automation, Project Management, Business Insight and Reporting, API Integration, Logistics, and Finance - Payment.Market Scope: South East Asia (SEA)Skill Acquired: Programming (REST API, Javascript, PL/SQL, and SQL Server, etc)Analyzing Company Business Model (Price Mix, Price Elasticity, Customer Behaviour, Lead Conversion, Purchase Frequency, and likelihood to churn) - Tools (Google AutoML and Google Analytics). Sitecore 9 - Marketing Automation & SalesforceReporting (CognosBI and Power BI)Software (SQL Developer, TOAD, Oracle, Visual Studio Code)Application Programing (React.js) Show less

• 

  ORIFLAME SOFTWARE

  Jan 2020 - Mar 2020

  Oriflame Software

  Apprenticeship and Developed New Feature for ID & VN Market. - Marketing Automation- Voucher Functionality + Multi Vouchers Feature- Oriflame Game - eWallet + Payment Integration

• 

  L'Oréal

  Nov 2021 - now

  Key Responsibilities● Lead CRM migration from CPRV to MRM, enabling automated journeys via Salesforce Marketing Cloud (SFMC).● Design data infrastructure that supports hyper-personalized campaigns based on brand briefs.● Upskill brand teams to build SFMC lifecycle journeys and increase campaign autonomy.● Oversee CRM strategy across 5 Luxe brands (Kiehl’s, Lancôme, YSL, Shu Uemura, Giorgio Armani).● Build loyalty programs for Shu Uemura & Armani to scale them into top growth brands by 2025–2026.● Guide, mentor, and manage performance of a 5-person CRM specialist team.● Drive cross-functional collaboration with marketing, commercial, Media, IT, legal, internal control, data, and CMI at both local and zone levels.● Partner with L’Oréal Data Team to build real-time KPI dashboards in Looker, ensuring clear data flow and business alignment.● Lead MARS POS migration to create a seamless O+O retail journey and real-time performance tracking through iBeauty Customer 360.Key Achievements● Increased CRM contribution by +20% through recruitment, conversion, and retention automation.● Boosted online growth by +200% via Shopee x CRM campaigns for Kiehl’s, Lancôme & Shu Uemura.● Delivered loyalty infrastructure to grow Shu Uemura & Armani’s customer lifetime value.● Built Looker dashboards to accelerate decision-making through real-time insight.● MARS POS projected to unlock IDR 500B+ in business impact by 2025.● Promoted for cross-functional leadership in CRM, data, loyalty, and digital transformation.New Skills✓ SFMC Journey Builder & Automation✓ MRM Campaign & Brand Enablement✓ Loyalty Program Development✓ Looker Dashboard & KPI Mapping✓ Cross-Functional Leadership✓ POS Modernization & Omnichannel CRM Show less Key Responsibilities• Capture customer behavioural data and leverage the insight in our social commerce channel to generate 25% of conversion rate to Sales. • Manage CRM Activations for 3 brands (Kiehls, Lancome, and YSL) and generate monthly evaluation report, provide insight and share with top management about our current customer demographic, behaviour to shape our business strategy. Achievements• Develop the Automated Consumer Focus Lifecycle CRM Frameworks which increased email productivity by 24% with net new hyper targeted personalized campaigns. Show less Key Responsibilities• Utilize mixture of Scrum, Kanban, and waterfall methodologies to lead team of 70 people across countries, departments, and time zone through D2C project development. • Optimize release management process using Confluence, JIRA, and SNOW ticketing system to minimize risk, maximize developer efficiency and keep team informed of sprint/project progress.• Coordinate regional team, solution architects and third-party vendors to communicate requirements, create project schedules, establish milestones and provide direction on the project expectations.Achievements• Implement more than 28+ projects successfully in L’Oreal Indonesia Luxe Division.• Lead D2C Project ELUXE for 4 major brands integrating across 9 platforms (e.g WMS-DHL, SAP, Infosys, Lazada, Shopee, Whatsquare, etc) ~ $8 Mio annual revenue contribution• Reduce outstanding backlog tickets plus deliver urgent project on expedited timeline (only 3 months when normally takes 6 months) and avoid any business sales loss due to this special condition. Show less Key Responsibilities• Define the data flow architecture for Luxe Division to feed in eCommerce weekly Power BI Dashboard.• Develop mega campaign reports on marketplace platform (e.g. Shopee, Lazada) that provides comprehensive view, easy benchmarking, and faster decision making. Achievements• Spearhead in-depth brainstorming with Ecom & Brand team and came up with reusable business dashboard for Ecom Channels (i.e. marketplace, brand.com, social commerce) for all brands which reduced the time spent in building a dashboard from scratch by 90%.• Collaborate with database vendors and successfully integrated multiple DB from each brand and create unique identifier for Luxe to bring the customer analysis from Brand level to Division Level. Show less

  • Senior LUXE Div. CRM & Data (DDX) Manager

    Oct 2024 - now

  • Customer Relationship Management Manager

    Nov 2021 - Jun 2025

  • Senior Project Manager

    Nov 2021 - Jun 2025

  • e-Data Manager

    Nov 2021 - Jun 2025