Find Jobs
Hire Freelancers

Custom SQL reports from MS Lync 2013

£750-1500 GBP

Closed
Posted over 9 years ago

£750-1500 GBP

Paid on delivery
We are IT services company in the UK of about 30 people. We have been using Lync for 4 years and have been looking for ways to improve 1. historical visibility of our call handling statistics 2. real-time visibility of our response groups to manage call load We have looked at various commercial packages for this and have found that some have good reporting, some have good real-time supervision, but neither have both, all are very expensive and none have enough flexibility for what we need. We have looked at the built-in call reporting within Lync (all based on SQL queries) and this is somewhere near what we need for the historical reporting but it is not quite right. We have a lot of database development experience in house, and we can code our own 3rd party db application to directly see all the SQL data behind Lync. The problem we have is that it is a very steep learning curve to get to grips with how Lync organises the relevant data in SQL and this is something we would prefer not to have to do from scratch. We are therefore looking for a SQL admin with plenty of exposure to Lync 2013 that can help us put together the relevant SQL queries to find out, say, how many abandoned calls we had to a certain hunt group in a given 30 day period, or what the average time for a call to a response group is, or the average time on hold for a given response group. Likewise, we would like to be able to see how many calls are currently holding for a given response group, what the maximum wait time is, etc. Once we have these queries working, we can do all the data reporting and presentation in our own db application. We would be happy to contract with either a company or a freelancer. If you think you can help, please get in touch.
Project ID: 6372910

About the project

14 proposals
Remote project
Active 10 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
14 freelancers are bidding on average £1,228 GBP for this job
User Avatar
A proposal has not yet been provided
£1,445 GBP in 25 days
5.0 (20 reviews)
4.9
4.9
User Avatar
Dear Sir, This is Sikander. I am having 12+ years of experience in software development and I am ready to start this job. I will provide you best services in development. Please have a look at my Profile, Ratings and feedback. I am working in Microsoft technologies and you can find the details below. My Skills includes: 1) .Net (Web/Windows) asp.net 2) MVC 3) Entity Framework 4) WPF/WinForms 5) MSSQL Server 6) SQL Server Reporting Services 7) Javascript/JQuery 8) WebServices/WCF Services 9) MySQL 10) Hosting Sites 11) Mailchimp 12) Recently Worked on Vending Machine solution with Monetary apparatus and Shipping Goods motor also worked on Kisok applicaiton. many more...... I have no fancy talks, no false promises and nothing to hide but honesty and a great will to expand our work experience. I am willing to expand my work experience to different clients and in this order I apply for this job in the hope to hear some positive response from you. I hope you will take us positively and will give us a chance to work with you. Many Thanks & Regards Sikander
£1,416 GBP in 20 days
5.0 (9 reviews)
4.6
4.6
User Avatar
Hi, I have gone through your requirements.I am a Database programmer at CMMI-5 Level company since August 2010.I am working on MySql,SQL,Oracle database, I can do your job confidently. I am very much Interested to do your work,Please revert me if you have any concern .I am ready to start now.
£1,475 GBP in 25 days
4.5 (12 reviews)
4.4
4.4
User Avatar
Hi, I have 10+ years of experience of developing reports from databases like SQL Server, Oracle and MS-Access. Additionally, i have been using C#, VB.net and ASP.net for development for the last 8 years. Can you please confirm if you want to develop a winform or web application ? Moreover, you can please suggest how many different reports you require. I look forward to hearing from you. Regards, Farooq
£1,444 GBP in 20 days
5.0 (13 reviews)
4.3
4.3
User Avatar
hi i have a sound knowledge of the sql and also have knowledge about the lync 2013 . i can help you to get the require details with the queries and make all your requirement to get it possible let me know when we can have the discussion further to proceed
£1,250 GBP in 20 days
4.8 (7 reviews)
4.2
4.2
User Avatar
Do you have a list of reports you want ? Also If I develop reports in SSRS with Custom parameters so that end user can run those realtime with different parameters will that work ?
£1,250 GBP in 20 days
5.0 (5 reviews)
4.0
4.0
User Avatar
Hi. I am msql server expert and have great xp in development ssrs reports. Regards, Yury .
£1,250 GBP in 3 days
5.0 (17 reviews)
3.7
3.7
User Avatar
A proposal has not yet been provided
£888 GBP in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have a good knowledge in Reports and i am working from 4 years as a report developer. I handled 5 projects reports.
£1,111 GBP in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am writing in response to the opening of the project, I just did something very similar during the past six months, the context was, a customer has a transaction application developed in Java Enterprise that connect to PostgreSQL database, and he needed an alternative mechanism for access information, the solution was, configured a separate server with Pentaho Business Analyst Server and its own PostgreSQL database instance, the database was backed up on the primary server and restored on the secondary server through a script. I installed the secondary server, the Pentaho Business Analyst Server and the PostgreSQL secondary database instance early in the project. I was developing reports and graphs with Pentaho Report Designer, and publishing those reports to Pentaho Business Analyst Server. Some reports were very simple and other very complex, for example one complex report has 3,599 SQL LOCs. You can see images of this reports and graphs in the portfolio of my profile. I am not have experience with MS Lync 2013, however I can analyze the database structure of MS Lync 2013 very quickly and begin to develop those SQL queries, the only two things that I need from you are the reports and graphs sketch and detailed information about that do you need to be displayed. I would welcome the chance to speak with you sometime.
£890 GBP in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
£1,111 GBP in 20 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of SWITZERLAND
Switzerland
0.0
0
Member since Aug 26, 2014

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.