We provide IT Staff Augmentation Services!

Systems Architect Resume

Arlington, VA

SUMMARY

  • 13+ years of IT experience which includes 7+ years of experience in BW4HANA and BW on HANA and 7+ years of experience in SAP BOBJ, Tableau and Power BI, 2+ years in Azure Data Factory.
  • Fresh Implementation, Agile Rollouts, Technical & Functional Upgrades, Enhancement projects, Performance & Optimization projects, Migration of SAP BI to Azure Data Lakes and Support Worked as Systems Architect, Business Analyst, Developer, Consultant, Team Lead, and Onsite coordinator through the projects.
  • Extensively worked SAP HANA modeling CDS Views, Calculation Views, Stored Procedures & Table function.
  • Expertise in designing and developing Native HANA Molding which includes Stored Procedures, Analytical Views, Attributes Views and Table Functions and consuming the same in BW as a Native HANA Hybrid model.
  • Designed ADSO, Composite Providers, Transformations, for different data flow mechanisms to extract data from S4 and ECC Systems
  • Worked on SAP HANA Data provisioning using SAP SLT and SAP Data services.
  • Experience in creation of Universe in UDT and IDT, generating BIAR files, Promotion of Universes, import/export of Universe between landscape environments
  • Expertise Business Objects Webi Report, Tableau Dashboards Scheduling, Optimization, Performance Tuning and modeling
  • Designed Power BI dashboards to end users using different visualization methods and Data Sets in backend.
  • Expertise in understanding business flow in different process areas like SCM, P2P, O2C and R2R.
  • Experience in working with different SAP modules like Logistics, One HR and CRM.
  • Worked with Different transformations.
  • Worked on procurement and vendor related tables like EKKO, EKPO, LFA1 and LFB1 etc., by using generic data extraction and for PO related reporting.
  • Hands - on experience of entire ETL process, Analytics & Visualization. Including customization beginning at Data source extractor to Dataflow in BI and views in HANA to defining Universe model and variable or variant in Reports, Webi, AAO to setting up Roles & Authorization.
  • Extensive experience in HANA Modeling, Extraction, Cleansing, Loading, Scheduling, Monitoring, Delta Management, Reporting,troubleshoot issues.
  • Worked on latest Data Modeling objects such as Composite Info provider, Semantic providers.
  • Conduct BI reporting (Bex, BO/WEBI, Dashboards & Crystal) features workshop with business users.
  • Involved in BW on HANA Migration Projects and worked on post migration and pre migration activities.
  • Experienced on SAP HANA Studio, Data Modeling using Attribute Views, Analytic Views and Calculation Views, Table Functions, Procedures, Analytical Privileges and Flow Graphs.
  • Experience in extracting data from ERP and non-ERP systems using standard and custom extractors.
  • Experienced on creating calculation views and procedure relate sales module. Enhanced standard SAP Business Content Extractors of Transaction data 2LIS 11 VAITM and 2LIS 11 VASCL of SD, 2LIS 03 BF and 2LIS 03 UM of Inventory and 0HR PT 1 and 0HR PA 2 of HR, Master data Extractors like 0MATERIAL ATTR, 0PLANT ATTR and 0EMPLOYEE ATTR of Mater data as per business requirement.

TECHNICAL SKILLS

ERP: BW4HANA, BW on HANA, SAP BI 7.0, SAP ECC on HANA, SAP ECC 6.0

ETL: SAP Business Objects Data Services (BODS)

Cloud: SAC, Azure Data Factory, Azure Data Lakes, Cosmos DB

Reporting Tools: Business Objects, Power BI

Job Scheduling: TWS

Programming language: SAP ABAP, SQL, PL SQL

Operating systems: Windows 10

Automation: SAP IRPA

PROFESSIONAL EXPERIENCE

Confidential, Arlington, VA

Systems Architect

Responsibilities:

  • Extensively worked on Native HANA Modeling which includes Stored Procedures, Calculated View, Table Functions and CDS Views.
  • Expertise in Designing and Developing Business Analytical Solution in SAP HANA System in Hybrid as well as Embedded Analytics for critical business decision making.
  • Designed different data model concepts for Native HANA Hybrid models by designing objects in SAP HANA and used in BW Application Layer.
  • Created Native HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies.
  • Extensively worked on HANA Objects development for Confidential critical reporting using IDT and HANA DB Studio 2.0.
  • Experience in working on HANA Eclipse Model and HANA DB Studio 2.0 along with BW Cockpit and FIORI Application.
  • Involved in SAP HANA Data provisioning using SAP SLT and SAP Data services 4.0.
  • Experienced on creating calculation views and procedure relate sales module. worked on creating HANA views using SDI/SDA tables and utilized them in Calculation views.
  • Expertise in consuming S4HANA CDS Views in Analytics and SAC Cloud for end user reporting in different process areas like Sales, Finance and Transportation.
  • Involved in Daily Operational Review Calls with the Project Team to get the list of objects targeted for business as usual for the day and worked with the offshore team to deliver them as planned.
  • Experience in working with integrated planning, consolidation and forecasting models with in BW/BPC and APO for SCM which includes MH and P2P.
  • Expertise in enabling delta data loading for S4 CDS Views by utilizing different annotations in S4.
  • Created Power BI reports using HANA CDS Vies, Calculation Views and published as dashboards to Power BI work spaces.
  • Involved in SAP HANA Data provisioning between Master Data and SAP box using SAP SLT.
  • Created Calculation views to get master data, Calculation views (with cube or Star Join) to get fact data and utilized Star schema modeling.
  • Worked on performance tuning the HANA models using Explain plan and Visualize plan.
  • Expertise in new Data Source Enhancements using BADI functionality in place of Customer Exists for LO Cockpit Extractors.
  • Designed and Developed Executive Dashboards in BOBJ, Tableau and Power BI.
  • Expertise in performance tuning of BO, Tableau and Power BI Dashboard which
  • Involved as a mentor in Change Control Board, GSTDs, One Pagers and RCA Escalation.
  • Creation of PSRM Tickets and working with Microsoft on Power BI Dataflow refresh Issues
  • Maintenance of 2.0 Dashboard for the Confidential CEO, CFO, key business users and super users.
  • Conducted performance tuning of BO Webi reports, Tableau Dashboards such as long running report, run away reports and time out reports.
  • Promoted BO Universes across the environments using BIAR Files.
  • Developed BODS jobs for transforming and loading data into HANA from non-SAP systems.
  • Designed Dashboards in and published in SAC, Power BI, AFO Reports and Business Objects platform from scratch.
  • Extensively worked on Order, Deliveries, Billing and Purchasing related data in SAP by utilizing different SAP Standard extractors: Ex: Purchasing 2LIS 02 ITM, Inventory: 2LIS 03 SCL
  • Maintained Power BI Dashboards and provided business user support on SAC and Power BI.
  • Expertise in working with DAX Queries and Power BI Functions.
  • Worked on generic data source for pulling data SAP ECC and loading into BW on HANA system.
  • Creating information objects/Data models (packages, calculation views, Table functions, Stored Procedures).
  • Created Analytic Privileges based on filters required as per the users using the privileges like restriction based in country and region etc. using normal filter upon the data models.
  • Monitoring the replication process using SAP HANA studio and SAP LT replication server for transactional integrity.
  • Daily day to day business support/ticket queue monitoring/handling of user ticket/ Enhancements/ New Changes.
  • BO Report Monitoring, fixing failed BO Reports, Tableau Dashboards; scheduling critical Sales and Trade Reports including AFO and Power BI Dashboards for Key Business Users
  • Handling MEC, PEC, QEC and extensively involved in Year End Activities which are key to the Confidential USA BI Systems.

Confidential

SAP BI/BW Consultant

Responsibilities:

  • Daily ticket queue monitoring reviewing tickets, assigning the tickets to resources available.
  • Interacted with internal business users & stakeholders to implement BW reporting projects from initial scope definition through analysis, design, implementation and On-going support
  • Worked with BPC teams for month-end smooth closing activities and resolve the issues with high priority
  • Worked with Finance users and created new standard and custom reports using BoBJ and BEx Analyzer
  • Resolved issues during month end, BW support pack upgrades and raise OSS notes to SAP for complex system issues
  • Setting up KT sessions with Project team to share the information of newly build changes in the system
  • Attending ARC and Release calls with Release Management to team to have a smooth rollout of Quarterly Release
  • Analyzing and resolving the issues in EWA Report sent by SAP
  • Communicating about Planned or unplanned outages in systems in time to the business stack holders and user groups
  • Resolving issues in Regression Test process /ART/ICE & Non-ICE Reports before and after the System Refresh in Quality System
  • Validating the Pre and Post Images and dumps taken in Production and Quality system during the Release Window.
  • Developed objects documented clearly with all possible test cases with end user understandable manner.
  • Ensure developments are completed to time, quality and cost.
  • Support System and User Acceptance testing.
  • To ensure that the technical elements of the business processes supported by SAP are satisfied.
  • Gives direction to Programs that may impact SAP functionality, making recommendations to minimize impact.
  • Designed & Developed custom Data Source, Extractor, Info Cube and ODS to fulfill user requirements.
  • Worked on Business content Extractors, enhancing them and added program logic in User Exit to populate data.

Confidential

SAP BI/BW Consultant

Responsibilities:

  • Working with business team to understand business requirements and through consultation, provide advice on how best to utilize available information and how best to analyze information to provide insights.
  • Produce the technical specification from functional specification document.
  • Responsible for design Data models, Data extraction from R/3 and External systems, BEx, WEBI Reports, Dash Boards, data staging with External applications, business contents
  • Installations and automate the data staging using process chains and Load monitoring within the SAP implementation.
  • Developed objects documented clearly with all possible test cases with end user understandable manner.
  • Ensure developments are completed to time, quality and cost.
  • Support System and User Acceptance testing.
  • To ensure that the technical elements of the business processes supported by SAP are satisfied.
  • Gives direction to Programs that may impact SAP functionality, making recommendations to minimize impact.
  • Producing business process reviews and process flow documentation.
  • Responsible for the coordination of technical aspects related BW/BO development project team.
  • Part of a team having responsibility for delivering Development objects to the business community within the timeline.
  • Ensure Successful production of data modeling objects, BEx and Web Intelligence reports meeting customer specifications.

Hire Now