SUMMARY

• A Dynamic IT professional wif 10+ years of experience in QlikView 10/11.x/12.x, Qlik Sense 0.9/1.0/ 1.1/2.0/2.1/2.2.4/3.1/ June 2017/September 2017/Nov 2018/June 2019/Feb 2020, Tableau 9.x/10.x, Hyperion IR, Business Intelligence, Decision Support Systems, ETL Process and Application Development
• Expertise noledge in design, testing, implementation, maintenance and administration of Business Intelligence Systems in multiple windows environment.
• Expertise in installing/configuring Clustered Server environments (QlikView/Qlik Sense) using default QlikView Webserver and IIS.
• Sound noledge in overall architecture design and strategy planning for the deployment of Qlik suite of products across the enterprise.
• Solid understanding of Windows Active Directory configurations and Authentication in QMC.
• Solid Hands on Experience in handling Qlik Sense Eco System (Hub, Sense QMC, Engine, Proxy, Scheduler etc.)
• Solid understanding of different types of security rules implemented on Qlik Sense sites
• Expertise noledge in analyzing the QlikView and Qlik Sense logs to troubleshoot the issues
• Well versed wif the elements that influence the performance of the QlikView and Qlik Sense components.
• Solid Hands on experience in implementing the new features of Qlik Sense like Story Telling, Data Profiling Techniques, Smart Data Associations, Beta maps integrations, Pivot Table, KPI Object, Custom Extensions, Mashups wif Workbench Utilities (Developer Hub) etc.
• Extensive hands on experience in creating enhanced rich visuals wif the help of extensions library from VizLib (Pivot Table, Sheet Menu, Table, Bar Chart, VizLib Filter etc.) and Qlik branch open source JavaScript API’s - Climber Chart, Sankey Chart, Any Chart, Tabbed Container etc.
• 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.
• Excellent noledge in designing and developing dashboards using QlikView by extracting the data from multiple sources (Hadoop Hive/Impala, Web Services, Teradata, Sales Force, Couch DB, Neo4J, SQL Server, Oracle, Flat files, Excel, Access, SAP BW/ECC).
• Explored intensively and Implemented QlikView 11 advanced features like Direct Discovery, Alternate States, Grid Container, Dimension Limits
• Extensive experience wif QlikView sheet objects like Straight tables, Pivot tables, Containers, Line charts and Bar charts, scripting and building QVD’s and QVW’s and QVFs.
• Trends, KPI’s, Macros, custom requests for Excel Export, and Fast Change and objects for Management Dashboard reporting
• 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 on Oracle
• Conducted analysis and evaluation of existing systems to upgrade latest versions of JIRA Prepared projects, dashboards, reports and questions for all JIRA related services.
• Team orientedindividual wif a results driven attitude, strong interpersonal and communication skills in effective information exchange and interaction wif clients at all levels of management.

TECHNICAL SKILLS

BI Tools: QlikView 12/11.x/10/9, Qlik Sense 1.1/2.0/2.1/2.2.4/3.1/ Sep 2017/Nov 2018/June 2019/Feb 2020, Tableau and analysis 9.x/11.x

Databases: PostgreSQL, Teradata, Netezza, Oracle 11g/10g, MS SQL Server 2005/2000, Sybase and MS Access

Tools: Toad, SQL developer, SSMS, Teradata SQL Assistant

Languages: SQL, PL/SQL, T-SQL, C, C++, Java, PHP

Scripting Technologies: JavaScript, UNIX

Data Modeling: Erwin data modeler

ETL: IBM Infosphere Datastage, Informatica, SSIS and Alteryx

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Qlik Sense Lead Developer

Responsibilities:

• Involved in gathering business requirements and preparing functions Specs for the application development.
• Connected to data sources (Oracle) using ODBC and OLEDB connections to create and schedule ad-hoc reports by leveraging the basic components of QlikView.
• Interacted wif end-users to collect requirements and acquire the necessary domain noledge to become a subject matter expert. Trained and provided support to end users
• Developed Proof of Concepts (POC) for various projects using Qlik Sense and QlikView.
• Configured different Qlik Sense roles and attribute-based access control
• 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
• Developed a governance dashboard using Qlik Sense data story telling feature, combining KPIs from various dashboard at one place
• Developed automated testing QVW for testing of QlikView reports.
• Enhanced existing dashboards wif new functionalities and established a secure environment using Section Access.
• Trained the other developers to set up apps and connections, create filters, templates and reports and schedule tasks etc. in Qlik NPrinting.
• Upgraded versions in Qlik Sense.
• Created Qlik database connections on the server in non-prod environments.
• Eliminated Synthetic keys, ambiguous relationships, and closed loops. Designed proficient dashboards according to the requirements

Environment: Windows Server 2012, Microsoft Windows 8, QlikView 12.0, Qlik Sense April 2020, Qlik NPrinting, Oracle 11g, TOAD, Azure SQL DB, SQL Server Management Studio 18, MS Office.

Confidential, Dallas, TX

Qlik Sense Lead Developer/Admin

Responsibilities:

• Global automation for enabling security for all Qlik Sense apps through Section Access by feeding in the data collected from SSO app using REST API.
• Created logins / users grant / deny permissions and other security issues inQlik Sense.
• Created complex security rules inQlik Sense Management Consoleincluding hiding sheets, apps, objects for multiple users.
• Actively participation inmigratingapplications fromQlikView/SAP BO to Qlik Senseand Power BI and resolving critical compatibility issues during migrations.
• Actively participation inmigratingapplications fromQlikView to Qlik Senseand took part in resolving critical compatibility issues during migration
• Installation and configuration of Qlik Sense Nov 2018/June 2019 for a multi-clustered environment (8 Nodes of Engine, 4 Nodes of Scheduler and 3 Nodes of Virtual Proxy).
• Hands on experience in setting up multiple lower and Lab environments for Development, QA, UAT and feasibility testing.
• Establishment of source connections to PostgresSQL, Azure DB, REST APIs, SQL Server, Oracle, Netezza and Datastax Cassandra DB.
• Worked on Data Storytelling to combine reporting, presentation and exploratory analysis techniques to emphasize the data insights.
• Implemented Incremental Load, Optimized Load & Binary Loads for performance tuning and for optimized Qlik Data Marts.
• Handling offshore team and sharing noledge wif them to improve the product development phase very faster.
• Optimized the rendering time between different KPI objects over large datasets.
• Worked wif Vizlib Charts for building advanced visualizations in QS Apps

Environment: Qlik Sense Nov 2018/June 2019/Feb 2020, Teradata, Netezza, PostgresSQL, VizLib Extension Bundle, Amazon Web Services (AWS), SSIS, Control-M

Confidential, San Jose, CA

Tableau/Qlik View/Sense Lead Admin/Developer

Responsibilities:

• Developed brand new Qlik Sense Apps wif 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 TEMPhas 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, mash ups for embedding the Sense visualizations into third party applications.
• Solid noledge in upgrading the existing Qlik Sense clustered environment to latest releases after performing stability checks.
• 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.
• Understanding the requirements from the users. Suggested better way of presenting charts, which are accepted and successfully implemented in the dashboards.
• Created EDX triggers, field event triggers and Implemented Incremental reloads for efficient data fetch from backend source systems.
• 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.
• Experience in setting up Server, Publisher configurations and Security authorization at different levels.
• Developed executive dashboards in QlikView and delivered through the web, enabling to measure the performance the performance of the business wif analytical capabilities.
• Extensively designed & Developed Start to End Automation for complete QlikView Project from ETL to QlikView distribution.
• Worked Closely wif BA and Clients to understand the requirements.

Environment: QlikView 11.2 x/12.0 SR5, Qlik Sense 2.2.4/3.1, Tableau 9.x/10.2, QlikView Server, QlikView Publisher, Hadoop HIVE, Teradata, Salesforce.com, Oracle, Informatica.

Confidential, SFO, CA

Qlik View/Sense Administrator

Responsibilities:

• Analyzed the performance of a dashboard by single user test and evaluated the performance test results generated by Load runner/JMeter.
• Installed and configured NPrinting server and designer on windows server and desktop.
• Generated formatted PDF and excel reports using NPrinting On-demand extension objects for enabling dynamic reporting wifin the QlikView Dashboards.
• Experience in installing and setting up third party customs connectors like SFDC connector, SAP Connector and Big Data connectors (Cloudera ODBC Connectors) etc.
• Extensive experience in Full Life Cycle Development including Analysis, Design, Implementation and Maintenance different analytical applications using QlikView suite of Products (QlikView Desktop, QlikView Server, Publisher and QlikView Enterprise).
• Implemented Direct Discovery Feature extensively in order to load large amount of big data from huge fact table and enables complete associative experience wif data stored in the memory.
• Migrated couple of QlikView dashboards to Sense and conducted feasibility tests in assessing the tool for future scope of requirements.
• Trained business users in understanding the sense development architecture and educated them in utilizing the master items for their analysis.

Environment: QlikView 11.2 SR 10/12 Intial Release, Qlik Sense 2.0.2, Windows 2008 Server, Oracle 11g, SQL Server 2005, TOAD 9.6.1.1, puTTY, IIS Webservers, Site Minder, SAP connectors, SAS 9.4.0.15175 , SIMS Cloudera Hadoop HIVE, Alteryx.

Confidential, Houston, TX

Qlik Implementation Consultant

Responsibilities:

• Responsible for gathering requirements, business and technical rules, implementing QlikView applications.
• Conducted training sessions to users on QlikView/Qlik Sense usage.
• Developed POC’s on Snapshot Model and few Near Real Time KPI’s to evaluate the feasibility of Qlik vs SAP Design Studio and SAP Lumera as per the business needs.
• Involved in optimizing the existing Qlik Dashboards and load scripts to improve the performance.
• Involved in Setting up the Development standards, Qlik Architectural best practices, efforts estimation and feasibility of the Product.

Environment: QlikView, QlikView Publisher, QlikView Management Console, Oracle 11g, SAP BW/ECC, Excel.

Confidential, Addison, TX

QlikView Lead/ Architect

Responsibilities:

• Built Qlik Dashboards, involved in developing, enhancing and supporting Qlik applications.
• Managed schedules and reloading of QlikView data model QVDs and QVWs through QlikView Enterprise Management Console (QEMC).
• Implemented Best Practices & Developed ETL Scripts to resolve Circular Relationships, Synthetic Keys in QlikView.
• Created customized gauge charts to show the Actual VS Plan for the MLO’s and the KPI scores for all the LOBs.
• 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.
• Used Section access and Sheet access to make the application available to desired users.
• Created weekly PDF report distribution for a set of users using Loop and Reduce functionality in QV Publisher.

Environment: QlikView 11.2 SR9, SQL Server, Oracle, Informatica, SSRS

Confidential, El Segundo, CA

Sr. QlikView/ Qlik Sense Developer

Responsibilities:

• Built QVD’s from Hadoop Hive/Impala, Web Services using SOAP request, Teradata, Oracle, and Sales Force.
• Gained noledge on Server Architecture by attending the weekly Qlik Webinars on Qlik Sense
• Implemented Direct Discovery Feature extensively in order to fetch the Live Data from a huge fact table that consist of users Account information.
• Wrote several macros for the dynamic construction of Multi Box based on the user selections, for triggering External Web services using SOAP request, exporting data to excel etc.
• Automation of PDF reports distribution to the users based on their region.
• Optimizing 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.
• Automated and scheduled daily data loads of QVW documents using QlikView Publisher.

Environment: QlikView 11.2, Qlik Sense 0.9, Set Analysis, Teradata, Hadoop Hive/Impala, Web services, Oracle, Excel, Salesforce

Confidential, Commack, NY

QlikView Developer

Responsibilities:

• Built QVD’s from SQL Server Database, Stored procedures and Excel files
• Developed QVD scripts to load history and current data using Incremental logic
• Created PDF reports and scheduled to generate PDF’s every week
• Installed and configured QlikView 11 SR2.
• Worked wif cross functional team and business user to develop Business requirement document (BRD), define key performance indicators (KPI’s) and identify data sources
• Used Section access and Sheet access to make the application available to desired users
• Created Input boxes, Pivot Tables, Straight Tables, Bar Charts, Buttons, Multi boxes on the UI to make it more accessible to User community
• Created Variables to select date ranges as Calendar objects are not user friendly on IPad
• Used SET Analysis and Aggregate functions to look back 30 days or 60 days and get the required information

Environment: QlikView 11, Set Analysis, SQL server, Excel, SAP BW

Confidential

Senior Applications Engineer

Responsibilities:

• Participated in Functional and Systems Requirements Modeling sessions to create System Requirements for the application.
• Designing and Development of ADF Applications.
• Designing and Development of ADF Bounded and Unbounded Task Flows.
• Enforcing Internal and External Security on ADF Applications and its partner applications.
• Conducted analysis and evaluation of existing systems to upgrade latest versions of JIRA Prepared projects, dashboards, reports and questions for all JIRA related services.
• Responded to all incoming questions and inquiries related to JIRA applications
• Implementation of sub-modules like Manage Project Enterprise Resources, Import Project Enterprise Resources process, FSM (Functional Setup Manager) service that takes care of importing and exporting the resources from one fusion application instance of the customer to the other etc.
• Implementing various ADF UI features like, Calendar and popups, Drag and Drop of selected players, Unbounded and Bounded Task Flows wif parameter calls, ADF Tree and Table implementation for points and providing statistics based on ADF graphs.
• Usage of ADF UI Shell and Page Templates for common UI across Project Management Application.
• Built logic in ADF binding layer to conditionally execute various executables in tandem.
• Remote and standalone deployment of ADF application in the WebLogic server
• Usage of ADF UI Shell and Page Templates for common UI across pages.
• Implementing various ADF Model features like BC4J based on AM, EO, Associations, VO, View Links.
• Data Binding layer based on Web Services and Java POJOs.
• Developing and Designing ADF Applications based on MVC architecture.

Environment: Java, J2EE, WebLogic Server 10.3, JDeveloper, Oracle ADF.

Confidential

Software Engineer

Responsibilities:

• Interacted wif Business analysts and developers for the requirement clarification.
• Worked as an Interface between the users and the different test teams for the better understanding of the business and IT processes.
• Framed test plan to execute them in strict time-lines for every Test Cycle.
• Faced several Quality Audits and ensured the alignment of process wif organizational standards.
• Built "Online-Knowledge Repository" for Test Cases and integrated Insurance domain.
• Developed “Environment tracker” to automate Server failure reports for clients.

Environment: Java/J2EE, Cordys BPM, Web Services, BIRT Report, Oracle 10g, MS SQL Server 2008, Windows 2008 R2, MS Office Suite 2007