Database Management

Hello, I have been working with a MNC bases company since last ~ 4 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 on 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 I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. Delivering best & Customer satisfaction is the key for any individual and I always work keeping these things in mind during project execution. Apart from above also successfully completed Database & Informatica Training for a US based Training Organization. Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Ashish Seth

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

1. 3 year of extensive experience in Database(modelling, creation) 2. Rich experience in writing complex SQL queries to create tables, views etc. 3. Extensive experience in writing PL-SQL queries for procedures, functions etc. 4. Completion of task on or before time. 5. No compromise policy with quality of work. 6. High preference for customer satisfaction.

Hi I am a professional database developer. I am very good in oracle and sql server. I have solid foundation in SQL. Please let us discuss details in PM thanks in advance

Hi, I am a masters degree holder in the field of web and cloud computing and I have done several similar school projects here on freelancer. You can check them via my port folio. This seems like a database design questionnaire about normalisation. Do not fret as I can get this done within a maximum of three hours. I am available for screening via team viewer or Skype and I prefer team viewer. Looking forward to work with you. Cheers, Saminda

"Rate and duration will be fixed on discussion" Dear Hiring Manager, I have gone through your job posting and become very much interested to work with you. I am an expert in these fields. I have already completed several projects like this. For evidence you can see my profile. I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. -- Kinds Regards, Mehedi Hasan.

Question 1: The product ID, product description, price are multiple values in a single row. Quesstion 2: Primary Keys: OrderID and Product ID, e.g.: Order ID Order Date Customer ID Customer Name Product ID Product Desc. Product Price Quantity Ordered 1006 10/24/10 2 Value Furniture 7 Dining Table 800.00 2 1006 10/24/10 2 Value Furniture 5 Writers Desk 325.00 2 1006 10/24/10 2 Value Furniture 4 Entertain Center 650.00 1 1007 10/25/10 6 Furniture Gallery 11 4 Drawer Dresser 500.00 4 1007 10/25/10 6 Furniture Gallery 4 Entertain Center 650.00 3 Question 3: Product desc and price are dependent on Product ID which is a part of the table's candidate key Question 4: 1) Order table, primary keys Order ID and Product ID, foreign key Product ID Order ID Order Date Customer ID Customer Name Product ID* Quantity Ordered 1006 10/24/10 2 Value Furniture 7 2 1006 10/24/10 2 Value Furniture 5 2 1006 10/24/10 2 Value Furniture 4 1 1007 10/25/10 6 Furniture Gallery 11 4 1007 10/25/10 6 Furniture Gallery 4 3 2) Product table, primary key Product ID Product ID Product Desc. Product Price 7 Dining Table 800.00 5 Writers Desk 325.00 4 Entertain Center 650.00 11 4 Drawer Dresser 500.00 Question 5: a. Customer name depends on Customer ID, not a prime attribute b. Customer info and order date are repetitive Question 6: Tables: Order {PK order ID, FK Customer ID, others: order date} Customer {PK Customer ID} Order Item (PK Order ID Product ID, FK Product ID, others: units ordered} Product-same above