Presentation for Business pitch CCMo and PWP

Business presentation

1. Presented by www.dwpractice.com Realize your Potential

2. Next Steps Enterprise Application Management Services Agenda DWP Background Enterprise Data Management Services Questions

3. Fast Facts More than 12 years of experience in providing Software Development Services specialized in Data warehousing and Application Development. Atlanta, GA based leading IT consulting Company that helps companies to realize their potential. US Corporation with established offshore software development centers. We develop our thought leadership through collaboration across multiple Industries Experienced in SDLC project Implementation for major corporations. Consulting led approach to delivery of best quality solutions. Office Locations Atlanta, GA ( Corporate Office ) Hyderabad, India ( Global Delivery Center ) Bangalore, India ( Global Delivery Center ) Strategic Partners No of Employees Company Introduction

4. Our Mission is to Provide our clients with the service of highest possible VALUE. Results Produced + Process Quality Price to Customer + Service Acquisition Cost = Value “We intend to achieve value through effective resources, proven methodology and efficient execution.” DW Practice, LLC

5. Core Services Data warehousing Business Intelligence ETL/Big Data Microsoft/ JAVA technologies Third Party Tools and Technologies Open Source Technologies Enterprise Data Management Services Centre Of Excellence Enterprise Application Management Services

6. Enterprise Data Management Services Enterprise Data Management Services

7. BI SERVICES & ANALYTICS BI Consulting Data Warehousing Reporting / Dashboards / Alerts Analytic Services Extract, transform and load (ETL) Tool Selection Data Warehouse Design Dashboards OLAP cubes Reporting Key Performance Indicators (KPI) Analyzing reporting requirements to model data warehouse schemas Building end-to- end ETL solutions Running ETL on cluster environment Report and Dashboard development Migration across reporting platforms Customized report development Performance optimization Tool comparison Design and delivery of different alert mechanisms Text Analytics Web Analytics / Usage Analytics

8. BI Overview Security Layer Discovery Operational Data Transactions (Legacy, CRM,ERP ) Supplier Data Customer Data External Data (Web, XML) DB DB DB Acquisition Integration Brokers ETL Integration Enterprise Data Ware House Financial Data Mart Sales Data Mart HR Data Mart Presentation Direct Access Portal Integration Market Analysis Reports Budgets Marketing Meta Data Management

9. Building a BI Solution Master Data Management Enterprise Data Ware House Third Party Feeds Conformed Dimensions ETL(Extract, Transform, Load) Source Systems and Transactional Systems Financial Data Mart Sales Data Mart HR Data Mart Bottom Up Approach Financial System HR System Sales System Customer Data Web Data Risk System Wealth Mgmt

10. Traditional Projects Real-time or deep analysis of information = Expensive and difficult to implement and maintain. Unable to feasibly achieve processing velocity and storage volumes. Traditional EDW very structured requiring very rigid design and development behavior to produce a valuable outcome. Highly structured environment resulting in costly changes to keep up with business demands. BI Approach Scalability to thousands of Reports Velocity and data volumes to achieve large, complex or real time analytics are now “possible”. Implementation in a more flexible data and programming model Initial implementation from multiple unique data sources less intensive in both time and cost. Modification to handle changes is less intensive in both time and cost. Overcoming Traditional Analytics Barriers

11. Application Architecture & Design Implement DWP Methodology Business Discovery Functional Gaps Application Portfolio Assess Business Requirements Data Requirements Functional Requirements Plan Database Architecture Data Probing & Assessment ETL, Target DWH Physical Modeling Logical Modeling Design & Develop Meta Data Presentation Direct Access Market Analysis Reports Budgets Marketing

12. Business Cases Compliance and Statutory Reporting Helps Decision Making Web Data Analysis Improves Efficiency Spend Analysis Insight into Customer Behavior Cross Selling and Up selling Analytics Profit Analysis

13. Configuration Tools Consumer Data Ware House Master Records Application Consolidation Engine Queued for merging Load Process Stage Process - Delta detection - Cleansing - Delta detection - Cleansing Landing Tables Standing Tables Sources (References Data) Auto Merge Match Manual Merge Un- Merge Target Data Name New Updates Address X-REF History Validation Lineage Match Rules X-REF Meta Data Master Data Management (MDM)

14. Enterprise Application Management Services Enterprise Application Management Services

15. 360 Degree Application Management Services Application Development Services User Interface / Custom Development Application Customization And extensions Data Management and Reports Development R&D Labs Support Application Support and Maintenance Services 24 x 7 Global Support Application Maintenance Infrastructure Management Technical Help desk Database Management Application Migration/ Reengineering End to End Implementation Global Rollout Application Migration Documentation And Training Application Integration Application Support and Maintenance Services Migration assessment Application Development Services Process Re-engineering Application/Database Upgrade System Integration and Data Integration Services Back-end/B2Bi Integration API Integration And Development Enterprise Application Integration Data/ESB Integration SOA/BPI Integration Microsoft Technology Oracle- Java Technology Open Source - PHP Cloud / Mobile Apps Technology QA Services Enterprise Application Management Services

16. Certified Microsoft Professionals Enterprise Portals / MOSS Business Process Integration Enterprise Application Integration Intranet/Extranet Application Rich Internet Application E-Commerce Application Data Warehouse/Business Intelligence Customer Relationship Management (CRM) Back office Data Transformation Application reengineering Solution Accelerators Process Accelerators Business Solutions Service Models ASP.NET AJAX Silverlight C# VC++ VB VB.NET XML, WS* WSE, WCF WPF, Winforms Ado.NET SQL Competency Value Addition Skills Technologies Microsoft - COE MOSS MSCRM

17. Certified Oracle/Java Professionals Business Process Integration Enterprise Application Integration Intranet/Extranet Application Rich Internet Application E-Commerce Application Data Warehouse/Business Intelligence Back office Data Transformation Application reengineering JAVA AJAX Applets /Swings POI JSP JSF JMS XML, WS* Velacity Spring/Struts EJB Oracle Competency Value Addition Skills Technologies Java Technologies - COE GWT Jasper Reports Solution Accelerators Process Accelerators Business Solutions Service Models

18. Innovation in four paradigms MTS SS7 Parser Tools Library Ticket Tracking System Customizable Framework Nexus Recruitment Tracking System Content Management System Email Validation System Managed Services SAAS Solution Accelerators Process Accelerators Business Solutions Service Models Custom Form Generator Version Management System Mobile Apps Extended Business Model Consulting Services Value Creator

19. Delivery / Transition Framework Assessment Transition Stabilization Optimization Project Planning & Resourcing Project Planning & Resourcing Parallel Perform - Call Based Support - Resource Consolidation Specific Transition Plan System Maintenance and Technical Document (SMTD) Execution Process Document (EPD) Weekly – Metrics Reports Steady State MIS, Status Reports Project Status Reports Continuous improvement plan Quarterly Review Process Service Delivery Lead Transition Lead SME’s Business Analyst Operation / Production Support Team Governance & Controls Productivity Improvements Instance & Infrastructure Consolidation Process Consolidation Key Activities Key Deliverables Key Staffing

20. Slide 21 Case Profile Case Studies The product involved contribution of the R&D Team. Some of the concepts had to be proven before it could be sent over to the implementation division. Case Profile The client is an industry leader in product innovation and product service of Cranes and Food equipment. The client needed DWP to improve the quality of data coming into data warehouse and subsequently data mart . This will help the business users to look at the financial data of in a better way and take right decisions for the business Case Profile Case Profile The client is the Judiciary System of Nigeria. The client partnered with DWP to implement an IT solution for their Legal System. Case Profile Case Profile The client is an IT solutions provider based out of Cambridge ,MA. The client deals with providing Life science Industry domain business solutions to Research Laboratories, Pharmaceutical companies and other Life science entities. Case Profile Case Profile Client is an established ISV based out of Florida. The client wants to develop a web application that will act as an interface with a physical Device (Pulse reading Oximeter)

21. Budgeting was done entirely on excel spreadsheets which is prone to errors and data integrity Our Success Stories Business Need Build budgeting models for their Capital expenses, Operating expenses, Corporate Branch Revenue Activity, Compensation expenses. Technology Challenge Enabled the business to develop plans, budgets, Forecasts and analyze operational and financial data in real time using Cognos Enterprise Planning tool V 10.1 Solution: BI + = Worlds 4th Largest Insurance Brokerage Company

22. Consolidation of GL,AP,AR data across the divisions Business Need Integrating Heterogeneous Financial systems across the Globe Technology Challenge Built an integrated financial data warehouse leveraging IBM Cognos Toolset (TM1 / CAFE). And subsequently automating the financial reports using Business Insights / Active reports This include Statutory, Regulatory and Management Reporting. Solution: BI + = $2.5 Billion Chicago Based Company Our Success Stories

23. Consolidating Premiums, Claims, Net posting and Financial data to arrive at the revenue recognition Business Need Build a Data Mart using Legacy systems, financial applications and Transactional systems Technology Challenge Provided enterprise wide data ware housing platform using Hybrid Tools (MSBI for developing ETL and COGNOS for reporting) Solution: BI + = Largest UK Insurance retailer Our Success Stories

24. Insight into project spend to publish project costing (Actual, Budget and Variance) Business Need Information of Projects was stored in multiple systems Viz.. Financial System, PMO System and Sales force tool. Technology Challenge Built data mart using SSIS for sourcing and integrating the data from multiple systems and published the data in the form of dashboard using COGNOS. Solution: BI + = Worlds Leading Banking and Investments products company Our Success Stories

25. Creating a Single Version of Truth Business Need Integrating multiple agency management systems, back office financial systems, HR and payroll system. Technology Challenge Created data ware house to provide comprehensive analytical reporting framework encompassing key performance of the profit centers/business units across the organization. Solution: BI + = Global Risk Management Firm Our Success Stories

26. Next Steps

27. Questions

28. THANK YOU! Laki Ponnam Director -Business Development DW Practice LLC 1(678)999-8203 Email: [email protected] Contact Us for more questions