Aritra Chandra
Kolkata
Summary
Highly skilled SAP BW HANA Consultant with 3 years of experience in designing, implementing, and optimizing SAP Business Warehouse (BW) and HANA solutions. Proven expertise in SAP Landscape Transformation (SLT), Data Services (BODS), and BusinessObjects reporting. Proficient in delivering end-to-end data warehousing and business intelligence solutions, leveraging HANA's advanced analytics capabilities. Strong understanding of data modeling, data governance, and data quality. Excellent problem-solving skills, with a track record of successfully resolving complex technical issues. Collaborative team player with excellent communication skills, able to work effectively with both technical and non-technical stakeholders.
Overview
3
3
years of professional experience
1
1
Certification
Work History
SAP BW HANA Consultant
Tata Consultancy Services
Kolkata
05.2021 - Current
- Have end to end working experience in BODS, HANA,SLT,BW,BO and SQL from requirement gathering to deployment.
- Have participated in two migration projects.
- Designed, developed, tested and implemented ETL processes to load data from source systems into SAP BW.
- Performed performance tuning of existing InfoCubes and DataStore Objects.
- Developed complex mappings, transformations, workflows and templates in SAP BW using various data sources.
- Analyzed business requirements and created functional specifications for SAP BW projects.
- Created database objects such as tables, views,calculation view,stored procedures and functions in SAP Hana.
- Designed, configured and tested complex SAP Hana models for enterprise applications.
- Provided technical support to troubleshoot issues related to SAP Hana systems.
- Utilized SQL scripting language to build complex queries for reporting purposes in the environment.
- Served as am Admin and functional expert handling dual responsibilities across HANA,BW,SLT,BO and BODS field.
- Ingest data from various source(SAP, Avaya, Netsuite etc) to Azure synapse analytics and also ingest data from SAP ISU ,CRM,S4 to HANA and blob.
- Data migration of finance objects from S/4HANA to S/4HANA,Worked as a BODS developer .Used BAPI, LSMW for loading purpose. For extraction ABAP dataflow used. Migrated: Customer Master DATA, Customer Open Items, GL Open Items.
- Creation of appropriate dataset for simulation of bills using HANA ,BW and BODS.
- Creating report based on generated dataset to help business identify generating insightful information.
- I contributed to a DS migration project that involved transitioning DS servers from Linux to Windows. In this role, I served as both a developer and administrator, successfully migrating all BODS jobs to the new server.
- I worked on an SLT brownfield-to-greenfield migration project, taking on both administrative and functional roles.
Education
B.Tech - Electronics And Communications Engineering
University of Engineering And Management
Jaipur04-2021
Skills
- Dashboard creation
- Data Warehousing
- Report Development
- Data Modeling
- Data Migration
- Performance Tuning
- SAP BW
- SAP HANA
- SAP BODS
- SAP BO
- SAP SLT
- PL/SQL
- SQL
- Azure Fundamentals
- Azure Spark
- Azure Databricks
Certification
- Microsoft Azure fundamentals (AZ 900)
- Microsoft Azure Administrator (AZ 104)
Timeline
SAP BW HANA Consultant
Tata Consultancy Services
05.2021 - Current
B.Tech - Electronics And Communications Engineering
University of Engineering And Management
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
Ankan BeraAnkan Bera
Application Architect at WiproApplication Architect at Wipro