Lead Sap Bw / Bi Consultant Resume
2.00/5 (Submit Your Rating)
SUMMARY
- Having around 14 years of experience as SAP BI/BW HANA, SAP Native HANA Consultant/Analyst with strong expertise in BW 7.5/7.4/7.3/3.5 , ECC 7.0, Bex, Business Objects, Power BI, Integrated Planning (IP), BPC, BPS and SAP ABAP (BI Enhancements).
- Extensively involved in Business Blueprint/Requirements gathering, Gap analysis, Project Scoping, Sizing, Preparing Functional and Technical Specifications, Functional Design and Modeling, Functional Unit Testing, Performance Testing, Integration testing, Regression testing cycles and End User Training and Documentation.
- Strong experience in Reporting and Analytical tools and extensively involved in report building practice with users on Analysis Office and WEBI.
- Experience with HANA design Studio and creating data tables using SQL in HANA studio and migration of Meta data.
- Good Knowledge on SAP BPC and BPC data flows in designing Actual Vs Planning forecast overview reports.
- Expert in BW on HANA migrations and post migration optimizations, enabling real - time and near real-time data acquisition by migrating/pushing ETL processes to native HANA.
- Strong experience in creating Calculation views using Star Joins, Filters, Input parameters, Variables, Calculated Columns for complex KPI’s and deriving Time Buckets joining Dimension Views.
- Experience on business process reengineering for corporate reporting solutions, reporting performance optimization, data modeling using different types of graphical views and SQL.
- Experience in Design and develop Native HANA data models using Graphical and SQL Scripting views to deliver SAP Business Financial Application.
- Experience with SAP FI-FM, FI-CO,CO-PA, MM, SD, SM, PM, CRM 7.0, PS, and PM module integration into the SAP Business Warehouse (BW 3.5, BI 7.0, 7.1, 7.3, 7.4, 7.5) with HANA.
- Strong experience of SAP BI report design techniques, implementation and supporting complex reports (Query Designer, Bex Analyzer, WAD, Web Intelligence) and knowledge of Analytical tools like Explorer, OLAP, Dashboards and SAP Lumira.
- Worked on a full life-cycle implementation project involving gathering of functional requirements, analyzing data flow, performing data provisioning using SLT, creating graphical views on SAP HANA Architecture and creating reports using BEx, Lumira and Webi.
- Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
- Strong experience in ABAP with implementation knowledge of Start Routine, End Routine, Using Enhancement Spot and BADI for BW Extractor enhancements and Customer Exit variable Enhancements
- Extensive experience with multiple Industry models Consumer Goods & Services Industry clients and Resources Clients implementing End to End projects and Application Maintenance projects.
- Extensive experience in handling data extraction and integration to BW with SD, FI (AP, AR, G/L), SRM, & HCM modules and non-SAP source systems.
- Experience in implementing the data models for Operational reporting for Shipment Delivery Analysis, Perfect Order Analysis, OCSL, Procurement, Cross Functional planning, Production Planning areas.
- Data flow modeling in BW on HANA using Composite Providers, Advanced DSO, Info Objects, Info Cubes, APD, SPO’s, Virtual Cubes, Multi-providers, Open Hub Destination, Info sets, Aggregates, ODS/DSO objects, Data Marts, Transfer Structure, Transfer & Update Rules/Transformation rules and Data Sources.
- Native HANA MODELLING - Designing Views (Attribute View, Analytic View, Calculation View), Stacked Calculation Views, Views that needs multiple table functions, counters, Restricted and Calculated measures, input parameters, filters, transparent filters. Debugging Views. HANA Modeling using SQL Script and CESQL scripting.
- Having Strong Knowledge on SAP HANA Data Modeling using Attribute views, Analytic Views and Calculation Views (both Graphical & SQL script based) & SAP HANA data provisioning using SAP LT Replication Server (SLT).
- Extensively involved in data extraction of LO Cockpit, Generic, COPA, CRM, SRM, FI-CO, FI-TM, and non-SAP data using DBCONNECT into SAP BW.
- Enterprise reporting with Business Objects Webi, BEx Query Designer, Analyzer, WAD and Dashboard Designer. Developed Complex BEx Queries using CKF, RKF, Variables, Structures, Filters, Free Characteristics, Conditions, Exceptions, and RRI.
- Experience in interacting with Business users in analyzing the Business process requirements and transforming them into documenting, designing, and rolling out the deliverables.
PROFESSIONAL EXPERIENCE
Confidential
Lead SAP BW / BI Consultant
Responsibilities:
- Worked with SAP Functional and SAP BI team in requirement gathering from Business Community.
- Implemented SAP Native HANA Data Models, Calculation Views, SLT, SAP HANA SQL scripting for Procedures, Views, Custom Functions, etc.
- Created SAP HANA information models such as Procedure and HANA Views (Attribute, Analytics and Calculation views) with graphical and SQL Scripting, SDA (Smart Data Access), SAP HANA Live (Analytics)
- Experience with SAP HANA migration & Optimization - HANA Sizing and performance tuning
- Configured SAP SLT, Hadoop Integration ecosystem and Spark
- Developed packages using SAP HANA using BODS, SDI, SDA and SDQ in SAP and Non-SAP Data Sources
- Worked on SAP HANA for its interfaces with SAP BW and SAP BO.
- Worked on SAP HANA Web IDE, HANA Cloud Platform and HCI
- Developed SAP HANA models on real time replicated data from SAP ECC and CRM systems.
- Table functions as data sources replacing scripted calculation views
- Designed and developed reporting for various functional areas like Sales and Distribution which includes Subscriptions, Accounts Receivable and Accounts payable and FSCM.
- Developed different Web Intelligence reports such as Summary and Detail reports, Cross Tabs with multiple tabs and charts, drill down functionality and calculating complex variables like dynamic rolling forward months and so on
- Developed Complex Crystal reports with lot of variables to calculate YTD and MTD matrix like Beginning Balance, New balance, Change and etc. on top of SAP BICS, SAP BW MDX query and ECC tables
- Created dashboards on Design Studio 1.6 version for Annualized revenue analysis for Leadership team- using GEO maps, Cross Tabs, Script editor, score cards on different data sources such as SAP HANA, SAP BOE, and SAP BW
- Used Information Design Tool to design Universes for HCM reporting
- Used Universe Designer to design and develop Relational Universes on SQL for Product Usage
- Developed OLAP Universes for on top of SAP BW queries
- Enabled Auditing Service on all relevant Servers in CMC and created audit reports
Confidential
Sr. SAP BW HANA Consultant
Responsibilities:
- Created reports based on the snapshot data aggregating Actuals and Plan for different planning seasons.
- Involved in Execution of test cases and fixing the defects raised during the SIT and performance testing for different Organizational region data.
- Also involved in administration tasks such as publishing workbooks, setting permissions, managing ownerships, providing access to the users, and adding them to the specific group and scheduled instances for reports in Tableau Server.
- Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
- Involved in Report building practice sessions on Webi and Tableau with Business users.
- Activation of BW Content (v.7.4), customizing BW solutions on HANA, creation of HANA Views, data flow, enhancing transactional and master data standard extractors, construction of different types of Info providers, universes, Query development in SAP BEx and SAP BO WEBI, performance tests, data-load process chains, incidences attendance and elaboration of functional and technical documentation, etc.
- Worked on creating Attribute Views, Analytical views, and Calculation Views. Developed HANA Views and Composite providers within BW reporting and BOBJ reporting
- Worked on creating Data models optimized for LSA++ Architecture and HANA enabled Data models.
- Involved in End to End development of Product Master from MDM, Customer Master from MDM, Date master data dimensional views.
- Extracted data related Point of Sale, Inventory and OTC functional areas from different source systems, cleansed, converted, and loaded the data into BW system.
Confidential
SAP BW, BI Lead
Responsibilities:
- Ensured that business capabilities and data were adequately addressed after corporate move to SAP.
- Established user community to track issues, enhancements, and newly identified requirements.
- Wrote business cases, requirements, mock-ups, test plans, and documentation for new reports in SAP to cover gaps between initially delivered SAP functionality and business needs.
- Evaluated business processes, anticipated requirements, and developing and implementing solutions.
- Leading ongoing reviews of business processes and developing optimization strategies.
- Staying up to date on the latest process and IT advancements to automate and modernize systems.
- Conducting meetings and presentations to share ideas and findings.
- Performing requirements analysis.
- Imparted Training on Business Objects- Universe Designer, Xcelsius, Crystal Reports, Webi Reports and Deski Reports.
- Awareness on DXC & Sybase replication process flows for Data-Provisioning to SAP HANA
- Good understanding of various components of SAP HANA.
- Worked on creating Attribute Views, Analytic Views & Calculation Views.
Confidential, Wilmington, DE
Lead SAP Business Intelligence and Business Analyst
Responsibilities:
- Worked on maintenance of Purchase Requisitions and Services and analyzed the data by extracting Data from Purchasing, Service master and Plant maintenance Tables and prepared the Reports using ABAP Query Report tools.
- Analyze information concerning markets, competition, and past marketing initiatives to understand how well the marketing campaigns and programs are performing and to influence the success of future marketing initiatives and campaigns during planning.
- Worked on Material Master, Purchasing Info records, Equipment master, Plant Maintenance Master data, Task lists and PM orders.
- Worked on Vendor Diversity Reports.
- MM Stock aging analysis and Slow moving and Non-Moving report.
- MM Department wise consumption report
- Logistics report
- Applied Material Analysis report (Plant wise, Category Wise, ABC Indicator wise, Functional Area Wise)
- Material Consumption Analysis report.
- Manufacturing plant wise Dashboard which consist of Comparison of Goods Issue date and Reservation Need Date.
- Inventory By plant report.
- In addition to the above reports worked on System Forecast Accuracy; Inventory Dollars, Inventory Turns, No of Not in Stocks and Purchase Requisitions
- Planning, delegating, and executing Cutover Activities for Kernel Upgrades, Support Pack application and Linux Server Upgrades.
- Provided solutions well within the specified Service Level Agreement (SLA) time limits.
- Established user community to track issues, enhancements, and newly identified requirements.
- Wrote business cases, requirements, mock-ups, test plans, and documentation for new reports in SAP to cover gaps between initially delivered SAP functionality and business needs.
- Worked with various types of programmers to perform solution validation and facilitate testing.
- Trained new users and performed remedial training to existing users, including creating training and reference documents.
- Evaluated business processes, anticipated requirements, and developing and implementing solutions.
- Leading ongoing reviews of business processes and developing optimization strategies.
Confidential
Lead- SAP BI Consultant
Responsibilities:
- Responsible for designing the Data Architecture for All the modules (SRM, MM, Real estate, Finance general ledger) implemented.
- Involved in the Requirements gathering, Development, UAT, and Production support phases of SAP BI, BOBJ and HANA development.
- Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for SAP BI, HANA, and SAP Business Objects.
- Designed, developed, and tested the reports based upon data generated by enterprise transaction, financial, and customer information systems using Business Objects connected to SAP BI.
- Field mapping between databases, Repository for component reuse, Custom Templates, OLAP reports.
- Cross-tab objects,Subreport objects, Text objects, User-defined tool tips for tools and report objects, Running totals expert, Top N, bottom N, sorting N Value, for Top N Style, Reports Custom (named) grouping Hierarchical Grouping.
- Developed Crystal reports with statutory requirement connecting SAP BI.
- Webi reports.
- Customized Webi Front end.
- Webi Reports have been created deployed through Info View.
- Exported the Business objects Reports to be webi so that all users can view on the intranet
- Generated several Templates in Webi.
- Created rules, events, Webi reports making use of several Queries (union, minus).
- Developed several Complex reports depending up on the metrics and customized several reports into excel, pdf, .csv.