PROFESSIONAL SUMMARY:

• Over 11+ years of extensive professional experience in implementation and support projects related to SAP BI/BW HANA and ABAP.
• 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 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.

EMPLOYMENT HISTORY:

Confidential

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

Confidential, Parsippany, New Jersey

SAP BW/HANA Consultant

Responsibilities:

• Created TS/FS/Test Cases templates.
• Worked with Language dependent text to provide text according to logged in user.
• 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

Confidential, Hillsboro, Oregon

BW/HANA Consultant

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

Confidential

BW Consultant

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 .

Confidential

SAP BW Consultant

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 .

Confidential

SAP BW consultant

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

Confidential

SAP BW Consultant

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 .

Confidential

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 .