Find Jobs
Hire Freelancers

MS SQL Expert Required to build SQL reports

$30-250 AUD

Cerrado
Publicado hace casi 8 años

$30-250 AUD

Pagado a la 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 del proyecto: 10860363

Información sobre el proyecto

55 propuestas
Proyecto remoto
Activo hace 8 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
55 freelancers están ofertando un promedio de $221 AUD por este trabajo
Avatar del usuario
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 en 5 días
4,9 (502 comentarios)
8,3
8,3
Avatar del usuario
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 en 5 días
4,8 (42 comentarios)
6,0
6,0
Avatar del usuario
Having 10 + years experience in SQL and willing to start the work immediately .
$277 AUD en 3 días
4,6 (214 comentarios)
6,2
6,2
Avatar del usuario
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 en 10 días
4,8 (43 comentarios)
6,2
6,2
Avatar del usuario
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 en 7 días
5,0 (11 comentarios)
5,5
5,5
Avatar del usuario
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 en 6 días
5,0 (17 comentarios)
5,7
5,7
Avatar del usuario
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 en 1 día
5,0 (68 comentarios)
5,7
5,7
Avatar del usuario
A proposal has not yet been provided
$250 AUD en 1 día
5,0 (31 comentarios)
5,3
5,3
Avatar del usuario
154 let me see the csv first .
$1.000 AUD en 10 días
5,0 (14 comentarios)
4,7
4,7
Avatar del usuario
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 en 7 días
5,0 (13 comentarios)
4,4
4,4
Avatar del usuario
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 en 3 días
5,0 (12 comentarios)
4,4
4,4
Avatar del usuario
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 en 15 días
5,0 (6 comentarios)
4,5
4,5
Avatar del usuario
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 en 0 día
5,0 (22 comentarios)
4,1
4,1
Avatar del usuario
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 en 1 día
5,0 (3 comentarios)
4,2
4,2
Avatar del usuario
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 en 3 días
5,0 (7 comentarios)
4,2
4,2
Avatar del usuario
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 en 5 días
5,0 (8 comentarios)
3,5
3,5
Avatar del usuario
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 en 3 días
4,4 (4 comentarios)
4,2
4,2
Avatar del usuario
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 en 7 días
4,5 (7 comentarios)
3,4
3,4
Avatar del usuario
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 en 3 días
4,6 (2 comentarios)
2,9
2,9
Avatar del usuario
Greetings, I can assist you with the required task. Just let me know when can we start the job. Pd: 154 Regards,
$45 AUD en 3 días
5,0 (1 comentario)
2,0
2,0

Sobre este cliente

Bandera de AUSTRALIA
Sefton, Australia
5,0
76
Forma de pago verificada
Miembro desde may 24, 2015

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos 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)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.