Sr Bw Hana Funtional Consultant Resume
Naperville, IL
SUMMARY:
A proactive and result oriented IT consultant with over 14 years of experience in the application of SAP BW/BI module from design, development, testing through production support with a proven ability to communicate effectively with technical and non - technical personnel from end-users to senior management. Strengths include problem resolution, team player, coaching/mentoring. Involved in 3 life cycle implementation for different modules (FI, CO, MM, SD) in SAP BW/BI following the ASAP methodology. Extensive experience in designing and maintaining InfoCubes, Data Store Objects (DSO), InfoSources, InfoObjects, InfoPackages, Transfer/Update Rules, Transformations, and Data Transfer Process (DTP). Worked on Datasource enhancements, Generic extractors, Logistic cockpit configuration and customization, Business content and User exits. Expertise in defining DSOs, InfoCubes, BW Accelerator and MultiProviders. Proficient with ETL activities which include Data extractions, Data modeling and loading from SAP and Non-SAP systems. Extensive experience with process chain design and development, scheduling, monitoring, Data mart and Open hub services. Experience in data load management, event processing and reporting optimization. Extensive experience developing reports with SAP BW tool Business Explorer (BEx), Web Application Designer (WAD) and Business objects reporting tools (BI Launch Pad, Webi).
PROFESSIONAL EXPERIENCE:
Confidential, NAPERVILLE, IL
SR BW HANA FUNTIONAL CONSULTANT
- Bringing 42 Erp Data Into Hana For Reporting
- Converting Data Business Requirement Into Functional Specification
- Item Material Master
- Plant Master
- Legal Entity Master
- Lot/Batch Master
- Customer Invoice
- Vendor Invoice
- Inventory Movement
- Inventory Balance
- Design Harmonization Process For Data Uniformity
Confidential, Crocs Niwot, CO
SR SAP BW/BOBJ LEAD
- Created Sales Matrix Exceptions Reporting for the Sales Team. This report took away a painful manual cross checking effort.
- Enhanced AP Extractor 0FI AP 30 with additional fields for reporting
- Created Desktop ABAP upload program for uploading Sales Forecast Reporting vs Actual Verses Plan data
- Designed and Created Global All Channel Tracker Reports that tells the business various global metrics
- Designed and Created Global Wholesale Reports that shows wholesale metrics
- Enhanced Desktop upload program to include with Discounts, J3AP, MSRP, Margins and currency conversion
- Designed and Created Open Sales Order Snapshot Report with Rejections
- Created Inventory Unsold Report
- Set up Sales Rejection Report Automation in Webi
- Led BW 7.4 Upgrade Testing for pre-and post
- Enhanced Open Purchase Order Summary enhancement with ex-factory, delivery and created on dates
- Enhanced PO Master Template enhancement for ex-factory, delivery and created on dates
- Enhanced 0customer Attr and 0cust sales extractor with various fields
- Re-dimensioned BW Cubes for Performance
- Enhanced Sales Order to Billing Report and Billing Details Report enhancement with Customer Sales Report(CSR) Partner function address number
- Created BPC staging Direct Update DSO and Cube for ASP and MSRP
- Run Process Chains to load data into BPC
Confidential
SR SAP BW LEAD
- Designed COPA Functional/Technical document in BW 7.4
- Developed ETL, BEX and BOBJ reports for Copa
- Developed COPA Gross Margin Quarterly Report, Gross Margin Rolling 12 months
- Designed Service Management FSD. (Service Contracts 0CRM SALES CONTR I , install Base 0CRM SRV IBASE ATTR , Ibase Comp Warranties 0CRM IL IBCWTY ATTR, Service Contract quotation 0CRM SRV PROCESS I ), Service Contract Details report, Service contract Renewal status report, 2LIS 44 POSREC POS Data: Receipt Data, End Customer Detail Report
Confidential
SAP BI SENIOR CONSULTANT
- Production Support
- ITSM ticketing system
- Performed many enhancements on various implementations including AP distribution, Invoice awaiting receipts, Project Systems, Vendor Status, Performance issues etc.
- Implemented COPA in SAP HANA
- Implemented Purchasing Reports from Legacy systems using SAP HANA
- Designed and created Attribute, Analytic and Calculation Views
- Designed Profitability reports in BOBJ
- Conducted SAP HANA Overview session for the customer.
- Data Movement in HANA including Data Services or SLT.
- Experience in extraction of data from Excel, External data base, SAP BW, SAP ECC, SAP LANDSCAPE TRANSFORMATION (SLT) to HANA Data Base.
- Experience in Creating and executing Data Service Jobs in SAP BODS
- Used BODS Table Comparison Transform, Map Operation Transform, Merge Tranform, Lookup Transform, Merge Transform etc
Confidential, Charlotte NC
BI/BW Data Architect
- Developed Project Plan for SAP BI implementation Activities
- Involved in review and Sign-off process of key deliverables for BI with the project sponsor
- Conduct BI reporting workshops with business users
- BW data load monitoring in order to meet SLA
- BW periodic cleanup activities
- Oversee BI Offshore stuff
- Work with Basis for Patch and Enhancement Pack schedules
- Responsible for SPDD and SPAU activities