We provide IT Staff Augmentation Services!

Sap Consultant Resume

San Jose, CA

PROFESSIONAL SUMMARY:

  • SAP Certified consultant with 17 years of IT experience, including 13 years in SAP BW, BW on HANA, native HANA, ABAP, BO
  • Technical hands - on in BW on Hana modeling, eclipse based BWMT, performance optimization and reporting for BW on HANA in HANA, BW On HANA using layered scalable architecture (LSA ++)
  • Experience in energy (oil & gas), aerospace, retail, manufacturing Chemicals
  • Architected, designed, developed and implemented solutions in SAP BW, BW on HANA, Native HANA, BO 4.x from SAP and non-SAP data
  • Team player and swift in understanding new technologies and coming up with solutions for complex issues
  • Adoption of existing BW architectures for S/4 HANA, reporting by integrating data from BW and Big data, Integrated and Context Reporting using S/4 HANA embedded analytics
  • Very good at fixing the production failures getting to the root cause of the issue preventing the reoccurrence of the failures

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, CA

SAP consultant

Responsibilities:

  • Designed the cancel negotiations according to CISCO standards and following SAP best practices for best performance
  • Designed ‘ all ‘functionality of negotiation grid and the notifications according to CISCO standards and following SAP best practices for best performance
  • Guided, trained and mentored team for 7 technical resources for alerts and notifications in GSM Baao product development in SAP Hana
  • Developed stored procedures and Hana models for all, cancel negotiations, alerts, and notifications

Environment: SAP HANA1.x, Eclipse Neon, Fiddler

Confidential, Brisbane, CA

SAP consultant

Responsibilities:

  • Analyzed the current manual process of creating HAL ICED Sales report and understand data, metrics, reports, systems, tools, and applications involved.
  • Created a architecture using LSA++ for BW on Hana 7.5 and higher, aligning with the SAP roadmap.
  • Created high-level design for ICED sales and Finance reports, integrating Visualization and Data transformation (Metric Calculation logic) in BW on Hana and BO Design studio, webi
  • Leveraged SAP Standard Extractors to load the staging/ landing area (ADSO’s) in SAP BW for SD, FICO, SD modules (3 environments).
  • Built the data flow for Sales, billing, CoPA dataflow using ADSOs, Composite Providers and built Bex queries in BWMT to be consumed by BO 4.2 webi, design studio 1.5
  • Created the FI GL, AR data flow using the standard extractors and creating ADSO, Composite provider, BW query creation in the eclipse based modeling tool for BW on Hana
  • Created Open ODS views for providing global vendor id from the external database.
  • Designed and developed the solution using hybrid model using Hana live and composite providers for Sales trend and operational data
  • Finalized the solution architecture for the project highlighting the technology components to be used.
  • Extractor creation, enhancements in ABAP using DB proxy, Hana complaint transformation
  • Created solution design for global model using global distributor id using smart data access, Hybrid model using open ODS view and composite provider
  • Evaluated the possibility of using ODP for global architecture
  • Project planning execution, monitoring and risk management
  • Project status tracking and weekly status reporting
  • Created Detailed project plan

Environment : SAP BW 7.5 SP01, HANA1.x, Sap Hana live, BWMT, SAP Business Suite on Hana, BO 4.2, Design Studio 1.5, SAP SD, FICO AR, AP, PP, QM, MM, Oracle 10, FI-GL, CCA,

Confidential, Houston

SAP consultant

Responsibilities:

  • Responding to Request for Proposal
  • Representing Sierra in Orals - Architecture and Technical discussions with the customers

Confidential, Houston

SAP consultant

Responsibilities:

  • Overall SAP BW on HANA system architecture design and performance optimization
  • Experienced as SAP BI/BW Architect and hands-on developer of both traditional BW and BW on HANA
  • Review business requirements and translate into SAP BW HANA architectural design. Provide options and recommendations.
  • Review deliverables and ensure conformation to the initial designs and that the blueprint is updated to reflect any significant changes
  • Define the Design Documents for the BW HANA Models
  • Implement SAP BW HANA Security including User Management, Roles, and Privileges
  • Delta Enabled the pricing reporting, increasing the scalability
  • Expanded the shop floor BI reporting to cater to the much wider audience for QM BI Reporting. Designed the back end for QM Reporting in such way that, minor or no changes required when we need to provide the reporting for other business units
  • Developed SQL Stored procedure for calculating thruput and inventory in the queue to be used in HANA calculation views and then in BW open ODS view for hybrid modeling.
  • Developed ABAB custom exits for work center, operation enhancements of the reporting
  • QM Dashboard to visualize the worst work center and what is the most occurring defect
  • Translates user requirements into a logical database design
  • Design and implement the Throughput reports BW on Hana using ADSO and Composite providers and integrated with BO4.1, Webi and Dashboard builder
  • Provide guidance and reviews technical aspects
  • Migrate to the SAP NetWeaver BW on SAP HANA
  • Create calculation views for Inventory in Queue Reports using Native Hana

Environment: SAP BW 7.4 on Hana, HANA1.x, Sap Hana live, Hana Studio, BO 4.x, SAP SD, AR, AP, PP, QM, MM oracle 10, FI-GL, CCA, SAP ECC 5.0/6.0, ABAP/4, BEx Analyzer, WAD, Solution Manager, Windows XP, Webi, Information design tool IDT, Explorer, Alaysis for office, Analysis for OLAP

Confidential, Houston

SAP consultant

Responsibilities:

  • Analyze the current implementation to find the issue and the fix for the same
  • Understand the business requirements
  • Work with the functional pricing consultant to accommodate the upcoming pricing changes in ECC.
  • Work in the functional spec, technical spec for the blueprint
  • Architect the solution for the performance improvement to have the delta enabled pricing extractor using BTE, Custom generic extractor for delta enabled datasource using ABAP Function modules
  • Migrated 3.x datasource, transformation to 7.x.
  • Co-ordinate with the business to make them understand the new implementation doesn't involve the change of existing reports
  • Implement the solution and work with business for post-production support.

Confidential

SAP consultant

Responsibilities:

  • Analyze the gap between the BW reports and the SQL reports and the business user’s requirements
  • Analyzed the business content 2lis 08trfkz and 2lis 08trtk and implemented them
  • Functional and technical specs for blueprinting and project plan for implementation
  • Architect the solution to fill the gap and implement the solution in sap BW
  • Implemented the start, end routines and field routines needed for the customization
  • Created multi-source universes to report on BW and SQL server data using BO
  • Create new Bex query shipment Cost summery by distance, weight, by the fiscal year

Confidential

SAP consultant

Responsibilities:

  • Analyze different options to send the outbound extracts and choose the best solution
  • Implement outbound extracts using openhub and into spokes.
  • Design the File utility solution which can archive older extracts
  • Performance tuned the APDs so that daily SLA is not affected
  • Created new APDs and reports for new extracts
  • Designed and implemented Role based dynamic authorization for all the sellers
  • Co-ordinate with the business and to the Qlickview team for the end to end testing and post-production support
  • Design and Implement a webi report to display the last refresh data of all the info providers using the BW technical content.
  • Design and implement the existing Qlickview dashboard for Account, Sales, Inventory in BO 4.0 using BO dashboards.

Production Support

Confidential

Responsibilities:

  • Fixed the missing delta data issue in the inventory cube
  • Improved the performance of APD from 10 hours runtime to 20 min
  • Created work plan for the line item report of sales order cube and aligned the loading from staging to reporting.
  • Improved the performance of PAC code report by replacing the virtual character lookup using Infoset.
  • Design and implement SPO DSOs at the staging, transformation, reporting layers for North America, Asia, EMEA.
  • Monitored the process chains and recovered the failed process without impacting the SLA and reports usage
  • Designed and implemented the extraction and retraction of BPC BW integration
  • Implemented the custom logic BADI for the finance cube to calculate the YTD percentage.

Environment: SAP BW 3.5/7.0/7.3, BPC 10.0, SAP SD, AR, AP, HR, SQL 10, FI-GL, CCA, BCS, PS, SAP BI IP, ECC 5.0/6.0, ABAP/4, BEx Analyzer, WAD, Solution Manager, Windows XP, Cognos, Qlickview, Business Objects Universe Designer, Webi, Information design tool, Explorer, Alaysis for office, Analysis for OLAP

Confidential, Houston

SAP consultant

Responsibilities:

  • Manual load for future forecasts
  • Fixed in the BTE for delta, for the missing month end actuals
  • Fixed the translation date for the currency exchange
  • Fixed the delta issue for the deleted/rejected/undetected forecasts.
  • Designed, Implemented and Validated the Bex queries with the BO reports and dashboard
  • Troubleshooting of BO queries not giving accurate results and fixing the issues.
  • Ensured overall successful delivery of a project which involved scoping requirements, scheduling, implementation and release management.
  • Requirements gap analysis
  • This involves managing a team of seven direct resources and a team of indirect resources to build a solution for GIS reporting using BW.
  • Co-coordinating with TSG SAP Release management for BW releases amidst Data center moves, R/3 refresh activities etc.)
  • Create workplan and get approval
  • Help the data load team if any issues
  • Validate the recovery
  • Address any issue from the dataload.
  • Designed multisource universe using SQL server tables and BW infoproviders
  • Designed Webi to validate the customer contract with the CISCO vendor contract
  • Implemented the webi report and trained the users to use the report.
  • Migrated the BW data flow to use the SAP HANA model and BW 7.3 transient provider for the analysis of performance.
  • Replicated the Sales order tables from SAP ECC to SAP HANA and built HANA information models
  • Post production support for the implementation
  • Responsible for end to end technical design of the reporting solution and openhub solution along with the intermediate deliverables like data model design and code development using ABAP as well as data loading for reporting.

Confidential

SAP consultant

Responsibilities:

  • Requirement analysis
  • Design the solution
  • Lead the development team for the construction

Environment: SAP BW 3.5/7.0/7.3, BPC 7.5, BO 4.0, BO 3.x, SAP HANA, SAP SD, AR, AP, HR, Oracle 10G, FI-GL, CCA, BCS, PS, SAP BI IP, ECC 5.0/6.0, ABAP/4, BEx Analyzer, WAD, Solution Manager, Windows XP, Business Objects Universe Designer, Webi.

Confidential, Fort Worth, TX

SAP consultant

Responsibilities:

  • Solution manager integration with Confidential Mega Process
  • Monitor process chains and other data loads
  • Modified transformation, field routine, start, end routine; modified User exits.
  • Verify data quality and ensure BW is in sync with source systems
  • Aid in the testing of BW to ensure that it matches requirements
  • Implemented the BADIs for start and end routine for NW BPC 7.5 for the planning sales cube

Environment: SAP BW 3.5/7.0, BPC 7.5 SAP SD, AR, AP, HR, Oracle 10G, FI-GL, CCA, BCS, PS, SAP BI IP, ECC 5.0/6.0, ABAP/4, BEx Analyzer, WAD, Solution Manager, Windows XP, Business Objects Universe Designer, Webi.

Confidential, NY

SAP consultant

Responsibilities:

  • Analysis, Blueprint, and Realization
  • Created reports for Credit, Finance, and Market Risk.
  • Integrate with the reconciliation and data acquisition capabilities and respective stakeholder’s business processes.
  • Investigate and resolve production issues rapidly and communicate every aspect of technical design and development effort to Project Manager for project scheduling purposes
  • Designed and developed ZMTRDPRPT (Trade Reporting MultiProvider) with 6 InfoCubes.
  • Created Custom DataSources to load data from NetWeaver BI to Bank Analyzer.
  • Created custom Infocubes to be added in the MultiProvider for disclosure and reporting for Basel II
  • Worked on the customization of BI Standard Content add-ons for Bank Analyzer like 0BA BA DR 25
  • Loaded data from Flat files for Basel II reporting
  • Created and maintained Process chains to load Master Data from PRD (R/3 Production) system onto the BIP (BI Production) system.
  • Developed a DTP Filter routine to load the relevant data from one text table onto another.
  • Coordinate with QA team for every release

Environment: SAP BW 3.5/7.0, SAP SD, Oracle 10G, Bank Analyzer, ECC 5.0/6.0, ABAP/4, BEx Analyzer, WAD, Windows XP, SAP BO, Webi

Confidential, TX

SAP consultant

Responsibilities:

  • Developed a DTP Filter routine to load the relevant data from one text table onto another.
  • Created History Validation queries for end-users to facilitate not to use the ListCube.
  • Analyzed and modified 15 queries to include new Promo group levels and the related Navigation Attributes.
  • Designed and developed Adjust HQ and Reject HQ Reports that help users identify the various discount approved or rejected for various clients. Built Web queries using Web Application Designer (WAD).
  • Involved in the performance enhancement activities like enabling cache, maintaining aggregates etc
  • Responsible for the documentation and successful transportation of the requests to upper landscapes
  • Created user-exit variables to populate the values automatically on the selection screen. Complexity includes changing of one variable value based on the value generated for another variable
  • Involved in production support activities.
  • Trained end-users on how to create ad-hoc queries in the production system.

Environment: SAP BI NetWeaver 2004s / BI 7.0, Oracle 10G, R/3 ECC 6.0, ABAP/4, BEx Analyzer, WAD, Linux, Windows XP, Business Objects universe designer, Webi

Hire Now