Now you can Instantly Chat with Susmita!
About Me
I have build various BI reports for users across different organisation as well fixed the issues in it by debugging it. Skilled in BI reporting tools especially in Tableau, SAP Business Objects and Crystal Reports with SQL knowledge (worked in Ter...
Show MoreSkills
Portfolio Projects
Contribute
HR department in NEC followed manual activity to log all the leaves taken by different employees which we automated the process and i was responsible to build a dashboard from built-in data warehouse
Description
HR department initially had SAP BO webi reports for their analysis and had a spread sheet which they used to update manually to track the days lost due to sickness. This was transformed to Tableau Dashboard by me by creating new dashboard connecting to SQL Server database and importing the tables/views into the dashboard and building charts and interacting graphs using different features in tableau like Actions, Parameter. The manual spreadsheet task was no longer required whereas tables were updated to keep track of leaves taken by employees and days lost due to sickness was calculated in Tableau Dashboard by me using calculated fields.
Show More Show LessContribute
Built a Car Park People Management Dashboard to track the people and car movement during events
Description
I was responsible to recreate the existing CPPMBO Dashboard in Tableau 10.5 tool. I had Car park Map and Database information through which i needed to connect my dashboard to build it. Used Tableau API, HTML to refresh the dashboard every 10 mins in a large screen whithout anyclick button.
Show More Show LessContribute
There was huge list of crystal report across different organisations which was creating trouble for maintenance point of view. Thus i merged multiple reports wherever possible and decommissioned
Description
I studied each and every report before merging or changing the reports, followed up with users to understand the usage of the reports. Scheduled various meetups before coming up with final list of reports. Build a new set of crystal report with all organisation and merging the report stucture into one wherever possible and moved to Ungerboeck Dev portal for testing team to test the report and provide their sign off before moving it Ungerboeck Test (allowing user to provide sign off) and eventually to Prod Environment.
Show More Show LessContribute
Fixed the issues faced by Finance Team in Event Overview Dashboard by analysing the issues in SQL Server database and data flow in data warehouse.
Description
There were multiple issues in Event Overview Dashboards, some of the issues were related to Tableau dashboard while rest others required database table fixes. Distinguished different issues into two catogories and analysed the database related issues and fixed them by changing the stored procedure or modiying the existing views.Tableau related issues were fixed by modifing the dashboard for example the forecast value was not getting displayed properly, so changed the calculated field related to it.
Show More Show LessContribute
Created New Universe from Scratch and webi reports as per user requirement
Description
I worked in a team responsible for any request coming through for Business Objects and tableau report development. As a part of Apple Gift Card(AGC) project, i was reportnsible for gathering the requirement, understanding and designing the universe structure and submitting the design doc for review by higher managers, once it gets approved i built universe by importing tables/views and joining based on primary index. Creating objects, joins, contexts ,setting incompatibility to avoid traps and loops. Once universe in build, this is exported to BO Server in dev environment to create webi reports. Once unit testing, functional testing are done this is moved to UAT for user testing, after getting proper approval universe and reports are moved to PROD/LIVE
Show More Show Less