RAJAT S.

RAJAT S.

SAP Analytics Consultant

Delhi ,

Experience: Year

RAJAT

Delhi ,

SAP Analytics Consultant

USD / Year

  • Start Date / Notice Period end date:

Year

Now you can Instantly Chat with RAJAT!

About Me

Highly committed and skilled technical professional having around 7 plus years of experience in SAP BI/BO/BW with Hana implementation and support projects in different domains. Extensive knowledge of data visualization tools specially SAP BO & Micros...

Show More

Portfolio Projects

Description

Involves in requirement gathering with users and functional consultants. Development of Bex/BO report/dashboards as per the requirements from scratch till the final outcome. Changes in existing reports as a part of enhancement as per the usersrequirement. Training and development related to SAP BW/BO to end user. Interactive dashboard designing in Lumira and Web Intelligence. Development of core logical Scripted based Hana Calculation Views. Working as an individual contributor and completes report development before the timelines. Involved in implementation of our subsidiary in Orissa, complete BW processes implementation from scratch. Involved in a little bit of prediction analysis projects as well using Python, Hadoop and R language.

Show More Show Less

Description

Dailymonitoring ofthe process chains inorder tomake sure that data loading should be done successfully to all the data targets respectively. Changes in existing reports as a part of enhancement as per the usersrequirement. Developed a report related to Pharma domain showing near expiry stocks and developed a configuration in BO for automatically broadcasting of the same to the related stakeholders. Developed a dashboard showing a particular divisions sale for every month. Developed a very complex report showing each and every FOs, ABMs and SMs field efforts on a click and then scheduled it to the related stakeholders. Working as an individual contributor and solving tickets of users with appreciation. Creation of views on the basis of logics provided by functional side and then creation of data sources and replication same in the BW system to go ahead with the data model further. Performed data extraction, transformation and loading from SAP and non- SAP source systemsintotheSAP BW. Activating the business content according to the functional requirements and developed various custom cubes both enhanced and generic cubes. Worked extensively with other databases as well in order to develop reports in BW and then representtheminWeb-Intelligenceusing complexformulasandvariables. Extensive knowledge of BO especially Web Intelligence. Ticketsresolving consistingofanychangesasper the client. Formulachanging inthequeries in the BW system as well as in the Web Intelligence. ETL development (Cube, ADSOs, Composite providers, Transformation and Data source), Query designanddevelopment(BEx& Web), Enhancementfor different modules like Sales & Distribution, CRM, Purchasing andWarehousing. Objectstransportingacrossthelandscape. Infopackages error detectionwhileloading thedata tothe PSA. Communication with the users and top management as well in order to gather their requirement and then develop reports and dashboards.

Show More Show Less

Description

Daily Data load Monitoring of the BW jobs. Ensured daily data load from R/3 to BW is successful. Created FI-GL jobs for G/L line Item Data to get the account balances and transaction figures. Performed data extraction, transformation and loading from SAP and non- SAP source systems into the SAP BW. Activating the business content according to the functional requirements and developed various custom cubes both enhanced and generic cubes. Worked extensively with 0FI_ACDOCA_10 (Universal journal Entry) Extractor and developed a cube to calculate Gross margin report for the top management. Extensively used reporting agent to make efficient use of BEx reporting functionalities like exception reporting, background printing and pre- calculated value sets Tickets resolving consisting of any changes as per the client. Formula changing in the queries. ETL development (Cube, ADSOs, Composite providers, Transformation and Data source), Query design and development (BEx & WebI), Enhancement for different modules like Sales & Distribution, CRM, Purchasing and Warehousing. Objects transporting across the landscape. Unit testing, performance testing and integration testing. Info packages error detection while loading the data to the PSA. Maintaining work history for all tickets until it is closed down. Communication with the customers in order to get the detail regarding the tickets raised. High level of customer service providing by solving the tickets at the earliest and to satisfy the customer.

Show More Show Less

Description

Daily monitoring of the process chains in order to monitor the loads. Modification in reports as per the requirement. Formula changing in the queries. ETL development (Cube, DSO, Transformation and Data source), Query design and development (BEx & Web), Enhancement for different modules like Sales & Distribution, CRM, Purchasing andWarehousing. Transporting of the objects from Dev to Prod and monitoring targetsystem. Unit testing, performance testing and integration testing. Monitoring of info packages and analyzing the reasons for failures of infopackages Job logs overview in SM37 and tRFC IDOCS execution in sm58,sm50. Maintaining reconciliations toverify the data in SAP R/3and SAP BW are same or not after data loads. Maintaining work history for all tickets until it is closed down. To communicate with customer who posted the tickets. Resolved the customer posted tickets through main. Provided high level of customer service to end users, business units andgroups. Daily monitoring of info cubes and ODS objects requests. Presentations to business client on the BW reports for their sign off. Performed extractions from SAP R/3 system or non-SAP systems to SAP BI/BW system using different extraction mechanisms. As part of existing BW team focused on Unit Testing, Integration testing, Extractor testing and enhancements. Extracted data from line item data sources like 0FI_GL_4, 0FI_AR_4, 0FI_AP_4 and 0FI_GL_7.

Show More Show Less

Description

Gathered user requirements for data modeling, and modeled the custom cube along with activation of business content and designed documentation for development. Did Gap analysis between Blue print and Business Content. Designed Developed and Modified Info Objects, Info Sources and Info Cubes and loaded these objects with Master data and Transactional data from SAP R/3 and flat files by creating Info Packages. Extensively worked in Data Mapping Fields between R/3 and BW for Info Cubes. Created Variables, Filters, Exceptions, Calculated key figures, restricted key figures, Global and Local structures and other features to meet user requirement. Conducted BI presentations, End Users Training, Documentations, Knowledge Transfer Sessions Extensively built Info Objects, Info Sources, Info Packages, ODS, Info Cubes Worked on DTP to transfer the data to Info cube and DSO. Developed business process documentation. Created TS/FS/TestCases templates, migrated objects from development to quality and from quality to production. Customized and managed the modeling of BW. Have created Queries (reports) mainly for SD, FI, MM. Created workbooks over the Queries and maintained via Process chains. Enhanced SAP Business Content to meet business requirement. Designed, developed and tested queries based on infoProvider with Bex. Generated and analyzed sales reports and financial reports. Verified sales data and financial data. Involved in the requirement gathering of the industry specific IS-OIL R/3 data Analyzed data requirements and translated these requirements into dimensional data models for FI. LoadedMaster andTransactional data from R/3 system and flatfiles into BW system. Developed Sales report to display territory sales based on customer, products, product types, and fiscal year. Worked on reports such as Vendor master data, Open Sales order report, Material pricing report, Daybook report, Accrual Balance report, Assets Depreciation, Assets retirement report etc. Provided Knowledge Transfer to the entry level employees. Monitored and evaluated their work. Trained users in creating Ad-Hoc reports using BEx Analyzer.

Show More Show Less

Description

SAP BI Extraction Starting from the functional specifications, understood the requirements of users through underlying tables, interacted with international clients to discuss requirements in FS (like keys of tables, granularity etc.) and understood their requirements based on FS to decide the design in BI. SAP BI Extraction (LO, GENERIC Data Source(RSO2), Flat Files) Extensively worked on Logistics(LO) Extraction, which includes activating the Data Source, Customizing the Data Source, Generating the Data Source, Deleting and running the Setup tables , Setting up the V3 update job to enable delta loads. Selected the fields as per requirements through LBWE for Logistics data sources. Extensively worked on creating Generic Data Sources using function module or Table/View where Standard Data Sources notsupporting. Enhanced the data sources through BADI. Worked on the various data sources (both generic and SAP supplied) as per the requirements gathered from the client. Based on the requirements, suggested solutions, designed the dataflow from source to BI. SAP BI Data Modeling: Proficient in data modeling, creation of custom info area, Info Cubes, DSOs, multi providers, Transformations, info sources, DTPs, aggregates, virtual providers, Info packages as per naming conventions. Also, installed relevant SAP Business Content as and when required. Gathered and implemented the requirements in BI system. Written basic start and field routines as and when required while implementing the requirements. After completion of development, sit with the users to present the comparison of reconciled data appearing in BI reports with the data in tables in ECC side. This presentation had been a part of functional user testing. Creation of Advance DSOs (ADSO) and Composite providers on the basis of requirement as per the data model.

Show More Show Less
Share: