Looking for expert to design Data Repository (Data warehouse)

Hello, I have been working with a MNC based company since last ~ 6 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 which I have gained during execution of project work 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, Point5Nyble

Hi I have been working with MSSQL for over 17 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

I got 11+ years experience in datawarehouse technologies. I worked as designer, architect, DBA and developer.

Hello there, We are a team of DWH experts who have rich industry experince & would be happy to work on the project. We have recently developed a customised DWH for one of our customers using concepts like star schema,index nested loop joins etc. The samples can be shared if required. Some of our other key areas include: Designing DB schemas for large applications in various business domains like finance,health,energy etc. Troubleshoots long-running reports. Performance bottlenecks. Data inaccuracies. In-efficient workflows & data inconsistencies in applications/reports. Expertise with ERP data, indexes, keys, views & relationships in an ERP database (1000+ tables). Our hard earned 5-star rating & great client reviews would help to gain confidence in our team,you can be sure of getting the best solution withn time & budget. Please let me know the best time to discuss the project requirements in detail so that we can take it further. Thanks for reading the proposal. Best Regards NK

Hello, I can help you in designing the data warehouse repository. I am into data warehousing field since 5 years. I can help you with the following: Staging design LDM Design Semantic layer design Visualization in Tableau/OBIEE/BO/Cognos if required. You can view my profile if you have any doubts on my expertise. Thanks! Regards, Tahir Badar

Experience in Data Warehouse and Data Design and Database Developer. ETL tools we can used to load the data into Data Warehouse Informatica Developer

I have worked on 6 data warehouse projects with complete dimensional modelling.

I have 6 years of experience in datawarehouse with multinational companies, so I can do the more efficiently