Home

Murthy - SAP BW/ HANA

surya.k@logicplanet.com

Location: Houston, Texas, USA

Relocation:

Visa: H1b

Resume file: Murthy SAP_1743600747987.docx Please check the file(s) for viruses. Files are checked manually and then made available for download.

Narasimha Murthy SAP HANA, BW/4HANA, BW, BOBJ Certified Consultant Executive Summary Over 15+ years in SAP HANA/BW4HANA/BW/BO/ABAP having worked with Commonwealth of PA State, SAP Global Delivery, Deloitte USA, IBM, HCL-AXON with excellent team leading skills SAP Certified in SAP HANA/BW/BO WebI 4.0 Information Technology Infrastructure Library (ITIL) Certified Excellent ability to understand and transform complex business requirements into functional design document for solution development, delivered on time, scalable, performance optimized and maintainable. Ability to interact with end users to understand various business requirements. Worked on multiple life cycle implementations of SAP S/4HANA, SAP HANA (Native HANA), BW/4HANA, BW on HANA, BW using SAP ASAP methodology right from conducting Workshops, Requirements Gathering, Creating Blueprints, Creating Specifications, Development, Testing, Documentation and End-user Trainings. Extensive experience in the Functional Modules such as General Ledger (GL), Accounts Payable (AP), Accounts Receivable (AR), Asset Accounting (AA), Cost Center Accounting (CO-CCA), Internal Orders (CO-IO) and Profitability Analysis (CO-PA); R2R, MM(SCM)-P2P, SD(OTC), IS-U(Utilities), FRE(RE-FX), Public Sector Flows (FM and GM), HR(HCM), CRM and SRM. SAP HANA/BW Expertise Worked on the new Data modeling techniques using BW/4HANA, BW on HANA methodologies such as ADSO, Composite Providers, Open ODS Views, ODP Extractors, SLT configuration and load monitoring using SLT. Created Open ODS views, ADSO s, Composite providers with the new Eclipse editor. Data provisioning landscaping methods such as SAP Landscape Transformation (SLT), BO Data Services (BODS), for replication/ extraction of data from SAP/ non-SAP source systems and on HANA integration tools SAP HANA business requirements architecture on SAP & non-SAP source systems including SAP BW on HANA, SAP BOBJ in large and complex environments. Modeling of SAP native HANA objects and developed Attribute Views, Analytic Views with various join conditions and Calculation Views using both Graphical and SQL script-based methods. Expertise in SAP ECC table data model and analysis. Proficient in creating Procedures, Calculated Columns, Restricted Columns, Filters, Hierarchy, etc. Proficient in SAP HANA Administration including managing schemas, data model objects, import/export content Worked on native HANA SQL scripting and PL SQL Worked on SDI Flowgraphs, Transforms and Data cleansing/manipulating using the adapters like file adapter and HANA adapters. Hands on experience with HANA SDI for Batch, real-time and Virtual access of external system. Worked on Business Objects Data Services (BODS) Jobs, Work Flows, Data Flows, and Scripts using various Transforms to load data from ECC to SQL database and BW Open hubs to other databases. Expertise on using Optimized joins while building model to improve performance of models Expertise in Performance Optimization of information models and SQL scripts, involved in SAP HANA Administration including managing schemas, data model objects, import/export content. Very good exposure in SAP Analytics Cloud (SAC) & S/4HANA Embedded Analytics Worked on S4/HANA for real time reporting and positioning BW with S/4 HANA CDS Views based on SAP best practices. Exposure on Fiori Lauch Pad and Fiori applications S/4 HANA using Fiori Catalogs. Handled complete Architecture, Design and Integration with HANA, BW on HANA, BOBJ 4.x using layered scalable architecture++ (LSA++) with buildup of hybrid Analytic/BI application. Work experience in different kinds of projects like Implementation, Upgrade (BW 3.5 to BI 7.0) and Migration to HANA database and Production Support Projects in SAP BW 7.5 ,7.4, BI 7.0, BW 3.5, 3.1C and B4HANA Strong End-to-End BW Configurations and Customization s from ETL process -Extraction, Staging, Loading, Performance, Transports, and Reporting Hands on Experience and Technical Proficiency in Data Extraction, Generic Extraction, Data Loading, Data Modeling, ODS/DSO Object, Info Cube, Multi-Providers, SPO, BEx Analyzer, BEx Browser and BEx WAD Excellent work experience in LOs (Logistics) Extractors for applications in SD and MM areas & Business Content DS of FI/CO Applications Good experience on COPA extraction of CO Module Extensive experience in extracting data from SAP ECC, CRM, SRM and external systems like Flat Files and non-ECC data sources and SAP Data Services 4.0 from relational databases Created customized InfoCubes, MultiProviders, Infosets, DSOs, InfoSource, Transformations and DTP Enhanced the Business Content for Data Modeling in Purchasing, Inventory, Sales, CRM and IS-U Utility Applications and PU (Public Sector) areas for Commonwealth of PA State. Worked extensively in BEx Analyzer and Query designer in building Queries and saving in Workbooks and created Custom Queries using Conditions, Exceptions, and Variables & Structures and created Aggregates for frequently used queries Expert in building Web Reports and Dash boards using BEx WAD Designer, BO Design Studio tools. Expert in Transportation of Objects across landscapes using STMS Good experience in Open Hub Service using InfoSpoke, Information Broadcasting and Analysis Process Designer Published BW/ BI reports into SAP enterprise portals. Very good experience in Business Flows of MM, SD, FI, CO, IS_U(Utilities), FRE(RE-FX), Public Sector Flows (FM and GM), HR and SAP CRM applications Have experience in ABAP to write custom codes for transformations (start routines, end routine and expert routines), enhancing DataSources and custom variables for reports using CMOD User exits. Strong experience in Upgrade of SAP BW 3.5 to BI 7.0(NetWeaver 2004s) which involves migration of 3.x to 7.0 data source, creating transformations, DTPs etc. and migration of BW 7.0 to BW 7.4 and BW7.4 to BW 7.5 with SAP BW4HANA Add on functionality Exposure in SAP-SEM (BPS): Transactional Cube design, Planning Area, Planning Levels, Planning Packages, planning folders, Manual Planning Function, User Defined and Predefined Planning Function, FOX formula extension. Trained in ETL tool Informatica PowerCenter 8.x Level I Developer and Big data Hadoop SAP Business Objects (SAP BOBJ) Experience: Developed various reports using SAP BO Tools such as IDT (Information Design Tool), Web Intelligence, Analysis for Office (AO), Analysis for OLAP, SAP Lumira, Dashboards and Crystal reports. Configured and maintained single and multisource universes in Information Design Tool (IDT) as Business semantic layer to consume HANA Info models/non-SAP applications using BI reporting clients. Developed various module applications Web intelligence reports on BEx reports using BICS connection Connected Tableau server to publish dashboard to a central location for portal integration Extensively worked on BO Analysis for Office (AO) to convert existing BEx Workbooks. TECHNICAL SKILLS: Data Warehousing: SAP BW/4HANA, BW7.5/7.4/7.3/7.0/3.5 SAP HANA2.0, SAP HANA1.0 & HANA STUDIO, Eclipse ERP: SAP S4/HANA ECC 6.0/, CRM, SRM, SEM (BPS) Programming Skills: SAP ABAP/4, PL SQL, SQL Script, Reporting Tools: SAP BO Tools: WEBI, IDT, UDT, Business Explorer, Analysis Office (AFO) SAP Lumira, Lumira Designer, Analysis for OLAP, Design Studio, SAP WAD Dashboards: Dashboard Designer, Design Studio, Tableau, SAC, S/4HANA Embedded Analytics Data Provisioning: SDI, SDA, SAP Landscape Transformation (SLT); SAP Data Services; and MS Excel flat file Databases: HANA 2.0, HANA 1.0, Oracle 11g, DB2, SQL Server ETL tools: SAP BODS 4.1/4.0, Informatica Power Center 8.x Other tools: ChaRM, JIRA, Remedy, Service Now, HP ALM, MQC Internet Technologies: HTML, DHTML, JAVA SCRIPT, VB SCRIPT ASP, JSP, XML CERTIFICATION: SAP Certified Application Associate -SAP HANA (ID: 01076902) SAP BW Certified (ID: 0004211038) SAP Business Objects Web Intelligence 4.0 Certified (ID: 01076902) Information Technology Infrastructure Library (ITIL) certified. PGDCA from BDPS Software Ltd. Certificate course in E-BUSSINESS TECHNOLOGIES from NIIT. Certificate course in Adv.-JAVA from NIIT. Informatica Power Center 8.x Level I Developer PROFESSIONAL EXPERIENCE: Client: Florida Power and Light (FPL), Juno Beach, FL July 2024 - Present Environment: SAP S4/HANA, SAP BW on HANA 7.5, SAP BO 4.2, SAP AFO Business Area: SAP ISC (SCM) - P2P, SAP FI, SAP SRM, SAP O2C(OTC) Role: SAP IT Specialist - HANA/BW Responsibilities: Worked with SAP ISC Team of Directors and Senior Managers on IT Special projects Led the SAP ISC team of Business Analysts and IT BW developers on the delivery of BW/HANA reporting dashboards. Responsible for the delivery of SAP Spend Analytics dashboard which comprises Enterprise Spend By Business Unit, Spend By Vendor and Spend by PO vs Non-PO which mainly used by Procurement Department to see the dollar amount spent that influenced the procurement process (Contracts or POs) Worked on SAP Integrated Supply Chain (ISC) Monthly Operating Performance Review (MOPR) Process repots: Enterprise Inflation/Deflation analysis ( IT Compliance Reports) Analyzed the ISC KPIs like Average Prices for the enterprise products for Bench Mark and current periods, calculated YOY and QOQ and Current Quarter Spend amounts Compared the KPIs wrt to SRM PO Assurances and SRM PO Confirmations. Designed the data flows which comprises SAP HANA Calculated Views and BW ADSOs for ISC needs. Used SAP AFO and Power BI tools for the support of ISC Reporting Dashboards. Heavily used BW exception aggregation and conditions functionality for KPIs. Worked along with SAP O2C team on HANA Sales Analytics requirements which involves Sales Analysis, Sales Performance reports and Billing Conditions. BPC tasks: Developed Custom process chains to load BW data into BPC applications for Finance applications. Designed/modeled a data flow from ECC into BW then into summarized BW info cubes designed specifically for BPC implementations this facilitated the cube to cube load for BPC planning. Working on Embedded BPC project which involves lots of Input forms VB Custom Code changes to fit into AO Working on creating new ADSOs for BPC planning purposes using a new eclipse platform. Client: Pacific Gas & Electric (PG&E), San Ramon, CA Jan 2024 Jun 2024 Environment: SAP S/4HANA, Native HANA, BW/4HANA, BW 7.5, ECC 6.0, BODS, BO 4.2 Business Areas: SAP WM, SAP Asset management, EDGIS, FI (R2R), H2R(HTR), HCM Role: Sr. SAP HANA/BW Lead Consultant Project Overview: PG&E has implemented Remote Grid Project for their Electric Distribution Services. This project involves integrating the Remote Grid data to SAP through interfaces and provided the Reconciliation Reports on GIS and SAP systems. RG is a new concept for utility service using decentralized remote systems for energy delivery. It has three components SPS (Stand Alone Power System), Component and Sub-Components. A Remote Grid SPS site contains assets that would be represented as Functional Location & Equipment in SAP. This design will illustrate how the RG asset be created using interface ED06 and functioning existing interface ED07 to send SAP ID back to GIS. Roles & Responsibilities: Responsible for the design, development and support including hyper care of new green field implementation of BW4HANA for the Remote Gid Project data flows from EDGIS to SAP Designed the scope document for the remote grid which involves BODS extraction from EDGIS to SAP and EDGIS to SAP ECC and SAP ECC to SAP B4HANA systems. Worked on the development aDSO, Composite Providers and BW queries for the remote grid deliveries. Designed the Reconciliation reports for EDGIS to SAP and SAP to EDGIS using BW query/ BEx functionality Worked on Master data of Functional area and Equipment etc using IE03 and IL03 Heavily worked on Customized extractors and BW ABAP to apply very complex business logic Worked on SAP CHARM process to release management and ALM testing tools for SAP testing scenarios. Worked on HR data sources 0EMPLOYEE_ATTR, 0HR_PA_0, 0HR_PA_1 for Head count and personal actions in H2R data flow. Worked on HR data flows Actual Time and Labor Times (0HR_PT_2) for HR Reporting. Client: Johnson & Johnson (J&J), New Brunswick, NJ Apr 2023 Dec 2023 Environment: SAP S/4HANA (C-FIN), Native HANA, BW/4HANA Business Areas: FI (R2R), Finance Planning, MM (P2P), PAPM, ANA PLAN Role: SAP HANA/BW Lead Consultant Project Overview: Johnson & Johnson (J&J) has very complex SAP landscape systems and have recently upgraded to S/4 HANA (C-FIN) for their financial planning solutions. And have BW/4HANA as their reporting solutions data models which involves mixed modeling scenarios of Native HANA and BW/4HANA. Roles & Responsibilities Responsible for the management of J&J RUN team for the daily BW report deliverables Involved in multiple team meetings with business stack holders at different business area and product owners to formulate their needs for their financial forecasting and planning processes. Heavily worked on Calculation Views (CV) using Native HANA, aDSO, Composite Providers and BW query to feed Tableau Dashboard. Involved in mixed hybrid flow of B4HANA & Native HANA objects for the reporting requirements. Worked with offshore SAP BW team to track the daily BW system issue and Finical planning data issues. Conducted different work shops to coordinate multiple teams like BW, PAPM, SAP S/4 HANA (C-FIN), Business Product Owners Client: Marathon Petroleum Corporation, Houston, TX Feb 2022 Mar 2023 Environment: SAP S/4HANA, Native HANA, BW/4HANA, BW 7.5, ECC 6.0 Business Areas: MM (P2P, IM), FI (R2R), CO Role: Sr. SAP HANA/BW Consultant Project Overview: Marathon Petroleum has been implementing green field implementation of BW4HANA. They have implemented MM(P2P), IM and FI (R2R) flows. The project requires the development and support of SAP BW4HANA system which is within S/4 HANA landscape. Roles & Responsibilities: Responsible for the development and support including hyper care of new green field implementation of BW4HANA for the P2P ad IM ad FI(R2R) data flows. Worked on the design and development PTP reports from end-to-end implementation. Heavily worked on Calculation Views (CV), aDSO, Composite Providers and BW query to feed Tableau Dashboard. Involved in mixed hybrid flow of B4HANA & HANA objects for the reporting requirements. Worked on ODP and SLT for the data sources for the new Inventory management extractors. Implemented Inventory Flow for the report Inventory Types and Inventory Turnover rate reports Worked on LO extractors 2LIS_03_BX, 2LIS_03_BF and 2LIS_03_UM and developed end-to-end data flow objects like aDSO and Composite Providers for Stock Quantities, Stock Values and Material Movements. Worked on SLT based data sources for PtP area for the base tables like MSEG, MKPF, MBEW (Material Valuation), QBEW (Project Stock Valuation), MARD (Plant data for Storage Location), JEST (Object status) and MARC (Plat data for Material) etc Reconciled Inventory data using MB52, MB5B Worked on CDS View based BW extractors for EKKO, EKPO , EBAN etc.. Developed CDS Views for BW extractors MKPF, MSEG, BKPF, BSEG, EKKO, EKPO etc Worked on 0FI_ACDOCA_10 (Unified Journal Entry) data source for the PTP Spend Analytics report Worked on ODQMON to monitor and maintain SLT ad BW based extractors. Used Testing tools like ALM, Service Now for Defect management Worked on ChaRM for Transports across S/4 ad B4HANA systems. Resolved daily BW load fixes by using RSPCM PC Monitoring Worked on User Incidents for different type of Reporting issues during different phases of the project testing, go LIVE, post Production support and Hypercare. Managed the BW/BI team. Client: Northwestern Energy (NWE) Butte, MT April 2021 Jan 2022 Environment: SAP S/4HANA, BW/4HANA, BW 7.5, ECC 6.0 Business Areas: FI, CO, IS-U, HR, SD, MM Role: Sr. SAP HANA/BW Consultant Project Overview: NWE has been implementing S/4 HANA upgrade for the current ECC systems and BW/4HANA Green field implementation of BW4HANA. They have implemented IS-U, MM, SD and FI and CO flows. The project requires the development and support of SAP BW system as part of S/4 HANA migration and new BW4HANA development for MM flows. Roles & Responsibilities: Responsible for the development and support of an existing SAP BW environment which comprises PRD, Quality and Development landscape. Provides support for enhancements to existing SAP BW Data Sources wrt S/4 HANA upgrade. Analyze the S/4 impact and its changes in existing flows Performed the required changes wrt Cost Elements and GL accounts in the existing reports due to S/4 HANA Reconciled the BW reports before and after migration Performed the refresh activities during the Project implementation Implemented the 0MATERIAL changes in SAP BW after S/4 HANA migration Fixed some of the issues during S/4 HANA migration Performed some analysis on CDS views for the existing BW reports i.e., feasibility of S/4 HANA embedded analytics. Corrected the existing ABAP code in S/4 HANA system for Z programs and custom data sources. Extensively used JIRA tool for the testing of migration processes. Client: Commonwealth of PA State, Harrisburg, PA May 2016 Mar 2021 Environment: SAP HANA, BW 7.5, ECC 6.0, CRM, SRM, SAP BO, SAP BODS, BPC 10.0 Business Areas: FI, CO, RE-FX (Real Estate), PU (Public Sector), HR, SD(OTC), MM(P2P), HR(HCM) Role: Sr. SAP HANA/BW Consultant Project Overview: The Commonwealth of PA has implemented SAP HANA(Native HANA)/BW as enterprise solution for their reporting needs which has involved mainly the Public Sector flows like Funds and Grant Management, Finance, Budget and Controlling, Real-Estate, Purchasing, Inventory, Sales HR flows, CRM and SRM flows. The project requires the development and support of SAP HANA/BW HANA environment by daily monitoring of SAP BW loads and provide solutions to the load failures and other complex issues. Also provide the development of new projects which requires lots of enhancements to the existing data flows. Roles & Responsibilities: Responsible for the development and support of an existing SAP BW HANA environment which comprises PW1, A3Q and A3D systems corresponding to PRD, Quality and Development landscape. Provides support for enhancements to existing SAP BW Data Sources, DSOs, InfoCubes, Multi Providers, InfoObjects, InfoSets & APDs for the all the applications of Commonwealth of PA Create/modify transformations or convert existing update rules and/or transfer rules to transformations Update/Create SAP BW queries and workbooks using the Query Designer and BEx Analyzer tools. Native HANA MODELLING - Designing Views (Attribute View, Analytic View, Calculation View), Views that need multiple table functions, counters, Restricted and Calculated measures, input parameters, filters, Ranks. Debugging Views, HANA Modeling using SQL Script Worked on new report FM balances which involves creating Composite Providers and HANA Calculation Views on top of BW4HANA ADSOs on FM Commitments Actuals (0PU_IS_PS_31) and FM Budget flows. Created SAP native HANA Calculation Views for the Vendor Analysis report based on LFA1, LFB1 and LFBK tables Worked on two POCs for native HANA projects for eGrants Designed work authorizations with security according to priority of users from executive to user level User administration (Create/ Delete; User Groups / Type; Password Parameters; Generation of Role, Profile & Authorizations using PFCG); Locks (Clients / Transactions); Security Profile & Authorization maintenance. Expertise in SAP HANA Security including User Management, Roles, and Privileges Expertise on reading the BW models into HANA and creating the HANA view to achieve the complex reporting requirement. Worked on New GL, FI-AP, FI-AR, FRE and Public Sector flows involving Funds and Grants management (FM & GM) applications and EAM Assets applications. Identify, troubleshoot & resolve issues in development/configuration/reporting for all CWOPA applications like New GL, CAFR, GASB87 etc. Develop and document test strategies & results for CAFR and Inventory applications Participate in the Functional meetings to get the new requirements for PA state CAFR Financial reporting purpose and GASB87 reporting. Analyze the requirements from the end-users and prepare a functional specification in the areas of PCI (Pennsylvania Commissary Institute) and FRE (Flexible Real Estate). Prepare a Fit-Gap Analysis document based on the gaps identified for GASB87 and CAFR projects. Match Functional requirements into SAP BW technical objects and prepare a Technical Design document for CAFR, GASB87, FRE and PCI applications. Worked on Procurement, Inventory, Purchasing Sales processes and BW Support for the State requirements Involved in implementing the data flows of Procurement, inventory management DataSource 2LIS_03_BF (Goods Movements from Inventory Management), Purchasing Data (Schedule Line Level) DataSource 2LIS_02_SCL, Production Orders: 2LIS_04_P_MATNR (Material View from PP/PP-PI), 2LIS_04_P_COMP (Component View from PP/PP-PI) etc. using the LO Cockpit. Extensively worked on LO cockpit for the Purchasing Application which involved the Data Sources like 2LIS_02_HDR, 2LIS_02_ITEM and 2LIS_02_SCL and Customer Support Sales Transaction data flow application which involved the Data Sources like 2LIS_11_VAHDR, 2LIS_11_VAITM for Sales; 2LIS_12_VCHDR, 2LIS_12_VCITM for Delivery; and 2LIS_13_VDHDR, 2LIS_13_VDITM for Billing. Filled the set-up tables using the tcode OLI*BW for the applications like Purchasing, Sales Order, Delivery and Billing Document in Sales and Distribution. Develop ALM support scripts for the BW objects like FRE Cash flow and FRE Conditions data sources. Involved in BW on HANA migration project from Oracle database to HANA DB. Upgraded the systems from HANA 1.0 to HANA 2.0 Worked on Upgrade from BW 7.4 to 7.5 with new Eclipse version Expertise in Improving performance issues by applying OSS notes as per SAP recommendation Expertise in resolving critical upgrade issues with help of SAP and implemented several OSS notes in resolving upgrade issues Developed the new requirements BW4/HANA objects like ADSO, Composite providers and BW Query for GASB87 project involves FRE Cashflow and FRE Contract Conditions using the new BW for HANA tool, Eclipse model. Worked on AMDP for the latest BW 7.5 objects in the transformations look ups for the better performance and to optimize the ABAP code. Involved in migration of New-GL and implemented the BW data models based on new data Sources 0FI_GL_14, 3FI_GL_0L_TT Migrated all old FI-SL based workbooks into New GL based workbooks for CAFR Statewide & AG versions Heavily worked on CAFR Financial Balance Sheet reports, Revenue and Expenses Reports using New GL data objects Created Financial Reconciliation reports for NEW GL Totals and Details using the Remote Cube and Data source 0FI_GL_RECON Worked on GL Hierarchies to load to Quality and PRD systems from the Development systems using BODS loading mechanism by creating BO DS object and DS enabled Data Sources. Worked on PCI Consolidated Operating Statement Report which involves Costs and Allocations - Cost Elements flow and 0CO_OM_CCA_9 (Cost Centers: Actual Costs with Delta Extraction) Worked on AP and AR Aging reports and enhanced these reports with FRE Contracts. Worked on Business Partner extraction from CRM systems and ECC and working on Business Partner -Customer Vendor integration project. Worked on eGrants project which involves SAP Lumira Designer / SAP BO Design Studio Dashboard on eGrants Dashboard Reporting based on KBLK (Document Header) and KNLP (Document Item) base tables with FMZ3 transactions at Source System for Earmarked Funds EGrants Enterprise Dashboard based on custom CSS functionality for Lumira Components and integrated ESRI maps for the county location wise Vendor Payments and allotted Grants in PA state Developed Business Objects Data Services (BODS) Jobs, Work Flows, Data Flows, and Scripts using various Transforms to load data from Open Hub Services Table into Oracle database and then consumed the data for BO Reporting tool Worked on FRE (Flexible Real Estate) Project which involves Contract Overview and FRE Lease Tracking work books with lots of tabs on different report views Developed data flows for FRE on Contract Conditions (0REFX_1), Contract Measurements, Differing Measurements (Contract) (0REFX_13) and Cashflow (0REFX_6) Extensively worked on RECN transactions at Source and resolved the issues related to measurement type mappings and non-cumulative KF like 0MEAS_VALUE (Measurement Amount) & 0COND_AMT (Condition Amount) Enhanced 0RECONTRACT(Contract) with a new End of Date field with a logic to replace it when Holdover Date exists Designed and developed new FRE Lease Tracking Report which displays the Total annual cost for all FRE contracts across Counties & Business areas using Analysis Office Enhanced the Revenue and Refund reports by adding Doc type exclusions SD, SU Worked extensively in BEx Analyzer and Query designer in building Queries and saving in Workbooks and created Custom Queries using Conditions, Exceptions, and Variables & Structures and created Aggregates for frequently used queries Converted many existing BEx Analyzer Workbooks into BO AO Workbooks in the area of CAFR Extensively worked on APD and Information Broadcasting to export BW data to different outbound interfaces Extensively worked on ABAP coding during transformations in Start Routine, End Routine Expert Routine and in Data Source enhancements and in customer exits where needed. Involved in a new project of BW4/HANA migration in Shell Conversion with the current SAP BW 7.5 BW/4HANA Add on Worked on new ODP extractors and ABAP CDS view extractors for FI-GL flows in S/4 Embedded Analytics HANA landscape for CAFR Financial Reporting Extracted the data from Oracle legacy systems using SAP HANA SDI. Worked on a POC on SAP data intelligence tool to target the SAP and non SAP systems Resolved lots of issues during SAP systems migration to Linux OS Created annual budget reports using Power BI Desktop for analyzing the V&A revenue and expenses. Developed complex calculated measures using Data Analysis Expression Language (DAX) for efficient data visualization in Power BI. Developed analysis reports and visualization using DAX functions like table function, aggregation function and iteration functions. Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts. Have experience in SAP SBP solution for the state s budgeting requirements. Implemented Funds Management, Grants Management and worked on Budget execution reports based out of BCS and other planning tools. Implemented budget execution data flow models using the new composite providers and FM Budget ADSOs Got trained in SAP Analytics Cloud (SAC) and hands on experience in developing SAC applications using story canvas and well versed in visualizations and their usage charts, tables, filters. Drop down menus etc. Successfully created Dashboard story in SAC using Canvas, Responsive pages and Digital boardroom. Successfully optimized SAC Dashboard as per business requirements Tested and resolved data issues in SAC Dashboard stories. Very good understanding of S/4HANA Embedded Analytics content using CDS views and Fiori applications Client: Kraft Heinz Company, Pittsburgh, PA Apr 2015 Feb 2016 Environment: SAP BW 7.4, ECC 6.0, SAP BO, SAP HANA, SAP BODS Business Areas: SD, FI, CO, MM, SRM Role: SAP HANA/BW Lead Consultant Project Overview: The project requires daily monitoring of SAP BW loads and support the possible fixes and do the daily maintenance activities. Need to talk to end users, understand the issues & change request and write a small specification and communicate with the end user and gain acceptance before starting development and execute the change order in an Agile development model. Roles & Responsibilities: Responsible for daily monitoring of the BW system using the tools ST13(PC Monitoring Runtime Analysis), RSPCM and fix the BW PC load issues Responsible for complex fixes and change orders in the SAP NetWeaver BI environment-BW/HANA along with BOBJ Ability to talk to end users, understand the issues & change request based on the Incidents raised in eDesk system Ability to write very good programming, unit test and document the changes and provide smooth handover to different teams and end users Understand and follow religiously the process to migrate the change orders to production Extensively worked on ABAP coding during transformations in Start Routine, End Routine Expert Routine and in Data Source enhancements and in customer exits where needed. Worked on new GL (0FI_GL_14), COPA, Sales, Billing data flows Resolved the long pending issue with Daily Sales Report (Global) which have the issue with two KPIs i.e., Open Orders (Volume) & Open Orders (Newt Weight). Resolved the issue on missing billing documents for CSS Commercial Sales report. Worked on COPA Income statement, FI Income statement and COPA-FI Reconciliation report changes as per the new organizational structures Extensively worked on Global Sales Analytical Reports and FI Profit & Loss Analytical reports Worked on Open hubs to distribute the COPA data to Essbase file Extensively worked on BW routines (start routines, end routine and expert routines) and BW data source enhancements Fixed the issues with BI Project systems report with ECC FAGLB03 report Resolved the issues related to GRNV SRM report Extracted PO data from SAP SRM systems Extensively worked on SAP BO Design Studio tool to create dash boards on sales analytics Work experience with BW 7.4 objects like Composite Providers, open ODS view and advanced DSO for the new data flows Developed SAP native HANA Views (Attribute and Analytical views) for Heinz Market Share Project Worked on the HANA Technical Spec which comprises all tables which were replicated to HANA Monitored SAP BODS jobs which are running on daily basis and fixed possible failures for Heinz ZBB data Worked on Power BI, Tableau and SAP Lumira dashboards for Analytics reporting Involved in running the SAP BO WebI reports on daily US time Client: SAP Global Delivery, PA Jan 2012 Jan 2015 Environment: SAP BW 7.3, ECC 6.0, SAP HANA 1.0, SAP BO (WebI, Design Studio, IDT) Business Areas: FI, CO, CRM, HR, SD Role: Business Process Consultant/Architect Roles & Responsibilities: Led the SAP BW/BI team for SAP IT projects BI Report Factory (Development of Reports using BEx WAD and Query Designer tools). Delivered the SAP IT Finance & PRM Analytics reports, GSIM and T&E Projects. Converted the FS requirements into Technical Specifications. Responsible for the delivery of objects from entire realization phase till go Live. Worked on SAP BW 7.3 objects and HANA based information models and followed LSA 2.0 and extensively worked on HANA enabled InfoCubes and DSO Developed SAP native HANA Data Models: Attribute Views for master data, Analytic Views for Transaction Data and Calculation Views to join the various Attribute and Analytic Views for GSIM (Global Security and Information Management) Project Created universe and developed BO WebI reports and dashboard using IDT tool on HANA views Developed Dash boards using SAP BO Design Studio on PRM analytics Migrated HANA content from development, testing environment to Production environment using delivery units. Developed Crystal Reports based on BEx query for T&E reports. Worked on HR data sources 0EMPLOYEE_ATTR, 0HR_PA_0, 0HR_PA_1 for Head count and personal actions for the T&E and GSIM Project. Handled the Tickets during the testing phase of the reports Having the daily calls with SAP IT team to discuss on the status of the deliverables. Worked on COPA-Finance Analytical reports i.e., COPA Actual Analysis, FI Actual Analysis which are based on COPA data flow and FI leading ledger balances (0FI_GL_10) data flows Designed Sale Analytics back-end data flows which includes Sales Orders, Billing and invoices and Deliveries data flows HCL-AXON Client: Xerox, CT Apr 2010 Jan 2012 Environment: SAP BI 7.0, SAP ECC 6.0 SAP CRM 5.0 Business Areas: CRM, FI-CO, HR Role: Sr. SAP BW Lead Consultant Roles & Responsibilities: Led the SAP BW team to deliver the ESAP release 1.1 objects Having status calls with onsite BW team to keep track of object status and updates by using the tools like PM SMART and APSE (Axon Program Standards of Execution). Involved in designing the RDDs (Report Design Documents) with the new reporting requirements by converting the business logic into BW solution and mapping the source system definitions into BW. Performed the BW Data Modeling Analysis on the existing BW InfoCubes of the Release 1.0 by using programs /SSA/BWT, SAP_INFOCUBE_DESIGNS and table RSRCUBE. Delivered the Xerox Direct and In-direct Business Analysis on the current data by classifying the business data across Sales Org, Distribution Channel and Division / Purchasing Org, Plant Involved in Z-filed Analysis for the existing CRM data sources like 0CRM_SRV_CONFIRM_H, 0CRM_SRV_CONFIRM_I,0CRM_SRV_PROCESS_H,0CRM_SRV_PROCESS_I CRM business processes Service Process and Service Confirmations etc. Involved in delivering the BW Phase 1 and Phase 2 objects as per the scheduled time lines. Delivered the BW CRM-CSO (Customer Service Organization) reports and database objects which based on Service Process and Service Confirmation data flows in SAP CRM area. Involved in developing the solutions for Finance-GTR reports using Asset Accounting (AA), New GL14, Cost Center Accounting (CCA) and CO-PA data flows. Worked on EAM Assets data flow objects 0FI_AA_11 and 0FI_AA_12 enhancements and master data objects 0ASSET_ATTR_TEXT and 0ASSET_AFAB Enhanced the 0FI_GL_14 extractors with Document Header Text BKTXT Designed and developed the data models on CCA, OPA and WBS data flows Enhanced 0CO_OM_CCA_9 to add COEP-EBELN and map to 0DOC_NUM and to add COBK-USNAM and map to EGRNUSR. Enhanced 0CO_OM_WBS_6 with ZZCONTNO, ZZSERNOs Worked on HR data flows Actual Time and Labor Times (0HR_PT_2) Performed QC10 steps for the BW back end and frond end reporting objects. Managed and handled BW Defects through MQC during Integration testing and regression test phases. Used RRI techniques for some of the CRM reports. Deloitte Consulting, USA Client: Harry & David Foods, Medford, OR Nov 2008 Sep 2009 Environment: SAP BI 7.0, SAP ECC 6.0 Business Areas: MM, IM, PP, FI Role: Sr. SAP BW Lead Consultant Roles & Responsibilities: Involved in Full Life Cycle Implementation of integrating the functional areas MM, PP and FI with BW. Responsible for Design of data models, comparing the model with delivered contents and implementing the business logic with delivered contents along with modifications. Involved in implementing the data flows of inventory management DataSource 2LIS_03_BF (Goods Movements from Inventory Management), Purchasing Data (Schedule Line Level) DataSource 2LIS_02_SCL, ProductionOrders: 2LIS_04_P_MATNR (Material View from PP/PP-PI), 2LIS_04_P_COMP (Component View from PP/PP-PI) etc. using the LO Cockpit. Performed Statistical Setup for Purchase, Inventory Management (Non-Cumulative method) and extracted the data to BW. Used Queued Delta method to extract the delta records of MM application. Activated Purchase and Inventory InfoCubes and DSO objects from the Business Content and customized according to business needs. Implemented the dataflow for the G/L Details by activating the DataSource0FI_GL_4(General Ledger: Line Items). Activated the Business Content master data sources for 0VENDOR_ATTR (Vendor Number), 0MATERIAL_ATTR (Material Number). Developed Generic Data Sources using RS02 for the Batch materials, data source for shelf life expiration by using views from the base tables MARD, MARA, MCH1. Created transformation, DTPs for the above dataflows. Developed Open Hub destinations to send the BI data to MS Sequel Sever for further reporting. Created process chains for the above dataflows and also created PC for purging the PSA requests periodically. Enhanced the purchasing dataflow (2LIS_02_SCL) with the new fields for PO Address details and enhanced the ABAP code to populate the data for the new fields using CMOD user exits. Participated in SAP BI system refreshes. Resolved multiple issues related to 0BATCH loads by using error DTPs and using RSKC transaction to allow extra permitted characteristics. Resolved data inconsistency issues related to production-order dataflows which involved the datasource2LIS_04_P_MATNR. Created Open Hubs for the purchasing and inventory DSOs. Worked on information broadcasting to broadcast the reports through emails. Extensively worked on BEx Query designer to create Purchasing reports. Post Production support, which involves daily monitoring of data loads via process chains, trouble shooting and correcting the known errors and escalating the unknown to the SAP support team Deloitte Consulting Client: MTEMC, TN Jan 2008 Oct 2008 Environment: SAP BI 7.0, SAP ECC 6.0 Business Areas: IS-U, FICA, FI Role: SAP BW Lead Consultant Roles & Responsibilities: Led the Deloitte SAP BI team to support the clients like MTEMC, NNWW and GRU. Worked on Utility dataflows like Open Items(0FC_OP_01), Cleared Items(0FC_CI_01), Sales Statistics(0UC_SALES_STATS_02) and FIGL etc. Ran the transactions for FPBW and FPCIBW mass activities at R/3 for open items and, cleared items extracts monthly or weekly based on client requirements. Loaded data to open and cleared items InfoCubes based on run date and run identification. Worked on some enhancements for the standard extractors 0FC_OP_01 and 0FC_CI_01 for open and cleared Items dataflows like adding sub G/L account field (HKONT) and worked on CMOD for the code changes to populate the new data for the enhanced fields. Worked with the business users on the requirements of stopped meter analysis and participated Fit-Gap analysis meetings Involved with the Meter Reading Data Analysis by working on DataSource 0UC_MTR_DOC (Meter Reading Document) Activated the Technical Device master data i.e. Device, Device locations(0UC_DEVICE_ATTR) Extracted the data from the billing order using 0UC_BILLORD. Worked extensively on Sale Statistics data source (0UC_SALES_STATS_02) to fix the missing data for certain posting periods using the tcode EBW_DQ_SS at R/3. Fixed the GL Details for missing posting periods which involves the DataSource 0FI_GL_4(General Ledger: Line Items). Involved in QA refresh activities: Ran tcode BDLS to convert the source system changes etc., checked the RFC connections and did all the BW tasks to refresh data. Extensively worked on Transports using the transactions SE01, SE09 and STMS. Activated and made use of Technical content in BI system (SAP BI statistics) to gather the statistics required for performance analysis. Created and maintained aggregates, rollup of data using process chains, after the successful extraction of transaction data and compressed the InfoCubes as part Performance Tuning of the BI system. Developed TVA reports using BEx query designer extensively. Created workbooks by including a set of BEx reports. Developed Web reports corresponding to BEx queries using BEx WAD tool. Developed executive dashboards which consist of pie charts, graphs and tables. Published BEx reports in SAP portal. Used Information broadcasting to send reports though emails. As a part of upgrading SAP ECC 6.0, supported BI system activities like running BDLS to change the old source system to new source system, taking care of delta Q s and scheduling the batch jobs and maintaining the Process chains after ECC upgrade. (ECC 6.0 Post upgrade steps) Provided on-going BI monitoring support such as troubleshooting and resolving issues using the transaction RSPC and RSMO. Deloitte Consulting Client: Newport News Water Works (Utilities), VA Oct 2007 Dec 2007 Environment: SAP BI 7.0, SAP BW 3.5, SAP R/3 4.7E Business Areas: FI, IS_U, FICA Role: Sr. SAP BW Consultant Roles & Responsibilities: Upgrade of BW 3.5 to BI 7.0(Net Weaver 2004s): Developed the strategy for the Upgrade project from BW 3.5 to BI 7.0 Prepared the project plan for BI which involved the time lines and BI tasks. Involved in Migrating the classical 3.x DataSource to 7.0 DataSource for IS_U and FI area for both master data and transactional data. Migrated transactional DataSources: Open Items(0FC_OP_01), Cleared items(0FC_CI_01), Sales Statistics (0UC_SALES_STATS_02) and 0FI_GL_4(General Ledger: Line Items). Migrated the master data sources for the objects like Business Partner, Premise, Contact Number, Contract, Connection object etc. Used the new Transformation process in place of old Transfer and updated rules and created DTPs for the data targets according to the requirement. Modified the update routines and start routines using ABAP objects especially for the 0BUSINESS_PARTNER and Sales Statistics dataflows. Resolved migration issues with the help of SAP OSS support. Included the newly created DTPs in the Process Chain for the automatic scheduling of data loads. Migrated all the BEx 3.5 reports into BI 7.0 reports. Worked on migrating work book which contains about 15 reports. Worked on migrating the Exception aggregation settings for the calculated Key Figures to BI 7.0 version. Deloitte Consulting Client: Gainesville Regional Utilities (GRU), FL Aug 2007 Oct 2007 Environment: SAP BW 3.5, SAP R/3 4.6 C Business Areas: IS_U, FICA, FI Role: Sr. SAP BW Consultant Roles & Responsibilities: Monitoring the SAP BW PC loads daily using the transaction RSPC and RSMO. If any issue comes up with the data loads, we need to investigate the issue and fix it accordingly. Based on the Deloitte Edge Tickets which are assigned under my name, I need to look into the ticket issue and need to resolve according to priority level. I need to update the status of each ticket in Deloitte Edge Portal. Worked on Utility data flows like Open Items, Cleared items, Sales Statistics etc. Run the transactions FPBW and FPCIBW at R/3 for open items and cleared items extracts monthly or weekly based on client requirements. Loaded data to Open and Cleared items InfoCubes based on Run Date and Run Identification. Worked on some enhancements to the existing dataflows for Open and Cleared Items dataflows like adding Sub G/L Account field. Worked with the standard extractors 0FC_OP_01 and 0FC_CI_01. Involved in QA refresh activities. Extensively worked on Transports using the transactions SE09 and STMS. IBM Global Client: Shell Global SAP(GSAP) Dec 2005 Apr 2007 Environment: SAP BW 3.5, SAP R/3 4.7E Business Areas: MM, SD, FICO Role: SAP BW Consultant Role: As a senior member of Shell Team, I was involved in the development of applications like purchasing data flow of Material Management (MM) and Logistics applications like Sales Overview Analysis of Sales and Distribution (SD) module and worked in Cost Centre Accounting (CCA) of FI/CO module. Responsibilities: Data Extraction from R/3(MM, SD, FICO): Involved in implementing Manage Purchasing application in MM, Customer Support Sales Transaction data flow in SD and Cost Center Accounting (CCA) reporting in CO. Extensively worked on LO cockpit for the Purchasing Application which involved the Data Sources like 2LIS_02_HDR, 2LIS_02_ITEM and 2LIS_02_SCL and Customer Support Sales Transaction data flow application which involved the Data Sources like 2LIS_11_VAHDR, 2LIS_11_VAITM for Sales; 2LIS_12_VCHDR, 2LIS_12_VCITM for Delivery; and 2LIS_13_VDHDR, 2LIS_13_VDITM for Billing. Filled the set-up tables using the tcode OLI*BW for the applications like Purchasing, Sales Order, Delivery and Billing Document in Sales and Distribution. Activated the Business Content Data Sources 0CO_OM_CCA_9 (Actual costs) & 0CO_OM_CCA_10 (Commitment line items). Generated Data Sources (Generic) for Master Data, Text and Transaction Data using the transaction RSO2. Enhanced master data DataSource 0VENDOR_ATTR with customized fields and populated data using ABAP code in EXIT_SAPLRSAP_001 of CMOD enhancements. Involved in extracting data from SAP SRM systems for Shopping cart information (0BBP_SC_TD_1) and providing text data to EBP user using Generic Text DataSource. Data Modeling: Responsible for configuring Info Objects, ODS objects, Info Cubes, Info Set and Multi- Providers for Purchasing data and Sales Overview applications Involved in mapping of data source to info source with Transfer Rules in SAP BW. Involved in mapping of info source with the Data Targets using Update Rules. Loaded Data into the ODS Object before transporting the data into the IC. Involved in Creation of ODS Objects and also worked with various options, which involves activating data in ODS, deleting data in change log and also updating the data in ODS to subsequent data targets. Created Info Packages and Scheduling the data into the Data Targets. Uploaded Transaction Data from the Flat File as the Source System. Involved in Performance tuning aspects of Info Cube maintenance i.e., Compression, Roll-up. BEX Reporting: Involved in developing KPI Reports for Purchasing application using BEx Analyzer & BEx Browser. Developed flexible queries using Filters, Free Characteristics, Navigational attributes in BEX analyzer to facilitate data analysis in a drill down version to enable the easy access of information at various levels. Involved in Creation of Reports such that the execution time is evenly distributed throughout the Report using Restricted Key Figures, Calculated Key Figures, Variables, Exceptions & Conditions and Structures. Used RRI concept whenever it is required as per the Technical Specifications. Extensively worked on BEx WAD for creating Web Reports using Web Templates of type Limited Analytical, Drilldown and Full Analytical Web Templates. Worked on Information Broadcasting to distribute Web Reports through different channels like E-mails and SAP Portals Educational Qualification: Master of Technology (MTech) in Computer Science from AAI-DU in 2007. Master of Science from Hyderabad Central University (HCU) in 1994. B.S in Computer Science from Andhra University in 1992 Keywords: cprogramm quality analyst materials management business intelligence database sfour sfour active directory rlang information technology golang business works hewlett packard purchase order trade national microsoft procedural language Arkansas California Colorado Connecticut Florida Idaho Montana New Jersey Pennsylvania South Dakota Tennessee Texas Virginia 732-512-0009 EXT 831 Surya.k@logicplanet.com Keywords: cprogramm quality analyst materials management business intelligence database sfour sfour active directory rlang information technology golang business works hewlett packard purchase order trade national microsoft procedural language Arkansas California Colorado Connecticut Florida Idaho Montana New Jersey Pennsylvania South Dakota Tennessee Texas Virginia