Navision Integration

Retail Chain located in India

Challenges

  • Client has over 50 Shoes & Apparel Stores across South India
  • Navision is used for all their Operations for various functions including Inventory Management
  • Auditing of the Inventory across different stores used to be validated manually making it a very time consuming process

Solution Delivered

  • Lera Tech engaged with client by deploying an audit module that was custom built and Integrated with Navision to have a seamless process
  • Handheld scanners were utilized in scanning RFID tags in each store and store inventory data was gathered in a very short period of time and minimal efforts
  • Store Inventory data was reconciled with Navision Inventory data by integrating directly with Navision
  • We ensured employees were trained appropriately to be proactive
  • Client has since been able to save significant dollars an immediate impact on bottom line.
Read more

Analytics & Data Governance

Client located in Africa

Assess Analytics Maturity & Develp ToM & Roadmap
  • Strategy
  • Organization
  • Governance
  • Demand Management
  • Architecture & Roadmap
  • DWH Recommendations
  • BI Tool evaluation
  • Alignment to Bank’s PMO
  • Stakeholder Management
Data Exploration, Preparation & BI Reporting
  • Data + BI Project Delivery
  • Bank wide MIS Demands
  • DWH fixes & enhancements
  • Data Model Enrichments
  • Data BI resource Ramp up
  • Business IT Collaboration
  • Transfer from IT DM (40%)
  • Streamlining DWH Ops
  • Data Governance Foundation
Data Insights Foundation
  • Focus on Compliance & Business Requirements
  • Common Semantic
  • Reference Data
  • BI Dashboards
  • BI Self service Foundation
  • Data Quality Foundation
Data Insights Analytics
  • Focus on Business Outcomes
  • Business Use cases
  • Analytics Competency Build up
  • Big Data Foundation
  • Sandbox

Client located in the Middle East

Challenges

  • The company embarked on a BI journey in 2014 with little success
  • Teradata was implemented twice with suboptimal application
  • Techno functional expertise was lacking in the organization
  • Businesses & departments access information from disparate sources
  • Absence of robust data capabilities posed risk to future growth, compliance, & efficiency

Solution Delivered

  • Data Strategy :
    A comprehensive BI & Data Strategy aligned to the overall corporate strategy of the Bank
  • Data Governance & Quality :
    Robust policy framework & processes to ensure ongoing integrity of data & reporting.
  • Demand & Supply Management :
    Process developed for Business Requirement Documents (BRDs), prioritization, and resource optimization for effective delivery to ends users
  • Analysis & Analytics :
    Developed analytics standards, dashboards, reports, formats, & methodologies. Developed reports & visualizations for various units in the Bank.
  • Organization :
    Created formal BICC organizational framework and organization
  • Business Partnership :
    Appointed specialists for business/functional areas, identifying appropriate data use and data structures required for analysis
Read more
Data Lake Implementation

Data Lake Implementation

Eficaz ETL & Data Lake

Engagements

cloud2

Big Data implementation and development

Technology

cloud-3

Eficaz DW Suite
(Lera’s Propriety)

cloud-image

Cloudera Hadoop
(CDH)

Client Overview

Client is an organization in Africa spread across multiple countries. The client has currently 130+ branches across the African Great Lakes region.

Challenges

The specific issues that the company faced in achieving this goal were:

  • Challenges in extracting, transformation and reporting/analyzing data across all the branches
  • Delays in report generation and distribution, as the report hits database for each slicer selection
  • Inefficient reporting of high level performance metrics
  • Complicated data structure
  • Moderate implementation resources are available

Solution

The overall deployment was designed to meet the following objectives:

  • Achieve significant improvements in accessing, transforming, analyzing , reporting and visualizing the data. This will allow customer’s employees to focus more on the analysis activities.

Benefits of Proposed system

  • Efficient and automated data collection, distillation and visualization platform.
  • Will provide advanced analytical capabilities to improve analysis and decision making (thresholds, trending, graphical analysis, etc.).
  • Dynamic and largely scalable user environment that allows numerous users to simultaneously work with the system.
  • Provides an effective and efficient method for collaboration and reporting of the required information to the appropriate stakeholders and management. In addition, it will streamline and automate the decision making.
  • Rapidly adapted and scaled to support additional users, new requirements and changing needs.

Business Benefits

In a short span of 24 weeks, Lera Tech created a highly scalable Data Lake which had the following:

  • Distributed ingestion pipelines from source to Staging environment in Data Lake.
  • Bots based pre processing and data consolidation from other data sources.
  • Automation of key reporting and analysis processes.
  • Seamless, incremental data extraction and transformation layer for extracting data from core source system.
  • Advanced analytical environment, enabling key personnel within the organization to perform What If? analysis on several business scenarios.

Measurable results

  • Reduction of time required to generate ad hoc reports used across the business to several minutes this has improved productivity of the employees, utilizing the information provided.
  • The integrated and accurate reporting translates into better decisions. These factors contribute to a high return on investment from the comprehensive reporting solution.

Success Factors

There were several elements in the decision making process as well as the solution and implementation partner i.e., Lera Tech that contributed heavily to the success of the project

  • The Data Access Layer (DAL) includes the core source system database or any other long term data storage including Active Directory/Authorization Store, file systems, externally managed services.
  • The Business Services Layer consists of components that abstract the knowledge of how to connect to the Data Layer. It also consists of services that allow for abstract of distributed processing and communications.
  • The ERP BI consists of Graphical User Interfaces that use the objects contained in the Business Layer.
Read more