SAP HANA/SAP BW/BObj Consultant

Summary:

** ***** ** ************ ********** in Design, Development, Implementation and Support of Business Application solutions using SAP BW: 3.x, 7.3 and 7.4 (on HANA), SAP HANA Studio, BI Platform 4.0

Extensively worked on requirements gathering from the business and end users, built business blueprints, did gap analysis and worked on development as part of the end to end implementations.

Worked on helping the user community in writing functional specifications and prepared technical specification documents for different application areas and involved in functional sign off before starting the development.

Worked with the Security teams to provide the necessary authorizations for the users inorder to access the reports and trained the users when needed.

Well versed with ASAP, AGILE and Waterfall methodologies in the project implementations.

Provided the developers with the User Acceptance Test (UAT) documents after the successful testing of the reports inorder to transport the development work across the system landscape.

Leveraged HANA DB over traditional Oracle, SQL and DB2 databases.

Very strong in HANA Studio, building Information models.

Worked with SAP LT, flat file loading, Direct Extractor Connection to replicate/load data into SAP HANA tables.

In-depth expertise in SAP HANA Live and Rapid Deployment Solutions (RDS).

Worked on Currency conversions for value and amount measures in the HANA models.

Worked on multiple FLC implementations in various modules MM, SCM, QM, PM, SD, PP, FI, SRM and CRM.

Good understanding of GTS process and tables involved.

Specialized in LO cockpit, FI-GL and Generic data extraction methods.

Expert in Hybrid, Composite Providers, Semantically Partitioned Objects, Open ODS views and Advanced DSOs (BW 7.4 features).

Well versed with LSA (w/o HANA) and LSA++ (with HANA) layers.

Thorough knowledge in BW admin, Performance Optimizing and Security admin tasks.

Coordinated with users from Sales/Materials/Finance departments to understand the requirements thoroughly and provide complex SAP BI reports by making use of BEx as well as BO front end tool set.

Dealt with day to day on-call support activities and ensured the SLAs are met.

Built Hundreds of BEx queries for sales and finance teams using BEx Query designer.

Good knowledge of ABAP Coding needed for writing routines at different levels in BW.

Expert in Calculated/restricted key figures, Customer exit variables, formula and text variables, structures, workbooks, RRI jump queries and broadcasting.

Launched web reporting on the enterprise portal using WAD.

Worked on implementing Integrated Planning in BW for a small scale project.

Knowledgeable in various BO tools (BI Platform 4.0/4.1) - Information Design Tool (IDT), Crystal Reports, Design Studio.

Experienced in building complex reports via Webi Rich Client for ad-hoc analysis.

Automated document scheduling, publishing and distribution of WEBI using broadcast agent server.

Hands on experience in Analysis for office, SAP LUMIRA.

Knowledgeable on Data Quality, Data Integration and Platform transforms of the BODS designer to massage, cleanse and load the data further to the targets using Data Services.

Proactive performer and team player with excellent communication and documentation skills.

Prepared training materials with supporting documentation and trained the team members on how to work with the new technologies.

Strong planner and organizer with demonstrated ability to master new concepts, incorporate the latest technology, and develop business solutions that increase efficiency, productivity, and profitability.

Certifications:

C_HANAIMP131: SAP Certified Application Associate (Edition 2013) - SAP HANA

C_TBW55_73: SAP Certified Application Associate Modeling and Data Management with SAP BW 7.3 & SAP BI Platform 4.0

Trainings from SAP: Virtual Classroom training from 6/24 to 6/28 in 2013

HA100 (SAP HANA Introduction)

HA300 (SAP HANA Implementation and Modeling)

HA362 (SAP Netweaver BW, powered by SAP HANA)

Education:

Bachelor of Technology (B.Tech) from J.N.T.U. Hyderabad.

Professional Experience:

SAP BW/BI/HANA Principal Consultant February 2016 to till date

Client : JABIL Circuit FL, USA

Environment : SAP ECC 6.0, BW 7.3 & 7.4, BI Platform 4.0, SAP LUMIRA, Native HANA Development

Modules : PM, QM, GTS

About JABIL: JABIL is an electronics solutions company providing comprehensive electronics design, production and product management services to global electronics and technology companies. The company has industrial design services that concentrate on the look and feel of plastic and metal enclosures which hold printed circuit board assemblies and systems.

Responsibilities:

SAP HANA/BW Architect:

Worked on performance tuning methods like SQL Tracing, Expensive statement trace and analyzed the SQL execution with the plan visualizer as well as Explain_Plan_Table.

Used smart data access to connect to remote datasources like SQL server which was used to create Open ODS views in SAP Business Warehouse environment.

Created triggers in HANA Studio in order to know who and when changes were made to a particular table.

Partitioned the tables in SAP HANA on the basis of HASH/Round Robin/Range partitioning methods.

Knowledgeable in Application Function Library’s components like Business Function Library (BFL) and Predictive Analysis Library (PAL) from SAP HANA.

Trained other teams on the basic concepts of HANA and creation of different design time and run time objects in HANA Studio as part of the knowledge sharing sessions.

Modeled decision tables in order to implement the business rules into HANA database.

Monitored system status and warnings within Administrative perspective of HANA Studio.

Implemented SAP HANA Live for real-time reporting on SAP MM and SD modules by installing calculation views into HANA.

Knowledgeable in backup and recovery in SAP HANA by using log and data volumes.

Worked on building Quality Management queries in SAP BW environment by means of the standard extractors like 2LIS_05_QVUDN, 2LIS_05_NOTIF, 2LIS_05_QE1/QE2 and 2LIS_05_TASK etc... along with Inventory data sothat the users can view the Quality managed materials for a particular Inspection Lot from the Quality tables.

Worked on reporting on top of SAP GTS (Global Trade Services) in BW to display tariff code numbers, commodity code numbers, common agricultural policy (CAP) and the relevancy of goods for custom treatment by means of transactional data source 0SLL_CD_1 (Custom Documents).

SAP LUMIRA Consultant:

Built and published Sales analysis across the regions, trend analysis and market share storyboards using various datasources by connecting to HANA view, Downloading data from a HANA view as a dataset, Universe(BO/BI) and SAP BW(BEx query) as the datasets

Built and published custom adhoc storyboards using datasources like Microsoft Excel, Text, Clipboard and SAP BW as the datasource for the business users across various business functional areas

Well versed with LUMIRA desktop, Cloud and LUMIRA server in the Business Suite Architecture

Trained the user community on the usage of SAP LUMIRA and created quick reference cards for reference on various functionalities and features within LUMIRA.

Knowledgeable in moving LUMIRA projects from Desktop to LUMIRA server.

SAP BW/BI Lead Consultant November 2011 to January 2016

Client : JABIL Sdn. Bhd. Penang, Malaysia

Environment : SAP ECC 5.0, SAP BW 7.3, SAP HANA, BEx, WAD

Modules : SD, CRM, SRM

SAP HANA Developer SR.

Gathered and analyzed the requirements to replicate real-time data from the ECC systems into SAP HANA using SAP LT replication server to get the latest data out of MSEG/MKPF/BSEG and BKPF tables.

Went live with multiple projects in SAP HANA SP8/9/10.

Extensively worked on the Modeler perspective of HANA studio and developed multiple Analytic views for the transactional data, Attribute views for the master data and Calculation views as final models in HANA Studio.

Developed information models for Inventory and Quality Management work streams in HANA.

Utilized SAP BW tables as a source to build complex models in HANA.

Created scripted procedures in HANA Studio which can be called in the calculation views.

Worked on developing Analytical Privileges, Delivery Units, Packages for the information models.

Used SQL scripts (CE_*) inorder to build Calculation views and procedures and used Debug perspective to trouble shoot the code when needed.

Worked on converting the value and amount fields (Sources include fixed as well as variable currencies) to a fixed currency to meet the user requirements via Analytic views

Made use of Rapid Deployment Solutions to estimate the completion and the cost needed for implementing HANA Live into the systems for reporting needs.

SAP BW/BO Architect:

Effective from April 2015, Malaysia implemented GST (Goods Service Tax) which is imposed on goods and services at every stage of the production and distribution in Supply chain hence there was a need to implement this in JABIL. Hence I worked with the business in creating functional specifications for couple of BW reports which reflects this information and worked on the development.

Made copies of the standard cube (0SLL_C01) and DSO (0SLL_DS01) as part of standard BW GTS content to report on the information at the Header and Item level for each custom document such as shipment and declaration.

Built queries like Imports per Product, Imports per Country, Import Analysis as part of GTS implementation in SAP BW.

Replaced long running ECC queries like PM-01, PM-02 etc... built on infosets with the flexible BW queries thus reduced the load on ECC systems.

Created a BW report for an Asia site which monitors and tracks the creation of SD/MM documents and the user can sort the data using Sales Document number. To fulfill this requirement, I combined the tables like VBAK, VBAP, EKKO, EKPO, EKBE, LIPS, LIKP and the billing tables VBRK, VBRP by means of ABAP routines in the transformations.

Built Inventory accuracy and Book to Physical reports which give the detailed information about the Inventory statistics on the System & Counted quantities and the % tolerances of the Materials.

Created Composite Providers to combine the Purchase Order data with the Info Record data to get the Sales Tax Codes of different Purchasing Documents for further analysis.

Created Vendor Master Queries to track if a buyer creates PO with a different tax code from info record and vendor with supplier GST (Goods & Service Tax) registration number. Buyers will then have visibility of PO issued with wrong tax code and easy access to check if a vendor has GST registration or not.

Worked on pulling Supplier Relationship Management (SRM 7.0) data into BW to build BEx queries like PO Status, PO Overview, Shopping cart to PO to view the follow-on document that is originated from a shopping cart.

Extracted the data out of SAP CRM system into BW to build Campaign revenue/costs per channel, product, customer etc., Customer Profitability, Campaign response rate, Marketing responses, Campaign Effectiveness reports

Built Warehouse Inventory Accuracy and B2P reports on the warehouse tables which provide the required information on Warehouse quantities and the % tolerances.

Made extensive use of various Exceptions available via Web Analyzer (Status and Trend) to display the Accuracy reports with different background visuals sothat the report clearly shows the relation between A, B, C indicators and their tolerances.

Developed the Stock Queries to view the Snapshot of daily stocks which also give the pricing information of Consigned/non-consigned Materials by means of the Standard Inventory extractor 2LIS_03_BX.

Migrated certain long running Inventory ECC queries to BW inorder to reduce the load on the ECC PRD server.

Followed LSA, LSA++ concepts to build new data models sothat the designs are more robust and easy to understand.

Worked on building the Virtual Providers to extract the data directly from the flat files to see the up-to- date information from non-SAP systems.

Created Hybrid Provider to report on the real time data by using a standard DSO based on real time data acquisition and a standard cube for faster query results and for tactical decision making.

Worked on Open Hub Destinations as there was a need to export the data in XML format.

Was part of a team during the upgradation of BW landscape from 3.X to BI 7.3. This involved comparing before/after images of the existing DSs & reports and to make sure the delta mechanism is not disturbed.

Worked on migrating the 3.X dataflows to 7.3 by creating Transformations, DTPs, HANA Optimized infoproviders.

Wrote numerous ABAP routines in the transformations to meet the complex business needs. Expert in object level routines in the DTPs and infopackages.

Worked on debugging the existing ABAP routines and tune those where needed for better performance.

Created various generic extractors based on Function Modules using ABAP code to combine multiple tables.

Created Customer Exit Variables for complex reporting requirements for date fields via Business Explorer.

Worked on creating Error Stacks and Error DTPs to remove the garbage data with minimal effort.

Worked extensively on Application Process Designers (APD) to grab the data from the existing reports and transform them into flat files to suffice the complex business requirements.

WEBI: 4.x

Developed high end interactive Web Intelligence reports from the scratch with cascading prompts, drillable hierarchy levels, custom date/time prompts, variables, filters and multiple open document links.

Used BW queries as the source via a BICS connection and built some quality WEBI reports for better presentation to the user community.

Created monthly as well as summary reports via Webi 4.0 for different domains like Finance, Sales, Inventory data.

Conducted training sessions for the end users, power users on how to build simple Webi queries and how to view the data for better slice and dice analysis.

Enhanced the existing Webi reports and scheduled them as per the business needs.

Made use of different charts, graphs in developing the reports.

Developed complex queries using combined queries and merging.

Created trending images and used them in WEBI to show the trending of the data.

DESIGN STUDIO: Ver 1.4 and 1.5

Used BW and HANA Models to build applications in Design Studio for the user community.

Used QR code scanning for displaying an application on Ipad.

Created RRI jump targets for BEx query applications in the studio.

Made use of Analytic, Basis components in designing an application for exporting data from cross tab to excel.

Created list box for multiple selection capabilities, to bookmark and personalize an application, to pass URL parameters between applications.

Generated several applications for Sales and MM users.

Worked with scripts to trigger multiple actions in an application, define global and local functions and set up cascading filters.

Other BO flavors:

Developed various jobs in Data Services to enable the data transfer between BW/ECC and HANA systems.

Expert in transforming data and maintaining Data Quality, Data Integrator and Platform transforms

Extensively worked on Variables and Parameters in the workflows and dataflows to increase the design flexibility.

Used try/catch methods to troubleshoot the errors while executing the jobs and sending the error message to the person responsible via an E-mail.

Created various trend analysis reports and Client invoice reports.

Used BW BEx queries as the backend for building Crystal reports for different groups in the organization.

Customized formatting for screen fits and exported reports in MS Excel, PDF, MS Word and CSV formats.

Created prompts, alerts, drill down on the reports for the Users as per their request.

Generated reports with Parameters, sub reports, cross tabs, charts.

Worked on modifying existing reports to optimize and troubleshoot accommodate business needs.

Created reports via Analysis for MS Excel using BW and HANA models as the source.

Company : JABIL Circuit India February 2007 to October 2011

Environment: SAP ECC 5.0, SAP BW 3.5, Inventory Control, Warehouse Management,

Sales & Distribution Purchasing and BW Support

Sr. BW Developer/Lead & SAP BW Support Lead

Worked as a center point of contact between Asia and America regions as a support lead to make sure daily loads are running without any issues. Documented the known errors and issues to avoid the repetition in future and shared it with the BI support team members.

Actively participated in the monthly PRD downtime maintenance activities as part of the support structure to make sure the data is not lost from the delta queues. Notified the Users and the customers in case of delays due to loading issues.

Involved in training the User community on how to use the BI reports and explained the basic terms of BI reporting. Created documents which explain relevant info on a particular report and added those as Query documents sothat the user is aware of the details required to understand the reports.

Made sure that the daily data loads are running fine and fixed the data loading errors.

Worked on High-Priority tickets related to data load monitoring issues and made sure the SLA is not missed.

Represented BW team in the weekly support meetings with the higher management.

Resolved numerous tickets related to report enhancements.

Worked on Purchasing reports using the Standard Header (2LIS_02_HDR), Item (2LIS_02_ITM) and Schedule line (2LIS_02_SCL) datasources to provide the PO history, PO detail and PO requisition reports. These reports were used to compare the Standard Price with the PO price to make a better understanding of the Purchasing level within the Organization.

Worked on building SD reports like Sales, Delivery and Billing information by using standard Business Content Header, Item, and Schedule lines DataSources.

Worked extensively on Multi Providers to combine the Inventory and the Purchasing data to view the Purchase Order and PO Value for any given Material, Plant and Storage Location on a given Posting date.

Worked on writing complex start routines to get the data from different infoproviders by means of lookups.

Extensively worked on InfoSpokes and Open Hub Destinations and writing BADIs to combine the data from different sources to send it out of BW using logical paths.

Well versed with running the Shell scripts using C prompt incase of an automated script failure.

Used BW Statistics, Query monitor and created Indexes, Aggregates to enhance the query performance.

Developed jump queries (RRI) to provide the users with the detailed level of information.

Used Information Broadcasting to distribute the reports in HTML formats/Online link to the current data to the users via E-mails.

Worked on creation of Customer Exit variables on date fields.

Expertise on Status and Trend Exceptions and various types of Conditions (Ranked list, Threshold value and mixed Criterion) in Web Analyzer.

Completed one full life cycle implementation on Inventory Management and Warehouse Management (IMWM).

Extracted data out of Standard Inventory Extractors (2LIS_03_BX, 2LIS_03_BF and 2LIS_03_UM) and built the Material Movements queries to view the Stock and Movements’ on a particular Posting Date at the Plant/Material/Storage Location level.

Built Custom Inventory Cube by copying 0IC_C03 to meet the business requirements. Wrote start routine to include the ‘Z’ movement types into the cube to get the accurate Inventory information.

Enhanced the standard Movements extractor (2LIS_03_BF) by adding fields from MSEG/MKPF & T157E tables to satisfy the reporting needs.

Initialized the Stock using 2LIS_03_BX for Inventory Management during a quiet time when no postings are done to get the accurate stock levels followed by loading the Historical Movements/Revaluations into the Inventory Cube and compressed the data using proper Marker Updates.

Staged the data at the first level by building ODS objects on top of Movements and Revaluations DataSources sothat the data can be reported at the detailed level and could be compared with the source data.

Worked on building custom datasources using table views to report on Goods Receipt Labels (MSEG extension data), Warehouse tables like LQUA, LTAP, LTAK and Feeder Numbers which were further used for Inventory Data analysis.

Worked on BW Statistics InfoCubes to enhance the performance of the system and query run times after looking at the details from their output.

Company : OPUSASIA Technologies July 2004 to January 2007

Environment: SAP R/3 4.6C, SAP BW 3.0B and 3.5

About the client: OPUSASIA is a SAP implementation partner located in India. It delivers Global Enterprise Resource Planning solutions and mostly implements Supply Chain, HR and CRM models for their clients. I was part of Mohan Breweries and Distilleries Ltd. India project wherein I worked on completing FLC implementation in IMWM and SD modules along with providing support for the BW job monitoring, handling tickets and maintaining SLA.

Responsibilities:

Involved in implementing SDLC in Inventory and Warehouse Management.

Interacted with the management and end users for writing functional specifications and conducted GAP analysis.

Extensively worked on data extraction for Inventory Control module from 2LIS_03_BX, 2LIS_03_BF and 2LIS_03_UM for providing the users with Movements and Stock information as part of Inventory analysis.

Created Stock Overview, Backlog Stock, Valuated Stock and Material Movements reports for the user community.

Worked on setting up delta mechanism for the standard as well as custom data extractors.

Used BW statistics to analyze the query performance.

Used reporting agent for exception reporting (Alert Monitor) and for printing reports in the background.

Developed queries using filters, navigational attributes, variables, calculated and restricted key figures in BEx analyzer to facilitate data analysis in a drilldown or summarized way to give detailed level of information.

Involved in creation of update rules, modifying communication structures and support infopackage creation.

Supported functional design and review existing queries, dataflow diagrams and multi-dimensional data models.

Built infocubes, infoobjects, ODS, transfer rules and process chains.

Diagnosed and modified queries and worked on improving load performance.

Scheduled automatic data loading process by creating process chains and enabled automatic deletion of requests before loading latest data into the infoproviders.

Attended weekly meetings with the management to discuss the critical issues and the actions taken to resolve those along with status updates.

Trained new team members on the basics of BW and helped them in bringing upto speed.

Loaded data from flat files into BW system for one time huge loads and via DB Connect for non-SAP databases.

Integrated data from different application components in BW by building Multi Providers to create reports like Material Movements with price information from Material Valuation table (MBEW).

Extensively worked on performance tuning by creating aggregates, compression, indexes, partitioning and statistics.

Managed BW security by creating Roles and authorizations for different users.

Involved in all phases of the project from blueprinting, configuration, development, integration testing, cutover, training and go-live.

Conducted training for the end users and project team members. Developed different training materials for different users based on their roles and mentored BW users on BEx Analyzer and browser.

Worked as a support lead in Post-Production support.

Contact this candidate