SUMMARY

• SAP Business Objects Developer with over 8+ years of experience in Business Intelligence using SAP Business Objects 4.0, XI - R3.1/R2/6.x with Info view, Web Intelligence, Universe Designer, Desktop Intelligence, Crystal Reports 9/10/XI/2008, Xcelsius 4.5/2008, Dashboards 4.0, Central Management Console (CMC), Central Management Server (CMS), Central Configuration Management (CCM), Query as a Web Service, Live Office, BI Web Services, Query Browser, Publishing Wizard, Import Wizard, Report Conversion Tool and Broadcast Agent
• Implemented two full life cycles implementations for different modules in SAP BI/BW which involves Gap Analysis, Blue Printing, Realization, Production support, Documentation, Requirement analysis,End user Documentation, Data Extraction, Data Modelling, Data loading and Reporting
• Expertise in BW reporting tools,BEx Query Designer,Analyzer and Web Application Designer(WAD)
• Expertise in Creating Users and Groups and setting the rights on them using Central Management Console (CMC). Scheduled Reports in CMC on Daily, Monthly, Weekly basis.
• Actively involved in all phases of the SDLC from Analysis, Design, Development and Implementation, testing to Maintenance for Insurance, Finance, Retail and Health Sciences systems
• Experience in creating Universes from wide variety of databases with measures and dimensions objects, joins, conditions, Filters, LOV, cardinality, Resolving join path problems like Loops and Traps in the universes using Aliases, Contexts, Aggregate Awareness in Business Objects Designer
• Strong SAP Data Migration skills from different legacy systems
• Experience in integrating BODS with SAP ECC and non-SAP data sources (RDBMS) like Teradata, Microsoft SQL Server, and Oracle 11g/10g/9i
• Very good experience of SAP BW Components like Info Cubes, DSO, Multiprovider, Info Source, Info Objects, DSO Objects, & Transformation
• Experienced in developing SAP BW and MSAS OLAP based Universe and WebI documents, and extracting data from SAP using the SAP Integration Kit and MSAS OLAP cubes
• Experience in building Universe against SAP Datasources like Infocubes, Multicube and SAP BI Query
• Designed universes in BO XI and applied row level security at database level, also worked on new features like Index awareness, Derived tables and Central Management Console (CMC)
• Created highly formatted analytic reports, Dashboards out of Crystal reports, WebI and Xcelsius from SAP BI data.
• Used Live Office and QAAWS (Query as a Web Service) and BI Web Services, Query Browser to feed live data into Xcelsius 2008 for dashboard creation
• Expertise in creating reports with features like Drill down, Slice and Dice, Ranking, Alerts, Section and Grouping
• Proven abilities in creating complex reports by linking data from multiple data providers, using free hand SQL, and functionalities like Combined Queries
• Experience working on PL/SQL, and using Stored Procedures in Crystal Reports 2008
• Knowledge in designing and developing Data marts, Data warehouse using multi-dimensional Models such as Snow Flake and Star Schema
• Very strong analytical skills, ability to learn quickly, good understandingof Business Process Management and Business requirements of the customers and translating them to specific Software Requirements
• Good team player with excellent communication and interpersonal skills, good analytical reasoning and high compliance to new technologies and tools

TECHNICAL SKILLS

SAP BI Tools: Information Design tool, Interactive analysis desktop, BI Launch pad, Universe Designer, Web Intelligence, Central Management Console (CMC), CCM, Import Wizard, Life cycle manager (LCM), Crystal Reports, Xcelsius dashboard, Live office, QAAWS, SAP BI/BO Integration,SAP BW, MSAS OLAP cube universe, BEx analyzer and Query Designer.

ETL Tools: SAP Business Objects Data integrator 11.7(ETL) /Data Services 4.0 and Informatica 11.7

Reporting Tools: SAP Business Objects 4.x/ XI 3.1/3.0/R2/6.5, SAP BI BEx Analyzer, Query Designer

Databases: Teradata 14.0/13.1, Oracle 11g/10g/9i, MSSQL Server 2012/2008R2, MySQL 5.1, Siebel

Programming Languages: SQL, T-SQL, PL/SQL, C, C++

Operating Systems: Windows Server 2000/2003/2008/2008 r2, Win XP/Vista/7/8

Other Tools: MS Office 97/2000/XP/ 2003/2007/2010/2013, MS Project 2000/2003/2010, MS Outlook 97/2000/2003/2007/2010

PROFESSIONAL EXPERIENCE

Confidential, Plymouth, MN

SAP BOBJ/BW Developer

Responsibilities:

• Responsible for delivering offshore Status Reports on daily basis & Project Status Reports on monthly basis
• Involved in designing new Project, Connection layer, data foundation layer in IDT
• Involved in creation of reports as per mockup
• Involved in fixing report issues raised by users
• Creation of BO reports through WebI Rich Client and BI Launch pad
• Created complex reports by linking data from multiple data providers, using free hand SQL, and functionalities like Combined Queries and, Merged Dimensions
• Used multi dimensional analysis (Drill Functions) to organize the data along a combination of Dimensions and Drill-down Hierarchies giving the ability to the end-users to view the data from heterogeneous viewpoints
• Handled project responsibility for verifying Project Deliverables against both Technical and Functional Specifications
• Created OLAP Universes on SAP data (Info cubes / BEx queries) and Relational Universes on Non-SAP data using the Information design Tool
• Experienced in handling critical incidents and change requests in SAP BO BI platform tickets

Environment: SAP Business Objects Business Intelligence 4.0/ XI 3.1, SAP BW 7.0 (BEx analyzer, Query designer), Teradata 14.0/13.1, MS SQL Server 2012/2008R2, Windows 7

Confidential, New York

SAP Business Objects Developer

Responsibilities:

• Worked on the Report Conversion project which involved installing the SAP Business Objects 3.1, Web intelligence and Broadcast Agent Server
• Designed complex reports based on discussions with the user groups and created various objects using built-in @functions (like @prompt, @select, @where, and @aggregate), complex SQL queries and joins. Thus Considering best business Practices using Web intelligence Rich Client
• Worked on enhancements/performance improvements for existing Xcelsius Dashboards. Followed Best Principles and made some major workflow changes and successfully reduced Dashboard load time to 15 secs
• Worked on SAP BOBJ EPM, Performance Manager for Dashboard framework
• Built Xcelsius Dashboard Power 2 Learn using Live Office, & QAAWS Using Universe as the Source of data. Used Flash Variables, Extensive Dynamic Visualizations, Chart and Map Drill Downs
• Used Open Docs to allow users to move from the Dashboard to its related detailed Webi report. And also from Webi reports to another reports using hyperlinks
• Used User row level security for data in the Dashboard. Used BO User variables and also Flash variables such as CELogon token to provide Token exchange since dashboard is deployed outside Info view/Launchpad.
• Synchronized reports using data from multiple data providers in Web Intelligence 4.0 by Merged dimensions functionality
• Extensively used calculations, variables, filters, conditions, breaks, sorting, drill down, slice and dice, master/detail, cross tab, charts and alerts for creating Business Objects reports
• Checked the integrity of the Universe schema for any errors in objects, joins, conditions, loops and cardinalities of the Universe which were causing the reports to be partially converted
• Enhanced reports which included standardizing format of report content, redefining query filters and prompts, linking summary report to a set of detail reports
• Used @Functions such as @Prompt to restrict return values and to enter prompt, @Select- to reuse the select statement of another object, @Variable- to restrict the currently logged user etc.,
• Migrated Universes/Reports from Development to Test environment and finally into Production environment after UAT (User Acceptance Testing) using Import Wizard
• Strictly followed the Release Management schedule as per client guidelines
• Scheduled the Web Intelligence reports using the CMC by creating event based triggers

Environment: SAP Business Objects XI R2/3.1/4.0, Xcelsius 2008 SP3, Excel Functions, SAP BI/BW, SAP Net weaver, BEx Designer, WebI, Crystal, Universe, QAAWS, Supervisor, Broadcast Agent

Confidential, Wilmington, DE

SAP BOBJ Developer

Responsibilities:

• Interacted with Business Users and Business Analysts to gather Information to enhance the Universe/Reports accordingly
• Developed the technical specifications based on functional Specs
• Understood the Confidential AS-IS process followed for budget formulation
• Working with different transformations like Query, Key Generation, Pivot, Map operation, Table Comparison in Data Integrator
• Migrated user reports and universes from Business Objects 6.5.4 to Business Objects XI R3
• Managed the BO environment by monitoring/granting permissions and rights to users for viewing, creating and publishing reports and implement Row and object level restrictions
• Implemented Standards and best practices for Business Objects XI R3 environment
• Defined BO XI R3 user security model, users, groups, Universe Security Authentication and Active Directory
• Created and maintained users and user groups to use within multiple Global projects for both application and data level security
• Used Derived Tables, Aggregate Aware, Index Aware, in the Universe using views to meet the Reporting Requirements
• Used WEBI, Reporter and Explorer for querying, reporting and analysis tasks
• Extensively used Calculations, Variables, Breaks, Sorters, Alerts, and Drill Downs for creating Business Objects reports
• Migrated Universes/Reports from Development to Test environment and finally into Production environment after UAT (User Acceptance Testing) using Import Wizard
• Strictly followed the Release Management schedule as per client guidelines
• Scheduled the Web Intelligence/CR reports using the CMC by creating event based triggers
• Worked in collaboration with Project Manager, Business Analyst, Data Analyst, Solution Architect, BI Developer, DBA to deploy the reporting solutions
• Handled Embedded Functions like @Prompt, @Select, @Where in the Designer
• Involved in the designing and building of the Universes, Classes and objects for the client requirements
• Created WebI reports with multiple data providers and synchronized the data using Merge Dimensions option in BO XI R3
• Developed Crystal Reports utilizing existing Business Objects Universes as data provider. Created complex Xcelsius dashboards. Used Crystal Reports XI advanced features like Dynamic and cascading prompts, command objects for building reports
• Created Analytics and Dashboards using Performance Manager to enable executives track progress and compare current and historical performance against established targets
• Created single or multi line chart for showing tendency over a period of time particularly used in revenue history using Xcelsius 2008
• Involved in enhancing the performance of the slow running reports
• Deployed Business Objects Universes and Reports in a Secure Environment from One Server to Other Servers using Import Wizard and BIAR files
• Excellent knowledge in analyzing system needs, discuss desired function with upper management, and successfully interchanged programs to meet the needs of the organization

Environment: SAP BOBJ XIR3(CMC, CMS, CCM, Designer, Desk I, Web Intelligence, Info View, Dashboard Manager, Performance Manager, Import Wizard),Crystal 2008, Business Objects 6.5.4(Supervisor, Designer, Reporter, Web Intelligence), Business Objects 4.0, XML, Broadcast Agent, Crystal Reports Enterprise Edition XI, Crystal Reports 2008, Xcelsius 2008, Oracle 9i/10g, DB2,SQL Server 2005/2008, Teradata 12.0, Windows 2003 Server.

Confidential - Andover, MA

SAP BOBJ/BW Developer

Responsibilities:

• Interacted with Business Users and Business Analysts to gather and document the requirements and translate these to Technical specifications for designing Universes.
• Created several Universes using Designer according to the requirement.
• Updated and maintained existing Universes based on changes in user requirements and changes in data.
• Improved the performance and reduced the coding with the use of @functions ( @select, @prompt, @where).
• Created Several Reports using WebI rich client, Crystal reports on SAP BEx query universe, Xcelsius Dashboards using Live office and QAAWS.
• Used Prompts, Conditions to restrict the data returned by Query and used Filters to restrict the unwanted data from the report.
• Used multi dimensional analysis (Drill Functions) to organize the data along a combination of Dimensions and Drill-down Hierarchies giving the ability to the end-users to view the data from heterogeneous viewpoints.
• Conducted User Acceptance Testing (UAT) on the reports developed and transferred the reports to production environment.
• Involved in Business Objects Support, Problem Solving, Trouble shooting and developing End user Notes.

Environment: SAP Business Objects XI 3.1 (Universe Designer, Web Intelligence, Crystal Reports, Xcelsius 2008, Live Office, QWAAS), Informatica 8.6 and SAP BW 7.0, MS SQL Server 2005.

Confidential, IN

SAP BO/BW Consultant

Responsibilities:

• Interacted with Business Users and Business Analysts to gather and document the requirements and translate these to Technical specifications
• The product data is used in order to work on the sales performance of the respective products
• Extensively worked on Infocube, Write optimized DSO, Standard DSO & Multiprovider
• Created reports in Bex query designer and embedded using data providers in workbooks
• Involved in creating the Webi reports using on top of BW infocubes using BICS
• Created several Universes using Designer according to the requirement
• Created various User defined objects including Dimensional, Detail, and Measure objects and tested them to ensure correct mapping of data
• Improved the performance with the use of @function (@aggregate aware, @select, @prompt, @where)
• Involved in performance tuning and optimization on Business objects Universes by creating Aggregate tables
• Updated and maintained existing Universes based on changing user requirements and based on changes in data source
• Created filter objects, and formatted objects and measures within the universe for faster report generation, created Measure class for measures, and created separate class for conditional objects
• Setting up the security levels to the users in universe module like row level and column level security
• Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, Functions, Cross Tab, Master Detail and Formulas etc.,
• Implemented Dashboard Manager & Performance Manager for dashboards & Scorecards
• Generated Reports from Different Data Providers in Business Objects using Oracle Database
• Developed different types of reports using Desktop Intelligence, Web Intelligence, Crystal Reports and Xcelsius 2008
• Created dashboards using live office connection using Xcelsius 2008
• Documented all the changes made to the Universes and Reports for future references
• Exported the universe to the Repository to make resources available to the users
• Scheduled the universes on daily, monthly and weekly by using Scheduler
• Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/interfaces
• Trained end users to use various functionalities of Business Objects and provided technical support

Environment: SAP Business Objects XI R2 (DeskI, WebI, Designer and Infoview),SAP BW 7.0, Crystal Reports 2008, Xcelsius 2008, Oracle 10g, Windows XP

Confidential, Philadelphia, PA

SAP BOBJ Developer/Analyst

Responsibilities:

• Experience with Installation and Configuration of all Business objects modules
• Created Universes using the Business Objects Designer and connected to the database
• Developed, implemented and maintained Universes using Business Objects Designer
• Used Business Objects 6.5 for developing reports
• Used Business Objects XI for securing the universes and extracting the universes from Metadata
• Responsible for creation of the Universe with Classes, sub classes, Dimension Objects, Measure objects and Condition objects
• Applied Row Level and Object Level securities to restrict sensitive data at designer level
• Resolved loops in universes using Aliases and Contexts
• Set up Aggregate Awareness to enhance the performance of SQL transactions
• Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @Functions, Cross Tab, Master/Detail and Formulas etc.,
• Exported the Business Objects reports to the repository to be viewed by all the users on the intranet and the Internet
• Involved in creating reports on the web using Business Objects and Web Intelligence. Involved in formatting the reports to the user requirements
• Involved in Migration of Business Objects 6.5 content in to Business Objects XIR2 environment
• Created simple and complex reports including dynamic calculations involving Contexts, Queries, Hierarchies, list of values (LOVS), local variables, Alerts, Ranking and multiple data providers
• Used Filters, Sections, Breaks, Sorts, Slice & Dice, Query prompts and Drill filters functionalities in making the reports easy for analysis
• Created reports using Desk I and Web I in BO XIR2 environment
• Developed Full client reports and Web I reports with various complex features and user accounts
• Administer user accounts, implement data security and personalization, and impart necessary features involved in creating reports on the web using Business Objects Web Intelligence training and knowledge transfer to assigned project members
• Scheduled Reports using Crystal Reports and used the Business Objects Server Administration Tool
• Managed the user, groups, repositories and the documents through Supervisor. Actively attended for the meeting in the team management to discuss the views and analysis of the documentation

Environment: Business Objects 6.5/XIR2(CMC/Supervisor, Designer, Desk I, WebI), CCM, Report Conversion Tool, BCA, Performance Manager, Crystal Reports, Teradata SQL Assistant, Oracle SQL Assistant, Windows 2003 Server.

Confidential

SAP BI/Report Developer/Business Analyst

Responsibilities:

• Requirement analysis, including change requests if any in the process flow
• Universe Designing based on requirements
• Building reports as per customer needs
• Design, development and maintenance of the ETL process
• Planning security at Data Level, Row Level, Object Level, Folder Level etc Restrictions on the Application
• Data pertaining to 13 measures related to the Quality, Time and Cost attributes is available to the user
• Hyperlinks to the relevant reports

Environment: SAP Business Objects XI R 2 (Universe Designer, Web Intelligence and Infoview), Data Integrator 11.7, Oracle 10g, SQL developer, Windows XP

Confidential

SAP BI/Business Analyst

Responsibilities:

• Requirement analysis, including change requests if any in the process flow
• Performance tuning and capacity planning
• Universe Designing based on requirements
• Building reports as per customer needs
• Developing Hyperlink reports
• Design, development and maintenance of the ETL process
• Applied row level security on different users
• Developed Web Intelligence reports making use of several Queries (Union, Intersection, Minus)
• Worked extensively with the major functionality of BO like Breaks, sections, Group values, Sorts, List of values (LOV), Pre-defined conditions, Calculations, Alerter and Ranking
• Preparation of Technical Documents

Environment: SAP Business Objects XI R 2 (Universe Designer, Web Intelligence and Infoview), Data Integrator 11.7, Oracle 10g, SQL developer, Windows XP.