Sap Bw/bo/hana Consultant Resume
Franklin, TN
SUMMARY:
- 14+ years experience in SAP BW/HANA/BI BOBJ with Multi - Terabyte systems for several Fortune 500 companies. Engaged in numerous full SAP lifecycle implementations in Insurance, Banking, Defense, Retail, Pharmaceutical, Consumer Goods, Manufacturing, Aerospace, and Automotive industries.
- Expertise includes Development, Coding, Performance Optimization, Architecture, Project Management, Leadership, Support, Coordination (on-shore/off-shore), Functional/Technical designs, and Training. Highly skilled in ETL, Data Modeling, Transformations/ABAP Coding, Reporting, and Interfacing with
- SAP and Non-SAP systems. Collaborated closely with C-level clients, Business Users, and diverse development teams to successfully deliver integrated requirements in SAP BW/BOBJ/HANA (FI/CO, OTC, RTR, PTM, COPA, SD, PS, APO, SCM, PP, MM, Logistics, Bank Analyzer, AA, SuPM, CLM) including consolidations (BCS), and BPS/BPC for financial planning/budgeting/forecasting in North America and International markets. Other skills include Qlikview, HANA SQL, BI/BOBJ (IDT Universe, Lumira, WEBI, Design Studio, Crystal, and Analysis), BODS, BPC 7.5/10, System Upgrades of SAP BW from 3.x to 7.0, 7.3. 7.5, and HANA, complex data modeling in HANA studio with calculation/analytic/attribute views, and optimizations to lower costs and maintenance. Self-motivated and team player focused on delivering high performing solutions that align with business growth and demand.
PROFESSIONAL EXPERIENCE:
Confidential
SAP BW/BO/HANA Consultant
- Upgrade SAP BW 7.0 to BW 7.5 SP4 and BO 4.2 at Nissan
- Lead upgrade teams(on-shore/offshore) and coordinate tasks/resolve issues
- Architect/Design complex Cost Forecasting solution in BW 7.5 for Purchasing
- Project Lead development from ETL thru LSA layers with complex business rules
- Simplify and optimize backend models to meet SLAs
- Managed all phases in Agile methodology with JIRA
Confidential
AP BW/BO/HANA Consultant
- Architect and Develop SAP HANA models for SAP CLM reporting for Spirit AeroSystems
- Architect and Develop BOBJ Universes in IDT and complex WEBI reports for SAP CLM
- Develop HANA models for Tableau and BOBJ
Confidential, Franklin, TN
SAP BW/BO/HANA Consultant
- Assessment of complex BW Cost Forecasting/Performance solution for Optimization
- Extensive ABAP code analysis and performance tuning
- Design optimal solution for backend, front-end, and user planning interfaces
Confidential, Savannah, GA
SAP BW/BO/HANA Consultant
- Design/Develop complex reporting solutions in BW for Logistics, FI-RTR, PP-PTM, MM, CRM-OTC, PS, SD
- Architect/Develop BOBJ IDT Universes(Relational/Multi-Source), SAP & Non-SAP integration
- Develop integration of SAP, Oracle EDW, and Legacy systems as sources for SC,MFG,FI
- SAP SuPM and SAP CPM - Install and customize BW business content, dataflow, and reporting
- Train Business Power users on BOBJ Lumira, WEBI, and BEX query development
- Create Generic and Enhanced SAP ECC extractors with ABAP BADIs
Confidential, Hurst, TX
SAP BW/BO/HANA Consultant
- Design/Develop complex HANA data models for SC-PTM and FI-RTR, PS, and PP for reporting
- Finance/IM/PP/PS/SD/MFG Pegging - Collaborated closely with business and technical teams to analyze integrated business and technical requirements to develop and enhance transactional/master data datasources/extraction logic/transformations/routines/user exits/DSOs/Cubes/process chains/multiproviders
- Upgrade of BW 7.0 to 7.3 to HANA, user acceptance, security roles, and cutover support
- Redesigned FICO and Inventory backend in SAP BW HANA studio for high performance reporting
Confidential, Chicago, IL
SAP BW/BPC Consultant/Architect - Global Implementation
- SAP BW/BPC technical implementation - Design/Build backend/front-end reporting for BW FICO/COPA/BPC/APO-DP and SNP solutions for US, Asia, and Europe.
- Performance tuning of ETL/backend designs/ABAP, reports and SAP BPC/BW Integration
- Architect/Develop/Support BW-APO architecture for Russia/Europe/Australia/Asia global
- Optimize COPA reporting flow with parallel builds and reporting logic for SLA
- Provided support for Europe, Asia, and Australia BW/APO systems, SAP PPM BW integration/reporting
Confidential, Charlotte, NC
SAP BW/Bank Analyzer/BPC Consultant
- Bank Analyzer AFI - design/build 24 TB high performing solution for General Ledger/Balance Sheet/Profit & Loss reporting.
- Design/build staging DSO/Transformations/Cubes/Multiproviders with parallel architecture for performance
- Used Calculation/Valuation Process Manager(CVPM) for BW extraction with key date/time stamp for delta
- Functional AFI knowledge, Reviewed functional/technical designs across the team for FI and Bank Analyzer extract
Confidential, Chicago, IL
COE SAP BW Lead /Architect/Project Mgr
- BW technical development lead and architect for Finance and Supply Chain
- Lead of up to 15 BW developers for delivery of business critical enhancements in FICO
- Analyze and resolve complex solutions in BI space of over 5 Terabytes and design architecture
- for massive records counts of over 1 billion records for reporting including Planning, Budgeting, and Forecasting solutions in BPS. Transfer pricing reporting/data modeling for elimination of profit in inventory.
- Interface with Hyperion for Consolidations integration and ESSBASE planning system
- Design/Build data models for Planning, Forecasting, and BCS Consolidations
- BPS Design/Development of Actuals data in areas of FI,COPA AB/CB, Supply Chain, SD- Sales/Deliveries/Billing, AOP, GTM, Product Costing, Business Consolidation(BCS).
- Performance analysis and tuning of data models, queries, data loads and system upgrades
- Design & Build: Datasources/Virtual Cubes & Multiproviders for P2P Global Spend Reporting
- Extractor customizing for Transaction/Master data
- Build & Test UDConnect from Teradata for Virtual Infoprovider Datasources
- Open Hub Destination extract from BW DSOs and master data to Teradata
- BW system upgrade from 3.5 to 7.0 to NW2004s
Confidential, Itasca, IL
Sr. Systems Analyst - Lead SAP BW Developer (BW 3.1, BW 3.5)
- Develop complex queries for Supply Chain Metrics
- Create Web Templates for Portal Reports and develop Crystal Reports
- Production support for data loading and issue resolution
- Configure and extract data via Logistics Cockpit
- Create Process Chain, Infospokes, and optimize background jobs to avoid issues.
- Project management from requirements gathering to deliverables.
Confidential, NJ
Accenture SAP BW Consultant (BW 3.1, BW 3.5)
- Scope business requirements for Supply Chain - Procurement
- Propose architecture based on requirements.
Confidential
Accenture SAP BW Consultant (BW 3.1)
- Extensive client interaction to gather/analyze requirements, deliver training and support,
- Create functional designs from requirements.
- SAP BW 3.1c front-end query development and support.
- 2 BW Implementations involving SD, MM, and FI, SCM.
- Work with clients to develop operational queries for enterprise data analysis.
- Maintain ODS, Infocubes, Multiproviders and key figures for enhancements.
- Create Job-aids and utilize advanced techniques in ad-hoc query design.
- Crystal Reports 8.5 & 10 for SAP BW trained
- Installed SAP BW/SEM IDES on W2K Server/Oracle9i
Confidential, Birmingham, AL
SAP BW Consultant (BW 3.1)
- Production support of BW 3.0b system by monitoring data loads/create process chains.
TECHNICAL SKILLS
SAP BW 3.x, Netweaver 2004s BI 7.0, BW 7.3, BW 7.3, BW 7.4 on HANA, BW 7.5, ABAP
SAP SuPM(Sustainability/Performance Management)
SAP CLM(Contract Lifecycle Management)
SAP Business Consolidations (BCS), BPS
SAP BPC 7.5 NW, BPC 10 Delta
SAP BW on HANA, HANA Studio, SLT, SDI, LSA+, LSA++, Composite Providers, Adv DSOsHybrid scenarios, SQL, Tableau, UC4, SharePoint, Remedy, Agile Methodology, Data ServicesBusiness Objects tool Suite: IDT, Crystal Reports, Xcelsius, WEBI, Analysis, LUMIRAS4/HANA, Solutions Manager, Charm, RevTrac, Bank Analyzer
MS Office, VBA, Qlikview, Control-M, Hyperion, Teradata, EDW
VBA, JIRA, HP Quality Center, Star Team, Project Management