SUMMARY

• Over 7 years of professional experience using SAP Business Objects4.0,XI - R3.1/R2/6.x with Info view, Web Intelligence, Data Integrator & Quality, Web Intelligence Rich Client, Desktop Intelligence, Crystal Reports 9/10/XI/2008, Xcelsius 4.5/2008, Central Management Console (CMC), Central Management Server (CMS), Central Configuration Management (CCM), Live Office, Business Explorer/Polestar XI 3.1, Publishing Wizard, Import Wizard and Report Conversion Tool.
• Technical expertise in Analyzing, Design, Implementation and administration of security models with row level data security, role based security etc in Business Objects Universes and Central Management Console (CMC).
• Extensively worked on Business Objects Architecture & Administration. Created Users and Groups and setting the rights on them using Central Management Console (CMC). Scheduled Crystal Reports in CMC on Daily, Monthly, Weekly basis..
• Worked through all phases of Business Intelligence projects including Analysis, Design, Development, Testing, Debugging in the problems in the crystal Reports and post production support.
• Good working knowledge in Migrating Universes, Reports to newer versions and Documenting the whole process during the project life cycle
• Created dashboards with multiple hyperlinks to various reports using Open Document Syntax. Experience in designing and implementing reports using Crystal Reports, Crystal Enterprise, Business Objects, MS Reporting Service.
• Extensive experience with SAP BW and Business Object Crystal Report like designing reports, automating report and scheduling reports.
• Extensive experience in SAP BW such as Info Cubes, Data Modeling, BEx Query designer, BEx Analyzer, Crystal Xcelcius and Business Object Live Office.
• Automating Xcelcius Dashboard using Web Service to pull data from SAP ECC, SQL Server, and Oracle database.
• Installed Crystal Xcelsius 2008 SP3 and developed dashboards using various components.
• Implemented Open Doc to drill down to detail WebI report from Xcelsius Dashboard.
• Expertise in building BI components like Info objects, data sources, Info cube, DSO, Transformations, Data Transfer Process (DTP), Multiproviders and Master data Info Objects, Transfer Structures, Communication Structures, Transfer Rules and Update Rules.
• Installed Business Content including Data Sources, Info Sources, Info Cubes, ODS objects, Update Rules and Queries.
• Solid understanding of data ware house concepts - star schema, snow flake designs,Dimensional modeling and fact tables
• Experience in user and content administration using Central Management Console and Infoview. Used import wizard to migrate reports across environments
• Having solid command in different Data Bases (Oracle, SQL Server, and Teradata).
• Developed test cases to perform unit testing and regression testing of crystal reports.
• Excellent PL/SQL and T-SQL skills. Experience in writing stored procedures in PL/SQL and T-SQL.
• Ability to communicate effectively with both technical and business users.
• Excellent communication, interpersonal, training, analytical and technical skills.

TECHNICAL SKILLS

BI Tools: SAP Business Objects XI (4.0/3.1)/XI R2/6.x/5.9, Crystal Report 9/10/ XI/ 2008,Xcelcius 4.5/2008, Info view, CMC, CCM, CMS, BEx Query, BEx Analyzer, Desktop Intelligence XI, Full Client, Web Intelligence, Business View Manager, SAP ECC 6.0, SAP BI/BW 7.0, Live Office

Databases: SQL Server 2000/7.0/6.5 , Terawatt, Oracle 10g, 9i/ 8i, Access, DB2

Languages /Web Technologies: Java, C, C++, SQL, PL/SQL, Visual Basic 6.0, UNIX Shell scripting, XML, VB, ASP

Data Warehousing: Star-Schema Modeling, Snowflakes Modeling, FACT, dimension tables, Toad

Reporting Tool: Bex/Bo 3.0&4.0/Crystal Reports

ETL tool: Informatica 5.1/6.1/7.1/8.0 (Power Mart/Power Center), BO Data Integrator (ETL), Data Services

GUI: Visual Basic 6.0,VB.Net

Products: SAP ECC 6.0/ BOBJ, SAP BI/BW 7.0, Microsoft Office, Erwin, Toad, Clarity, Epic

PROFESSIONAL EXPERIENCE

Confidential, Des Moines, IA

SAP BOBJ Developer/Admin

Responsibilities:

• Fulfilled Business Analyst requirements by Completing Universe Development Life Cycle to Prepare, Analyze, Plan, Implement, Test, and Deploy & Maintain to successfully develop Universes meeting User Needs and Requirements from both technical and strategic views of an organization.
• Involved in establishing SAP BW connectivity with Universe Designer and Business objects Infoview, using SAP integration kit. And also installed java connector to import the roles of the SAP user to Business objects.
• Performed day to day admin tasks like monitoring DB Services, creation of user groups and handled password resets, monitoring of user activities/ sessions, universe connection and availability checks.
• Conducted Study to Build Universe's Classes and Objects involving everyday terms that supports Users. Object properties defining Measure, Dimension and Details were created.
• Implemented Universes by detecting Cardinalities, resolving loops, Chasm Traps and Fan Traps using Contexts and Aliases, and also Developed Hierarchies to support users with the option to drill down on reports.
• Designed complex reports based on discussions with 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.
• Involved in creation of Reports, formatting reports, generation of charts, bars as per user requirements using Webi, Xcelsius 2008.
• Developed new set of standard Web Intelligence reports against the new universe. Completed ad-hoc data requests as required.
• Involved in writing scripts and also used some built-in functions like To Date, lookup, key generation and Custom Functions like checking whether the load is an initial load or a bulk load.
• Creating complex Data flows with inner R/3 data flows and declaring parameters at different levels of Workflow.
• Creation of different data stores to get SAP tables.
• Used Business Objects Data Integrator XI R2 for ETL extraction, transformation and loading data from heterogeneous source system.
• Used BEx Analyzer and Query Designer to Query and analyze SAP BW OLAP Cubes.
• Developed Dashboards using Xcelsius 2008 components using maps, Pie Charts, Staked Bar, List Views creatively using best Xcelsius components effects for better interaction.
• Performed ETL activities using Data Integrator and Data Services, by extracting data from various Sources.
• Worked on Polestar to generate complex reports for the data required. Simultaneously export reports and making it easily available to Decision makers.
• Design, develop, and implement Xcelsius dashboard against SAP BW data sources. Established the design pattern for all future Xcelsius development using Live Office
• Developed Cross Tab Reports, Sub Reports by using Crystal Reports 2008 and embedded Xcelsius onto Crystal Reports for better results and also provide users with clear understanding.
• Worked on certain issues and dealt with Info View, CMC.

Environment: -SAP Business Objects XI 3.1/3.2,Xcelsius 2008, Crystal Reports 2008, Data Integrator & Services, Web Intelligence, Business Explorer (Polestar) XI 3.1, SAP BI/BW 7.0, T-SQL, Oracle PL/SQL, Info View, CMC.

Confidential, El Segundo, CA

SAP BOBJ Developer

Responsibilities:

• 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.
• Created reports using Business Objects functionalities like Slice and Dice, Drill Down, Cross Tab, Alerter and Formula using Web intelligence.
• Scheduling daily, weekly and monthly reports using BO XI Scheduler using Events, creating Calendars. Upgraded BO XI R2 to BO XI R 3.0 Enterprise 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.
• 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 in Creating Reports, formatted old reports, generated charts, bars as per user requirements using Crystal Reports 2008, Xcelsius 2008 and integration as well.
• Designed interactive Dashboards such as Popup, Tabs and many creatively styled Xcelsius Reports 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, Crystal Reports 2008, Web Intelligence, Business Explorer (Polestar) XI 3.1, SAP BI/BW 7.0.

Confidential, Hartford, CT

BUSINESS OBJECTS 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 6.5.
• 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 Info View 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.

Environment: Business Objects 6.5, Designer, Webi, Full-client, broadcast Agent, Supervisor, Oracle9i, PL/SQL, and Windows NT/XP.

Confidential

BUSINESS OBJECTS CONSULTANT

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Designing and development of Universes for forecasting the selling margin.
• Defined Derived Tables, Aliases, Classes, Objects, Dimensions, Measures, Details, Conditions, Joins, and Contexts. Creating complex objects, aggregate navigation, @prompts, @variables, and resolving traps (chasm/fan) among others and Verifying Integrity of universes.
• Developed Business Objects Universes with classes, objects and condition objects and developed hierarchies to support drill down reports.
• Extensively used the Business Objects functionality such as Master-Detail, Slice and Dice, Drill Down and Hierarchies for creating reports.
• Created the Universes using Business Objects Designer.
• Created reports using Business Objects functionality like slice and dice drill down, cross tab, master detail tables and formulas, etc.
• Involved in scheduling of documents monthly, weekly and daily through Broadcast agent.
• Developed Business Objects Universes with classes, objects and condition objects and developed hierarchies to support drill down reports.
• Designing logical and physical data model, building data mart and data transformation by ETL
• Responsible for Creating Complex using Master/Detail, Cross Tab, Slice and Dice, and Sub Queries.
• Extensively used Alerts, filters, Variables, Prompts, and also generated hyperlink reports using Webi.
• Maintained existing reports and Created standard template for all reports.
• Provided production support for the existing reports/universe and modified them when needed.
• Developed standard canned, Adhoc reports & crystal reports

Environment: BO XIR2, Designer, Web Intelligence, Desktop Intelligence, Info View, Import Wizard, CMC, Oracle 10g/9i, Windows XP