Transcript Leading Energy Producer & distributor, USA

Leading HealthCare Data Provider, USA IMS
Consolidated
Business Situation
Enable Sales Force Effectiveness standardization and rollout
across countries
Integration of the SAP financials, PeopleSoft HRMS, Budgeting
& Planning Hyperion reporting system
Scale up the consulting division
Improvise the customer services through 24X7 support of
customer requirements
Building integrated data repository of drug distribution and
prescriber data
Services Delivered
Managing multiple applications across the business area of
consulting , customer system support, partner implementation
and internal systems support
Business Benefits
Significant increase in the productivity improvement on Y-o-Y basis
where the same system with minimal change can be used to add data
for new source systems, countries and markets.
Centralized focus on Global MIS by capturing information from
Operational Data sources like SAP and CRM (SalesForce. Com)
Decrease in the number of errors that would occur during the manual
process of preparing the data
Increase in the efficiency of data provided to the MIS team
Increase in the level of detail provided to the users of commercial
reports by designing reports specific to each Profit Center with all the
required metrics.
Commercial Reports will now be made available to the Client
Management reflecting global revenue on a D-o-D basis instead of
the prior weekly basis.
Technology
Platform : Unix, Mainframe, Windows
System support and maintenance of Centralized global data
warehouse for financial information. Over 200 ETL Mappings,
MRA (Management Reporting & Analysis) Cubes, CEP
(Consulting Engagement & Profitability) Cubes and 100+
Financial reports
Extended Consulting team for data analysis
Reporting Tools – Hyperion Suite, Custom Web Applications,
Excel, SAS, MicroStrategy, SSRS, SSAS, Share Point services
Databases – Oracle, Essbase, SQL Server, Nettezza, VSAM,
DB2
ETL Tools : Informatica, SSIS,SAS
Applications: SAP Financials, PeopleSoft HRMS, SFDC
Delivery of custom market share reports on prescriber data
Statistics
Market specific Brand Diagnostics reporting
Team Size : 140
Multi-Language (East Asian Language) data handling
capabilities
Total Systems/Applications : 30+
Application Spread : 51+ countries
Supporting 10 leading healthcare manufacturers data analysis
requirements