QlikView Microfinance Institution

This websit is under construction

Sokkorn Cheav (Mr.)
Phnom Penh, Cambodia
Telephone: +855 12 414 156 / +855 99 977 729
Email: [email protected]

Career Objective
Seeking for a position as QlikView Developer where I can show case my strong technical skills in designing and implementing BI platform and systems to generate essential business information relevant to the company.
Core competencies
  • 4+ years working with QlikView.
  • Strong knowledge of dashboards design and development both in QlikView desktop and Mobile.
  • Expert knowledge of QlikView set analysis, aggregation functions.
  • In-depth knowledge of data modeling technique, ETL processing, data transformation and data warehouse methodologies.
  • Skilled in analyzing user requirements and building front-end BI applications.
  • Familiar with different reporting tools such as Crystal Report and Microsoft Report.
  • Sound knowledge of project management and development life cycle.
  • Ability to work in fast paced and stressful environment.
Click to edit table header
Work Experience
Organization
Duration
Designation
: First Cambodia Co., Ltd.
: September 2009 - Present
: Senior QlikView Developer
 

Fist Cambodia is Co., Ltd the #1 System Integration Company in Cambodia awarded by IDG for four years consecutively from 2009, 2010, 2011 and 2012. First Cambodia Co., Ltd is the country’s leading provider of Total IT solutions and networking services. Client included Banking, Insurance, Telecom, MNC, Government Institution/NGO, Hospitality and Retail industry have chosen First Cambodia Co., Ltd to be their Solutions Partner for transforming their business into a best-run business and turning inefficiencies into opportunity.

Project within First Cambodia Co., Ltd

Client

Project

Role

Team

First Cambodia Co., Ltd.

: Insight Business App

: QlikView Project Lead

: 3

This is internal project where C-Level from Sale, Business Development and Customer Service want to see what happen in the pass from business transaction. The most challenge is boost up sale pipeline and optimize deal aging.


Role and Responsibilities:

  • Lead QlikView developer team and provide technical direction to less experienced members.

    • Perform as test resource for existing Microsoft Dynamic CRM and SAP R3.
    • Handling client communications and functional discussions.
    • Defining and evaluating business requirements with key business stakeholders
    • Interact with functional analysts and business users in refining business requirements in designing technical specifications and data models.
    • Perform investigations and make appropriate suggestions on various services and to meet the development efforts.
    • Ensure that all data in the report is up to date and 100% correctly.
    • Documentations for each report (business application and technical).


    Client

    Project

    Role

    Team

    First Cambodia Co., Ltd.

    : myBilling

    : .NET Developer

    : 1

    The purpose of this project is to capture Call Details Record from Avaya Phone. myBilling is out-of-the-box from build-in call management to capture all call transaction and present it to Finance, IT department.


    Role and Responsibilities:

  • Interact with AVAYA team on how it work in source system.
    • Design database and coding to get data from call transaction (capture data over TCP/IP).
    • Documentation both server and client application.

    Technologies: Window Server 2008 R2 Enterprise, Microsoft SQL Server 2012 Express, Visual Studio 2010, Microsoft Report.

    Client

    Project

    Role

    Team

    : AEON Mall (Cambodia) Co., Ltd

    : QlikView BI

    : QlikView Project Lead

    : 2


    AEON Mall is biggest shopping mall in Cambodia under supervision of AEON japan. In Cambodia they have two food courts; Japan food court and Europe food court which total 21 tenants. By end of the day each tenant must submit sale report to AEON staff to verify their sale transaction. Because of manual and not real-time report (late submit from each tenants); AEON Mall utilize QlikView solution to produce Sale Dashboard which allow them to monitor real-time report.


    Role and Responsibilities:

  • Prepare project plan.
    • QlikView server (SBE) installation and deployment.
    • Perform data loading and save into QVD (separate and combine for 21 tenants).
    • Responsible for the design and development of sale dashboards.
    • Deploy dashboard to end user.
    • On phone/TeamViewer support

    Technologies: QlikView Desktop 11.2, QlikView Server 11.2, Sybase, Excel, SQL Server 2012.

    Client

    Project

    Role

    Team

    : Grand Soluxe Angkor Palace Resort and Spa

    : QlikView BI

    : QlikView Developer

    : 1


    Grand Soluxe Angkor Palace Resort and Spa is the five-star resort designed and build by a Cambodian architect with 260 luxurious guestrooms. They need a report that can integrate roomMaster, Sage Accpac and a couple of excel files to get insight booking trend, guest profile and help them to prepare budget.


    Role and Responsibilities:

  • Prepare project plan.
    • Present project weekly update to client project team.
    • Perform data loading and save into QVD.
    • Responsible for the design and development of dashboards solution.
    • Deploy dashboard to end user.
    • On phone/TeamViewer support
    • Documentations for each report.

    Technologies: QlikView Desktop 11, Sybase, Excel, SQL Server 2005.

    Client

    Project

    Role

    Team

    : Suvannaphum Power Plan

    : QlikView BI

    : QlikView Developer

    : 2


    The purpose of this project is to identify key business performance such as gross profit, energy output, consumption and downtime which we transform from raw data in Excel format into “Dashboard”. This will be achieved by enabling the end users to analyze this and other important measures and KPI’s across many different dimensions.


    Role and Responsibilities:

  • Capture data from Excel log file into QVD.
    • Performed data analysis to meet up with existing Excel report template. 
    • Transform report in Excel template into QlikView dashboard.
    • Responsible for data modeling and data warehouse methodologies, Business Intelligence and ETL development.
    • Responsible for the design and development of dashboards solution.
    • Documentations for each report.

    Technologies: QlikView Desktop 11, Excel.
    Client
    Project
    Role
    Team
    : HELLO Axiata (Cambodia)
    : QlikView BI
    : QlikView Developer
    : 3
     

    HELLO Axiata (Cambodia) is a subsidiary of Axiata Group Berhad (Axiata). They have more than 5 million subscribers. While they have a lot of client, then Network Operation Center (NOC) needs to monitor report daily basis.  From this deal, we provide QlikView report to capture data from 3 MSC across Cambodia and spot check for each BTS where have to most call drop.

     

    Role and Responsibilities:

    • Responsible for data modeling and data warehouse methodologies, Business Intelligence and ETL development.
    • Responsible for the design and development of dashboards solution.
    • Reusable components and a data semantic layer that reaches across lines of business.
    • Perform investigations and make appropriate suggestions on various services and to meet the development efforts.
    • Managing client’s requirements and expectations.
    • Ensure that all data in the report is up to date and 100% correctly.
    • Documentations for each report (business application and technical).
    • Post production support/maintenance.


      Technologies: Window Server 2008 R2, IIS 7, QlikView Desktop 10, QlikView Server 10, Sybase ASE, SQL Server 2005.

      Client
      Project
      Role
      Team
      : PRASAC Microfinance Institution
      : QlikView BI

      :
      QlikView Developer
      : 2
       

      PRASAC positioned itself as a leading financial institution with good and strong infrastructure and platform to offer financial services to the rural and urban clients. For instance, PRASAC has 145 office networks spread across the country, and operates in 10,170 villages which represent 72.6 percent penetration of total villages in Cambodia. There were more than 90 offices are online where the transactions are real time, along with 1,501 staff support. They provide various services such as group loan, individual loan, big ticket loan,…From management objective, a must view weekly report to monitor their client segment and credit officer. And this is the raw opportunity for me to expose my first experience with QlikView.

       

      Role and Responsibilities:

      • Responsible for data modeling and data warehouse methodologies, Business Intelligence and ETL development.
      • Responsible for the design and development of dashboards solution.
      • Perform investigations and make appropriate suggestions on various services and to meet the development efforts.
      • Ensure that all data in the report is up to date and 100% correctly.
      • Documentations for each report (business application and technical).
      • Post production support/maintenance.


        Technologies: Window Server 2008 R2, IIS 7, QlikView Desktop 10, QlikView Server 10, Oracle Core Banking (FlexCube).

        Client
        Project
        Role
        Team
        : Cambodian Mine Action Centre
        : HRMS

        :
        HRMS Technical Lead
        : 4
         

        The Cambodian Mine Action Centre (CMAC) is Cambodia's leading demining organization, working in the key areas of Survey and Land Release, Mine and UXO Clearance, Mine and UXO Risk Education and Training, Research and Development. CMAC currently has 1,715 staff across Cambodia, including a national office in Phnom Penh, six provincial demining units and a Training Centre in Kampong Chhnang, working towards the mission of "Saving lives and Supporting Development for Cambodia".

         

        Role and Responsibilities:

        • Lead developer team (4 members) to coding in-house system.
        • Handle the tasks of conducting process analysis and drafting conceptual design for Human Resource Management System.
        • Work with functional managers and the team sponsor to obtain necessary resources to support the team’s requirements.
        • Ensure deliverables are prepared to satisfy the project requirements, cost and schedule.
        • Responsible for assisting business intelligence specialist in develop, designing and maintaining HRMS System.
        • Handle responsibilities of identifying causes and developing an approach for resolution.
        • Perform the tasks of testing, evaluating and implementing of HR System.
        • Documentation during implementation phase (technical and end user).
        • Conduct end user training and ensure all target audients well equip with system.


          Technologies: Window Server 2008 R2, VB.NET, Crystal Report, Excel.

          Client
          Project
          Role
          Team

          : CROWN Beverage Cans (Cambodia) Limited
          : Quick Win

          :
          VB.NET Developer
          : 1

          CROWN Beverage Cans (Cambodia) Limited is the part of CROWN Asia operation. They are manufacturing plant producing aluminum beverage cans. Most of employee there is engineer. And from HR perspective, they need to equip their staff with well training. With this opportunity, I provide an in-house software development to capture on training record. I spend 3 weeks for this project and then we called “Quick Win”.

           

          Role and Responsibilities:

          • Interact with HR manager to gather all requirements.
          • Coding in-house software base on business blueprint.
          • Performing unit testing, validation and sanity checks on the deliverables.
          • Import existing data file into system.
          • Documentation during implementation phase (technical and end user).
          • Conduct end user training and ensure all target audients well equip with system.


            Technologies: Window Server 2003, VB.NET, Crystal Report, Excel.

            Client
            Project
            Role
            Team
            : Latelz Co., Ltd.
            : Norming PSA

            :
            Norming PSA Developer
            : 2
             

            Latelz Company Limited is the top 3 mobile operator in Cambodia. They operates 2G, 2.5G, 3G, 3.75G mobile services, supporting the very latest in multimedia and mobile internet services as well as international roaming across more than 147 countries. They looking for a Human Resource Management System to serve their HR division and integrate payroll with their Sage Accpac.

             

            Role and Responsibilities

            • Responsible for implement whole HR process from Business Blueprint.
            • Handle on integration between Norming PSA and Sage Accpac.
            • Ensure deliverables are prepared to satisfy the project requirements, cost and schedule.
            • Documentation during implementation phase (technical and end user).
            • Conduct end user training and ensure all target audients well equip with system.


              Technologies: Window Server 2008 R2, Apache Tomcat, Norming PSA, Sage Accpac, Crystal Report, VB. NET

              Click to edit table header
              Educational Summary
              2008 – 2012
              2006 – 2010
              2005 – 2006
              2001 – 2004
              1994 – 2000
              : Bachelor's degree in Economic faculty – Business Economic from National University of Management.
              Bachelor's degree in Computer Science faculty – Management Information System from SETEC Institute.
              : High School Certificate Grade B, Hun Sen Saang High School.
              : Hun Sen Saang High School.
              : Svay Tany Primary School
              Click to edit table header
              Short Course Training

              No

              1

              2

              3

              4

              5

              6

              7

              8

              Start Date

              28-Sep-10

              18-Oct-11

              15-Feb-12

              27-Feb-12

              18-Jan-12

              19-Jan-12

              28-Aug-12

              05-Sep-12

              End Date

              01-Oct-10

              20-Oct-11

              17-Feb-12

              29-Feb-12

              18-Jan-12

              19-Jan-12

              30-Aug-12

              07-Sep-12

              Course Title

              QlikView Advance Training

              IBM Cast Iron Integration Appliance Configuration

              IBM  SOA-ESB (Service Oriented Architecture-Enterprise Service Bus)

              IBM WebSphere Cast Iron enablement and CoE Completion

              SAP Data Warehousing, BI, EIM and Mobile Analytics Strategies

              Winning with SAP Mobility

              Oracle SOA

              Oracle Exalytics and OBIEE 11g

              Class

              Classroom

              Remote

              Classroom

              Classroom

              Classroom

              Classroom

              Classroom

              Classroom

              Location

              Thailand

              Cambodia

              Cambodia

              Cambodia

              Singapore

              Singapore

              Singapore

              Singapore

              Click to edit table header
              Contest and Award

              No

              1







              2

              Date

              21-Mar-12







              06-Nov-13

              Contest

              QlikView Mobile App Contest







              QlikView Data Visualization

              Participant

              1,400+ partners






              QlikCommunity members

              Range

              Top 3 of 5







              Top 3 of 3

              Criteria

            1. Innovative
              • Exciting & Eye Catching
              • Simple & Intuitive
              • Professional
              • Strong Mobile Design Quality
              • Clear Mobile Use Case and Value Proposition

              • Shared new idea on dashboard design
              • Explain data visualization
              • Contributed on how to use QlikView object to present data.
              Click to edit table header
              Personal Details
              First Name
              Last Name
              Gender
              Date of Birth
              Place of Birth
              Nationality
              Marital Status
              : Sokkorn
              : Cheav
              : Male
              : February 12, 1985
              : Kandal Province, Cambodia.
              : Cambodian
              : Single
              Click to edit table header
              Reference
              Will be pleased to provide upon request.