Last seen: Jul 26, 2014 4:58 PM EDT
Hire Me!
Rate: $10.00 USD/hour
Follow Invite to Project
Browse Similar Freelancers:


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



(7 reviews)

[see more]

1 user has recommended this freelancer.

My projects:

  • $135.00 USD
    Profile image for Seller 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.
  • $75.00 USD
    Profile image for Seller 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...
  • [Sealed]
    Profile image for Seller 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...
  • $75.00 USD
    Profile image for Seller 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...
  • $103.00 USD
    Profile image for Seller 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
  • $250.00 USD
    Profile image for Seller 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)...
  • $325.00 USD
    Profile image for Seller 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...
    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.

  • $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.

  • R17500 ZAR 2 days ago

    THe project has previous completed versions. We want to update.

  • $222 USD 2 days ago

    I have raw data from our IT system in flat file format, would like to create statement using crystal report.

  • $25 USD 2 days ago

    need a little fix on my server something is wrong but don"t have time to fix.

  • $8333 USD 2 days ago

    Time and attendance software is to maintain the employees time and attendance in an organization. Important Features: 1. Complex Shift management like - Breakshift, Night shift etc.. 2. Groupwise Weekends & Holidays assignment 3. Reports 4. Door controller management (Biometric or Card system controllers) - Uploading/downloading users or Sync, Downloading Attendance data The software will gather the attendance data from multiple biometric/card system time and attendance machine. We will be providing you SDK.The software should have all the details of the organization, departments and employees.**Note: ** 1. We will give more priority to those who have executed same type of app before 2. We are based in bangalore India 3. If required or whenever required we are open to developer execute project in our premises, we are ready to provide all facilities here in our office First verion - Desktop application Second Version - Web version using ASP.Net ## Deliverables1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer"s environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer"s environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder"s Seller Legal Agreement). * * *This broadcast message was sent to all bidders on Friday Jul 27, 2007 2:01:30 AM: Hi All, Please read my Bid & if you already have background on Time and attendance software then please reply me urgently. Thanks Bharath ## Platform Micrsoft .Net 2.0 framework & language - prefered Database: MSDE or SQL server Coding guidelines: No SQL Query in .Net sourcecode & everything executed on database thru Stored procedures

  • ₹27777 INR 2 days ago

    Web based enterprise application development of Hotel Management System (Using ASP.NET 2.0, VB, Sql Server.

  • $4444 USD 2 days ago

    Looking to build a complex multi-user login website with auto emailing and texting using email templates, automated ecommerce mixed with sql database data queries, inventory management system, and highly secure with credit card storage and PII. Prefer html and sql based with asp scripts.

  • $15 USD 2 days ago

    This project is to develop a report form using Microsoft SQL Server Reporting Services (SSRS) 2012. •The report form shall have the identical layout as shown in the attached Blank Report.pdf file, which is designed for the A4 size page setup. •The report shall be developed using Microsoft SQL Server Reporting Services (SSRS) 2012. •The goal of this project is only to do the report layout. The report will not have any datasets or parameters to populate the data in the report. The datasets and parameters will be added later as part of a different project.•The report designer shall deliver a .RDL file that will load in Microsoft SSRS 2012 without any changes.•The report form shall use design requirements shown in the attached Blank Report with Requirement.pdf file. •The final output of this project shall include one .RDL file and one sample print out of the report form in the PDF file format.

  • $555 USD 6 days ago

    I need an online store designed and coded. CMS to be discussed.

  • $155 USD 6 days ago

    This project will only be awarded to a freelancer who has read and understood all of the requirements.We have a SQL database running on a windows server 2012.We need little program to set it self u as a system service and export some sql fields into a pre defined xml structure.What has to be done:1. User interface for settings1.1 Lets us choose what fields are interesting to us1.2 Lets us choose at what time we want the script to run2. Select data with necessary joins2.1 There are only 2 tabes that are of any interest to us at this point and they only have to be joined by ID or by a third reference table (not decided yet)3. Create the xml file with all the data in it"s place.3.1 Only the data that was selectod to be written will be but into the xmlIdeally the set up program (GUI) has to be run only once and then there already is a system service that will start up with the server and run at the predetermined times.To clarify you"ve read the whole description write "XYZ" in your proposal.Thank you for reading.

  • $15 USD 27 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

  • $222 USD 27 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.

  • $55 USD/hr Jun 28, 2014

    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.

  • $555 USD Jun 28, 2014

    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 and i want you to use my own function and make the layout index and all graphic work same has and then make everypage of my site same has replicate 100% by updating my function and features

  • $55 USD/hr Jun 28, 2014

    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.

  • [Sealed] Jun 27, 2014

    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!

  • $555 USD Jun 27, 2014

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

  • ₹62500 INR Jun 27, 2014

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

  • $1250 USD Jun 27, 2014

    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

  • £555 GBP Jun 23, 2014

    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.

  • £1111 GBP Jun 23, 2014

    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.

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


[see more]



Database Administrator

Aug 2007 - Jul 2013 (5 years)


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