Summary:

• Over 7+ years of experience in SAP Business objects with strong emphasis on SAP BW 3.5,7.0, Business Objects Enterprise XI R2, XI 3.1 and 4.0, Web-Intelligence, Crystal Reports, OLAP, and SQL SERVER for clients in Financial, Manufacturing , Retail and Business service industries
• Over 5 years of experience in Developing Xcelsius Reports and BI services.
• Over 3+ years of experience in developing SAP reporting and warehouse solutions.
• Extensively worked on client tools like Desktop Intelligence, Web-Intelligence, Info View, Universe Designer, CMC, and Xcelsius Dashboard.
• Implemented 2 full life cycle implementations on SAP Migration projects, starting from Blue printing stage to Production using Life Cycle Manager.
• Good understanding of BW solution modeling that includes ETL, DSO, Info set, Info Providers, multi provider.
• Extensively used SQL for report optimization and strong knowledge of layered architecture in BI.
• Extensively worked on planning, analyzing, designing and build reports using SAP Business Objects Enterprise Tools on top of SAP BW and relational databases.
• Extensively worked on BI backend and BO frontend reporting (Web- intelligence, Crystal Reporting 2011 and Crystal Reporting for Enterprise 4.0, Dashboards).
• Prepared Technical specifications for the development of Universes and Reports.
• Worked on several projects using BW BEx and BO Product Suite SAP-BO, XCELSIUS, CRYSTAL and WEBI to generate reports.
• Good understanding of BO administration in 4.0, 3.1, R2 and analysis tools such as APD .
• Good knowledge of SAP BCM for business communication.
• Experience in fetching data using extractors from multiple data sources such as Database tables/ views, Query, different functional modules – MM, SD, HR and FICO and generated reports etc.
• Strong knowledge in BW concepts like data modeling, Info providers, Star Schema, Snow Flake, Fact Constellation, Dimension and Fact tables.
• Experience in creating Customized and Adhoc reports using Business Objects Full Client and Web Intelligence (WEBI) tool.
• Knowledge of functional global supply chain management.
• Extensively used Business Objects reporting functionalities such as Master/ Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
• Extensive experience in front-end BW Components like Queries, Calculated Key figures (CKF), Restricted Key Figures (RKF), Structures, Variables, Exceptions, Conditions, RRI - Jump queries and Web Application Designer (WAD) etc.
• Knowledge of SAP BW BWA that helps to improve the performance of BW queries.
• Strong leadership and organization ability for development of well-defined processes, requirements gathering, implementing SDLC methodology, Scrum methodology, analyzing business needs and delivering solutions.
• A team player having ability to work independently, strong communication, analytical thinking, problem solving skills and priorities needs/ risk delivering solutions.

Technical Skills:

BI : SAP BI 7.3,7.0/3.5

SAP Tools : BEx Query Designer, Web Application Designer, SAP data warehousing, SAP Business Objects Designer, Web Intelligence Rich Client (WEBI), Desktop Intelligence (DESKI), Query as a Web Service (QAAWS), Info View, Xcelsius, OLAP, OLTP.

Reporting Tools: SAP BW BEx Analyzer, Business Objects 4.0, XI 3.1(R3.1)/R2/R1/6.x, Crystal Reports XI, Crystal reporting 2011 and Enterprise 4.0, Xcelsius, Central Management Console, Designer, Web Intelligence.

Databases: Oracle 11.2/10g/9i/8i/8.0/7.x, MS SQL Server 2005/2000, SQL Loader, SQL*Plus, PL/SQL and oracle DBMS Packages, MS-Access, XML.

Programming/Web Technologies: Visual Basic 6, PL/SQL, HTML, JavaScript, MS Front Page.

Environment: MS Windows 95 – 2000, MS- Windows NT/XP, Unix.

Methodologies: Object Oriented OOP, Client Server, n-tier Architecture, SDLC

Professional Experience:

Client: Confidential,Sept 2012 – Till Now
Sr.Business Objects Developer

• Responsible for gathering the requirements from the users and preparing the specs and schedule docs.
• Migrated Business Objects XI 3.1 version reports to Business Objects XI 4.0 with proper pre and post migration plans using life Cycle Manager (LCM).
• Migrated universes and reports from DEV to PROD and QA environments from BO XI 3.1 to BOXI 4.0 version to their respective folders using Import and Repository Migration Wizard.
• Pointed Crystal reports 2011 from DEV to QA or PROD by updating links.
• Extensively worked on BW BEx and Crystal Reports For Enterprise 4.0 that includes understanding data architecture, data modeling and providing support in development and production environment
• Involved integrating and creating Universe design against Oracle Database using Aliases and Context to resolve loops.
• Maintain and optimize universe using SQL queries, query stripping.
• Designed Universes in BO 4.0 using information design tool (IDT) that includes creating Relation or OLAP Connections, Data Foundation layer, Business Layer, Folders and Objects, employing integrity check.
• Ability to pull data using extractors from multiple sources like database tables, BI, ECC functional modules such as SD, HR, and MM.
• Generated queries for reports using BEx query designer, to do drill-down analysis and formatted these reports with web application designer (WAD) for publishing over web.
• Configured calculated key figures (CFK), structures, variables and calculated key figures in Crystal Reports Enterprise.
• Resolved Universe problems like Loops, chasm trap, fan trap using Alias and context.
• Developed complex WebI and Crystal reports with reports level context to control numbers according to user’s requirements.
• Extensively used SQL queries, procedures for analysis.
• Created OLAP Universes Based on SAP BI System (SAP BEx Queries, Multi Providers…).
• Extensively worked on Universe Optimization by either analyzing report SQL or report query.
• Tested BOBJ Universes and reports by checking back source in ECC through BW.
• Developed business reports like Drill down, Chart reports, and Cross-Tab Charts, slice and dice reports using Crystal Reports and WebI.
• Used Central Management Console and Publishing Wizard for scheduling the reports on Business Objects Enterprise System and published several reports for On-Demand as well as recurring viewing.
• Provided end user support and problem resolution for various issues related to BO.
• Involved in the User Acceptance testing (UAT) to check the reliability for end users.

Environment:
UNIX, SAP Business Objects XI 4.0 (Information design tool, Web Intelligence, Info View, Crystal Reports for Enterprise 4.0, Crystal Report 2011, Dashboard Design), SAP BW 7.0, BEx Analyzer, BEx Browser, Windows XP Oracle 10g, XML.

Client: Confidential,DE Dec 2011 – June 2012
Sr.Business Objects Developer

• Collaborate and meet with business analyst, team leader, internal staff and external consultant to clearly understand layered architecture and client business requirements.
• Clearly translate business and functional specifications into detail technical specification.
• Actively participated in migration of BO XI 3.1 to 4.0.
• Used extractors to pull data from multiple sources like BI, ECC functional modules such as SD, MM,HR and other systems and merge the data for reporting in BOBJ tool by using APD process in SAP BI.
• Developed hierarchies in BW to support drill down reports.
• Actively participated in Universe Designing in BO4.0 using IDT and generated ad-hoc reports by integrating systems and interfaces.
• Performed administration in BO such as tuning for 300-400 users with a desktop reporting tool.
• Created OLAP Universes Based on SAP BI System (SAP BEx Queries, Multi Providers…).
• Supported BW solution modeling that includes ETL, DSO, Info set, Info Providers, multi provider.
• Design reports in BEx Query Designer while making using of Calculated and restricted key figures (RKF), calculated key figures (CKF), formula/ Selections, Structures, exceptions, conditions and variables.
• Analyzed report query and report SQL for universe optimization.
• Also integrated BO with SQL server and creating Universes using aliases and context.
• Extensively used ANSI SQL skills such as quires, stored procedures, indexing functions and data modeling experience.
• Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, @Functions, Custom sorts, Cross Tab, Master Detail and Formulae\'s etc.
• Developed WebI reports that translate of data from current platform to integrated system that supports all other business needs.
• Using WebI developed cross tab, sub- reports, PIE and BAR chart with Drill down Option using Drill down Report Expert.
• Created Dashboards reports based on different data source such as Excel, BEx quires and BO4.0 that helps users with unique business information.
• Used SAP BCM for reporting extracts, transform and load process.
• Tested BOBJ Universes and reports by checking back source and performing integrity test.
• Scheduling various numbers of reports for daily, weekly and monthly runs.
• Troubleshoot problem areas and efficiently solve them in timely manner

Environment:
UNIX, SAP Business Objects XI 4.0 (Web Intelligence, Info View, Crystal reporting, Dashboard Design), SAP BW 7.0, BEx Analyzer, BEx Browser, Windows XP SQL Server 2008.

Client : Confidential,Boston, MA Oct 2010 to Nov 2011
Sr.Business Objects/Crystal Report Developer

• Responsible for gathering the requirements from the users and preparing the specs and schedule docs.
• Migrated Business Objects XI R2 version reports to Business Objects XI 3.1with proper pre and post migration plans using life Cycle Manager (LCM).
• Migrated universes and reports to PROD and DEV environments from BO R2 to BOXI 3.1 version to their respective folders using Import and Repository Migration Wizard.
• Extensively worked on BW BEx that includes understanding data architecture, data modeling and providing support in development and production environment
• Involved integrating and creating Universe design against Oracle Database using Aliases and Context to resolve loops.
• Maintain and optimize universe using SQL queries, query stripping.
• Designed and Built Universes, Classes and Objects, employing integrity check.
• Ability to pull data using extractors from multiple sources like database tables, BI, ECC functional modules such as SD , HR , MM, CRM to generate reports by using ADP.
• Responsible for OLAP cubes using Enterprises Managers.
• Scheduled reports from CMC and Info view. Added objects into repository
• Generated queries for reports using BEx query designer, to do drill-down analysis and formatted these reports with web application designer (WAD) for publishing over web.
• Configured use of restricted key figures (RFK), calculated key figures (CFK), structures, variables and calculated key figures in BEx reporting queries.
• Resolved Universe problems like Loops, chasm trap, fan trap using Alias and context.
• Developed complex WebI reports with reports level context to control numbers according to user’s requirements.
• Extensively used SQL queries, procedures for analysis.
• Extensively worked on Universe Optimization by either analyzing report SQL or report query.
• Tested BOBJ Universes and reports by checking back source in ECC through BW.
• Developed business reports like Drill down, Chart reports, and Cross-Tab Charts, slice and dice reports using Crystal Reports.
• Used SAP BCM out-of-the-box reports generated by third party reporting tool.
• Provided end user support and problem resolution for various issues related to BO using OLAP Discoverer Plus.

Environment:
Windows XP, SAP Business Objects XI 3.1 (Web Intelligence, Crystal reporting, Xcelsius Dashboards 2008 SP4, Info View, Central Management Console (CMC), Siebel CRM, Oracle 11g, SQL Loader), SAP BW 7.0, BEx Analyzer, Query Designer.

Client: Confidential,Irvine, CA March 09 to Sep 2010
Sr.Business Objects Developer

• Migrated Business Objects XI 6.5 version reports to Business Objects XI R3 with proper pre and post migration plans using life Cycle Manager.
• Extensively worked on BW that includes understanding data architecture and data modeling.
• Designing automation process to refresh Xcelsius Dashboards
• Designing data base and creating table to load data from Excel files using SQL loader
• Creating universes, classes and objects by retrieving data from Oracle data base and defining the necessary connections
• Creating Reports by using functionalities like Slice and Dice, Drill Down, Master Detail, etc. to use for Xcelsius Dashboards.
• Creating Xcelsius Dashboards and connecting it to database using BI services
• Worked closely with Business users to gather requirements for reports and dashboards.
• Involved in the analysis, design, development, testing of analytical reporting.
• Created graphical representation of reports such as Bar charts, Line Charts as per end user requirements.
• Created Dashboards with the selection criteria defaults by user role to help pre-select a subset of data that is most critical and most relevant for the users.
• Extensively used QaaWS as Xcelsius web service provider.
• Creating database connections for different data sources.
• Involved in the extensive standards & guidelines documentation
• Designed and developed reports from Universes.
• Used Life Cycle Manager to move the content between different environments.
• Scheduling various numbers of reports for daily, weekly and monthly runs.

Environment:
Windows XP, SAP Business Objects XI R3 (Web Intelligence, Info View, Xcelsius 2008, Oracle 11g, SQL Loader)

Client: Confidential,Saint Louis, MO Jan 2008 – Feb 2009
Business Objects Developer

• Generated ad-hoc reports by linking systems and interfaces.
• Wrote detailed level documentation for reports and Universe Design.
• Managed the resources, WEBI users, connections, and the Universe repository.
• Queries, Slice and Master Detail.
• Scheduled Business Objects reports through Broadcast Agent
• Responsible for developing all types of reports including Cross-tab reports.
• Scheduled reports from CMC and Info view. Added objects into repository
• Created OLAP Universes Based on SAP BI System (SAP BEx Queries, Multi Providers…).
• Mapped complex spread sheet data within Xcelsius Dashboards and also used Crystal reporting which provides the users with unique business information.
• Worked on new Complex Reports (include multiple groupings, drilldowns, parameter fields, formulas and retrieving data from more than one database) development as well as production support for existing reports.
• Worked in the Migration of reports from Crystal Reports 9.0 to 2008.
• Aided project manager in managing programmers to develop and implement customer information system.
• Helped develop detailed project plans for multiple simultaneous projects, resulting in increased visibility of inter-project dependencies and improved development efficiency.
• Designed and implemented project status reports and communications.

Environment: Windows XP, SAP Business Objects XI 3.1(Desktop Intelligence, Web Intelligence, Designer) Xcelsius, Crystal Reports, MS Office, SQL Server 2008.

Client: Confidential,Eagan, MN April 2007- Dec 2007
Business Objects Developer

• Involved in requirement gathering, writing specifications for generation of reports.
• Involved in Writing Detailed Level Documentation for reports and Universe Design.
• Created Linked reports with multiple prompt as passing parameters within Application.
• Created Complex Crosstab reports with multiple queries.
• Created Metrics and Dashboards using Application Foundation.
• Created reports using Complex variables, multiple breaks, Sorts and multiple data providers.
• Responsible for more interactive reports created Prompts in reports and Universe
• Responsible for creating Full Client/Web Intelligence/OLAP reports.
• Created complex reports using cascading and @aggregate aware function for summarized reports.
• Developed Complex Reports (Used multiple data providers, Union, Intersection, minus and Master/Detail, cross tab, Charts).
• Experience in creating New Users, Groups, Profiles and Publications using CMC.
• Involved in scheduling of documents monthly, weekly and daily through Broadcast Agent Server.
• Generating various numbers of reports on a daily, weekly and monthly basis.

Environment: Windows XP, SAP Business Objects XI 3.0(Desktop Intelligence, Web Intelligence, Designer), Oracle 11g, SQL Loader.

Client: Confidential,Oxnard, CA Aug 2006 - Mar 2007
Business Objects Developer

• Involved in the analysis, design, develop, testing of analytical & transactional reporting systems and user training
• Developed business reports like drill down, chart reports, slice and dice reports using Business Objects and Web Intelligence (WebI).
• Development and Deployment of Complex Reports. Used multiple data providers, Union, Intersection, minus and Master-Detail, cross tab Charts.
• Created Aliases and Contexts for resolving Loops and checked the Integrity of the Universe.
• Created user Prompts, Conditions, Filters to improve the report generation and also Used Alerts for better readability of the reports.
• Worked extensively with the major functionality of BO like Breaks, Alerts, Filters, Sorts, Query Prompt and Drill filters.
• Used Query Builder in Development, Integration, and Production environments to check Reports Binding to two Universes.
• Creating database connections for different data sources
• Used Central Management Console and Publishing Wizard for scheduling the reports on Business Objects Enterprise System and published several reports for On-Demand as well as recurring viewing.

Environment:
Windows XP, SAP Business Objects XI R2 (Web Intelligence, Info View), MS-Access.

Client: Confidential,Indianapolis, IN April 2005- July 2006
Business System Analyst

P&G Pharmaceutical development capabilities include, Drug Safety, Clinical Supplies, Data Management, Biometrics, Clinical Supplies, Chemical Development, Legal & Regulatory, Bio analytical and Analytical Chemical.
P&G Data Management Department was launching a data warehouse that will enable health care professionals to access and share accurate, complete and historical medical information. Additionally, P&G can gather relevant information about their customers that will give them a better understanding of the different kinds of drugs they use, and their costs, in order to reduce customer’s costs. To accomplish this goal, P&G implemented a data warehouse with Business Objects as the primary decision support tool.

Responsibilities

• Gathered business requirements by collecting information from end users and internal stakeholders.
• Prepared Business Requirement Document and then converted business requirements into Functional Requirements Specification and Technical Specification using Rational Requisite Pro.
• Used Rational Unified Process (RUP) as a software methodology.
• Identified Use Cases from the requirements and created UML Diagrams in Rational Rose, including Sequence Diagrams, Collaboration Diagrams and Class Diagrams.
• Authored business and functional requirements with supporting use cases (data modeling) and traceability matrix.
• Conducted the requirements and design walkthroughs with designers, developers and management staff.
• Involved in the User Acceptance testing (UAT) to check the reliability for end users.
• Used MS Project to manage schedules, deadlines and resources and collaborate on the project
• Participated in weekly team meetings, where test status and defects were discussed.

Environment:
Rational Rose, Rational Requisite Pro 2003, Windows XP/2000, MS Project, Oracle 8/8i, Oracle 9, Business Object 5.6, Microsoft SharePoint 2003