Candidates About

Preethi

Sr. Qlikview/QlikSense Developer

 

 

PROFESSIONAL SUMMARY:

●      8+ Years of real time IT experience in Architecture, analysis, design, development and implementation of QlikView and QlikSense applications.

●      Including 4+ years of experience as a QlikView Developer.

●      Extensively worked on QlikView to implement applications as per client requirement

●      Expertise in QlikView performance optimization.

●      Strong experience in designing and developing dashboards using QlikView by extracting data from multiple sources (Oracle, Flat files, Excel, Access).

●      Extensively worked on Data Analysis/Mining using QlikView.

●      Worked on different QlikView objects like straight tables, line charts, bar charts and pivot tables Etc.

●      Expertise in Installing and Configuring QlikView/QlikSense Desktop, QlikView/QlikSense Server, QlikView Publisher and also QlikSense Server.

●      Designed and implemented the Incremental Loading using QVDs so that instead of reloading the entire data from the database, QlikView would only load the data worth of one day and concatenate it to the Old Data which is already stored in QVDs.

●      Expertise on set analysis, advanced aggregation and section access.

●      Hands on Experience with QlikView Architecture in development and deployment.

●      Expertise in the Qliksense SDLC and governance.

●      Extensive experience with QlikView sheet objects, scripting, and optimizing applications and building QVD’s and QVW’s.

●      Extensive experience in using NPrinting for quick generation of reports and QlikMaps analytics engine.

●      Can write and analyse complex SQL queries.

●      Trained the end users effectively to use the reporting tool, to build and customize their ad-hoc reports. 

●      Strong understanding of Dimensional Modelling technique, Multi-Dimensional Database Schemas like Star, Snowflake Schema, Fact and Dimensional tables, Automation and Macros interface, Section Access, Set Analysis in QlikView and DW concepts.

●      Job roles include gathering business requirements, establishing functional specifications, translating them to design specifications.

●      Extensive experience in using Microsoft BI Studio products for implementation of ETL methodology in data extraction, transformation and loading.

●      Improved Performance of the queries by creating Clustered and Non Clustered Indexes and by optimizing the T-SQL statements using MS SQL profiler, Job Activity Monitor and Performance monitor. 

●      Developed Triggers, Stored Procedures and Functions for the custom database objects. 

●      Customized and optimized the existing stored procedures according to the Technical specifications and performed performance tuning on the existing stored procedures using performance monitor, SQLprofiler, query execution plan, Query Analyzer.

●      Extensively used triggers, transaction in stored procedures which involves complex joins and Sub-Queries to simplify complex queries involving multiple tables.

 

 

TECHNICAL SKILLS:

 

Dash boarding/Analytics	QlikSense, Qlikview 11.0/10.0/9.0, Tableau, Microsoft SSRS, Cognos, Power BI, Tibco Spot fire, Micro Strategy, Crystal Reports.
Languages	SQL, T-SQL, PL/SQL, C, C++
Database Technologies	SQL Server, Oracle 10g/11i, SQL Server, Toad, Teradata, DB2, MS Access.
ETL Tools	Informatica, SSIS
Operating Systems	Windows7/XP/Vista, Windows 2000/2003/2008 Server, UNIX

 

 

EDUCATION:

 

Bachelors in Information Technology from JNTUH, Hyderabad, India

 

PROFESSIONAL EXPERIENCE:

 

Client: Exelon, Philadelphia, PA                                                                                                       Mar 2017- Till Date                                                                                                     

Role: Sr. QlikView /Qliksense developer

 

Responsibilities:

 

•          Responsible for Building, publishing customized interactive reports and dashboards, report scheduling using QlikView server.

•          Experience in working with QlikView server to create data sources, creating users and QlikView installation   and   providing training to Business users in using QlikView.

•          Have Experience in deploying advanced metering infrastructure (AMI) systems in centralized operations centres that provide real-time, end-to-end monitoring, analysis and management of the systems.

•          Have Experience in management responsibilities for a component of the AMI system to include the meter data management (MDM), information technology (IT), communications and metering hardware.

•           Responsible to convert all business objects and excel reports to QlikView reports and dashboards.

•           Created metrics, attributes, filters, reports and dashboards, created advanced chart types, visualizations and complex calculations to manipulate the data. 

•           Experience in designing and deploying rich Graphic visualizations with Drill Down and Drop down menu option and Parameterization using QlikView.

•           Responsible for interaction with business stake holders, gathering requirements and managing the delivery, covering the entire QlikView development life cycle.

•          Responsible for Self-Business analysis tool QlikSense initial setup and end to end development of Qlik Sense applications.

•          Create, manage, clone, and delete nodes in QlikSense sites that are deployed in cloud computing environments.

•           Worked as QlikSense administrator to optimize Qliksense performance.

•           Involved in designing the data models, extract & transform the data from heterogeneous data sources like QVD files, Excel, SQL Server, Oracle, binary QVW, Inline & txt files in creating the QlikSense dashboards.

•            Worked with Dashboards style of reports using all the QlikView components like List Box, Slider, Buttons, and Charts etc. 

•          Developed Set Analysis to provide custom functionality in QlikView applications 

•          Worked towards optimal development of universe by resolving loops through the use of aliases and contexts. 

•          Created daily, weekly, monthly and quarterly reports for the management team based on the Customer requirements. 

•          Experience in Qlikview Server and Publisher maintenance - Creating scheduled jobs for QVD extracts and report reloads. 

•           Involved in to create Hierarchies from providing dill down options for the end-user. 

•          Worked with Sheets and Sheet Objects in QlikView. 

•          Designed and delivered complex dashboards.

•          Expertise in ETL (Data Extraction, Transformation & Loading), Data modelling, Report designing and Performance Tuning using QlikView. 

•           Experience in all phases of project life cycle. 

•          Generate QVD files created by ETL logic to feed QlikView applications 

•          Experience in Incremental Loading & QlikView document Versioning. 

•          Strong understanding of Dimensional Modelling technique, Multi-dimensional database Schemas like Star Schema, Snow flake Schema, Fact and Dimensional tables, Section Access, Set Analysis in QlikView and DW concepts.

Environment: QlikView 13,QlikMaps, Qlik Sense 3.1, SQL Server 2008 R2, MS Access, MS Excel, Flat Files, Windows Server  2008, .PL/SQL, CSV Files.

 

 

 

Client: Verizon, Atlanta, GA                                                                                                                 Aug 2015- Feb 2017                                                                                              

Role: Sr. QlikView (QlikSense) Developer

 

Responsibilities:

·         Involved in the Requirements gathering, analysing, and documenting business requirements and data specifications.

·         Implemented Star Schema & Snow Flake for Dimensional Data Modelling in QlikView and QlikSense.

·         Responsible for the QlikView Dashboard & Report development, which includes dashboard design /QlikView Script writing.

·         Created optimized QVD's which loads faster and helps to improve the performance. 

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

·         Distributed QV reports using NPrinting in the form of Excel/PDF/Power Point/Word etc. to users through email or publish to a folder on the scheduled time. 

·         Experience in Nprinting Qlikview Reporting (NPrinting is the most advanced report generation, distribution and scheduling application for Qlikview). 

·         Have experience with Master Data Dictionary creation and maintenance.

·         Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages. 

·         Developed the high-end visualization Qlikview Dashboards using Qlikview objects.

·         Built the SSIS reports and extracted data Using SSIS and transformed & loaded into QlikSense. 

·         Designed and developed various types of reports using SSRS and rendered them in front end applications like Excel and .Net. 

·         Developed reports in SQL Server Reporting Services (SSRS). 

·         Designing & developing of QlikView dashboards for Operations & Marketing business groups. 

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

·         Implemented the Various scenarios of section access and security levels.

·         Creating dashboards by extracting data from database and externalize the load scripts, store the data as QVD files and designing the UI based on business/user requirements.

·         Use of Set analysis and aggregation functions for sheet objects.

·         Installing, configuring and maintaining the QlikView infrastructure.

·         Used Set Analysis and various QlikView and QlikSense functions in writing expressions for sheet objects. 

·         Using QlikView and QlikSense functions such as Date and Time, Keep, Join, Mapping, and String & input Fields etc. 

·         Used QlikView Maps to show the reports and dash board for good visualization to the managers. 

·         QlikSense app performance optimization.

·         Designed the QlikSense Governance and development cycle.

·         Configured different QlikSense roles and attribute based access control

·         Performed architecture, redesign of QlikView / QlikSense  BI platform running 60+ dashboards that improving availability, scalability and performance to accommodate high volume data 

 

Environment: QlikView 11.2, QlikSense3.2, NPrinting, QlikMaps, SQL Server 2008 R2, MS Access, MS Excel, Flat Files, Windows Server 2008, .CSV Files, Oracle 10g,SQL Scripting.

 

 

 

Client: M&T Bank, Buffalo, NY                                                                                              Sep 2014 – Jun 2015                                                                                                                             

Role: Sr.QlikView /Qliksense Developer

 

Responsibilities:                             

·         Full life-cycle development and implementation of QlikView for a packaged Help Desk/Service Desk module. Involved in Analysis, design, installation & implementation of the BI solution. Converted and enhanced an older Oracle Discoverer BI solution and implemented QlikView.

·         Use of Set analysis and aggregation functions for sheet objects. 

·          QlikSense data modelling.

·         Hands on experience in implementing the new features of QlikSense like Story Telling, Beta maps integrations, Pivot Table, KPI Object etc. 

·         QlikSense app performance optimization.

·          Performance tuning by analyzing and comparing the turnaround times between SQL and QlikView/QlikSense. 

·         Designed the QlikSense Governance and development cycle. 

·         Configured different Qliksense roles and attribute based access control.  

·          Expertise in QlikSense data modeling, master items and maps 

·         Extracted data from the database, stored into QVD files, and wrote load scripts.

·         QlikView data modeling by building the Star schema and resolving loops/synthetic keys.

·         Used QlikView Scripting and Complex SQL coding for loading, and transforming.

·         Use of Set analysis and aggregation functions for sheet objects.

·         QlikView dashboards optimization.

·         Involved in analyzing existing complex systems to understand and document data elements, relationships, data flow, dependencies related interfaces and data visualization. 

·         Strong working experience in Load script and Data modeling.

·         Building the QlikView extensions.

·         Working with all types of data loads and functions like Automap.

·          Working experience with SQL/Server T-SQL, SSIS and SSRS (MSBI).

·         Enhanced existing dashboards with new functionalities and established a secure environment using QlikView Section Access.

·         Implemented drill down and cyclic dimensions.

·         Excellent knowledge of JavaScript, CSS and their behaviour on different browsers. 

·         Extract, transform, cleanse, and load (ETL) data into Microsoft SQL Server, Staging Databases using Microsoft SSIS. 

·         Developed dashboards for data analysis with strong programming skills.

·         Creating dashboards by extracting data from database write and externalized the load scripts, store the data as QVD files.

·         Use of Set analysis and aggregation functions for sheet objects.

·         Presented the Dashboard to Business users and cross functional teams, define KPIs (Key Performance Indicators), and identify data sources there were 4 million records with incremental loading of […] Enhancement and translation of the already existing Dashboards in Business Objects into QlikView. 

·         Debugging the QlikView server issues through server logs, Fiddler logs.

       Environment: QlikView 10, QlikView dashboard, Qliksense 3,Business Objects, SVN, Oracle 10g/11g, Subversions, MS Access, MS SQL server, Agile Methodology.

 

Client: Brightstar Corporation, Libertyville, IL                                                                         July 2013 – Aug 2014                                                                                 

Role: QlikView Developer

 

Responsibilities:

·         Creating dashboards by extracting data from database write and externalized the load scripts, store the data as QVD files.

·          Experience in generating of QVDs. 

·          Experience in working with QlikView Functions. 

·          Experience in Incremental Loading to reduce the reload time of QlikView applications. 

·         Developed Scripts to load the relevant Data in QlikView Applications. 

·          Implemented set analysis in QlikView Applications. 

·         Developed dashboards for data analysis with strong programming skills.

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

·         Data Extract would load the Data from the data sources into the QVDs, Data Model will define the relationships between the tables(QVD) and Application layer is User Interface Design layer where we layout all our Charts, Tables and List Boxes. 

·         QlikView data modeling by building the Star schema and resolving loops/synthetic keys.

·         Performance tuning of dashboards was carried out to limit the response time to well under 5 seconds on calculation and defining server sizing for optimal performance of QlikView dashboards. 

·          Maintain tested applications for quality assurance and production support. 

·         Creating mock up with the sample data, created model with Extract, Transformation and Data Model in QlikView.

·         Debugging the QlikView server issues through server logs, Fiddler logs.

·          Developed SQL scripts to load business data and used VB macros and set analysis to create customized reports for regulatory reporting.

·         Developed KPIs and set analysis application with QlikView functions (join, concatenate, keep, apply map). 

·          Performed different tasks like repeat tasks, reload tasks and distribution tasks using the QlikView publisher.

·         Gathering data sources like QVD files, Excel, Oracle & Teradata DWs, binary QVW, Inline & txt files in developing the QlikView Data Models.

·         Expertise in working with multiple modules of business with QlikView. 

·         Optimizing existing data models including changing load scripts to load data in optimized way to achieve reduction of loading time, simplifying complex expressions in the front-end, improving layout structure. 

·         Performed different tasks like repeat tasks, reload tasks and distribution tasks using the QlikView publisher. 

·         Stored the tables as QVDs and used Scripts to generate appropriate fields that help in modelling the data accordingly the requirements. 

·         QlikView data modeling by building the Star schema and resolving loops/synthetic keys.

·         <span style=