Solution Architect Sap Bw

LAKSHMINARAYANA GOLLAMURI

SAC Solution Architect

Cell: +1-469-***-****

Linkedin:linkedin.com/in/lakshminarayana-gollamuri-25250170 Email: **************@*****.***

Skype: GLNBWARCHITECT

Professional Experience:

SAP Certified professional with over 14 years of experience in SAP Native, SAP BW/4HANA, Datasphere, BTP, BW on HANA, BW/BI, SAC and BOBJ, having played roles such as Solution Architect, Technical Lead, Senior Developer, and Consultant.

Worked with SAP modules like FI, CO, SD, MM, PM, PP, PS, QM, and HR for Industries like Enterprise, Accounting, Pharmaceuticals, Polymers, Chemicals, Steel, Mining, and Construction.

Extensively worked on creating Data Models in SAC using Live and Import connections on SAP BW4HANA and S/4HANA.

Data Wrangling, Model Config, Story Development, Security Development. Analytics and Planning applications with S/4 HANA and BW4HANA source systems.

Experienced and sound knowledge of Native HANA 2.0 and SAP Analytics Could (SAC).

Experienced in SAP HANA - Information Models, Attribute, Analytical, and Calc Views. Experienced in SAP BI AFO, BOBJ, IDT, WebI, Dashboard, and Crystal Reports. Strong communication skills to liaise with business users in understanding strategic goals and key data information.

Hands on experience in SAP BTP, Business Application Studio.

Strong experience in Native HANA Modeling, Exposure to CDS views.

Played a pivotal of Lead Data Architect while working closely with FP&A (Financial Planning and Analysis) team to understand their requirements for planning, budgeting, and forecasting, and translated them to technical documents.

Developed and maintained complex BOBJ reports and dashboards for executive leadership, resulting in improved data- driven decision-making.

Collaborated with cross-functional teams to gather requirements, design data models, and create interactive visualizations using Web Intelligence and Crystal Reports.

Developed and maintained complex reports using SAP Crystal Reports to support business decision-making processes.

Collaborated with stakeholders to gather requirements and translate them into technical specifications for report development.

Optimized report performance by implementing best practices in data retrieval and report design.

Worked on various planning processes including Capex (Capital Expenditure), Opex (Operating Expenditure), depreciation, and P&L (Profit and Loss).

Worked on SAP implementation, Development, SAP BW to BW4HANA conversion, Migration, Upgrade, and production support.

Managed all phases of the project from Requirements gathering, blueprinting, Configuration, Integration Testing, Training to Go Live, Documentation, Post -Go Live support activities.

Experience in gathering the business requirements and converting them into Functional and Technical Documents, with test Scenarios.

Hands-on experience in the Cloud Application Programming Model, ABAP Programming Model, and Business Application Studio. Additionally,

I have practical expertise with SAPUI5, Fiori Elements, OData Service, CDS Views, and Embedded Analytics on the SAP BTP Cloud Platform.

Experienced in Cloud Application Programming Model, RESTful ABAP, Business Application Studio, SAPUI5, Fiori Elements, OData, CDS Views, and Embedded Analytics on SAP BTP.

Mobile expertise using SAP UI5 and Gate way of Odata Integration

Created Fiori applications using SAP UI5 and SAP Web IDE.

Created SAP FIORI tiles by using SAP S/4HANA and BW/4HANA data.

Strong experience in cloud technologies, and cloud platform tools like Azure, GCP and AWS.

Worked on SAP On Premise to Cloud data migration and cloud to cloud migration.

Experience in writing SQL Queries for creating calculation views and building data flows.

Fields to append the structure for an existing extract structure by ABAP Functional Module and Add corresponding ABAP logic to fill these fields in the data source.

Expertise in Bex Analyzer, Query Designer, and created Queries, Bex Broad caster, Workbooks, structures, Cell Editor, RRI, Variables, Properties, Exceptions, and conditions to enhance the reporting features.

Worked on in-place conversion for converting objects as compatibility for BW4HANA.

Created CDS Views, ADSO, Open ODS view, and Composite provider as per the project requirement.

Hands-on Experience in Data Load Monitoring and Designing & and Maintain Process Chains.

Highly motivated, Proactive, and possess excellent technical, interpersonal & problem-solving skills and motivate others to produce results on time.

Participated in all phases of the life cycle including Requirement Gathering, Analysis, Design, Development, Testing, Deployment Solutions, Post Go Live Support, Documentation, and User Training LAKSHMINARAYANA GOLLAMURI

SAC Solution Architect

Cell: +1-469-***-****

Linkedin:linkedin.com/in/lakshminarayana-gollamuri-25250170 Email: **************@*****.***

Skype: GLNBWARCHITECT

Responsible for efficiently delivering the project and supervising the implementation team.

Successfully creating dashboard stories in SAC using Canvas, Responsive pages and Digital Boardroom.

Excellent business process, analytical, interpersonal and communication skills. SAP Certified Application Associate – SAP Analytics Cloud SAP Certified Application Associate -Reporting, Modeling & Data Acquisition with SAP BW/4HANA 2.x PROJECTS HANDLED

Client Name Cigna Health Care Florida, US

Role

Environment Tools

SAC Solution Architect

BTP SAP DATASPHERE BW4HANA NATIVE HANA SAC BOBJ

Duration JAN 2024 – till date

Responsibilities:

● Responsible for preparing the As-Is and To-Be requirements finalizations.

● Responsible for close interactions with product owners and stakeholders.

● Understand the Epics and estimation of stories.

● Work as Scrum team member and as scrum master.

● Involved in estimation of user stories.

● Skills sets include SAP Dataspheres, S4HANA and SAC.

● Active involvement as a part of cross functional teams at enterprise level and part of Agile release train.

● Align with other scrum teams to make sure as part of the product delivery for customer value.

● Responsible for QEC and YEC activities.

● Handling the Migration and conversion activities while moving from BW4HANA.

● Pre and post activities of handling the application related activities

● Coordinating with Platform teams, Monitoring teams along with basis teams to make the smooth run of BW business applications in terms of loads and reporting.

● Developed and maintained SAP BTP applications by various services like S/4HANA, BW/HANA and BAS

● Designed and implemented custom interfaces using SAP Fiori for the reporting

● Integrated SAP BTP solutions with external systems.

● Provided technical support and troubleshooting for SAP BTP applications.

● Created calculation views using Business Application Studio in BTP.

● Perform the transport request Management using SAP BTP.

● Create Various report tiles by consuming SAP Fiori on SAP S/4HANA and SAP BW/4HANA date.

● Document all the dataflows before and after migrations and make sure proper business stability sign off from the counterparts.

● As part of the remote conversion process, Timely interactions with respective business counterparts align with Platform teams to make all the application related business contents.

● Actively involved in CDS view based extractions.

● Analyzing the identifying the analytical reports at each business cluster. And making those available using HANA calculation views to SAC based on the user choice.

● Activate the delta from CDS view based extractors -generic and ODQ -based.

● Creating the composite providers based on the ADSOs, Open ODS views and HANA CV using UNION/JOIN.

● Custom BW process chain creation and monitoring in BW4 Cockpit.

● Configuration SAC to BW connectivity using CORS and consuming BW query in SAC model and Story.

● Actively involved in Cloud for semantics layer, Generated perspectives and deployed to HANA.

● HANA deployed views are accessed to SAC based on the power users / Analytical owners Requirements.

● Involved in the conversion of dataflows.

SAP Certifications:

Current Employment: Working as SAP Solution Architect Cigna Health Care Jan 2024 – Till Date LAKSHMINARAYANA GOLLAMURI

SAC Solution Architect

Cell: +1-469-***-****

Linkedin:linkedin.com/in/lakshminarayana-gollamuri-25250170 Email: **************@*****.***

Skype: GLNBWARCHITECT

● Model, RESTful ABAP Programming Model, and Business Application Studio. Extensive experience with SAPUI5, Fiori Elements, OData Service, CDS Views, and Embedded Analytics on SAP BTP Cloud Platform

● Using Business Application Studio and developing with SAPUI5 and Fiori Elements

● Prepare data sources, create models creates SAP Analytics Cloud story using the models in SAP Datasphere

● Developed a comprehensive dashboard using SAP Datasphere to provide real-time insights into customer behavior and sales trends.

● Assisted in designing and implementing data models using SAP Datasphere.

● Using SAP Datasphere and SAP Analytics Cloud enable a common evaluation of both data scopes by the business user himself

● Prepare data sources, create models Create SAP Analytics Cloud story using the models using this data in SAP Datasphere. Client Name Astra Industrial Group Riyadh, Saudi Arabia Role

Environment Tools

SAP BW Technical Architect

SAP DATASPHERE BW/4HANA S4HANA SAC BTP BODS BW/BI ECC BOBJ Duration MAY 2013 – DEC 2023

Responsibilities:

● Responsible for preparing the As-Is Business process and To-Be business processes

● Created multi-dimensional data models using information models using HANA STUDIO.

● Documented the Gaps analyzing with business

● Performed Reporting analysis in BI, which are related to all the Standard and Custom.

● Design SAP BW on HANA objects such as info cubes, DSO’s, master data, transformations, extractors and develop the HANA views as per the Requirements.

● SAC Led in SAP Analytics Cloud implementation for multiple use cases.

● Managed all phases of the project from Requirements gathering, blueprinting, Configuration, Integration Testing, Training to Go Live, Documentation, Post -Go Live support activities.

● Developed SAP Analytics Cloud Analytics solution involving data wrangling, Multi model set-up, Model development, Story development, and KPI Dashboarding for multiple streams of reporting and business.

● Developed complex Bex Queries to Support SAC background.

● Developed comprehensive planning solutions involving data wrangling, model setup, and input schedules.

● Developed SAP Analytics Cloud planning solutions, including data wrangling, model setup, input schedules, planning functionality, reporting, and dashboards1.

● Integrated SAP Crystal Reports with various data sources, including SAP ECC, SAP S/4 HANA, and other databases.

● Provided training and support to end-users on how to effectively utilize SAP Crystal Reports for their reporting needs.

● Ensured data accuracy and consistency by conducting thorough testing and validation of reports.

● Customized and enhanced existing reports to meet evolving business requirements and improve user experience.

● Utilized advanced features of SAP Crystal Reports, such as sub-reports, cross-tabs, and formula fields, to create comprehensive and insightful reports.

● Managed report deployment and scheduling using SAP BusinessObjects Enterprise.

● Troubleshot and resolved issues related to report generation and data discrepancies.

● Create a table or view that represents our data set by Using Transaction RSO2 to create a generic extractor with SAP ABAP.

● Assisted in the development of custom ABAP programs and reports.

● Developed and maintained custom ABAP programs to meet business requirements.

● Optimized existing ABAP code to enhance system performance and efficiency.

● Configured SAP FI modules, including General Ledger (GL), Accounts Payable (AP), and Accounts Receivable (AR).

● Ability to interpret, Configure and implement data mapping/ transformation business rules into data services.

● Integrated SAP BW data with SAP FI for financial analysis and reporting.

● Developed and maintained SAP BW data models, ensuring data accuracy and consistency.

● Created multi-dimensional data models using information models using HANA STUDIO.

● Creation and maintenance of Universes using IDT Using BO client tools.

● Handle application movement across DEV, QA, PRE-PROD, and PROD environments.

● Responsible for Requirements gathering, providing effort estimation & Gap Analysis.

● Designed and developed ETL models in BODS, modified or created new data services jobs to meet the project requirements. LAKSHMINARAYANA GOLLAMURI

SAC Solution Architect

Cell: +1-469-***-****

Linkedin:linkedin.com/in/lakshminarayana-gollamuri-25250170 Email: **************@*****.***

Skype: GLNBWARCHITECT

● Understanding if end to end data migration process including extraction, data profiling and transformation and generation of load ready data files.

● Preparing Design Documents (Technical/Functional) & User Training Documents

● Design and implementing SAP BI data modeling using Info cubes, DSO’s and Multi providers and Calculation View (Graphical as well as Scripted), Analytical Privileges in the HANA

● Designing the relevant data flows in BW data load maintenance.

● Cutover & Go-live Preparation.

● Consolidate financial data from SAP into Snowflake for comprehensive financial reporting purpose and analysis for Group management.

● Integrate SAP supply chain data with Snowflake to optimize inventory management and logistics for the SCM team.

● Combine customer data from SAP with other data sources in Snowflake to gain deeper insights into customer behavior and preferences.

● Worked as Technical Architect SAP Business Planning and consolidation S/4 HANA Optimized BPC10.1

● End to End Implementation and support projects of Legal Consolidation, Planning and Migration of Legal Consolidation in SAP BPC NW

● Worked extensively on the SAP BPC Tools like creation of Environment, Models, Business Rules, Script Logic, Dimensions, Work Status, Security and Business Process Flow.

● Responsible for preparing the upgrade strategy from BPC7.0 MS Version to BPC10.1 MS Version.

● Configured BW and BPC Embedded objects like Maintain the Aggregation levels for Planning on Real time info cubes, Multiproviders, Composite Providers, ADSO and Direct update DSO.

● Configuration designer, configuration led to Analyze, design, build, test and deploy the end-to-end solution on BPC10.1.

● Given training to the Key users on BPC

● Responsible for replacing all the Customized objects in BPC 7.5 and re-creating them in BPC 10.1 or provide alternative solution to support the existing functionality.

● Process chains monitoring and working on the support tickets like BRS’s, CR’s and regular support.

● Responsible for Design data flow and reports for all the modules like SD, FI, CO, MM, PP, QM and HR.

● Activating all the standard reports from the BI Content and creating process chains for the data extraction.

● Preparing Design Documents (Technical/Functional) & User Training Documents

● Design and implementing SAP BW/BI data modeling using Info cubes, DSO’s, Multi providers, Attribute View, Analytic View, and Calculation View (Graphical as well as Scripted), Analytical Privileges, Decision Tables. Client Name Astra Industrial Group Riyadh, Saudi Arabia Role

Environment Tools

SAP BW Led Consultant

SAP BW ECC

Duration JUL 2012 – APL 2013

Responsibilities:

● Responsible for activating all the business content objects from BI Content

● Responsible for Design data flow and reports for all the modules like SD, FI, CO, MM, PP, QM and HR.

● Activating all the standard reports from the BI Content and creating process chains for the data extraction.

● Responsible for Requirements gathering, providing effort estimation & Gap Analysis

● Preparing Design Documents (Technical/Functional) & User Training Documents

● Build/ Development

● Design and implementing SAP BW/BI data modeling using Info cubes, DSO’s, Multi providers, Attribute View, Analytic View, and Calculation View (Graphical as well as Scripted), Analytical Privileges, Decision Tables.

● Designing the relevant data flows in BW data load maintenance for MRP data.

● Cutover & Go-live Preparation.

● Vendor Team and Working with them based on demand.

● Data load monitoring and working on technical issues.

● Provided best practice, tips and tricks for using the tool for the developers and technical implementers.

● Business Enhancements and Support.

● Responsible for QC reviews and corrections and updating the customized objects LAKSHMINARAYANA GOLLAMURI

SAC Solution Architect

Cell: +1-469-***-****

Linkedin:linkedin.com/in/lakshminarayana-gollamuri-25250170 Email: **************@*****.***

Skype: GLNBWARCHITECT

● Accountable for preparing the status updates and review meetings Client Name PWC Kolkata, India

Role

Environment Tools

SAP BW Led Consultant

SAP BW ECC BOBJ

Duration NOV 2010 – JUN 2012

Responsibilities:

● Understanding the business requirements and designing the report for the business users.

● Responsible for gathering requirements, providing effort estimation by maintaining single point of contact with the User.

● Design and implement SAP BW data modeling relevant data flows in BW and its process chains.

● Responsible for application management of BW data from SAP R/3 using different data sources.

● Extensively using Administration Workbench (RSA1) and created customized Meta objects (Info Objects, Info sources, Info cubes, ODS, Aggregates, Info packages)

● Prepared the functional Specs for the requirement.

● Created Users, Roles, Privileges, Packages, Schemas as part of BW Security and Development.

● Loading Master & Transactional data by using flat file source system as R/3

● Scheduled and monitored BW jobs daily, weekly, monthly data load using process chains.

● Worked on FI-AP Dashboard with BW Back end.

● Analyzing the requirements, understanding the business process, configuration changes

● Preparing Best practice, governance and strategy documents.

● Preparing testing strategy and cutover activities

● Expertise in designing complex Dashboards using SAP Dashboard Design

● Effectively administered BO environment by monitoring/granting permissions and rights to users for viewing, creating, publishing and Scheduling reports through CMC.

● Developing Dashboards on Enterprise data using BICS connections.

● Enhancement of existing Dashboards for better performance and look & feel. Client Name Lexmark Kolkata, India

Role

Environment Tools

SAP BW Consultant

SAP BW ECC BOBJ

Duration APL 2010 – NOV 2010

Responsibilities:

● Prepared Technical document designs, Reviews, Coding and unit testing

● Working on priority-based tickets

● Preparing Root Cause Analysis document of Problems raised by users.

● Involved in solving High-prioritize tickets regarding extractions, Performance Issues and load failures.

● To estimate the Work Requests and make sure their completion is within the deadline.

● Executing project activities as per the timelines of the Project.

● Worked on BI content for FI, PM, HR.

● Worked extensively on creating Info Objects, Transformation's and Extraction.

● Developed Queries and Workbooks, Created Formulas, Selections, Structures, Calculated Key Figures, Restricted Key Figures, and Used Variables with User Entry/Default Value, Replacement Path.

● Created Aggregates on Info Cubes to improve Query performance.

● Creating queries on different Info Cubes Using Bex.

● Worked on Creating Aggregates, Compressions, Indexes, Multi Cubes and parallel setups for data loading to improve performance and utilize data effectively.

● Extracted Transaction data by FI extraction from SAP R/3 to BI by maintaining the extract structures, maintaining data sources & replicating the data sources into BI.

● Interacting with the client during the weekly scheduled meetings. LAKSHMINARAYANA GOLLAMURI

SAC Solution Architect

Cell: +1-469-***-****

Linkedin:linkedin.com/in/lakshminarayana-gollamuri-25250170 Email: **************@*****.***

Skype: GLNBWARCHITECT

● Involved in customizing Business Content for Standard Info Objects, Info Sources, Info Cubes related to Sales and Distribution

● Managed and monitored data loads with full update and delta mechanism

● Automated data loading and administration tasks using process chains

● Used ODS to stage the Listings changes data before transferring the transaction data into Info Cube

● Managed and monitored several data loads with millions of records. Optimized load performance by Parallel loading and resolved the errors and inconsistencies during the data loads

● Involved in taking necessary actions to correct info packages by way of doing Manual Update, Reconstruction and Running info packages manually depending on the case

● Involved in solving customer posted tickets and system-generated tickets.

● Extensively used Bex Analyzer, created queries with Variables, Filters, Calculated key figures, restricted key figures, Exceptions, Conditions etc. Used RRI feature to jump between the Queries to analyze the data efficiently Lakshminarayana G

Contact this candidate