Senior Sap Bw4hana Developer Resume
Camden, NJ
SUMMARY
- Overall 10 year experience as a senior SAP BW consultant which includes data modelling, extraction and report creation and Technical Lead with Client facing roles and responsible for Technical Architecture, Implementation & Go live support including end - to-end SAP implementation experience and also integrated on ECC, HANA, BOBJ, SCM, SRM, CRM, EHSM, EC, IS-Utilities, Device Management, FI-CA, Billing (MTC-Billing), EC, SEM-IP, NetWeaver, Implementation, Upgrade, HANA Migration and Enhancement.
- Certified SAP HANA (C HANAIMP141) App. Associate
- Involved in SAP BI 7.5 Implementation, HANA migration and Support and Maintenance projects.
- Worked on various versions of SAP BW starting from 3.1C, 3.5, Net weaver BI 7.0, 7.3 and BW 7.4, 7.5 powered by HANA, HANA Studio 1.0, SAP BO4.0/4.2, ECC 6.0, APO EHP2 SCM 7.0, Microstrategy
- Good Knowledge in Hana Database Architecture and strong understanding of different types of engines; SQL Engine, Calculation Engine, OLAP Engine, Join Engine and XS Engine.
- Experience in HANA Modelling and worked with Attribute, Analytic and Calculation views and strong understanding of when and where to use join types like Text, Left Outer, Right Outer, Referential and Inner.
- Worked with different Data Provisioning Techniques like SAP DS/BODS, SLT, SDA (Smart Data Access), DXC.
- Hands-on experience with Hana Studio - Modeler/Developer/Debug /Admin/Lifecycle/BW perspectives
- HANA security implemented through graphical ap creation, role, user to assign analytical privileges
- Worked on NLS and archiving the historical data for large volumes of the data set.
- Fetched data from various Source systems viz. ECC6.0 (SD, MM, FI, PP, Inventory, HR, PM, CO, COPA, FI-CA, ISU-Utilities...Etc.). SAP EC Environment Compliance and EHSM-Environment, Health and Safety, BODS, Hyperion, Flat-file, SRM, CRM, SCM and SEM-IP modules.
- Knowledge in Implementing SD, MM (Purchasing, Inventory Management, Procurement), Production support & Maintenance Projects, Enhancement Projects.
- Involved in designing the Graphical star Schema View by following the necessary standards to deploy optimized Info cube Data Model both at the Database level and Reporting Level.
- As part of Information Consumer Layer designed BEX Reports providing insight of Business Intelligence for Business Analyst for Decision making using Formulas, Selections, Structures, Calculated Key Figure, Restricted Key Figure and Used Variables with User Entry/Default Value and Replacement Path.
- Involved in changing the Existing data model of an Info Cube by adding new Characteristics and Key figures, involving the Re-initialization of Data Sources from SAP R/3.
- Involved in creating Generic Extractors using Table and view.
- As part of Data Provider Layer, migrated data from SAP R/3 using LO, Business Content Extractors.
- Extensively Involved in Setting up the procedures for LO Cockpit, Involving Activating the Business Content Data Sources, Maintaining the Extract Structure, Generating the Data Source, Activating the Data Source, Enhancing the Data Source and Using the Enhancement RSAP0001 to fill the data into the enhanced Fields.
- Extensively worked in Business Information Warehouse Info Cubes, ODS Objects, Info sources, Info objects, Transfer rules, update rules, Extractors, Info sources, Info packages, Info objects Catalogs, Data sources, Data Extraction, Business Content, Data Marts, Process Chains.
- As part of Quality management standards to deliver the objects in quality performed Unit testing and recorded the test results in unit test cases documents.
- Designed and developed process chains (RSPC) for master data loads and transaction data loads with the halp of Info-Packages. And these Process chains are scheduled for periodic loads.
- Extensively worked on BW modelling, extraction, reporting and dashboards.
- Performed on performance tuning on BW, HANA to optimize the data loads and query execution.
PROFESSIONAL EXPERIENCE
Confidential, Camden, NJ
Senior SAP BW4HANA Developer
Responsibilities:
- Requirement gathering of the legacy BW metadata objects including Master and Transaction data of the APO flows.
- Involved in lift and shift HANA migration from BW 7.4 to BW 7.5 for HANA.
- Estimate the migration plan for HANA migration of the APO flows as Lift and Shift migration project.
- Prepared Cutover activities and lead the migration from end to end activities delivered on time.
- Collected the metadata including info objects, DSO, Cube, Multi provider, Bex, Transformation, DTP, Open hub, APD, Process chains and FM and Programs.
- Transport the objects of the APO BW metadata in a sequence with object dependency from legacy BW to HANA BW where EPM objects already existed without impacting on the common master and transaction data.
- Resolved technical issues during migration and transports of the BW objects and documented for tracking purpose.
- After applying BW4HANA add on with compatibility and B4H mode, system no longer accept classic metadata creation and applicable for automated HANA optimized LSA++ flow
- Conversion of the classic DSO to advanced DSO by using tcode RSB4HTRF which converts entire flow from classic to advanced DSO, Cube to advanced DSO and Multi provider to Composite provider.
- Conversion of Multi provider and it’s Bex to Composite provider including Bex by using program RSO CONVERT IPRO TO HCPR
- Created ADSO, Open ODS view and Composite providers for the data flow related to PPDS, DP and SNP.
- Created generate export data source for APO flows for data mart and replicate for new data flows.
- Implemented and developed various scenarios in SAP HANA system related to modelling on Attribute Views, Analytical Views and Calculation Views by graphical.
- Created the Microstrategy reports instead of BO Webi reports as per client requirement.
- Created and managed Delivery Units to move across different environments and maintain schema mapping.
- Organised transports of HANA models through CTS management tcode SCTS HTA
- Created Users, Roles, Privileges, Packages, and Schemas as part of HANA security on HANA life cycle management.
- Perform Build and Unit test on the BW4HANA system for APO flows and documented with test result.
- Lead the Pre-and Post-Go-Live activities after successful UAT, SIT, Regression and VTO
Environment - SAP BW 7.5, HANA 1.0, EPM 10, APO EHP2 SCM 7.0, ECC 6.0, Micro strategy
Confidential, Wilmington, DE
SAP BW HANA Developer
Responsibilities / Deliverables
- Worked on the BW7.4 objects with HANA on Composite providers, Transient providers, Analytic indexes and ODS views.
- Worked on Mixed Scenarios to utilize Hana models into BW to achieve reporting solutions for SD module reports.
- Hands-on experience in creating ADSOs, DSOs, Info cubes, Virtual and Composite Providers as per LSA++ Architecture.
- Created ADSO, Composite providers for the data flow related to FI, Material Management, Procurement and SD.
- Implemented and developed various scenarios in SAP HANA system related to modelling on Attribute Views, Analytical Views and Calculation Views by graphical.
- Created Virtual Info providers in BW on top of BW and HANA Model, transient Info providers for SAP BW OLAP Functions to report on SAP HANA Analytic and Calculation Views.
- Created and managed Delivery Units to move across different environments.
- Followed HANA Live Modelling approach in categorization of PRIVTE, RE-USE, QUERY view and leveraging into custom views.
- Implemented Manufacturing orders calculation view on AUFK and AFKO as per Business requirement by leveraging SAP BIA (BI adoption) RDS implementation SAP Business Intelligence Adoption rapid-deployment solution.
- SD models created using HANA Live content (SalesOrderItemNetAmountQuery, BillingDocumentItemQuery).
- Captured statistics of each model from PLAN VIZ and handled optimized performance tuning through same perspective.
- Created Variables and Input parameters in the HANA Views.
- Replicated data from ECC to HANA using SLT based table Data Provisioning and performed operations like, Load, Replicate, Stop, Suspend and Resume as part of Data Provisioning.
- Inventory Transfer and Inventory Adjustment details based on the EKKO, EKPO, EKET, EKBE & MARD tables using the SLT functionality to fetch the ERP tables
- Worked on SLT to connect SAP HANA with SAP systems (SAP ECC & SAP BW source systems) and extracted tables, performed metadata import, schema mapping.
- Created and managed Delivery Units to move across different environments and maintain schema mapping.
- Organised transports of HANA models through CTS management tcode SCTS HTA
- Created Users, Roles, Privileges, Packages, and Schemas as part of HANA security on HANA life cycle management.
- Designed the Business reports and story board through SAP Lumira and Analysis office on sales and Fi related data.
- Camel Notation fields’ usage halped in quick development of tableau reports.
Environment - SAP BW 7.4, HANA 1.0, SLT, NLS, BO 4.1, ECC 6.0, SAP Lumira
Confidential, Houston, TX
SAP BW HANA Design Authority
Responsibilities / Deliverables
- Work across business/technology teams to ensure alignment between business solution definition & technicalarchitecture to meet project requirements on Procurement, Inventory Management and Finance, Plant Maintenance, Sales & distribution, fixed gaps on every application to meet customer reporting requirements
- Preparing the LDM’s based upon the FD’s received for ECC sub modules for approaching design on TD of backend and frontend.
- Prepared project plan of deliverables of the backend and frontend objects which uses reviewing deliverables on expected time lines.
- Worked on SAP BW-HANA based LDMs with LSA++ Architecture design deployed.
- Instrumental in standardizing the Implementation process in data modelling in sap HANA from ERP,Integration with TnT interface for purchasing procurement data 2LIS 02 HDR/ITM and QA 2LIS 05 Q0ITEM by ODP is as a BW source, implemented ODP SAP NetWeaver-based framework, retained Delta for a definable time in the ODQ (delta queue).
- Designed and implemented SAP HANA data modelling technics using Attribute View, Analytic View, and Calculation Views.
- Instrumental in standardizing the Implementation process in data modelling in sap HANA from ERP andPOSDM systems using data source 0RT PA TRAN CONTROL with myself BW as source
- Worked on SLT to extract the real-time data from table MBEW, MBEWH and monitoring the related jobs at LTRC
- Worked on NLS and archiving the historical data for large volumes of the data set on specified retention period.
- Prepared BW Object sizing growth tracker for various objects based upon DBACOCKPIT to overcome future mitigates.
- Created Open hub destination on purchasing data and connected to 3rd party system via SSIS for target interface.
- Worked on 3rd party connection Spotfire with Simba interface in between BW, extracted BEx reports into the Spotfire system.
- Involved in SAP HANA Security including User Management, Roles, and Privileges using Life cycle management.
Environment - SAP BW 7.4, HANA 1.0, SLT, NLS, BO 4.0, ECC 6.0, Spotfire, BPC
Confidential, New Jersey
SAP BW Team Lead
Responsibilities / Deliverables
- Prepared project plan of deliverables of the backend and frontend objects which uses reviewing deliverables on expected time lines.
- Being involve on various source models viz ECC, ISU and CRM to implement the BW reports as per business requirement.
- Performed Mass simulation activities for simulated Billing during cutover activity.
- Delta enabled for following Successful Initialization of ISU-FICA data sources viz Simulated Billings (0UC SALES SIMU 01), Sales Statistics (0UC SALES STATS 02), Payments (0FC PAY), Returns (0FC RET), and Business Partners data (0FC BP ITEMS)
- Working experience on IS-Utility projects including Device management, FI-CA and Billing, Payment, Returns.
- Also, involved in Batch simulation process for simulatedBilling. Worked on Meter to Cash (MTC-Billing) including MRO, MRU, Premise, Function Location, Device, Installation, and Business partner to its associated Contract account.
- Performed prerequisites in ISU to perform data load into BW with different tcodes EAMS20, EAMS10, EAMS12, EAMS01, FP09, FPBW EXTRACT
- Followed LSA architecture for each area FI-CA, BI, DM as per SAP standards
- Created SPO on large data volume Business Partner, Sales with aggregation and without aggregation
- Created Number range buffering on master data and cube to improvise the data loading for DM, FICA, and BI area.
- Created business reports General Enquiries Statistic Report, Mean Time to Supply and Service Request Statistic Report
- Created Aggregates and roll up on the BP, Sales and Payment cube for faster query execution
- Created open hub destination for SISTERS report for governance norms.
- Handled transports the metadata objects across the landscape
- Created BO Webi reports on the source of BEX of each different module.
- Created process chains to auto schedules the daily loads for various modules DM, FICA, Billing and Master Data.
- Worked on UAT defects and resolving as per SLA.
- Performed the detailed design of application and technical architecture components.
- Configure, build, and test the application or technical architecture components.
- Participated in transitions of the application or technical architecture components to the testers.
- Fixed any defects and performance problems discovered in testing.
- Documented the application to facilitate maintenance.
Environment - SAP BI 7.3, BO 4.0, ECC 6.0, SRM, CRM, SAP ISU, FICA
Confidential
Senior BW Developer
Responsibilities / Deliverables
- Prepared project plan of deliverables of the backend and frontend objects which uses reviewing deliverables on expected time lines.
- Being involve on various source models viz ECC, ISU and CRM to implement the BW reports as per business requirement.
- Creating BO Webi reports on the source of BEX of each different module.
- Creating process chains to auto schedules the daily loads for various modules DM, FICA, Billing and Master data.
- Delta enabled for following Successful Initialization of ISU-FICA data sources viz Simulated Billings (0UC SALES SIMU 01), Sales Statistics (0UC SALES STATS 02), Payments (0FC PAY), Returns (0FC RET), and Business Partners data (0FC BP ITEMS)
- Working experience on IS-Utility projects including Device management, FI-CA and Billing, Payment, Returns.
- Also, involved in Batch simulation process for simulated Billing. Worked on Meter to Cash (MTC-Billing) including MRO, MRU, Premise, Function Location, Device, Installation, and Business partner to its associated Contract account.
- Performed prerequisites in ISU to perform data load into BW with different tcodes EAMS20, EAMS10, EAMS12, EAMS01, FP09, FPBW EXTRACT
- Working on UAT defects and resolving as per SLA.
- Perform the detailed design of application and technical architecture components.
- Configure, build, and test the application or technical architecture components.
- Participate in code reviews.
- Created Webi Intelligence Reports with query filters, Sorts, Breaks, alerts, Complex Operations. Performed performance tuning, troubleshoot existing performance issues problem solving, and debugging.
- Participate in transitions of the application or technical architecture components to the testers.
- Fix any defects and performance problems discovered in testing.
- Document the application to facilitate maintenance.
Environment - SAP BW 7.4, BO 4.0, ECC 6.0, SAP ISU, FICA
Confidential
SAP BW Technical Lead
Responsibilities / Deliverables
- Involved in requirement gathering from various departments viz SD, Procurement, MM, PP, PM, FI, CO, and HR at Client site (International and Domestic)
- Extensively involved in creating Info objects, Data Store Objects, Transformations, Info cubes, Multi providers. Involved in enhancing the data sources and write the ABAP coding to populate the enhanced fields.
- Conducting meetings with various department end users to understand the Business requirement for analytical reports.
- Configured BI system basic general settings at SPRO and RSA1 for mitigating issues while data loads transports and other activities.
- Preparing the LDM’s based upon the FD’s received for ECC sub modules for approaching design on TD of backend and frontend.
- Worked with Generic data sources and SAP delivered Data sources, LO Extraction, Data Loading (full/Init/delta upload), Scheduling, Monitoring
- Performed LO-Cockpit extraction to pull data from R3 SD modules into BW system extracting the Header and Line item data from the Sales and Distribution (SD) module (LIS 11 VAHDR/VAITM, 2LIS 12 VCHDR/VCITM, 2LIS 13 VDHDR/VDITM).
- Performed LO Extraction to pull data from Plant Maintenance for 2LIS 16 I0NOTIF,2LIS 17 I0NOTIF and 2LIS 18 NOTIF for Maintenance Notifications Info Cube (0QM C10)
- Extracted data from 2LIS 02 ITM, 2LIS 02 SCL, 2LIS 03 S194 and populated into the procurement info cubes 0PUR C07, 0PUR C08, and 0PUR C09 to appraise the service levels
- Responsible for the development of Exception & Condition based reports on Slow Moving Items, Inventory Ageing, Delivery Tracking System and Vendor evaluation for SCM (0IC C03, 0PUR C01).
- Design and develop data extracts from SAP and non-SAP systems, Data modelling of Operational Data Store and Info cube structures
- Analyse, design, develop, implement, and support back-end design, construction and testing of Info Cubes, Multi Cubes, and Info Packages and all back-end components (e.g. ODS, Transactional Info Sources/Data sources, Master Data, Info Objects, Transfer Rules, User Exits, Update Rules) as specified by end user requirements for reporting solutions.
- Ability to work with a diverse and integrated team consisting of application developers, business users and business analysts. Understand BW Authorization Concepts, Conduct Testing (Unit, Functional, Integration, User Acceptance)
- Created Info Packages to do Full, Initial, and Delta extraction for both Master data and Transaction data with dynamic selection criteria where needed.
- Performance tuning at data loading, reporting before Go-Live. Analysed performance statistics and recommended improvements.
- Worked on Design & Development on BW / CRM and FI related BI objects & queries.
- Prepared project plan of deliverables of the backend and frontend objects which uses reviewing deliverables on expected time lines.
- Worked on Hyperion source thru DB connect for various Business reports.
- Created multiple APD’s to achieve Business reporting on Inventory non-cum module.
- Monitoring Process Chains of various modules viz Master Data, SD, MM, HR, FI, PP, PM, PCA, CO and Inventory.
- Lead Off-shore team as Technical front for resolving Tech issues during data loads and development.
- Monitoring data loads from BODS Source system as 3rd Party External connectivity.
- Involved in Creation of Semantic Partition DSO and Cube for optimal data loads.
- Creation and Monitoring of RDA data loads using Web Service as Source system.
- Designed complex APDs by using merging options for different Queries to achieve the requirement.
- Create BIA Index on high data volume and complex cubes to improve the Query performance.
- Analysed Performance Tuning on complex and high volume of data loads and implemented different scenarios viz. SPO and Number Range buffering...etc. for Master and Transaction loads.
- Worked with Customer, Material and Vendor master data objects data mapping from the source to target fields as per the business requirement.
- Created Scripts like starting script and ending script for each job and declaring the variables local and Global Variables. Used various transformations like Map Operation, Table Comparison, Row-Generation, History Preserving, Query and SQL transformation in BODS.
- Created, validated and executed jobs to transfer data from source to target. Worked on Data Quality and cleansing the data. Created Technical Design documents and unit test plans.
- Production Support Activities to take care of the job executions loading Adjustment files for supporting Month/Year end closure in BW and BODS.
- Expertise in monitoring the job logs, server logs to troubleshoot and resolve the issues in BODS.
Environment - SAP BI 7.3, BO 4.0, ECC 6.0, BODS, PCFILE, Web Service
Confidential
Sr. SAP BW Consultant
Responsibilities / Deliverables
- Monitoring the Event Trigger Process chains daily.
- Unit Testing on Latest Support Pack on EC for each patch level Test script as this is new implemented by SAP and Accenture jointly as 3rd Party-Source system SAP-EC Environment Compliance and EHSM-Environment, Health and Safety.
- Preparing Technical specification, Unit Test, User Acceptance Test and related documents for Enhancement projects.
- Scheduling Info packages for loading Master Data and Transaction Data & Monitoring.
- Configuration work TEMPhas included Info objects, Info Cube, Transfer Rules, Update Rules, Roles, Queries, Web Templates, ABAP
- Actively worked on testing scenarios and coordinated with team on the assignments to get the work finished under deadline.
- Uploaded master data and transactional data from SAP R/3 via data staging to PSA, ODS and Info Cubes. Worked with data flows from R/3 to BW.
- Uploaded master data and transactional data from SAP R/3 via data staging to PSA, ODS and Info Cubes. Worked with data flows from R/3 to BW.
- Worked extensively with LO Cockpit data sources like 2LIS 02 HDR, 2LIS 02 ITM, 2LIS 02 SCL, 2LIS 03 BF, 2LIS 03 UM. Also, worked on APO Standard data sources which are created on Planning Area, and New Custom Planning areas with different aggregation levels.
- Extensively worked on development of Data Models for extracting the DP/SNP data into SCM System from Live Cache and then into SAP BW Data Models as per the reporting needs at different levels.
- Handling the various priority Tickets with in SLA.
- Enhancement on WAD Dashboards.
- Learning on Functional SAP-EC aspects to get scope with business requirements.
- Worked on redesigning of Purchase Orders, Inventory, MRP Reservations and Contracts and pulling delta from R/3 to development environment.
- Followed AGILE Methodology throughout the development of the project.
- Extensively worked on Enhancing ECC Logistics data sources using ABAP user exits.
Environment - SAP BI 7.0, SAP Environmental Compliance(EC), BPC, ECC 6.0
Confidential
SAP BW Consultant
Responsibilities / Deliverables
- Extensively involved in creating Info objects, Data Store Objects, Transformations, Info cubes, Multi-Providers. Involved in enhancing the data sources and write the ABAP coding to populate the enhanced fields.
- Extracted purchasing documents and inventory data from R/3 using LO cockpit, implemented Report-to-Report Interface and R/3 thrill-through for drill down analysis, and developed SAP BW reports for performing the analysis of purchasing documents and inventory management.
- Loaded Data to Standard Cubes (0PM C01) and (0PM C03) from 0PM OM OPA 1 to find the Status of the maintenance orders in terms of completed, outstanding and the percentage completion. This report is very useful in tracking the compliance of breakdown or the maintenance activities.
- Analysing source data, and halping to establish ETL guidelines, to the design, development, and testing of Data Services ETL programs/processes to move and transform data from several businesses into SRA database.
- Read data from Flat Files, Spreadsheets, SQL Server, Oracle Client, SAP BW Source, SAP Applications etc. Extract data from the SAP ECC, R3 tables using ABAP Dataflow.
- Scheduled jobs using Management Console and Crtl+M. Worked with Central repository to share jobs with other users and check-out, check-in the jobs.
- Involved in Monitoring and Production Support.
- Monitoring Process Chains of various modules viz Master Data, SD, MM, HR, FI, PP, PM, PCA, CO and Inventory.
- Created of Generic Data source for Customer Portal by using View.
- Monitoring of Monthly loads of SCM.
- Involved in performing Production Support, Time Sheet Maintenance of the Support Team.
- Maintain list of all the activities for all the Tickets until it is closed.
- Actively involved in Rectification of Load Failure Errors like Master Data Loads, Transaction Loads.
- Daily monitoring of Info Cubes, Info Objects and ODS object requests.
- Involved in creation of Info cube of Factory Calendar Id for SCM.
- Created Audit Reports of MM and FI Modules.
- Involved in Creation of Info cube and DSO for Customer Portal and created Reports for the customers.
- Involved in Functional Upgradation from 3.1c to BI 7.0
- Involved in Quick Sizing of Production Data.
- Implementation of PCA and BCS and Monitoring daily loads of PCA data.
- Enhancement of Data source 0WBS ELEMT ATTR by adding required field
- By appending structure and written code in functional enhancement.
- Enhancement done in Audit Reports by adding user required fields in Rows and columns.
- Involved in submitting the Ticket Status (Open/Close) report.
- Maintain Work History 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.
- Handled tickets with different priority and never missed the SLA.
- Involved in developing the SLA reports at end of every month.
- Involved in maintaining lot of documentation for all the Support Activities.
- Loading of Actual data into Info cubes for SEM-IP.
- Enhancement done in SD, PP Info cubes viz 0SD C03 and 0PP C01 by adding required fields.
- Loading the data into 0PP C01 Info cube by using Loop Back Process.
- Designing the BW staging area’s and BPC staging areas for the required T&W costs from various applications from below interfaces Volumes from APO, Rates from FTI Costs from Material Ledger, Allocations from COPA.
- Designed Process Chains for Daily Master data loading and transaction data loading from ECC to BI and to BPC.
- Creating staging Cubes in BI & BPC system and loaded data to Open Hubs and generated custom Data Sources, to load data into Staging Cubes in BPC.
- Involved in Monitoring and Production Support.
- Monitoring Process Chains of various modules viz Master Data, SD, MM, HR, FI, PP, PM, PCA, CO and Inventory.
- Created of Generic Data source for Customer Portal by using View.
- Loading the data into 0PP C01 Info cube by using Loop Back Process.
- Involved in creation of Info cube of Factory Calendar Id for SCM.
- Involved in Functional Upgradation from 3.1c to BI 7.0
- Involved in Pre-and Post-check of BW upgrade activities and document the ongoing issues.
- Involved in Quick Sizing of Production Data.
- Implementation of PCA and BCS and Monitoring daily loads of PCA data.
- Developed dashboards on Visual Composer with distinguish features and published on Enterprise portal.
Environment - SAP BW 3.1C & BI 7.0, R/3 ECC 6.0, CRM, SCM, IP-SEM, Visual Composer, Enterprise Portal