BI and Datawarehousing Architect at Datamagnet Transech Pvt Ltd
Jul-2016 to present
Headquartered in Lewisville, Texas. Med Fusion an integrated Roche Molecular Center of Excellence full-service laboratory and clinical trials service organization. This project mainly deals with designing and developing a Data mart, Developing ETL using SSIS from Sybase Sunquest Data Source and Building IBM Cognos DMR Cube on laboratory and clinical trials services data and deploying them for End User Usage. Roles and Responsibilities: ? Understanding Sybase Sunquest Data tables ? Designing Data mart (Logical and Physical). ? Loading the data from Source to Mart using SSIS. ? Understand the Requirements and Functionality of the application from specifications. ? Designed, developed, tested, and maintained Tableau functional reports based on user requirements. ? Developed rich Graphic visualizations with Drill Down and Drop down menu option and Parameters using Tableau. ? Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines,