We provide IT Staff Augmentation Services!

Sap Bods Hana Consultant Resume

3.00 Rating

Atlanta, GA

SUMMARY

  • SAP certified BW HANA consultant with 4 full - life cycle implementations.
  • Strong experience in Upgrades, Implementation, Maintenance Support, and Configuration and Rollout of SAP projects experiences in fortune 500 companies.
  • A multi-faceted SAP Consultant over 12+ years of techno-functional expertise in SAP with specialization in SAP Net Weaver BI / BW and SAP BODS (DATA SERVICES) BO Tools such as Webi, Dashboard designer, Crystal Reports, Data Services, SAP CRM, SAP SRM and SAP R/3 platform.
  • Over 2 years experience as a BW HANA Consultant working on HANA studio along with multiple data provisioning - Data Services and SLT, DXC to extract data from SAP and NON SAP systems.
  • Over 4 years of experience BOBJ Reporting Webi 4.0 and Dashboards 4.0 - backed as Bex Report, Explorer, and crystal reports
  • Experienced working with both onshore and offshore environment.
  • Extensively worked in Implementation, Maintenance Production Support projects and have in-depth exposure in technical as well as functional areas like CRM, SRM and ECC includes SD, MM, PP, PM, QM and FI/CO and HR modules augmented by strong testing skills acquired from various project experiences.
  • Extensively worked on ECC Logistics data extraction for SD, MM Inventory, PP etc.
  • Extraction from (CRM, SRM, Logistics, SD, MM, FI, PP, HR and Generic): Source systems (SAP, Non SAP like SQL data using DB Connectivity, Web Services, and Flat File).
  • Extensively worked on BO data services designing data flows, BO reporting with Webi, Crystal reports, Explorer.
  • Extensively working on BW on HANA new developments creating HANA models, and Optimized BW modeling objects like Advance DSO, Composite Providers, Open Views etc. Rectifying the alerts on HANA studio.
  • Extensively worked on HANA models creating views and Data provisioning and user privileges.
  • Data Modeling (Business Content and Customized BW Objects): Expertise in Installing Business Content and worked extensively on developing complex data flow structures based on multiple source systems, with customizing Info Objects, Info Cubes, DSO layers as staging, DTP, Transformations, BIA Indexes, Complex routines in transformations, Open Hub Service, Process Chains, Info Sets and Multi providers, Virtual Providers, Hybrid Providers.
  • Strong experience in using ABAP methodology for BW Report in ECC and BW - Creating Programs, Creating Badi’s, Creating Function Modules, Debugging, User Exists, Customer Exists, End and Start and Expert Routines, DTP routines, Field routines, rule groups, Extracting from multiple tables and Creating Views on tables, maintaining logics in Include Program and Badi's environment required for BW Report Development.
  • Worked on Integration Planning BW-IP by developing Real-time (Virtual) Cubes, Planning Functions, and making available the Planning Data and developed the Planned Report.
  • Worked extensively withBEx Query Designer, BEx Analyzer and Web Applicationdesigner, Workbooks, Dashboardsfor creating custom and enhanced reports for business.
  • Worked extensively on Bex functionalities - Cell definitions, Exception aggregations, Offsets, Customer Exits, etc.
  • Developed Complex Reports in BEx, Web Application Designer and BO - ECC Reports - TOP 25 Ranking Reports, Monthly Snapshot Reports, Customer Aging Report, Vendor Open Items Report, PO History Report, SD Billing Report, Production Orders Confirmation Report.
  • CRM Reports - Lead Analysis Report, Milestones Report, Opportunities Report etc. for business users.
  • Extensively worked on Business Objects - Web Intelligence 4.0 version generated different types of reports using all the features- sub queries, merge dimensions, combining multiple queries, drilldown, ranking, hyperlinks etc.
  • Extensive worked on SAP Business Objects Dashboards 4.0 (XCelsius Reporting).
  • Upgrade experience includes - Upgrading SAP BW 7.0 Ver to 7.3 Ver systems, Deploying to HANA based system, HANA optimized BI Content (SAP BW on HANA).
  • Worked on Upgrade of SAP BW 7.0 Ver system to SAP BW 7.3 Ver, ECC 4.6 Ver to ECC 6.0
  • Production Support Activities includes extensively worked on Scheduling and Monitoring of process chains, Expert in resolving production Support issues and data load issues and analyzing the issues related to load failures. Analyzed and corrected production problems as they occur in the SAP BW System.
  • Extensively worked on Performance tuning at 3 levels in SAP BW - Database level resolving table space issues, Modeling level -data loads performance optimization and Frontend Report level - Query optimization.
  • Data Testing includes Testing of BW and R3 Objects, dataflow at all levels, by using various testing methods Unit Testing, Integration Testing.
  • Maintaining Cutover Steps post and pre transportation of SAP objects used for development and enhancements.
  • Transports include Transportation of BI/BW and R/3 Objects, Collected objects in Development System and transported throughout the System landscape using Revtrac.

TECHNICAL SKILLS

SAP BW Versions: 7.4/7.3/7.0/3.5/3.0/2.1 C. SAP HANA - 1.0/ S4 HANA

SAP R/3 Versions: ECC 6.0, 4.6; SAP CRM Versions 6.0; SAP SRM Versions 6.0.

SAP Business Objects: DATA SERVICES 4.2, Web Intelligence 4.0, Dashboards 4.0/ Xcelsius, Crystal Reports

BW reporting: BEX Analyzer (3.x, 7.0, 7.3), Query Designer (3.x, 7.0,7.3), WAD (3.x and 7.0) and SAP Portal.

ERP Packages: SAP SD, MM, PP, QM, PM FI/CO, HR and CRM and SRM modules

Operating Systems: Windows 7.0/Vista/XP, UNIX. Databases Oracle 9.i/8.i.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

SAP BODS HANA Consultant

Responsibilities:

  • Worked with business process owners, stakeholders to understand and document the requirements. Interacted with the manager to understand the business requirements and implemented the business rules to redesign and enhance the existing dataflows.
  • Managed the central and local repositories using the Management console and Repository Manager.
  • Position responsible for monitoring and performance tuning jobs.
  • SAP HANA Data provisioning using SAP Landscape Transformation and SAP Dataservices, DXC, Flat File Uploader, SAPHANA Architecture. Extensively used ETL to load data from central Data Warehouse into Data Marts.
  • Worked on customizing Info Objects, Info Cubes, DSO layers as staging, DTP, Transformations, BIA Indexes, Complex routines in transformations, Open Hub Service, Process Chains, Info Sets and Multi providers, Virtual Providers, Advance DSO's, Composite Providers, Bex Reporting.
  • Developed queries using BEx analyzer. Create variables, calculated and restricted key figures, filters and conditions in BEx query designer.
  • Configured and managed Repositories using administrator console as per business requirements.
  • Used various Transforms like Map Operation, Table Comparisons, Row-Generation, Query transform, History Generation, Key Generation, Pivot, Reverse Pivot and functions like lookup, pivot, case etc. for transforming data.
  • Configured the mappings to handle the updates to preserve the existing records using History Preserve Transformation (Slowly Changing Dimensions Type-2)
  • Developing and modifying changes in data flows according to the business logic.
  • Executed Data Extraction Transfer Loading (ETL) using SAP Data Services 4.0 to import csv files into SAP HANA tables to reflect exchange live rates application
  • Involved in SAP HANA Security including User Management, Roles, and Privileges
  • Reporting, Accessing Analytical and Calculation views from EXCEL
  • Involved in Information Design Tool Creation of Data Foundation, Universe for HANA reporting.

Confidential, Wichita, Kansas

SAP BW HANA BOBJ Consultant / Lead

Responsibilities:

  • Understanding the functional and business requirements by participating in User discussions.
  • Preparing project specific technical specifications, DTP design documents, unit test documents and estimation of efforts required for new change requests.
  • Extensively involved in end to end development from CRM area to BW system.
  • Worked on new developments on BW on HANA system creating HANA views calculation view, analytical view and reports.
  • Rectifying the alerts or issues on HANA system.
  • Extensively worked on logistics extraction of SD, Inventory, MM, PP, HR other modules
  • Worked extensively on creating Badi’s, User exits, Function Modules for customized ECC and CRM Data sources, transformation routines, end routines, start routines, DTP routines, Field routines customer exits..
  • Worked intensively on upgrading SAP Systems - ECC 4.6 Ver to ECC 6.0 and SAP BW 7.0 Ver to SAP BW 7.3 Ver which includes managing ECC system delta loads cleaning and re setup.
  • Extracted the third-party data (SQL data) through DB connectivity and flat file data to BW system.
  • Developed webi reports and Bex Reports for business use.
  • Developed process chains as per the requirement and maintained auto-scheduling of process chains which includes - ECC background jobs as well as ECC events auto trigger.
  • Collecting the Objects in transport requests for which changes made in ECC, CRM and BW and importing them across landscapes (from development to QA and Prod accordingly).
  • Handling the Level 3 support issues within agreed SLA’s which include analyzing (RCA) and resolving any data load failures, break fixes in production, performance issues, and support issues

Environment: SAP BW 7.4/7.3/7.0, ECC 6.0/4.6, HANA 1.0 CRM 6.0, BO Webi 4.0, BEX, MM, PP, SD, Oracle, Windows XP/7/Vista, UNIX

Confidential, San Jose, CA

SAP BW/BOBJ ABAP Consultant / Lead

Responsibilities:

  • Understanding the functional and business requirements by participating in User/onsite team discussions.
  • Preparing technical specifications, design documents, unit test documents and estimation of efforts required for new change requests.
  • Worked extensively User exits, Function Modules for ECC Data sources, transformation routines, end routines, start routines, DTP routines, and Field routines customer exits.
  • Worked on Integration Planning Area by creating the Planned Real time Info Cubes, Planning functions and Aggregation Levels
  • Creating and monitoring process chains and Meta chains with the message handling
  • Developed reports extensively in SAP BO Dashboards Xcelsius Reporting tool.
  • Designed various Charts and exported dashboards to outlook, PPT, etc.
  • Extracted Standard Data sources and Customized Data sources from SRM system to BW by enhancing as required.
  • Automated the Bex Reports for user easy access as per region.
  • Worked intensively on end-end developments form SRM to BI which includes extracting the fields from multiple data sources from areas like Invoice and Shopping carts.
  • Maintained customer exit code to maintain the period of data dynamically.
  • Developed queries using BEx analyzer. Create variables, calculated and restricted key figures, filters and conditions in BEx query designer.
  • Automated the error handling which triggers the email to the intended recipients in case of the erroneous records.
  • Creating and monitoring process chains and Meta chains with the message handling.
  • Handling the Level 3 support issues within agreed SLA’s.
  • Making necessary modifications in SRM reports and data load issues as part of the support issues.
  • Collecting the necessary changes and objects into transport and moving across landscape.

Environment: SAP BW 7.0, ECC 4.6, SRM, BO Dashboards 4.0, BEX, Query Analyzer, Net weaver Portal, Web Application Designer, Oracle, Windows XP/7/Vista, UNIX.

Confidential, San Francisco, California

Sr. SAP BW ABAP Consultant

Responsibilities:

  • Requirement analysis, preparing project specific documents like Technical Specifications, Development Doc
  • Modifying the existing data flow for better performance by identifying and deleting the obsolete Objects
  • Worked extensively User exits, Function Modules for ECC Data sources, transformation routines, end routines, start routines, DTP routines, and Field routines customer exits.
  • Worked extensively on LO data extraction for SD MM areas - deletion and re-initialization of setup tables.
  • Worked on Integration Planning Area by creating the Planned Real time Info Cubes, Planning functions and Aggregation Levels
  • Extensive worked on developing the Dashboards through Web Application Designer and published the same in Enterprise Portal by iview’s, Web Application Designer for end users.
  • Developed Charts by using web items in Web Designer and published accordingly.
  • Developed the Reports using the planned data.
  • Extensively worked on performance tuning of data load and reporting levels.
  • Maintaining carrying out the Cut-Over Activities.
  • Daily Monitoring of Master Data and Transaction Data of P2P, OTC and FIN Process Chains.
  • Created Process Chains as required - Monitoring daily, weekly and monthly loads - SCM Chains, Outside Spend loads Chain
  • Actively participated in Ticket Handling

Environment: SAP BW, ECC 4.6, SD, MM, SCM, APO, WAD Dashboards, Enterprise Portal, Oracle, Windows XP/7/Vista, UNIX.

We'd love your feedback!