Ruban Tamilselvan

• Implemented various Automated Solutions to Reverse Engineer and Document BW Data Models so as to replicate the same in Non SAP Cloud Data Warehousing Solutions
• Implemented SAP Consumable Data model for various Functional Areas to ingest Data from SAP S/4HANA and SAP ECC to Non SAP Cloud Solutions like ADF , Snowflake etc that also enables agility in gaining insights, optimizing operations, creating a single source of truth and enable advanced digital analytics roadmap
• Implemented Tools such as IOBJ Catalyst and ADSO Catalyst that will accelerate SAP BW/4HANA Modeling
• Reduced project timelines with effective management of cross-functional teams in the implementation of SAP solutions.
• Ensured data accuracy and integrity, conducting thorough testing of all implemented SAP solutions.
• Implemented process improvements, driving efficiency gains within client organizations using SAP tools.
• Leveraged expertise in multiple industry verticals to provide insightful recommendations on best practices for efficient use of deployed SAP systems.
• Led multiple data migration projects from SAP to Azure and Snowflake, managing timelines, resources, and deliverables.
• Achieved high levels of client satisfaction, consistently exceeding expectations in delivering tailored SAP solutions that meet specific business needs.

• Managed Offshore and Onshore team model
• Involved in the Architecture to analyze best use of Technology to replicate Data in HANA
• Reengineered existing Traditional BW Solutions and Transformed into HANA Solution that involves Calculation Views and Table Functions
• Worked in Agile and Waterfall Project Management approaches
• Deployed Hybrid solutions that combines HANA and BW modeling approaches for better performance and reporting
• Managed day to day interactions with executive clients and Gathered requirements from clients and stakeholders
• Investigated system issues and implemented resolutions to reduce downtime.
• Identified value opportunities to exploit product for maximum business effectiveness.
• Architected SAP solutions by prioritizing simplicity, appropriate scale, resiliency and maintainability.

• Extensively worked on Data design and BW/4 HANA Data modeling
• Involved in full life cycle implementation which includes Gap Analysis, Requirements gathering, Development, Testing, Reporting, Go-live and Post Go-live support
• Involved in data migration and conversion activities that include, extraction, transformation, migration, validation and reconciliation of data
• Worked on L1 Support Activities like Process chain Monitoring, Application Server Monitoring , SLT Monitoring , RFC Connections,User Creations , Role Creations, Data Load Failure Corrections etc.
• Worked on L2 Support Activities like Corrective actions needed for Data load Failures , Data Reconciliation between ECC and BW System , Handling Change requests , etc.
• Worked on various Ticketing Tools like JIRA , Smart Process and Service Now.
• Good Experience in Native HANA Calculation views, Virtual Tables etc
• Extensively worked on CSD Views
• Good Experience and knowledge in ODP Extractors and Modeling
• Designed and implemented SAP HANA data modeling using Attribute View, Analytic View, and Calculation View
• Worked extensively on SAP BW Data Modeling design like creating Info Objects, Info Cubes, DSO, Advanced DSO, Composite Provider, Multi Providers, Info Sources, Infoset, time dependent master data and also in ETL (Extraction, transformation and loading) activities like Extraction from Source system, Transformation rules, Data Transfer Process (DTP),Open Hub service etc.
• Wide Knowledge on ABAP & SQL in BW/4 HANA transformations
• Created Process Chains and Meta-Chains for periodic upload of Text data, Master data and Transactional data and Monitored data loads with full update and delta mechanisms
• Worked extensively on APD's and exporting BW Data as CSV files to the Application Server.
• Worked extensively on Reporting Environments like BEx Query Designer and BEx Analyzer to build queries and worksheets to access the data from BW data targets
• Worked Extensively on AFO
• Provisioned multiple OData services and provided to the front end to consume on UI5/Fiori
• Proficient in importing HANA models into BW system
• Involved in both SAP BW and SAP HANA Security including User Management and Roles/Privileges Management
• Involved in features of SAP BI security like Analysis authorization
• Involved in importing BW models from SAP BW HANA to HANA Studio
• Proficient in Hybrid data models using both native HANA and BW/4 HANA
• Proficient in SLT configuration and replication of tables by using various replication techniques
• Successfully worked on White Box Testing with many test cases
• Successfully created test scenarios and validated reports accuracy, Source to target mappings, calculations etc.

Project : Visy Industries

• Understood the business and gathered the requirements from the business and functional users
• Worked with project managers, developers, quality assurance and customers to resolve technical issues.
• Work with downstream application users to gather reporting/data requirements.
• Responsible for solving the production issues raised by the business users.
• Responsible for defining the BEx Queries used in BO environment.
• Created Queries in the Query Designer by using Attributes, Variables, Filters, Calculated key figures, Restricted key figures, different conditions and exceptions
• Worked on different kinds of Extractors like LO-Cockpit, CO-PA and Generic extractors in order to configure the data sources in BW Back end
• Created and activated Communication Structure, Transfer Structure, Transfer Routines, Update Rules (both ODS and Info Cube level). Built and loaded cubes and validated results
• Worked extensively on start routines, field routines and end routines
• Used Direct Update DSO in the process of APD (Analysis Process Designer).
• Gathered data on integration issues and vulnerabilities and reported all findings, including improvement recommendations.