The Enterprise Technology Platform

Top Project Highlights

FFC SKU Limited

FFC SKU Limited project will limit the SKUs list in Ecommerce DC by considering the limitation of space. Today Ulta Beauty have multiple FFC (Fast fulfilment centres) and this Solution is leveraged to all DC’s for better utilization of limited space by applying assortments like Fragrance, Aerosol and General.

This allows business to analyse and plan to decide which articles to be carried by a quarterly basis based on past sales and forecast for better utilization of DC’s.

Trade Promotion Evaluation

Trade Promo Eval is a solution to Nestle waters North America, Which Evaluates the Performance of the Promotions, by using the Trade Promotions data and Market Research data.

Employment

SAP HANA Technical Consultant

2007 - Present

- Involved in Requirement gathering to understand the current business scenarios for the e-commerce Fast Fulfilment centre SKUs Limited.
- Analyse and architect HANA staging and developed models using Scalar and Table functions.
- Analysed and Created KPI’s as per the outcome of brain storming from the business users.
- Enhanced data models to accommodate additional data without impacting existing reporting setup.
- Involved on NetWeaver 7.3/7.4 platform to deploy BI models by integrating other services.
- Worked on SAP NetWeaver Application server, perform analysis and embedded analytics in real time.
- Configured and Replicated the ECC Tables using SLT for retail time data and modelled the Calculation Views.
- Created Technical specs by analysing functional specs.
- Developed Info Providers using HANA Studio such as Advanced DSOs, Composite Providers, Open ODS Views.
- Export/Import of Models, Validating Information Models, Creating Schemas, Manage Schema Mapping, Performance Tuning.
- Developed SAP HANA Information Models using Calculated Views.
- Designed the data flow architecture for Master & Transaction data.
- Modelled Calculation views using Scalar functions to derive Week from and Week to from Current date input parameter.
- Upgraded BO from 4.2 SP2 to BO 4.2 SP7.
- Involved in BO 4.3 Beta testing and provided issues/suggestions to SAP.
- Created Tableau dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts etc. using show me functionality.
- Created complex Webi reports for the calculation of fiscal year, year to date, and month to date.
- Developed Row level and folder level security for BO universe objects.
- Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps and forecasted reports.
- Involved in SAP HANA Security Analytical Privileges.
- Created Test cases for data models.
- Conducted user trainings to help them understand the enhancements so that they can use self-service reporting views, Bex reports and AO.
- Developed new Reports as per the Business Requirements.
- Worked extensively on Data Model design in Supply chain.
- Coordinated with teams from cross functional areas to manage dependencies and continue to complete project with in the agreed time lines.
- Maintained detail document for all the changes and shared knowledge with support team for smooth transition.
- Provided training to the end users on reports for their business decision making.

Education

MBA

2003-2005

I am specialized in Marketing and systems streams, studied managerial aspects, ecommerce and information systems to build my carrer and explored the concepts to build my professional carrer.

Certification

SAP HANA 1.0

2014-2014

I have certified in SAP HANA 1.0

$85

Suresh Guttikonda

Industry Experience

Location Supported

Languages Supported

Skills

Product Specialization

About