Profile
I have around 7+ years of experience in different fields of SAP including SAP Netweaver, SAP Portal, SAP Business Intelligence, SAP BusinessObjects, SAP ABAP and SAP Solution Manager

BO (BUSINESS OBJECTS) SKILLS

• Client Interaction for activities such as initial Requirements gathering, Tracking requirement changes, building functional test scenarios, coordinating user acceptance testing and Production Support. Knowledge in full SDLC.
• Extensively worked on Administrative work such as installation configuration
• Experience in DSS/OLAP tool Business Objects suite like BO reporter, Designer Web Intelligence, Info View and Broadcast Agent.
• Maintain Users and modify their Profiles
• Extensively worked in designing and development of Reports and Universes.
• Scheduling, executing, monitoring, and reviewing Data Warehouse Environment related jobs
• Performed drill analysis which will allow the user to view data at a more detail level, and generated Master/Detail, Crosstab, Chart, Subtype reports as and when required.
• SQL, PL/SQL Performance Tuning using Oracle Cost based Optimization techniques like Explain Plan
• Experience in providing solutions and implementation of Performance Tuning of reports.
• Experience in the development of Dashboards and refreshing them periodically.
• Experience in the analysis of data mismatch in the reports and source.
• Worked and resolved loops by creating aliases
• Coordinated for the Production moves and post move issues.
• Well Versed with different tools like TOAD and SQL Developer for accessing/development of Databases
• Experience in creation of complex/ simple reports on web using Info view portal and Web Intelligence, distributed the reports to different users.
• Provided Production support, performed document reviews, and prepared detailed design, Test Plan, Promotion, Change Request, Maintenance and Check List documents.
• Experience in creating ad-hoc reports
• Experience in SAP BI - BO integration using SAP Integration Kit

BW (BUSINESS WAREHOUSING) SKILLS

• Experienced in BI Components like InfoObjects, InfoProviders, Hierarchies, InfoSources, Update Rules, Transfer Rules, Routines, InfoCubes, MultiProviders, InfoSets, ODS, InfoPackages and Aggregates using BI Administration Workbench.
• Worked extensively with BEx Analyzer, BEx Browser, and BEx Query Designer for developing reports, analysis and also worked on web reporting using BEx Web Publisher, Web Publishing wizard and BEx Web Application Designer.
• Created custom queries using Variables, Filters, Calculated and Restricted Key figures and provided drill down functionality in the Reports.
• Created, Activated and Customized Business Content, Extract Structures, Generic Extractors, InfoPackages, Roles and Transports etc.
• Worked with Reporting Authorization Objects, User Profile Maintenance.
• Activated and Enhanced Extractors like LO-Cockpit, LIS, CO-PA, FI-AR-AP-GL.
• Expertise in SAP BW components like Data Modeling, Data Source Enhancement, User Exits (CMOD), OLTP extraction, Loading (Full/Delta Up-Load), Scheduling, Monitoring Data Loads, Process Chains, Data Mart and Open Hub Service.
• Expertise in Performance Enhancement features such as Indexing, maintaining Aggregates, Compression and Partitioning.
• Working knowledge in ABAP/4 programming language.
• Worked on Classic and interactive Reports, BDC’s Routines, User Exits and Function Module.
• Worked in various sectors including IT enabled services, Media, Manufacturing, Government Administrative body.

Experience / Project Work

Confidential,
SAP BI and Business Object Consultant
Duration – Oct 2008 – till date

Responsibilities:

• Worked on two different phases of data warehouse integration project: Integration of SAP BW data warehouse and traditional data warehouse Teradata with BO as front end. Integration of BW and BO using SAP Integration Kit.
• Exp in installation of SAP BO on Windows environment and Oracle as the backend
• Extensively worked on creating Universe
• Extensively worked on administrative work including CMS and CMC
• Installation of SAP Business Object
• Extensively worked on resolving loops by creating alias and contexts
• Created dashboards to check effective use of the entire BP process.
• Developed reports in WebI
• Creating Universes and Reports between controlled environments.
• Publishing of Universe and setting access restriction, maintaining database connection for Universe
• Creating database components (e.g. stored procedures, views, etc.) working with the development team to optimize where possible proactively.
• Developing UNIX scripts (csh, ksh, Perl, etc.)
• Conversion rules and then use the data services engine in SAP to convert legacy data.
• Maintaining Users and modifying their profiles
• Administrating and enforcing the security model and the Business Objects repository across development, testing, and production environments.
• Designed OLAP Universes on top of NetWeaver BI using BW Cubes and BEx queries.
• Used Query as a Web Service (QaaWS) to leverage OLAP Universe as a source for Xcelsius dashboards.
• Developed and automated Sales Orders Status reports using standard datasources like 2LIS_11_VASTH and 2LIS_11_VASTI for specific order types “ZNCL”, Clinical Sales Orders.
• Developed custom extractor to bring in Bill of Material (BOM) related information into BW for master data reporting on a few measures like Batch Size and Lot Size.
• Actively involved in sourcing the SAP Purchasing, vendor and Invoice related information in Teradata using Informatica and built the reports based on the existing complex BEX reports using the Infoview to generate WEB Intelligence reports.
• Actively involved in creating Classes, Objects and complex Universes. Used all Business Object functionality\'s like Queries, Slice and Dice, Drill Down, Functions, Cross Tab, Master Detail and Formula\'s etc.
• Extensively worked on Crystal Reports
• Extensively worked on Business Object Metadata Manager
• Developed Cost Center Expense Summary Report, Head Count and Vendor Diversity Classification reports using Web Intelligence.
• Used Live Office Document as a source for Xcelsius dashboards by retrieving data from NetWeaver BI via Crystal reports using Live Office.
• Actively involved in training the end users in Adhoc reporting.

Confidential, (NC)
BO Admin and Technical Consultant
Duration: Dec2007 to August 2008

Responsibilities:

• Requirement gathering and analysis. Functional & Non Functional requirements. Ordering of requirement. Traceability & versioning of requirements.
• Architect for automation of the existing reports to reduce the number of man hours to run the weekly/monthly reports by enabling the file based option in BO CMC.
• Installing and deploying and administering SAP Business Objects
• Data Modeling & Universe design.
• Developed DeskI and WebI reports.
• Created Crystal reports using Universes and Business views.
• Created Use cases / Test plans for quality & data analysis.
• Crystal Xcelsius was used to improve Dashboards and Scorecard.
• Enabled the Unmanaged disk option to save the report into the shared drive as .pdf format.
• Java ReportEngine sdk was used for creating dynamic folders and achieve report bursting.
• Gathered user requirements for Data modeling and modeled the Star Schema concept.
• System Administration
• Managing server, user and doing content management
• Developed front-end queries using Query Designer and Web Application Designer (WAD) and publishing results on the web.
• Data Management by creating universe
• Creating Semantic Layer Design
• Query Reporting
• Designing Reports
• Worked on Customization of Sales, Delivery and Billing Cube as per the user requirements.
• Enhanced the Data Source for adding new fields in the Extract Structure and populated the data through User Exits (CMOD).
• Monitoring BOE services
• Migrating BOE Objects across environments
• Importing 3rd party application Users and groups into BO Platform
• WebServer / AppServer Integration
• Performance tuning
• Administering BOE using administrative tools and scripts that are included with the UNIX/Linux distribution of Business Objects Enterprise.
• Enable/Disable Trace to BOE server services
• Root Cause Analysis and Troubleshooting issues
• BO Installation / Integration support
• Migrating Business Objects from a Lower to higher version
• Scaling BOE services vertically/horizontally
• Establishing Database connectivity in BO servers
• Used CTS to transport objects to Test Environment and Handled Post Production support.

Confidential, Uxbridge, U.K.
BO Consultant
Duration: June 2007 to Nov 2007

Responsibilities

• Installation and configuration of BO
• Work as Analyst to gather the Requirements and Business logics.
• Design the universes for the canned reports and for adhoc reporting.
• Resolved loops in Universes using Table aliases and contexts to remove cyclic dependencies.
• Define Business Objects Classes and Objects, Created complex Universes and Reports.
• Performed in depth analysis of data & prepared weekly, biweekly, monthly reports by using Business Objects.
• System Administration
• Managing server, user and doing content management
• Data Management by creating universe
• Creating Semantic Layer Design
• Query Reporting
• Designing Reports
• Designed & developed various departmental reports by using Business Objects.
• Creation of different types of reports, such as: Master/Detail, Cross Tab and Chart (for trend analysis). Use of filters, conditions, calculations, etc.
• Use of Designer module to implement Universes, linkages between tables, creating prompts and queries, parsing the Universes, applying contexts and alias tables to remove cyclic dependencies.
• Created derived tables in the universe to help generate complex reports.
• Used Infoview to generate the web intelligence reports and also used desktop intelligence to develop full client reports.
• Provided BO training for end users.
• Scheduled Documents on daily, weekly, and monthly bases.
• Involved in Informatica tool –Source Analyzer, Data warehousing designer, Mapping Designer & Mapplet, and Transformations.

Environment: Business objects XI R2, Informatica 7.1

Confidential,MN

Technology: SAP Business Intelligence (SAP BI)
Role: Technical Consultant & Developer
Duration: Jan 2007 to June 2007

Responsibilities:

• Created new Queries in Business explorer for the Clients forecasting and Finance Reporting needs to work upon the InfoCubes, with calculated Key figures, navigational attributes, variables and restricted Key figures.
• Created Exceptions, Conditions and filters for Query evaluations including follow-up actions for mail in reporting agent.
• Performance tuned Queries by creating aggregates and by cube compression.
• Created a Generic Structure to extract data from the custom tables. Designed and created an ODS object which gets data from the generic structure.
• Created InfoPackage to load data and was scheduled to run periodically.
• Used CTS to transport the Objects to test environment.

Environment: SAP R/3 4.7, SAP BI, MS Excel, Windows 2000/NT

Confidential,Colombo, Sri Lanka

Technology: SAP Enterprise Portal (SAP EP) and SAP Business Intelligence (SAP BI)
Role: Technical Consultant & Developer
Duration: March 2006 to Dec 2006

Responsibilities:

• Gathered user requirements for Data modeling and modeled the Star Schema concept.
• Extensively worked in LO-cockpit environment to extract data from SD Data sources and others using V3 update Process.
• Worked on Customization of Sales, Delivery and Billing Cube as per the user requirements.
• Enhanced the Data Source for adding new fields in the Extract Structure and populated the data through User Exits (CMOD).
• Extensively worked in Data Mapping Fields between R/3 and BW for SD Communication Structures.
• Designed Developed and Modified InfoObjects, InfoSources and InfoCubes and loaded these objects with Master Data and Transactional Data from SAP R/3 and Flat files by creating InfoPackages.
• Worked extensively with loading Transactional data into Transactional ODS and then into associated Standard ODS and InfoCube using the Data Mart interface.
• Created MultiProviders on InfoCubes like Orders, Delivery and Billing for specific Queries.
• Wrote Transfer Rules, Update Rules and Routines for Data Transformation.
• Developed the Process Chains to automate the Data Upload and Rollups for Aggregates.
• Worked with Reporting Authorizations and Developed Roles as per customer requirements.
• Improved performance of existing SAP BW Queries and Reports by creating Aggregates, Compression, Indexing and Partition etc.
• Created Variables, Filters, Exceptions, Calculated Key figures, Restricted Key figures, Global and Local structures and other features to meet user requirements.
• Created Web Templates using Web application Designer for the existing queries and scheduled in background using reporting agents.
• Conducted presentations, End Users Training, documentations, Knowledge transfer sessions.
• Used CTS to transport objects to Test Environment and Handled Post Production support.
• Implementing of SAP NetWeaver 2004 SAP Enterprise Portal.
• Creating iViews (BI iViews, Transactional iViews, BSP iViews, JAVA based etc.).
• Creating Roles and Pages.

Confidential,Mumbai, India

Technology: SAP Enterprise Portal (SAP EP) and SAP Business Warehouse (SAP BW)
Role: Technical Consultant & Developer
Duration: Jan 2006 to March 2006

Responsibilities:

• Implementing of SAP Netweaver 2004 SAP Enterprise Portal.
• External Facing Portal for Citizens of Mumbai who are going to access the Portal as Anonymous Users for different services
• Use of Light Framework for pages.
• Implementing Internationalization
• Making Bi-Lingual Portal
• Marathi Language Support which is not a standard feature of SAP Enterprise Portal
• Giving Anonymous Access in Portal
• Doing the Translation through Portal Content Features as well as PAR Files
• Anonymous access to Knowledge Management Documents
• Different Access to Anonymous and Non Anonymous Users
• Using the existing Tag Library as well as creating NEW Tag
• Creating Anonymous Access to anonymous users for Documents in Knowledge Management
• Changing Portals Title
• Created custom iViews using JAVA and JSP’s
• Creating iViews, Pages, Roles and Stylesheet
• Creating Universal Worklist
• Implementing ESS on Portal side and used Standard Features of ESS
• Creating customized Log-On Page
• Integration of Stateless BSP Application using Web Request.
• Creating and Using Breadcrumb as a Navigation Technique for User Interface
• Creating the Brand Book as per client Brand requirements
• Using Multiple Replacement Property to replace the value in bulk
• Integrating with SAP CRM
• Use of Business Packages for SAP CRM.
• Integration with Supply Relationship Management
• Created BEx Web Application iViews
• Integration of SAP Enterprise Portal (SAP EP) and SAP Business Warehouse (SAP BW)
• SAP BW Data Modeling: Designing of INFO Objects, Data Store Objects, INFO Cubes, INFO Sets
• SAP BW Reporting: Using the functionality of restricted key figures, calculated key figures,
• Formulae, different types of variables, exceptions, conditions, etc. in Query Design through BEx
• SAP BW Authorizations: Defining Authorizations, Roles as per client’s requirement

Confidential,Mumbai, India

Technology: SAP Enterprise Portal (SAP EP) and SAP Business Warehouse (SAP BW)
Role: Technical Consultant & Developer
Duration: Jan 2005 to Dec 2005

Responsibilities:

• Phase 0 implementation of SAP Enterprise Portal
• Implementation and Customizing of SAP Knowledge Management (KM) content in Portal
• Implementation of Collaboration features in Enterprise Portal
• Customizing of SAP Portal PAR Files using SAP Netweaver Developer Studio
• Experience in Designs and Layouts of Portal
• Implementing Single Sign On (SSO) with SAP Applications
• Creating and Using Breadcrumb as a Navigation Technique for User Interface
• Creating the Brand Book as per client Brand requirements
• Changing Portals Title
• Creating iViews, Pages, Roles.
• Creating the Stylesheet
• Creating Universal Worklist
• Responsible for Monitoring process chains and Rectification of failures.
• Responsible for resolution of issues and development tasks assigned through Mantis.
• Responsible for Problem resolution of nightly extracts for Master/Transaction loads scheduled through Info package groups.
• Responsible for client interaction to understand their requirements, type of service call and to resolve their online queries.
• Extensively worked with PSA in Monitoring Data Transfer from Source Systems into BW
• Responsible for transportation of customized objects to QA.
• Developed Recalculation of Web templates and Reporting agents and used them as part of process chains.
• Developed reports with complex restricted and calculated key figures.
• Environment: SAP R/3 4.7, SAP BW 3.1, SAP Solution Manager 3.1,SAP EP 5.0 MS Excel, Windows 2000/NT

Confidential,Mumbai, India

Technology: SAP BW and SAP Solution Manager
Role: Technical Consultant & Developer
Duration: Jan 2004 to Dec 2004

Responsibilities:

• Data extraction from SAP and non-SAP systems.
• Creating, replicating and transporting data sources (e.g. extract / transfer structure, DTP & Transformations).
• Metadata uploads, uploading transactions, master and hierarchy data.
• Creating and maintaining info-objects, attributes, key figures etc.
• Creating and Managing cube and DSO.
• Data activation; Index creation; Create, maintain, schedule info-packages (SAP systems, flat files etc.).
• Maintain PSA; Aggregates (select, optimize); Event controlling (creating, scheduling, editing process chains).
• Creating, maintaining variables, master data translation; Roles & Authorizations (create, assign, maintain).
• Involved in the Pre – Sales activities of SAP Solution Manager
• Defining System Landscape & creating RFC connections
• Requirement gathering and Support Desk Configuration
• Creating BC Sets
• Creating E – Learning Programs
• Training the Project Team Members
• Environment: SAP 4.7, BW 3.0B, Windows NT

Confidential,Mumbai, India

Technology: SAP Business Warehouse (SAP BW)
Role: Technical Consultant & Developer
Duration: Sept 2003 to Jan 2004

Responsibilities:

• Worked extensively in the Data Modeling of SD, PP and HR InfoCubes.
• Created Generic Data Sources.
• Created InfoAreas, Application Components, InfoObjects and InfoSources to build Master Data Tables, ODS Objects, InfoCubes and Aggregates.
• Loaded Transaction Data and Master Data via Flat files.
• Created ABAP Conversion Routines in Transfer Rules and Update rules to load and update data into Data Targets.
• Created Formula Conversion Routines using Transformation Library to create formulae for Concatenation, Date Change and String Manipulation.
• Created Process Chains to schedule periodic data loads.
• Managed and monitored several data loadings. Optimized the load performance by adjusting the packet sizes.
• Involved in scheduling the Roll Up of data from aggregates into InfoCubes. .
• Thoroughly analyzed Short Dump and Application Log reviews to debug errors.
• Developed front-end queries using Query Designer and published results on the web.
• Environment: SAP BW 2.1C, SAP R/3 4.6C, Windows 2000

Education & Certification:
- Bachelor of Engineering Information Technology (B.E. I.T.)
- Post Graduate Diploma in Advanced Computing (C-DAC DAC Course)