SUMMARY:

• Above Eleven years of experience in information technology which includes 9 years in SAP BW/BI.
• Worked on Four life cycle implementation, Rollout, Upgrade and Support projects of BI/BW for well-known international companies, primarily in the FMCG, FMCD, Retail, Supply chain management and Utilities
• Expertise knowledge in data modeling, data extraction and front end reporting.
• Expert in implementation methodologies in phases of projects Project Preparation, Blueprint, Realization, Final Preparation and Go-Live and Support activities
• Expertise knowledge on User Requirement Gathering, GAP Analysis, Design, Development, Transportation of objects, Testing, Reconciliation of data and Post Go-Live support.
• Expert in work with the Client's process teams in identifying and documenting necessary reporting requirements to build a reporting architecture.
• Prepare project related documentation functional design, technical design, test scripts during the different stages of a project.
• Good knowledge on Business Objects Web Intelligence.
• Extensively worked on BI accelerator issues and upgrade
• Relevant exp rience in BPC 10.0
• Relevant exp rience on Enterprise Portal.
• Good functional knowledge on SAP R/3 application areas like MM, QM, PP, SD,AP,FI CO and IM
• Good knowledge in IS-Utilities
• Good knowledge on ABAP transformation field routines, Start routines, End routines, Expert routines, user exit and data source enhancements
• Extensively worked in LO extraction, FI-CO and COPA.
• Expertise in Inventory data management.
• Expert in activating standard Business Content repository objects
• Expertise in backend Business warehouse components like Info Cubes, DSO, Info Objects, Multiprovider, Infosets, Transformations, DTP and Info Packages
• Expert knowledge of SAP BW components like enhancing standard Data Sources, creating Generic Data sources, User Exits, OLTP extraction data, Loading Full/Delta Up-Load , Scheduling, Monitoring, Data Mart and Open Hub Service.
• Extensive experience in front-end Business Warehouse Components like Queries, Calculated Key figures, restricted key figures, Structures, Cell definitions, Variables, Exceptions, Conditions.
• Expert in Bex Designer, Bex Analyser and Bex Reporting Performance improvement techniques enhanced reports for fast reporting, OLAP Cache Monitor, Aggregates, Compression, Partitioning of cubes, Line Item Dimensions, dropping and creation of indexes on the
• Extensively worked with the clients and SAP in improving the performance of critical business reports.
• Extensive experience in create and automation of Load process by creating Master data and Transactional Process chains
• Expert in Production Support Batch issues, System Monitoring, Building stats and fixing of data loads.
• Good knowledge in effort estimation for change requests and new RFSM's
• Experience in Bug Fixing for reports, solving production issues.

Technical Skill

• ERP : BW 7.3, SAP BI 7.0 and BW 3.5
• Business Process : SAP R/3- MM, PP, QM, SD, FI, CO
• Business Objects : Business Objects 4.0
• Planning Tools : SAP BPC 10.0
• Performance Tools : BI Accelerator 7.2
• Portal Technology : EP 6.0
• Databases : Oracle, HANA 1.0

Professional Experience

Confidential

Environment : BI 7.0, BW 7.3, Business Objects 4.0 and ECC 6.0

Planning Tools : SAP BPC 10.0

Development and Support Activities:

• Working as a Solution Architect .
• Understand the new business process and reporting requirements by interacting with Sr. Managers, COE leads and Business analysts
• Effort estimation for new development and change requests
• Feasibility analysis, fit-gap analysis and provide the high level design to satisfy the User requirement
• Participate in BPC and BI Interface Discussions
• Resolve the User created issues in BI/BPC.
• Responsible for all BI accelerator issue resolutions
• Handling change requests, User tickets solve performance related issues.
• Create/enhance existing DSO, Cubes, info objects, Multi providers etc as per new design
• Experience in designing, developing, modifying WEBI Reports with multiple data providers
• Create/enhance data sources in various applications using user Exits as per the requirement
• Responsible for Unit testing, Integration testing and User acceptance testing UAT
• Develop new queries and published them as Iviews on the portal, change the existing queries as per the requirements
• Work on all BI accelerator activities Create/delete index, RSDDV, RSDDBIAMON2, TREXADMIN and regular maintenance activities
• Leading the team with onsite- offshore base model
• Responsible for monthly scheduled, un-planned outage activities in BI area and work with Tivoli team to manage the daily /weekly batch jobs.
• Responsible for all Weekly/Month/Year end critical reporting and recon activities.
• Actively participate in Bug Fixing for reports, solving production issues, Implementing SAP Recommendations.
• Participate in the Daily/Weekly/Monthly BW Status on BW Job monitoring, Reconciliation Activities, User tickets resolution and Root Cause Analysis submission

Upgrade activities:

• Played Pivotal role in SAP BW 7.3 and BI accelerator 7.20 Upgrade project estimates and deliverables
• Extensively worked on ASU, SPDD and SPAU activities
• Responsible for Pre and Post ABAP/Java stack split testing
• Responsible for BW remediation activities and BIA checks
• Extensively worked with SAP for critical SPDD,SAPU programs errors, BI accelerator errors and implemented the SAP recommendations
• Worked on BIA activities Create and Delete index, RSDDV, RSDDBIAMON2,TREXADMIN
• Responsible for all functional testing Extraction, Modelling, Front end, Data loading and monitoring, Portal checks
• Extensively worked on defect analysis and resolution, Emergency modifications and corrections, support during application failure, preventive maintenance activities and application health checks.

Environment : SAP BI 7.0 and ECC 6.0

Performance Tools : BI Accelerator 7.0

Project Description

The scope of the project includes modules to support Financial Reporting, Logistics, QM, Procurement, SD, Manufacturing, BI and other customer facing functions. This also is an extension of their existing Enable I project.

Project Responsibilities

• Work with the Client's process teams in identifying and documenting necessary reporting requirements to build a reporting architecture.
• Involved in Fit-Gap analysis, Design and Development for Logistics.
• Responsible for creating the technical specifications and business blueprint documents.
• Analyzing business reporting requirements that could be satisfied by Business content and installed the related business content objects.
• Participate in co-coordinating the onsite and offshore activities and help translating the Reporting functionality to technical terms
• Involved in designing the data model by identifying the characteristics for dimension and key figures for the fact tables and defined the display and navigational attributes for the BI extended star schema.
• Responsible for create and maintain the Info Cubes, DSO, Info Objects, Info Areas, Multiproviders, Infosets, Transformations, DTP and Info Packages
• Responsible for enhancing the standard Data Sources and creating Generic Data sources.
• Developed flexible queries using Filters, Free Characteristics, Navigational attributes, Cell definition, Variable etc in BEx Designer to facilitate data analysis in a drill down version to enable the easy access of information at various levels of management hierarchy.
• Work on collaborating for the design and specifications for the individual objects to be developed.
• Developed Process Chains for MD and Transaction data loads to automate the load processes and created Meta chains to streamline dataload activities via Tivoli scheduler
• Participated in UT, IT and UAT
• Closely worked with Tivoli team to schedule and monitor the dataload jobs
• Fine tune the under-performing BI Info Providers using the index, Cube partition and Cube Repartitioning to improve the query performance
• Responsible for transporting objects across the landscape.
• In support actively participated in Bug Fixing for reports, solving production issues, Implementing SAP Recommendations.
• Reconciliation of data between R/3 and BI.

Environment : SAP BI 7.0 and ECC 5.0

Project Description

The scope of the project includes modules to support billing, customer care, device management, FICA, credit and collections, BI and other customer facing functions. This also is an extension of their current SAP implementation that was started in 2003 with FICO, MM, PM, and PS, and then and HR/Payroll project in 200

Project Responsibilities

• Analyse the legacy system farm, understand the existing Reporting requirements and Propose Business Intelligence solution for IS-U industry vertical based on SAP BI
• Participate in co-coordinating the onsite and offshore activities and help translating the Reporting functionality to technical terms
• Understand the IS-U processes and Master data and carryout the relevant Data Analysis steps to cleanse the data formats out of the existing legacy system
• Involved in GAP Analysis, Design, Development, Testing, Reconciliation of data for Billing and FICA.
• Delivered technical documentation corresponding to Utilities MD,TD objects in the BI solution
• Understood the Functional BI Reporting Requirements in IS-U Billing, DM, FI-CA areas, and interacted with the technical team to come up with the corresponding BI Technical documents
• Identified the Gaps and enhanced the BW Objects to meet the Reporting Requirements in IS-U Billing, FI-CA and Master Data objects
• Created and maintained Info Cubes, DSO, Info Objects, Info Areas, Multiproviders, Infosets, Transformations, DTP and Info Packages.
• Analyzed the IS-U Billing business reporting requirements that could be satisfied by SAP-Delivered Business content and install the related BC objects
• Developed flexible queries using Filters, Free Characteristics, Navigational attributes, Cell definition, Variable etc in BEx Designer to facilitate data analysis in a drill down version to enable the easy access of information at various levels of management hierarchy.
• Developed BW Process Chains for MD and Transaction data loads to automate the load processes and created Meta chains to streamline dataload activities via RedWood scheduler
• Followed the established Change Management Policies and transported all the BI objects across the landscape.
• Fine tune the under-performing BI Info Providers for Sales Statistics and Meter Reading documents to improve the query performance
• Implemented the SAP Recommendations for Master Data issue, Load performance issue for Sales Statistics cube and connection object issue.

Environment : SAP BI 7.0 and ECC 5.0

Project Description

The scope of the project is implementation of SAP ECC 5.0 and SAP BI 7.0 to consolidate all HUL systems on the SAP platform and align with Unilever global standards.

Project Responsibilities

• Interacted with users to identify the business requirements and understood the business process and functional specifications after a series of requirement analysis sessions.
• Involved in User Requirement Gathering, GAP Analysis, Design, Development, Testing, Reconciliation of data and Post Go-Live support.
• Analyzed business reporting requirements that could be satisfied by Business content and installed the related business content objects.
• Created and maintained Info Cubes, DSO, Info Objects, Info Areas, Multiproviders, Infosets, Transformations, DTP and Info Packages.
• Good knowledge in Logistics Cockpit configuration and customization
• Interacted with in SAP for Blueprint Audit and realization phase Audit.
• Designed and developed process chains RSPC for master data loads and Transaction data Loads to automate the load processes.
• Developed flexible and complex reports using Filters, Free Characteristics, Navigational attributes in BEx Designer to facilitate data analysis in a drill down version to enable the easy access of information at various levels.
• Worked with Client team in testing phases like UT, IT and UAT.
• Developed reporting jump targets using RRI RSBBS to reports and R/3 Transactions.
• Responsible for transporting BI objects across the landscape.
• Bug Fixing for reports, solving production issues, Implementing SAP Recommendations.
• Reconciliation of data between R/3 and BI.

Environment : SAP BW 3.5

Project Responsibilities

• Solving of tickets regarding extractions, Reporting, performance issues and also load failures
• Schedule Daily/Weekly/Monthly data loads and schedule new jobs.
• Weekly schedule change-run Activities.
• Monitor the BW loads fix those if any issues.
• Resolve BW Query fault and change requests.
• Involved in Reconciliation to ensure the data integrity between SAP R3 and SAP BW.
• Monitor reports and address performance issues if any.
• Review and propose improvements to existing BW Support processes.
• To communicate with the user who post the ticket.
• Maintain and update production ticket details and completed the tasks with in SLA breach
• Worked in building Queries by using Calculated and Restricted key figures, Structures, Variables, Conditions and Formulas.

Other COE Responsibilities:

• Involved in COE activities to build SOPs at Practice level
• Developed customized implementation tools Rollout Upgrade Projects
• Developed Proof of Concepts such as Purchase, Inventory Analysis, Production planning etc Environment : SAP BW 3.5

Non SAP : VB Oracle

Implementation, Rollout Support Responsibilities

• Performed analysis, design, development and implementation of standard/ customized InfoCube, Multiproviders and ODS Objects.
• Analyzed business reporting requirements and Installed business content.
• Created Update rules, transfer rules as per requirement.
• Logistics Cockpit configuration and customization.
• Configured Process chains for Master data and transaction data as per report requirements, at a frequency of daily, weekly, monthly and Monitoring loads
• Uploaded the master data and transactional data from sap R/3 via PSA, ODS and infocubes.
• Good Knowledge in Transport Organizer
• Monitoring the data load and resolving the errors in data loading process.
• Help the end users in their difficulties in understanding the BW reports.
• Creating New reports
• Enhance the cubes as per delta requirements
• Explaining existing blueprints and Identifying the Delta points after analyzing the requirements
• Training the core team members representing each company
• Good experience in dealing with Reconciliation of data between R/3 and BW
• Developed flexible queries using filters, calculated key figures and restricted key figures in BEx analyzer to facilitate data analysis in a drill down and summarized way to present detailed level of information.
• Developed reporting jump targets using RRI RSBBS .
• Solve the escalated Queries in the Solution Manager and help the Support team to resolve it.
• Imparting training as and when required at different management levels.

Enterprise Portal

• Hands on experience in integrating BW Queries with Enterprise portal through iviews.
• Excellent in Content Administration where managing the iviews, Pages, Worksets, Folders, Roles
• Excellent in User Administration where creating Users, Groups Assigning Roles to users.

As a team member in Oracle based in-house Package my roles is as follows

• Generating MIS Reports for All the departments Like Materials, Purchase, Productions and Quality on daily and monthly basis.
• Compiling and generating the COO Formats and HO formats.
• Training the new user on how to use package.