Ø Understanding and preparing technical documents based on the requirements gathered from Business Analyst.

Ø Loaded Data into QlikSense application from different QVD’s, excel files, database and external files.

Ø Created QVDs by importing data from the database tables using QlikSense script.

Ø Extensive experience in Joins, Concatenate, Variables, QVD and Mapping

Ø Hands on experience in removing of Synthetic keys and Circular loops.

Ø Work directly with QlikSense on debugging efforts and trouble tickets.

Ø Developed QlikSense Dashboard using Charts,List box, Input Field, Box and Calendar.

Drill Information by creating Groups/Cycles in QlikSense

Ø Responsible for gathering and analysing user requirements.

Ø Retrieving of external data from ORACLE,SQL Server,Flat files and SalesForce, Share Point to Dashboard in terms of QVDs by making connection through ODBC and OLEDB

Ø Extracting the data into Qlikview from various data sources like Database tables, QVDs, Excel sheets, Web Files into Qlikview.

Ø Created QVD’s by importing tables from the database using Qlikview and Building Data model on top of QVDs

This Project has involved building an enterprise-wide Sales and Supply Chain Analysis for Hindustan unite Limited - which is the Indian arm of Unilever Limited and is Indias largest FMCG Company from ground up. The warehouse serves the needs of all the profit centers in HUL including beverages, detergents, personal care products, ice creams and foods. For each profit center, it stores the data for the entire sales and supply chain starting from raw material purchase, packing material purchase, transportation of materials to factories, inventory and production of finished goods at factories, dispatch of goods to depots, inventory at depots, primary sales of goods to distributors, secondary sales of goods to retailers, etc. The warehouse further captures all the financial expenditure related to the marketing and advertising of products and brands, computation of net proceeds from sales, tracking and settlement of expense claims from distributors, etc.

Xerox is an American multinational document management corporation that produces and sells a range of colour and black-and-white printers, multifunction systems, photocopiers digital production printing presses, and related consulting services and supplies. The Project includes zonal wise analysis of sales, margins and annual growth is compared to be in period of time. Data was extracted from SQL Server and Flat Files, Cleaned, Transformed & Loaded in a separated data base. The enterprise data analyzer was built to implement a centralized data base that collects and organizes and stores data from different operational systems, integrated and historical data for the purpose of end user reporting. The various business patterns can analyses using different business dimensions.

Abbott Health Group, Inc. is a leading Pharmaceuticals Company. We have designed different set of dashboard and scorecards to help Health Market business users such as Country Managers/ Distribution heads, Senior Management to analyse their YoY revenue and expense reports, so that they have flexibility to generate Multi-dimensional reports and constantly expanding business.