Sap Bw Hana
Resume:
Navya Bharathi Uppari
*************@*****.***
SAP BW / SAP BW/4 HANA / SAP HANA Developer
PROFESSIONAL SUMMARY:
•Almost 10 years of extensive experience in SAP BW, SAP BW/4HANA, and SAP HANA development, specializing in data modelling, extraction, and reporting.
•Proficient in end-to-end data warehousing solutions, including data integration, transformation, and optimization.
•Managed various projects which include SAP implementation, upgrade and roll out for various industries includes Health, Transportation and Brewing.
•Proven track record of interaction with client executives.
•Demonstrated expertise in using SAP HANA Studio, BW Modelling Tools, and various SAP data services.
•Adept at performance tuning, complex data modelling, and creating advanced analytics solutions.
•Managed and resolved SAP incidents and change requests across SAP SD and MM modules.
•Successfully resolved a data loading issue within two hours, preventing a potential sales order processing delay for a key client.
•Strong experience in collaborating with cross-functional teams to deliver robust and scalable SAP solutions.
•Assessed the impact of a system upgrade on existing data models, mitigating risks by identifying and addressing compatibility issues in advance.
•Extensively worked on defining processes, estimation/development templates for technical development in SAP implementations.
•Proven experience in HANA system architecture design, Implementation, Integration & Testing and post production support.
•Experience in developing Dashboards and Scorecard using Dashboard manager to effectively represent
•KPI’s and visually accentuates critical business controls.
•Expertise in creating reports with features like Drill down, Slice and Dice, Ranking, Alerts, Section and Grouping.
•Excellent analytical, time management, interpersonal skills and a good team player with excellent oral and written communication skills.
•Experience in gathering, documenting user requirements and end - user.
•Good Knowledge in ABAP and Business Objects.
•Extensively worked on creating and customizing ODS, Info Objects, ADSOs, Info Cubes, Transformations, Multi providers, Info sets, Transient and Composite Info Providers, DTPs, Process Chains and BEx Reporting.
•Strong experience in Native HANA Modelling, Performance Tuning.
•Strong experience in SQL, stored procedures.
•Knowledge in different ETL tools like SLT, BODS, SDA and SDI.
•Performed the Go-Live activities individually.
•Performed the end user, Knowledge transfers and production support activities and resolved various issues.
TECHNICAL SKILLS:
ERP Modules
SAP ERP, EWM, ECC, S/4 HANA, MM, PP, SD, QM.
Business Warehouse
SAP BW 3.x,7.0,7.3, 7.4, 7.5, SAP BW4Hana, BODS
Application Development
SAP Hana Studio 2.0, Eclipse
Programming Languages
ABAP, SQL DB, Python
Cloud Platforms
AWS (EC2, S3, Glue, Lambda, Redshift, EMR)
Project Management & Process Designing
MS Project, ASAP Project Methodology.
Databases
PL/ SQL, SQL Server 2000, MS Access.
Document Management
SharePoint
Operating Systems
Windows 7/XP/NT/2000/98, Mac OS X
Office Software
MS Word, MS Excel, MS PowerPoint, MS Access
Reporting Tools
BEx Analyzer, AFO, Query Designer, PowerBI
EXPERIENCE:
Elevance Health, United States Dec, 2023 - May
SAP HANA / BW4/HANA Developer
•Designed and implemented an SAP BW/4HANA data warehouse for production planning, quality control, and sales performance analysis.
•Implemented scheduling and automated distribution of reports, ensuring timely delivery of information to stakeholders.
•Responsible for performing casual analysis to come up with a plan to avoid redundant errors.
•Responsible for tracking the development progress and highlighting the risks in case of any schedule variance.
•Strong Analytical using SAP methodologies with Administration workbench data modelling BI Extractor Custom, and Enhancement to Business Content, to help the Business Customer the better solution for requests HANA skill (modelling attribute view, analytical view and calculation view with composite provider and BW objects like Advance DSO).
•Successfully implemented SDA in SAP HANA, designed and developed virtual tables to provide real-time access to remote data.
•Coordinated the implementation of a new data extraction process, collaborating with business users and development teams to validate requirements and minimize disruption to production systems.
•Worked for the Sell-outs pulse and Supply chain Planning project, developed the calculation views and migrated to the Production system.
•Led the successful design, development, and implementation of SAP BW/4HANA solutions tailored to specific business requirements, with a focus on modules such as Sales and Distribution (SD), Accounts Receivable (AR), Accounts Payable (AP), General Ledger (GL), Procurement and Inventory Management.
•Developed calculation views and procedures based on Functional documents and information shared from Users.
•Performing unit testing for the developed objects and peer review testing on team developed objects.
•Preparing technical specification documents for each development.
•Migrating the developed objects across the landscape.
•Reviewing and working on production issues, working on the enhancements.
•Provided the KT for developed objects and supported on the production issues.
•Environment : SAP GUI, Hana Studio, AFO, JIRA, ServiceNow
IBM-Heineken International, Hyderabad Jan, 2021 – Aug, 2023
SAP BW4/HANA Developer / SAP HANA Brewing Industry Analytics
•Designed and implemented a SAP BW/4HANA data warehouse for production planning, quality control, and sales performance analysis.
•Developed and maintained multi-dimensional cubes and analytical models for raw material tracking, production efficiency, and brand performance.
•Worked on Update rules (BW 3.x), Transfer rules (BW 3.x), Transformations, Info object Creation, maintenance of DSO(standard, write-optimized), Info cubes, aggregates, Multiproviders and process chains.
•Supported the development of ETL processes using SAP BW's Data Transfer Process (DTP) and Transformation rules to load data from various source systems.
•Participated in the creation of data models, hierarchies, and data sources within SAP BW, ensuring data accuracy, consistency, and quality.
•Implemented data governance and security measures to ensure data integrity and compliance with industry regulations.
•Created, edited, and maintained numerous Web reports to provide actionable insights for various business units.
•Implemented scheduling and automated distribution of reports, ensuring timely delivery of information to stakeholders.
•Customized reporting tools and dashboards to meet the specific needs of different departments within Heineken.
•In-depth cross-functional experience with SAP modules - QM, PP, SD, and MM.
•Spearheaded the development of custom Extractors and transformations to enhance data quality and granularity within SAP BW/4HANA, enabling detailed analysis and reporting capabilities for key business metrics such as sales performance, financial transactions, and inventory management.
•Hands on experience reporting using BEX Query Designer, creating CKF, RKF, Variables, Conditions, Filters, Exceptions and Cells, Report to report interface techniques and distributing the reports using BEx Broadcasters.
•Created and implemented efficient and scalable business processes using APD to streamline operations and improve productivity.
•Created SAP CDS Views, Open ODS view, ODP objects, Virtual Provider & ABAP views in SAP BW/4 HANA.
•Implemented robust error handling and monitoring mechanisms within SAP BODS jobs, ensuring proactive identification and resolution of data quality issues and minimizing downtime in critical data pipelines
•Supported the development and implementation of new brewing technologies and their integration with the data warehouse.
•Successfully migrated legacy BW system to BW/4HANA, enabling improved data processing and reporting capabilities.
•Provided technical expertise and guidance to business users on data analysis and reporting tools.
•Used the BW Modelling Tools in Hana Studio 7 Eclipse to develop the Business request.
•Developed ABAP code for start and end routines in SAP BW to enhance functionality and optimize data transformations.
•Developed calculation views and procedures based on Functional documents and information shared from Users.
•Implemented complex logic into HANA modelling through procedures and table functions.
•Worked on Agile methodology and handled the end to end implementation like requirement gathering, providing estimates, interacting with security, Basis and other required teams for smooth deliverables and deadlines.
•Interacting with Users daily and proposing Technical solutions based on the requirements.
•Performing unit testing for the developed objects and peer review testing on team developed objects.
•Preparing technical specification documents for each development.
•Migrating the developed objects across the landscape.
•Reviewing and working on production issues, working on the enhancements.
•Provided the KT for developed objects and supported on the production issues.
•Environment : SAP GUI, Hana Studio, AFO, BEx Analyzer,JIRA, ServiceNow
IBM-APMM Maersk line Support, Chennai May, 2016 - Dec, 2020
SAP BW Consultant Transportation and Logistics
•Monitored data loads through various source systems like R/3 ( RP1 & EP1 ).
•Involved in 24/7 production support. Primarily concentrating on making data available to users as and when promised within the expected reporting aspects. Hence gaining trust of clients.
•Handled various data load issues like PSA load failures, DSO activation failures, Processing end, Cube failures, System dumps, rollup failures etc.
•Handling Incidents which were raised by User for data quality Issue and explanation of doubt in using AFO Tool.
•Performed reconciliations between ECC and BW, BW to BW to avoid data discrepancies. Took required action if any discrepancy appeared.
•Involved in handling service requests raised by users and also created, assigned the service request to the concerned team.
•Performed various ad hoc activities like weekly, monthly loads and delivery of files to business users and Played a key role in Period End Activities.
•Worked on Year end activities, creation of New Info cubes, mapping to multiprovider, query filter changes etc.
•Maintenance of BIA indexes and delta index settings for info cubes, identification and correction of errors in BIA indexes using RSRV tests.
•Recovered delta load failures during unplanned outages of system, unexpected failures in source system.
•Resolved many of the issues related to the AFO tool like Crosstab component error and other queries as per the end user requirements.
•Played a key role in creating Problem Tickets and fixing most of the recurring issues in daily loads.
•Knowledge on creating the CTS in ALMQ tool.
•Background Job Maintenance (Monitoring logs, Scheduling, Cancelling long running jobs).
•Involved in Housekeeping activities to improve the system and load performance.
•Worked on SAP BW/4 HANA
•Developed and maintained SAP BW data models, including Info Objects, Info Cubes, and Datastore Objects (DSOs), ensuring optimal performance and data integrity.
•Implemented complex ETL (Extract, Transform, Load) processes using SAP BW transformations, DTPs (Data Transfer Processes), and Info Packages to integrate data from various source systems into the data warehouse.
•Designed and optimized SAP BW queries and reports using BEx (Business Explorer) Analyzer and Web Analyzer, providing actionable insights to business users for decision-making purposes.
•Worked on delta load failures, Info package failures, DTP failures, DSO failures, Rollup failures etc.
•Collaborated with business stakeholders to gather requirements and translate them into technical solutions, ensuring alignment with business objectives and data governance standards.
•Conducted performance tuning and optimization activities for SAP BW systems, including database tuning, query optimization, and system parameter adjustments, to enhance overall system performance and responsiveness.
•Developed and delivered training sessions and documentation for SAP BW administrators and end-users on system monitoring tools, procedures, and best practices.
•Environment : SAP GUI, Hana Studio, AFO,BEx Analyzer,ServiceNow
Walking Tree Technologies, Hyderabad Aug, 2014 - Apr, 2016
SAP BW Consultant
•Actively monitored the data loads through various source systems ECC.
•Developed and maintained SAP BW data models, including Info Objects, Info Cubes, and Datastore Objects (DSOs), ensuring optimal performance and data integrity.
•Implemented complex ETL (Extract, Transform, Load) processes using SAP BW transformations, DTPs (Data Transfer Processes), and Info Packages to integrate data from various source systems into the data warehouse.
• Designed and optimized SAP BW queries and reports using BEx (Business Explorer) Analyzer and Web Analyzer, providing actionable insights to business users for decision-making purposes.
• Recovered delta load failures, Info package failures, DTP failures, DSO failures, Rollup failures etc.
•Performed reconciliations between ECC and BW to avoid discrepancies.
•Collaborated with business stakeholders to gather requirements and translate them into technical solutions, ensuring alignment with business objectives and data governance standards.
•Conducted performance tuning and optimization activities for SAP BW systems, including database tuning, query optimization, and system parameter adjustments, to enhance overall system performance and responsiveness.
•Developed and delivered training sessions and documentation for SAP BW administrators and end-users on system monitoring tools, procedures, and best practices.
•Environment : SAP GUI, Hana Studio, AFO,BEx Analyzer,ServiceNow
EDUCATION:
•Bachelors in Information Technology at Jawaharlal Nehru Technological University Hyderabad, India - 2014
Contact this candidate