Sonika S.

Sonika S.

Senior Systems Engineer–Business Intelligence

Delhi , United States

Experience: 4 Years

Sonika

Delhi , United States

Senior Systems Engineer–Business Intelligence

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. Experience in developing ...

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

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