SUMMARY:

• Around 6+ years of experience in Designing and Development of Business intelligence application with QlikView 11.0/10.0/9.0, Qlik Sense 1.0/1.1 and Tableau as BI tool
• Expertise in Installing and Configuring QlikView Server and Publisher 10.0/11.x with QlikView web server / IIS in both clustered and non - clustered environments
• Expertise in Developing QlikView Dashboards by integrating data flowing from different data sources like Oracle, SQL Server, Teradata, Hadoop HIVE, Salesforce, SAP,Text files and Excel documents.
• Explored on QlikView/QlikSense Management Console, QlikView Access Point, NPrinting.
• Created logins / users grant / deny permissions and other security issues in QlikSense.
• Created complex security rules in QlikSense Management Console including hiding sheets, apps, objects for multiple users.
• Expert in QlikSense Datamodelling.
• Experience in Nprinting with QlikSense.
• Qliksense integration with Sales force.
• Solid Hands on experience in implementing the new features of Qlik Sense like Story Telling, Beta maps integrations, Pivot Table, KPI Object etc
• Installing, configuring, Clustering, Load balancing and Multi-node installation of
• Qlikview and Qlik Sense Environment.
• QlikSense administration.
• Qliksense performance optimization.
• Enhanced existing dashboards with new functionalities and established a secure environment using Qliksense/QlikView Section Access.
• Excellent knowledge and work experience on QlikSense Hub, QMC, Proxy, QIX, Qlik
• Sense Scheduler(QSS), Qlik Sense Repository(QRS) and QVF
• Involved in Building the QlikSense Governance dashboard.
• Actively participation in migrating applications from Qlikview to Qlik Sense and took part in resolving critical compatibility issues during migration
• Worked with Macros, Filters, Variables, Set Analysis, Aggregate functions and Mapping Functions
• Connect QlikView & QlikSense to multiple data sources including Oracle, SQL Server, MS Access and MS Excel.
• Involved in Data Modeling and implementation of 3 Tier Architecture for HR Dashboard.
• Good knowledge and understanding of overall architecture with respect to QlikView server, QlikView publisher and QlikView Management Console
• Experience in implementing security for the QlikView applications
• Extensive experience in Prototyping Qlik Sense dashboards using Story Telling, Beta maps integrations, Pivot Table, KPI Object etc. for evaluation to Business
• Solid hands on experience designing mobile friendly dashboards using Qlik Sense including the mapping extensions and macros
• Adept in reviewing and analysing Data, Business Processes, and Business Requirements
• Good hands on Experience in managing and distributing User Access Pass (1:1 w.r.t Tokens) and Login Access Pass (1:10 w.r.t Tokens) on Sense Server
• Implemented Qlikview 11 advanced features like Auto Refresh, Direct Discovery, Document Chaining, Grid Container, Dimension Limits, Write back functionality using Macros, On Demand extensions for N-Printing reports etc.
• Strong understanding of Dimensional Modeling technique, Multi-dimensional database Schemas like Star Schema, Snowflake Schema, Fact and Dimensional tables, Section Access, Set Analysis in QlikView and DW concepts
• Extensive experience in basic components of QlikView Enterprise like List Boxes, Multi Boxes, Tables, Charts, Current Selection Boxes, Buttons etc.
• Experience in editing scripts for creating variables, fields, and calculated expressions, basic and aggregated functions
• Wide Variety of Functional Experience with Innovative Solution Design, Information Technology solutions and Passionate Leadership producing consistent results
• Experience in implementing and supporting the production of QlikView apps
• Hands on experience in formulating KPI’s within Qlikview using functions and set analysis
• Proficient in Designing QVD layer Data Mart within QlikView environment
• Experience in development of QlikView scripts for Data Modeling along with resolving Synthetic Key and Circular Loop issues
• Expertise in PL/SQL Programming skills. Experience in query optimisation& performance tuning. Used SQL Profiler, Execution Plan

TECHNICAL SKILLS:

BI Tools: QlikView11/10/9,QlikSense 1.1, Tableau

Databases: Oracle 11g/10g, SQL Server 2008/2005, Hadoop(HIVE)

Tools: Toad, SQL developer, SQL Server Management Studio

Languages: SQL, PL/SQL, T-SQL, Java

Scripting Technologies: JavaScript, VB script

Additional Skills: Data Analysis

DataModeling: Erwin Data Modeler

ETL: Informatica, Datastage, SSIS

PROFESSIONAL EXPERIENCE:

Confidential, South SFO,CA

Sr.Qlik Developer/Admin

• Experienced in full life cycle of QlikView and Qlik Sense application implementation and was responsible for Design, Development and Delivery.
• Lead developer of the Qlik Sense environment and supporting the business decisions.
• Qlik Sense Data Modeling and Development.
• Performance and Scalability test using JMETER
• Building the Extensions using D3 and Qlik APIs
• Building automated solutions using APIs.
• Installing, configuring, Clustering, Load balancing and Multi-node installation of Qlikview and Qlik Sense Environment.
• QlikSense administration.
• Qliksense performance optimization.
• Building the Mashups and Widgets.
• Data modeling, analysis, design, testing, development and implementation
• Fixing Complex issues using Advanced Set analysis.
• Advanced aggregation and SQL scripting.
• Qliksense integration with Sales force. Installed, configured and upgraded Qlik Sense with SAML authentication
• Understanding user requirements and expectations. Providing end to end reporting solution.
• Have a strong experience with GeoAnalytics (GeoMapping),Mashups,ODAG(On-demand app generation)
• Developed QlikView dashboards for diversified business areas in Finance, Customer Reporting, Vitality, MRA
• Designed, developed, implemented, and supported QlikView/Qlik sense dashboards. Integrated data sources and databases with QlikView/Qlik Sense and designed and developed data models and backend queries for presenting data.
• Designed the Data models, extract & transform the data from data sources like QVD files, Excel files in creating the QlikSense dashboards
• Involved in Dashboard migrations from Qlikview to Qlik Sense
• Gained experience in creating mobile friendly applications using QlikSense
• Good knowledge of deploying QlikSense dashboards on the Sense Server
• Experience working in agile methodology development environments, involved in Scrum meetings and experience with Rally software.
• Created complex security rules to hide sheets, apps, objects on QlikSense Management Console
• Involved in the installation, upgradation of the QlikSense server.
• Connect QlikView & QlikSense to multiple data sources including Oracle, SQL Server, MS Access and MS Excel.
• Qliksense integration with Sales force.
• Analyzed underlying data for potential discrepancies, investigate errors, and perform data cleanup.
• QlikView version 11.2 and Sense 3.1 was used for reporting inquiries of historical information.
• Tune/Optimize QlikView and QlikSense applications in order to meet enterprise performance standards
• Implemented security in QlikView and QlikSense applications using section access
• Create tasks on QMC for the developed dashboard
• Created Dashboards with different style using Qlikview components like List Box, Slider, Buttons, charts and Bookmarks.
• Migrated the reports from SAP BO to Qlikview
• Develop KPI’s using different charts viz. QlikMaps, Gauge chart, Block chart, Scatter chart, Pie Chart, Line Chart, Bar chart
• Extensions created using Java Script.
• Customized extensions(Scroll Text) in order to meet business needs
• Implemented business logic at chart level using advanced set analysis expressions and aggregation functions
• Built confidence interval charts for actuaries using complex statistical functions in QliKView
• Created alerts for specific events
• Built QlikView and Qlik Sense applications in order to improve user experience, performance with large data volume
• Create Jmeter scripts for performance testing
• Experience in pulling data from different ODBC, OLE DB data sources Oracle and flat files to create different complex QlikView dashboards as per given business requirement by leveraging the basic components of QlikView.
• Build data refresh strategy based on requirements,
• Created and managed ETL script generation using QlikView Script Builder Application.
• Implemented managerial hierarchy in Workers dashboard
• Implemented section access which prohibits users from viewing other’s data

Environment: QlikView 12,11, Qlik Sense 3.1(SR5), QMC, HIVE, Oracle 11g, PL/SQL Developer, SQL Server 2008

Confidential, Baltimore, MD

Qlik View/Qlik Sense Developer

• Gathering Business requirements from Clients, Providing Project Estimates & involved in Business Meetings.
• Actively involved with Business Analysts, Architects and End Users to understand the business requirements and design specifications and providing demos.
• Responsible for the implementation, analysis, design, development, administration and support of the QlikView dashboard.
• End to end implementation of all 3 QlikView environments i.e. Dev/Stage and Production.
• Worked with Qlikview to design visually rich interactive KPIs, Base Metrics and dashboards. Also created quick turn-around, ad hoc analysis for high priority internal clients.
• Backend scripting to pull data from multiple data sources.
• Developing SET ANALYSIS to provide custom functionality in QlikView Applications.
• Enhanced existing dashboards with new functionalities and established a secure environment using Qliksense/QlikView Section Access.
• Familiar in understanding the scope and purpose of stand-up meetings with the team, storypoint estimations for the tasks that are targeted for the sprint
• Solid Hands on experience in implementing the new features of Qlik Sense like Story Telling, Beta maps integrations, Pivot Table, KPI Object etc.
• Conducted training sessions for users on Qlik Sense usage.
• Developed Qlik Sense dashboards as per 3-tier architecture Implementation.
• Involved in designing, developing, testing, publishing, maintaining and supporting QlikView and Qlik Sense applications.
• Solid experience in creating the NPrinting E-mail reports on Daily basis, Monthly basis to the business users as per the requirements
• Good experience in validating the data and based on that giving the Star rating for the solution
• Expert level skill in UX design, integrating maps, color schemes, etc.
• Building QVD’s, QVW’s, QVF’s using various source systems like Oracle, SQL Server, Terra Data, Excel files, Flat files, MS Access and SAP BW.
• Created different types of dashboards using objects like List Boxes, Multi Boxes, Scatter charts, Bar charts, Combo charts, Pie charts, Line charts, Funnel charts, Buttons, Straight tables, Pivot tables, Containers.
• Involved in performance tuning of various QlikView and Qlik Sense applications.
• Created tasks and set dependencies using QlikView Publisher and monitored the tasks.
• Good knowledge of installing and configuring/administering Qlikview Desktop, Qlikview Server and Qlikview Publisher
• Assisted in installation and configuration of QlikView and Qlik Sense tools.
• Involved in optimizing the existing data models and load scripts to improve the performance.
• Simplifying complex expressions in the dashboards and improving layout structure.
• Implemented section access to limit the accessibility of data and objects to the users.
• Developed Proof of Concepts (POC) for various projects using QlikView and Qlik Sense.
• Developed generic QVD generator application to generate QVD’s.
• Implemented Security and involved in Deployment of QlikView Applications.
• Created detailed technical specification, business requirements and unit test report documents.
• Responsible for validating the developed applications against the pre-defined design standards.

Environment: QlikView, QlikView Publisher, QlikView Management Console, QlikSense 1.1, Sense Management Console, Microsoft SQL Server, Oracle 11g, Teradata, Excel, Flat files, MS Access.

Confidential, San Jose,CA

Qlikview Developer

Responsibilities:

• Created POC’s to demonstrate the scope of the project to the business users.
• Built QVD’s from Hadoop Hive/Impala, Web Services using SOAP request, Teradata, Oracle, and Sales Force.
• Extracting normalised data set from Informatica and from various database sources and build a data model with Master Calendar to connect the various fact tables with master tables
• Used QlikView sheet objects including Pivot, List, Multi-box, multiple charts types, Trends, KPI's, custom requests for Excel Export, and Fast Change and objects for Management Dashboard reporting.
• Implemented Direct Discovery Feature extensively in order to fetch the live transactional Data from Teradata warehouse.
• Executed the concept of Document Chaining to navigate from QVW file to the other by maintaining the state.
• QlikView best practices were used in scripting, set analysis and usage of variables.
• Designed/Implemented Star Schema while loading data from multiple data sources.
• Implemented data level Security using Section Access that hides selected areas of the dashboard and reduces data dynamically depending on user entitlements/privileges.
• Created QVD's & updated on timely basis as database updates.
• Made sure that no synthetic keys or circular loops are getting formed in the data model.
• Interacting with end users to gather the functional requirements and customise Qlikview dashboards accordingly and involved in developing, enhancing, re-engineering, maintaining, supporting Qlikview applications.
• Monitoring of the QVS, QVW's and user accounts for the usage of applications and user access to manage the limited number of licenses.
• Deploying the QlikView reports onto the QlikView servers.
• Interacting with end users to gather the functional requirements and customise Qlikview dashboards accordingly and involved in developing, enhancing, re-engineering, maintaining, supporting Qlikview applications.

Environment: QlikView11/11.2, Oracle 11g, Salesforce, Hadoop HIVE, Teradata, MS SQL Server 2008, Toad, Informatica 9.0

Confidential

Qlikview/ SAP Business objects Developer

• Understanding Business requirements and translate into Application and operational needs using Qlikview reporting tool.
• Interacted with customers to gather business requirements and developed functional and technical specification document
• Participated and proposed new business analysis for data which has no prior reports
• Planning, implementing, and developing BO/ universe (3.1)
• Built the Business Objects Universe and row/column level security.
• Improved the overall performance of the application and redesigned data model applying QlikView performance tuning techniques
• Installing and Configuring the Qlikview environment.
• Handling the Deployments.
• Explored the use of User Defined Functions to encapsulate commonly used logic in the stored procedure and maximised the readability of such Stored Procedures.
• Building the SAP business Objects reports and Universes.
• Extracted data from the database, stored into QVD files, and wrote load scripts.
• Involved in End to End Application, Design, Development and Deployment
• Developed load scripts to pull data from different data sources viz. Flat files, Oracle, SQL Server 2008
• Actively involved with Onsite/BAs/developers to understand the business requirements and design specifications.
• Presenting status reports and communicating project status to the Customer.
• Preparation of Test strategy and Test plan.
• Developed data model (Star schema) in QlikView which would suffice business needs
• Worked extensively on complex Data models as per client requirements. Eliminated Synthetic keys, ambiguous relationships and closed loops.
• Extracted data from the database and stored into QVD files.
• Creating data model with necessary fact tables and dimension tables.
• Developed 3 tier structure for approved prototype consisting of executive dashboards and detail dashboards with Stage 1 extracting data from data sources, stage 2 for building data model and stage 3 is the application layer
• Developed KPI’s using different charts viz. gauge chart, Block chart, Scatter chart, Pie Chart, Line Chart, Bar chart
• Implemented section access that enables users to access the section of the QlikView document depending upon their access privileges
• Implemented alerts for specific events in order to send email to region supervisors

Environment: QlikView 9, Oracle 10g, PL/SQL Developer, SQL Server 2008