Susmita Ghosh

· Proficiency in MS Power BI Visualization and designed and developed visual reports, dashboards and KPI scoreboards using Power BI desktop that aggregate data from multiple data sources, importing data and transforming data for Business Intelligence.

· Publishing reports from desktop to Power BI service and creating Reports and Dashboards in Power BI service, and sharing them with end users so that users can view and interact with them in service and mobile devices.

· Worked on gateways to create connection between Power BI cloud-based Data analysis technology and the data source located on-premises.

· Developed Dashboards in Power BI using advanced level of calculations(DAX) on the data set.

· Adept in developing, publishing and scheduling Power BI reports as per the business requirements.

· Developed reports and dashboards in Tableau desktop using different types of data sources and tuned to optimize the reports and dashboards.

· Possesses working knowledge of different types of charts, tables, filters, details, functions in Tableau.

· Working experience on Tableau desktop and Tableau server.

· Experience with advanced level of skills in Excel,Access, SQL.

· Designed and developed interactive Dashboards in SAP Analytics Cloud(SAC) on top of HANA views and Bex queries by combining latest features like Responsive Layout Design, Linked Analysis for the interactivity within the Dashboard, Linking Dimensions for merging of different data sources within the Dashboard, used the different advanced features like Smart Insights, Search to Insights and Smart Discovery.

· Created Hierarchical data using Imported data sources and modelling in SAC with data imported from Excel files.

· Worked on the development of planning applications with SAP Analytics Cloud on top of excel data and used the planning features: Allocation, Distribution, Spreading, Value driver tree and Predictive forecasting.

· Knowledge of JavaScript and CSS in Application Designer.

· Developed various mobile and desktop compatible dashboards in SAP Lumira Designer 2.X to expose the KPIs to end users.

· Created Dashboards based on real time cube from SAP BW/4 HANA using the Planning features of SAP Lumira Designer where users can enter data into the Dashboard and the data gets stored in the database for further analysis and reporting.

· Designed and developed various detailed level reports in Web Intelligence using the diverse features of WebI on top of Bex queries and HANA views.

· Worked in end to end development of workbooks in SAP Analysis for Office(SAP AFO) by connecting multiple data sources from HANA views and Bex queries and used the different capabilities of Analysis for Office such as conditional formatting/ exceptions, filter by measures/conditions, excel commentary on data cells, hierarchies and groupings, excel based charts and filtering across the workbooks. 

· Possess expertise in SAP BI/BW Modelling using data sources, DSOs, Cubes, Info providers and Reporting with BEX query.

· Experience in developing views in SAP S4/HANA and consumed the views in SAP AFO.

· Developed and maintained Crystal Reports for a dedicated project and repaired and updated existing reports as needed due to reported bugs or development changes.