offline
Last seen: Jul 22, 2014 2:34 PM 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.

  • $555 USD Yesterday

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

  • $2500 USD Yesterday

    Our company has been developing a business class web application for the last 2 years and we need an additional developer to complete most of the remaining tasks. The application is using the Codeigniter framework and a decent amount of Jquery. The code is shared on a repository at Github. Your tasks will include the following:- Work with existing code to implement additional features, per our instruction- Develop a training module- Develop an HR module- Any other tasks that are neededI know the scope of work is very vague, but we are looking for a dedicated developer who can work on this project FULL-TIME through completion. If that is not the case, then please do not apply.

    [more]
  • $155 USD Yesterday

    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.

    [more]
  • $15 USD 22 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 22 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 25 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 25 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]
  • $55 USD/hr 25 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] 26 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 26 days ago

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

  • ₹62500 INR 26 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 26 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 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.

    [more]
  • £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.

    [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]
  • $666 USD Mar 5, 2014

    SituationI am developing an online database that allows the following 192 reports to be displayed and maintained via a web interface. In addition to faithfully recreating the contents of the reports, the database will provide a mechanism for authorised users to propose changes to individual entries and will allow for the generation of reports. https://www.un.org/en/sc/1540/docs/matrices/Afghanistan%20revised%20matrix.pdfTask1) To select a database engine that is compatible with my siteground web hosting account. 2) To faithfully recreate the template for country reports (with the additional columns shown in the attached)3) To add additional functionality, including: - ability for authorised users to propose modifications to specific entries- ability for administrator to add new questions or countries- ability for all users to generate reports as described below4) To populate the database with the information contained in the existing reports5) To demonstrate the solution operating via my siteground accountAdded functionality: In addition to faithfully recreating the existing reports, and important part of this project is the additional functionality sought through the use of an online database. This includes the following requirements:a) To provide a mechanism for authorised users to propose changes to entries via either a page that shows one question for all countries or that shows all questions for one country. After such proposed changes are made, a mechanism should exist where these proposed changes can be shared with an external authorising group before being accepted or rejected or deferred. Where an administer assesses the change as "accepted" or "deferred", an additional column should appear on the country report showing what change was proposed. b) To allow scores to be set for each question, such as "mandated" and "optional". It should be possible to generate a report that for each country states how many "optional" and "mandated" entries exist in each category as a percentage of the total number of questions. (This report should be sortable either alphabetically or by value)c) To enable export of country reports as PDFsResultThe database, which will be hosted on a siteground account, will allow any user to view the status of 1540 implementation in each country and thematically. It will also allow authorised users to propose modifications to the entries.

    [more]
  • $555 USD Feb 8, 2014

    Hi there,I got a platform and admin where you can create a sales page with payment options. And after a payment automatically an invoice is sent. In the admin all the settings can be done.Now I want to add a registration form to this system and I also want to intergrate paypal. I also to implement a new admin design, but this is not in a hurry, so maybe this will be out of the scope of this project. Next I also want some changes in existing platform. For example: the e-mail messages that user will received should be altered. I also want to intergrate a form so that the platform can work together with existing autoresponders. I also got a example of websites who are already using this.If you are suited for this job please send me the following word in capital letter, lean , at the beginning of your message.only respond if:- you are really good in communicating English - you can have skype webcam chat so that I can see you- you can build all the above in one weekLet me know if you are ready to build!

    [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