SUMMARY

• Having 7+ years of IT industry, experience inQlikView10, 11.x, 12.2 and Qlik Sense 3.2 Dashboard Development involving UI design, Qlik scripting and Data Modeling.
• Complete life cycle development experience including Requirements gathering, Planning, Analysis, Design, Implementation and Maintenance usingQlikView/Qlik Sense.
• Proficient in creating QV data models, QV objects, Adhoc Reports and Data Visualizations using different data sources like SQL Server, QVD files using incremental load, Access, text files, excel documents, Cross tables etc. as per teh user requirement.
• Experience using different dimensional data models (Star, Snowflake, Data islands) based on need.
• Worked on multiple Full Life Cycle Developments including Planning, Data Warehousing, Analysis, Design, Implementation, Testing and Production Support forQlikViewapplications.
• Thorough understanding onQlikViewSecurity, Architecture and Design components, User Profiles, and Authentication Mechanisms.
• Extensive noledge on Data modeling, Dimensional Modeling, Star/Snowflake Modeling, Data Marts, OLAP, FACT & Dimensions tables, Physical & Logical data modeling, Data Warehousing.
• Expertise in DevelopingQlikViewData Models using various data sources like Oracle, Teradata, SQL Server, Inline Load, QVD files, text files and excel documents.
• Used Dimensions tables and Fact tables in Data Modeling.
• Worked on data modeling and developed different complex models as per given user requirement wifout any closed loops, synthetic tables and ambiguous relationships.
• Experience wifQlikViewsheet 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.
• Designed TEMPeffective KPI Dashboard (Gauges, Text Objects and Charts) that halps management to make faster and better decisions.
• Expertise in UsingQlikViewFunctions (Date and Time, Keep, Join, Mapping, String & input Fields etc and subroutines.
• Implemented security usingQlikViewsection access technology that dynamically hides selected areas of teh dashboard depending upon user privileges.
• Involved in implementing Application level, Sheet level and Object level Security wif Section Access method.
• Implemented triggers using macros to provide custom functionality in Dashboards.
• Expertise in Optimizing teh existingQlikViewDashboards wif a focus on usability, performance, flexibility, testability, and standardization by using Document Analyzer.
• Experienced in SET Analysis to improve teh calculation times on teh UI.
• Experience inQlikViewServer and Publisher maintenance - scheduling and monitoring Incremental Loads and Report Reloads.
• Well Versed wifQlikViewreporting using NPrinting.
• Knowledge of Extension Objects.
• Familiar wif SDLC, Agile methodology and Waterfall methodology.
• Scheduled Data Extractions, Data Model and Dashboard Reloads usingQlikViewManagement Console (QMC).
• Developed QlikSense applications using various Qlik Sense extensions to reach teh expectations.
• Excellent analytical, co-ordination, interpersonal, leadership, people, organizational and problem solving skills, ability to adapt, learn new technologies and get proficient in them very quickly.
• Experience in data integration of various data sources from Databases like MS Access, Oracle, SQL Server and formats like flat-files, CSV files and XML files.

TECHNICAL SKILLS

Reporting Tools: QlikView 12x, 11x, 10, Qlik Sense 3.2,QlikView Publisher, Extension objects, Nprinting 16/17, Enterprise Management Console, Management Console, QV Ajax Client, QV IE Plug-In.

Operating System: Windows, UNIX

Environment: Client/Server

Tracking Tools: JIRA

DBMS: DB2 V8.1, DB2 V9.0, Oracle 9i, Oracle 10g and MS Access DB2 V8.1, DB2 V9.0, Oracle 9i, Excel & .CSV Files.

Database: Oracle, SQL Server, DB2 & Teradata.

ETL Tools: Datastage 9.x/8.x

Languages: SQL, Oracle PL/SQL, Python.

PROFESSIONAL EXPERIENCE

QlikView/QlikSense Developer

Confidential, EverestRe, NJ

Responsibilities:

• Generated QlikView reports to analyze data from multiple data sources like Oracle, Access, Excel, Flat Files, etc.
• Involved in full project life cycle implementation (requirement gathering to production) Qlik Sense dashboards.
• Participated on business requirement document preparation.
• Responsible for Self-Business analysis tool Qlik Sense initial setup and end to end development of Qlik Sense applications.
• Security and mobile ability enabling and taken care of QlikSense QMC, repository and hub access.
• Involved in designing teh data models, extract & transform teh data from heterogeneous data sources like QVD files, Excel, SQL Server, Oracle, binary QVW, Inline & txt files in creating teh Qlik Sense dashboards.
• Connected to different ODBC, OLE DB data sources (SQL Server, Oracle) and flat files to create and schedule different complex reports as per given business requirement by leveraging teh basic components of Qlik Sense.
• Generated reports, dashboards using QlikView desktop and web client.
• Maintained QlikView applications.
• Created multiple tab dashboards. Created Pivot tables, Trend graphs, Bar graphs, Stacked Graphs, containers and so on.
• Involved in Extracting, Transforming and Loading data from different data source.
• Worked on Incremental load, SET Analysis.
• Developed reports usingchartsand reports as per teh customer requirement depends on Quarter, monthly and analyzes teh report wif charts provided byQlikView.
• Used scripting, set analysis, aggregation functions and charts for applications
• Have noledge in writing teh Load scripts for QlikView.
• Worked on writing SQL Scripts to load Data in QlikView Applications.
• Assist in resolving teh issues/cases raised by teh users for this application.
• Involved in Dashboard development & Testing.
• Create, manage, clone, and delete nodes in Qlik Sense sites that are deployed in cloud computing environments.
• Worked on large scale and data volume based applications.
• Developed SET ANALYSIS to provide custom functionality in QlikView Applications.
• Loaded Data into QlikView application from different QVDs excel files, database and external files.
• Created QVDs by importing data from teh database tables using QlikView script.
• Worked on Incremental Loading to reduce teh reload time of different applications.
• Involved in designing technical specifications, development, deploying, testing.
• Maintenance and Modification of pre-existing applications.
• Having proven abilities in design, testing and production, support for successful execution of projects on QlikView.

Environment: QlikView 12.2, Qlik Sense 3.2, NPrinting, Oracle 10g, flat files, Windows 2007, XP, SQL Server, HTML, MS-Excel.

QlikView/QlikSense Developer

Confidential - Tinton Falls, NJ

Responsibilities:

• Actively participated wif business users and functional team to understand teh reporting requirements and worked on all phases of teh project.
• Supported in modifying, testing and implementation of existing reports.
• Extensive experience in creating QV data models, QV objects, reports, graphical interactive UI and dashboards using Qlik Sense from multiple data sources like SQL, Oracle and Flat Files (XML, CSV, Excel).
• Developed scripts for data reloading, mapping and transformation by using joins, concatenations, resident loads and temporary tables.
• Performed redesign of teh existing Qlik Sense BI associative model to improve availability, scalability and performance by eliminating synthetic keys and circular loops in teh data model.
• Optimized existing data models including changing load scripts to load data in optimized way to achieve reduction of loading time, simplifying complex expressions in teh front-end, improving layout structure.
• InteractedwifCustomersforrequirement gathering,TEMPeffectiveanalysisand also to provideend-user training.
• Well-versed in developing reporting applications usingcognos Business Intelligence components like Report Studio, Framework Manager, Query Studio, Analysis Studio, Metric Studio and Cognos Connection.
• Involved in a data migration process between different versions of cognos. migrated Reports from COGNOS 10 to QlikView.
• Migrated applications fromQlikviewenvironment to Qlik Sense.
• Developed GUI using Extension Objects from Qlik Branch, Variables, charts, Filter pane, Text objects, map, KPI etc. on Qlik Sense.
• Used Qlik Sense Functions (Cross tables, Date and Time, Join, Aggregation, Range, Ranking, Peek, Previous, Class, First Sorted Value etc.) and Created Variables using LET, SET or control statements in teh scripts.
• Worked wif various Sheet Objects, Charts (including Drill Down and Cyclic field grouping), Treemap, Waterfall chart, Histogram and Master Calendar.
• Implemented Incremental load for teh update of QVD's, used Set Analysis for aggregations at granular levels.
• Considered best practices of Qlik Sense and created heat map and KPI graphs.
• Creating binary loads for quick reloading of applications.
• Hands-on experience in implementing new features like Creating Stories, Pivot Table, KPI Object etc. in Qlik Sense.
• Conducted training sessions to users about teh functionality and usage of application.
• Created and Scheduled WeeklyQlikViewcustom reports extensions to distribute on email using NPrinting.

Environment: QlikView 10, Qlik Sense 3.0, NPrinting, Cognos 10, Oracle 10g, Windows 2007, XP, SQL Server, HTML, MS-Excel.

BI/ QlikView Developer

Confidential

Responsibilities:

• Gathering and documenting requirements from teh users and developed Complex Graphical User Interactive reports using variousQlikViewObjects.
• Strong Skills in Data Modeling & Loading data from multiple data sources.
• Worked wif Incremental Loading &QlikViewdocument Versioning.
• Developed executive dashboards inQlikViewdelivered through teh web, enabling to measure teh performance of teh business wif analytical capabilities.
• Dashboards were served to track inventory and sales as well as to monitor various KPIs. Dashboards included customer detail drilldowns, threshold gauges.
• Experienced inQlikViewServer and Publisher maintenance - Creating scheduled jobs for QVD extracts and report reloads.
• Worked on requirement specifications for teh strategic KPI's that drive performance and profitability in teh division. Waterfall methodologies were followed during course of teh project.
• Performed analysis, documentation for calculation for various attributes.
• Performance tuning of dashboards was carried out to limit teh response time to well under 2 seconds.
• Implemented Section access and hidden scripting for teh 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 wif Alternate state for data visualization.
• Developed KPI's, User Interactive Sheets as needed by teh business.
• Identified teh highly memory consumption objects and performed necessary steps to reduce memory used by objects.
• Analyzed end user requirements and developed technical solutions.

Environment: QlikView 10, Windows Server, MS-Access, SQL, and XML.

QlikView Developer

Confidential

Responsibilities:

• Worked directly wif business users to define and prototype QlikViewApplications.
• Worked wif senior management to plan, define and clarify dashboard goals, objectives and requirement.
• Gathered, Analyzed, and transformed business requirements of teh Client into logical and physical BI solutions.
• Provided technical leadership inQlikViewBI/DW design, dashboard and KPI metrics design, data modeling, QlikView SAP integration, QlikView scripts development, QlikView Set Analysis and QlikView Server/Publisher setup/configuration.
• Participated in project planning, documentation, budgeting, and requirement analysis.
• Applied Scrum methodology in teh system development process.
• Worked wif cross functional team and business user to develop Business requirement document (BRD), define key performance indicators (KPIs) and identify data sources.
• Conducted requirements gathering and developed strategy maps and roadmaps for delivering Data Analytics and BI Reporting via QlikView in-memory technology.
• Designed and developedQlikViewsoftware applications and server-basedQlikViewdashboards from scratch to support BI initiatives.
• Hands-on experience in setting up new task and troubleshooting existing task setup and other issues.
• Designed and developed BI Reporting solution enabling users to TEMPeffectively utilize teh tools to create Analytical Reports, Dashboards, and Scorecards, halping clients align KPIs performance metrics to strategic drivers and priorities.
• Identified data sources and targets for data modeling and solution architecture.
• Implemented new production methodologies that resulted in optimizing employee's time to finish teh tasks, thus enhancing employee efficiency.
• Created automatic schedulers to reload teh data as per requirements.
• Developed predictive analytics and forecast models to halp clients gain deeper insights on existing data and information, improve business performance, and shape teh future of teh companies.
• Worked closely wif teh development team to understand functionality, resolve issues and provided feedback for teh UML diagrams.
• Extracted data from multiple complex hierarchies from cross tables, flat files and websites.
• Provided ongoingQlikViewconsultation to teh development team.

Environment: QlikView 7.0/8.0, OBIEE, Informatica, Oracle, Windows, QlikView Server and Publisher, QlikView Developer, Real-Time BI Analysis, Microsoft SQL Server, SSIS, SSRS, Oracle Database, SAP Business Objects, Crystal Reports, Cognos.