Live data from ground level instruments needs to be dumped on sql.
There are 8 machines from which data needs to be taken. Hence it has been decided to have 8 tables, 9th table will have consolidated data of all 8 tables.
After the data is collected, a report needs to be generated, one individual report for each machine. And a consolidated report for the all the machine.
We also need to have different authenticated levels for different users, and based on their login the user information ll be captured.
Please send the design approach, expected time and your resumes to shazimkhan574@ [login to view URL]
Hi
Im a IT Project Manager with over than 20 years of experience in banking software development.
Im an expert in .NET technologies (C# and vb) over sql server databases
Please attach de datamodel and a example of whats needed
Regards
Carlos
Dear Employer, Have reviewed your requirement and can serve your requirement with ease, So requesting you to kindly consider my bid for further discussion.
Please have a look at our profile, we will provide you great web application.
We have specialize developers in ASP.NET ,MS Server and c#.
Please come online at PM for further discuss
The design will involve following steps.
1) Database script that runs to collect data from 8 machines and dump into single table
2) .net script to have authentication.
3) Crystal report to provide reports as per the requirements
For your requirement , I will provide a solution design, the data model, the data load modules and basic excel reporting.
I would the following details :
a. Data Capture Mechanism & ETL Process
1. Source/Format of data.
2. Target system.
3. frequency of data load
4. granularity of data stored
5. user authentication levels required
6. login information to be captured
7. Data definition
I completed a similar project a couple of months ago which collected data from several temperature recorders. The project was able to use a single table for all of the devices. This approach may be possible here but request lacks sufficient information on the 8 machines to decide.
I have experience with Microsoft SQL Server. I worked with SQL Server along 18 months. During that time, I have administrated the databases, builded BI reports and created the database structure. Moreover, I have experience with ETL jobs. During several of the jobs done for me, I needed to manipulate data from databases to export information to report and other structure choose.
An ISTQB certified Testing professional with 3 years and 9months of hands on experience in Software Testing with a working knowledge of Test Methodologies and Processes. Having strong technical background and expertise in ETL testing and functional testing of applications and products in the Treasury domain.
I have good knowledge on ETL, Repots, writing the SQL script and MS SQL SERVER.
My best solution for this project is that just create the single table (consolidated ) and load the data from all 8 servers. We have to create the one more extra column in above table called Machine Name , So while reading the data from Machines we have to hard code the machine name and then enters the data into consolidated table. For Ex: We have derived column in SSIS, so while reading the data from Machine 1 then tag all these data with the Machine 1.