SUMMARY:

• Mo re than 11 years of IT experience.
• Recently worked with Confidential, SFO, USA as SAP BW Developer/Architect.
• 11 years of experience in SAP BW in various versions 3.0, 3.5 and BI 7.0, 7.3, 7.4.
• 4 years of SAP HANA, modeling - created Analytical, attribute, and calculative views.
• 8 years of SAP ABAP, written many codes and stand alone programs in BW system.
• 3 years of SAP BOBJ ( WEBI, Crystal, Dashboard, Design studio ), 2 years of SAP BODS.
• Excellent working knowledge of SAP BW Projects includes End to End Implementations, development projects, has Good Analytical approach towards Landscape Design, Project Management, Resource & Requirement Gathering, Fit and Gap Analysis for BW Projects
• Worked under different functional areas like HR, FI, MM, PP and SD.
• Excellent communication, analytical skills & experience in interacting with client and end-users and a very good team player and always a reliable resource in the team to count on any technical help required.
• A very quick learner of new subjects, learned ABAP, HANA, BODS on my own.

TECHNICAL SKILLS:

SAP: ECC 6.0, BW 3.0, 3.5 and BI 7.0, 7.3, HANA, BOBJ, BODS

LANGUAGES: ABAP, SQL, Python.

WORK EXPERIENCE:

Confidential

SAP BW/HANA Developer

Responsibilities:

• Plan for future and current changes as they relate to business real estate
• Manage real estate projects on-budget, on-time, and in a sustainable manner, negotiate and manage contracts for vendors and facilities
• Grow revenue and control expenses through effective real estate distribution strategies.
• BI system has cross function data, data from ERP, SRM and SMS(Tririga) are loaded.
• Reports on SAP and SMS data comparison were created in BW and were used for data correction
• Reports on Lease, contracts and many other real estate related were built in BW.

Confidential

SAP BI Solution Architect and Senior developer

Responsibilities:

• Worked on many enhanceme nt and development CRs in SAP BW/HANA/BO/BODS, primarily on SAP BW
• Created new reports based on SAP HANA Model:
• Accounts receivables report (WEBI report) - (End to End Implementation)
• Exploration view of Sales/Delivery/Billing (BEx report) - (End to End Implementation)
• COPA Health and Wellness report (BEx report)
• GIT - Delivered not Billed report (BEx report)
• Actual Payments related to CAPEX (WEBI report)
• Project - Secondary sales data to Navigator from HANA (involved modeling in HANA and BODS job)
• Created many new reports in BW:
• Sales details by source plant report - (End to End development)
• Contract details for Vendor Schedule report
• MRP - PO optimization report
• GRIR aging report
• Accounts payable report
• Compliance to Schedule report
• Business requirements gathering and preparation of functional and technical specifications.
• Realization of the approved design, also involves ABAP coding wherever required.
• Involves HANA modeling like creation of tables, attribute views, analytical views and Calculation views.
• Creation of jobs, SQL and queries in BODS for extraction of data from HANA system.
• Worked on fixing issues with Business objects reports (Webi, Dashboard and helping users in trouble shooting issues during report execution
• Mentoring new joiners and training them in SAP BI. I took this step voluntarily and this helps them to up skill themselves and also adds value to SAP practice.

Developer

Responsibilities:

• Worked on many enhancement and development CRs in SAP BW-HR platform.
• Realization of the approved design, also involves ABAP coding wherever required.
• Designing of BEx reports for end users and helping them in trouble shooting issues during report execution

Solution Architect/Developer

Responsibilities:

• Manual identification of unwanted and inactive objects in BW.
• Categorizing them to important, recently used, and not used based on the last changed dates and dependencies factors.
• Deletion of the unwanted objects through programs, after confirmation from user.
• Creation of program to identify the unwanted and temporary objects.
• Creation of Program to send email to the object owners

Developer

Responsibilities:

• Gathering requirements from client with the aid of onsite coordinator and understanding the Business requirements and analyzing the best way to design them.
• Development of the architecture and the entire end to end flow in SAP BW like creation of Datasources for Master and transaction data, Infoobjects, Infocubes, Transformations, routines.
• Design of translation tables required to lookup while translating the CCE values to KO values and designing of DASHBOARD query in SAP BEx query designer for reporting.

SAP BW Developer/Support consultant

Responsibilities:

• Worked as a Focal Point in the team, in cluster Credit MI (Management Information) and involving, guiding the team members for resolving all the functional and all the data load issues tickets and worked on performance issues and improved Query performances by creating right aggregates.
• Have designed all the test scenarios and test scripts required to be performed during the regression test for GPMR for cluster Credit MI and FPS (Fuel pricing system)
• Performed reconciliation for different interface streams in GPMR on every month.
• I defined the reconciliation procedure and steps for all the 6 different interface streams in GPMR and created the run book.
• Work on Designing & Developing and correction of existing reports and interactive Dashboards on top of Webi reports built using Bex Queries on an OLAP Universe for FPS cluster

SAP BW Consultant

Responsibilities:

• Involved in Design issues with regards to Data Load Extraction(R/3 extraction, delta handling), Attribute Change Run and overall improvement in Data Load Performance.
• Worked in migration of SAP BW 3.x environment to BI 7.0 version.
• Monitor the data loads from various source systems like R/3, CRM, SEM and APO by means of process chains and Involved in the Incident Management (Second Level Support for tickets involving Data load issues).
• Scheduling and Monitoring of Process Chains enabling in automated scheduling of all Data Loading Jobs across different systems (BW and SEM).
• Performing cutover activities like setup table filling, delta Q clearing, data load to new flow.