Naveed Ahsan

• In collaboration with IMS Health, working as technical lead on a Project for a leading Spanish Pharmaceutical Firm, ROVI.
• Agile Business Intelligence (BI) solution for ROVI to evaluate their standings in the corporate world via analysis of historical data based on various scenarios according to different possible business strategies, or scenarios which could be experienced in the near future.
• Construction of a complete business intelligence stack which composed of an enterprise data warehouse and reporting.
• Accurate and insightful commercial analytics which requires very limited effort, and there is an effective dissemination of information via proper collection and organization of data
• It includes complicated ETL processes which consolidates data from multiple data sources (including SAP, Salesforce and Mastercard) and provides a single version of truth for the customer.
• OLAP Cubes are implemented for multiple data sources via Microsoft SQL Server Analysis Services (SSAS).
• The analysis will be revolving around ‘specific data for specific user’ rather than displaying ‘everything to everyone’.
• The business intelligence solution will also facilitate for envisioning the future in a cost-effective way by doing efficient scenario-based analysis and handle any possibly exceptions that should be considered during the formation of an efficient business strategy for the company.
• Microsoft SQL Server Integration Services (SSIS) is being used to implement an enterprise data warehouse which allows automatic maintenance of SQL Server databases and updates to multidimensional cube data.
• TIBCO Spotfire is being used for reporting to empower the broadest spectrum of users across the widest range of analytic processes for excellent modeling and analytics coverage, good coverage for data interactivity, visual drill down and drill down support.