Name NIDHI GUPTA

Contact No: 609-***-****

Mail ID: adadvw@r.postjobfree.com

Professional Summary:

Over 11+ years of extensive professional experience in implementation and support projects related to SAP BI/BW HANA and ABAP.

Worked as Business Analysts in Projects.

Worked directly with Business to gather reporting requirements.

Performed all phases of Project Life Cycle in modules like Supply Chain (SD, MM, and PM), Finance (AR, AP, and GL) and CO-PA in multiple projects

Handled Production support Issues through Remedy and Communicated with users to solve the tickets.

Worked in Blue printing, FS and TS preparation phase.

Develop and maintain knowledge within the functional/technical area of focus to support the business to design and improve business/system processes

Develop standards and templates to track project schedule, cost, and performance

Demonstrated work experience developing functional and technical specifications, Test Scripts and User Training

Worked to analyze written specifications and CR’s to determine technical feasibility

Completed full-life cycle implementations of SAP BW which includes Data-Modeling (Star-Schema), Data Extraction, Data Loading (Full / Delta Up-Load), including Business Explorer Query Analytics and Reporting Design.

Expertise in all aspects of BI: BI data modeling, data staging and Activating & Enhancing standard Business Content, Info Objects, Hierarchies,DSO, Info Cubes(non Cumulative), Multi providers, Data sources (3,x & 7.x), Info Sources (3.x), APDs & Open Hub, Transformations and Data Transfer Processing (DTP), Master Data(Time dependent and Time independent)Features like Remodeling & Repartitioning, Administration, Scheduling, Process Chains, Performance Tuning with Aggregates, Info cube Partitioning & Compression, OLAP Cache, Pre-calculations etc.

Experience in Data Extraction (ETL): Activating & Enhancing the standard Data sources with structural changes & User Exits with complex ABAP coding, Lo-Cockpit, Generic Data sources with Tables/Views/Function Modules in releases up to ECC 6.0. Extracted Data from Flat files & DB Connect source systems for legacy data

Design of custom objects like Info Objects, DSOs, Info Cubes, Data Sources, Info Sources, Multi providers, Transformations & Update Rules Start Routines, Aggregates, Advanced DSOs and Composite Providers

Managing ODS Objects, Info Cubes and Activating Business Content Objects

Created the Process Chains to automate the data load and data target administration and monitored the processes.

Expertise in Report Generation. Worked extensively on BEx Analyzer in building Queries using Filters, Variables, Structures, Restricted Key Figures, Calculated Key Figures, Conditions, Exceptions and created aggregates for frequently used queries.

Hands on experience in Testing - Master/Transaction data testing in BW and handled Reconciliation with R/3 Data

Working experience on Analysis process designer (APD)

Expertise in HANA modeling using attribute view, analytical view, calculation view (with graphical and SQL scripting), and decision tables etc.

Table, Sequence, and programming including SQL and SQL Script.

Experienced with data provisioning technologies for HANA such as SLT & BODS.

Experienced with Currency conversion for user defined currency by input parameter.

Experienced with Language dependent text to provide text according to logged in user.

knowledge of various replication methods to HANA and various reporting techniques on top of HANA views

Experienced in SAP HANA administration including managing schemas, data model objects, import/export content, and SAP HANA Security.

Experienced with User input methods using Input parameters and restrict data using Variables and filters.

Experienced in creating advanced DSO, Open ODS views and Composite providers using BW modeling tools in eclipse environment.

Experienced with different referential join, inner join, left outer join, right outer join, text join and temporal join.

Experienced with Union, projection, aggregation and join calculation view.

Experienced with security features in HANA i.e. SQL, Analytical, Package and System privileges.

Good experience of SLT data provisioning, administration, and its monitoring.

Strong Experience in ABAP

Prior to BW, I was an ABAP programmer interacting with various R/3 modules (SD, MM, PM, FI, HR, PP) in multiple previous engagements in releases up to ECC 6.0.

Expertise in BDC (Batch Data Communication) using both session and call transaction methods, LSMW (Legacy System Migration Workbench), SAP Queries (by using T-code SQ01, SQ02, SQ03) SAP Script, ABAP/4 reports (Classical & Interactive reports, ALV), User Exits (Enhancements),BADI and BAPI .

Working Experience in ABAP OOPs

Worked with Smart forms.

Good Technical, Communication, Interpersonal and Client Interfacing Skills.

Excellent analytical, self-learning abilities and able to prioritize and complete multiple tasks.

EDUCATION

Bachelor of engineering in Computer Science & Engineering from Rajasthan University,

Jaipur-Rajasthan INDIA (2002-2006).

EMPLOYMENT HISTORY

Client: PayPal Jul 2018 –Current

SAP BW/HANA Consultant

Responsibilities:

Worked on SAP-BW bank analyzer solution

Worked on BW on HANA objects such as Composite providers, ADSO etc.

Created procedures for automation of DSO Archival .

Worked on transportable hdbdd tables.

Worked on Performance tuning via HANA PlanViz..

Troubleshooting HANA errors

Worked on SAP HANA ABAP Transport Mechanism as well as life cycle Management .

Implemented of SAP HANA /DB Connect based data source

Created Calculation view for WEBI reports

Worked on BW data source based on Informatica workflow (3rd party extraction)

Converted standard BW Models into HANA optimized models and imported into SAP HANA

Used Smart Data Access to extract data from production to testing environment for regression testing for new products.

Worked with User input methods using Input parameters and restrict data using Variables and filters.

Worked with Currency conversion for user defined currency by input parameter.

Worked on BW support project activities data loading monitoring and troubleshooting the failures

BW load/job automation through process chain and Control-M.

Build WEBI Reports like Credit card fee, reconciliation reports,T-Account,Daily checks etc

ENVIRONMENT: SAP HANA 1.0 SP11, SAP BW 7.5, SAP BOBJ 4.2

Client: Zoetis, Parsippany-New Jersey Feb 2017 –June 2018

SAP BW/HANA Consultant

Responsibilities:

Created TS/FS/Test Cases templates.

Worked with Language dependent text to provide text according to logged in user.

Experience in implementing SAP Financial module .

Develop and maintain knowledge within the functional/technical area of focus to support the business to design and improve business/system processes

Worked on Calculation Views, joins, Unions etc inside HANA Studio using side car scenario.

Worked on programming including SQL and SQL Script

Created Inner join, Left outer join for building HANA model.

Implemented Calculation view with dimension, Calculation view with cube and Calculation view with Star join.

Used input parameters, input variable, Filters for designing model.

Implemented Calculation View for various reporting requirement in O2C/M2D/P2M/R2R/P2P.

Managed Hyper care for all reports delivered.

Closely worked with Business/ Functional Team for all reporting requirements and thereby delivering the HANA models.

Strong experiences in installing the Standard Business Content objects and enhance them into custom objects based on the business requirements.

Educates Power Users on model designs and mapping of data to business processes.

Design reports based on SAP-BOBJ tool like Analysis for OLAP, Web Intelligence Reports .

Worked on system maintenance tasks Delta queue cleaning, Setup table deletion validation

ENVIRONMENT: HANA 1.0 SP11, SAP BW on HANA 7.5 ECC 6.0, SAP BOBJ 4.2

Client: NIKE (Hillsboro, Oregon) Dec 2015 – Jan 2017

BW/HANA Consultant (Tata Consultancy Services)

Responsibilities:

Requirement gathering, analysis, effort estimation of Change request.

Quality Review and Unit Testing of the developments.

Designed SAP BW on HANA Composite Provider as semantic layer using BW on HANA Modeling tools in HANA Studio.

Generated SAP HANA Analytic Views for standard DSO’s in HANA and used them in calculations Views.

Enhanced Loading performance by Pushing down ABAP Logic into SAP HANA Script Based calculation view and improved performance.

Loaded data into SAP BW with SAP HANA Calculation View as source using DB Connect.

Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.

Implemented LSA++ architecture in the BW on HANA Landscape.

Worked extensively on HANA modeling for BW Objects.

Performance tuning of queries in webi.

ENVIRONMENT: SAP HANA 1.0, SAP BW 7.4, SAP BO 4.0, SAP ABAP, SAP BODS 4.0, SAP ECC 6.0

Client: Cardinal Health Jan 2013 – Oct 2013

BW Consultant (Tata Consultancy Services)

Responsibilities:

Designing and development of Change request for both BW and BO Requirements.

Quality Review and Unit Testing of the developments.

Designed and developed universes and WebI reports.

Publishing and scheduling of Business Object reports.

Worked on Advanced Analysis reports (MS Excel version) with SAP-BW as data source.

Dashboard for Inventory Management, Procurement Cycle through Dashboard Designer ( SAP-BO 4.0)

Documented Business Processes and designed and developed centralized reporting system with universes and reports to access users from BI Launchpad and run effectively on their month/quarter end processes and reports producing to their country regulators

BPS related Developments, function module created for planning sequence for the logic to be implemented for BPS calculation

Guidance and support for BW/BO Change Requests implementation till go live and support.

ENVIRONMENT: SAP BI 7.0, SAP BO 4.0, SAP ECC 6.0 .

Client: WABCO Sep 2012 – Dec 2012

SAP BW Consultant (Tata Consultancy Services)

Responsibilities:

Installation of Standard data Sources in SAP-ECC and creation of Generic Data Source.

Modeling of non SAP Source System like Flat File and DB Connect, UD Connect Systems.

Created Crystal reports tool in SAP BOBJ.

Transforming business decisions into functional requirements and thereby converting those into technical specifications to formulate an appropriate multi dimensional design after assessing against the usage of standard SAP delivered Business Content.

Worked on data source like 2LIS_02_ITM and 2LIS_02_SCL etc in SAP- Procurement.

Worked on all kind of SD data source like 2LIS_11*, 2LIS_12*, 2LIS_13* .

Created Process chains for all Master data and transaction data loading from acquisition layer to Business Transformation layer and finally to Reporting layer.

Created of Test Case Scenarios. Managed Cut Over Activities.

ENVIRONMENT: SAP BI 7.0,SAP BO 4.0, SAP ECC 6.0 .

Client: Gujarat State Fertilizer and chemicals Oct 2011 – Aug 2012

SAP BW consultant (Tata Consultancy Services)

Responsibilities:

Part of Requirement Gathering, Blueprinting and signoff from client.

Activation of BI content.

Installation of bw data sources, providers.

Customized and managed the modeling of BW.

Involved in creation of info set and multi provider.

Xcelsius Dashboard designing and Creation Query design for Dashboard on universe to integrate Non SAP Data.

Design Universe and WebI report for Non SAP data.

Worked on Advanced Analysis reports (OLAP version) with SAP-BW as datasource.

Created Process chains for different data flows. Manage data targets by having the correct data analyzed the errors in the data loads while monitoring.

Scheduled automatic alerting when process chain fails .

Broadcasting of Daily reports to users once data load is complete.

Designed Info cubes and set up extraction from both R/3 modules and from flat files.

Conducted training for Key Users to operate BW reports.

ENVIRONMENT: SAP BI 7.0, SAP BO 4.0, SAP ECC 6.0 .

Client: Vinmar International Jul 2011 – Sep 2011

SAP BW Consultant (Tata Consultancy Services)

Responsibilities:

Generic data source creation on the reports in ECC which was earlier used to dump data in excel file for upload in BW.

Info object creation, transformation mapping, field routines for manual calculation done in flat files.

WAD and query modification, designing.

BW Authorization Matrix for around 250 users defined. Authorization matrix was designed based on 10 info object.

Profitability Cubes maintenance and support.

ENVIRONMENT: SAP BI 7.0, SAP BO 4.0, SAP ECC 6.0 .

Client: Hindustan Zinc Limited Oct 2010 – Jun 2011

SAP BW – Associate Manager

Responsibilities:

Designed and developed Info Objects, Info Cubes, ODSs, Info sets and Multi Providers.

Dashboard Designing/development in Xcelsius 2008.

Worked with Business Content as well as creating Info sources.

Analyze and design the cubes as the requirement, remodeling the cubes as per requirement.

Involved with PSA in Monitoring the Data Transfer from Source Systems into BW.

Created Reports using BEx Query Designer by using Conditions, Exceptions, Filtering,

Structures, Free Characteristics, Calculated key Figures, Restricted Key Figures and Variables.

R/3 Logics and Enhancement needed to be done at R/3 side for BW.

Process chain Creations and monitoring.

User creation roles and authorization for users in BI

End user Training for using analyzer and portal functionality.

ENVIRONMENT: SAP BI 7.0, SAP BO 4.0, SAP ECC 6.0 .

Client: Vedanta Resource Plc Jan 2010 – Sep 2010

In House Consultant, ( SAP BW Core Member )

Responsibilities:

Creation of BI queries

Developed Dashboards using Xcelsius 2008 with direct SAP-BI connectivity.

Modelling and Configuration of BI 7.0 Content

Installation of Standard data Sources in SAP-ECC and creation of Generic Data Source.

Modelling of non SAP Source System like Flat File.

ENVIRONMENT: SAP BI 7.0, SAP BO -Xcelsius 2008

Client: Hindustan Zinc Limited Nov 2006 – Dec 2009

SAP-ABAP Support and Implementation

Responsibilities:

Implementation for reports

Maintenance of ABAP reports

End user requirement Gathering, analyzing and Implementing

End user Trainings for new developments.

For PM /PP Modules

Daily MIS Reports in smart form display as well as in interactive report format and automatic mailing from SAP to Lotus mail box.

Many BDC developed for uploading Data.

Power Report in smart form for Plant.

PMI Summary Report, Recovery, Analysis, Variance and many more Report for Plant.

For FI /SD Modules

RTGS (Real Time Gross Settlement System) covering letter using smart form.

Many changes in the existing reports as per user requirement.

Smart Forms for Sales Invoices. Weighbridge Reports.

BDCs for uploading data from Legacy System into SAP R/3.

For MM Modules

Purchase Requisition,Purchase orders and Good receipt, VAT calculation,RFQ- enquiry letter, Reservation slip,Allow slip, payment tracking,List of moving and non moving items,Conversion report from PO-PR-GR,MRP Analysis,GRN to inspection analysis,On time delivery, late delivery,PO printout Scripts.

Report for deleting and closing PR not assigned or not released using BAPI call.

Modification in ME21n using Badi for cross verification of valuation price and net price.

Vendor PAN NO And Service registration Number check in ME21n through BADI .Stock comparison at time of PR creation through BADI.

Restricting ME51N for Delivery date if it more then 50 present of plan delivery time and will invoke for the emergency PR to create. Enhancement is done with User exit.

Modification in MIRO and MIGO screens for better control .Using BADI GR Posting date as baseline date.

ENVIRONMENT: SAP ECC 6.0

Contact this candidate