SUMMARY:

• SAP BW/4HANA Integrated Business Planning consultant with over seven years of experience delivering complex global data analytical and planning projects across Confidential and pharmaceutical industries with demonstrated success in data acquisition, data modeling, BW queries development, testing and deployment.
• SAP HANA 2.0, SAP BW/4HANA IBP and SAP BW Data Modeler, also worked on SAP S/4HANA Custom CDS Views
• SAP BW/4HANA and Integrated Business Planning analytics business transformation at retail client. Activated business contents in B/4HANA for Finance and Logistic such as Composite Provider, ADSO and Transformations, replaced legacy data warehouse with SAP BW/4HANA and SAP Business Objects.
• Responsible for architecting and delivering SAP BW/4HANA 2.0 project, deployed analytics for Order to Cash and Financial and Controlling business units. Enabled robust enterprise data, analytics foundation and analytics group.
• Enterprise data and analytics transformation for “Order to Cash” and “Record to Report “, “Financial Supply Chain Management” and “Operations” with SAP BW 7.4 on HANA, Hana Live views, and Business Objects at Confidential replacing several excel, access - based and open source tools for line of businesses, responsible for successfully delivering of processes, methodologies, SAP BW and SAP Business Objects. Effectively managed cutover, testing and .

CORE COMPETENCIES:

• SAP BW/4HANA, HANA 2.0, SAP BPC, IBP, SAC, CDS Views
• Data Services, SDA/SDI, SDQ and SLT, SAP HANA Data Warehousing Foundation
• Waterfall and Agile Methodology
• Self - Service Analytics Delivery
• SAP S/4 HANA Embedded Analytics
• SAP Analytics Cloud, Digital Boardroom Dashboards
• Architect, Sizing, Data Aging and Testing
• SAP Power/EA Designer, MS Visio, SQL, Java//HTML
• Finance and Supply Chain analytics

TECHNOLOGY LEADERSHIP:

Confidential, Asheville, NC

SAP BW/4HANA IBP Consultant

Responsibilities:

• Responsible for conducting business workshops, and prepared business case for SAP BW/4HANA deployment for financial reporting at company, division, store level, department, article level reporting.
• Prepared SAP BPC environment and grant access, created local provider based on a flat file, used fields in HANA without any infoobjects, created a model based on local provider, and in the end created planning enabled query, enabled planning on local provider using Analysis. Client had a requirement to build a holistic view of the plan values, hence integrated Local Planning Data to Global with below steps.
• Added the calculation view to a CompositeProvider that already includes the central planning aDSOs. In the CompositeProvider, I mapped the Hana view fields to the central InfoObjects. I created the planning enabled query which included local and global plan data, I also created aggregation level. Led efforts copying the local revenue/quantity plan data from native HANA table into the plan aDSO using copy planning function.
• Created a repost planning function to move revenue/quantity plan data local material items to the materials that reside in the material master. I was able to test the integration in Analysis.
• Created calculation view with start schema on Stores Sales tables, also created calculation view with dimensions for article master data table, enabled sales reporting at store, site group level and at merchandising hierarchy level.
• Created Custom CDS view on SAP delivered data source “I Customer” and exposed as a web service, generated OData service, and created new scenario and YY NEW CUSTOMER CDS as a service.
• Provided it to Fiori App developer.

Confidential, Secaucus, NJ

SAP BW/4HANA, IBP and BPC Consultant

Responsibilities:

• Responsible for conducting business workshops for logistics and finance team and documenting functional specifications for reporting requirement.
• Build Visio diagram for all objects such as ADSO, Open DSO View, and Composite provider, also created technical specification for data mapping between data sources with ADSO, business rules for transformations.
• Documented the integrated business planning requirement for finance
• Created the local provider based on flat file, and also added calculation view to a CompositeProvider, developed the planning enabled query,
• Created aggregation levels, and used planning function copying the local revenue and quantity plan data from native HANA table into the plan aDSO
• Activated and enhanced business contents for ADSO, Composite providers and transformations and BW standard queries etc.
• Developed Hana information views, calculation views, created composite provider with ADSO and HANA information views to merge demand solutions data with sales data
• Created transports and worked with cutover lead to provide sequence of objects transports.
• Assisted organization change management lead to document material for business users on BW reports.

Confidential, Center Valley, PA

SAP BW on HANA Data Modeler

Responsibilities:

• Deployed SAP BW on HANA, SAP BPC and Business Object 4.1 for OTC, RTR and supply chain management
• Worked with business users to document requirement, created functional and technical specifications, developed blueprint including data flow diagram with each object, data fields and their mapping with data sources and transformation rules.
• Activated data sources in SAP ECC 6.0, enhanced data sources by adding new fields from communication pool in t-code LBWE for delivery data sources. Activated BW contents and enhanced as per business requirements documented in technical specifications.
• Worked on second phase of the project to enhance several BEx queries.
• Enhancement and operational support for business planning and consolidations users, developed and enhanced planning enabled ADSO and BW queries for planning on analysis for office.

Confidential, Secaucus, NJ

SAP BW Developer

Responsibilities:

• Responsible for creating BEx queries for inventory management such as Inventory aging and IMU report, created global and local calculated and restricted key figures.
• Enhanced Profit and Loss statement BEx query with new profit center hierarchy
• Worked on performance and tuning for various reports, also enhanced info cubes with aggregates, enhanced process chains to improve data load performance.
• Activated SAP logistic cockpit “LBWE” data sources for orders, delivery, billing, added additional fields form communication pool to data sources for delivery data sources.
• Activated SD data source using tcode RSA5, tested data sources using RSA3, and. then replicated data sources to SAP BW, deleted outbound queue “LBWQ” and delta queue “LBWG”, and filled up setup tables using OLI7BW (Sales order), OLI8BW (Deliveries) and OLI9BW (Billing) tcodes.
• Initialized delta queues for data sources using info packages for initial loads, also scheduled process chains with delta load info packages. Ensured filling up aggregates, recreating indexes in process chains and also monitored using RCPCM tcode.