Summary
Overview
Work History
Education
Skills
Websites
Certification
Honors Awards
Timeline
Generic

Yegammai Solaiyappan

North York,Canada

Summary

Highly motivated and goal-oriented SAP BW/BI/SAC Consultant with over 8 years of experience. Expertise in development, full-cycle implementations, data modeling, and insightful reporting. Specializes in designing advanced data solutions, integrating SAP BW, SAP Analytics Cloud, BW-ABAP, and Analysis for Office to meet and exceed business requirements. In addition, delivered comprehensive SAP BI training, demonstrating technical expertise and instructional abilities. Experience with SOX Audit (Sarbanes-Oxley Audit) from the application side.

Overview

9
9
years of professional experience
1
1
Certification

Work History

SAP BW/BI/SAC Consultant

Cognizant
02.2015 - 11.2019

BW 7.5 on HANA:

  • End-to-end implementations of BW including Requirement gathering, Data modeling, Data extraction, and Reporting involving Generic and Business Content Extractors
  • Possesses extensive knowledge of SD and Inventory modules, and has used the LO cockpit extensively
  • Generic datasource creation based on function module using Open Cursor in ABAP
  • Engaged in writing ABAP routines at the transformation level, including start, end, and expert routines
  • Possess strong ABAP reading and debugging capabilities in BW routines
  • Model BW objects such as Composite Provider, ADSO, open ODS views, and infoobject in HANA studio
  • Oversaw and supervised multiple data loads, engaged in performance optimization, and addressed data inconsistencies between BW and ECC
  • Robust knowledge of design and development of BW queries using eclipse-based BW Query designer in HANA studio
  • Expertise in customer exit variables using CMOD - Enhancement RSR00001 and BAdi RSROA_VARIABLE_EXIT
  • Proficiency in creating and managing Analysis for Office (AO) reports
  • Design and development of Attribute view, Analytic view and Calculation view, Variables, and Input Parameters on HANA studio
  • Experience working with ODP-enabled data sources, understanding delta merge, indexing, partitioning, streaming process chains, and semantic groups within BW4HANA

SAP Archiving:

  • Experience in Data Archiving using standard archive objects in ADK with SARA, Archiving Infostructure, and TAANA analysis

SAP Analytics Cloud planning:

  • Worked with SAC Data Analyzer on BW
  • Develop SAC analytic models, and data wrangling in data models
  • Created compelling stories with impactful narratives
  • Built intuitive planning models, forecasting data, OpEx planning, CapEx planning, cash flow waterfall charts and headcount reports
  • Expertise with planning operations such as allocations, version management, configuring data actions, multi actions, and workflows in the calendar
  • Designing value driver trees, creating formulas, template creation, variance analysis, thresholds and scheduling tasks
  • Data governance in SAP Analytics Cloud

Application Developer

IBM
05.2011 - 02.2015

SAP BW 7.3 and higher:

  • Design and Development of Info object, DSO, Infocube, Aggregates, SPOs, Multiprovider, Infoset, Real-time Data Acquisition and Open Hub Destination
  • End-to-end implementation of APD as per user requirements
  • Greenfield project implementation involving Generic Datasource creation and corresponding BW flow creation from scratch
  • Enhancing LO datasource and using CMOD - RSAPR001 to populate data
  • Experience in Flatfile datasources
  • Design and development of BEx queries, Report-Report Interface, Calculated Key figure, Restricted Key figure, Cell definition, Condition and Exception
  • Creating process chains, monitoring data loads, and resolving critical issues to ensure timely data availability for users
  • Expertise in addressing data discrepancies between ECC and BW by conducting comprehensive data analysis, utilizing BW routines, and examining ECC base tables for SD and MM flows
  • Engaged in performance-tuning activities such as compression, indexing, and partitioning

SAP Training:

  • Provided SAP BI training to graduate hires as a BI instructor at IBM

Auditing:

  • Involved in the Sarbanes-Oxley (SOX) audit from the application side

Education

Bachelor of Engineering - BE - Electrical and Electronics Engineering

Government College of Engineering, Bargur
04.2010

Skills

  • SAP BW On HANA
  • BW-ABAP
  • SAP Analytics Cloud planning
  • Analysis for Office (AO)
  • SAP Archiving
  • SAP Trainer
  • Auditing

Certification

  • SAP Process Methods and Tools Basics
  • SAP Certified Technology Associate - SAP Solution Manager (Implementation) 7.1 SP 8

Honors Awards

  • Client Appreciation - BP Accolade
  • Supernova of Sanofi

Timeline

SAP BW/BI/SAC Consultant

Cognizant
02.2015 - 11.2019

Application Developer

IBM
05.2011 - 02.2015

Bachelor of Engineering - BE - Electrical and Electronics Engineering

Government College of Engineering, Bargur
Yegammai Solaiyappan