SUMMARY:

• SAP-BO techno functional consultant around 8+ years of experience in IT with 7+ in SAP BO Business Objects XI3.1/XIR2 Expertise in all phases of SDLC like blue-printing, realization, analysis, multi dimensional schema design, functional specification, development, performance tuning, testing, documentation, support & maintenance, training, security authorizations and trouble shooting.
• Well Rounded Experience in Configuration of BI Experience in implementation of the SAP Business Objects Enterprise Systems and Support the administration of the Business Objects Reporting Systems. Expertise in Universe designing, developing and generating complex, Adhoc, dashboard Reports, Business views, List of values(LOV) along with User Acceptance Test and data accuracy Test. Created Universes for query, reporting and analysis using BO Designer Module. Scheduled and published reports using CMC and Document Agent /Broadcast Agent server.
• Experience in Data Extraction (Activating/Enhancing standard content with Structural changes & User Exits for Data sources in FI Modules, LO Cockpit, Generic Data sources, Non-R/3, Flat Files, DB Connect, Hyperion and Informatica). Strong interaction with various R/3 modules (HCM(TM, PD, PA, and OM), SD, MM, FI, CO, CRM, EBP, and SRM) in multiple engagements in releases up to ECC 6.0.
• Strong Experience Strong expertise in setting up of repositories, connections, creating and managing users/groups, assigning resources to users, Importing/Exporting users in CMC. Worked on integration of SQL Server, SAP, Oracle, XML, Flat file source systems into the Centralized Data Warehouse. Created OLAP reports, Web I reports, Crystal reports, Adhoc reports, Xcelsius and Dashboards. Experience in developing reports from various sources like Oracle, SQL Server, MS Access, TeraData, Sybase and DB2.
• Experienced in Business Objects Universe designing, Desktop Intelligence, Web Intelligence , Business view Manager and Info view
• Experience in designing and developing the Universe and updating the existing Universes, Creating interactive Dashboards using Xcelsius, developing canned/ad hoc reports, scheduling the processes and administering the BO activities using Business Objects XIR2/ BOXI 3.0.

TECHNICAL SKILLS:

Business Intelligence: SAP Business Objects XI R3/XI R2/6.x/5.x, Webi XI  R2/6.x/2.x, Info View, CMC, Supervisor, Designer,  DesktopIntelligence, Webi Rich Client, Crystal,  Xcelsius, Dashboards, Scorecards. 
Databases : Oracle 11/10g/9i/8i, MS SQL Server, MS Access, IBM DB2 TeraData V2R6/V2R4, Sybase 12.0/11.x
Languages : C, C++, JAVA, SQL, PL/SQL, XML, UNIX Shell scripting
Data Modeling : Star-Schema Modeling, Snowflake-Schema Modeling,  Erwin 4.5/4.0/3.5/3.0
Operating Systems : Windows 95/98/NT/XP, MAC, UNIX, MS DOS
ETL Tools : Business Objects Data Services XI 3.2, Business Objects Data Integrator12.2/11.7.2 

EDUCATION:

• Bachelor of Engineering (Mechanical)

PROFESSIONAL EXPERIENCE:

• Worked with functional consultant for mapping the source data (R3/non R3) to target Data Sources in BI. Defined the initial sizing requirements based on source data volume estimates.
• Responsible for creating, modifying and activating business content extractors, Info Objects, Info Cubes, Multi provider and DSO according to the reporting requirements.
• Created custom variants that allow users to choose report type based on variant conditions like sales division, sold-to-party and sales representatives.
• Worked on the upgrade to 7.3 from 3.5 versions. Performed the various upgrade checks, used OSS notes, configured the new settings for 7.0 and did a post upgrade checks to ensure system is stable.
• Involved in using the new functionalities of BI 7.0 like creating Right optimized DSO’s for staging raw data.
• Developed Transfer rules, Update rules and Start routines using ABAP to incorporate Business logic and perform data manipulation.
• Developing flexible queries using filters, Free Characteristics, Navigational attributes in Bex analyzer to facilitate data analysis in a drill down version to enable the easy access of information at various levels.
• Designed and developed WEBI reports using features like charts, cross tabs, Drilldown reports.
• Designed and developed Xcelsius dashboards by using various components based on requirements.
• Created query variants, restricted key figures, filter values and exceptions for the effective query management
• Developed complex routines in ABAP/4 for transfer & update rules.

Confidential, New York, NY Feb 2009 - Sep 2010
SAP BO Consultant

• Involved in the requirements gathering from users and conducted Gap Analysis to install Business Content.
• Designed & Developed custom Data Sources, Info Sources, Extractors, Info Cubes and ODS to fulfill user requirements.
• Created Info Sources assigned Data Source to Info Source, maintained Communication structures and created/ scheduled Info packages.
• Extracted data from SAP R/3 using Generic extraction techniques and LO cockpit and loaded into Sales Order Info Cube using Data Sources.
• Created Transfer rules (Using ABAP Routines), Update rules to translate the business processes into end reporting objects. Developed custom design ABAP function modules and used LO cockpit extractors for Initial and Delta data load from SAP source system.
• Checked the Universes for Integrity and exported to the Repository to make resources available to the users and groups and Created Adhoc Reports by accessing the Universe.
• Performed unit testing, system integration testing, and user acceptance testing of Crystal Reports at various levels.
• Extensively worked on custom functions and formulas in Crystal reports.

Confidential, Pittsburgh, PA Aug 2007 to Jan 2009
SAP BO Consultant

• Collected requirements in application areas of SD, MM and FI-CO.
• Extensively worked on SAP BW delta load Info Package creation, updating Update rules, modifying communication structures and Day to Day Data Load support.
• Involved in technical and business analysis aspects of BW data warehouse project development, creation of test plans and scenarios, testing, and implementation; including significant hands-on work.
• Depending on department and project needs, support functional and technical design efforts, including data flow diagrams and multi-dimensional data models.
• Review design documents to identify improvement opportunities.
• Developed executive dashboards for the Regional Managers and Finance Directors.
• Involve in building financial & budgeting reports and applying functions based on requirements.

Confidential, Fremont, CA Jan 2006 to July 2007
SAP BO Consultant

• Coordinated with developers in the preparation of Technical specification documents and their documentation.
• Developed/maintained Info Cubes, ODS objects, Info sets and Multi providers
• Created various Data Sources, Info Sources, transfer structure, and assigned source systems for extraction of data and scheduling of jobs for extraction
• Debugged and rectified, issues/problems faced during the data uploads
• Performed and monitored data loading into Info Cubes, ODS objects from SAP R/3, non SAP systems and flat files.
• Tested the data present in PSA as well as in Data targets.
• Created customized queries/reports on various data targets and tested them with the legacy data.
• Developed flexible queries for AP and AR in BEX analyzer to facilitate data analysis in a drill down/summarized way to give detailed levels of information

Confidential, Seattle, WA Oct 2004 to Dec 2005
SAP BO Associate Consultant

• Simplified the data model and investigated & proposed resolutions for failures
• Supported data issues with downstream systems like LZ, AMPS, ESSBASE, and MERLIN.
• All Issues related to support were effectively managed.
• Supported 24*7 environment for process chains and meta chain loads
• Issues regarding function module level, loads level, monitoring level are handled efficiently.

Confidential, Seattle, WA Feb 2004 to Sep 2004
SAP Consultant

• Taken reports using Bex Analyzer and saved them in the workbook.
• Involved in solving Customer Issues within SLA.
• Used Root Cause Analysis (RCA’s) methods to cement the recurring problems and cause of High severity problems.
• Scheduling and Monitoring data loads into the Info cubes.