SAP Sr. DATA Architect

Sai Yerram

201-***-**** *********@*****.*** https://www.linkedin.com/in/sai-yerram-3597037/

SAP Sr. DATA Architect

** ***** ** ** ********** and 18 years of SAP experience in SAP R/3 ABAP, BW, Business Objects, HANA, BO, BODS and SAP Industry solution IS-PS.

Thorough understanding of BW architecture including Design of custom info cubes, Data Store Objects, and data sources. Worked on end to end solutions for BW Reporting projects.

Worked on SCM, Labor, and Financial reporting using BW, BW on HANA and HANA as backend tools for SAP and non-SAP data source data.

Worked on different front end reporting Experience with various SAP Business Objects (BOBJ) tools (WEBI, Design Studio, dashboards) development lifecycle on either BW or SAP (Native) HANA from design through implementation and production support.

Worked in HANA for creating Calculation view, Analytical view, Attribute views and Store procedure.

Hands-on experience working with traditional SAP BW and SAP BW on HANA features, among others, standard and custom SAP BW Extractors, complex transformations, advanced DSOs, composite providers, exposing BW models as HANA views, mixed scenarios

Strong Exposure in developing, tuning and designing ETL solutions using Business Objects Data Services

Worked on BODS for extracting data from SAP and non-SAP systems and loaded data into new SAP system using AIO methodology.

Designed SAP Data Services (BODS) to load data from SAP BW to external systems.

Worked extensively on Data conversion projects using BODS tool for SAP IDOC and LSMW loading method.

Designed extensively on BEx, Process Chains, ETL (LO & LIS Cockpit), Delta Initialization, performance tuning, and transfer/update rules.

Strong Techno Functional Knowledge in various modules like FI, SCM, CO, CO-PA, Logistics, FI, FM, SPL, GM, BCS HR and MM.

Worked on User-Exit for enhancing the SAP standard functionality.

Worked as a Senior Techno-Functional Architect in SAP NetWeaver/BI with good understanding in SAP and Non-SAP data.

Designed TABLEAU reporting for Revenue recognition ASC606 new accounting standard.

Experience in design, development and management of Universe, Creating complex reports using Desktop Intelligence, Web Intelligence, Crystal reports and XCELSIUS.

SAP Work Experience

Verizon Communications, Irving, TX May 2012 to Present

BW/HANA/BODS Sr. Architect

Worked on Self-service Financial Reporting hub using BW, HANA and WEBI. Created different hierarchies and drill down reporting from summary to details.

Managed technical solution from end to end with the help of on-site and off-shore resources.

Designed SCM reporting on BW, HANA and IDT. The source of the SCM data is from SAP and non-SAP.

Migrated SAP labor reporting from BW on HANA to complete HANA and changed the reporting from BEX/WEBI to IDT/WEBI.

Worked on Alternatives Finance reporting using HANA and BW with hierarchies.

Worked as a subject matter expert from Reporting group for ECC and BW upgrade. Involved in BW/ECC upgrade as BW functional point of contact.

Worked with off-shore on all Reporting development and Architect for all Reporting needs. Responsible for delivering the Reports from end to end.

Designed Financial Hub Data Lake for flexible and self-service Finance reporting.

Designed different HANA views and store procedures in HANA.

Designed on SAP Data service mappings to load the data into SAP, the mappings involved extensive use of simple and complex transformations like Key Generator, SQL Query Transform, Table Comparison, Case, Validation, Merge, lookup etc in Data flows.

Created Data service mappings to load the SAP ERP and R/3 tables to Staging area then to new SAP system using LSWM and AIO methodology.

Used parsing, correction, standardization, duplicate matching for arranging information using Data Quality Management.

Executed complex jobs in Debug mode and traced out errors using Data service logs.

Used Information Steward for presenting error records and deleted records in the standard AIO Job.

Cleanse the data using Data service data quality transforms. Worked on different address cleansing transforms to clean the legacy address in the standard address format.

Designed Loading data from SAP BW and HANA to external system using SAP Data Services (BODS).

Commercial Metals Company, Dallas, TX April 2008 to May 2012

BI & BO Architect

Created Plant Maintenance, Inventory and Production Trends, Daily Production, Mills comparison dash boards using SAP Visual Composer tool.

Experience in creating data models in BW, BW-BEX queries, Views, function modules for the dashboards.

Strong Techno Functional Knowledge in various modules like FI, SCM, CO, CO-PA, Logistics, include in PP, PM, QM, PTP and Inventory modules.

Configured multiple navigation points from source WEBI report to target WEBI reports dynamically.

Extensively worked on Finance and Sales BW reports using WEBI Interactive analysis, dashboard designer

Configured and installed SAP Business Objects Data Services and Job Server on client systems.

Worked on ETL design and implementations involving the Data extraction from a variety of legacy system, integration, and cleansing of data using BODS tool.

Extracted data from SAP and non-SAP and loaded data into SAP BW using SAP Data Service.

Loaded data into SAP BW using DB connect from external database.

Extracted data from different sources using BODS and stored in SQL server for reporting.

Created Trend reports using BO tools Data federator, Universe, WEBI and BI Launch pad using SAP and non-SAP data sources.

Created an EDW layer for PM and PP modules in BI. The EDW layer helps BI team to reload the data from ECC into BI without any ECC down time.

Developed and maintained different dashboard reports in Production Planning and Inventory using Visual Composer tool.

Monitoring data loads on daily basis and fixing any load issues when needed.

Used ABAP coding to written Start, End routines and BEx-User exit and ECC-User exits.

Lasing with the functional team and power user for understanding report requirements. Prepared the functional and technical specification.

Developed the BI Reports for Sales Forecast, Forecast V/S Consumption, Forecast accuracy, Budget accuracy, Cumulative forecast accuracy & Forecast Variance

Architect and oversee the full life cycle development of SAP BW / BI solutions to meet business goals.

IBM Global Service ( IT Specialist) Mar 2006 to Feb 2008

Newell Rubbermaid

Worked in MM and SRM modules. Development of BW objects like Extractors, Enhancement of standard data sources, Operation Data sources, Info Sets, Info Cubes, Multi Cubes, Transfer routines, Update routines & Complex queries.

Defined BEx queries with BEx Analyzer using characteristic value variables, formula variables and text variables, processing type manual entry/default value, authorization, replacement path and customer exit, used exceptions, restricted key figures, calculated key figures and RRI.

Activated standard business contents in MM and SRM areas and enhanced based on requirements.

Developed generic data extractors (delta enabled) using Table Views for transaction data.

The development effort was largely based on functional specifications sent in by the client. Analysis functional specifications and client meetings, a detailed technical specification was created. And finally further developments were carried out based on technical specification.

Coded user exit for populating fields added to extractor as append structure

Prototyping and testing processes prior to design of solution. Configuration, documentation and unit testing of processes.

Responsible for timely & qualitative submission of all deliverables by all off shore team members.

Activated standard contents for BW statistics and proposed strategy for performance improvement using standard queries. Performance Enhancements and the remodeling on the Info Providers.

Analysis of data requirements & translation of these requirements into dimensional data models using star schema and extended star schema data modeling techniques.

Queens Library, New York June 1999 to Jan 2006

Sr. IT Developer

BW

Conceptual design and Data modeling for sap business warehouse development and implementation by conducting workshops/Interviews.

Created info providers info cubes, multi cubes,ODS objects, Characteristic, key figure and info objects.

Scheduled data loads, i.e. Data loads are set with different conditions.

Created a process chain to load data into different info providers, activating ODS objects, creating indexes, rollup aggregates, and custom programs.

Wrote ABAP code in transfer rules and start routine.

Schedule and performance monitor periodic data loads from SAP R/3 to BW.

Liaise with SAP Basis Technical Team regarding BW Transport requests.

Liaise with other teams for necessary update, patches, corrections, transports, application enhancements.

Used Reporting Agent for scheduling Reports, Evaluating exceptions, printing queries and pre-calculating web template.

Analyzed the requirements, performed a gap analysis with respect to the data model needs and available business content.

Improved the performance of the queries by rolling up the data into aggregates.

Developed Queries, Calculated key figures, Restricted-key figures, Structures in BEx Reporting.

Customization of web templates, Web reporting and web items using web application designer (WAD) and query designer.

Developed Extraction Structures and Communication Structures to transport the OLTP Information to the Business Warehouse.

Analyzing the SAP BIW Business Content required, activating the business content components.

ABAP

Developed custom ABAP reports (classic and interactive) for management as needed in all modules, and used ALV and ABAP objects techniques to write reports.

Created most of the new business forms with SAP script and Smart forms.

Assisted in migrating legacy data to R/3 using BDC, BAPI and LSMW.

Produced comprehensive test plan documents, created various CATT programs and used Mercury Interactive third party tool for testing applications.

Researching OSS notes for application problems and fixing problems by communication with SAP.

EDUCATIONAL QUALIFICATIONS

Master’s in Business Administration (MBA)

CERTIFICATION

Solution Consultant SAP Net Weaver 2004s – Business Intelligence

Solution Consultant Financials – Strategic Enterprise Management – CPM & BPS (SEM3.5)

SAP Certified Application Associate - SAP HANA 1.0

Contact this candidate