Curriculum Vitae Saravana Prabhu

SARAVANA PRABHU P

Experience Summary

Saravana Prabhu P has 5 years of experience in the Information Technology. As part of my assignments,

I have been in Requirement Analysis, SSIS Developer, QlikView Developer and Administrator for SAP BPC

and QlikView. I’ve worked on projects for clients such as Symantec, Firmenich, Metro and some others.

Education and Certifications

Title of the Degree with Branch College/University Year of Passing

Master of Engineering in Kumaraguru College of 2008.

Computer Science. Technology, Coimbatore.

Bachelor of Engineering in Dr.Mahalingam College of

2005.

Computer Science. Engineering and Technology,

Pollachi.

Technical Skills

Hardware / Platforms Windows 98/XP/2000.

Datawarehouse, BI, SAP

Technology

QlikView 10, 11 & Next, SAP BPC (SAP Business Planning and Consolidation),

Tools

SSIS

C/C++, Java, VB

Programming

Languages

Teradata, MS-Access, Oracle, SQL Server, MySQL.

Databases

Scripting Languages JavaScript, HTML, VBScript.

Version Control PVCS, Perforce

Systems

Certifications

QlikView 11 Certified Administrator

QlikView 11 Certified Developer and Designer

IBM Certified Developer Cognos 10 BI Reports

CCP in DATAWAREHOUSING

Contact Details

Mobile No. +1-650-***-**** Web site : www.qliktab.wordpress .com

Page 1 of 6 Dated: 10/20/14

Curriculum Vitae Saravana Prabhu

Relevant Project Experience

Organization: Cognizant Technology Solutions

Project #1

Title Symantec QlikView Support

Client Symantec

Operating System Windows Server 2008, Windows 7

Environment QlikView 10 & 11 Developer, Server & Publisher

DB SFDC, Teradata, Oracle & SQL Server

Testing Tool Jmeter

Team Size 4

Role Team Lead (since Mar 2014)/Member

Period September 2012 – Till date

Project Description

In Symantec QlikView Support our project team owns all the environments like Prod, Development,

QA and UAT. Apart from QlikView dashboard development, we are responsible for the performance,

deployment, migration and almost all the happenings to these environments. Worked for different

business groups like Sales, finance, VCC, Trustservices, Sympay, GSO and CMC.

Role and Responsibilities

Gathering functional requirements and reporting requirements from application stake

holders.

Designed data model in QlikView to accommodate the application requirements.

Working on writing complex Scripts to load Data in QlikView Applications. Extracted data

from sources like SFDC, Teradata, Oracle, SQL Server and Flat files.

Implemented SECTION ACCESS for some dashboards – Row level security and hiding sheets

Developed SET ANALYSIS to provide custom functionality in QlikView Applications.

Developing trend analysis reports using complex graphs for study of data quality patterns.

Implemented Tableau style charts for business requirement

Used Google cluster extension in one of the dashboard

Worked on large scale and data volume based applications

Worked extensively and developed VBA Macros

Dashboards were served to track services and service order information as well as to

monitor various KPIs. Dashboards included customer detail drilldowns, threshold gauges and

alerting mechanisms.

Developed executive dashboards in QlikView delivered through the web, enabling to

measure the performance of the business with analytical capabilities.

Coordinating with the business and setting up QlikView environment.

Designed and implemented complete QlikView architecture from scratch.

Playing the role of Administrator for Symantec’s QlikView environment.

Some of the dashboards developed by business might not be up to standards; in order to fix

those things will have an extensive CODE REVIEW before moving to Production

environment.

Implemented EDX logic for a load executed by Informatica

Participate in Change Management procedures by checking in the changed code in PVCS.

Developed dashboard with QlikView Next (Qlik Sense) as POC

Page 2 of 6 Dated: 10/20/14

Curriculum Vitae Saravana Prabhu

Performed Load Testing with JMETER open source tool

Enabled anonymous access for an environment for load testing

Customized QlikTech monitoring dashboards like QlikView System Monitoring and

Governance dashboard for meeting the client needs.

Designed and changed the Accesspoint logo for Symantec environments.

Used QlikView optimizer dashboard to optimize the QlikView dashboards.

Working on QlikView 11 migration project – Deprecated features of QV10 dashboard and

workarounds to achieve those.

Worked on embedding QlikView dashboard in SFDC portal

Project #2

Title Symantec QlikView 11 Upgrade project

Client Symantec

Operating System Windows Server 2008, Windows 7

Environment QlikView 10 & 11 Developer, Server & Publisher

DB SFDC, Teradata, Oracle & SQL Server

Testing Tool Jmeter

Team Size 5

Role Team Lead

Period August 2014 – October 2014

Role and Responsibilities

To install QlikView servers and Publishers – Stand-alone and distributed environments

To setup System Monitor and Governance Dashboard

Dry run the environment using Jmeter with some sample dashboards

Install database drivers – Teradata, Oracle & Salesforce driver

To coordinate with Winops, SSL, Load balancer, Firewall and Storage team for getting

things done

Configure & Enable Salesforce integration

Enabling Anonymous access in UAT environment

To setup QVS cluster in Prod and UAT environments

Fail-over Publisher setup in Prod and checking it thorough

Worked with security team on QlikView’s requirement

Coordinating with QlikTech for temporary licenses

Migrate the dashboards from QV 10 servers to QV 11 servers

To enable and check PDF distribution

Creating unanimous folder structure across the environments

To setup shared configuration files across the environment

Enable server URL as landing page for QlikView application

Mapping all services on QMC

Mounting QlikView folders and grant application level access to respective DEV teams

Creating tasks

Granting access to dashboard and QMC

Configure Mail server on QMC

To map LDAP and make sure the user names are accessible

Identified deprecated features of QV10 in QV11

Page 3 of 6 Dated: 10/20/14

Curriculum Vitae Saravana Prabhu

Project #3

Title Metro POC

Client Metro

Operating System Windows XP

Tools QlikView 11, SQL Server 2010

Team Size 4

Role Team Member

Period July 2012 – September 2012

Project Description

Metro POC is set of dashboards that summarize the detailed sales data for each outlet at diffe rent

level of hierarchy. Dashboard portrays the trend of sales compared in terms of Years, Product,

Customer Type and some others. Major focus area of this program is to deliver a clear visualization of

their raw data.

Role and Responsibilities

Dashboard was developed to understand sales distribution across the region, product and

vendor

Implemented Comparative analysis using Alternate states feature of QlikView

Showed seasonal trend with radar chart

Extensively used Set analysis for overriding user selection especially on Summary sheet

Used cyclic and drill down groups in charts

Development of scripts (QVW application) for creating connection and storing the data in

QVDs.

Implemented WHATIF analysis for increasing sales of particular product.

Created dynamic straight tables based on the user selection dimension and metrics will be

made available

Used extension dial extension instead of regular slider.

Used Binary load which will get data and data model

Worked on Web ticketing

Administrator for QlikView Publisher & Server

Performed Unit Testing

Project #4

Title HomeServe QlikView Dashboard

Client HomeServe

Operating System Windows Server 2008, Windows 7

Tools QlikView 11 Server, Publisher and Developer, SQL Server 2010

Team Size 2

Role Team Member

Period May 2012 – July 2012

Page 4 of 6 Dated: 10/20/14

Curriculum Vitae Saravana Prabhu

Project Description

Home Serve QlikView Dashboard is developed for the management team to look into details at

different level. We got a chance to implement incremental load. Here we published reports to end-

users email as pdf.

Role and Responsibilities

Interacted with Business for Requirement Gathering and Analysis

Implemented incremental logic for insert and update logic

Created charts with visual clues feature to highlight the open items

Alert based on the aging of the unattended items.

Created reports and distributed as PDF for set of users

Administrator for QlikView Server

QlikView Developer

Unit Testing

Project #5

Title Firmenich ADM

Client Firmenich SA

Operating System Windows XP

Tools SAP BPC, SSIS, SQL Server 2008

Team Size 3

Role Team Member

Period June 2010 – September 2012

Project Description

IS SAP BPC Support is a part of Firmenich ADM project, and I work for it. In SAP BPC support we offer

technical support for the end-users and work on development activities.

Our technical support is similar to an Admin kind of roles which involves granting/revoking access,

modify access, processing dimensions, creating BPFs, creating Teams, creating Tasks and so on.

Our development activities includes creating new packages in SSIS, creating tables in SQL Server,

creating reports in SAP BPC, creating input schedules in SAP BPC and of course we do modify some of

the existing for newer business needs.

Role and Responsibilities

Requirement Gathering and Analysis

Administrator for SAP BPC

SSIS package developer

SQL Server developer

Unit Testing

Page 5 of 6 Dated: 10/20/14

Curriculum Vitae Saravana Prabhu

Project #6

Title Zurich

Client ZNA

Operating System Windows XP

Tools Informatica

Team Size 5

Role Team Member

Period March – May 2010

Project Description

ZURICH-UW BPM Reporting Phase 2 aims at loading the data from PEGA to ZEA layer going through

Reprocessing staging layer, ZNAW layer modeled based on Insurance Application Architecture (IAA) and

ZEA staging.BIX extracts the incremental data from PEGA database and generates CSV files. These files

will be the source for ETL process along with limited number of PEGA database ta bles as source.

Informatica mapping will trim the data fetched from the source CSV files using User defined function in

Informatica. Then the data will be loaded into target DB2 tables after applying a date filter on the

source records.

Role and Responsibilities

Requirement Analysis.

Prepared Design Document

Prepared Unit Test Case Document

Page 6 of 6 Dated: 10/20/14

Contact this candidate