Veraqor, Inc.

Description Migrating 161 unique Reports of 5 business units from SAP BOBJ to PowerBI with key features and customizations available; Training 500+ Business users on POWERBI; By doing this so the current operating cost and licensing shall be reduced. Challenge ? High Operating Cost of over $20,000 ? Expensive support cost of over ($60,000) including license fee ? IT Dependency Solution ? By introducing self-service BI, business users can develop their reports ? Drill down functionality. ? Minimal upfront cost, as low as $9 per year. ? Optimal performance ? No memory and speed constraints. Read More

Description ? Product Master (MDM) implementation and rollout across 50 countries. ? Product hierarchy management by local business units. ? Sales and Marketing analytics using internal sales and audited sales. • In Market and Market Sales data. • Multi-currency and multi-country implementation. • Geography and Product hierarchies. Challenge Market and To market sales consolidation across affiliates. Solution ? Data warehouse/MDM, Oracle Exadata, Informatica ? Business Objects, Xcelsius Impact ? Data warehouse/MDM, Oracle Exadata, Informatica ? Business Objects, Xcelsius. Read More

Description ? The Streebo team laid the foundation for what is now called the BUE Platform within P&G. ? Architected a federation of data warehouses in a hub and spoke architecture. ? All feeding from the central information repositories – but allowing flexible customization at each instance level. Challenge “Single version of truth” Reporting that satisfies the divisional/local business needs System to allow for management by regional/divisional business users as well as tie in data external to the company – e.g. Nielson for Point of Sale Data Solution ? Kalido DIW/MDM ? TIBCO Spotfir Read More

Description ? To convert this data into actionable insights, Streebo helped integrate it into a third-party analytical system through REST web services. All technologies involved were open source, with the core transformation logic in Java. ? VeraQor Big Data Consultant outlined the integration strategy and a scalable architecture to support the system over predicted future growth. Challenge When a global pharmaceutical, with 40000+ employees worldwide and affiliates companies in 24 countries, undertook a revolutionary initiative to put a chip on a pill, they turned to Streebo to integrate the Big Data that was generated, with a cloud-based analytical tool. Solution ? MongoDB ? Java ? REST APIs Read More

Description ? Data warehouse/MDM, Oracle Exadata, Informatica ? Business Objects, Xcelsius Challenge ? Sales efficiency Analytics (Sales + CRM) Solution ? Master Data Management and Data Warehouse implementation rollout across multiple countries. • Product hierarchy management by local business units. ? Sales analytics using data from Internal Systems and Audited Sales (IMS) • Data handling on Sani-Brick level. • Complex calculations of MAT, YTD, I&C Period, etc. • Analysis of sales at all Sales Organization Levels (MGU, Territory, District, BU, Market Company) ? Territorial and Country level reporting dashboards. ? Sales Force Activity Data from Cegedim’s MI • Complex KPI analysis at all alignment levels. Read More

Description ? Microsoft Azure Data Lake ? Mi Description Crosoft Data Factory ? MicroStrategy (migrated to Microsoft Power BI during 2020) Challenge ? Unstructured data collected from sensors (such as dashboard camara) within the client’s fleet. ? Data being collected from different repositories belonging to different vendors. Solution Our consultants built the solution keeping the following objectives through Big Data Analytics in mind: ? Ensure vehicle safety ? Reduce road-related incidents ? Protecting the driver and encouraging responsible behavior ? Assist risk reduction ? Improve operational efficiency Results ?  7 X reduction in fleet analysis time ? New vehicle movement, event, and potential violation view capture ? Preemptive incident flagging Read More

Description ? Microsoft SSIS engine ? TIBCO Spotfire, Mobile dashboards Challenge The client required a full-scale Data Warehouse and Business Intelligence (BI) solution, to help them establish a single source of truth over data coming in from disparate internal and external systems to evaluate business strategies, and market trends and predict results based on analysis on historical data. Solution ? Designed and implemented a business intelligence solution that allows the customer to perform commercial analytics with little end-user effort. ? Developed complex transformation for data loads, leveraging the inherent capabilities of Microsoft SSIS to implement efficient ETL processes with ease. ? Consolidation of data from disparate sources into the warehouse and exposure as cubes to reporting tools. ? A common Data Model for different interest areas of analysis for the customer ? Flexible reporting environment. Impact ? Microsoft SSIS engine ? TIBCO Spotfire, Mobile dashboards Read More

Description Kalido DIW and MDM, Oracle 11g Asp .NET Challenge Data management to efficiently broadcast appropriate content globally. Solution Master Data Management and Data Warehouse implementation. Implementation of data model. User roles and security management. Development of customized screens based on Asp .NET. Manage program hierarchy and global diversity. Read More