I am a database / Business Intelligence / solution architect and have more than 14 years of experience in IT industry.
Solution: I will load (using SSIS ETL) your input file (csv or text file will be best) into database and then we will do analysis and then generate all required report using SSRS technology. GUI will be developed in ASP.Net, C#, MVC or entity framework.
So we will use SSIS, SSRS, ASP.Net web application.
Let me know if you want to discuss further.
My Technical background
• A goal-oriented professional with more than 14 years of experience in IT Database Management and Project Management specifically Airlines, Telecommunications and Health care domain
• Having good amount of practical exposure on AngularJS, MVC, Javascript, ASP.Net with C#, VB.Net language and executed multiple projects independently.
• Possess expertise in Data Warehouse/Data mart concepts, data modeling for OLAP & OLTP systems from design and analysis to implementation including the conceptual, logical and physical data models
• Experience in relational and dimensional data modeling using ERWIN, understanding of Ralph Kimball and bill Inmon methodology for dimensional modeling, star and snowflake schemas
• Having depth knowledge of large database design techniques; experience in data analysis, data cleansing, and data transformation and migration using ETL tools;