arvind singha, SAP BO Developer

arvind singha

SAP BO Developer

SABA software

Location
India - Hyderabad
Education
High school or equivalent, Engineering
Experience
16 years, 6 Months

Share My Profile

Block User


Work Experience

Total years of experience :16 years, 6 Months

SAP BO Developer at SABA software
  • India
  • My current job since December 2011

• Developed universes, reports using Designer, Web Intelligence and Desktop Intelligence. Created metrics and dashboards using Application Foundation.
• Exported the universes to the Repository to make resources available to the users. Created reports for various Portfolios using the Universes as the main data Providers.
• Handled all the change requests to the existing universes requested by reporting team.
• Worked towards optimal development of universes by removing loops through the use of aliases and contexts, Creating Universe with number of Classes, many objects, Derived Tables using inner/outer and equiv. joins as per requirement.
• Resolved Chasm &Fan traps and resolved loops using aliases, Contexts, shortcut joins
• Used Dashboard Manager to build Dashboards and deploy them across the organization to monitor business performance.
• Created Classes (Sub classes), Objects, Prompts and Predefined conditions and user defined objects and custom Hierarchies for drill down purposes
• Used @Functions like @Prompt (for user defined queries), @Where (for creating conditional filters), and @Select to create duplicate objects in the process of building the Universes.
• Analyzed the business logic built into the warehouse and also gathered user requirements for the reporting work.
• Extensively used custom list of values (LOV) and hierarchies etc to make the universes more efficient.
• Use of various reporting functionalities like Drill, Filters, Alerter, Formulas, Variables, Multi Data Providers, Ranking, Merging, Sections, Query Panel, Report Panel, Formatting etc.
• Mocking up the data considering security and confidential data. Thorough Documentation of all the Reports with Report definition, field definitions and layouts.
• Attended Business meetings and assisted Business Analysts in gathering requirements, discussed the conversion work reviews and Auditing follow-ups

SAP BO Developer at desigual
  • India
  • October 2010 to November 2011

• Interacted with Users and Business Analysts to understand and document the requirements and translate these to technical specifications for designing Universes and Business Object Reports.
• Designed and implemented Data Models to meet existing and future anticipated reporting requirements
• Designed Universes using BO XI R2 designer by retrieving data from database, using Derived tables, defining the necessary connections and exported them to specific universe domains
• Extensively worked with Web Intelligence XI R2 and Info View to create thin client reports based on the business requirements
• Designed and Developed WebI Reports as per the Users Requirements using the features in Business Objects including: Master/Detail, Charts, Cross Tabs, Slice and Dice, Drill Down, @Functions and Formulae to analyze the data
• Created user Prompts, Conditions and Filters for various reports to specify the reporting parameters as per the business rules and requirements of the end users
• Created Crystal Reports Templates to support Corporation Report Standards and color scheme
• Created interactive Dashboards and Business Presentations by importing data from Excel sheets using Crystal Xcelsius.
• One of the Core parts of Project’s Crystal Reports enhancements and migration to BOE.
• Used Derived tables to create the universe for best performance.
• Created Dashboards for Top management using Xcelsius 2008 using Live Office and QAAWS.
• Generated Reports using the Universe as the main Data provider and also using the personal data files provided by the users.
• Developed critical reports like drill down, Slice and Dice, master/detail for analysis of parts benefits and headcount.
• Created complicated reports including sub-reports, graphical reports, formula base and well-formatted reports according user requirements.
• Designed exceptional reports with “Alerter".
• Involved in creating Dynamic & Static crystal Xcelsius dashboards, crystal reports, Web intelligence reports, Rich Client reports with various Data sources

process Developer at hsbc-hdpi
  • India - Hyderabad
  • December 2007 to October 2010

• Maintaining the Service Quality Customer Service Standards Library for the department.
• Handling and swiftly resolving customer complaints in a professional and effective manner.
• Maximizing every sales opportunity by promoting the highest standards of customer care and recognizing potential development and training opportunities.
• Meeting the Monthly sales targets through Self-Motivation and determination.
• Reporting to the higher Management primarily responsible for the internal and external customers.
• Providing Classroom session to deliver the product knowledge.
• Supervising, motivating and developing team reward and recognition programmers.
• Coordinating with the trainees to ensure that the customer requirements are not accommodated but surpassed.
Roles:
• Customer Credit card analysis and Finance Queries Management.
• Credit card Disputes Management and Resolving function.
• Credit card Fraud charges identification and Resolving function.
• Credit Card interest rate calculation and rollout functions.
• Provided a single point for customer service for all products and services.
• Maximized product sales to agreed targets by probing customer needs and actively cross.
• Effectively cross selling various products to meet & exceed HSBC cross selling ratio's target.
• Handled general customer queries and redirecting them as appropriate to other staff.
• Provided feedback either personal through working environment experience or through an impression reflected from customers to the related departments to help improve our products and services in the way they should really be.
• Identified and followed upon sales opportunities based on potential customer lists

Education

High school or equivalent, Engineering
  • at B-Tech Computer Science
  • January 2007

Degree and Date Institute Major and Specialization Engineering 2007 Gandhi Institute Of B-Tech Computer Science Technology And Engineering Management

Specialties & Skills

Web Intelligence
Crystal Reports
Dashboards
Business Development
CREDIT CARD
CRYSTAL REPORTS
CUSTOMER SERVICE
FINANCE
MONTHLY SALES
PRODUCT SALES

Languages

English
Expert