We provide IT Staff Augmentation Services!

Sr. Sap Bw/hana Consultant Resume

Minneapolis, MN

PROFESSIONAL SUMMARY:

  • Over 12+years of strong experience in implementing Enterprise Scale Reporting SolutionsusingSAP BW / BO/Hana. Architect Design, Develop, and Implement SAP BW Hana systems and processes to capture, integrate and distribute information in enterprise business intelligence. Leverage subject matter knowledge in SAP BW with SAP HANA to lend additional credibility to their project teams and add value to their projects. Identify business requirements, requirements management, functional design, prototyping, process design (including scenario design, flow mapping), testing, training, defining support procedures and supporting implementations. Architect, design and develop an enterprise business intelligence and data warehousing solution.
  • Certified in SAP Business Warehouse powered by SAP HANA in Open SAP Online Course
  • Experience in SAP HANA data modeling using Attribute View, Analytic View and Calculation View.
  • Experience in Near Line Storage (NLS) using Sybase IQ to archive data from BW Hana.
  • Experience in SLT & RDA processes for Real Time Reports.
  • Worked extensively on the BI tools, Business Objects, Crystal Reports, Design Studio, Power BI, Analysis for OLAP, BO Explorer for Info Spaces, Bex Query / Analyzer and HANA reporting.
  • Comprehensive functional knowledge inSales & Distribution(Sales Orders, Deliveries, Billing),MM(Purchasing& Inventory Management),PP, QM, SRM,FI/CO(GL, AR, AP, CCA, PCA and COPA) and General business process of SAP ECC.
  • Experience in migration activities for BW 7.3 on Hana migration.
  • Involved in planning, design, development, implementation and production deployment of reporting solutions using SAP BOBJ reporting tool for various business process like Sales and Finance.
  • Expertise in using Universe Designer(UDT)/Information Designer(IDT) Tool using BICS (Business Intelligence Consumer Services)over BEx queries and Info Cubes to migrate & model data from BI to BO for reporting. Excellent skills to develop reports using SAP Webi/Crystal Reports live Office.
  • Extensively worked on BO performance over Bex by implementing Query Stripping, removing unused hierarchies in BEx, Suppressing unused hierarchiesin BW.
  • Worked as an onsite AMS reporting lead for BOBJ reporting and coordinated with Offshore BOBJ BI teams.
  • Extensively worked on Designing and maintenance of data targets like the Info Objects, DSO Objects, Info Cubes, Info Sets, open hub, APD and Multi Providers, SAP HANA - optimized DSOs,SAP HANA-optimized Cubes, Composite Providers,SemanticPartitioned Objects(SPO), 7x Migration Tool, AnalyticalIndexas per the SAP Best practices.
  • Experienced in activatingstandard Business Content, extendingandenhancingusing User Exits according to the end-user requirements
  • Involved in Post-Production support that includes monitoring ofprocess chainsand data loads, reconstruction of data targets in case of failed loads, rescheduling ofprocess chains, debugging of transformations.
  • Expertise in creatingBex Queriesusingstructures, variables, calculated key figures, restricted key figures, cell restrictionsandRRI Jump Queries and modifying standard templatesandcreating custom templatesUsing Web Application Designer.
  • Expertise in writing ABAP code instart / end routineand routines in transformations, CMOD code for Bex Variables, Custom Extractors.
  • Experiencetraining end usersin Bex reports, workbooks.
  • Experience in working individually, onsite - offshore model, multi delivery location (global delivery) model and multi-vendor environment.
  • Worked on BODS Data migration to Migrate data from Non-SAP and ECC systems to SAP BW.

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

Sr. SAP BW/Hana Consultant

Responsibilities:

  • Worked in Catalyst Rel. 1,2 US implementation
  • Involved in a detailedgap analysisbetween the SAP Standard Business Content and Reporting Requirements.
  • Worked on Lag analysis concept where we have we different fiscal variants (USA Vs other countries) to update corresponding Fiscal period.
  • Worked on GPC reports design where we have used the concept converting Data Model to KF Model to improve the query performance.
  • Worked in Hana Studio for creation of advanced DSO’s & Composite Providers.
  • Involved in Analysis Authorization objects for users data security authorizations.
  • Designed and developed on ABC/XYZ analysis report by Product & Product location level, on Open PGI, Pipeline Sales reports, OBD (Outbound) & IBD (Inbound) reports.
  • Worked on Supply Chain Reports like Monthly Inventory Snapshots, Demand Planning reports, Inventory Projection, Products Past Shelf life & Demand Vs Supply reports.
  • Worked on SOE (Statement of Expenses) reports distribution to respective users through broadcasting (using Email Bursting) using Cost Center Authorizations.
  • Expertise in writing ABAP code instart / end /expert routineand routines in transformations, CMOD/BADI code for Bex Variables, Custom Extractors.
  • Handling Lookups in transformations using ABAP Coding.
  • Worked on UC4 job scheduling tool for Process chains schedules.

Environment: SAP BI 7.4/7.5, BW on HANA, SAP ECC 6.0, HANA 2.3.29

Confidential, Minneapolis, MN

Sr. SAP BI/BO/Hana Consultant

Responsibilities:

  • Managed Onsite and Offshore Teams and acted as SPOC for all communication
  • Involved in Year end and Period end activities.
  • Experience in maintenance of Authorization objects for roles in reporting.
  • Actively Involved in Providing the Solution for recurring failures in Production to keep system healthy.
  • Actively involved in monitoring the Production System and close the service requests (SR) with in SLA deliveries in ticketing tool Global Resolution System (GRS) & Service Now (SN).
  • Worked on extremely complex landscape where there is separate path for Break-fix and Development.
  • Experience in Data flow with multiple systems like Sending the data from APO (Supply Chain) to BW then to Smart Ops once respective optimization completes sending the resulted data back to BW and then to APO BW.
  • Worked in architecture team to design the new requirement and redesign the existing flows.
  • Worked as onsite coordinator for all communications.
  • Experience in Converting functional requirements to technical design documents.
  • Extensively involved in gathering thereporting requirementsfrom the business users by meetings.
  • Involved in a detailedgap analysisbetween the SAP Standard Business Content and Reporting Requirements.
  • Extensively worked onwriting test scriptsand on theUnitandIntegration testingof the reports.
  • Worked on different areas SD, MM, QM, PP, Inventory and APO (Supply Chain).
  • Worked on all the backend objects like Info objects, DSO, Info cube, Info set, Multi providers
  • Extensively worked on BWA/BIA, Aggregates, Partitioning of info cubes, and secondary indexes on DSOs.
  • Extensively worked on BEx Queries, CKFs, RKFs, Cell definitions, Workbooks, WAD.
  • Extensively worked on thestart / end routinesand theroutinesin the transformations using ABAP Coding.
  • Created generic extractors usingfunction modulesand tables for reporting on the custom build contract application in ECC.
  • Worked on Inbound and Outbound Interfaces (Ex: Setting up of message types, Partner profiles for the respective configuration)
  • Worked on Composite Providers which has the feature of Union and Joining Functionality.
  • Worked on APO Pipeline reports.
  • Experience in migration activities for BW 7.3 on Hana migration, pre-migration i.e.,housekeepingactivities and post migration i.e., check consistency of tables by running program ex: RSDU TABLE CONSISTENCY, RS BW POST MIGRATION, transfer inconsistentInfo Objectsfrom SAP Business Content.
  • Checking DDIC (data dictionary) consistency by running the program RSUPGRCHECK.
  • Experience on Converting the Regular tables to Real Time tables through SLT(SAP Landscape Transformation) Process and converting the Standard Data Sources to Real Time Data Sources (RDA).
  • Worked on Daemons which will be used to push the data from ECC to BW Hana System at regular intervals.
  • Experience in Converting Hana Optimized confidencial’s to Standard confidencial’s for SLT Purpose by running the program RSDRI RECONVERT DATASTORE.
  • Generated BO universe on Bex queries and created SAP Webi reports.
  • Worked extensively with SAP Webi intelligence functions, formulas and variables.
  • Utilized SAP Webi Intelligence reporting tool to create graphical representation of reports such as bar charts, Pie charts as per requirement.
  • Used formatting options such as Cross tab representation, section breaks, data sort options, calculations, fonts, colors and conditional formatting in SAP Web Intelligence.
  • Generate reports withparameters, sub reports, cross tabs, chartsusing Crystal Reports
  • Scheduledthe BO report using Schedule Managerin CMC to run every day on a periodic basis
  • Responsible for creating theCrystal ReportsOn demand, Ad Hoc Reports, Frequency Reports, Summary Reports, Sub Reports, Drill-down, Dynamic grouping, Cross-Tab, graphical, aging reports
  • Created Dashboards for Freight Level A, B, C, D & E Def, Pref Dashboard Charts & tables in Design Studio.
  • Created multiple Analysis Application Using Bex Query as a data source in Design studio
  • Sales and Shipment (Freight) relevant information used for charts and tables in design studio.
  • In a Single dashboard we have shown the trends of the data year wise, month wise by using multiple analysis applications in design studio.
  • n Enterprise Hana to create Attribute Views, Analytical Views and the Calculation Views for the Complex logics (Graphical & SQL Script) in HANA Studio.
  • Designed and Developed Reporting on Hana Analytical Views and publish them in BW with Virtual Provider.
  • Migrated HANA content from development, testing environment to Production environment using Delivery Units.
  • Having Experience in HANA Objects creation using SQL Script for Calculated Views and having exposure in execution of Store Procedure in HANA.
  • Reconciled the data with the existing BW Reports with the new HANA Models.
  • Converting Data Store objects and Info Cubes into advanced Data Store objects.
  • Extensive Knowledge on LSA, LSA++, Composite providers, Transient Providers, Advanced DSO (ADSO) and Open ODS view using BW Modeling tools in HANA Studio.

Environment: SAP BI 3.X,7.X, BW on HANA, SAP ECC 6.0, SAP BO 4.X, HANA 1.0 SPS9, Design Studio

Confidential

Sr. SAP BI Consultant

Responsibilities:

  • Worked in architecture team to design the new requirement.
  • Involved in upgrade activities from SAP BW 3.5 to SAP BI 7.0
  • Involved in cutover plan preparation for all go-lives.
  • Worked extensively on performance tuning on existing process chains, set up the dependencies, master data and hierarchies.
  • Worked on different areas SD, MM, QM, and Inventory.
  • Worked on all the area of ABAP related to BI like extractors, Function modules, Views, Customer-exit variables, Expert routine, start routine and end routine
  • Worked on Sales performance reports.
  • Set standards, review check list for BW development and ABAP development related to BW.
  • Work on BEx Queries, user profiles and role assignment.
  • Experience in usingBODSas an external system for ETL between ECC and BI.
  • Created Jobs, Work Flows, Data Flows, and Scriptsusing variousTransforms (Integrator, Quality and Platform) to successfully load data from multiple sources into a desired target through BODS.
  • Used Open Hub Services to push data out of SAP BI using BODS
  • Worked on Developing jobs to extract data from SAP Extractors & Tables, SAP BW DSOs, load to BW PSA
  • Worked on creation of DS data stores to connect to data sources such as SAP R/3, SAP BW and Oracle
  • Worked on Data Profiling and Data Validation Scenarios

Environment: SAP BI 7.0, SAP BW 3.5, SAP BODS, SAP ECC, and SAP R/3 4.7.

Confidential

SAP BI Consultant

Responsibilities:

  • Worked extensively in all the backend objects like DSO, Info cubes, Info objects, multi providers
  • Involved in giving training on BI activities to core technical team
  • Worked extensively on extractors / Data sources.
  • Work on Bex Queries, RRIs, WAD, CKFs and RKFs, role assignments.
  • Exposed to full lifecycle right from BW configuration, modeling, analysis, design specification, development, performance tuning and maintenance.
  • Designed Technical documents based on business requirements in SD, MM, Financial Management.
  • Analyzed, Designed, developed, coded and implemented standard/ customized Info Cubes and DSO (ODS) Objects for MM, SD, FI-CO
  • Extensively worked on Generation of Data sources, activation of Info Sources, Transferring Master Data to Characteristics and Transaction data from ECC systems to Info Cubes in BI. Responsible for loading Plan/Actual Master data (Texts, Attributes and Hierarchies)/Transaction data from ECC Data Sources and from Flat Files.
  • Regarding Logistics Extraction Cockpit, Maintained extract structures for Sales & Distribution. Developed and enhanced data sources & activated the extract structures for the above modules. Designed data loads Schedule for Lo-cockpit Data Sources.
  • Involved in Preparing the Business Blueprint Documents.
  • Involved in Loading of Historical Data from Oracle 10g to SAP-BW through DB
  • Used the Business Content Sales Overview Infocube for overall Sales Analysis. The transaction data is loaded from different Source Systems using the Info Sources such as Sales Order, Delivery, Billing Document and Sales Order/Delivery using LO-Cock Pit.

Environment: SAP BI 7.0, SAP BW 3.5, SAP ECC, and SAP R/3 4.7.

Confidential

SAP BW Consultant

  • Worked on activation of BI Content and modified standard extractors related to SD and MM.
  • Extensively used BW standard Lo-cockpit business content extractors to extract data from SAP R/3 to BW and performed enhancements to accommodate business needs.
  • Designed and developed Info cubes, Info Sources and loaded data from SD module to BW. Worked on line item dimensions.
  • Used ABAP Routines in Update rules & Transfer Rules to update characteristics and Key Figures in the Info Cubes.
  • Created Info Packages and Info Package Groups to do Full, Initial, and Delta extraction for both Master and Transaction data.
  • Involved in Converting the key figure Data model into Account Data model in Budget and forecast part.
  • Created transport and communication structures, transfer rules, update rules for ODS and Info Cube.
  • Created custom CO-PA Cube, ODS, Data Mart to satisfy business requirements.
  • Developed designs dealing with currency conversions as per the user requirements.
  • Managed and monitored several data loads. Optimized load performance by adjusting the packet sizes.
  • Used BEx to create reports with exceptions, conditional formatting, restricted key figures and calculated key figures.
  • Worked extensively on BEx Analyzer and customized the reports creating variables, exceptions and conditions.

Environment: SAP BW 3.5, SAP R/3 4.7.

Confidential

SAP BW Consultant

Responsibilities:

  • Development of Technical specification documents for the developments assigned.
  • Object development and review of the development requests assigned.
  • Creation of unit test plans for the objects developed.
  • Interaction with onsite for clarifications of issue
  • Ensuring a high-quality solution for all the delivered objects to the client within the schedule.
  • Data Dictionary objects like Database tables, Structures, Data element.
  • Worked as a developer in BW-OTC (Order-To-Cash) team, mainly provides all backend work for Sales Reporting to the management
  • Performance tuning for the existing objects.
  • Extracted data from legacy system using flat file interface.

Environment: SAP BW 3.5, SAP R/3 4.7.

Hire Now