offline
Last seen: Jul 12, 2014 10:36 AM EDT
Hire Me!
Rate: $10.00 USD/hour
Follow Invite to Project
 
Browse Similar Freelancers:

Prateekagra

Software Development and database managament

Username: Prateekagra

  • Has made a deposit.
  • Has verified their email address.
  • Has completed their profile.
  • Has verified their secure phone number.
  • Verified
  • Payment is not verified.

Location: Delhi, India

Member since: October 2010

Reputation:

4.8/5

(7 reviews)

4.2
[see more]

1 user has recommended this freelancer.

My projects:

  • $135.00 USD
    5.0
    Profile image for Seller Five01CIO

    Five01CIO

    Jan 16, 2014

    As proven time and again, Prateek is my go-to person for SQL Server and .Net needs.

    Project Description:My client needs to set up SQL Server Reporting Services on a Windows Server 2012 computer and migrate about 10 SSRS reports from a Windows 2003 server to this new one.
    [more]
  • $75.00 USD
    5.0
    Profile image for Seller Five01CIO

    Five01CIO

    Dec 22, 2013

    Prateek has become my favorite Freelancer consultant. Time and again I have turned to him for assistance, and each time he continues to prove himself to be the go-to person who gets the job done.

    Project Description:After changing the sa password on our SQL Server for security reasons, a mission-critical SSIS package stopped working. Numerous attempts to fix it have failed. Our lack of understanding the various...
    [more]
  • [Sealed]
    5.0
    Profile image for Seller TetraMedia

    TetraMedia

    Nov 16, 2013

    Prateek did a great job. His performance was excellent.

    Project Description:Experienced SQL programmer required to implement database mirroring between SQL servers. Two Cloud Servers in same facility, running MSSQL 2008 R2 Enterprise, with Windows 2008 R2. Need to be...
    [more]
  • $75.00 USD
    1.0
    Profile image for Seller Five01CIO

    Five01CIO

    Oct 29, 2013

    Prateek did a great job. This is the 3rd time he has completed a project for me. As you can tell, I like his work and would recommend him to anyone.

    Project Description:I need a SQL 2000 View that assigns a row number to each record. In later versions of SQL, this can be accomplished using the WITH statement. Unfortunately, this feature did not exist for this version...
    [more]
  • $103.00 USD
    5.0
    Profile image for Seller walliyaw

    walliyaw

    Oct 15, 2013

    Amazing!!! very patient with our company and scope change and very well done.

    Project Description:ONLY FOR Prateekagra implement cflock to only allow capacity limited registration and the rest to go to waiting list so the event registration is not allowing to register more than capacity
    [more]
  • $250.00 USD
    5.0
    Profile image for Seller Five01CIO

    Five01CIO

    Sep 16, 2013

    This was the second opportunity I had to work with Prateek. He definitely has the technical expertise I need when it comes to SQL Server. Thanks for a job well done.

    Project Description:We have a database that is missing about 40 SQL Views that need to be restored and hundreds of columns in various tables whose default values need to be reset. For some reason they came over into a new database with the value of ' ' (with a space), rather than '' (two single quotes with no space)...
    [more]
  • $325.00 USD
    5.0
    Profile image for Seller Five01CIO

    Five01CIO

    Sep 13, 2013

    Prateek showed exceptional and impressive SQL Server skills. He clearly understood the client's needs in this case, which tells me he is a good communicator. I definitely recommend hiring him.

    Project Description:A client of mine has a SQL Server 2008 database with a Case-Sensitive collation. It needs to be converted to a Case-Insensitive collation. The database contains about 800 tables, many of which contain...
    [more]
    Prateekagra has not completed any projects.
  • $111 USD In Progress

    I have a test to do and its the skype knowledge test., Please see attached document for the questions and there are 35 questions and I dont know the answers I need a good skype expert to find the answers and get back to me and I am willing to offer you around $50 - 100 for this.

    [more]
  • $4 USD/hr In Progress

    need a SQL/SSIS expert urgently. C#, ASP.NET / SQL Spatial Queries would be an added advantage.30+ hrs a week.

  • $15 USD 10 days ago

    “The College Management System” is fully computerized information organization, storage and retrieval system that could provide us any information about an Institute just at the click of a mouse. The most fascinating asset about a computerized College fee Manager is that it enables us to explore any institute related information at any time on demand and that too in an absolutely user friendly environment that could be accessed even by a layman very easily OBJECTIVES AND GOALS:To computerize ‘College Management System’ an educational center, the main missions of this software are as under:To provide user-friendly interface to the college administratorTo minimize the typing errors during data entryTo search record of a particular object (course, student, faculty etc.)To update the record of an objectTo generate various reports for managementTo print various reportsTo reduce the typing work by keeping maximum information available on the screenTo reduce the expenditure involving stationery items such as paper, ledgers, fee receipt book etc.To provide consistent, updated and reliable data at any time on demand.To analyze, plan and forecast the inflation or recession graph of the in college in the near future based on the college’s record of revenue sources and expenditure.To provide the most important feature of maintaining the valuable back-up of the critical data.To be bestowed with the latest security facilities provided by the modern computerized DBMS. Above all, the basic objective/mission of this project is to gain experience and confidence for software development, to develop analytical and design skills and to improve upon my technical skills. PROJECT BUILDING BLOCKSThe project consists of following major modules and internal sub-modules:QUERY1)ADD RECORD2)SEARCH RECORD3)VIEW ALL RECORDS4)DELETE RECORD5)EDIT RECORDCOURSES1)ADD COURSE2)SEARCH COURSE3)DELETE COURSE4)EDIT COURSE5)VIEW ALL COURSESFACULTY1)ADD FACULTY 2)SEARCH FACULTY3)DELETE FACULTY4)EDIT FACULTY5)VIEW ALL FACULTYSTUDENT1)ADD STUDENT2)SEARCH STUDENT3)DELETE STUDENT4)EDIT STUDENT5)VIEW ALL STUDENTSADMINISTRATION1)ACCOUNTS2)EXPENDITURE MANAGEMENT3)PROPERTY MANAGEMENT FEE MANAGEMENT1)ADD FEE2)FEE TRANSACTION3)VIEW ALL RECORDSSALARY MANAGEMENT1)TECHNICAL SALARY MANAGEMENT2)NON-TECHNICAL SALARY MANAGEMENT3)VIEW ALL RECORDSDATA REPORTS1)STUDENTS REPORT2)FACULTY REPORT3)COURSES REPORT4)FEE REPORT5)SALARY REPORT6)PROPERTY REPORTSECURITY1)CREATE USER2)LOGIN MANAGER3)CHANGE USERINSTITUTE PROSPECTUS

    [more]
  • $222 USD 10 days ago

    I"m looking for a person who has the knowledge to make a 4-5 table database with Microsoft SQL Server 2012.You will also have to tell me briefly, how it"s done, step by step.What I need to know is how to install the database software, how to create and manage created tables, follow and optimise the database, creating user accounts, etc. I would say it"s pretty much basic stuff, but I still need someone else to do this since I do not have any experience from SQL.We can also make a teamviewer desktop presentation, and you quide me through how to do it. I will give you more details when you contact me.

    [more]
  • $55 USD/hr 14 days ago

    We want to hire someone full time, 8 hours per day as a senior ASP .NET developer. The candidate must satisfy the following requirements:min. of 4 years experience in:Developing systems and applications in the following:ASP. NET 4.0, C#, OOP, WCFSQL server 2008-2012Telerik ControlsSQL server reporting service 2008Crystal reportsVirtual environmentsTeam foundation server 2010-2012offering software solutionssystem integrationHe must have a Bachelor of science in computer scienceand must have and MCTS and MCPD certificates.

    [more]
  • $555 USD 14 days ago

    i have a website which needs updating "Okay, so basically i just want to re-design my existing website with new layout/design/graphics and improving the function work , i will provide a site which where you will see the graphic of that site and layout and making my site same has that , if you read this and i know write when bidding I AM HUMAN so i know you read this and thanksi want new features doing which i will tell you at end ones it is done so basicly , my site is www.stategangsters.com and i want you to use my own function and make the layout index and all graphic work same has http://www.downtown-mafia.com/ and then make everypage of my site same has http://www.downtown-mafia.com/ replicate 100% by updating my function and features

    [more]
  • $666 USD 14 days ago

    1.Online Exam portal very similar to one you can find in http://ultimate.embibe.com2.Questions can be imported from word document to the software. These questions will contain math equations, chemical formulates, images, tables etc. Also these question can be in multiple languages.3.Questions can be categorized in Board, Standard, Medium, Subject, Topic, Difficulty Level and few more various categories.4.Question can be of multiple types e.g. MCQ Single Choice, MCQ with multiple response, fill in the blanks, matching, fill in the blanks, essay ,etc.5.Software will have multiple modes of testing (a) Practice/Learning Mode (b) Mock test6.Each test should have configurable such as Test Name, Marks, Duration, Negative Marking etc.7.Once student appears for online exam, detailed result should be provided for each answer. Each question wise solution can be shown. Please refer to above link as I mentioned.8.Referral system should be there which rewards students for inviting there friends.9.Students can be given various badges based on their performances10.User Management: Bulk user can be imported from excel/CSV and user groups can be defined. Test is assigned to one or more groups.11.There should be option to keep the test paid or free.12.Messaging to student via SMS, Email should be there.I am looking for someone with real experience on such system. Freshers please excuse us.System should be developed with PHP, SQL, Joomla etc.This is only for Serious developers.

    [more]
  • $55 USD/hr 14 days ago

    We want to hire someone full time, 8 hours per day as a senior system analyst. The candidate must satisfy the following requirements:min. of 5 years experience in:anaysising software and systems.analysis of work flow to help in developing software.UMLASP. NET, C, OOP, WCFMicrosoft Visual Studio 2010Building databases using SQL server 2008-2012documentation of systems and softwareAgile MethodologyHe must have a Bachelor of science in computer scienceand must have and MCSD certificate.

    [more]
  • [Sealed] 14 days ago

    Hi there,I am doing online business of website development, software development and data entry stuff since 2-3 years. I am alone at the moment, but have hired thousands of people to work for me and I pay them per project. As my work has been increased and I am wanting a kind of assistant or may be a partner who can work with me on commission basis. You job will be to keep eye on projects, contacting developers, hiring developers, doing discussion with me, etc. I will pay you some percentage on each project. Your percentage will be decided according to your skills, so the less your skills the less you get and the more your skills the more you get.I am not restricting beginners, learners or people not having web development skills to bid on this project, you can bid but as I said percentage will be less then. Anyway I forgot to mention that you should be excellent in English language, if you are not good, please I request to not waste my time.Good luck!

    [more]
  • $555 USD 14 days ago

    1) windows form application with graphics .2) sql server .3) ado.net .4) wpf

  • ₹62500 INR 14 days ago

    We are looking foe a expert to give training for 15 days @ 8 hrs. to freshers on SQL Implementation and Database Administration

  • $1250 USD 14 days ago

    Used technologies: .Net C#, Sql ServerNeeded tools: VS Express, SQL Server ExpressProject:Development of a DLL able to integrate to an external system, which will permit to elaborate financial transactions like:- Sale- Preauthorization/Conclusion- Void Transaction- Refund- Reversal TransactionBoth the DLL I/O and the integration I/O are fully documented, as well as the directives about the coding structure.A test library is supposed to be implemented in order to test the flow of the calls, and a I/O integration log (in text file) must be enabled/disabled through a configuration parameter.the estimated length for such project (based on extended previous experiences) is of 40 working days. Please let me know if you are interested and skilled for this project, and specify the cost per hour or per day, so that i can send you: - a specific economic offer- complete project specifications.Best regards

    [more]
  • £555 GBP 18 days ago

    Background:Customer is a medico-legal company based in the UK. Customer uses a bespoke web based application providing CRM, financial, clinical and messaging components. This application uses Classic ASP, ASP.NET and Microsoft SQL Server 2008.Customer wishes to optomise the database through the use of stored procedures and views.Brief:The coder will be provided with a blank copy of the database and a list of approximately 50 queries which are currently embedded within the database. Some of these contain multiple statements which may be able to be consolidated, others may require the use of cursors.Deliverables:1. A .SQL script containing the appropriate T-SQL to create the procedures/views. Where appropriate this will be accompanied by any appropriate indexes or function to support this.2. A documented list of all stored procedures noting the name of the procedure, the required input parameters and their format and the output data.

    [more]
  • £1111 GBP 18 days ago

    Background:Customer is a medico-legal company based in the UK. Customer uses a bespoke web based application providing CRM, financial, clinical and messaging components. This application uses Classic ASP, ASP.NET and Microsoft SQL Server 2008.Customer wishes to offer a facility whereby medical reports can be written quickly and easily using minimal data.Brief:Using ASP.NET (VB) and SQL Server 2008, the coder will create a database containing a series of questions. This questions will be used to populate a web form. The web form will contain, for example the fields "Client Name", "Client Gender", "Accident Type" and "Accident Date".From these questions a block of text will be generated which would state, for example "Mr Smith informs me that he was involved in a car accident on 1 January 2014.". This would be stored in the database as a template for example "%%CLIENTNAME%% informs me that %%HE/SHE%% was involved in a %%ACCIDENTTYPE%% on %%ACCIDENTDATE%%. The final report must show good grammar; this means that from the selected gender the report must correctly use he/she, his/her, a/an etc.. Database will support multiple templates.Where fields are marked as optional a block of text may be omitted.In total there are approximately 50 questions which may change regularly. The required solution would offer a flexible way of editing the field and the text part associated with the field. Deliverables:ASP.NET (VB) code and .SQL file needed for database creation.

    [more]
  • $12 USD/hr 27 days ago

    We want to modify some open source software to serve our business, we are an voip providers the goal that we are heading to is to make our own billing system that controls many sip switches and to serve wholesales and retail.

    [more]
  • $555 USD 27 days ago

    SCOPE OF WORKThe website will be interactive and will have the following sections:1. Setup, Installation, Maintenance and Other services for the new website:a) Hosting and Upload/Download Servicesb) Domain Name registration with GOV.IN registryc) Uploading and maintenance of content whenever needed2. Tracking & Reporting Servicesa) Maintenance of Emails involving sending automated replies, tracking, reportingand download statistics, etc.b) Search Engine optimization.c) Automated Search Engine submission.3. Monthly e-Newslettera) Designing and mailing out to all registered subscribers.b) Newsletter should be English and Hindi.c) Department will provide major content – however, the consultant may sourceadditional content for the newsletter.4. New Content Development:a) Creative Designs on regular basis.b) Graphic designs on regular basis.c) New pages to be added.d) Uploading of documents (in Hindi/English) released by Dept. from time to time.e) Dedicated resources for Response Management & Data Collection.f) Develop and design various advertisements on home page.5. The website has to be maintained for atleast 2 years (from the date of launch). It willhave to be updated and changed frequently during this period. The intending vendorhas to be in close contact with the Industries Dept. for obtaining and publishing theseupdates as and when they are released. However, ownership of entire websiteincluding its code and data will lie solely with the department.6. The website shall contain links to: Related Government Departments.7. The website should incorporate necessary security features against hacking anddefacement of the same.8. Website should be developed strictly in accordance with the guidelines of Govt of Indiafor government websites, which may be downloaded from http://web.guidelines.gov.in.9. Public Interface:This will include –4 Designing of the website with latest technologies using multimedia features ofsound and animation to make it attractive. The website should possess comprehensive information and should includeseparate sections for –1. Home2. About the Department – Setup, Overview, Mission/Objectives3. What’s New4. Acts & Rules5. Circulars/Notifications6. Notice Board7. Sanction Orders and office orders8. Incentives- Industrial incentives, food processing incentives, AuthorityLetters, Disttrictwise Pending Incentives and others Incentives.9. SIPB Reports with different tab.10. Other Reports (Like PMEGP, EM etc.)11. Food Processing Reports with different tabs.12. Handloom & Sericulture Reports with different tabs.13. Mukhyamantri Samekit Hastkargha Vikas Yojna14. Organisational Chart15. Steps to setup industry in Bihar with flow chart.16. District Industries Centre Profiles17. Reports in Searchable format for MSME, Large Industries in Bihar18. Tenders19. Photo Gallery20. Comments21. News & Events22. Success Stories23. Schemes in e-Book format24. Complaints/Feedback in Blog format25. Forms/Guidelines26. Asset Declaration by Employees (simple hyperlink only)27. Events28. FAQ29. Contact Info – in searchable format30. Videos31. Publications32. Single Window Assistance33. Important Downloads34. Info regarding all Directorates.35. Hyperlink for Useful links and Online Applications.10. The site should also have a Suggestion box. The comments by various visitors shouldbe mailed directly to the officers in the department.

    [more]
  • $3333 USD 27 days ago

    Hi, I require hosting for my server, these are the details :Based in US (east)Linux based4GB RAM4 shared CPU cores100GB SSD storage4TB Transfer40Gbit Network in500 Mbit Network outPlease contact me with offers and I will require an official invoice for this. Price should be based on yearly.Cheers,Desmond

    [more]
  • $666 USD 27 days ago

    Have MSSQL Stored Procedure ("SP") that has been running flawlessly for years on Win Server 2003 and MSSQL 2005. Moved app and database to Win Server 2012R2 64-bit and MSSQL 2008. SP functions to fetch data from database and propagate to Excel spreadsheet. Now have an issue with the SP involving the parameter for the "Path to Excel Spreadsheet" If path is entered as \Share\spreadsheet (e.g. E:\DD\5051.xls) it works fine. However if enteres as \\servername\share\spreadsheet (e.g. \\SUPCTCP\DD\5051.xls) it results in error message and failure. Using the Drive letter limits access to only those users who log on to the server itself. This SP needs to be run by client pcs on the network. There for we need to use the \\servername\ format. I can provide printout of the SP and screen shots of the success and failure. Successful candidate must be familiar with MSSQL and must have good diagnositc skills.

    [more]
  • $155 USD Apr 7, 2014

    This project is to:Load data from a text file into SQL Server as FAST AS POSSIBLECode already exists but it is too slow for our needs. It times out often.The existing code:reads the text file (AGS format) into a datasetuploads tables from dataset into SQL Server - it is this write Tables to Database part which is too slowThe Upload needs to retain referential integrities

    [more]
  • $400 USD Apr 5, 2014

    SQL code changes

  • $277 USD Mar 25, 2014

    Need someone to develop 10 Crystal Reports. Need to start ASAP. Will need 3 reports completed today. Am looking for someone that can be used on a regular basis in the future

  • $1250 USD Mar 20, 2014

    Hello,we are a little start up company from Germany and now we need a website with a database based on SQL Server 2012.We want a tariff comparsion web site. In this website you have to create calculator for current comparison, gas comparison, Internet comparison and mobile comparison.We get our product datas from our partners based on csv or xml document file formats. This datas must go with a api to our server database.Then our customer can search the desired (cheapest) product with our calculator.It could be, that the table has not the same structure and you must maybe perform a changing of the tables, so the PHP-Calculator can work with the database table, because he must search in the database tables. And we don"t know, if that is possible.The Second job is we need a company logo if you able to perforn otherwise we make that in a seperataly order.The Project is divided in two parts:. In the first Part you have create the WebSite with the layout, calculators and 8 subpages: this part should be ready in 4- 6 weeks and the second part is the creating of the database the should be ready in 2-4 weeks. And the last job is the SEO that is really important for us.When the Cooparation was good we are interested in a permanent maintenance job.Best regards Karakus

    [more]
    Prateekagra does not have any open projects.
    Prateekagra does not have any work in progress.
[see more]

Portfolio

[see more]

Résumé

Experience

Database Administrator

Aug 2007 - Jul 2013 (5 years)

My

Hi,<br />I have worked on different technologies i:e .Net ,MS Sql 2000,2005,2008,2012 and having good knowledge of these technologies ,have worked on the set-up the environment of ms sql and configuring the high availabilities features for managing the databases and environment,<br /><br />recently i have develop the website for the online examination which help the school and teacher to give less time and efforts for conducting and checking the exams

Education

MBA

2009-2011

Certifications

MCITP

Publications

Nothign