Title: KARYA Technologies - Data Management Services
1Data Management Solutions Data Warehouse
Business Intelligence Integration Master
Data Cloud Mobility CPM Data Governance
Big Data
2Agenda
About us
What we do ?
How we do it ?
How we do it differently ?
3Agenda
About us
What we do ?
How we do it ?
How we do it differently ?
4About Us
- Provider of High-Quality Cost Effective
Enterprise Solutions which includes - Business Software (ERP CRM)
- Application Development
- Data Management
- Digital Transformation
- Software Quality Assurance
- IT Infrastructure Services
- Current Headcount of 983.
- 687 Global Delivery Center (GDC)
- 296 Dispersed globally
- Headquartered in PA, USA with Global Delivery
Center (GDC) center in India
5Our History, Evolution, and Milestones
2007
2008
2009
2010
2011
2012
2014
2015
CMMI Action Plan
Mobile Platform Development Enterprise Mobility
Services
Microsoft Dynamics Practice
Microsoft Technology Solutions.NET Framework,
SharePoint, SQL Server, MSBI, BizTalk
IT Infrastructure with Cloud Data Management
Solutions
Open Source Technology
More ERPs, CRMs
Oracle Platform Technology Solutions
Quality Assurance
Internet of Things
Social Media Integration
Big Data
Technical Expertise
Functional Skills
Business Analysis
Industry Vertical SMEs
Technical Writing
Project Management
IT Infrastructure with Cloud
6Our Core Values
With these values reinforced, we are a
High-performance IT Service Organization
Highlight
Client Focus
Technology Innovation
Professionalism
Efficiency
Agility
Responsiveness Quick TAT
Quality
Trust Integrity
Competency
Flexibility Scalability
Time Consciousness
Top-Notch Problem Solving
Commitment
Cost Consciousness
LeadershipResponsibility
Hi-Availability
Excellence
Team-Work Collaboration
Continuous Learning
Leanness
Communication
7Our Lines of Business
Enterprise Solutions
Business Software
Application Development
Data Management
Quality Assurance
IT Infrastructure
- Hardware, OS, Network, Storage, Firewalls
- ERP CRM Implementations, Upgrades,
Customizations, Integration
- New Application Development, Enhancements,
Modernization, Platform Porting, Integration
- Functional and Non-functional Testing
- SQL Server
- SSIS, SSRS, SSAS
- PowerBI
- Microsoft Dynamics Suite (AX, NAV, GP, CRM)
- Microsoft (SharePoint, Core .NET, BizTalk)
- Cloud Virtualization Solutions
- Provisioning Configuration Management
- Oracle Database
- Oracle BI(ODI, OBIEE, OBIA, Hyperion)
- Oracle(Fusion Middleware, Web Center)
- Digital Solutions (Web Application, Mobile
Application, Internet of Things)
- IT Infrastructure Compliance
- Open Source (Frameworks, Languages, CMS, DMS,
Web Servers, BI)
Managed Services
8Our People
KARYA Technologies Group Chairman / Group CEO
(USA)/CFO
CEO India / VP Global Services
Microsoft Practice
Digital Solutions
Delivery Management Group
Oracle Practice
Data Solutions
210
189
91
225
88
9Our Global Footprints
10Some of our Esteemed Clients
11Our Technology Partners
Category Partnership Vendor
Accelerators DELL SharePoint Migration Suite
Automation Rfsmart
Data Warehousing BI Atlas, DOMO, Jet Reports, Prophix, Solver
Cloud Azure, Amazon Web Services, Jitterbit, Rackspace
E-Commerce Kecommerce, Magento
Enterprise Mobility Blackberry, Samsung
Field Service Industry Key2Act (Wennsoft), Dynarent
Integration Data Masons EDI, Scalable Data Systems EDI, Scribe, Talend
Payment Processing Bluepay, Card Connect, Charge Logic
Supply Chain Management Demand Works, e-con solutions, eBridge, Perfion (PDM)
12Agenda
About us
What we do ?
How we do it ?
How we do it differently ?
13Data Management Solutions Practice
Advanced Services
Cloud
Mobility
Corporate Performance Management
Data Governance
Big Data
Core Services
Foundation Services
IT Infrastructure
Database Architecture Administration
Data Quality
Meta Data
Documentation
14InformaticaOur Service Offerings
247 Production Support
Advisory
Solution Delivery
PowerCenter
- Healthcheck Assessments Recommendations
- IT Infrastructure
- Tools Technologies
- ETL Application
- Architecture, Design Performance
- MDM
- Data Quality
- Data Governance
- Architecture, Planning Roadmap
- IT Infrastructure Plan
- Integration
- Data, Application Cloud Integration
- Architecture Design
- Implementation Plan
- MDM, Data Quality Governance
- Server Monitoring
- Application Monitoring
- Trouble Shooting Failure Recovery
- ETL Performance Tuning
- Upgrades Patch
- Application Support
- Project Delivery Management
- Install, Upgrade, Configure, Setup
- PowerCenter, Connectors, Meta Data Manager, IDQ
and MDM Servers - Development
- ETL Design Development
- Integration Hubs
- MDM Hubs
- Data Quality
- Cloud
- Job Orchestrations
- ETL Test Management
PowerExchange
Data Quality
Master Data Management
BigData Management Edition
Meta Data Manager
- Options
- Ad-hoc support
- Managed Services
15247365 Production Support
Administration Support
ETL Application Support
- Scope
- Informatica Server ETL Application
- Database (Oracle, SQL Server)
- Hardware Server OS
- Network
- Environment Monitoring
- Source Target Connectivity Issues
- Troubleshooting Failure Recovery
- Job Reruns
- Performance Tuning
- Security - Admin Developer
- Reorgs, Backup Restore
- Proactive Maintenance
- Patches, Hotfixes
- Health Check Diagnostics
- Non Production Env. Mgmt
- Informatica Liaising
- Deployment
- Scheduling Workflows
- Analyze Job Failures
- Break Fixes
- Performance Tuning
- Identify Create CRs
- Objective
- Stabilization
- Proactive Reactive Maintenance
- BAU Support
16IBM Cognos - Our Service Offerings
247 Production Support
Advisory
Solution Delivery
- Project Delivery Management
- Install, Upgrade, Configure, Setup
- Cognos dispatchers and gateways, Framework
Manager, Cognos configuration, user namespace,
load balancing and optimization - Development
- Framework Manager Model, Relational and
Multi-dimensional - Reports and Cubes
- Dashboards and Visualizations
- Alerts and notifications
- KPIs, Balanced Scorecards
- Healthcheck Assessments Recommendations
- IT Infrastructure
- BI Tools Technologies
- BI Application
- Architecture, Design Performance
- Current state BI maturity and requirement
- Architecture, Planning Roadmap
- IT Infrastructure Plan
- Data Integration and BI
- Data modelling
- Architecture Design
- Implementation Plan
- Governance and Metadata management
- KPIs and Metrics
- Self service and centralized BI provisioning
(BICC)
- Cognos Server and Job Monitoring
- Trouble Shooting Failure Recovery
- Report and Model Performance Tuning
- Upgrades Patch
- Consulting Training
- Application Support
- Options
- Ad-hoc support
- Managed Services
17Data Solution Using IBM Cognos
Cognos Connection Portal
Data Lineage
Source Systems
Framework Manager Meta Data Layer
Cognos Security Layer
Query Studio
Star Schema
IT Provisioned BI Content
Report Studio
Analysis Studio
Cloud ERP CRM E-Commerce
Self Service BI Content
Cognos Work Space
SSAS Cube Data
Cognos Cube Data
Essbase Cube Data
Event Studio
Data Governance
18Qlik- Our Service Offerings
247 Production Support
Advisory
Solution Delivery
- Project Delivery Management
- Install, Upgrade, Configure, Setup
- Qlikview Desktop and servers, Publisher, Security
configuration, load balancing and optimization - Development
- Qlikview Data Models
- Data Load Scripts
- Dashboards and Visualizations
- QVD Reload schedules and QVW distribution
- Publishing and Collaboration
- KPIs, Balanced Scorecards
- Healthcheck Assessments Recommendations
- IT Infrastructure
- BI Tools Technologies
- BI Application
- Architecture, Design Performance
- Current state BI maturity and requirement
- Architecture, Planning Roadmap
- IT Infrastructure Plan
- Data Integration and BI
- Data modelling
- Architecture Design
- Implementation Plan
- Governance and Metadata management
- KPIs and Metrics
- Self service and centralized BI provisioning
(BICC)
- Qlikview Server and Job Monitoring
- Trouble Shooting Failure Recovery
- QVW and Model Performance Tuning
- Upgrades Patch
- Consulting Training
- Application Support
- Options
- Ad-hoc support
- Managed Services
19Data Solution Using Qlik Architecture
Frontend Layer
Reload Engine
Management Service
Backend Layer
20Tableau - Our Service Offerings
247 Production Support
Advisory
Solution Delivery
- Project Delivery Management
- Install, Upgrade, Configure, Setup
- Tableau Desktop and servers, Online, Security
configuration, - Development
- Data Marts and Data Warehouses
- Tableau Curated Data Sources and Models
- Tableau Workbooks, Views, Dashboards and Stories
- Tableau Analytics for Mobile and Tablets
- Tableau Extract schedules
- KPIs, Balanced Scorecards
- Healthcheck Assessments Recommendations
- IT Infrastructure
- BI Tools Technologies
- BI Application
- Architecture, Design Performance
- Current state BI maturity and requirement
- Architecture, Planning Roadmap
- IT Infrastructure Plan
- Data Integration and BI
- Data modelling
- Architecture Design
- Implementation Plan
- Governance and Metadata management
- KPIs and Metrics
- Self service and centralized BI provisioning
(BICC)
- Tableau Server and Job Monitoring
- Trouble Shooting Failure Recovery
- Tableau Workbook Performance Tuning
- Upgrades Patch
- Consulting Training
- Application Support
- Options
- Ad-hoc support
- Managed Services
21Our Data Warehousing BI Solutions forMicrosoft
Platform
Features
Objectives
- Operational Efficiency
- Sales Marketing Effectiveness
- Corporate Performance Analytics
- Web Analytics
- End-to-end Data Architecture, Integration
Analytics
- Mobile Enablement Cloud Orchestrations
Data Sources
Integration Batch (ETL) Real-time (EAI)
Data Warehouse
Reporting Analytics
Reports, KPI Dashboards and Score Cards
Dashboards
EPM
Data Warehouse
ODS
BI Portals
Flat Files
Guiding Principles Sound Architecture Design
Advanced Technologies Performance Meta Data
Data Quality Data Governance Methodology
Documentation
22Our EDW BI Solutions for Oracle Platform
Features
Objectives
- Operational Efficiency
- Sales Marketing Effectiveness
- Corporate Performance Analytics
- Web Analytics
- End-to-end Data Architecture, Integration
Analytics
- Mobile Enablement Cloud Orchestrations
Data Sources
Integration Batch (ETL) Real-time (EAI)
Data Warehouse
Reporting Analytics
Dashboards, Integration - Portals MS Office
Oracle BI Dashboards
BI Delivers
Portal Integration
Third Party Integration Tools
Third Party Analytic Tools
MS Office Integration
Flat Files
Guiding Principles Sound Architecture Design
Advanced Technologies Performance Meta Data
Data Quality Data Governance Best Practices
Documentation
Flat Files
23Our Data Solutions Informatica Platform
Data Target
Informatica IntegrationPlatform
Data Source
Data On-Premise Data On-Cloud
Data On-Premise Data On-Cloud
Power Exchange
ERP/CRM Systems
ERP/CRM Systems
Informatica Data Quality
Flat Files
Flat Files
24Our Data Solutions Talend Platform
Data Sources
Integration Batch (ETL) Real-time (EAI)
Data Warehouse
Reporting Analytics
Reports, KPI Dashboards Score Cards
Talend Open Studio
Data On-Premise Data On-Cloud
Data Integration
Application Integration with ESB
Dashboards
Data Quality
Talend Master Data Management
Big Data Integration
OLAP Cube
Power Pivot
Portals
Flat Files
25Our Talend Center of Excellence
KARYA Technologies is Partnered with Talend Since
2012
- Thorough knowledge and experience on Talends
Suite - Data Integration
- Application Integration
- MDM
- Cloud Integration
- Big Data Integration
- Broad service offerings
- Design Solution Orchestration
- Installation and Configuration
- Core Development
- 247365 Operations, Maintenance Production
Support - Consulting Training
26Highlights of our Data Management Solutions
Practice
- IT Infrastructure Know-How - Hardware, OS,
Network, Database Cloud - Experience with Source Systems ERP, CRM, Web
and Legacy - Data Architecture Modeling competency
- Advanced Integration Expertise - Batch (ETL)
Real-Time (EAI) - Business Intelligence/Analytics Specific
Competency - Visualization Self-Service
- Corporate Performance
- Statistical Analysis (R, SPSS, SAS)
- Web Mobile BI Portals
- Performance Oriented Solutions DB, ETL, Reports
Analytics - 3rd Party Tools Proficiency ETL, BI, EAI, DQ,
MDM - Methodology, Best Practices
- Data Quality, Metadata Management, MDM, Data
Governance - Documentation - Run book Instruction Manuals
27247365 Production Support Process
KDMS is KARYAs Delivery Management Portal, a
SharePoint based Web Application hosted on Azure
28Advisory Services
Our Approach
Our Current Engagements
- Strategy, Blue Prints
- Business Fit Analysis
- Technology Decisions
- Infrastructure and Capacity
- Technology and Tools Evaluation
- Cloud Considerations
- Implementation Plan
Methodology
Documentation
Detail Orientation
Justification
29Training Services
ADVISORY
Curriculum Structuring
Content Sourcing Development
Training Delivery
Training Need Analysis
Assessments
Types of Trainings
Key Benefits
- Product Functionality Focused Training
- Role-based Training
- Train the Trainer
- End User Training Business and Technology
- On-Job Training
- Greatly Enhances Productivity
- Real-time Hands-on
- Certified/Experienced Trainers
30Our Solutions for Industry Verticals
Industries We Serve
Vertical Solutions to support your
31Our Solutions for Industry Verticals
Mining
Agriculture Food Forestry
Supply Chain Management
- Dairy Products
- Food Beverage
- Poultry
- Wood Processing Ship Building
- Logistics/Distribution/ Transportation
- Retail
- Trading / Export/Import
- Trading Apparel
- Warehouse and Inventory Management
- Whole Sale
Services
- Automotive
- Carpentry
- Education
- Engineering- Construction/ Electrical/Electronics
- Equipment Rental
- Financial Services
- Hotel/ Hospitality
- Information Technology
- Management Consultancy
- Packaging
- Professional Services
- Thermal Solutions
- Travel
Health Care
Manufacturing
- Discrete Automotive
- Discrete Medical devices
- Process Building Materials
- Process Cement
- Process Chemicals
- Process Metal Finishing
- Process Paper
- Process Pharmaceuticals
- Process Plastics
Utilities
- Natural gas
- Electricity
- Telephone
- Water
32Agenda
About us
What we do ?
How we do it ?
How we do it differently ?
33Global Delivery Model
How we do it ?
Types of Engagement
Overall Engagement Process
Collaboration Mode, Timings
Modes of Engagement
People Logistics
Pricing
Our IT Security Compliance Standards
34Types of Engagement
Types
We Support you for the Hours Purchased
We Offer Fully Dedicated Resources
We help Procure Licenses
We Undertake Projects
You request certain skillset(s). We Fulfil, you
manage those Remote Resources as your team
We help you purchase Microsoft, Oracle and other
third-party licenses, Cloud and other Hosting
spaces
You Purchase certain Monthly hours, We agree
scope and serve you for the hours
You can assign us end-to-end projects
- System Monitoring Break fixes other Production
Support Activities - Application Development
- Sys Administrators, DBAs, ETL Admins BI Server
Admins - Architects Developers Database, ETL,
Reporting - Business Analysts
- QA/QC Resources
- Advisory
- Application Design Development
- Infrastructure Implementations,
- Quality Assurance
- Oracle, Microsoft, Talend, Solver, Tableau
- Azure, AWS, Rackspace
Opted During
Support Requests (Mostly) Project
Requests (Occasionally)
Resource Requests
License Requests
Project Requests
35Overall Engagement Process
Our Engagement model is a Judicious combination
of People, Processes Tools
- All Technical, Functional, Administration Experts
under one roof
One-time Tasks
Recurring Tasks
Document Execution Engagement Kick-off Sign
MSA, SOW, SLA A Formal kick off meetingDesignate
KARYA/Client POCs
Engage, Execute DeliverAnalyze, Design,
Develop, Deploy, Test, Maintain
Establish Client Connectivity VPN Preferred
Access Tools Setup Client in KDMS
CollaborateContinuous Meetings, Reporting and
KDMS
Knowledge TransferOn all aspects to our senior
Functional Technical Consultants
KDMS is KARYAs Delivery Management System, a
SharePoint based Web Portal hosted on Azure
36Documents Executed
Non-Disclosure Agreement (NDA) Master Service
Agreement (MSA)
Mutual Signing of NDA MSA with a Default SLA.
Default SLA
Mutual signing of the first SOW along with SLA
and Engagement Kick-Off
Statement of Work(SOW)
Mutual signing of additional SOWs for subsequent
projects during the course of time
Service Level Agreement (SLA)
37Knowledge Transfer
From KARYA to Client
Approach
From Client to KARYA
Objective
Project Requests
Inventory the Clients Enterprise System
- Understand
- As-Is Scenario
- Current Pain Points
- Document
- To Fill Gaps
- To Educate KARYA Support Teams
- Design Documents Business Technical
- User Adoption Training Documentation
- Best Practices Documents
Identify Systems Relevant to KARYAs Scope
Gain Access to the Relevant Systems
Scope
- Depends on Scope of SOW
- Comprehensive or Targeted
- Core Application
- Add-ons or Legacy Systems (if any)
360o Technical Analysis
Support Request
360o Business Analysis
- Requests Knowledge Base Issues Resolutions
- Operational Statistics
- User Instructions
Method
- Use Senior Consultants and Developers
- Run Scripts, Inspect Logs
- Review
- Processes
- Documentations
- Code Base
- Conduct Client Interviews
Document Findings and Review with Client
Socialize within our Delivery/Support Team
38KARYA Delivery Management Portal
Request Management
- What is a Request? One of the Four from the
Client - Project Requests (PR) Closed Ended Tasks
- Advisory Evaluation, Recommendations, Strategy,
Architecture, Blueprints, Roadmaps, Tools
Assessments Selections DB, ETL, Analytics,
EAI, ESB, MDM, Continuous Improvement - Analysis Design ETL, KPI, Dashboard, Web
Service, Data Mapping - Development DB, Data Modeling, ETL, Web
Service, Reports, Dashboards, Cubes, Portals,
MDM. - Functional Tasks Requirement Gathering
Analysis, Documentation, Training, UAT - Support Requests (SR) - 247365 Operations,
Maintenance and Prod Support - Infrastructure and Admin Tasks
- O/S, Database, Servers ESB, ETL, Reporting,
Analysis. - Security and Access related
- Resource Requests (RR)
- Sys Administrators, DBAs, ETL Admins BI Server
Admins - Architects Developers Database, ETL, Report
- Business Analysts
- QA/QC Resources
39KARYA Delivery Management Portal
KDMS is the system that connects us with our
Global Clients
Request Pipeline
Advantages of using KDMS
- Strongly SLA driven
- Alerts and Workflows at right stages
- Works well for Project Support Requests
- Handles Traditional Agile Methodologies
- Complete Visibility
- Cloud-hosted and Web-based Solution
- Accessible Anytime Anywhere
- Real-time status updates on Requests
- Placeholder for relevant SDLC Documents
- Knowledge base that stores/grows Issues
Solutions
New Pipeline Request created, categorized,
estimated client approved
Execution Pipeline Request gets worked on
Client UAT Pipeline Request undergoes Client UAT
Billing Pipeline Request gets Invoiced
Request History Request gets Archived
40Project Requests Engagement Model
Sys Administrators, DBAs, ETL Admins BI Server
Admins , Architects Developers Database, ETL,
Reporting, Business Analysts, QA/QC Resources
Assigns the Tasks to the Right Resource Mix from
KARYA Resource Pool.
Specifies Requirements
KARYA Project Manager
KARYA Resource Pool
The assignees get the tasks Accomplished
Delivery and Reporting
Client
New Projects New Request Creations, Resource
Assignments, Status Updates, Reports Analytics,
Document Uploads
New Requests Creation, Status Enquiry, Workflow
Approvals, Reports Analytics, and Documents
Upload
Time Logging, Request Status Updates, Document
Uploads
Timesheets Invoicing
41Resource Requests Engagement Model
Rejects Resource(s)
Client
KAMAnalyses Requirements
ClientInterviews Resource(s)
KARYA Resource(s) On-boards
Client Specifies Resource(s) Requirements
KAM Suggests Resource(s)
Administration
KARYA Account Management (KAM)
Delivery Process
Accepts Resource(s)
KARYA Resource(s) Engage with Client Fulfill
Tasks Provides Status
Client Assigns Projects / Tasks to KARYA Resources
KAM Monitors Engagement
Billing
Extension / Completion of Engagements
Administration
KARYA Resources
42Collaboration Multi - Modal
Client System Access/Connectivity
Delivery Management
Telephone
E-mail
- Video Conference
- Scheduled
- Adhoc
Chat
Remote desktop software
Weekly Status Reporting
43Modes of Engagement People Logistics
Resource Location
Mode of Engagement
Use Cases
KARYAs Site
Client Site
Modes
- 247365 Operations, Maintenance Production
Support - Development Projects
- Infrastructure Services
Mode 1
Fully Remote (to the Client)
- Project Manager (POC)
- Resource Pool
- Sys Administrators, DBAs, ETL Admins BI Server
Admins - Architects Developers Database, ETL,
Reporting - Business Analysts
- QA/QC Resources
- Comprehensive Projects
- Training
- Project Manager (POC)
- DW/BI Architects
- Industry Vertical SMEs
- Project Manager (POC)
- Resource Pool
- Sys Administrators, DBAs, ETL Admins BI Server
Admins - Architects Developers Database, ETL,
Reporting - Business Analysts
- QA/QC Resources
Mode 2
Hybrid
Need based Travel
44IT Security Compliances
Stringent IT Security Policies to Secure Clients
Information IT Assets
- Well Defined Security Policies Standards
- Perpetual Employee Training
- Periodic Review
- Physical Environmental Security
- Secure Facility Inside Out
- User Access Control
- Secured Communications Operations
- Authorized/Secured Information Exchange
- Secured Websites
- Secure Media Handling
- Tele-Commuting Mobile Computing
- Information Backup
- BCP DR Sites
- Network Security
- Network Access Control
IT Compliances we are aligned with
ISO, PCI DSS, SOC 2, Safe Harbor, SOX
Industry Vertical Compliance we Service
HIPAA, HL7 , FDA, CAPA, MSDS, USDA, CPSC, CPSIA
45Agenda
About us
What we do ?
How we do it ?
How we do it differently ?
46How we Address Offshore Challenges ?
- Best Practices during the Engagement
- Quality Deliverables with No/Minimal Rework
- Training/Awareness to Analysts Developers
- Follow the Right Process and Check-lists
- Code Reviews and Peer Reviews for all
Deliverables - Additional Layer of Testing
Quality Timeliness of Deliverables
- SPOCs with good Technical Functional Skills
- Separate SPOC for every Client
- SPOCs fully responsible for Deliverables
Accountability Aspects
- Direct collaborate for at least 4 Hours with
KARYA Team - Can extend Collaboration beyond 4 Hours
- 24x7x365 Production Support Model
- High Availability
Collaboration Hours High Availability
- Delivery Team with Good Spoken Written English
- Regular Communication Workshops for Delivery Team
Communication Levels
- ERP/CRM Product Specialists, Business Analysts
- Industry Vertical SMEs
Functional Specialists
47KARYA Value Proposition
Comprehensiveness
Client Focused SLA Compliant
Depth Breadth
- Advisory, Delivery 24x7 Support
- Core Data Management Services, Foundation
Services, Advanced Services - Support Capabilities for Core Product,
Third-Party Add-ons and Legacy Systems. - Support for Emerging Technologies such as Cloud,
Mobility, Big Data
48(No Transcript)