Now you can Instantly Chat with RUNIL!
About Me
Having 4.10 years of Professional IT Experience in Retail, Supply Chain and Finance domain with expertise in Qlikview and Qliksense designing, development,reporting and admin. Actively involved in various phases of the project -Requirement gathering,...ment,reporting and admin. Actively involved in various phases of the project -Requirement gathering, POC, Specification, Development, UAT, Implementation and Production Support Extensive experience in end-to-end implementation of QlikView life cycle using QlikView developer. Hands on retrieving of external data from ORACLE,Salesforce,Facebook,Google to Qlik Dashboard in terms of QVDs.Good Knowledge of Data Warehousing Concepts. Developed script to resolve synthetic key issues and Circular reference between tables. Extensive experience in Joins, Concatenate, Variables, QVD and Mapping. Implemented Incremental Load. Hands on experience in implementing Set analysis. Experience in optimizing Qlik applications to improve the performance Implemented column level and sheet level security by using section access. Implemented Comparitive analysis by using alternative states. Developed QlikView & Qliksense dashboards using different charts like bar chart, line chart, piechart, mekko chart, block chart, scatter chart, straight table and pivot table. Migrated all Qlikview dashboards in to Qliksense Experience in creating customized reports by applying Section Access for different clients. Reports generated and sent to users by N-Printing and triggered on daily basis. Expertized to create Ad hoc Reporting.
Show MoreSkills
Portfolio Projects
Description
DAMAC Properties is a property development company, based in Dubai, in the United Arab Emirates.The company operates internationally providing residential, commercial and leisure properties and has a collective presence in the UAE, Saudi Arabia, Qatar, Jordan, Lebanon, Oman, and the United Kingdom Dashboard lets to analyze the information about sales, inventory, due, overdue,collections, handedover, Sales Executives (PC,DOS,HOS,HOD) information and their ranking system etc. Using this existing information, the system should analyze and generates reports for KPIs in month wise, Quarter wise and year wise. The resulting model gives us an idea about growth in profit, prediction about increase in sale and performance about sales executives. Live applications are Sales dashboard, Collection & ageing Application, Procurement dashboard, Egypt Finance dashboard and Food division dashboard.
Show More Show LessDescription
Transport Control Tower is an essential Management tool helping to take timely informed decisions to reduce road accidents and improve overall management of road transport for LafargeHolcim Groups (ACC&ACL) for India and all other ASIA , MEA countries. The Regional TCT for India is the first regional control tower of its kind focussing initially to provide safety analytics and help desk service using the in-vehicle monitoring system and ERP systems such as SAP, to provide insights on how to improve road safety performance. TCT Phase-1: Dashboard gives the Daily , Weekly, Monthly, Vehicle Performance, Driver Performance and Transporter dashboard. It will give the Score Card based on their Violations (Hash Acceleration, Hash Braking, OverSpeeding and Continuous Driving per 1000kms weekly , monthly and yearly wise. The resultant model gives us number of trips, Violations of the vehicles, behaviour of the drivers. Plant managers will take the decisions against the Vehicles, Transporters and Drivers. TCT Phase-2: Operational KPI dashboard performs the three major roles. Safety, Cost and Services.
Show More Show LessDescription
Staples, Inc. is an American multinational office supply retailing corporation, with over 1500 stores in North America. Headquartered in Framingham, Massachusetts, Staples also does business extensively with enterprises in the United States and Canada, and as Staples Business Advantage. Staples sell supplies which include staples, office machines, promotional products, technology and business services both in stores and online. Dashboard lets to analyze the information about sales, net profits, customer site visit, conversion rate, etc. Using this existing information, the system should analyze and generates reports for KPIs in month wise, Quarter wise and year wise. The resulting model gives us an idea about growth in profit, prediction about increase in sale.
Show More Show LessDescription
Independent Health is a not-for-profit organization headquartered in Buffalo, New York. The company began operations in 1980 and has consistently been rated among the top health plans in the country for customer service and member satisfaction. Independent Healths comprehensive portfolio of product and service offerings include HMO, POS, PPO and EPO products, Medicare and Medicaid plans, traditional indemnity insurance, consumer-directed plans, coverage for self-funded employers, plus health savings account and pharmacy benefit management services.
Show More Show Less