Qlikview Developer

Bindu Kovvali

Contact # 302-***-****

Email:*****.*****@*****.***

SUMMARY:

6+ years of overall IT experience in the software field in Business Intelligence Tools and the

Databases.

4+years of experience in QlikView Desktop, QlikView server & Publisher in aspects of

development, deployment and administration.

Experience in development of business intelligence applications using QlikView 11.x/10.x/9.x.

Experience in developing dashboards using Qlik Sense for over an year.

Experience using an ETL tool QlikView to handle the various data feeds from the different data

sources using QlikView load scripts into QVDs. Profound knowledge on Data Warehouse

concepts like Star schema, and Snowflake schema.

Connect QlikView to multiple data sources including Oracle, MS SQL Server, and MS Excel.

Created different data visualizations using QlikView 11.0.

Domain Knowledge on Healthcare, Retail and Services Industries.

Experience in Healthcare, Tax and Financial space.

Experience in developing User Interfaces and QlikView/Qlik Sense Dashboards using Chart-Box

(Drill Down & Cyclic Grouping), List Boxes, Input Fields, Table Boxes and Block charts.

Strong Experience in working with Charts (Table Box, Pivot Tables, Straight Tables, Pie-Charts,

and Trellis).

Good Exposure to working with QlikView (Functions and Expression Scripts).

Hands on Experience with QlikView Set Analysis and Calendar Scripts.

Extensively used Apply Map and Joins in creating qvd’s.

Experience in creating Reports on Ad-hoc basis with triggers on actions.

Expertise in planning, implementation and testing of QlikView Dashboards.

Support enhancement of existing solutions on an as-needed basis

Loaded data into QlikView application from different sources like QVD’s, excel files, databases

and external files.

Experience in Creating Reports with Alternate States Set analysis.

Worked on Joins, Concatenation techniques to avoid Synthetic keys and Circular Loops.

Experience in creating Dynamically changing expressions.

Implemented Section Access for providing Security.

Experience in Microsoft SQL Server 2016

Exceptionally well organized with strong analytical, design and leadership skills coupled with

team work to support and achieve enterprise business objectives.

TECHNOLOGIES:

• BI Tools - QlikView 10.x/11.x., Qlik Sense 3.0

• Administrative Tool – QlikView Server & Publisher.

• Databases- SQL server 2012,2016 Oracle 11g.

• Operating System - Windows-7/8/2000/XP.

• Languages - SQL, HTML.

PROFESSIONAL EXPERIENCE:

Client: State of Alaska – Remote Oct 2016 - Till date

Role: QlikView/Qlik Sense Developer

Responsibilities:

Involved in design, development and maintenance of QlikView dashboards for the system.

Building QVD’s, QVW’s, QVF’s using source systems like MS SQL Server, MS Excel and flat

files.

Bindu Kovvali

Contact # 302-***-****

Email:*****.*****@*****.***

Gathered, documented requirement from the users and developed Complex Graphical User

Interactive reports for the case management details using various QlikView/Qlik Sense Objects.

Developed Proof of Concepts for various projects using QlikView and Qlik Sense.

Strong Skills in Data Modeling & Loading data from multiple data sources.

Worked with Incremental Loading & QlikView document Versioning.

Developed executive dashboards in QlikView delivered through the web, enabling to measure the

performance of the business with analytical capabilities.

Experienced in QlikView Server and Publisher maintenance – Creating scheduled jobs for QVD

extracts and report reloads.

Developed different complex models eliminating closed loops, Synthetic tables and ambiguous

relationships.

Work on requirement specifications for the strategic KPI's that drive performance and profitability

in the division.

Performed analysis, documentation for calculation for various attributes.

Performance tuning of dashboards was carried out to limit the response time to well under 10

seconds.

Implemented Section access and Hidden scripting for the Application Security

Performed testing of dashboards for functionality, data, performance, look and feel.

Promoted dashboards to production environment and manage user access.

Developed Heat map charts for data visualization.

Identified the highly memory consumption objects and performed necessary steps to reduce

memory used by objects.

Developed systems architecture for QlikView implementation identifying the data sources and

target reports.

Extensive knowledge in design and best coding practices.

Knowledge in debugging and troubleshooting issues along with exposure to performance tuning.

Environment: QlikView 11.0,MS SQL Server 2012, HTML, Excel, Windows Server 2012 Enterprise

Edition

Client: CareSource -- Dayton, OH Aug 2015 - Sep 2016

Role: QlikView Developer

Responsibilities:

Effectively participated in requirement gathering, architecture design, Data Modelling, ETL

process and development of user interface objects in QlikView applications.

Design, develop and deploy business intelligence presentation layer solutions in the provider

healthcare market focused on analytics and reporting components such as dashboards,

scorecards, reports.

Extracted the data from various databases such as Oracle, MS SQL Server, web files and MS

Excel to create and schedule different complex reports as per given business requirement.

Created Dashboards style of reports using QlikView components like List Box, Slider, Buttons,

Charts, and Bookmarks etc.

Developed Dashboards included customer detail drilldowns, threshold gauges and alerting

mechanisms.

Eliminated synthetic keys using QVD concatenation.

Experience in writing complex expressions using Set analysis and various QlikView functions.

Bindu Kovvali

Contact # 302-***-****

Email:*****.*****@*****.***

Created daily, weekly, monthly and quarterly reports for the management team based on the

Customer requirements.

Designed application for Sales & Marketing Modules that Generates GUI Report for easy access

through the data.

Worked closely with the development team to understand functionality, resolve issues and

provided feedback.

Environment: QlikView 9.X, MS SQL, Excel, Oracle, Windows Server 2012

Client: Bank of America -- Newark, DE Jan 2014 - Dec 2014

Role: QlikView Developer

Responsibilities:

Actively involved in requirement gathering sessions with business analysts, business

stakeholders, Subject Matter Experts (SME), developers and sponsors. Involved in complete

SDLC life cycle.

Design, develop and deploy business intelligence presentation layer solutions in the provider

healthcare market focused on analytics and reporting components such as dashboards,

scorecards, reports.

Held timely meetings with Solution Architect, Business Analysts, and Healthcare Subject Matter

Experts to prototype, design and develop solutions to meet requirements.

Created Dashboards style of reports using QlikView components like List Box, Slider, Buttons,

Charts, and Bookmarks etc.

Created the reports using charts like Pie, Bar, Line etc. Charts are used in making reports more

user-friendly in analysis purposes.

Created daily, weekly, monthly and quarterly reports for the management team based on the

Customer requirements.

Developed Set Analysis to provide custom functionality in QlikView applications.

Adopted Scrum methodology in the system development process.

Worked closely with the development team to understand functionality, resolve issues and

provided feedback.

Successfully performed User Acceptance Testing (UAT) before releasing to Production

environment.

Extensively used SQL scripts for data mapping and querying.

Developed data mapping procedures ETL - Data Extraction, Data Analysis and Loading process

of collected data from mentioned data source.

Designed business intelligence dashboards using QlikView (Desktop/Server), allowing executive

management to view current and past performance sales trends, forecast sales and to track

existing customer sales.

Environment: QlikView, SQL, Excel, Oracle, Windows Server 2012, QlikView 11

Client: Tech Mahindra Sep 2011 - Oct 2013

Role: SQL Developer

Bindu Kovvali

Contact # 302-***-****

Email:*****.*****@*****.***

Responsibilities:

Involved in Database design and creation of tables, stored procedures and other DB objects.

Involved in the modification of the database structures as directed by developers for different

environments.

Perform regular database maintenance activities such as backup, restore and setup of jobs.

Created complex queries using joins and sub-queries.

Deployed database objects to production.

Extensive knowledge in design and best coding practices.

Developed reports using SQL Server Reporting Services.

Part of the data extract, transformation and load activities using integration services.

Worked as a team member, actively involved in development.

Working with the Client teams in debugging performance issues and suggesting improvements in

all the areas including but not restricted to infrastructure setup, web-server setup, database

server setup and all the various components of the software in question.

Designed re-usable classes which can be consumed across other projects as well.

Environment: SQL Server 2012, SSRS, MS Excel, Windows Server 2008 R2

Contact this candidate