learning SAP and IT skill on this blog’s

Jl. Kembang XI no 42 Rt 05 rw 02 kec kwitang Jakarta Pusat Indonesia

Mobile: +62 81 318 805003

Phone: +62 21 314 7851

E-mail: Deri.permana@yahoo.co.id

YM: deri.permana@yahoo.co.id

Deri Permana

Nationality: Indonesian

Summary

Deri has been involved in SAP BW / Netweaver and mainstream IT industries for more than five years. Prior to his career as a BW / Netweaver expert, he focused as a system administrator and application developer in the oil and gas, multinational shipping and retail industries.

Employment History

Sapindigo Solusi, PT – Present
SAP NetWeaver BI and BASIS Consultant.
INDOCATER, PT
System administrator and application developer
Sarijasa Transutama, PT
Network Engineering and System Administrator
MADANI MART, PT (PNM)
Consultant – POS System

SAP Experience

SAP Education Course

o PDEBWB – User Exits, BAdl’s and ABAP Programming in BW back-end

o BW310 – Data warehousing

o BW330 – BW Modelling

SAP BASIS

• Maintain, customizing and installing SAP NetWeaver 2004/2004s, Enterprise Portals and ECC, Solution Manager on various database
• Backup, restore and recovering SAP Database systems
• Maintain and troubleshooting issues related to SAP systems
• SAP Installation, Upgrades, System copy, Client Copy, SAP performance tuning, Authorization setup, TMS admin (Work Flow), Language support, Applying patches, Backup and Restore.
• Maintain and configuration for ITS and TREX (BIA), SLD, CUA, UME, LDAP, System Creation in Portal for ABAP system and WEB AS
• Configuration for integration between R/3 to SAP EP and BW/BI to SAP EP
• Maintain and configuration SAP EP for PORTAL DESKTOP, Themes, Role, Rule, Permission, Authorization, Transport ( Export and Import ) and Reporting from BW/BI and R/3 to Portal

SAP BW / NetWeaver

o Experience in both BW 3.x and BI 7 system and BEx analyser

o Data Modelling and architecture including standard business content and bespoke development

o Web Application Designer, Report Designer and Broadcasting

o Custom applications using Web Dynpro and Visual Composer

o Proficient with ABAP for use in CMOD’s, transfer rules and update rules.

o Creating Report /chart with Visual Composer and Web Dynpro get data from R/3 System

o Interfacing BW with VBA and VB using BAPI

o ABAP including transfer rules, update rules and function module creation.

o Performance tuning of data extraction using indexing and aggregation

o Query Designer including restricted/calculated key figures costumer exits (CMOD), exceptions, conditions, cell definition and report to report interface

o Analysis Process Designer and Data mining

o Authorisation and Roles

o Process chains, creation and administration

o Business content – Activation and Modification

o Activating and modifying standard BC extractors in R/3

o Human Capital Management in R/3 system

IT Experience

IT Education Course

o Small Business Server 2000, Microsoft Exchange Server 2000 and 2003

o Windows 2000 Server and Windows 2003 Server Fundamental

o Microsoft Visual Basic 6, .Net 2003 and .Net 2005

o Cisco Router and Cisco Switch

o Certified Ethical Hacker

o ASP.NET with C#

o ASP.NET with VB.NET 2003 (OOP)

o ASP.NET 2.0 with C# 2005 (OOP)

o ASP.NET 2.0 with VB 2005 (OOP)

Server and Desktop Development

o Maintain, configuration and installation of:

o Mail server using Exchange, M-Daemon, Merak Mail Server , Lotus Note Domino

o Proxy server with ISA Server 2000 and 2004

o Server AD DC

o Backup and Joining Server

o Installation and configuration Antivirus client Server (Norton, AVG, ANTIVIR, KASPERSKY)

o Disaster and recovering database with SQL server

o Client configuration for XP and 2000Prof with Group Policy

o Maintenance and configuration or Server Storage and Printer Server

• Administering Microsoft SQL Server 2000 and 2005
• Extraction, transport and loading process using Microsoft Transaction Server.
• Administering, Backup and Recovering MaxDB
• Installation OS Unix FreeBSD

Application Desktop Development

o Invoice Application, Preventive Maintenance, Meal Accommodation Sheet , Standard Recipe, Inventory, General Affair Application, Export and Import Application, Forwarding Application (VB)

o Company Profile on WWW.INDOCATER.CO.ID (ASP)

o Intranet Absents (Cold Fusion MX)

o HRIS (ASP.NET 2.0).

Other Training education

o LB Management for Communication Skill (Certificate)

o English Course (Certificate)

o Basic Offshore Safety Emergency Training (BOSET) (Certificate)

o Emotional Successes (Certificate)

o Erasmus Huis Dutch course (Certificate)

Consultancy Skills

Communication:

• The ability to communicate in English and Indonesian.
• Intermediate to communicate in Dutch.

Oracle :

• Administering Oracle 91 and 10g
• Managing database backup and recovery using Oracle Recovery Manager (RMAN)
• Performance Tuning

SQL Server :

• Administering Microsoft SQL Server 2000 and 2005
• Extraction, transport and loading process using Microsoft Transaction Server.
• Backup and recovery using query SQL and Database replication

Max DB :

• Administering Max DB database
• Managing database backup, restore and recovery, parameter in session track

Web and Desktop Application :

• Building portal web-site
• Creating reports for SAP BW using java
• Building interfacing BW with VBA and VB using BAPI
• Building office Application such as ( Invoicing, GL, POS, HRIS, AR )

SERVER and Client :

• Maintain and installation server and client such as ( AD DC, Mail Server ( Exchange, Lotus Note ), Proxy Server , Group Policy, Backup/Restore, Security )
• Maintain and configuration networking such as ( VLAN , Router, Switching, ADSL, Site2site, Per2per )
• Maintain user access for security environment

SAP BASIS :

• Maintain, customising and Installing SAP NetWeaver 2004,2004s R1/R2 , Enterprise Portals and ECC/R3 on various databases
• Backup, restore and recovery SAP Database systems
• Maintaining and troubleshooting technical issues with SAP Systems and authorization or role
• Integration Between R/3 system to BW/BI system and R/3 to SAP EP or BW/BI to SAP EP
• Configuration SEM for Balance Scorecard in ECC/my SAP
• Configuration in SAP EP ( collaboration room, forums, themes, portal desktop, integration to LDAP/OWA )

SAP BI/BW :

• Creating report in BI/BW publish to Portal, Creating report using Visual Composer, Web Dynpro as ABAP, Bex Query, WAD, Report analyses to Excel.
• Data modelling in BI/BW, getting data form R/3 system or Flat File or from another DB with DBconnect in BI/BW / UDConnect

Project Experience

Sarijasa Transutama – JAKARTA, Indonesia 2003 to 2004

Deri built a local area network utilising Cisco switches and routers for the active directories and domain controllers in the business.

He also developed and implemented a solution for the shipping system to manage and monitor documents in business.

ImajixNet.COM – JAKARTA, Indonesia 2004 to 2005

Configuration of a mid-size scale company network to establish an inbound and outbound connection to the internet and mail servers.

MADANI Mart – PEKAN BARU, Indonesia 2006 to 2006

Development of the POS (Point Of Sales) system and support for the IT team to build an easy and simple transactions.

Large Media Publishing Firm – JAKARTA, Indonesia 2006 to 2007

Implementation of BW 3.5 (2004) Responsibilities included:

• Creation and maintenance of KPI reporting using BEx-Analyzer.
• Development of user exits for BEX-reporting
• Setup of aggregates
• Creation of BI documentation for recording end user commentary.

Manufacturing Company , Thailand - 2007 to 2007

Implementation of BI 7.0 with Enterprise portals, His responsibilities on this project was to create the required queries for KPI reporting, however he was heavily involved in the following activities:

o Data Model build (ABAP for Transfer and Update rules)

o Creating ODS and Info Cube

o Report to Report Interfaces / Drill Down Report to Line Item

o Report Documentation

Service Company, Australia (Remote from Indonesia) 2007

Maintenance of the Oracle DB and parameters. Responsible for the creation of aggregates to improve query performance. Transport of system configurations, applying patches and OSS notes. Maintaining BW datamodel and enhancing queries to provide more detailed information, this also included the writing of ABAP for customer exit variables.

Manufacturing Company , Nederland (Remote from Indonesia) 2007

Responsible for the creation of aggregates and copy to multiple aggregates to improve query performance using ABAP.

Bank – Nederland (Remote from Indonesia) 2007

Creating Report for data model monitoring using WebDynpro as ABAP

Current Project in FMCG company – JAKARTA, Thailand, Malay, Vietnam 2007

Deri is responsible to Implement SAP NetWeaver 2004s R2 64bit, SAP EP 7.0 64bit, BIA on Blade Server

His project Responsibilities including:

• Installing Oracle DB 10.2..2(R2) 64 bit and patching for Oracle DB
• Installing SAP NetWeaver 2004s R2 64bit on Windows 2003 server R2 64bit SP2 for (DEV, QA, PROD and Test)
• Installing SAP EP 7.0 64bit on Windows 2003 server R2 64bit for (DEV, QA, PROD and Test)
• BI Accelerator for performance reporting in BI system using Blade server on LINUX SUSE 10 sp1 64bit SLES
• Integration between SAP BI and SAP EP, SAP R/3 and SAP BI, SAP R/3 and SAP EP
• Creating Transport Management for DEV, QA, PROD, Test with Work Flow configuration
• Patching all SAP System
• Creating BI authorization and Role
• Creating EP authorization and Role
• DBConnect to the other DB
• Activation BI content to extracted data from R/3 system