Sap Ibp Consultant Resume
3.00/5 (Submit Your Rating)
Houston, TX
SUMMARY
- 9 Years of SAP Experience in SAP APO (CIF, DP, SNP, and GATP), IBP/S&OP, BW / BI has good knowledge in Manufacturing, Hi - tech, FMCG, Process Industry and Oil&Gas
- Around 1.5 Years of experience as SAP IBP Consultant (S&OP 3.x, IBP 4.x and IBP 5).
- Extensively worked on implementation methodologies like ASAP Methodology and Scrum Methodology
- Trained in SOP200 & SOP300 and HCI
- 2 End-to-End SAP APO Implementations with strong understanding of Business Requirements, Business Process flows and System Analysis.
- 3 Production Support in SAP APO in the areas of Demand Planning (DP) and Supply Network Planning (SNP)
- 1 Enhancement in SAP APO in the Area of Global Available to Promise (gATP)
- 1 End-to-End SAP IBP Implementation using Scrum Methodology.
- 1 Production support in SAP IBP for Demand Planning and Supply Planning.
- 1 Rollout in SAP IBP for Demand Planning and Supply Planning
- 1 POC & Demo in SAP S&OP .
- Extensively worked on SAP IBP Web UI and Excel UI
- Hands on experience on JAM (Success Factors)
- Configured complex scenarios in SAP IBP with good performance.
- Involved with SAP in performance testing
- Good Knowledge on Supply Chain Control Tower
- Highly Proficient in Requirements gathering and preparing Business blue print.
- Extensive experience in Solution design and Data modeling.
- Good experience in Implementation of Supply chain reports and KPI’s.
- Good experience in Sales and Inventory.
- Excellent Technical, analytical, presentation, communication, leadership and Management skills.
- Strong team player and interact well with Business users, Functional and Technical team to meet the project deadlines.
- Strong Knowledge in the business process of Sales, Forecasting, Promotion, NPI, Supply, Production, Procurement, Sub Contracting, Availability Check.
TECHNICAL SKILLS
ERP: SAP R/3 ECC6/ 4.6C/ 4.3C (SD,MM,PP)
SAP APO: SAP SCM 5.0, 7.0
SAP S&OP: SAP S&OP 3.x, IBP 4.0 & 5.0(IBP For Demand)
Warehouse Tool: SAP BW 3.5, SAP BI 7.0
Reporting Tools: SAP BO 3.X, Bex Analyzer, Query Designer.
Collaboration: JAM
PROFESSIONAL EXPERIENCE
Confidential, Houston, TX
SAP IBP Consultant
Responsibilities:
- Designed S&OP process for mid-term planning in IBP which will balance Demand and Supply.
- Understanding the current business flow and their Hierarchies starting from Supplier level to Customer level.
- Modeled Unique Master data, by which finance planning can be integrated with Demand Planning and Supply Planning.
- Worked with HCI (Hana Cloud Integration) team for mapping Master data and transaction data.
- Load master data and transaction data through HCI batch job.
- Configured Process Modeling Ribbon in IBP, which will show the complete S&OP Process stating from Demand Review, Supply Review,Pre S&OP and Executive Review
- Integrate Planners with IBP through JAM
- Schedule batch job to greater forecast at different levels and provide view access to different segments in Demand Planning.
- Maintained authorization based on the planners hierarchy
- Configured reason codes and JAM Groups for demand planning and supply planning.
- Calculate consensus forecast based on all adjustments.
- Created batch job in IBP, which will run Supply planning operator (Unconstraint Heuristics).
- Calculate different demands over lead time (Demand Over Lead time, Max Demand Over Lead time, Average Demand Over Lead time)
- Calculate safety stocks (Lead time safety stock, validated safety stock)
- Configured alerts based on the threshold values
- Target stock based on 3 Months Moving Average
- Created versions to check what if scenarios.
- View Profitability of different Planning versions
- Extensively worked on Web UI and Excel UI.
- Involved in Implementation, Rollout, and Production Support.
- Worked on User Management and Authorizations ( User Creation, Roles, Visibility Filters)
- Create documentation and train end users
- Identify the Master data issues
- Provide support to the Existing Business
- Supporting daily day to day issues
- Capturing user requirements and creating as change requirements
- Configured Complex solutions and tuned system in terms of better performance
- Identified bugs in the systems and co-ordinate with SAP and get resolved
- Worked with SAP during performance testing.
- Enhance the existing Functionalities as per Planners requirements
- Provide Documentation for Business Users
- Good Knowledge on HCI (Hana Cloud Integration)
- Helping out HCI team in resolving data integration issues.
- Respond to tickets As per SLA’S
Confidential
SAP IBP Consultant
Responsibilities:
- Understand the Business Templates
- Designed unified model for Both Demand and Supply Planning
- Analyze Master data and Transaction Data from templates
- Configured in IBP as per their templates for Cables and non-cables
- Ability to generate different versions of rolling Plan for (Local, Export, Dubai, Projects)
- Change the DPG inventory strategy which is propagated to the material level.
- Change the calculated monthly target stock @ material level which will reflect in Rolling Qty
- Consider Sales of Phase out SKUs as a part of new SKUs to generate the forecast.
- Automatically cleanse the historical data to calculate the material contribution & Classification inside each DPG
- Statistical Forecast Projection by various statistical algorithms include best Fit & ability to change the forecast at any level and system will change the under/upper level Automatically.
- Ability to measure storage constraints and production capacity constraints
- Capture both constraints and unconstraint Forecast
- Ability to consider backlog orders.
- Simulate the best mix considering standard cost, Profitability
- Ability to get capacity underutilization and over utilization load alert
- Consider stock of all DCs before Calculating MPS, for stock utilization
- Modeled S&OP Process (Demand Planning, Supply Planning, Demand & Supply Balancing)
Confidential, Cupetino,CA
SAP APO Consultant
Responsibilities:
- Worked on DP, SNP & GATP Enhancements (AMC,EMIA,APAC)
- Worked on RBA & BOP
- Done Enhancement to Product Allocation
- Interacts with the business team and understand their business and Issue.
- Replicate the issue in the System and analyze the same.
- Interacts with Business for the required changes.
- Provide Detailed designed document (functional Spec) which includes filed at table level, and get approvals from Business.
- Helping out technical team in understanding the gap
- Provide documents for technical people for their Unit testing
- From functional side, we make sure that new functionalities are working as expected and not affecting any other existing functionality.
- Perform Unit testing and UAT for one Region (AMC) and get signoff from users.
- Check the Performance Testing Results and get signoff from Performance team.
- Provide overview for RT Testing.
- Follow-up with client after the new changes are in production
- Knowledge on MATP
Confidential
SAP APO Consultant
Responsibilities:
- Involved from realization and successfully completed Go-Live within the time
- Interact with clients and gather requirements
- Providing Solution based on client requirements.
- Understand the as on Process and Map the Client Requirements in SAP
- Configuration of DP&SNP Based on Client Requirements
- Configuring CIF
- Resolving CIF Issues.
- Carried out entire implementation of demand planning and Supply Network Planning.
- Provided the best SNP solution based on the DRC Business.
- Worked in a tight integrated Systems (APO,SRM,EWM,ECC,BI)
- Proposed best suitable forecasting techniques according to the clients business.
- Mapping Quota for Procurement & Production
- Configured Subcontracting Scenario.
- Generate Scheduling Lines from APO.
- Configured Justin time Scenarios.
- Analyze SNP Results based on Optimizer and Heuristics.
- Proposed different BW Reports in DP &SNP Based on Client Requirements.
- Configured Deployment based on the business Requirement.
- Configured TLB based on the Different transportation available to DRC.
- Identify the core/end users and train them.
- Creation of roles for different users.
- Provided core user documents.
- Provided configuration documents.
- Carried out Integration Testing and UAT Testing.
- Prepared SOP (Standard Operating Procedure) Documents
- Successfully Completed go live
- Configured ATP settings in ECC and SCM
- Enabled Product Availability and product allocation checks
- Configured BOP
Confidential
SAP APO Consultant
Responsibilities:
- Responsible for understanding and mapping the business process in DP.
- Involved in regular discussions and meetings with the Onsite team for requirements in DP.
- Design and Maintenance of Info Cubes, ODS and other BW related Objects.
- Involved in Creating Macros, Transfer Profiles and Release Profiles and created Activities for Mass Processing.
- Create planning versions, Configuration of new Planners in APO, Assign user to planning books/data views, Run the forecast (both interactively and through background job) for all the models.
- Create a background job to run the macros, Check the release functionality both online and background, Check for the distribution functionality, Run-realignment in the planning area, Upload the data to planning area, Version copy of planning area in Testing system.
- Responsible in maintaining characteristic value Combinations & loading planning area version.
- Responsible for Maintaining Planning areas, Master planning objects structures.
- Responsible for Creation and Activation of Integration model to transfer the Master Data and Transaction data from ECC to APO system (CIF).
- Maintained CIF Integration Models for Master and Transaction Data transfer between R/3 and APO. Mass Maintenance of Master Data in APO.
- Performed Life Cycle Planning through Like Profile, Phase-in and Phase-Out Profiles.
- Resolved all issues related to Unit testing, Integration testing in DP (Download/ upload, Info packages, CVC’s, Realignment, Batch jobs, Forecast release, variants, Planning books, Macros etc).
- Created Time bucket profiles, Planning books, Data views, forecast profiles for Demand Planning components of SAP.
- Involved in Creating Macros, Executing Forecast, Transfer Profiles and Release Profiles and created Activities for Mass Processing.
- Set up SNP Master Profile and configured SNP Master Data.
- Maintain Different models and versions.
- Experience in Heuristics.
- Creating different profiles for SNP run.
- Created a Supply Chain Model to represent the Supply Chain Network with all relevant locations (vendors, plants, distribution centers and customers), resources (storage, handling and supply capabilities) and relationships (Transportation Lanes).
- Knowledge on PP/DS.
Confidential
SAP APO Consultant
Responsibilities:
- Analyze and understanding of business needs and requirements so as to design collaborative solutions to streamline client business processes.
- Preparation of unit test cases from functional documents APO DP.
- Execution of unit test cases for APO DP.
- Monitoring of Batch job runs, failure analysis and reporting.
- Monitoring of CIF queues. Analyzing and clearing the blocked queues.
- Involved in knowledge transfer sessions from our senior consultants.
- Developed training documents for the End Users, knowledge transfer with end user.
- Released Demand Plan to SNP.
- Hands on experience in monitoring CIF issues and resolving.
Confidential
SAP BI Consultant
Responsibilities:
- Implementation of SLOB / Inventory Ageing KPI.
- Implementation of MAPE report .
- Performance tuning of queries.
- Implementation of operational Reports.
- Modeling of Cubes, DSO and multi Providers.
- Created Infosets for master data reporting.
- Creation of process chain.
- Creation of Past due Order Reports.
- Creation of Data source based on function module.
- Creation of Data source Enhancement.
Confidential
SAP BW Consultant
Responsibilities:
- Data loading and monitoring in accordance with loading plan.
- Solving the tickets posted by the end user.
- Monitored data loads with full update and delta mechanisms for both master and transaction data
- Involved in monitoring of Info Packages and analyzing the failure reasons of Info Packages.
- Optimization of process chains and processes.
- Checked Source system connections.
- Involved in Design and creating Processes Chains to automate the process of loading data into data targets
- Checking the daily time schedule for the run & ensuring that the jobs are finished within the specified time frame.
- Load Monitoring of Daily, Weekly and Monthly Data Loads using Process Chains.
- Extensively worked on the Performance Tuning of the System.
- Maintaining Reconciliation to verify the data in R/3 and SAP BW are same or not after the data loads.
- Uploaded master data and transactional data from SAP R/3 to SAP BW via data staging to PSA, ODS and Info Cubes.
- Used ODS to stage the data before transferring the extracted data to the Info Cube.
- Involved in activating the Business Content Data Sources for QM, Customized BW objects including the Data sources, Info Cubes, ODS Objects, Info objects and Standard Queries
- Worked Extensively on Lo cockpit for the Data Sources.
- Created custom Reports for QM using Filters, Calculated and Restricted Key Figures, Exceptions and Conditions and Text Variables.