Skills
- 5.2 years of experience in SAP BW/BI (Business information warehouse/Business Intelligence) and 3 years of experience in ITES (Thomson Reuters).
- Over all 8 years of corporate Experience.
- Involved in 5 BW implementations, 1 BW support project and 2 other support (BODS, BOBJ).
- Experience in BW 7.0, 7.3, 7.4 and SAP BW on HANA (BW 7.5).
- As a SAP BW/BI Consultant involved in Data-Modelling, Data Extraction, Data Loading, Scheduling, Monitoring and Reporting.
- Worked on SAP HANA Studio: Advanced DSO Creation and Maintenance.
- Exposure in BEx Query Designer and Analyzer in building queries and created custom queries using filters, restricted key figures, calculated key and variables.
- Good Knowledge of modules like SD, MM, CO, FI, COPA and PS.
- Involved in ABAP coding on routines, variable exits (RSR00001) and data source enhancements (RSAP0001).
- Client coordination, work estimation, technical development, work delivery and status reporting for the pending issues.
- Involved in Transforming the Functional Requirements to Technical documents.
- Basic knowledge on SAP HANA.
Project history
PROJECT-1
Project Type : SAP BW Development.
Company : Deloitte Consulting India Pvt. Ltd
Client : USL (United Spirits Ltd).
Tenure : March 2016 to till date.
Environment : SAP ECC 6.0, SAP BW 7.5 on HANA.
Functional Area : COPA, Inventory, Asset Accounting AND CO.
Role : SAP BW Consultant.
Description:
United Spirits Limited (USL) is a subsidiary of Diageo plc which is a global leader in beverage alcohol with an outstanding collection of brands across
spirits, beer and wine categories.
Responsibilities:
- Involved in creation of Advanced DSO (ADSO) using SAP HANA Studio.
- Developed custom InfoObject, InfoCube, DSO, Transformation and DTP for specific user
- Worked on ABAP routines – Infopackage routine, start routine, end routine, field level Routine.
- Involved in BEx variable exits for achieving YTD Logic.
- Worked on Unit conversion and currency conversion.
- Implemented Analysis Process & Design (APD) to transfer data from BEx query to DSO.
- Involved in developing Bex Reports using Filters, Restricted Key Figures, Calculated Key Figure and Variables.
- Extensively involved in setting up the procedures for LO Cockpit, involved in activating the business content data Sources, maintaining the Extract Structure, generating the Data Source.
- Implemented COPA module: Creation of COPA data source 1_CO_PA_XXXX_XXX and recreation of data source.
- Worked on Leading and non-leading data sources.
- Transport Management: Collection of object, releasing request, importing the requests.
- Involved in creation of process chains, schedule and monitor.
Project Type : SAP BIBO Development & Implementation.
Company : Deloitte Consulting India Pvt. Ltd
Client : Alcon Inc.
Tenure : Jan 2015 to Feb 2016.
Environment : SAP ECC 6.0, SAP BI 7.4 on HANA.
Functional Area : SD, MM, PM, FI AND CO.
Role : SAP BW/BI Consultant.
Description:
Alcon is a global medical company specializing in eye care products. Alcon's U.S. headquarters are located in Fort Worth, Texas. Alcon has been purchased by Novartis from Nestlé and there have been confirmed information indicating high likelihood that Alcon will soon also be merged with the new parent company.
Responsibilities:
Modeling:
- Involved in creation of process chains, schedule and monitor.
- Worked on performance tuning on data loads.
- Developed the ad-hoc data loading tool.
- Developed custom InfoObject, InfoCube, DSO, Transformation and DTP for specific user
- Created DSO to stage the data before transferring DSO contents into InfoCube.
- Uploaded master and transaction data from OLTP source.
- Involved in creating Generic Extractors using Tables and Function Module.
- Involved in Data Loading (Full/Delta Up-Load), Scheduling, monitoring, working with master data, transaction data.
- Uploaded Transaction Data from the Flat Files as the Source System.
- Involved in Technical document updates.
- Data Extractions:
- Extensively involved in setting up the procedures for LO Cockpit, involved in activating the business content data Sources, maintaining the Extract Structure, generating the Data Source.
- Enhancing the Data Source and Using the Enhancement RSAP0001 to fill the data into the enhanced Fields.
- Involved in creating generic extractors using Tables and Function Module.
- Collection of objects for Transportation.
Project Type : BW Support and monitoring.
Company : Deloitte Consulting India Pvt. Ltd
Client : Bank of America.
Tenure : April 2014 to Dec 2014.
Environment : SAP ECC 6.0, SAP BI 7.3.
Role : Support and monitoring
Description:
The client is an American multinational banking and financial services corporation. It is the largest bank holding company in the United States by assets. As of 2010, it is the fifth-largest company in the United States by total revenue, as well as the third-largest non-oil company in the U.S. In 2010, Forbes listed this client as the 3rd biggest company in the world.
Responsibilities:
- Actively and regularly involved in load monitoring of daily, weekly, and monthly, data Loads using Process Chains.
- Actively Involved in Rectification of Load Failure errors like Master Data Loads, Transaction Loads. Monitoring of info packages and analyzing the reasons for frequent failures of info packages.
- Analyze the errors in the data loads and report to the corresponding team
- Handled tickets with different priority and never missed the SLA.
- Triggering the process chains giving update to control room till the task are completed.
- Validating different object from Development to Quality to Production system.
- Analysis of process chain runtime and record count for daily, Weekly & Monthly process chain.
- Involved in SPO Rotation and rebuilding BWA Index.
Project Type : BO Development & Implementation.
Company : Deloitte Consulting India Pvt. Ltd
Client : WellPoint Inc.
Tenure : Sept 2013 to April 2014.
Environment : SAP BOBJ.
Functional Area : SD, MM, PM, FI and CO.
Role : BO Developer.
Description:
WellPoint, Inc. is the largest managed health care, for-profit company in the Blue Cross and Blue Shield Association. It was formed when WellPoint Health Networks, Inc. merged into Anthem, Inc., with the surviving Anthem adopting the name, WellPoint, Inc.
Responsibilities:
- Interact with the Onsite team in order to collect the requirements for the new crystal reports to be developed.
- Analyze the given mock reports; identify the measures & dimensions and mapping fields.
- Analyze the functional logic, create report books, reviewed and get approved by Client.
- Writing SQL queries for the report books to extract data from Edward database.
- Involved in Transforming the Functional Requirements to Technical documents.
- Prepare daily development status and discuss with the onsite team on daily basis and customers on a weekly basis on the progress of the work.
PROJECT-5
Project Type : BODS Development & Implementation.
Company : Rolta India Limited.
Client : Salalah Methanol Company LLC (SMC).
Tenure : April 2013 to July2013.
Environment : SAP ECC 6.0, BODS.
Functional Area : SD, MM,PM, FI AND CO.
Role : Sr SAP BI Consultant & Team Co-ordinator.
Description: Salalah Methanol Company LLC (SMC) is a methanol production facility in Salalah free zone located near the port of Salalah. Founded in February 2006, the plant is wholly owned by Oman Oil Company (OOC).
Responsibilities:
- Involved in technical specification and business blue print based on functional specifications.
- Activated Business Content datasources and maintain entry in ROOSATTR table as its part of BODS extraction.
- Extensively involved in setting up the procedures for LO cockpit, involving activating the business content data Sources, maintaining the extract structure, generating the data Source, activating the data source, Enhancing the Data Source and Using the Enhancement RSAP0001 to fill the data into the enhanced Fields.
- Involved in creating Generic Extractors using Tables/View and Domain.
- Acts as an effective bridge between the Project Manager and the team.
Company : Rolta India Limited.
Client : Advanced Petrochemical Company (ADVANCED).
Tenure : Aug 2012 to Mar 2013.
Environment : SAP ECC 6.0, SAP BI 7.3.
Functional Area : SD, MM,PM, FI AND CO.
Role : Sr SAP BI Consultant & Team Co-ordinator.
Description:
Advanced Petrochemical Company (ADVANCED), is a Saudi joint stock venture, commercial production was started in the first quarter of 2008. The facility produces 450 thousands tones per year of polypropylene.
Responsibilities:
- Modeling:
- Installation of standard delivered business content Cubes.
- Developed custom InfoObject, InfoCube, DSO, Transformation and DTP for specific user
- Involved in creating Generic Extractors using Tables and Function Module.
- Involved in Data Loading (Full/Delta Up-Load), Scheduling, Monitoring, working with Master Data, Transaction Data and Cube Compression as part of BI 7.3.
- Involved in maintaining Multi Providers.
- Uploaded Transaction Data from the Flat Files as the Source System.
- Data Extractions:
- Extensively Involved in Setting up the procedures for LO Cockpit, Involving Activating the Business Content Data Sources, Maintaining the Extract Structure, Generating the Data Source, Activating the Data Source, Enhancing the Data Source and Using the Enhancement RSAP0001 to fill the data into the enhanced Fields.
- Involved in creating Generic Extractors using Tables and Function Module.
- Reporting:
- Understanding the specifications provided by the functional consultants, and interacting with functional team to get to know the exact business requirements, suggest them the changes that are required and then develop the objects as per the revised specifications.
- Involved in developing BEx Reports using BEx BEx Query, Involved in Creation of Reports using Filters, Restricted Key Figures, Calculated Key Figures, Variables, Exceptions and Conditions.
Company : Hages Busniess Solutions Pvt Ltd.
Client : Mathrubhumi.
Tenure : Jan 2012 to July 2012.
Environment : SAP ECC 6.0, SAP BI 7.0.
Functional Area : SD, MM,PM, FI AND CO.
Role : Sr SAP BI Consultant & Team Co-ordinator.
Description:
Mathrubhumi is a Malayalam language newspaper that is published from Kerala, Mathrubhumi was founded by K. P. Kesava Menon, an active volunteer in the Indian freedom struggle against the British. Based in the northern Kerala town of Kozhikode (Calicut), Mathrubhumi was founded in 1923 in the aftermath of Gandhi's non-cooperation movement as a public limited company.
Responsibilities:
Developed custom InfoObject, InfoCube, DSO, Transformation and DTP for specific user requirement.
- Created DSO to stage the data before transferring DSO contents into InfoCube.
- Worked on Performance Tuning using the concepts of Aggregates, Compression, Indexing and Partitioning.
- Uploaded master and transaction data from OLTP source.
- Involved in Data Loading (Full/Delta Up-Load), Scheduling, and Monitoring, working with Master Data, Transaction Data and Cube Compression as part of BI 7.0.
- Involved in maintaining Multi Providers.
Company : Hages Busniess Solutions Pvt Ltd.
Client : Amara Raja Batteries Limited.
Tenure : May 2011 to Dec2011.
Environment : SAP ECC 6.0, SAP BI 7.0.
Functional Area : SD, MM,PM, FI and CO.
Role : SAP BI Consultant.
Description:
The Amara Raja Group is better known for its automotive battery brand "Amaron" which is the second largest selling automotive battery brand in India today.
Responsibilities:
- Modeling:
- Installation of standard delivered business content Cubes.
- Developed custom InfoObject, InfoCube, DSO, Transformation, and DTP for specific user requirement.
- Involved in creating Generic Extractors using Tables, Domains and Function Module.
- Involved in Data Loading (Full/Delta Up-Load), Scheduling and Monitoring.
- Involved in maintaining Multi Providers.
- Uploaded Transaction Data from the Flat Files as the Source System.
- Data Extractions:
- Extensively Involved in Setting up the procedures for LO Cockpit, Involving Activating the Business Content Data Sources, Maintaining the Extract Structure, Generating the Data Source, Activating the Data Source, Enhancing the Data Source and Using the Enhancement RSAP0001 to fill the data into the enhanced Fields.
- Reporting:
- Involved in developing BEx Reports using BEx Analyzer & BEx Query designer.
- Designed Reports as per reporting requirements, the reports includes Sales Order Details, Customer Details, and Sales Overview etc. using Query Designer.
- Involved in Creation of Reports using Filters, Restricted Key Figures, Calculated Key Figures, Variables, Exceptions & Conditions.
Involved in Creating WEBI (BO) Reports Based on BEX and Universe. Creating variables and prompts based on Requirement.
Local Availability
Only available in these countries:
India
I flexible to work any where in the world.
