SUMMARY:

• Dedicated SAP Supply chain solution provider with 20 years of experience in the IT industry with 3 years of experience in SAP IBP, 12 years of experience in SAP BW reporting solutions and Over 5 years of SAP ECC.
• Seeking a challenging position as a SAP SCM /IBP Consultant, where my knowledge along with my Professional experience, allows me to make an immediate contribution with continued personal and Professional growth
• Involved in complete life cycles of 2 SAP IBP implementations .
• Very strong supply chain domain expertise by providing solutions using SAP BW, SAP HANA and other reporting tools.
• Very strong Data warehousing concepts and developing custom solution to client specific BW systems.
• Extensively involved in data extraction from R/3 function modules (SD, MM, PP, FI/CO,HR and General Ledger) and other legacy systems.
• Extensive knowledge of report design, query design, report construction, testing and performance tuning.
• Involved with end - users and team leads to gather their requirements.
• Involved in training end-users and project team members. Documented business process.
• Exceptional organizational, analytical, problem solving, debugging and communication skills.

TECHNICAL SKILLS:

ERP: SAP HANA S4, SAP IBP 6.0, SAP BW 7.0/3.0, SAP ECC 6.0, SAP R/3 4.6c/4.0b

Reporting tools: SAP Report Painter/ Writer, Oracle Reports, Crystal Reports, Lotus Reports

Databases: Oracle, SQL Server, Access, DB2, Sybase, Microsoft SQL server 2000

Data Migration tools: LEI, Notes Pump, ODBC

Groupware: Domino, Lotus Notes R6/5

GUI: Developer 2000, Power Builder 4.0, Visual Basic, .Net, ASP.NET, Visual Studio

Operating Systems: Windows XP/NT 4.0/2000/98/95/3.1, AIX, Unix

Language: JavaScript, Java, Lotus Script, HTML, C, COBOL, DHTML, XML, CSS

PROFESSIONAL EXPERIENCE:

SAP IBP Implementation Consultant

Confidential

Responsibilities:

• Review of existing Supply Chain to understand process for improvements.
• Conducting the business review meetings with Supply, Inventory, Operations and Sales business Leads.
• Preparation of functional document for the implementation of SAP IBP.
• Providing the Planning reports for DC view to track key figures like Safety Stock, Inventory target and Projected Stock.
• Provided the planning views for Cost input and Cost constraints delivered to see what If scenarios.
• Final optimized output view for the Safety stock at different locations with max dollar savings.
• Draft document for IBP configuration and specification deliverables.
• Providing the architecture document for SAP IBP implementation.
• Manage a team of highly experienced Supply Chain Business Analysts for supporting Strategic functions
• Work with cross-functional teams (Agile, IT, PMO) to drive successful deployments
• Submitted final approval document for the KPIs and What If scenario reports.
• Deliver large scale, high-value projects within an established delivery methodology

Environment: SAP IBP 6.x, SAP HANA S4 and SAP BI.

Sr. SAP IBP Implementation Consultant

Confidential

Responsibilities:

• System Architecture lead and responsible for landscape design
• Modeling Supply Optimizer based on the business requirements such as Minimum capacity usage of production resource, Inventory using fare share, safety stock penalty, Minimum Aggregated Production, etc. using associated cost rates for cost minimization
• Modeled Sub-Network for international demand scenario
• Design automated solution to update source validity dates based on the quotas generated by optimizer
• Created custom Attributes, Master Data and Key Figure to support business process and reporting requirements
• Security role setup with the various restrictions using visibility filter
• Lead Production cut-over activities

Environment: SAP IBP 6.0, SAP HANA S4 and SAP BW .

Confidential, Arizona, USA

SAP HANA Sr. SAP Business Analyst Lead

Responsibilities:

• Review of SOW and documentation of functional specifications.
• Facilitation of functional and technical team meetings for the better understanding of the requirements.
• Development of detailed functional specifications based on the legacy reports.
• Identifying the requirement gaps and review the gaps with business leads.
• Maintaining the project plan, resource plan, project schedule and deliverables.
• Coordination of efforts between the SAP functional, technical teams and BI teams.
• Stake holder updates on the time line and preparation of test plans.
• Documentation of technical specification and data flow.
• Involved in monitoring the status of Webi Report development based on the BO universes.
• User training documentation and walk through of final deliverables.

Environment: SAP HANA V1.0(SP08), SAP BO XI 4.0 and ECC 6.0

Confidential, CA

SAP BI Supply Chain Functional Lead - SAP HANA, BI

Responsibilities:

• Initiated supply and inventory management report project. Key role in Blueprint phase.
• Lead the requirement gathering session to understand the real time scenarios and issues.
• Conducted analysis sessions with different BU’s like Home appliances, AV products, computers and Home equipment to learn their legacy inventory systems.
• Provided detailed functional requirements, business test cases and expected result documents.
• Conducted sessions with technical teams to convert the functional spec into technical requirements.
• Agreed with business leads and sign off process to develop the final reports.
• Business user training and completion of hand over process with documentation.

Environment: SAP HANA, Business Objects, ECC 6.0, MM, PP and WM

Confidential, NJ

SAP Functional / Technical Lead - Supply Chain Management- BW

Responsibilities:

• Initiated supply chain project in Confidential as part of PRISM (SAP) Phase II implementation.
• Identified the business side functional managers and key users.
• Initiated and identified the scope of the project. Agreed with scope of the project and Sign off.
• Conducted GAP analysis sessions to identify the gaps between Global template & North America requirements.
• Produced GAP analysis summaries and presentations to the Snack, Pet and Food functional managers.
• Produced High level phase by phase approach and presented to the Project sponsors.
• Heavily interacted with Core team to learn and keep SCM BW project in the same page with the whole big PRISM implementation.
• Managed technical team to complete the development. Maintained & monitored project plan to run the project on schedule.
• Monitored and controlled the budget to restrict the project cost.

Environment: SAP BW 3.0/3.5, ECC R3 4.6c, Business Objects and Oracle.

Confidential, NJ

SAP BW Technical Manager.

Responsibilities:

• Conducted extensive requirement gathering workshops with the end users in the areas HR.
• Extensive analysis of requirements to identify the data resources.
• Final blue prints developed using the data resources.
• Complete knowledge of SAP Report painter and SAP BW architecture.
• Analysis of current crystal reports to define the existing requirements.
• Installed business content from the Personal Administration module.
• Installed and activated Infocube 0PA C01 and customized.
• Loading strategies of all the employee data from different countries.
• We have used the data sources like Ethnic Area, Payroll area, Education area and other.
• Involved in entire lifecycle of the project.
• Conducted extensive requirement gathering workshops with the end users in the areas of Sales and distribution, Inventory and FI/CO.
• Designed custom info provider for Delivery analysis and to load large volume of data from SAP R/3 4.6C Source systems.
• Installed and activated standard Inventory cube 0IC C03 and developed transfer rules and updated rules.
• Designed ODS object for MRP and loaded data.
• Developed a multi cube on sales and delivery basic cubes to facilitate reporting on sales and delivery together.
• Designed loading strategies for master data, initial load of transactional data and delta loading of both master data and transactional data.
• Defined strategy to set up the historical data to load into BW and improved performance by running parallel setups.
• Designed process chains for master data loading, delta loading and for weekly PSA deletion.
• Developed Transfer rules, update rules and Start routines to in corporate Business logic for data manipulation.

Confidential, NJ

SAP BW Techno-functional Consultant.

Responsibilities:

• Conducted extensive requirement gathering workshops with the users in the areas of APO, Sales and distribution, FI/CO, and Inventory.
• Designed custom info provider for sales analysis and to feed the info provider from SAP R/3 3.1H and 4.6C Source systems.
• Designed custom ODS for sales order line items relevant to demand planning in APO.
• Designed custom ODS for subcontract PO items relevant to demand planning in APO.
• Developed custom data source, Info source and extractor for Subcontract PO.
• Designed custom info provider for Delivery analysis and to feed the info provider from SAP R/3 3.H and 4.6C Source systems.
• Designed custom info cube and ODS for vendor invoice and payments.
• Enhanced master data sources 0costcenter, 0wbs elemnt, 0project, etc extensively and developed the user exit code to populate the data.
• Developed a multi cube on sales and delivery basic cubes to facilitate reporting on sales and delivery together.
• Worked with APO and created data sources for the cubes to feed the data to the APO cubes, through data mart technique.
• Designed data loading strategies into APO from BW.
• Designed loading strategies for master data, initial load of transactional data and delta loading of both master data and transactional data.
• Developed ABAP routines at Info package level for data manipulation and restriction.
• Defined strategy to set up the historical data to load into BW and improved performance by running parallel setups.
• Designed process chains for master data loading, delta loading and for weekly PSA deletion.
• Developed Transfer rules, update rules and Start routines to in corporate Business logic for data manipulation.
• Involved in production support, handling production problems.

Confidential, NJ

SAP BW Techno-functional Consultant

Responsibilities:

• Extensively conducted requirement gathering workshops by giving overview of BW architecture, data modeling, Info cubes, ODS objects and reporting functionality. Extensively collected requirements in application areas of SD, MM, FI, APO and PS.
• Designed ODS objects for Forecasting, vendor/material source list, sales order line items and purchase order line items relevant for APO Demand planning.
• Designed loading strategies from SAP R/3 to BW and from BW to APO.
• Designed custom info sources, data sources and extract programs for APO related ODS objects.
• Designed custom sales order info cube and designed loading scenarios for full load and delta loading.
• Designed custom purchase order info cube and designed loading scenarios for full load and delta loading.
• Extensively involved in modifying master data and transactional data sources and coded user exits to populate data into custom added fields.
• Developed Transfer rules, update rules and Start routines to in corporate Business logic for data manipulation.
• Extensively worked on setting up of historical data in SAP R/3 and involved in extraction and loading into data targets in BW.
• Extensively designed delta loading strategies and designed info package groups and scheduled info package groups in batch jobs.
• Extensively involved in resolving performance problems in BW while ETL process and in Reporting.
• Developed archiving objects for info providers and designed archiving strategies and reloading procedures, when required.
• Extensively worked on BW Reporting, authorizations and Web reporting using ITS.

Confidential, AL

SAP BW Consultant, SAP R/3 4.6C

Responsibilities:

• Technical involvement in areas including BW, MM, SD, PP, and IM
• Gathered BW related data according to end-user requirements in the areas of FI/CO, SD, MM/PP modules
• Produced detailed Gap Analysis for BW
• Heavily involved in CO-PA, LO, LIS and Generic data extraction mechanisms.
• Involved in the Data Modeling. Defined dimensions and developed a worksheet for Fact Table details in the BW Extended Star Schema
• Analyzed, designed and created several extract structures, Info Sources in Logistics. Utilized existing Purchase and Sales details extract structures for Logistics
• Created ABAP routines in Update rules. Used custom exits in creation of Variables
• Used debugging process for verification of extraction process
• Assisted in performance tuning for loading data and improving the query response times using aggregates, Info Cube partitioning and indexing.
• Worked extensively with User exits for Master and Transaction data
• Activated and implemented Sales cubes (0SD C01, 0SD C02, 0SD C03, 0SD C05) from Business Content
• Enhanced Master Data Sources for 0MATERIALand 0CUSTOMER.
• Monthly & Weekly extractions are scheduled using Info Packages on Sunday nights & End of month by using after jobs & after events.
• Extensively used BEX Analyzer to build queries implementing maps, charts and worksheets to access data from BW data targets

Confidential, IL

SAP ABAP/4 Consultant

Responsibilities:

• Involved in the developing of specific reports required in the areas of MM,SD and FI/CO modules
• Involved in active interaction with the functional consultants, tailoring and developing the applications as required by the end users
• Developed both classical and interactive reports for freights, stock valuation ledger report for plants, stockyard location and external processing agents and generated reports for purchase order listing
• Involved in the data migration from legacy system to SAP R/3 system. Developed Beds for transfer of Master to SAP using session method and call transaction methods
• Extensively used of Business Object Repository and BAPIs for integrating SAP R/3 in non-R3 external system.
• Receiver determination, Data selection, Segment filtering, Field conversion, Dispatch control
• Error Handling in Outbound and Inbound processing, setting up communication system and monitoring Idec processing and RFC communication
• Transport of customizing data from maintenance systems to receiving systems

Confidential, NJ

Project Leader, System Architect/Analyst

Responsibilities:

• Modified custom SQR reports. Developed SQR Programs from scratch to meet the business requirements.
• Developed Record Definitions, Pages, Components, ad-hoc SQRs & ad-hoc queries, Inbound and Outbound interfaces. Developed Run Control Pages as per corporate requirements and attached to menu to run the SQRs online.
• Involved in online changes like adding customized translate values, modifying People Code, adding fields to pages and modifying Components and menus.
• Developed SQRs and Application Engine programs to upload and for the validation of data from legacy system to PeopleSoft system.
• Developed Public and Pvt Queries using query tool. Worked along with Administration team to apply PeopleSoft Patches and bundles for HR / Payroll. Debugged and Fixed bugs after applying bundles. Customized rules.
• Developed conversion SQRs to transfer existing HR, Benefits and Payroll data from legacy system to PeopleSoft application database tables.
• Developed Technical specifications and working with client team in knowledge transfer.
• Worked along with Technical team in creation of component interfaces and application engines to convert Job data, Project data from legacy system to PeopleSoft.
• Worked in shared Database environment.