Vandana Goyal
Cell: +1-682-***-**** adkgrd@r.postjobfree.com https://www.linkedin.com/in/vandanagoyal
Location: Pleasanton, CA
Visa: L2 with EAD (Authorized to work in US and no sponsorship require)
Summary
Awesome journey of 13+ years’ experience including,
SAP BW Version worked on 3.5, 7.0, 7.3, 7.4 and 7.5 (SAP BW on HANA), SAP BW/4 HANA
SAP BW skills: Data extraction & modeling, ETL, BEx, Performance optimization, APDs, ADSOs, SAP BW on Hana, Reports reconciliation, Dashboard, Data flow design
SAP HANA skills: Data modeling, View creation, ER modeling, Data modeling from files using BODS
SAP ABAP skills: ABAP developer for BW, Performance tuning, Custom Data source design, BEx variables & transformation, AMDP, ABAP CDS view in S/4 HANA
Agile skills: Building stories, Sprint planning and backlogs, Version management, Retro, JIRA Management
SAP Project Management skills: Requirement gather, scope documentations, effort estimations, technically mentoring the team, user trainings, user manuals and UAT signoffs, release managements.
SAP BPA Skills: Job configuration, Job Chain creation, Scheduling and Monitoring, Chain Management, Event Management
Industry Experience
Technology used
For Client
Finance and Insurance
SAP BW, SAP BW HANA
Nationale Nederlanden, Reliance Capital
Consumer Products / Retail
SAP BW, SAP ABAP
British American Tobacco
Petroleum / Pharma
SAP ABAP, SAP BW
Hess Corporation, Barr Pharmaceuticals, ENOC
Manufacturing / Electronics
SAP BW, SAP ABAP, SAP BPA
Applied Materials, Panasonic, EMEA, EDF Energy, Micromax
Utilities / Construction
SAP BW, SAP ABAP
Ircon, Vandana Global Steels, Unitech, PG&E
Disaster and Recovery / Others
SAP BW
BCRS, SAP AG
Professional Experience:
Role play
Timeline
Organization
SAP BW4HANA Consultant
Sep 2020 - Present
Emirates National Oil Company
Sr. SAP BW HANA Consultant
Jun 2019 – Sept 2020
Applied Materials US
Sr. SAP BW on HANA Associate
Aug 2018 – Nov 2018
Cognizant US
Sr. SAP BW on HANA Associate
Jun 2017 – Feb 2018
Cognizant US
SAP BW / HANA Associate
Nov 2015 - Nov 2016
Cognizant India
SAP BW / ABAP Trainer
Jul 2013 - Jul 2015
Corporate Trainer (IBM, Accenture)
SAP BW Lead Consultant
Jul 2014 - Jan 2015
BKS Associates
SAP BI Module Lead
Nov 2011 - Jul 2013
Wipro Technologies India
IT Analyst
Jun 2011 - Nov 2011
Tata Consultancy Services (TCS) India
Sr. SAP BW Consultant
Aug 2010 - Jun 2011
Price Waterhouse Coopers (PWC) India
SAP BW Package Consultant
Aug 2006 - Aug 2010
IBM India
SAP ABAP Trainee
Mar 2006 - Jun 2006
IBM India
Corporate Trainings:
Jun 2015 – Jul 2015
39 days SAP BW ABAP Training for IBM
Mar 2015 – Apr 2015
35 days SAP BW ABAP Training for IBM
Nov 2014 – Dec 2014
19 days SAP BW ABAP Training for Accenture
Education:
Certificate
Jun 2019 – Oct 2020
Data Science Certification – R Basics, Visualization, Probability, Linear Regression and Productivity Tools (Unix and Git Hub)
Certificate
Jul 2007 - May 2011
PGDBA with Finance Specialization from Symbiosis, India
Certificate
Jan 2007 - Aug 2007
German Language certification (level A1 and A2), MMB - Goethe Institute, India
Master
Jul 2003 - Jul 2006
Master of Computer Application (MCA), Jai Narayan Vyas University, India
Bachelor
Jul 2000 - Jun 2003
Bachelor’s in science (Computer Science), Jai Narayan Vyas University, India
References:
Viresh Kurugodmath
SAP Manager, Cognizant US
adkgrd@r.postjobfree.com +1-372-***-****)
Gopalkrishnan Krishnamoorthy
SAP BW Program Manager, Cognizant India
adkgrd@r.postjobfree.com +91-897*******)
Chandra Vangoor
SAP BW Lead, Wipro Technologies
adkgrd@r.postjobfree.com +91-990*******)
Alok Sharma
Founder & CEO, BKS Associates
adkgrd@r.postjobfree.com +44-791*******)
Anjeel Babbar
SAP BW Product Lead, IBM India Pvt Ltd
adkgrd@r.postjobfree.com +91-971*******)
Works in details
1.Emirates National Oil Company
Industry: Petroleum
Project: SAP BW/4 HANA Location: Dubai
Role: SAP BW4HANA Consultant (Oct 2020 – till date)
Responsibilities:
Credit Hold, Pending Sales Order, Sales Register and Customer Credit report Architecture designing.
Data Model designing using SAP BW4HANA and S/4 HANA source
ABAP CDS view data source
ABAP to AMDP transformation migration and New AMDP Transformation design
SAP Sales / Delivery / FSCM models functional area.
Technology responsibility to create custom data sources via CDS views, ADSOs, process chains, BEx queries,
LSA++ Architecture design (ODS concepts for acquisition layer)
2.Applied Materials US
Client: Applied Materials Industry: Manufacturing / Electronics
Project: SAP BW 7.5 on HANA Location: Santa Clara, California, US
Role: Sr. SAP BW HANA Consultant (Jun 2019 – Sept 2020)
Responsibilities:
Worked with various technology teams (ECC / BW/ Hadoop/ BODS/ Solar)
Data Model designing using in SAP BW from various systems.
Understanding requirement and working with offshore to get delivery done
Working in agile methodology for frequent releases.
Technology responsibility to create custom data sources, ADSOs, process chains, BEx queries, Redwood job chain scheduling and monitoring.
Working with Functional Analysts for functional testing
Working on release management approvals and documentations
JIRA stories and task management
Redwood (SAP BPA) job chain creation, application job steps management, event management, monitoring, error log handling
SQL queries in Hadoop for data validations
LSA++ Architecture design
Worked on solutions for BPC (Business Planning & Integration)
Worked extensively on COPA and COEP Actuals, Forecast and material overheads
3.Cognizant US Corp.
Client: Pacific Gas and Electricity Industry: Utilities
Project: SAP BW 7.5 on HANA Location: San Francisco, California, US
Role: Sr. SAP BW Consultant (Aug 2018- Nov 2018)
Sr. SAP BW Consultant (Jun 2017- Feb 2018)
Responsibilities:
Worked in Agile Methodology
Worked on SAP HANA BPC trouble shootings post-upgrade. Worked involve in fixing BAPI failures (char to string type error due to SAP upgrade).
Creating – Scope documentation, Requirement document, Technical Design documents, UAT and User Manuals
End-to End solution designing for SAP BW Work Management reports.
Discoveries on varies feasible architect solutions.
4.Cognizant
Client: Nationale Netherlande Industry: Insurance
Project: SAP BW 7.4 on HANA/Hana Development project Location: Bangalore, India
Role: SAP BW Associate (Nov 2015- Nov 2016)
Responsibilities:
Worked on APDs
Worked in Agile Methodology
Worked on file locking systems
Worked on SAP HANA Data Quality (HANA Views)
Worked on ADSOs
Project coordination, scrum Planning, documentation
5.BKS Associates
Client: Micromax Industry: Consumer Electronics
Project: SAP BW 7.3 Development project Location: Remote (Bangalore, India)
Role: SAP BW Lead Consultant (Jul 2014- Jan 2015)
Responsibilities:
Leading SAP BW team
Communication with business and requirement gathering
Complete SAP BW Architecture development in CRM Services
Semantic DSO design
6.Wipro Technologies
Client: British American Tabaco Industry: Retail
Project: SAP BI 7.0 Support project Location: Bangalore, India
Role: SAP BW Module Lead (Nov 2011- Jul 2013)
Responsibilities:
Involved in training and mentoring new joiners in SAP ABAP / BI
Maintaining currency conversions
Finding bug in existing data flow and converting them to CRs and working on them
Working on data consistency through tickets
Worked on performance issues
Project coordination, documentation
7.Tata Consultancy Services (TCS)
Client: SAP AG Industry: CRM Services
Project: SAP BI 7.0 Support project Location: Bangalore, India
Role: SAP BI CRM Consultant (Jul 2011- Nov 2011)
Responsibilities:
Involved in Regression tool for Inactive objects
Giving complete ABAP training to 13 associates
8.Price Waterhouse Coopers (PWC)
Client: Reliance Capital Ltd Industry: Financial Service
Project: SAP BI 7.0 Implementation project Location: Mumbai (Onsite), India
Role: SAP BI Consultant (Aug 2010 – Apr 2011)
Responsibilities:
Requirements gathering from business development team & end user
Reliance Consumer Finance profitability
Reliance General Insurance Undetermined Risk Reserved developments for Brach wise / Channel wise Profitability
SAP BI development for 6 LOB’s dashboards
Resolving support issues
Project coordination & documentation
9. IBM India Pvt Ltd
Client: HESS, US Industry: Petroleum
Project: SAP BI 7.0 Support project Location: Gurgaon (Offshore), India
Role: SAP BI Consultant (Nov 2009 - Aug 2010)
Responsibilities:
Initialization plant data from Downstream Hess Project from SAP R/3 to SAP BI
Process Chain monitoring for Purchasing & Inventory for Downstream Hess Project
Process Chain monitoring for finance data for Upstream Hess Project
Process Chain modifications.
OLAP Variables / Customer exit creation
Data Model Objects creation
Query Creation
Start Routine / End routine coding
Info package / DTP routines coding
10.IBM India Pvt Ltd
Client: Vandana Global Ltd, India Industry: Steel
Project: SAP BI 7.0 Implementation Project Location: Raipur (Onsite), India
Role: SAP BI Consultant (Jan 2010 - Mar 2010)
Responsibilities:
Cost Sheet Daily Plan v/s Actual
Product Component Charge Mix
Dashboard
Daily Quality Control Report
Client Core Team Technical Training
End User Training
Note: Worked on Hess & Vandana Global Ltd projects simultaneously as full time resource.
11.IBM India Pvt Ltd
Client: EDF Energy, UK Industry: Electrical
Project: SAP BW 3.5 Implementation Project Location: London (Onsite), India
Role: SAP BW Consultant (Apr 2009 - Oct 2009)
Responsibilities:
Worked as an owner of 4 SD reports: First Pick Availability, Delivery Failure report, Customer OTIF, Delivery OTIF. Her responsibilities in this project were
Designing prototype for BW reports
Defect resolution during user acceptance testing
User training
Single SAP BW Consultant from IBM UK at client site in support phase
Technical handover and knowledge transfer to client’s BW support team
First line reviewer in support (storm) phase
Development of technical objects using
Creation / Enhancement of R3 extractors
Data Modeling
Query Designing
Process Chain
Custom-exit BW variable
12.IBM India Pvt Ltd
Client: IBM Global Services, US Industry: BCRS (Business Continuity and Recovery Solutions)
Project: SAP Enhancement Project Location: Gurgaon (Offshore), India
Role: SAP ABAP Consultant (Aug 2008 - Mar 2009)
Responsibilities:
Development of technical objects using Module Pools & OO ABAP
Project quality and audit work
Single consultant from IBM India
13.IBM India Pvt Ltd
Client: IRCON International Limited, India Industry: Railway Construction Company
Project: SAP Project Location: New Delhi (Onsite), India
Role: SAP ABAP Consultant (Jan 2008 – Jun 2008)
Responsibilities:
Development of technical objects using
Interactive Reporting
BDC
Module Pool
ALV
SMARTFORM
14. IBM India Pvt Ltd
Client: Panasonic EMEA Industry: Electronics
Project: SAP Support / Upgrade Project Location: Pune (Offshore), India
Role: SAP ABAP / XI Consultant (Apr 2007 – Dec 2007)
Responsibilities:
Development of technical objects using
Interactive Reporting
BDC
Module Pool
SAP Upgrade (from SAP 4.6 to ECC 6.0) developments
OSS Notes implementation to support new functionality
SAP XI tickets
SAP XI System Monitoring
Technical tickets and CR related to Interactive Reports, BDC, SMARTFORMS, ALV and in all the areas of ABAP
15.IBM India Pvt Ltd
Client: Barr Labs Industry: Pharmaceuticals
Project: SAP Implementation Project Location: Pune (Offshore), India
Role: SAP ABAP (Sep 2006 – Mar 2007)
Responsibilities:
Development of technical objects using
Interactive Reporting
Object Oriented ALV
Smart Forms
BDC