SUMMARY

• 6+ years of IT industry experience in all aspects of Business intelligence applications with a strong background in Database development, Data Warehousing /Decision support systems and Business Intelligence.
• Good expertise with the development and design of Qlik Sense and QlikView applications.
• Experience in complete project life cycle including Documentation, Analysis, Development and Testing under Agile methodology.
• Gained Expert knowledge in migrating applications from QlikView to Qlik Sense and Handled critical compatibility issues during migrations.
• Extensive experience administering Qlik Sense Server, Scheduler, QlikView Server, QlikView Web Server and QlikView Publisher using QMC.
• Extensive hands on experience in creating enhanced rich visuals with 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.
• Excellent knowledge in designing and developing dashboards using QlikView/Qlik Sense by extracting the data from multiple sources (Hadoop Hive/Impala, Web Services, Teradata, Sales Force, Couch DB, SQL Server, Oracle, Flat files, Excel, Access, SAP BW/ECC).
• Well versed with D3 Visualization library (open source Java Script Library) for custom visual extensions and solid experience in developing custom extensions using HTML 5, CSS and Angular JS for Qlik Sense.
• Well versed with D3 Visualization library (open source Java Script Library) for custom visual extensions and also solid experience in developing custom extensions using HTML 5, CSS and Angular JS for Qlik Sense.
• Good working knowledge in all components of QlikView and interaction on Server and Publisher.
• Experience with QlikView sheet objects including Pivot, List and Multi box, multiple chart types, Trends, KPI's, custom requests for Excel Export, Fast Change and objects for Management Dashboard reporting.
• Strong working knowledge of QlikView scripting, set analysis, aggregation functions, multi-dimensional objects, layout and design including chart properties and formats. strong understanding in creating Dashboards and scoreboards for the required KPI's in QlikView.
• Extensive experience in creating Pixel Perfect reports, Excel reports, Word reports, PowerPoint reports using NPrinting designer and automating the jobs in NPrinting Server.
• Hands on experience in customizing the QlikView, Qlik sense and NPrinting reports as per the business requirements.
• Expertise in Installing and Configuring QlikView Server and Publisher 10.0/11.x/12.x with QlikView web server / IIS in both clustered and non - clustered environments
• Experience in designing QlikView Document/User Setting Layouts to make consistent and professional optimized look to clients.
• Proficient in migrating reports from different platforms (such as Excel, Crystal reports) to QlikView.
• Ability to offer end-to-end solutions starting from requirements gathering, design, development and deployment of Business Intelligence applications.
• Comprehensive knowledge and exposure to different phases of Software Development Life Cycle (SDLC). Experience in Planning, Analysis, Design, Implementation and Maintenance using QlikView.
• Good Understanding of QlikView/Qlik Sense integration issues.
• Strong experience in UI Design by using different QlikView and Qlik sense sheet objects including multiple charts types, Trends, KPI's, custom requests for Excel Export, and Fast Change.
• Experience in1 tier, 2tier as well as 3 tire architectures of the QlikView.
• Experience in QlikView Server and Publisher maintenance - Creating scheduled jobs for QVD extracts and report reloads.
• Developed and scheduled reports using NPrinting tool and implemented user security for the reports.
• Experience in working with Data Warehousing and BI tools for developing various reports using QlikView.
• Performed different types of loads Incremental Load, Optimized Load & Binary Load.
• Strong skills in providing custom functionality using Macros, Triggers, Set Analysis.
• Experience in development of ETL scripts for Data Modeling along with resolving Synthetic Key and Circular Loop issues.

TECHNICAL SKILLS

BI Tools: QlikView™ 12/11.x/10/9, Qlik Sense June 2019/Nov 2018/QS 3.x, Tableau 9.x/10.x

Databases: Oracle, SQL Server, DB2, Teradata, Vertica, IBM Netezza

Tools: Aginity, Toad, SQL developer, Denodo

Languages: SQL, PL/SQL, T-SQL, C, C++, Java Script, Python

Additional Skills: Data Analysis

Data Modeling: Erwin data modeler

ETL: IBM Infosphere Datastage, Informatica

PROFESSIONAL EXPERIENCE

Sr. Qlik Sense/QlikView Developer

Confidential, Baltimore, MD

Responsibilities:

• 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 has 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.
• 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.
• Leveraged existing Qlik Marts for building Qlik Sense Applications during the migration phase.
• 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.
• Designing and developing dashboards for Sales, Marketing team and Production Managers and other business groups
• Involved in the developing of star schema and snow flake schema dimensional data model.
• Implementing security to the dashboard on different levels like Data level, Object level and Document level Security.
• Interacting with the different user groups and developing a data model according to their requirements
• Conducting Knowledge Transfer sessions to the end user groups regarding the ease and performance of the QlikView tool.
• Developed/modified SQL codes like stored procedures, functions, triggers etc. based on technical and functional specification documents.
• Developed load script using QlikView Functions (Date and Time, Keep, Join, Mapping, String, Interval match etc.)
• Connecting to various databases to retrieve the data and create relationships between the tables.
• 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.

Environment: QlikView 12.x, AWS, Qlik Sense June 2017/Sep 2018/Nov 2018/Feb 2019 SQLServer2012/2008R2, SQL Server BI Development, QlikView Enterprise Server, QlikView Server and Publisher, Windows 7.

QlikView/Qlik Sense Developer

Confidential, San Francisco, CA

Responsibilities:

• Worked on Developing Qlik Sense Dashboards for US Telecom and communications giant.
• Developed custom Mashups with mashup bootstrap template and Basic mashup template.
• Worked with multiple business users on requirements handling.
• Built the QVD Generator with flat files for Delta and full loads.
• Designed and implemented the QVF as a Database to handle all ETL Transformations.
• Expert in building the backend scripts and Data model.
• Expert in providing the user mapping for anonymous user and building section access for Directory users.
• Expert in following best practices in Qlik Sense Applications for better performance.
• Expert in building visualizations effectively with various charts depending on requirement.
• Developed Qlik Applications for E -commerce business in building scorecard reports.
• Worked on Agile Environment and managed the team.
• Experience in maintaining the Three Tier Architecture in Qlik Sense.
• Worked for Global service team and provided Qlik sense services to Different business around the world.
• Worked on enhancements in the existing Apps as a part of Service team.
• Provide documentation on Qlik Sense self-service functionality to users.
• Worked on end to end implementation of projects from requirements gathering, Developing, testing and deploying the applications to production.
• Created Complex data model with necessary fact tables and dimension tables.
• Extensively used Qlik functions such as Date and Time, Keep, join, Concatenate, Mapping Load, Inline Load etc.
• Worked with different types of loads Incremental, full and Resident loads.

Environment: Qlik Sense, QlikView 11.x, Excel, HIVE/Impala, Salesforce.com, CSV, QMC, SIMS tool, F5 Load Balancer

QlikView Developer

Confidential, Dallas, TX

Responsibilities:

• Developed proof of concept to check the functional feasibility of the QlikView implementation.
• Strong understanding in creating Dashboards for the required KPI's in QlikView.
• Work directly with business users to define and prototype QlikView Applications.
• Work with senior management to plan, define and clarify dashboard goals, objectives and requirement
• Design, Develop, Test, debug and implement QlikView/Qlik Sense solutions based upon specified requirement.
• Extract, transform and load data from multiple sources into QlikView applications.
• Created QVD's & updated on timely basis as database updates.
• Deploy applications on production server and set up automated data reloads
• Developed ETL Scripts while loading the data, resolving loops & ambiguity joins.
• Developed QlikView Functions (Date and Time, Keep, Join, Mapping, String & input Fields etc.)
• Created Pixel Perfect reports, Excel reports, PowerPoint reports and Word Reports using N Printing tool.
• Set Analysis in providing custom functionality to QlikView Applications.
• Experience in Using QlikView Functions (Date and Time, Keep, Join, Mapping, String& Input Fields).
• Created different publisher tasks like reload tasks, reduction tasks and distribution tasks using QlikView Enterprise Management Console.
• Gathered & loaded data into QlikView from various data sources (Sql server 2012, Oracle 10g, .CSV and excel files).
• Monitoring of the QVS (Access Point), QVW's and user accounts for the usage of the applications.
• Developed User Interactive Sheets & Reports as business needs
• Created Dashboards style of reports using QlikView components like List Box, Slider, Buttons, Charts and Bookmarks
• Developed extensively Alerts, Variables, Input boxes, calendar & Macros
• Implemented Star & snowflake schema (confirmed dimensions). Writing SQL Scripts to load the relevant Data in QlikView Applications
• Testing Applications using review checklists, Data quality for Quality Assurance before delivering to the end users.
• Developed Macros, SET ANALYSIS to provide custom functionality in QlikView Applications

Environment: SQL Server 2008, Excel, Windows Server 2008, QlikView11.2

DB Developer

Confidential

Responsibilities:

• Interacted with business users, business owners for requirements gathering, analyzing business process, and making necessary changes to schema objects to fulfill reporting/Data needs.
• Involved in analyzing existing complex systems to understand and document data elements, relationships, dataflow, dependencies related interfaces and data visualization.
• Involved in Implementing the Functional Decomposition Test Automation Framework as the base to define the automated testing process to validate the application functionality.
• Participated in KT sessions with manual team, studying and analyzing the Manual Test Cases to prepare the Regression Suite.
• Developed Data tables and Recovery Scenarios and organizing them in the Folder Structure of the Framework.
• Involved in analyzing the Functional Libraries and preparing the Functional Tracker Analysis report.
• Extensively worked on developing, reviewing and execution of Scripts on various builds to validate the functionality of the application.
• Prepared and evaluated the Test Result Reports.
• Extensively performed automated testing process to ensure the quality of the software.
• Involved in creating and maintaining technical design documentation and test cases for the application tested.

Environment: DB2, QlikView 11, Flat files, Data stage, SQL Server 2008, Microsoft Windows XP Professional, 2007 and UNIX.