Candidates About

 

PROFESSIONAL SUMMARY:                                                                                                               

Ø  Over  8+ years of Hands-on Experience on Business intelligence and analytics with strong experience on Qlikview, QlikSense and NPrinting in Development and Administration.

Ø  Experienced in end-to-end Business Intelligence enterprise solutions that include BI architecture, software development, deployment, infrastructure maintenance, system administration and security 

Ø  Hands-on Experience in Development of Qlikview and Qlik Sense.

Ø  Strong Knowledge and Extensive Experience in Qlik tools Such as Qlikview Desktop, Qlik sense hub, Qlikview Enterprise Management Console, Qlikview Publisher /Server.

Ø  Strong knowledge and Extensive Experience in ETL (Data Extraction, Transformation & Loading), Data modeling, Report designing and Performance Tuning using Qlikview.

Ø  Extensive experience with Qlikview sheet objects, scripting and building qvd’s and qvw’s.

Ø  Complete Life Cycle Development experience including Planning, Analysis, Design, Implementation and Maintenance using Qlikview.

Ø  Extensive Experience with Qlikview sheet objects including multiple charts types, Trends, KPI’s, custom requests for Excel Export, Fast Change and other objects for Management Dashboard reporting.

Ø  Extensive Experience in developing User Interfaces and Qlikview Dashboards using several sheet objects Chart-Box (Drill Down and Cyclic Group), List Boxes, Input Fields, Table Boxes, Calendars.

Ø  Strong Experience in working with various Charts (Pivot Tables, Straight Tables, Pie-Charts, Gauge-Charts, Line-chart, Combo-chart, Bar-chart, Scatter-chart).

Ø  Good experience in using the functionality Join, Concatenate, Keep in the preparation of Qlikview data model.

Ø  Good understanding of Synthetic Key, Circular Loops and implemented the process to eliminate.

Ø  Comfortable to use various sources like QVD files, MS Excel, Relational Tables, Binary QVW, Inline & txt files in developing the Qlikview reports.

Ø  Hands on experience in various loads - Binary Load, Inline Load, Partial Load, Incremental Load.

Ø  Utilized Alternate States to simplify application design and reduce on-going maintenance.

Ø  Designed and utilized master calendar for time related dimensions.

Ø  Proficient in SET ANALYSIS to provide customized functional Qlikview applications.

Ø  Extensive experience with Qlikview sheet objects, scripting, and optimizing applications and building qvd’s and qvw’s.

Ø  Hands on Experience with Qlikview Architecture in development and deployment.

Ø  Expertise knowledge in Set Analysis, Advanced aggregations, synthetic keys and circular references

Ø  Experience in setting up server, publisher configurations and security/ authorization at different levels.

Ø  Strong understanding of Dimensional Modeling technique, Multi-Dimensional Database Schemas like Star, Snowflake Schema, Fact and Dimensional tables, Automation and Macros interface, Section Access, Set Analysis in Qlikview and DW concepts

Ø  Expertise in Creating Dashboards using Qlikview 11.0, 11.2 using different data sources like Oracle, SQL Server, QVD files, text files, excel and generated dashboard as per the user requirement.

Ø  Implemented all levels of security at row level, field level, and sheet level.

Ø  Experience in building the Self-service Model by a User Template, which can reload all the data sources and section access automatically without any need of load script in Qlikview.

Ø  Experience in implementing the Qlikview/Qlik Sense governance model

Ø  Expertise in License Modeling for both Qlikview and Qlik Sense.

Ø  Involved in Performance Tuning using Incremental load logic which handles Insert, Update, Delete of source data and tuning underlying data in Qlikview Applications.

Ø  Experience in error handling and debugging of Qlikview reports. Expert in handling production issues like resolving synthetic keys, Loops.

Ø  Experience in using advanced aggregation functions and alternative states in Qlikview.

Ø  Experience in dimensional modeling using star and snow flake schemas. Very strong knowledge on data warehouse and data base concepts.

 

TECHNICAL SKILLS:

 

Languages	SQL, PL/SQL, C, Java, HTML, JavaScript
Business Intelligence Tools	QlikView9.0/10/11/11.2, Qlik Sense 3.0, Qlikview Management Console, NPrinting
Database Technologies	MS SQL Server 2012/2008/2005,Oracle11g/10g
Operating Systems	Windows 7/8, Windows XP, UNIX
Domains	Financial, Healthcare, Services, Manufacturing, Pharmaceuticals
Data Modeling	Dimensional Data Modeling, Star Join Schema Modeling, Snow Flake Modeling, FACT and dimensions tables, Physical and Logical Data Modeling
Others	MS Access 2013, MS-Excel 2013, MS Visio 2010, MS Power Point, MS Word, SQL Developer 4, Oracle SQL Developer 1.5.5

 

PROFESSIONAL EXPERINCE

 

 

Client:       Michigan Milk Producers Association, MI

Duration:  November 2015-Present

Role:         Sr. Qlik Developer

 

Responsibilities:

 

§  Developed Qlikview dashboards for diversified  business areas in Finance, Customer Reporting, Vitality.

§  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.

§  Qlikview version 11.2 was used for reporting inquiries of historical information.

§  Tune/Optimize Qlikview and Qlik Sense applications in order to meet enterprise performance standards

§  Implemented security in Qlikview and Qlik Sense applications using section access

§  Created Dashboards with different style using Qlikview components like List Box, Slider, Buttons, charts and Bookmarks.

§  Created different types of sheet objects like List boxes, Buttons, Multibox.

§  Sound knowledge of various functions of Qlikview/Qlik Sense technology.

§  Implemented Incremental Load to improve Load Time.

§  Created multiple tab dashboards. Created Pivot tables, Trend graphs, Bar graphs, Stacked Graphs, containers and so on. Created customer search. Used variables to show and hide objects based on user selection.

§  Installing, configuring, Clustering, Load balancing and Multi-node installation of Qlikview and Qlik Sense Environment.

§  Worked on Qlik Sense App development, templates, story generation, data modeling and Qlik Sense app performance optimization.

§  Develop data model (Star schema) in Qlikview using ETL concepts which would suffice business needs

§  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.

§  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

§  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.

§  Implemented section access which prohibits users from viewing other’s data

 

Environment: Qlikview 12,11, Qlik Sense 3.1, QMC, Oracle 11g, PL/SQL Developer, SQL Server 2008

 

 

Client:        Bed Bath and Beyond, Union, NJ

Duration:   May 2014-September 2015                                                                     

Role:          Senior Qlik Consultant

 

Responsibilities:

 

§  Developed Qlikview dashboards which enables business users to deep dive in their data and make decisions

§  Developed Qlikview dashboards which aids Qlikview server admin team to monitor enterprise wide Qlikview  servers in a single dashboard

§  Developed Qlikview scheduler dashboard which facilitates development team to view status of their data refresh

§  Evaluation of different BI Tools (As a part of COE team) viz. Qlik Sense 2, NPrinting, QVSource etc.

§  Experienced in creating and maintaining dashboards in Qlik Sense.

§  Experienced in developing dashboards using different inbuilt Qlikview API’s

§  Based on analytical/reporting needs build Data model in Qlikview by analyzing different data sources 

§  Interaction with different business owners/users which helps them understand how Qlikview can best suffice their analytical/reporting needs and what more functionality Qlikview can provide in addition to existing tool

§  Involved in providing solution to enterprise wide developers/users experiencing Qlikview related issues

§  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.

§  Created and managed ETL script generation using Qlikview Script Builder Application.

§  Implemented section access which prohibits users from viewing other’s data

§  Experience in developing reports in BI Publisher

§  Experience in Tableau server administration which includes publishing of Tableau dashboard to server and license management at site and  project level

Environment: Qlikview 9/10/11,Qlik Sense, Tableau, n Printing, Oracle 11g, PL/SQL Developer, MS ACCESS, SQL Server 2005

 

 

 

Client:         CVS Health, Boston, MA

Duration:    May 2013 – Mar 2014                                                 

Role:           Qlikview Consultant

 

Responsibilities:

• Work with a cross-functional team of developers and business analysts to deliver on strategic data and analytics initiatives.

§  Interact with senior managers for gathering requirements and presenting them with analytical information.

§  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.

• Qlikview data modeling by building the Star schema and resolving loops/synthetic keys.
• Extracted data from SQL Server using SSIS and later converted them into Qlikview reports
• Converted the existing reports of the company from the current BI tool i.e. SSRS and SSIS to Qlik View.
• Improved Qlik View's application performance by creating as much backend coding such that the server's memory is utilized rather than user's computer memory.
• Developed dashboards for data analysis with strong programming skills.

§  Creating dashboards by extracting data from database write and externalized the load scripts, store the data as QVD files.

§  Use of Set analysis and aggregation functions for sheet objects.

§  Qlikview data modeling by building the Star schema and resolving loops/synthetic keys.

§  Implemented the Various scenarios of section access.

§  Design and Develop NPrinting scheduled reports.

§  Use of Set analysis and aggregation functions for sheet objects.

§  Qlikview dashboards optimization.

§  Strong working experience in Load script and Data modeling.

§  Building the Qlikview extensions.

§  Debugging the Qlikview server issues through server logs.

 

Environment: Qlikview, QV publisher, QV access points, SQL server2008, CSS, HTML, NPrinting12.3, Share-point,SSRS, SSIS, Windows 7, Windows Server 2008, MS Visio.

 

Client:         Siemens Medical Solutions, Malvern, PA

Duration:    Nov 2012 to Apr 2013

Role:           Qlikview Developer

 

Responsibilities:

 

§  Involved in Requirement gathering & designing QlikView applications.

§  Created QlikView scripts to extract the data from Teradata, built QVDs,data model and dashboards

§  Developed dashboards using QlikView sheet objects using list boxes, multi boxes, charts, drill downs, cyclic groups, sliders (what-if-analysis) etc.

§  Developed Macros, Set Analysis in provide custom functionality in QlikView Applications.

§  Expert in Scheduling the QlikView Dashboards and Load files

§  Communicating with the QlikTech Team, India along with TCS Technology Excellence Group for latest features, versions/migrations

§  Experienced in Financial Services, Commercial domains and Sales Domains, Project Planning & Scheduling

§  Sound Knowledge in Dimensional Modelling Concepts for DWH and in ETL/Database Optimization.

Environment: QlikView 9, 10, Teradata, Windows 2003 Server 6.0 and IIS 6.0

 

Client:         InfoTech Solutions, INDIA

Duration:    Jan 2010 to Nov 2012

Role:           Qlikview Developer

 

Responsibilities:

 

§  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

§  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.

§  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

§  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 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

 

 

Educational Background:

 

Bachelor's in Computer Science

Kakatiya University