Find Jobs
Hire Freelancers

Create a Database , a UI to enter data, generate automated report from database

R10500-21000 ZAR

Closed
Posted about 8 years ago

R10500-21000 ZAR

Paid on delivery
Background of the Operation: Almar Investments specialise in the provision of hot material handling services within the Ferrochrome Smelter Industry and a geographically dispersed throughout South Africa. In order to effectively manage operations, daily metrics regarding Plant Equipment Hours, Diesel Usage, Adhoc Requests, Staff Allocations and Plant Hours Allocated to Specified Areas are required. Thus is currently being generated manually from Excel inputs at our Headoffice based in Rustenburg. Please find attached a baseline operations input model, which is utilized to generate various reports, however this is excel based. Requirement: We are looking for a database solution to optimize and streamline the input of data as well as the generation of daily analytics regarding operations.
Project ID: 9370442

About the project

28 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
28 freelancers are bidding on average R16,746 ZAR for this job
User Avatar
Hello there, I reviewed the spreadsheet you shared and also the requirements brief. From what I understand, you may explore two options. First, for which I have made this bid, is to have the current Excel process augmented by a database backend (preferably MS Access since it is most compatible with Excel). So, your excel front end will remain same and clicking on the buttons would show some 'Forms' rather than the sheet (as of now) and will allow the users to enter the data. We may also explore some 'Upload' features to allow update of spreadsheets instead of entering the data one by one. Reports may then be developed as required for daily analytics. I have done several similar projects and may share some examples if required. Second option (much bigger in scope) is to migrate this complete system online. So all the users would be able to enter their data (or upload files) to an online portal and 'Admin' type of users would be able to generate the reports as and when required. This is operationally much more efficient but is costly as well. I have done similar portals as well. Would you be interested in exploring these options further? Do let me know and we may discuss the requirements in detail. Thanks and Regards, Rishi
R20,000 ZAR in 30 days
4.8 (9 reviews)
4.9
4.9
User Avatar
Hello, I have been working with a MNC based company since last ~ 5 years, as an IT BI DWH Professional. The project is a BI DWH project which covers 3 layers of BI (ETL, Data warehouse & Reporting) and helped me in nourishing my talent in all the technologies around these 3 layers. Below are some key areas of my skills: • Expert in SQL Server, Oracle and MS Access Databases • Expert in BO XI, Cognos and SQL Server Reporting Service (SSRS) • Expert in & designing & Implementation of end to end ETL Process using Informatica & SSIS Tools • Expert in Designing Qlikview Dashboard BI Solution • Expert in ER & Dimension Data modeling • Complete Command on PL/SQL concept e.g. Procedures, Functions, packages and complex queries. • Basic knowledge of Unix Shell scripting • Web Development using Java, CSS, and HTML ,PHP & Java Script • Expert in excel Macro • Expert in C & C ++ Programming I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. I had conducted Informatica & DWH training for a US based training organization from Nov’14 to Dec’14. We recently started our own company “Point5Nyble Your Needs, Our Dream”. We always work to provide Best Delivery with 100 % customer satisfaction Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Ashish-Point5Nyble
R17,777 ZAR in 10 days
4.9 (32 reviews)
5.0
5.0
User Avatar
Hello there I have a team and we have been developing database management softwares fo years both in MYSQL and Oracle. I have understood your requirement kindly contact me so that we can aware of your complete scenario and start making schema and identifying main entities. Contact to learn more!
R10,500 ZAR in 20 days
4.8 (2 reviews)
4.6
4.6
User Avatar
Hello I am Java and Database expert and interested in this project. I have reviewed your requirements and confident to handle this project perfectly. Please communicate to discuss further. Regards Anshu
R18,947 ZAR in 15 days
4.7 (30 reviews)
4.8
4.8
User Avatar
So, you have come to the end of term and realized that you do not have the time to write your final dissertation or essay. Thats where Anacris comes to your rescue. We will provide you with an authentic, well researched and fully referenced assignment to get you the grade that you deserve. Intelligent, Experienced,Quality, recently joined freelancer, have excellent writing and grammar skills. With past employers, I have written many objective reports, articles, reviews and data input. I am 100% committed to deadlines, and have an acute eye for detail. I look forward to working with you.
R16,578 ZAR in 30 days
4.7 (24 reviews)
4.9
4.9
User Avatar
I am TOP RANKED database programmer with 10+ years of experience and completed 700+ projects on this site. I am very interested in your project. Please award me this project.
R17,500 ZAR in 10 days
4.4 (17 reviews)
5.2
5.2
User Avatar
Hi, I have more than 14 years of Programming and VBA/Excel exp and I am expert in this kind of work. I have completed more than 270 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
R17,500 ZAR in 30 days
5.0 (2 reviews)
4.2
4.2
User Avatar
I have 4 + years of experience in MSBI Technology(SQl Server 2008/2012) Expert in creating Sql queries ,Dynamic T-sql,functions,triggers,indexes etc Expert in creating SSIS package ,configuration,Deployment and Scheduling and extracting the data from different sources like sharepoint lists,excel files,csv files,Data feedstore,mysql database,sql database etc Expert in creating different ssrs reports like drill through,drill down,parameterized,table,matrix, tablex etc SSRS reports integration with sharepoint and with web services . Fetching the data from multidimensional cube with the help of MDX queries and creating SSRS reports
R15,000 ZAR in 7 days
4.5 (16 reviews)
4.6
4.6
User Avatar
I can absolutely help you with this! Let me introduce myself I am Archil, a veteran developer working with .NET and SQL server for over a decade. In order to satisfy your needs I can build a database with web or desktop frontend, also I can design brilliant looking report forms in SSRS. It is pretty much faster and efficient way to handle large amounts of data such as your companies. Excel and Access couldn’t handle it. Estimated time of finishing is two weeks and price is 15000 ZAR Thanks for your attention and waiting for your call Archil
R15,000 ZAR in 15 days
5.0 (1 review)
3.2
3.2
User Avatar
Dear Sir/Madam, It’s a great pleasure me to bid on your project. I am a 8 years experienced web Developer / Software Engineer.. I hold two master degrees for Computer Science and GIS. Please see my profile I have enough experiences and gained lot of job experiences working in various world recognized institutions. I am maintaining nearly 100% on time job completion rate with 5 star rating in freelancer.com customer reviews. And also I have passed the necessary skill examinations in freelancer.com which are related to complete your project. As a master for Computer Science I can handle your project to meet your requirements which are listed in the project description. I will start your project for a minimum initial payment and balance you can pay at the end of each milestone or you can create milestones at your convenience according to satisfaction of my work. Further I will give you 3 months free of charge bugs fixing and maintenance service to improve your application’s performance. I will let you to see progress of your project by hosting your application on my live testing server. Please accept my bid if u are satisfy with my proposal. Thank you for giving opportunity to bid on your project…!
R15,789 ZAR in 30 days
5.0 (3 reviews)
2.8
2.8
User Avatar
Dear Sir/Madam: I am interested in your project recently posted on Freelancer.com. I have experience in developing pieces of and working with Enterprise software combined with Analytics which is just enough for your project's needs. Add to that my hands-on experience with Django web framework for the user interface. Daily Reports could be delivered using any existing open-source BI tool such as Pentaho, or even a commercial one like Tableau. Look forward to hearing from you. Yours truly, Yordan B
R18,500 ZAR in 18 days
5.0 (2 reviews)
2.6
2.6
User Avatar
I have read and fully understood your requirements.. Please open chat to discuss. =============================================================================
R17,500 ZAR in 30 days
4.5 (6 reviews)
3.0
3.0
User Avatar
Hi - I am an experienced Access developer and run my own small IT agency in Durban, South Africa, where I create and maintain Access systems, which is the core of my business. I have also successfully completed several Access projects here on Freelancer. My special interest in this project is that I have assisted many companies in migrating from Excel-based systems to MS Access, and I am familiar with the processes required for such a transition. I had a look at the attachment that you included in the project, and since the information is already very well organised, with clear field names to the various columns, and a menu that indicates the structure and flow that is required, this transition could be done within the budget of the project. I prefer to establish long-term relationships with my customers and I remain on standby once the initial system has been delivered, in case further enhancements are required, which will be done according to an hourly rate. Please feel free to contact me if you would like me to participate in your project or if you have any questions for me. Kind regards - Karin
R21,000 ZAR in 30 days
5.0 (1 review)
0.7
0.7
User Avatar
A proposal has not yet been provided
R17,500 ZAR in 30 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Need a Database interactive software ? No problem, I have developed similar software but its a POS that holds the same functionality as you want. I have read your requirements and I can certainly work for you. I have developed database interactive systems before that you can see at my profile. Plus i can show you a sample of my work that includes database handling in a software. I assure you of quality work with no wastage of time and at an affordable price. To see my previous work you can visit my profile. As for this job i am ready to work on your project. Looking forward to hear from you. Thanks.
R11,111 ZAR in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I would be able to create an online secure web form for you to interact with data from the database. You would be able to view and export reports to Excel sheets. I'd use ASP.NET to do this, a technology I've been working with for 3+ years. The database would be MS-SQL based. I will do this for the minimum budget. Please contact me to discuss further.
R10,500 ZAR in 28 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am a senior software engineer, from South Africa - with an honors degree in computer science from UCT. I run a small software consulting company, and have experience building and maintaining mission critical software for various companies (the likes of Vodacom, Mweb, etc.) I am always on the lookout for new clients, and would like to offer my services to assist with your IT software development needs
R16,666 ZAR in 30 days
0.0 (0 reviews)
0.0
0.0
User Avatar
This Project involves • Understand the requirements of the user and accordingly design the database structure and decide the no of screens required to take user input. • Creation of screens for data entry, data validation, and storing the input in the database • Creation of reports in order to display the consolidated data from the database. My Profile • I have worked extensively with Microsoft SQL Server Databases, Tables, Views, Constraints, etc. Also worked on projects involving complex SQL Queries including joins, union, intersect, sub queries etc. which will be involved in creation of views. • I have also worked with .net projects involving authentication, data entry and validation, data flow and processing, displaying the appropriate output to the user. My Approach • According to my understanding of the project, since it involves data entry from multiple location/sites, it requires a client server architecture where in the client connects to the server and all the data is stored in a single repository. This would also make generating the real time reports quite faster and easier. • Also design the forms with minimum user input and appropriate data validation so that the data repository is complete and accurate. • Tools used by me for building the project o Microsoft Visual Studio (Asp.net) for creation of User Interface o Microsoft SQL Server for the database I would like to work with you on this project. Kindly get in touch if interested. Thanks.
R11,666 ZAR in 30 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello! I'm proposing a solution based on eiter MS SQL Server, DB2, Oracle, MySQL, PostgreSQL or Firebird SQL server(company LAN or cloud based) - as per your preferences. Regards, Evgeny
R17,500 ZAR in 8 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, Hope you are doing well. I have gone through the requirements and found myself best suited with this job as I have recently done the same work I can show you the code and running sample also. the product is for sales reporting. We are highly qualified and experienced team works on large Java based web applications using following technologies. Java, j2ee, spring, struts, jsp, jsf, ejb, hibernate, ibaitis, I but , camel, maven, gradle, ant, mysql, oracle, mongo, json, xml, HTML, CSS, bootstrap, angular js, jquery, JavaScript, hyperjaxb3, Jersey web services and spring rest web services. we have developed applications with following feature secure web SSO login user management with roles hierarchy business intelligence reports emailing feature live dashboards to show live business API integration Please let me know how may I help you awaiting positive response Regards Vishal
R16,666 ZAR in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of SOUTH AFRICA
South Africa
0.0
0
Member since Jan 18, 2016

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.