SUMMARY

• 7+ years of professional experience in the development and implementation of the business applications with extensive experience in SAP BW 7.3 /BI 4.1 & BO 4.0.
• Have done 2 complete implementation life cycles of SAP BOBJ which dealt with Blue Print, Realization, Data Modeling, Data Extraction, Data Loading (Full / Delta Up - loads), Scheduling, Monitoring, BEx Analyzer, Query Designer, Web Applications Designer, Testing, Go Live & Production support, End user documentation.
• Expertise in working with BW 7.3/BI 7.0 - Info Objects, Data Sources, PSA, Info Cubes (Multidimensional, BW Star schema), Multi Providers, Data Store Objects (DSO), Info Packages, DTP, Transformations (BI 7.0), Aggregates, BI content, Process chains.
• Experience in bringing Master Data Analysis and Transactional data from R/3 to BW.
• Evaluated statistical performance using BW Statistics and suggested recommendations to Basis support for optimization. Improved data load and query performance by doing Compression, Studio, creating Aggregates, Rollups, Partitioning, Indexes, and Data packet size.
• Experience in Data Extraction (including LO Cockpit COPA, Generic Extraction), Data Loading (Full /Delta Up-Load), Scheduling, and Monitoring.
• Expertise in working with BEx Analyzer, Design Studio in building Queries. Extensively created Calculated Key Figures, Restricted Key Figures, Formula Variables, Conditions, Exceptions, Customer Exit Variables and Structures for developing complex custom reports.
• Proficient in Business Objects tools - Web Intelligence, Crystal Reports, and Universe Designer.
• Completely utilized various features in the Business Objects Web Intelligence and Crystal Reports such as Pre-defined Filters, Prompts, Cross-Tab, Hierarchies, Drill Down, Charts/ Graphs, Report layout/ format features etc.
• Developed Executive Dash Board using Web reports, Web items, Customized web templates using Web Application Designer (WAD), Report Designer and Query designer.
• Involved in Performance tuning of reports that were running slowly and also applied Confidential various levels like report level, Designer level and database level.
• Excellent Documentation, communication, verbal, and problem solving skills. Proficient skills to communicate effectively with Team members, developers, clients and end users in a diverse environment.
• Created various ad-hoc and canned reports usingSAP Business Object Web Intelligence XI and Crystal Reports 2008 And Bw cubes. functionalities like Queries, Slice and Dice, @Functions, Cross Tab, drill down, Master Detail and Formula etc. .
• Wrote SQL queries / views and used them as a data source Analysis in designing Crystal reports 2008 .
• Developed new Universe that accommodates metrics for the Xcelsius Dashboard.
• Facilitated establishing a change control process for promotion of dashboards between environments.
• Developed documentation (Business purpose and metrics / content summary) for various Dashboards.
• Converted Desktop Intelligence Reports to Web Intelligence using Report Conversion Tool.
• Used SAP Business Objects CMC and Info View extensively for scheduling and distribution of reports and content management.
• Well-coordinated with SAP Business Objects administrator and in resolving database connectivity issues, service management, server troubleshooting, and overall Performance Bottleneck issues.

TECHNICAL SKILLS

BI Tools: Business Objects XI3.1/XI4.0/XIR2/6.x/5.x, SAP BW 7.3, SAP BI 4.1, BOBJ, Universe Designer, Web Intelligence, Desktop Intelligence, Info view, CMS, CMC, Live OfficeImport Wizard, Report Conversion Tool, Enterprise Performance / Information Manager, Dashboard Manager, Explorer, Design Studio, Scorecards, Crystal Reports 2008/ XI/10/9, Xcelsius 2008/4.5, Crystal Decisions, Xcelsius 2008, Dashboard Import Wizard, Report Conversion Tool and Services.

ETL Tools: Business Objects Data integrator XI,SAP BW 7.4, 3.5

Databases: Oracle 11i/10g/9i/8i, SQL Server 2008/2005, MS Access.

Programming: C, C++, JAVA, SQL, PL/SQL, HTML, XML, SQL*Plus

Operating Systems: Windows XP/NT/2000/98/95, Windows 2003,Windows 7,8.

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Sr. SAP BI/BW Consultant

Environment: SAP R/3, SAP BI7.3

Responsibilities:

• Designed and developed different objects in new data flow and in enhancement in the existing solutions.
• Developed Technical Design document based on the Functional Design Document and Business requirements gathering and got approved from management.
• Expertise in Importing and converting data from ECC and External systems into SAP BOBJ System by using ETL Techniques.
• Developed Generic Data source to pull the data from R/3.
• Developed Custom Master Data Info objects and loaded the data by using generic data sources.
• Enhanced the Master data Info objects, Data sources basing on the client requirement.
• Developed Start Routines and Field Level Routines to populate the cost centers by doing the lookups from the custom Master Data Info objects.
• Created Monthly and daily Process Chains to automate the Data loading process for Master Data and Transactional data.
• Handled Performance Tuning of query response time by building Aggregates and Indexes on Info cube.
• Developed Secondary Indexes for the DSO to improve data load performance for downstream feeds.
• Developed the complete strategy to reload the historical data after the enhancements are done for the existing BW Models.
• Developed EO200 report, Cost center report, Booking Billing reports etc, by using BEx Functionalities like Filters, Variables, Restricted Key Figures and Calculated Key Figures.
• Involved in Unit Testing to validate the Business requirements and prepared documents for the results.
• Created Ad-hoc Explorer Query to calculate Period to date, Design Studio,Quarter to Date, Year to Date Values.
• Involved in resolving day to day Production issues and also coordinated with offshore team and Business.
• Analyzed various Data Warehouse Models like Slowly Changing models, Conceptual Models, Logical Models.
• Involved in Writing Stored Procedures and SQL Queries for the Reports.
• Defined Context and Alias to resolve the Loops in WEBI Universes.
• Created Dimensions, Details, Measures and Classes in Universe.
• Detected cardinalities and checked the Integrity of Business Objects Universes.
• Creating WEBI Universes, Classes, Objects, Measure Objects, Prompts, Conditions and Joins.
• Resolving the loops, fan traps, chasm traps using contexts and aliases, checking the Cardinalities and Integrity of the Universes.
• Responsible for creating Derived Tables, Aggregated Tables using Aggregate Awareness concept.

Environment: SAP Business Objects Enterprise XI R2, SAP BW 7.4, SAP BI 4.1, SAP BOBJ Oracle10g/9i, Designer, Web Intelligence XI Windows 2003

Confidential, Dallas, TX

SAP BOBJ CONSULTANT

Environment: SAP BI 7.0, BO 4.0, ECC 6.0; MM, SD.

Responsibilities:

• Interacted with Business Users and Business Analysts to gather and document the Requirements and translate these to Technical specifications for Designing WEBI Universes.
• Created several Universes using Designer according to the Requirement.
• Created new SAP BW 7.4 and modified existing Hierarchies in the universes to meet Drill Analysis of the user’s reporting needs.
• Tested the aggregate awareness to ensure the query is pulling correct level of aggregation.
• Defined Alias and Contexts to resolve loops and also tested them to ensure that correct results are retrieved.
• Exported the WEBI universe to the Repository to make resources available to the users.
• Scheduled the WEBI Universes on daily wise, monthly wise and weekly by using Scheduler
• Created several Webi reports, Deski reports and Dashboard reports for graphical presentation.
• Developed standard, cross-tab, On Demand and Drill-down Reports using Crystal Reports.
• Developed Web Intelligence reports making use of several Queries (Union, Intersection, Minus).
• Used Prompts, Conditions to restrict the data returned by Query and used Filters to restrict the unwanted data to be displayed on the report.
• Developed reports by linking different data providers in a single report, and made all possible incompatible objects as compatible by merging the common objects.
• Used multi-dimensional analysis (Slice & Dice and Drill Functions) to organize the data along a combination of Dimensions and Drill-down Hierarchies giving the ability to the end-users to view the data from heterogeneous viewpoints.
• Worked extensively with the major functionality of BOBJ like Breaks, sections, Group values, Sorts, List of values (LOV), Pre-defined conditions, Calculations and Ranking.
• Created different types of reports, like Master/Detail, Cross Tab and Chart (for trend analysis).
• Generated Reports on WEBI Universes based on time like Year, Quarter, Month, Week based on Geographic and Comparative reports.
• Used Broadcast Agent Publisher, which enables distribution of information via email using an easy-to-use, subscription-based mechanism
• Created Analytics and Explorer using Performance Manager to enable executives track progress and compare current and historical performance against established targets.
• Created single or multi line chart for showing tendency over a period of time particularly used in revenue history using Xcelsius 2008.
• Created graphical representation of reports such as Bar charts, 3D charts, Pie charts, Column chart, Line chart, Bubble chart using Xcelsius 2008.
• Used Xcelsius for presenting dashboards to End users.
• Created Revenue Dashboard, Sales figure Dashboard using Xcelsius 2008.
• Migrated Business ObjectsXI R2 content (users/user groups, Universes, reports) in to Business ObjectsXI 3.0 environment using the Import Wizard.
• Involved in Business ObjectsSupport, Problem Solving, Trouble shooting and developing End user Notes.

Environment: Business ObjectsXI 3.1/3.0/R2,SAP BI 4.1, SAP BW 7.4, SQL Server2005/2008, Data Modeler, Web Intelligence XI R2/ XI, Info view, PL/SQL, Windows XP, Windows 2003 Server

Confidential, Boston, MA

SAP BW/BJ Consultant

Environment: SAP BI 7.0, ECC 6.0

Responsibilities:

• Worked on Creation of Custom defined BW Cubes and Custom Multiprovider.
• Monitored Daily Chains, weekly Chains, and Monthly Chains.
• Uploaded Transaction Data Design Studio from the Flat File as the Source System.
• Involved in escalating high-prioritized tickets regarding extractions, Performance Issues and also load failures.
• Monitoring of Info packages and analyzing the reasons for frequent failures of Info packages.
• Maintaining Work History for all the tickets until it is closed down.
• Maintaining and sending the tickets status to the onshore coordinator with end-users.
• Installed necessary objectsbusiness content Explorer in R/3.
• Analyzing the reporting issues and resolving them so that priority wise.
• Transport the objects development to production.
• Maintaining Reconciliation’s to verify the data in SAP R/3 and SAP BW 7.4 are same or not, after the data loads.
• Resolving and implementing BW Query issues (day to day) and change requests.

Confidential

SAP-BW Consultant

Environment: SAP BI 7.0 &SAP R/3 4.7

Responsibilities:

• Monitored Daily Chains, weekly Chains, and Monthly Chains.
• Monitoring of Info packages and analyzing the reasons for frequent failures of Info packages.
• Used Bex to create reports with exceptions, conditional formatting, restricted key figures and calculated key figures.

Confidential

Assistant Manager Sales

Environment: Sales & Marketing

Responsibilities:

• Responsible for achieving monthly sale targets for various products and services offered by Bank
• Customer mapping, competitor mapping in the geography assigned
• Following internal guidelines and procedures of the bank
• Ensuring customer satisfaction and resolving customer queries/issues