CSI Consulting LTD Value Proposition
- Siddharth Sen
AGENDA
~
CSI Consulting Ltd – Corporate Overview
~
Technology Integration Services Practice • Data Warehousing and Business Intelligence • Enterprise Application Solutions • Strategic Sourcing of IT Professionals Other SBUs / Practices
~
Value Proposition
Company Introduction
~ ~ ~
~
~
~
CSI Consulting (US) is a member of CSI Group headquartered in Toronto, Canada. CSI group companies are heavily diversified into almost all segments of the IT services domain. We are in the business of keeping internal and external customers happy for more than a decade. Some verticals are more than three decades old. CSI Consulting is offering a wide spectrum of IT Services in US, taking all the core competencies of the group companies into consideration. We can offer services in the various areas – • Project Implementation. • Staff Augmentation. We have a huge global talent pool of 25000 strong with current payroll strength of 1100.
CSI Consulting Ltd –Corporate Overview
North America ~ Toronto ~ Ottawa ~ Winnipeg ~ Columbus, OH ~ Gainesville, FL ~ Sacramento, CA International ~ UK, Mexico, Singapore & India Business history ~ Headquarters: Toronto, Canada ~ Established 1996 ~ Global execution capability
Corporate facts ~ Enterprise wide technology partner ~ Deployed Resources: 1000+ (across locations) ~ Partnerships : • IBM • ORACLE • MICROSOFT • WIPRO ~ 40% CAGR ~ Focused Practices • DW BI • EAS – SAP, P/Soft, Oracle, Siebel, Ariba • Project Management • IT Security and Governance • Knowledge and Content Management • SME
Group Companies
CSI America Inc (US)
CSI e-Secure
CSI Consulting Inc
CSI Networks
CSI Consulting Ltd (UK)
Mentor TechSource
Knowledge Genus
Bates Project Management
CSI Software Pvt. Ltd (India)
Group Hierarchy Ajit Someshwar
President CSI Group
Amitabh C
Director - CSI Consulting
Matty Narasimhan
Business Head - CANADA
Charles McDougall
Venkata Basavaiah
Siddharth Sen
Wayne King
Business Head - Bates
Business Head - EU
Business Head - India
Business Head – Knowledge Genus
Michael Groff
Business Head - Mentor TechSource
Munjal Kamdar Business Head - CSI eSecure
OUR VALUES
~
Local Focus, Global Reach.
~
Continuous Evolution to exceed customer expectation.
~
Addressing Tomorrow’s Issues Today !
~
Credible, Efficiency - Driven Track Record.
~
Aggressive but Sensitive to Internal and External Clients.
OUR CAPABILITIES
~
~ ~ ~ ~ ~ ~
Global delivery model • Talent pool access capability across Americas, Asia and Europe. Headquartered in Toronto, Canada Global Representation: Americas (Canada, USA and Mexico), Europe (UK), APAC (India, Singapore). Ability to build complete solutions. Ability to provide effective, timely, resource solutions. Industry expertise: BFSI, Energy and Utility, Manufacturing, Pharmaceuticals, Government, Retail. Technology expertise: DW/BI; ERP/SCM/CRM, Testing; Infrastructure, IT Security, Information & Project Management.
CORE COMPETENCIES
TECHNOLOGY INTEGRATION SERVICES PRACTICE: DW & BI EXPERTISE
BI & DW CAPABILITY Differentiators
Domains
BFSI
Energy & Utility
Retail, CPG, FMCG
Manufacturing
Telecom
Healthcare
Augmentation
Government
Managed Services
Transportation &
Services Facets
Data Warehousing
Industry Solutions
Enterprise BI
team of 200+
Consulting
employees and consultants.
Project Staff
Annual growth is around 30%.
Over 500 + years of BIDW experience.
Competency Center.
Pharmaceuticals & Bio Technologies
Partnered Onsite – offshore delivery of BIDW projects ensuring cost savings of up to 35%
Multiple end to end data warehousing engagements with team sizes ranging between 7 – 25.
Very short ramp up time frame for highly skilled
Logistics
Dedicated in-house
resources.
Very competitive onsite rates.
BI & DW SERVICES PORTFOLIO
Consult
BI & DW Solution Framework Business & Information Analysis
Architect
Data Modeling
DWH Application
ETL Architecture
Technical Architecture
Integrate
Manage
Design Implementation
Data Warehouse Administration
Development & Deployment
Capacity Planning
Data Warehouse Audit
Performance Tuning
Roadmap for Implementation
DW Project Management
Metadata Management
Data Warehouse Maintenance
Tool Evaluation
Managed DW Services
Proof of Concept
BI & DW TECHNOLOGY EXPERTISE SOURCE SYSTEMS
DATA STORAGE
ETL & DATA CLEANSING
DATA MODELLING
Informatica Informatica Constellar Constellar
ERP Cognos Cognos Decision Decision Stream Stream
CRM
DATA ANALYSIS & REPORTING OLAP
Powersoft Warehouse DATAArchitect MARTS ERWIN Oracle Designer Sales Mktg HR
MS MS DTS DTS DATA MANAGEMENT
Datastage Datastage S
SCM
SAS SAS
Legacy Systems
Oracle Oracle Warehouse Warehouse Builder Builder A
Web Data External Data
Oracle Sybase HR Enterprise SQL Server Teradata Data Sybase Warehouse Sales DB2 Informix
T A G I N G
R E A
DATA MINING
OLAP Reports
SAS E-Miner Business Miner SPSS Clementine IBM Intelligent Miner SGI Mineset Cognos Scenario
Data Mining
DW/DM SUITES
Oracle Oracle DM DM Suite Suite
Transform Extract Load Extract Transform Load SAS SAS
EssBase Business Objects Cognos Data Brio Visualization MicroStrategy MS OLAP Seagate Holos/Info Oracle Express
SAP BW SAPODS BW META DATA
IBM IBM Visual Visual Warehouse Warehouse
Platinum Platinum Repository Repository M E T A D A T A
Prism Prism
BI & DW RESOURCE DISTRIBUTION Total Resources 250
Growth in BI & DW Consultants
BI/DW Architects Business Analysts ETL Consultants
37%
60
50
2003-04
OLAP Consultants
34%
25 2002-03
2004-05
2005-06
2006-07
Data Quality Consultants
2007-08
OLAP Resources
5%
4%
125
100
4%
BI/DW Project Management
4%
160
150
0
225
210
200
15%
6%
ETL Resources
8% 24%
16%
36%
Cognos
Informatica
Business Objects
7%
Cognos DecisionStream
Microstrategy Oracle
MS DTS
Brio 9%
Actuate
Ascential Data Stage
Hyperion
Oracle Warehouse Builder
Crystal 13%
30%
24%
5% 7%
12%
Others
BI & DW – Clients (Direct and Partnered)
BFSI
Retail & Utility
Nationwide Insurance
Statestreet
Manufacturing
Cadbury Schweppes
HE Butt
Citigroup
Best Buy
Capital One
Cooper Industries
Healthcare & Pharma
Cardinal
Medtronic
Brady Corp.
Eli Lilly
General Motors
Healthways
Colgate-Palmolive
Weyerhaeuser
BlueCross BlueShield
Pepsi
Sony
GSK
Anheuser-Busch
Daimler-Chrysler
Eli Lily
Albertsons
Pfizer
Reliant Energy
Janssen Ortho
Data Organization Enterprise Data Warehouse
Data Acquisition Data Quality • • • • • • •
Staging Cleansing De-duping Obfuscation Certification Governance Standards
Infrastructure Compliance
• • • Information Dissemination • • Portals, Dashboards KPI,EPM Scorecards External Data Feeds Advanced Analytics
Data Marts MOLAP / ROLAP Cubes
ODS TDS CDI Hubs
Security Metadata Standards Audit &Control Data Validation
• Compliance
Data Enrichment • • • •
Data Mining Aggregates Pre-calculations Summarization
REPORT MANAGEMENT
TECHNOLOGY INTEGRATION SERVICES PRACTICE: ENTERPRISE APPS. SOLUTIONS
EAS: SKILLS MATRIX Decision Support
Supply Chain
Core ERP Back Office
; SAP ; Oracle ; PeopleSoft
; i2 ; SAP APO ; Ariba
Customer Relationship
Front Office
; SIEBEL ; SAP CRM
EAS Competency Life Sciences
Consumer Products/Retail
Public Sector
BFSI
Hi Tech & Discrete
Financial and Corporate Practice Financial Accounting & Controlling, Financial Supply Chain Management, Corporate Governance Human Capital Management, Strategic Enterprise Mgmt, Business Intelligence, EPM
Technology Practice Enterprise Portal, Process Integration (XI,BPM), Data Unification (MDM), Custom Development, Duet, Service Enabled Solutions, BASIS, mySAP Component Administration, Upgrader.
Tools and Services Upgrade Uptimizer, Hot Pack Analyzer, ArchievePac, SPEED, PMT, Synergy
Onsite / Offsite
Supply Chain Management, Supplier relationship management, Global Trade Services Customer Relationship Management, Logistics Execution, Product Lifecycle Management
GLOBAL DELIVERY
Logistics Practice
EAS Practice – Services Portfolio ~
Advanced Services • Planning for ERP II, • • • • • •
~
Upgrades ERP II Implementations Global Roll outs Platform Migration Technology Roadmaps Optimization Services Best practices
Core Services • • • • •
Implementation Offsite Development Staff augmentation Support Services Post Go-Live Support
~
Strategic Services • • • • •
~
Application Mgmt Services Continuous Business Improvements Compliance Services Process Optimizations Spot Assessments, Functional & Technical
Extended Services
• Custom Enhancements • New Roll Outs • Offshore Functional • •
and Technical support Support for onsite training and documentation Tools deployment
EAS RESOURCE DISTRIBUTION 500
Total Resources
Growth in EAS Consultants
400
18%
390
Project Managers
5%
425 12%
27%
300
Functional Consultants
250
200
190
100
New Dimension Products
130
80
Technical (RICEF)
0
24%
2002-03
Tech Arch / Security / BASIS
2003-04
Skills Matrix 7%
2004-05
2005-06
2006-07
Applications DBAs/QA
14%
2007-08
2% %
Skills Matrix by Business Area
7%
17%
20% DW/BI 7
37%
EPM
SAP Oracle e-Biz
NetWeaver
PeopleSoft
11%
JD Edwards
SRM/MDM
Ariba
21%
Microsoft Biz One
24%
Oracle R12
17% 13%
22%
Others
EAS PRACTICE: BENEFITS TO CLIENTS
•
Cost effective outsourcing model – In-House Employees and External Consultants.
•
CSI Pricing Model ensures that Onsite Consultant prove Cost Effective Relocation as opposed to Telecommuting.
•
Ability to Ramp Up / Down as per Project Needs.
•
Highly skilled operations team to Pre-Screen candidates.
•
Over 60% Consultants are Certified in different modules.
•
Offsite center for providing remote maintenance and support.
•
Attrition managed through optimum Backup Resources and Retraining Procedures.
•
Knowledge Retention - Maintain critical Project Resources for re-use by client.
Value for money services to Clients
EAS – Clients (Direct and Partnered) BFSI
Retail & Utility
Canada Life
Great West Life
Charles Schwab
State Street Bank
Healthcare & Pharma
Iron Ore Co.
Cardinal
KennaMetal
Medtronic
Colgate-Palmolive
AMAT
Eli Lilly
Anheuser-Busch
Brady Corp.
Pfizer
Nationwide
Albertsons
Honda
Zurich North America
Reliant Energy
Weyerhaeuser
Convergys (Dupont)
Sony
Daimler-Chrysler
Sony Electronics
Capital One
Cadbury Schweppes
Manufacturing
AT&T
Pitney Bowes
E-Bay
Suncor Energy
Level 3
Ontario Power
VALUE PROPOSITION
Domain Capabilities ±
BFSI
±
Strong understanding of Banking and Financial Services business process
±
Business Analysts and SME deployment.
■Service
■Technology
Capabilities
±
Packaged Solutions: ERP/SCM/CRM; DW/BI; Testing Services; Infrastructure
±
IT Security
±
Microsoft, IBM product suite.
±
Technology Infrastructure services.
Capabilities
■Customer
Satisfaction
±
End to End services
±
Onsite Presence
±
Flexible global staffing model
±
±
Flexible global delivery models
Off-Shore staffing models and co-sourcing model results in cost reduction
±
Time tested Methodologies
±
Multi skilled resources
±
Quality Management
±
Customer Satisfaction Survey
A Unique Value Proposition for the BFSI vertical
TECHNOLOGY INTEGRATION SERVICES PRACTICE: STRATEGIC RESOURCING
STRATEGIC STAFFING MODEL Understanding of client’s Business and IT Requirements.
We spend time to get an accurate description of the requirement before commencing our search.
Highly Skilled Operations Team to ensure the right fit. Most of the team members have been in CSI for over 5 years with at least 8 years in the IT Industry.
Access to an extensive Database of IT professionals. This is our Proprietary Database and not limited to search engines like Dice/ Workopolis/Monster.
Excellent Consultant-2-Consultant Networking to provide the best fit at short notice. This comes with years of experience in this Industry.
Use of Advanced Pre-Screening Methods for initial selection.
RECRUITMENT PROCESS - SCHEMATIC •Technical skills •Client Environment •Specific requirements •Resource Re-usability •Client Project Resource Plan
Client
Account Manager
Candidate 1
Technical Recruiter
Pre-submittal review Practice Mgr. VP Technology
Client Interview
Approved
Human Resources Reference Check
Account Manager
Candidate 2
•Mapping client tech requirements vis-àvis qualifications & experience •Telephonic Screening •Written Test / Computer Based Test (CBT) •Technical Interview •Evaluation of Projects executed •Profile of clients •Analysis of Technical fit •Methodology for addressing client project resource augment plans vis-à-vis bench •Statusplan Check & Security Clearance •Suitability to client work environment •Communication & Presentation •Immigration & Visa •Time Sheets & other documents
Consultant commences work with client
VALUED ADDED SERVICES Quality Resources at extremely competitive prices Access to Consultants with specialized skills. Advantage of low overheads at CSI is passed on to our Clients. Detailed Assessment of Candidates At all 3 levels - Operations, Practice/Account and HR. Candidates for critical positions are met personally to ensure right fit. Consulting Support and Assistance to Candidates and Clients Customized interviews to assess and prepare candidates. Job Description assistance
Job description fine tuned collectively with client.
VALUE ADDED SERVICES Specialized Recruitment Team Team has a wide network of specialists not found on job boards Excellent soft skills and negotiation skills Consultative Market Intelligence Sometimes there is a mismatch between client and candidate expectations regarding skill-sets and salary. We provide information to correct that imbalance. Extensive Database of Specialized Candidates CSI has a proprietary database of 25,000 candidates Background Check Sometimes required to be conducted by clients in regulated business pr federal government. CSI retains the services of Cluso or Backcheck for the same.
WHAT MAKES CSI UNIQUE? • Understanding the Client’s Environment & Business Dynamics • Personalized Service is our Principal Core Value • Competitive Pricing • International Presence and Global Delivery • Attrition Management • Knowledge Retention
OUTSOURCING PRACTICE
OUTSOURCING SOLUTIONS
Devised outsourcing solutions tailor-made to provide value added services to clients. ~ Engagement Models: ~
• • • •
Project/Deliverable based outsourcing: ON/OFF model (IT Security, EAS, DW/BI and Testing) Offshore outsourcing for T&M based skills delivery (recruitment and sourcing from India). Participation in large outsourcing deals (partnered with Wipro or Infosys – management and staffing for onsite and SMEs). Co-sourcing solutions (to manage client expectations in retaining specific business skills)
TRANSITION DURATION & RESOURCE REQUIREMENT Application Outsourcing Setup Pre Knowledge Acquisition Phase
1-2 weeks
Knowledge Acquisitio n Phase (KAP)
6 - 12 weeks
CSI Training, Pilot Phase (Transition)
2 - 4 weeks
Continuous Improvement
Steady State
Ongoing
Customer team involvement across different phases
Team Client Team § Program Manager § Project Manager § Application Owner/s CSI Team § Program/Delivery Manager § Project Manager § Team Members
Team Client Team § Application Owner/s § SMEs § Team Members § Project Manager/s § Business Users CSI Team § Project Manager § Project Manager/s § Team Members
Team Client Team § Project Manager/s CSI Team § Program/Delivery Manager § Project Manager/s § Team Members
Team Client Team § Application Owners § SME’s § Business Users CSI Team § Program/Delivery Manager § Project Manager/s § Team Members
PROCESS – DEVELOPMENT PROJECTS Phase Decide/Define
Deliverables ~
Estimates Project Plans
Activities ~Participate
in JAD sessions requirements
~Understand
Design
~ ~ ~
Develop
~ ~ ~
Prototype/POC High level Design Detailed Design
~Technical
Specifications ~Unit Test Plan
Unit tested Code Status Reports Review Check lists
~Development
of code (JSP/ASP, beans, components, HTML, XML) ~Clarifying issues with business/Functional analysts ~Format code using coding standards specified. ~Run the code through a static analyzer which points out the potential problem areas in the code. ~Unit testing of all components ( test plan will be generated with technical spec) ~Integration testing - with all modules ~Analyze and evaluate Change Requests. ~Code walk thru/ reviews
Test
System test plans/Cases ~ System tested code ~ User accepted code ( ready for prod move) ~ Load/Performance Plan/Tests
~Create
Deliver
~Code
~Turnover
~
move to Production
system test plans ~QA Check lists ~Code move to Q/A region ~Address Q/A issues/ bugs ~Evaluate Change Requests co-ordination Implementation
~Production
To RTB/Support
PROCESS – SUPPORT PROJECTS Page/Call from users
Phone Call/Mail
Help Desk closes the Call
Knowledgebase is updated
H E L P
Call reported at Help desk. Help Desk pages for Support on call
D E S K
Consultant understands the problem & provides final resolution (best case)
Consultant needs more information from user to provide final solution (Other scenario)
Initial Triage
Consultant sends the initial response to the user with the estimated time to provide resolution
Scenario A Configuration Change
Scenario B-Change to Existing code base
Scenario C - New Development
Help desk assigns ticket to appropriate queue & Status is changed to REPORTED
PROCESS – SUPPORT PROJECTS A - Configuration Change
DO impact analysis for config change
Implement Change
Test change
Knowledgebase is updated
Approval from Q/A team
Helpdesk closes the call
Users approval
User confirms the closure to Helpdesk / Consultant
Transport to Staging (Testing & Approval)
Implement to PRD
PROCESS – SUPPORT PROJECTS C - New Development
B - Change to Existing Code N
In scope
Time & cost estimate
Y Business analyst provides Specifications to Developer
Get business approval
N
Y
Tech Specs create/ review
Update Specs
Code Development Code walk through by Developer Testing Q/A Testing & Approval Transportation to PRD
User confirms the closure to Help Desk / Consultant
Specs exists
Reverse eng. code & understand the logic
Knowledgebase is updated
Functional / Technical specs is built
TYPICAL PROJECT ORGANIZATION Onsite Project Lead/Manager
Offshore Project Manager Technical Lead
Client Managers Business Analysts Others
Onsite Developers
Sourcing team (offshore)
Module Lead
Developer
Module Lead
Developers
Application Support/Development
Testers
SQA
INFORMATION AND PROJECT MANAGEMENT PRACTICE
AREAS OF EXPERTISE
~
Business and Information Technology Management.
• • •
Content Management. Document and Records Management. Business Intelligence.
Portfolio / Project Management. ~ Portal & Web Strategy. ~
• •
Deployment. Integration.
Advanced Collaboration & Messaging. • Corporate social networking. ~ Governance and compliance management tools ~ eLearning. ~
OUR SKILLS AND KNOWLEDGE
~
Enterprise & Application Architects - Enterprise and application design, assessment and deployment services.
~
Business Information / Technology Analysts - Expertise in a variety of business areas and solutions.
~
Application Developers - Application developers, system administrators and configuration experts.
~
Portfolio & Project Management
- Skilled project managers, and coordinators
SOLUTION APPROACH
PM SERVICES AND PRODUCTS Client Requirements
PM Training
Consulting & Assessment Services
Project Planning & Delivery Services
Bates Project Management Methodology
EFFECTIVE PROJECT MANAGEMENT Senior Management Support and Direction Human Considerations Business & Technology Processes & Methodology Project Management Systems & Tools
Project Management Methodology
Project Management Organization
Education & Certification
Leadership Skills
PROJECT MANAGEMENT METHODOLOGY
~ ~ ~ ~ ~ ~ ~ ~ ~
Universal and scalable. Integrates with technical life cycle methodologies. Framework “What to Do” and “How to Do”. Earned value integrated into the planning, control and execution. Project selection, planning, control and execution. Project risk, quality and procurement management Communications, team building, conflict management Complies with PMI’s PMBOK Integrates with IBM’s Rational Portfolio Manager, RPM.
GOVERNANCE, RISK & COMPLIANCE PRACTICE
CAPABILITY OVERVIEW
Services Offered
Assurance
Compliance
IT Security
• COSO
• SOX/Bill 198
• Applications
• COBIT
• HIPAA
• Platform
• PIPEDA
• Network
• Consulting • Advisory Services • Compliance • Process Controls
Consulting team certifications to complement their CA / CPA / CIA Core Consulting Team 10%
10% Sun Certified
• CISA • CISSP
75% CISA
12%
CCSA / CCSE
CISSP
19% CCNA / CCNP
10% Entrust PKI Certified
19% BS 7799
-Certified Information System Auditor -Certified Information System Security Professionals • CISM -Certified Information Security Manager • BS 7799 -Certified Lead Auditor • ISO 27001 / 2 -Certified Lead Auditors • ITIL -ITIL Certified • CCSA -Checkpoint Certified Security Administrator • CCNP -Cisco Certified Network Professionals • PKI -Entrusted PKI Certified
CSI eSECURE – SERVICE PORTFOLIO
• Expert Domain Knowledge Core Capabilities of Consultants
• Global Reach • Industry Experience • Multiple Qualifications • Live Project Experience
COMPLIANCE CONVERGENCE INTEGRATED APPROACH
•Identify similarities and duplications in the •current models and structures •Build company wide framework and platform
FRAMEWORKS COSO COBIT BS 7799 ITIL SAS 70 GASSP IETF SecurityHandbook
IT Controls Sarbanes Oxley Act C-SOX (Bill 198)
•Develop a centralised core team •Continuous training and education platform
Operational Risk Basel II PCI-VISA / MasterCard AML Broker Dealer Act OSFI B-10
Corporate Governance Risk Assessment Risk Management Polices and procedures Monitoring / Auditing Reporting Documentation Record Retention Internal Controls Certification Business Continuity Regulatory Penalties & Fines
Privacy GLBA PIPEDA UK DPA EU Privacy Guidelines OPA 1974 Privacy Acts & Amendments
WRAP UP ~
CSI Consulting “ a better way” to meet your needs
~
Next Steps • How can we engage with you ?
Thank you
CONTACT INFORMATION
~
CSI Consulting Ltd:
•
Siddharth Sen Business Head EU
Tel: +44 1189 072 535 X 6007 (UK/EU) +1 416 847 0742 (US/Canada) E-Mail:
[email protected]