• Over 8 Years experience in Information Technology using Business Intelligence Tools, Business Objects BOBJ Tools in various versions- BI4 BOBJ 4 BO XI 3.1/R2/R1/ 6.5.1/ 5.1, SAP BW on Windows and UNIX Environments.
• Experienced in Development, Implementation, Testing and support for various data warehousing applications using SAP Business Objects XI 4.0/3.1/R2/6.5 with experience in CMC, CCM InfoView, BI Launch Pad IDT Information Design Tool IDT Desktop Intelligence, Web Intelligence, Import Wizard, Upgrade Management Tool, UMT and Dashboard Tools Xcelsius and QlikView and Tableau.
• Developed WEBI report/dashboards/Universes using IDT in BI4 Environment.
• Developed WEBI BOBJ 3.1 using advanced features including Hyperlinks, Delegate Search, Data Tracking, Input Controls and Merge Dimensions.
• Experienced in developing complex reports using Business Objects WebI Rich Client Crystal Reports
• Experienced in complete deployment Installation, Upgrading, Configuration and Administration of Business Objects versions: BOXI 4.0, XI 3.1, XI R2.
• Enterprise having Parameter/Formula Fields and Selection Formulas, Grouping and Sub reports.
• Tuned and Enhanced Universes with SQL Queries for the Report Performance.
• Created Web Intelligence Ad-hoc and canned reports.
• Experienced in web publishing and scheduling, Report Bursting using Broadcast Agent or Publishing wizard.
• Experience in Building Dashboards for Visual Representation of Data using Crystal Xcelsius 2008 SP3/4.5 using Qaaws, Live Office, XML, Flash variables and SAP BW Net weaver as Source connections.
• Developed flexible queries using filters, navigational attributes in BEx Analyzer to facilitate data analysis in a drill down or summarized way to give detailed levels of information.
• Experienced in creating OLAP Universe using Universe Design Tool based on BEx Queries, BICS connections using Information Design Tool IDT and created Web Intelligence, Advanced Analysis for Web and Crystal Reports on top of them.
• Installed Business Content including DataSources, InfoSources, InfoCubes, ODS objects, Update Rules and Queries.
• Installed Crystal Xcelsius 2008 SP3 and developed dashboards using various components and developed Xcelsius 2008 Dashboards on top of Qaaws and Live Office connections.
• Implemented Open Doc to drill down to detail WebI report from Xcelsius Dashboard.
• Experience in developing static and dynamic dashboards using QlikView and Tableau.
• Defined Security Users/Groups/Folders based on Business Model
• Strong Knowledge in SAP Integration with BOBJ with HANA
• Experienced in Production Support role 24/7 to resolve the issues using a trouble ticket system
• Created Universes using complex and advanced features from various Database sources including Oracle, SQL Server, DB2, Teradata, Sybase and SAS.
• Efficiently mapped business requirements and processes to technical solutions.
• Expertise in designing Universes for Performance Management and Reporting needs.
• Experienced in developing Web Intelligence, Desktop Intelligence and Crystal Reports using different Data Sources.
• Expertise in dimensional data modeling, Star Schema Modeling, fact and dimensional table design, physical and logical data modeling.
• Demonstrated excellent interpersonal skills and communication skills during identification of user requirements.
• Capable of working in a team or individually, self-motivated with good problem solving skills.
• Team-Oriented and focused on delivering exactly what the client needs to succeed in a timely manner, with amazing communication skills.

Confidential

SAP Business Objects Developer

Responsibilities:

• Performed an initial study of the current reporting application, to finalize the data elements required for reporting.
• Interaction with users management, performance of analysis, designing, coding, testing implementation.
• Involved in understanding the end-user requirements and business processes in creating and designing universes, queries and reports.
• Extensively worked with BOXI 4.1 for creating complicated reports including sub-reports, parameter based reports, graphical reports, formula based, well-formatted reports, drilling reports, analysis data reports along with LOV.
• Designed Universes using IDT , incorporating all the business requirements.
• Implemented object level security universe to incorporate security for sensitive information.
• Worked in migration of universe and reports between environments.
• Designed universes, solved loops by creating aliases, contexts and resolved traps.
• Created complex variables, breaks, sorts, filter and conditions for various reports.
• Created complex reports involving master/detail and cross-tab and Combined queries and sub-queries
• Linked multiple data-providers and Used calculation contexts/extended contexts
• Created multiple contexts for catering different functional areas in a single user query.
• Used Aggregate awareness function of Business Objects to route the query objects through the appropriate path while selecting from multiple contexts..
• Used prompts in the reporter as well as in the universe to create more interactive reports for running different kind of campaigns.
• Extensively used scheduler for report scheduling and deployment
• Generated various report templates for standardizing the reports throughout the organization.
• Involved in end user training and documenting the procedures.
• Involved in developing the financial reports for the Financial services Dept and successfully published the highly formatted reports
• Scheduled pre-canned reports through Scheduler for distribution and printing.
• and met with the end user requirements
• Resolved Year Ago Variance Calculation, Percentage Calculation in Cross Tab in Web I XI R2.

Environment: Business Objects XI4.0, Lunch Pad IDT, Xcelsius 2008 Oracle 9i, HP Quality Center 9.2, Windows NT

Confidential

SAP BI/BO Developer.

Responsibilities:

• Interacted with clients and assisted in business requirements gathering, including working with end users to interpret functional requirements into report specifications.
• Participated in project planning sessions with project managers, business analysts and team members to analyze business report requirements and provided Several Report Mock-ups to finalize the requirements.
• Converted business requirements BTRD to TDD technical requirement documents.
• Build the new universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections.
• Used designer Information Design Tool IDT to create Universes and resolve Join Path Problems utilizing contexts and Alias tables.
• Created linked universes and developed Complex reports that involved multiple data providers, Master/Detail charts, cross tab charts and complex variables and calculation contexts.
• Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.
• Migrated universes and reports from SIT/UAT to production using Upgrade Management Tool.
• Maintaining Universes and Reports to multiple Environments Dev, Test, and Prod and Promoted the tested content form Development to IT, QA and Production using Life-Cycle Manager.
• Extensively worked with BOXIR4 and BOXI 3.1 for creating complicated reports using LaunchPad and Web Inteligence including sub-reports, parameter based reports, graphical reports, formula based, well-formatted reports, drilling reports, analysis data reports along with LOV.
• Created and Formatted the Reports as per the Users Requirements using the features in BOBJ like Master/Detail, Charts, Cross tabs, Slice and Dice, Drill down, functions and Formulae to analyze the data.
• Created complex reports using user-defined functions like variables, prompt, condition Objects and Aggregate Awareness Functions for SQL enhancement.
• Used the Drill Down/up function to analyze data and created multiple charts in Reports.
• Created, managed and formatted standard reports, master/detail reports and cross tab reports using Report Manager
• Developed Crystal Reports with Web Elements. Where they use a Custom Function library for Crystal Reports which allows you to easily embed web controls on to the report.
• Worked on Implementing the LOVs, Hierarchy's, Pre-Defined Conditions, Resolving Data Base Connections, Adding new objects to the Universes.
• Worked closely with the end users and user decision makers to develop the transformation logic to be used in Reports.
• Designed Universes using different data sources. And created Derived Tables in the Universe using views and sqls to meet the Reporting Requirements. Scheduled jobs in CMC by Daily, weekly, bi-weekly and monthly basis and export the results in Excel and send the report to the user thru Email.
• Resolved the issues while converting Deski report to WebI by direct workout
• Created different Dynamic Dashboards using Xcelsuis and QlikView for based on states and LOB.
• Worked with Crystal Xcelsius and QlikView for creating simple dashboards and simple crystal reports and convert those in to user interfaces like excel files, PowerPoint representations for better understanding.
• Created Universes and complex reports against huge Oracle and Teradata database.
• Involved in Training the Users in using this robust system.
• Implemented mappings in Informatica powercenter involving source as flat files, relational tables to load the data to relational target tables using real time extract methods.
• Involved in universe performance tuning and Data Quality

Environment: Business Objects XI4.1/XI3.1, IDT Universe Designer, Web Intelligence, Desktop Intelligence, Crystal Reports, InfoView, Xcelsius 2008, QlikView 9, Import Wizard, UMT. QWAS, Live Office, Dashboard Manager, Performance Management, SAS, Microsoft Excel, Oracle 10g, SQL Server 2008, PL/SQL, TOAD, Apache Tomcat 5.5.26, Windows 2003,Informatica Power Center 8.1, HP Quality Center 9.2, Windows NT.

Confidential

SAP BW/BO Developer

Responsibilities:

• Loaded data into Dimensions manual and Applications from BW and external sources.
• Performed an initial study of the current reporting application, to finalize the data elements required for reporting.
• Interaction with users management, performance of analysis, designing, coding, testing implementation.
• Created Repository for BO development, created Universes and Complex Reports.
• Involved in working with different database environments and moving of the universes and reports between PROD, DEV, and TEST.
• Created the OLAP Universes on top of BEX queries and generated the WebI reports.
• Created Complex Crystal Xcelsius Reports from the output of Business Objects report data.
• Created Xcelsius dashboards for the Sales management application.
• Used QaaWS to provide dynamic functionality.
• Working on creating Universes, Business Intelligence Layer for end users to develop the Adhoc/Canned reports.
• Created user objects including Dimensions, Details, Measures, Filters and Prompts, LOV
• Defined Report Level Ranking, Database Ranking and Alerts in Reports based on the specifications.
• Designed Universes by defining joins, cardinality between tables, linked the existing Universes using Business Objects XI R3.1.
• Configured the Data services to connect to the SAP R/3 BW.
• Created the complex WebI reports such as Cross Tab and Master Detail Reports using the Java Report Panel.
• Worked closely with the end users and user decision makers to develop the transformation logic to be used in Reports.
• Created very complex reports that include multiple data providers, cross-tab, drill up-down, master detail reports, charts/ bar charts / pie charts and VB macro.
• Generated various report templates for standardizing the reports throughout the organization.
• Involved in Training the Users in using this robust system.

.

Environment:

SAP BI 7.0, ECC6.0, Business Explorer 7.0, BO XI R3.1, Crustal Reports , Crystal Xcelsius, Windows XP.

Confidential

SAP BW BOBJ Developer

Responsibilities:

• Involved in gathering end user Functional and Technical requirements, User/System Documentation, User training and testing developed reports for final deployment.
• Used Business Objects XIR3 extensively and Involved in Full SDLC software development life cycle rules are followed for designing new components.
• Designed, created and maintained Universes for Business Objects and Web Intelligence users using Business Objects Designer Module.
• Worked on Informatica Power Center Source Analyzer, Data warehousing Designer, Mapping Mapplet Designer and Transformation Designer.
• Created Web Based reports using Web Intelligence and Dashboards for various reports such as Cross Tab and Master Detail Reports using the Java Report Panel.
• Generated various reports on a daily, weekly and monthly basis using Business Objects Report module.
• Involved in writing free hand SQL, as data provider for retrieving data when universe doesn't provide required data.
• Created complex Stored Procedures and Views to be used for the reports.
• Involved in performance testing of all the reports, which helped in analyzing its performance before moving into production.
• Involved with the group which provided support and ideas for migration from BO XI 2 to BO XI 3
• Created Xcelsius dashboards using Query As A Web Service QAAWS and Live Office
• Tested reports for data consistency, tested Universe table joins, contexts, defects in reports/fixed the defects in reports
• Gave my thoughts and ideas to the data-modeling team in designing a new data mart for future reporting applications in a EDW warehouse.
• Coordinated with BO Admin in managing the Central Management Server to add/delete, enable/disable BO Servers.
• Coordinated with DBA and ETL in solving various technical issues and also to stream-line universe design and optimize query performance

Environment: SAP Business Objects XI R3/R2, Designer XI R3/R2, XiR3.1, Desktop Intelligence, Crystal Reports 2008, Oracle 10g, SQL, PL/SQL, UNIX

Confidential

Business Objects Developer

Responsibilities:

• Analyzed Business Processes and the already developed Scope of the support project
• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Build the new universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections.
• Involved in Installation and Configuration of all products of Business Objects.
• Worked on Business Objects Administration like CMC and CMS maintenance security issues
• Assigned privileges to users and groups using Supervisor.
• Worked in setting up the CMS and Audit database, Input and Output FRS repository systems.
• Implementing Security Features of Business Objects like row level, object level and report level to make the data secure
• Extensively used Business Objects Designer to design and maintain Data warehouse Universe.
• Used designer to create Universes and resolve Join Path Problems utilizing contexts and Alias tables.
• Designed and developed Universes and reports according to user requirements.
• Constructed different types of reports, such as Master/Detail, Cross Tab and chart for trend analysis . Use of filters, conditions, calculations, etc.
• Created linked universes and developed Complex reports that involved multiple data providers, Master/Detail charts, cross tab charts and complex variables and calculation contexts.
• Created prompts, conditions and filters to improve report generation. And also used Alerts to the report.
• Scheduled the Business objects documents for automatic refresh and to different destinations.
• Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.
• Worked on Implementing the LOVs, Hierarchy's, Pre-Defined Conditions, Resolving Data Base Connections, Adding new objects to the Universes.
• Migration and Report life cycle management through different stages of production which includes Web Intelligence, Desktop Intelligence and Crystal Reports for BOXI R2,3.1
• Migrated the content from XIR2 to 3.1 using Import Wizard.
• Creating publications of both types i.e. Enterprise recipient and dynamic recipient
• Worked with SAP Technical Support to troubleshoot various Deployment and performance issues.
• Worked with DBA's and System Administrators to back-up the repository and database and scheduled daily and weekly back-ups for both environment and repository.

Environment: Business Objects XI R3/R2, Designer XI R3/R2, XiR3.1, Desktop Intelligence, Crystal Reports 2008, Oracle 10g, SQL, PL/SQL, UNIX

Confidential

Business Objects Developer/Administrator.

Responsibilities:

• System study, interaction with users, management and designing, coding, testing implementation of the system.
• Involved in gathering user requirements.
• Analyzed the existing database and designed Universes using Designer module for generating reports.
• Exported universes to the repository to making resources available to the users.
• Worked on Query Panel, Prompts, Report Layout and Re-formatting.
• Created and modified the existing Universes by adding new classes/objects, prompts, hierarchies based on the business requirement.
• Defined categories of documents for different level of groups.
• Defined Complex Security set up for end users.
• Migrated upgraded Business Objects from 6.5 and Crystal Reports 10 to BOXI-R2 Universe designing and establishing BO environment.
• Designing, creating, enhancing, testing BO universe, reports.
• Troubleshooting and customization of reports after upgrade.
• Creation of reports like Reports by Period, Demographic reports and Comparative Reports using Business Objects Full Client application.
• System study, interaction with users management, performance of analysis, designing, coding, and testing implementation of the system.
• Designed Test cases for UAT of Reports for end users.
• Created the full client and Webi reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, Functions, Cross Tab, Master/Detail and Formulas etc.
• Used aggregate awareness in universes and Created Reports employing functionality like Queries, Slice and Dice, Drill down, Functions, Formulae etc.,
• Tuned the reports for better performance using SQL.
• Designed templates for Webi documents and customized Webi Front Page.
• Involved in Business Objects 6.5 Broadcast Agent and Supervisor.
• Mentored other IT staff Conducted Corporate training for end users on Business Objects XI.
• Linked Webi reports for different hierarchies.
• Mentored other IT staff Conducted Corporate training for end users on Business Objects XI.
• Trained the user community in making use of universe to create and publish reports.