Data Warehouse Design

Hi, I am 12+ years experienced Database Developer at CMMI-5 level company. I am working on : RDBMS: MS Access,Oracle,MySQL,MSSQL Server 7.0/2000/2008R2 and Onwards. Data Base Tools : Database Configuration Assistant, Database Migration Assistant, OEM, SQL/Oracle Trace, EXP/IMP, SQL*Loader, RMAN, DataPump, AWR, ADDM, Asmcmd, Asmca, Tkprof I Can do your work easily. Let me know when we can discuss.

Hello! There are several solutions for your problem: 1. You might use an Excel's PowerPivot feature to process your data. In case of proper design it may handle of your data in RAM of a single workstation (yes, all of your 10x15GB data may fit into 8-16G RAM of a workstation because of columnar storage). 2. You might deploy SQL Server data warehousing infrastructure, perform data integration using ETL, and use SQL Server's analysis instance to query your data. In either case data processing will be very fast. Please contact me for further discussion. Andrey.

Hi. I am database/datawarehouse developer. I've been working in the field for 5 years. I have experience in many dw technologies. I can analyze your database and queries and give you my solutions and apply changes. If you like my offer, feel free to contact me. Thanks

Hi, I am DB developer with DB design/DB tuing/DWH/BI experience. I propose to work with you to make your DWH reports/queries faster. Kindly provide more details on DWH like purpose/DB/table structure/reports/queries etc. Based on above details, let us agree on work in 4 milestones and plan payments as per milestones. Regards Sankar

6 years of IT experience in BI & Big Data DWH Solutions for Banking , Oil & Gas domain. • Extensively worked in Data Warehousing and Business Intelligence using SAP BODS, SAP HANA, Informatica as ETL tools. • Using Apache Hadoop along with other Apache suites like Hive/HBase for Datawarehouse /Database concepts for Product Development and Product Architecture Design. • Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes,Fact and Dimension tables using star schema for successful creation of Data Warehouse and Data Marts. • Responsible for Extraction, Cleansing, Transformation and Loading of data from multiple feeds and sources into Data Warehouse • Building Information Views ,Stored Procedures, Triggers, Materialized Views, Cursors, Partitioning, Exception handling, Optimization tuning on SAP HANA. • Proficient in developing Business Objects reports with custom and free hand SQL queries. • Using Scrum , Agile Methodologies and tools GitHub AgileFant . • Jira, Dimensions, VSS, IBM Clear Case for Version Control. • Excellent analytical and programming skills(Java / Python /C++) with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals along with excellent communication skills. • Expertise in Software Development by applying SDLC practices

Professional Database Specialist, will deliver efficient results in short time. I just need to have a look on the actual definition of the tables and the already associated indexes. Also, an estimation of the numer of records for each table would be good to know, together with the frequency of the data changes. If you already have the queries, I can analyze and provide a feedback and, eventually, optimizing hints. A short sample consisting in 10-15 rows of data for each table would be useful in order to recreate a similar context and test. Also, The hardware you are using is also important to be known. Have a nice day, Alin Bejenaru

Thu, 12 Mar 2015 09:46:59 +0000 operating system and MySQL version? Please upload schema and query samples. Connect to database may be required. Any attempts at correction? Please advise on other errors.

My experience working to develop data analytic KPIs for the game-analytic data of 100+gb while working at a leading gaming company makes me an ideal candidate for the job.

A proposal has not yet been provided

I work as a DBA, so i am well versed in tuning the databases.I can help you in tuning the queries.I can also provide you documentation for future reference..

Hi! I'm willing to help you and i'll try to solve your problems. I've over 4 years of expirience in databases, in particular DWH. My skills in MySQL: 1. Asynchronous MySQL -> MySQL replication 2. Performing improvement and queries optimisations 3. Developed ETL workflow from MySQL -> different databases

The following Milestones will help manage the project. Further we can discuss once contacted. Regards, Digbijoy

Please give the table structures. List if sql and run time. We do optimization and create indexes. Will do re design and populate the data( if required)Your sql will fly.

Previous experience in similar type of engagement and successful deliveries make me an ideal candidate for the same.

Hi! My name is Chetan and I'm a Spark and Cassandra DBMS developer. After going through your project's description, I believe that I can help you. However, I would like to know if you're looking for a data warehouse on which you can perform queries to search through data or weather the data needs to be updated frequently as well. MySQL is not a very good DBMS for massive datasets. I can review your current queries, the architecture and model of your current database system and even redesign one for you if needed. I have quoted a generic price since the information I had was limited. The price is negotiable and the payment can be made once the job is done and you're satisfied with the work.

A proposal has not yet been provided

I am an experienced SQL developer and had a wealth of knowledge in DataWarehouse design and architecture. Have worked in data warehouse projects for huge banks like Barclays.

Hi, This is what I do for my living as a DW/BI consultant in NZ. The 15 days will need to start once access is obtained to your system. Alternatively, a comprehensive subset of population data will need to be provided as well as the schema of the DB. Business involvement may be required to interpret the DB structures to logic. Do you have the original requirements / design assumptions from the DW development? Regards Mike Jakowetz

I have a lot of experience Parsing, Structuring and Optimizing large Database files within various types of Databases. I have been doing this for the past 30 years. Please feel free to contact me to discuss how the project could/will be undertaken. Kind regards, Arthur

La propuesta todavía no ha sido proveída