Senior Sap Bw/4hana Consultant Resume
AtlantA
SUMMARY:
- SAP Certified with 10+ years of IT experience in ERP based Business Warehouse application SAP BW/4HANA, SAP HANA , SAP BW 7.4 on HANA, SAP BW 7.4 Oracle, SAP BW 7.4 on Oracle EXADATA, SAP BI 7.0, SAP BW 3.5, Business objects 4.2, Design Studio 1.6, SAP BI - Integrated Planning(IP), SAP BW-Business planning and Simulation(BPS), SAP BW - Advanced Planning and Optimization (APO), with 10 projects experience of Implementations, Developments, Enhancement, Support, Migration, Roll out projects and 3 Proof of Concepts .
- Knowledge and 2+ years of working experience with business process and 5 years of working experience on CPG business process.
- Extensively worked on implementing Logistics, Finance - General Ledger, Account Receivable, Account Payable, Banking, Manufacturing, Material Requirements Planning (MRP), Controlling, Project systems, and CRM applications.
- Currently Working on SAP BW/4HANA (Greenfield) implementation for Confidential .
- Experience in Native HANA Modeling - Calculation Views, Analytical Views, Attribute views.
- SAP BW HANA Expert in the areas of Building EDW architecture (Data Modelling) to front end design BEx Query Designer, Analyzer, Web Designer, Analysis for Office, Business objects Webi Reporting, Design Studio .
- Strong experience in SAP BW Design or Architecture and in implementing Customizations, automations, Performance Optimizations, solution provider.
- Experience in implementing Layered Scalable Architecture (LSA++) in SAP BW on HANA system.
- Experience on implementing Operational data provisioning (ODP), ODP with SLT (SAP Landscape transformation) to perform real-time data replication to BW.
- Experience and working knowledge on implementing Financial and Sales planning models using HANA PAK (Planning Application Kit), Integrated planning, Business planning Simulation.
- Strong experience in handling SAP BW Cutovers and successful delivery of Tire 1 projects.
- Strong experience in Requirements gathering, analysis, validation, and management of requirements, provides an estimate to completely deliver the project, Lead the solution development, quality assurance, release management, Post go-live support, performance tuning and coordinating with business experts, stake holders and multiple vendor management teams.
- Strong experience in implementing data archiving using NLS.
- Worked on Business objects analysis office 2.4.
- Worked on large SAP and Non SAP systems landscapes having SAP ECC, CRM, HANA, Business objects, BW - Portal, Enterprise portal, SAP Data Services, SAP MDM, DataLake, 3rd party data bases.
- Demonstrated ability to work independently and flexibility to adapt in an ever changing business environment.
- Strong Communication and Interpersonal skills to maintain effective work relationships with all levels of personnel.
- Good team player with excellent communication, analytical, interpersonal and writing skills.
TECHNICAL SKILLS:
ERP & Applications: SAP BW/4HANA, SAP HANA, SAP BW 7.4 on HANA, SAP SLT, SAP BI 7.0, SAP BW 3.5, ABAP, SQL Script, SAP ECC, SAP CRM, SAP APO, SAP BW- BPS, SAP BW-IP.
Reporting Tools: SAP BW-Business Explorer, WAD, SAP Business Objects Analysis Office 2.4, WEBi, Design Studio 1.6, Enterprise Portal.
Languages: SAP ABAP, SQL Script, C, C++, JAVA.
Database: HANA 1.0- In Memory Appliance, Oracle 12c-Oracle EXADATA.
Tools: HP Change Management, Software Testing - HP ALM, AGILE Methodology - JIRA, Service Now
PROFESSIONAL EXPERIENCE:
Confidential, Atlanta
Senior SAP BW/4HANA Consultant
Responsibilities:
- Involve in preparing HANA Best Practices handbook and Naming convention documents.
- Analyze the existing Design of BW Reports in classic BW systems and prepare design documents for BW/4HANA development.
- Designing calculation views (private views, reusable view, Query View), counters. Restricted and calculated Measures, input parameters, filters debugging views.
- Created the HANA objects like ADSO, Open ODS, and Composite provider.
- Working in HANA Replication techniques SLT.
- Handling currency conversions in HANA views.
- Imported and exported HANA Views in different Landscape and Migration of HANA views from Development till Production.
- Test HANA Views and all developed objects and resolve defects.
Environment: BW/4HANA, SLT, HANA Studio, BW Modeling Tools, HANA Modeling tools, Lumira 2.0 .
Confidential, Atlanta
Sr. SAP BW Consultant
Responsibilities:
- From SAP BW Technical perspective, Ensure overall Migration of SAP BW, BW - Portal, Enterprise portal systems, migration to ORACLE EXADATA/Linux goes well and smooth and making sure all the Interface apps are connected and work as expected.
- Understanding overall Oracle EXA Architecture build, implementation from CTO Team and Oracle OOO/O2O Migration process and worked with Oracle ACS Team throughout migration.
- Involvement in defining project success and Exit criteria.
- Involvement in Project plan preparation, and submission for review with CoE Teams.
- Impact analysis and test strategy preparation and test cases preparation to cover all Confidential BW objects.
- Conduct all required function and performance testing to cover all the scenarios in Confidential .
- Ensure all SAP BW inbound and outbound Interfaces are connected and tested.
- Implementing ABAP program for easy validation of SAP BW and ECC Objects during each migration window.
- Co-ordination with SAP during performance testing on BW on EXADATA and analytical solution testing.
- Technically lead migration of each BW systems and cutover activities.
- Fix the defects and Identify potential issues and fix.
- Report out preparations with lessons learning, performance analysis on EXAD.
Environment: SAP BW 7.4, SAP ECC, SAP Solution manager 7.4, BW Business Explorer, BW- Portal, Enterprise Portal, Business object 4.2, Business Objects Analysis Office 2.4,Design Studio 1.6 .
Confidential, Atlanta
Sr. SAP BW Consultant
Responsibilities:
- Discuss with Business key users of Field core and Functional teams on Reporting requirements.
- Define tasks in JIRA Story created as per requirements and daily cadence (Scrum meeting ) establishment
- Analyze the requirements and prepare high level technical Design.
- Extensively worked on field core, business process using Project systems, Controlling.
- Extensively worked on business on implementing Manufacturing (MRP) Reporting and Material Optimization Suit.
- Understanding and worked on MRP Extractor build (MD05).
- Extensively worked on implementing cross application BW reports on PS-SD and these reports are being used globally
- Lead the solution development and Testing.
- Conduct working sessions with business key users and functional team on testing the BW Reports.
- Co-ordinate with various stake holders and Basis team on BW Cutover activities.
- Handled BW cutovers and resolved critical business issues and provided User Trainings.
Environment: SAP BW 7.4, SAP ECC, SAP Solution manager 7.4, BW Business Explorer, Enterprise Portal, Business objects 4.2, Business Objects Analysis Office 2.4,Design Studio 1.6, JIRA, HP ALM.
Confidential
Sr. SAP BW Consultant
Responsibilities:
- Understand the PowerMax - SAP systems architecture (SAP ECC, SAP BW, Business Objects, BW-Portal, Enterprise Portal) and all other interfaces connected to ECC and BW systems.
- Conduct Impact analysis on SAP landscape.
- Understand the SAP Landscape optimizer tool functionality.
- Prepare project implementation approach, remediation strategy, test strategy and project plan.
- Analyze the BW applications and all objects in the system.
- Conduct Remediation activities to the Identified/impacted BW objects and ABAPs.
- Co-ordinate with SAP, Multiple Interface teams, mapping teams, business on testing activities.
- Identify potential defects during Testing and resolve defects.
- Handled all BW production cutover activities
- Resolved critical issues part of post migration.
Environment: SAP BW 7.4, SAP ECC, SAP Solution manager 7.4, BW Business Explorer, Enterprise Portal, Business objects 4.2, Business Objects Analysis Office 2.4, JIRA, HP ALM.
Confidential
Technical Specialist
Responsibilities:
- Discussed with IGS Business Experts on 50 finance, SD, SRM, MM, HR reporting requirements.
- Prepare the blue print documents with DDIC for each report and high level design for all Financial Reports.
- Understand the Trial balance reporting functionality using 3rd party tool from Business experts and implement the functionality with in BW on HANA.
- Prepared the BW on HANA project approach and project plan.
- Conduct validation checks in Serco BW on HANA and IGS BW on HANA systems and corresponding Source systems.
- Prepare technical design documents and Lead the solution development
- Created Semantically Partitioned objects.
- Conducted Analysis to change the design with Composite provider to replace Current Info set object.
- Worked on LSA++ architecture.
- Handled all testing activities, coordinated with business and resolved defects.
- Handled all BW cutover activities
- Build business objects webi Reports.
- Provided daily and weekly status reports.
- Mentoring team, Lead daily calls.
Environment: SAP BW 7.4 on HANA, SAP ECC, SAP SRM, SAP BW Business Explorer, Business Objects Analysis Office, Business objects 4.2 .
Confidential
Technical Specialist
Responsibilities:
- Identify the pre-requisites for ODP framework configuration in SAP BW and Source system i.e SAP ECC.
- Explore the features of ODP vs. SAPs existing data provisioning by configuring, implementing ODP.
- Understand the ODQ functionality and benefits.
- Convert generic extractor to ODP enabled extractor.
- Understand the risks in replacing the ODP with existing data provisioning
- Identify the pre-requisites for ODP-SLT configuration in SAP Source systems, SLT system and BW system.
- Explore the features and configurations of ODP framework with SLT in SLT system.
- Understand the SLT functionality in real time replication scenario with ODP and monitoring queues in ODQ.
- Understand the Pre-requisites for implementing PAK.
- Gather requirements from Sales Team and implement Planning models for Sales and financial strategic planning.
- Identify and install the sales order and relevant master data extractors required
- Create DSOs in BW to extract the Sales history data from SAP ECC system
- Create and schedule the controller jobs in ECC.
- Create an FM based generic extractor to extract characteristic variant configurations and store data in BW.
- Replicate relevant Sales history DSO and variant configuration DSO in SAP APO system.
- Create Info Cube to transpose the characteristic variant configuration into CBF data in SAP APO.
- Create Process chains and schedule the data loads in both BW and APO systems.
Environment: SAP BW 7.4 on HANA, SAP SLT, SAP ECC, SAP APO, SAP BW Business Explorer, Business Objects Analysis Office, Business objects 4.2 .
Confidential
Technical Specialist
Responsibilities:
- Owns the Requirements gathering, analysis, validation, and management of requirements.
- Provides an estimate of Full Time Effort (FTE) days needed to completely deliver the Work Request.
- Lead the solution development, quality assurance, release management and leverages vendors to deliver on time.
- Coordinating with the Project Managers, Operations Managers, and all other teams (stake holders)
- Run and monitor the application processing after the change moves into production to determine if the change is successful and if it can be closed
- Communicate the change progress with the business and all stakeholders.
- Lead offshore BW technical team of 7 who are working in development/enhancements
Environment: SAP BW 7.0, SAP ECC, SAP BW Business Explorer, Business Objects Analysis Office.
Confidential
Technical Lead
Responsibilities:
- Requirement gathering from business users
- Provide estimations (effort and cost)
- Resource work allocation / assignments
- Conduct review for the deliverables and ensure on time and quality delivery.
- Prepare Technical design documents and review with Application Manager.
- Build the EDW layer for SD (orders, Delivery, Shipments, and Billing) and MM applications.
- Extensively worked on standard (LO) and Generic extractors using Function Modules, Views and Tables.
- Lead development, Data loading and set up table fill and preparation technical test cases, and conduct SIT.
- Conduct SIT review with business and support for BAT.
- Extensively worked on change management and Cut over activities.
- Conduct hyper care and fix issues during hyper care.
- Co-ordination with other vendor teams and business users.
Environment: SAP BW 7.0, SAP ECC, SAP BW Business Explorer, Business Objects Analysis Office.
Confidential
Sr. SAP BW developer
Responsibilities:
- Worked extensively in development and enhancing BW objects for all regional landscapes.
- Handled Design, Development, Release to Test Systems, Resolving issues in Test Systems, Release to production system activities, Hyper care activities
- Analyze the requirements and preparing technical design document for change request.
- Working on activating standard Data Sources in SAP ECC Source system, enhancing the standard and generic data sources, replicating and activation data sources in
- SAP BI Data warehousing workbench.
- Creating info Objects, DSOs, DTPs, Transformations, Info Packages.
- Design and development of Process chains, monitoring process chains.
- Worked on Creating Out bound Web Services for transforming data to Spring Wireless Application through TIBCO by using END Point as Function Modules
- Configuring web Services in SOA MANAGER.
- Generating binding WSDL Link for outbound Web Services.
- Creating Info Objects, DSOs, and Writing routines in Transformation Level.
- Working on Business Planning and Simulation and creating Standard Planning areas, Planning Levels, Planning packages, Manual Planning Layout, Planning Functions, and Planning Folders.
- Release the Planning Objects to Test Systems.
- Worked on Planning Function using Exit for uploading Flat File data to Real-Time Info.
Environment: SAP BW 7.0, SAP ECC, SAP BW Business Explorer, Business Objects Analysis Office.
Confidential
Sr. SAP BW developer
Responsibilities:
- Worked extensively on Data warehouse workbench (RSA1) and customized Info Objects, Info Cubes, DSOs, Data Sources, DTPs, Transformations, and Multi Providers.
- Worked extensively on BPS0 and installed Standard BI content for CRM trade promotion planning Cubes, Data Flows including Planning packages, Planning Levels, planning profiles.
- Worked on Data Source Enhancements on ECC and CRM until BW Reports and generated workbooks.
- Worked extensively on creation of Data Sources, Transformations, DTP, and DSO’s, Info Cubes, BEx Queries and workbooks.
- Worked extensively on Start Routines and End Routines.
- Worked on BPS in defining Planning objects like Planning areas, Planning Level, Planning packages, planning Layout, Planning Profiles.
- Worked on BW - BPS Manual Planning.
- Conducted testing and prepared test cases.
- Conducted BW Technical cutovers.
- Conducted process chain monitoring.
- Provided training to user on BW-BPS Manual planning.
Environment: SAP BW 7.0, SAP CRM, SAP ECC, SAP BW Business Explorer, SAP BW-BPS.
Confidential
Developer
Responsibilities:
- Worked extensively on Data warehouse workbench (RSA1) and customized Info Objects, Info Cubes, DSOs, Data Sources, DTPs, Transformations, and Multi providers, Info Sets.
- Activated Standard data sources of SD & MM (Purchasing) and Shipment application areas.
- Extensively worked on LO Cockpit. Activated standard data sources and performed necessary procedures like setting up of Update Mode, Generate Data sources, filling up of set up tables and loaded the data from SAP ECC to SAP BI.
- Created Generic data source using Database view, Tables and Function Modules.
- Replicated the standard and generic data sources into BI.
- Installation of standard BI content objects.
- Created Custom Info Objects, DSO, DTPs and Info Cubes.
- Scheduled DTP for loading Transactional Data from PSA to Info Provider using process chains.
- Created process chains and scheduled.
- Monitor the process chains and fix the issues.
- Involved in creation of BEx reports using Query Designer such that by using Conditions, Exceptions, Free Characteristics, Restricted key figures, calculated key figures, variables.
- Monitoring process chains and resolute issues.
- Working on Incidents and Service Requests and problem Management tickets and close with in SLA.
- Perform critical Month end and Quarter End, year End Closure activities.
- Perform weekly housekeeping activities.
- Identify data Load Performance issues and conduct steps to improve performance.
- Debug ABAP Codes and identify logic issues and clarify users on existing logics and propose logics.
- Conduct history data loads during Technical Go-Live.
Environment: SAP BW 7.0 and 3.5, SAP ECC, SAP BW Business Explorer.