SAP BO CONSULTANT
RAMESH
E-mail: *******.****@*****.***
Mobile: +91-996*******
PROFESSIONAL SUMMARY :
• Having 3+ years of experience in IT and 3.4 years of experience in BO Design,
Development, Data Warehousing, documentation and implementation in BOBJ.
• Experience in IT industry with strong knowledge in all phases of Software
Development life Cycle (SDLC) such as report developments, scripting and testing with all security managements.
• Worked on Business Objects XI 3.1 Integration with SAP BI and SAP R/3.
• Experience in Crystal Reports 2008 with Universe for dashboard designing
• Expertise in Business Objects WebI, Deski, Designer, Crystal Xcelsius 2008,Crystal Reports2008
• Expert in Xcelsius Dashboard designing using Xcelsius 2008 Client tool
• Developed interactive dashboards and data presentations from Excel spreadsheets and other data sources using Xcelsius 2008
• Created Xcelsious Dashborads using LIVE OFFICE Connections and QAAWS Connections
• Created interactive graphs & Dynamic Charts in Xcelsius Designed, developed and tested the reports based upon data generated by enterprise
• Implementation and design of Crystal Reports XIR2 & Crystal Xcelsius (Business Objects) reports and dashboards for customers.
• Web Reports were created and deployed through Infoview
• Knowledge on CMC, CMS and CCM.
• Knowledge on Creating BEx Queries.
• Good team player with reputation of Integrity and an ability to work on multiple platforms and a quick learner.
Education Qualification:
• Bachelor of Science (MPC) in 2007 from Kakathiya University, Warangal, A.P.
Professional Experience:
• Working as a BO Developer in IntellSys Software Solutions, Bangalore from June 2010 –till the date
• Worked as BO Developer in Future Focus Infotech Pvt. Ltd Bangalore. from July 2008-May-2010
Technical Expertise
Reports : Universe Designer, Desktop intelligence, Web intelligence Rich Client,
Live Office, Crystal reports 2008 with Universe, CMC, Info View,
Xcelsius 2008, BOXI-3.1,SAP BI,BOXI 3.0, and BOXI-R2.
Languages : SQL
RDBMS : Oracle 9i and 10g.
Operating Systems : Windows 2003 server, Windows 95 98 2000 XP, 7.
SAP BI/BW : BEX Query / Info Provider(ETL & Modeling).
Projects
1. Project Details
Title : Analysis of Sales Reports.
Client : Dell
Type : Development, On-going Maintenance, Enhancements and Support.
Software : Business Objects XI3.1, SAP R/3, Web Intelligence, Live
Office, QaaWS, SAP GUI and Windows XP.
Role : SAP Business Objects Developer
Description:
The company currently sells personal computers, servers, data storage devices, network switches, software, computer peripherals and televisions. All the data has been captured in the reports. This project is to perform sales analysis at Dell. There are 14 Reports and 2 dashboards which were created by Crystal Xcelsius. It is real time data warehouse. Weekly report scheduling has been done. Informatica8 has been used as an ETL Tool to extract data from Oracle Database.
Responsibilities:
• Created Reports Using Web Intelligence.
• Used filters and conditions in reports.
• Used Context Analysis in the reports which give opportunity to End users to drill down the data.
• Used merged dimensions in the report.
• Tested and analyzed the report.
• Followed the best practices in generation of the reports.
• Used functions in the reports.
• Used Open Document functionality to link reports.
Responsibilities:
• Worked with QAAWS (Query as a Web Service) to access data from the Universe.
• Analyze business requirements and use Business Objects Xcelsius Enterprise to create visualizations to meet those requirements.
• Developed visualizations of complex data using charts, single value components, selectors, and other components
• Add custom formatting, graphics, and animations
Publish models in multiple formats
Set up drill down functionality, alerts, and dynamic visibility to create interactive visualizations
Analyze business requirements and use Business Objects Xcelsius Enterprise to create visualizations to meet those requirements.
2. Project Details
Title : Analysis of Sales Reports.
Client : Nikon Pharmaceuticals Ltd
Type : Development, On-going Maintenance, Enhancements and Support.
Software : Business Objects XI3.1, SAP R/3, Web Intelligence, Live
Office, QaaWS, SAP GUI and Windows XP.
Role : SAP Business Objects Developer
Description:
Nikon Pharmaceuticals is one of the biggest pharmacy companies in India. In this project reporting was done on a warehouse created using Informatica. Reporting was done on three modules stock, purchases and sales. The reports created were daily and weekly sales reports, sales per retailer, purchase details reports and stock reports for every type of products etc.
Responsibilities:
Involved in Analysis, Design, Testing, Development, and Maintenance
of the Universe.
Developed and created classes with dimensions, details and measure
object and specified hierarchies.
Involved in creation of various reports like cross-tab, master/detail reports according to the client requirement.
Creating filters and alerters.
Reporter Operations such as Sum and Average, Intersection, etc.,
Extensively used calculations, sorting, rank, drill down, drill thru, slice and dice, formatting, and used prompts for creating BO reports.
3. Project Details:
Title : Telegence Billing System
Industry Telecommunications
Client : Dish Network
Type : Development, On-going Maintenance, Enhancements and Support.
Software : Business Objects XI3.1, SAP R/3, Web Intelligence
Role :Team Member.
Project Description:
Dish network has developed TBS. TBS stands for Telegence Billing System. TBS is used to manage the billing task of entire telegance system. That enables Growth Markets to perform what-if analyses and better service its customers with more precise information. In just two months, we enabled the client to organize its sales force around its customers as desired, as opposed to around its products; sales reps can now focus on the best prospects and offer favorable terms to key customers. In the long-term, the client can also add third party competitive information to further attack the multi-billion dollar communications market.
Responsibilities:
• Understanding the existing universes and reports for enhancement.
• Enhanced the existing Universe and added the new tables and classes and objects as per the business.
• Worked on BO Support for L1, L2.
• Enhanced the reports as per the business by adding calculated measures, dimensions and functions.
• Created daily, weekly and quarterly reports for the management team and field operation Managers using Business Objects reports.
Extensively used calculations, Sorting, Rank, Drill down, Drill thru, Formatting, Changing Displays and Prompts for BO Reports