SUMMARY:

• Having 4+ years of work experience as a SAP BI/BO Consultant.
• Extensive experience on SAP Business Objects XI R3 and Knowledge on XI R4(Arora)
• Strong knowledge on BO tools like Design Universes, WEBI Reports, Xcelsius (Live Office and QAAWS) and Crystal Reports.
• Strong understanding of Business Information Warehouse like Info cubes, ODS objects, Characteristics, key Figures and Multi providers.
• Involved in Production, Enhancement Projects for SAP BI/BO and Implementation project for developing reports in SAP BO.
• Self-Starter with drive, Initiative and a positive attitude and able to deliver results even under pressure.
• Experienced in Migrating reporting from BOXI R2 to BOXI R3
• Knowledge in installation of SAP Integration with BO desktop and server products
• Strong Understanding on Crystal Reports, Xcelsius, Live Office and Performance Manager
• By Using HANA STUDIO Creating Attribute Views, Analytical Views, Calculation Views(Graphical, Script)
• Creating Batch Jobs on BODS and transfer data to HANA DATABASE.
• Have knowledge on SLT to pull the data from SAP systems and Non-SAP systems
• Creating Reports Xcelsius, Crystal Reports, WEBI on HANA DATABASE (BO XI 4.0)

SKILL SET:

Business Intelligence: Business Objects XI R3 /R4, Central Management Console, Central Configuration Manager, Web / Desktop / OLAP Intelligence, SAP BEX, Designer, Dashboard Manager, Crystal Reports Server XI, Crystal Xcelsius 2008/4.5,Import Wizard, Publishing Wizard.
Data Modeling : Star-Schema on Master Tables and Transaction Tables
DBMS : Oracle 9i, 10g
Environments : Windows NT/XP/2003/2000
HANA : HANA 1.X, HANA DATABASE.
Industry Application : Banking and Finance, Healthcare, Retail, Manufacturing and Logistics

• Master of Computer Application(MCA)

Working as a BO Consultant Confidential,
Worked as a BO Consultant Confidential,

PROFESSIONAL EXPERIENCE:

Project #1- Mutual Fund System
Confidential,
NJ Mar 2011 –Till Date Role: Business Object Developer

Environment: Designer, Web Intelligence XI R3, Xcelsius, Dashboards, Data Marts, SQL, Windows 2000 Server.

Description:
This Project has been developed for investment management system of Citibank, which is one of the largest savings and financial banks in New York. We generated reports that helped analyze how the customers are investing in mutual funds, trade stocks, bonds and mortgages by business users. The project involved development of various complex, Ad-hoc and canned reports. Large manipulations were done to generate reports that could help the managers to analyze and improve the performance of company in the weaker areas and increase customer base
Responsibilities:

• Developed universes by using Universe Designer Tool, Developed the General systems Universe (Non-SAP Universe) by using secured connection.
• 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
• Analyzed the business logic built into the warehouse and also gathered user requirements for the reporting work
• Created Classes (Sub classes), Objects, Prompts and Predefined conditions and user defined objects and custom Hierarchies for drill down purposes
• Work with the onsite team to meet the specified project deadlines. Work in unison during product development
• Tested Universe and Reports, which includes
• Database connectivity
• Resolved loops and contexts to ensure the correct results from the query
• Objects in the universe, to ensure the correct mapping of the objects
• Aggregate awareness to ensure the query is pulling correct level of aggregation
• Verified the data by running the SQL against the database
• Designed and Developed WebI Reports using the features like Charts, Cross Tabs, Drill Down, Drill Up, @Functions and Formulas to analyze the data
• Created user Prompts, Conditions and Filters for various reports to specify the reporting parameters

Project #2– Dealer Oracle Conversion (DOC)
Confidential,
TX Dec 2009- Mar 2011
Role: Business Object Developer

Environment: Business Objects XI R2/R3 (CCM, CMC, Designer, Web Intelligence, Desktop Intelligence),Crystal Reports, SQL, Windows XP.

Description:

It is next generation of AT&T’s dealer ordering process and applications. The Singular dealer portal allows a dealer to purchase AT&T products online. The business analysis phase captured the requirements for the different tender types of payments including credit cards. It is converted from legacy systems to oracle. The Existing system will support Order Status, iStore, Rebate, Gross Revenue Information
Responsibilities:

• Designed universes and applied row level and objects level restrictions to different groups and users as required
• Interacted with Oracle App’s team members to understand the BRD’s and convert them to tangible Technical spec’s to be used in report specifications
• Coordinating with onsite team to update the business requirements. Work hand-hand during the entire product development
• Embedded reports directly into developed web applications and thick client report generation
• Worked extensively on creating Universe’s for Order Management, Accounts Payable, Invoice and Account Receivable Data Marts
• 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
• 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 equi joins as per requirement
• Used Dashboard Manager to build Dashboards and deploy them across the organization to monitor business performance
• Attended Business meetings and assisted Business Analysts in gathering requirements, discussed the conversion work reviews and Auditing follow-ups
• Documented requirements and performed Gap analysis to identify the gaps
• Data modeled part of the warehouse tables and was part of the team in designing the final conceptual, logical, physical model.

Project #3- BLUESERVEBCBSA May 2008-Dec 2009
Confidential,
Role: Business Object Developer

Environment: BO XI R3 (CMC, CCM, CMS, Designer, Info View, WEBI), Xcelsius 2008, Oracle 9i, Windows 2000/XP.

Description:
BLUESERVEBCBSA collects and maintains BCBS Plans survey data responses, as well as develops and maintains valuable resources that enable BCBS Plans and their customers access to the information that support Plan marketing activities. The current BlueServ application is a combination of a web front-end tool used for accepting survey responses and analyzing data and a desktop client application called Marketing Services Data Administration (MSDA). The future BlueServ application will provide enhanced functionality in a web-based application that is accessible from any computer using a web browser. Blue2 BCBSA’s web-application built for real-time transmission of transactions, so you can better handle inter-Plan claims exceptions management. Using Blue2, you can manage claims inventory, request a claim status, view claim formats, request medical attachments, and send electronic attachments. Blue2 streamlines the processing of inter-Plan business

Responsibilities:

• 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 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
• Mocking up the data considering security and confidential data. Thorough Documentation of all the Reports with Report definition, field definitions and layouts
• Created Crystal Reports Templates to support Corporation Report Standards and color scheme
• Used Dashboard Manager to build Dashboards and deploy them across the organization to monitor business performance
• Created interactive Dashboards and Business Presentations by importing data from Excel sheets using Crystal Xcelsius
• Development confirmation with users and modification if required accordingly