Sonika S.

Sonika S.

Business Intelligence Domain Experience

Irvine , United States

Experience: 4 Years

Sonika

Irvine , United States

Business Intelligence Domain Experience

60000 USD / Year

  • Immediate: Available

4 Years

Now you can Instantly Chat with Sonika!

About Me

  • Having 4.5years of experience as Senior Systems Engineer in Business Intelligence (Tableau, Qlikview).
  • Experience in building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • ...

Show More

Portfolio Projects

Description

  • Designed, developed, implemented, and supported QlikView dashboards. Integrated data sources and databases with QlikView for presenting data.
  • Created data queries and reports using QlikView and Excel. Created custom queries/reports designed for quality verification and information sharing.
  • Used SQL, PowerPoint and Excel daily to generate various performance reports for analysis.

Show More Show Less

Description

  • Created Dashboards with different style using Qlikview components like List Box, Slider, Buttons, charts and Bookmarks.
  • Gathered & loaded data into Qlikview from various data
  • Created different types of sheet objects like List boxes, Buttons, Multibox.

Implemented Incremental Load to improve Load Time.

Show More Show Less

Description

  • Redesigned all the existing 7 dashboards by removing the Gregorian calendar model and implementing 4-4-5 Calendar model.
  • Requirement gathering for each dashboard to collect specific details for implementation of 4-4-5 Calendar model in Qlikview.
  • Redesigned all dashboards Data models and GUI to incorporate the 4-4-5 aligned calendars.
  • Exhaustive testing of all the dashboards and Production release of the same.

Show More Show Less

Description

  • Extensively used Qlikview advanced reporting functionalities such as Set Analysis, Comparative analysis, Section Access, Master calendar(Gregorian and 4-4-5 Calendar), Link Tables, Incremental load, Extension Objects, Generic load, Partial load, Sorting, QVD, Variables, Joins, cyclic groups, In-built functions, Mapping tables and Containers etc.
  • Extracted data from multiple data sources and implemented the data flow architecture of complex Data models.
  • Created several PDF reports on dashboards based on requirements of Client which are daily distributed to specific user group via email, through publisher.
  • Optimized commercial contracting dashboards with heavy data set at report level and script level which resulted in high performance dashboards.
  • As a result of SAP BW source system up gradation, existing dependent Qlikview Supply chain dashboards were successfully repointed to new source and redesigned.

Show More Show Less

Description

  • Design Dashboards using filters, parameters and action filters.
  • Strong understanding of advanced Tableau features including calculated fields, Parameters, R-integration, Joins, Data Blending and Dashboard actions.
  • Administer user, user groups and scheduled instances for reports in Tableau.

Show More Show Less