Employment History 

• QlikView / Qlik Sense Developer

  Colaberry Consulting Firm/ School of Data Science & Data Analytic

  February 2020 - Present

  • Extract, Transform, and Load data into QlikView and Qlik Sense using various sources like SQL Server, QVDs, Excel files, and flat files to create and developing various complex reports as per given business requirements.
  • Interact with users extensively in gathering the requirements and analyzing the needs of the end-users
  • Resolve Synthetic keys using various resolving techniques.
  • Perform the Incremental load to fetch the new and updated records from the database.
  • Develop Qlik Sense dashboards for Visualization and monitoring of KPI, which helped to improved business processes.
  • Develop reports using QlikView/Qlik Sense software to generate all daily, weekly, monthly and quarterly reports based on the user business requirements.
  • Work extensively in developing expressions and set analysis expressions.
  • Optimize existing data models and load scripts to improve performance.

• QlikView / SQL BI Developer

  IPeople

  May 2016 - June 2018

  • Worked closely with all levels of business, with varying levels of technical knowledge, to develop KPIs for the calculations in the QlikView apps.
  • Created report based on dimensional, and relational models.
  • Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various users and business units.
  • Developed SSRS Reports in Visual Studio by using the variety of tools such as charts, map, matrix, indicator and more.
  • Deployed and configured reports in Report Server configuration and make it ready for the end user.
  • Involved in designing, developing, testing, publishing, maintaining, and supporting QlikView applications.
  • Optimized existing data models and load scripts to improve performance.
  • Analyzed the QlikView data model, script logics and the ETL business logic for the existing QlikView applications.
  • Developed, tested and implemented Referential Integrity rules and regulations through constraints, triggers and views in the centralized SQL database.
  • Troubleshoot T-SQL, SSIS and SSRS errors and performance issues and address them as required.

• QlikView / Qlik Sense Developer

  Spectrum

  September 2018 - January 2020

  • Developed Qlik Sense dashboards for Visualization and monitoring of KPI, which helped to improved business processes and earned us a JD Power award for Customer Satisfaction.
  • Developed complex QlikView load scripts in 3 Tier Architecture – Source Layer (Database), Transformation Layer (QVD), Presentation Layer
  • Developed reports using QlikView software to generate all daily, weekly, monthly and quarterly reports based on the user business requirements
  • Worked extensively in developing expressions and set analysis expressions
  • Optimized existing data models and load scripts to improve performance.
  • Created Dashboards style of reports using QlikView components like List Box, Slider, Buttons, Charts (Drill Down & Cyclic Grouping), bookmarks, Containers and Calendar object.
  • Read and interpret Complex Data Models, and Data Modeling.
  • Implemented QlikView scripting, QVD, QVW, and data loads.
  • Implemented tasks to schedule QVD generation and Dashboard refreshes at regular intervals and appropriate dependencies.
  • Worked on Qlik Sense, QlikView installation, server-side administration, and user administration.
  • Designed and implemented Qlik Sense/ QlikView Extensions into enterprise level applications.