Sameer Ailawadi Email & Phone Number

Santa Monica, Ca, Us

Fuschl, At

Fuschl, At

Mumbai, Maharashtra, In

1. Expert level experience in SAP BI-BW, HANA and Business Objects playing Lead and Architect roles.2. Key Projects in SAP BW on HANA- Buy Anywhere Fill Anywhere Implementation - Integration with IBM Sterling to capture Order Lifecycle Metrics. - Store Operations Dashboard Optimizations - Significant Performance Improvements for Lumira Dashboards and efficient Security design in HANA. - Supply Chain Analytics - focusing on DC performance KPIs , Omni-channel key metrics, Buy online pick up in store/Ship from store KPIs- Market Basket Analytics - Sales basket and promo analytics, association analysis, market basket reporting- Merch Analytics - Key Sales, Inventory, Fulfillment and forecast KPIs- Enterprise Security Project - Defining architecture with analysis authorizations and HANA roles with focus on self service model architecture.- HANA migration project (Migration with complete re-engineering of flows)i. Movement of functional areas with in traditional BW to BW on HANA box.ii. Migration from BW 7.0 to BW 7.4 on HANA.iii. Extensively using HANA views to re-architect entire flows and reducing the data foot print with efficient design.- Inventory In-Stock Reporting - Combined Inventory, Sales, Purchasing, Space Planning and Planogram data to provide key In stock reporting for business for replenishment planning including KPIs like Inventory/ATP/WEB out of stock counts.- Vendor Performance Reporting - Worked on high visibility Purchasing enhancement project to deliver a key Vendor Performance report to determine the efficiency of vendors so that rates can be negotiated with them.- Worked on HR Implementations for Personnel Administration data sources with complete modelling in BW for time dependent objects. - Worked on Inventory and Shrink reports including implementation for Store Cycle counts automation through BW. - Worked on Sales Reports based out of POSDM including POSDM extraction and enhancements.

1. Completed 3 end to end implementations on BW on Business objects for Pepsico for Saudi Region, Thailand and Jordan.2. Led the team from offshore and traveled to onsite for SIT/UAT and was able to get all the reports passed for Jordan Implementation.3. Extensive work on Business Objects including UDT, Webi (4.0) and BICS for final reporting including complex scenarios like multiple rankings/sorting, hyperlinks and customized layouts.4. Received client award for excellence in implementation projects.

Santa Clara, Ca, Us

1. Key Initiatives- Handling day-to-day monitoring activities in SAP-BI and ensuring successful data loads.- Involved in improving the process by taking initiates to improve the System performance, which involves Maintaining DB statistics, Analyzing the Utilization OLAP Statistics and taking the effective decisions to improve the query performance - Involved in BW Jobs Scheduling & Monitoring- Worked on many L3 and Support tickets including tickets on ABAP- Creating and execution of test cases for upgrades.

Pgdm, Marketing

Bachelor Of Engineering - Be, Electronics And Communications Engineering

Education record