SUMMARY

• Over 13 years of experience in SAP BW/BI/HANA. Mainly focused in design, development, implementation, managing and delivering projects.
• Analyzing business requirements, writing Functional specifications, technical specifications, Work estimation and development planning, testing, cut - over planning, supporting live application.
• Hands on experience in End to End SAP BW to HANA Migration as well as Native HANA modelling and Architecture.
• Good experience in working projects where the backend data model is built in SAP BW and front end reports are delivered using Business Objects tools like Webi, Design studio and Analysis office
• Worked on SAP BW 7.0 to SAP BW 7.4 upgrade project, as a key member.
• Designed and developed complex Calculation views using Graphical and Script based.
• Worked on SLT to load data into HANA system using Data Provisioning.
• Involved in building reports using SAP BO 4.0 and integrating BO with BI and SAP HANA.
• Experience in Custom development ABAP code at various levels of the data flow to handle complex data loading requirements and optimizing to handle large volumes of data.
• One HANA Side-car engagement with SLT as Data provisioning
• Involved in performance tuning of BW Objects to address high query run times
• Capable of working in teams as well as independently with good communication, interpersonal and analytical skills.
• Hands on experience in Smart Data Integration (SDI)
• Functional areas of expertise include Sales and distribution (SD), Material Management (MM), Production Planning (PP), Inventory Management (IM), Finance(FI), Accounts Payable (AP), Accounts Receivable (AR), Supply Chain Management (SCM -DP, SCM-SNP) and Customer relationship Management(CRM).

TECHNICAL SKILLS:

Data Warehousing: SAP BW 7.x, HANA 1.0

Reporting Tools: SAP BO Web I 4.x, Bex Designer, Analysis office

Dashboards: SAP Dashboard Designer

Programming Languages: ABAP/4

PROFESSIONAL EXPERIENCE:

Confidential, TX

SAP BW& HANA Consultant

Responsibilities:

• Involved in BW on HANA Life cycle implementation.
• Involved in requirement gathering, Design, Development of the new HANA system.
• Developed Reports for Sales and distribution (OTC) and Shipments modules.
• Developed reports like Open order detail level, Contracts, Shipments flow and Document flow.
• Created required ADSO, Hana Calculation views, Composite providers, Bex reports.
• Extensively worked on the SAP HANA calculation views to get the data transformations.
• Worked on Performance improvement SAP HANA Views.
• Handled postproduction support and development of new design cycles simultaneously.

Confidential, NY

SAP BW& HANA Consultant

Responsibilities:

• Involved in BW on HANA Life cycle implementation.
• Created required ADSO, Hana Calculation views, Composite providers, Bex reports and Dash Boards (Design Studio) developed the reports Spend, TMS, Contracts Etc.
• Created Account Receivable Dashboard (Invoice processing timelines, Paid on time, Number of invoices processed etc.)
• Created Customer Accuracy Dashboard for Keyboards, Flat Panels, PC, B unit( Comparing terminal Vs installed)
• Worked on SCM DP project which improved the forecast in detail level.
• Worked on HANA SQL views and procedures.
• Worked with the non-cumulate ADSO to get the snap shots.
• Worked on Spend Reports to get details spend controlled on fly with various rules.
• Worked on Equipment life cycle project for Keyboards, Flat Panels, PC, B unit.
• Extensively worked on the SAP HANA calculation views to get the data transformations.
• Worked on Performance improvement SAP HANA Views.
• Worked on OTC and P2P reports.
• LSA++ models developed.
• Developed BADI to restrict the F4 selection values in the reports.
• Develop and implement best practices and standards
• Handled postproduction support and development of new design cycles simultaneously.
• Translate Business KPIs into HANA models

Confidential, Brooklyn NY

SAP BW& HANA Architect

Responsibilities:

• Worked on Emergency, repair and construction maintenance reports for Gas distribution front office project in release one, two and three.
• Built BW models using LSA++ architecture Acquisition, propagation, corporate memory, transformation, Dimension and reporting layer.
• Participated in BW upgrade from 7.0 to 7.4 in plan, pre upgrade, post upgrade defect fixing
• Constructed the GDFO and shared service project reports in Native HANA by using SLT replication.
• Create Complex Function modules get the results for emergency, repair and Construction custom details.
• Introduced SAP HANA Hints to improve the coding performances across various data flows.
• Worked with BODS for extracting the data from Legacy systems in data migration and data warehouse.
• Constructed the 6 dashboards in HANA utilized calculation view to derive complex logic.
• Configured SLT system to replicate the required master and transaction tables to HANA database and scheduled replication hourly.
• Worked on Agile methodology implementation.
• Contribute to Solution Design documents and create or review detailed Design documents
• Worked on Performance tuning in CAB and HPMIS projects.

Confidential

SAP BW Consultant

Responsibilities:

• Worked on the Implementation of SD and COPA modules for Hitech pharmacal. Was responsible from requirement gathering to delivery of reports.
• Worked on production support for Hitech pharmacal interms of data loading and user assistance.
• Worked on the implementation of SD, MM, Inventory and COPA modules for Nava bharat ventures and given the production support.
• Was involved in Vistex module implementation at Hitech pharamacal.
• Worked on BW upgrade project for Impax Lab
• Assisted our clients to fine tune the data loading process for BI Data loads, HR, COPA data load to meet their data load schedule to complete within SLA.
• Was involved in Pilot project of HANA standalone system.
• Configured the SLT replication server to extract the required table’s data in to the HANA system.
• Configured the attribute, analysis and calculation view as required for the reporting.
• As per the VAR solution partner, handled the OSS messages from our customer’s high, medium and low priority.
• Handling the team of 5 members in terms of distributing the workload and deliveries.
• Worked on proposal writing and given new estimations for our customers.
• Developed the BI reporting in our solution manager system in terms of call duration and message reporting for our Audit purpose.
• Given internal demo on HANA powered by BW and complete cycle of HANA process.

Confidential, UK

SAP BW Consultant

Responsibilities:

• Implemented business content and developed the data model to satisfy the various functional requirements as well as enhancements for ECC and CRM implementations.
• Participated in Go-live activities like Scheduling, Un-scheduling the Process chains, Co-coordinating the transports, flushing the delta Queues, Deleting & Filling the setup tables, running ad-hoc process chains.
• Created Process Chains to load data on a Daily/Weekly/Monthly.
• Worked with the users for defining the reporting needs and helped design/develop flexible queries using BEX reporting features like variables, exception and conditions.
• Created Infosets and MultiProviders to satisfy the different reporting requirements.
• Created numerous numbers of start, end & expert routines.
• Implemented CMOD exits in ECC & BW systems.
• Worked on Data source enhancements.
• Monitoring of loads and fixing failures.
• Maintenance of Process chains, Info packages for changes in schedules or repair loads.
• Resolving tickets raised by Business Users for their issues on BW Reports, validating data with source systems or if application is not working or it’s slow.
• Communication to users in case of any load delays or issues with source systems.
• Knowledge transfer along with team members regarding technical guidance & support throughout the project lifecycle.
• Created Process chains for all jobs, which were scheduled directly through Info packages.
• Performance initiatives taken to improve performance of queries.

Confidential

SAP BW Consultant

Responsibilities:

• Monitoring of loads and fixing failures.
• Maintenance of Process chains, Info packages for changes in schedules or repair loads.
• Resolving tickets raised by Business Users for their issues on BW Reports, validating data with source systems or if application is not working or it’s slow.
• Communication to users in case of any load delays or issues with source systems.
• Knowledge transfer along with team members regarding technical guidance & support throughout the project lifecycle.
• Created Process chains for all jobs, which were scheduled directly through Info packages.
• Performance initiatives taken to improve performance of queries.
• Daily Discussions with managers & Application owner to resolve issues that arise during data loads and aggregation activities. This could include analysis of Data load fails due to Locks & Replication errors, Master data load fails due to SID’s problem & duplicate records.

Confidential, Salt lake city, UT

SAP BW Consultant

Responsibilities:

• worked on Activities(0CRM SALES ACT 1),Opportunity Header(0CRM OPPT I),
• Opportunity Header (0CRM OPPT H), CRM Sales Order Item (0CRM SALES ORDER I), Generic Extractor for Marketing Attribute, Values (0CRM MKTATTR ATTR),SAP BP: BW Extraction Central Data (0BPARTNER ATTR) data sources.
• Worked on the scenario like modifying the master data of 0BPARTNAR with reference to the transaction data available in BI system.
• Worked on performance tuning.
• Created Aggregate in order to improve the performance of queries.

Confidential, Orange County, CA

SAP BW Consultant

Responsibilities:

• Extensively worked on 0FI GL 10, 0FI GL 14 data sources.
• Worked on performance tuning in FI module.
• Developed reports on 0FI Gl 14, 0FI GL 10 data sources.
• Created Info cubes, update rules, info sources to design the reports.
• Written update rule and transfer rules routine to cater the requirement.
• Worked on enhancement of data sources for FI Module and written user exits.
• Created aggregates to increase the performance of reports.
• Created Dashboards reports.
• Extensively worked on transporting objects between BW system environments and corresponding SAP R/3.

Confidential

SAP BW Consultant

Responsibilities:

• Involved in BW Configuration as per the needs of customer, modelling the data, defining the extraction process and developing the reports.
• Optimized the performance related to query execution and data extraction. Developed the aggregates improve query performance.
• Developed Historical reports like forecasting accuracy, demand plan reports, Pre demand plan, etc. Enhanced the existing reports as per the new requirement.
• Installed the BW statistics, involved in the setup of the extraction policy, analyzed system reports for performance related issues.
• Created Update Routines and Transfer Routines so as to in corporate business logic and to map the source system data into BW as per the client requirements.
• Extensively used ABAP code in writing user exits, BADI’s, transfer rules and update rules.
• Extensively worked on Remote cubes and Remote cube reports.
• Enhanced the data sources using the BADI and used the user exit so as to populate the data into the same.
• Enhanced the structure of the info cube by adding the necessary key figures and characteristics and populated the data for these and realigned the same using backup cube concept.