Find Jobs
Hire Freelancers

MS SQL Expert Required to build SQL reports

$30-250 AUD

Fechado
Publicado há quase 8 anos

$30-250 AUD

Pago na entrega
I have a system that generate a csv report daily. I need someone that can create a MS SQL scheduled job to import the data, generate the reports similar to the images attached and email them to an email address (preferably in one report). Some content from the attached images have been redacted for privacy issues, but a real a csv will be available for the successful candidate. If you have any questions please include them in your proposal so I can get to you first. Ensure you start your response with the number 154
ID do Projeto: 10860363

Sobre o projeto

55 propostas
Projeto remoto
Ativo há 8 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
55 freelancers estão ofertando em média $221 AUD for esse trabalho
Avatar do Usuário
154 Hi there We have a lot of experience in creating MSSQL reports and letting it run as triggers. We are quite interested in working on your project. Thanks Rinsad
$263 AUD em 5 dias
4,9 (502 avaliações)
8,3
8,3
Avatar do Usuário
154, Hello, I have read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I am having 7+ years of experience in Web Development. I have worked on below technologies/languages/database server. - Asp.net,C#.net, MVC - Linq to SQL,Entity Framework - Jquery,AngularJS - Crystal Reports,DevExpress Reports - SQL server,SSIS Package,SSRS Reports - Web API 2, WCF WebService - Application Security Remediation,Penetration Testing - SVN,TFS I love working on SQL and query/sp optimization . I can achieve the results that you are asking for. We can discuss further on chat(Skype:mahajan344). Looking forward from your end. Thanks
$222 AUD em 5 dias
4,8 (42 avaliações)
6,0
6,0
Avatar do Usuário
Having 10 + years experience in SQL and willing to start the work immediately .
$277 AUD em 3 dias
4,6 (214 avaliações)
6,2
6,2
Avatar do Usuário
154 Hi, This will be achieved by designing a C# automate that will be scheduled in windows scheduler. This automate will read csv file and import data in database. Once data imported, it will generate these reports and send them to specified recipients. I have 9 years experience in C#, ASP.NET/ MVC with Jquery/Ajax and for services using WCF/Rest WCF/Rest Web API and SQL Server for back-end. I have delivered highly successful projects in ASP.NET, C#/VB.NET Win-Forms, EF with complex logic in SQL Server Stored Procedures. Thanks
$277 AUD em 10 dias
4,8 (43 avaliações)
6,2
6,2
Avatar do Usuário
I am VB, VB.NET, MVC, XML & MS SQL programmer. I have experience about 10 years in programming complex database application as well as Windows Desktop and Server/Client application. you will get yearly service and support as well as update of this software to avail new version from me. I am professional to provide corporate custom complex software which is not available in the recent market. So you may turn your desired application dream in real. Long term support.
$250 AUD em 7 dias
5,0 (11 avaliações)
5,5
5,5
Avatar do Usuário
Hi, We are experienced programmer with more than 5 years of development experience here. We have handled production applications with various technologies like .NET, PHP, Classic ASP and many more using databases like MySQL, Microsoft SQL, Oracle, MS Access and etc. We are also developing mobile apps in Native technologies for iOS, Android and Windows platform. Mentioned below are a few USPs for choosing me: 1. Well written codes with proper documentation 2. Highest possible code optimization 3. Quick support through email / skype / telephone 4. Daily / Weekly status reporting Let's discuss and make this project a success. Thanks & Regards, JayamSoft
$333 AUD em 6 dias
5,0 (17 avaliações)
5,7
5,7
Avatar do Usuário
154 Dear Sir, I'm very much familiar with MS SQL Server ( SSIS SSAS SSRS) and also during last nine years I involved many project in ETL, data warehousing, BI reporting and six years of application development experience. I would highly appreciate if you assign this job to me and also I'm Microsoft Certified Technology Specialist (MCTS) for Microsoft SQL Server 2008 for Business Intelligence Development and Maintenance & Microsoft Office SharePoint Server Application Development. Please reply me for further details Best Regards, Jinesh
$35 AUD em 1 dia
5,0 (68 avaliações)
5,7
5,7
Avatar do Usuário
A proposal has not yet been provided
$250 AUD em 1 dia
5,0 (31 avaliações)
5,3
5,3
Avatar do Usuário
154 let me see the csv first .
$1.000 AUD em 10 dias
5,0 (14 avaliações)
4,7
4,7
Avatar do Usuário
Hi, I am an experienced java proffessional expert in core java j2ee spring mvc hibernate orm webservices. I can do this. Pls contact for further progress.
$250 AUD em 7 dias
5,0 (13 avaliações)
4,4
4,4
Avatar do Usuário
154 Hi - ok, so let me see if I understand your requirements correctly. Are you saying that you want to create a scheduled job that imports data from CSV files into MS SQL Server and then generates a report as per the templates provided and emails them? Should this be a SSRS report? Thanks, Hatim
$250 AUD em 3 dias
5,0 (12 avaliações)
4,4
4,4
Avatar do Usuário
Hello , Thank you for posting this opportunity. I read you requirement and I understood it. Hope chat soon for more further details. I am professional website designer/developer. I have 7 years of experience in this field and can provide you my past sample work. I will be serving you with all my hard work and skills. My expertise are: - PHP, MySQL, WordPress, CodeIgniter, E-commerce (Open cart, Magento, shopify), Yii, AJAX, JavaScript, JQuery, OOPS, HTML, DHTML, HTML5, .net, MVC, c#, ASP, Crystal Report, Designing (Bootstrap/Responsive) My skills and enthusiasm as follows:- •Knowledge and experience with front-end web technologies such as HTML/XHTML, CSS, XML, JSP and JavaScript with Ajax, JSON, jQuery, CodeIgniter, WordPress and Joomla. • Knowledge of .Net, MVC, c#, ASP, Crystal Report. •Advanced knowledge of back-end web technologies such as classic ASP, OOP PHP, Apache, mod_rewrite, WordPress, Drupal, SQL, MySQL and relational database concepts. •Knowledge of modern business applications such as Dreamweaver CS5, Photoshop CS5, Bootstrap and custom responsive website designing. I highly value professionalism and hold myself strictly accountable to represent my client's brand. I believe that, with my skills, experience and attitudes, I can bring a lot to you. Hope chat with you soon. Thank you for your time and consideration. - Zub
$315 AUD em 15 dias
5,0 (6 avaliações)
4,5
4,5
Avatar do Usuário
154 Please let me know when will we start. Queries: Screenshot 1 and Screenshot 3 are CSV files. Correct? Screenshot 6 has 3 reports and Screenshot 7 has 2 reports. Right? You need these reports in one SSRS report. Correct? Create report from latest imported data or older one also. Please confirm. Tasks: 1) Import data from CSV to MS SQL DB. 2) Scheduled the job for the above task. 3) Generate Report from those imported data. 4) Send an email with attachment. 5) Above task also scheduled.
$45 AUD em 0 dia
5,0 (22 avaliações)
4,1
4,1
Avatar do Usuário
Greetings, I'm professional database expert with 8+ years experience. Currently I'm working as DBA and DB developer in one of the leader company. As you can see in my profile, I have deep experience of same jobs like database administration and development by remotely. I'm top expert. -- Best regards, Davit Dartsimelia Senior Database Administrator & Developer
$250 AUD em 1 dia
5,0 (3 avaliações)
4,2
4,2
Avatar do Usuário
154 Good day, I have the necessary skills in MS SQL Server to be able to assist with your application. I have great design skills and the technical know-how to ensure that your project will be delivered within time and budget. Your solution will definitely work as a SQL Job in SQL Server but a more secure efficient solution will be to develop a windows service that will perform these tasks: 1. Import data from CSV 2. Create a report as defined (can be MS RDLC report/PDF) . 3. Email the report. The benefits will be that the processing will taken off SQL Server, no emailing needs to be done from SQL (unless you have this configured already) and it can be scheduled to run at specific intervals. Please contact me to discuss you requirements further. Regards, Shayalin
$200 AUD em 3 dias
5,0 (7 avaliações)
4,2
4,2
Avatar do Usuário
Hi, In my current Professional Microsoft Senior SQL Server DBA role, I have extensive experience with SQL Server versions 2000-2016. I have immense experience working in SQL Server Development on a daily basis for a Multi Billion dollar company. Specifically related to your project, I have created an automated process to extract CSVs from FTP sites, load CSV files into SQL Server, apply updates to the data, and then load the data into BI Databases for Reporting. I perform the following Sr. DBA & Developer duties on a daily basis in high traffic Production OLTP environments: - Database Design and Modeling per Best Practices - SQL Server Development (Complex Queries, Stored Procedures, Dynamic SQL, Functions, Parameterized Queries, etc.) - Analytical Development of KPIs and Dashboards utilizing MS DATAZEN - SQL Server Replication Configuration - Microsoft EXCEL development, reporting, and data extractions - Business Intelligence Development utilizing the MSBI Stack (SSIS, SSRS, SSAS) - Implementing/maintaining Database security Please review my Profile, in which you can observe my 5 star ratings, outstanding reviews, and a 100% completion rate as well! I can assure you that if you work with me once, you will always work with me for these kind of projects; I will do whatever it takes to completely 100% deliver on this project and earn a 5 star rating from you as well. Kind Regards, Joshua Burns
$200 AUD em 5 dias
5,0 (8 avaliações)
3,5
3,5
Avatar do Usuário
154 First of all let me introduce myself. I am Archil, a veteran software developer working with .NET and SQL for over a decade. I can import CSV file to SQL Server, generate a report and send as a mail using any technologies you want. My advice is to make SSIS task importing and sending as a mail. Regards Archil
$350 AUD em 3 dias
4,4 (4 avaliações)
4,2
4,2
Avatar do Usuário
154. I am working as an software developer in a MNC. I have worked upon graph libraries like d3, plotly etc. Can help you with your task.
$166 AUD em 7 dias
4,5 (7 avaliações)
3,4
3,4
Avatar do Usuário
Hi I am looking forward to work with your proposal. I am having 5.6 years of experience in the Software Development. Currently I am working with world class MNC. I would like to discuss in detail if you find my proposal suitable for your project.
$155 AUD em 3 dias
4,6 (2 avaliações)
2,9
2,9
Avatar do Usuário
Greetings, I can assist you with the required task. Just let me know when can we start the job. Pd: 154 Regards,
$45 AUD em 3 dias
5,0 (1 avaliação)
2,0
2,0

Sobre o cliente

Bandeira do(a) AUSTRALIA
Sefton, Australia
5,0
76
Método de pagamento verificado
Membro desde mai. 24, 2015

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos Publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.