SUMMARY:

• Over 8+ Years of real time experience in in business intelligence lifecycle projects from requirement gathering, documentation, data analysis, modeling, development, testing, production, deployment, Administration and support.
• Have 7+ years of experience in QlikView and 3.5 Years of experience in Qlik Sense. Worked on all versions of Qlik Sense from version 2.x to version 3.x and from .
• Extensive experience administering Qlik Sense Server, Scheduler, QlikView Server, QlikView Web Server and QlikView Publisher using QMC.
• Extensive experience in creating Pixel Perfect reports, Excel reports, Word reports, PowerPoint reports using NPrinting designer and automating the jobs in NPrinting Server.
• Implemented QlikView advanced features like Direct Discovery, Document Chaining, Grid Container, Dimension Limits, Write back functionality using Macros, On Demand extensions for N - Printing reports etc.
• Expert in Extracting, Transforming, Analyzing, Visualizing, and presenting data from diverse business areas in novel and insightful ways to take informed action.
• Good exposure working with Qlik Sense Mashups, Widgets etc. to integrate Qlik objects into Web portals.
• Monitoring the server logs as needed to find out if any job failures and implement Qlik view ops monitor system monitor dashboards to check user a nd server performance.
• Created and scheduled power shell scripts to monitor the server resources utilizations on a daily basis.
• 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.
• 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 with Workbench Utilities (Developer Hub) etc.
• Expertise in QlikView/Qlik Sense performance optimization and Load Balancing.
• 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).
• Prepared Qlik Sense proof of concepts as per the requirements and specifications. Expert in extracting, transforming, analyzing, visualizing, and presenting data from diverse business areas in novel and insightful ways to enable Directors, Vice Presidents, and Leadership teams to take informed action.
• 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.
• In-depth knowledge on setting up the SSL certificates, PingFederate SAML authentications for masking the URLs, External Load balancing setup and Web ticketing mechanisms on Qlik environments.
• Experience in complete project life cycle including Documentation, Analysis, Development and Testing under Agile methodology.
• Designed different audit dashboards for analyzing the trends and usage of the applications.
• Excellent knowledge and work experience on Qlik Sense Hub, QMC, Proxy, QIX, Qlik Sense Scheduler (QSS), Qlik Sense Repository (QRS) and QVF.
• Expert in all administration functions of Qlik Sense like SAML integration, User directory and Security Rules.
• Exceptional analytical, troubleshooting and communications skills to communicate directly or remotely with business partners/clients to identify key areas where Business Intelligence can solve business problems by delivering pertinent and timely information.

TECHNICAL SKILLS:

Business Intelligence Tools: Qlik sense Nov 2017, Feb 2018, Nov 2018, Feb 2019, June 2019,3.1,3.0,2.1, QlikView 12/11.2/ 10X/9X, Business Objects, Tableau

ETL Tools: Informatica Power Center 8.x/7.x, Microsoft SSIS

Databases: Teradata, Greenplum, SQL Server, Hadoop HIVE/Impala, Oracle 11g/10g/9i, IBM DB2, Sybase, MS Access 2000 and SAP BW.

Programming tools: Java Script, D3, HTML, CSS, VB Scripting.

Operating Systems: Windows XP/NT/2000, Windows Vista, Unix.

PROFESSIONAL EXPERIENCE:

Confidential, New York City, NY

Sr. Qlik Sense Developer/Admin

Responsibilities:

• Designed and developed Qlik Sense software applications and complex server-based Qlik Sense Apps from scratch to support reporting and Business Intelligence initiatives.
• Developed Qlik Sense Applications using Master items. Worked on Certified extensions from VizLib and Extensions available in Qlik Branch.
• Created Mashups for integrating global KPI’s on Fair Credit Lending, Alerts etc. into IDB Web portals.
• 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.
• Worked on Data Storytelling to combine reporting, presentation and exploratory analysis techniques to emphasize the data insights.
• Developed Master resource library across Qlik Sense Apps and trained users in leveraging them to create custom stories/additional visualization based on their need.
• Extracting, Transforming and Loading data from multiple sources
• Implementing Data Modeling process on Visualization and Reporting Technique .
• Creating QlikView Documents and transformations.
• Creating different Charts/ Visualization in Qlik Sense App for Analytics.
• Leveraged existing Qlik Marts for building Qlik Sense Applications during the migration phase.
• Provide inputs on Evaluating process and selecting appropriate decision making which meets Client requirements.
• Monitoring Application and Server environment.
• Checking Data- Reload and User Access Implementation.
• Creating and maintaining Technical Document to support Qlik environment.
• Good Experience with Qliksense management console.
• Designed and developed user manuals, product documentation using technical skills.
• Direct interaction with business analysts and managers on daily basis.
• Strong working experience in Load script and Data modelling.
• Working with all types of data loads and functions like Automap.
• Debugging the QlikView server issues through server logs, Fiddler logs.

Environment: Qlik Sense November 2018/Feb 2018, Oracle 11g, Business Objects, VB Scripting, D3.js, HTML5, CSS, NPrinting, Hadoop HIVE, Salesforce.com.

Confidential, Dallas, TX

Sr. QlikView/Qlik Sense Developer

Responsibilities:

• Scheduled Bi-weekly meetings with developers to have code reviews, to ensure the best practices are followed in development & design phase of the project
• Imported qvf and qvw source documents to QMC in QlikSense/QlikView and created publisher tasks with appropriate dependencies and schedules.
• Created User access rules and Login access rules to allocate licenses and tokens based on the user usage type.
• Written QlikView Scripts, macros, design Dashboard and Reports for different user groups
• Deployed the QlikView Application to the server and automated the jobs.
• Managed QlikView Licenses User CAL, Document CAL, Server Licenses, Publisher Licenses.
• Provided security for the developed boards.
• Installed Nprinting Server and Client in the remote systems, so that developers can access the client tool to create adhoc reports.
• Implemented different types of security on Qlik Sense streams based on the user access types
• Responsible for adding and managing Users , apps , objects , streams , ODBC data connections , content libraries and extensions in Qlik Sense environment.
• Responsible for backing up and restoring the Qlik Sense site and certificates used on central node, to use for restoring a site in emergency
• Pro-Active Monitoring and troubleshooting day to day issues based on the priority levels.
• Opened case tickets and worked with Qlik support on various production environment issues .
• Performance and Scalability test using JMETER/Qlik Scalability Tools.
• Implemented all levels of security at row level, field level, and sheet level.
• Created macros in VBScript to meet the business requirements.
• QlikView data modeling by building the Star schema and resolving loops/synthetic keys.
• Creating new extensions using the QlikView API and using effectively in dashboards.
• Building the user-friendly interface by modifying the QVPP files in the extension.
• Implemented the Various scenarios of section access.
• Created and Scheduled Weekly QlikView reports to distribute on email using NPrinting and publisher.

Environment: Qlik Sense November 2018/Sep 2018/June 2017, Oracle 11g, Business Objects, VB Scripting, D3.js, HTML5, CSS, NPrinting 17, Teradata, Netezza.

Confidential, San Jose, CA

QlikView/Qlik Sense Consultant

Responsibilities:

• Leveraged existing QlikView Data Marts and migrated QlikView Dashboards to Qlik Sense.
• Built few Qlik sense extensions in house using java script.
• Performance and Scalability test using JMETER
• Building the Extensions using D3 and Qlik APIs
• Building automated solutions using APIs.
• Qliksense performance optimization.
• Qliksense integration with Sales force.
• Installed, configured and upgraded Qlik Sense with SAML authentication.
• Strong experience in creating the extensions using Java script both in QlikView and Qlik Sense.
• Data modeling, analysis, design, testing, development and implementation
• Building the Qlik Sense Governance Model.
• Building the Governance dashboard for QlikSense.
• Fixing Complex issues using Advanced Set analysis.
• Implemented all levels of security at row level, field level, and sheet level.
• Building the Self-service Model Creating dashboards by extracting data from database write and externalize the load scripts, store the data as QVD files and designing the UI based on business/user requirements.
• QlikView data modeling by building the Star schema and resolving loops/synthetic keys.
• Creating new extensions using the QlikView API and using effectively in dashboards.
• Building the user-friendly interface by modifying the QVPP files in the extension.
• So that users can use the extensions effectively.
• Implemented the Various scenarios of section access.
• Created and Scheduled Weekly QlikView reports to distribute on email using NPrinting and publisher.

Environment: Qlik Sense 3.1,3.0,2.2, QlikView 12,11, Business Objects, Tableau, Oracle 10g/11g, MS Access, Spotfire, NPrinting 17, Teradata, MS SQL server, SAP BW

Confidential

QlikView Developer

Responsibilities:

• Full life-cycle development and implementation of QlikView for a packaged Help Desk/Service Desk module. Involved in Analysis, design, installation & implementation of the BI solution. Converted and enhanced an older Oracle Discoverer BI solution and implemented QlikView.
• Extracted data from the database, stored into QVD files, and wrote load scripts.
• Building the Qlik Sense dashboards from scratch.
• Eliminated Synthetic keys, ambiguous relationships and closed loops. Designed proficient dashboards according to the requirements.
• Enhanced existing dashboards with new functionalities and established a secure environment using QlikView Section Access.
• Created Input boxes, Pivot Tables, Straight Tables, Bar Charts, Buttons, Multi boxes on the UI to make it more accessible to User community.
• Implemented drill down and cyclic dimensions.
• Worked on integrating NPrinting setup with QlikView reports for creating automated Pixel Perfect reports and Office Reports.
• Handled end to end integration for NPrinting setup in Microsoft.
• Worked on complex SQL of multi joins, sub queries and unions.
• Worked with bulk volumes of data and extracted them from various sources like excel, Oracle, SQL Server through ODBC and OLEDB connections.
• Interact with senior managers for gathering requirements and presenting them with Health insurance analytical information.
• Created multiple database objects of tables, views and materialized views.
• Developed dashboards for data analysis with strong programming skills.
• Creating dashboards by extracting data from database write and externalized the load scripts, store the data as QVD files.
• Use of Set analysis and aggregation functions for sheet objects.
• QlikView data modelling by building the Star schema and resolving loops/synthetic keys following QlikView dashboards optimization.
• Implemented the Various scenarios of section access.
• Created macros in VBScript and building the QlikView extensions.
• Use of Set analysis and aggregation functions for sheet objects.
• Strong working experience in Load script and Data modelling.
• Working with all types of data loads and functions like Automap.
• Debugging the QlikView server issues through server logs, Fiddler logs.

Environment: QlikView 10, NPrinting 16.0.0, QlikView Dashboard, Business Objects, SVN, Oracle 10g/11g, Subversions, MS Access, OBIEE, MS SQL server, SAP BW

Confidential

BI/Report Analyst

Responsibilities:

• Involved in Gathering requirements, analyzing the business specifications and the reporting issues provided by the End users and Developed specification documents for reports as per client requirements.
• Interacted with Development and Management Teams.
• Used Framework Manager to import metadata from multiple data sources, to Design and Develop the Framework Manager models.
• Created Packages and published to the Cognos Connection.
• Scheduling and distributing the reports using Cognos administration.
• Designed and developed the reports using Cognos 8 Report Studio, Query Studio, and Analysis Studio.
• Knowledge on creating and maintain reports in OBIEE and Business objects.
• Involved in testing the reports and enhanced the performance of the reports by writing Complex SQL queries.
• Involved in moving to Deployment, UAT and Production.

Environment: Cognos 8.3/8.4 Suite (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, Cognos Office Connection), Oracle 10g, Cognos Access Manger, SQL Server 2005