We provide IT Staff Augmentation Services!

Sr. Qlikview / Qliksense Developer Resume

Buffalo, NY

SUMMARY:

  • Over Eight (8+) years of referable IT experience in Architecture, Analysis, Design, Development and Implementation of QlikView and QlikSense Applications.
  • Expert 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.
  • Experience 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.
  • Expertise in design & implementing 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 analyze complex SQL queries.
  • Effective in training end users properly 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.
  • Extensive experience in using Microsoft BI Studio products for implementation of ETL methodology in data extraction, transformation and loading.
  • Versatile team player with excellent analytical, presentation and inter personal skills with a strong ability to quickly learn and adapt to new project environments.

TECHNICAL SKILLS:

Dashboard / Analytics: QlikSense, Qlikview 11.0/10.0/9.0, QlikSense 2.0, Tableau, Microsoft SSRS, Cognos, Power BI, Tibco, Spotfire, 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, Cognos, SSIS, SSRS

Operating systems: Windows7/XP/Vista, Windows 2000/2003/2008 Server, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Buffalo, NY

Sr. QlikView (QlikSense) Developer

Responsibilities:

  • Involved in the Requirements gathering, analyzing, and documenting business requirements and data specifications.
  • Implemented Star Schema & Snow Flake for Dimensional Data Modelling in QlikView and QlikSense.
  • 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, QlikSense, NPrinting, QlikMaps, SQL Server 2008 R2, MS Access, MS Excel, Flat Files, Windows Server 2008, CSV Files, Oracle 10g, SQL Scripting

Confidential, Atlanta, GA

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.
  • Extracted data from the database, stored into QVD files, and wrote load scripts.
  • Eliminated Synthetic keys, ambiguous relationships and closed loops. Designed proficient dashboards according to the requirements.
  • Enhanced existing dashboards with new functionalities and established a secure environment using QlikView Section Access.
  • Implemented drill down and cyclic dimensions.
  • Worked with bulk volumes of data and extracted them from various sources like excel, Oracle, SQL Server through ODBC and OLEDB connections.
  • Interact with senior managers for gathering requirements and presenting them with Health insurance analytical information.
  • Developed dashboards for data analysis with strong programming skills.
  • Created 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.
  • 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.
  • Optimized QlikView dashboards and built QlikView extensions.
  • Working with all types of data loads and functions like Automap.
  • Debugging the QlikView server issues through server logs, Fiddler logs.

Environment: QlikView 10, QlikView dashboard, Business Objects, SVN, Oracle 10g/11g, Subversions, MS Access, MS SQL Server, Agile Methodology

Confidential, Bloomfield, CT

QlikView Developer

Responsibilities:

  • Interacted with senior managers for requirements gathering and presenting them with analytical information.
  • 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.
  • Developed dashboards for data analysis with strong programming skills.
  • Created dashboards by extracting data from database write and externalized the load scripts, store the data as QVD files.
  • Optimized 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.
  • Use of Set analysis and aggregation functions for sheet objects.
  • QlikView data modeling by building the Star schema and resolving loops/synthetic keys.
  • Implemented the Various scenarios of section access.
  • Created mock up with the sample data. Created model with Extract, Transformation and Data Model in QlikView.
  • Use of Set analysis and aggregation functions for sheet objects.
  • 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
  • Debugged the QlikView server issues through server logs, Fiddler logs.

Environment: Qlikview11, QV publisher, QV access points, QMC, QVWS, SQL server2008, CSS, HTML

Confidential, Libertyville, IL

QlikView Developer

Responsibilities:

  • Responsible for interacting with the Business Users regarding information about the Project Deliverables, and on finalizing System and Reporting Requirements.
  • Highly involved in working with Multi-Dimensional Model, Star & Snow Flake Schemas and other Data Modelling and Data Warehousing applications.
  • Created and Monitored Batch processes and Sessions.
  • Created Proof of Concepts, Prototypes, and Business rule documents.
  • Designed and populated Time hierarchy, Geography hierarchy, and Transformation tables.
  • Scheduled the created reports to users by creating Narrowcast Subscriptions and Services.
  • Tested Micro Strategy Reports.
  • Responsible for designing and executing Application objects and Schema objects using Micro Strategy Desktop.
  • Retrieving of external data to QlikView Dashboard in terms of QVDs by making connection through ODBC and OLEDB.
  • Developed different types of dashboards using QlikView like charts Bar charts, Line charts for Trend Analysis, Straight, Tables, Pivot Tables, Pie Charts etc.
  • Responsible for efficient design and usage of various attribute dimensions like Customer, Product, Payment, Geographic and Time dimensions, and integrating them into reports displaying forecasting metrics.
  • Designed and deployed customized reports and Documents into Micro Strategy web.
  • Actively involved in creating Advanced Reports in the desired formats (Grid, Graph, or SQL) involving multifaceted data analysis using Micro Strategy Desktop and Web.
  • Responsible for improving the performance of the reports by efficient usage of Data Marts and Report Cache Sharing.
  • Involved in extraction of data from different Sources like SQL Server, Oracle, Flat Files into Teradata Global Repository Database, using Informatics.

Environment: Micro Strategy 7.5 (Administrator, Architect, Desktop, Object Manager), SQL Server, Informatica, Oracle 9i, HTML & DHTML

Hire Now