SUMMARY

• Managed migrations of BW on HANA and Upgrades within BW,Hana, and ECC
• Solution provided on Embedded Analytics for Finance and Sales and Distribution.
• Extensively worked on S/4 Hana Embedded analytics and designed solutions.
• Worked on CDS views on S/4 HANA analytics and content driven models.
• Implemented Virtual data models for applications such as Sales and Distribution, Material Management and Finance with huge Customizations.
• Worked extensively with SAP HANA Models and HANA as BW Database and BW Models Integrated.
• Developed Calculation, Analytical and Attribute views and worked with Analytical privileges from Security standpoint.
• Strong experience on Eclipse platform and developed and Modeled on HANA studio/Eclipse for HANA models and BW 7.5 versions objects.
• Completely understands the Eclipse tool set and the HANA components on the Eclipse platform.
• Designed and implemented 4 SAP BW systems & worked on various phases of the project starting from Blue print, Design, Functional specs, Technical specs, Developments and Testing.
• Very good knowledge and complete understanding of BW/4HANA developments and use cases.
• Maintained BW and BOBJ OLAP applications for sales, finance, Vistex, SPM & HR.
• Provided guidelines to maintenance, data loading & monitoring procedures to the clients.
• Improvised system performance with remodeling & established day to day operation procedures.
• Designed ADSOs, Open ODS views, Composite providers and have extensively leveraged the new BW 7.5 features.
• Expert in designing and developing standard and custom Info cube, DSO objects, info object catalogs, Infoobjects, Transformation, Infopackage, DTP, Datasource, Characteristics and Key figures, Multiproviders, Business content, WODSO, Process chains.
• Administer data warehouse (BW and BI).
• Excellent ETL background with data warehousing for Extract, Transform logics. Completely understands the ETL process and various design/models in the ETL space.
• Have delivered POCs with new tool sets understanding the overall business requirements.
• Utilize ABAP and SQL procedures for data transformation into data warehouse.
• Design data models for BW analytical and BOBJ operational reporting tools.
• Integrate data from external sources into data warehouse using Business objects data services.
• Worked with security teams to setup BW roles for several reports across most of the applications.
• Very good knowledge and understanding BIG Data tools and Hadoop technologies and tools like HDFS, MAP Reduce, Hive and Talend.
• Good knowledge on SAP BODS connectivity’s, extractions and loading in to HANA Database.
• Designed solutions using various reporting tools on the front end and have authenticated the feasibility to use on various OLAP applications.
• Developed executive Dashboards and Reports using Tableau and Power BI.
• Have extensively worked on Creation of metrics, attributes, filters, reports, and dashboards. Created advanced chart types, visualizations and complex calculations to manipulate the data.
• Created several reports using Bobj tools on top of Bex queries using Crystal reports and Webi.
• Excellent skill set in building Bex queries using Reusable structures, filters, Restricted Key Figures, Calculated Key Figures, formulas, conditions, and exceptions.

TECHNICAL SKILLS

Operating Systems: Windows XP/ NT/, UNIX

ERP: SAP R/ 3 4.7, ECC 6.0 and S/4 Hana

Data warehousing: SAP BW 3.5, BI 7.0,BI 7.3, 7.5,SAP HANA SPS 12. BW/4HANA, SAP BODS

BIG Data: HDFS, MAP Reduce, HIVE and TALEND

Databases: Oracle, SAP HANA

Reporting: SAP Business Objects (BI Launch pad, WEBI, Dashboards, Crystal Reports and Lumira

Analytics: S/4 Hana Analytics

Testing: HP Quality Center

Functional: SD,MM,VISTEX,FI,FSCM,COPA,SPM

PROFESSIONAL EXPERIENCE

SAP S/4 HANA Implementation

Confidential

Environment: SAP S/4 HANA Embedded Analytics, Tableau and Power BI

Responsibilities:

• Involved in Blue print design and Functional and Technical specs development.
• Set up of SAP S/4 HANA Embedded Analytics with CDS views for Applications such as SD and FI.
• Extensively worked with CDS views using various Virtual data models.
• Built Sales orders received and uncommitted sales order KPIs, leveraging the Sales Delivered Virtual Data Models with huge customization.
• These KPIs have been customized to return the User specified date range for Internal/External and Intercompany Orders and both revenue and non - revenue generating Orders.
• Worked with Basic, composite and Consumption views at various levels.
• Worked on Vistex various Modules for several KPIs part of Vistex like Sales Incentives, Sales Rebates, Global Claims, Transaction Register areas.
• Extensively dealt with Different Vistex tables in ECC and completely understands the ECC vistex addon and BW business content.
• Heavily customized with IP Documents and how it’s been utilized in ECC, the way data is being driving from Sales orders and how it’s been processed for Incentives, Rebates and claims.
• KPIs designed for Material Management applications for Purchasing and Inventory areas.
• KPIs built for Sales Backlog, open Orders that are yet to be delivered. These are Orders, that are to be delinquent and orders with future date.
• The Backlog orders metrics show the open order quantity and value based on the delivery date. Solution for two quantity/value combinations Customer Required Quantity value and Current Scheduled Quantity value.
• Built Customer Account Receivables BI data needs with Aging buckets to display the Open Amount yet to be received based on the Base Line date.
• The Payment terms have been further adjusted to align with BI data needs.
• Dealt thoroughly with Various Annotation types and have used them extensively to meet the development requirements.
• Extensively leveraged the Basic Views to design Composite and Consumption views.
• Implemented huge customizations throughout the process using the views.
• Consumed the views to Tableau and Power BI for advanced reporting.
• Worked in complex BI Reports, Dashboards to designed various Metrics.

SAP BI/HANA Implementation

Confidential, Arkansas

Environment: SAP HANA, SAP ECC 6.0, SAP BI 7.5, Business Objects

Responsibilities:

• Created various use cases and related data models in HANA for Sales and distribution, Finance, MM and Vistex.
• Created ADSO, Open ODS views, Composite providers and new features of BW 7.5
• Converted Enterprise Data Management based Schema views such as Analytical/Attribute views to Calculations views.
• The EDM layer sources data to several applications such as PPS,TBM and BW.
• Delivered Vistex Reports for Trade analytics which pulls the information from Sales Incentives logs, Sales Rebates logs, Claim logs and COPA. These reports explain in detail information of the overall Trade process for all the IP Documents created.
• Developed Sales View by Billing and Delivery KPIs that gives a comprehensive understanding of the Sales Orders with respective to the Billing and Delivery status.
• These reports are built with standard structure as well as adhoc basis to give feasibility for the Business to view sales order at different granularity.
• Has extensively involved in Migrating BW 7.3 to BW 7.5
• Created various use cases and related data models in HANA for Sales and distribution, Finance, COPA and Material management including Inventory.
• Extensively worked with Material Management area and created various reports for both Purchasing and Inventory applications and completely understands the Functional process and BW mechanism to handle and deliver BW/HANA based reports.
• Worked with various Inventory extractors to handle Movements and Revaluations and created Historical weekly snapshots, Target Inventory and Manual adjustments. Also used mixed scenarios between BW and Native Hana models.
• Worked KPIs for Daily Inventory Base adhoc, Intra company Movements, Rolling weekly Inventory Balance History, with customizations as required in ECC/BW/HANA with different modeling mechanism.
• Created complex Calculations views with lot of customization to deliver the KPIs specific to each functional area.
• Involved in Blue print design and Functional and Technical specs development.
• Created various Views like Analytic, Attribute and Calculated and Analytic privileges.
• Leveraged the features like calculated columns and restricted columns to perform various operations to finalize the data models.
• Integrated BW Imported DSOs to use them as Analytical views to combine them in different calculated views to suit to the data model.

SAP BW Implementation and Support

Confidential, Arkansas

Environment: SAP ECC 6.0, SAP BI 7.3, Business Objects (Crystal reports and Webi).

Responsibilities:

• Involved in setting up the procedures for extracting the data from ECC by using the LO COCKPIT and GENERIC extractions
• Extensively involved in modifying the mappings that generated after migration from 3x to 7x BI
• Fixed errors related to transformations.
• Complete migration of 3x dataflow to 7x.
• Used latest features of SAP BI 7.3 like data flows, Semantic Partitioned Objects and Optimized infocubes and DSOs.
• Create Query and process chain log documents.
• Created and maintenance of Info Objects, DSO, Cubes, Transformations, DTPs, Data Sources

SAP BI Implementation

Confidential

Environment: SAP ECC 6.0, SAP BI 7.1, SAP BPC

Responsibilities:

• Developed Custom Generic Data Sources through Views
• Worked with Early Watch Reports for improving the loading and Query Performance
• Extensively worked with FSCM end to end Testing using HP QC
• Interacted with Client very frequently understanding the requirement for creating various type of reports
• Worked with Performance related issues like Aggregates, Partitioning and Compression
• Monitoring of info packages and analyzing the reasons for frequent failures of info packages
• Developed load strategy and created process chains to schedule the loads on daily, weekly and monthly

SAP BW Implementation and support

Confidential

Environment: SAP ECC 6.0, SAP BI 7.0

Responsibilities:

• Installed Business Content Objects as and when required
• Extensively involved in setting up the procedures for extracting the data from ECC by using the LO COCKPIT and GENERIC extractions
• Created Generic Data sources using Tables and Views for extracting Master and Text Data.
• Uploaded master and transaction data from flat files
• Collected, released and imported the BI Objects from Development to Acceptance to Quality boxes
• Direct interaction with the business users
• Created and maintenance of Info Objects, DSO, WODSO, Cubes, Transformations, DTPs, Data Sources
• Created and maintained queries in BEx Query Designer and BEx Web Application Designer for analysis and web reporting respectively which are published in Enterprise Portal
• Developed Custom Generic Data Sources through Views
• Involved in escalating prioritized tickets regarding extractions, performance issues and load failures. Analyzed and corrected production problems as they occur in the SAP BI
• Successfully scheduled repair full loads for master data attributes and master data texts whenever new attributes or texts enhanced.
• Fine tuning of the performance issues by handling the indexes, aggregates and compression
• Shared knowledge to team members for different objects and maintained healthy people relationship management, to maintain teamwork
• Attending day by day meetings like Internal Review Meeting, Quality status and Client Review Meetings

SAP BW Implementation

Confidential

Environment: SAP R/3 4.7, SAP BW 3.5

Responsibilities:

• Interaction with users to resolve BW reporting issues
• Enhancement of Data source
• Installed Business Content Objects when required
• Changes made to existing reports as per requirements of users
• Actively and regularly involved in Load Monitoring of Daily, weekly, and Monthly Data Loads using Process Chains
• In case of data load failures, involved in analyzing the errors, and took corrective actions
• PSA Data Deletion on weekly and monthly basis
• Involved in submitting the Ticket Status (Open/Close) report
• Involved in Validated data consistency in reporting with Data Target against PSA after loading them to data targets
• Extensively worked on modeling SAP BW objects like Info Objects, Info Cube, ODS, Info Source, Transfer Rule, Update Rules, Multi Provider.