Find Jobs
Hire Freelancers

Write some Software

min €36 EUR / hour

Fechado
Publicado há mais de 8 anos

min €36 EUR / hour

Re-design Analysis Services Cube to partition large dimension. Need to have skills in MS SQL Server, SSIS, SSAS, BI Architecture
ID do Projeto: 9612834

Sobre o projeto

22 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
22 freelancers estão ofertando em média €38 EUR/hora for esse trabalho
Avatar do Usuário
Have designed SSAS cubes with partitions and other complex features. One example client: a large telco in India.
€37 EUR em 30 dias
5,0 (6 avaliações)
6,5
6,5
Avatar do Usuário
Hi I have been working with MSSQL for over 16 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
€36 EUR em 10 dias
4,9 (65 avaliações)
6,0
6,0
Avatar do Usuário
Hi, I have been working as Database Analyst Programmer more than 10 years. I became OCP, CCNP, RHCE 3 years back. Earlier I completed B.Sc. Enng and M.Sc. Engg both in computer engineering. Check my works here https://www.freelancer.com/projects/Software-Architecture-Engineering/Entity-Relationship-Diagram-ERD.html https://www.freelancer.com/projects/PHP-HTML.1/Database-Project.html https://www.freelancer.com/projects/database-administration/Database-Coursework.html I'm assuring you that you will score more than 90% I'm looking forward to hearing from you very soon
€40 EUR em 3 dias
4,6 (49 avaliações)
5,7
5,7
Avatar do Usuário
Hi, my name is Ron Bowes, and I live in Philadelphia PA USA. I have been a developer for over 20 years. I currently work with 4 developers, and 3 graphic designers in the US. I also work with several college students in the US on a part time base. I am more than confident with my team we can more than meet, and even exceed your expectations. If you have any questions, please feel free to contact me Thank you Ron Bowes
€37 EUR em 40 dias
5,0 (5 avaliações)
5,1
5,1
Avatar do Usuário
Hi, I am 12+ years experienced Visual Basic,ASP.NET, VB.NET,MVC, C#,Bootsrap,Telerik control,Crystal report,WCF,JSON,SharePoint,MySQL,SQL,MSSQL Server(2005 to On wards) developer at CMMI-5 level company.I can do your work confidently. I am very much Interested to do your work,Please revert me if you have any concern.
€40 EUR em 30 dias
4,1 (20 avaliações)
5,5
5,5
Avatar do Usuário
I'm a very experienced and active BI developer with 6+ years of experience, especialized on Microsoft tools, but also working with Oracle and Sybase databases. Also experienced working with Hadoop and Hive, migrating a traditional DW to Big Data project to improve the performance of the processing, based on Azure tools and HDInsight.
€38 EUR em 8 dias
5,0 (1 avaliação)
4,3
4,3
Avatar do Usuário
Hello, I (and my small team comprising 2 other individuals) have over 8 years of SSIS, SSAS, SSRS and BI experience. We have in the past partitioned cubes containing large volumes of telecommunications data so as to speed up performance - basically we partitioned it to hold yearly data. But we will need to look at your data structure to determine the best possible optimisation for your needs. Looking forward to hearing from you. Thank you, Hatim
€36 EUR em 3 dias
5,0 (10 avaliações)
4,0
4,0
Avatar do Usuário
I am interested. .
€36 EUR em 20 dias
4,9 (16 avaliações)
3,9
3,9
Avatar do Usuário
Hi there - My name is Bogdan. I’ve read your brief and can see that you’d like to build an interesting sysytem. My team has 6 years experience designing and developing websites and mobile apps for iPhone and Android and also desktop apps. I would approach your project by starting with wireframes and getting the design completed, before starting the actual development phase. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, take a look at my Freelancer Portfolio.
€36 EUR em 30 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
A proposal has not yet been provided
€40 EUR em 5 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
With the specific requierements and details of data structure of the data sources and destination, I will give the exact amount of time I will get done the solution.
€40 EUR em 3 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
I have been working as senior Microsoft BI Developer with one of the top IT Consulting company with industry standard skill set and experience as below : Expertise in Data warehouse modelling with very sound fundamental concepts of DWH. Extensive hands on practice in SSIS package creations using all features of SSIS services to build a highly scalable ETL process. Expertise in writing effective T-SQL Code/Triggers/Views/Stored Procedures/ Functions/Query optimization and tuning/Indexing using SQL Server 2008 & 2012. Practical working experience on Microsoft SQL Server Parallel Data Warehouse (PDW) and data warehousing concepts. Very Good experience in developing dashboards for senior leadership using SSRS, PowerView & PowerPivot for developing Tabular/Matrix/Chart reports. Have good knowledge in SSAS cubes and tabular model which can be used as source to various reports for super fast retrieval. I would be an ideal match for the skill set that you are looking for. I have written highly optimized and efficient queries for huge data tables with more than 5 TB in size and having more than 2 billion records. And prepared various SSIS packages / Stored procs for creating ETL processes. SSAS tabular model which was built on this was of 1 TB size in approax which was loaded every 30 minutes by our ETL process. I would love to talk to you about how I can be of great help to you. Thank you very much -- look forward to your positive respon
€36 EUR em 20 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
I am a certified MSBI & database expert currently working in the role of BI Architect cum developer with 12+ yrs of experience using SSAS, SSIS, SSRS, SQL Server and various BI tools. I am sure will be able to complete your project as per requirement, timely and within budget as I have worked on lot of cube optimization projects which involves - cube partitioning, - dimension optimization - Aggregation design - etc I am using these in my current project: SQL Server 2012, SSAS, SSIS, SSRS, excel, MDX (complex), XMLA, .net (c# only), scripting SSIS using c#. Please feel free to contact me. We can finalize on the billing rate as per convenience. Thanks Nitini
€40 EUR em 3 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
5+ years of work experience in MSBI. Very good experience in SSAS cube development and also on SSRS reports based on cube (using MDX).Worked with cube partitioning MOLAP storage mode.
€40 EUR em 3 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
I have a lot off experience on BI Microsoft. i commit my projects on deadline setted. Also i'm hard worker.
€40 EUR em 3 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Hi, I am having 9 years of exp in SSIS ,SQL and SSAS. Please let me know if you are interested to work with me
€36 EUR em 3 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
I have 9+ years of IT experience in various ETL technologies like SSIS,SSRS,SSAS,Informatica as well as in MS SQL Server, C#
€40 EUR em 3 dias
0,0 (0 avaliações)
0,0
0,0

Sobre o cliente

Bandeira do(a) LUXEMBOURG
Sandweiler, Luxembourg
5,0
1
Método de pagamento verificado
Membro desde fev. 10, 2016

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.