PROFESSIONAL SUMMARY:

• SAP BOBJ Consultant with over 5+ years of experience.
• Expertise in gathering business requirements, systems analysis, systems design & solution architecture, developing solutions for complex business applications through all phases of the system development life cycle
• Involved in 4 full life cycle implementation, which includes Gap Analysis, Requirement gathering, Blue printing, Development, Testing, Reporting, Go - Live and Post Go-Live Support.
• Experience in creation of Reports and Dashboards on top of BI/BEx Queries.
• Excellent Experience working on Business Objects 4.0/4.1, Releases XI R2/3.1/4.0 SP2, SP4 and SP5 (CMC, CCM, CMS, LCM, Promotion Management, Information Designer tool, Business Intelligence Consumer Services (BICS), Universe Design (Unv and Unx), Web Intelligence 4.0/4.1, Business Intelligence Web Services (BIWS), Report Conversion Tool, Crystal Reports, Dashboard Design using Xcelsius, Live Office, Query As a Web Service (QaaWS), SAP Business Objects Explorer.
• Strong work experience in Dimensional Modeling, and designing Star and Snowflake Schemas, Fact and Dimension tables.
• Experience in using Information design tool (IDT), to create universes using multiple Data Sources.
• 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/4.1.
• Developed WEBI and Deski reports on SAP BW Queries using BICS.
• 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 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.
• Worked on migration of the Business Objects from lower versions to XI R2, 3.0, 3.1, 4.0,4.1
• Worked on Business Objects with Databases like SQL Server 2000/2005, Oracle, Sybase, flat files, Teradata and DB2.
• Excellent analytical, time management, interpersonal skills and a good team player with excellent oral and written, leadership skills communication skills.
• Wide experience in interacting with end-users to gather and document the reporting requirements and giving training to the end users.
• Assistance in creating one or more Lumira storyboards that can serve as models of what is possible in Lumira using the launched data sources
• Assistance in defining how to set up a Lumira knowledge center.

TECHNICAL SKILLS:

Reporting Tools: BOBJ WEB Intelligence, Cognos 8.x/7.x, TM 1 (Impromptu, PowerPlay), Business Objects XI 3.1(Web Intelligence, Xcelsius) BEx Reporting, Web Reporting & BW 3.5/3.x/2.x,, Crystal Report 7.X/8.X, Tableau, Microsoft BI, Qlikview

Operating Systems: Microsoft Windows XP/Server 2003/2008/Linux, Unix

Databases: Oracle, SQL, DB2 and MS-Access

WORK EXPERIENCE:

Confidential, Boston, MA

SAP BI/BO Developer

Environment: Crystal Reports, WebI Reports, Oracle11g

Responsibilities:

• Extensively worked on Business Objects Enterprise (BOE) BO XI 4.1 for reporting purposes.
• Created Web I reports with Complex Calculations and Worked on creating Variables, Structures and Prompts in WebI also worked extensively on thorough analysis using cases and sequences.
• Involved in 3 full life cycle implementation, which includes Gap Analysis, Requirement gathering, Blue printing, Development, Testing, Reporting, Go-Live and Post Go-Live Support.
• Understanding the business challenges and translating them into requirements and developed Analytics and Reporting Queries according to Business Requirements.
• Created and enhanced new and existing Analysis Process Designs (APD) to load the data into direct update DSO and further into Metrics using DTP’s.
• Created Web Intelligence reports and processed them to next level for reporting
• Designed universes and created Web Intelligence documents for queries developed on the commission data.
• Performed unit testing on the complete data flow of the model developed from source system through BI. Involved in user acceptance testing and data validation testing and prepared documentation.

Confidential, Atlanta, GA

SAP BO Lead Developer

Environment: Crystal Reports, Xcelsius, WebI Reports, Design studio, Live Office, Oracle 11g/10g

Responsibilities:

• Extensively worked on Business Objects Enterprise (BOE) BO XI 4.0/4.1 for reporting purposes.
• Interacted with senior management and business leaders to elicit business and technical information in order to produce high quality decision making solutions.
• Responsible in providing leadership, guidance, and mentoring for a team of 4 Business Intelligence members
• Extensively Worked in SAP Live Office to create connections b/w WEB I and Xcelsius Dashboards.
• Extensively worked on SAP QAAWS used in mapping data directly from Universe to Xcelsius Dashboards.
• Created Xcelsius Dynamic Dashboards over SAP BI data.
• Implementation of Full life cycle including Dash boards and KPI’s in Crystal Xcelsius.
• Created Web I reports with Complex Calculations to get Alerts for Xcelsius Dashboards.
• Worked on creating Variables, Structures and Prompts in webI also worked extensively on thorough analysis using cases and sequences.
• Created complex webI reports with multiple queries, custom SQL, using complex functions, merging dimensions at report level, drill down, drill up, drill across and complex filters. Also deployed those reports (Mobile reports) on IPad.
• Involved in Conversion of Deski reports to Webi reports using Report Conversion Tool.
• Developed universe from Oracle Database (RDBMS) for the Operational Risk Reporting purpose to Create Web Intelligence Reports for the end users.
• Converted analysis for office reports in to Design studio applications.
• Used various components of Design Studio like charts, crosstabs, popups, filter panel, tabstrip, and dropdown box to create visually appealing reports.
• Worked on creating web I reports with Variables, Prompts, Breaks, sections, and Custom SQL functions as per Report specifications.
• Developed report environments, reports and dashboards based on the operational data stored in the data warehouse.
• Created Web Intelligence reports by using all business objects functions.
• Configured the Crystal Reports job server to process report objects and generate report instances.

Confidential, New Brunswick, NJ

SAPBO Consultant

Environment: Business Objects XI 3.1,4.0 (BOBJ), Oracle 11g/10g, Crystal Reports, Xcelsius, WebI Reports

Responsibilities:

• Developed BO Classes, Objects in the Universe, defined cardinalities, Contexts, Joins and Aliases. Resolved loops in Universes using Table Aliases and Contexts.
• Provided hands on leadership, direction and guidance to design and develop a sustainable Enterprise wide Business Intelligence reporting framework and solutions
• Created universes, classes and objects by retrieving data from the data sources like BW queries and defining necessary connections.
• Responsible for developing Analytical reports with multiple parameter fields, multiple expressions and multiple grouping for hierarchy levels and publishes them using the Business Objects Enterprise (BOE) XI.
• Involved in full life cycle implementation, which includes Gap Analysis, Requirement gathering, Blue printing, Development, Testing, Reporting, Go-Live and Post Go-Live Support.
• Understanding the business challenges and translating them into requirements and developed Analytics and Reporting Queries according to Business Requirements.
• Created Web Intelligence reports and processed them to next level for reporting.
• Expertise in Dashboard Design, Web Intelligence and Advance Analysis for OLAP.
• Solid Knowledge on Both Analysis for office and OLAP editions.
• Extensive experience in creation Analysis Workspaces and Analysis Views using Advanced Analysis for OLAP.
• Designed universes and created Web Intelligence documents for queries developed on the commission data.
• Created many test cases and test scenarios for Unit testing, Integration testing of many BI reports. Performed unit testing on the complete data flow of the model developed from source system through BI. Involved in user acceptance testing and data validation testing and prepared documentation.

Confidential, Houston, TX

SAP BO Consultant

Environment: BO XI 3.1/4.0, Crystal Reports, Live Office, Xcelsius, Design Studio, WebI Reports

Responsibilities:

• Design and developed Web-I query and Web-I Reports from standard and custom universe
• Enhanced the standard universe for the Web-I reporting
• Web-I Reporting design and scheduling for designed and developed with Customer and Material Hierarchy
• Web-I reporting design and developed for profitability analysis, and financial analysis
• Generated Web-I Reports using the Universe as the main Data provider and also using the personal data files provided by the users
• Designed Universes for Financial billing system, Sales Order processing and Sales analysis by location, Sales Analysis by country reports
• System design and data model developed in SAP BO XI 3.1/4.0 for Actual and Plan data model developed for reporting in SAP BI and SAP BO reporting
• Performance tuning is done on Web-I reports that developed using Info View Web-I.
• Created Dashboard for profit analysis using Xcelsius.
• Performance testing developed in all the application servers
• Backup plan for execution created for the client development and production system
• Business user Training and Best practice developed for the client BOBJ XI 3.1/4.0 and BI Universe, Java Info View.

Confidential, Thousand Oaks, CA

BO Consultant

Environment: BO XI 3.0, Crystal Reports, Live Office, Xcelsius, WebI Reports

Responsibilities:

• Design and developed query based and Info Provider based Universe and Web-I Reports
• Web-I reporting design and developed with customer and Material hierarchy
• Build the New universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections
• Developed dashboards using Xcelsius 2008 and published in intranet portal
• Live office connection and Query as a Web Service implementation completed in Development Server and Production server completed
• Xcelsius 2008 installed in client system as well as Develop and Production App server
• Universe Query and Web-I Query used to develop excel file data to create custom Xcelsius dashboard
• Performance testing developed in all the application servers