Find Jobs
Hire Freelancers

Write some Software

min €36 EUR / hour

Closed
Posted about 8 years ago

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
Project ID: 9612834

About the project

22 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
22 freelancers are bidding on average €38 EUR/hour for this job
User Avatar
Have designed SSAS cubes with partitions and other complex features. One example client: a large telco in India.
€37 EUR in 30 days
5.0 (6 reviews)
6.5
6.5
User Avatar
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 in 10 days
4.9 (65 reviews)
6.0
6.0
User Avatar
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 in 3 days
4.6 (49 reviews)
5.7
5.7
User Avatar
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 in 40 days
5.0 (5 reviews)
5.1
5.1
User Avatar
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 in 30 days
4.1 (20 reviews)
5.5
5.5
User Avatar
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 in 8 days
5.0 (1 review)
4.3
4.3
User Avatar
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 in 3 days
5.0 (10 reviews)
4.0
4.0
User Avatar
I am interested. .
€36 EUR in 20 days
4.9 (16 reviews)
3.9
3.9
User Avatar
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 in 30 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
€40 EUR in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have a lot off experience on BI Microsoft. i commit my projects on deadline setted. Also i'm hard worker.
€40 EUR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of LUXEMBOURG
Sandweiler, Luxembourg
5.0
1
Payment method verified
Member since Feb 10, 2016

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)
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.