Susmita Ghosh

 Susmita Ghosh 1603, 40 Alexander Street, Toronto, Ontario – M4Y1B5,- Summary Data Analyst with 6 years of BI experience in data management, data analytics and business intelligence. Experience in data modelling tools and performed cleansing of data, source to target data mapping, data transformation and data visualization. Analysing the large volumes of data and ability to solve problems, finding logical patterns to give useful insights to business users. Designed and developed reports and dashboards with several BI tools by considering end user requirements and supported requests related to reporting by providing practicable solutions. Prepared functional, technical and training materials for all users. Experience in working on Agile projects. Skills & Abilities Primary Skills –Tableau, Microsoft Power BI, SAP Analytics Cloud(SAC), SAP Lumira 2.X, SAP Design Studio 1.6, SAP Analysis for Office(SAP AFO), SAP BusinessObjects BI Platform 4.x, Web Intelligence. Secondary Skills –SAP BW, SAP HANA. Programming Languages – SQL Database – RDBMS, Sybase, SAP HANA, Teradata Operating System – Windows 7, Windows 10 Tools – Tableau, Microsoft Power BI, SAP Analytics Cloud (SAC), SAP Lumira Designer, SAP Design Studio 1.6, SAP BO Analysis for Office(SAP AFO), Crystal Reports, Information Design Tool (IDT), Universe Design Tool (UDT), Web Intelligence Rich Client, BI Launch Pad, Central Management Console (CMC), SAP Logon, Query Designer, SAP HANA Studio, Microsoft Excel, Microsoft Power Point,Microsoft Word, Microsoft Access. Methodologies – Data Warehousing and Modeling, Software Development Cycle, Agile and Waterfall. Professional Experience SENIOR CONSULTANT | PricewaterhouseCoopers PVT LTD | JULY 2017 – Till date 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. Solution Integrator | ericsson india global services pvt ltd | april 2014 – july 2017 Development and enhancement experience with different SAP BI tools for reporting like Web Intelligence (WEBI), Universe Design Tool (UDT), Information Design Tool (IDT). Migrated customized and standard reports from BO XI 3.1 to BO 4.1 and implemented changes for the customized reports and validation and testing of all standard and customized reports. Achievements Received Rock Star award for quality deliverables. Received We Applaud award for exceptional performance in client deliverables. Received Above and Beyond Team award for commitment to the client engagement and outstanding delivery as a team. Education BACHELOR OF TECHNOLOGY | 2009 - 2013 | JIS College of engineering Major: Electronics and Communication