- 15 years of IT experience in SAP BW/BI/BO, ABAP and Oracle.
- BW Architecture, Data - modeling, Extraction (ETL) and Reporting.
- Excellent knowledge of SAP BW components like InfoCube, InfoSource, Info Object, ODS/DSO/ADSO, Composite Provider, Transformations.
- BEx Query/Analyser, Work books, InfoSet Query, Web Application Designer, Enterprise Portal, Reporting Authorizations, User Profile maintenance.
- DataSource Enhancement, Generic Extractors, User Exits, Scheduling, Monitoring, Process Chains, Cubes, MultiProvider, Remote Cubes, Data Mart, Open Hub, InfoSpoke, DB Connect, BW Statistics, HANA, SLT, Analysis for Office.
- LIS, LO Cockpit, FI-SL and CO-PA.
- Knowledge of Business Objects BI 4.x tools Web Intelligence, Dashboard, Crystal reports, Design Studio, IDT, Universe Design Tool and integration with SAP BW in BO 4.0.
- ABAP Dev Workbench, Dialog Module, Data Dictionary, Logical Database, Adhoc and InfoSet/SAP Query, SAPScripts and Layouts, Smart Forms, ALV, LSMW, User Exits, Debugging, SQL trace and CTS.
- Specialized in SD, MM, FI/CO, HR/HCM, CRM and PP modules.
- Experienced in various stages of implementation from pre-implementation to production support and participated in 4 full life cycle implementations.
SAP ECC 5.0/6.0, SAP R/3, BI 7.0/7.3/7.4, CRM 5.0, SD, MM, FI/CO, HR/HCM, PP, BEx, Query Designer, ABAP, BDCs, BAPI, Oracle, UNIX, Windows, BOBJ, HANA, Qlik Sense 3.0.
- Data modelling of FI-AP and various BEx/Webi reports for Line Items and Aggregates.
- Data Modelling for AR and used standard datasources with BADI enhancements and developed BEx/Webi reports for Outstanding balances .
- Custom development for Purchasing Header/Detail, Sales Order/Delivery/Billing enhancements.
- Created Custom Extractors for various Master Data and Transaction Data. Used custom Views and tables and enhanced the standard extractors for FI, Sales and Purchasing.
- Worked on BW on HANA and developed Advanced DSO, Composite Provider, Open ODS view. Developed complex Transformations (Field/Start/End Routines) to process the data and used Infosources as a layer. Used CDS views to load data from ECC.
- Used Analysis for Office to validate the reports and MS Visio for dataflow. Used HP ALM for defect management/testing and Charm for Change Mgt.
- Worked on native HANA modelling involving packages, schemas/contents, attribute/analytic/calculation view with graphical/script based methods in SLT based sidecar deployment. Migration of HANA info models in the landscape using Export/Import and Life Cycle Management.
- Created calculated/restricted columns/attributes/measures, filters, hierarchies, variables, procedures and input parameters to satisfy reporting requirements using SAP HANA studio.
- Worked on Webi developing multiple reports, adhoc query, tables, charts, filters, formulas and formatted page layouts.
- Got trained in Qlik Sense and SAP HANA Modelling.
Environment: SAP ECC 6.0, BW 7.4, SAP HANA 1.0 SP11, BEx, ABAP, BADI, HANA Studio, Analysis for Office, BI 4.1, FI, SCM, SD.
Sr. SAP BI/BO Consultant
- Requirement gathering for custom Stock in Transit, Executive Management Inventory Reporting and Order Analysis. Created Technical Specifications, enhanced the Inventory and Purchasing standard extractors and created custom Extractors and Report development using Cristal Reports and Webi.
- Worked on activation of SAP HANA business content for Procurement, Sales and FI. Worked on creating Transient/Composite/Virtual Provider based on HANA model for Sales and used Design Studio.
- Designed Universes using IDT to create Data Foundation, business layer on HCM BEx Queries and Cubes.
- Worked on formatted reports using Cristal Reports, multiple groups, Integration with SAP DataSources(BEx, HANA, Universe, Relational DB), used formulas/conditions/variables/hierarchies, exporting reports to Excel/Word, Summary and Detail Chart.
- Worked on Environment Health and Safety Management EHSM module for specifications, enhancement using BOPF, DataSources using BADI, develop Custom DSO’s, Cubes, Multi-Providers and BEx Queries.
- Worked on Enhancement for Customer, Material Price Forecast, Material Classification, Sales Document Header/Item-Status, Purchasing and Goods Movement.
Environment: SAP ECC 6.0, BI 7.4, SCM, EHSM, BEx, ABAP, BADI, BOPF, HANA, Design Studio, IDT, BO 4.0, Webi, CR.
Sr. SAP BW Consultant
- Worked on requirement gathering for OPA (Optimized Product Availability) for North America.
- Worked on development of Reports for Days of Coverage, Demand Compare and Forecast Analysis.
- Developed Info Objects, DSO’s and worked on Transformations and DTP’s for Data Load and used Process Chain.
- Developed Reports using BEx and worked on APD’s to populate the data to reporting system.
- Worked on SCM Inventory visibility reporting for Forecast/Stock Requirements, Days of Coverage Material/Plant/Batch and used extractors, Master Data, Info Providers, APD’s and BEx Queries. Worked on Rule Groups, Semantic Partitions to handle different region wise data.
- Worked on Open Hub for SCM which include Material, Material-Plant and Vendor Info. Worked on APDs for Demand Compare and Forecast Analysis to be reported in third party reporting tool.
Environment: SAP ECC 6.0, BI 7.0/7.3, SCM, BEx, ABAP, APD, Oracle 10.x, UNIX, NT, MS Office.
Sr. SAP Reporting Consultant
- Developed the Technical Specifications for 10 custom reports and developing the reports using ABAP.
- Managed report requests using CRM Employee Service Center and co-ordinated the development and mentored the HRIS Team.
- Worked on reports for Surveys, Headcount, Actions, Payroll, Time, Vacation, Tax, Compensation, Benefits. Used SAP Query/ Adhoc Query, Infosets, SAP Standard/Custom/Adhoc Reports, Business Intelligent Reports. Also integrated data from various modules using Access/Excel.
- Working on specifications for HR Workforce Analytics Dashboard, which includes 15 reports and Graphs. Designed and developed reports for Market Pay Survey, Tax Credit Reports and Multiworksite reports.
Environment: SAP ECC 6.0, BI 7.0, HCM, BEx, ABAP, CRM 5.0, Oracle 10.x, UNIX, NT, Lotus Notes 8.5, MS Office, Remedy.
Sr. SAP BI Consultant
- Requirement gathering from Business/Functional Analysts for Period Cost, SG&A Expenses and GL.
- Developed Technical Reporting Specifications for both BEx and Webi Reports.
- Worked on BOBJ creating Universes and Webi Reports for MTD & YTD SG&A Expenses, Expenses by OPEX Category and SG&A Ad-hoc Reporting.
- Also created Universes and Webi Reports for Period Cost.
- Worked on Re-modeling of custom GL Cube which will be used by Consolidation for drill down reporting.
Environment: SAP ECC 6.0, BI 7.0, FI, BEx, ABAP, WAD, BOBJ Universe, Webi, Oracle 10.x, UNIX, NT
Sr. SAP BI Consultant
- Gathering the Report requirements and development of Technical Specifications and Test Scripts.
- Developed BEx Reports for Time & Expenses for Travel Mgt., GL Tax Profile Report, GL Open Items Report after enhancing the Data Sources. Used Structures and developed security for FI Reports.
- Drill down reporting (RRI/Jump Queries) into line item queries, R/3 Transactions for detailed analysis.
- Worked on BEx Report Variables and used User Exit(ABAP) for dynamic reporting capabilities in PCA Reports. Customized the Workbooks for individual users.
- Developed BEx/Web reports for HR which includes Average Headcount, Turnover, Average Length of Service and Number of Positions.
Environment: SAP ECC 6.0, BI 7.0, ABAP, HR/HCM, PA/OM, FI, MM, BEx, WAD, Universe, Webi, Oracle 10.x, UNIX, NT
Sr. SAP BI Consultant
- Development of Infospokes to transfer the data (using ABAP) to EBI for Business Partner, Marketing Attributes, Relationships, BP Address, Incentives and IBase Data Targets.
- Development of ABAP Programs and Function Modules to transfer other BP details (Territory, Communication, Address) from CRM Systems.
- Worked on Sales order Header/Details and Delivery Header/Details data targets.
Environment: SAP ECC 6.0, BI 7.0, ABAP, CRM 5.0, SD, BEx, Oracle 10.x, UNIX, NT
Sr. SAP BI Consultant
- Met Subject Matter Advisers (SMA) and HR Process Team for gathering the report requirements (HR Personnel Administration, Payroll, Time, Benefits, Org Mgt. and e-Recruiting).
- Developed the Data Flow document for HR for standard business contents and Custom DSO’s.
- Worked on Data Mapping process to identify the fit/gap conditions for HR Reporting.
- Enabled the standard Business Contents for CATS 0CATS C01 'Time Sheet Data' and enchanced the Data Sources as per the clients requirement. Worked on Custom BEx Queries for CATS.
Environment: SAP ECC 6.0, BI 7.0, ABAP, HR/HCM, PA/OM/BN/PY/CATS, FI, BEx, Oracle 10.x, UNIX, NT
Sr. SAP BW Consultant
- Met with Business owners and Analysts for requirements gathering, functional/technical specifications.
- Worked on Funds Management FM developing custom ODS Budgets and custom cube Commitment/Actuals and used MultiProvider for reporting for various Campuses.
- Used Budgets 0PU O11 and Commitment/Actuals and Budget 0PU C01 for reporting.
- Worked on FI-GL/AP/AR systems for the data extraction and Reporting.
- Worked on CATS with regard to enabling the standard business contents and BEx Reports.
- Created Custom Headcount and Personnel Actions Cube, Benefits Cube and activated the standard Payroll Posting and Auditing Document Targets. Identified the gap and designed best possible solution creating custom Payroll Posting and Auditing Target.
- Worked on Open Hub, DB Connect, Enhancements, ABAP, Custom/Function Module extractors, Transports, Process Chain, Information Broadcasting, BW Statistics, Performance Tuning.
Environment: SAP R/3 4.7, NW 2004s/BI 7.0, BW 3.5, ABAP, FI, HR/HCM, PA/BN/OM/PY/CATS, MM, CM, BEx, Oracle 10.x
SAP BW/ABAP Consultant
- Interacted with Management and users to gather requirements and developed Design Document.
- Created custom cube for Profit Center Accounting (PCA). Extracted the data from FI-SL.
- Worked on custom Cubes and ODS for OPEX, CCA and extracted the data. Developed WorkBooks and BEx Reports for Income Statement, Trial Balance, P & L Account, Org Expense, Std Mgt Expense.
- Developed Hierarchies for Business Area, Company Code, Functional Area and Profit Center.
- Performance tuning of Queries using Aggregates, Compression, partition, indexing of InfoCubes, Query Cache, Book marking and BW Statistics.
- Created BEx queries using Variables, Navigational attributes, Filters, Formulas, Structures and Virtual Characteristics. Developed workbooks, InfoSet Queries and used RRI jump queries.
Environment: SAP R/3 4.7, BW 3.1C, ABAP, FI/CO, BEx, Web Application Designer, Oracle 9i, HP-UX