Welcome to website of Dejan Mladenovic
Home | Resume | Portfolio | Site map | Contact
Portfolio
Please follow this link to read my Resume or read "About me/Resume" section of my website.
ERP solution
As a member of team in "Informatika Co." I had opportunity to work on ERP project localized for Serbian market as a programmer and that helped me to get inside knowledge of this huge project. Good performance on the field during the implementation of ERP has been a recommendation for me to join in team of "Jaffa" factory and had opportunity to work on the same ERP solution but from a different perspective as DBA and user.

Technology / Platform: n-tier windows application
Client side: Menu windows application on Windows XP
Application server: COM+ components on Windows 2000 Server
Database server: SQL Server 2000 Enterprise on Windows 2000 Server
Languages: VB 6.0, T-SQL, XML
Tools: Visual Studio 6.0, Enterprise Manager, Query Analyzer, Profiler
Controls: ComponentOne TrueDBGrid Pro, ComponentOne True DBList, ComponentOne TrueDB Report...

Here is a list of key features of ERP solution and images of some applications and reports that I have worked on.
ERP solution architecture
See full-sized image.
Features Description
Application wide
  • Navigation toolbar
  • Master - details concept of GUI
  • Tabs and grids for details
  • Zoom detail's row in new form
  • User menu- client side application
Navigation toolbar, tabs
Master - Details GUI
Zoom detail's row
User menu
Financial management
  • General ledger
  • Cash management
  • Pay-roll
  • Chart of accounts
  • VAT
  • Accounts Receivables
  • Accounts Payables
  • Bank accounts
  • Bank accounts management
General ledger
Payment order
Payment order print
 
Sales & Receivables
  • Accounts Receivables
  • Sales invoicing
  • Sales invoicing discounts ( can be optionally applied to the line item and/or the order total value )
  • Handling Customer Returns
  • Customers
  • Products
  • Price lists (or Sales quotes)
  • Sales Analysis (for Individual Customers, for Individual Salespeople, for Individual Products, by Customer and Products)
Sales invoice
See full-sized image.
Sales invoice print
   
Purchase & Payables
  • Payables
  • Items
  • Vendors
  • Purchase invoicing
  • Purchase returns
Purchase invoice
     
Inventory
  • Inventory transactions (adjustments, inventory movements, physical inventory counts, sales order shipments and returns from customers, purchase receipts and returns to vendor, and production order issues and outputs)
  • Item tracking policies - serial numbers
  • Locations setup
  • Authorized Locations for an Item
Item tracking policy
Stock transfers
   
Fixed Assets
  • Definition and grouping of assets
  • Depreciation
Fixed asset report
     
Human Resources
  • Employees' data
Manufacturing
  • Production BOM ( Bill of materials )
  • Production orders (Life cycle of a production order: Entered, Firm-Planned, Released, and Finished)
  • Work centers
Bill of Material - BOM
Production order
   
Dimensions
  • Analytic Dimensions (by customer group, salespeople, bank accounts.)
  • Dimension Hierarchies
  • Reporting by Dimensions
Administration
  • Document counters
  • Document generating model
  • Document booking model
  • Users and jobs
  • Business object permissions
  • Menu creation and administration
  • Application setup
Document generating model
Document booking model
   
Top of page

I have some knowledge about network infrastructure and peripheral devices and one can see how I have set up my home network and peripheral devices.

Please follow this link to see list of hardware equipment that I have been working with or read "Resources/Hardware" section of my web site.

Home network and peripheral devices
See full-sized image.
 
I would like to share with you my qualifications, so please visit the following link to see my online Microsoft Certified Professional Transcript.
Transcript ID: 750479
Access Code: DejanMladenovic
Certificate of achievement: 2780 Maintaining a Microsoft SQL Server 2005 Database

I would like to emphasis that for me is very important continuous improvement in IT field and to be up-to-date especially with MS SQL Server improvements, please follow this link to see the list of courses I have attended or read "About me/MCSD - MCAD" section of my web site.
Certificate of achievement
Top of page
I had the great privilege to work with foreign business associates, particularly with Baker Perkins – Peterborough UK and Cavanna – Prato Sesia Italy and opportunity to work with excellent managers and staff, above all to learn from them many skills which I had not experienced in the past. One of them is Biscuit Line project timeline showing the order in which activities happens and labor which is needed for activities to be accomplished. I have used learned skill to incorporate activities which has been dedicated to me with lab our needed for activities to be accomplished and created comprehensive project timeline which will include activities both including Baker Perkins involvement and including involvement of other contractors and subcontractors who should provide services which will need to be finished for main project. With such project timeline I had visual management tool which very easily gave me answers what, when and with whom some activity should be done within project.

During that period I managed a team of up to 12 personnel of fitters and electricians introduced to them plans for new plant, trained them to use new equipment and tools. Although I held this position for a period of only four months during this period I had opportunity to manage and work with team members, contractors, subcontractors and foreign business associates in a very dynamic period of constructing and installing new plant and last time when opportunity of this size occurred in Jaffa factory was 30 years ago when old plant was constructed and installed.
Project timeline
STAR method  
Situation Payment order exported from ERP solution as .xml file and imported into e-banking solution afterwards doesn’t show in a listing of imported payment orders. Because of that payment orders have to be entered manually in the e-banking solution and efficiency has been reduced.
Task Finding the cause for import with errors and writing a business requirement to ERP solution support team.
Action
  • Created payment order as .xml file.
  • Sent .xml file to e-banking solution support team for review.
  • Got response with corrected .xml file. Some tags were missing in .xml file.
  • Checked reviewed .xml file into e-banking solution. Reviewed .xml file successfully imported into e-banking solution.
  • Wrote business requirement to ERP solution support team.
  • Tested corrected payment order dll in test environment. Test was successful.
  • Installed payment order dll in production environment.
Result Import of payment orders was with no errors, no need for manual enters of payment orders and efficiency has increased.
   
Situation During the implementation of ERP solution in Jaffa 's own shop, where products are sold, I have noticed that different flavors of Munchmallow's bellow standard products were packed in the same boxes. Salesman didn't know which flavor was in the box.
Task

Create labeling system for Jaffa 's products.

Action
  • Created labels for products with fallowing features: each product has its own color, barcode and product name on the label. Green and red colors were reserved for standard and bellow standard product labels.
  • Given approval from management for new concept of labeling.
  • Sent design of labels to commercial department to make order from print suppliers.
  • Introduced new concept to production line personnel and sales personnel.
Result

Created labels for products, better customer satisfaction, and greater job satisfaction for sales personnel.

Top of page
Letters of recommendation and commendation  
Jaffa biscuit factory
Harrah's Cherokee Casino
Cavanna Art of Flowpack
   
Master of Science in Mechanical Engineering
M.Sc. supplement
M.Sc. in Mechanical Engineering
Please follow this link to read my Language passport or read "About me/Language passport" section of my web site.
English language course
German language course
   
Please notice some skills which I have learned, used and familiar with or read more about them in "Interests" section of my web site.
 
   
Evidence of interest in and exposure to more than one culture:  
- Esperanto seminars – helped me to visit many beautiful countries, to meet a lot of interesting people, to have roommates from many different countries. Read more in “Interests/Esperanto” section of my web site.
- Work & Travel USA Program – lived and worked within interesting Cherokee community with 60 students from all over the Europe. Read more in “Interests/Traveling/USA” section of my web site.
- Travels to foreign countries – tourist visits, business trips, seminars and meetings created memorable experiences on many beautiful countries. Read more in “Interests/Traveling” section of my web site.
Top of page
Home | Resume | Portfolio | Site map | Contact
Copyright © 2006 - 2007, designed by Dejan Mladenovic. All rights reserved.