Data Project

MAYURI MITESH NANDU

(: +91-702******* *: ********@*****.***

Technical Lead (Analytics & Business Intelligence)

Total Experience: 10+ years

Seeking challenging role in Analytics and Business Intelligence (Qlikview / Qliksense / NPrinting) with a progressive and growth oriented organization, preferably in IT, Insurance, Manufacturing, Financial & FMCG domain

SYNOPSIS

Dynamic professional with 10+ years of total experience in the IT industry, with 7+ years in Analytics and Business Intelligence with focus on Customer experience analytics. Worked across various domain including Life, Health & General Insurance, Finance, and NPS. Stronghold in blending different data sets including financial, operational and behavioural data using various BI tools. Excels in creating operational, executive and analytical dashboards. Adroit in analyzing data to identify customer pain points, process bottlenecks and triggers for intervention before things go wrong. Knowledge of end to end project planning & designing solutions. Worked on Qlikview / Qliksense projects with SQL, DB2, Oracle, ODS (Mongo DB), Raw System (IRPAS, ARTL & Flat Files) & SAP to fetch the data. Exposure in Billing Process & PO renewal of project. Proven abilities to design QlikView Dashboards using various objects & writing complex front end expressions. Familiar with associative data model. Possess basic Knowledge of Tableau & Power BI Tools. Brilliant communication, organizational, leadership and interpersonal skills with ability to work with stakeholders across all levels

CORE COMPETENCIES

Business Analytics

Business Intelligence

Data Modeling & Validation

Server Aministration

Dashboard Design & Creation

Technical Support

Client Engagement

Requirement gathering

Technical Documentation

Project Governance

Business User training

Team Management

TECHNICAL KNOWLEDGE PURVIEW

Platforms: Windows (98/NT/2000/XP), MS-DOS

Database: SQL Server, Oracle, SAP, DB2, ODS(Mongo DB), Flat Files

Languages: SQL

Tools: QlikView (9 & 11), Qliksense 3.2, QS Nov’17, QS Feb’18, QS Jun’18, QS Feb’19

AREA OF EXPOSURE

Understanding & documenting client Data Models and ETL procedures.

Data Modeling/scripting, managing data flow between source and application.

Scripting, data source integration and advanced front end development in QlikSense.

Training end users to use and develop charts in QlikSense.

Retrieving of external data from SQL, ORACLE to Qliksense Dashboard in terms of QVDs by making connection through ODBC, OLEDB.

Creating QVD’s and QVF’s applying business rules and data validations.

Developing applications using best practice of staging architecture.

Developing multiple dashboards and enhance the feature of qliksense with many objects like Straight tables, Pivot tables, Containers, Line charts, Bar charts, Combo charts, Pie charts and few extensions. Installation of Nprinting.

Extensive experience in creating Excel reports, Word reports, PowerPoint reports using NPrinting designer and automating the jobs in NPrinting Server.

Administration - Worked on QMC security rules customization as per client requirement, created users groups for access, Licenses allocation.

Customizing the Qliksense view through security rules in QMC as per the user need, power users having all the access like create new sheet, bookmark, create store, extract data etc. excluding create new application and other user read only user can only view the application cannot create sheet or extract the data.

Activating Client Authentication Link for IOS users.

Conducting end user training sessions of QlikSense Navigation and Qliksense Mobile App use.

Interacting with Qlik Support team regarding the Vulnerability and updated the settings in QMC to achieve VAPT.

Administration: Creating Stream, Assigning user’s licenses and giving access of the required stream and application access, creating users group through custom properties in QMC.

Installation of NPrinting version Nov’17 and upgradation to Jun’17.

Using Mapping Loads to eliminate dimension tables & reduce no. of tables.

Automating and scheduling daily data loads of Qvds from different source system and QVFs.

Performing backtracking while validating the application.

Using SET Analysis, Aggregate functions to look at the history data and get required information.

Using Section access and Sheet access to make the application available to desired users.

Giving demo on QlikSense applications to user and gathered feedback at every phase.

Developing dashboards using different objects like pivot table, text box, KPI, table, line chart, bar, pie chart etc, and extensions like Screen resizer, climber KPI, container etc.

Creating Excel reports, PowerPoint reports and Word Reports using NPrinting tool.

Creating the tasks and scheduled the jobs in NPrinting sever.

Circulating reports with data restriction to the user at NPrinting reports level.

Sending the updated status report to the managers and client on daily or weekly, monthly basis

NOTABLE ACCOMPLISHMENTS

Made significant contribution in providing a joined-up view & meaningful insights on key customer issues on a regular basis using data engineering and data science

EMPLOYMENT HISTORY

Since Feb’2008 till date

Team Computers Pvt. Ltd.

Started IT journey in 2008 as IT Helpdesk / Coordinator for Dell Project & worked till Dec’2011.

Started with BI Analytics in Jan’2012.

Current Role : Technical Lead (Qlikview / Qliksense / Nprinting)

Deliver complex regular and ad-hoc analysis: Lead on complex analysis requests comes from various business areas to provide insight on specific areas of interest on a regular as well as ad-hoc basis. Requests will need to be scoped out, estimated, delivered with valuable insights and the relationship with the stakeholder managed throughout the delivery of the project

Maintain existing analytics assets within the team: Maintain the Qlikview/Qliksense based models within the team and enhance them over time

Develop re-usable analytics assets: Develop analytics models and tools that are re-usable that become assets for the organisation and help deliver strategic objectives around developing analytics capability in the organisation.

Provide quick PoCs to the business to validate any specific hypotheses and providing quick insights within a very short span of time

Provide Diagnostic CX Analytics: Produce insights around customer experience (what the experience is? Develop understanding of why is it good or bad? How we improve it?).

Develop diagnostic and predictive model to analyse the data providing clear recommendations.

Understand and analyse customer behaviour and help build forecasting modes / propensity models to gain more insights into customer expectations and needs

Understand customer experience across various channels

Prioritise the improvement areas for the business

Forecast upcoming trends on issues and customer needs (e.g. more online service, better training of staff etc.)

Collecting, collating and carrying out complex data analysis in support of management and client’s requirement.

Interacting with clients, understanding requirement and developing cost effective solutions.

Carrying out analysis of the given data and draw correct inferences, in keeping the objective of the analysis.

Responsible for the Creation of Qvds and implementation of delta logic.

Designing, coding, and testing the QlikView / Qliksense applications according to business requirements.

Advising on the suitability of methodologies and suggesting improvements.

Monitoring and scheduling of daily Qvw’s

Imparting training to end users of QlikView / Qliksense

Coordinating with customers for any changes or new requirements in project.

Developing Customized Reports and Dashboards as per the project requirement

Projects Undertaken:

Current Client: Reliance Health Insurance

Time Period: Jan’ 18 to Till Now

Overview: Project is on Qliksense

Responsibilities:

Managed complete project from conception to completion and signoff

Interacted with client and gathered requirement for the project

Performed DM Matrix Analysis, Understanding Business Logic, BRD Documentation & Signoff

Involved in project & technical documentation

Handled installation and administration of Qliksense Jun2018 Server Multinode

Creating Dashboards using Extensions, Mashups & Customized HTML/CSS Coding

Mentored and provided technical guidance to the team

Imparted training to business users

Client: ATUL LIMITED

Time Period: Nov’ 16 to Dec’ 17

Overview: Project was on Qliksense (Qliksense Version 3.2)

Responsibilities:

Gathered requirement, managed project completion & signoff

Handled Data Modeling & validation, Server aministration and Dashboard creation

Managed team and provided business user trainings

Client: NSDL

Time Period: Nov’ 16 to Dec’ 17

Overview: Project was on Qlikview

Responsibilities:

Responsible for understanding the requirement specifications, BRD Documentation & Signoff

Performed data modeling & validation

Client: Allana Sons

Time Period: Dec’ 15 to Mar’ 16

Overview: Project was on Qlikview

Responsibilities:

Understand requirement specification and created BRD documentations

Responsible for

-Qlikview Dashboards & Reports Optimization

-Qlikview Data Intermediate Process

-Qlikview Development server setup

Developed and designed Qlikview Dashboards

Client: Mahindra & Mahindra

Time Period: Jan’ 14 to Nov’ 15

Overview: Project was on Qlikview

Responsibilities:

Responsible for understanding the requirement specifications and building scripting logic as per requirement specification for dashboards

Handled client communications

Performed data modeling/scripting, managed data flow between source and application

Created and designed Dashboards

Deployed and published Qlikview applications on server

Client: Reliance General Insurance

Time Period: Feb’ 13 to Dec’ 13

Overview: Project was on Qlikview

Responsibilities:

Understand requirement, and built scripting logic as per requirement specification for dashboards

Managed client communications

Involved in data modeling/scripting, managing data flow between source and application

Designed and created Dashboards

Responsible for authorization and authentication to user and scheduling the application

Created and Scheduled Weekly QlikView reports to distribute on email

Client: Reliance Life Insurance

Time Period: Apr’ 12 to Jan’ 13

Overview: Project was on Qlikview

Responsibilities:

Understand requirement, and built scripting logic as per requirement specification for dashboards

Managed client communications

Involved in data modeling/scripting, managing data flow between source and application

Designed and created Dashboards

Responsible for authorization and authentication to user and scheduling the application

Created and Scheduled Weekly Qlikview reports to distribute on email

ACHIEVEMENTS

Awarded by customer Reliance Health Insurance for Best implementation of Qlik

QUALIFICATION

Master in Commerce from Ram Manohar Lohia University

PERSONAL DOSSIER

Nationality: Indian ● Passport: xxxx Validity: xx-xx-xxxx ● Visa Status: xxxx

Contact this candidate