Manager Sap
Resume:
MADHUSUDAN RAJU.S
Cell No: +91-800*******
Pass port No: JO677167
Email ID: *********@*****.*** \*********@*****.***
SAP BUSINESS OBJECTS PROFESSIONAL
EXPERIENCE SUMMARY
Over 10 years of total experience in IT Industry
7+ Years of Experience in Telecom Billing Domain
Onsite Transition Expeirence of 12 months
Worked as a Functional Manager\Transition Manager
Functional Experience: worked on BusinessObjects XIR2,XIR3 Enterprise suite Designer, Desktop Intelligence, Web Intelligence reporting, Infoview,CMC knowledge in BO XI R 3.1,SAP BO 4.1,SAP BO 4.2
Strong skills: Business Objects 6.5.1, BO XI R2,& BO XI R3.1,SAP BO 4.1,SAP BO 4.2,Oracle8/9i, SQL.
Billing System: INCA
Knowledge in :BW,SAP LUMIRA
Experience in Data Warehouse and BI technologies - In various phases of development including requirement, analysis, design, development, testing, implementation and post-production support
. Hands-on experience in SDLC entailing activities related to requirements gathering, including planning, design, development, implementation, documentation, prototyping, development, testing, implementation and user training
Created Several Documents for the end users such as Best Practices, Server Sizing standards, Admin Guide, Users Guide, Change Control Management, Report templates and Universe Design Standards Document and also external design, program specifications, Test cases document, Status reports.
Good Interpersonal and analysis abilities, hardworking and result oriented as an individual and in a team
Manger Role Resposibilities
Worked as a Functional Manager\Transition Manager
Experience in Data Warehouse and BI technologies - In various phases of development including requirement, analysis, design, development, testing, implementation and post-production support
ACADEMICS
Bachelor of Engineering in Mechanical Engineering, Osmania University
TECHNICAL EXPERTISE
Skills
Tools
Experience
Datawarehousing
Business objects 6.5.1 & BO XI R2, BO XI R3.1,SAP BO 4.1,SAP BO4.2,WEBI,BOBJ,CRYSTAL REPORTS
120 months
Data base
Oracle 8i/9i
Domain
Telecom-INCA Billing
Operating sysytem
Windows NT/XP/Vista, HP Unix
Knowledge in Report Tools
SAPLumira,BW
WORK EXPERIENCE
Duration
Organization
Designation
May 2007 to June 2017
Tech mahindra ltd
Tech Lead\Tech Manager
June 2017 to Till Date
Datasolutions inc
Free Lancer( Developer)
ACHIEVEMENTS
Rewarded Thrice “PAT ON BACK” certificate for client Appreciation For BO Reports(SLA Reports)
Rewarded Thrice “Star PERFORMER” certificate for client Appreciation on Error free Invoicing
WORK EXPERIENCE
FreeLance Company : Datasolutions inc ( July 2017 –Till Date)
Projects : PMOSS Mobility.(AT & T Subcon)
Environment :,SAP BO 4.2, BI Launchpad & Oracle 10g
Team Strength : 1
Projects : PMOSS Mobility
Objective of this project is to create an interface between PMOSS and the performance management tool – Optima and to generate the reports as per the observed parameters.
Software development: The software product produced under this project will be provided for integration of performance- based alerting from Radio Access Networks (RANs) with performance alert streams from Core Network elements such as routers. Corresponding configuration and topology data will also be shared.
Reports generated will show the correlation of performance impairments manifested separately in the network segments; and will facilitate faster root-cause analysis and reduced mean-time-to-repair. This will also enable improved end-to-end service quality management through the use of predictive analysis; this will allow developing problems to be detected and corrected before they become service-affecting. AT&T Core is deploying this functionality in support 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 Business Objects. This includes change of default error message displayed by Business Objects.
• Establishment of link between Business Objects and any other tool using Java SDK’s .
Company : Tech Mahindra Ltd ( Oct,14-June 2017)
Projects : BASE GNOC Operations
Environment :,SAP BO 4.1, BI Launchpad & Oracle 9i
Team Strength : 4
Project : BASE GNOC Operations Belgium
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
Roles and Responsibles:
Interacted with client to attain good business designs and product reviews.
Developed Daily/weekly/monthly and quarterly Reports such that we make sure business users have the correct data.
Maintained, fixed and resolved the issues when occur during report generation with permanent solutions.
Worked and created with different design layouts like Cross Tab, Vertical, Horizontal and 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.1
Created reports using Business Objects functionalities like Queries, complex queries Filters, Slice and Dice, Drill down, @Functions, @Prompt, @Aggregate awareness, Tracking data changes, Alerts, Multiple data source, Merging dimensions, Drilling reports, Calculation context, hyperlink reports, Cross Tab, Master Detail and Formulas. Developed complex queries using different data providers in the same report
Implemented Security Features of Business Objects like row level, object level and report 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 problems
Hands on experience with Import Wizard, Publishing wizard, Schedule Manager, Instance Manager and Query Builder. Running different kinds of diagnostic tools for troubleshooting
Setting rights and privileges on objects, folders, connections depending upon the requirement. Creating and maintaining different User groups as per the business need.
Clustering of Business Objects servers, Load Balancing, Disaster Recovery Experience.
.
Company : Tech Mahindra Ltd ( May,12 to Oct,14)
Projects : KPN-NL Innovations &Operations
Environment : BOXIR3.1,SAP BO 4.0, Oracle 9i & Unix
Team Strength : 3
Project : KPN-NL Innovations & Operations Netherland
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.
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 sure business users have the correct data.
Maintained, fixed and resolved the issues when occur during report generation with permanent solutions.
Worked and created with different design layouts like Cross Tab, Vertical, Horizontal and Master Detail etc.
Generated and maintain the BO reports (Web Intelligence, Dashboards, Analysis Office and Explorer) and published to SAP Enterprise Portal, FTP server and BO Repository.
Prepared various Technical documents like creation of BO-Universe Fact-Dimension Matrix document, Data Element Sheet, IPS Universe Design document, Universe Dimension and data tables mapping document and updating the Report Functional Specification Document and
Identify 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 Enterprise Portal / SAP BW server.
Implemented Windows AD (Active Directory) authentication for all BO users.
Installed SAP BO 4.0 on Cluster environments for High system availability
Worked 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 BO 4.0
Installed latest and updated patches on BO systems to provide client with more stabilised environment that improved BO operations.
Implemented and installed Mobile BO Server such that all the reports generated is viewable through Mobiles
Raised and Fixed defects with permanent solutions while Testing BO Reports using QC (Quality Centre)
Worked in Ticket solving with in SLA’s (Service Level Agreement)
Involved in creating and updating Operational Manual document
Scheduled and Involved in technical discussion with the team members to find the gap between the business requirement and technical functionality
Provided extensive Support to developers for developing BO Reports also provided in-house training on SAP BO4.0 and BOXI R3.
Company : Tech Mahindra Ltd ( Feb,12 – Apr,12)
Projects : Telecompass MTS(Sistema Shyam Teleservices Ltd)
Environment : BOXIR3.1 (Webi, Deski, Designer), Oracle 9i & Unix
Team Strength : 1
Project :Telecompass MTS(Sistema Shyam Teleservices Ltd)
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.
BO team is responsible for Developing and generating daily Monthly Reports Used /Unused Mobile SIM Report,Zero Usage Mobile SIM,Average Revenue per User report etc.,Scheduling of some Daily, weekly Reports.
Roles & Resposibility:
Involved in Designing the Universe.
Detected cardinalities, loops, and checked the Integrity of Universe.
Created Reports with graphical representation such as Bar charts, pie charts.
Created reports as per user specifications like Slice and Dice, Drill Reports.
Created the reports using scope of analysis.
Created the reports using prompts and filters.
Scheduled the reports using Info view.
Company : Tech Mahindra Ltd ( May’09 – Jan’12)
Projects : IDEA-IOBAS
Environment : Business Objects XI R2, Oracle 9i & Unix
Team Strength : 20
Project:IDEA-IOBAS (Inter Operator Billing and Accounting System)
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 responsible for the following
Managing day-to-day operations: Fetching /Collection of CDR files from over 35 Poi’s (Switches), Regular processing of (Approx 450 million/day CDRs), Time Gap and Record Continuity analysis, Error CDRs extraction and processing remaining data, Streamed Call Volume check, 100% Collection and Processing, Impact Analysis.
Configuration and Troubleshooting: Trunk Groups, Generating reports for Client and MBT on regular updates for the same. Clearing all the wrongly processed data from the system.
Troubleshooting: Finding corrupt records in CDR files, removal, Clearing the system and reprocessing. Wrong Trunk Group configuration and rectification for the same.
System Health: Regular coordination with other support functions within MBT for Database 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 for those issues by coordinating with different teams.
Regular updating IOBAS web portal if any modification / change in the Switch CDR Collection / Processing status, Time Gap, Record Continuity, and Error check and other technical reports about the project.
• Created the reports using Business Objects functionalities like Slice and Dice, Drill down, Cross Tab,
Master/Detail and Formulas etc.
• Designing the Universes, Classes, Objects and integrity Checking
• Developing the reports thru different Data Providers.
• Developed complex queries and sub-queries using different data providers in the same report.
• Created and enhanced reports based upon the requisition. Creating reports using Business Objects
functionalities 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 reports
• Creating 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 Complex Requirements.
• Conducted Data Validation, User Acceptance and Performance testing of Business Objects reports.
• Scheduling the documents for hourly, daily or weekly basis and making available to the clients in BO
Portal.
• Developing the reports in WEBI and placing the reports in Info View
Environment:Business Obects XI R2, Visual Oracle 9i (Using Toad as GUI), HP UNIX, Cute-ftp.
Company : Techmahindra ltd (May ’ 07 – May’09)
Project : Interconnect Billing
Clients : BSNL, BSNL-ILDO
Environment : Business Objects 6.5.1, Oracle 9i
Team Strength :10
The Aim Of This Project to get Interconnect Billing System for BSNL.
Generating month wise invoices to the Other Licenced Operators thru IDEA for both Inward
and Outward Calls.
BO team is responsible for generating Monthly Invoices, ASP Bill Reports,Traffic Reports
etc.,Scheduling of some Daily, weekly Reports, Accounting Reports.
Making all these reports available to the clients thru Web Portal and BO Portal
using facilities Supervisor, Designer, Bo Reporter, WebI, BCA and InfoView from Businessbjects.
The Project refers to get Interconnect Billing System For BSNL-ILDO.Generating month wise invoices to the Other Licenced Operators thru BSNL for both Inward and Outward Calls.
Attending Adhoc CRs,Providing Supplementary Invoices etc. BO team is responsible for
generating Monthly Invoices, Supplementary Invoices,Monthly Reports like TRAI Reports, CGM
IT Reports, ASP Bill Reports, Traffic Reports.
Scheduling of some Daily, weekly Reports and Accounting Reports. Making all these reports available to the clients thru Web Portal and BO Portal using facilities Supervisor, 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 the issues whichare
impacting on finance.
Created the reports using Business Objects functionalities like Slice and Dice, Drill down, Cross
Tab, Master/Detail and Formulas etc.
Developed complex queries and sub-queries using different data providers in the same report.
Created and enhanced reports based upon the requisition. Creating reports using Business
Objects functionalities like Section/ Breaks/ Sorts/ Alerter/ Ranks and many other features.
Creating and modifying complex functions and variables.
Creating 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.
Conducted Data Validation, User Acceptance, Regression and Performance testing of Business
Objects reports.
Contact this candidate