Find Jobs
Hire Freelancers

Write some Software

min €36 EUR / hour

Cerrado
Publicado hace alrededor de 8 años

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 del proyecto: 9612834

Información sobre el proyecto

22 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
22 freelancers están ofertando un promedio de €38 EUR /hora por este trabajo
Avatar del usuario
Have designed SSAS cubes with partitions and other complex features. One example client: a large telco in India.
€37 EUR en 30 días
5,0 (6 comentarios)
6,5
6,5
Avatar del usuario
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 en 10 días
4,9 (65 comentarios)
6,0
6,0
Avatar del usuario
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 en 3 días
4,6 (49 comentarios)
5,7
5,7
Avatar del usuario
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 en 40 días
5,0 (5 comentarios)
5,1
5,1
Avatar del usuario
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 en 30 días
4,1 (20 comentarios)
5,5
5,5
Avatar del usuario
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 en 8 días
5,0 (1 comentario)
4,3
4,3
Avatar del usuario
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 en 3 días
5,0 (10 comentarios)
4,0
4,0
Avatar del usuario
I am interested. .
€36 EUR en 20 días
4,9 (16 comentarios)
3,9
3,9
Avatar del usuario
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 en 30 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
€40 EUR en 5 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 20 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I have a lot off experience on BI Microsoft. i commit my projects on deadline setted. Also i'm hard worker.
€40 EUR en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de LUXEMBOURG
Sandweiler, Luxembourg
5,0
1
Forma de pago verificada
Miembro desde feb 10, 2016

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.