analyse | predict | monetise · microsoft business intelligence, qlikview, microstrategy,...

Big Data Services PortfolioAnalyse | Predict | Monetise

Services Portfolio

CALL CENTER OPTIMISATION

RESOURCE AUGMENTATION

BIG DATA ADVISORY

BIG DATA PLATFORM IMPLEMENTATION

Services Big Data AdvisoryConsolidate | Automate | Predict

Credentials: Highlights

• Big Data Implementation across various domains – Insurance, Banking, Payments, etc.

• Processed huge amounts of Data

o Data sizes in order of 10s of Terabytes

o Data Volumes in order of 10s of billions

• TAT for the reporting process reduced from Hours to Minutes

Big Data Advisory

Credentials: Customers

Big Data Advisory

Software Stack Selection

- Need Analysis

- Feasibility

- Production Monitoring

- Implementation

- Performance

- Additional SW

- Columnar Database

- Visualization

Software Selection

Big Data Advisory

Data Architecture

Data Source Systems Data Processing and ETL Data Visualization

Big Data Advisory

Hardware Selection

- Hardware Feasibility

- Storage

- Compute

- Node Architecture

- Data Transfer – Onetime

- Timings

- Tech Processes

- File structures and Splits

- Hardware Planning

- Data since beginning of time

- Yearly Growth

- Match to performance

- Data Transfer – Ongoing

- Real Time Integration

- Services Implementation

- Timings

Hardware Architecture and

design choices

Big Data Advisory

Engagement Model

• Resourcing: One onsite Data Scientist

• Duration: 7 Days

• Process :

Envisioning Big Data Strategy

Anchor Business

Requirements

Scoping Project

Hands-On Training

Experience

Big Data Advisory

Services Big Data Platform ImplementationConsolidate | Automate | Predict

Big Data Platform Implementation - Objective

• InnoTx helps organizations create an Analytics Ready Data environment.

• This helps in creating a single, unified data management framework that brings appropriate data together for reporting & analysis. Such streamlining of data provides a unified view across various segments.

Manage huge volumes of data, with multiple deployment options.

Automation of data pull, aggregation for reporting and increase in productivity

Gain deep insights to take timely action

Big Data Platform Implementation

Big Data and Analytics Platform


Big Data Platform - Benefits

All data has potential value

No defined schema - stored in native format

Schema is imposed and transformations are done at query time (schema-on-read)

ELT(Extract, Load, Transform) rather than ETL processing

Designed for low cost storage

Highly agile – configure and reconfigure as required

Provide Faster Insights

Apps and users interpret the data as they see fit

ELT WORKFLOW


Big Data Platform – Data Lake Ecosystem

DESIGN

IMPLEMENT

ANALYTICS

SUPPORT


Big Data Platform – Technical Architecture

Full Stack Support



Analysis of data sources

i. Identification of data sourcesii. Analyzing the architecture of databases,

studying table structures, etc.iii. Data sizing for planning hardware

requirements

Technology setup i. Installation of Big Data platform on respective project server

ii. Installation of supporting applications such as MS office, etc.

i. Identifying data to be migrated ii. Creation of input databases and

output databasesiii. Migrating data to project server

Testing data lake architecture, UAT, validation reports, etc.

Data movement

Testing and validation

PHASE 1: Data Set-up and Movement

Activities include:• Hardware Setup and Testing• Connectivity • Big Data Platform Download and

Installation• Coherency Testing• Testing (including sample data)• Data Transfer- Final• Acceptance Testing activity

*Each process involves InnoTx team and Client support



PHASE 2: Transfer and Loading Data for End Use

Activities include:• Understanding requirements for

Metadata and final Use Cases• Document Metadata

implementation• Design/Implementation• Testing of final structured data• Regulatory Reports generation &

validation• Acceptance Testing

*Each process involves InnoTx team and Client support

i. Selection of relevant input tablesii. Marking relevance of variables in each

table

Data Model creation

i. Understand the specific report requirementsii. Reuse the existing queries to create Hadoop queriesiii. Run queries and output tables in consumable form

i. Establish connection between BI tool and Data Martii. Generation of intermediate data cubes for visualizationiii. Demonstrate generation of reports via the BI tool

Generation of reports

BI tool integration

i. Specification of output tableii. Mapping of input tables/variables to output tablesiii. Scripts for output table creationiv. Data mart creation

Creation of assets data dictionary


Delivery Process

Business

requirement

gathering and

sign offs

Specific data

sets

identification

as per mutual

discussion

Data sizing

requirements

Technology

Setup

Validation to

establish data

integrity

Analysis of

data to track

industry

trends from

the data

Reporting –

Insights,

dashboards/r

eports and

output

analysis

User review

12 3 4

56

7 8


Delivery - Success Metrics

Deliverables/Milestones Success Criteria

Infrastructure Setup Specification Documents

Infrastructure verified as per information provided in the proposal and subsequent emails

Assets Data Dictionary Excel with Tables, Variable names and their importance etc

Data Movement Pipeline (Data Pipe) Scripts that enable automated movement of data; single click run and query tests for newly moved data

Archival Data Store Basic stats comparison, eg.. row counts, sum of columns, unique entries etc

Reports Documentation Business Requirements Document: Report output values, input variables, frequency, updates, and usage (department wise)

Assets Data Mart Reports enabled with quick query respose wrt raw data

Assets Reports Tables and Graphs as per BRD

Query Performance Assessment Excel Tables and Graphs for execution time for Data ingest, Compression store, Data Cube building, Report generation etc

Real-time Dashboards via Spotfire Spotfire real-time interactivity with underlying Hadoop data


Implementation Team

• Client Engagement Manager

• Business Analyst – Requirement specification

• Data Scientist – Data & Platform architecture, Advisory & Sizing

• Data Modeler/Analyst - Design architecture and Data Model

• Big Data Engineer – Platform Implementation and ETL

• Data Analyst/s : Analytical work load

• Specialist Support if any, with vendor Involvement (If any, like Cloudera support)

• Post Go Live – Admin Roles for Maintenance & Risk

• Assumption – Delivery is on onsite basis


Big Data Platform Implementation - Impact

Case Study1: Big Data Implementation in payments & transactional intelligence

Client Context : Nodal agency for payments serving 600+ Banks/Payment product providers

Benefits:

Implementation costs 1/10th of similar implementations

Automated reporting, Complex query for analysis (for 6 products, multiple stakeholders across Banking/Govt)

High volume, High velocity, Real time, User Behaviour use cases


Big Data Platform Implementation - Impact

Case Study2: Leading Private Sector Bank

Client Context :

• Implementation of a Big Data platform (Hadoop) on premise on existing virtualized IT infrastructure

• Building a fully functional Assets Data Marts using data model, corresponding regulatory reports, and interactive visualization

• Implementation and testing of various data security and system security processes and technologies required for Banking applications and use-cases

Benefits: Archival data storage Performance DBs Real-time integration Secure environment


Analytics Services Insurance Analytics Suite

Customers


RESOURCE AUGMENTATION

Services Contact Center OptimisationPlan | Map | Yield

Contact Center Optimisation

Context:

• Customer retention processes run via centralized factory processes :• Contact or service center

processes

• High churn typical of these set ups (20-25% churn every month)

• Lack of skill leading to poor conversion – low ROI

Problem Statement:

• Planning problems• Network planning – location and

capacity planning

• Optimization problems• Conversion maximization

• Scheduling

• Skill map



Strategic Impact

Planning problems addressed using machine learning based “Risk of renewal” scores :

• Power management decisions

Tactical Wins

Optimization problems addressed by combining:

• “Risk of renewal” scores

• Portfolio optimization framework

• Skill level classification



Benefits

• Measureable ROI – higher conversion

• Measure multiple contact center KPI’s

• Optimization combining business and operational metrics

Key Features & Enablers

• Business user focused

• Configurable optimization window

• Ready deployment/consumption formats for contact center

• Configurable dashboards

• Deployment on-premise or Cloud

• Industry level machine learning models


Credentials: Customers


Resource AugmentationAdvisory | Fulfilment

Services

Resourcing – Solutions

• Leveraging on our deep understanding of Digital Transformation and technology-led disruption in the UAE enables us to identify and hire new and emerging skills related to this market transformation.

• Resourcing Team focussed on MENA• Dedicated team based out India office

• Partner teams based out of Eastern Europe

• Currently Serving customers in KSA and UAE

• Resourcing Model • Short Term

• Project based

• FTE placements

Resource Augmentation

Resourcing – SkillsetsTechnologies Skillsets

Big Data & Analytics Specialists (Tableau Software, R-Programming Language, Apache Spark, Storm, Pig, Apache Hive, Splunk, Pentaho, Power BI -

Microsoft Business Intelligence, QlikView, MicroStrategy, Informatica)

Web Technologies

ASP.NET / C# / VB.NET Developer, Classic ASP Developer, Java / J2EE Developer, PHP Developer

Frontend Developer (jQuery / Angular / React JS /Vue.js / etc.), Perl Developer, Python, Node.Js Developer / MEAN Stack

Developer, ROR Developer

Mobile Technologies Android Developer, iOS Developer, Windows Mobile Developer,

Hybrid / Cross Platform Mobile Developer (Phonegap / Ionic / Titanium / Xamarin / React Native / etc.)

Desktop Technologies C# / VB.NET Developer, Java Developer

C / C++ / VC++ Developer

UI / UX

Web Designer (Only HTML/CSS)

Flash / Action Scripting / Flex Developer, HTML 5 + Javascript + Jquery Developer, Web Designer (Both Graphics + HTML/CSS),

Web Designer (Only Graphics)

Software Testing Manual Tester

Automation Tester (Functional / Regression / Performance / Load / Security / etc.)

Open Source / CMS / Ecommerce DNN (Dotnetnuke) Developer, Drupal Developer, Joomla Developer, Magento Developer, Wordpress Developer

CRM CRM Developer (Salesforce / Vtiger / SugarCRM / Microsoft Dynamics / Sage CRM / Netsuite), Liferay Developer, Odoo

Developer, Sharepoint Developer

ERP Developers, Administrators (Microsoft Dynamics, SharePoint, Office 365, Odoo, SAP Business One, SAP ERP, SAP S/4HANA,

Oracle ERP, Tally ERP)

Internet of Things Specialists (Tessel, PlatformIO, IBM Watson, Losant, Azure IoT Suite, AWS IoT, AllJoyn, IoTivity, Kaa, SiteWhere, ThingSpeak,

Contiki)


Resourcing – Skillsets

Functions Skillsets

IT Infra, Security and Cloud

Desktop Support Engineer (Windows, Unix/Linux & Mac), System Administrator

(Windows OR Unix/Linux), Network Engineer/IT Managers

Storage Implementation & Support Engineer (Dell EMC, Netapp, Hitachi,

CommVault)

IT security & Infosec Specialists (Implementation, Audit, Administration, Pen Test

specialists)

Cloud Administrator (AWS / Microsoft Azure /Google Cloud / VMware etc)

Design, Analysis, Planning &

Architecture

Database Administrator (Oracle / MSSQL / MySQL /etc.), PL/SQL / T-SQL Developer

Business Analyst, NoSQL Database Administrator (Hadoop / mongoDB / Neo4J /

etc.), NoSQL Developer (Hadoop / mongoDB / Neo4J / etc.), Project Manager,

Technical / Solution Architect


Resourcing – Database & Pool

• Access to a wide and deep pool of skills

• Global resource pool from • South East Asia and Asia

• Middle East and Africa

• Europe and Eastern Europe

• CIS Countries

• Pool of resources from technology vendor partners

• Recruiter network in the UAE, India, and Eastern Europe

• Online sources


Resourcing – Selection Process

• Robust identification and selection process

• Strong resume screening process - by technically qualified recruiters

• Rigorous interview process - by senior experienced executives in offshore location in India

• Final interview and alignment by UAE-based senior executives


Resourcing – Client Servicing

• Local Client Servicing in the UAE• UAE-based account manager

• Alignment with client requirements through face-to-face meetings

• Local feedback and escalation point


A SnapshotYour Digital Transformation Partner

Innovation Aggregators• Leverage digital technologies to disrupt business models, re-design customer experiences and

transform business processes based on

Innovation Intelligence CloudInnovation is no longer an option. It is central to digital transformation.

There is no dearth of data. Intelligence will be the differentiator

Innovation at scale is not possible without Cloud.

About us

CloudIntelligenceInnovation

Digital Transformation Stack

InnoTx is your digital transformation partner. We help you translate your digital vision, and transform your business into a digital business. We bring disruptive technologies to

• create a first mover environment• provide a competitive edge• provide a platform to innovate

GovernmentIndustry

TransformationUtilities &

EnergyRetail

Banking & Insurance

Healthcare & Hospitality

Education

Technology-led Disruption

AI or Cognitive

IoTBig Data Analytics

eInsurance RPAPrivate, Public, Orchestration

Resourcing

About us

Who we are. What we believe in

• Middle East arm of Teckraft InfosolutionsGroup, estd 2002.

• Team of 180+ professionals spread across India, MENA and Europe offering• Advisory

• Big Data Analytics

• Software Development

• Cloud

• Resourcing Solutions

• MENA office based out of Abu Dhabi, UAE

• We enable CIO/CTO/CDO in developing services portfolio for digital transformation.

• We challenge your vision and accelerate your digital transformation. Quantum vs Incremental changes

• Making the Innovative and disruptive technology accessible locally.

• We enable experimentation. PoCs are essential

• Rooted and aligned to Govt’s vision on Innovation and backed by UAE national’s investment

About us

Logistics Pharmaceuticals ITES BFSI Manufacturing & Other International

Clients – Select List

About us

Thank You

[email protected] | +971 50 6160 889

PO Box 14 64 74 | Abu Dhabi | UAE