Senior System Analyst served on a team of 3 for 1+Years for DOH. His role as a subject matter expert was to examine business processes and/or define business requirements. Develop reports as required to meet the needs of the business processes and requirements, create and update SQL queries and stored procedures to support reporting needs and create and update Online Analytical Processing (OLAP) Cubes for multi-dimensional analysis of data.
Project goals included development of new and maintenance of existing technical resources used in the process of producing reports and maintaining data structures.
Main technical skills utilized for project: SQL Server, .Net, OLAP Cubes, Dundas
Project summary including outcomes achieved:
- HMS Reports portal provides one place, which provides a wide range of County-reporting needs.
- Developed State wide SSAS Cube for Department of Health integrating 67 County Department Health Management System Data.
- Developed Cube reporting Interface using Dundas Charts and ASP.Net and C#.
- Designed and developed several Crystal Reports which gets data from each county’s HMS application Database. This is achieved by changing the DSN of the reports that are published in Business objects Enterprise dynamically.
- Involved in writing Data Transformation Server, SSIS tasks to import data from different sources to central database.
