Professional Summary:
** ***** ** ** ********** in Data Analytics which includes 10+ years of experience in SAP BI / BW with 4+ years `of experience in SAP BW on HANA/SAP BW4HANA with 1+ years of experience in SAP Embedded Analytics (CDS Views) and 2+ years of experience in SAP MDG
Developer, Consultant, Tech Lead, Architect, Project Manager through the projects.
Fresh end to end Implementations, Rollouts, Technical & Functional Upgrades, Enhancement projects, Green field Implementations using both ASAP and Activate Methodologies
Experience in multiple domains – Consumer goods industry, Oil & Gas, Industrial, Manufacturing, Utilities
Worked on S/4 Embedded Analytics, creating and enhancing CDS views.
Experience in Information Technology industry with SAP BW/HANA/(BW/4 HANA, BW 7.5, BW, BW 7.3, BI 7.0, BW 3.5, BW 3.0B), SAP ECC, SAP CRM, SAP SCEM, SAP MDG and S/4.
Well experienced in requirement gathering, technical analysis, Estimation, design, development, Testing
Hands-on experience of entire ETL process, Analytics & Visualization. Including customization beginning at Data source extractor to Dataflow in BW, building Queries and deploying to BO tools
Experience in all stages of projects from Identifying the requirement, Business Blueprint, Analyzing Requirement, Defining project plan, identifying resources, setting Project timelines and delivery schedules in accordance with business availability, Documenting the Functional &Technical Specification and setting up the Test plan and Quality controls, Getting Approvals, Development and Implementation, UAT & Regression testing, training business in features & process and finally planning and deploying the releases in time.
Expert in Requirement gathering, Workshop preparations, Developed Project plans, support plans, cut over plans, SAP BW/BI data model design and deployment.
Experience in extracting data from ERP and non-ERP systems using standard and custom extractors.
Experienced in SD, MM, FI, CO and HR, PM, PP, CRM, Extraction.
Implemented SAP BW 7.3 and SAP BW 7.5 on HANA and SAP BW4HANA environment, Worked on latest Data Modeling objects such as Composite Info providers, ADSO’s, ODP extraction, Open ODS Views, CDS Views Based Datasources, Hybrid data models.
Co-ordinate with technical BI development team to resolve the issues in BI report development.
Conduct BI reporting (Bex, BO/WEBI, Dashboards & Crystal) features workshop with business users.
Involved in BW on HANA Migration Projects and worked on post migration and pre migration activities.
Experienced on Eclipse based Modelling, SAP HANA Studio and Fiori based BW Cockpit
Good understanding of data provisioning using SLT/SDI/SDA and pulling data from legacy systems and SAP systems.
Having experience on creating CDS views and generic extractors using CDS views.
Experienced on LSA++ architecture and ODP enabled data sources.
Worked on Analysis for office, Tableau for generating reports.
Good exposure to SAC
Education:
Bachelor of Engineering from Mumbai University, India
Technical Skills:
ERP: S4HANA, SAP ECC 6.0, SAP HANA 1.0, 2.0, BW/4 HANA, SAP BW on HANA
Reporting Tools: SAP web intelligence, Bex, Analysis office, tableau, SAC
Programming language: SAP ABAP, HANA SQL
Operating systems: Windows 8/10
Exposure to SAP SD, MM, FI (AR, GL, AP), HR, PM, customer, Vendor Modules, CRM
Professional Experience:
Feb 2019 – Till date, SAP BW Associate Manager/Technical Architect Accenture Consulting
Client: Chemicals Industry
Duration: Jan’ 19 – Aug 2020
Industry: Chemicals, USA
Duration: 18 Months
Role: SAP BW Architect
Responsibilities:
Involved in full life cycle implementation, which includes Analysis, Requirements gathering, Development, Testing, Reporting, Go-live and Post Go-live support.
Delivery & Accountability of projects with Onsite-Offshore based model, coordinating with multiple Business units in a collaborative environment with good understanding of business priorities, & handling multi-location teams.
Worked with client stakeholders, management and business partners to get buy-in and propagate thought leadership.
Involved in SAP HANA Data provisioning using SAP SLT
Created ADSO, composite providers and Open ODS views
Extracted data from S/4
Created Calculated Views in Hana Modelling for reporting purpose.
Working knowledge in AMDP based Transformations in BW Start routines, end routines and expert routines.
Worked on SAP BW Data source enhancements, generic data sources, CDS Views based Extractors.
Expertise in creating BW reports, Webi and AO reports
Created composite providers on top of DSO and calculation views for reporting purposes
Experienced in creating CDS views as part of S4HANA embedded analytics.
Created Basic/Composite CDS views, Consumption views, publishing to Odata, deploying the
same on Fiori, creating tiles etc
Used associations, joins and other standard functions to meet the requirements
Extended standard views for adding fields not available in the standard views.
Environment: S/4, SAP BW4HANA, SAP HANA 2.0, SAP MDG
Feb 2012 – Jan 2019, SAP BW Consultant/Technical Architect/Technical Lead IBM India Pvt. Ltd. India
Projects:
Client: LDC, Europe
Duration: April 2018 – Jan 2019
Role: SAP BW4HANA Lead & S/4 Hana Embedded Analytics
Client: AP Moller Maersk, Europe
Duration: Feb 2017 – Mar 2018
Role: SAP BW on Hana Lead
Client: Shell Oil, Europe
Duration: July 2015- Aug 2016
Role: SAP BW on Hana Testing Lead
Client: Adani Enterprises, India
Duration: Feb 2015- July 2015
Role: SAP BW on Hana Consultant
Client: Yara International, Europe
Duration: Feb 2012 – Jan 2015
Role: SAP BW Solution Lead
Key Deliverables:
Planning and Preparation
Blueprint and Design Workshops
Requirement Capturing and Fit Gap Analysis
Modelling and Solution Design
End User Training and workshops
Demos to Key Stake Holders
Developing Test Strategy and aid in Integration testing, UAT, FUT
Responsibilities:
Involved in full life cycle implementation, which includes Analysis, Requirements gathering, Development, Testing, Reporting, Go-live and Post Go-live support.
Creating Virtual providers, composite providers, Hybrid Providers.
Extract data from ECC &legacy systems
Created Advanced DSO and Open ODS Views.
Worked on creation DSO, cubes, ADSO, Composite provider, Open ODS and ODP framework.
Experienced working Eclipse modeling and Query designer.
Worked with SAP Business Objects Analysis for office for creating the reports.
Designed and developed HANA models like attribute view, analytical view, calculation view (both graphical and script based), calculated columns and Input parameters as per requirement.
Worked on BW LSA++ architecture.
Extracted data from SAP R/3 using LO and Generic extractors. Apart from that extracted data from flat files using flat file source system.
Involved actively in supporting the various issues addressed by the Users from the client side and providing them with required solutions.
Developed Global info cubes, Multi cubes, Transactional Info cubes, DSO objects and extracted Master data and Transaction Based Data in SD, HR, QM, MM, and FI Info areas.
Created Queries with BEX Web Application Designer for analysis and reporting and to display the Report in Web.
Designed, developed Bex queries, Universes and WebI Reports, Xcelsius Dashboards
Worked with BEX Query designer to build queries according to the client’s requirement using Calculated Key Figures, Restricted Key Figures, Variables, Structures, and Query properties, Filters, Free Characteristics, Conditions and Exceptions.
Documented Query Definitions based on Client Requirements.
Imparting Training to End Users
Worked closely with the architects during the Design reviews, Prototypes, option analysis etc.
Worked closely with project manager for providing estimated and preparing the project plan
Responsible for leading a project team in delivering solution to our customer in the Industrial sector.
Responsible for managing Stake holders like business community, Support & delivery groups.
Deliver new and complex high quality solutions to clients in response to varying business requirements. To Plan, design and manage the scope and strategies around the business requirements.
Responsible for managing scope, planning, tracking, change control, aspects of the project by participating in workshops and kick off meetings for key management stake holders to update them about progress of the project and update them of any impact.
Evaluate and manage risks to the project and define action plan to meet the delivery targets.
Responsible for effective communication between the project team and the customer. Provide day to day direction to the project team and regular project status to the customer.
Translate customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results.
Utilize in-depth knowledge of functional and Technical experience in SAP BW ERP and other leading-edge products and technology in conjunction with industry and business skills to deliver solutions to customer.
Establish Quality Procedure for the team and continuously monitor and audit to ensure team meets quality goals.
Key projects handled so far include SAP BW upgrade 7 to 7.3, SAP FICO Project (Profit center implementation), Finland Sales reporting, Upbase reporting.
Environment: SAP BW on Hana 7.0, SAP BW BI 7.0, SAP BW on Hana 7.3, SAP BW4HANA, SAP HANA 1.0, SAP Embedded Analytics
Oct 2009 – Jan 2012 SAP BW Consultant
General Mills, Mumbai India
Client: General Mills, USA
Duration: Oct 2009 – Jan 2012
Role: SAP BW/BI Analyst
Responsibilities:
Work with Business Analyst in translating business requirements into Functional Requirements
Document and to Detailed Design Documents
Lead analysis sessions, gather requirements and write specification and functional design
documents for enhancements and customization
Involved in resolving of user queries based on priority
Ensure that development is performed as per requirements
Work with QA to create test scripts and scenarios for enhancements and customizations to the core
product
Communicate activities/progress to project managers, business development, business analysts
and clients
Develop implementation and test plans, build software acceptance criteria, coordinate and work
with clients
Environment: ECC, SAP BW on Hana
Sept 2006 – Oct 2009, Sap BW Developer/Team lead Capgemini Consulting India Pvt Ltd.
Client: American Greetings, USA
Duration: Dec 2008 – Oct 2009
Role: SAP BW Consultant/Reporting Lead
Client: Stanley Works, USA
Duration: Jan 2008 – Nov 2008
Role: BI Consultant / Developer, Onsite coordinator during Integration Testing
Client: Limited Brands, USA
Duration: Aug 2007 – Jan 2008
Role: SAP BW Developer
Client: Chep International, USA
Duration: Sept 2006 – Aug 2007
Role: SAP BW Developer
Responsibilities:
Working with business team to understand business requirements and through consultation, provide advice on how best to utilize available information and how best to analyze information to provide insights.
Produce the technical specification from functional specification document.
Responsible for design Data models, Data extraction from R/3 and External systems, BEx, WEBI Reports, Dash Boards, data staging with External applications, business contents
Installations and automate the data staging using process chains and Load monitoring within the SAP implementation.
Working on BI 7 Transformations and new Functionalities
Documentation for Multi Cube, Cube, Transformations Rules and Reports Specs / HLD
Responsible for creation of BEx reports, work books
Identifying Unit Test Cases
Internal Unit Testing
Planning and Supporting User Acceptance Testing
BI Content analysis and Installation
Generic Data Sources
SCEM BCT datasources
Design and Data modeling of Cubes, DSO’s and Multiproviders
Responsible for creation of BEx reports, query views, work books and web templates
Responsible for complex Dashboards Development in WAD 7
Ensure developments are completed to time, quality and cost.
Support System and User Acceptance testing.
Environment: SAP BW 3.5, SAP BW 7.0
May 2005 – Aug 2006, Sap BW Developer
Patni Computers
Client: Harman Music Group, USA
Duration: June 2005 – Aug 2006
Role: SAP BW Developer
Responsibilities:
Requirement Analysis and Understanding existing Functionality
LO Datasources and its configuration
Documentation for MP, Cube, Update Rules and Reports Specs / HLD
Development of user exits for reporting purpose.
Development of Process Chains for automation purpose.
Identifying Unit Test Cases
Internal Unit Testing
Planning and Supporting User Acceptance Testing
Co-ordination with Onsite team for various project related issues
Job Monitoring during hyper care period.
Testing after upgrading to BW 3.5
Maintaining BW Upgrade Issue log.
RSRV Checks.
Information broadcasting settings as per client’s requirement
Environment: ECC, SAP BW 3.0, SAP BW 3.5
Trainings
SAP MDG 9.0
S4HANA Embedded Analytics (ABAP CDS Views) Course – Mar 2018
SAP HANA
Agile Methodology
SAP BW on Hana BW 362 course – Aug 2014 – Conducted by SAP
SAP BW 3.0B
SAP ABAP 4.0, SAP BW 3.0 (Internal)
BW-BPS, SAP BI-IP (Internal)
SAP Business Object 4.0
Skills
SAP BW 3.0 SAP BW 7.0
SAP BW 3.5 SAPHANA
SAP BW 7.4 S/4 Hana Embedded Analytics
SAP MDG 9.2 SAP BW4HANA
Work History
Accenture Consulting Jan 2019 to Current
SAP Data and Analytics Manager
IBM Consulting Feb 2012 to Jan 2019
SAP BW Sr Consultant/Lead/Manager
General Mills Oct /2009 to Jan/2012
SAP BW Analyst
Capgemini Consulting Sept /2006 to Oct /2009
SAP BW Consultant
Patni Computers May/ 2005 to Aug /2006
SAP BW Developer
LionBridge Technologies July 2004 to Feb 2005
Web developer