SUMMARY

• Around 8 years of total IT industry experience with over 4.5 years of Qlikview, Qlik Sense experience majoring in analysis, design, testing, development and implementation of client server applications.
• Experience covers areas of designing and development of Data warehousing and Business Intelligence applications.
• Solid Hands on experience in implementing the new features of Qlik Sense like Story Telling, Beta maps integrations, Pivot Table, KPI Object, PDF Printing etc.
• Data Visualization expertise in creating QlikSense application building on the Hub with good exposure to the QlikSense extension development.
• Developed different apps for Qlik Maps (Points & Polygon), Extension objects to let the user to explore best features in Qlik Sense and to compare with Qlikview.
• Expertise in designing data models from multiple data sources in Qlikview.
• Gained experience in creating mobile friendly POC’s using Qlik Sense.
• Experienced and worked on of Relational and Dimensional Database Concepts.
• Excellent understanding of data warehouse specific Architecture, Design and Procedures, ETL and Workflow Development, data cleansing, data quality validation and unit testing.
• Expertise in QlikView 11.x installation and upgrading existing version.
• Good Knowledge in managing and distributing User Access Pass (1:1 w.r.t Tokens) and Login Access Pass (1:10 w.r.t Tokens) on Qlik Sense Server
• Expertise in developing/designing Qlikview Dashboards with complex data sources like SQL, Oracle, Teradata, Sales Force, SAP BW/ECC, Cloudera HIVE/Impala, Flat Files(ranging from Excel, XML, CSV and files with fixed width) and optimizing applications by using QVD’s, removing non key fields and script variables that comes under Loading phase.
• Experience in designing QlikView Document/User Setting, Layouts to make consistent and professional optimized look to clients.
• Experience with QlikView sheet objects including multiple charts types, Trends, KPI’s, Bookmarks, Pivoting, custom requests for Excel Export, Fast Change Type and objects for Management Dashboard reporting and other KPI’s.
• Experience in creating ETL Applications for QVD’s and QlikView Scripting variables and File, Date, System, Mapping, and Table functions.
• Created data models for power users to create their own ad - hoc queries
• Expert in complete project lifecycle including developing, analysis, development and testing.
• 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
• Gathered fair understanding of Qlikview application administration encompassing Planning/ Implementing User, Resource and Password Management, Backup & Recovery Strategies, Performance Tuning, Creation and Configuration of database .
• Good working knowledge in the industry best practices including both business management and technology domains.
• Team orientedindividual with a result driven attitude, strong interpersonal and communication skills in effective information exchange and interaction with clients Confidential all levels of management.

TECHNICAL SKILLS

Statistical Packages: SPSS 17.0, Mini Tab- Math software

BI Tools: Qlikview, Qlik Sense 1.0/1.1, Tableau(Educational Knowledge)

Application servers: Internet Information Server

Testing Tools: QC 9,10,11& QTP 9.5, 10, JMeter

MS Office: Excel, Project Management

Languages: Visual basic, C, C++

RDBMS: MS Access, SQL server 2008 & 2012, Teradata, SAS

Browsers: IE 6/7/8/9, Mozilla Firefox 3/3.5/3.6/4.0 , Safari, Chrome

PROFESSIONAL EXPERIENCE

Confidential, OH

BI Lead - QlikView

Responsibilities:

• Developing QlikView dashboards for Healthcare business units, for data visualization and Analytics needs.
• Performance tuning of QlikView Applications, by using Document Analyzer and data model analysis, and fine tuning of object rendering time to maintain the SLA.
• Deployment of BI Applications and related Metadata, under SDLC and version controlling using Git hub.
• Developing data-model layer by Data-modelling using Star and snow flake schema, based on data granularity.
• Developing Qlik user interfaces such as charts, graphs, tables, and defining Dimensions & expressions.
• Level-3 support for Qlikview applications, in bug fixing for high utility dashboards.
• Designing and developing complex analytic solutions that enable user functionality with minimal on-going maintenance and post-production incidents.
• Manage and monitor tasks, dependencies, and user/team expectations regarding scope and timeline of BI solution delivery.
• Organizing disparate data sources into single data models; and Integrate with third-party software’s, using web services.
• Data element mapping for new dashboards, by analysing and querying data in Teradata.
• Assist client with QlikView Server integration issues, arising from platform capacity.
• Validating solutions, including end-to-end processes, by testing programs and validating results on the Dashboards.
• Implementing document chaining functionality to chain one dashboard to another dashboard to handle dashboard volume and rendering issues.

Confidential, NY

Sr BI consultant - QlikView, QlikSense

Responsibilities:

• Developed QlikView dashboards for Actuarial sciences commercial division, for visualization Loss and policy level data.
• Designed user interfaces of dashboards and integrating them with other technologies to provide state of the art visual models.
• Executed SQL queries in T-SQL & MS SQL databases, to validate QlikView KPI’s on the UI layer pre-production.
• Developed self-service analytic module, for ready consumption of reports, for the end users.
• Worked on QlikSense Mashup API’s to integrate BI onto various platforms (VBA & .net), using embedded objects and Hypercubes.
• Developed Drill down area maps using Geo Analytics suite.
• Designed reports in NPrinting 16.x to run jobs on weekly, monthly and quarterly basis, to maintain report schedules, user streams and trouble-shoot issues.
• Performed data element mapping exercise and data lineage analysis for new visualization requirements, from ground up.
• Liaised with database developers and architects to structure the dashboard KPI requirements, to embed them into the data warehouse.
• Translated business requirements into functional design documents and preparing sub sequent technical design documents.
• Performance tuned the existing dashboards to accommodate, higher volumes of historic data, for the business to develop forecast models.
• Prepared a capacity plan, for the QlikView delivery team for the upcoming projects and integrating the deliverables into scrum master, on a regular feed basis.
• Worked with underwriters and Actuaries from the business side, to collate the user experience stories and conducting training sessions periodically.
• Leading a small team of offshore junior resources, to allocate sub deliverables, by creating work breakdown structure and adhering to the project deliverables.
• On-boarded multiple sub streams of QlikView visualization projects into the project charter to deliver cutting edge solutions to the stakeholders.
• Prepared application packaging and artefacts, for SDLC deployments, to move dashboards to production.
• Maintained and tracked inventory of QlikView and QlikSense licenses, to aid the budget allocation for the project.
• Designing adhoc reports using the tool 'Report Manager', for periodic reports (Weekly, Monthly and Quarterly).

Environment: QlikView 11.2 & 12, QlikSense 3.0, JFrog, Service Now, Tableau 9.1, AWS, Report Manager, JMeter.

Confidential, NJ

Platform Engineer - Qlikview, QlikSense, Tableau & Cognos

Responsibilities:

• Identified and raised system capacity related issues (storage, licenses, performance threshold)
• Server Performance, capacity, utilization monitoring and Health monitoring of QlikView, QlikSense & Tableau servers across various instances, for the enterprise data analytics teams.
• Performed QlikView & QlikSense application reviews with developers on the dashboards and functionalities, for SDLC deployment phases.
• Optimization and Performance tuning of Qlikview applications & Servers, and recommended development best practices to be implemented.
• Define best practices for Qlikview deployment and create reusable templates.
• Installed, tested and debugged complex data connectors like SAP BW, Hadoop & Salesforce; for QlikView and QlikSense.
• Participate in overall architecture and strategy for the deployment of Qlikview suite of products.
• Environment monitoring pro-active monitoring to ensure for the optimal performance on the server.
• Hands on experience in Installing and configuring Qlikview/QlikSense server and publisher, in single and Multi-node instances.
• Provide troubleshooting and diagnostic support Confidential L2 / L3 level for Qlikview and other related products
• User license management using QlikView user Manager Dashboard.
• Implementing a QlikView COE toolkit with a suite of Qlik products to monitor the best practices.
• Server Issues handling and liaising with Qlik tech service account Managers to implement best practices.
• Research and Development on new versions of the Qlikview by building POC's with various complex functionalities.
• Maintained Server Logs, and performed Qlikview Server Backup process, during system update phases.
• Collaborated with L3 support team on patch and bug fix deployment.
• Platform on boarding of new applications by analyzing their BI requirements and platform setup.
• Installed Kerberos authentication mechanism to generate tickets to be able to connect to huge data Sources.
• Installing and testing the Tableau 10.1.1 server in Sandbox and Creating POC’s.
• Tableau online server administration and Application on boarding management.
• Maintenance of QlikSense Server with token management and task distributions for applications.

Environment: QlikView 11.2 SR13 & 12. Nimsoft server Monitor, Service Now, Tableau 9.1, 10.1.1 Cloud, Cognos 10.2.2

Confidential, SFO

BI Consultant/QlikView Admin

Responsibilities:

• Maintained the DEV and UAT Qlik View Publisher, to run the daily, weekly Tasks for the, dashboards to be viewed for the users.
• Ran a Document analyser, to test and analyse QlikView applications.
• Installed and Configured QlikView NPrinting, Qlikmaps & on demand objects on UAT & PROD.
• Verified the data lineage for each application to ensure proper data flow.
• Performed different tasks like repeat, reload and distribution tasks using the QlikView Publisher.
• Centralized the list of users having access to multiple applications in QlikView such that it is easy to track which user has access to which application.
• Created folder structure for new applications and provided access to the users in QlikView server.
• Configured the QlikView Extension Objects.
• Trouble shooting the QlikView task reloads failure problems, by analysing QVS, event, audit, session, and performance logs.
• Gathering business requirements and created functional and technical specs, and worked with business clients to confirm and clarify requirements and business logic.
• Enhanced the Business discovery process, by adding new features into the Dashboard, for the users to deep dive into the sales data.
• Facilitated data mapping process for the Dashboard Metrics, to standardise the Data warehouse component.
• Implemented 3-Layer architecture, Binary loads and Incremental Loads for optimal performance of the Dashboard reloads, rescaling and to adhere to data retention standards.
• Performed data modelling on requirements analysis by creating table displays, logical data model, star schema models and table designs.
• Developed a new dashboard, for supply chain Department; using the sources from legacy systems and mapping the Qlik Mart.
• Ran the daily, data validation of the Dashboard figures based on the SSAS cubes.
• Customized and tweaked the scripts for cross-tables and generic loads and created simple and complex expressions.
• Implemented data reduction feature to remove the unwanted associated data from QlikView using Post Reload triggers to reduce performance issues.

Environment: QlikView11.2,SQL Server, Oracle, Oracle, SQL, Customer Master, Clinapps, Windows XP/2003/2008 server and JavaScript.

Confidential, Dallas, TX

Qlikview Developer

Responsibilities:

• Imported data from multiple data sources including Web files, MS SQL Server and MS Excel through OLEDB and ODBC connections and modeling data as per user requirements.
• Participate in enterprise DW / BI strategy/ Dash boarding.
• Qlikview 9.0 implementation and integration.
• Involved in utilizing Qlikview solutions to develop complex reports and executive dashboard.
• Created Architectural Conceptual documentation and Technical Specification Documents.
• Create and manage ETL script generation using QlikView Script.
• Creating complex data models without synthetic tables and circular loops.
• Developed Qlikview applications creating expressions using set analysis.
• Created and scheduled Complex reports by leveraging the basic components of Qlikview.
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using the QlikView publisher.
• Involved in organizing meetings to know the needs of clients for the Enterprise solution Implementation.
• Involved in design and development of QlikView Platform integrated with Expandable Databases.

Environment: Qlikview 10.0/11, Windows 2003 Server/XP, Oracle 10g, MS Access 2007, MS Excel 2007.

Confidential

SQL Developer

Responsibilities:

• Prepared the Database Design, Technical Design (Low level Design) of some modules based on the approved functional design document.
• Enhanced the physical data model using Microsoft Visio.
• Created database links to transfer data from one database to another.
• Performed tuning and optimization on SQL queries.
• Developed automated Korn shell scripts to schedule the loading of flat files.
• Used composite partitioning schema (Range-Hash partitions) to partition very large transaction tables, range partitioning and hash sub-partitioning.
• Developed SQL scripts using Sybase to perform data retrieval for a range of business criteria’s.
• Produced scripts to cleanse source data, ETL process (Extract, Transform & Load) data with business rules, and built re-usable Mappings.
• Devised the test strategies and prepared the unit test plans.
• Used Remedy to log the design defects, bugs or review defects.

Environment: Oracle 9i, TOAD, Putty, Autosys GUI, OEM, T-SQL