Position Applied : IT System Analyst/Developer.
Name : Abram Ington Sugita
Place / Date of Birth : Jakarta /June 26, l979
Religion : Christian Advent
Marital Status : Single
Height / Weight : 170 cm / 64 Kg
Address : Pondok Pucung Indah Tahap 2, Blok A.8 no.9
RT/RW:01/06 Pondok Aren, Tangerang 15229
Telephone : 08176070600 / 08176611228 / 02192681262
Email :
EDUCATION
l997 – 2004 : UNIVERSITY BINA NUSANTARA, JAKARTA
MAJOR: SYSTEM COMPUTER
1994 – 1997 : SENIOR HIGH SCHOOL, JAKARTA
WORKING EXPERIENCES
Mei 2004 - Present : PT.Indoxchage Tbk.
On Chase Palza Building, 19th Floor.
My Responsibility:
1. Database Programming using Visual Basic, VB .NET and SQL Server 2K
2. Database Administrator SQL Server.
3. Data Warehouse Developer and Maintenance.
4. Wireless WAN Router Administrator (ZG5000-11g, IH1500-11b , Radwin - Israel), and Wired LAN Administrator.
5. Web Developer and Administrator (using ASP).
6. Database Tuning and Wireless Bandwidth Tuning.
Project PT. Marga Mandala Contactless Smartcard
Project MMS Phase I (IT DEVELOPER)
• Build TOD (Tour of Duty) application (Data Analysis Application that analyze data transaction from Toll Transaction in each Gate, Data was generate from TCT machine and other’s machine while Pultol doing a transaction) and Data Analysis, using Visual Basic, SQL Server 2000, Crystal Report 8.5.
• Software/Hardware maintenance and technical support for TOD (Tour of Duty), TCM (Toll Collector Manager), PSM (Plaza level Smartcard Management), TPS server (Toll Plaza Server) and ODC server (Operational Data Center).
Project MMS Phase II (TEAM LEADER)
• Develop data warehouse software (synchronization from nine gates to one point ODC-Operational Data Center) and database data warehouse architecture. From nine gates automatically sending data transaction to operational Data Center (ODC). At ODC data received and automatically restored.
• Design and Develop Patroli and Analysis Application.
• Develop Web data transaction Analysis for nine gates (TPS) and data center (ODC) using ASP & XML.
• Database APKOS Maintenance & Tuning.
• Database TPS and ODC Maintenance and Tuning.
• SQL Server Service Tuning & Optimizing, to get best performance execution time, disk caching, memory cache, and other setting that effect with service performance.
• Develop an Inventory and Technicians Application and Report in Peralatan Toll Division.
• Develop a Real Time Application that Synchronize Inventory and Technicians Database from one Gate to other gate (Long Distance Data Communication–Wireless Or Dialup/RAS), using TPC/IP Winsock Protocol and FTP Protocol.
• Develop a Report For SPD (Sistem Pengolahan Data), that Analyze Toll Revenue, Toll Traffic etc.
Project MMS Phase III (IT DEVELOPER & ANALYST)
• Develop a Real Time Application that Synchronize Huge Smart Card Database (million of Record) from one Gate to other gate (Long Distance Data Communication - Wireless), using TPC/IP Winsock Protocol and FTP Protocol.
• Wireless WAN Router Administrator, to communicate between nine gate (every gate have router, antenna wireless, server and some of clients) scattered from Cikupa kilo meter 31 to Merak kilo meter 97.
• Wired LAN Administrator for nine gate.
• Develop and Update TOD in order that Support Smart Card Transaction and Smart Card Data Analysis.
• Update & Major Bug Fixing PSM Application (Plaza Level Smartcard Management).
• Database PSM & HSM Maintenance and Tuning.
Project MMS Phase IV (IT DEVELOPER & ANALYST)
• Develop and Update TOD in order that Support Barcode Overload Transaction and Overload Data Analysis.
• Develop and Update TOD in order that Support Barcode Single Used Transaction and Single Used Data Analysis.
• Develop Web base data transaction Analysis and Recapitulation for Overload and Single Used Transaction. In nine gates (TPS and PSM) using ASP.
Apr 2004 – Mei 2004 : Hardware and Software Development of EFT-POS & VB
At PT.Grajaya Grammi Grafika
On Jakarta Stock Exchange Building Tower II, 17th Floor.
• Develop a software/application that flashed to EFT-POS or EDC device like PAX70-S, Nurit 8320 (using the SDK that base on Microsoft Visual C++ language).
• Hardware Maintenance and Technical Support for EFT-POS/EDC device for P70-S and Nurit 8320.
• Develop Database Software using VB (not the main Job)
Nov 2003 – Mar 2004 : Database Programmer at PT.Perkamen Ideal Sejati
On Grinting Street Petogogan, Blok A.
• Develop two Database Software that manage and manipulate Citibank Surveyor and Citibank Collector Databases.
• Develop a Module to convert Data Columnar structure to Tabular Report, using Visual Basic for Application (VBA) under Excel environment.
• Develop a module that create a Citibank Credit Card Customer Surveyor Form Report, using Visual Basic for Application (VBA) under Excel environment.
Feb 2002 - Okt 2003 : PT. Dentsu
On Graha Niaga Building Floor 22th , Sudirman.
• Technical Support, Network Administrator and maintenance.
• Database Administrator (SQL Server 2000).
• Develop a module to convert database structure to desire form using VBA. As the final form it was convert to SQL.
Jan 2000 – Okt 2001 : IT Freelance
• Giving Course in Web Design, Graphics Design, Image Editing, 3D Modeling, Animate 2D/3D, Programming and Resolve Computer Trouble/Problem.
• Build two software’s that ordered from my friend that don’t have time/ability to made her/his Thesis.
• Open a Private Enterprise :
Þ To Repairing/Resolve Computer Trouble (System Troubleshooter Hardware/Software, OS Installation, Data Recovery, Monitor Repairing, Printer Repairing, Fixing CD/DVD Rom laser/optic, Fixing Power Supply).
Þ Fixing Sony Playstation Game Console, Dreamcast, Sony PlayStation II
Þ Fixing Handphone trouble like Nokia 3xxx series, Motorolla T19X series and Siemen Cxx/Mxx/Sxx /SLxx series.
Dec 1999 – Jan 2000 : IT Programmer at PT. TING SHEEN BANDA SEJAHTERA
On Pangeran Jayakarta Street.
Two Months Project as Database Programming (using VBA)
SKILL
q Programming : Delphi, VB .NET, Visual Basic, VBA, Visual C++, SQL Server, Crystal Report, Oracle, Turbo Pascal, Turbo Assembler
q Knowledge in Hardware/Software for EFT-POS or EDC device like PAX 70-S and Nurit 8320.
q Networking Windows 2000 Server.
q Web/Internet Programming : ASP, Java, Java Script, VB Script.
q Experience in Data Recovery (Recover broken Data in Storage Media).
q Ability to Cracking Program (Software) almost 60 shareware application has been cracked by my self (Education Purpose Only).
q Ability to create a VIRUS MACRO under Ms Office Environment.
q Experience to Resolve Computer Trouble Software/Hardware.
q Design Web (Dreamweaver, Firework, FrontPage, Photoshop).
q Making Dynamic Web/Animation Web 2D (Macromedia Flash, Swish, Swift 3D)
q Graph Design & Image Editing (Photoshop, Freehand, Illustrator, Instant Artist)
q Video Editing (Adobe Premiere, Ulead VideoStudio, VCD Cutter)
q Sound Editing (Cool Edit, CakeWalk, Melody, Sound Recorder)
q 3D Modeling & 3D Animation (3D Studio Max 3, Maxon Cinema 4D 7XL, Bryce 6, TrueSpace 5, Animation Master 2000)
q Familiar to use Common Program like :
§ MS Office (Word, Excel, Acces, PowerPoint)
§ Utility/Tools Program (Norton Utility, Ghost And Antivirus, Partition Magic, Nero Burning ROM, Norton CrashGuard, Hex Editor, UltraEdit, WinZip, WinRar, WinAce, McAffee Antivirus, PCCillin, F-Prot, F-Secure, Panda AV, Sisoft Sandra)
