Neelakandan N

Mobile No: +91-962*******

Email: acpqgh@r.postjobfree.com

[pic]

SUMMARY

. 4 years 9 months of professional experience in the area of Business

Intelligence leveraging Qlikview/BO and Dashboard Designer for various

types of industries.

. Highly skilled in designing Functional, Technical specifications and

process implementation roadmaps for business requirements.

. Strong understanding of Dimensional Modeling, Multi-Dimensional

Database Schemas (Star, Snowflake Schemas).

. Good hands-on Experience in Development of dashboards using QlikView

11, QlikMaps V2.1, GeoQlik 11 and other extension objects in QlikView.

. Good exposure on the shape files and Aquifer layers overlay.

. Expertise in ETL (Data Extraction, Transformation & Loading), Data

modeling, Report designing and Performance Tuning using QlikView.

. Proficient in creating QV data models, QV objects, reports, graphical

interactive UI and dashboard using different data sources like Oracle,

SQL Server, QVD files, Access, text files, excel documents etc. as per

the user requirement.

. Extensively worked on QlikView designer objects like straight/Pivot

tables, Containers, line charts, bar charts and Bubble charts Etc.

. Expertise knowledge in Set Analysis, Advanced aggregations, synthetic

keys and circular references.

. Worked on QlikView server/publisher to handle user security.

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

. Good Exposure towards the creation of dashboards with the integrated

data from web sites and database using the fuzzy logic.

. Hands on experience with the creation of maps using Geo spacial

information and integration of the same with the data from database.

. Worked on Central Management Server (CMS), Information designer Tool

(IDT)/Universe Designer, Dashboard Designer 4.0, InfoView & WebI Rich

Client.

. Designed universes to build WebI reports on relational databases.

. Developed dashboards using Xcelsius / Dashboard Designer by using

Query As A Web Service, Excel sheets and Universes.

. Good hands on experience in development of canned, ad-hoc reports and

dashboards.

. Good Hands on experience in report development in SAP Bo 4.0 and BOXI

R3.1.

. Had involved in many POC's for the dashboard creation in pre-sales

activities in both Dashboard Designer and QlikView 11.

. Experience in Dashboard, Universe and WEBI report

performance optimization.

. Involved in Full Development Life Cycle - Requirement Gathering,

Design, Development, Migration and Testing

. Good knowledge on GeoQlik 11 for the Geo spacial analysis using

QlikView.

. Undergone technical training for QlikView 11.

. Conducted trainings on SAP Business Objects 4.0 and QlikView 11.

. Conducted interviews for SAP Business Objects and QlikView

11.

. Excellent team player with good communication and interpersonal

skills.

EXPERIENCE SUMMARY

Organization Designation Duration

Mindtree Limited - Module Lead (01/2015) - Till Date

India

Mindtree Limited - Senior Software (03/2014) - (12/2014)

India Engineer

Mindtree Limited - Senior Software (08/2013) - (03/2014)

Singapore Engineer

Mindtree Limited - Senior Software (06/2012) - (08/2013)

India Engineer

CIBERSites India Pvt Consultant (08/2010) - (06/2012)

Ltd

TECHNICAL EXPERTISE

Reporting Tools QlikView 11, QlikMaps 2.1, GeoQlik11, SAP

Business Objects 4.0, BO XI R3.1, Dashboard

Designer 4.0, Xcelsius 2008

Databases MS SQL Server, Oracle 11g, SQL Developer, Sybase

Configuration Tool SVN

Concepts Business Intelligence, Data warehousing

EDUCATION DETAILS

M.C.A (Master of Computer Applications) from Bangalore University,

Bangalore

Degree/ Year of University/Board Percentage

Course Passing

M.C.A 2010 Bangalore University 77%

B.Sc. 2007 Calicut University 94%

Higher 2004 Kerala Higher Secondary 85 %

Secondary

Board

Senior 2002 Kerala Higher Secondary 85 %

Secondary

Board

PROJECTS HANDLED - Mindtree India

1. AIG Data Quality Assessment Project

Client : AIG

Duration : July - 2014 to Till Date

Team size : 6

Role : Senior Developer

Technology/Tools : QlikView 11, DB2, Data Stage, Microsoft Access

Project Description:

AIG DQ Assessment project involved the development of visualization

dashboards for Data Quality team to assess their results and improve the

business and processes. The prime focus of the POC is to identify the

errors whatever happening while doing the DQ Assessment and to identify

the scores based on different parameters. The POC involves the analysis

of different scores by project, system, Entity, Attribute, Domain,

Processes and different subjects like Brokers, underwriters, TIV and

Geography.

Responsibilities:

. Understanding business, requirement analysis, interaction with client

for requirement clarification.

. Analyzing the data model for finding out the different dimensions or

measures which needs to be used for decision making.

. Created the summary and detailed reports or dashboards for Commercial,

Corporate and Consumer businesses.

. Implementation of Data model in Qlikview using the tables provided at

DB level to incorporate the business logic involved in the dashboard.

. Creation of complex QlikView documents using QlikView 11.

. Creation of QlikView data files (.QVD) using QlikView 11.

. Customized the dashboard to in-corporate the complex requirements from

the business team.

. Creation of different visuals to achieve various requirements.

. Implementation of different types of drill downs and Slice and dice

concepts to achieve the user requirements.

. Performance tuning of the dashboard for different KPIs.

. Eliminated Synthetic keys, ambiguous relationships and closed loops.

. Designed proficient dashboards according to the requirements.

. Developed Drill through Dashboards which enabled users to drill down

between dimensions.

. Implemented the Slice and Dice / Drill Down functionalities using

Cyclic / Drill down groups.

. Created charts as per the customer requirements on Quarterly, Monthly

and Yearly for report analysis with charts provided by QlikView.

. Implemented the QA process for the dashboards for User Acceptance

Testing.

. Creation of various documents for the design and functionality of the

dashboards.

2. AIG GRA EDM Project

Client : AIG

Duration : Apr - 2014 to Jul 2014

Team size : 3

Role : Senior Developer

Technology/Tools : QlikView 11, QlikMaps 2.1, GeoQlik 11, Oracle 11g

R2, Quality Stage, Python

Project Description:

AIG GRA EDM project involved the development of visualization

dashboards and Geo-Spacial analysis using shape files and Aquifer layers.

The prime focus of the POC is to enhance the revenue from the Fracking

domain for different Oils and Wells. The POC involves the analysis of

identifying the insured and non-insured firms with wells on different

Aquifer layers and shape files and hence increase the business from the

non-insured firms. The data sources for this project include the normal

GRA database data and unstructured data from web. The unstructured data

was scrapped and integrated to the database by applying the Fuzzy

Matching logic for different analysis on the dashboards.

Responsibilities:

. Understanding business, requirement analysis, interaction with client

for requirement clarification.

. Analyzing the data model for finding out the different dimensions or

measures which needs to be used for decision making.

. Designed report layout and implemented QlikView dashboards using

various sheet objects like charts, table box, list box, multi box,

buttons etc., to get front end professional look which are used by

Insurance teams at client location.

. Involved in analysis process to implement the Best KPI's suitable for

each requirements.

. Involved in Performance tuning of the dashboards by using the best

practices.

. Creation of QVD Files to implement the data model and speed-up the

performance of the dashboards by connecting to Oracle database.

. Worked on different data sources like Oracle, excel files, QVD's and

QVW's.

. Performed Geo Spacial analysis using QlikMaps 2.1 and GeoQlik 11.

. Creation of point maps and polygon maps using different shape files

and Aquifer regions with the integrated data from the database after

implementing the Fuzzy matching logic.

. Creation of overlay of different shape files / Aquifer layers and

different data points (which show the insured and non insured wells

from the integrated data) in a single map.

. Deploy & Maintain QlikView Applications, Dashboards into the

development, UAT, and Production environments.

. Implemented QlikView security using Section Access (Row level

security) and through QMC.

. Eliminated Synthetic keys, ambiguous relationships and closed loops.

. Designed proficient dashboards according to the requirements.

. Developed Drill through Dashboards which enabled users to drill down

between dimensions.

. Implemented the Slice and Dice / Drill Down functionalities using

Cyclic / Drill down groups.

. Created charts as per the customer requirements on Quarterly, Monthly

and Yearly for report analysis with charts provided by QlikView.

. Implemented the QA process for the dashboards for User Acceptance

Testing.

. Creation of various documents for the design and functionality of the

dashboards.

PROJECTS HANDLED - Mindtree Singapore

1. DBS RTT Managed Services

Client : DBS Bank, Singapore

Duration : Aug - 2013 to Mar - 2014

Team size : 6

Role : Senior Developer

Technology/Tools : QlikView 11, Sybase, Crystal Reports 2008, SAP

Business Objects 3.1, UNIX

Project Description:

DBS RTT Managed Services is a development project where we will be

creating different dashboards and reports using QlikView, SAP Business

Objects, Crystal Reports 2008 and Sybase upon the user requests. All the

UR process and development of dashboards includes the end to end process,

which contains the Requirement gathering, development, user-acceptance

testing and implementation of the report. It involves more interaction

with the users and liaises with them for the end-to-end process.

Responsibilities:

. Understanding business, requirement analysis, interaction with client

for requirement clarification.

. Designed report layout and implemented QlikView dash boards using

various sheet objects like charts, table box, list box, multi box,

buttons etc., to get front end professional look which are used by

finance teams at client location.

. Designed the dashboards with the standard layouts and suitable

structures.

. Involved in analysis process to implement the Best KPI's suitable for

each requirements.

. Involved in Performance tuning of the dashboards by using the best

practices.

. Creation of QVD Files to implement the data model and speed-up the

performance of the dashboards by connecting to Sybase database.

. Worked on different data sources like Sybase, excel files, QVD's and

QVW's.

. Manage/Schedule QlikView applications using QlikView Management

Console (QMC)/ QlikView Access Point.

. Deploy & Maintain QlikView Applications, Dashboards into the

development, UAT, and Production environments.

. Implemented QlikView security using Section Access (Row level

security)and through QMC.

. Eliminated Synthetic keys, ambiguous relationships and closed loops.

. Designed proficient dashboards according to the requirements.

. Developed Drill through Dashboards which enabled users to drill down

between dimensions.

. Implemented the Slice and Dice / Drill Down functionalities using

Cyclic / Drill down groups.

. Created charts as per the customer requirements on Quarterly, Monthly

and Yearly for report analysis with charts provided by QlikView.

. Maintenance of reports created using Crystal Reports 2008.

. Implemented the QA process for the dashboards for User Acceptance

Testing.

. Creation of various documents for the design and functionality of the

dashboards.

PROJECTS HANDLED - Mindtree India

1. Infrahedge Phase 1 &2

Client : Infrahedge Services Private Limited

Duration : Jul - 2012 to June 2013

Team size : 12

Role : Senior Developer

Technology/Tools : QlikView 11, MSBI, SQL Server 2008 R2, Oracle 11g

Project Description:

Infrahedge project includes 3 modules: MILTRUST, VALUE ACT, and NIKKO.

This project contains various dashboards which are used for the decision

making in Capital Marketing domain. Here all the dashboards are created

on the basis of various risk measures and performance analytics factors.

The dashboard displays the data for investor and fund level with the

transaction dates selected from the calendar.

Each dashboard contains a summary tab which contains high level

information about the values for different parameters used. The various

parameters used are Asset Class, Sector, Region, Market Capitalization,

Currency Exchange and Country.

Responsibilities:

. Understanding business, requirement analysis, interaction with client

for requirement clarification.

. Designed report layout and implemented QlikView dash boards using

various sheet objects like charts, table box, list box, multi box,

buttons etc., to get front end professional look which are used by

finance teams at client location.

. Used Oracle/SQL Server as backend and also QlikView script for ETL

Operations for extracting, transforming & loading data into QV

applications or into QVD files to speed up the loading process into QV

application & also scheduled the application to reload the latest

data.

. Worked on different data sources like SQL Server, Oracle, excel files,

QVD's and QVW's.

. Manage/Schedule QlikView applications using QlikView Management

Console (QMC)/ QlikView Access Point.

. Deploy & Maintain QlikView Applications, Dashboards into the

development, UAT, and Production environments.

. Configured QlikView Server /Publisher, Scheduled jobs, & security.

. Eliminated Synthetic keys, ambiguous relationships and closed loops.

Designed proficient dashboards according to the requirements.

. Enhanced existing dashboards with new functionalities and established

a secure environment using QlikView Section Access.

. Developed Drill through Dashboards which enabled users to drill down

between dimensions.

. Implemented the Slice and Dice / Drill Down functionalities using

Cyclic / Drill down groups.

. Created charts as per the customer requirements on Quarterly, Monthly

and Yearly for report analysis with charts provided by QlikView.

. Provided user training to get familiarity on using QlikView

reports/apps.

. Assist the QA team for performing the QC process.

. Performed Mock test on QlikView Documents.

. Creation of various documents for the design and functionality of the

dashboards.

. Lead the team in offshore by taking the ownership of the dashboards

and delivery of the same.

PROJECTS HANDLED - CIBER

1. Lawson ERP System - Internal Project

Client : CIBER Inc., US

Duration : Oct - 2012 to May -2013

Team size : 4

Role : Developer (Dashboard Developer)

Technology/Tools : QlikView 11, Oracle 11g

Project Description:

Lawson ERP System is a POC, which needs to create dashboards for

different ERP modules like Finance, HR and Supply Chain Management

systems. The dashboards needs to be created using QlikView 11 as the

front end and Oracle 11g as the backend. Here in each dashboard we had

created different KPI's and charts to analyze the different measures

which need to be shown as part of ERP systems. Each dashboard contains 6

KPI's and each KPI's will be having different charts on various

dimensions and expressions, which will help the end users to take

decisions on the business analysis.

Responsibilities:

. Understanding business, requirement analysis, interaction with client

for requirement clarification.

. Analyzing the data model for finding out the different dimensions or

measures which needs to be used for decision making.

. Designed report layout and implemented QlikView dash boards using

various sheet objects like charts, table box, list box, multi box,

buttons etc., to get front end professional look which are used for

HR, finance and Supply Chain Management teams at CIBER U.S.

. Creation of QlikView data files (.QVD) using QlikView 11.

. Implemented the Slice and Dice and Drill Down functionalities using

Cyclic / Drill down groups.

. Created charts as per the customer requirements on Quarterly, Monthly

and Yearly for report analysis with charts provided by QlikView.

. Assist the team members to come out for the suitable way to show the

KPI's understandable by the users.

. Performed Mock test on QlikView Documents.

. Creation of various documents for the design and functionality of

the dashboards.

. Lead the team in offshore by taking the ownership of the dashboards

and delivery of the same.

2. Social Service Agency, Santa Clara County Data warehousing/Business

Intelligence

Client : Santa Clara County, California, US

Modules : 4

Duration : Aug - 2010 to Sep - 2011

Team size : 9

Role : Developer (Reports & Dashboards)

Technology/Tools : BO XI 3.1, Xcelsius 2008, SAP BO 4.0, Dashboard

Designer 4.0, Oracle 11g, OWB, SVN

Project Description:

Santa Clara County project contains different modules like CCS, DFCS

Referrals, SSA Remediation.

1.CCS program Statistics module is used to get the application details

for different program types such as CalWORKS, Food Stamps and Medi-

Cal. These complaints or applications should be registered in Santa

Clara County - Social Service Agency.

2.CCS Forecasting is dealing with the details of applications which

are registered in Social Service Agency, Santa Clara County. This

module has two sub modules which are dealing.

3. DFCS Referrals is an extension of DFCS project which were running

in Production. DFCS is a department of the County of Santa Clara's

Social Services Agency that cares children and families with access to

health, financial, nutritional, and employment assistance. This module

includes the details of the Children and parents which has the

problems for different types of abuses and takes the summary of the

details of children complaints according to the location, ethnicity,

language, gender.

4. SSA Remediation was the enhancement project done at the previous

reports and dashboards at the data model, universe and report levels.

Responsibilities:

. Understanding business, requirement analysis, interaction with client

for requirement clarification.

. Creation of Views/Materialized Views (SQL Queries to fetch

result/desired dataset).

. Creation of Universe for all the sub modules.

. Creation of Derived tables in the Universe.

. Creation of WebI reports using Web Intelligence XI R3.1 and SAP BO

4.0.

. Creation of dashboards using Xcelsius 2008 and Dashboard Designer 4.0.

. Creation of web services to pull out data from database using Query As

A Web Service.

. Creation of Corporate Dashboards / BI Workspaces to integrate to

InfoView / Launchpad.

. Expertise in Both Information Design Tool (IDT) and Universe Designer

Tool (UDT).

. Performed Unit testing on Reports and Dashboards.

. Involved in R&D for implementing the calendar functionality in the

dashboards according to the client's requirements.

. Migration of source code to client environment/other environment (e.g.

Use of Import Wizard, Upgrade Management Tools, LCM etc

. Extensive knowledge on Migration from BO XI R3.1 to SAP BO 4.0.

Personal Details:

Mobile No : [91] 962*******

Date of Birth : 03 - Mar -1987

Marital Status : Married

Languages Known : English, Malayalam, Tamil and Hindi

Visa Status:

Visa Category Valid From Expiry Date

H1-B 10-Nov-2014 18-Aug-2017

DECLARATION

I hereby declare that all the particulars furnished above are true to the

best of my knowledge.

Place: Bangalore

Neelakandan N

Date:

Contact this candidate