SUMMARY

• Over all 13 years 4 months of professional experience as SAP BI consultant, expertise in projects End - to-End Implementation 6 full life cycles, 24X7 Support, BI 7.0 upgrade and SAP BW 7.31, BI - SAP Business Objects 3.2XI integration, SAP BI4.0 Upgrade and Enhancements to existing application, with proven track record of company and customer satisfaction.
• Experience of 6 full (end - to - end) life cycle implementation projects, with experience in all areas of SAP BI viz. Data Modeling, Data Extraction, Data staging and Reporting.
• Extensive experience in 24x7 support projects involved in addressing several end-user tickets, proposed and implemented change requests to improve business processes, and monitoring the data loads and other data warehouse maintenance activities.
• Experienced in Architecting and Designing end to end implementation of BW projects involving Business Blue print, preparing Functional and Technical Specifications and defining Testing Strategy.
• Expertise in Migrating SAP BW 3.5 to BI 7.0, and implementation of new functionalities of BI 7.0 and SAP BW 7.31.
• Experienced in SAP HANA implementation, SAP System Landscape transformation (SLT), SAP HANA data modeling using Attribute View, Analytic View and Calculation Views. Knowledge in using SAP BODS.
• Experienced in importing SAP BW Models in SAP HANA, Converting the standard DSO into HANA Optimized DSO, Standard Info Cube into HANA optimized Info cube.
• Understanding of SAP In-Memory Computing Architecture, Column store, Row store tables in SAP HANA studio.
• Experienced in Configuring various Provisioning Methods viz SLT, Data Services, Flat File.
• Expertise in integration of BW with SAP Business Objects XI 3.2, SAP Solution manager, SAP Governance, Risk, and Compliance (GRC), SAP Resource and Program Management (xRPM).
• Experienced in Upgrading existing SAP BOXI 3.2 Business Objects System to SAP BI 4.0 using side - by - side installation approach.
• Implemented various BI solutions in logistic area (SD, MM, and PM), financial area (GL, AP, and AR), controlling area (CCA, PCA), SAP CRM, and SAP SRM.
• Extensive hands-on experience in data extraction from SAP R/3 systems using LIS, LO and Generic Extractors and from legacy systems using UDConnect.
• Extensively worked on data flow enhancements, performed data backup and history recovery without affecting the business users in Production systems.
• Expertise in complex query building using customer exits, SAP exits, virtual characteristics, cell editors, VBA code in BEx etc, and publishing reports to web/portal.
• Good Experience in activities related to Technical Upgrade and Testing, System Refresh, Production Releases, and Transportation of Objects from Development - QA - Production. Liaison with Basis team in assessing the pros-cons attached while installing new patches or plug-ins.
• Hands-on experience in the maintenance of information warehouse and good acumen in maintenance, trouble shooting, and performance tuning.
• Experience in manufacturing, energy and utilities industries business processes .
• ABAP/4 programming skills involved in enhancing various DataSources, preparing various customer-exit variables, creating transfer/update/start/end and expert routines.
• Worked on Roles and Authorizations (PFCG) and Analysis Authorization (RSECADMIN).
• Experience in leading teams and delivering solutions within time lines at the required quality levels.
• Extensively involved in project management activities like preparing project proposals, project plans, quality plans, Capacity utilization plans, PMRs, and conducting quality audits .

PROFESSIONAL EXPERIENCE

Confidential

Tools: Used: SAP ECC 6.5, SAP-BW 7.01/7.31

Responsibilities:

• Involved in phases of SAP BW implementation project configuration, testing, cutover, go-live and production support.
• Involved, Understand the gaps in the requirements.
• Reviewed the Entire Data model, Indentified potential Performance bottlenecks in the data flows. Resolved various performance related issues in data modeling.
• Involved in fine tuning the custom code written both at extractor level and Transformations level.
• Updated the High level design (HLD) document and Detailed Design Document and scope of the requirements and solution Overview.
• Managed UAT activities and supported Business during this phase
• Headed entire Cutover activities (BW object transports, prepared high level cutover plan and involved in Cutover simulation and actual cutover)
• Prepared the Service Management Technical Document and involved in Post Implementation support phase.
• Lead the Post Implementation Support team in fixing all the defects, improving the data load performance for both Standard and Custom extractors. Fine tunes the report performance by changing/moving the calculation from BEx query to OLAP Universe to WebI report level vise versa.
• Proposed BI Road Map for Confidential Client to migrate the Finance Reporting system from SAP BW on Oracle to SAP BW powered by HANA.
• Involved in defining scope, Architecture, design phases of the implementation and responsible to gather business requirements gathering for solution migration to SAP HANA.
• Worked in Consulting capabilities SME for Financial Business Analyst to define Functional scope, identify Gaps and define integration of Finance and controlling data Reporting solution on SAP BW on HANA.
• Created attribute, analytic and calculation views for Sales and Procurement modules as part of the current POC.
• Data Provisioning and replicating data from source system to HANA Database using SLT and Business Objects Data Services.
• Replication of the selected tables of SD from ECC to SAP HANA. Performed transformations during the replication process.
• Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies.
• Monitoring the replication process using SAP HANA studio and SAP LT replication server for transactional integrity.
• Experience in Importing meta data, Table definitions, Performing initial load and Replication, Resuming and Suspending data loads using SAP HANA IMCE(In memory calculation Engine) studio.
• Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
• Migrating standard InfoCubes to In-memory optimized InfoCubes using migration Tool.
• Importing the BW Models in to HANA using HANA Studio.
• Consuming the HANA Models in BW by creating the Transient Providers.

Confidential

Tools: Used: SAP ECC 6.4, SAP-BW 7.01

Responsibilities:

• Involved in all phases of SAP BW implementation project blueprint, configuration, testing, cutover, go-live and production support.
• Involved, Understand and gather business requirements for the four streams of Gas Distribution (Maintenance, Emergency & Meter Works, Repair and Construction). Conducted workshops with business owners to gather the reporting requirement. Helped the business in identifying the BI reports to measure the process safety KPIs.
• Involved in Identifying and classifying reports as operational or Analytical and checked the feasibility in SAP BW
• Prepared the High level design (HLD) document and Detailed Design Document and scope of the requirements and solution Overview.
• Prepared Functional specification for the requirements for Custom Reports, coordinated with offshore team in converting the functional specifications to technical specification.
• Developed logical data models, ETL Specifications, Source to staging, traceability matrix and Object Tracker. Guiding and assisted the team in developing technical specification. Carried out Internal and Supported design reviews by third party vendors. Managing the build and unit testing phases to provide quality deliveries.
• Managed UAT activities and supported Business during this phase
• Managed the BW object transports across multiple system landscapes, prepared high level cutover plan and involved in Cutover simulation and actual cutover.
• Prepared the Service Transition Technical handover document and involved in Post Implementation support phase.
• Developed regulatory reports like standard of service (SOS) and RIGS for operations
• Conducted process Knowledge transfer sessions to the off shore team
• Conducted Proof-of-Concepts on Integration of BW with BO XI3.0, Created OLAP universes on BEx queries, Developed WebI reports.
• Upgraded SAP BOXI3.0 system to SAP BI4.0, one of its first kinds in EU. Successfully upgraded 250+ WebI reports with minimum impact to business community

Confidential

Technical Lead (Onsite).

Responsibilities:

• Actively participated in Activating BI Content as per the Business requirements in the areas of HR, RE, FI and SRM (P2P) modules.
• Analyzing the Client requirements for various Custom Reports (HR & FI Module) in SAP BI.
• Actively involved in Reviewing the Report Detailed Definition (RDDs) and provided necessary comments for the same in line with SAP BI limitations, before Onsite team submitting to the Business.
• Actively involved in analyzing the requirement from the business and given the feasibility for the same to the Onsite-team. Understood the best approaches of SAP BI and applied it to various assignments like installing BI Content, Data Modeling, extracting, Generation of Reports and transportations for SW BAS program.
• Actively involved in feasibility study for the migration approach for SAP BI from 3.X to 7.0 versions.
• Worked extensively on SAP BI Query Designer & Web Application Designer (WAD) for various custom reports in HR. Created queries using BI-Reporting Variables (Direct/Replacement Path/Custom Exit Variables), Navigational attributes. Developed several queries and Web Templates using BEx Analyzer and WAD according to Business requirements.
• Worked on SAP BI for SW BAS Program to extract, Load, Transport, Configure, Monitor the loads and reporting.
• Proactively worked to identify the assumptions to be taken care while delivering the RDDs to avoid defects in objects while delivering.
• Involved in the SRM stream's implementations in the areas of e-procurement, vendor evaluation etc. Having in-depth knowledge in SAP BI technical and functional areas, helped team in resolving few challenging issues faced during the Integration testing. The biggest challenge was to resolve the failure of the BI transports to the production system. This required a lot of effort to work out and analyze the system independently and at the same time meet the project deliverables
• Designed the complete data flow process for each application in BW and subsequently created custom Objects and activated the required Business Content Objects which were part of the data flow.

Confidential

Tools: Used: SAP 4.7E, SAP-BW 3.1C, SAP ECC 6.0, SAP BW 7.0.

Responsibilities:

• Involved in documentation of the methodologies, preparation of test cases, executing of test cases, identify and resolving or raising OSS messages with SAP supporting/coordinating with BASIS and DBA, fixing the issues before and after Technical Upgrade from SAP BW 3.1 to SAP BW 7.0
• Supported BASIS team during the Post Refresh and pre-upgrade activities of the Development, Quality and Production Environments, Created Transport Requests to get the Source System Connectivity to SAP BI InfoSources, Deleted of all incorrect requests from InfoProviders, Checked the complete system for consistency. Prepared Test Plans, Test Cases and Review, executed the test cases, captured test case results and documented, resolving all the issues which are occurred when time to time.
• Converting all the Business Intelligence old functionalities with all new SAP BI 7.0 functionalities like Information Broadcasting, SAP BI Accelerator, Data Transfer Process, and Transformations. Converted in to all the new SAP BI reporting functionalities from old SAP BW report functionalities.
• Involved in understanding requirements, converting functional requirements in to Technical document. Modified the standard SAP R/3 Sales Extractor 2LIS 11 VAITM, added required fields, written Enhancement code, modified the Sales Orders Item Data ODS and InfoCube and created necessary reports for “Other Transactions Purchase Power (OTPP)” enhancement.
• Carried out Functionality testing, Performance testing, Load testing, regression testing and User acceptance testing of SAP BW system when the Application platform was migrated from HP-UX to IBM-AIX Operating System.
• Involved in developing reports Sales Pricing Calculations for Customer Material, Open Sales Orders Report, Shipment Report, Invoices History Report, Accounts Receivables, General Ledger Reports when we replaced the existing legacy system called IES (International Exports System) with SAP R/3.
• Involved in Data Load monitoring, RFC issues, IDOC's stuck up, server choking (Monitoring server to ensure that server is not over loaded at any point of time during workdays), handled user remedy tickets,
• Implemented PSA deletion strategy and monitoring the status. Founded recurring failures and provided permanent remedies for them. Discussed with Data source teams to fix data issues permanently.
• Carrying out performance related activities like Cube compression/Index rebuilt etc. Worked on Ad-hoc requirements from users either through mail/remedy where user wants something to be done on an urgent basis.