data warehouse

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 dashboards via Power BI and 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

Greetings, I'm professional database expert with 9+ years experience. Currently I'm working as DBA and DB developer in one of the leader company. As you can see in my profile, I have deep experience of same jobs like database administration and development by remotely. I'm top expert. -- Best regards, Davit Dartsimelia Senior Database Administrator & Developer

I am an expert in delivering custom scripts and softwares willing to discuss further details about the project

Hello, The data warehouse project is of interest to me. Please, I would like you to award me this job. I have More than 10 years experience with dataBase and Data WareHouse. I'm familiar with sas data integration Studio, Pentaho, ORACLE, sqlServer and so others. As soon as the contract will be signed, I'll deliver the result within 1 week (including test periode), for a negotiatable total amount of $150 (including freelancer.com fees), payable at project success. Post Service: during first 3 months, I'll be available to assist you for free, about any issue concerning the solution. I'm available for an interview and hope you'll award me this project. I'm waiting to hearing from you soon. Best Regards, Balouki ADEWI

I have worked in various Datawarehousing projects. Have worked with Informatica ETL tool. Looking forward to work with u.

Hello My name is Pranav I have checked the details shared by you and will be done exactly as per your requirement please consider my bid so i can assist you in better way thank you My Portfolio https://www.freelancer.com/u/amitarai.html

 Having 3+years of total IT experience in customizing and Production environment and enhanced functionality on Oracle Technologies like SQL, PL/SQL and Stored Procedures, Packages on oracle Data base as backend.  Extensive experience in SQL, PL/SQL programming concepts.  Extensively worked on SQL Concepts like Views, Joins, Sub Queries and Indexes.  Extensively worked on SQL related utilities such as TOAD, SQL*Plus, SQL*Loader.  Having Good Knowledge on creating and debugging the Packages, Procedures, Functions and Triggers.  Analyzing of SQL statements using EXPLAIN PLAN to improve the performance.  Hands on experience with Collections like Nested Tables, v-arrays and Index by Table.  Extensively worked for resolving the Observations, Bugs and issues received from Business.  Having good knowledge on UNIX commands.  Worked with Oracle Supplied Packages like UTL_FILES.  Having good knowledge on Informatica power center 8.6 client concepts.  Having good knowledge on using transformations and data mapping.

HI I'M WORKING WITH ORALCE, PL/SQL ,PERFORMANCE TUNNING ABOUT 8 YEARS IN A BIG COMPANY. COULD YOU SEND MORE DETAILS?

Hi, I have 10+ years in Data Warehouse and Data Integration in different domains like Finance, Telecom. Thanks & Regards, Team@UNS Technologies

A proposal has not yet been provided

I have 8 years of work experience working in a reputed MNC as a Database Lead, main skill set is Sql Server 2005/2008/2012, MYSQL Oracle (PL/SQL), MSBI, Data analytics using R-Programming and SAAS. I would be able to deliver your solution within the timeline with better quality

i m now working on poste italiane tableau datawarehouse (back end side) going to be plsql-sql certified expert

Project Manager – Microsoft Certified Trainer – IT Instructor – MBA, PMP, MCP, MOS, TOT IT Management Professional with 14 years of experience encapsulate all strands of the industry, most recently focusing on using important elements of computerized Project Management, comprise of process analysis, streamlining, operational efficiency, right through to implementation, and throughout providing leadership, guidance and governance to all teams involved. Microsoft Certified Trainer in MS Office & MS Project Software with Microsoft Certified Professional (MCP) certificate in MS Project Server. Have excellent technical skills in the latest software and development tools, capable of working under pressure and meeting all deadlines, ability to work effectively independently and/or with other staff members, strong time management and organizational skills.

Having more than 8 years of experience in the DW industry, I would be able to provide you the required solution using Informatica Power Center 9 . I can also provide you the reports over the Crystal Reports 2008. The database would be Oracle. If you have any specific needs please let me know I have industry experts with me and will be able to deliver the project with 100% accuracy and in the stipulated amount of time.