SUMMARY

• SAP BW/HANA consultant having 15 Years of experience. reliable, positive, open - minded and collaborative personality with strong team working skills and determined to reach a goal in time and has the ability to work independently as well as with a team and prioritize the development tasks based on changing demands.
• Ability to propose multiple options and different approach for working solutions as per best practices and lead the team in right direction.
• Adept in SAP Design, Development, Extraction, Reporting, Support, Maintenance, Migration, support pack implementation, Archiving, Performance Tuning Projects and AWS Migration
• Worked on SAP HANA 2.0 migration project in line with SAP Recommendations.
• Strong Business understanding along with hands on expertise across BI/BW solutions forfunctional modules like Sales and distribution, Material Management, Shipments, Billing, APO, etc.…
• Created Custom Tiles, KPIs, and groups in Fiori and worked on Custom Analytical queries to integrate CDS views with Fiori
• Actively involved in SAP ECC system migration to Amazon Web Services (AWS).
• I have proven skills in the BI Related ABAP at Start Routine, End Routine, Field level, Customer exit, DTP, Info package, Standard Data Source Enhancement, Generic data source creation…etc.
• Having Good Experience in HANA SQL Environment (Scalar UDFs, Design and development type Objects, Table Functions / Types, Stored Procedure, etc.…)
• Well versed with Analysis for Office (AO), Web IDE, SDI, Eclipse.
• Good Exposure on CDS Views, Annotations, Extend function, Authorizations, etc...
• As part of BI housekeeping activities deleted unused objects and data to save the space, deleted system logs like DTP runtime buffer, DSO activation, error logs to improve load performance.
• Ability to create Models, Stories, Geo reports, Analytical Reports etc.… in SAC
• Familiar with Roles and Authorizations setup related issues.
• Implemented Generic Delta queue mechanism to improve the generic extractor data load performance.
• Pre and post BWOH Migrations activates are Automated with ABAP and Excel Functionality.
• Designed Dash boards using the Visual Composer tool, Xcelsius, Web Application designer, Analyzer, Report Designer.
• Worked on various Proof of Concepts (POC), project effort estimations and resource mappings
• Having Knowledge on JAVA and Android Studio for mobile App development.

PROFESSIONAL EXPERIENCE

Confidential

SAP BI/HANA Lead Consultant

Responsibilities:

• Interfacing with customers for business requirement gathering, conducting system analysis and finalizing technical / functional specifications and creation of high-level design documents.
• Data Extraction from Non-SAP Sources by using Smart Data Integration and maintained Virtual Tables
• Various Housekeeping activates performed as part of system space clean activity and applied different techniques for back-end data loading performance and front-end query performance.
• Created and Maintained BADI for the Data Source enhancement.

Confidential

SAP BI/HANA Lead Consultant

Responsibilities:

• Migrated Deprecated Views (Attribute and Analytical Views) to Calculation Views
• Maintained pre and post migration documents
• Worked on Migration Assistant tool for XSA Migration
• Hana Views compared between cross system to check other projects dependency.
• Synchronized views with import and Export mechanism.
• Migrated scripted calculations views to graphical calculation views

Confidential

SAP BI/HANA Lead Consultant

Responsibilities:

• Compared Cost Centers Balance between cross systems.
• Currency conversion performed without deleting data from 1st level object
• Implemented dynamic code enable concept in transformation level as per the need.
• Actively Involved in various POC to create assets for the organization.
• For better reporting performance modified existing reports by having mandatory variables, Suppress the subtotals, keeping most detailed objects in free char Area, conducted user trainings to apply the conditions, exceptions in report output, RSRT properties.

Confidential

SAP BI/HANA Lead Consultant

Responsibilities:

• Performed BI Housekeeping activities and various methods applied for data loads and report performance.
• Automated year and month end data load activities by adding the code at DTP Level.
• Implemented flat file data source to pass the delete image across the data models for deleted records.
• Applied customer exit variables at Report and DTP level to avoid Repeated Report level changes.
• Designed operational reports and monitoring reports.
• Coordinating development with the Offshore/Onsite development teams.

Confidential

SAP BI/HANA Lead Consultant

Responsibilities:

• Worked on SAP BI7.5 Migration project as per the SAP Recommendations.
• Transported BI objects with import/export process as per the project need.
• Automated data objects properties comparison with excel functionality.
• Incorporated possible best practices for better performance/maintenance.
• Actively involved in ECC system migration to AWS.
• Mentoring resources and Team building.
• Reviewer of all the back-end and frontend changes/development.

Confidential

SAP BI/HANA Lead Consultant

Responsibilities:

• Worked on SAP BI to BWOH Migration environment.
• Handled various types of objects (ADSO, Composite Provider…) in HANA Studio.
• Implemented pseudo delta concept for heavy data loads to reduce the load time.
• Migrated SAP BI objects to HANA Environment with Migration tool.
• Migrated SAP BI objects to HANA Environment and Optimized BI Data models in HANA environment for better performance and maintenance.

Confidential

SAP BI Lead Consultant

Responsibilities:

• Worked on Data Model and Report performance tuning activities.
• Modified existing queries as per the enhancement requests received from the end user and provided Ad-Hoc Reports for their temporary use.
• Transported modified objects to Quality and production system by maintaining the proper test evidence By Using the Mercury Tool.
• Performed data reconciliation for missing/Not visible/incorrect data records and auctioned accordingly.
• Prepared reports to identify the long running reports, DTP, IPs and acted accordingly.
• Created Flexible Reports using Filters, Calculated and Restricted Key Figures, Exceptions, Variables and Conditions.
• Extensively worked on the Performance Tuning of the BI Objects
• Resolved different priorities (Critical, High, Medium and Low) of End user tickets with in the SLA By maintaining the proper work logs.
• Email broadcast bursting concept implemented to distribute the Reports.

Confidential

SAP BI Lead Consultant

Responsibilities:

• Resolved different priorities (Critical, High, Medium and Low) of remedy tickets within the SLA By maintaining the proper work logs.
• Handled different issues occurred during the BI System Upgrade and Automated the pre and post data comparison activities.
• Production System cleanup activity performed for unused objects (DSO and CUBEs).
• Worked with Information Broadcasting where we distribute BI information to different users in different formats and also in different schedules.
• Designed Dashboards using the Xcelsius Dashboard designing tool
• Used BW Statistics for various objects to keep track of the usage of the BW System and thereby increasing the Performance.
• Designed Dash boards using the Visual Composer tool for key performance indicators
• Implemented dynamic code enable concept in transformation level as per the need.

Confidential

SAP BI Consultant

Responsibilities:

• Integrated SAP BW queries developed using Bex with Web Application Designer (WAD)
• Resolved different priorities (Critical, High, Medium and Low) of remedy tickets within the SLA By maintaining the proper work logs.
• Worked on Bex Query Designer in designing queries using RKFs, CKFs, Formulae, filters, variables, and navigational attributes to facilitate flexible, detailed drill down data analysis to required level of information.
• Implemented Customer Exit variables to meet the client requirement and enhanced the Standard data sources.
• Designed and developed Process Chains (RSPC) for Master data loads and Transaction data loads and these Process chains are scheduled for periodic loads.
• By using LO Cockpit (LBWE), initialized Set-up tables. Scheduled and Implemented delta mechanism for periodic loads.
• Improved back-end data loading performance and front-end query performance by maintaining Aggregates, Compression, Partition, and Indexing for Info Cubes.

Confidential

SAP BW Consultant

Responsibilities:

• In BW system Installed Business Content Objects as and when required.
• Installed necessary Business Content Data Source in ECC System and created generic data sources
• Created custom queries and created Calculated Key Figures, Restricted Key Figures, Text Variables, etc..