KOTI KUNREDDY

Sr. Data Science & Analytics Consultant

SAPBI/ HANA Certified Professional

CAREER SUMMARY:

** ***** ** ********** ** SAP BW as a Techno-Functional Consultant with expertise in SD, MM, PP, SM, FI/CO, HR and CRM Modules and 4 years in SAP BI Integrated Planning

6 years as SAP BI/HANA Architect with Multiple implementations.

Around 5 years of experience as SAP HANA Enterprise Development including HANA 2.0 XSA.

Worked on multiple projects with end to end solution including Business Requirements, Data Modeling, Data Architecture, Application Design, Infrastructure Planning, Project Management, proof of concept, ETL Design, Reporting Architecture, Development and maintenance

Extensive experience in SAP BW on HANA, SAP BW 7.5/7.3/7.2/7.0//3.5/3.1/3.0B/2.1C configuration, OLTP Extraction and Reporting.

Experience with SAP HANA for Data Replication (SLT), Data Modeling, Data Provisioning and Administration. Worked on HANA Data modeling using Dimension and Calculation View.

Expertise in Designing and Scheduling ETL jobs using SAP BODS (Data Services).

Expertise with SAP Business Objects Analysis, edition for Microsoft Office

Experience on Universes, BI Launch pad, Live Office, WebI and BO Dashboards using Business Object 4.0 platform.

Worked on Tableau and Power BI to connect with HANA Views to create dashboard Reports.

Expertise in BW Components like Info Objects, InfoSources, Update rules, Transfer rules, Info Cubes, Composite Providers, DSO, PSA, DTPs, transformations, Open Hub, Queries, Calculated key figures, restricted key figures, variables etc.

Worked extensively on CRM, CO-PA, FI, LO Cockpit, HR and Generic data Extractions.

Worked on Real Time Cubes, Aggregation Levels, Planning functions, Planning Sequences, Planning Filters, Data Slice, Char. Relationships and input queries using Integrated Planning.

Expertise in designing SAP BW interface requirements with both SAP and Non-SAP source systems.

Worked extensively on performance tuning, BW Statistics, Indexes, Data Marts, process chains, Error handling in subsequent processing, Business content installation, data cleansing in PSA, Error handling is using PSA, Multi-Cubes, Query development, RRI and Documentation.

Worked on reports using BEx Browser, BEx Analyzer, VBA and Web Application Designer

Created and enhanced Data Sources using database views, InfoSets, and function modules. Hands on ABAP coding on extractions.

Experienced in ABAP programming techniques including Reporting, Dialog Programming, BDC, ALE, IDoc, LSMW, SAP Script, BAdIs and user exits

Excellent technical, business, communication and time management skills

SKILLS:

ERP ERP

SAP ECC 6.0, SAP R/3 4.7/4.6C/4.5B/4.0B,

SAP CRM 7.0/5.0

Data Warehouse

SAP HANA 2.0/1.x, SAP BI 7.x/3.5/3.1C/2.1C, Informatica 9.1/8.6, BO Data Services 4.0

Reporting Tools

BOBJ Tools, SAP Analytics Cloud (SAC), SAP BEx, Tableau, Power BI, Cognos, Fusion Ops

Languages

SQL Script, Node JS, ABAP, C, C++, Java and VB

Tools

Ms- Office, MS Project, HP ALM

Databases

HANA DB, SQL Server, Oracle, DB2

Web Skills

HTML5, SAP UI5, HTML, ASP, Java Script and VB Script

PROFESSIONAL EXPERIENCE:

ExxonMobil, TX June14 – Present

Sr. SAP HANA/BI-IP Consultant

Designed and developed MDC containers in HANA 2.0 XSA and developed HANA analytics views for Celonis system using Web IDE.

Developed SLT pipes to get data from SAP into HANA system. Developed global templates and built SLT filters and decimal shift logic to improve currency conversion performance.

Designed and developed SAC Analytics Dashboards for Production volumes data from Energy Components (EC) data for Upstream Project

Developed ETL data flow using SSIS from oracle system into MS SQL Server.

Developed SDA connection from SQL server to SAP HANA 2.0 XSA.

Developed all the master data flow from SAP into HANA system and combined it with production volumes data from SQL server.

Worked on Chemicals Data flex automation to improve the Finance month end close process.

Build Predictive Order Inflow Dashboards using Tableau for Supply chain Planners.

Helped Business to improve reporting performance using HANA Hybrid models (Using Native HANA models and BW objects).

Participated in daily scrum calls using agile methodology. Used TFS for PBIs and daily tasks

Worked on GitHub, Jenkins to Build, deploy, and run CI/CD to manage code.

Led the requirement gathering with the Business Users on Product Costing and Margin Analysis Simulation areas for Chemicals business.

Developed all reports using Composite Providers in HANA Studio in SAP BW on HANA.

Worked on Data validations for BW on HANA Data Migration

Created Real time Cubes, Aggregation Levels, Planning functions, Planning Sequences, Planning Filters, Data Slices and Characteristic Relationships using Integrated Planning.

Designed and developed BO Analysis Workbooks for Product Costing Unit price Simulation, Variable Margin and Allocation Non-Prime products to Prime products.

Developed Product Costing Portal Dashboard using SAP BO Design Studio 1.4. Enabled Comments in design studio using planning application.

Developed Native HANA Calculation Views to expose the Planning data to Third Party Reporting tool (Tableau Dashboards).

Designed and developed Supply Curve Dashboard to Margins for Customer and Product segments using Data Mining Tools. Created linear Regression Models to predict cost based demand volumes using Analysis Process Designer.

Helped Security team to build IT and End user roles for Simulation Scenarios.

Involved in Functional Unit, Integration and User acceptance testing during Cutover.

Columbia Sportswear, OR Oct’13 – May 14

Sr. BI Consultant

Led the requirement analysis with the Business Users on how the reporting is currently used and how the report models are driven for Life of an order stream.

Developed Functional and Report Specifications Sales Contracts, Account Services Order book, Allocation Analytics and Direct Ship Reports.

Responsible for Modeling and deployment of Fusion Ops Reports in Life of Order space.

Designed models for Sales, Shipments, Allocation and Direct ship Analytics.

Led the Performance testing for corporate Reporting and Analytics Team including the tools SAP BW, Fusion Ops and Cognos (Teradata) Reports.

Involved in Functional Unit, Integration and User acceptance testing during Cutover.

Grainger, IL July 13 – Sep’13

Sr. BI/HANA Architect

Worked on Business Blueprinting, Realization phase of SAP BI for Americas SAP Project at Grainger for Canada and Mexico.

Conducted workshops with business to gather the reporting requirements in Sales, Purchasing, Vistex (Vendor Rebates, Customer Rebates, chargebacks and Commissions), CRM (Activities, Opportunities, Territory Management, and Service management), and Service Parts Planning (SCM-SPP), Global Trade Service (GTS) modules.

Developed Naming standards and design guidelines to the new HANA landscape.

Enabled the standard business content and identified the GAPs in standard Business content.

Prepared Architecture diagrams and dataflow, system landscapes in Visio documents.

Designed and developed data models in BW 7.3 on HANA to support report requirements

Demo the business with reporting capabilities using BOBJ 4.1 Toolset.

Nike, OR Sep’ 06 – June 13

SAP BI Architect/COE Feb ‘11 – June 13

Worked as cross functional Architect and COE for Several projects at Nike including

SAP Retail BI and HR re-New, NFL, Africa distributors, upgrades and several POCs

Worked on GLAPPO project to integrate Account Payable, General ledger and purchasing data.

Worked on SAP BI SLO tool (Systems Landscape Optimizer) which is primarily used for Archiving, Realigning and Conversions of data in various BI Objects with a minimum downtime.

HANA POC

Involved in HANA and BOBJ 4.0 Proof of concept for Finance with SAP America at Nike

Helped business to create BO Analysis and WeBI, BO Launch Pad, Live Office Reports.

Working on Architecture drive to simplify and consolidate the BI Landscape.

Retail Project

Involved in End to end solution for Retail BI project which includes Inventory, Purchasing and

POS sales and Merchandise and Assortment Planning module

Worked on design sessions and proposed design options for building data warehouse objects.

Involved in creating Governances, programming standards, development standards for BI objects

Involved in design approvals and development reviews for all BI development objects including

Integrated Planning.

Developed Planning Function to calculate End of Period, Begin of period values in Merchandise, Location,Top line Location Planning Inventory Templates

Developed characteristic Relationship class to derive Season, Season Year from Fiscal month.

Developed various Customer exit variables related to 0FISCPER, 0FISCYEAR,0FISCPER3

Created Aggregation Levels, Planning Filters, Planning functions, Planning Sequences, Characteristic Relationships using Integrated Planning.

Developed BO Analysis Workbooks for Merchandise and location planning.

Developed Daily sales summary WebI Reports and broadcasted to users.

Worked and resolved on several ongoing issues during Project go-live.

HR re-New Project

Involved in design sessions for HR project which includes OM, PA, Payroll and compensation.

Proposed SAP standard extractors to extract the data from ECC to BI solution.

Performed Gap Analysis to determine SAP Delivered Extractors and Custom Extractors

Designed and reviewed Standard Master Data/Transaction Data/ Custom Extractors for OM/PA

and Compensation Modules

Worked with Security team to design HR security for BI back end data objects

Sr. Business Systems Analyst June 09 – Dec’ 10

Involved in EBI BAP-BW divesture Project to represent OFS Reporting Team.

Worked on moving all Front end Objects like Queries, Query Views, Web Templates, Jump queries, Broadcaster Settings from BAP to BIP system.

Resolved several ongoing issues in Operational Reporting for Order Management. Modified Virtual BAdI logic and created InfoSets under MultiProviders to build Operational Reports.

Implemented BW Accelerator for DIFOT Schedule line Reports

Worked Coverage Project to send the BWA query output data to external systems using Analysis Process Designer (APD) tool.

Worked with SAP Support on several on going issues with BEx 3.5 broadcaster

Worked on Analysis, design and implementation of Coverage Reports in BIP system and Divested the Legacy Systems.

Worked on Cognos POC to connect Cognos to BI/BWA queries to create dashboard Reports

Involved in upgrading BEx 3.5 to 7.0

Techno Functional Consultant June 07 – May 09

Responsible for Asia Pacific region Tier III Project at Nike GBI.

Job includes requirement gathering, meetings with business users, issue resolution, preparing functional specifications, interaction with Architecture and development team

Defined Statement of work, functional specifications and level of effort for Tier III Projects.

Designed and developed Sales Gross futures logic (Freeze Process) and Pre-Freeze logic for Asia Pacific Sales

Worked on several on going issues in Sales, Order Management, Finance and Planning functional areas.

Worked on FI-AR, FI-AP and FI-GL Line Item InfoCubes and InfoSources for loading the data from SAP R/3.

Worked on Information Broadcasting to email OM Operational Scorecard Workbooks to OM/DL top level Management on weekly basis.

Involved in Content Engineering Governance process and participated in Content Reviews(Front-End development work) as part of Content COE Team

Extensively worked on reporting using BEx Analyzer. Created calculated and restricted key figures, variables, exceptions, conditions, jump queries and customer exit variables to meet client requirements.

Worked on Open Hub to extract Sales/billing data to external systems using Info Spokes

Application Engineer Sep’ 06 – May 07

Involved in requirement gathering for the PSST Project as part of the Order Management.

Designed Functional and Technical Specifications.

Enhanced Sales Order schedule line and delivery item extractors and created generic extractors to get Partner functions data

Modified the Application-Specific and Generic Data Extractors in CO/PA, FI-GL and cross-application generic extractors.

Designed and implemented all the required Info Objects, Data store Objects, Transactional ODS, Transformations, Start routines, DTP’s etc in the B3 architecture using BI 2004s features.

Worked on Demand Planning Sales Orders Project to improve query performance.

Created Indexes on Master data tables, repartitioned the InfoCubes using 04s Repartitioning Tool.

Involved in Unit, Integration and User acceptance testing during Cutover.

Cardinal Health, CA Apr’ 06 – Aug’ 06

BW Consultant

Designed and Developed MII data Extractors and InfoCubes to integrate with CRM SFA data.

Enhanced the Installed base and Activity data extractors and InfoCubes.

Worked on Sales Track Project to extract data to external server using Open Hub (InfoSpokes).

Responsible for Break fixes, Analysis and Enhancements for CRM SFA (Opportunity Management, Activity Management, Installed Base, Customer Partners and MII third Party data), Sales & Distribution and Service Management Modules.

Documented Overall System Architectural flow diagrams and maintenance user guide.

Worked on Global Supply Chain Project to identify impact on Existing BW System.

Involved in Integration and Regression Testing and prepared the documents and executed.

Developed Workbooks, Web Templates, and Dashboards as per user requirements.

Participated the Prototype Project for NetWeaver 2004s implementation

Automatic Data Processing (ADP), CA Feb’ 06 – Mar’ 06

BW Consultant

Developed the technical specifications for the Cash Balance and Cash Flow data.

Designed and implemented the Cash Balance Cube

Implemented Start routines and update rules

Implemented Business Partner Master Data extraction to extract insurance related data from R/3.

Designed separate history Cubes to load Historical data and MultiProviders on top to show current and history data

The Scotts Miracle-Gro Company, OH June 05 – Dec’ 05

Lead BW Consultant

Responsible for deliverables in all phases - Project Planning, Business Blueprint, Realization, go live and Post-Go live phases of the Lifecycle.

Sole output person responsible for making implementation design decisions.

Job included design, user approval, designation of duties, and configuration.

Performed data sizing of all infocubes and provided estimation to Project Management.

Used ODS to store transaction data before loading it to the infocubes. Developed MultiCubes across basic cubes to provide consolidated query view on Actual and Forecasting data.

Identified required standard business content objects for CRM Service, installed and activated the same. Enhanced some of the data sources with append field structure and populated additional data in CRM Service.

Implemented Opportunities, Service Contracts, Service Orders and Billing documents.

Created queries on all the InfoCubes as per user requirements.

Designed complex reports using variables (custom, hierarchy and text), formulas, calculated key figures, restricted key figures and structures.

Customized the Web Printing with Excel Solution as per user’s requirement.

Developed customized web template for Scotts Lawn Service.

Published and organized all reports in Enterprise Portal.

Responsible for the SAP OSS management and Transports.

Forest Labs, NY Nov’04 – May 05

BW Consultant

Responsibilities included requirement gathering from functional experts and designing data models, DataSources for BW 3.5 implementation.

Identified required standard business content objects, installed and activated the same. Enhanced some of the data sources with append field structure and populated additional data in customer-function.

Worked on Data Modeling for custom Info cubes for IMS Alignment data to Integrate with Call Activity, which is coming from SAP CRM.

Extracted Business Partner, Health Care professional, Organizations and Sales Representatives Master data from CRM using flexible master data update.

Designed custom ODS Objects for Business Partner Affiliations, Addresses, License and Extracted data from CRM using Views/tables and InfoSet Query.

Designed ODS Objects to store transaction data for Early View, Xponent and IC Org Sales before loading it to the InfoCubes. Developed MultiCubes across basic cubes to provide consolidated query view on IMS Prescriber Monthly and weekly aligned data.

Coordinated with Informatica team to load the IMS data from legacy systems. Designed the interfaces to map external data from Informatica to SAP BW using Informatica Power Connect.

Extracted data from BW InfoProviders using InfoSpokes with Open Hub Functionality to external systems through flat files and separate DB tables.

Extracted Sales Territory, Customer deciles and POA data into SAP CRM systems using Analysis Process Designer tool.

Responsible for the SAP OSS management and Transports to coordinate with Basis team.

GE ERC, KS June 03 – Sep’04

BW Consultant

Designed InfoCubes, ODS Objects, DataSources, InfoSources, and update rules for all non-R/3 data being loaded through DB connect for the Claims Data Warehouse.

Developed technical specifications and involved in reviewing the specifications and made necessary changes.

Used ODS to store transaction data before loading it to the InfoCubes. Developed MultiCube across basic cubes to provide consolidated query view in Claims header and transaction data.

Developed strategies for Master data loading and created generic data sources for Global Mappings in Master data, which feeds data from middleware.

Wrote transfer routine, transfer rules, update routine and update rules to populate the fields in each cube. Used master data tables in update rules to check desired control data.

Handled complex currency requirements that varied by each InfoCube by using currency translation keys in the queries to show amounts in local currencies and as well as in US Dollars.

Creating, Scheduling and Monitoring InfoPackages and Job load Process with automation of standard loads after initial runs using Process chains. Handled error monitoring using Internal User Alerts and External Mail address Alerts.

Created aggregates to improve the query performance based on the DB statistics information.

Designed BEx queries based on SAP variables as well as custom variables involving application of User Exit routines.

Created web reports for various claims data using customized cascading style sheets, along with customer specifics images.

Created queries on InfoCubes, ODS Objects and MultiCube as per user requirements.

EDUCATION:

M.S. in Computer Science, Illinois Institute of Technology, Chicago

B.Tech in Mechanical Engineering, J.N.T.U College of Engg., India

Contact this candidate