SELECT distinct
[MISTERCHEFNET].[dbo].[Lojas].[Nome Loja] as 'Loja'
,c.[Código Vendedor] as 'Código Entregador'
,a.[Nome Funcionário] as 'Entregador'
,c.[Data Caixa]
,c.[Data/Hora Vencimento]
,(c.[Tempo Total Entrega] - c.[Tempo Preparo]) as 'Tempo Entrega'
,c.[Tempo Preparo]
,c.[Tempo Total Entrega]
,((select sum(p.[Valor])
FROM [MISTERCHEFNET].[dbo].[Contas a Pagar] p
where a.[Nome Funcionário] = p.[Credor] and DATEDIFF(MONTH, p.[Data Vencimento], c.[Data Caixa]) = 1) + ((select count(x.[Nome Funcionário])
from [MISTERCHEFNET].[dbo].[Comissões] z
full outer join [MISTERCHEFNET].[dbo].[Funcionários] x on
x.[Código Funcionário] = z.[Código Vendedor]
and x.[Loja]=[login to view URL]
where DATEDIFF(MONTH, z.[Data Caixa], c.[Data Caixa]) = 0 and [login to view URL] = [login to view URL] and z.Repique=0 and z.[Código Vendedor] not like 0 and x.[Nome Funcionário] = a.[Nome Funcionário])*3)) / (select count(x.[Nome Funcionário])
from [MISTERCHEFNET].[dbo].[Comissões] z
full outer join [MISTERCHEFNET].[dbo].[Funcionários] x on
x.[Código Funcionário] = z.[Código Vendedor]
and x.[Loja]=[login to view URL]
where DATEDIFF(MONTH, z.[Data Caixa], c.[Data Caixa]) = 0 and [login to view URL] = [login to view URL] and z.Repique=0 and z.[Código Vendedor] not like 0 and x.[Nome Funcionário] = a.[Nome Funcionário]) as 'custo'
,[MISTERCHEFNET].[dbo].[Clientes].[Código Cliente]
,[MISTERCHEFNET].[dbo].[Clientes].[Nome Cliente]
,[MISTERCHEFNET].[dbo].[Clientes].[Endereço]
,[MISTERCHEFNET].[dbo].[Clientes].[Bairro]
FROM [MISTERCHEFNET].[dbo].[Comissões] c
full outer join [MISTERCHEFNET].[dbo].[Funcionários] a on
a.[Código Funcionário] = c.[Código Vendedor]
and a.[Loja]=[login to view URL]
full outer join [MISTERCHEFNET].[dbo].[Clientes] on
c.[Código Cliente] = [MISTERCHEFNET].[dbo].[Clientes].[Código Cliente]
and [MISTERCHEFNET].[dbo].[Clientes].Loja = c.[Loja]
left join [MISTERCHEFNET].[dbo].[Lojas] on
[MISTERCHEFNET].[dbo].[Lojas].[Código Loja] = [login to view URL]
where c.[Data Caixa] >= '2016-01-01' and c.Loja=2 and [login to view URL] = 0 and c.[Código Vendedor] not like 0
order by c.[Data/Hora Vencimento] desc;
Hello,
I have been working with a MNC based company since last ~ 5 years, as an IT BI DWH Professional.
The project is a BI DWH project which covers 3 layers of BI (ETL, Data warehouse & Reporting) and helped me in nourishing my talent in all the technologies around these 3 layers.
Below are some key areas of my skills:
• Expert in SQL Server, Oracle and MS Access Databases
• Expert in BO XI, Cognos and SQL Server Reporting Service (SSRS)
• Expert in & designing & Implementation of end to end ETL Process using Informatica & SSIS Tools
• Expert in Designing Qlikview Dashboard BI Solution
• Expert in ER & Dimension Data modeling
• Complete Command on PL/SQL concept e.g. Procedures, Functions, packages and complex queries.
• Basic knowledge of Unix Shell scripting
• Web Development using Java, CSS, and HTML ,PHP & Java Script
• Expert in excel Macro
• Expert in C & C ++ Programming
I have experience in all the above areas and during my project work I have completed all of the above tasks.
As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. I had conducted Informatica & DWH training for a US based training organization from Nov’14 to Dec’14.
We recently started our own company “Point5Nyble Your Needs, Our Dream”.
We always work to provide Best Delivery with 100 % customer satisfaction
Would be looking forward to work on this opportunity and will ensure to deliver best.
Regards,
Ashish-Point5Nyble
Let's start! I understand what you need and you will have a 100% complete job on time.
I can assure you that if you work with me once, you will always work with me for these kind of projects.