SUMMARY

Mr. Ravi has overall 9 years of work experience in SAP BW/BI/ABAP/BO which includes working with Global and Domestic clients.

• Extensively worked on all phases of SAP BW/BI project lifecycles including Analysis, Architecture, Design, Development, Data Extraction, Staging and Storage, Transformation, Presentation, Testing, Cutover/Go-Live Planning, User Training, Knowledge Transfer, Deployment, Production Support, Change Control, and Change Management.
• As a techno functional consultant he was involved in all facets of SAP BI including modeling, extraction and reporting.
• Demonstrated experience in all phases of systems SAP implementation- Requirements gathering, Blueprint, Architecture, GAP Analysis, Actual Build and Post Production Support phase.
• Extensively involved in integration projects where there are requirements for both inbound and Outbounds from SAP BW environments to the third party applications.
• Implemented Open hub/Info spokes/APD's for sending the data from SAP BI System to external applications.
• Exceptional skills lie in Architecting SAP BW data models and taking on challenging projects, tuning performance by analyzing the ABAP code and resolving the support issues. Mentoring team members.
• Experience in handling ABAP code for data source enhancements, transformations, user exits, start and end routines, BADIs.
• Worked extensively with BEx Analyzer and Query Designer for developing and analyzing reports. Built front-end queries, using filter, condition, exception, hierarchy and variables User Entry, Customer Exit
• Involved in end user training , architecting the warehouse layers for new requirements, understanding customer issues and troubleshooting the same , conceptualizing design and has been involved both on the technical and functional aspects of the same.
• Enhanced standard data sources, programmed user exits for data sources and variables, customized transfer, start routines and end routines using ABAP routines.
• Expert in use of process chains to automate loading of all master and transaction data.
• High-volume data load management and improvements to data load performance.
• Performance tuning of queries by maintaining aggregates, compression, partition, indexing of Info Cubes and use of statistics for the same.
• Extensively involved and led the technical and functional BW migration projects from 3.0B till 7.3 Version.
• Strong SAP functional experience such as FI-GL, FI-AP, FI-AR, FI-AA, COPA, P2P, PS, PM, SD and MM.

Technical Expertise's:

• Operating Systems Windows XP/2000/NT
• Databases Oracle 9i, SAP HANA
• Languages ABAP/4
• Reporting Tools SAP BW BEx Business Explorer , Business Objects 4.0
• Dashboard Tools WAD, Visual Composer, Crystal Xcelsius 2008 Adobe Flex
• Data Warehousing SAP BW 3.0B, 3.5, BI 7, BI 7.1, BI7.3
• Planning Tools SAP BPC 7.5 BPC 10.0

EXPERIENCE

Computer Associates

Confidential

• Lead Reporting projects, working with customer, collecting requirements, analysis, designing, developing and testing of BI projects.
• Performed Requirements Gathering Analysis by actively soliciting, analyzing and negotiating customer requirements while leading the technical requirements analysis, driving the system design and construction
• Designed and developed software applications using Software Development Life Cycle SDLC method and conducted user and business meetings
• Collaborated with key internal and external decision makers to recommend process enhancements
• Worked with the Power Users, Data modeling team, ETL team and Higher Management to define the requirements. Review the requirements and convert them into design specifications.
• Collaborated with different technical teams to understand the design obstacles and made sure that the deliverables are achieved within the budgeted period.

Confidential

SAP BW/BI Data Architect

• Involved in building the test systems as part of the Finance BW deployments for supporting the testing activities by different User groups.
• Extensively involved in validating the system configurations and settings before the actual handover of the environments to the End users for different testing phases.
• Validated the BW data flows and extractors as part of the deployment and ensured the readiness of a test system for effective testing.
• Activated transformations, DTP's and Multi providers in case if they are inactive while the system is copied from a different environment.
• Extensively involved in identifying the root cause of the missing objects during system readiness.
• Closely worked with Change Migration team and Involved in retrofit activities for all the missing transports.

• Extensively involved in gathering the Business requirements for Finance and Mergers and Acquisitions reporting Solutions.
• Closely worked with Business teams to understand the business scenarios for Finance reporting solutions and effectively translated them into technical deliverables.
• Extensively working on setting up the integration patters for sending the data from the SAP environments for further reporting purposes.
• Extensively created Open hubs and APD's to send the data from SAP BI environment to the external applications for further reporting purposes.
• Involving in SAP designing improvements for the Business Warehouse environment.
• Enhancing the existing finance Product costing and Network activity data models or reports based on the client requirements.
• Developed Single level and Multilevel Itemization reports based on the Product costing extractors and cubes.
• Involved in building up the reports related to the WBS, Network Activity and Network Activity Elements extractors.
• Led the effort of Implementing Logical partitioning for the Finance related BW Info providers.
• Involved in developing several finance, Balance Sheet, Summary financial report, commitments report, Benchmarking report, Spend Analysis report, SLA Audit report, CWT Travel Expenses report, etc
• Involved in implementing Account based and Costing based COPA.
• Extensively involved in analyzing and resolving the high priority production issues as part of the L4 support team.

Confidential

Sr. SAP BW/BI Consultant

• As SAP BI Lead handled global BW project management/implementation, QA testing, offshore coordination and production support with hands-on technical and functional expertise on Enterprise Data Warehouse EDW and Enterprise Reporting Analysis.
• Extensively involved in preparing the data models for Procure to pay, Source to Contracts, Fixed Assets, Real Estate Project Systems Modules.
• Individually performed the Data Modeling PLAT real estate Module.
• Developed the data integrity pattern for the inbound data from third party applications to SAP BW environment.
• Extensively worked on new features in BW 7.3 such as Semantic Partition Objects for decreasing the Load durations for the Fixed Assets Extraction.
• Extensively involved in sending the data to Web focus environment using Outbound objects in SAP BI environment.
• Extensively involved in developing multiple custom extractors based on the standard SAP ECC tables, View and complex function modules using ABAP coding.
• Performed multiple roles in the project at different phases to support Realization and testing phases.
• Extensively worked as a liaison between the technical and functional team across all the phases of projects.
• Involved in developing the complex reports using the Exception aggregation, RKF's, CKF's and various query elements to meet the business requirements.
• Independently driven the cutover activities for all the non-production and production environments.
• Worked extensively on the LO extractors to get the Purchasing and Invoice details into BW environment.
• During performance testing, extensively involved in optimizing the data load and query performance..
• Load performance analysis/optimization of data warehouse during the performance testing phase through BI Statistics, Semantic Partitioning/Repartitioning Remodeling functions of Info Providers through redesigning.
• Involved in providing the solutions for the defects/CR across P2P/PS/FA/S2C functional areas during the FIT1, FIT2, E2E and UAT testing phases.
• Involved in enhancing the FI and LO extractors to meet the Business reporting requirements.
• Worked with multiple downstream applications such as EDW, Data stage and terra data to send the data out from BW system for further reporting purposes.

BW 7.1 to 7.3 Migration

SAP BW Technical/Functional upgrade

• As part of the upgrade from BW 7.1 to BW 7.3, oversaw a technical migration and subsequently did a functional migration to utilize the new functionalities in BW.
• Effectively handled the Data load issues after completing the technical upgrade.
• Suggested to Implement the SAP notes for few of the known BW issues post upgrade activity.
• Have involved in testing the environment both backend data models and front end reporting post upgrade.
• Effectively worked on the Semantic partitioning Objects as part of the functional upgrade, which resulted in reducing the data load times and also the query runtimes.

Confidential

Lead/Sr. SAP BI/BW Consultant

• Designed, developed and supported BW solutions based on requirements gathered from the business in the area of Finance.
• Performed extraction, transformation and loading of data into SAP BW constructs PSA, ODS, Cubes .
• Programmed custom user-exit extract function modules to include data missing from SAP Business Content.
• Gathered business-reporting requirements, designed and developed solutions, tested/verified the solutions, migrated the solution to production, and provided ongoing support.
• Designed and created new BW objects Info packages, ODSs, Cubes, Info objects, Transfer structures, Data sources .
• Extensive experience with the BW Administration Workbench and LO Data Extraction Cockpit.
• Designed and created BW Queries using Business Explorer BEx .
• Developed complex WebI reports on top of multiple BEx queries merged dimensions, drill down to detailed reports using the hyper link functionality.
• Used SAP BW statistics to improve performance of SAP BW system.
• Involved in production support activities such as data load failures, bad data analysis and other backend issues.

Confidential

SAP BI Consultant

SAP BW Implementation for Secondary sales and Up Gradation from 3.x to BI 7

• Oversaw a technical migration to BI7.0 and subsequently did a functional migration to the new data flow.
• Demonstrated expertise in managing data warehouse performance at all levels
• Have architected and managed a 9 Terabyte data warehouse for HUL focusing on outlet level sales data.
• Information broadcasting as delivery of Reports via eMails.
• Used the new Re-modelling Toolkit to migrate the whole Infrastructure from SKU7 to CBU.
• Supporting the Month-End Closure activity to ensure that the month-end activities are performed smoothly.
• Using Analysis Process Designer APD to fetch data from Query Data source and persisting in the DSO/Cubes. Using Aggregates to enhance the report execution speed.
• Extensively worked on BI 7.0 Archiving process to archive the data from huge DSOs and Cubes.
• Developed customer exits for various reporting requirements
• Developed Start routines , Update routines , End Routines , Transfer routines etc. for all stages of the data flow in BI 3.x and 7.0
• Developed custom programs and Transaction codes which were used for User ID migrations for Query views and also for Switching off BIA for specific queries.

Confidential

SAP BW/BI Consultant

• Responsible for developing the BP Finance BW LSA SAP BI systems and enhancements to the application.
• Involved in implementing FI GL, FI AR, FI AP new extractors.
• Analyzed and mapped financial business processes to BI and wrote Technical Designs using ASAP methodology
• Extensively involved in creation of Info Cubes, DSO, Info objects, Transformation rules, Extractors, Info sources, Info packages, DTPS, Data Sources, Data Extraction, Characteristics and Key figures.
• Used ODS objects to store external data and updated into various data targets based on the requirement using update rules.
• Involved in creating Generic Extractors using Views.
• Installed relevant Business Content Objects where and when required.
• Extensively involved in providing the logic for Routines and also Exits which are used to get the status of the Work Order based on different criteria.
• Developed Info sets using new capabilities of BI 7.0 to join Info cubes .
• Carried out Transports of all the Contents from development system to entire landscape.
• Created process chains and event triggers for job scheduling.
• Loading data via flat files into respective data-targets and consolidated into a single data-target..
• Maintained issue list, defect lists, support documents, end user training documents, review list.
• Scheduled data loads to BI from other BW systems, Monitored data loads which are running hourly, daily, weekly monthly basis and solving errors when errors occurred.
• Involved in Validated data consistency in reporting with Data Target against PSA, source systems after loading them to data targets.
• Expertise in BEx-Analyzer, Condition reporting, Exception highlighting, Restricted key figures, Calculated key figures, Variables, Filter, Free Characteristics, Variants, Structures and RRI Report to Report Interface .
• Developed critical reports like Work Load Status Report, KPI Report, Notifications Report Costing report which is based on Day to Day Work Orders over a date range through Web Application Designer.
• As part of Data Provider Layer migrated data from SAP R/3 using LO Cockpit and Generic Extractor.
• Designed various types of Queries on SD and PM cubes and generating reports using BEx Analyzer Web Application Designer.

Confidential

SAP Business Analyst

Ryerson Prime Implementation/Support

• Analyzed and documented the high level design of the Current and Future State of the System for full understanding of the business.
• Involved in Functional analysis and prepared functional specification documents for technical designers.
• Analyzing the Business needs and converting them into the technical deliverables.
• Participated in the Mini Steering meetings with the Senior Stakeholders of the company in the Review and Status Meetings. Tracked Issue logs and generated Project Plans.
• Maintenance of data sources at SAP OLTP source
• Setup Flat file extraction for legacy data, Assigning Data Sources to the Info Source, Defining Transfer Structure,
• Installation of relevant SAP business content as when required.
• Data extraction into info cubes after creating transfer rules, info packages and update rules.
• Creation Maintenance of Standard customized Info Objects, Info Sources, Info Cubes, ODS, Info sets and info providers using administration workbench RSA1 .
• Created aggregates to improve the query response.
• Created modified queries based on the user requirement using Calculated Key Figures, Restricted Key Figures, Formulas, Exceptions, Conditions and Variables
• Involved in Monitoring of Daily, Weekly Monthly Loads.
• Participated in Rectification of Load Failure errors like Master Data Loads, Transaction Loads.
• Handled Tickets of Priority 4 5.
• Maintain list of all the activities for all the tickets until it is closed.
• Involved in Validated data consistency in reporting with Data Target against PSA after loading them to data targets.
• Monitoring of info packages and analyzing the reasons for frequent failures of info packages.
• Maintaining Reconciliation's to verify the data in SAP R/3 and SAP BW are same or not after the data loads.