Consultant Requirement

Location:

Colombo, Sri Lanka

Posted:

May 20, 2021

Contact this candidate

Resume:

Anil Mendis

Senior Consultant - Business Intelligence (BI)

Experience

13+ years (BI)

24+ years (Overall)

Competencies

Infor

Birst, Infor BI 11, Infor BPW (Business Performance Warehouse), Infor BV DWD (Business Vault Data Warehouse) Tools & Technologies

Microsoft/BI: Performance Point 2007 Monitoring and Analytics, SQL Server 2005/2008R2, 2014 SQL Server Integration Services 2005/2008R2/2014 (SSIS), SharePoint 2010, Performance Point 2007 Planning, Visual Studio 2005/2008 & 2010, SQL Server Analysis Services 2005/2008R2

/2014 (SSAS)

Other: ProClarity, (DB2, RPG 400, CLP 400, ILE RPG), MDX Script Training Competencies Birst, Infor BI, Infor BV DWD, Infor BPW Experience at Fortude

APP GROUP (Canada) - Birst Fashion Analytics and Birst implementation Senior Consultant - BI (January 2021 to Present)

Requirement Responsibilities

Implement a Birst Standard Fashion Analytic

16.1.8 and Birst BI Solution

Configure, Setting up work flows and

troubleshooting issues in Birst Fashion

Standard.

Design and Develop and Birst Custom

Reports

Baptist Health (US) – Infor BI reports development and Support Senior Consultant - BI (October 2020 to December 2020) Requirement Responsibilities

New Infor BI report development for Finance

Module and Support

Design, Develop and testing Infor BI

Reports

Providing support role function

Rocky (US) - Birst Fashion Analytics implementation Senior Consultant - BI (August 2020 to September 2020) Requirement Responsibilities

Implement a Birst Standard Fashion Analytic

16.1.6

Configure, setting up work flows and

troubleshooting issues in Birst Fashion

Standard.

Senior Consultant - BI (May 2020 to July 2020)

Requirement Responsibilities

Integrating data from Infor M3 to Rocky Sub

systems

Design and Develop Data integration

flows from Infor Data lake

Patties (Australia) – Infor BI report development and support Senior Consultant - BI (March 2020 to April 2020)

Requirement Responsibilities

Recipe sheet report development and support Design and Develop Infor bi Recipe sheet support

Surgical Partners (US) – Infor BI report development and support Senior Consultant - BI (December 2019 to February 2020) Requirement Responsibilities

Enhancement and new report development

to finance Model

Design, Develop and Modification to

Infor bi Finance reports and

troubleshooting Ad-hoc issues

Fashion Retail-in-a-Box (FRIB) - Data analytics and Birst dashboards Senior Consultant - BI (September 2019 to November 2019) Requirement Responsibilities

Implement a Birst dashboard solution for

FRIB, which is a preconfigured, fully

functional, user-oriented, scalable solution

that is an adaption of the Cloud Suite Fashion

Implementation Accelerator.

Design and Develop Birst data models

and dashboards for Global Inventory,

Store Performance and Sales

Summary functions.

Brandix Group - Data warehouse, and BI upgrade project Senior Consultant - BI (February 2019 to April 2019) Requirement Responsibilities

Plan and execute data warehouse upgrade

BPW from version 10.1 to version 11.3

Set up and test the accuracy of data in

the BPW 11.31 environment

Migrate data models, solutions and

data cubes from 10.1 to 11.3

Samsung C&T America, United States - Infor Fashion Analytics Senior Consultant - BI (November 2018 to January 2019) Requirement Responsibilities

Implement and customize Infor Fashion

Analytics for a leading Fashion Company in

New York, USA.

Install and configure Infor Fashion

Analytics

Customize the implementation

Senior Consultant - BI (June 2018 to October 2018) Requirement Responsibilities

Develop and implement data models and

dashboards for Customer Billing, Planning,

Marketing streams in Watercare, New

Zealand.

Design and develop Birst data models

Design and develop Birst dashboards

Conduct Birst training

Leading healthcare facility in Arkansas, USA - Infor S3 Healthcare Analytics Senior Consultant - BI (January 2018 to May 2018)

Requirement Responsibilities

Implement and customize Infor S3 Healthcare

Analytics for a leading healthcare hospital in

Arkansas, USA.

Install and configure Infor S3 Analytics

Customize the implementation

Leading university-based medical center, Chicago, USA - Infor S3 Healthcare Analytics Senior Consultant - BI (August 2017 to December 2017) Requirement Responsibilities

Implement and customize Infor S3 Healthcare

Analytics for a leading university-based

medical center in Chicago, USA.

Install and configure Infor S3 Analytics

Customize the implementation

Leading surgical hospital in Chicago - Infor S3 Healthcare Analytics Senior Consultant - BI (June 2017 to July 2017)

Requirement Responsibilities

Implement and configure Infor S3 Healthcare

Analytics for a leading surgical hospital in Chicago, USA. The client partners with local physicians to

establish successful freestanding surgical facilities.

Install and configure Infor S3

Analytics

Gather requirements

Hynds New Zealand - Infor M3 Manufacturing Analytics implementation, Infor BI Training Senior Consultant - BI (March 2017 to May 2017)

Requirement Responsibilities

Implement Infor M3 Manufacturing

Analytics.

Provide end-user training on Infor BI.

Infor Office Plus, Infor BV DWD

Hynds is a leading manufacturer and

supplier of infrastructure products to

the civil construction and rural sector.

Infor M3 Analytics installation and

Configuration

On-site support

Prepare training material

Provide training on the following:

o Infor BI concepts

o Infor BV DWD

o Application Studio

o Office Plus

o Repository administration

o Self-service dashboards

Requirement Responsibilities

To provide end-user training on Infor BI.

Infor BV DWD Champion Petfoods is a

world-renowned company known for

making a quality product, shipping to

over 70 countries around the world.

Prepare training material

Provide training on the following:

o Infor BI concepts

o Infor BV DWD

o Application Studio

o Office Plus

o Repository administration

o Self-service dashboards

Retail, manufacturing, and services organization in Bangladesh - Yellowfin BI Business Intelligence Consultant (August 2016 to November 2016) Requirement Responsibilities

Develop an Infor BI-based

solution to monitor the

organization’s KPIs.

Elicit requirements

Prepare the Business Requirement Specification

Design the system

Develop cubes and dashboards using SQL Server

2014 Analysis Service and Yellowfin

Test the solution

Brandix Group - Operational Expense BI Solution Implementation BI Consultant (June 2016 -August 2016)

Requirement Responsibilities

Develop a BI solution based on

DevExpress and BPW to monitor the

Operational Expenses of the Brandix

group and its subsidiary companies.

Requirement elicitation

Prepare the Business Requirement

Specification

System design

Develop the solution using Infor BPW and

DevExpress

Test the solution

Leading healthcare provider in Illinois and Iowa - Infor S3 Analytics Implementation BI Consultant (May 2016)

Requirement Responsibilities

A solution to monitor Analytical

healthcare information.

Configure data warehouse using Infor BPW

Configure and build healthcare analytics solutions

Implement business measurements models for the

following modules:

(Human Capital Management), and Project

Accounting

Brandix Group - Works Human Resources BI Solution

BI Consultant (January 2016 - March 2016)

Requirement Responsibilities

A solution to monitor the Works HR

information of Brandix Group of

companies. The solution facilitated cadre

analysis, incentive analysis, absenteeism

analysis, labor turnover analysis in

consolidated and company-wise

dashboards.

Create the proof of concept of the solution

Design and develop Works Human

Resources BI solution using Infor BPW and

DevExpress.

Test the solution

Train users

Fortude Healthcare - BI Productization

BI Consultant (November 2015 - January 2016)

Requirement Responsibilities

A home-grown BI solution for the

healthcare industry with the following

dashboards:

Quality dashboard

Main KPI dashboard

Emergency unit KPI dashboard

Perform the technology evaluation

Develop and commercialize healthcare

products using Yellowfin and Infor BI

Test the solution

Brandix Group - Account Receivable Analysis Solution BI Consultant (September 2014 -November 2015)

Requirement Responsibilities

A solution to monitor the Account

Receivables (AR) information.

Design and develop a BI solution using

Infor BPW and SharePoint 2010

Test the solution

Brandix Textile - BI Solution

BI Consultant (June 2013 - September 2014)

Requirement Responsibilities

A solution to monitor the financial

information, including the following:

Cash flow dashboard

Profit & Loss dashboard

Balance sheet dashboard

Overhead dashboard

Design and develop a BI solution using

Infor BPW

Test the solution

Train users

BI Consultant (May 2013 -June 2013)

Requirement Responsibilities

Plan and execute data warehouse

upgrade BPW from version 9.0 to version

10.1.

Set up and test the accuracy of data in the

BPW 10.1 environment

Brandix Group - Cost Sheet Analysis Solution

BI Consultant (2012)

Requirement Responsibilities

Design and develop BI Cost Sheet

Analysis for the Brandix Group with the

following dashboards:

Consolidated Cost Sheet

Company Cost Sheet

Engage in designing and developing the

solution using Infor BPW

Test the solution

Train users

Brandix Group - Budgeting System

Senior Consultant (2011)

Requirement Responsibilities

Automate the Excel-based budgeting

process.

Design and develop the budgeting solution

using Performance Point Budgeting and

Planning Tool

Test the solution

Train users

Brandix Group - Data warehouse, and BI upgrade project Team Lead (2010)

Requirement Responsibilities

Upgrade data warehouse and Business

Intelligence tools to SQL Server 2008 R2

and SharePoint 2010.

Upgrade Data warehouse from SQL 2005

to SQL 2008 R2

Upgrade Performance Point BI solution to

SharePoint 2010 BI.

Test the data warehouse solution

Test the dashboards

Brandix Essentials - HR KPI Analysis

Team Lead (2010)

Requirement Responsibilities

Analyze HR KPIs. Generate HR cubes by

extracting decentralized HR information

to the data warehouse.

Design and develop HR BI Solution using

Infor BPW and SharePoint 2010

Test the solution

Train users

Team Lead (2009)

Requirement Responsibilities

Provide weekly projections based on the

budget and the facility to compare and

monitor projections, budgets, and

actuals.

Design and develop a Projection BI Solution

using Infor BPW and SharePoint 2010

Testing Solution

Train users

Brandix Group - Procurement Information Analysis Cubes Team Lead (2009)

Requirement Responsibilities

Analyze Purchase Order information

between Infor M3 and the in-house

developed ERP system.

Design and develop a Purchase Orders

Cubes Using Infor BPW

Test the solution

Train users

Brandix Group - Financial Data Cubes

Team Lead (2008)

Requirement Responsibilities

Design and develop a financial

information analysis tool based on Profit

and Loss and Balance sheet cubes.

Design and develop Profit and Loss and

Balance sheet cubes using Infor BPW.

Test the solution

Train users

Brandix Group - Financial BI

Team Lead (2008)

Requirement Responsibilities

Design and develop Financial KPI analysis

through Business Intelligence tools with

the following dashboards:

Profit and Loss Dashboard

Overhead Dashboard

Sales Dashboards

Design and develop KPIs and dashboards

using Infor BPW and SharePoint 2010

Test the solution

Train users

Brandix Group - BPW implementation

Team Lead (2007)

Requirement Responsibilities

Provide awareness of data warehouse

concepts and capabilities of data cubes to

the Brandix group.

Develop sample cubes using Infor BPW

Demonstrating cubes and their

capabilities

Train users

Maharaja Group Sri Lanka - BPCS ERP

Project Leader (2004 - 2007)

Requirement Responsibilities

Support ERP

implementation

across

manufacturing

entities.

Design and develop ad-hoc modules for operations such as Purchasing and Production.

Test the solution

Provide user training on BPCS ERP

Provide configuration support for Finance, Procurement, Sales and Distribution, and Manufacturing modules

Jarir Book Store - Saudi Arabia, ERP Solution

Project Lead/Developer (2003 - 2004)

Requirement Responsibilities

Work with the JD

Edwards ERP

software along

with Retail Pro

and IBM

OPOS/600.

POS System implementation

Design and develop the integration of the Retail Pro System to JD Edward via MQ Series and RPG 400

Test the integration

Conduct user training and provide support

John Keells Holdings Sri Lanka

MIS Analyst Designer Developer (1999 - 2003)

Requirement Responsibilities

Work with

FAMAS/400 and

System/21 ERP

packages across

the entire group.

Design and develop an ad-hoc module for Fixed Assets, Procurement modules

Design and develop consolidated modules

Design and develop entity and consolidated cash flow

Test the solution

Provide user training

Provide support for General Ledger, Procurement and Fixed Assets modules

Golden Key Ltd, Sri Lanka

Designer Developer (1997-1999)

Requirement Responsibilities

Work with

IMAS/400 ERP

packages.

Develop ad-hoc modules for sales and distribution

Test the solution

Design and develop reports

• MSc in Information Management, Sri Lanka Institute of Information Technology (2008)

• Bachelor of Science, University of Kelaniya Sri Lanka (1996)

• Diploma in Chemical Engineering, University of Moratuwa Sri Lanka (1990) Training & Certifications

• Birst - Beginner Training (2017)

• City and Guilds Train the trainer certification (2017)

• Training - Lawson Business Performance Warehouse (BPW) (2007)

• Chartered IT Professional (CITP), British Computer Society (2004)

Contact this candidate