SUMMARY

• Around 10 plus years of extensive experience in SAP BW/BI which includes around 5 years in HANA and BW/4HANA, this includes Data Modeling, ETL and Report Development.
• During years of experience she has worked for multiple onsite Projects in USA, Switzerland and India in SAP ERP space with different roles like Business Analyst, Team Lead and Onsite coordinator handling end to end deliveries.
• So far, she has been involved in 3 end - to-end SAP Implementations, 4 SAP Upgrades, 2 Data archiving, 3 BW HANA migrations, 2 HANA DB Administrations.
• Certified C HANAIMP141.
• Hands on experience in HANA modeling. Experience in creating Attribute views, Analytical view and Calculation views.
• Worked extensively on HANA modeling and responsible for HANA development deliverables in time, handled multiple projects.
• Configured and Extracted data from SAP BW/4HANA Data Base using SLT.
• Experience with integration of HANA with MDX provider for validation through frontend.
• Hands on experience in SQL, Procedures and Scripted Calculation Views, SQL Hints and SQL Plans.
• Experience in creation of delivery units.
• Experience in creation of Variables, Input Parameters
• Experience in creating calculated columns.
• Experience in Performance tuning of HANA Models.
• Exposure to functionalities like Import, Export and Schema Mapping.
• Developed reports using AFO and created Webi reports.
• Hands on BW 7.5 on HANA using objects such as composite providers, ADSO’s etc.
• Created and validated HANA based designs.
• Validate CPU usage, memory footprint and system load during test run for reports and data loads.
• HANA Security (creation of users and providing the roles and authorizations based on the business requirements).
• Experience in SAP BW/4 HANA, Advanced DSO(ADSO), Open DSO Views, Transient Providers, Composite Providers, Publishing HANA Model in SAP BW, Import SAP NetWeaver BW Model to HANA.
• Experienced in handling tasks/requests and actions in FIORI.
• Experience in Layered Scalable Architecture plus plus (LSA++).
• Experience in writing AMDP, creating Open ODS views, DB connect datasources.
• Transportation of objects to different landscapes.
• Responsible for planning cut-over activities for the go-live support for the development work.
• Redesigned HANA Attributes Views, and HANA Analytical Views for Sales Stats Extractor Loads and called them using the Open ODS (Using Database Tables/ Views) in SAP HANA Studio for SAP BW/4 HANA.
• Extensively worked in creating Business Information Warehouse objects like Info Cubes, DSO Objects, Info objects, Transformations, DTPs, Info packages and Data Sources.
• Implementation of BW which includes Data-Modeling, Data Extraction, Generic Data Extraction, Data Loading, LO Cockpit, BEx Query, Expertise in Business content services.
• Worked extensively on Extracting data from Different OLTP Source Systems - Flat File, generic extractors.
• Involved in creating a Generic Extractor using Tables and Views.
• Strong knowledge on SAP BI Modeling, Extraction and reporting which includes BEx suite
• Defined LSA architectures in BI implementations for optimizing usage of standard business content.
• Involved in transportation of the objects.
• Created Start Routines, Field Routines and End routines as per requirement.
• Extensively involved in the Performance Tuning of Queries using BIA, Aggregates, Indexing, statistics, Compression and partitioning of cubes
• Handled design issues by Remodeling of the existing design
• Design & Maintenance of Customized InfoObjects, Info Sources, Info Packages, DSO Objects, InfoCubes, Multi providers, Infosets, Data Marts, SPO’s, Hybrid, Transient and composite Infoproviders.

TECHNICAL SKILLS

Languages: C, knowledge of C++, SQL

Databases: HANA, SQL Server 2012

Operating Systems: MS-DOS and Windows NT/2000/2007/Vista

ERP: SAP BI 7.0, 7.3, 7.4, BW/4HANA, SAP ECC 6.0, EHP6, S/4HANA 1809 in SD, MM, FI, SC

Reporting Tools: BEx, Design Studio 1.5, POWER BI

Tools: HP QC

PROFESSIONAL EXPERIENCE

Confidential

Business Analyst

Responsibilities:

• Creating Data flows in SAP BW/4 HANA Modelling involving ADSO, Composite Providers and Open ODS for extracting data from S4 and third-party data sources.
• Created SAP BI Related AMDP/ABAP routines like Start/End/Field/Expert routines.
• Conversion of Multiprovider in BW to Composite Providers.
• Creation of Procedures and Functions.
• Creation of Analytic Privileges.
• Experience with integration of HANA with MDX provider for validation through frontend.
• Hands on experience in SQL, Procedures and Scripted Calculation Views, SQL Hints and SQL Plans.
• Experience in creation of delivery units.
• Experience in creation of Variables, Input Parameters
• Experience in creating calculated columns.
• Experience in Performance tuning of HANA Models.
• Compared Object Versions and validated information models.
• Imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports.
• Created Dax Queries to generated computed columns in Power BI.
• Generated computed tables in Power BI by using Dax.
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps
• Explore data in a Variety of ways and across multiple visualizations using Power BI

Confidential

Business Analyst

Responsibilities:

• Created AMDP’s, created Open ODS views, DB connect datasources.
• Expertise working with Eclipsed based Data modeling and design in BW/4HANA.
• Creating Data flows in SAP BW/4 HANA Modelling involving ADSO, Composite Providers and Open ODS for extracting data from S4 and third-party data sources.
• Extraction and loading of data from S4 HANA data sources across different business functions such as Sales and Distribution, Finance, Billing etc.
• Created Process chains to load data from S4 to BW/4 HANA data model objects.
• Created BW Queries on top of Composite providers and ADSO for various Operational and analytical reporting needs.
• Involved in multiple end to end development Projects using S/4HANA, BW.
• Created SAP BI Related AMDP/ABAP routines like Start/End/Field/Expert routines.
• Day to Day support tasks to Monitor and fix any load issues.
• Involved in requirement gathering for development, Data modelling and designing reports as per the requirement.
• Provided solution architect for the design.
• Involved in discussion with User and requirement gathering.
• Developed objects such as Info-object, DTP, Transformation, Data source, ADSO’s, Composite Providers, Cube, Multi provider, Involved in DSO deletion program.

Confidential

Business Analyst

Responsibilities:

• Created Technical Specifications with respect to SAP HALM process.
• Hands on experience in HANA modeling. Experience in creating Attribute views, Analytical views and Calculation views
• Creation of Procedures and Functions.
• Creation of Analytic Privileges.
• Compared Object Versions and validated information models.
• Conversion of Multiprovider in BW to Composite Providers.
• Used HANA data as Pivot tables in Microsoft Excel through MDX provider.
• Transported HANA content from development to testing environment using import/export.
• Integrating HANA views with Reporting tools like AFO, Tableu.
• Coordinated with offshore for testing, change management and implementation between 2 environments.
• Conversion of Multiproviders to Composite Providers.
• Troubleshooting the Performance Issues.
• Review, Refine and Validate Data Generated Reports in AFO.