Lead Designer & Senior Developer
IBM India Pvt Ltd
(Internet and Information Technology, >10.000 employees)
Keywords
Skills
Experiance:
SAP BW : 14 Years SAP
BW-ABAP : 8 Years
SAP BW on HANA : 6 Years
SAP HANA : 3 Years
SAP BW-IP : 2 Years
SAP Analytics cloud : 1 Year
Certifications:
BW Modeling: Info Areas, Info Object catalogs, Info Objects, Data Sources, Info Sources, DSOs, Cubes, Info sets, MultiProvider, Info Packages, DTPs,
Process Chains creation
BW Extraction: Data source creation (Master data&transaction data) Using Table, Views &Function Module, Data sources Activation & replication to BW,
Data source Enhancements, LO cockpit
BW Reporting: Query Creation with Filters, defaultfilters, Restricted Key figures, Calculated Key Figures, Selections, Formulas, Variables, Structures, Cell definition
Conditions, Exceptions, Formula Variables by replacement path, Exception Aggregations and Customer Exit Variables. Query Views
and Web Application Design, Workbooks, BO Webi reports & Lumira Reports
BW−HANA Objects: ADSO, Composite Providers, Virtual Providers using Function module, calculation views, Data provisioning by using SLT, BODS & DXE.
BW−IP: Planning ADSOs, Characteristic relations, Data Slices, Aggregation Level, Filters, Planning Functions & Planning Sequences.
BW − ABAP: Data Source Enhancement code in c mod, ABAP code in Start Routine, Field Routine, End routine, Expert Routine, Routinesin Info packages Routines in DTP filters, Enhancement code for Virtual Key figures and customer exit variables.
Sap Analytics Cloud: Have hands on experience on data models creation using Live connection using HANA – Views & BW- Queries, Data models creation, Story, Analytic Applications, Table charts, Trending Charts, Page Filters, Widgets, Linking variables, commentaries, book marks.
Optimization Objects: Includes in Start, End and expert routines, Independent classes for Customer Exit Variables.
Performance Tuning: Code optimization for data load performance, Cube compression, Aggregations, Indexes, BIA, Data Achieving
ABAP Objects: T codes, Selection screens, Input parameters, tables, Structures, types, Internal tables, Forms, Function Groups, Function modules, classes.
SAP BW : 14 Years SAP
BW-ABAP : 8 Years
SAP BW on HANA : 6 Years
SAP HANA : 3 Years
SAP BW-IP : 2 Years
SAP Analytics cloud : 1 Year
Certifications:
- SAP HANA – SAP Certified Application Associate (C_HANAIMP14) - May 2015. −
- • SAP BPC – SAP BPC Optimized for SAP S/4HANA - May 2019.
- • SAP BW/4HANA – SAP Certified Application Associate (BW/4HANA 2.X) - May 2021.
- • SAP SAC – SAP Certified Application Associate – (C_SAC_2021) - Feb 2021.
BW Modeling: Info Areas, Info Object catalogs, Info Objects, Data Sources, Info Sources, DSOs, Cubes, Info sets, MultiProvider, Info Packages, DTPs,
Process Chains creation
BW Extraction: Data source creation (Master data&transaction data) Using Table, Views &Function Module, Data sources Activation & replication to BW,
Data source Enhancements, LO cockpit
BW Reporting: Query Creation with Filters, defaultfilters, Restricted Key figures, Calculated Key Figures, Selections, Formulas, Variables, Structures, Cell definition
Conditions, Exceptions, Formula Variables by replacement path, Exception Aggregations and Customer Exit Variables. Query Views
and Web Application Design, Workbooks, BO Webi reports & Lumira Reports
BW−HANA Objects: ADSO, Composite Providers, Virtual Providers using Function module, calculation views, Data provisioning by using SLT, BODS & DXE.
BW−IP: Planning ADSOs, Characteristic relations, Data Slices, Aggregation Level, Filters, Planning Functions & Planning Sequences.
BW − ABAP: Data Source Enhancement code in c mod, ABAP code in Start Routine, Field Routine, End routine, Expert Routine, Routinesin Info packages Routines in DTP filters, Enhancement code for Virtual Key figures and customer exit variables.
Sap Analytics Cloud: Have hands on experience on data models creation using Live connection using HANA – Views & BW- Queries, Data models creation, Story, Analytic Applications, Table charts, Trending Charts, Page Filters, Widgets, Linking variables, commentaries, book marks.
Optimization Objects: Includes in Start, End and expert routines, Independent classes for Customer Exit Variables.
Performance Tuning: Code optimization for data load performance, Cube compression, Aggregations, Indexes, BIA, Data Achieving
ABAP Objects: T codes, Selection screens, Input parameters, tables, Structures, types, Internal tables, Forms, Function Groups, Function modules, classes.
Project history
05/2018
-
Present
Client Name :SHELL
Role : Senior Developer & solution designer
Project Type : Development, Migration, Automation & New Implementations
Environment : BW, BW-ABAP, BW on HANA, BW-IP, SAC
Responsibilities:
• Working as Lead designer for one of the streams in Finance for GPMR Migration
• Working on Migration classic BW object into HANA optimized objects
• Working on ADSO, CPs, Virtual Cubes and other HANA optimized objects
• Working on ABAP code optimization in transformations
• Working on converting C mod logic into Classes for Bex variables
• Working on BW-IP objects developments
• Working on Automated submissions using program
• Worked on testing, transportations, validations
• Working on other migration activities
• Working on SAC Flash Reports
• Handling multiple internal projects (Currently 3) parallelly.
• Working as active member in solutioning team.
• Working on HANA-ABAP Remediation
• Handling Re-Shape design and Country level Commentary POC teams.
Role : Senior Developer & solution designer
Project Type : Development, Migration, Automation & New Implementations
Environment : BW, BW-ABAP, BW on HANA, BW-IP, SAC
Responsibilities:
• Working as Lead designer for one of the streams in Finance for GPMR Migration
• Working on Migration classic BW object into HANA optimized objects
• Working on ADSO, CPs, Virtual Cubes and other HANA optimized objects
• Working on ABAP code optimization in transformations
• Working on converting C mod logic into Classes for Bex variables
• Working on BW-IP objects developments
• Working on Automated submissions using program
• Worked on testing, transportations, validations
• Working on other migration activities
• Working on SAC Flash Reports
• Handling multiple internal projects (Currently 3) parallelly.
• Working as active member in solutioning team.
• Working on HANA-ABAP Remediation
• Handling Re-Shape design and Country level Commentary POC teams.
05/2015
-
04/2018
Technical Team Lead
IBM India Pvt Ltd
(Internet and Information Technology, >10.000 employees)
Client Name : KRAFT FOODS - Mondelez International
Role : Offshore technical lead
Project Type : Development & Migration
Environment : BW, BW-ABAP, BW on HANA, Bex
Responsibilities:
• Created custom defined Info objects, ADSOs, Composite Providers, Hana Views.
• Created transformations, DTP and Info package
• Developed various data extraction procedures for Master Data, for attributes, texts and
• hierarchies and transactional data (Full and Delta) using LO cockpit and generic
• Extractors for customer-defined tables.
• Loaded master data and transaction data for testing reports
• Created process chains for master data and transaction data.
• Involved in transportation objects from development to quality and production.
• Created BI/BW reports using Web Application Designer.
• Involved in designing the Bex Queries and reports according to the user requirements.
• Developed BEx queries using Conditions, Exceptions, Selection, Formula, RKFs, CKFs.
• Developed daily, weekly and monthly process chains and scheduled them accordingly.
• Worked on Multi Provider to compare the Sales data and Plan data.
• Created data source enhancement for both Master as well as Transaction data.
• Working on Migration classic BW object into HANA optimized objects
• Working on ADSO, CPs, Virtual Cubes and other HANA optimized objects
• Working on ABAP code optimization in transformations
• Working on converting C mod logic into Classes for Bex variables
• Worked on testing, transportations, validations
• Working on other migration activities
Role : Offshore technical lead
Project Type : Development & Migration
Environment : BW, BW-ABAP, BW on HANA, Bex
Responsibilities:
• Created custom defined Info objects, ADSOs, Composite Providers, Hana Views.
• Created transformations, DTP and Info package
• Developed various data extraction procedures for Master Data, for attributes, texts and
• hierarchies and transactional data (Full and Delta) using LO cockpit and generic
• Extractors for customer-defined tables.
• Loaded master data and transaction data for testing reports
• Created process chains for master data and transaction data.
• Involved in transportation objects from development to quality and production.
• Created BI/BW reports using Web Application Designer.
• Involved in designing the Bex Queries and reports according to the user requirements.
• Developed BEx queries using Conditions, Exceptions, Selection, Formula, RKFs, CKFs.
• Developed daily, weekly and monthly process chains and scheduled them accordingly.
• Worked on Multi Provider to compare the Sales data and Plan data.
• Created data source enhancement for both Master as well as Transaction data.
• Working on Migration classic BW object into HANA optimized objects
• Working on ADSO, CPs, Virtual Cubes and other HANA optimized objects
• Working on ABAP code optimization in transformations
• Working on converting C mod logic into Classes for Bex variables
• Worked on testing, transportations, validations
• Working on other migration activities
06/2014
-
04/2015
Technical Team Lead
IBM India Pvt Ltd
(Internet and Information Technology, >10.000 employees)
Client Name :Estee Lauder – AMS BI
Role : Technician Lead
Project Type :ProductionSupport &Enhancements
Environment : SAP BI7.0, ECC 6.0 and BI ABAP
Responsibilities:
• working as Sr. SAP BI Consultant since joined in this project.
• Working on data Load Monitoring & Supporting to team while strutting on Load failures.
• Working on Tickets, Defects and Change Requests.
• Working in shifts and weekends and available to team 24/7.
• Supporting team members in incidents & Defects Resolution.
• Involving all types of BI Related works
• Worked on Critical Incidents, Defects and Enhancements
• Working on Performance improvement aspects.
Role : Technician Lead
Project Type :ProductionSupport &Enhancements
Environment : SAP BI7.0, ECC 6.0 and BI ABAP
Responsibilities:
• working as Sr. SAP BI Consultant since joined in this project.
• Working on data Load Monitoring & Supporting to team while strutting on Load failures.
• Working on Tickets, Defects and Change Requests.
• Working in shifts and weekends and available to team 24/7.
• Supporting team members in incidents & Defects Resolution.
• Involving all types of BI Related works
• Worked on Critical Incidents, Defects and Enhancements
• Working on Performance improvement aspects.
10/2013
-
05/2014
Technical Team Lead
IBM India Pvt Ltd
(Internet and Information Technology, >10.000 employees)
Client Name :British Petroleum - WRO
Role : Senior BW consultant
Project Type : Production Support
Environment : SAP BI7.0, ECC 6.0 and BI ABAP
Responsibilities:
• I've been working as Sr. SAP BI Consultant since joined in this project.
• Working on data Load Monitoring & Supporting to team while strutting on load failures.
• Working on Tickets, Defects and Change Requests.
• Working in shifts and weekends and available to team 24/7.
• Supporting team members in incidents & Defects Resolution.
• Managing Team when Team Leader is on Leave.
• Involving all types of BI Related works
• Worked on Critical Incidents, Defects and Enhancements
• Working on Performance improvement aspects.
Role : Senior BW consultant
Project Type : Production Support
Environment : SAP BI7.0, ECC 6.0 and BI ABAP
Responsibilities:
• I've been working as Sr. SAP BI Consultant since joined in this project.
• Working on data Load Monitoring & Supporting to team while strutting on load failures.
• Working on Tickets, Defects and Change Requests.
• Working in shifts and weekends and available to team 24/7.
• Supporting team members in incidents & Defects Resolution.
• Managing Team when Team Leader is on Leave.
• Involving all types of BI Related works
• Worked on Critical Incidents, Defects and Enhancements
• Working on Performance improvement aspects.
01/2012
-
09/2013
Senior Software Engineer
Accenture
(Internet and Information Technology, >10.000 employees)
Client Name :SAB Miller (AO) Role : Senior BI Consultant
Project Type : Production Support
Environment : SAP BI7.0/, SAP GUI 7.0, BEx Analyzer, ECC 6.0 and BI ABAP
Responsibilities:
• Monitoring data loads and Trouble Shooting the Load failures and resolving issues.
• Handled tickets with different priority and involved in multitasking and never missed SLA.
• Actively and regularity involved in Load Monitoring of Daily, weekly, and Monthly data Loads using Process Chains
• Monitor the data Loads from various source systems Like R/3 & Flat Files by means of process chains.
• Monitoring of data loads and analyzing the reasons for frequent failures of info packages.
• Created and scheduled the Error DTP to handle the error records in the Error stack.
• Handled performance tuning of queries by Compression and partition of Info Cubes, Roll ups
• Handling tickets with different priority, and working on never missing the SLA
• Participating in developing the SLA reports at the end of every month
• Participating in submitting the ticket status (Open/ Close) report
• Participating in both the activities monitoring and production support
• Maintaining work history for all the tickets until it is closed down
• Solving many data mismatch tickets by doing back fills
• Maintaining work history for all the tickets until it is closed.
• Involved in maintaining lot of documentation for all the support Activities.
• To communicate with the customer who posted the Ticket.
• Performance tuning using Aggregates, compression, Partitioning of Info Cubes.
• Identified the data model required Incidents as CR and take it as New demand and worked on it
Project Type : Production Support
Environment : SAP BI7.0/, SAP GUI 7.0, BEx Analyzer, ECC 6.0 and BI ABAP
Responsibilities:
• Monitoring data loads and Trouble Shooting the Load failures and resolving issues.
• Handled tickets with different priority and involved in multitasking and never missed SLA.
• Actively and regularity involved in Load Monitoring of Daily, weekly, and Monthly data Loads using Process Chains
• Monitor the data Loads from various source systems Like R/3 & Flat Files by means of process chains.
• Monitoring of data loads and analyzing the reasons for frequent failures of info packages.
• Created and scheduled the Error DTP to handle the error records in the Error stack.
• Handled performance tuning of queries by Compression and partition of Info Cubes, Roll ups
• Handling tickets with different priority, and working on never missing the SLA
• Participating in developing the SLA reports at the end of every month
• Participating in submitting the ticket status (Open/ Close) report
• Participating in both the activities monitoring and production support
• Maintaining work history for all the tickets until it is closed down
• Solving many data mismatch tickets by doing back fills
• Maintaining work history for all the tickets until it is closed.
• Involved in maintaining lot of documentation for all the support Activities.
• To communicate with the customer who posted the Ticket.
• Performance tuning using Aggregates, compression, Partitioning of Info Cubes.
• Identified the data model required Incidents as CR and take it as New demand and worked on it
01/2011
-
12/2011
Senior Software Engineer
Accenture
(Internet and Information Technology, >10.000 employees)
Client Name :Shell Lubes CRM
Role : SAP BI Consultant
Project Type : Implementation
Project Environment : SAP BI7.0/, SAP GUI 7.0, BEx Analyzer, ECC 6.0 and BI ABAP
Responsibilities:
• Expertise in creation of info source, info objects maintenance, transformations.
• Developed customized Info Areas, Info Object Catalogs, Info Objects, Application components, Data sour Transformations, Info packages, and DTPs.
• Used Write-Optimized DSO as staging layer to the extracted data before Loading into the Info cube.
• Used query performance techniques Like Indices, Aggregates, Rollups, Partitioning, Compression, and Line item dimensions
• Saving queries in Workbooks (Excel work sheets).
• Built Queries and presented the results in workbooks by defining rows, columns and free characteristics drill-downs using RRI functionality and other features in BEx.
• Activating the Data Source, Enhancing the Data Source
• Worked extensively on Generic Extraction and used delta mechanism.
Role : SAP BI Consultant
Project Type : Implementation
Project Environment : SAP BI7.0/, SAP GUI 7.0, BEx Analyzer, ECC 6.0 and BI ABAP
Responsibilities:
• Expertise in creation of info source, info objects maintenance, transformations.
• Developed customized Info Areas, Info Object Catalogs, Info Objects, Application components, Data sour Transformations, Info packages, and DTPs.
• Used Write-Optimized DSO as staging layer to the extracted data before Loading into the Info cube.
• Used query performance techniques Like Indices, Aggregates, Rollups, Partitioning, Compression, and Line item dimensions
• Saving queries in Workbooks (Excel work sheets).
• Built Queries and presented the results in workbooks by defining rows, columns and free characteristics drill-downs using RRI functionality and other features in BEx.
• Activating the Data Source, Enhancing the Data Source
• Worked extensively on Generic Extraction and used delta mechanism.
03/2007
-
12/2010
Software Engineer
Accenture
(Internet and Information Technology, >10.000 employees)
Client Name :Ericson – Application Development
Role : SAP BI Consultant
Project Type : Implementation
Project Environment : SAP BI7.0/, SAP GUI 7.0, BEx Analyzer, ECC 6.0 and BI ABAP
Responsibilities:
• Created custom defined Info objects, info cube, info sets and multiproviders.
• Created transformations, DTP and Info package
• Developed various data extraction procedures for Master Data, for attributes, texts and
• hierarchies and transactional data (Full and Delta) using LO cockpit and generic
• Extractors for customer-defined tables.
• Loaded master data and transaction data for testing reports
• Created process chains for master data and transaction data.
• Involved in transportation objects from development to quality and production.
• Created BI/BW reports using Web Application Designer.
• Involved in designing the Bex Queries and reports according to the user requirements.
• Developed BEx queries using Conditions, Exceptions, Selection, Formula, RKFs, CKFs.
• Developed daily, weekly and monthly process chains and scheduled them accordingly.
• Worked on Multi Provider to compare the Sales data and Plan data
Role : SAP BI Consultant
Project Type : Implementation
Project Environment : SAP BI7.0/, SAP GUI 7.0, BEx Analyzer, ECC 6.0 and BI ABAP
Responsibilities:
• Created custom defined Info objects, info cube, info sets and multiproviders.
• Created transformations, DTP and Info package
• Developed various data extraction procedures for Master Data, for attributes, texts and
• hierarchies and transactional data (Full and Delta) using LO cockpit and generic
• Extractors for customer-defined tables.
• Loaded master data and transaction data for testing reports
• Created process chains for master data and transaction data.
• Involved in transportation objects from development to quality and production.
• Created BI/BW reports using Web Application Designer.
• Involved in designing the Bex Queries and reports according to the user requirements.
• Developed BEx queries using Conditions, Exceptions, Selection, Formula, RKFs, CKFs.
• Developed daily, weekly and monthly process chains and scheduled them accordingly.
• Worked on Multi Provider to compare the Sales data and Plan data
Local Availability
Only available in these countries:
India
Only can do from offshore
Other
Experience: 14 years’ experience in SAP & 2+ years in Banking
SAP BW : 14 Years
SAP BW-ABAP : 8 Years
SAP BW on HANA : 6 Years
SAP HANA : 5 Years
SAP BW-IP : 2 Years
SAP SAC : 1 Year
Knowledge : MS Power BI Reporting
SAP BW : 14 Years
SAP BW-ABAP : 8 Years
SAP BW on HANA : 6 Years
SAP HANA : 5 Years
SAP BW-IP : 2 Years
SAP SAC : 1 Year
Knowledge : MS Power BI Reporting
