Md. Shahnewaz Rasel

Managed data warehouse for leading pharma clients like - Pfizer, Novartis, Johnson & Johnson, RB etc. Completed around 50+ projects all related to MS BI stack. BI Developer, Pfizer RADAR Dashboard [Client: Pfizer] [Jun’13 – Nov’13] Pfizer RADAR is a web based BI solution for the client containing a dashboard and custom reports to enable the client to monitor sales performance of Pfizer brands and competitors. Responsibility: Project Management, requirement analysis, staging, building data warehouse and CUBE, write MDX to generate table and trend chart. Technology: SSIS, SSAS BI Developer, My Market Monitor Dashboard [Client: Novartis] [Jun’11– Mar’12] My Market Monitor is a web based platform to bring local data source (like France, Italy, Belgium, UK, Spain, Norway, Poland, Canada, US etc.) with different data behavior; into a same standard pattern to measure out business performance in visual representations with fast online access and delivery. Responsibility: Requirement analysis, staging, creating star-schema, building data warehouse and CUBE, write MDX to generate table and trend chart Technology: SSIS, SSAS BI Developer, Johnson Infant Formula Dashboard [Client: Johnson & Johnson] [Apr’12 – Aug’12] Mead Johnson Infant Formula Dashboard makes available sales and market performance data for Mead Johnson and competitor brands across Belgium, France, Ireland, Italy, Netherlands, Poland, Portugal, Spain and UK in visual representations. Responsibility: Requirement analysis, staging, creating star-schema, building data warehouse and CUBE, write MDX to generate table and trend chart Technology: SSIS, SSAS DWH Developer, Reckitt Benckiser Feed Project [Client: Reckitt Benckiser] [Sep’12 - Present] Integrate different local data sources (like, Algeria, UK, Belgium, Italy, and France etc.), analyze data with different format and then generate reports with hierarchical structure to meet the client requirement. Responsibility: Project management, data mining, staging, bridging and building a data warehouse to generate excel reports. Technology: T-SQL, SSIS, Excel Macro

Created multi-dimensional model for different clients.

I am working as MS BI consultant for last 12 years. I worked with IMS Health (www.imshealth.com), Gapminder Foundation (www.gapminder.org), Dynamic Web (https://dynamicweb.com/), Lanetix (http://www.lanetix.com/), ST Advisory (http://stadvisory.com/) etc. and provided small to large scale BI solutions. I am comfortable with other BI tools like Tableau & Qlik