Sumeet Vartak

Sr. Software Engr

+1-647-***-****

ac9lel@r.postjobfree.com

Toronto, ON, CA

PROFESSIONAL SUMMARY

* ***** ** ** **********

3.5+ years of Qlik Admin responsibilities

* ****** ** experience in Designing and Development of Business intelligence application with QlikView 8.5/9.0 and Sense as BI tool.

Admin Activities including design, setup and maintenance of Qlik tools on physical and Virtual servers

In-depth knowledge and expertise in Installing and Configuring

Qlik Sense

Qlik Nprinting

GeoAnalytics

QlikView Server and Publisher 10.0/11.x/12.x with QlikView

Setting Qlikview web server / IIS in both clustered and non-clustered environments.

Received training certificates for Admin Activities from Qlik for

QlikView

Qlik Sense

NPrinting

Configured Web server to use both IIS and QlikView Web Services as a failover.

Designed the architecture considering contingency analysis for maximum uptime of services leading to a successful + 99% uptime

Designed Clustered Qlik Sense environment

Planning upgrades and maintenance activities to be in sync with the quarterly released updates for the tools

Knowledge about analyzing and utilizing governance dashboards for maximum resource utilization and future planning.

Setting up Qlik Maps extensions for Qlik Sense

Installing and supporting Qlik Maps Extension

Point of contact for support with Qlik (Analytics8) for troubleshooting and logging cases.

Strong expertise in implementing the advanced features like Direct Discovery, Document Chaining, Dynamic Update, Alternate States, Dimension Limits, write back functionality using Macros, On Demand extensions for NPrinting reports.

Hands on experiencing in improving the Ajax responses in the server environment and fine tuning of QlikView dashboards to reduce the initial rendering time.

Experience in debugging QlikView, Qlik Sense applications to improve the performance, flexibility and usability

Experience in integrating QlikView applications with Salesforce, SAP BW etc...

Worked in all phases of Business Intelligence Life Cycle and Software Development Life Cycle.

Good knowledge about integrating extensions in all the Qlik tools

Developed reports in QlikView and report templates in NPrinting so that they can be emailed to the users using PDF add-on and NPrinting scheduler. Sumeet Vartak

Sr. Software Engr

+1-647-***-****

ac9lel@r.postjobfree.com

Toronto, ON, CA

Understanding of Dimensional Modeling technique, Multi-dimensional database Schemas like Star Schema, Snowflake Schema, Fact and Dimensional tables, Section Access, Set Analysis in Qlik and DW concepts.

Implemented data level security using Section access that hides selected areas of the dashboard

& filters data dynamically depending upon user privileges.

Conducted analysis and evaluation of existing systems to upgrade latest versions of JIRA

Having knowledge on the SDLC methodologies like AGILE, Waterfall model.

Organized, coordinated and ran weekly meetings with offshore and admin team members.

Experience working in agile methodology development environments, involved in Scrum meetings.

Utilized Qlik Schedulers in Qlik Sense QlikView and NPrinting to manage and maintain scheduled jobs for application dashboards.

Involved in Performance Tuning & Deployment of QlikView Applications.

Experienced in Training & Supporting end-user reporting needs using QlikView products.

Onsite-Offshore coordination in delivering Business Intelligence Solutions.

Excellent knowledge in Implementation of Relational Database (OLTP), Data warehousing systems (OLAP) and Data Marts.

TECHNICAL SKILLS:

QlikView Tools :QlikView Developer, QlikView Server & Publisher, Enterprise Management Console, Management Console, Publisher Analyzer, Governance Dashboard, QlikMaps, QlikSense, nPrinitng, OCX Control, QV Ajax Client, QV IE Plug-In

Business Intelligence : QlikView 9.0/10.0/11.2, Qlik Sense till June 2018. Tableau 2018.2 RDBMS : Oracle 11g/10g, SQL Server, DB2, Teradata, MS Access Operating System : Server Windows 2016/2012/2008/2005/XP, UNIX. Web Applications : IIS 6.0/7.0/7.5, Web Logic 8.

Languages : SQL, VB-Script, Shell Scripting, C, C++ Data Modeling : Visio.

PROFESSIONAL EXPERIENCE:

Tech Mahindra,

Hinjewadi, MH

Sr Software Engr

Sumeet Vartak

Sr. Software Engr

+1-647-***-****

ac9lel@r.postjobfree.com

Toronto, ON, CA

Jan 2019-April 2019

Responsibilities and activities:

• Completed basic training for Tableau Development

• Completed basic training for Tableau Architecture. SunTrust Banks, Inc.

Atlanta, GA, USA

Qlik System Admin Lead

April 2015-August 2018

Responsibilities and activities:

• Setting up Qlik tools on Physical and Virtual Environments

• Designed the architecture for all the Qlik Tools

• Migrating Qlik Tools from legacy physical servers to Virtual environment for the tools and all the environments (DEV, QA and PROD)

• Proposed and setup a separate environment for high profile and fast application development projects

• Stability of around 120 server (physical and Virtual) working with the windows team to trouble shoot and mitigate the issues.

• Windows 2008, 2012 and 2016 Servers

• Maintaining DEV, QA and PROD environments.

• SunTrust Banks, Inc. has around 13000 unique users and around 4000 concurrent Qlik users

• Support to over 105+ dashboards.

• Planning and design for the increasing user base and system stability.

• 24x7 initial support for issues and incident and practicing correct resolution

• Lead for 4 offshore QlikView Admins and 2 Onshore Admins

• Stabilizing the environment and planning updates for the services

• Server configuration as per the number of user and requirements.

• Config Scheduler and proxy services on the server as per number of concurrent jobs

• Security as per QlikView document share access

• Knowledge about CAL and PGO

• .shared files, QVPR and Optimal System setting files for QDS, QVS, QWS, QMC and DSC services

• Tools to debug the issues in the environment.

Sumeet Vartak

Sr. Software Engr

+1-647-***-****

ac9lel@r.postjobfree.com

Toronto, ON, CA

• Publisher scheduler

• Changes in environment as per increasing user base. (When I joined it was 1200 now its 12000)

• Sending communications to users for any service down issue or maintenance window.

• Firewall and Anti-Virus settings.

• File privileges and permission settings on the window server.

• Used LDAP and Active directory for security and privileges.

• Creating 32/64 bit Connection strings fetching data from SAS, ODBC, OLEDB, Big Data, Hadoop, Sql, Impala, Hive etc. data sets for Sense and View extraction process Installations: Qlik Sense, QlikView, NPrinting, GeoAnalytics installations, Publisher Analyzer, QlikMaps

Qlik upgrades: Version Upgrade, SR upgrades, Patch installs Horizon Advanced System.

Irving, Texas, USA

Qlik System Admin

Dec 2014-March 2015

Responsibilities and activities:

• QlikView Installations

• Upgrade activities

• Configurations

• Dashboard migrations

• Dashboard Publishing

• Patching

• Database connection setups

Qlik Dashboard Developer

Aug 2014-Dec 2014

Responsibilities and activities:

• Developed proof of concept to check the functional feasibility of the QlikView implementation.

Sumeet Vartak

Sr. Software Engr

+1-647-***-****

ac9lel@r.postjobfree.com

Toronto, ON, CA

• Created mock-up dashboards during the initial phase of the projects to set expectations and discuss various possibilities

• Studied QlikView, Sense and its components and worked closely with the QlikView Implementation partners.

• Participated in Installing, configuring and deploying and Gathering business requirements from business users and developed Application Prototypes.

• Deployed the application on QlikView server and imported data from different sources like Salesforce.com, Oracle 10g, MS Access, XML files and flat files using OLEDB/ODBC.

• Mainly designed and developed QlikView applications from scratch, to support reporting and Business Intelligence initiatives.

• Worked on Publisher to Automate and scheduled daily/weekly/monthly data loads of QVW documents and error notifications by email to assigned users. Qlik upgrades: Version Upgrade, SR upgrades, Patch installs Education:

MS in Information Technology and Management from Campbellsville University, Louisville KY, USA

MS in Electrical Engineering from Colorado State University, Fort Collins, CO, USA BE in Electronics and Telecommunication from, University of Mumbai, MH, India

Contact this candidate