We provide IT Staff Augmentation Services!

Sr Sap Bw/hana/bo/ Developer/lead Resume

Plano, TX

PROFESSIONAL SUMMARY:

  • SAP AG Certified in SAP BI 7.3/BO 4.0 and SAP HANA with 10 plus years of experience.
  • Expertise in all phases of SDLC like Realization, Analysis, Functional and Technical specification, Development, Integration and UAT, End - User trainings and Post Go-Live support.
  • Experience in Leading and managing teams. Handled multiple roles like Senior BI consultant, Onsite Coordinator, BW Tech Lead and BW Developer.
  • Holding more than 5 years of experience in Webi Reporting and Administration.
  • Good Experience in Webi reporting on Non-SAP sources and on SAP HANA (Ms Access, Oracle, etc).
  • Expertise in ETL and Data Modeling (Data Extraction, Generic Extraction, Data Loading), Scheduling, Monitoring, Reporting Web publishing.
  • Extensively worked on Info-objects, Info Sources, Info Cubes, DSOs, Multi Provider, Info Set, Transformations and Process Chains.
  • Extensively worked in BW Security on end user authorizations for reporting.
  • Good Experience in Experience in Solomon Manager - Charm.
  • Strong ABAP programming skills including Data Source Enhancements, Routines (Start, Field, End and Expert Routines), Customer Exit Variables, Info Package and DTP Routines.
  • Exclusively worked on BW/HANA testing, Unit Testing, Regression testing and DR testing.
  • Experience on Native HANA and SAP BW Powdered by HANA
  • Experience on SAP Native HANA Data Provisioning (SLT, DXC and BODS), Data Replication, Modeling and Reporting.
  • HANA modeler experience includes creating Composite Providers, Advanced Data Store Objects, HANA Views (Analytic, Attribute and Calculation). Extracted data from ECC and created reports using reports SAP Landscape Transformation Replication Server (SLT). Created reports on external Databases using Smart Data Access (SDA). Business Objects Data Services (BODS) is used as an ETL from extracting data from external systems.
  • Involved in Transporting HANA Views from Dev to Production using Delivery Units.
  • Have hands on experience in HANA modeling in creating Attribute, Analytic and Calculation Views.
  • Extensively Involved in the SAP BW 7.3 to 7.4 upgrade with HANA as database
  • Extensive knowledge in Integrated Planning, resolved the end user incidents in IP.
  • Involved in three full - life cycle BW implementations, upgrade from 3.X to 7.0, Enhancements and Post Production Support in the areas of SAP SD, MM, PP, PM,PS, FI and SAP CRM.
  • Expertise in BW Performance Tuning of Queries by maintaining Aggregates, Compression, partition and indexing of Info Cubes.
  • Extensively worked on Tableau Dashboards on top of HANA, BW Systems.
  • Proficient in loading data from different sources to HANA using SAP Data Services with good exposure to all the transformation available, repository creations and scheduling the jobs in Management Console. Hand on experience in writing and tuning SQL.
  • Knowledge on BW-BPC.
  • Good Knowledge in pre and post activities in the upgrades from BW 7.x to BW 7.5.
  • Good Knowledge on Enterprise HANA and Live HANA.
  • Worked on LUMIRA as frond end reporting tool.
  • Extensively worked on Data Source Enhancement using Customer Exit and Badi (Multiple Implementations).
  • Proficient in all kinds of Routines (Start, Field, End and Expert routines). Ability to identify the suitable routine based on the scenario.
  • Expertise in design and development of Generic Data Source Extraction using Table, View, Info Set Query and Function Module with delta functionality.
  • Extensively worked on Customer Exit Variables using Customer Exit and Enhancement Spot/New Badi (Multiple Implementations).
  • Worked on Info Package and DTP routines.
  • Expertise in Debugging, Performance tuning of various objects and designed the documents for best practices in BW environment.
  • Extensively worked on Attribute Views (Standard, Time and Derived), Analytic and Calculation Views (Graphical and Script based), Creation of Hierarchies, Variables and Input parameters.
  • Proficient in creation and calling procedures, using the CE functions based on the requirement.
  • Excellent knowledge on Data Replication Techniques using SLT, BODS, DXC and SDA.
  • Proficient in SLT configuration and replication of tables by using various replication techniques.
  • Involved in importing the BW models from SAP BW HANA to the HANA Studio.
  • Good Knowledge in SAP HANA security including User Management, Roles and Privileges.
  • Extensively worked on migration of standard Info cube and DSOs to HANA-Optimized Info Cubes and DSOs by using Tcode ‘RSMIGRHANADB’.
  • Good working knowledge in creation of Advanced DSO.
  • Worked on Open ODS View, Composite providers and Transient providers.
  • Proficient in importing HANA models into BW system.
  • Developed Webi reports on BW queries and HANA views used the IDT.
  • Created the connection between IDT and HANA views
  • Proficient in importing HANA models into IDT
  • Created Interactive design studio dashboards on HANA views.

PROFESSIONAL EXPERIENCE:

Confidential, Plano, Tx

Sr SAP BW/HANA/BO/ Developer/Lead

Responsibilities:

  • Extensively worked on FI reporting, created the FL flow from scratch.
  • Managed, Configured and Performed Transports between multiple BW environments. Defined practices for BW transport management. Created multiple process chains for Delta & Full Data sources. Troubleshooting data and technical issues related to SAP BW.
  • Interaction with business users and gathered the requirement and built the BI reporting accordingly.
  • Extensively worked on the custom/standard Info-objects, Info Sources, Info Cubes, DSOs, Multi Provider, Info Set, Transformations and Process Chains.
  • Led efforts on handling of UAT and coordinating with offshore team for quick closure of bugs reported
  • Worked on SAP MM, SD, FI, HR and all other modules.
  • Created customer data sources and worked on SAP defined data sources and built the BW flow according to the requirement.
  • Worked on SAP BW on HANA and worked on mixed modelling scenarios.
  • Worked on HANA studio, created the Information Views.
  • Worked on APD’s and OHD’s extensively.
  • Worked on pre and post BW version upgrade activities.
  • Worked in Solomon Manager, used CHARM as the transport mechanism to transports the objects throughout the landscape.
  • Worked extensively on DVM activities.

Confidential, Pheonix, Arizona

Sr SAP BW/HANA/BO/ Developer/Lead

Responsibilities:

  • Designed and implemented SAP HANA data modeling using Attribute View, Analytic View, and Calculation View.
  • Involved in Test final output based on requirements and business needs.
  • Extensively worked on Info-objects, Info Sources, Info Cubes, DSOs, Multi Provider, Composite Providers, Transient Providers and Transformations and Process Chains.
  • Created BEx Reports providing insight of Business Intelligence to aid the analysts in decision-making using Formulas, Selections, Structures, Calculated Key Figure, Restricted Key Figure and Customer Exit.
  • Developed BOBJ Webi reports on BW queries and HANA views used the IDT.
  • Worked on SAP Native HANA and BW on HANA used the Data Provisioning (SLT, DXC and BODS and SDA), Data Replication, Modeling and Reporting.
  • Worked on HPQC tool for BW testing, created test scripts, test plans.
  • Worked Extensively on Webi reporting using BICS connection to connect the Bex Queries.
  • Exclusively worked on BW/HANA testing, Unit Testing, Regression testing and DR testing
  • Worked on DSO look-ups at start routine and end routine using Classes and Methods.
  • Creation/Change of Process Chains for the entire Daily / Weekly/Hourly Loads..
  • Provided hyper care- Post Implementation Production Support includes Monitoring the Process Chains Daily, Weekly and Monthly. Troubleshooting and Correcting the Data Load Errors.
  • Involved in Data Source Enhancement using the BADI-Enhancement Spot.
  • Involved in all support pack activities every quarterly.
  • Created the connection between IDT and HANA views
  • Proficient in importing HANA models into IDT
  • Created Interactive design studio dashboards on HANA views
  • Created Info objects, DSO’s, and Cubes & Multi providers as per the data model. Defined several transformations as per the need. Performed clean-up activities for the pre-emigration of BW on HANA implementation. Optimized BW cubes for HANA purpose .
  • Created generic data source for custom requirement and enhanced data sources as required.
  • Managed, Configured and Performed Transports between multiple BW environments. Defined practices for BW transport management. Created multiple process chains for Delta & Full Data sources. Troubleshooting data and technical issues related to SAP BW.
  • Created Complex Bex reports using Composite Providers.
  • Create Open ODS view and Advanced DSO’s in HANA Studio.
  • Reconciled Inventory and purchasing data from BW to R/3 for existing Production reports

Confidential, Dallas, Texas

Sr SAP BW/HANA/BO//Lead

Responsibilities:

  • Facilitate requirements gathering and reconciliation of data definitions with business and IT experts.
  • Playing a Lead role for onshore and offshore.
  • Designed and implemented SAP HANA data modeling using Attribute View, Analytic View, and Calculation View.
  • Involved in SAP HANA Security including User Management, Roles, and Privileges.
  • Evaluate the information gathered from multiple sources, reconcile conflicts, and decompose high level information into details, abstract up from low-level information to a more general.
  • Understanding, distinguish presented user requests form underlying true needs and distinguish solution ideas from requirements.
  • Involved with basis team in the upgrade process from BW 7.3 to BW 7.4 version HANA as a database.
  • Prepare requirements documents to be used as the basis for project development.
  • Leading Onshore and Offshore teams.
  • Involved in BO and Tableau server maintenance and installation, configuration.
  • Experience in publishing reports, dashboards and data sources to Tableau Server.
  • Test final output based on requirements and business needs.
  • Using Design Studio created the dynamic dashboards.
  • Coordinate with global IT and Business teams to deliver the requirements
  • Created the Open Hubs for PS Flow, HRMS, Time Entry and COPA Data Flows to transfer the data to Third Party PDW System.
  • Extensively worked on Info-objects, Info Sources, Info Cubes, DSOs, Multi Provider, Info Set, Transformations and Process Chains.
  • Extensively worked on Data Source Enhancements.
  • Data provisioning using SAP Landscape Transformation and SAP Dataservices, DXC, Flat File Uploader, SAP HANA Architecture Participated in year-end Rollover to gather requirements from business, do impact analysis and Implement changes.
  • Used DSO look-ups at start routine and end routine.
  • Worked on SAP Native HANA Data Provisioning (SLT, DXC and BODS), Data Replication, Modeling and Reporting.
  • Expertise in SAP Native HANA data modeling using Attribute View, Analytical view and Calculation view where non BW sources where used.
  • Experience on Open ODS View, Composite providers and Transient providers
  • Created BEx Reports providing insight of Business Intelligence to aid the analysts in decision-making using Formulas, Selections, Structures, Calculated Key Figure, Restricted Key Figure and Customer Exit.
  • Created multiple Visualization reports/dashboards using Dual Axes charts, Histograms, Filled map, Bubble chart, Bar chart, Line chart, Tree map, Box and Whisker Plot, Stacked Bar etc. using tableau.
  • Involved in writing the td and fd documents, and developing and deploying technical components of Tableau BI Solution.
  • Created daily, weekly, monthly and quarterly reports for the management team and Regional Managers
  • Create parameterized reports (these reports show information from highest level by company and can be drill-down to single product using hyperlinks), cross-tab, conditional, and Top N, Summary and Sub reports in Web Intelligence.
  • Effectively used data blending, filters, actions and Hierarchies feature in Tableau
  • Experience with Single Sign on with Tableau.
  • Worked on data blending for data extracts and ability to work with multiple data sources.
  • Built the tableau dashboards and bubble charts as the source as SAP BW (bex query) and SAP HANA views.
  • Developed story boards and dashboards on HANA Information models using SAP Lumira.

Confidential

Sr SAP BW/HANA Developer

Responsibilities:

  • Creation/Change of Process Chains for the entire Daily / Weekly/Hourly Loads as and when required.
  • Supporting multiple projects wherever necessary.
  • Worked on LO-Extraction, CO-PA extractions and F1 Extraction.
  • PFCG & RSECADMIN transactions for creating, maintaining roles and authorizations in assigning authorization values to the BW Custom objects.
  • Involved in designing the functional and technical specs for the ECC 6.0 and HANA Models.
  • Involved in SAP BI with HANA Migration.
  • Experience in SAP Native HANA data provisioning using SAP LT Replication Server (SLT) and data services and Flat files.
  • Worked on HPQC tool for BW testing, created test scripts, test plans.
  • Develops specific test conditions and expected results for functional and regression Test Scenarios and Test Cases based on Functional requirements, and Technical & Interface specification
  • Maintained QA Status Report, QA Summary Reports, QA Test Logs, Maintain issue and defect databases.
  • Created Tableau scorecards using stack bars, bar graphs, scattered plots, geographical maps
  • Employed various Tableau functionalities like Tableau Extracts, Parameters, Filters, Contexts, Data Source Filters, Actions, Functions, Trends, Hierarchies, Sets, Groups, Calculations, Data Blending and Maps etc.
  • Provided 24/7 production support for Tableau users and conducting trainings to interact, filter, sort and customize views on an existing visualization generated through Tableau Desktop.
  • Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau
  • Worked in BW IP(Integrated Planning), resolved the IP issues when users had issues with their budgeting their five year plan.
  • Created Planning Function, Planning Sequences and Filters on Aggregation Levels for Planning in IP.
  • Worked closely with end user to handle the budgeting and forecasting issues.
  • Exclusively worked on BW/HANA testing, Unit Testing, Regression testing and DR testing
  • Experience in SAP Native HANA data modeling using Attribute View, Analytical view and Calculation view where non BW sources where used.
  • Involved in full project life cycles (i.e. requirements gathering, design, development, test, cut-over and support) as SAP BW developer, and one full project life cycle as SAP HANA Modeler
  • Created BEx Reports providing insight of Business Intelligence to aid the analysts in decision-making using Formulas, Selections, Structures, Calculated Key Figure, Restricted Key Figure and Customer Exit.
  • Extensively Involved in the SAP BW 7.3 to 7.4 upgrade with HANA as database
  • Cross Verifying the Daily data load as per the checklist for ensuring the proper data upload in BI.
  • Extensively worked in developing and enhancement in WEBI Reports
  • Checking the daily time schedule for the run & ensuring that the jobs are finished within the specified time frame.
  • Interacting with the clients from time to time to discuss the open issues.
  • Worked with all the SAP modules, FI, PM, COPA, MM, SD, CLM, RLM, and HR.
  • Changes to the existing Reports & Creation of new Reports as per Clients requirements.
  • Fixing the High and Medium, low priority incident raised by users.
  • Actively involved in end user training as well as developer training. Created technical documentation, user training manuals etc.
  • Led efforts on handling of UAT and coordinating with offshore team for quick closure of bugs reported
  • Monitoring the Production/ Pre- Production system and fixing the Master data, Transaction data and Process Chains load failures.
  • Worked on creating BW Security related objects for end user reporting.
  • Extensively involved in writing Routines, Start Routine, End Routine, Info package routines.
  • Enhanced the Standard Data Sources and Variables using Customer exit and BADI.
  • Having knowledge on Creating PM Orders in ECC (OLTP) for testing BI (OLAP) reports.
  • Extensively involved in SR Process and incident Management Process.
  • Working major issues on integrated planning.
  • Develop WEBI Reports based on client requirements.
  • Created SAP Lumira reports and Webi reports on HANA studio.
  • Analyzed existing business requirements in Tableau.
  • Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
  • Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
  • Experience integrates output with mobile platform and delivers on end user mobile devices and provides training to the end users to view the order in PM module.

Confidential

Sr SAP BW/BO Developer

Responsibilities:

  • Involved in enhancement of the data sources in order to add new field as per client requirement.
  • Populated the historical data for new infoobject in infocube by using remodeling method.
  • Designed user’s manual for training.
  • Extensively worked in end to end implementation in BW-IP for the budget forecasting.
  • Worked in the BODS4.0 Environment, the entire project implementation was on 4.0
  • Extracted Data from all the Relational Databases including oracle, Microsoft Sql server and loaded in different environments which include BW, ORACLE, SQL SERVER, and .txt & .CSV files.
  • Creating Jobs, Work flows, data flows and scripts in Data Integrator to pull data from the legacy systems and load the data into target database. Writing SQL Statements in DI scripts to modify data. Created initial and delta loads.
  • Involved in the production support, and interacted with the Reporting developers to change the code of the Tables based on their reporting requirements.
  • Worked on comprehensive process of Order to Cash cycle posting and reporting.
  • Create Functional Requirement Documents based on Adhoc requirements gathered from user
  • Worked on simplified Order to Cash cycle like order-to-invoice and invoice-to-cash
  • Worked on SD business processes OTC and sales order processing, Delivery, shipping and billing
  • Responsible for design of the data flow and developing DSOs for Line items, InfoCubes for summarization, and MultiProviders for Cross reporting
  • Built new DSO’s infoCubes, multi-providers to support SD, FI-CO, GL, PP, GR, and AP reporting requirements.
  • Enhanced extract structures for Master Data to bring additional fields in to BI and created custom Data Sources for transaction data to meet the business requirements.
  • Advised the functional team about the impact in BI and with the extractors when they require a configuration change in ECC.
  • Utilized BI 7.0 transformations and DTPs for all new developments.
  • Developed new BEx Queries, workbooks based on the different InfoProviders.
  • Involved in performance tuning by maintaining aggregates, compression, partitioning, indexing of info cubes.
  • Maintenance of Hierarchies Structures
  • Create CKF and RKF as needed and adopt performance on all queries
  • Created queries in Query Designer and deployed to the Portal
  • Activated required BW Statistics Objects and created a virtual Cube that is required for Reports.
  • Developed process chains to automate the initialization and delta updating of all data.
  • Created over BEX queries and assigned them to roles by department.
  • Provided Post Implementation Production Support includes Monitoring the Process Chains Daily, Weekly and Monthly. Troubleshooting and Correcting the Data Load Errors
  • Resolved Tickets Raised by Users.
  • Enhanced the Existing Reports based on User Requirements to include New Functionality.
  • Created Generic extractors for custom table and loaded data into BI.
  • Created/Modified custom Infocubes, DSOs, Transformations, Infopackages, DTPs as per the requirement.
  • Created Open Hub Destination for Info Cubes, DSOs and Infoobjects to generate Flat Files.
  • Performed Unit testing for the changes and new functionality and transported dependent objects to test environment and into Production.
  • Identified the necessary Business Content using content browser and content analyzer, mapped the business process requirements with the available Business content.
  • Installed and activated the relevant Business content for master data and transactional data.
  • Implemented standard Business Content FI-GL, FI-CO and FI-AP cubes for transaction figures reports.
  • Prepared Technical specifications for the Functional Specifications.

Confidential

SAP BW/BO Developer

Responsibilities:

  • Worked on requirements gathering for HR reports from various Modules like PA & OM.
  • Worked on data modeling and created Info objects, DSOs, Multiprovider, Infocubes, Infosets, Transformations, DTPs and Info packages.
  • Enhanced many datasources and wrote customer exit to get the data for additional fields.
  • Created generic data sources to extract the data from PA & OM modules.
  • Worked on HR Employee, Personnel Actions, Head count and Payroll extractors to pull the data from R/3 system.
  • Configuring master data and business content for POSDM to BW.
  • Thorough understanding of SAP BW cubes, POSDM data aggregation, POSDM reports
  • Worked on Start routine, Update routine and End routine to extract data for various field.
  • Created Process chains to automate the HR data load process for both Master data and Transactional data info cubes.
  • Worked on Transports Maintenance for all developed objects for HR module.
  • Created delegation reports for both Org Management and Personnel Actions.
  • Worked on HR Structural Authorizations to implement security on HR reports.
  • Interacted with Power users by providing demo and user training on how to use the various HR reports and BEx tools.
  • Delivered the documents for all new objects and enhancements.
  • Worked on support tickets from end users on various issues related to BI reports.
  • Monitored Process Chains, loading errors and analyzed system logs and ABAP/4 dumps.

Confidential

SAP BW/BO Developer

Responsibilities:

  • Installed Business Content and activated the SAP delivered Standard InfoCubes and InfoSources
  • Worked on Generic Data Extraction (RSO2) to create DataSources for transaction and master data
  • Created Views in the non-SAP database systems and generated Data Source for the tables/views.
  • Maintained customized InfoCubes, Operational Data Sources, and MultiCubes for the business requirements.
  • Defined update and transfer routines in transformation rules.
  • Worked on Process Chains to load InfoCube, ODS, aggregate roll up etc.
  • Extensively used BEX Analyzer to build queries, queries with maps and charts and Worksheets to access data from BW data targets.
  • Involved in the development of programs for data conversion, interfaces, custom reports and transmission of data to vendors using advanced concepts like BDC, LSMW, and SAP Scripts

Hire Now