PROFESSIONAL SUMMARY:

• Over 7+ Years of IT industry experience in Analysis, Design, Development, and Implementation of Business Intelligence applications.
• Exceptional analytical, troubleshooting and communication skills to communicate with clients to identify key areas where BI can solve Business problems by delivering relevant and timely information.
• Experience in Design and Development of Business intelligence applications with QlikView - 12.10/ 11.2/ 10.0 , Qlik Sense - 3.1/3.0/2.2/2.0 as BI tool.
• Experience in working with QlikView components such as QlikView Desktop, QlikView Publisher, QlikView Enterprise Management Console and QlikView Web Server.
• 3+ years of experience in generating reports using N-Printing (Regular/On-demand) which is the most advanced report generation, distribution and scheduling application for Qlik.
• Worked with N-printing Reports/Tasks/Schedules in 16.3 and 17.2.
• Implementation of 1-tier, 2-tier as well as 3-tier architecture(Data-Extraction, Data-Modeling and Application Development) which are recommended in QlikViewas best practices guide.
• Experience in developing User Interfaces and QlikView Dashboards using Charts (Drill Down, Drill up & Cyclic Grouping), List Boxes, Multi Boxes, Input Fields, Table Boxes, Calendars and Containers.
• Utilized QlikView and Qlik Sense to implement complex analytical solutions which access data from multiple sources (Oracle, SQL, Flat files, SAP BW, Excel, Access) by connecting through ODBC and OLEDB.
• Strong experience in working with Charts (Pivot Tables, Straight Tables, Bar charts, Scatter charts, combo charts, Pie-Charts, Gauge-Charts, Trellis).
• Implemented best practices to resolve Circular Relationships, Synthetic Keys inQlikViewand designing an optimized Data Model.
• Developed Qlik Sense dashboards by importing QVDs and binary load to compare Qlik Sense design over QlikView.
• Experience in using N-Printing for quick generation of reports from QlikView Documents and Qlik Sense applications and distribute them automatically in the formats like PDF, HTML, Pixel Perfect reports, Power Point, Excel and Word file
• Configuring N-Printing on Demand Extension object on a Clustered QlikView Environment.
• Performed different types of loads Incremental Load, Optimized Load & Binary Load.
• Involved in Optimizing existing QlikView dashboards with a focus on usability, performance, long-term, flexibility, and standardization.
• Good Exposure to working with QlikView Functions and Expression Scripts and Streamlining Reporting operations of QlikView Applications.
• Expertise in complete lifecycle Implementation of Data Modeling concepts like (Star Schema, Snow Flake Schema) & loading data from multiple sources.
• Proficient in SET ANALYSIS to provide customized functionality in QlikView Applications.
• Proficient in Designing Data Mart & Data Warehouse of QlikView for BI (Business Intelligence) Reporting Solutions.
• Experience in QlikView Server and Publisher maintenance - Creating scheduled jobs for QVD extracts and report reloads.
• Involved in Performance tuning to limit the response time for optimal performance of dashboards.
• Deployed QVWs on the production server, Created Reload and Distribution tasks on QlikView Server/publisher.
• Extensive experience in writing and tuning complex sub queries, SQL, PL/SQL stored procedures, functions, and triggers.
• Used triggers and stored procedures, which involves complex joins and Sub-Queries to simplify complex queries involving multiple tables from multiple data sources.
• Implemented Section Access on different levels i.e., Sheet, Object, document and Column level.
• Created QMC Tasks for Dashboard, monitor QlikView Server, reload jobs, grant and revoke user access, and troubleshoot reload failures by analyzing the reload logs.
• Comprehensive knowledge and exposure to different phases of Software Development Life Cycle (SDLC).
• Solid hands-on experience in implementing new features of Qlik Sense like Storytelling, Beta Maps integrations, Pivot Table, KPI Object, PDF Printing etc.
• Experience in packages, to extract, transform and load data (ETL) using SSIS.
• Dedicated, disciplined, detail oriented, with the ability to work both independently and as part of a team with excellent technical, analytical, and communication skills.

TECHNICAL SKILLS:

Business Intelligence Tools: QlikView: 9/10(SR3/4)/11.2(SR2)/11.2(SR10)/11.2(SR12), 12.0,12.10 Qlik Sense 3.0, 2.2, 2.1, N-Printing - 16.5, 17

Databases: MS: Access, Oracle 12c/11g, MS SQL Server 2012/2008, DB2

Database Tools: SQL * PLUS, Toad for Oracle Base (10.6.1.3)

ETL Tools: Hyperion Essbase, Planning, Informatica Power center, and SSIS

Office Tools: MS Word, Excel, Power Point, Project Management

Operating Systems: Windows 10/8.1/7/ XP/Vista, Windows 2000/2003/2008 and UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Qlik Sense / QlikView Developer

Responsibilities:

• Actively participated in Production meeting for requirement gathering working closely with business users and stakeholders.
• Involved in full project life cycle implementation (requirement gathering to production) Qlik Sense dashboards.
• Participated on business requirement document preparation.
• Responsible for Self-Business analysis tool Qlik Sense initial setup and end to end development of Qlik Sense applications.
• Involved in designing the data models, extract & transform the data from heterogeneous data sources like QVD files, Excel, SQL Server, Oracle, binary QVW, Inline & txt files in creating the Qlik Sense dashboards.
• Connected to different ODBC, OLE DB data sources (SQL Server, Oracle) and flat files to create and schedule different complex reports as per given business requirement by leveraging the basic components of Qlik Sense.
• Created multiple tab dashboards. Created Pivot tables, Trend graphs, Bar graphs, Stacked Graphs, containers and so on.
• Created SQL Stored Procedures and Views to fetch the data from database to build reports.
• Extensively worked with Qlik Sense functions, objects, Set Analysis, Variables to generate different kinds of charts. Also generated QVD files by writing scripts in Qlik Sense applications.
• Used a KPI/gauge object which has built in color switching to color code the fonts.
• Extracted data from multiple complex hierarchies from cross table excel files.
• Created Line Charts to show different trends of finance information over years using set expressions, year function, max () function etc.
• Built several Dashboards with current year statistics and trending information with ability to toggle between different metrics and drill down sheets and report detail charts for further analysis.
• Worked as Qlik Sense administrator to optimize Qlik Sense performance.
• Trained users to build their own apps in Qlik Sense.
• Worked on Qlik sense new objects Maps, KPI and object and document extensions for wire frames, and proof of concept applications.
• Implemented optimized loadings and performance tuning with the help of Qlik support.
• Security and mobile ability enabling and taken care of Qlik Sense QMC, repository and hub access.
• Used Set Analysis in the Line and Bar charts (Combo Charts) to show the user different trends of product sales over years.
• Loaded external JavaScript files to load resources from a Content Delivery Network (CDN) in several visualization extensions since the browser does not have to load the resource all over again.
• Installed and configured the N-Printing into the environment to publish the reports.
• Worked on N-Printing Tool and created Pixel Perfect customized reports as per the client requirements using the rich N-Printing reporting features.
• Distributed QS reports using N-Printing in the form of Excel/PDF/Power Point/Word etc. to users.
• Create, manage, clone, and delete nodes in Qlik Sense sites that are deployed in cloud computing environments.
• Installation of IE plugins and worked with business analysts to train the end users to use the reports effectively to build and customize their ad-hoc reports.

Environment: Qlik Sense 3.1, N-Printing 17.2, Data Modeling, Oracle 10g, DB2, MS SQL Server 2016, Windows 2008 R2, Excel, MS Access, Flat files.

Confidential, Charlotte, NC

QlikView developer

Responsibilities:

• Collaborated with Business Analysts to understand the requirements for application development and translated that into technical specification document.
• Extract the data from SQL Server which is fed from different sources where the physicians and nurses enter the data
• Created 3 Tier architecture to load the data intoQlikViewapplication.
• Eliminated synthetic keys using concatenation and/or Qualify based on the nature of synthetic keys.
• Design and develop user friendly application by providing apt graphs for the business requirement and reducing complexity in data model.
• DevelopedQlikViewDashboard using Drill down & Cyclic Grouping in charts, Pie chart, Line charts Scatter chart, Sliders, KPI's and Date Island for a self-service.
• Worked closely with Business to design, develop and enhance theQlikViewDashboards.
• Implemented complex set analysis to show various time based KPIs.
• Worked on N-Printing Tool and created Pixel Perfect customized reports as per the client requirements using the rich N-Printing reporting features.
• Distributed QV reports using N-Printing in the form of Excel/PDF/Power Point/Word etc. to the users.
• Performance tuning of dashboard by implementing best practices of QlikView
• Created an Ad hoc report for self-service.
• Implemented the security for the applications using Section access based on their User name.
• Split the huge tables into multiple QVDs, so that only the recent ones needed to be refreshed using Incremental load.
• Deployed application onto server and distributed based on active directory groups using QMC
• Refresh or Schedule the Tasks on timely manner, Managing Cals, Managing the server management for Errors or Failures.

Environment: QlikView 12.10, Qlik server and Publisher, Qlik N-Printing Designer and Server 16.7, SQL server report builder 10.50, SQL server 2008, MS EXCEL.

Confidential, Chicago, IL

QlikView / Qlik Sense Developer

Responsibilities:

• Work directly with business users to define and prototype QlikView Applications. Worked with senior management to plan, define and clarify dashboard goals, objectives and requirement.
• Installed and configured complete QlikView Desktop in multi clustered environment.
• Gathered functional and non-functional client requirements to optimize the design of BI deliverables (reports, dashboards, alerts, visualizations).
• Data modelling, analysis, design, testing, development and implementation
• Experience withQlik Sense Extensions and workbench
• Generate QVD files created by ETL logic to feed QlikView applications
• Ability to optimize existing QlikView reports to improve business productivity.
• Implementing the QlikView dashboard security model using Section Access. Implemented all levels of security at row level, field level, and sheet level.
• Used conditional statements, set analysis, dynamic actions, conditional show or hide of objects or fields.
• Used QlikView Scripting and Complex SQL coding for loading and transforming.
• Use of Set analysis and aggregation functions for sheet objects.
• QlikView data modelling by building the Star schema and resolving loops/synthetic keys.
• Developed QlikView Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box and Calendar & Date Island.
• Develop QlikView Dashboards using Drilldown & Cyclic Grouping.
• Developed Macros, Set Analysis in provide custom functionality in QlikView Applications.
• Deploying the QlikView reports onto the QlikView servers and Publishing the reports on Access Point.
• Used various Charts, aggregation functions, set analysis statements for designing the dashboard.
• Equipped the dashboard with an automation trigger to update the data in the dashboard whenever the database is updated.
• Developed applications in the desktop as well as in the Qlik Sense hub and shared the apps with the team through Qlik Sense Cloud.
• Used Java Script to embed some of extension objects into Qlik Sense.
• Importing data from Oracle Database and using SQL scripts to join the data tables and pull the required data.
• Worked on Incremental Loading to store data into History table and to enable dashboards to reflect rolling back data.
• Designed and developed BI Reporting solution enabling users to effectively utilize the tools to create Analytical Reports, Dashboards, and Scorecards, helping clients align KPIs performance metrics to strategic drivers and priorities.

Environment: QlikView 11.1 (SR1), Qlik Sense 1.x, 2.x, Qlik server and Publisher, SQL server report builder 10.50, SQL server 2008, Oracle 11g, MS EXCEL, Windows server 2008 R2, 2010.

Confidential, Miami, FL

QlikView/ Qlik Sense Developer

Responsibilities:

• Actively participated in Production meeting for requirement gathering working closely with business users and stakeholders.
• Involved in designing the data models, extract & transform the data from heterogeneous data sources like QVD files, Excel, SQL Server, Oracle, binary QVW, Inline & txt files in creating the QlikView dashboards
• Developing the high-end visualization QlikView Dashboards using QlikView objects.
• Expertise in building QV objects for different requirement such as straight table, pivot table, different charts (Bar Chart, Line Chart, and Scatter Chart).
• Performed data modeling on requirements analysis by creating table displays, logical data model, star schema models and table designs.
• Extracted data from multiple complex hierarchies from cross table excel files.
• Created Line Charts to show different trends of finance information over years using set expressions, year function, max () function etc.
• Built several Dashboards with current year statistics and trending information with ability to toggle between different metrics and drill down sheets and report detail charts for further analysis.
• Implemented Pick Dimensions and Pick Measures as Custom reports tab at the Dashboard. Extensively used variables to meet various requirements.
• Worked on set analysis and advanced aggregation functions. Applied document event trigger and field event triggers.
• Implemented secure environment using QlikView Section Access. Implemented QlikView dashboards distribution to business users using Section Access to dashboards, providing CALs to documents.
• Optimized existing Data Models like changing Load scripts to load data in optimized way to achieve reduction of loading time, simplified complex expressions in the front-end and improved layout structure
• Implemented all levels of security at row level, field level, and sheet level.
• Worked with Variables to hide/show the necessary objects and perform logics according to requirement.
• Used Qlik N-Printingapps to organize the created entities, such as filters or reports.
• EmbeddedHTMLreports into emails using N-Printing, so that recipients can make data-based decisions directly by reading an email, even on a mobile device.
• Created tasks and reduce, reload, and distribution of Publish the Reports using QMC.

Environment: QlikView11.2, Qlik Server/Publisher (QMC), N-Printing 16, SQL Server 2008 R2 Enterprise.

Confidential, Landisville, PA

QlikView/Qlik Sense Developer

Responsibilities:

• Understanding the requirements from the business users and their reporting needs. Suggested better way of presenting layout /Sheet Objects and developed the architecture of prioritized reports which were accepted and successfully implemented in the dashboards.
• Development of QlikView BI Applications from Scratch with all Performed planning, design from the gathered requirements which were focused on aggregating, counting, Reconciliation of Physician’s Sample requests to a Pharmaceutical company which manufactures the drug and the distribution of the drugs from the company in different US States.
• Used Index, Concat, Chart Field Functions like GetSelectedCount (), GetCurrentField () etc. functions for enabling the conditions on the dimensions in the Ad hoc Sheet.
• Used Drill Down and cyclic groups on Bar Charts and Table Charts.
• Created Some triggers like Document on Open Action trigger to set current date, Field Event Trigger - on Select and On Change etc.
• Used ApplyMap, MapSubString, Autonumber functions as part of some data modeling techniques while creating composite keys.
• Used some inter record functions like Exists, Peek, Previous, FieldValue while scripting/Data modeling and Above (), Below (), RowNo () etc. while designing the User Interface.
• Developed Fast Change Charts by using both Cyclic Groups (merged Expressions and fields) and Drill Down groups.
• Successfully passed through the QA Environment and implemented on Production and currently working as post production support.
• Installed Qlik View Server and configured the Publisher and was involved actively in the Server migration and the Fresh QlikView Installation process.
• UtilizeQlikViewPublisher for client application rollout toQlikViewAccess Point and administrator security using Active Directory technology. Advanced report generation, distribution and scheduling application for QlikView using N-Printing Designer.
• Scheduled the reports, provide On Demand buttons in the Dashboard and to process XML files to kick off jobs using N-printing Server.
• Good Knowledge ofQlik Viewpublisher implementing PDF Distribution and Data Reduction.
• Installed, configured and deployed the application on QlikView server and Imported data from different sources such as Oracle, SQL Server, MS Access, XML files and flat files using OLE DB/ODBC connections.
• Conducted and managed the design and development of high volume, high performance QlikView in-memory solution to support over 1 billion daily transaction volumes.
• Collected and analyzed business requirements, developing engineering prototypes and using POC to facilitate KPI Metrics dashboard design across different regions and business units.
• Participated in design and code reviews, QA/UAT testing, enhancement design and development, and deployment to support day-to-day business operations
• Involved in the development/implementation of Single sign on (SSO) and implemented security for company’s Active Directory Users and external users.
• Task set ups were done using QEMC and created architecture for the interdependent applications and to execute in proper order.
• Created Custom Users list for the external users who are not a part of the Client’s Active Directory and made the application accessible.
• Created QMC tasks/scheduled windows automated jobs and used batch files to reload the applications.
• Implemented Security & involved in daily Deployment of QlikView Applications.

Environment: QlikView 11.2 - SR9, Oracle SQL Developer 3.2.20 T-SQL, HTML, CSS, JQuery, JSFiddle, Windows 2012 Enterprise server, Excel, Qlik Sense -2.0.2, N-Printing

Confidential, Brecksville, OH

QlikView developer

Responsibilities:

• Gathered the requirements from Business Users and passed on the requirements to the team.
• Developed User Interactive Sheets & Reports as per business needs.
• Worked on designing the Data Model and Construction of the Data Model and implemented the Star schema for better QV optimization
• Developed Link Tables, Concatenation (Resolving Loops & model ambiguity).
• Created Dashboards style of reports using QlikView components like List Box, Slider, Buttons, Charts and Bookmarks. Developed KPI’s and set analysis applications.
• Developed extensively Alerts, Variables, Input boxes and Calendars.
• Gathered & loaded data into QlikView from various data sources (SQL SERVER 2008, Oracle 10g .CSV and Excel files).
• Generate new QVD files created by ETL logic to feed QlikView applications.
• Included the enhancement scripts to the existing QV scripts and performed the actual load to test the overall functionality of the application.
• Coordinated with ETL team and performed integration testing to check data discrepancies.
• Automated QlikView jobs in QlikView Publisher and rolled out to QlikView Access Point and administered Security using Active Directory.
• Analyzed the existing QlikView data model, script logics and the ETL business logic for the existing QlikView applications.
• Executed the scripts and checked the incorporated script changes in the Application.
• Improved the overall performance of the application and redesigned data model applying QlikView performance tuning techniques.
• Published Client application using QlikView Publisher and rolled out to Shared Drive with security permissions using Active Directory features.
• Used advanced scripting, alternate states for comparative analysis, set analysis, VBScript, advanced aggregation functions, advanced charts for applications and document chaining.
• Created layout themes and applied it to the several QVW’s.
• Good understanding in monitoring the various services in QMC, Task setup, managing client licenses, mounting folders, session collaboration, enable session, performance and audit logging, type of authorization (NTFS and DMS), loop and reduce and Section access management in PAT.
• Working knowledge of QlikView Server, QlikView Publisher, and QlikView Enterprise Version.
• Developed SQL Scripts in validating data from different data sources. Mentoring Business User Groups.

Environment: QlikView 11.0 (SR2), QEMC, SQL Server, DB2, Windows 2008 Server, HTML, VBScript, MS TFS, MS Excel.

Confidential, Englewood, CO

QlikView Developer

Responsibilities:

• Gathered the requirements from Business Users and passed on the requirements to the team.
• Worked on designing the Data Model and Construction of the Data Model and implemented the Star schema for QV better optimization.
• Installed, configured and deployed the application on QlikView server and Imported data from different sources such as Oracle, SQL Server, MS Access, XML files and flat files using OLE DB/ODBC.
• Created Dashboard reports to track all the way through ship to final acceptance phases.
• Developed executive Dashboards in QlikView delivered through the web, enabling to measure the performance of the business with analytical capabilities.
• Created Dashboards with complex sheets which include List boxes, Statistic boxes, and containers, different charts (bar charts, scatter charts, Heat charts, and Block charts and pie charts) to show the statistics of the sales held on different products in different years.
• Created static reports using straight tables and pivot tables with spark lines and mini charts
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using the QlikView Publisher.
• Worked on upgrade of QlikView environment from QV 10.0, QV 11.0 versions.
• Designed, developed, implemented and tuned multiple QlikView applications for the Sales, IT.
• Used advanced scripting, Alternate states for comparative analysis, set analysis, VBScript and JavaScript macros, advanced aggregation functions, advanced charts for applications and Document chaining
• Created Layout themes and applied it to several QVW’s.
• Involved in performance tuning of Dashboards to improve the response time for the users accessing the documents via access point by reducing the size of the QVW.
• Good understanding in monitoring the various services in QMC, Task setup, managing client licenses, mounting folders, session collaboration, performance and audit logging, type of authorization (NTFS and DMS), loop and Section access management in PAT

Environment: QlikView 10, QEMC, SQL Server, DB2, Windows 2008 Server, HTML, VBScript, JavaScript, MS TFS, MS Excel.

Confidential

SQL Developer

Responsibilities:

• Converted Data Transformation Services (DTS) application toSQLServer Integrated Services (SSIS) as assigned.
• Developed DTS packages to extract, transform and load into the campaign database from OLTP database using ofSQLServer 2005 Integration Services (SSIS).
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Configured load balancing, backup/recovery, sizing and space management, PL/SQLtuning, diagnostics, and proficient with the use of Oracle's Enterprise Manager Tool.
• Worked on Migration of packages from DTS usingSQLServer Reporting Service (SSRS).
• Generated reports usingSQLReporting Services for customized and ad-hoc Queries.
• Involved in creating calculated members, named set, advanced KPI'S for the SSAS cubes.
• Experience with configuration, load balancing, backup/recovery, sizing and space management, PL/SQLtuning, diagnostics, and proficient with the use of Oracle's Enterprise Manager Tool.
• Designed and created the table schema and stored procedures that will be used in Data QC.
• Integrated SharePoint Server with SSRS and deploying SSRS reports on to SharePoint Server.
• Created and Maintained SharePoint Site for Issues Tracking and Reporting Weekly & Monthly Status & Metrics.
• Designed and developed the Data QC Maintenance website that will be used to maintain the application tables, execution of main Data QC store procedures, and report generation that will be exported to Microsoft Excel file.
• Responsible for documentation of system related activities.

Environment: DB2,SQLServer, Windows Enterprise Server, BizTalk Server, Erwin, IIS 6.0, .NET, Erwin, Microsoft Visio, SFTP, Microsoft Reporting Service.