PROFESSIONAL SUMMARY:

• Over all 8 years as an IT professional and 7 years ofQlikview/Qliksense with strong background in developing Qlikviewapplications, 1 year in ETL design, database development, designing data modeling, data warehouse, requirements analysis and data conversions.
• Technically hands - on experience incorporating full range of BI Skills withQlikView11&12,QlikView/ Qliksense Designer, Developer, Server &Publisher.
• Active involvement in developing designs for software enhancements and making recommendations for improved business-customer relations.
• Experience in Agile and involved in scrum meetings and Waterfall Methodologies.
• Experience in Financial,Insurance,Manufacture and hitech domains.
• Strong abilities in development, design, testing and production support for successful execution of projects on Qlikview 3-Tier Architecture.
• Good knowledge on QlikView system and application architecture.
• Good experience on Oracle DB and knowledge on Vertica and Teradata DB.
• Experience in Data Extraction, Transformation and Loading, Report Designing and Performance usingQlikView.
• Strong Knowledge on Dimensional Modelling Technique, Multi-Dimensional Database Schemas like Star Schema, Snowflake Schema, Facts and Dimensions Tables, Section Access, Set Analysis, Trends and KPI, Custom requests for Excel export, Fast change and other objects for Management Dashboard Reporting.
• Hands-on experience in the design, development of end user applications for the data presentation and analytics, including dashboards, reports, monitors, and graphic presentation (Information Visualization & Analysis) usingQlikView11.2 BI platform.
• Good expertise in creatingQlikView/QlikSense Data Models from different data sources, to provide end to end solution usingQlikviewapplications and deploying toQlikviewServer.
• Solid understanding of QVD / QVW / QVS and QMC / QEMC management, working with large data and incremental load.
• Experience onQlikSenseScripting, Set analysis and Section Access.
• Extensively worked onQlikViewDesigner objects such as Multi box, List box, Containers, Maps, Buttons, Straight/Pivot tables and Different kinds of charts like Bar chart, combo chart, pie chart etc. and Variables, Fields, Calculated Expressions, Basic and Aggregated Functions.
• Experience in Migrating Reports from One Environment to Other.
• Involved in performance tuning ofQlikView& Qlik Sense apps for faster data reloads and efficient response times.
• Extensively worked on changing the reports according to client requirements and Optimization of Report Performance.
• Worked on Advanced PL/SQL Concepts (PL/SQL Tables, Record type, Bulk Collects and Bulk Binds).
• Strong Experience in creating Stored Procedures, Indexes, Functions and Triggers using Oracle PL/SQL.
• Experience in Debugging, Testing, and Deploying the Applications.
• Involved in requirement gathering from user through meetings, understanding the business from end user and technical perspective.
• Solely manage the activities like design, development, coding, testing and End-user .
• Ability to handle multiple priorities, develop and deliver cost, time, quality effective solutions and handling responsibilities independently as well as a proactive team member.

TECHNICAL SKILLS:

Query Languages: SQL, PLSQL, SQL server 2008

Database Query Language: Oracle 11g,12g My SQL,SAP

Data Modeling: Star and Snow flake schemas, Normalization Techniques

Operating Systems: Windows, Unix, Linux

Front end Development: HTML, CSS,VB,Javascript

Development Tools: SQL Developer,TOAD

Reporting Tools: QlikView 11.0,11.1, QlikSense 3.2

ETL: Informatica power center 9.1,Power designer.

WORK EXPERIENCE:

Confidential, New York, NY

Sr.Qlikview/Qliksense Developer

Responsibilities:

• Involved in full project life cycle implementation (requirement gathering to production)QlikSense 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 theQlikSensedashboards.
• 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 ofQlikSense.
• 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 withQlikSensefunctions, objects, Set Analysis, Variables to generate different kinds of charts. Also generated QVD files by writing scripts inQlikSenseapplications.
• 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.
• Trained users to build their own apps inQlikSense.
• 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 ofQlikSenseQMC, 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 NPrinting into the environment to publish the reports.
• Worked on NPrinting Tool and created Pixel Perfect customized reports as per the client requirements using the rich NPrinting reporting features.
• Distributed QS reports using NPrinting 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.
• 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, Nprinting 17.2, Data Modeling, Oracle 12g, DB2, MS SQL Server 2016, Windows 2008 R2, Excel, MS Access, Flat files.

Confidential, Maryland,MD

Sr.Qlikview/Qliksense Developer

Responsibilities:

• Worked in all phases of Qliksense application implementation life cycle of the project from requirements gathering to delivery.
• Connected to different ODBC, OLE DB data sourcesand flat files to create and schedule different complex reports as per given business requirement by leveraging the basic components ofQlikview/Qliksense.
• Updated the existing framework to perform incremental reloads and modified the scripts to improve and implement best practices on the existing application, and implement new business rules.
• Gathered requirements and performed the GAP Analysis, translated them into technical design documents.
• Extracted information from different data sources like SQL, MS Access and flat files by using different scripts like add, concatenate, resident, qualify, unqualified etc.
• Used QVD and incremental loading to delete, insert and update records.
• Extensively usedQliksenseFunctions (Joins, Concatenate, Keep, Apply Map etc.) in creation ofQlikViewapplication.
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Straight and Pivot Tables, and different variety of charts like Bar chart, Pie Chart, Gauge Chart, Funnel Chart, Line Chart etc.)
• Redesigned the existing applications to improve performance by eliminating Synthetic keys and Circular Loops in the data model.
• Split the huge tables into multiple QVDs, so that only the recent ones needed to be refreshed for data accuracy.
• Used Mapping Loads to eliminate certain dimension tables and reduce the number of tables and complexity in theQliksensedata model.
• Customized the scripts and necessary data transformation, created simple and complex expressions (using Set Analysis).
• Used Set Analysis and Alternate States for Comparative Analysis.
• Created Data Extraction scripts for creating QVD's,Qlik Sense Scripting variables, file, date, system, Mapping and Table functions and advanced functions like What-if-Analysis.
• Hands on experience on the third-party extension QlikMaps. Created maps based on spider analysis, custom pop up which displays bar chart, etc. both in QlikView &QlikSense.
• Using Extensions to integrate with QLiksense and to have better virtualisation
• ConvertedQlikviewdashboard to QlikSense Dashoard.
• Working on theQlikSenseapp by adding the sheets and adjusting the visualizations after the conversion.
• Developed dashboards inQlikSenseto replicate existing QlikView Dashboards/reports.
• 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.
• Knowledge in optimize,analze, and improve SQL query performance.
• Knowledge in relational database like Oracle,SQL Server.
• Experience working with SAP as a database source and work on the developement of reports.
• Troubleshooting and debugging the script for error correction and optimization.
• Gave production support to the existing applications.
• Testing applications and reports using predefined review checklists. Testing the data quality before delivering it to the users.
• Used Publisher and Server to automate the reports to perform Reload, Reduce and DistributeQlikViewApplication.
• Created Best Practices/Design Guidelines Document For Qlikview Reports.
• Coordinated with Offshore and Onsite teams to meet user requirements.
• Experience in NprintingQlikviewReporting.
• Using NPrinting Tool created Pixel Perfect customized reports as per the client requirements using the rich NPrinting reporting features.

Environment: QlikSense3.1 Qlikview Server and Publisher, QlikView 11.x and Qlikview 12 Microsoft SQL Server 2008 R2, Oracle 12g, SAP, Excel, Flat files, MS Access, NPrinting

Confidential

Qlikview/Qliksense Developer

Responsibilities:

• Performed admin activities like installing and configuring QlikView server, assigning User Cal’s to users, monitoring QMC publishing tasks and reload tasks.
• Involved in various stages of software development life cycle design, development and also testing.
• Working on various projects such as performance analysis, key performance metrics, and other data needs which gives insights of commercial operations using QlikView.
• Developed 3-tier qlikview/QlikSense development architecture and also worked on incremental loads.
• Worked on QlikView/QlikSense section access to provide authorization to respective dashboards to users.
• Designed and developed various reports and KPI dashboards including both backend and front end development in QlikView/QlikSense.
• Created Report Specification Documents for each Report.
• Involved in developing, enhancing, maintaining and supportingQlikViewapplications.
• Developed dashboards using different sheet objects like List boxes, Multi boxes, Buttons, Text objects, Input boxes, Scatter charts, Bar charts, Pivot Table, Straight Table, Containers, Slider, Funnel chart.
• Worked on QlikView set analysis and QlikView/QlikSense scripting to provide effective and informative insights to users.
• Developing scripting templates design guidelines and implementation plan.
• Optimizing existing data models and load scripts to improve the performance.
• Experience in UsingQlikSenseFunctions (Date and Time, Keep, Join, Mapping, String & input Fields etc )
• Created stored procedures, functions, triggers, cursors and packages for effective data model.
• Simplifying complex expressions in the front-end and improving performance.
• Analyzing the data and defining Key Performance Indicators.
• Created ad-hoc reports inQlikViewand supported the users with the adhoc reporting queries.
• Providing demo ofQlikViewdashboards to users to enhance their knowledge on all the key capabilities ofQlikViewapplication.
• Involved in testing process and performing the Unit testing and System testing.
• Perform error handling process, debugging and troubleshooting the jobs.
• Providing production support to theQlikViewapplications.
• Sending the updated status report to the managers on daily, weekly and monthly basis.
• Involved in security implementation onQlikViewapplications and deployment ofQlikViewapplications to the production environment.
• Designed the daily refresh process and created tasks and triggers.
• Continuously monitored log files like Event log files, session log files and performance log files to ensure effective functioning and performance of published applications.
• Created and Scheduled Weekly QlikView reports to distribute on email using NPrinting and publisher.
• NPrinting for distribution of reports in different format to respective users, adding users, groups, adding Triggers and scheduling of reports.

Environment: QlikView 11.x,12 ETL, SQL Server 2008 R2, MS Access, MS Excel, Flat Files, Windows Server 2008, CSV Files, Oracle 11g, SQL Scripting.

Confidential

Qlikview Developer

Responsibilities:

• Implemented 3 tier development architecture.
• Designed and developed a wide variety of charts and associated sheet objects to satisfy complex business requirements.
• Creating a relevant data model and front end to satisfy theQlikViewrequirements
• Worked with bulk volumes of data and extracted them from various sources like excel, Oracle, SQL Server through ODBC and OLEDB connections.
• Developed highly customizedQlikViewdashboard applications.
• Developed SET ANALYSIS to provide custom functionality inQlikviewApplications.
• Wrote Complex set analysis statements.
• Eliminated Synthetic keys, ambiguous relationships and closed loops.
• Enhanced existing dashboards with new functionalities and established a secure environment using QlikView Section Access.
• Extensively utilized nativeQlikViewfunctions within load scripts and charts to streamline application design.
• Code review as well as fine tuning of applications as well as fixing data model.
• Implemented section access to enforce row-level data security.
• Designed and developed the Data mart for theQlikViewdashboards in star schema/snow-flake schema. Identified various sources and designed the data transfer and transformations with inQlikView
• Developed dashboard's using different components ofQlikViewlike List boxes, Multi boxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc.
• Involved in gathering data from sources like QVD files, Excel, Oracle & Teradata DWs, binary QVW, Inline & txt files in developing theQlikView Data Models.
• Created daily, weekly, monthly and quarterly reports for the management team based on the Customer requirements.
• Coordinated with Offshore and Onsite teams to dicsuss on the requirement and get clarifications from business stakeholders.
• Provided Production support to the existingQlikviewapplications.

Environment: Qlikview 10x, Qlikview Server and publisher, Oracle 10g, PL/SQL, MS Office, QVDs, Windows 2008 R2 Server, Microsoft Visual Studio.

Confidential

ETL Informatica Developer

Responsibilities:

• Strong experience in Informaticapower center for (ETL) extraction, transformation and loading data from heterogeneous source systems.
• Participate in the discussions with the business solutions team in creating and implementing the plans for the designs like Flow Chart diagrams, Conceptual and Logical Diagrams, and defining the terms on the needs of the project.
• Experience in creating various transformations using Aggregator, Look Up, Update Strategy, Joiner, Filter, Normalizer, Sorter, Router, XML, Stored procedure inInformaticaPower Center.
• Experience in Performance tuning ofInformatica(sources, mappings, targets and sessions) and tuning the SQL queries.
• Developed batch Scripts for scheduling the sessions inInformatica.
• Worked extensively on database joins, procedures and involved in improving performance of queries by debugging the joins and data types of columns in database tables.
• Build and maintain SQL and PLSQL Scripts, indexes, complex queries for data analysis and extraction.
• Including tables, views, stored procedures, triggers, indexes, foreign keys, schedule jobs. knowledge of System Development Life Cycle (SDLC) and/or Relational Database Management Systems (RDBMS).
• Performed unit testing and documented the results.
• Worked closely with QA team during the testing phase and fixed bugs that were reported.

  Environment: Informatica 9x, Unix Shell scripts, PL/SQL, SQLdeveloper, WinSCP, Putty Oracle 10g.