Complete SQL Database for .NET Application

Budget $750 - $1500 USD
Bids 68
Average Bid $1272

Project Description:
We are looking for a highly skilled and experienced database expert (SQL + MySQL) to complete the backend for an existing [url removed, login to view] MVC4 web application running on MSSQL 2008R2, and write the appropriate store procedures to link the backend to the already-completed presentation layer.

To date, development of the database schema in its current form has been haphazard and inconsistent - a result of multiple developers making patches to achieve a desired result in the presentation layer. With the presentation layer now complete, the supporting data infrastructure must be cleaned up - you will be tasked with creating an efficient, relational database with associated store procedures to ensure the application functions per the requirements.

In addition to the .NET application, our web service also relies on a MySQL/PHP service that already contains all the tables/schema needed within the .NET application. Our recommended approach would be to adapt the MySQL DB schema/tables to the .NET framework. However, you are welcome to approach the project in the manner that is most efficient to you or your team.

Required skillset:
- Extensive SQL and MySQL building and DBA experience
- Visual Studio/.Net Experience (C#; C++; [url removed, login to view])
- Web services integration (XML/JSON) experience
- Object oriented (JavaScript/jQuery) experience a plus
- Agile development environment and source control (GitHub)

Bidding Requirements:
For you or your organization to be shortlisted for this project you must meet the following requirements:
- Must show and demonstrate relevant references to past work related to this project
- Code must be clean, efficient and WELL DOCUMENTED!
- Must have a Freelancer rating >=4.5
- Must be able to communicate freely in English

BIDDING INSTRUCTIONS - YOU MUST FOLLOW THESE GUIDELINES!!
- To verify that a human is reading and responding to this post you must visit the following link and include the color of the books in your bid message:
- For shortlisted candidates, to receive additional details regarding this project, you must sign our company’s NDA (not Freelancer’s).

Thank you for considering our project. Happy bidding and good luck!

Post a Project Like This

This project was awarded to

proegler

Lolt was wonderful to work with. We were dealing with an area far outside of our expertise, and Lolt always carefully explained what he was doing and why he was doing things a certain way. This project even stretched him out of his comfort zone in terms of skill set, but he was willing to go that extra mile for us. Lots of contractors out there who can implement exactly what you tell them, but Lolt brings a wealth of experience to the table, and can contribute to your project in many other ways. Hope we're able to work with him again!
About the Freelancer
proegler Profile Picture

My expertise covers a range of technologies but my principal focus has always been on the development of innovative technical solutions employing database technology (Access, DB2, Informix, Oracle, SQL Server.) as the backend for enterprise solutions. For the past 2-3 years my emphasis has been on C#.Net, primarily with SQL Server or integration projects across Office technologies (Access, Excel and VBA) .

Looking to make some money?

  • Set your budget and the time frame
  • Outline your proposal
  • Get paid for your work

Bids on this Project

  • WebBizSolution Profile Picture

    WebBizSolution

    Glasgow,  United Kingdom

    We offer perfect solutions tailored to meet your style and needs. We go for solutions that bring you on top and an edge over your competitors. With an extensive range of services that suits your needs, we are there to give professional assistance .

    PHP, XML, Website Design, and Logo Design

  • IShailaza Profile Picture

    IShailaza

    Visakhapatnam,  India

    I was worked in GE as Project Lead and also working as a freelancer Specialized in Website Designing , Development (ASP, ASP.Net, AJAX, SQL Server and PHP development) services. I customize my processes and reports based on client's styles and guidelines. All my work remains in the background and the end client never knows that the work has been outsourced resulting in both savings and brand value for you and your company. I strictly work on performance basis and can assure you of getting quality works.

    ASP, JSP, Javascript, and XML

  • UmbrellaSri Profile Picture

    UmbrellaSri

    cbe,  India

    Hi, i am Sridhar from India. I am a master graduate and i was in the filed of software around 7+ Years.I had a very good knowledge in Microsoft Technologies and Financial & Marketing domains. I hope i have enough knowledge to handle business and so i started a business and now working for a client from UK. I can give best solutions with advanced technologies and yes of course i expect proper clients and i want to put my dedication in right place.

    Visual Basic, .NET, Windows Desktop, and AJAX

  • WJ6I3zLa1 Profile Picture

    WJ6I3zLa1

    Adana,  Turkey

    SOLVER COMPUTATIONAL SERVICES

    Perl, Visual Basic, .NET, and Mobile Phone

  • onurissi Profile Picture

    onurissi

    Quilmes,  United States

    Im SQL DBA, trying to find some extra job, and focus on learning from experience to develop good programming solutions and designing database solutions. I'm already certified MCTS and MCITP on database administration, I'm experienced on global companies like IBM implementing high availability environments and currently working in a more demanding company where I can work with DB tuning as well as taking advantage of the already learned skills. I've taken the challenge to do at least 2 certifications a year to keep on growing.

    Translation, Data Entry, SQL, and Microsoft

  • PSSPL2000 Profile Picture

    PSSPL2000

    Vadodara,  India

    Prakash Software Solutions Pvt. Ltd. is a software development company based in India specialized in Custom Application Development, Quality Check, Analysis and IT consulting. Services: • Cloud based Systems - Architecting, Build, Development, Implementation, Cloud Infra Management • Web Application Design and Development • Microsoft Public Cloud Architect, Design, Build and Deploy. – includes Office365 SharePoint Online, Skype for Business, Exchange Online, Yammer, Delve, Power BI, Visio and Project Online • Office 365 Migration Services for SharePoint • SharePoint Architecting, Design, Development and Implementation. • Microsoft Enterprise Project Management (EPM) Solutions • SharePoint Migration • SharePoint Business Intelligence • SharePoint Branding • SharePoint Work Flow • SharePoint Web Parts • Migration and Re-engineering • Rich Internet Application Development • CMS Development • E-Commerce application development • Mobile Application Development

    PHP, ASP, JSP, and Javascript

  • subhanisaleem Profile Picture

    subhanisaleem

    islamabad,  Pakistan

    i m senior .net developer working since 2002 ......

    XML, .NET, Windows Desktop, and AJAX

  • spfcneto Profile Picture

    spfcneto

    Sorocaba,  Brazil

    Zone Zero Network is a professional firm that provides high-quality services for web designing, web development, search engine optimization and many other web solutions. Whether you want to take your business online or convey a more professional appearance, we offer distinctive and viable website solutions. Web Design - When you choose our company, you will receive the classiest designs embodied in your corporate colors. You will be able to communicate your message with a bang. We will work together to help you create a powerful and lasting impression. Web Development - From web and e-commerce software development to maintaining sophisticated Internet applications, we have the expertise to help you roll out your interactive campaign, right now! Internet Marketing - A comprehensive online marketing strategy is imperative to stay afloat in today's virtual market. The parameters to judge online success include your website's ability to attract new clients, convert visitors into leads and ultimately sales, maximize turnover and maintain customer loyalty. From our inception, we have created numerous websites that cater to diverse target groups. Our creative sense, experience and expertise enable us to deliver the latest designs and styles so you can gain a competitive edge.

    PHP, XML, Adobe Flash, and Visual Basic

  • KrantiTech Profile Picture

    KrantiTech

    Noida,  India

    Software Consultancy & Development, Tailor Made custom software solutions, IT support & maintenance services and an effective engine to help organizations building an online presence which includes development, maintenance and promotion of their products and services through latest technologies.

    PHP, ASP, Javascript, and .NET

  • sinharavi Profile Picture

    sinharavi

    Bangalore,  India

    ## BIO RAVIRANJAN KUMAR SINHA (Sun Certified Java Programmer)  [Removed by Freelancer.com Admin for posting of Contact information] Objective To secure a challenging assignment in a dynamic environment that would require my aptitude and technical skills and give ample opportunity for my all around growth in the software industry. Work Experience Total 2.9 Years Of Experience in IT Industry. ? 2.9 Years of Experience working on VB.NET, ASP.NET, Oracle9i/10g, SQL Server 2005/2000 . Professional Summary 1.) Softrade Infoware Private Limited, Bangalore From July 2007 to till date. 2.) Laavanya Technology, Bangalore from January 2007 to June 2007. Technical Summary ? Very Good Knowledge of Programming in VB.NET, C# .NET. ? Very Good Knowledge of Programming in ASP.NET. ? Good knowledge of Web Services. ? Very Good Knowledge of writing Sequel Query in Oracle . ? Very Good Knowledge of writing stored procedure in Oracle. ? Very Good Knowledge of writing Sequel Query in Microsoft SQL Server 2005. ? Very Good Knowledge of Java Technology. ? Good Knowledge of VB6. ? Proven ability to work as a Team. ? Design, Development, and Coding. ? Debugging and troubleshooting the application. Technical Skill Languages : VB.NET, ASP.NET, Java, J2EE(JSP,Servlet) Database : Oracle9i/10g, SQL Server 200/2005 Web Development : ASP.NET, ADO .NET, J2EE(JSP,Servlet) Database Tools : TOAD, Oracle SQL Developer Reporting Tool : Crystal Report 11 OS : Windows 2000/XP Excellence SCJP Certified (Sun Certified Java Programmer) Academic Credentials BE (Computer Science & Engineering) in 2005 Bhagalpur College Of Engineering 69% TMB University Bhagalpur, Bihar 12th Sardar Patel Memorial College 52% Bihar Sharif, Nalanda, Bihar 10th HSDS Nalanda, Bihar 60% Project #1 Project Title FinOPS Language/Tools Used VB.NET 2008, SQL Server 2005, Dx Report, Infragistics 8.3 Team Size 4 Duration April 2009 to till Date Role Developer Project Objective This project is customized to meet SKS (A Finance Company) needs. The application is customized to provide solution for Finance management system. The purpose of FinOPS is basically to keep track of Clients, Loans taken by clients, repayment of loans, including Assignment, Stamping, Head Office Entry. FinOPS is developed to give updates of Loan taken by the clients, Repayments of Installment, Late payment , Head Office entry. In this project loan can also be sold to other banks. Also functionalities are calculating IRR(Internal Rate Of Return), Head Office entry, Stamping Transaction, Assignments and others. For the reporting purpose many reports are developed in different entities Loan Disbursement Summary, Loan Disbursement Detail, Product wise Loan Outstanding, Month wise Ageing Outstanding, Portfolio Rundown, Loan Written Details and others. Based On user rights many roles are defined. Responsibilities • Developing various functionality using VB.NET • Developed many stored procedure in SQL Server 2005. • Created Index and Partitions for making fast execution • Responsible for designing Report. Project #2 Project Title dbPays4 Client Deutsche Bank Language/Tools Used VB.NET 2005, Oracle 10g, Crystal Report, TOAD, Oracle SQL Developer Team Size 3 Duration July 2008 to April 2009. Role Developer Project Objective dbPays4 is used to monitor and maintain payment system for DEUTSCHE Bank. The major modules are Master Upload, Customer Instruction, Process, payments(WBR) ,Payments(ABR), Charges, Accountings, Cheque Atpar . In this project we are using DJ Convertor to convert different format of Cheques. Module which I have done is Master Upload, Payments, Customer Instruction, Accounting and charges. In this system two types of charges is there Customer charging and partner bank charging. Payments within Bank Reference means payment generation for a client given by single customer and Payments Across bank reference means payment generation for a client given by more than one customer. Responsibilities • Developing various functionality using VB.NET. • Developed various stored procedure to implement functionality of process program. • Responsible for Designing Report. Project #3 Project Title ChitSmart Language/Tools Used VB.NET 2008, SQL Server 2005, Dx Report, Infragistics 8.3 Team Size 4 Duration March 2008 to July 2008 Role Developer Project Objective This is a product based product of this company. This is based on chit fund system. In this foreman (Generally Owner) is responsible for the system. The main functionality of this project is giving money to many persons as borrow and they will payback in small installment Daily/Weekly/Fortnightly/ Monthly with very less interest. This is same like a person taking loan from bank but the difference is that in this system they can get money easily without providing any proof and they will pay in installment with very less interest. Because in this system the extra amount earned is dividing to each person. Responsibilities • Developing various functionality using VB.NET • Responsible for designing Report. • Developed many Stored procedure in SQL Server 2005. #Project 4 Project Title Cash Track Client Deutsche Bank Language Used ASP.NET 2003, SQL Server 2000 Team Size 3 Duration December 2007 to March 2008 Role Developer Project Objective Cash Track is used to Monitor and Maintains cash funding system for DEUTSCHE Bank. In this system there are three types of users Customer, DB user and Service provider. Process flow of this system is first customer send request to DESTSCHE Bank with request number then DB User upload customer file to the server, after that service provider user download current date request and he will open downloaded file and he will collect the cash at mention pickup location. Then service provider will do deposit entries. In this system we are using cut off time. If customer adding request after cut off time warning message will popup. This cut off time is defined at the system level by administrator in admin mode. Responsibilities • Implementing functionality using ASP.NET. • Responsible for Form Designing. Project #5 Project Title IMS NET Client Bharat Industrial Corporation(BIC) Language Used VB.NET 2005, SQL Server 2000,Crystal Report Team Size 3 Duration October 2007 to November 2007 Role Developer Project Description This Project Maintains the Ac ## Area of Expertise I have experience in VB.NET, C# .NET, Java , J2EE, JSP, Servlet, JSF, Oracle, Microsoft SQL Server, My SQL, Microsoft Access, Java Script, CSS, Web Services, XML, WCF, JQUery

    .NET, Electronics, Mobile Phone, and Research