SUMMARY

• 7+ years of experience in Business Intelligence using SAP Business Objects.
• 2+ years of experience in building dashboards using SAP BOBJ Dashboards 4.0/Xcelsius 2008 using Query as a Web Service (QAAWS) & LiveOffice.
• Expertize on different versions of Business Objects: 4.0/XIR3.1/XIR3/XIR2/XIR1/XI
• Experienced in Installation, Administration, and Configuration of BusinessObjects XI 3.1 Enterprise Products on Windows environment.
• Good experience in Business Objects Administration. Creating the security model, creating Users and User Groups and assigning security using Custom Access levels in Central Management Console (CMC).
• Expertize on Business Objects tools such as: Web Intelligence, Universe Designer, Desktop Intelligence, Crystal Reports etc…
• Performed two life cycle implementations of Data warehousing projects from Requirement Analysis to delivery of Reporting Solutions.
• Strong understanding of Data warehouse concepts such as Star Schema, Snowflake Schema and Multi - Dimensional Models for query and analysis requirements.
• Experienced in building Universes from Both Relational and Datawarehouse databases.
• Performed Migrations from XiR2 to XI 3.1 and recreated security Model in Xi 3.1.
• Experience in working in an onsite/offshore set up and coordinating with offshore team for report/dashboard/universe deliverables.
• Experienced in interacting with business users to analyze the business process and requirement and transforming requirements into screens, designing, documenting and rolling out the deliverable.
• Multiple project experience in handling production support issues.
• Experienced in setting up Unit Test Case, Integration Test, User Acceptance Test (UAT).
• Proficient in multi-tasking and handling responsibility with minimal direction from supervisors. Efficient in providing team leadership, motivation and development.
• Strong Communication Skills, Excellent Oratory and Presentation Skills, Organizational and Team Leadership skills, Experience in Marketing and Direct Sales.

TECHNICAL SKILLS

Business Objects Tools: SAP BusinessObjects (SAP BOBJ) XI R2/3.1/4.0 Central Management Console, Central Management Server, Web Intelligence (Webi), Desktop Intelligence (Deski), Info View, BI Launch pad, Import Wizard, Universe Design Tool, Universe Designer, Xcelsius, SAP BusinessObjects Dashboards 4.0, SAP BI7.3, ECC6.0, Report Conversion Tool, Crystal Reports 2008, Query as a web service (QAAWS), Live Office

Operating systems: Windows 2008, Unix

Data Base: Oracle 10g/9i, SQL Server 2005/2008, DB2

Web Servers: Tomcat Apache

Languages: SQL, HTML, Java

Spoken Languages: English & Conversational Spanish

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

Business Objects Consultant

Responsibilities:

• Gathered requirements from the end users of different business units.
• Responsible for the Design phase of the universe and reports.
• Interacted with the Project Manager, Business Analysts and end users in finalizing the Report, Universe & Dashboard requirements.
• Designed and developed complex Universes, and identified most commonly used queries to design/define the Aggregate Tables.
• Implemented Aggregate Awareness using 8 Aggregate Tables.
• Used Derived tables as needed to simplify the universe structure.
• Created prototype dashboards, Visual Models and passed on to offshore resources.
• Designed Business Objects reporting solutions: Web Intelligence, Crystal Reports & Xcelsius
• Developed few complex reports which included WEBI and Crystal with multiple parameters and custom SQL wherever required. Created various filters at both Universe and report levels when required.
• Coordinated directly with offshore resources and worked as a QA for the delivery of the universe & reports.
• Delivered 10 Management Pack reports pertaining to Trial Balance, Accounts Receivables, and Labor & Revenue.
• Trained client resources and end-users on reporting and designer tools.
• Created Best practices document for Report, Universe & Dashboard creation.

Environment: Business Objects Xi 3.1/4.0, Xcelsius 2008, SAP Dashboards 4.0, Oracle 10g, SQL Server 2008, Web-Intelligence, Crystal Reports, Desktop Intelligence, UniverseDesigner, Windows 2008.

Confidential, Malvern, PA

Business Objects Consultant

Responsibilities:

• Created Universes from SAP BW/BI for Ad-hoc users and trained users and explained the different functionalities of business objects and crystal reports and how to use Ad-hoc reporting.
• Created Dashboards for Top management using Live Office, QAAWS connections.
• Created Crystal Reports usingSAP Netweaver business warehouse system
• Used best practices for improving the performance of the SAP universe.
• Created different variables depending on the requirements.
• Developed few complex reports which included WEBI and Crystal with multiple parameters and custom SQL wherever required. Created various filters at both Universe and report levels when frequired.

Environment: Business Objects XI 3.1, SAP BI 7, ECC6.0, Universe Designer,, Web Intelligence, Crystal Reports2008, Xcelsius2008, Live Office, QAAWS.

Confidential, Windsor CT

SAP BO Administrator

Responsibilities:

• Created the security model which included the content plan, and Access Control list for the project.
• Implemented row level security on specific restricted usergroups.
• Maintained administration of users, usergroups and folders and Applied access rights on folders, applications, universes & connections for specific usergroups.
• Created Custom Access Levels for the client needs.
• Scheduled reports based on file events and used profiles/publications for report bursting.
• Created audit reports and monitored the SAP BO servers.
• Created additional server processes based on the server sizing guide.
• Implemented BIAR back up for development, test & production servers - This back up would be retained for about a week. This is in addition to the repository/File Storeback up managed by network administrators.
• Setting up the configurations for publishing process for the Crystal Reports.
• Involved in managing users, groups, folders and published reports using crystal management console, in exporting and scheduling of reports using Crystal Enterprise. Also installed, tested, and maintained Business Objects XI (including Crystal) client and server Software. Participated in design meetings and code reviews.
• Assisted the team that set up AD authentication & configuring the Single Sign On (SSO).
• Responsible for production support and resolving/trouble-shooting issues.
• Applied Service Packs and upgraded from one version to a higher version of SAP BO software.

Environment: SAP BOBJ 3.1, Central Management Console, Web Intelligence, Desktop Intelligence, Crystal Reports, Tomcat, Oracle 11g & Windows Server 2008.

Confidential, Norwood MA

Business Objects Migration Consultant

Responsibilities:

• Migration of Universes, Reports, and Users from BO Xi R2 to BO XI 3.1.
• Created the Migration Implementation Plan
• Was responsible for the Assessment, Migration & Post migration phase of the project
• Deployed Business Objects (BOBJ) Servers in Development, UAT and Production environments.
• Tested and implemented Service Packs and Fix packs to resolve identified issues and bugs in BusinessObjects XI 3.1
• Extensively used Designer to design various universes for different groups.
• Involved in creating Test plans and test scripts for User Acceptance Testing.
• Extensively used the Import Wizard to migrate the universes, corporate documents, users and groups to the XI 3.1 version.
• Scheduled the reports in various formats in CMC for recurring reports.
• Created & customized existing reports using sub-reports and charts to present information.
• Converted Desktop Intelligence reports to Web intelligence
• Re-migrated failed reports to the new 3.1 environment
• Fixed the webintelligence reports during post migration phase.

Environment: Windows Enterprise Server 2003 Apache Tomcat, SAP BusinessObjects (SAP BOBJ) Enterprise XI 3.1SP2 (Designer, Desktop intelligence, Web Intelligence, Import wizard, Publishing Wizard, Report Conversion Tool), Oracle 10g.

Confidential, Auburn Hills, MI

Business Objects Developer

Responsibilities:

• Gathered, analyzed, and documented business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Designed Universe and migrated existing Desktop Intelligence (Deski) Reports to Web Intelligence (Webi) report.
• Set up the security levels to the BOBJ users in universe module like row level and object level security.
• Designed & developed financial dashboards (Balance Sheet, Profit and Loss) using best dashboard design practices.
• Used BO Designer Module to implement Universes, linkages between tables, creating prompts and queries, parsing the Universes, applying contexts and alias tables to remove cyclic dependencies.
• Created simple and complex reports including dynamic calculations involving Contexts, Queries, Hierarchies, List of Values (LOVS), local variables, Alerts, Ranking and multiple data.
• Created multiple Flash variables in Xcelsius and used them to pass data from one dashboard to other.
• Created dashboard reports on ROI, actual and plan cost analysis, profit analysis on operating concern level and profit center level.
• Performed and coordinated System Integration Testing (SIT) and User Acceptance Testing (UAT).

Environment: SAP BusinessObjects (SAP BOBJ) Enterprise XI R2 SP3 (Designer, Desktop Intelligence, Web Intelligence, Info View, Import wizard, Publishing Wizard, Report Conversion Tool), Xcelsius 2008, SQL Server 2005, Oracle 10g.

Confidential, Peoria IL

Business Objects Developer

Responsibilities:

• Created Complex reports using diverse business objects functions such as slice and dice, Master/detail, crosstab, user responses, formulas, Multiple dataproviders and Combined Queries.
• Used features such as custom SQL, free hand SQL and stored procedures to build reports in WEBI and DESKI.
• Used natural and customized hierarchies in the universe to build reports with drill down and drill through functionality.
• Created reports using Desktop Intelligence functionalities like Sections, Breaks, Filters, Alerters, slice and dice, drill down functions and formulas etc.
• Created linked reports for WEBI reports using open document functionality.
• Performed documentation for the Business Objects Enterprise System, design, development, test plan, implementation and maintenance.
• Participated in all BI Testing cycles which involved unit testing, system integration testing, regression testing.
• Responsible for handling production support issues.
• Determined best solution and tools to best meet BI business requirements.
• Developed Mutiprovder for reporting all the lease accounting and sales contracts data.
• Developed various complex BI reports to display the leasing summary, Amount financed, Equipment listings.
• Developed training manual for end users.

Environment: Business Objects 6.5, Full Client, Supervisor, BO XiR1/XiR2, Desktop Intelligence, Web Intelligence XI R2, Designer XiR2,Oracle 9i, Import Wizard, and CMC.