Download PDF

Summary

IT Professional with 9 years of experience, expertise in Hyperion technical, Oracle database administration, and Microsoft SQL Server database administration. Significant experience in troubleshooting technical problems in database, Windows O/S and UNIX O/S. Excellent interpersonal, organizational, presentation and writing skills.

Work experience

Feb 2008Present

Hyperion Consultant

PT Emerio Indonesia

PT Cipta TPI, Jakarta (http://www.tpi.tv), November 18-19, 2008Installation & configuration of Hyperion System 9 9.3.1

oInstalled and configured Oracle WebLogic 9 and Oracle Database 10gR2 to be used for Hyperion 9.3.1 implementation.

oInstalled and configured Hyperion 9.3.1 Shared Services, Planning and BIPlus.

oConfigured SSL on WebLogic 9.2 for Planning and Workspace.

oCreated backup procedure.

PT Bank Danamon Indonesia, Jakarta (http://www.danamon.co.id), April 2008 – present Hyperion Application Support

oSupported day to day operation of Hyperion application for 9 cubes (5 cubes for Planning and 4 cubes for Essbase).

oConfigured SSL on WebLogic 8.1 for Shared Services and Planning.

oCopied applications from Development environment to UAT, Production and DRC (4 Planning applications and 2 Essbase ASO applications).

oDeveloped Disaster Recovery plan to shorten RTO (Recovery Time Objective) for DR switch over/switch back by 90.3 % (from 6 hours to 35 minutes)

oOrganized the implementation of Hyperion Planning Forecast 2008 and Budget 2009 in Production and DRC machine.

oOrganized the backup procedure.

PT Coca Cola Bottling Indonesia (http://www.coca-colabottling.co.id/), Jakarta, April 28 - May 9 andJuly 3 – 12 & 22, 2008 Hyperion 6.5 to 9.3.1 Migration Project

oInstalled and configured all Hyperion components, 2 development servers and 3 production servers, including Windows 64-bit machines for Essbase in PT Coca Cola Bottling Indonesia.

oInstalled IBM WebSphere 6.1 as J2EE server for Shared Services, Workspace and WebAnalysis components in PT Coca Cola Bottling Indonesia

oPerformed migration, checked and validated 50+ cubes migrated from Essbase 6.5 to Essbase 9.3.1.2 64-bit in PT Coca Cola Bottling Indonesia.

oPerformed migration, checked and validated 500+ Analyzer 6.5 reports migrated to Hyperion WebAnalysis 9.3.1 in PT Coca Cola Bottling Indonesia

Nomura International Hong Kong Ltd. (http://www.nomura.com), Aug 4-5, Aug 21-27, 2008

oResearched on SSH solution needed for doing the backup process.

oCreated and tested Backup scripts to backup all Hyperion components.

Aug 1999Feb 2008

IS Technical Analyst

PT HM Sampoerna, Tbk

oAdministered 30 different instances of Oracle, ranging from Oracle 8-10g.

oAdministered Hyperion Financial Management, Hyperion Planning and Hyperion BIPlus system.

oInstalled, configured and administered all Hyperion products in Sampoerna (Hyperion Financial Management, Hyperion Planning, Hyperion Essbase and Hyperion BIPlus) using BEA WebLogic Server 8.1 SP4.

oAdministered Microsoft SQL Server 2000 & 2005 database.

oAdministered and troubleshoot problems on Worldox document management system for Legal department, Marketing division and Public Relations department.

oInstalled Oracle 9.2.0.1 and upgraded to 9.2.0.4 on HP-UX 11.11.

oAdministered Microsoft SQL Server 2000 & 2005 database.

oAdministered and troubleshoot problems on Worldox document management system for Legal department, Marketing division, Public Relations department and Product Development division.

oOversaw the need to use the partitioning option on Oracle 9.2 on Panamas (Sampoerna’s sales division) In-house applications.

oInvestigated and communicated with Hyperion to identify the bug on Hyperion products related with active directory users tree moving.

oInvolved on the following projects

    • Remedy ARS 6.0 implementation
    • CMMS Upgrade
    • Transport Order Management
    • Panamas Sales Division In-house applications
    • Manufaturing Division In-house applications
    • Consolidation project using Hyperion Financial Management
    • Budgeting project using Hyperion Planning
    • Remedy ARS 5.5 implementation
    • Clove Receiving Information System
    • Tobacco Traceability Information System
    • Remedy – Altiris connectivity
    • Panamas Consolidation Server
    • Computerized Maintenance Management System (CMMS) implementation using Datastream MP2.
    • Laboratory Information Management System (LIMS) using Agilent LIMS
    • Manufaturing Division In-house applications

oIdentified and reported to BMC to resolve ARS 5.5 bug connecting to MSAD.

oInstallation of Agilent LIMS on HP-UX 10.20.

oInstallation of Oracle 7.3.2 on HP-UX 10.20.

Education

19942000

Bachelor Degree

Sekolah Tinggi Teknik Surabaya

Skills

ITIL Foundation
Training attended:   ITIL ITSM Essentials Course, Kata Systems, Singapore, June 6 – 8, 2005
Windows System Administration
UNIX/Linux System Administration
Training attended:   HP-UX System and Network Administration I, HP Education Indonesia, Jakarta, January 22 – 26, 2001 HP-UX System and Network Administration II, HP Education Indonesia, Jakarta, May 28 - June 01, 2001
MS SQL Server Database Administration
Oracle Database Administration
Training attended: Oracle Database Administration, Inixindo, Surabaya, 2000 Oracle8i SQL Statement Tuning , Oracle Education, Jakarta, November 7-9, 2001 Oracle9i Database: Fundamentals I, Oracle Education, Jakarta, July 18 – 22, 2005
Hyperion Installation & Configuration
Training attended: BEA WebLogic Server 8.1: System Administration, BEA Education, Singapore, October 16-20, 2006 Hyperion Financial Management: Create & Manage Applications, Hyperion Education, Singapore, 2006 Hyperion Planning & Budgeting: Create & Manage Applications, Hyperion Education, Singapore, 2006

Certifications

Jun 2005Present

ITIL Foundation

Exin