Ajay Kumar Adabala
Atlanta,GA
Summary
Certified SAP BW/4 HANA and Datasphere consultant with 13 years of experience in SAP BW, HANA modeling, SAC and data integration. Demonstrated expertise in complex scenarios involving data migration, real-time analytics, and advanced reporting. Proven ability to lead technical teams, manage end-to-end implementations, and optimize system performance. Strong background in integrating SAP and non-SAP data sources and leveraging SAP Analytics Cloud (SAC) for comprehensive business insights.
Overview
14
14
years of professional experience
1
1
Certification
Work History
Technical Team Lead
Twinings USA
Clifton, NJ
03.2024 - Current
- Lead a technical team in the development and delivery of reporting solutions focused on S/4 Sales, Finance, Purchasing and Production Planning and Detailed Scheduling (PPDS) using BW/4 HANA and SAP Analytics Cloud (SAC)
- Extensive knowledge in SAP processes in overall OTC, P2P, Finance, Manufacturing, Inventory, Quality and Project system areas
- Very much aware of all required transactions, tables and flows in SAP ECC and S/4 systems which takes almost minimal or no dependency on functional teams in data issues
- Managed the extraction of data from HANA live cache involving SAP, ensuring efficient data processing and reporting
- This data is used to report shift level planned vs Actual production on each Workcenter
- Involved in cutover activities and multiple development waves, coordinating efforts to meet project timelines and objectives
- Conducted requirement gathering sessions and converted business needs into detailed technical specifications
- Acted as senior developer for BW/4 HANA leading the offshore team, preparing and reviewing technical documentation to ensure alignment with best practices and project goals
- This role required strong leadership skills and a deep understanding of both the technical and functional aspects of BW/4 HANA, contributing to enhanced reporting capabilities and data-driven decision-making within the organization
- Worked on translations of Dimensions and Queries into German, Polish and French languages
- Involved in identifying multiple root causes of the issues providing permanent fixes like OMSL setting issues for 0MATERIAL infoobject in client 000 with leading zeroes, missing formula errors in transformations even if formula exists in both display/edit mode due to RFC destination issues when transporting objects from one development system to another in multi development environments
- Extensively worked with SAP on OSS incidents and coordinated with Basis in implementation of multiple SAP notes
- Extractions of data from ABAP CDS views and BW datasources using ODP
- Manipulations of data in BW queries using customer exits and formula variables
- AAExtensively used and enhanced standard datasources in applications like purchasing, Quality Management, Sales, Billing and Delivery
- Extracted data from CDS view based on ACDOCA table for sales and financial reporting
Functional Consultant & Analytics Role
Praesidiad
Delaware, NJ
08.2023 - 02.2024
- Worked as both technical, Functional Consultant along with providing Analytics expertise in BW
- Collaborated with the Azure team to migrate ECC report logic to Azure across multiple SAP modules, including Material Management, Sales and Distribution, Purchasing, Production Planning, and Finance
- Developed custom BAPIs to facilitate seamless integration between IFS and SAP using Dell Boomi as the integration tool
- Translated business requirements into technical specifications, providing comprehensive logic and backend table information to the Azure team
- Ensured accurate data extraction and transformation for effective Power BI reporting
- This role required a strong blend of functional expertise and technical acumen, enabling the successful transition of complex reporting logic to a modern data analytics environment
Data Migration Specialist
Msa Safety Inc
Bangalore
02.2023 - 08.2023
- Successfully lead the migration of data from SAP to Azure and AWS, improving data accessibility and analytics capabilities
- Implemented efficient data transfer mechanisms using Theobald and Qlik
- Developed comprehensive documentation and conducted training sessions for stakeholders on new systems and processes, facilitating smooth adoption and usage
- Set up and managed standard and custom datasources in Qlik transaction codes in SAP and facilitated extraction to Qliksense
- Creation and scheduling of tasks in Qliksense to replicate data from SAP
- Developed proof of concepts (POC) for SAP Datasphere to integrate existing BW data, creating dynamic models for enhanced analytics
- As part of POCs of datasphere, worked on graphical views, ER models, Analytical Models and dataflows
- Used Python Pandas for data frames in data manipulations for datasphere
- Involved in remote table replications, CDS view replication flows, BW integration with in Datasphere
Analytics Solutions Developer
SASREF
Bangalore
03.2022 - 02.2023
- Designed and implemented real-time analytics solutions for operational reporting, resulting in enhanced decision-making processes and improved business insights
- Extractions from S/4 HANA and building warehouse data and reporting on SAC
- Creation of ABAP CDS views and utilized ODP extraction methods to efficiently extract data, enabling robust reporting capabilities on SAC and BW queries in BW/4 HANA
- Streamlined data workflows to facilitate real-time insights, contributing to improved operational efficiency and informed business strategies
- Create functional and solution design based on gathered business requirements.Experience with Live and Acquire/Import Data connections
- Built the Visualizations, Dashboards, stories canvas, responsive, grid, Smart Discovery, formulas, cross calculations, input controls, linked analysis
BW and HANA Consultant
Cognizant
Hyderabad
02.2019 - 02.2022
- Gained extensive implementation and support experience in BW utilizing ServiceNow, with a focus on incident management, problem management, and change management
- Collaborated closely with the HANA admin team to identify system bottlenecks and implement performance and service improvements based on Early Watch report alerts
- Conducted root cause analysis to diagnose long-standing issues, providing effective permanent fixes
- Enhanced process chain runtimes and improved ABAP performance by analyzing traces and implementing necessary optimizations within the BW and HANA systems
- Mentored team members by sharing technical knowledge and offering guidance on resolving complex issues
- Successfully addressed and implemented backlogs of previous developments, ensuring timely project delivery and operational efficiency
- Created Composite Provider Union of advanced DSO on Hana Model using Tables, Calculation Views
- Used ABAP code in Start, End Routine, in Transformation, CMOD, and Customer EXIT
- Ensured the project was completed on time, following the scope weekly to avoid Go-Live delays
- Activated the Customizing Cockpit for Sales, Shipment, and Billing with ABAP programming
- Interacted with SAP modules in ECC like FICO, COPA, and SD
- Created visually appealing and insightful dashboards for data analysis and reporting in SAC
- Worked for Sales Cube, Recoveries, Debit Note and credit note dashboard creation
- Collaborating with stakeholders to understand analytical needs and proposing SAC solutions
Senior SAP Business Warehouse Consultant
IBM
Bangalore
10.2016 - 02.2019
- Developed and optimized calculation views in HANA to enhance data retrieval efficiency and support complex business logic
- Utilized advanced SQL scripting to create dynamic and reusable data models, streamlining the data preparation process for reporting
- Implemented table functions to improve performance and flexibility in data modeling, enabling more efficient data transformations
- Prepared and optimized views specifically for Business Objects (BO) reporting, ensuring seamless integration and accurate data representation
- Conducted performance tuning and optimization of HANA models, leading to improved query response times and overall system performance
- Developed HANA views for on Project System and Purchasing modules via SLT which were used as a datasource for Tableau
- This project reports for the projects, which shows budgeted, allocated, and actual costs
- This has drill-down capabilities by Region, Project and Managers
- It also shows the number of projects completed, in progress, and the duration of completion.Apr 2011
- Developed HANA views for the reporting on New GL FAGLFLEXA and FAGLFLEXT as source tables via SLT, which will report daily and monthly actual amount with comparison of current YTD, MTD, Previous YTD, and MTD
- It also allows drill-down and filtering by GL Account, Cost Center, Profit Centers, as well as Cost Center and GL account groupings
- Web-Intelligence reporting was used as the reporting tool for these HANA views
- Replication of SAP data into HANA using SLT
- Repartitioned huge CDPOS table with 7 billion records in HANA
- Worked with HANA Admin team on multiple issues reported in Early Watch report
Senior Application Developer
Accenture
Bangalore
08.2011 - 10.2016
- Seasoned SAP professional with extensive experience in developing custom ABAP routines, implementing data archiving solutions, and enhancing reporting accuracy in BW on HANA environments
- Played a key role in hypercare support, significantly reducing issues, and contributed to month-end financial reconciliation efforts
- Involved in the migration of BW to BW on HANA 7.5 and proficient in SLT data provisioning and advanced database techniques
- Developed custom ABAP routines and transformations to enable complex business logic, enhancing reporting accuracy and efficiency
- Implemented NLS archiving solutions, facilitating the migration of data from BW on HANA to Sybase IQ through effective data archiving processes
- Played a pivotal role in hypercare support, reducing support issues from over 100 per month to just 20, thus improving system reliability and user satisfaction
- Conducted month-end financial reconciliation between FI and BW reports, ensuring data consistency and accuracy in financial reporting
- Developed BW on HANA objects specifically tailored for Business Objects (BO) reporting, improving reporting capabilities
- Contributed to the migration team for the transition from BW to BW on HANA 7.5, ensuring a smooth upgrade process and minimal disruption
- Worked on SLT data provisioning to ensure efficient data replication between source systems and BW/HANA environments
- Applied advanced database techniques, including repartitioning of large tables like CDPOS, to enhance system performance and manageability
Education
Masters - Computer's Applications
Andhra University College of Engineering
Skills
- SAP BW/4 HANA Datasphere
- SAC SAP HANA Modeling
- SAP BW 7x/3x
- SAP S/4HANA
- ECC ABAP
- CompositeProviders
- Calculation Views
- Multiproviders
- Bex Queries
- Open Hub Destinations
- SAP Smart Data Integration (SDI)
- SAP Landscape Transformation (SLT)
- SAP Analytics Cloud (SAC)
- Analysis for Office (AO)
- Webi
- ODP-based extractions
- CDS View extraction
- SAPI extractions
- Theobald
- Qlik Extractions
- Data migrations to Azure and AWS from SAP
- Custom ABAP routines
- Extraction logics
- Customer exits
- ABAP CDS Views
- Data archiving (DTO, NLS, ADK)
- System performance improvements
- ServiceNow
- JIRA
- Service Manager
- CharM
- Revtrac
- ActiveControl
Certification
SAP Certified Data Engineer - Data Fabric, C_BW4H_2404
Awards
- ACE Award in Accenture
- Multiple star awards in Accenture and IBM
- Individual performer Awards in Cognizant
Professional Development
- Advanced SAP BW/4 HANA Modeling
- SAP Analytics Cloud (SAC) Integration
- Data Migration Strategies and Tools
- HANA Modeling
- ABAP for Business Intelligence
Timeline
Technical Team Lead
Twinings USA
03.2024 - Current
Functional Consultant & Analytics Role
Praesidiad
08.2023 - 02.2024
Data Migration Specialist
Msa Safety Inc
02.2023 - 08.2023
Analytics Solutions Developer
SASREF
03.2022 - 02.2023
BW and HANA Consultant
Cognizant
02.2019 - 02.2022
Senior SAP Business Warehouse Consultant
IBM
10.2016 - 02.2019
Senior Application Developer
Accenture
08.2011 - 10.2016
Masters - Computer's Applications
Andhra University College of Engineering
SAP Certified Data Engineer - Data Fabric, C_BW4H_2404
Similar Profiles
Chetan AshwathnarayanaChetan Ashwathnarayana
Business Process Lead for Make to Deliver at Twinings Ovaltine (TwO)Business Process Lead for Make to Deliver at Twinings Ovaltine (TwO)
Con KapkidisCon Kapkidis
Senior Finance Business Partner at Twinings AustraliaSenior Finance Business Partner at Twinings Australia
Ezaina UmukoroEzaina Umukoro
Procurement Manager/Project Lead-Nigeria at Twinings (Associated British Foods)Procurement Manager/Project Lead-Nigeria at Twinings (Associated British Foods)
Raymond ConwayRaymond Conway
Member Services Specialist at Vystar Credit UnionMember Services Specialist at Vystar Credit Union
Jordan AndersonJordan Anderson
Registered Nurse, HRP at Northside Hospital AtlantaRegistered Nurse, HRP at Northside Hospital Atlanta