Need to create (build) Data warehouse from OLTP databases SSIS SSRS and SSAS

Hello.. I am working as DBA with one of US Financial Institutions. My Job included maintenance and enhancements of existing system which includes huge databases, data warehouse, SSIS packages and SSRS. We use to extract all data from different databases to DW_ODS. This is done by daily maintenance jobs via SSIS packages and then transform there and finally move it to DW. From DW, we have a reporting services to extract various reports. In short the full ETL cycle is automated to push data from source database to DW. I think you also need similar system. Currently I have 20 hours per week bandwidth available and is ready to work with you at 18¬ hourly rate. My hourly rate is high but in Long term I will be cost effective to you as I have very good speed then others. Most importantly this job requires a guy to understand the full system first and then think about architecture to create for ETL. And I am best for this as I already have strong analytics skills and good grasping power. Thanks

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

Dear Sir, This is Sikander. I am having 14+ years of experience in software development and I am ready to start this job. I will provide you best services in development. Please have a look at my Profile, Ratings and feedback. I am working in Microsoft technologies and you can find the details below. My Skills includes: 1) .Net (Web/Windows) asp.net 2) MVC 3) Entity Framework 4) WPF/WinForms 5) MSSQL Server 6) SQL Server Reporting Services 7) Javascript/JQuery 8) WebServices/WCF Services 9) MySQL 10) Hosting Sites 11) Mailchimp 12) AngularJS 13) Recently Worked on Vending Machine solution with Monetary apparatus and Shipping Goods motor also worked on Kisok applicaiton. many more...... I have no fancy talks, no false promises and nothing to hide but honesty and a great will to expand our work experience. I am willing to expand my work experience to different clients and in this order I apply for this job in the hope to hear some positive response from you. I hope you will take us positively and will give us a chance to work with you. Many Thanks & Regards Sikander

Hello, I have been working with a MNC based company since last ~ 5 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 • 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 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. 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 Ashish Seth

Do you have any Business requirement design prepared for this project ? A BRD would help a lot . I have 8 + years of experiece on SSIS , SSAS and SSRS with experience in maintaining and designing databases of sizes from 2 Gb to 1.6 TB

I am interested. can we start work now? .

SQL Server DBA/MSBI Developer with 5+ years of experience. I have expertise in creating ssis packages, ssrs reports and sql server performance tuning. Project Requirement: Create ssis package for ETL Processes for loading data into database. Create SSRS Reports based on the business requirement Details Required: Share access via teamviewer or Remote Desktop I can create ssis package on target machine based on the business rules you provide. I have created several ssrs reports for my clients. Looking forward to work with you. Please check my profile (5 star rated) Regards, Chetan Palrecha

I am an Expert Digital Analytics consultant having extensive experience in Web Analytics and campaing analytics, Business Intelligence Initial Project scope understanding Creating Business Intelligence Applications and Dashboard using QlikView and SQL Server BI My Expertise 12+ IT Experience End to End experience in web development, web analytics to Business intelligence 5+ Experience in Web Development (PHP, ASP.Net, SQL) 5+ Experience in Business Intelligence (MS SQL BI, Qlikview, Xcelcius etc) 8+ Experience in Web Analytics & Campaign Analytics 5+ Experience in Google Analytics, Omniture Project Plan 1. Requirement Understanding 2. Design DW database (Star/snowflake) 2. Design SSIS ETL 3. Build DW & ETL 4. QA 5. UAT & Approval Let's discuss with detailed requirement

Hi, I have worked on projects involving end to end implementation of BI. ( Insurance domain) As long as product goes I have sound understanding of MSBi and SAP BI tools. Let me know if I can help. Thanks, Dilkush

HI, I WOULD LIKE TO ASSIST AS I DO HAVE GOOD KNOWLEDGE OF DW DESIGN PRINCIPALS. PLEASE FEEL FREE TO APPROACH ME FOR FURTHER ASSISTANCE. KIND REGARDS,ENRICO

I have more than 11 years of industrial experiance in data integration,data architect and data base development for OLTP systems and large data warehouse projects.

Hello. I have I have experience in creating such systems, please see my portfolio. I also worked with SSRS-reports (remote and local).

Dear Sir, I have 10+ years of experience as Oracle DBA and I have worked on many Oracle Database installations and set-up, data warehousing, shell scripting, Automation, ETL projects etc. I can write a nice shell/perl/php/python script to extract and load the data from your PostgreSQL. Regards, DH

I am a microsoft certified professional and I have more than 5 years of experience in complex data warehousing and business intelligence projects of fortune 500 companies using sql server and MSBI stack.

I have more than 9 years of IT experience in Data Warehousing and Business Intelligence Systems using ETL/OLAP tools. Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS). Thorough knowledge of Ralph Kimball's Data Modeling concepts including data modeling, data marts, dimensional modeling, star and snowflake schema, fact aggregation and dimension tables, slowly changing dimensions and surrogate keys. Professional experience working with Banking, Retail and IT consulting firms most of which are CMM level 5 and ISO 9000 certified. Skilled in defining and implementing the various components of a data warehouse such as Operational source systems, Data staging, Data presentation and Data access layers. Participated in Full lifecycle development of large Data Warehouse systems. Proficient in different performance tuning approaches for both ETL and Databases. Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports. Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.

A proposal has not yet been provided

Hi, As i am new freelancer i would like to work with on no expectations in order to get reputation in the field. we are 4 members team having an extensive knowledge on BI Stack and Talend, You decide the payment based on the work we delivered on timelines. That's all i can say about us. Thanks and Regards, Darur Ashok

Not been provided

As we understand project is about developing ETL packages and create reports using SSRS We are Technology Consulting company offering spectrum of IT solutions & services. We provide expert Software development services spanning a range of Microsoft technologies like C#, VB. NET, SQL server, ETL, SSRS etc . Presently we are supporting our clients in USA, Middle East, Africa and India. The team has delivered products on Microsoft technologies with extensive reporting using SSRS. We look forward to work with you on this requirement and any upcoming requirements you may have. We are looking for a long term relationship as a technology partner. We are reachable at Mob: +91 9833056016 skype: sathe_mukund

Hi ,I have worked on Data Migration using Various ETL tools such as ABINITIO ,Informatica,Sybase ETL so i can work on the project and deliver within given Timelines.