Find Jobs
Hire Freelancers

MS SQL Expert Required to build SQL reports

$30-250 AUD

Closed
Posted almost 8 years ago

$30-250 AUD

Paid on delivery
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
Project ID: 10860363

About the project

55 proposals
Remote project
Active 8 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
55 freelancers are bidding on average $221 AUD for this job
User Avatar
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 in 5 days
4.9 (502 reviews)
8.3
8.3
User Avatar
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 in 5 days
4.8 (42 reviews)
6.0
6.0
User Avatar
Having 10 + years experience in SQL and willing to start the work immediately .
$277 AUD in 3 days
4.6 (214 reviews)
6.2
6.2
User Avatar
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 in 10 days
4.8 (43 reviews)
6.2
6.2
User Avatar
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 in 7 days
5.0 (11 reviews)
5.5
5.5
User Avatar
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 in 6 days
5.0 (17 reviews)
5.7
5.7
User Avatar
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 in 1 day
5.0 (68 reviews)
5.7
5.7
User Avatar
A proposal has not yet been provided
$250 AUD in 1 day
5.0 (31 reviews)
5.3
5.3
User Avatar
154 let me see the csv first .
$1,000 AUD in 10 days
5.0 (14 reviews)
4.7
4.7
User Avatar
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 in 7 days
5.0 (13 reviews)
4.4
4.4
User Avatar
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 in 3 days
5.0 (12 reviews)
4.4
4.4
User Avatar
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 in 15 days
5.0 (6 reviews)
4.5
4.5
User Avatar
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 in 0 day
5.0 (22 reviews)
4.1
4.1
User Avatar
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 in 1 day
5.0 (3 reviews)
4.2
4.2
User Avatar
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 in 3 days
5.0 (7 reviews)
4.2
4.2
User Avatar
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 in 5 days
5.0 (8 reviews)
3.5
3.5
User Avatar
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 in 3 days
4.4 (4 reviews)
4.2
4.2
User Avatar
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 in 7 days
4.5 (7 reviews)
3.4
3.4
User Avatar
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 in 3 days
4.6 (2 reviews)
2.9
2.9
User Avatar
Greetings, I can assist you with the required task. Just let me know when can we start the job. Pd: 154 Regards,
$45 AUD in 3 days
5.0 (1 review)
2.0
2.0

About the client

Flag of AUSTRALIA
Sefton, Australia
5.0
76
Payment method verified
Member since May 24, 2015

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) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
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.