Jhonny Mustafa

JOB DESCRIPTION :

- Maintain BINET application for BAU included but not limited from :

1. Analyze and query checking for web error / wrong data shown from BINET apps.

2. ETL Checking to search root cause if any error data shown.

3. Maintain sql job we created if there is any problem.

4. Develop new Report base on CRM from user.

5. Develop web API for requirement report in Agency Portal application.

6. Enhance / Fixing report in BINET apps through CRM registered by user.

7. Develop SSIS based on requirement by CRM.

8. Analyze requirement and make query using store procedure, create SSRS , and integrate them with our BINET apps to create report for our user.

9. Work closely with BSD team and Dev ETL to understand and fixing problem each request.

- OVERVIEW = BINET is web based application built in c# MVC. BINET used to provide report from almost all department in company. When handling BINET, aside from Web apps, we also maintain query for each report.

Task / Modules I have developed so far :

- Report Daily Submit

- Report Daily Collection

- Report Enrollment AAI NB

- Report Production for TAT

- Report Enrollment AAI PHS

- Report Outstanding Premium

- Report Waiting Period And PEC Confirmation

- Report MOO Activity Log

- Report Summary Daily Submission

- Report Daily History Unit

- Report Billing TMI

- Report Accounting Claim Handling Expenses Payable Summary

- Report Matched Suspense Summary

- Report Payment Control Summary

- Etc.

Duties:

· Develop and maintain RFGen software on client site.

· Bug fixing software

· Deploy software code

· Testing software code

PROGRAMMING PROJECTS:

· RFGen Software. Client: PT.Ajinomoto Indonesia. Web version and RFID version.
Overview: RFGen software is warehouse management system.

· Module I have developed : CR Cancel Picking, consist of: Cancel GI to SAP, Change GSN, Cancel Picking, Change Pallet Location, Report for cancel picking, Report picking list with barcode . Environment : ASP.NET C# , IDE : Visual Studio 2005 , Database : MS SQL 2014 , Reporting : SSRS

· SCM Project. Client : PT. Ajinomoto
Overview: SCM is project to support client requirement regarding Supply Chain Management.

· Build a total 7 Report demand planning , review , stock movement, etc. and display each of them on ASP.NET web view.

· Preparation including : build each web to display report, build each report to display on web browser, and build SP to get data from database.

· Environment : ASP.NET C# aspx , MS SQL 2014 , SSRS 2014

· HR Software. Client : PT. Indesso Aroma.

Overview: HR software is Human resource application used by HRD to enlist employee leave, substitution,etc.

MODULES I have developed :

- Change Request Forget Password.

OVERVIEW :

In order to increase security for their HR portal system, we decided to add encryption to password user stored in DB. After this step, we added one additional page named “Forget Password” , so after implementation, all existing user should change their current password by input their ID and email respectively. And then user will got email notification that their password has been changed to temporary password first, after they login with temporary password, they can input their password again. And user can return to access the HR portal. Environment: ASP.NET C# aspx

TASK I have done :

· Deliver HR portal to server production, include Database and Reporting services

Duties:

· Develop software in team project, based on ASP.NET

· Troubleshooting and research the needs for new software

· Bug fixing software

· Deploy software code

· Testing software code

PROGRAMMING PROJECTS:

· LCMS NIAGA . Client: BANK CIMB NIAGA
Overview: Learning Content Management System. This program is use for employee in NIAGA to take training, take exam, and learning.

· Module I have developed : Training Request Overseas, Training Evaluation, Training Confirmation, Login Page, Sending Email, Training Attendance, Dashboard Activity.

Environment: ASP.NET C# aspx

· CMS CoTrivia.
Overview: CMS (Content Management System) Co Trivia is web based application developed using Code Igniter Framework. This is part of admin side for mobile quiz app named CoTrivia. CoTrivia is mobile (android and iOS) quiz apps which user get couple of question and they should answer within time limit. So this CMS is used to running CRUD Operation for question in CoTrivia apps. (Dummy Project)

· Module I have developed : Display Question, Add Question, Edit Question, Delete Question, Add Subject.

Environment: PHP Code Igniter.

Responsible for developing software to use in office environment. Also in charge of providing support and solution for other division to ensure their job running smoothly

Duties:

· Develop software based on ASP.NET.

· Troubleshooting both hardware and software, such as personal computer, laptop, printer, scanner, outlook, repair and fixing them.

· Check for old computer and prepare new unit, including installation and setting until it ready use for colleague.

· Input several data from other division to system.

· Give explanation and best solution if colleagues asking about technology such as smartphone, laptop, etc.

· Learning new software/hardware in order to update knowledge.

· Accompany collagues to customer’s office to learn and give explanation regarding software they would use.

PROGRAMMING PROJECTS:

· Sales Utility
Overview: This program is use for salesman. Salesman can use this to searching detail information from both customer and product, searching existing customer by name. It also show currency from several country and exchange rate. This program can be accessed from PC and mobile.
Environment: ASP.NET C# aspx

· Monitoring
Overview: This program is use to monitoring item status. Is it on process or delivered? We can check one of them with open data from database, checking item status, we also can overwrite data status and save to database. It also create report.
Environment: ASP.NET C#

· Invoice
Overview: This program is use to create invoice. We can add new item to invoice, and create invoice report.
Environment: ASP.NET C#