About me
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
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
dpermana
Good.
I think you have a lot of experience in SAP environment, and this time for you to go live. and hidup orang Bandung
Keep learning buddy.
Hi,
I am Dharmendra, I am new in SAP R/3 Administration. Persently I am core team member of a oil and gas company of india for Implementation.
May you give me idea for server sizing and no of servers, clustering, DEV, QAS, PRD- Database, Applications, trex, content, Web dispatcher/ITS, XI, BI, MI thier usage in oil & gas company and nof servers required for it.
Thanking you
Howdy,
My company just upgraded my computer with Windows XP 64-bit Edition. Therefore I had to upgrade my SAP to GUI 64-bit.
But when I run BW/BI, I do not get the BEx Analyzer drop-down in the menu bar of Excel. Is there an Add-in that I need or am not seeing?
Thanks.