SUMMARY

• Over 6 Years Of Experience in SAP BI, Business Objects, Crystal Reports and Xcelsius as lead with experience in deployment and developing business processes and system solutions for Financial, Pharmacy, Retail, Manufacturing verticals
• Excellent Experience working on Business Objects Suite BI 4.0, BI 4.1, XI 3.1 & XI R2 (Web Intelligence, Desktop Intelligence, IDT, UDT, BI Launch Pad, Info View, Promotion Management, Report Conversion Tool, Import Wizard & CMC)
• Strong Experience (over 3 years) in developing Highly Formatted Reports using Business Objects Version 4.1
• Experienced in Universe Design using IDT and UDT with Multiple Data Sources
• Expert in utilizing Import Wizard, Promotion Management and Report Conversion Tools to migrate the Universes and Reports between different environments like Development, Quality and Production
• Experienced in Installation, Configuration Of BO Tools, Set - Up and Maintenance of Business Objects Enterprise Environment
• Worked on Business Objects with Databases like SQL Server 2005, Oracle, Sybase, Teradata and DB2.
• Developed WebI and Crystal Reports on BEx Queries using BICS connection
• Strong experience to Create Universes, Classes and Objects by retrieving data from the backend SAP BW data source
• Excellent skills to develop reports using Web Intelligence Rich Client 4.0 and 4.1
• Strong experience in Business Objects Reporting using Crystal Reports, Web Intelligence Rich Client, Live Office and Xcelsius for both SAP and Non-SAP sources.
• Tuned And Enhanced Universes With SQL Queries for the Report Performance
• Strong Skills In SQL and creating complex ad-hoc Reports using Business Objects Reporting Tools
• 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
• Proficient in Creation of Cardinalities, Contexts, Joins and Aliases to resolve Loops and Traps in Universe Design
• Created Universe-Level, Query-Level and Report- Level Filters to restrict data based on Business Requirements
• Strong Knowledge in designing and developing Data Marts, Data Warehouse using Multi-Dimensional Models such as Snow Flake and Star Schema
• Expertise in developing reports that includes Complex Calculations & Formulas, Variables, Input Controls, Grouping, Ranking, Section, Breaks, Alerting, Drill-Down and Prompts
• Experienced in implementing Object-Level Security and Row-Level Security profiles in Universe Design
• Excellent Skills to Develop, Schedule and Publish Reports using CMC and BI Launchpad
• Solid Knowledge on both Analysis For Office and OLAP
• Extensive Experience in creating Dashboards in Xcelsius by using QAAWS, Live Office and BI Service.
• Experienced in Xcelsius for creating Dashboards including Alerts, Drill-Down, Filtered Rows and Dynamic Visibility
• Experience in Creation Of Users, Groups and maintaining User Access Rights by using Central Management Console
• Have good knowledge of SAP Lumira and Design Studio
• Involved in several full life cycle implementations and Production Support projects
• Wide experience in interacting with end-users to gather and document the reporting requirements and giving training to the end users
• Excellent Communication Skills, Interpersonal, Analytical & Problem-Solving Skills, Quick Learner with Excellent Work Ethics, Team-Oriented with Strong Analytical Skills

TECHNICAL SKILLS

Reporting Tools: Business Objects BI 4.0, BI 4.1, XI 3.1 and XIR2, Information Design Tool(IDT), Universe Designer, Web Intelligence, BI Launchpad, Infoview, Import Wizard, LCM, Promotional Management, Report Conversion Tool, Crystal Reports 2008 and 2011, XCelsius2008, Dashboard Designer 4.1 & 4.0, SAP Lumira, SAP Design Studio

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

Databases: SAP-BW, Oracle 9i,11g10g, SQL, DB2, Teradata, MS Access

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

SAP BO Lead Developer

Environment: Crystal Reports, Xcelsius, Webi, 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 Webi 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 Lifecycle including Dashboards and KPIs in Crystal Xcelsius.
• Successfully Performed Migration of Business Objects XI 3.1 to BI 4.1
• Created Webi 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 for Operational Risk Reporting. Created Web Intelligence Reports for the end users.
• Converted Analysis For Office reports into 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 Webi 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, Houston, TX

SAP BO Consultant

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

Responsibilities:

• Designed and Developed Webi Queries and Webi Reports. From Standard and Custom Universe
• Enhanced the Standard Universe for Webi Reporting
• Webi Reporting Design and Scheduling, Developed with Customer And Material Hierarchy
• Webi Reporting Designed and Developed for Profitability Analysis, and Financial Analysis
• Generated Webi 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 SAP BI and SAP BO Reporting
• Performance Tuning done on Webi Reports developed using Infoview Webi.
• Created Dashboard for Profit Analysis using Xcelsius.
• Performance Testing done in all the Application Servers
• Backup Plan created for the Client Development and Production System
• Business User Training and Best Practice Developed for the Client

Confidential, New Brunswick,NJ

SAP BO 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.
• Published them using 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. 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 Advanced Analysis For OLAP.
• Solid Knowledge on both Analysis For Office and OLAP.
• Extensive experience in creation of 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, Data Validation Testing and Prepared Documentation.