Jhansi Lakshmi Chindanuru

Email: ad41ap@r.postjobfree.com Phone: +1-281-***-****

Courses & Certifications:

· SAP BW4HANA 2.0 SP07: Maser Class from Udemy

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

Education:

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

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

Intermediate (75%) from Board of Intermediate.

S.S.C(82%) from Narendra Bharathi High School.

My Skills:

Analytical/OLAP Tools: SAP HANA, SAP BW/4HANA, SAP SAC, SAP Bex.

Programming: ABAP on 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 BW on HANA

SAP Functional Expertise (from Analytics view): SAP CRM, SD, MM, SCM and PM.

SAP BW - HANA Experience

SAP BW-HANA Consultant with overall 12+ yrs. 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 BW modeling objects like ADSO’s, Transformations, DTPs, 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 in SAP S/4HANA perspective.

Hands on experience on enabling external access to BW objects and generating HANA views. Creating Composite provider/ODS Views.

Worked on enhancement of SAP HANA Data Modelling objects like Attribute Views, Analytical Views, and Calculation Views.

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

Experienced in data extraction, modelling and reporting on various SAP modules.

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, encompassing both master data and transactional data.

Hands on experience on ETL process 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 and 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, SCM using new dimension products like BI extraction methods such as LO Cockpit and maintaining the delta queues.

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

Experience in designing APD’s, Open Hub destination process related ABAP coding for OHD.

Hands on experience on creation of Info objects, data targets like DSO, Info Cube, Multi provider, semantically partitioned Object and Info Set, Customized Data Sources in BI system, Info package and DTP.

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

ABAP Skills:

Hands on experience on 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.

Creation of Data Dictionary objects like Tables, Views, Data Elements and Domain.

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

Debugging of code in transformations routines, programs and APD in BI.

Work Experience

SAP BW HANA consultant for the Client: DuPont and Data Lake Jan 2023 to Current

Following the Agile Methodology for Data Lake Project.

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.

Converted the Reporting requirements to Design along with DuPont Architects

Co-ordinated with other teams from planning to execution.

Developed and End to End Application as per the agreed design.

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

Replicated Data Sources from ODP/ODQ Source system.

Developed SAC reports and dashboards from multiple data sources.

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

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

Created Dimension Calculation views to get master data, Calculation views (with cube or Star Join) to get fact data and utilized Star schema modeling.

Supported OMP Projects in developing and supporting BW related objects.

Also Designed and developed Sale change metrics in BW and HANA and AO reports.

Infosys Pvt Ltd April 2014 to Dec 2018

SAP BW HANA Consultant for the client Adidas Group.

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 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 presenting updates on ongoing issues, developments and delivered within the SLA (Service Level Agreement) time limit.

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

Provide a solution to get the transport request logs across the system for multiple TR’s at a time and list of TR’s based on RFC / Project, Username.

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

HCL Technologies May 2012 to Mar 2014

SAP BW consultant for the Moduslink Solutions

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 performance of queries and performed various tuning techniques using Compression, Aggregates and Mult provider. Created a process chain and schedule to do compression on weekly basis.

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

HCL Technologies Pvt Ltd Nov 2010 to April 2012

Associate consultant for the client Rockwell Collins

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 issue (PSA deletion).

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

Provided Weekly status report on tickets.

Scheduled background jobs and creating variants.

Personal details

Date of Birth - 06/05/1987

Sex - Female

Marital status - Married.

Spoken languages - English, Telugu, and Tamil

Passport/Visa Info

Have a valid Passport with an Expiry Date - 10/25/2026.

Have a valid H4 EAD Visa with an Expiry Date - 06/12/2024.

Contact this candidate