Sap Bw Hana

Jhansi Lakshmi Chindanuru

Phone: 281-***-****

Email: ******.*******@*****.***

Professional Experience:

SAP BI/BW-HANA Consultant with an overall 10+ years. of experience in the IT industry in various Analytics, Data warehousing, Data Modeling, Data Quality, and various BI Analytical tools, design, development, testing, and implementations.

Proficient in Conceptualizing & Orchestrating Business needs and providing Appl. development/Integration solutions as per Agile market trends.

Experience in creating advanced BW modeling objects like ADSOs, Transformations, DTPs, and Composite Provider in HANA Studio.

Experienced in creating Attribute, Analytical, and Calculation views in HANA Studio on stand-alone HANA box and SAP Business Suite on HANA.

Experience in utilizing SAP BW on HANA objects and SAP HANA Calculation views to create hybrid data models.

Experience in creating and using CDS views, AMDP procedures, Table Functions, SQL views, and Graphical views from an SAP S/4HANA perspective.

Experienced in the development of BW4HANA 2.0 data models including ADSOs, Composite Providers, Semantic Group (SEGR), ODS, and CDS (Core Data Services).

Experienced in designing Bex queries consisting of RKFs, CKFs, Virtual Key Figures, Exceptions, Conditions, Cell Restrictions, Exception Aggregation, Constant Selection etc.

Involved in full life cycle implementation (requirement gathering, realization, implementation, and postproduction activities).

Conducted daily monitoring of data loads and promptly addressed load failures, and transactional data.

Functional knowledge of SAP Inventory Management, including Material Movements, Inventory Snapshots etc.

Experience in designing APDs, and Open Hub destination process-related ABAP coding for OHD.

Worked in most of the areas of SAP BI such as Modelling, BEX reporting, Data Extraction, Process Chain, Analysis process designing (APD), Web Application Design, and Broadcasting of reports while resolving ticket-related issues and production monitoring.

Experience in developing SAC stories using canvas, responsive, grid designing with blending data, formulas, cross calculations, input controls, linked analysis.

Prepared demo and presented Dashboards on SAP Analytics Cloud to the higher management to showcase the SAC tool and its functionalities.

Experience in creating interactive and graphical dashboards in SAP Analytical Cloud to present the planning data which helps for decision making.

Hands-on experience in writing ABAP code for Routines (at field level, Start and End routines), BADI to populate data at query variables at runtime, and Customer Exit in BI system to restrict data at report level and populate data by lookup from other targets.

Handled Work area and internal tables and DML operations on internal tables. Handled with String functions and Control break statements.

Proficient in Power BI data modeling, and Power Query transformations to clean and prepare data for analysis.

Designed and developed interactive dashboards and reports using a variety of visualizations (e.g., cards, tables, charts, maps etc).

Capable of collaborating with cross-functional teams to understand business requirements and translate them into effective data visualizations.

Functional experience in configuration and testing the magor Master Data like Plant, Company Code, Sales Org, Distribution channel and extract the same into BI system.

Having good knowledge on OTC sales process in SAP like validating the customer-material information, determining the shipping point.

Having good knowledge on Price condition techniques which helps to determine the price during the sales document process.

Experience with procure-to-pay (P2P) process, including purchase requisition creation, purchase order processing, goods receipt, invoice verification.

Technical Skills:

Analytical/OLAP Tools:

SAP HANA, SAP BW/4HANA, SAP ECC, SAP SAC, Power BI,AFO

Programming:

ABAP on BI/BW, SQL, PL/SQL.

Databases:

Oracle 7.X/8.0, SQL Server, SAP S/4 HANA, SAP R/3, AFS, SCM, and Flat File.

Data Modeling Tools:

SAP HANA Studio, SAP BW/4HANA, and SAP BI/BW on HANA

SAP Functional Expertise (from an Analytics view):

SAP CRM, SD, MM and SCM.

Courses & Certifications:

SAP BW4HANA 2.0 SP07: Maser Class from Udemy.

SAP BW4HANA-Essential Training: Complete hands-on-course from Udemy.

Professional Experience:

CORE ITS LLC Jan 2023 to current

Software Developer for the client DuPont

SAP BW HANA consultant

Responsibilities:

Gathered the Reporting requirements of type new and change of existing, working closely with Power/Business Users.

Converting the reporting requirements to Design and develop the flows in SAP BW on HANA and HANA systems.

Developed CDS view in the source system to utilize in the BWHANA environment.

Developed SAC reports and dashboards from multiple data sources.

Created new BW modeling objects – advanced DSOs (ADSO), Open ODS, and Composite Providers in new “Data Flows”.

Experienced in different data extraction techniques like SLT, SDA/SDI, BW LO Cockpit, Generic Extractions, and Master and Transactional data Extraction.

Integrate the data from different targets of Procurement(MM), Inventory(IM), warehousing, sales distribution(SD).

Sales Order entry, determining pricing, validating goods issues, order fulfillment, shipping and delivery.

Created the BW4HANA modeling objects like ADSOs, Composite Providers, Semantic Group (SEGR), and ODS.

Created CDS views for the source system and used them in the HANA system to make it available for reporting purposes.

Extensively worked on Open Hubs/APDs and sent the data to BW/4HANA system to use the data in HANA Models.

Experience in building efficient and scalable planning models within SAP SAC, understanding considerations like granularity, hierarchies, and attributes.

Spearheaded the synchronization of production support systems with project systems, ensuring data integrity and operational efficiency.

Capable of collaborating with cross-functional teams to understand business requirements and translate them into effective data visualizations.

Experienced in data modeling, creating relationships between tables, and optimizing data for performance within Power BI.

Experience in modelling of Native HANA Objects like Calculation Views, Analytical Views, CDS views, Table Functions, Stored Procedures.

Skilled in creating and managing workspaces, datasets, and reports within the Power BI Service, including sharing and collaboration features.

Deployed and maintained Power BI reports and dashboards, ensuring data accuracy, accessibility, and performance.

Proficient in Power BI data modeling and transformation techniques, including Power Query, to clean, prepare, and analyze large and complex datasets from various sources. Experience in creating intricate data models with multiple sources and hierarchies.

Infosys Pvt Ltd April 2014 to Dec 2018

SAP BW HANA Consultant for the client Adidas Group.

Responsibilities:

Implemented end-to-end process from source to HANA system for the seasonal upgrades received from the client.

Implemented HANA objects like Attribute view, Calculation view, and Analytical view on top of info providers of the BW system.

Generate HANA views for the existing data flows to access them from BW4HANA & HANA systems.

Functioned as the primary point of contact for clients to gather enhancement requirements and present updates on ongoing issues, and developments and delivered within the SLA (Service Level Agreement) time limit.

Led the team of 3 consultants for the upgrading BW project.

Provide a solution to get the transport request logs across the system for multiple TRs at a time and a list of TRs based on RFC / Project and username.

Implement ABAP code for customer exit variables and start routine, end routine, and Field level routines to fulfill the requirements.

Hands-on experience in ETL processes from SAP, Non- SAP source systems using transformations and Customer Exits / User Exits / IP Routines / DTP Routines.

Hands-on experience in performance tuning, maintenance of system performance through compression, roll-up of Aggregates, creating indexes, PSA deletion, and loading performance.

Hands-on experience in data source enhancement for customization from different source systems like ECC, AFS, and SCM.

Hands-on experience in data extraction from SAP R/3 like SD, MM, and SCM using new dimension products like BI extraction methods such as LO Cockpit and maintaining the delta queues.

Involves in planning, execution and control of all activities of material information from SCM system to HANA.

Generating reports for Demand forecasting, production planning, inventory management, transportation planning.

HCL Technologies May 2012 to Mar 2014

SAP BW consultant for the Moduslink Solutions

Responsibilities:

Generated testing documents and participated in housekeeping activities aimed at improving system performance.

Ensured timely problem resolution as a member of the support team.

Prepared status emails containing all necessary information and executed Master data deletions.

Worked on the performance of queries and performed various tuning techniques using Compression, Aggregates, and Mult provider. Created a process chain and schedule to do compression weekly.

Quality review of deliverables and developed queries as per end-user requirements.

Integration of new BW objects and transforming data from source system to BW.

HCL Technologies Pvt Ltd Nov 2010 to April 2012

Associate consultant for the client Rockwell Collins

Responsibilities:

Developed technical specifications, business design specifications, user testing manuals, and system integration documents.

Monitored the Data loads and analyzed the reasons for frequent failures of data extraction such as lower-case errors, special characters, deadlock, and table space issues (PSA deletion).

Monitored Daily, Weekly, and month-end Data loads/Variant change activities successfully.

Provided Weekly status reports on tickets.

Scheduled background jobs and creating variants.

Education:

Master of Computer Applications (75%) from Osmania University, Hyderabad, 2010 passed out.

Bachelor of Computer Science (78%) from MSR Degree College, SV University, 2007 passed out.

Visa:

H4 EAD valid until 2027.

Contact this candidate