Kapalı

Data Warehouse

Requirements

• Collect the data from the core and distributed branches.

• Collect business requirement documents from business site.

• Collect system requirement for data warehouse.

Analysis

• Document current process and solution workflows for both current and proposed state for existing and future reporting requirements.

• Document detailed security requirements for accessing data.

• Document the infrastructure requirements, hardware and software.

• Document user requirements for ad-hoc reporting and analysis.

• Analyze the source data and transactional data.

• Make sure all source data is available and can be collected.

Design

• Select database system.

• Select server and its operating system.

• Design conceptual and solution architecture to support the data warehouse.

• Design technical specifications for the staging area, data warehouse, metadata, data mart base on the requirements.

• Design logical and physical data models, schema and data structure.

• Analyze performance of system and database server tuning.

• Analyze frequency of data loading.

• Establish interfaces to source systems and data transfer.

• Build up data mart from diverse sources and is designed to support query and analysis.

Development & Implementation

• Develop extraction, transformation and loading data from the source data.

• Analyze and determine missing data.

• Create physical structure of staging area, data warehouse and data marts.

• Perform data loads of new mappings into new structure.

• Analyze new data structure to ensure all necessary levels of reporting, analysis and business requirements are met.

• Establish data mapping, programs, scripts to perform ETL work of new data contents, formats, and descriptions.

• Analyze data loading at various intervals to ensure appropriate loading.

• Design and develop require reports.

Testing

• Develop test cases, test plan and test execution timeline.

• Design test scenarios for business requirements.

• Establish unit testing, functional testing, and UAT testing environment.

Production

• Transition to end users and generate the required business reports.

• Analyze and validate the reports.

• Projection on reports and support decision making.

Beceriler: CRM, Veri Madenciliği, Veri Depolama

Daha fazlasını görün: test scenarios, systems analysis and design, software test scenarios, requirement specifications document, projection design, process data structure, new data structure, mapping document, implementation of data structure, ensure data security, design warehouse , data warehouse process, data warehouse design, data structure solution, data structure implementation, data structure design, data mining process, database design for crm, data analysis reports, c data structure programs, c data structure, c and data structure, business plan formats, ad hoc testing, test execution

İşveren Hakkında:
( 0 değerlendirme ) Myanmar

Proje NO: #6554839

29 freelancer bu iş için ortalamada 5493$ teklif veriyor

qitsol

A proposal has not yet been provided

in 30 gün içinde5263$ USD
(29 Değerlendirme)
5.7
Maestros

Hi There, We are an ISO 9001:2008 certified company with strength of 50+ software professionals. We have a legacy of 10 years of excellence behind us and we were recently among the very few companies selected by Bri Daha fazlası

in 60 gün içinde5555$ USD
(1 Değerlendirme)
4.4
ashishseth1988

Hello, I am working with a MNC based company in a DWH project since last 4 years. This project is pure DWH project which comprised of DWH concept,Informatica as ETL tool and Business Object & Qlikview as report Daha fazlası

in 30 gün içinde5555$ USD
(3 Değerlendirme)
2.5
smartguy666

Hi sir, i am interested in your project. We can do this for sure.I have a team of developers, we can start your project right away. You will be completely satisfied with our work and speed. I can assure you quality wor Daha fazlası

in 30 gün içinde5000$ USD
(1 Değerlendirme)
2.4
swarm22

I am a data scientist/quantitative developer with over 5 years of experience doing analysis. My interest and expertise in using MS Access,R , Matlab ,weka and Database Development.

in 30 gün içinde5555$ USD
(3 Değerlendirme)
2.4
GenesisTec

Hello, We have gone through your project description and we can help you out. We are having a team of expert professionals which can cater you with desired solution. With more than a decade of experience in IT, we ca Daha fazlası

in 30 gün içinde5555$ USD
(1 Değerlendirme)
0.0
winqsys

A proposal has not yet been provided

in 30 gün içinde5555$ USD
(0 Değerlendirme)
0.0
qualifiedcoders

Hi, We have read your requirements and would like to discuss further as we have strong hands in web, desktop & mobile application development & have extensive experience in data warehousing and completed over 150 pr Daha fazlası

in 35 gün içinde5263$ USD
(0 Değerlendirme)
0.0
umesh2360

A proposal has not yet been provided

in 30 gün içinde5000$ USD
(0 Değerlendirme)
0.0
sirkeyur

A proposal has not yet been provided

in 30 gün içinde5000$ USD
(0 Değerlendirme)
0.0
fixfin

Hi We are quite confident that we can accomplish the project as per your requirement. You are requested to go through our Profile to know our domain knowledge and our Services. We read your requirement and you sh Daha fazlası

in 30 gün içinde5147$ USD
(0 Değerlendirme)
0.0
dnts

I have a team in US who are very specialized in data warehousing project and My team also has offshore counter parts for round a clock operations. We are startup organization, however our team's collective experienc Daha fazlası

in 30 gün içinde5000$ USD
(0 Değerlendirme)
0.0
pujasinha

I have 4 years of experience in ETL development projects wherein I worked on Oracle, SQL server, DB2, unix. I have experience in end to end design of the overall architecture, development from the scratch, deployment Daha fazlası

in 30 gün içinde5555$ USD
(0 Değerlendirme)
0.0
rajgrv

I am working as a Senior Software Engineer expertise DWH and BI practices like Informatica with sound knowledge of SQL, total experience of 4 years. I would like to know more about requirement, on which delivery time Daha fazlası

in 30 gün içinde6111$ USD
(0 Değerlendirme)
0.0
jomaoliva

Hello Good Day, I have high experience in data architectures and business intelligence in as Major companies such as Millicom Tigo, British American Tobacco Mexico, I'm new as Free lance and i am interested in this pr Daha fazlası

in 23 gün içinde5000$ USD
(0 Değerlendirme)
0.0
priyankaetl

I am having two years of industrial experience in ab-initio. Worked on the Allstate projects. Having good knowledge on ETL process. Independently supported the UAT and production. I have knowledge on running graphs th Daha fazlası

in 60 gün içinde5000$ USD
(0 Değerlendirme)
0.0
kimit1234

Hello, I am a part of firm which is into Data Warehousing. Please visit [url removed, login to view] for more details you can ping me.

in 30 gün içinde5555$ USD
(0 Değerlendirme)
0.0
Pranab3mukherjee

I have 12 years of experience in various areas of SAP applications and data integration, involving different sap and non sap systems through SAP Portal and through ETL Data migration tool - SAP Business Object Data Se Daha fazlası

in 60 gün içinde5555$ USD
(0 Değerlendirme)
0.0
srinivasuluv

Have an extensive experience in ETL world and build a system from start to end. Provided an ultimate performance based solutions to clients. In database world, each and every record is very important. Came with an e Daha fazlası

in 25 gün içinde5555$ USD
(0 Değerlendirme)
0.0
rbs100

I have more than 20 years of experience in IT handling highly complex major projects for global clients like Citi Bank, RBS,AIG to name few. I have played roles like DBA,Dimension Modeler, Technical Architect with cap Daha fazlası

in 30 gün içinde6111$ USD
(0 Değerlendirme)
0.0