SUMMARY

• Having 11+ Years of Work Experience in SAP BI/BO with ABAP.
• Involved in 3+ implementations ( both 3.5 and 7.0) and numerous support projects as well
• Involved different types of applications like OTC, P2P, PROD, QM, PM and FIN analytics as per business needs.
• As a lead consultant involved in requirements Gathering and provide solutions to business needs. And also dealt with ODC for development and support activities.
• As a SAP BI consultant involved in maintenance of BW systems, which includes Data - Modeling, Data Extraction, Reporting and Production Support activities. Few tasks are listed below.
• Enhancement of data sources, user exits, LO extraction, Finance extraction and Generic extraction includes function module.
• Extensively involved with delta management with standard and customer extractors.
• Proficiency in Designing data flows by using BI objects ( Data sources, Transformations, DTPs, DSOs, Info cubes, Info sets, Multi providers)
• Extensively involve with Design queries by using structures, RKF, CKF, Variables including exits, filters, exception conditions etc.
• Involved in Web intelligence Reporting and Dash boards by using WAD.
• Extensively involved in Process chains and Support issues includes data load monitoring.
• Expertise in solving the user issues through gRemedy HD tickets.
• Involved all levels of Debugging techniques to trouble shoot the issues like data loads, extraction, variables, DTPs etc.
• Involved in various level of Routines (ABAP code)
• Involved in Business content, BW statistics and performance issues
• Having ability to communicate effectively at all levels of Application Development phases in the Company.
• An excellent team player as well as an individual contributor with good communication and interpersonal skills.
• Quick learner and stronger desire to master in new Technologies.
• Extensively worked on Universe, Webi, Crystal Reports and Dashboards in BO XI 3.1
• Designed webi reports for sales and purchase applications.
• Designed PO dashboards by using the Xelcious.
• Designed BO reports based on Universe and Sap BEx queries as well

PROFESSIONAL EXPERIENCE

Confidential, CA

SAP BI Analyst

Responsibilities:

• Involved SAP-Business Intelligence professionals design, implement and deploy SAP business intelligence solutions for end-to-end data warehousing and analytics including SAP BI, and Business Objects (BO).
• Involved in Global Supply Chain Project GSPR implementation and Enhancements.
• Design and Developed BW data flows from ECC and APO systems as part GSPU.
• Design and Develop data flows form BW to WEbi reports using Universe connection, Universe Design and Webi reports.
• Created Data security Profiles and Applied to user groups in Universe design.
• Involved the worked on various SAP components including Designer, Reports, Web Intelligence, Info View, Broadcast Agent Publisher, Import Wizard, LCM, and Central Management Console (CMC) and So on.
• Created GSPU universe which joins 5 modules transaction data with Common dimensions of master data by using the contexts.
• Involved in Enhancements and Issues related to GSPU, QM, GCU, Grower Reliability and Prod Ops universe on top of Views .
• Migrated BW/BO Objects from development, testing environment to Production environment using delivery units.
• Resolved the Prompt issues, data format issues in Universe and Webi as well.
• Created Webi reports extensively using tables, Cross tabs, Sections, breaks Merge Dimensions and so on..
• Involved in Webi reports extensively by using formulas like For each, For all, Running sum, Previous, Self, User response and So on.
• Involved in FOCUS dash board report by using Gauge, Odometers Drop downs, Radio buttons and So on..

Confidential, San Francisco, CA

SAP BI/BW Analyst

Responsibilities:

• Worked as Offshore/Onsite team lead for both Development and Support teams.
• Involving the Business Requirement Analysis, Updating the FS and TFS, Development and test, Migration and test, UAT, Deployment and Cut Over tasks as well.
• Developed Inventory coverage, production plan performance, current production schedules and other Performance metric reports
• Developing the Test Scripts for UAT in Test Directory.
• Re design data flows per data load optimization
• Working on SCM (PP, PM, and QM)) Enhancements.
• Developed Sales and purchasing reports on webi and xelcious.
• Worked on OLAP connections through Business Intelligence Consumer Service (BICS)
• Working on tickets through gRemedy on both HD and CR.
• Involving Tracker update meetings to prioritize the CHGs.
• Guiding team members on technical issues

Confidential

SAP BW Lead

Responsibilities:

• Requirement analysis, Creation of Architectural design documents.
• Migrating the existing EDW system into BI system
• Activating the LO Cockpit Datasources from R/3 side,Deletion of setup tables,Initialization of setup tables.
• Created the EDW layer, Integration layer, Reporting layer DSOS in the Item level and produced the report based on the requirement.
• Creation of Datasources, Infoobjects, DSO objects, DTPs, Multiprovider.
• Worked on PROP module. Created Write-optimized DSOS, Integration Layer DSOS for Order, Operations and Components and produced reports on those cubes.
• Worked on Start Routines, Update rules, Transfer rules and User Exits.
• Worked extensively on Restricted key figures (RKFS),Calculated Key. figures(CKFS),Structures, Conditions, Exceptions, Free characteristics, Filters in BEX Reports. Etc.
• Worked on Collective updates, various delta update modes based on ROOSOURCE, RODELTAM tables.

Confidential, San Francisco, CA

BW team lead

Responsibilities:

• Worked as an onsite coordinator and Developer(USA - California)
• Handling Issues during the Quires Conversion- BI 3.5 to BI 7.0.
• Doing Thorough Unit Testing and CIT Testing.
• Working on Open Issues in Remedy.
• Checking the Queries performance in CIT Server.
• Checking Same in G2G- Gen portal.
• Maintain Query Cleanup Activities along with CIT Track leads.
• Identifying Workbooks, Y-queries etc.
• Developed the Test Scripts for UAT in Test Directory.
• Working on PROP EDW Project ( New enhancement for PROP)

Confidential

BW Consultant

Responsibilities:

• Worked as an onsite coordinator for 3 months(USA - California)
• Working on tickets through gRemedy on both HD and CR
• Finance reconciliation on weekly basis
• Call monitoring activities and assign tickets
• Guiding team members on technical issues
• Checking the system performance
• Involved in Up gradation activities
• Re design data flows per data load optimization
• Worked on P2P Enhancements.

Confidential

BW Senior Consultant

Responsibilities:

• Monitor process chains (daily, weekly and monthly)
• Working on Notifications like RQ, IN and PR
• Sales reconciliation with G/L on weekly basis
• Call monitoring activities and assign notifications
• Guiding team members on technical issues
• Assign roles to end users and 1st line support by checking approvals from controllers
• Coordination with development team for import transport requests to BWP.
• Checking synopsis documents which are handover by development teams
• Maintain BW-Support Documents as per organizational changes
• Checking the system performance
• Maintain RCA documents for data load failures
• Involved in Up gradation activities
• Creating daily error reports and So on.

Confidential

BW Technical Consultant

Responsibilities:

• Understanding Functional documents
• Involved in impact analysis.
• Preparing Functional and Technical documents.
• Attended weekly status update meetings
• Changed and created objects in BWD.
• Developed Currency translations routines
• Conduct unit test after preparing test scenarios
• Transported developments to BWQ environment
• Test the Developments in BWQ and generate reports for UAT
• Finally coordinate with BW-support to move those developments into BWP.
• Test in BWP and inform to user about the changes

Confidential

BW Consultant

Responsibilities:

• Collect all info
• Impact analysis
• Design of the BW data model and R/3 Extraction
• FD Updating
• TD Updating
• Development
• Unit Test BWD
• Corrections
• CR test in BWQ
• UAT in BWQ
• Corrections
• Documentation
• Check in BWP

Confidential

SAP BW Consultant

Responsibilities:

• Design, development and implementation of Customized Info Cubes and ODS objects.
• Redesigned the data flows and reports as per M2MR (Move to Monthly reporting) compliance.
• Analyze existing Data modeling using extended star schema concepts.
• Source system compounding for strong characteristics as per the new design principle. Uploaded Master and Transactional data from flat files and SAP R/3.
• Involved in high level partitioning of the data target.
• Involved in installing Business Content for standard Info objects, Info sources, and Data sources.
• Configured LO-Cockpit and setup the Statistical Setup for the LO-Cockpit and used the V3 Update for Delta Management.
• Set up procedure for extracting R/3 data for Sales Order, Delivery, Billing Document in Sales and Distribution using LO-Cockpit.
• Creation of Info Packages for scheduling the data load process with Full and Delta update mode.
• Created data marts to extract data from BW system itself.
• Prepared Test cases for Unit Testing, integration testing and Data reconciliation.