KPN is Ducth Land line and Mobile Telecomunications and IT service providers inNetherland.Transition taken from the client(MINDTREE,ATOS)for the Business objectApplications(BO GNO,BOIP,BONO,BOOTS)Worked as Functional Manager for the Applications.Roles and Responsibles:Interacted with client to attain good business designs and product reviews.Worked with daily/weekly/monthly and quarterly Reports such that we make surebusiness users have the correct data.Maintained, fixed and resolved the issues when occur during report generation withpermanent solutions.Worked and created with different design layouts like Cross Tab, Vertical, Horizontaland Master Detail etc.Generated and maintain the BO reports (Web Intelligence, Dashboards, Analysis Officeand Explorer) and published to SAP Enterprise Portal, FTP server and BO Repository.Prepared various Technical documents like creation of BO-Universe Fact-DimensionMatrix document, Data Element Sheet, IPS Universe Design document, UniverseDimension and data tables mapping document and updating the Report FunctionalSpecification Document andIdentify the functional gaps between interface Applications.Expertise, Administrated and worked on SAP BO 4.0/BOXI R3 Admin.Worked to Established SSO (Single Sign ON) between BO Server and SAP EnterprisePortal / SAP BW server.Implemented Windows AD (Active Directory) authentication for all BO users.Installed SAP BO 4.0 on Cluster environments for High system availabilityWorked on Different tools like Explorer, Information Designer, Promotion manager,Analysis Office and Dashboards.Extensively used upgrade management tool to migrate reports from BOXI R3 to SAP BO4.0Installed latest and updated patches on BO systems to provide client with morestabilised environment that improved BO operations.Implemented and installed Mobile BO Server such that all the reports generated isviewable through MobilesRaised and Fixed defects with permanent solutions while Testing BO Reports using QC(Quality Centre)Worked in Ticket solving with in SLAs (Service Level Agreement)Involved in creating and updating Operational Manual documentScheduled and Involved in technical discussion with the team members to find the gapbetween the business requirement and technical functionalityProvided extensive Support to developers for developing BO Reports also provided in-house training on SAP BO4.0 and BOXI R3.

Client :IDEA 23 circles namely Haryana, Rajasthan, Andhra Pradesh, Kerala, Maharashtra,Madhya Pradesh, Himachal Pradesh, Gujarat, UP East, UP West, Tamilnadu, Punjab,Bihar, Mumbai,Kolkata,Orissa,Nesa,Jammu & Kashmir,NLD and Delhi NTR.Platform : Business Objects 6.5,Oracle 9i (Using Toad as GUI), HP UNIX, Cute-ftp.As Associate Billing (with a team size of 20) of the IDEA-IOBAS Project was responsiblefor the followingManaging day-to-day operations: Fetching /Collection of CDR files from over 35 Pois(Switches), Regular processing of (Approx 450 million/day CDRs), Time Gap and RecordContinuity analysis, Error CDRs extraction and processing remaining data, StreamedCall Volume check, 100% Collection and Processing, Impact Analysis.Configuration and Troubleshooting: Trunk Groups, Generating reports for Client andMBT on regular updates for the same. Clearing all the wrongly processed data from thesystem.Troubleshooting: Finding corrupt records in CDR files, removal, Clearing the systemand reprocessing. Wrong Trunk Group configuration and rectification for the same.System Health: Regular coordination with other support functions within MBT forDatabase Backup, File System Backups to ensure uninterrupted 24X7 working.Roles & Resposibility:As a Team member, am responsible for the following:Interaction with client for all the processing related issues and finding solution forthose issues by coordinating with different teams.Regular updating IOBAS web portal if any modification / change in the Switch CDRCollection / Processing status, Time Gap, Record Continuity, and Error check and othertechnical reports about the project.Created the reports using Business Objects functionalities like Slice and Dice, Drilldown, Cross Tab,Master/Detail and Formulas etc.Designing the Universes, Classes, Objects and integrity CheckingDeveloping the reports thru different Data Providers.Developed complex queries and sub-queries using different data providers in the samereport.Created and enhanced reports based upon the requisition. Creating reports usingBusiness Objectsfunctionalities like Section/ Breaks/ Sorts/ Alerter/ Ranks and many other features.Creating and modifying complex functions and variables.Used sub-queries & FREE Hand SQL in complex reportsCreating Design Documents for all Business Objects reports.Conducted Universe enhancements including building objects/ classes defining joins,creating aliases,defining contexts and troubleshooting traps and loops.Developing the complex queries and Stored Procedures in Oracle for ComplexRequirements.Conducted Data Validation, User Acceptance and Performance testing of BusinessObjects reports.Scheduling the documents for hourly, daily or weekly basis and making available to theclients in BOPortal.Developing the reports in WEBI and placing the reports in Info View

The Aim Of This Project to get Interconnect Billing System for BSNL.Generating month wise invoices to the Other Licenced Operators thru IDEA forboth Inwardand Outward Calls.BO team is responsible for generating Monthly Invoices, ASP Bill Reports,TrafficReportsetc.,Scheduling of some Daily, weekly Reports, Accounting Reports.Making all these reports available to the clients thru Web Portal and BO Portalusing facilities Supervisor, Designer, Bo Reporter, WebI, BCA and InfoView fromBusinessbjects.The Project refers to get Interconnect Billing System For BSNL-ILDO.Generatingmonth wise invoices to the Other Licenced Operators thru BSNL for both Inwardand Outward Calls.Attending Adhoc CRs,Providing Supplementary Invoices etc. BO team is responsible forgenerating Monthly Invoices, Supplementary Invoices,Monthly Reports likeTRAI Reports, CGMIT Reports, ASP Bill Reports, Traffic Reports.Scheduling of some Daily, weekly Reports and Accounting Reports. Making allthese reports available to the clients thru Web Portal and BO Portal using facilitiesSupervisor, Designer, Bo Reporter, WebI, BCA and InfoView from Business Objects.Roles & Resposibility:As a Developer, am responsible for the following:Generating AspBills and monthly invoices and client interaction & resolving theissues whichareimpacting on finance.Created the reports using Business Objects functionalities like Slice and Dice, Drilldown, CrossTab, Master/Detail and Formulas etc.Developed complex queries and sub-queries using different data providers in thesame report.Created and enhanced reports based upon the requisition. Creating reports usingBusinessObjects functionalities like Section/ Breaks/ Sorts/ Alerter/ Ranks and many otherfeatures.Creating and modifying complex functions and variables.Creating Design Documents for all Business Objects reports.Conducted Universe enhancements including building objects/ classes definingjoins, creatingaliase

BASE-GNOC Belgium Land line and Mobile Telecomunications and IT service providers in Belgium. MXPD Datasource is a Ticketing database Reports were developed SAPBO BI Launchpad 4.1

KPN is Ducth Land line and Mobile Telecomunications and IT service providers in Netherland.Transition taken from the client(MINDTREE,ATOS)for the Business object Applications(BO GNO,BOIP,BONO,BOOTS)

Worked as Functional Manager for the Applications.

Aim of the project to get customers who are not using the MTS service and used MTS service,Under MIS Activities

1. Zero Usage Mobile SIM(Zero usages report is used to find prepaid Individual mobile SIM customers

who are not using MTS network in any form.

(Zero usages report is used to find out customers/mobile users who are not using their mobile numbers.)

2.Reconciliation of Zero Usage

3.ARPU Report Mobile SIM

Average Revenue per User report contains revenue generated for customer (mobile SIM and individual category)

from voice, SMS, VAS, Roaming and Data usage done per day but cumulated monthly.

IDEA 23 circles namely Haryana, Rajasthan, Andhra Pradesh, Kerala, Maharashtra, Madhya Pradesh, Himachal Pradesh, Gujarat, UP East, UP West, Tamilnadu, Punjab, Bihar, Mumbai,Kolkata,Orissa,Nesa,Jammu & Kashmir,NLD and Delhi NTR.

Objective of this project is to create an interface between PMOSS and the performancemanagement tool – Optima and to generate the reports as per the observed parameters.Software development: The software product produced under this project will be provided forintegration of performance- based alerting from Radio Access Networks (RANs) withperformance alert streams from Core Network elements such as routers. Correspondingconfiguration and topology data will also be shared.Reports generated will show the correlation of performance impairments manifestedseparately in the network segments; and will facilitate faster root-cause analysis and reducedmean-time-to-repair. This will also enable improved end-to-end service quality managementthrough the use of predictive analysis; this will allow developing problems to be detected andcorrected before they become service-affecting. AT&T Core is deploying this functionality insupport of the Mobility network.Creation of Business Objects Universe for report development.Development of reports (webi, deski or crystal) as per user specification.Responsible for writing or modifying any code related to internal working of BusinessObjects. This includes change of default error message displayed by Business Objects.Establishment of link between Business Objects and any other tool using Java SDKsand open documents.

BASE-GNOC Belgium Land line and Mobile Telecomunications and IT service providers inBelgium. MXPD Datasource is a Ticketing database Reports were developed SAPBO BILaunchpad 4.1Roles and Responsibles:Interacted with client to attain good business designs and product reviews.Developed Daily/weekly/monthly and quarterly Reports such that we make surebusiness users have the correct data.Maintained, fixed and resolved the issues when occur during report generation withpermanent solutions.Worked and created with different design layouts like Cross Tab, Vertical, Horizontaland Master Detail etc.Developed and scheduled the reports on daily , weekly and monthly Basis.Developed the BO Reports using of SAP BO BI Launchpad 4.1Created reports using Business Objects functionalities like Queries, complex queriesFilters, Slice and Dice, Drill down, @Functions, @Prompt, @Aggregate awareness,Tracking data changes, Alerts, Multiple data source, Merging dimensions, Drillingreports, Calculation context, hyperlink reports, Cross Tab, Master Detail and Formulas.Developed complex queries using different data providers in the same reportImplemented Security Features of Business Objects like row level, object level andreport level to make the data secure.Dealing with WEBI and CR reports. Rectifying all the issues related with scheduling,connection, Server failures, CR viewer problems, Database connectivity problemsHands on experience with Import Wizard, Publishing wizard, Schedule Manager,Instance Manager and Query Builder. Running different kinds of diagnostic tools fortroubleshootingSetting rights and privileges on objects, folders, connections depending upon therequirement. Creating and maintaining different User groups as per the business need.Clustering of Business Objects servers, Load Balancing, Disaster Recovery Experience.