SUMMARY

• Around 5 Years of IT 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 Business Intelligence can solve Business problems by delivering relevant and timely information.
• Good Experience in developing different analytical applications using QlikView Server, QlikView publisher, and QlikView enterprise.
• Experience in Qlik families such as QlikView Desktop Client, Qlik Management Console(QMC), QlikView Server and Qlik Sense hub.
• Experience in Qlik Sense initial setup and end to end development of Qlik Sense applications.
• Experience of deploying Qlik Sense Dashboards on the Qlik Sense Server.
• Experience analytical database design and data modeling skills in Qlik Sense.
• Experience in designing QlikView documents and layouts to make consistent and professional optimized look to clients.
• Experience in implementing N - tier architecture (Extracting the data model, Transforming the data model and Application development).
• Experience in Optimizing QlikView applications at the server level, scripting level, and design level.
• Experience in Data modeling including Dimensional Data modeling, Star Schema and Snowflake schema, FACT and Dimensions tables, Physical & logical data modeling.
• Experience with QlikView sheet objects including Multiple Charts Types, Trends, KPI's and Bookmarks.
• Proficient in creating QV Data Models, QV Objects, Custom Reports and Data Visualizations using different data sources.
• Worked on Set Analysis for inclusion and exclusion of Dimensions.
• Experience in implementing Incremental load for the update of QVD's.
• Efficient in writing complex SQL Queries using Inner, Left, Right, Outer and Cross join.
• Experience in using NPrinting to generate Reports.
• Experience in using QlikView Functions (Date and Time, Keep, Join, Mapping & input Fields etc.) Conditional Statements and Variables.
• Expertise in Agile Software Development Process and techniques.
• Experience in extracting, transforming and loading data from multiple sources into Qlik Sense applications.
• Expert in Designing and Developing database applications, Entity Relationship Modelling (ERM), Data export/import, SQL programming &ETL procedures.
• Experience in Qlik Nprinting Server, Designer and Engine.
• Experience in optimizing Qlik Sense performance.
• Good Understanding of Relational and Dimensional Database Concepts.
• Deployed QVW's on the production Server, created Reloads and Distribution tasks on QlikView Server/publisher.
• Connected to different ODBC, OLE DB data sources to create and schedule different complex Reports as per given the client requirements by using the basic components of Qlik Sense.
• Experience in generating static reports using Qlik Nprinting.
• Created PL/SQL module which was used to integrate the existing data from third parties on to the database
• Communicated with clients to gather data and constructed data sources using ETL/SSIS.
• Experience in RDBMS concepts like User Defined Data Types, Indexes, Indexed Views, Functions, CTE's, Table Variables and Stored Procedures.

TECHNICAL SKILLS

Business Intelligence Tools: QlikView/Qlik Sense, Tableau, Informatica

Database Technologies: SQL Server, Oracle 10g/11g, Teradata, MS Access and Salesforce

Languages: SQL, T-SQL, PL/SQL, C, C++, Java, CSS, HTML, Python.

MS office: Project management, Excel.

Operating systems: Windows 10/8.1/7/ XP/Vista, Windows 2000/2003/2008 Server, and UNIX.

PROFESSIONAL EXPERIENCE

BI Developer

Confidential, CARY, NC

RESPONSIBILITIES:

• Collaborated with Business Analysts to know the requirements for Application Development.
• Worked on a large scale and data volume based applications.
• Worked on SQL scripts to load the data into QlikView applications.
• Worked on migrating applications from QlikView to Qlik Sense and took part in resolving critical compatibility issues during migration.
• Worked on optimizing QlikView performance.
• Responsible for gathering requirements, business, and technical rules, implementing QlikView and Qlik Sense applications.
• Implemented Incremental load & Binary loads to optimize the Reports and for performance tuning.
• Loaded the data from multiple data sources to build the consolidated Dashboards.
• Distributed the Workload across multiple-threaded engines using Nprinting.
• Worked on various QlikView functions to generate different kinds of visualizations.
• Suggested a better way to represent the charts by understanding the user requirements, which are successfully implemented in the Dashboards.
• Worked with Nprinting apps and organized various entities.
• Developed QlikView Dashboards using Hierarchic groups (drill-down) & Non-hierarchic groups (cyclic grouping).
• Wrote scripts to obtain the Information such as Date, Year, Month & Quarter from existing data.
• Extensively worked on functions like Lookup & Apply map for Data connectivity.
• Reviewed QlikView error logs and provided production support.
• Extensively Worked with Qlik Nprinting Server, Designer and Engine.
• Worked on NPrinting Tool and customized Reports as per the client requirements using the NPrinting reporting features.
• Implemented security for the Reports based on the responsibility hierarchy.
• Worked with Qlik Sense upgrade at the lab environment.
• Generated various kinds of reports using Qlik Nprinting.
• Used various visualizations like distribution plot, histogram, and Boxplot in QlikView.
• Worked on Data Modelling and built QVD's as per business requirement and Optimizing applications by using QVDs, removed synthetic keys and circular loops.
• Worked on deploying Qlik Sense Dashboards on the Qlik Sense Server.
• Automated and scheduled data loads of QVW documents using QlikView Publisher.

ENVIRONMENT: Qlik Sense 3.1/3.0, QlikView 12, Qlik publisher, NPrinting 17, QMC, SQL Server.

QlikView / Qlik Sense Developer

Confidential, CEDAR RAPIDS, IA

RESPONSIBILITIES:

• Worked with Business Intelligence team to learn about ongoing practices and processes.
• Developed Reports & Interactive sheets as per the requirement of the clients.
• Developed Dashboards using QlikView to monitor insurance and policy information.
• Used various types of sheet objects for Dashboard creation.
• Worked on various visualizations in Qlik Sense.
• Generated reports using Nprinting.
• Worked on Qlik Sense Dashboards using Qlik Sense extension objects and mashups.
• Worked on QlikView and SAP database connection to extract the data and store it into QVD'S for best optimization practices.
• Worked on converting QlikView applications to Qlik Sense.
• Created custom schedules for reports using Qlik Nprinting Newsstand.
• Developed Qlik Sense applications using various extensions.
• Created Static reports using QlikView Nprinting tool.
• Extensively worked with Variables and Aggregate functions.
• Worked with Qlik Nprinting Server, Designer and Engine.
• Experience in use of Set Analysis for data comparison.
• Developed complex Dashboards using KPI's, Filters, Variables and Prompts as per the client requirements.
• Implemented multiple tiers of QVD architecture depending upon the complexity of the applications.
• Implemented triggers to provide custom functionality in Dashboards.
• Created event trigger and field event triggers and implemented Incremental reload.
• Scheduled the Reloads as per demand and published Reports on the access point.
• Involved in performance tuning & deployment of applications in QlikView environment.
• Used Qlik Sense story telling module in presentations.
• Maintained the sheet security & controlled the sheets.

ENVIRONMENT: QlikView-11.2, Qlik Sense 2.2/2.0, NPrinting 16, QlikView Server/Publisher (QMC), SQL Server.

QlikView Developer

Confidential, NASHVILLE, TN

RESPONSIBILITIES:

• Used QlikView to develop Dashboards supporting the tracking and performance of patient and physician progress with new pharmaceutical treatments, showed daily feedback into functional and exciting visualizations.
• Used various charts for data representation and creation of Dashboards.
• Worked on QlikView Server and Publisher for user access management and to schedule refreshing of documents.
• Worked on the design and delivery of complex Dashboards. Created Dashboards style of Reports using various components of QlikView like List Box, Slider, Buttons, and Bookmarks making Reports more user-friendly for analysis purposes.
• Worked on scripts that made use of Variables and assigned data values to them & used them in various QlikView sheet objects Extensively worked on various functions like Above, Below, Pick, Peek & Previous.
• Implemented schemas like and Star and Snowflake.
• Worked on creating multilayer QVW applications.
• Worked on comparative analysis for comparison of the data.
• Identified Facts and Dimensions in relation to design Specifications.
• Improved load time using Incremental load.
• Made clients understand the applications by enabling the features which are requested by them.
• Used different color schemes for charts according to meet requirements.

ENVIRONMENT: QlikView-11.2, SQL Server, QMC.

QlikView Developer

Confidential, WILLMINGTON, DE

RESPONSIBILITIES:

• Collaborated with business users and application developers to Identify business needs and provided Solutions.
• Worked on with Qlik Management Console(QMC).
• Retrieved external data to QlikView Dashboards in terms of QVD's by making the connection through ODBC and OLEDB.
• Designed, Built, Tested and Debugged QlikView applications in QlikView test server environment.
• Analyzed QlikView Data models, Script logics and the ETL business logic for the existing QlikView applications.
• Distributed and scheduled tasks for reloading using QlikView Management Console.
• Eliminated synthetic keys and ambiguous relationships.
• Extensively worked on advanced aggregation functions.
• Experience in using Set Analysis on the front end to control the display of the data.
• Developed macros, Set Analysis and section access to provide functionality in QlikView applications.
• Built complex data into easily understandable for analyzing operations data by creating informative Dashboards reflecting data in different graphical interpretation with charts and table.
• Worked on the deployment of QlikView applications in the production.

ENVIRONMENT: QlikView-11.2, QlikView Server/Publisher (QMC), SQL Server 2008 R2 Enterprise.