Qlik view developer

Vijaya B

adb05i@r.postjobfree.com

732-***-****

Objective:

Self-motivated and enthusiast in learning new technologies with 5+ years experience in Information Technology having strong ability to manage and manipulate databases and build visualizations according to the user needs.

Professional Summary:

Experience as software engineer in Business Intelligence applications, ETL Tasks and Data Warehousing.

Expertise Designing and Development of Business Intelligence applications with QlikView 12.10/11.2/10.0 as BI tool and preparing dashboards using Qlik sense November 2017, April 2019 Versions.

Extensive experience in developing different analytical applications using QlikView suite of Products (QlikView Server, Publisher and QlikView Enterprise).

Good experience in Qlik sense latest concepts like Data profiling, Storytelling, Mash ups and N printing.

Good knowledge on Tableau Data Modelling and Report design concepts.

Expertise in generating and printing Ad hoc reports in Qlik View.

Experience in using QVW, QVD, QVX and QVF (Qlik Sense) files effectively.

Experience with Qlik Sense sites, Qlik Management Console (QMC), Qlik Sense Operations and License Monitors, & Qlik Sense Audit logs.

Strong experience in creation and Scheduling of tasks in Qlik Management Console (QMC).

Expertise in Creating Dashboards using QlikView &Qlik Sense using different data sources like SAP, Oracle, Hadoop, SQL Server, QVD files, SharePoint, text files, excel and generated dashboard as per the user requirements.

Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Cyclic Group menu option and Parameterized using QlikView.

Ability to offer end-to-end solution starting from requirement gathering, design, development & deployment of Business Intelligence applications. Experienced with Agile Development Methodology in providing quick analysis and visualizations for business users.

Experience with QlikView objects including multiple charts types, Trends, KPI’s, Bookmarks, Pivoting, custom requests for Excel Export, Fast Change and objects for Management Dashboard reporting and other KPI’s.

Created QVD’s & updated on timely basis as database updates. Developed ETL Scripts while loading the data, resolved Circular Relationships, Synthetic Keys.

Involved in Optimizing existing QlikView dashboards with a focus on usability, performance, long-term, flexibility, and standardization.

Strong experience in writing SQL Queries, Views, and Stored Procedures.

Self-Starter with excellent communication and interpersonal skills.

Technical Skills:

BI Tools

QlikView (11.x,12.x/10.x), Qlik Sense

SQL Tools

Toad, SQL Developer

RDBMS

Teradata, Oracle, SQL Server, Access

Documenting and Data Modeling Tools

MS Office (Word/ Excel/ Access/ Power Point), MS SharePoint

Scripting/Lang.

HTML, SQL, PL/SQL, C, C++, JAVA

Operating Systems

Windows XP/ Net/2000/ Vista/7, UNIX

EDUCATION:

MTech in Computer Science and Engineering 2013, JNT University

Professional Experience:

Mauser Packaging Solutions, NJ Jul 2019 -Till Date

Qlik View/Qlik Sense Developer.

Responsibilities:

Involved in gathering requirements from clients.

Involved in developing, enhancing, maintaining and supporting QlikView applications.

Actively participated in gathering requirements meeting and trained power users about Qlik capabilities.

Used Mapping Loads to eliminate certain dimension tables and reduce the number of tables and complexity in the QlikView data model.

Building QVD's from different data sources like SQL Server, Oracle, Excel, CSV and Flat Files.

Simplifying complex expressions in the front-end and improving performance.

Created ad-hoc reports in QlikView and supported the users with the ad-hoc reporting queries.

Providing demo of QlikView dashboards to users to enhance their knowledge on all the key capabilities of QlikView application

Creating and modifying Business Intelligence analytical reports/dashboards using Qlik view Desktop.

Imported data from SQL Server and flat files, Excel files.

Created and designed Win-Loss Report in Qlik View using multiple data sources using month end analysis.

Worked directly with sales and business team members in understanding requirements.

Demonstrated efficiency of the Qlik View to the business team and trained them to reach their expectations.

Implemented three tier Qlik Architecture (Extraction, Transformation and Data model/Presentation) and followed best practices.

Used Line charts to show comparison between Wins & Losses.

Ensured security of Qlik View Reports by providing access to assigned users at both user and admin group level using Section access.

Worked in Agile methodology and followed sprint ceremonies.

Handled simple data model comprises of 3-4 tables through complex data model comprise of 25-30 tables.

Optimized Qlik View performance by creating QVD’s from data warehouse and setting up incremental reload which reduced load on Database Server.

Identified bugs in existing reports and enhanced visualizations for ad-hoc requirements.

Implemented both Star Schema and Snowflake Schema for Dimensional Data Modeling in Qlik View.

Developed Qlik View dashboards based on DAR (Dashboard Analysis and Reporting) principle using chart (Drill down and Cyclic Grouping), List box, Input Field, Table box, Calendar, Date Island etc.

Used various Qlik Objects like Input boxes, Pivot tables, Straight tables, Bar charts, Buttons, Multi boxes on the UI to make it more accessible to user community.

Involved in full project life cycle implementation (requirement gathering to production) of QlikView dashboards.

Created Unit Test Cases and documented the Unit Test Results.

Identified bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing. the bugs so that business needs meet. Redesign the existing mappings for improving the performance.

Developed Qlik Sense using different Charts like bar chart, Line chart, Grid chart, Drill down, Cyclic Groups, List, Table Box, Container.

Implemented Security & involved in Deployment of Qlik Sense Applications.

Developed extensively Alerts, Variables, Input boxes, calendar & Macros.

Developed load script using Qlik Sense Functions (Date and Time, Keep, Join, Mapping, String, Interval match etc...)

Developed Linked Tables using Concatenation and solved the loops issues.

Gathered & loaded data into Qlik Sense from various data sources (Oracle 11g and excel files).

Used to solve the issues related to the end users.

Working knowledge of Qlik View Server, Qlik View Publisher, Qlik Sense and Qlik View Enterprise Version.

Implemented advanced SET Analysis for aggregation calculations so that set of records can be defined in an expression.

Worked on Qlik Sense QMC and provided security to Qlik Sense apps by using Security rules.

Expertise on Qlik Sense concepts like Mash ups, Storytelling and Nprinting.

Environment: QlikView 11.x, QlikView 12.x, Qlik Sense, Oracle, SQL Server, MS Office Suite (Word, Excel, PowerPoint).

Gen Re, Stamford, CT Oct 2018 – Jun 2019

QlikView Developer.

Responsibilities:

Interacted with the Customer Support Group for domain requirements gathering.

Involved in defining the whole project life cycle, following agile methodology. Analyze business requirements and segregated them into high level and low level

Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.

Thoroughly analyzed the current Architecture, databases and designed schemas.

Creating and modifying Business Intelligence analytical reports/ dashboards using Qlik View Desktop.

Installed and Deployed Qlik sense application to create dashboard. Also, created very complex Dashboards using the drill down, drill across, actions for business steering committee.

Implemented Star Schema & Snowflake schema for Dimensional Data Modeling in QlikView

Imported data from different sources like Teradata, SQL Server, MS Access, XML files and flat files using OLE DB/ODBC.

Managed schedules and reloading of QlikView data model QVDs and QVWs through QlikView server.

Created user interface reports using QlikView sheet objects like List Box, Input Box, Buttons, Text Input, Slider, Bookmarks, Charts (Pivot/Straight tables, Pie, Bar, Line etc.)

Generated QlikView reports and published them for business steering committee.

Developed Drill through Dashboards which enabled users to drill down between dimensions.

Showed the statistics in bar charts and pie charts as per the client needs.

Created Unit Test Cases and documented the Unit Test Results.

Created and Scheduled Weekly QlikView custom reports extensions to distribute on email using NPrinting.

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

Involved in the daily standup with business analysts and data architect to resolve the business issues and Data challenges. Worked independently and capable of multitasking & prioritizing in a fast paced and agile work environment.

Extensively used Nprinting17 (November 2017 and February 2018 Versions) for PDF Notices for both Batch and On Demand Processing.

Based on each requirement from business, implemented security using Qlik functionalities like Section Access and loop & reduce etc.

Worked on the creation of tasks at Qlik View Publisher.

Hands on experience on the third-party extension Qlik Maps. Created maps based on spider analysis, custom pop up which displays charts etc. both in QlikView & Qlik Sense.

Prepared extensively alerts, variables, input boxes, calendar & macros.

Involved in testing the database using complex SQL scripts and handled the performance issues effectively.

Environment: QlikView 11.x, QlikView 12.x, Qlik Sense, Oracle, SQL, MS Office Suite (Word, Excel, PowerPoint).

Synovus Bank, Columbus GA Oct 2017– Sep 2018

Qlik Sense Developer, Administrator

Responsibilities:

Communicated with the business users to comprehend the requirements and Designed Functional

Requirement Specifications for application development.

Developed Qlik Sense using different Charts like bar chart, Line chart, Grid chart, Drill down, Cyclic Groups, List, Table Box, Container.

Implemented 3-layer architecture different load scripts so that data stored as QVD’s. Many QVD files will be shared between applications build an elaborate structure.

Implemented Security & involved in Deployment of Qlik Sense Applications.

Developed extensively Alerts, Variables, Input boxes, calendar & Macros.

Developed load script using Qlik Sense Functions (Date and Time, Keep, Join, Mapping, String, Interval match etc...)

Developed Linked Tables using Concatenation and solved the loops issues.

Gathered & loaded data into Qlik Sense from various data sources (Oracle 11g and excel files).

Used to solve the issues related to the end users.

Working knowledge of Qlik View Server, Qlik View Publisher, Qlik Sense and Qlik View Enterprise Version

Implemented advanced SET Analysis for aggregation calculations so that set of records can be defined in an expression.

Worked on Qlik Sense QMC and provided security to Qlik Sense apps by using Security rules.

Identified bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs so that business needs meet. Redesign the existing mappings for improving the performance.

Responsible for the performance and tuning of the application, including performing maintenance/upgrades on applications programs and systems as required.

Responsible to ensure that all assigned systems and application are defined and tested backup and recovery procedures for critical data.

Coordinated with Team Members in development process to integrate with the Test and Production Servers and helped creating use cases.

Involved in Production Support for Qlik Sense applications& Server.

Used TOAD, Squirrel to run SQL queries and validate the data in Data warehouse and Data Marts.

Conducted end user training sessions and prepared the training documentation.

Environment: QlikView 11.0, 11.2,12 Qlik Sense 2.1,3.0 SAP BW, SQL Server, SharePoint, MS Project, MS Office Suite (Word, Excel, PowerPoint), NPrinting.

ACS Xerox, Little Falls, NJ Oct 2016 – Sep 2017

QlikView Developer

ACS develops software and hospital-wide solutions, combined with comprehensive services to more than 1,000 hospitals nationwide, from large multi-facility hospital systems to independent community facilities, result in a powerful, holistic offering designed to help hospitals improve operations, patient flow, care and revenue.

Responsibilities:

Strong understanding in creating scoreboards and KPI’s in QlikView.

Developed load scripts to work with multiple data sources (SQL, Flat Files, Excel, and MS Access).

Developed production-grade QlikView reports and dashboard to meet business requirements in timely manner.

Optimized QlikView performance by creating QVD’s from data warehouse which reduced load on Database Server.

Worked with business clients to confirm and clarify requirements and business logic.

Designed, developed, implemented and tuned multiple QlikView applications for the Healthcare Operations.

Working on Microsoft Excel, Access to automate the process by creating/modifying Macros as per the requirements.

Conducted User Acceptance Testing as part of SDLC process.

Involved in full project life cycle implementation (requirement gathering to production) of QlikView dashboards.

Connected to various data sources like Oracle, SAP BW and flat files to create and schedule different complex reports.

Hands on retrieving of external data in terms of incremental loading of extract scripts for QVDs by making connection through FTP, ODBC and OLEDB.

Sound understanding of relational, object and dimensional databases.

Developed QlikView Dashboards based on DAR (Dashboard Analysis & Reporting) principle using Chart (Drill down & Cyclic Grouping), List Box, Input Field, Table Box, Calendar, Date Island etc.

Analogics Tech, Hyderabad, India Apr 2014 - Mar 2016

Role: SQL Developer/Qlik Sense Developer

Responsibilities:

Involved in User requirements and Documentation.

Provided support and enhancement of national rental property listing database applications.

Performed production system software installations.

Derived and documented process application business rules.

Created files, views, tables and data sets to support Sales Operations and Analytics teams.

Understanding business data model having multiple schemas, each for an application.

Write complex queries and procedure adhering to design document.

Provide ad-hoc results by querying the database.

Perform basic query optimization.

Analyzing production issues arising from database queries of the applications.

Developed Qlik Sense using different Charts like bar chart, Line chart, Grid chart, Drill down, Cyclic Groups, List, Table Box, Container.

Implemented Security & involved in Deployment of Qlik Sense Applications.

Developed extensively Alerts, Variables, Input boxes, calendar & Macros.

Developed load script using Qlik Sense Functions (Date and Time, Keep, Join, Mapping, String, Interval match etc...)

Developed Linked Tables using Concatenation and solved the loops issues.

Gathered & loaded data into Qlik Sense from various data sources (Oracle 11g and excel files).

Used to solve the issues related to the end users.

Working knowledge of Qlik View Server, Qlik View Publisher, Qlik Sense and Qlik View Enterprise Version.

Implemented advanced SET Analysis for aggregation calculations so that set of records can be defined in an expression.

Worked on Qlik Sense QMC and provided security to Qlik Sense apps by using Security rules.

Coordinated with Team Members in development process to integrate with the Test and Production Servers and helped creating use cases.

Involved in Production Support for Qlik Sense applications& Server.

Environment: Oracle 9i/11G, Qlik Sense, SQL Server 2008, Access, CSV Files, Windows 2008 Server, SharePoint.

Contact this candidate