SUMMARY:

• Over 9+ years strong experience in Business Intelligence (BI) using Business Objects (Universe Designer, CMC, Web Intelligence, Report Bursting, Import Wizard, Reporter modules, Info view), Xcelsius 2008, Crystal Reports 2008/ XI, Java BI Launch pad, CCM, IDT.
• Experienced in Developing Webi, Deski, Crystal, Webi Rich Client and Xcelsius Dashboards
• Developed WEBI report/dashboards/Universes (using IDT) in BI4 Environment.
• Development WEBI BOBJ 3.1 using advanced features including Database Delegated (Smart Measures), Hyperlinks, Delegate Search, Data Tracking, Input Controls and Merge Dimensions.
• Experienced in developing complex reports using Business Objects Webi Rich Client & Crystal Reports. Enterprise having Parameter/Formula Fields and Selection Formulas, Grouping and Sub reports.
• Tuned and Enhanced Universes with SQL Queries for the Report Performance.
• Good experience in SAP HANA 1.0 SPS4 - SP8.
• Designing the data flows to load the data from non-SAP source systems to SAP HANA.
• Good Knowledge of SAP HANA Modeler HANA Studio, Designing Schemas, Creating Packages, Attribute View, Analytical View, Calculation view, Analytical Privileges, Procedures.
• Worked on SAP HANA for E3 billing invoice and Reporting on SAP Native.
• Lead full cycle SAP HANA sizing and pre-procurement planning.
• Embedded all the calculation in HANA Analytical View and Calculation View.
• Developed custom function to save the invoice data in the HANA tables for recording and auditing purposes.
• Worked with exiting BI team to integrate What if reports using native HANA, Webi4 and Dashboard.
• Day to Day SAP HANA Administration and Support.
• Design and Build multiple universes for information model consumption.
• Conducted 5 day on site training on SAP HANA for BI team.
• Build the Sandbox, Pre-Development and Development SAP HANA environment in Cloud Share environment.
• Leverage SAP SLT and Business Object Data Services BODS to acquire the data into SAP HANA DataMart Native and BW on HANA
• 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.
• Created connections to BEx queries and BW Info providers using Business Intelligence Consumer Services (BICS) in IDT.
• Experience in Designing/Developing Universes/Data-Model, Developing Canned/Ad-hoc Reports, Scheduling and processing of reports.
• Excellent skills to develop reports using Web Intelligence Rich Client 4.0.
• Developed WEBI reports on SAP BW Queries using BICS.
• Modified BW queries in to generate WEBI reports in BO to meet user requirements.
• Expertise in creating Xcelsius Dynamic Dashboards using SAP BI data/ BEx Queries. Valuable Knowledge on Dashboard Designer Components like Charts, Selectors (Filters, label Based menus), Tab Sets, Canvas Containers.
• Proficient in Business Objects Reporting using Crystal Reports, WEBI Rich Client 4.0, Live Office and Xcelsius for both SAP and Non SAP sources.
• Strong knowledge in creating connections using Data Connection manager like Query Bowser, Live Office, Query As A Web Service (QAAWS), Flash Variables, SAP BI connectors, UD connecters, DB connectors.
• Provided HANA training to end user to upgrade their knowledge of SAP HANA and Lumira.
• Strong experience as Business Objects Administrator including installation, configuration of BO tools, set up and maintenance of Business Objects Enterprise environment, creating and managing groups and user profiles.
• Experience in CMC Administration activities like creating and managing repositories, monitoring/granting, permissions and rights to users, user groups through Central Management Server.
• Extensively worked on migration of the Business Objects from lower versions to XI R2, 3.0, 3.1, 4.0
• Good Knowledge of Data Warehouse Concepts including Schemas and Data Modeling.

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Sr. BOBJ / HANA Consultant

Responsibilities:

• Interacted with end users and Business analysts to identify and develop business requirement and transform them into technical requirements.
• Designed Maintained and Modified Universes using BO Designer by identifying required tables from Data Marts and exported Universes to CMS Repository.
• Migrated XI3.1 application and user contents to BO 4.0 using Upgrade Wizard.
• Developed Lumira stories using hana views and hana live as data source.
• Created joins, Contexts, and Aliases for resolving Loops and checked the Integrity, Cardinalities of the universe.
• Configured SAP HANA Finance and controlling rapid-deployment solution RDS .
• HANA model development for non-SAP Databases and application.
• Design and build SAP HANA Universe Business Layer .
• HANA and BI integration point optimization.
• Developed CO-PA and ODS date models and reporting.
• Worked with Power user from different business units design traditional and HANA universe.
• Created 100 plus interactive analysis for Inventory Analysis, Income Statement and Balance Sheet using Webi4. Building filters, using prompts, creating merge queries and linked reports with breaks. Integrating Financial Statement Versions as Hierarchies in Webi4 documents over HANA engine.
• Worked in SD, PM, MM and FICO modules.
• Create printable reports for actual verses plan data using Crystal Reports for Production, Sales and Revenue.
• Integrated Microsoft Office to HANA reporting build scale out HANA design for growth and performance boost and disaster recovery.
• Developed universes using Information Designer. Created Hierarchies for Multi-Dimensional Analysis and also created various Classes and Objects (Measure, Dimension and Detail ).
• Created Custom and Cascading List of Values (LOVs) for better understanding of Prompts by end users.
• Designed and developed complex Web Intelligence and Desktop Intelligence reports using functions like @prompt, variable, condition objects and Aggregate awareness functions for SQL Enhancement.
• Extensively worked on TCA business objects API using partner link of oracle business suite.
• Formatted various reports using Business Objects Functionalities like Sub Queries, Filers(Custom and predefined)Slice and Dice, Drill Down, Functions, Cross Tab, formula’s Charts, Master Detail Breaks, sorting, Ranking, Alerter (Sub alerter).
• Created Crystal Reports using Business Views and Universe as Data providers.
• Scheduled recurring, daily, weekly and monthly reports (Webi, Deski and Crystal Reports) in Info view and used Calendar based scheduling.
• Expertise in creating Metrics, Goal and Analytics to create Dashboards for better decision using Xcelsius 2008.
• Worked on SAP BO XI for oracle products like E business suite
• Created Excel-based interactive visual analytics, dynamic charts and groups and business presentations with Crystal Xcelsius.
• Build Interactive Dashboards using Live Office and also various connections such as QWAAS, BICS.
• Created Derived Tables in the Universe using views and stored procedures to meet the Reporting Requirements.
• Created complex reports by linking data from multiple data providers, using free hand SQL and functionalities like Combined Queries.
• Linked two universes sales and customer using kernel approach.
• Involved in creating users and user groups using Central Management Console (CMC) and assigned Privileges to the users
• Created different Categories in the repository and published full client reports corporate documents to their respective categories.
• Responsible for Troubleshoot performance issues related to application design
• Experience on working with Management components like Publishing Wizard, Query Builder and Report Conversion Tool.
• Responsible for customizing and tuning SQL queries for better performance of reports.
• Migrated Business Objects Universes, Users and user groups, and reports from Version XI 3.1 to XI 4.0 using the Upgrade Wizard.
• Microsoft SQL Server 2005 server side development including (SSIS, SSRS, SSMS)
• Integrated BOBJ 4.0 and BODS 4.0 with SAP HANA1.0.
• Created Technical specifications and standard modeling documents for HANA.
• Architect and design SAP HANA SP4 three tier landscape for Maple leaf food HQ and Frozen Bakery business diversion.
• Design and integrated exiting BODS and SAP SLT with HANA.
• Develop ETL Jobs with very heavy transformations for data acquisition from SAP ECC and Non SAP systems.
• Data Load via SAP BW extractors DXC to HANA from Legacy BW.
• Involved in planning of migration and created the checklists for migration for business contents and personal contents.
• After the migration, ran the check integrity utility for all the universes and reports and fixed divergences.
• Documenting the entire effort generating Requirements Specifications, Design Document, Project Planning, Change History, Unit testing documents, and System testing documents.

Environment: Business Objects XI 3.1/4.0, IDT, Web Intelligence, Infoview, Designer, Xcelsius 2008, Crystal Reports, Oracle 11g, IBM DB2, Teradata 13.0,Windows 2007, Informatica 8.6, Information designer, java BI Launch pad, Teradata 13.0, SQL Server 2005/2008.

Confidential, TX

Sr. BOBJ / HANA Consultant

Responsibilities:

• Interacted with Business Users and Managers in gathering business requirements and provided several Report Mock-ups to finalize the requirements.
• Involved in the designing and Building of Universes, Classes and objects and set up Universe level conditions to restrict data based on report requirements.
• Performed end to end SAP HANA implementation for several business units globally.
• Developed Universes from Bex queries and performed OLAP reporting.
• Tested objects in the universe, to ensure the correct mapping of the objects.
• Enabled SSO along with SAP authentications and configured Integration Kit for SAP BW.
• Configured JAVA SDK scripts like web XML, Aliases, and Sec windows AD for tomcat deployment and enabling windows AD aliases.
• Extensively used Web Intelligence through Info View interface to generate reports and published through I-Views on SAP BI Portal .
• Worked on canned reports which involved lot of complexity including hyper-linking, drill down, optional prompts and Alerters.
• Extracted data from Oracle E business suite using ETL tool for reporting purpose.
• Conduct query view on virtual data models delivered by hana live.
• Responsible for creating the reports (On demand, Ad-hoc Reports, Summary Reports, Sub Reports, dynamic grouping, Cross-Tab, graphical reports, etc) using the features like Ranking, Sorting, and @functions as per End user requirements.
• Designed Criteria to handle the customer’s request from Tables, Stored procedures, Views and Command objects using Crystal Reports .
• Used Crystal Xcelsius to create Dashboards to Visualize and enhance the data presentation by developing dynamic charts and graphics.
• Created Users/Groups and defined their roles and set privileges using the CMC.
• Published Documents on the World Wide Web for access to authenticated users via InfoView.
• Created Agency reports like, Reports by Region, Reports by Agency, Reports by Sales Manager, Reports by Segment, etc.
• Used Report Conversion Tool to convert the Deski reports into Webi and maintained the folders in the Info view.
• Support functions include troubleshooting problems with existing reports, modifying existing universes.
• Responsible for migration of universes & reports into Production environment.
• Coordinating with DBA Team, Warehouse Team and BO Administrator for resolving technical issues.
• Worked on Oracle E business suite integration with SAP business objects.
• Worked on bex queries to bring data from SAP BI 7.0.
• Responsible for designing, building, testing, and deploying Dashboards, Universes and Reports through Business Objects.
• Migrated Hana content from development to quality and to production environment using delivery units.
• Trained how to create Webi reports using Info view (Java Report Panel) and also trained the users on using the Alerter, Prompts, etc.
• Designed complex reports based on discussions with user groups and created various objects using built-in functions (like prompt, select, where, and aggregate), complex report level filters and contexts and complex SQL queries and joins involving case statements, some analytic functions like partition by etc. Thus Considering best business Practices using Web intelligence Rich Client and IDT.
• Design and develop hana models like attribute view, analytical view, calculation view etc.
• Moved the developed reports and universes between development, QA and production environments using Import wizard.

Environment: Business Objects XI 3.0/R2, Designer, Oracle 10g,Import Wizard, Web Intelligence, Crystal Reports, BO SDK, SAP BW 7.0,Teradata 12.0, Bex Analyzer.

Confidential, Washington, DC

Sr. Xcelsius/BOBJ Consultant

Responsibilities:

• Directly coordinated with user to gather the new requirements and working with existing issues.
• Developed 5 dashboards for shipping, procurement, operational, Cost management, Supply chain management.
• Used what if analysis, dynamic visibility to improve the navigation, look and feel of the dashboards.
• Extensively used live office and QWAAS as data sources for the Xcelsius dashboards.
• Deployed dashboards through Info view and published them as SWF files and also in PDF, PowerPoint formats.
• Linked dashboards and webi reports through hyperlinks and open document syntax.
• Involved in the Designing and Building of Universes, Classes and objects.
• Created DB2 Aliases through configuration tool and ODBC connections for Universe development.
• Created Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.
• Used @ functions and Aggregate Awareness in the Universe design.
• Used Business Objects (Web Intelligence, Desktop Intelligence) for creating various Adhoc Reports to business users on a daily basis.
• Created the complex Reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Prompt, Cross Tab, Master Detail.
• Created Drill-Through, Drill up/Drill down Reports to provide users with more detailed information and query linking.
• Automated document Scheduling, Publishing and Distribution for WebI and Info view clients, using info view.
• Designed, developed and deployed new data marts along with modifying existing marts to support additional business requirements.
• Created Complex Reports based on the Revenue Data like Revenue by Region, Workers compensation, and Supply chain Business trends

Environment: SAP BOBJ 3.1, Tearadat 12.0, SAP BW7.0, Bex query/Analyzer, Universe designer, xcelsius 2008, Webi, Infoview, CMC, CCM, Windows 2007, ms office 2007, lotus notes.

Confidential, Houston, TX

SAP BOBJ/Xcelsius Developer

Responsibilities:

• Analyzing system functionality requirements, documents and scope of the work.
• Work included Developing, Testing and enhancing existing Business Objects Universes; work required modifying, testing and promoting to the Repository.
• Developed, Tested, Promoted and Maintained the WEBI Reports, also had modified the existing reports based on user requirements, Also solved any issues/errors encountered
• Responsibilities required acting as the Key Person for maintaining Universe’s with creation of joins, Cardinalities, Contexts, and solving the loops, Testing, Data analysis etc.
• Have resolved loops, Fan Traps and Chasm traps using context and alias and also have built custom hierarchies and predefined filters to facilitate easy drill down and addressed performance issues.
• Worked extensively on the deployment and modification of data marts.
• Created reports using Business Objects functionalities like Slice and Dice, Drill Down, Cross Tab, Alerter and Formulae etc using Web intelligence.
• Scheduling daily, weekly and monthly reports using BO XI Scheduler using Events, creating Calendars.
• Extensively worked on the development of Data marts.
• Formatted Reports as per the User requirements using extensively the functionalities in Business Objects, which allows the users to analyze the data.
• Used Polestar for better interaction with predefined data sets to generate quick visualized reports
• Extensively used Calculations, Variables, Break points, and Sorted inputs, Drill down, Slice and Dice, Alerts etc in Creating Reports, formatted old reports, generated charts, bars etc as per user requirements using Crystal Reports 2008, Xcelsius 2008 and integration as well.
• Deployed new data marts along with modify existing marts to as per changing business requirements.
• Designed interactive Dashboards such as Popup, Tabs etc and many creatively styled Xcelsius Dashboards to best support needs using effective HCI Principles.
• Manipulating data through various presentation styles using Crystal Reports 2008 such as charts cross tabs, slice and dice, user response, alerts, prompts, nested loops and filters.

Environment: SAP Business Objects XI 3.1/3.2,Xcelsius 2008, Bex query, Bex analyzer, Crystal Reports 2008, Web Intelligence, Business Explorer XI 3.1, SAP BI/BW 7.0.

Confidential, Pittsburgh, PA

BOBJ Developer,

Responsibilities:

• Creating, developing, maintaining and testing the Universe for running the queries against the Database using Designer.
• Involved in Installation and Configuration of all products of Business Objects XIR2.
• Analyzed the existing database and designed Universes using Designer module for generating reports.
• Used various data providers like Freehand SQL and Stored Procedures to extract data from different sources and tuned for better performance.
• Resolved loops by creating Aliases & Contexts and checked integrity of universes.
• Exported universes to the repository to making resources available to the users.
• Created reports using the Universes and Free-hand SQL as data providers.
• Involved in development and deployment of Complex Reports.
• Exported the Reports to the Broadcast Agent and used the Broadcast Agent server to Schedule and Monitor the Reports which offered robust performance and ability to balance Loads.
• Generated analytical reports using Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae features.
• Automated document Scheduling, Publishing and Distribution for Webi and InfoView clients using Broadcast Agent server.
• Used Supervisor to Grant User rights and roles etc.
• Involved in optimizing the universe developing time and SQL Tuning to increase the query performance.
• Used Designer as a part of Universe Development for Defining the Parameters of Universe, Inserting the table, making Joins, Resolving Loop's, Creating Classes, and Objects.
• Involved in creation of Filters, prompts and setup Hierarchies for Multidimensional Analysis.
• Created the Reports using the Universes as the main Data providers and wrote complex queries including Sub Queries, Case and Decode functions, using Crystal reports XI.

Environment: Business Objects XIR2, Designer, Webi, Deski, CMC, CCM, Crystal reports XI, sd9i, PL/SQL, and Windows NT/XP, Ms Office, Ms Visio.