Swetha Bindu Kavali Cell: 832-***-****

ac88gf@r.postjobfree.com Houston, TX

Professional Objective

Seeking opportunities to assist organizations in achieving business objectives by bringing strong leadership, technical development, design experience, and effective communication skills to collaborative ventures with business partners and other stakeholders.

Experience Qualifications

Total 8 years of extensive experience as a SAP BI/BW (7.5,7.4,7.3, 7.0.) consultant, which includes experience in SAP HANA as a techno - functional consultant playing various key roles in Design, development, Production support and reporting techniques across modules SAP Investment Management, FI/CO & Treasury.

Expertise in implementing 3 Complete Life-Cycle Implementation of SAP BW/BI which dealt with Blue Print, Realization, Data Modeling, Data Extraction, Data Loading (Full / Delta Up-loads), Scheduling, Monitoring, support packs implementation, BEx Analyzer, Query Designer, Web Applications Designer, Testing, Go Live & Production support, End user documentation.

Strong working experience in data analysis, design, development, implementation and testing of data warehousing using data conversions, data extraction, data transformation and data loading (ETL).

Extensively worked on LO Extractors.

Solid experience in construction of customized Info Objects, Basis Info Cubes, Remote Cubes, Transactional Cubes, Virtual cubes, Multi Providers, Info sets, ODS/DSO objects, Advanced DSO and Composite Provider.

Expertise in Transformations, DTPs, Update rules. Transfer Rules, Hierarchies, Routines, and Process Chains.

Extensively worked in creation of process chain for daily, monthly and quarterly data loads also involved in creation of mailing chains to deliver the mails automatically to the clients.

Conducted and performed Performance tuning Techniques (Aggregates, Process chains, Cube Compression, Line Item Dimension, and Indexing) for Improving the Reporting.

Expertise in BEx Analyzer, Web Application Designer, Info-Set queries. Experience with Front-end Business Warehouse Components, which involved constructing custom queries using Variables, Structures, Conditions and Exceptions, Restricted and Calculated Key Figures. Expertise in publishing queries to web portals through Web Analyzer.

Expertise in Business Explorer Suite - BEx Query Designer, BEx Analyzer and BEx Web Analyzer.

Good Knowledge on BW 7.4 and its new features like Hybrid Providers, Semantic Partitioning Objects, Advanced DSO, Composite Provider, HANA Views, HANA Optimized Cubes.

Extensively worked on SAP BW 7.5. Extended non cumulative handling for Advanced Data Store Objects with delta calculation.

Conversion of existing MultiProvider and “old” Composite Provider.

Experience in Creating Universes (.UNX and .UNV) using Business Objects Universe Design Tool, Information Design tool(IDT) for Web Intelligence (WebI)

Expertise in creating complex filters such as pre-defined conditions, report filters, prompts and drill filters.

Extensively Worked on SAP HANA Modeler (HANA Design Studio), Designing Schemas, Creating Packages, Attribute View, Analytical View, Calculation view, Analytic Privileges, Stored Procedures and CE Functions.

Experienced in importing SAP BW Models in SAP HANA, Converting the standard DSO into HANA Optimized DSO, Standard Info Cube into HANA optimized Info cube.

Understanding of SAP In-Memory Computing Architecture, Column store, Row store tables in SAP HANA studio.

Experience in SAP HANA development, migration, optimization and support for mixed approach with Native and SAP BW on Hana solutions.

Extensively worked on SAP NLS (Near Line Storage), Hot, warm and Cold Storage and unlocking data when is needed.

Good HANA SQL scripting knowledge.

SAP Technical Skills:

• Data Warehousing: SAP BW 3.5, BI 7.0, BW 7.3, BW 7.4, BW 7.5

• ABAP: Routines (Start, End & Field Routines), Debugging, Modifying Existing Functional Modules, Executing Programs and reports, Creation of Customizing tables, Routines in DTP Filters.

• SAP HANA: Hana Modelling, Data Provisioning methods and Performance optimization.

• SAP BO: Creation of Webi and Dash boards.

SAP BW/BI Sr. Consultant Allianz Technology - Pune, India.

April 2014 to Dec 2018

Client Description:

Allianz SE a European financial services company headquartered in Munich, Germany. Its core businesses are insurance and asset management. As of 2014, it is the world's largest insurance company, the largest financial services group and the largest company according to a composite measure by Forbes as well as the largest financial services company when measured by 2013 revenue.

Travelled to Twice to Germany Munich and France Paris to work with Client in Germany and French Clients.

Roles and Responsibilities

Implementing a full life cycle Analytics solution which includes Requirements gathering, Development, Testing, Reporting, Go-live and Post Go-live support.

Designed and implemented SAP HANA 1.0 SP9 data modeling using Attribute view for master data, Analytic Views for Transaction Data and Calculation Views Graphical and SQL script to Join/Union the various Attribute and Analytic Views for report consumption with time dimensions.

Written SQL command to delete duplicate records.

Worked on SQL DDL and DML commands

Worked on setting indexes on tables.

Wrote SQL queries using different JOINs.

Extensively worked on Query building, filtering, free Characteristics, RRI-Jump queries, Restricted Key Figures and variables, Calculated Key Figures, Conditions, and Exceptions using BEX Analyzer.

Maintained Process Chains to automate and schedule the data loads.

Extensively worked on SAP BW 7.5. like Creating Advanced DSO, Open ODSO View and Composite Providers.

Extensively worked on Data design and Data modeling using Extended Star Schema.

Configured components related to sales orders like sales document types, item categories, schedule line categories etc.

Worked on Business Content SD and MM Extractors and enhanced datasources for 2LIS_11_VAHDR, 2LIS_11_VAITM, 2LIS_11_VASCL.

Developed trended versions of Revenue reports by Region, Product and Service.

Understanding the business challenges and translating them into requirements and developed Analytics and Reporting Queries according to Business Requirements.

Worked extensively on Data Modeling design like creating Info Objects, Info Cubes, DSO, Advanced DSO, Composite Provider, Multi Providers, Info Sources, Infoset, time dependent master data also in ETL (Extraction, transformation and loading) activities like Extraction from Source system, Transformation rules, Data Transfer Process (DTP), Open Hub service etc

Customized queries using navigational attributes and filters in BEX analyzer and used customer exits as per client requirements.

Designed report templates with BEX Analyzer and Web Analyzer using key figures, features, hierarchies, variables, properties, exceptions and conditions in the query definition.

Involved in postproduction support activities in monitoring the daily data loads, fix report issues, and reconciliation issues. Defined Transformations created DTP’s and Info package for scheduling loads to data targets.

Created Process Chains and Meta-Chains for periodic upload of Text data, Master data and Transactional data, and Monitored data loads with full update and delta mechanisms.

Worked on NLS, Achieving data.

Designed report templates with BEX Analyzer and Web Analyzer using key figures, features, hierarchies, variables, properties, exceptions and conditions in the query definition.

Meeting SLA for all the developments and continuously tracking for the updates to move the project in a smooth way to the target state.

SAP BW/BI Sr Developer InfoTech Enterprises – Hyderabad, India

Dec 2010 to March 2014

Client Description:

(KRC) is the US subsidiary of Kawasaki Heavy Industries Ltd. KRC’s Yonkers, New York, plant is equipped for complete fabrication, assembly, rehabilitation and functional testing of all types of passenger rail cars. KRC also maintains a state of the art manufacturing facility in Lincoln, Nebraska – the first in the United States capable of building different types of cars.

Individual Contribution:

Uploading Master data and Transactional data of Daily, weekly, and Monthly, Data Loads using Process Chains.

Involved in Load Monitoring Using RSPC, RSMO, SM37, and SM50.

Handled the tickets of priority S1, S2 and S3 by following (SOP) Standard Operating Procedures and never missed the (SLA) Service Level Agreement.

Involved in performing Production Support activities like Ticket Analysis report, Resource Utilization Report, Time sheet maintenance of the support team.

Supported the client by providing long-term solutions to the tickets by doing Root cause Analysis.

Involved in creating data source for FI, MM and SD modules and also from flat files.

Created open hub to transfer data from Info Provider to Flat Files for further analysis.

Schedule Daily/Weekly/Monthly data loads schedule new jobs.

Worked on aggregates, export data source, transfer rule, update rule, info source.

Created process chains for data loads for transaction data, master data, and data from finance and Goods movement.

Created reports, web reports.

Process Developer GE Capital – Hyderabad, India

Nov 2007 to Nov 2010

Worked on FCRA (Fair Credit Reporting Act) and ECOA (Equal Credit Opportunity Act) Reporting of Customer Credit Status to the Major Credit Bureaus in USA like Equfax, Innoves and Transunion.

Worked on Reporting of Both Bank and PLCC of the Customer of the major Clients in USA.

Education

Bachelor of Commerce with Computer Science (Osmania University, India)

Attended SAP Trainings in SAP India Labs.

Contact this candidate