About Us

Client Situation

A leading software company sought our help in supporting their Client’s Oracle Hyperion Services for the applications.

Oracle Hyperion Planning Application PLANT

Oracle Hyperion Essbase Application VFONE, Suppinfo & Analysis

Oracle HFM and FDM Application

It was of paramount importance that all the systems were up and running as the top management of the Client and CFO to seek vital and critical business information from the reports every month-end to make key decisions directly uses the applications.

Experis IT Solution

Experis IT team provided Client with day-to-day maintenance and minor enhancement of the applications defined above, based on the requirement specified. The deliverables comprised of the following:

L1 and L2 support for HFM, Planning, and Essbase Environment

FDM Batch Loader or Execution of FDM Scripts based on location alias

Maintaining and Executing in bound Interfaces to FDM to HFM

Maintaining and Executing Interface HFM to Planning

Maintaining and Executing Interface Planning to HFM

Maintaining and Executing Interface Planning to HSF

User ID Management for FDM, HFM, Planning, Smart View and Financial Reporting

Filter open close in planning

SOP for version copy in planning

Substitute variable updating in planning

Outline change

Two days on site support to Business at corporate office (Mumbai) during submission every month

Execution of Calc script based on service request

Export and Import

MIS

Data Extraction as per business requirement

Cal script batch file preparation and upload

Support calls in Remedy tool

Re-conciliation for Data matching inter applications

Restructuring in Planning, Reporting Applications

Promote to production for Calc scripts, rule files, reports etc in Planning

Lock & send data in Planning, Reporting as required

Data consolidation & scale conversion in planning

The consultants if required will assist the Business Users for HFM UK updates in local HFM and Circle HFM copies – once in a month at Client corporate office in Mumbai

Data clearing and copy based on service request

Load file for enterprise upload based on service request

Filter execution based on service request

Data partitioning in planning as part of pre-approved changes

Substitute variable updating in reporting & planning

Cal script batch file preparation and upload

Smart View, Financial Reporting issues

HFM Metadata extraction and pasting in HFM local replica month on month

HFM-FDM-Financial Application Mapping queries Redressal

Ad-hoc Reporting

Historical Reporting and Data extraction from Essbase

Promoting to production of Updated mappings, HFM rules, FDM rules, Batch Scripts, COA, locations, Form and FR and related metadata month on month

Forms, Data grid, Smart View, Financial Reporting, ICP Data loading issues

Maintenance and Monitoring of HFM, Planning, Essbase Environment Production and Test Servers

Experis IT’s expert team with Hyperion HFM and Essbase consultants along with the BAU team planned the migration activity, showcased the plan to the client and executed to ensure zero business impact and successful completion of migration activity from Essbase to HFM.

Client Benefits

Our expertise in the Hyperion space provided Client with the consulting support in critical migration activity at no extra cost.

Experis IT is serving Client in supporting Oracle Hyperion Services for all these applications with 100% uptime and the following additional benefits:

Developing the strategic planning for BAU activities

Detailed resource utilization report

Cost savings with cross training to resources on HFM, FDM and Essbase

Ad-hoc reporting

Client Situation

A leading Telecom company was facing challenges in managing compliance mandates, competitors, customers, employees, and suppliers. Responding to these challenges calls for a much greater availability of applications in ‘near real time’ and a more streamlined view across the business units.

Experis IT has taken Client Support (BAU – Business As Usual), to provide extended support to Client in resolving issues through ticketing tool (BMC Remedy), Migrations, Monitoring, Alerting, also resolve Level 1 up to level 3 issues and updating any issues encountered within and outside the scope of work with back to back agreed SLA to concerned teams.

Systems to be handled

As part of SDP System, following systems or components need to be managed and are within the scope of this proposal :

AMP (Aepona product / components)

CMS (IMI product / components)

Common Module

UUP

IDAM

And any other component integrate as a part of SDP solution

The key objectives were:

Ongoing maintenance and support services

Code reviews

Design and architecture updates

Upgrades and patches

Service Level Agreement based support services

Support & maintenance of application systems

Experis IT Solution

Ensure subscriber data, files received in SDP components such as Aepona, IMI and other components from all the sources as per agreement and as per timelines defined.

Ensure complete data processing and loading in the SDP System and its components.

Ensure no rejection during processing and loading at SDP and its components.

Ensure all processes running fine and no impact on charging.

Incidents and Ticket Resolution- Ensure to resolve Remedy tickets as per SLA.

24x7 Day to day operations of SDP System - Ensure that all operations of the service run smoothly and as planned to guarantee operational effectiveness.

Monitoring - Routine monitoring of the applications and its internal components.

Quality Checks - Quality Controls, reconciliations and audits etc. to guarantee operational effectiveness.

Job Scheduling - Scheduling and monitoring the scheduled jobs and direct alerting.

Process - Create and Maintain operational documentation and perform activities accordingly.

Reports - Submission of reports as per schedule and Implementation of adhoc reports for users and telecom dashboard for analytics. Carry out reconciliation between SDP and other systems.

Service - Monitor and ensure availability of the service as per agreed SLAs.

Support - User support and User query resolution as per agreed SLA with customer.

Overall Operations - Overall accountable for the effective operation of managed applications.

Perform the quality assurance of operational activities and continuous improvement on all services provided.

System maintenance like space management, archival, backup, performance.

Co-ordination with all cross functional teams for all SDP operations issues.

Files pulling / pushing from external sources or systems like Mediation etc.

Problem and Incident Management - Handle, resolve, control and reduce incidents raised by users.

User Id Management – Create, modify and delete users as per User Id Management process.

Routine Configuration as required in the system.

Back to Back Service Level Agreements (SLAs) will be applicable to Managed Services Team (Supplier).

Daily report: Number of alerts generated.

SDP SNOC monitoring team will share the weekly alerts analysis. Resolver group will share the RCA and plan for reduction of alerts for repeat cases.

Interface with SPOC identified by Customer for quicker resolution.

Track the day to day operational issues related to SDP and work towards resolution.

Interface with Customer IT SPOC for maintenance activities (down times, changes implementation , housekeeping activities like clearing of logs.

Application testing in case of outages, configuration.

Manage Remedy requests.

All SDP related administrative services including change management in accordance with the existing operations manual.

Coordination with Customer SDP SPOC for service request fulfilment.

Incident analysis, change and problem management related to SDP applications.

Call resolution

Root cause analysis for Severity 1 incidences.

Vodafone SDP Partner On-boarding process - Process initially to be managed from Customer location and then Supplier location

Manage charging interface and support.

Aepona Monitization Platform Operations in

Charging API

SMS interface

Location Service Interface

Manage operations of Common Module, Unified User Profile

Monitoring of services and execution of schedule batch jobs

Providing application support for SDP applications

Provide inputs for capacity planning related to SDP application and infrastructure

Monitor vendor applications and coordination for L3 level defects with vendor’s.

Handle operations of SDP software including SDP core engine, Content management system, portal management system and management reporting.

Ensure and adhere to security compliance and SOX compliance as per IBM policy and guidelines

Client Benefits

Our application monitoring services roadmap offers clients a portfolio of services, which target cost reduction and address their business value creation priorities, by:

Understanding business challenges, considering business imperatives and tailoring a custom-made solution using latest technologies.

Developing a strategic roadmap for evolution of applications into robust platforms.

Establishing an ongoing plan and governance process for change management.

Analyzing applications for common patterns.

Identifying application components that can be extended or enhanced as core components

Additional Value Added Scope Supported

Implementation of ad-hoc reports for users.

Supporting business users in decision making with analytics by using Telecom dashboard.

Reconciliation of different systems with different reconciliation points.

Documentation for use in configuration, repair and troubleshooting.

Deployment of all new applications including any bug fixes or configuration changes however roll outs not requiring effort more than a day.

Client Situation

A leading Telecom company was facing challenges in managing compliance mandates, competitors, customers, employees, and suppliers. Responding to these challenges calls for a much greater availability of applications in ‘near real time’ and a more streamlined view across the business units.

Experis IT has taken Client Support (BAU – Business as Usual), to provide extended support to Client in resolving issues through ticketing tool (BMC Remedy), Migrations, Monitoring, Alerting, also resolve Level 1 up to level 3 issues and updating any issues encountered within and outside the scope of work with back to back agreed SLA to concerned teams.

Systems to be handled

As part of TBO System, following systems or components need to be managed and are within the scope of this proposal

The key objectives were:

Ongoing maintenance, monitoring and support services

Code reviews

Design and architecture updates

Upgrades and patches

Service level agreements based support services

Support & maintenance of application systems

Experis IT Solution

Day to day operations of TBO applications. Ensure that all operations of the service run smoothly and as planned to guarantee operational effectiveness.

Monitoring - Routine monitoring of the applications and its internal components.

Quality Checks - Quality Controls, reconciliations and audits etc. to guarantee operational effectiveness.

Job Scheduling - Scheduling and monitoring the scheduled jobs and direct alerting.

Process - create and maintain operational documentation and perform activities accordingly.

Reports - Submission of reports as per schedule and implementation of ad-hoc reports for users and telecom dashboard for analytics.

Service - monitor and ensure availability of the service as per agreed SLAs.

Overall Operations - Overall accountable for the effective operation of managed applications.

Perform the quality assurance of operational activities and continuous improvement on all services provided.

System maintenance such as space management, archival, back-up, performance.

Co-ordination with all cross-functional teams for all operational issues.

User Id Management – Create, modify and delete users as per User Id Management process.

Routine Configuration as required in the system.

Fulfill customer request by creating small reports/enhancements, provide required data/reports.

Support on business user queries, tickets

Strictly adhere to IBM processes and ensure the process compliance for User Id Management, Work Instructions, IBM approved tools usage, Security Compliance, IBM business conduct guidelines.

Communicate with internal teams and business SPOCs for any planned or unplanned downtime.

Perform application testing wherever required before releasing system to users.

As part of Asset Management, keep track of each asset, licenses, notify and ensure to raise requests from concerned Asset Management team.

Follow the Escalation Matrix of IBM as per defined Escalation Process.

Strictly follow IBM security guidelines and ensure security compliance

Implementation of ad-hoc reports for users

Supporting business users in decision-making with analytics by using Telecom dashboard.

Reconciliation of different systems with different reconciliation points

Documentation for use in configuration, repair and troubleshooting

Deployment of all new applications including any bug fixes or configuration changes

Backup/Archiving/Purging coordination

Client Benefits

Our application monitoring services roadmap offers clients a portfolio of services, which target cost reduction and address their business value creation priorities, by:

Understanding business challenges, considering business imperatives and tailoring a custom-made solution using latest technologies

Developing a strategic roadmap for evolution of applications into robust platforms

Establishing an ongoing plan and governance process for change management

Analyzing applications for common patterns

Identifying application components that can be extended or enhanced as core components

Additional Value Added Scope Supported

Implementation of ad-hoc reports for users

Supporting business users in decision making with analytics by using Telecom dashboard

Reconciliation of different systems with different reconciliation points

Documentation for use in configuration, repair and troubleshooting

Deployment of all new applications including any bug fixes or configuration changes however roll outs not requiring effort more than a day

Client Situation

Our client, a world leader in driving license provider had a system in place for student lesson booking. However, it lacked dynamic scheduling capability. ExperisIT was approached to design and develop a solution for them.

Client envisioned developing iPhone application show-casing fitness videos of Denise Austin.

The key challenges included:

Developing a booking engine with dynamic scheduling capability

Assigning location-wise instructor privileges, and

Enabling reporting capability to measure volume of business and instructor performance

Experis Solution

ExperisIT proposed a solution to Client ensuring a new capability to manage its business effectively, greater controls over the franchisees and instructors utilize direct customers relationships to advance with marketing strategies, and establish a framework for future expansions.

Solutions Overview

The application was based on a 3-tier architecture with .NET 3.5 (Visual Studio 2008) used to develop the presentation layer, business layer and data access layer. Web services were used to interface between the presentation layer and business layer. The data was stored in an Oracle 10g database. Custom controls were used to enable reuse of components. The application and database were optimized to enhance performance. AJAX was used to enrich user experience.

The expected business outcomes from this project were:

Customers would be provided with the capability to book, and re-book a driving lesson through four channels:

Online: Through a Safer Driving School Website that will allow self-service bookings, re-bookings, payments and the ability to track individual student’s progress.

Retail: Distribution Channels including IAG Branches, Country Service Centres, which include a number of IAG branches. These retail distribution channels will use the online Safer Driving Website to manage customer registration, bookings and payment.

Client Call Center: Prospects and existing customers will be able to book a driving lesson via telephone with the Client Call Centre. It is expected that the Client CCC will also use the Safer Driving School Website to manage customer registration, bookings and payment.

Instructors: Using technology to allow Client Instructors to make bookings at the conclusion of a driving lesson for existing customers and to possibly enable payments via a PDA tool.

Client Management, Franchisees and Instructors will be able to manage marketing, advertising and administration more effectively.

Achieve ecommerce capabilities to allow immediate purchase of lessons via the online Client Booking System.

Client will be able to capture and store customer information, including non- member data, which will enable the expansion of future marketing opportunities from a single channel to multiple channels.

Achieve improved financial control through a centralised system, enabling all stakeholders the ability to manage bookings and payments, reporting functionality and invoicing solutions.

Achieve operating cost reductions and improved control and efficiency in data management, achieved through termination of the existing relationship between Client and Unity4 who are an external provider.

Achieve a change to operating components so that the mix of fixed costs and variable costs are balanced in a way that unit costs fall as lesson volume increases.

Further, develop Client’s online capability. This will include the ability for Client Management to have the flexibility to develop the website to reflect the change in consumer demands, competitor strategies and franchisee and instructor expectations.

Offer self-manageable tools to the customer with the objective of increasing the average number of lessons attended.

Enable Client Management to have greater control over SDSO.

Client Benefits

Following is a snapshot of the beneficial features of the application:

Separation of business logic from presentation layer and database logic

Adds level of security to the process

Improved user experience

Enhanced performance and reusability