Create 80 SQL Queries out of a ERP for Compiling Data to a KPI System

Hi I have been working with MSSQL for over 17 years. I am fully experienced as a developer and a DBA. Currently I am working at big financial organization in which I am responsible for the BI department. I have designed and the Developed the Organization’s Reporting Database which has been constructed with SQL Server 2008 R2 Enterprise Edition. The database is being updated daily from the core system with txt or excel files via SSIS or with direct connection at mainframe’s DB2 and a numerous of KPIS are being daily updated during the ETL. For isolation reasons the KPIS are replicated to another DB (with transactional replication) which exploits the reports via SSRS to the consumers. Some KPIS are being replicated with merged (bidirectional) replication. Also, 10 Cubes in SSAS are being daily automatically processed and the end of the ETL. Several other reports are daily automatically produced and sent via email to the recipients. Finally I have designed and developed the bank’s crm DB which is published on the intranet. The DB holds full information about the customers (Customers,Addresses , Financial Data , Contacts , campaigns , etc) and covers 4 countries. To achieve this i have made partitions over the country code. The size of the Reporting DB, is about 4TB and consists of about 4.000 objects and the replicated KPI DB is 350GB. Best Regards mpalgeo

Hi I am a database expert with 12 years experience in handling MS SQL databases. I have worked as DBA for large ERP databases and use to write and do performance tuning for SQL queries, procedures and triggers. With my domain expertise in the ERP, when ever I have a business requirement, I can easily look into a database, identify the required tables and write the required query for that. I can connect on team viewer or on a RDC and work on your server, thats how I normally work on remote SQL databases. I have placed a rough estimate, I can give you a better bid after getting more requirements, or can work on an hourly basis. Look forward to hear from you. Thanks Roni

We have EXPERTISE in writing SQL Queries for various purpose. We have been doing Database Driven software development for the past 15 years. We need briefing about your requirements to understand and talk sensible in the proper direction. Thank You Bhavesh Jain

Hello Sir, Greeting for the day, Hope you are doing well We are Group of professional having more than 8 years’ experience in Windows/Linux Server administration , Website Hosting migration, Mail server configuration management ,CISCO Router Switches, Firewall Cloud computing), We provide support for small and medium companies to build their successful online businesses utilizing different platforms like Microsoft (Asp.net, SQL Server, C#, VB.net), LAMP, CMS like DNN, CATALLOK, Magneto, Word Press. We provide solutions focused web professional with comprehensive background orchestrating the design and development of cutting-edge web sites and user experiences that strategically leverage and maximize online presence. Please initiate chat to discuss your requirement in details. Thanks karun

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

Hi! I'm senior lecturer on databases and I've 10+ years experience in MS SQL Server. I can create SQL queries and other backend if you need. Please chat me for details.

A proposal has not yet been provided

Hello I am able to implement the queries in fast and efficient manner and provide support after the task will be finished. Please refer to my previous tasks on this site. All the best Alexei

Hello, I am interested in your project. I am a software engineer and I have professional experience with SQL. Could you please send me more details about your project? Thank you, Best regards, David

Can you please provide more details about this project? We could not fully understand the work required.

Hi, Will you be providing a sample database or a test database to connect to to write those queries? Also do you know what KPI to be extracted from the ERP system? What is your expected completion date? Awaiting your response.

Hi I can develop 80 SQL queries in 2 weeks (this is a maximum) I will take 2500 BRL for this. If you pay same amount I can develop reports either in SSRS or Tableau or Crystal Reports. I can provide demos for both queries and reports if you want. As for me, I am a veteran software developer working for over a decade. You can find more about me looking into my profile. Please do not hesitate to contact me. Thanks Archil

Hello There, I can help you with this, available to work immediately on this requirement. Please let me know if you are ok to start working with me. Thanks, Kalyani

A proposal has not yet been provided

I have done exact project similar to website doctorondemand, memd which make patient & doctor to have online video call. Above project I have done in .net(MVC, WEB API, AngularJS, C#, MSSQL 2000-2016) so I will be using above technologies. 1] Effectively architect and deliver the docviaweb 2] Development member of bookmyshow 3] Effectively architect and deliver the myrefers I have 13+ exp in software Development in Microsoft Technolgies (MVC, WEB API, AngularJS, WCF, LINQ, ENTITY FRAMEWORK, JAVACRIPT, JQUERY, C#, MSSQL 2000-2016, VB 6.0, CRYSTAL REPORT, HTML5, CSS). I am a Microsoft Certified Professional. Proficiency in the entire lifecycle for software development, right from onsite & offsite plans, requirement analysis, prototype development, deployments & maintenance of multi-site applications. Projects done with different technologies is as below : 1]MVC 2]ANGULARJS 3]WEB API 4]WEB SERVICES 5]SILVERLIGHT 6]WPF, WWF, WCF 7]Facebook API 8]Web API 9]XAMARIN 10]MSSQL SERVER 2000-2016

I have professional experience in Business intelligence and certified as a SQL expert from ORACLE. I have completed around 19 projects so far and working for an analytics firm. I can provide you the best optimized SQL with different Key performing metrics at various grain of data.

I have been a database expert for 5 years at intel with experience in sql server and other datasources

Do you have and ERD or Data dictionary to assist in the mapping of tables. Will the chosen freelancer have access to the ERP's database to test the queries. I work on a daily with Informix, Sybase, MSSQL and AS400 for my job so building these queries should not be to difficult once i have what was requested above.

Hi, Saw your project regarding the SQL queries in ERP and I am willing to work on the same. I have 5 years 4 months of experience in the SQL and data analysis of the Multinational organizations' ERP. I have handled there databases and debugged them too. I will give you optimized queries for your ERP. Thanks and Regards

I have 15+ years of programming experience in SQL Server. Upgraded systems from Access, FoxPRO, ORACLE and other databases. I can create a SQL Script or Stored Procedure to complete your process. Hope this will be a test so we can create a future working relationship for your projects. Thanks, Iosif