Saveen K. Email & Phone Number

Cypress, Ca, Us

Pennsylvania, United States

1. Analyze business requirements (functional and technical requirements, information needs, business processes), conduct information -gathering workshops with client, propose and implement solution. Design, build and publish SAP SD, SAP FI and SAP CRM reports based on approved technical specifications. Driving overall project delivery right from system Analysis, Blueprinting, Realization, Testing documentation till Go Live.2. Reviewing Functional design document (FDD), providing estimation of Data Flows (SAP & Non – SAP) & report development (Bex. Query, Webi & Crystal) based on complexity, object type and Preparing Technical Design document (TDD) for new report development and enhancement that contains detailed technical aspects.3. Developed key information models like Calculation views, ADSOs, Multiproviders, SAP ABAP CDS View, Open ODS Views, Info objects, Info-cubes and Composite Providers. Implemented complex business logics in start, field, expert and end routine using SAP ABAP and Hana SQL.4.Designed HANA data models (attribute, analytical and calculation views) and stored procedures Implemented data provisioning using SLT, DXC.

Bellevue, Washington

• Gathering requirements from the end users and preparing business requirement documents and get reconfirmation from the business users.Created CDS view to Flattened P/L Hierarchy in S/4 Hana, loaded it to ADSO then used it in Calculation view to combine with FIGL data.• Designed HANA data models (attribute, analytical and calculation views) and stored procedures Implemented data provisioning using SLT, DXC.• Worked on ABAP routines such as Start Routines, End Routines, and Field Routines. Converted ABAP routines to AMDP to push down logic to data base.• Lead BW HANA 7.5/BW4Hana upgrade project and guided team to resolve post upgrade data and performance issues.• Designed HANA data models (attribute, analytical and calculation views) and stored procedures Implemented data provisioning using SLT, SDA.• Worked on Composite provider by creating virtual providers using HANA views to design the report on actual data which is coming from BW and planning data ‘which being uploaded’ from flat file into HANA table. Created SAP Hana Graphical views and star joins as per the business requirement.• Worked on Open ODS view and created reports on this for prototype of design. Extensively worked on BW Virtual providers based on HANA views to get the data from HANA. And created BW Real time reports using these virtual providers. Worked on SLT to replicate ECC tables for various functional areas to meet user’s report requirement. •Exposed ADSO/ Master data as Hana views and used them as source to Calculation views.• Created composite provider based on calculation view and ODSO. Exposing the views to be consumed in visualization tools like SAP BOBJ, Tableau.• Worked on ABAP routines such as Start Routines, End Routines, and Field Routines.

Chandigarh Area, India

- Handling day-to-day monitoring activities in SAP-BI and ensuring successful data loads

Chandigarh Area, India

• Interacted with customers and Developed a high level implementation plan, selected project team, training plan• Determine Landscape and Transport Strategy along Basis team, Acquire, Install and Test the Technical Environment (hardware, software, database, desk top and connectivity - Basis)• Finalized a list of pre-delivered business contents to be activated by functional components, data sources, Info Cubes, Info Objects, Queries, and roles• Assigned responsibility for each components Agree upon the instrument (template) to record the test result and additional requirements, Develop evaluation criteria and test plan, Check database parameter setup for performance Prepare end user training material• Spearheaded Business Contents Activation, Populate SAP delivered business contents with customer data, Verify the content activation Result, Conduct End User Training• Conducted System Tests with End User Feedback, Conduct Volume Test, System Performance Tuning,• Coordinated and Implement Production Scheduling, Develop a BW Operations Guide• Enhanced Operations Guide, Monitoring and addressing production issues, if any. End user support, Project Go-live Review, Define the Scope of next Iteration of Implementation

Chandigarh Area, India

Designed, developed, tested and implemented BW Objects for Pepsico SD and LO Modules. Responsible for creating reports to facilitate demand planning, Shop Floor Planning and Inventory Management. Also responsible for performance tuning; resolving loading issues and Query performance issues. Gathered Business Requirements and Conducted Gap Analysis to install Business Content.• Designed & Developed custom Data Source, Info Source, Extractor, Info Cube and ODS to fulfill user requirements.• Developed Transfer rules, Update rules and Start routines using ABAP to incorporate Business logic and perform data manipulation.• Extensively worked on transporting objects between BW system environments and corresponding SAP R/3.• Developed data loading strategies for master data, transactional data and delta uploads. • Created process chains for data loading, delta uploading and periodical PSA deletion. • Created MultiProviders on sales and delivery cubes to assist reporting on sales and delivery together. • Worked on Creating Aggregates, Compressions, Indexes, Multi Cubes and parallel setups for data loading to improve performance and utilize data effectively. • Extensively worked on Query Designer and Web application designer to create Queries to forecast sales, budget and delivery analysis using Restricted Key Figures, Calculated Key Figures, Variables, filters and exceptions.• Using Control-m agent to monitor batch jobs. HP Service Manager 7 for ticket assignment and status of tickets.• Involved in documentation and end-user training.• 24*7 on-call production support

Portland, Oregon Area

• Job monitoring and scheduling Process Chains and Fixing Process Chain failures during data extraction. Analyzed and corrected the load failure.• Manual data load using Flat files whenever user wants to load file.• Involved in tuning the performance of the system.• Actively Involved in Rectification of Load Failure errors like Master Data Loads, Transaction Loads. • Experience in the Transport Management activity of importing the transports among various SAP systems• Generated and maintained aggregates and rollup activities on info Cubes as part of the info Cube management• Creation & Modifications of queries as per the NG business Request.• Handling the tickets raised by the market. (P3, P4, P5)• Change Request based development of BW objects. Delivery from offshore with a team of 3 BW Consultants.• Worked in the R/3 side for adding fields in Generic Data Source and standard extractor.

Greater Chicago Area

Responsibilities: • Lead a 16 member offshore team through the preparation of high level design, detail design, development, testing and migration of SAP BI back end objects and reports.• Gather requirements from process & business teams • Work with technical team in developing estimates and creating the project timeline documents for development and testing phase• Transport coordination, process adherence and quality control for BI team• Worked as a BW Consultant on enhancements, implementation as well as production support• Working on BW on HANA system including projects, enhancements and Support.• Worked on Inventory and Shrink reports including implementation for Store Cycle counts automation through BW. Achievements: 1) Delivered all objects with minimum defects under strict timelines2) Only team in the project to deliver all objects before the deadlines3) Worked closely with other software vendors of the client in coming up with unified reporting interfaces for add-on systems in the utilities industry

Chandigarh Area, India

 SAP Business Warehouse (BW) Full Live implementation experience. Worked in data modeling using BIW extended star schema models as per the business requirement  Extensively worked on administrative workbench for defining Info Objects, InfoCubes, MultiProviders, aggregates, ODS, InfoSets  Created transfer rules, application specific update rules Expertise in scheduling and monitoring of data flow to InfoCubes, ODS objects through process chains  Configured and implemented BW reporting using BeX analyzer/browser Lo Cockpit, LIS Extraction, Flat File Extraction, Exposure to generic Extraction, Activating DataSources , Deleting Setup Tables, and Data Loading. Well conversant in data staging (PSA and ODS to info Cubes), data monitoring. Conceptual Knowledge and hands on experience of ABAP Object Data Dictionary, Internal Table, Exits ,Reports. Excellent organizational, leadership, communication and documentation skills.

Chandigarh Area, India

• Responsible to gather requirements from business users and coordinate between onsite and offshore team.• Involved in converting the requirement document into functional and Technical design documents.• Responsible for developing Cube, DSO, Multi Providers, Transformations, DTPs and handled test loads using Transformations, Info Packages, DTPs to verify BI 7.0 functionality.• Worked on Generic, File system and LO Extraction.• Involved in the enhancement of data sources, appended the vital fields by writing the exit code.• Transported various objects from BID to BIQ to BIP after completion of successful testing by using SE09 and STMS.• Created custom queries and defined Calculated Key Figures, Restricted Key Figures, Text Variables, etc. For customized reporting using BEx Analyzer, Designed and developed several workbooks and global views.• Created routines in Transformation as per customer requirement.• Created Webi Reports using various functionalities like cross tab, conditional formats, Break, Built in functions.

Bangalore

• Job monitoring and scheduling Process Chains and Fixing Process Chain failures during data extraction. Analyzed and corrected the load failure.• Manual data load using Flat files whenever user wants to load file.• Involved in tuning the performance of the system.• Actively Involved in Rectification of Load Failure errors like Master Data Loads, Transaction Loads. • Experience in the Transport Management activity of importing the transports among various SAP systems• Generated and maintained aggregates and rollup activities on info Cubes as part of the info Cube management• Creation & Modifications of queries as per the NG business Request.• Handling the tickets raised by the market. (P3, P4, P5)• Change Request based development of BW objects. Delivery from offshore with a team of 3 BW Consultants.• Worked in the R/3 side for adding fields in Generic Data Source and standard extractor.

Chennai Area, India

• Responsible for the Production Support Activities performed at Offshore• Monitored the Loads of master data and transactional data through process chains• As part of loading we schedule the process chains on daily, weekly and monthly basis to load the data into respective targets• Monitored Process Chains and Meta Chains, worked to fix errors; Sid issues, duplicate data records, Activation of DSO errors, memory issues and Timestamp errors, etc. with respective corrections• Performed Data Extraction and Data Staging using LO Cockpit (LBWE), loaded the data from ECC6.0 to BI7.0 used Initialization with Delta Update methods• Involved in planning of Data reloads activities• Worked on Broadcasting and pre calculation servers, Created Broadcast setting for queries and workbooks to publish the reports to the users via E-Mail• Performing test data loads in mirror systems before transporting changes to production server.• Involved in solving tickets regarding extractions, Performance Issues and also load failures.• Worked on BI stabilization project where the teams from SAP and service teams are involved to stabilize the system and improve the data load SLA’s.• Proposed many Process Improvement Plans (PIPs) which were implemented for best practice

Bachelor’S Degree, Electronics And Communication, First Class With Distinction

Activities and Societies: Debate Team

Intermediate, Non-Medical, First Class