PROFESSIONAL SUMMARY:

• 5+ Years of IT professional experience with 4+ years’ experience in all aspects of designing and developing Business intelligence applications with QlikView & Qlik Sense.
• Ability to offer end - to-end solution starting from requirement gathering, design, development & deployment of Business Intelligence applications. Experienced with Agile Development Methodology in providing quick analysis and visualizations for business users.
• Expertise in QlikView Desktop, QlikView Server & Qlik Sense in aspects of development, deployment and administration.
• Experience with QlikView objects including multiple charts types, Trends, KPI’s, Bookmarks, Pivoting, custom requests for Excel Export, Fast Change and objects for Management Dashboard reporting and other KPI’s.
• Created QVD’s & updated on timely basis as d Confidential base updates. Developed ETL Scripts while loading the d Confidential, resolved Circular Relationships, Synthetic Keys.
• Involved in Optimizing existing QlikView dashboards with a focus on usability, performance, long-term, flexibility, and standardization.
• Experience in working with Qlik Sense extensions such as Quick Map, Word Cloud and Word Map.
• Security Implementation using Section Access script, dynamically hides selected areas of the dashboard depending upon user privileges.
• Experience in implementing triggers using macros to provide custom functionality in Dashboards.
• Performance tuning by analysing and comparing the turnaround times between SQL and QlikView.
• Strong understanding of Dimensional Modelling technique, Multi-dimensional d Confidential base Schemas like Star Schema, Snow flake Schema, Fact and Dimensional tables, Section Access, Set Analysis in QlikView and DW concepts
• 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.
• 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.
• Created d Confidential models for power users to create their own ad-hoc queries.
• Strong knowledge in designing and developing QlikView and Qlik Sense dashboards by extracting d Confidential from different sources like Sales Force, SQL server, oracle, SAP, Hadoop, Excel files, XML files, Flat files.
• Knowledge of advanced features in QlikView like Alternate States.
• Experienced in QlikView Server and Publisher maintenance - scheduling jobs, user management and deployments.
• Experience running complex and high volume ETL processes.
• Excellent working knowledge in D Confidential Warehousing Models, RDBMS concepts, SQL, PL/SQL, Oracle and SQL Server.
• Developed ETL Scripts to resolve Circular Relationships, Synthetic Keys & Modelling Issues.
• Expertise in optimizing, Debugging and testing SQL queries.
• Expertise in using NPrinting.
• Expertise in using Extensions and Mashup for better visualizations in Qlik Sense applications.
• Excellent communicative, interpersonal, intuitive, analysis and leadership skills with ability to work efficiently in both independent and team work environments.

TECHNICAL SKILLS:

Business Intelligence Tools: Qlik Sense, QlikView 10.0/11.0.

Languages: SQL, PL/SQL, C, Java, HTML, CSS, Java Script

D Confidential base Technologies: Oracle SQL Developer 3.0.04, Oracle11g/10g, MS SQL Server 2012/2008, Terad Confidential 14/13x, Netezza, DB2

Operating Systems: Windows Hyper-V, Windows, Cent OS, Ubuntu

D Confidential Modeling: Dimensional D Confidential Modeling, Star Join Schema Modeling, Snow Flake Modeling, FACT and dimensions tables, Physical and Logical D Confidential Modeling

Methodologies: SDLC, Agile Software Development.

WORK EXPERIENCE:

Confidential

Qlik Sense Developer

Responsibilities:

• Involved in designing the d Confidential models, extract & transform the d Confidential from heterogeneous d Confidential sources like QVD files, Excel, SQL Server, Oracle, binary QVW, Inline & txt files in creating the Qlik Sense dashboards.
• Connected to different ODBC, OLEDB d Confidential 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.
• Involved in D Confidential modelling and worked on various complex models which involved in eliminating Circular keys, Synthetic keys.
• Developed charts as per the customer requirements as Monthly, Quarterly and Yearly for report analysis with charts provided by charts in Qlik Sense.
• Developed Drill through Dashboards, which enabled users to drill down between dimensions for better visualization.
• Used Set Analysis in the charts as per the customer requirement.
• Worked with Variables to hide/show the necessary objects and perform logics according to the user requirement.
• Implemented the concept of Master Library items and used the concept of Story generation to meet the user requirement.
• Optimized existing D Confidential Models like changing Load scripts to load d Confidential in optimized way to achieve reduction of loading time, simplified complex expressions in the front-end and improved layout structure.
• Implemented the various types of loads to improve the performance of the dashboards like Binary Load, Partial Load, In line Load, Incremental load.
• Implemented optimized loadings and performance tuning with the help of Qlik Support.
• Performed error handling process and debugging the applications.
• Use different color schemes for charts according to meet requirements.
• Worked on Qlik Sense new objects Maps, KPI and object and document extensions for wire frames and proof of concept applications.
• Created dashboards using Qlik Sense Extension Objects and Mashups.
• Involved in converting QlikView applications to Qlik Sense.
• Extensively worked with Qlik Sense Functions to meet the user requirements.
• Trained users to build their own apps in Qlik Sense.
• Involved in client communication sessions to evaluate client needs & ensure timely project deliver

Environment: Qlik Sense 3.2/3.0/2.2, QlikView 12/11, SQL Server, Oracle, Excel, Flat files, MS Project, MS Office suite (word, Excel, PowerPoint).

Confidential

Qlik Sense Developer

Responsibilities:

• Developing Qlik Sense Dashboards using Various functionalities of Qlik Sense - Chart types: Line, Bar, Combo, Map and Gauge charts, drill down, drill up.
• Design Develop and test Qlik Sense scripts to import d Confidential from source systems and test QlikView dashboards to meet business requirements.
• Implementing web application security and concepts - SSL, LDAP Authentication.
• Managing D Confidential in Qlik Sense application from QVDs. excel files, d Confidential base and external loading files.
• Creating Mashup and integrations in Qlik Sense using Qlik Sense Web Services/API's
• Working on Qlik Scripting, d Confidential analysis, BI D Confidential Models.
• Developing/Creating Qlik Sense Extensions to meeting business requirements.
• Developing/building dimensional model for facts and dimensions tables.
• Worked on the creation of the tasks, scheduling of the applications, reloading of d Confidential, distribution of applications and reducing the size of application. Created scheduled jobs through Qlik Management Console(QMC)
• 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.
• Involved in the installation, upgradation of the Qlik Sense server.
• Business User Engagement for overview of Qlik Sense and performing sessions for End Business users.
• Managing security layer with access management at the user level.
• Image Insertion into Pivot table, creating scattered charts based on requirements.
• Modifying existing Qlik Sense dashboards, communicate with the business users in case of any issues with using the applications and providing solutions.
• Performing detailed analysis of source systems, source d Confidential and model that d Confidential in Qlik Sense.
• Performance tuning of Qlik Sense dashboard in order to reduce the calculation time and improving the overall performance of the dashboard.

Environment: Qlik Sense 2.1/2.2, QlikView 11, Oracle (11g/12c), SQL, MS Office.

Confidential

QlikView Developer

Responsibilities:

• Integrated d Confidential sources and d Confidential bases withQlikView. Designed and developed d Confidential models and backend queries for presenting d Confidential .Designed, developed and implemented QlikView dashboards.
• Created Dashboards with different style usingQlikViewcomponents like List Box, Slider, Buttons, charts and Bookmarks.Optimizing the dashboards that are taking a lot of reload time.
• Developed SQL scripts to load business d Confidential and used VB macros and Set analysis to create customized reports for regulatory reporting.Developed KPIs and set analysis application withQlikViewfunctions (join, concatenate, keep, apply map).
• Administered onQlikViewServer and Publisher, to manage user access, schedule refreshing of documents, mount completed applications.
• Tested Applications, ensuring the application met the requirements, D Confidential quality for Quality Assurance before delivering to the end users.
• Support user Acceptance testing for the dashboard functionality. ReviewedQlikViewerror logs for exceptions to provide production support.Interacted with the Customer Support Group for domain requirements gathering.
• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Implemented Security and involved in deployment of QlikView Applications to the access point.
• Assisted Project Manager in developing in project timeline and resource estimations. Implemented Star Schema & Snow Flake for Dimensional D Confidential Modelling in QlikView.
• Developed and maintained QlikView load scripts across multiple d Confidential sources.
• Extracting d Confidential from large tables and views into multiple QVD’s used by different applications.
• Developed Macros to provide custom functionality in QlikView application.
• Eliminated synthetic keys and loops in thed Confidential model and developed effective d Confidential models.
• Created and modified Business Intelligence analytical reports/ dashboards using QlikView Desktop. Imported d Confidential from different sources like SQL Server, MS Access, XML files and flat files using OLE DB/ODBC.
• Created daily, weekly, monthly and quarterly reports for the management team based on the Customer requirements in QlikView.
• Used section access and sheet access to make the application available to desired users.
• Managed schedules and reloading of QlikView d Confidential model QVDs and QVWs through QlikView server. Showed the statistics in bar charts and pie charts as per the client needs.

Environment: QlikView 10.0, Upgrade to 11.0, SQL server, SAP, SQL, MS Excel, Flat files.

Confidential

SQL Developer

Responsibilities:

• Understanding business d Confidential model having multiple schemas, each for an application.
• Involved in D Confidential base Schema design and development.
• Write complex queries and procedure adhering to design document.
• Involved in D Confidential Migration and D Confidential Consolidation Activities.
• Updated the d Confidential using D Confidential Manipulation language.
• Developed complex SQL queries to generate reports.
• Created indexes on tables and partitioning the table for SQL tuning purpose.
• Created complex views, materialized views on multiple tables as per the requirement.
• Created Triggers to enforce D Confidential Integrity.
• Monitoring SQL Server performance using profiler to find performance and find Dead Locks.
• Worked on creation of views to restrict the access to d Confidential in the table for security.
• Provide ad-hoc results by querying the d Confidential base.
• Perform basic query optimization.
• Analysing production issues arising from d Confidential base queries of the applications.
• Developed SQL Server stored procedures, functions, and d Confidential base views.
• Extensively used joins and sub-queries for complex queries involving multiple tables from different d Confidential bases.

Environment: SQL Server 2000 Enterprise Edition, Oracle, PL/SQL, Enterprise manager, MSOffice.