We provide IT Staff Augmentation Services!

Sr. Sap Bw/hana/abap/bobj - Development Resume

Kansas City, MissourI

PROFESSIONAL SUMMARY:

  • Around 12 years of IT experience in which 11.5 years are in SAP BW/HANA/ABAP/BOBJ with three implementations, involved in support and upgrade projects.
  • Having hands on experience on BW 7.4 with HANA 1.0, 6 years of SAP BOBJ and 5 years of experience in SAP HANA.
  • Excellent Skills in all aspects of SAP BI tools which includes Extraction from SAP ECC, SAP BW Data modelling to Universe creation using IDT and UDT including report creation using SAP Business Objects3.1/4.0/4.1 versions.
  • Worked on the BW7.4 objects with HANA like Composite providers, Transient providers, Analytic indexes and ODS views.
  • Good knowledge on SAP HANA Data Modeling and Data Provisioning using BODS and SLT.
  • Hands - on experience in creating HANA objects like Attribute View, Analytic view, Calculation View, Decision tables, Variables and input parameters
  • Hands-on experience in creating BW objects like ADSOs, DSOs, Infocubes, Virtual, Multiproviders and Infosets as per LSA Architecture.
  • Knowledge in SAP Desgin studio, Qliksense and Created reports in Tableau and also using Qlikview.
  • Having experience in User administration activities like Creation, Deletion, Modification of user master record, creation/deletion of user groups, Locking/Unlocking, Validity date, password reset.
  • Excellent experience in designing Infocubes, DSOs by using data extracted from R/3 modules SD, Purchasing, MM, FI-CO, FI AR/AP/GL, CO-PA, HR as well as legacy systems.
  • Involved in upgrade projects like BW7.0, BW7.3 to BW7.4, and also in patch upgrades.
  • Expertise in working with BEX Query Designer in building Queries.
  • Extensively created Calculated Key Figures, Restricted Key Figures, Formula Variables, Conditions, Exceptions, Aggregations, Cell editors, Customer Exit Variables and Structures for developing custom reports.
  • Experience in security in BW including infoobject level security by maintaining them as authorization-relevant and using them in Analysis Authorization.
  • Created roles and restricting them in Queries, Infocube, Infoarea levels.
  • Strong ABAP programming and debugging skills. ABAP in Data dictionary, datasource enhancements & user exits in R/3 & BW, Routines in Transformation, Transfer and Update rulesUser Exits for custom variables.
  • Excellent Client facing skills in understanding requirements and thoroughly documenting it.

TECHNICAL SKILLS:

BI Tools: SAP BW Netweaver 7.0/7.3/7.4, Bex Queries, and SAP Business Objects 3.x/4.1/4.0.

Database: HANA1.0, Oracle 10g/9i/8i/7.3, SQL Server 2000/2005, DB2, MS-Access.

O/S: Windows8/10, 2000/2007 and XP.

PROFESSIONAL EXPERIENCE:

Confidential, Kansas City, Missouri

Sr. SAP BW/HANA/ABAP/BOBJ - Development

Responsibilities:

  • Created Attribute views, Analytic views and Calculation views using the data flow of MM, FI, COPA related dataflows.
  • Created ADSO and Composite providers for logistics, custom Finance related dataflows.
  • Created WEBI reports for the data flow related to FICO, MM and SD.
  • Created WEBI reports on BEX query using BICS connection including Cross Tabs, Charts and linked reports.
  • Enhanced the existing datasources by using BADI related to COPA and Custom datasources.
  • Created process chains for the respective data flow of SD, MM, FICO etc.,
  • Worked on routines like start and end routine in the SAP BW.
  • Created BEX customer exits for the client requirement specific reports.
  • Transports of BW objects between the systems and BO objects using Promotion Management.
  • Worked on the tasks related SAP BO CMC in giving the access to respective users.
  • Debugging of code through RSA3 and checking the data consistency.

Environment: SAP BW7.4, HANA 1.0 SP12, ECC 6.0, Analysis Office and SAP Business Objects 4.0

Confidential, Conklin, New York

Sr. SAP BW/ABAP/BOBJ - Development

Responsibilities:

  • Created WEBI reports on BEX query using BICS connection including Cross Tabs, Charts and linked reports.
  • Created Planning functions, Filters, Planning sequences for the planning activities of data.
  • Created process chains related to Planning activity.
  • Enhanced the existing datasources related to FI-AR, MM and Custom datasources.
  • Created process chains for the respective data flow of SD, MM, FICO etc.,
  • Developed routines like start, end and expert routine in the SAP BW.
  • Created Linked reports in the WEBI for detailed reports.
  • Created BEX customer exits for the client requirement specific reports.
  • Transports for BW objects between the systems
  • Debugging of datasources through RSA3 and checking the data consistency.
  • Created technical documents in a detailed step by step procedure.
  • Monitoring of daily loads and resolving the failures of it if any.
  • Created aggregates and rebuilding the indexes for good performance of loading data.

Environment: SAP BW7.3, ECC 6.0 and SAP Business Objects 4.0

Confidential, Mason, Ohio

Sr. SAP BW/ HANA /ABAP/BOBJ - Implementation

Responsibilities:

  • Created ADSOs, Composite providers for the dataflow related to CRM, EM, FICO, AR, Vistex, SD, MM, COPA and ECC loads.
  • Created Attribute Views, Analytical Views, Calculation Views by graphical and by Script.
  • Created and managed Delivery Units to move across different environments.
  • Created Variables, Input parameters and Hierarchies in the HANA Views.
  • Implemented data flow related to Vistex like sales incentive line, sales incentive header and condition datasources.
  • Created Tableau reports using BEX queries and by using HANA views.
  • Worked on the SLT by activities like Load, Replicate, Suspend and Resume.
  • Extraction of data from event handler data and events from EM systems.
  • Worked HANA SQL scripts and procedures.
  • Created WEBI reports on BEX query using BICS connection including Cross Tabs, Charts and linked reports using OpenDocument for Summary and Detail reports.
  • Appended datasources using BADIs.
  • Loading of data into SAP HANA by using SAP HANA SDI process.
  • Created BEX customer exits for the client requirement specific reports.
  • Created customized datasources using tables/view.
  • Involved in transporting objects between BW system environments and also corresponding SAP R/3 environment and BOBJ objects by using LCM.
  • Created reports in SAP Lumira based on the Hana Views.
  • Created process chains for all the dataflows like masterdata, transaction data including functional areas like CRM, FIAR, FIGL, SD, MM and Vistex.
  • Created APDs and Open hub for sending data to MDG and CRM systems.
  • Scheduled WEBI reports on the basis of daily, weekly and monthly wise.

Environment: SAP BW 7.4 SP10, ECC 6.0, Tableau 9.1, SAP Business Objects 4.1 and HANA 1.0 (SPS11/12).

Confidential, Trenton, NJ

Sr. SAP BW/ABAP/BOBJ Consultant/HANA

Responsibilities:

  • Replicated data from ECC to HANA using SLT based table Data Provisioning and also performed operations like, Load, Replicate, Stop, Suspend and Resume as part of Data Provisioning.
  • Created Packages, Attribute Views, Analytical Views, and Calculation Views.
  • Performed data loading into SAP HANA by using SAP BODS.
  • Involved in migrating existing standard InfoCubes, DSO's and SPO's to HANA-Optimized InfoCubes, DSO's and SPO's respectively.
  • Created and managed Delivery Units to move across different environments.
  • Created Variables and Input parameters in the HANA.
  • Created custom specific DSOs, infocubes, Datasources, calculated /restricted key figures and BEX reports.
  • Created WEBI reports on BEX query using BICS connection including Cross Tabs, Charts and linked reports using OpenDocument for Summary and Detail reports.
  • Scheduled delta loads, monitoring data loads, PSA maintenance and de-bugging/rectification of data load errors.
  • Created BEX customer exits for the client requirement specific reports.
  • Involved in transporting objects between BW system environments and corresponding SAP R/3 environment.
  • Reconciliation of data related to FICO and COPA between WEBI and ECC.
  • Created process chains using APD step.
  • Scheduled WEBI reports based on daily, weekly and monthly wise.
  • Designed technical solutions and created technical documentation for all the enhancements.
  • Estimate the efforts required for developing required objects.
  • Maintained Work History and communicated the status with the clients.
  • Guided support team for resolving data load issues and upgrade issues.
  • Created Universe using BEX queries in BOBJ 3.1 and connections to the BEX.
  • Transported the Universe, Connections and WEBI reports to across the systems.

Environment: SAP BW7.3, SAP BW 7.4, ECC 6.0 and SAP Business Objects 4.1/4.0/3.1, SAP BODS and HANA SPS09

Confidential, Greenland, NH

Sr. SAP BW/ABAP/BOBJ Consultant

Responsibilities:

  • Enhanced existing Reports based on BRS and FRS given by Users.
  • Worked on functional areas related to COPA, MM, SD, PM and Inventory functional areas.
  • Developed infoCubes, InfoSource, Info Objects, ODS objects, Update rules and Transfer rules, Delta management, Transformation, BEX queries and installation of Business content objects.
  • Took Initiative for requirement gathering from APO Consultants and Functional Consultants.
  • Designed technical solutions and created technical documentation for all the enhancements.
  • Estimate the efforts required for developing required objects.
  • Wrote ABAP Routines in SAP APO Objects.

Environment: SAP BW 7.3, SAP APO and ECC 6.0.

Confidential

SAP BW/ABAP/BOBJ/HANA Lead Consultant

Responsibilities:

  • Developed the SAP BI objects from extraction to reporting as per user requirements in the areas related to FICO, CCA, GL, HR, Vistex and SD.
  • Created Attribute, Analytical, Calculated views, Analytic authorizations, Decision tables, Hierarchies and Delivery units for transportation in SAP HANA.
  • Enhanced datasources by using ABAP exits in the ECC.
  • Solved the security incidents reported by end users experiencing problems in viewing the WEBI reports.
  • Created WEBI reports from Bex queries and presented users the various functionalities of WEBI reports like Query Stripping, Hierarchies, creating Cross tabs reports and Linked reports.
  • Created WEBI reports on HANA System as a Proof of Concept for Performance improvements.
  • Created new SAP BW Objects like Transient and Composite info provider for consuming SAP HANA views.
  • Created Qlikview reports based on the BEX queries and on HANA views.
  • Extraction of data by using SAP BODS.
  • Created data flow related to Public Sector datasources like Collection agencies, Debit positions, Installment plan items etc.,
  • Created WEBI reports on the top of the data flow related to Public Sector.
  • Involved in the upgrade activities from BI7.0 to 7.3 and BW 7.4 on HANA.
  • Created Bex query based on the Transient provider.
  • Tested the reports by creating the copy roles of the user’s profile.
  • Worked on the roles for respective users in accessing the reports using BO4.0 CMC
  • Created necessary roles as required and assigned them to the proper users.
  • Troubleshooting user issues and authorization issues using SU53 code.
  • Given estimates of new development tasks and billing of it to the clients.
  • Checked the dependency of objects for transports and granted the permission to move it to QA or PRD.
  • Worked on the HANA scripts and HANA procedures and also XHTML coding in the WAD.
  • Scheduled and Monitoring the Data loads by means of Process Chains.
  • Documented all the training material needed for the team members in detail level as and when needed.
  • Involved in SAP BI training for the campus hires.

Environment: SAP BW 3.5, BI7.0, and BI 7.3, BW 7.4, ABAP, SAP BODS, ECC 6.0 and SAP Business Objects 4.0, Qlikview 11 and HANA 1.0 SPS 06/07.

Confidential

SAP BW Consultant

Responsibilities:

  • Scheduled and Monitoring the Data loads by means of Process Chains.
  • Involved in reconciliation activities from different areas like COPA, CCA, PCA etc.,
  • Prepared dashboard reports on weekly basis.
  • Adhoc activities like Selective deletions, filling up of setup tables and scheduling of jobs.
  • Involved in both the Activities monitoring and Production Support.
  • Involved in Validated data consistency with Data Target against PSA after loading them to data targets.
  • Involved and worked on the tasks related to integration planning data.
  • Solved Data Mismatch tickets and analysis of Performance of the system.
  • Created process chains like time based & event based.
  • Involved in maintaining lot of documentation for all the Support Activities.
  • Re-initialization of business area in case of inconsistency in data targets.
  • Monitoring of Info packages and analyzing the reasons for frequent failures of Info Packages BIA & adding of infocubes to the BIA
  • Involved in submitting the Ticket Status (Open/Close) report.

Environment: SAP BI7.0, ECC 6.0 and Windows 7 Professional.

Confidential

SAP BW consultant

Responsibilities:

  • Scheduled and Monitoring the Data loads by means of Process Chains.
  • Analyzed the reasons for failures of Info packages.
  • Maintained Work History for all the tickets until it is closed.
  • Adhoc activities like Selective deletions, filling up of setup tables and scheduling of jobs, Activating and filling the Aggregates.
  • Involved in Production Support like upgrade and outage activities.
  • Involved in Validated data consistency with Data Target against PSA after loading them to data targets.
  • Solved Data Mismatch tickets and analysis of Performance of the system.
  • Maintained the reports about the status, updating the documents for the markets if there is any delay in reports availability.
  • Re-initialization of business area in case of inconsistency in data targets.
  • Involved in training Shadow resources and other team members
  • Involved in submitting the Ticket Status (Open/Close) report.

Environment: SAP BI7.0, ECC 6.0 and Windows 7 Professional.

Confidential

System Analyst

Responsibilities:

  • Analysis of the specifications corresponding to the given functionalities.
  • Made the code changes as per the DDD and see for any peculiar cases which are deviating from the regular process if any.
  • Preparation of Unit test plans and Unit test results.
  • Overseen the Quality procedures related to the project.
  • Supported in User Acceptance Testing.
  • Involved in submitting the Ticket Status (Open/Close) report.

Environment: COBOL, JCL, DB2 and CICS.

Hire Now