SUMMARY

• Expertise in the entire SDLC process with Requirements Collections, Analysis, Design, Development, Testing and Maintenance of Universes, Reports, and Documentation of the entire life cycle.
• Extensive experience and solid understanding of Data Warehousing, Data Marts, Star Schema, Snow Flake Schema, Star Flake Schema Modeling, Dimensional Modeling, OLTP and OLAP concepts.
• Experience with Business Objects XI 4.0/R3/R2/6.x/5.x comprising of Designer, Desktop Intelligence, Web Intelligence, Crystal Reports, Xcelsius, Live Office, QaaWS, Design Studio, Mobile Analytics, Explorer, Analysis for OLAP/Office, Lumira, CMC, CMS, Info view, Import Wizard, Report Conversion Tool, Migration Wizard, Supervisor, Broadcast Agent, BO Auditor, BO Reporter.
• Designed and Developed Universes implemented Classes, Objects, Set Cardinalities, Conditions, Loops, Contexts, Aliases, resolved Chasm Traps, Fan Traps,Defined Hierarchies, Customized LOVs,@functions,Derived Tables, Index Awareness and Linked Universes.
• In Web Intelligence, developed wide variety of advanced and complex reports using functionalities like, Cross Tabs, Forms, Tables, Sections, Breaks, Sorts, Ranking, Prompts, Drill - Up, Drill-Down, Drill-Across, Drill-By, Charts, Formatting Cells and Blocks, Conditional formatting using Alerts, Formulas and Variables, Functions, Report Filters, Combined Queries, Multipass Queries, Sub Queries, Merged Dimensions.
• Created reports in Desktop Intelligence usingUniverses, Stored Procedures, Freehand SQL, Personal Data files, Linking Data from multiple sources.
• Expertise in Customizing and Trouble shooting of Business Objects Designer, Desktop Intelligence, Web Intelligence, and Crystal Reports for Query Optimization and Faster Performance.
• Developed dashboards using Xcelsius with data sources included Excel, Live Office and Query as a Web Service (QaaWS).
• Expertise in using Central Management Console for Creating New Users, Groups, Setting Access Rights and Managing Security. Created Folders, Categories, and scheduled the reports using InfoView/Launch pad.
• Designed and developed Crystal Reports using various features like Cross Tabs,Forms Letters, Selection Expert, Formulas, Sorting, Grouping, Running Totals, Summary, Absolute and Conditional Formatting, Charts, Maps, Alerts, Sub Reports, Drill-Down, Top N, OLE Objects, Sections and Performance Tuning of Reports
• Expertise in configuration of BW data objects including InfoObjects, InfoSources, Transformations, ODS, InfoCubes, Info Providers, MultiProviders, BEx Reporting, and accessing BEx queries in Business Objects environment.
• Expert in creating content with Design Studio, Mobile Analytics, Explorer, Analysis for OLAP/Office, and Lumira
• Expertise in Production Support, Maintenance, Communicating, Issues Tracking, Train End Users on Business Objects Products.
• Well versed in developing SQL Statements, PL/SQL procedures, functions, packages, database triggers, cursors and views against Oracle 10g/9i/8i, SQL Server 2005/2000 and other RDBMS.
• Excellent Problem Solving, Communication and Interpersonal Skills, passion to Learnand good team player.

TECHNICAL SKILLS

BI Tools: SAP Business Objects 4.0/XIR3.1/3.0/R2/XI/ 6.5/5.1.6/5.1.2 , (Information Design Tool, Universe Designer, Web Intelligence, Dashboards Designer (2008/4.5), Launchpad, CMC, Design Studio, Mobile Analytics, Explorer, Analysis for OLAP/Office, Lumira, Designer, Desktop Intelligence, Broad Cast Agent Server, QaaWS and Live Office) CrystalReports 2008/XI/10/9/8, SAP BW/BI 3.x/7.x

ETL Tools: SAP BODS, Informatica 7.1.2/6.1/5.1. SAS 9.1.1

RDBMS: SAP HANA,Oracle 11i/10g/9i/8i/8.0.5, SQL Server 2008/2005/2000 , Teradata 13/14, DB2, MS-Access

Data Modeling: Erwin, MS Visio

Languages: SQL, TSQL, PL/SQL, SQL*Plus, TSQL, HTML, DHTML

O/S: Windows XP/2003/NT/ 2000.98.95 , Linux, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Lexington, MA

SAP BO Consultant

Responsibilities:

• Extensively participated in the requirements gathering phase for the project and closed worked with the other team to extract data from different sources.
• Responsible for preparing Business Requirement Document (BRD) and then translating into functional specifications. Closely coordinated with both business users and developers for arriving at a mutually acceptable solution and gathered requirements.
• Created and managed project templates, use case templates, requirement types and tractability matrix in Requisite Pro.
• Facilitated (JAD) Joint Application Development sessions to identify business rules and requirements and then documented them in a format that can be reviewed and understood by both business people and technical people.
• Facilitating sprint planning as Scrum master for multiple Scrum teams.
• Participated in Design walk-through with the SMEs to baseline the business architecture.
• Created and groomed backlogs, user stories with product owner and facilitated Scrum ceremonies.
• Helped the product owners to come up with set of stories for better understanding for estimate and development.
• Representing the team to report overall project status and upcoming risks and suggest solutions about it.
• Providing high level strategic, analytical direction and vision.
• Developed Dynamic dashboards which are used across the Sales Department to analyze the teams monthly and Quarterly Targets.
• Worked on building dashboards in Dashboard Designer using Live Office Connectivity and also created WSDL’s using Query as a Web Service (QaaWS) and BI Service from different data sources to build Xcelsius dashboards.
• Worked closely with the Dashboard product development team on various product bugs which we came across on both desktop and mobile dashboards.
• Created reports and Dashboards which are compatible for MOBI environment.
• Extensive knowledge on dashboard components and data connections for desktop and mobile compatibility.
• Worked on Optimizing the performance of the dashboards by limiting the use of excel formulas and scheduling the backend source WEBI reports and by selecting the filter option changing with refresh on trigger option to pick the latest instance.
• Worked on complicated Crystal Reports involving Cross-Tab and Sub-reports using different data sources.
• Created stored procedures to support the business requirement owing to the limitations in Crystal Reports.
• Migrated reports from Crystal 2008 to Crystal 2011 and resolved the design breakage issues occurred.
• Worked on the development and implementation of business views to deploy dynamic LOV’s in Crystal Reports.
• Worked on migration of BO platform from 3X to 4.X
• Defined JDBC connections to use BOBJ as reporting platform on HANA.
• Defined HANA variables and parameters with integration of SAP Business Objects.
• Designed universe on HANA data models and tables.
• Responsible for Creating and Maintaining Users/Groups, Universes, Repositories, Connections and Security Policies.
• Used Slice and Dice, Drill Down, Filters, Conditions, Cross Tab, Master Detail and Formulas etc and developed Hierarchies to support drill down reports.
• Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.
• Write Complex Queries including JOIN relationship (Inner and Outer) for extracting the data according to the requirements of Reporting Group; also tune the queries to improve the time limit to run.
• Created projects, connections to database, Data Foundation layer, Business Layer using Information Design Tool.
• Involved in the designing and building of Universes, Classes and objects and exported universe across different environment domains from Development to PU to Production.
• Experience in creating Alias and Contexts to resolve Loops, Chasm Traps and Fan Traps
• Defined conditions using @bouser functionality to apply mandatory security filter on the respective class or universe
• Defined @Prompt functions in the universe to record user selected prompt and perform the calculations in the universe based on the user input
• Using Import wizard or LCM to migrate the Universe, reports, and dashboards from one environment to other environment.
• Created restricted or custom LOV’s in the universe objects as per the request from the user community.
• Defined custom Navigation paths to facilitate the drill down and drill up functionality in Webi and Dashboards.
• Experience in using Query panel in universe to verify the generated SQL after the joins are defined
• Experience in creating and managing access restrictions in the Universe to define the row based security.
• Used the access restrictions to define the Object level security for developers and Power users
• Built WebI reports using various Web Intelligence features like alerters, hyperlinking, sections, breaks, sorts, formulas, functions and operators.
• Experience in trouble shooting the performance issues in WebI reports.
• Used SQL extensively in command objects of Crystal Reports.
• Worked on building Explorer information spaces against universes.
• Scheduled periodic refresh of the Explorer spaces and setup end user security to access the Explorer space.
• Trained power users of the Reports using Info View and exporting reports to various formats.
• Extensively used the CMC in setting up security in BOXI and also managed security configuration for various reports, folders, connections, applications and universes.
• Scheduled the reports daily, weekly, monthly, quarterly and also on-demand using the event server on CMC.

Environment: Business Objects Enterprise XI 4.x/3.x, BODS, CMC, SAP BO Explorer, BO Information Design Tool, Web Intelligence/Info View/BI Launch Pad, MOBI, Desktop Intelligence, Import Wizard, Crystal Reports, Xcelsius, QAAWS, Lumira, Live Office, BI Service, SQL Server, SAP HANA, Unix Shell Scripting and Windows.

Confidential, Aliso Viejo, CA

SAP BO Sr. Architect

Responsibilities:

• Worked closely with Business Analysts/Business Users and gathered requirements to build the new Universe, Web Intelligence Reports, Dashboards, BEx Queries and Reports in OLAP Analysis.
• Designed and developed Universes by creating Classes, Objects, selecting/joining tables, cardinalities, aliases, loops, contexts, pre-defined conditions, advanced objects, hierarchies, cascading prompts and customized LOV’s to facilitate easy end-user reporting.
• Developed Web Intelligence reports with varying level of complexities with respect to data retrieval (sub-queries, multiple data sources, custom SQL, etc.) and report formatting/layout (Alerters, dynamic display of report blocks, charts, etc.).
• Worked extensively with SAP BI functional/technical developers to design and develop the SAP BI Info cubes and Multi Providers utilized in Business Objects environment.
• Designed and developed BWBEx Queries with Restricted Key Figures, Calculated Key Figures, and Variables which were utilized in Web Intelligence Reports and Dashboards.
• Designed and developed Universes based on SAP BEx sources.
• Created interactive in Dashboard Designer (Xcelsius) sourcing from BW Environment (BICS Connection), QaaWS and Excel Model used advanced functionalitieslike Drilldown.
• Expert in creating content with Design Studio, Mobile Analytics, Explorer, Analysis for OLAP/Office, and Lumira
• Performed Unit/Data Validation tests on Universes, Reports, and Dashboards by comparing data against the Bex queries using BEx Analyzer, and against source RDBMS by issuing the SQL Statements.
• Extensively involved in resolving Production issues and trained Business Users on various reporting tools for generating their day to day reports using various easy and complex functionalities.
• Involved in project planning process by estimating Reporting tasks and deliverables.

Environment: Business Objects XI R 4.1, Design Studio 1.2, Analysis for Office/OLAP, SAP BW 7.3, SAP FICO, SAP PM, SQL Server 2008/12, Oracle 11i, Windows 2008 R2, Win 7

Confidential, Minneapolis, MN

SAP BO Architect

Responsibilities:

• Gathered, analyzed, and documented business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Tuned existing Universes, and built a new universe for Ad-hoc and canned reports. Reduce complexity of the existing universes so that Debugging and maintenance is easier.
• Converted derived table level reports to Universe Tabular level approach for better usage of Business Objects Universe.
• Built and Implemented very complex WebI reports, and fixed existing complex reports while regression or in Release Implementation.
• Developed complex reports by linking data from multiple data providers, using free hand SQL, using opendoc parameters and functionalities like Combined Queries.
• Used BEX Queries directly to Web Intelligence, used SAP BI warehouse in the back end.
• Directly Interact with Users to understand their routine issues in Business Objects and built a process how we can effectively use Business Objects Reporting.
• Interacted with the Data Warehouse team (Data Modeling, ETL, and Business Analysts) and improve the OLAP model, which can help in tuning the SQL and improve the performance of generating reports.
• Created and modified existing JSP files for Xcelsius Dashboard 2008 and deployed it on Tomcat Web Server.
• Worked with migration team during the upgrade from Business Objects 3.1 to 4.1.
• Developed Functional (Business terms) and Technical Design documents. And lead the team while gathering, analyzing, and documenting technical requirements from the functional requirements.
• Responsible to support the issues with reports on the Business Objects Enterprise environments (Development, Test, UAT and Production).
• Arranged and supervised the training sessions for business users to get them acquainted with Info view and Web intelligence. Developed training materials for Business Objects and Documentation of the environment, as well as migration and administration processes.

Environment: SAP Business Objects BI XI 4.1/4.2/3.x, (Information Design Tool, Universe Designer, Web Intelligence, Dashboards Designer, Launchpad, CMC, Design Studio, Mobile Analytics, Explorer, Analysis for OLAP/Office, Lumira), Crystal Reports 2011, SAP BI 7.x, SAP ECC 6.x, Oracle 11g.

Confidential, Mason, OH

SAP BO Architect

Responsibilities:

• Involved in the requirement gathering from the business users to build the new Universe and set of Business Objects - Web Intelligence Reports.
• Worked closely with the Business Analysts to understand this business Requirements.
• Developed universes as per the requirements of the universe, deployed and maintained the universes. Troubleshoot if any issues were raised with the universes.
• Created Universes by defining Joins, Cardinalities with multiple Star Schemas, utilized advance functionalities like @Prompt, @Variable, @Select and resolved the join path problems like Chasm Trap andFan Trap and Loops by creating Context and Aliases.
• Created new set of Web Intelligence Reports using Calculations, Variables, Breaks, Sorting, Drill down, Slice and Dice, Alerts,Complex Formulae and Sections, Multiple Data Providers, Merge Dimensions, Filters, Parameters to meet the user requirements.
• Experience in developing dynamic, operational, and executive dashboards using Dashboards Designers (Xcelsius)using the BICS, Web Service Connectors, QaaWS, Live Office, XML and Universe.
• Provided end user and production support after deploying the Universe and the reports into the production environment.
• Used Universe and Personal Data Files as sources for the Business Objects reporting, developed different types of reports with features like Ranking, Filtering.
• Worked extensively with SAP BI functional/technical developers to design and develop the SAP BI Info cubes and Multi Providers utilized in Business Objects environment.
• Designed and developed BWBEx Queries with Restricted Key Figures, Calculated Key Figures, and Variables which were utilized in Web Intelligence Reports and Dashboards.
• Developed and maintained standards for administration and operation including the scheduling, running, monitoring, logging, management of errors, recovery from failures, and validation of outputs and made it available to team members.
• Created technical and user documentation which has the step by step process of creating reports and using the functionality of Business Objects.

Environment: SAP Business Objects BI XI 4.x/3.x, (Designer, Information Design Tool, Web Intelligence Rich Client, QaaWS, Import Wizard, Info View, CMC), Live Office, Analysis for OALP/Office, Crystal Reports, SAP Dashboard Design, Teradata 14, Oracle 10g, SAP Net Weaver 7.3, BEx Queries

Confidential, San Jose, CA

SAP BO Lead

Responsibilities:

• Interacted with development and business teams to identify and define requirements for Business Objects software application and day-to-day management of assigned project plans, schedules and test requirements as it relates to Business Objects and/or user reporting needs
• Held/Attended e-meetings to describe the functionality of the application to the users.
• Involved in documenting Requirements Specifications, Design Document, and Project Unit testing documents.
• Involved in maintaining the existing Universes and modifying them according to the requirements.
• Defined different level of Hierarchies in the Universe to provide the users with Drill down option in reports and Predefined Conditions to use in Business Objects
• Worked extensively with SAP BI functional/technical developers to design and develop the SAP BI Info cubes and Multi Providers utilized in Business Objects environment.
• Designed and developed BW Bex Queries with Restricted Key Figures, Calculated Key Figures, and Variables which were utilized in Web Intelligence Reports and Dashboards.
• Involved in developing and creating both Full client (Desktop) as well as Thin client (Web Intelligence) reports.
• Created complicated reports including sub-reports, parameter based reports, graphical reports using Crystal Reports tool.
• Developed interactive/dynamic dashboards with Xcelsius and implemented prompts, drill down capability and Applied alerts
• Involved in creating chats & graphs using Xcelsius based on the user requirements.
• Involved in training the users about the functionality and the usage of the Business Objects Info View.

Environment: SAP Business Objects XI 4.0/3.1, Live Office, Crystal Reports 2008, Xcelsius 2008, SQL Server 2008, Oracle 10g, Teradata 12. SAP BW 7.x, Analysis for OLAP/Office.

Confidential, Phoenix, AZ

SAP BO Sr Developer

Responsibilities:

• 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.
• Used Derived tables to create the universe for best performance, and use context and alias tables to solve the loops in Universe.
• Created complex reports stating revenue generation per year using cascading and user objects like measure objects by using @aggregate aware function to create the summarized reports.
• Exported the Universes to the Repository to make resources available to the users for ad-hoc report needs.
• 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 complex reports using the multiple data providers and synchronized the data providers by linking the common objects.
• Created different reports containing charts showing revenue and operating income by different divisions, market share of newspaper by circulation.
• Created complicated reports including sub-reports, graphical reports, formula base and well-formatted reports according user requirements.
• Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.
• Provided the security access management by creating users/groups and folders.
• Implemented the ETL process and business logic by using PL/SQL.
• Developed universe user documentation guide for the end users reference.
• Provided training for end users for generating their own report including complicated report.

Environment: SAP Business Objects XI 4.x, (Designer, Information Design Tool, Web Intelligence Rich Client, QaaWS, Import Wizard, Info View, CMC, Live Office, Analysis for Office), Crystal Reports 2008, Xcelsius 2008, Teradata 14, Oracle 10g, SAP BW 7.x

Confidential, Memphis, TN

SAP Business Objects Architect

Responsibilities:

• Involved in all phases of Software Development Life Cycle (SDLC).
• Involved in gathering, analyzing and documenting business requirements, functional requirements and data specifications to generate the Reports.
• Created universes, classes, objects, complex measure objects, prompts, pre-defined conditions.
• Created universes for the users to do ad-hoc Reporting.
• Resolved loops by either creating aliases or contexts or by defining shortcut Joins.
• Created Universes using @functions like @select, @where and @prompt in the process of building the universes.
• Created design for running multi flavor reports like - Date, Weekly and monthly as well.
• Defined Hierarchies in Universe to provide the users with Drill down option in reports and Predefined Conditions to use in Business Objects.
• Imported/ Exported the Universes from/ to repository to make them accessible to end-users.
• Migrated several reports/universes from BO XIR2 to XIR3 using Import Wizard and converted them to WEBI reports using Report Conversion tool.
• Created Prompts, conditions and Filters to improve the report generation. Also used Alerts to improve the readability of the report.
• Applied slice-and-dice, drill-up and drill-down techniques in master detail reports for multi-dimensional analysis of retrieved data.
• Created financial reports, charts using Universes as the main data provider. Reports such as Quarterly variance, Regional, Actual vs. Forecast, Balance sheets etc. were developed.
• Created graphical representation of reports such as Bar chart, Pie chart etc. as per the end user requirements.
• Created number of formulae, conditional display of fields for complex calculations and used them in different sub reports.
• Developed various Charts and Graphs like Bar Chart (Side by Side, Stacked), Line graphs, Pie Charts etc. by using Chart expert of Crystal Reports 2008.
• Worked on crystal complex reports that require running totals, sub-totals, sub-reports, hierarchies, cross-tab, multiple groups and conditional display of groups, fields, and messages.
• Developed several complex reports (include multiple groupings, drilldowns, parameter fields, formulas and retrieving data from more than one database)
• Created Dashboards using Xcelcius.
• Involved in displaying data from legacy systems and relational databases and also in creating, modifying reports using tables, views, functions and stored procedures.
• Created Web Intelligence and Desktop Intelligence reports with multiple data providers like Universes, Personal Data Files and free-hand SQL.
• Built queries to retrieve data in SQL Server and Teradata through a universe and set up query conditions.
• Developed, tested and implemented new PL/SQL Packages, Functions and Stored Procedures, Triggers etc.
• Worked with Central Management Console (CMC) to manage groups, users, set security levels, Publish and schedule reports.

Environment: Business Objects XIR3, Crystal Reports 2008,SAP Dashboard Designer, Designer, Desktop Intelligence, Web Intelligence, Info View, CMC, CMS, 8.1, Oracle 9i/10g, SQL, PL/SQL, SQL Server 2008, TOAD, Windows 2000/XP.

Confidential, Radnor, PA

Business Objects Consultant

Responsibilities:

• Involved in complete SDLC from gathering requirements, analyzing them, design, development, testing, maintenance and documentation.
• Designed and developed Universes data models from both star schema and operational databases and worked with Classes, Objects, Loops, Contexts, Aliases, Checked the Cardinalities, Joins and Aliases, Hierarchies and Traps based on business logic.
• Created Classes (Sub classes), Objects, Prompts and Predefined conditions and user defined objects and custom Hierarchies for drill down purposes.
• Designed and developed reports in Desktop Intelligence and Web Intelligence using functionalities like Combined Queries, Merged Dimensions, Slice and Dice, Drill Down, Functions and Variables, Cross Tab, Master Detail, Formulas, Filters, Sorts, Charts, Ranks, Breaks and conditional formatting with Alerts.
• Used Report Conversion Tool to convert reports from Desktop Intelligence to Web Intelligence.
• Retrieved data using Universes, Personal data files, stored procedures, free hand SQL methods and creating complex ad-hoc Reports using the Desktop Intelligence.
• Worked with Xcelsius to create interactive dashboards, and used Live Office and QaaWS as data sources.
• Used Query as a Web Service to build visualizations based on the reports built in Business Objects.
• Involved in production Support and trained end users in understanding the reports functionalities such as Slice and Dice, Drill mode and Ranking were used for Multidimensional Formatting.
• Designed and developed complex Crystal Reports (on demand, Adhoc Reports, Frequency Reports, Summary Reports, Sub Reports, Drill-Down, Dynamic Grouping, Cross-Tab, Graphical, Aging Reports).
• Involved in query performance tuning and report tuning, for various different reports.
• Created users/groups and defined privileges and access rights using Central Management Console.
• Published the Reports that are generated by the users in Info View for reusability by different users.
• Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems or questions with programs/interfaces.

Environment: Business Objects XI R2/3.1, Designer, Web Intelligence, InfoView, Desktop Intelligence, Central Management Console, Xcelsius, QaaWS, Crystal Reports 2008, Teradata, Oracle 11g, SQL Server 2005, MS Office 2003/07/10, and Windows XP/7