Balaji K

Project 1: MSTR to Qlik Migration Project (LTIM).

Software Used: Qlik Sense Cloud, Athena, Oracle, MSTR.

Client: Insurance Client: MMC.

Description:

This is a migration project from MSTR to Qlik Cloud. Contains more than 100 dashboards for seven different modules. I have led and completed two modules, and I am currently working on three modules. We have used the most advanced options to get the real-time data through ODAG.

Responsibilities: Involved in system analysis and design. Understand business requirements, analyze, and translate them into application and operational requirements as per MSRT, and implement a similar solution in Qlik. Deployed the application on the server for publishing and scheduled for use in Qlik Sense and UAT updates.

• Developed scripts for ODAG and dashboards.
• Created reports using Qlik Sense components, like Filter Panes, Sliders, Buttons, Charts, and utilized a lot of extension objects and Bookmarks.
• Utilized Vizlib extensions a lot to meet the end-user expectations.
• Created QVDs by importing data from the database tables using Qlik Sense.
• Worked with variables, set analysis, aggregate functions, and mapping functions.
• Involved in designing the data models.
• Extract and transform the data from data sources like QVD files, Excel, Microsoft Access, and binary QVF in creating the Qlik Sense dashboard.
• Involved in UI build activities to create custom reports based on end users' interests, utilizing Vizlib extensions.
• Achieved a lot of advanced options to handle the data volume in Qlik Cloud due to app size limitations.

Project 2: POS vs. Actual - Finance Dashboard (NTT Data)

Software Used: Qlik Sense, Data Bricks, SQL, Excel.

Client: NTT Data Internal.

Description:

In the current assignment, we have created two dashboards; one will help the finance team understand the adjusted cost compared to the actual cost spent. The main agenda of this work is to notify the weak performer in the client's space in which they are making a profit or loss over the contract tenure. The second dashboard is to compare the data on point of sale without adjusted cost to know the business performance details: tower, location, and grade level details. We have onboarded 20 clients in this dashboard. The long-term goal is to onboard more than 200 clients.

Responsibilities:

• Involved in system analysis and design.
• Understand business requirements, analyze, and translate them into application and operational requirements.
• Deployed the application on the server for publishing, and scheduled for using Qlik Sense and the UAT update.
• Developed scripts and dashboards.
• Created reports using Qlik Sense components, like Filter Panes, Sliders, Buttons, Charts, and utilized a lot of extension objects and Bookmarks.
• Created QVDs by importing data from the database tables using Qlik Sense.
• Worked with variables, set analysis, aggregate functions, and mapping functions.
• Involved in designing the data models.
• Extract and transform the data from data sources like QVD files, Excel, Microsoft Access, and binary QVF in creating the Qlik Sense dashboard.
• Used different chart objects, like bar chart, line chart, combo chart, pivot table, and straight table.
• Validating the reports' data with existing source files.
• Created the BYOR reports as per the end user's request.

Project 3: SD Performance and Prediction - Telecom Dashboard (NTT Data)

Software Used: Qlik Sense, N-printing Oracle, Databricks, SQL, and Excel.

Client: NTT Data Internal.

Description:

The main agenda of this dashboard is to track the telecom agents to present on the phone provided by the telecom providers, Cisco, and BT. We need to track the key metrics for the agent's utilization, phone time, and available time. We need to get the average call-handled time vs. the target time set for the account. We have provided the prescriptive insights and descriptive insights for the clients to make better decisions. Built over 20 N-print reports as part of automation for downstream.

Responsibilities:

• Involved in system analysis and design.
• Understand business requirements, analyze, and translate them into application and operational requirements.
• Deployed the application on the server for publishing and scheduled for using QlikSense and the UAT update.
• Developed scripts and dashboards.
• Created reports using Qlik Sense components, like Filter Panes, Sliders, Buttons, Charts, and utilized a lot of extension objects and Bookmarks.
• We have prepared more than 20 N-print reports for the automation of the downstreams.

Project 4: Launch Dashboard (Accenture)

Software Used: Qlik Sense, Data Bricks. S3.

Client: Takeda.

Description:

The main objective of the LAUNCH Dashboard is to provide information to the top management users about the patient journey in terms of how the business will get source (SOB). The conversion rate of patients from the Launch program to the commercial program. It will keep track of insurance details and the consistency of sales. This project is mainly used by top management for critical decision-making.

Responsibilities:

• Involved in system analysis and design.
• Upgradation of QlikView to Qlik Sense tools.
• Understand business requirements, analyze, and translate them into application and operational requirements.
• Deployed the application on the server for publishing and scheduled for use with QlikSense/QlikView server and UAT update.
• Developed scripts and dashboards.
• Created reports using QlikSense/QlikView components, like List Box, Slider, Buttons, Charts; utilized a lot of extension objects and Bookmarks.
• Created QVDs by importing data from the database tables using Qlik Sense/QlikView.
• Worked with variables, set analysis, aggregate functions, and mapping functions.
• Involved in designing the data models.
• Extract and transform the data from data sources like QVD files, Excel, Microsoft Access, and binary QVW/QVF in creating the Qlik Sense/QlikView dashboard.
• Used different chart objects, like bar chart, line chart, combo chart, pivot table, and straight table.
• Validating the reports' data with existing source files.

Project 5: Sales Dashboards. (Accenture)

Software Used: Qlik Sense, Qlik View 12, Netezza, Azure, Oracle.

Company: Takeda/Shire

Description:

The main objective of the Sales Dashboard is to provide information to the top management users about the sales, stock, and contract to delivery. It will also provide information about the sales rep performance details over Zone, Region, and Territory. This project is mainly used for top management for critical decision-making at the ZRT level. Key metrics for TRx, NRx, and NBRx. Market depth and market volumes will be calculated.

Responsibilities:

• Involved in database extraction using Qlik Sense, QlikView, and storing them in QVD.
• Working with platform support for the deployment of reports to production and quality assurance servers.
• I worked as an internal tester for the development team.
• Gathering data sources, like QVD files, Excel files, and TXT files, in developing the QlikView data models.
• Used set analysis to provide custom functionality in QlikView applications.
• Performed unit testing.
• Scheduling reloads and distributed tasks in QlikView Publisher, distributing the reports in the Access Point.
• Developed QlikView dashboards using Chart Box (drill down and cyclic grouping), list box, input box, table box, multi box, and calendar.
• Gathering data sources, like QVD files, Excel files, and TXT files, in developing the QlikView data models.

Project 6: Patient Services Dashboard. (Accenture)

Software Used: Qlik Sense, QlikView 12, Salesforce, Oracle, SQL, and flat files.

Client: Takeda/Shire.

Description:

The main agenda of this project is to show the patient journey. In Salesforce, we will have the different phases of tracking for patients, HCPs, and insurance components. It will help patient to HCP mappings in ZRT. HCP to ZRT mappings due to cross-territory mappings. Patient flow for the drug, and turnaround time for the patients to get the insurance details. This will hold even the feedback for the HCP, and the patient is on the drug. This project holds a lot of sensitive data for patients and HCPs.

Responsibilities:

• Involved in the scripting and designing of the project to fetch data from SFDC to Qlik Sense. Data is fetched from different sources, such as XML, SQL, and Oracle.
• Creation and loading of QVD every 15 minutes while the DB extracts are in progress.
• Incremental load with daily updating records.
• Documentation for the SFDC object mapping to DB tables creation.
• Meeting the user requirement and understanding the client requirement.
• Dashboard creations.
• Security access, user creation optimizing technique.
• Using Extension Objects.

Project 7: Executive Dashboard. (Accenture)

Software Used: QlikView 12, SQL, and flat files.

Client: Accenture (Internal).

Description:

The project mainly deals with HR information, such as how the candidate is entering the recruitment pipeline. Mainly, we are going to display the demand vs. candidate tagging info.

Also, I still have the offer run rate. It will be used primarily by the HRs for faster decision-making and tracking a candidate's journey in the recruitment pipeline.

Responsibilities:

• Involved in scripting and designing of the project.
• Data fetch from different sources, like XML, SQL, Oracle, and MS Access.
• Creation and Loading of QVD.
• Meeting the user requirement and understanding the client requirement.
• Dashboard creations.
• Incremental load with daily updating records.
• Security access, user creation optimizing technique.
• Using Extension Objects.
• Documentation