SUMMARY

• About 8 years of extensive Techno-Functional experience in SAP BI/BW and SAP Business Objects which includes 3 end to end implementations.
• Excellent front-end and back-end skills with SAP BI/BW and SAP Business Objects XI 4.0
• Proficient in writing ABAP user exits for transaction data and complex routines in Start Routine, End Routine and Update Routines.
• Experience in modules of Logistics (MM, SD, PP), FI-CO, HR, IP and strong emphasis on Business Warehouse.
• Implemented full life cycles using ASAP methodology across various modules of (MM, SD, FI-CO) in SAP BI/BW that includes gathering business requirements, analyzing the business process, performing AS-IS Analysis, Identifying and analyzing the Gaps, Implementation, Designing, Configuration, Customization
• Data Modeling: Experienced with creating, modifying and activating Info Areas, Info sets Info-Objects, DSOs, Info-Cubes and Multi-Providers according to the reporting requirements.
• Expertise in Data Source enhancements like Loading, Scheduling, Monitoring, Process Chains Maintenance, Reporting, Enterprise and Portal Integration.
• Extracted data using BW extraction structures such as LIS, LO Cockpit, CO-PA, FI and Generic Extractors
• Experience in BI Performance Tuning by maintaining Aggregates, Compression, Partitioning, and Indexing of Info Cubes.
• Performed Remodeling on already existing Info Cubes to add new Key figures and Characteristics
• Created BEx Reports providing insight of Business Intelligence to aid the analysts in decision-making using Formulas, Selections, Structures, Calculated Key Figure, Restricted Key Figure andCustomer Exit
• Expertise in using Bex formulas in getting and setting the data to the workbooks, formulas like BexGetData and BexSetData
• Extensively worked on creating Real time Cubes and Input Enabled Queries for Planning
• Expertise in Business Objects 4.0, XI 3.1/XI R2 (CMC, CMS, CCM), 6.5.1/5.x Universe designer, Information Design Tool, QaaWs, Import wizard, Publishing wizard, Business views, Desktop Intelligence, Xcelsius/Dashboard Designs, Crystal Reports 2011/2008 and Web Intelligence
• Expertise in creating a Universe using Universe designer/Information design tool from various source systems and exporting them onto Infoview/BI Launch pad
• Experience in Linking Universe, Canned/Adhoc Reports, Scheduling and Processing of reports
• Extensively used Calculations, Variables, Prompts, and Sorted inputs, Drill down, Slice and Dice, Alerts, Input Controls, Tracking Changes, Sorting and Ranking for creating interactivereports
• Expertise in creating Charts like Dual Axis, Combined Column and Line, Surface Chart, Stacked Column, Pie with Variable Slice Depth and Cross Tabs too
• Extensively worked on documenting and formatting reports. Have exported them to PDFs and published them on to BI Launch Pad/Infoview
• Competency in all phases of the project from analysis, design, development, configuration, testing, as well as documentation, and providing end-user training
• Involved in Unit testing, System testing, Integration testing and User Acceptance Test throughout the project.
• Expertise in Business Intelligence/Reporting Space with exposure to wide variety of BI tools – SAP
• Business Objects

TECHNICAL EXPERTISE:

Data Warehouse

BI 7.3, BI 7.0, BW 3.5, BW 3.X

RDBMS

DB2, Oracle, SQL Server, MS Access, My SQL and Teradata

Languages

C, SQL, PL/SQL, ABAP/4

ERP Packages

SAP ECC 6.0, R/3 4.7, R/3 4.6

Reporting Tools

BEx Reporting, Web Application Designer (WAD), Business Objects (XI R2, 3.1), BI 4.0, Xcelsius Dashboards/Dashboard Design & Crystal Reports 2008/Crystal Reports 2011.

PROFESSIONAL EXPERIENCE:

CLIENT: Confidential North America, MI
ROLE: SAP BI/BO/IP Consultant APR’12 – Present

ENVIRONMENT: SAP BI 7.3, SAP ECC 6.0, CO, BEx and Business Objects XI 4.0
DESCRIPTION: Confidentialis a global automotive parts supplier with a focus on wire harnesses and to a lesser degree instruments and components such as connectors and terminals.
RESPONSIBILITES:

• Have worked in SAP BI Integrated Planning to do the Short term forecast (STF)
• Extensively worked on Controlling side used 0CO_OM_CCA20 data sources to create various Expense reports
• Used the standard info cube 0CO_CCA20, created custom Real time Info Cubes and Multi Provider on top of them
• Maintained the load behavior on the created real time info providers by changing them from Planning mode to Data Loading mode
• Developed various Aggregation Levels on top of Real time Info providers
• Created various Filters for restricting the data at the planning modeler side
• Created various Planning Functions like COPY, DELETE, REVALUATION and so on for the planning purpose
• Defined the Planning Sequences for executing and testing the planning functions
• Developed Bex queries in change mode by building them on Aggregation levels
• Used Structures for defining the fiscal year/months and calculated Sales for the period for the respective Cost Element of the Cost Centers
• Developed BEx queries for reporting on InfoCubes, DSO and Multi Provider by defining Variables, Formulas, Exceptions, Selections, Navigational Attributes, Conditions providing drill down functionality in reporting
• Have created different kind of workbooks with different user interface functionality
• Provided various options like BUTTON’s, Drop down box for easy navigation
• Assigned all the planning functions defined in the Planning modeler to the BUTTON’s created
• Also created Input Enabled templates for the users, in order for them to enter Direct input values to the Real time Info Cube
• Used Open hubs for the retraction process to get data from the real time info providers back to ECC
• Have given trainings to the users on working with the workbooks and saving the input data
• Have got and set the data to & from the workbook using Bex formulas(BexGetData, BexSetData)
• Have maintained and created multiple Universes and Web Intelligence reports respectively
• Created Web intelligence reports directly pulling the Bex reports onto BOBJ side.
• Provided various interactive ways in viewing the report by creating Input controls, Prompts, Combo box, Drop down, Radio buttons and Check box options
• Used the Information Design tool(IDT) for creating the .unx universe file and also for converting the .unv to .unx files
• Published the reports to the CMS and scheduled the reports weekly and monthly
• Have good knowledge on Universe designer tool, Information Designer tool, Web Intelligence, Xcelsius/Dashboards and Crystal reports 2011

CLIENT: Confidential, CA
ROLE: SAP BI/BO Consultant NOV’11 – APR’12

ENVIRONMENT: DB2, SAP BI 7.3, SAP ECC 6.0, BEx and Business Objects XI 4.0
DESCRIPTION: Confidential is an online car bidding company, selling and buying lots all over US, UK and CANADA. 
RESPONSIBILITES:

• Created custom InfoCubes and DataStore objects by enhancing the business content
• Transferred data using DTP to various targets and monitored Process Chains
• Created various Routines to transfer the data to data targets depending on the requirements
• Created and Maintained DTP and InfoPackage for Loading, and Monitored Process Chains for periodic loads of Master data and Transaction data from ECC system to Data Targets using various process categories and process types
• Worked extensively and Involvedin the installation of Business Objects XI 4.0 (BI 4)
• Have given trainings on the BOBJ tools (Web-I, Dashboard Design and Crystal Reports 2011)
• Have created a Universe using both Universe Designer and Information Design Tool
• Converted .unv to .unx using IDT for creating universes from multiple Relational/OLAP sources
• Created interactive Dashboard designs, Web Intelligence Charts and Crystal reports like Dual Axis, Combined Column and Line, Surface Chart, Stacked Column and Pie with Variable Slice Depth
• Provided various interactive ways in viewing the report by creating Input controls, Prompts, Combo box, Drop down, Radio buttons and Check box options
• Involved in the installation process of Business Objects XI 4.0
• Created multiple reports from different Data Providers
• Worked to integrate data from multiple source systems including legacy systems with SAP
• Performed various Analysis on the reports like Filters, Ranking, Controls, Data Tracking, Alerts, Breaks and Sorts
• Created various Master Detail, Cross tab, Horizontal and Vertical tables and published them on BI Launch pad/Infoview
• Created different Variables depending on the requirements
• Created a report on Bex query and Excel data
• Performed formatting issues and data issues like Alignment, Sizing, Padding and Page Setup
• Created ‘Drill-Through’ reports to provide users with detailed information by creating Custom Hierarchies at Universe Level for analysis purpose
• Improved the performance by using Conditions, @Functions, @Prompts, @Select, @Where at the universe level for filtering of data
• Managed and maintained the Universe security and worked on functionalities like Breaks, Sections, Group Values, Sorts, List of Values (LOV’s) and Ranking
• Schedule and exported the reports to PDF’s, Excel on weekly basis
• Have created few custom queries according to the requirements like restricting the data for last 5 weeks and for last 18 Months
• Build reports on both SAP and Non SAP (Non SAP being DB2, AS/400)

CLIENT: Confidential, MI
ROLE: SAP BI/BO Consultant OCT’10 – NOV’11

ENVIRONMENT: SAP BI 7.0, SAP ECC 6.0, SD, MM and Business Objects 3.1

DESCRIPTION: Confidential competencies are in the areas of custom application development, service oriented architecture, web services, and privacy and security.

RESPONSIBILITIES:

• Actively interacted and scheduled meetings with the business users to gather the reporting requirements, performed gap analysis and developed design documents
• Used Standard Data Sources and enhanced them to meet the reporting requirements
• Extensively created custom InfoCubes and DataStore objects by enhancing the business content
• Responsible for Data Modeling to correct the models for a better loading of data. Created Line Item Dimensions, Number ranges for the dimensions to enhance load performances
• Developed complex ABAP routines to split single records from sales source data to multiple records in the target by creating Internal table to the meet the requirement
• Used ABAP coding for Start Routines & Transfer/Update Rules to meet the customer requirements & worked on creation of Aggregates and hierarchies for the Info Cubes to access data in an efficient and ordered level
• Created and Maintained DTP and InfoPackage for Loading, and Monitored Process Chains for periodic loads of Master data and Transaction data from ECC system to Data Targets using various process categories and process types
• Performed automated deletion of PSA and Change Log tables using Process Chains to improve the Data Management
• Implemented Compression and Partition techniques for cubes to improve the query response time. Proposed archiving strategy for future based on Time characteristics.
• Worked with Transport connector for transporting the BW objects and reports between Development, Test and Production systems
• Developed BEx queries for reporting on InfoCubes, InfoSets, ODS and Multi Provider by defining Structures, Variables, Formulas, Exceptions, Selections, Navigational Attributes, Conditions providing drill down functionality in reporting
• Extensively worked on formatting Business Objects reports to meet the user’s requirements using Calculations, Variables, Prompts and Sorted inputs, Drill down, Slice and Dice, Contexts, Alerts
• Extensively Worked with SAP to create connections between WEBI and Xcelsius Dashboards. Worked on INFOVIEW to create Web Intelligence Reports over BO Universes

CLIENT: Confidential, NY
ROLE: SAP BI/BO Consultant AUG’09-OCT’10

ENVIRONMENT: BI 7.0, ECC 6.0, FI, BEx, Business Objects (XI)

DESCRIPTION: Confidential is a world-leading financial services company, advising clients in all aspects of finance, around the world, around the clock.

RESPONSIBILITIES:

• Performed extraction of data from NON-SAP and SAP ECC systems to BW
• Maintained standard & custom MP, Info Cubes, DSO, DS and also extracted data from flat files
• Developed and Maintained the Process Chains, DTP’s, Info packages
• Generated BEx queries on the Multi Providers by defining Exceptions, Functions and Variables
• Worked on the integration of BI/BO and developed reports using Business Objects
• Development of BO Universe and complex Reports using BO XI 3.1 and implementing it into WEBI and exported to server
• Created complex security structure for BO and migrated using migration tool
• Extensively worked on INFOVIEW, Web Intelligence, Desk Intelligence Reports over the Universe created
• Created reports using Business Objects functionalities like Slice and Dice, Drill Down, Cross Tab, Alerter and Formula etc
• Created Several Webi Reports, Deski Reports and Dashboards for Graphical representation
• Developed objects with Aggregate aware/Index Awareness functions to improve performance
• Created custom Hierarchies, which help the end user to Drill down to lower levels
• Involved in installation Business Objects and Xcelsius dashboards
• Extensively Worked in CMC in configuring BO environment
• Designed and implemented complete security model for SAP BO
• Worked In creating Variables, Prompts in Webi
• Sound Knowledge over QaaWS used in mapping data directly from Universe to Xcelsius
• Sound Knowledge over Xcelsius Dashboard Components and providing the end user with Drop down, Combo box functionalities

CLIENT: Confidential, IL
ROLE: SAP BW/BO Consultant JAN’09-JUL’09

ENVIRONMENT: SAP BW 3.x, R/3 4.6C and Business Objects (XI)

DESCRIPTION: Confidential is a member-owned organization of more than 75 best-in-class member-distributors with combined annual revenue of over $12 billion.
RESPONSIBILITIES:

• Responsible for gathering requirements from Super Users and Functional & ABAP team and provided the design options for generating custom extractors and various report design options to meet the requirements.
• Loaded the data from ECC to BW and used initialization with Delta update and Full update methods.
• Completely designed and implemented the reporting requirements for the user.
• Developed transformations with Start routine and End routine and involved in the creation and maintenance of DTP and Info Packages for loading data in to data targets.
• Created custom Multi Provider, on standard cube and a custom cube, which allows the users to drill down on the details
• Scheduled jobs using Process Chains for Data Load, Compression, Aggregates and Information Broadcasting.
• Coordinated with the Payroll & Time Management on customizing queries in HR module
• Extensively used BEx analyzer, created queries with Variables, Filters and performed detailed reporting, published several web reports and worked on InfoSet queries using BEx analyzer.
• Created reports using BEx Reports, Workbook, and Queries for the required sales order queries with Exceptions, Conditional formatting, Restricted Key figures and Calculated Key figures
• Used BI Broadcasting services for the distribution (Print & Email) of exception reports to key business users.
• Provided production support and administration of BI back-end operations to ensure data is successfully extracted from source systems
• Worked on Business Objects using Universe designer, Web-I, Crystal Reports and Dashboard reporting.
• Created Web-I reports and Crystal reports over OLAP universes and created Dashboards using Xcelcius

CLIENT: Confidential, NJ
ROLE: SAP BW/BO Consultant JUL’08-JAN’09

ENVIRONMENT: SAP BW 3.5, SAP ECC 5.0, FI, Business Obj 3.0, BEx Analyzer, Net weaver 2004s.

DESCRIPTION: One of the world\'s largest hotel and leisure companies.

RESPONSIBILITIES:

• Gathered Business Requirements from Users & Business Analysts for data modeling, identified the gaps and suggested necessary enhancements for transaction data and master data extractors.
• Activated Business Content for Accounts payable (AP), General Ledger (GL) and enhanced them as per the client requirement
• Created Generic extractors using Table/View and Info set queries to satisfy multitude user requirements and maintain availability of specific data for reporting purposes.
• Extracted Master and Transaction Data from Flat files and loaded into Info Objects, DSOs and Info Cubes and developed many complex Start Routines and End Routines to meet business logic.
• Extensively worked on custom data source enhancement, and used User Exits to populate data & customized delta built up for the data sources.
• Installed SAP BI standard business content Info Cubes for FI-GL, FI-AP and modified them to meet the Business Requirements and User needs.
• Worked extensively on Data Modeling design like creating Info Objects, Info Cubes, DSO, MultiProviders, Info Sources, Info sets in BI as and when required.
• Extensively worked on performance enhancement features such as cube Partitioning, Indexing, Maintaining Aggregates, Rollups and Compression
• Created Process Chains for automation of data load & monitored the processes.
• Used Open Hub Destination to store data from SAP BW to local databases for ad-hoc reporting purpose of ERP super users.
• Created FI reports like GL Balance display, FI Actual/Actual Comparison, AP Payment history, AP Overdue analysis.
• Extensively worked on BW reporting using BEx Analyzer, BEx Query Designer, BEx Broadcaster using Calculated Key Figures, Restricted Key Figures, Structures, Variables, Aggregations,Exceptions, Conditions and Customer Exits for calculating the YTD and MTD Values.
• Extensively created Queries and Dashboards (Query Designer), Workbooks (BEx Analyzer) and Web Applications (Web Application Designer).
• Published the reports on the web using the Web Application Designer using the wizard as well as drag and drop web items like Ad-hoc, Table, and Filter for creating customized Web templates as per customer requirements.
• Worked on Business Objects using Universe designer and created WEBI, Dashboard reporting.
• Extensively worked with BO Classes, Objects, in the Universe, Cardinalities, Contexts, Joins and Aliases and resolved loops in Universes using Table aliases and contexts.
• Extensively used functionalities like Calculations, Variables, Breaks, Sorting, Drill Down, Slice and Dice, Alerts for creating BO Reports.
• Worked with the DBA to create aggregate tables and materialized views to improve query performance by cutting down on the size of the result set at the data provider level.
• Handled issues and provided support for reports on Crystal Enterprise environments (Development, UAT, Testing, Production)
• Planned the cut over activities before go live and performed the downtime activities.
• Worked on production support issues like data reloads as required, fixing bugs etc. Resolved issues connected with running the query

CLIENT: Confidential, NC 
ROLE: SAP BW Consultant AUG’07-JUL’08

ENVIRONMENT: BW 3.5, R/3, SD, MM, BEx Analyzer

DESCRIPTION: Leading software Services Company in IT industry

RESPONSIBILITIES:

• Prepared the Technical specifications of the report requirements by aligning to the requirements of the client
• Installed the Business Content and also created Info sources, Info objects, Info cubes, ODS objects, Transfer/update rule and Process Chains
• Worked on setting up Flat files extraction for Legacy data and also on assigning Data Sources to the Info Source
• Designed Info Cubes with daily and monthly granularity with extraction from PSA
• Responsible for Job schedules for loading Master data (Texts, Attributes and Hierarchies) for sales areas and Transaction data into the corresponding ODS Objects and InfoCubes
• Worked on different modules such as SD, MM and extracted data using RSA5 and RSO2 (standard and generic extractors)
• Activated business content for Standard InfoObjects, InfoSources, InfoCubes related to Sales & Distribution and Material Management
• Published reports on Portal and use Information Broadcasting to send reports to users on Portal profile and email and performed data integrity testing by executing BEx Queries validating against the backend R/3 System
• Extensively worked on supporting SAP BW application and worked with data loading, fixing issues related to data loading, load monitoring, performance tuning, write and modifies existing ABAP codes for better performance and issues
• Extensively worked on BW Scheduler to load data into Info Cubes and ODS
• Configured the use of Variables, Restricted Key figures, Calculated Key figures, Conditions and Exceptions
• Worked on Query Development Templates and Workbooks in BEx Analyzer

EDUCATIONAL QUALIFICATION

• Bachelors of Technology, Confidential University