Candidates About

 

SUMMARY:

• Around 8 years of experience in IT industry with strong background in Analysis, Design and Development in the field of Database, Data Warehouse, Data Modeling and implementation of QlikView/Qlik Sense for BI applications. 
• Having proven abilities in development, design, testing and production support for successful execution of projects on QlikView 3-Tire Architecture.
• Excellent skills in Coding and Report developing using QlikView/Qlik Sense.
• Solid Hands on experience in implementing the new features of Qlik Sense like StoryTelling, Data Profiling Techniques, SmartData Associations, Beta maps integrations,PivotTable,KPIObject, CustomExtensionswithWorkbenchUtilities (DeveloperHub) etc.
• Strong experience in understanding Business Applications, Business Dataflow and Data relations. Exception ability to quickly master new concepts and capable of working in-group as well as independently.

·         Gained experience in configuring Qlik Sense clustered environment and involved in trouble shooting issues like Sync issues, App Duplication issue, SSL certificates, SAML issues etc.

·         Good knowledge in configuring the security rules at Qlik Sense stream level and at the Qlik sense server level.

·         Experienced working with D3 Visualization library to create custom Qlik Sense visualization object based on business needs.

·         Extensive knowledge in creating Qlik Sense Apps using advanced features like KPI object, Story Telling, Beta Maps, Beta maps integrations, Pivot Table, Smart Data Associations, Export to PPT/PDF, Custom extensions using work bench utilities etc.

·         Conducted training sessions to business on how to leverage the Self Service capabilities in Qlik Sense and walked them through all the features that help them construct their own stories in Sense.

·         Extensive experience in conducting feasibility tests to migrate native QlikView applications to Qlik Sense.

·         Solid Hands on Experience in handling Qlik Sense Eco System (Hub, Sense QMC, Engine, Proxy, Scheduler etc.).

·         Scheduling the automation of QV jobs using QlikView/Qlik Sense Management Console. 

·         Strong knowledge in developing highly informative dashboards using QlikViewobjects like ListBoxes, MultiBoxes, Tables, Charts, Current Selection Boxes, Buttons, etc and variables, fields, calculated expressions, basic and aggregated functions. 

·         Experienced in importing data to QlikView from databases, QVD files, text files and connecting to external data sources to generate different dashboard style reporting user interfaces. 

·         Importing Metadata from different data Sources, creating dimensions and hierarchies, determinants using Star Schema Grouping. 

·         Experience in installing and setting up third party customs connectors like SalesForce connector, SAP Connector and Big Data connectors (Cloudera/Horton ODBC/JDBC Connectors) etc.

·         Expertise in designing data models from multiple data sources in QlikView. 

·         Worked with QlikView/Qlik Sense administrator to optimize QlikView /Qlik Sense performance.

·         Involved in QlikView Administration, Installation and upgrading the QlikView Server and Publisher, QlikView Web Parts. 

·         Experienced in creating QlikView Access point for Client application rollout and administrator security by Active Directory technology using QlikView Publisher.  

·         Good knowledge of Data Warehousing Models, RDBMS concepts, SQL and SQL Server. 

·         Expertise in optimizing, debugging and testing SQL queries. 

·         Good working knowledge in Data Modeling including Dimensional Data modeling, Star Schema/Snow flake schema, FACT & Dimensions tables, Physical & logical data modeling.

·         Excellent analytical, co-ordination, interpersonal, leadership, organizational and problem solving skills, ability to adapt, learn new technologies and get proficient in them very quickly.

 

TECHNICAL SKILLS:

 

Databases	SQL Server 2008/2005/2000, MS-Access 2000, Oracle.
BI Tools	QlikView 9/10/11.2/12, Qlik Sense 2.1.1/2.2.4/3.1 and Tableau 8.x/9.x
Languages	JavaScript, Java and SQL
Data Modeling	MS Visio
Web Technologies	JAVA,HTML 5, CSS 3
Operating system	Win 9x/NT/2000/XP/Vista , MS-DOS, UNIX, Windows 2003 server

 

Education Details: B.Tech in Computer Science and Engineering.

WORK EXPERIENCE:

 

Cisco, San Jose, CA                                                                                                                                               Jan 2015 – Present

Sr. QlikView/ Qlik Sense Developer/Admin

 

Responsibilities:

 

As a QlikView Developer

• Understanding the requirements from the users. Suggested better way of presenting charts, which are accepted and successfully implemented in the dashboards.
• Document event trigger and field event triggers are created. Incremental reloading is implemented.
• Involved in dashboard layout design and internal data mapping design.
• Developed  executive  dashboards  in  QlikView,  delivered  through  the  web,  enabling  to  measure  the performance of the business with analytical capabilities.
• Provided implementation and ongoing support related to QlikView.
• Created Dashboards style of reports using QlikView components like Slider, Buttons, Charts, and Bookmarks.
• Developed extensively Alerts, Variables, Input boxes, calendar & Macros.
• Developed load script using QlikView Functions (Date and Time, Keep, Join, Mapping, String, Interval match etc
• Support included creation of reports and standard relational databases for upload to SharePoint dashboard web part pages, and creation of supporting SQL queries.
• Worked with QlikView 10.x, 11.x SQL Server, Excel, flat files.
• Experience in setting up Server, Publisher configurations and Security authorization at different levels.
• Developed  executive  dashboards  in  QlikView  delivered  through  the  web,  enabling  to  measure  the performance the performance of the business with analytical capabilities.
• Dashboards were served to track inventory and sales as well as to monitor various KPIs. Dashboards included customer detail drilldowns, threshold gauges and alerting mechanisms.
• Extensively designed & Developed Start to End Automation for complete QlikView Project from ETL to QlikView distribution.
• Worked on DEV, UAT and PROD servers simultaneously.
• Worked Closely with BA and Clients to understand the requirements.
• Experience in complete project life cycle including Documentation, Analysis, Development and Testing.
• Provided end user and production support after deploying the application into the production environment, also provided extensive support for the users on application usage and trained users in the functionality of the software.

 

As a Qlik Sense Developer

·      Developed brand new Qlik Sense Apps with the help of D3 Visualizations, Extensions available in the Qlik branch, new Qlik Sense framework default functionality like Beta Maps, KPI Object, Export to PPT/PDF, storytelling etc.

·      Developed Master resource library across Qlik Sense Apps and trained users in leveraging them to create custom stories/additional visualization based on their need.

·      Upgraded Qlik Sense server by following feature release paths to inherit the latest features that are available for consumption.

·      Leveraged existing QlikView DataMart’s to migrate Qlik Dashboards onto Qlik Sense environment.

·      Implemented Application Level Section Access and configured security rules on Qlik Sense streams to control user actions over Qlik Sense Hub.

·      Created Qlik Sense Wizards, mashups for embedding the Sense visualizations into third party applications.

·      Good knowledge on trouble shooting Qlik Sense server related issues like Sync issue, App Duplications etc.

·      Solid knowledge in upgrading the existing Qlik Sense clustered environment to latest releases after performing stability checks.

·      Provided capabilities from an existing data model, which has been already created with QlikView. Instead of recreating that model in Qlik Sense it can be converted easily by utilizing the existing QlikView.

·      Created scheduled jobs through Qlik Sense management console(QMC).

·      Involved in extracting, transforming and loading data from source into QlikView/Qlik Sense applications.

·      Deployment of Qlik Sense/QlikView dashboards from DEV to UAT and UAT to PROD.

    

 

Environment: QlikView 11.2 x/12.0 SR5, Qlik Sense 2.1.1/2.2.4/3.1/November 2017/February 2018, QlikView Server, QlikView Publisher, Hadoop HIVE, Teradata, Salesforce.com.

 

 

Genentech, South San Francisco, CA                                                                                                         Jan 2014 - Dec 2014

Sr. QlikView Developer

 

Responsibilities:

 

·         Testing application performance following existing test procedures and suggested improvements.

·         Resolved technical problems for QlikView dashboards.

·         Installed and configured QlikView NPrinting & on demand objects on windows server & windows desktop.

·         Upgraded the QlikView environment from QlikView 11.2 SR 10 to11.2 SR12 and then to12 SR5.

·         Documented QlikView installation procedures and run books.

·         Installed and configured Qlik Maps on windows server.

·         Configured QlikView extension objects.

·         Troubleshot the QlikView task reload failure problems.

·         Analyzed QVS, event, audit, session, performance logs.

·         Reviewed data model and dashboard scripts during migration of files to production.

·         Restricted administrator privileges to certain group of users on QlikView publisher.

·         Validated the application using QlikView document analyzer.

·         Verified the data lineage for each application to ensure proper data flow.

·         Managing database connections by creating connection strings as per requirement.

·         Created tasks and complex triggers to deploy the applications in access point using QlikView Management Console.

·         Acquaintance with HP service manager for day-to-day issue tracking.

·         Reviewed new procedures on staging environment before implementing on production.

·         Used TOAD to validate the data using SQL queries.

·         User management on LDAP server by creating groups to distribute the QlikView application access to users.

·          Mounted the folders on QlikView publisher to publish the application on access point. 

·          Created folder structure for new applications and provided access to the users in QlikView server.

·         Assisted users with basic trouble shooting techniques like clearing System/Browser cache, URL bookmarking, browser resolutions setup, user friendly mobile access setup etc.

·         Perform basic performance troubleshooting on clustered environments, Grant/Fix user access, monitor health of servers, upgradation of environments, responsible for migrations across the environments.

·         Extensive experience on third party integration like QV Extension, Nprinting, Connectors, SSO API’s and Load balancing strategies.

·         Handled cross platform dependencies by coordinating with System Ops, Windows Admin, Middleware integrations, System Architecture and DNS teams.

·         Worked on various category of low to urgent tickets as part of production support for a number of dashboards and user groups

·         Provided troubleshooting and diagnostic support at L1/L2 /L3 level for QlikView.

·         Provided 24 hours support and work on call weekends when needed.

 

Environment: QlikView 11.2 x, QlikView Server, QlikView Publisher, DB2, Oracle, Informatica, SAP BW

 

Verizon Wireless, Irving, TX                                                                                                                                July 2012 –  Dec 2013

QlikView Developer

 

Responsibilities:

• Actively involved in gathering requirements from end users, involved in modifying various technical &functional specifications.
• Participated in Business Processes with the Business Analyst to understand the requirement and reviewed High Level Design Documents, Functional Specifications documents with the Technical Manager.
• Hands-on experience in the design, development of end user applications for the data presentation and analytics, including dashboards, reports, monitors, and graphic presentation (Information Visualization & Analysis).
• 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.
• Extracted information from different data sources like Teradata, SQL Server, MS Access and flat files by using different scripts like add, concatenate, resident, qualify, unqualified etc.
• Wrote SQL queries and created ad hoc queries to perform data validation and analysis.
• Created QVD files to hold data from data sources and updated the QVD files on timely basis as the source database updates.
• Developed various QlikView Data Models by extracting and using the data from various sources like QVD files, MS SQL DB, Excel, and Flat Files
• Implemented Incremental Load, Optimized Load & Binary Loads for performance tuning and for optimized QlikMart.
• Designed best suitable UI to achieve user requirement in simple and user-friendly interface of reports.
• Used QlikView Functions for creating dashboards, and designing the User Interface based on business/user requirements.
• Developed QlikView Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box, Statistics Box, Multi Box and Calendar & Date Island. Also, installed and deployed them according to UI design.
• Adept in creating various QlikView reports and publishing them as per clients request.
• Used Section access and Sheet access to make the application available to desired users.
•  Created dashboard style of layouts using different sheet objects like List boxes, Multi boxes, slider, currency selection box, buttons, charts, text objects, bookmarks, etc

 

Environment: QlikView 11.2 x, QlikView Server, QlikView Publisher, MS SQL Server, SSIS/SSRS.

 

 

TPvision India Pvt ltd, Banglore ,India                                                                                                        June 2011 –  July 2012

QlikView Developer

 

Project1 :

This is a report developed for TPvision India Pvt ltd’ to view the number of application available per country and which country peoples are using this feature in Philips TV’s and utilization of apps in each country at a very detailed level. QlikView is used as the reporting tool, Have completely involved in the development of SQL logic for the QlikView. The report pulls the data from a web service, Implemented Rolling 3 Months in QlikView. This is a report which shows the opening sales and closing sales of

 

Project2:

This is a report developed for TPvision India Pvt ltd’ to view the growth of performance of the Philips TV’s at a very detailed level. QlikView is used as the reporting tool, Have completely involved in the development of SQL logic for the QlikView. The report pulls the data from a web service, Implemented Rolling 3 Months in QlikView. This is a report which shows the opening sales and closing sales of business.

Project3:

Gives a complete analysis of time effort distribution of resources across the organization at various levels& Verticals. This report gives a detail analysis of billable, non billable, vacation percentages so that the management can track the health of the organization. Implemented dynamic section access security at document level, sheet level and data levels. The logic was implemented to distribute the utilization of employees into different buckets based on billability.

 

Responsibilities:

 

• Collaborated with Business users and cross functional teams to develop Business Requirement Documents (BRD), define KPIs (Key Performance Indicators), and identify data sources.
• Developed executive  dashboards using QlikView, delivered thru the web, enabling to measure the performance of the business with analytical capabilities.
• Worked on QlikView Server and Publisher, to manage scheduling, reloading of documents, mounting of folders.
• Performed time over time analysis of sales and performance related data.
• Performance tuning of dashboards was carried out to limit the response time to well under 10 seconds.
• Helped end users to design test cases and worked through multiple UAT cycles.
• Created dashboard style of layouts using different components of QlikView Enterprise like Listboxes, Multiboxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc.
• Presented QlikView applications to various levels of user.
• Designed application for Sales & Marketing Modules that Generates GUI Report for easy access through the data.

 

Environment: QlikView 10/11, Oracle, SQL Server, Excel files and flat files, QMC, IIS Web Server, IBM Infosphere Datastage.

 

 

 

Iterum Health Care technologies, Banglore ,India                                                                                       Apr 2010 –  May 2011

Business Analyst

Description:

A general hospital is typically the major health care facility in its region, with large numbers of beds for intensive care and long-term care; and specialized facilities for surgery, plastic surgery, childbirth, bioassay laboratories, and so forth. Larger cities may have many different hospitals of varying sizes and facilities. Very large hospitals are often called Medical Centers and usually conduct operations in virtually every field.

Responsibilities:

• Responsible for Test Designing ,Preparation of Test cases, Reviewing and Executing Test cases.
• Performed functional and non-functional testing.
• Involved in peer reviews and suggesting ways to fresher's in writing test cases.
• Responsible for tracking Daily Status and preparing Weekly Status report.
• Defect tracking using Bugzilla and Quality center.

 

 

 

 

 

 

Refereces are available upon request