Miloni Parekh

• Client Industry : Healthcare
• Modules : Finance, Sales, Inventory, Equipment Monitoring
• Environment : Qlik Sense, Qlik View, Power BI
• Data Source : SQL server, SAP, SAP HANA and Excel

Project Description

Developed multiple dashboards and reports for various modules like Finance, Inventory, Sales , Equipment Monitoring and Order to Cash Cycle Tracker

• Development of these applications resulted in automization of most of the reports which were originally prepared manually, saving huge amount of time and increasing the efficiency of the reporting proccess.

A few of the dashboards and reports include:

• MIS, Management, Sales and NCE dashboards to display Key Performance Indicators and analyse different levels of financial data by identifying trends and patterns in the expenditure on travel & publicity, sales and cash flow across various business areas, business lines, regions and customers
• Major KPIs include YTD and LYTD Sales/Revenue, MTD and LMTD Sales/Revenue, CY vs LY comparison, CM vs LM comparison
• Also included Actuals, Forecast and Budget calculations as per complex business logics
• Order to Cash Tracker gave detailed dashboard for tracking the order based on its different milestone dates, from the time it is booked till installation process is completed
• It also triggered email alerts for important milestone dates approaching or any changes in the same, to respective BA and region heads.
• Equipment Monitoring application which provided analysis on the amount of orders executed/unexecuted and various parameters for monitoring the orders, sales, shipment and payment status
• Data governance dashboard for governing the consistency & frequency of data received and memory utilized by data on the server. Also notifies the report owners and users in case of any missing files due to which the dashboards are not updated
• Inventory management dashboard to manage and recognize the inventory trends to help management take important business decisions based on the inventory information

Responsibilities

• Gathering and understanding business requirements
• Design technical solutions and dashboards based on requirements and business needs
• Testing applications for checking validity of the developed application data with the source data
• Development and distribution of Nprinting reports and email notifications to management including CMO and CFO
• Managing access of the users based on application
• Provide support and resolution of escalations if any, in previously developed reports.

• Client Industry : IT
• Project title/Module : Sensor and Incidents Analytics Dashboard and Reporting
• Environment : Qlik Sense

Project Description : Project was divided into two major parts

1. Sensors Analysis Dashboard : The aim of the application was to organize all sensor data from across the company’s different systems, across the different locations and help them gain the visibility needed to identify and prioritize sourcing opportunities

• The sensor analytics include Camera analytics, Fire alarms analytics, Access Control Analytics and BMS analytics
• KPIs include the count of the different states of the above sensors Application

2: Incidents Dashboard : The aim of the project was to screen all the incident data from across the company’s different systems and locations and present it in a way which gives real time updates of the incidents and the events occurring, according to different granularity levels

• This made it easier for the business to analyse the frequency, severity and the number of incidents taking place at different locations and gave them just the right insights to take further actions

Responsibilities

• Installation, stabilization and licensing of Qlik Sense Enterprise
• Analysis of sensor system data and requirement gathering
• Design technical solution based on requirements and customer needs
• Develop Qlik sense mashups to enhance customization of the dashboards, allowing users to access the dashboards through web URL