DB Solution for analytical services
Company provides data validation service for different companies. Data from that companies come into inner information system with aid of Encoding and FTP. It is processed and sent back to client's information system. Cube is created to agile data analytic. Corporate data warehouse contains following elements: 1. Client DB. 2. ETL to retrieve data from client db, encode sensitive information, and stores in Adapter db (see below). 3. Adapter. This database keeps mapping between encoded identifiers and real client identifiers as well. It keeps some client specific administrative data as well. 4. ETL to dump changed data for further importing into corporate central database. 5. Flat file Input. 6. ETL to load data into staging. 7. Staging. Raw data in tables with source identification. 8. ETL to load data into Central database for further operating. 9. Central. Consolidated database. 10. Data Access Layer. 11. ETL to transform data DW. 12. Data Warehouse (DW). Relation
About Me
Others say about me better for me: (job: SSAS, SSIS and MDX) Roman is a top notch developer. He can solve any problem and has a thorough knowledge of the Microsoft SQL Server toolkit. He will always be my first choice for any assignment. He is able to translate business requirements into a working, well designed, and high performing BI solution. Would recommend to anyone looking for work within his skillset. (job: Senior DB / Business Intelligence Manager) Roman was a pleasure to work with! (job: T-SQL Expert Required for single Dynamic Pivot) Roman was a great help with a difficult problem. (job: SQL report development projects) I found Roman Khramtsov to be hard working and creative in coming up with solutions. Very cooperative and knowledgeable. I will use his services again, looking forward to future projects with him and would recommend him to others. I would add that I enjoy to take part in Business Intelligence and database projects. I can be respond for any phase of your data processing or the whole database modeling, design, and implementation.
$ 15 USD/hr
NEW FREELANCER!
