We provide IT Staff Augmentation Services!

Sr. Sap Bw Hana Developer Resume

Naperville, IL

SUMMARY

  • Implemented 12+ SAP BI/BW, HANA and BPC projects with ABAP lifecycle implementation projects effectively translating functional objectives into clear technical requirements and further into high performance data models in various functional areas like SD, MM, APO, FI.
  • Expertise in working with clients from various industrial domains like Utilities, Automobile & Industrial Equipments, Food & customer products & services, Supply chain management, telecommunications.
  • Experienced in end - to-end complete lifecycle implementation of projects including systems sizing, scoping, disaster recovery strategy design as per business need following SAP ASAP, Agile methodologies.
  • Good knowledge and working exposure on SAP HANA Data Modeling using Data Services, HANA Studio.
  • SAP BI Configuration, Design and development of Standard and Custom Info Cubes, Info Object and Data Sources, Multi-Providers, Data store objects (DSO), Transformations, DTPs and Process Chains.
  • Good knowledge on complete Data Extraction, Modeling and Reporting with proven track record of project and customer satisfaction.
  • Provided best practices and sanity checks to be carried out during SAP BW, BPC upgradations.
  • Good working exposure on SAP BPC 10.0 data extractions both master data and transaction data with customizations meeting client requirement and creating input schedules, top side adjustments through Journals, reports with good understanding on consolidation process flow.
  • Good ABAP skills involve - creation and enhancement of reports, transactions, generic extractor using function module, BAdIs - WriteBack, Routines, retraction and Custom Logic, customer-exits transfer/ update/ start/ end and expert routines, debugging.
  • Involved in the configuration of Vistex Plug-in with SD module in ECC and configured the BW extractors into LO Cockpit
  • Configured and customized data sources, Vistex Namespace and number ranges in ECC/BW.
  • Extensively working on customer sales and incentives (Vistex modules)
  • Worked with Customer Rebates module (/IRM/LIS RM IPCAHDR, /IRM/LIS RM IPCAITM, /IRM/LIS RM IPCAKON)
  • Involved in Production Support and addressed Process Chains failures, Scheduling, Manual Loading (Full/Delta Up-Load), Selective deletion and loading, addressed the tickets/issues related to reports, and Design Enhancements.
  • Activation and installation of Business Content according to Requirement and Activated Data Source Structures in (ECC). Extracted data from non- Confidential /3 systems such as Flat files and Oracle.
  • Expertise in creating Reports using Calculated Key figures, Restricted key figures, Variables, Exceptions, conditions using BEx tools and testing the reports for required functionality.
  • Experienced in leading the teams and delivering solutions in required time lines at the required quality levels.
  • Worked with BEX Analyzer, BEx Web, Query Designer, Analyzer, WAD and BEx Broadcaster.
  • Worked with BI Accelerator to improve the read performance of BI Queries on Infocubes.
  • Developed WebI report, Advanced Analysis reports using BO 4.0 suite with OLAP Universe.
  • Extensively used BI Launch Pad to create Web Intelligence Reports over the Universe. Extensively worked in WEBI reports
  • Strong analytical and problem solving skills
  • Excellent communication, interpersonal, and presentation skills
  • Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.

TECHNICAL SKILLS

ERP: SAP BW 7.3/ 7.0/ 3.5, SAP Confidential /3 ECC 6.0/5.0/4.6C, SAP HANA

Reporting Tools: BeX, Crystal 2008/XI, BO 4.0, 4.2, Tableau

SAP Modules: SD, MM, WM, PLM, DP, FI/CO, SAP EPM 10.0 NW

ETL Tools: SAP BODS, SAP SLT, Cognos

Systems: Windows, HP-UX, UNIX, Sun Solaris, HANA 1.0

Languages: ABAP, HTML, XML, C, SQL, PL/SQL, SAP ABAPDatabasesOracle 9i/8i/8.x, Teradata, HANA

Methodologies: ASAP, SDLC, AGILE

Testing Tools: HP Quality Center, Rational Suite

PROFESSIONAL EXPERIENCE

Confidential, Naperville, IL

Sr. SAP BW HANA Developer

Responsibilities:

  • Analysis of existing analytics solutions implemented for Confidential
  • Support Vistex upgrade from BI Side.
  • Analyze modifications and object conflicts on the current landscape
  • Conduct training sessions to business in helping to understand the dynamics of SAP Vistex implementation process and reporting
  • Identifying the gaps in reporting needs of business
  • Re-design and develop Functional and Technical documents for different reports which helps in analyzing the rebates and incentives management solution.
  • Redesign the cubes and reports to improve the performance of the reports
  • Adjust user exits and BADI’s due to changes in interface programs
  • Involved in redefining SAP BW Security roles
  • Re-design and develop Vistex Commissions reports
  • Assisted BASIS team in re-mapping security roles to for users

Technical Environment: SAP ECC 6.0, EHP7, Vistex 6A to 6D, SAP BW 7.0, SAP Business Explorer, WebI

Confidential

Sr. SAP BW HANA Developer

Responsibilities:

  • Analysis of existing analytics solutions implemented for Confidential
  • Conduct training sessions to business in helping to understand the dynamics of SAP Vistex implementation process
  • Gathering requirements and identifying the reporting needs of business
  • Design and develop Functional and Technical documents for different reports which helps in analyzing the rebates and incentives management solution.
  • Design data flow architecture and Develop custom transactions to extract, modify, download and delete data from non-SAP database tables to SAP landscape
  • Involved in defining SAP BW - HANA Security roles
  • Design and develop Vistex Commissions reports
  • Assisted BASIS team in mapping security roles to for users

Technical Environment: SAP ECC 6.0, EHP7, SAP BW 7.5 on HANA Database, BI 4.1

Confidential, New Jersey

Sr. SAP BW HANA Architect

Responsibilities:

  • Analysis of existing analytics solutions implemented for Confidential
  • Conduct workshops and training sessions to business in helping to understand the dynamics of SAP implementation process
  • Gathering requirements and identifying the reporting needs of business
  • Design and develop Functional and Technical documents for different reports which helps in analyzing the inventory management solution.
  • Design data flow architecture and Develop custom transactions to extract, modify, download and delete data from non-SAP database tables to SAP landscape
  • Involved in design & development of cross channel order management (CCOM) allocations.
  • Involved in defining SAP HANA & BW Security roles
  • Assisted BASIS team in mapping security roles to enable single sign on for users
  • Design and develop HANA model views for supply chain management process
  • Integrate SAP BW to non-SAP products like Cognos, Tableau for client specific, management reports
  • Develop sales planning & forecast reports
  • Helped in designing and developing data model views for retail store mobile app for better inventory management and stock validations.
  • Consolidate income and balance sheets for supply chain management department.

Technical Environment: SAP ECC 6.0, SAP BW 7.4 on HANA Database, APO BW, Hana Studio, SAP Fiori1.0, SAP Design Studio, Cognos, Oracle, Tableau 8.2

Confidential, Houston, TX

Sr. SAP BI HANA Developer

Responsibilities:

  • Responsible in gathering requirements from customers for asset life cycle management.
  • Manage the BI & ABAP team and help the team in resolving the technical issues.
  • Responsible for conducting workshops with clients.
  • Design and develop Functional and Technical documents for different reports which helps in analyzing asset life cycle.
  • Develop custom transactions to extract, modify, download and delete data from database tables
  • Migrate objects from BW landscape to BW HANA landscape.
  • Involved in SAP landscape Transformation to extract real-time data directly from SAP ECC system into SAP HANA using trigger based mechanism
  • Developed attribute views, analytical views and calculation view using SQL and CE functions
  • Enhance datasources, changes in respective Transformations/Routines as well as InfoProviders.
  • Develop score card and summary reports to track work orders, notifications and transformer performance.
  • Involved in defining SAP BW Security roles
  • Assisted BASIS team in mapping security roles to enable single sign on for users
  • Involve in unit testing, integration testing and UAT testing.

Technical Environment: SAP ECC 6.0, SAP BW 7.3 on HANA Database, SAP HANA 1.0 SPS 8, SAP BOBJ 4.0, WebI, Tableau

Confidential

Sr. SAP BI HANA Developer

Responsibilities:

  • Manage the BI, HANA & ABAP team and help the team in resolving the technical issues.
  • Responsible for conducting workshops with clients and do requirements gathering.
  • Design and develop Functional and Technical documents for different reports which helps in reconciliation of Meters master data across different sources, service orders tracking and unbilled revenue etc.
  • Design the process to synchronize master data across three enterprise systems and helped in identifying the missing information, help in enhancing the performance of data loads - master data & transaction data
  • Involved in defining SAP BW Security roles
  • Assisted BASIS team in mapping security roles to enable single sign on for users
  • Implemented SAP Fiori system landscape with HANA Extended Application Services using sidecar approach to compare and visualize asset analytics on customer smart devices.
  • Extract data from non-SAP sources and design data models in SAP HANA environment
  • Enhance datasources, changes in respective Transformations/Routines as well as InfoProviders.
  • Involve in unit testing, integration testing and UAT testing.

Technical Environment: SAP ECC 6.0, SAP BW 7.3 on HANA Database, SAP HANA 10.0 SP 7, BODS 4.0, SAP Fiori, SAP BOBJ 4.1, WebI, Xcelsius dashboards

Confidential, Memphis, TN

Sr. SAP BW BPC Developer

Responsibilities:

  • Manage the BI & ABAP team and help the team in resolving the technical issues.
  • Re-designed and implemented approach to derive and calculate unit of measure custom logic BadI effectively
  • Involved in design & implementation of Default logic enhancement for trade profit, cash flow calculations for different modules.
  • Involved in enhancements of BAdIs for Cost Center, Direct Profit Models
  • Helped in enhancing the performance of data loads - master data & transaction data, drastically reduced the execution time.
  • Built Info Cubes, DSO, Hierarchies, Info Sets and MultiProviders and Core Reporting Queries.
  • Reviewing the functional specifications and incorporating necessary modifications as per Business requirements
  • Enhancement of datasources changes in respective Transformations/Routines as well as Infoproviders.
  • Performed enhancements for both the transactional and master datasources and written the ABAP logic for the enhancements in order to meet business needs.
  • Involved in unit testing, integration testing and UAT testing.

Technical Environment: SAP EPM BPC NW 10.0, SAP BW 7.3 on HANA database, ECC 6.x

Confidential, Bellevue, WA

Sr. SAP BW BPC Developer

Responsibilities:

  • Interacting with the Client Team in understanding the business requirements and coming up with the Design document.
  • Manage the BPC team and help the team in resolving the technical issues.
  • Design and developed a Model for Consolidation.
  • Design and developed a Driver Based Planning Model.
  • Design and developed BAdIs for Consolidation and Planning Models
  • Conducted the workshops with the client and finalizing the design Document.
  • Developed Prototypes for all the Complex requirements.
  • Customized Lo Cockpit data source to include custom defined fields and populated those fields using customer exits before the setup.
  • Created Process chains for Master and Transaction data load.
  • Created Bex Queries for Warranty Report, Inventory Aging, sales representative efficiency, Vendor Delivery efficiency.
  • Developed Validation reports to check on master data changes.
  • Developed data models, data flow diagrams, functional design and technical design documents for BI Solutions
  • Built info objects, master data objects, DSO and info cube
  • Mapped the third party data to SAP data
  • Built customized Cubes and Multi provider for Sales; Developed BEx reports
  • Tested for data integrity, Data load/query runtime performance
  • Involved in unit testing, integration testing and UAT testing.
  • Focused on developing team spirit, motivation and Technical knowledge.

Technical Environment: SAP EPM BPC NW 10.0, SAP BW 7.3 on HANA database, ECC 6.x

Confidential, Rosemead, CA

SAP BW HANA BODS Developer

Responsibilities:

  • Design and Develop Data Models for Advanced Asset Analytics capturing Asset Telemetry and Residual Life Analytics, Asset Risk Portfolio and What-if Analytics and Asset Failure Analytics on SAP HANA Studio.
  • Design and Develop Data Models for Meter to Cash Analytics capturing Meter Event Analytics and Customer Consumption Analytics on SAP HANA Studio.
  • Analyze and compare these analytics with SAP Smart Meter Analytics
  • Built Webi and Xcelsius reports
  • Used Calculation and Analytical views
  • Custom extractors was used to bring in the Smart Meter data
  • BW DSOs was used as the source, BODS was used to pull data into HANA and reporting was done in BOBJ

Technical Environment: SAP HANA 1.0 Studio, SAP BOBJ 4.0 - IDT, Dashboards, SAP BODS 4.0

Confidential, Houston, TX

SAP BW BPC ABAP Developer

Responsibilities:

  • Worked on Business Transfer of customers between different Business operating companies in APO BW within SAP to SAP
  • Worked on extraction of Sales Order data from ECC system directly into APO BW system without disturbing delta load of SAP BW system.
  • Worked on Business Transfer of customers between different Business operating companies in APO BW from third-party systems like SUS to SAP
  • Worked on purchase, sales and chargeback rebates implementing custom rebate basis logic using SAP - Vistex
  • Involved in enhancements to P&L forecasting using custom logic BADIs in BPC NW
  • Involved in data load monitoring with effective bug fixing as and when an issues arise.
  • Prepare and Executed Test Cases for queries in Development Test and Production Server.
  • Involved in collection and transport of objects to quality & production systems
  • Involved in unit testing and Integration testing with client in APO BW.

Technical Environment: SAP Confidential /3, SAP BW 7.0, BPC 7.0 NW, SAP APO BW, SAP BW 7.3 (checking new features), SAP BOBJ - Crystal Reports, Xcelsius dashboards

Confidential, Battle Creek, MI

SAP BW BPC ABAP Developer

Responsibilities:

  • Worked on retraction of CCA data from BPC to SAP ECC system using BAdi.
  • Extraction of actual and planned data from BPC into BW cubes for Bex Reporting.
  • Created custom data sources for custom hierarchy.
  • Generic data source creation to extract Red K price using function module.
  • Data Source Enhancements using BADIs.
  • Involved in BI business content installation in Client server.
  • Involved in Migration from SAP BW 3.5 to SAP BI 7.0
  • Worked on Customer Exits for query variables and Virtual Key Figures and Characteristics
  • Involved in Estimation and Designing of Technical Documents for Functional Specifications.
  • Extracted data from CRM data sources to BW and generated reports as per customer requirement.
  • Prepare and Executed Test Cases for queries in Development Test and Production Server.

Technical Environment: SAP ECC 6.0, SAP BI 7.0, BPC 7.0 NW, SAP BOBJ - Webi Reports, Crystal Reports, Xcelsius dashboards

Confidential

SAP BW ABAP Developer

Responsibilities:

  • Involved in Design and Development for new Enhancement requirements.
  • Created new reports according to the user requirements which also involved Jump Queries.
  • Created Technical design for pricing simulation.
  • Involved in Estimate and Execute Change Requests.
  • Involved in reconciliations process for major scenarios and Involved in rectification process if there is any disturbance between Confidential /3 and BW, preceded with rectification plans.
  • Created and Maintained Info spokes through Open Hub Services (OHS) to export data from data target to External Logical system.
  • Generated an online report that SWCC (Client Basis Team) can use immediately before importing a transport into production to prevent overwrite with Back version of objects.
  • Implemented a BAdi enhancement to verify the versions of objects at the moment of release of a transport.
  • Created a Back order reports to help client in successful deletion of back orders related to a sale order simultaneously selecting different line items.
  • Generated reports to calculate monthly budgets, cost plans and implemented BAdis to increase expenses on internal orders and decrease budget related to Goods Movement in warehouse.
  • Co-ordinate all activities between Off-shore On-shore teams and communicate effectively with client team.
  • Daily monitoring the 6 production systems and implement solutions when a disruption occurs in any data loading processes.
  • Used Clear Quest tool to maintain the tickets and activities history.
  • Communicated effectively with client and brought long standing issues to closure.
  • Handled High priority Tickets and successfully got them to closure on time.
  • Trained newly joined junior level resources in the project and assisted the team members whenever required.
  • Transferred KT to associate team members.

Technical Environment: SAP ECC 6.0, SAP BI 7.0

Confidential

SAP BW ABAP Developer

Responsibilities:

  • Enhancing existing functionalities with the help of BADI.
  • Solving the critical issues in time and providing a quick response to client’s queries.
  • Has performed the unit Testing and helped on-site team in integration Testing.
  • Has prepared the Technical design, Test Scripts.
  • Developing RFCs, BAPIs and configuring Interface architecture though IBM JCA Adaptor
  • Involved in monitoring process chains and reporting errors if any to client team
  • Performing end to end testing and prepared test documents based on different test conditions.
  • Make modifications to the objects based on the CRs in the specified time lines.
  • Being Mentor to ASEs in the project by helping them in learning interfaces according to business scenarios

Technical Environment: SAP ABAP- Enhancement Framework, BW 3.5, BADIs

Confidential

SAP BW ABAP Developer

Responsibilities:

  • Involved in writing ABAP routines in update rules, transfer rules.
  • Developed Smartforms,
  • Worked on ALV reports,
  • Worked on module pool programming
  • Has prepared the Technical design, Test Scripts.
  • Performed unit testing and prepared test documents based on test conditions.
  • Has performed the unit Testing and helped on-site team in integration Testing.
  • Track External defects in Solution Manager
  • Resolve the tickets related to the objects assigned
  • Make modifications to the objects based on the CRs in the specified time lines.
  • Provided Knowledge sharing session on Smartforms to fellow project members

Hire Now