SUMMARY

• SAP BI/BOBJ Senior Consultant with 8 years of SAP BW, BI, BOBI 4.1,4.0 BO XI 3.1/XI R2/6.x/5.x with Full Life Cycle Implementation experience.
• Strong skills in ABAP/4 and associated tools in SD, MM, PP, CO, HR and FI modules.
• Involved in Full life cycle (analysis, design, integrating BI to BO, design, development and deployment) of Business Objects reporting Applications with Web Intelligence, Crystal Reports and Dashboards.
• Excellent experience in designingBusiness Objects universes, complex BO reports bothfull client andWeb Intelligence Reports.
• Expertise in the functional and technical areas of SAP BI 7.0with full cycle implementations usingASAPmethodology.
• Extensive experience in Data modeling usingInfoCube,MultiProvider,ODS,Transfer rules, Update rules,InfoSet,InfoSources, DataSources,Transfer Routines, Update Routines and Start Routines.
• Working experience on Microsoft Business Intelligence tools SSAS, SSIS and SSRS.
• Experience in SQL and PL/SQL including all database objects: Stored procedures, functions, Packages, Triggers, cursors, Parameterized cursors, Views, PL/SQL collections.
• Experience in creating Relational Universes, OLAP Universes (UDT, IDT), Xcelsius reports, Desktop Intelligence, Webi reports and Dashboards.
• Expertise in Crystal Reports 2011 and interactive dashboards from SAP .unx and Bex Queries.
• UsedLive OfficeandQAAWS (Query as a Web Service)to feed live data intoXcelsius 2008 (both Dashboards & Scorecards).
• Experienced in creating BICS - OLAP Connections, Data Foundation Layer, Business Foundation Layer, Single Source and Multi-Sourced Universe with Information Design Tool (IDT)
• Experience in Business Objects Reports migration from earlier versions 6.X to 3.1 and 3.1 to 4.0.
• Created classes, subclasses, objects, Cardinalities, Conditions, Contexts, Joins, External Strategies, Prompts and Aliases for resolving Loops and checked the Integrity of the Universes.
• Experience in analyzing, designing and modeling data warehouses and star schema data marts for various business verticals and Insurance.
• Good at Database Design, conceptual, logical and physical Data Modeling, Star Schema, Snowflake; FACT and Dimensions tables, slowly changing dimensions (SCDs)
• Extensively workedinData Extraction from Multiple SAP and Non SAP (Legacy) Systems using Business Content, LO, LIS, CO-PA, FI-SL, Flat File,and Generic ExtractionMethods for legacy data.
• Experience in construction of customized InfoObjects, InfoCubes, Remote Cubes and ODS/DSO objects.
• Conducted and performed Performancetuning Techniques (Aggregates, CubeCompression, Line Item Dimension, and Indexing) for Improving the Reporting.
• DevelopedUpdateandTransferRoutines in BW to implement business rules and conversions while extracting data from R/3.
• Involved in Info Cube maintenance i.e., Compression, Roll-up for Aggregates.
• Complete automation of all BI Daily, Weekly and monthly loads (Info Package Scheduling) using Process Chain.
• Designed and developed queries for reporting usingBEx Analyzer, Query Designer and Web Application Designer.
• Expert in creatingProcess Chainsfor Automation of processand Better Performance.
• Experienced in the functional and technical areas ofSAP FI/CO, CRM, HCM, Project Systems, SD, MM, PPModules.
• Complete knowledge ofSDLC cycleand worked on projects comprising of Business architecture transformation from the Legacy or Mainframe systems into Client-Server Web Based architectures.
• Excellent communication skills and presentation skills.

TECHNICAL SKILLS

BI Tools/Modules: Business Objects (BI4.0, 3.1/XI R3/XI R2/6.x/5.x),BI launch Pad, Infoview, Interactive Analysis (Web Intelligence), Web Intelligence Rich Client, Desktop Intelligence, Report Conversion, Crystal Reports 2011/2008, Crystal reports for Enterprise 4, Information Designer, Universe Designer, Dash board designer, Xcelsius 2008, Qaaws, Live office, Admin tools CMC, CMS, Windows AD, Promotion Management (LCM), WEBI SDK, Broadcast Agent, Business Explorer, BI Open Text, Cognos.

Database(s): ORACLE 9i/10g, OWB 11, DB2 UDB, MS SQL Server 2005, MS Access, Teradata, SAP BW,HANA

Data Modeling Tool: Star Schema, Snowflakes Modeling, Erwin 4.0, Microsoft SQL Server Reporting Services 2005/2000

ETL Tools: Informatica, SAP BI 7.0/3.5,Business Objects Data Services

GUI/SQL Development Tools: SQL Navigator, TOAD, Teradata SQL Assistant, SQL Server.

Programming Languages: C, C++, Core Java, VB, XML, HTML, SQL, PL/SQL.

Operating System: UNIX, Windows 95/98/2000 /NT/XP/7, Sun Solaris 6.x/7.x

Other Tools: Control - M, BMC Remedy, MS Office Suite

PROFESSIONAL EXPERIENCE

Confidential, Florida

Sr. SAP BI/BOBJ Consultant

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• BI (Open Text) migration to Business Objects BI 4.0
• Identify list of tables, joins, calculated columns and reports in BI Data Warehouse model.
• Used BI 4.0 Information Designer Tool to design Universes, joining tables, creating prompts and applies Contexts and Aliases to remove loops.
• Publish/Retrieve .unx Universes from/ to repository to make them accessible to end-users.
• Created WEBI reports from BI model reports using corresponding Universes.
• Conducted Review meeting with BI model owner to review Universe for corresponding BI Model.
• Migrated Universes and WEBI reports to QA and Production using Life Cycle Management Console (Promotion Management)
• Work with Business Analysts and Database Architect to identify database relation for the business requirement.
• Designed, Developed and Maintained Universes by defining joins cardinalities between tables applying contexts and alias tables to remove cyclic dependencies.
• Defined and Created Hierarchies as per the business rule for the reports to be viewed at selected reporting level.
• Developed various Complex Ad hoc and Complex Canned Reports Using Mainly Universe as the main Data Provider.
• Developed Dashboards usingXcelsius 2008 components usingmaps, Pie Charts, Staked Bar and List Views.
• Extensively used various techniques like Sectioning, Ranking, Filtering, breaking to develop the report.
• Created different types of reports such as Master/detail (drilldown), Cross Tab, Bar charts, 3D charts and Pie charts.
• Converted universe from the BO 3.1to .Unx universe (BI 4.1) and also rebuilt the universe in 4.1
• Participated in design reviews, spec reviews, code reviews, test plan reviews.
• Worked with various standard as well as custom BI/BW objects for FI, CO, SD, and MM of ECC.
• Designed and developed various Datatargets and Infoproviders like DSO (ODS), Infocubes, Infoobjects, Multiproviders and Infosets using Admin workbench (EDW, RSA1).
• Worked on customization and enhanced the extract structure to support business needs.
• Populated various data targets like Infoobjects, DSO and Infocubes, with Master data and Transactional data from ECC 6.0, legacy systems using flat file interface via Data Staging area (PSA).
• Debugging the Extractor checker, Start routines and End routines.
• Evaluated statistical performance and provided recommendations for optimization. Improved data load and query performance by doing compression, aggregates, and partitioning.
• Used transformations and have written transformation code in start routines.

Environment: SAP ECC 6.0, ABAP/4, SAP BI 7.0, SAP BOBJ XI 3.1,4.0 Universe Designer (UDT), Information Design Tool (IDT), Web Intelligence, Crystal Reports 2011, Life Cycle Management, CMC, Dashboard (Exelcius),Teradata 13,Oracle 11i

Confidential, Cleveland, OH

Sr. SAP BOBJ Consultant

Responsibilities:

• Createdcomplex Webi reportswithmultiple queries, custom Sql, using complex functions, merging dimensions at report level, drill down, drill up, drill across and complex filters.
• Createdsix complex dashboardswhich use live office to feed the data into Xcelsius from the source Webi reports.
• DevelopedProvider scorecard reports using Webi as the reporting tool.
• Developed complex webi Core Measures Scorecard reportwhich is used by the organization to track various core measures of the company by month, quarter, and year against the benchmarks.
• Developed a complexprovider scorecard dashboard withmultiple tabs using dynamic visibility.
• This dashboard shows the high level information ofrolling 12 months of provider performance datavarying across different areas like productivity, machine utilization, compliance and quality.
• The dashboard also has the capability ofdrilling downto the detail data on to the detail webi reports.
• Fulfilled the business objects development needs for various departments. And also performed the day to day admin tasks.
• Modified existinguniversesand implemented new universes according the reporting needs by detectingcardinalities, resolving trapsand usingcontextsand also developedhierarchies and derived tables.
• Developed complex webi reports usingcombined queries, merging dimensions, complex functionsat the report level andcomplex filtersto satisfy the end user requirement.
• Handled various tickets for business objects issues for the end users.
• PerformedAdmin taskslikemonitoring DB Services, monitoring BO serverrunning with optimal performance,monitored licenses, monitoring ofuser activities/ sessionsetc.
• Some daily admin tasks included verification of allBO user logins and security checks, testing the availability of all universe connections.
• Modified the defaultsession timeout, for the Infoviewas the users complained about being session timeouts frequently.
• HandledBOBJ Administration tasks, tocreate new users and groups and assign security.
• Created a stable environment for Business Objects XI 3.1 byscalingthe number ofprocessing serversbased on theuser baseandaccess frequency.
• Modified existingcrystal reportsand created new reports withcross tabs and sub reportsbased on the client requirements usingCrystal Reports 2008.
• Was involved in training the end users over the newly developed crystal and webi reports.

Environment: SAP ECC 6.0, ABAP/4, SAP BI 7.0, and Business Objects XI 3.1, Web Intelligence, Crystal Reports 2008, Crystal Reports Enterprise, CMC, CMS, Data stage 8.5

Confidential, Fortworth, Texas

Sr. SAP BOBJ Consultant

Responsibilities:

• Participated in project planning sessions with project managers, business analysts and Team members to analyze business requirements and outline the proposed solution.
• Designed and Document Universe and Report Requirements Definition templates, Security strategies, Migration strategies and Report Distribution strategies.
• Created Full client, WebI and Crystal Reports based on the END Users and Business requirements and Modified the existing Reports based on the specifications and requirements.
• Analyze the reporting requirements with the business users and the QA team and come up with the technical specifications for the BO Reports.
• Involved in Building universe, Inserting tables, Detecting joins, Detecting cardinalities and checked the integrity.
• Created universes, classes, objects, Prompts, Predefined conditions, by retrieving the data from data sources and defining the necessary connections.
• Involved in the troubleshooting of universe schema with loops, chasm and fan traps, and cardinality problems.
• Implemented the Object-Level Security and Row-level security in Universe. Implementing the Table Mapping in Universe to restrict certain data in a table to only one group of users.
• Designed and developed extensive Business Objects reports like Simple, Complex, Cross Tab using multiple Queries, Prompts, combination chart and tables.
• Created, maintained and modified the business critical reports using the Web Intelligence.
• Created Standard Reports utilizing all the features on Web Intelligence in BOE XI 3.1 like Optional Prompts, Functions, Alerters etc.
• Created complex reports using Merged Dimension and multiple data providers and synchronized the data providers by linking the common objects to create the common report.
• Extensively worked on Unix Shell Scripting.
• Responsible for creating the Deski and Webi reports (On demand, Audit Reports, Ad-hoc Reports, Summary Reports, Sub Reports, dynamic grouping, Cross-Tab, graphical, etc)

Environment: SAP Business Objects v XI R2 SP2,XIR3.1 SP3, Xcelsius 2008,Live Office, Crystal Reports 2008, Tomcat v5.0.27,v5.5,DB2 v8.2,v9.5,Data Stage 8.5, Oracle 10g

Confidential

SAP BO Consultant

Responsibilities:

• Involved in System Study & Business Requirements Analysis & Documentation.
• Interacted with the End Users, Business Analysts and responsible for Involved in training sessions to impart knowledge on designed universes and published reports.
• Creating, enhancing, and testing of universes and reports in coordination with DBA and architects.
• Used Designer to create Dimensional, Detail and Measure objects.
• Resolved loops in universe using contexts and aliases and also Implemented aggregate awareness function.
• Development of Dashboards using Crystal Xcelsius 2008.
• Created Dashboard, Chat and Containers, Selectors using the Xcelsius components.
• Created Dashboards using Filters, List View, table, Line, Column and Pie charts (combination bar graphs, combination bar and line graphs, and line graphs will be used to display metrics).
• Created the weekly tab will show the last 10 operating date, defaulting to the current calendar date
• Involved in creating Tables and relationships.
• Developed complex queries and reports using different data providers in the same report.
• Worked on the monthly tab which will show the last 8 weeks (4, 4, 5 calendar weeks) defaulting to the week that includes the current operating date.
• Involved in production supporting on various platforms like UNIX, Windows NT/2000/XP/98
• Worked on Dashboard Design and Development, capable of analyzing requirements documentation.
• Automated Excel sheet data using VBA to reflect on power point slides as various data graphs.

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

Confidential

SAP BO Consultant

Responsibilities:

• Analyzingsystem functionality requirements, documents and scope of the work.
• Work included Developing, Testing and enhancing existingBusiness 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 maintainingUniverse's with creation of joins, Cardinalities, Contexts, and solving the loops, Testing, Data analysis etc.
• Have resolvedloops, Fan Traps and Chasm trapsusing context and alias and also have built custom hierarchies and predefined filters to facilitate easy drill down and addressed performance issues.
• Created reports using Business Objects functionalities likeSlice and Dice, Drill Down, Cross Tab, Alerted and Formulae etc usingWeb intelligence.
• Scheduling daily, weekly and monthly reports usingBO XI Scheduler using Events, creating Calendars. UpgradedBO XI R2 to BO XI R 3.0Enterprise Environment. Used Java SDK's.
• Formatted Reports as per the User requirements using extensively the functionalities in Business Objects, which allows the users to analyze the data.
• UsedPolestarfor better interaction with predefined data sets to generate quick visualized reports
• Designed interactive Dashboards such asPopup, Tabs etcand many creatively styledXcelsius Reportsto best support needs using effectiveHCI Principles.
• Manipulating data through various presentation styles usingCrystal Reports 2008such ascharts cross tabs, slice and dice, user response, alerts, prompts, nested loops and filters.

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

Confidential

SAP BO Consultant

Responsibilities:

• Involved in developing, designing and maintaining new and existing universes with Classes and Objects using SAP BW Info Cubes.
• Preformed Business Objects XI upgrades and Migration from DEV, TEST to PROD.
• Debugged issues which resulted from Migration. Provided support in enhancement and maintenance of the Reports and Universes.
• Involved in SLD post installation and performed configuration of SLD server and persistence parameters and assigning SLD security roles and actions to users or user groups.
• Created Webi reports with multiple data providers and synchronized the data using merge dimensions.
• Updated the Universe as per the changes of the Database table and notified the users about changes made to the Universe.
• Build Webi reports with different functionalities like Dynamic cascading prompts, drill down, linking reports, charts and graphs, ranking and set alerter to enable exception highlighting in the reports for business conditions alerts.
• Extensively used Import Wizard to migrate the universes, corporate documents, users and groups from the legacy BO to the XI R3.1 version.
• Created complex reports using Desktop Intelligence and Webi XI3.1. Used Business Views, universes to create Crystal Reports for presentation purposes.
• Scheduled reports based on specific time, events and calendars in various formats such as Excel and PDF.
• Used the Publishing wizard to export different document types as objects to different folders in CMC.
• Used performance manager to build Dashboards and Score cards to provide the users with visual representation of corporate data.
• Developed Crystal Reports and formatted the same with respect to the requirements. Added parameters, special fields, formulae and used multiple data sources to create the reports
• Exported the Universes to the Repository to make resources available to the users.
• Created engaging, interactive dashboards and business presentations from ordinary spreadsheets via Crystal Xcelsius giving greater insight into data, hence ensuring audiences make smart decisions
• Interacted with business users to know their business views in developing and modifying Dashboards, Reports, Universes and User Security.

Environment: SQL Server 7.0, Oracle 9i, Business Objects XI, Business Objects Designer, Business Objects Supervisor, Infoview, Web Intelligence 2.7, Broadcast Agent, Broadcast Agent Publisher, Windows NT 4.0

Confidential

SAP BO Consultant

Responsibilities:

• Creating, developing, maintaining and testing theUniversefor running the queries against the Database usingDesigner.
• Involved in Installation and Configuration of all products ofBusiness Objects 6.5.
• Analyzed the existing database and designedUniverses using Designermodule for generating reports.
• Used various data providers like FreehandSQL and Stored Proceduresto extract data from different sources and tuned for better performance.
• Resolved loops by creatingAliases & Contextsand checked integrity of universes.
• Exported universes to the repository to making resources available to the users.
• Created reports using theUniversesand Free-handSQLas data providers.
• Involved in development and deployment of Complex Reports.
• Exported the Reports to theBroadcast Agentand used theBroadcast Agent serverto Schedule and Monitor the Reports which offered robust performance and ability to balance Loads.
• Generated analytical reports usingSlice and Dice, Drill Down, Cross Tab, Master Detail and Formulae features.
• Automated documentScheduling, Publishing and Distribution for Webi and Info Viewclients using Broadcast Agent server.
• UsedSupervisortoGrant User rights and rolesetc.
• Involved in optimizing theuniverse developing time and SQL Tuning to increase the query performance.
• UsedDesigneras a part of Universe Development for Defining the Parameters of Universe, Inserting the table, making Joins, Resolving Loop's, Creating Classes, and Objects.
• Involvedin 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, usingCrystal reports XI.

Environment: Business Objects 6.5, Designer, Webi, Full-client, broadcast Agent, Supervisor, Crystal reports XI, Oracle9i, PL/SQL, and Windows NT/X