Kolluri Chandana

Developed Complex Graphical User Interactive reports using various QlikView /Power BI Objects. Expertise in working business intelligence tools for developing various reports using Power BI/Qlik Sense BI. Strong analytical database design and Data Modelling skills in Qlik Sense/Power BI.

Configured

Access control within Qlik Sense Apps using QMC. Created dashboards with complex sheets which include List boxes, Statistic boxes, containers, different charts bar charts, scatter charts, Heat charts, and Block charts and pie charts to show the statistics of the sales held on different products in different years. Worked in large teams delivering end to end dashboards in on-shore/off-shore delivery model.

Analyzed reporting requirements to usable long-term dashboard and reporting solutions, develop solutions, as necessary. Involved in Optimizing existing QlikView/Power BI dashboards with a focus on usability, performance, long-term, flexibility, and standardization. Designed and developed interactive Power BI dashboards to visualize KPIs.

Built data models, relationships, and hierarchies. Developed advanced DAX measures and implemented data transformations using Power Query.

Connected

Power BI to SQL Server, Excel, flat files, and QVD.

Implemented

Row-Level Security (RLS) and managed workspace access. Published, scheduled, and maintained datasets and reports in Power BI Service. Optimized performance using incremental refresh and model improvements. Migrated reports from Qlik sense/Congo's to Power BI

Power BI Developer at Cognizant Technology Solutions India Private Limited (2022-01 – 2026-03)

Domain: Life sciences

• Designed and developed interactive Power BI dashboards to visualize KPIs.
• Built data models, relationships, and hierarchies.
• Developed advanced DAX measures and implemented data transformations using Power Query.
• Connected Power BI to SQL Server, Excel, flat files.
• Implemented Row-Level Security (RLS) and managed workspace access.
• Published, scheduled, and maintained datasets and reports in Power BI Service.
• Optimized performance using incremental refresh and model improvements.
• Migrated dashboard from other tools like Congo's and Spotfire to power BI

QlikView/Qlik Sense Developer at Cognizant Technology Solutions India Private Limited (2022-01 – 2026-03)

Domain: Life sciences

• Worked with Business Analysts and the Business users to identify the user requirements, business reporting needs, layout, and developed the architecture of prioritized reports.
• Developed Qlik Sense dashboards by importing QVDs and binary load to compare Qlik Sense design over QlikView.
• Created data blending in case of merging two different datasets.
• Installed, configured and deployed the application on QlikView server and Imported data from different sources such as Oracle, SQL Server, MS Access, XML files and flat files using OLE DB/ODBC.
• Used Qlik Sense Functions (Date and Time, Join, Aggregation, Peek, Previous, Class, FirstSortedValue etc.) and Created Variables using LET, SET or control statements in the scripts.
• Implemented security using QlikView section access technology that dynamically hides selected areas of the dashboard depending upon user privileges.
• Implemented security through Qlik Sense scripting as well as QMC to restrict data as per users'/group privileges.
• Created dashboards with complex sheets which include List boxes, Statistic boxes, containers, different charts bar charts, scatter charts, Heat charts, and Block charts and pie charts to show the statistics of the sales held on different products in different years.
• Involved in performance tuning of dashboards to improve the response time for the users accessing the documents via access point by reducing the size of the QVW

Qlik Sense/QlikView Developer at Spectrum Consultants India Private Limited (2020-03 – 2022-01)

Domain: Logistics

• Develop, design and maintained Qlik sense dashboards using data from the Data Marts. Determine the relationships among business data, determine KPIs, dimensions or measures
• Designed and developed Qlik sense dashboards using Chart Box (Drill Down, Cyclic Grouping), List, Input Field, Table Box and Calendar & Date Island as per the business requirements.
• Involved in designing the data models, extract & transform the data from different data sources like QVD files, Excel, SQL Server, Oracle, binary QVW, Inline & txt files in creating the Qlik sense dashboards.
• Created Dashboards style of reports using Qlik sense components like List Box, Slider, Buttons, Charts and Bookmarks. Extensive knowledge on implementation of Set Analysis and also worked on the Alternate states to do a comparative analysis in Qlik sense
• Implemented Incremental ETL to handle high, incremental volume of data, resolved Circular Relationships, Synthetic Keys.
• Implemented tasks to schedule QVD generation and Dashboard refreshes at regular intervals and appropriate dependencies. Developed transformation logic as per the requirement, created mappings and loaded data into respective targets.

MTech in Digital Communication – Kakatiya University (2017)

Bachelor of Technology in ECE – JNTU at Hyderabad (2014)