Tek02624

SAP - 9 yrs


MTech

Highlights

  • Having 9+yearsof experience which is on SAP BI/BW, BW on HANA, BW/4HANA,S4 CDS Modeling& Embedded Analytics, BPC optimized for S4 HANA, Embedded BPC and native HANA modeling.

  • Worked on creation of ADSOs, composite providers and complex reports in BW modeling tools in Eclipse for BW on HANA and BW4HANA.

  • Created Attribute, Analytical and Calculation views by slicing and dicing the database tables as per user requirement. Hands on experience on HANA modeling through HANA Studio, Eclipse and WEBIDE for HANA 2.0

  • SDI replication to get data from ECC or other database to HANA DB.

  • Worked on Volume, Revenue and COGS planning using standard and custom planning sequences using FOX in Embedded BPC.

  • Involved with ASAP methodology for implementation right from Project preparation, to Post-Live Production support.

  • Involved in designing Reports by understanding functional specifications and handled defects. Also gained hands-on experience in SAP ABAP.Expertise in data modeling, data extraction and data reporting.

  • Good knowledge of BW ABAP and worked on development of ABAP Routines.

  • Expertise in Business Content objects installation designed and developed custom objects as per the business requirement.

  • Good knowledge on Data warehouse concepts.

  • Worked on Order to Cash, Procure to Pay Production operations and Finance module in S/4 HANA CDS Modeling.

  • Wrotetechnical papers on SAP BI/BW, ABAP CDS & Streaming process chainwhich were approved and published in portal.

  • Received appreciations from Senior Managers and Managers for the technical paper on SAP BW.

  • Got an Applause award for my exceptional performance in this initiative.

  • Worked on preparation of RFP for a project as part of firm initiative activity.

  • Worked on SAP Analytic cloud (SAC) for designing analytic dashboards and also SAC for planning as a firm initiative.


Skills
Primary Skills
  • BW4HANA
  • Embedded Analytics

Secondary Skills
  • CDS
  • S4 HANA
Other Skills
  • Programming languages : C,C++, Basic SAP ABAP
  • Software / Products : SAP BI 7.0,BI7.3, HANA, BPC Optimized for S4& Embedded BPC
  • Tools : SAP, Design Studio, AO, TABLEAU, Power BI
  • Databases : SQL,PL/SQL
  • Operating Systems : WINDOWS
  • General Tools : MS-office
  • Strengths
  • Good communication &Interpersonal skills
  • Good leadership skills and Good Team Player
  • Great Zeal to learn and interest to research on new things, Always think innovatively.
  • Very hardworking& Flexible.
Projects

ASAP


    • Client : SPX Flow

    • Industry : Food & Energy

    • Role : S4 & BW4HANA Consultant

    • Duration : Dec 2020 to till date



    Key Responsibilities




    • Extensive expertise on developing Virtual Data Models in S4HANA, Table functions, Virtual Data Models in HANA, Gateway services and creating Fiori Analytical applications.

    • Using CDS Virtual Data Models, created an Analytical Delivery Compliance Report which helped Sales Team to analyze the reason for delay and any discrepancy caused in real-time. This report effectively improved customer service experience and reduced noise in the SAP system.

    •  Using Transient providers of CDS Views, created RRI reports to help Finance Team on EDI Monitoring along with IDOC failure rate and details on reason for failure.

    • Created aFiori Tile to help MM team specifically Buyers to find out the discrepancy between Vendor confirmation Quantity and actual Goods Received Quantity.

    •  Createdinformation Models using calculation views in SAP HANA for various customer requirements.

    • Expertise on S4HANA Optimized BPC. Have helped Business Users to access standard reports delivered by SAP which are based on HANA information Models.

    • Expertise on Custom Analytical Queries and have given various KT sessions to Key Users and SMEs on how to effectively create and use them.

    • Expertise on various Embedded Analytical applications such as KPI Modeling, Analytical List Pages, Analytical Path Framework and Multi Dimensional Reports.

    • Expertise on using Query Browser and View Browser.

    • Expertise on Data integration between S/4HANA and BW4HANA.

    • Created various CDS Views and consumed in different Analytical applications such as Power BI, SAC, SAP Business Objects.

    • Expertise on creating Fiori Catalogs, groups and ensuring security to users through defined roles.

    • Lift and shift of old BW 7.0 into BW4HANA. Building all modules flows in BW4HANA and creating respective reports.


Farmers reporting and planning


    • Client :  Farmers Insurance

    • Industry  : BW4HANA and BPC Consultant

    • Role : S4 &BW Consultant, Cutover Lead, BW and BPC  integration lead

    • Duration : April 2020 to Dec 2020



    Client Description:



    Farmers Insurance Group is an American insurer group of automobiles, homes and small businesses and also provides other insurance and financial services products.



    Key Responsibilities :




    • Involved in requirement gathering phase and conducted workshops with users to understand the reporting requirement and converted the requirements to functional specification documents

    • Conducted user sessions to help users test the reports built and get approval for UAT sign off and production GO.

    • Delivered S4 reports on ACDOCA by building CDS models. Created BEx queries on CDS cubes, created custom CDS hierarchy views where ever needed.

    • Used SDI replication to get S4 tables to B4HANA and used these tables in HANA models. This will give real time data into BW when there is a change in S4.

    • Created HANA Calculation views in WEBIDE as it is HANA 2.0 and worked on moved the models (MTAR file) across the landscape.

    • Created B4HANA objects, ADSOs, Composite providers on HANA models and ADSO combination, process chains and complex BEx reports.

    • Intensively worked on streaming process chain to get near real time data to B4HANA and configured real time daemon job in S4. Monitoring Operation delta queue to understand the delta and fix any issues.

    • Created complex AO formatted reports. Balance sheet, comparative income statement report. Reports based on complex structures and cell references.

    • Performance optimization of ADSO to better query runtimes, handling huge data volumes. Process chain optimization for faster load times.

    • Worked on consolidation from planning side to build BW flow to push year to date models. Wrote start routine in transformation file. Created logic script for copying data from one model to other model.

    • Worked on data manager packages to load master data, transactional and hierarchy loads to BPC models.

    • Data archiving is also achieved by creating DAP to push data to near line storage at SAP IQ. Worked on POC for DTO which is the feature of B4HANA.

    • Handled cutover activities:

      • Pre Cutover – Checking the system connections

      • Cutover – Moving transport in sequence, performance manual activities, data source activation

      • Post Cutover – validation of the objects, data flows, reports



    • Worked closely with security in creating roles for business users and enabled Analysis authorization based on company code, profit center as per the business functions and organization structure.


Gallo Wines BPC (Aspire)


    • Created Functional specification documents based on Business requirement document and by understanding the client requirement.

    • Worked on transferring Functional Requirement to Technical Spec.

    • Created input templates based on the mock ups provided for Volume, Revenue and COGS.

    • Created Planning sequences where ever required to meet the functional requirement to write back data. Planning sequences for currency conversion and planning sequences with complex FOX coding.

    • Automated monthly actualization process for copying forecast to monthly forecast category.

    • Performance optimized input templates.

    • Implemented dynamic locking of templates using data slices on category and time as per the month end closure and year end closures.


Hunter Douglas


    • Client : Hunter Douglas

    • Industry : S4 HANA Analytics

    • Role : Consultant

    • Duration : May 2017 to Oct 2018




    • Client : Hunter Douglas

    • Industry : S4 HANA Analytics

    • Role : Consultant

    • Duration : May 2017 to Oct 2018

    • Client Description : Hunter Douglas is a Dutch multinational corporation. Its principal business is making window blinds and coverings.

    • Key Responsibilities :

    • Created Functional specification documents based on Business requirement document and by understanding the client requirement.

    • Worked on transferring Functional Requirement to Technical Spec.

    • Carry out Functional Specs review with business and Development based on S/4 CDS Modeling.Working with the business team on various scenario’s and incorporating the same in the backend CDS model.

    • Creating Re-usable objects for SAP Processes which can be utilized across different requirements.

    • Created complex finance reports like Balance sheet, Income Statement, Profitability Analysis and Procure to pay. Worked on complex exception aggregation scenarios.

    • Creating Analysis for Office Workbook with Custom branding and utilizing the CDS models.

    • Troubleshooting and Analyzing errors which occur after upgrade in already created models.

    • Developed data models, data flow diagrams, functional design and technical design documents.

    • Designing the security around CDS and carrying out proof of concepts to better understand how it works for CDS models.

    • Performance optimization for CDS views


DHL Ishell Phase 2

    Client :   DHL



    Industry   :   CRM



    Role : Business Technology Analyst



    Duration : Nov 2016 to tillMay 2017



    Client Description  :



    Deutsche Post AG, operating under the trade name Deutsche Post DHL Group, is a German courier company and the world's largest. With its headquarters in Bonn, the corporation has 467,088 employees (FTE 421,270) in more than 220 countries and territories worldwide and generated revenue of €56.63 billion in 2010. Deutsche Post is the successor to the German mail authority Deutsche Bundespost , which was privatized in 1995.




    • Key Responsibilities : 

    • Created Functional specification documents based on Business requirement document and by understanding the client requirement.

    • Worked on transferring Functional Requirement to Technical Spec.

    • Enhanced standard CRM datasources, also created generic datasources based on BADI.

    • Developed data models, data flow diagrams, functional design and technical design documents.

    • Start, End and field level routines wherever required to meet the client requirement.

    • Identify data discrepancies and data quality issues, and work to ensure data consistency and integrity.

    • Worked on BADI to restrict F4 help values on Query selection screen and wrote User Exits for dynamic population of variables

    • Worked on Analysis authorization to provide restricted access to uses based on user provided norms.

    • Designed interactive Dashboards in Design Studio.

    • Used virtual characteristics and key figures based on BADI at report level where backend development didn't suffice the requirement

    • Worked on customer exits for dynamic population of date based on user input selection.

    • Broadcasted Workbooks to users through email and automated the process.

    • Documented all the created/ changed objects.

    • Validated object before and after Transport.

    • Technical Environment : SAP BI 7.4, Design Studio, CRM


SMUD

    Client : SMUD



    Industry :   Utilities



    Role : Business Technology Analyst



    Duration : Apr 2016 to Nov 2016



    Client Description :



    The Sacramento Municipal Utility District (SMUD) provides electricity to Sacramento County, California, and a small portion of adjacent Placer County. It is one of the ten largest publicly owned utilities in the United States, generating the bulk of its power through natural gas (estimated 56% of production total in 2009) and large hydroelectric generation plants (22% in 2009), and SMUD's green power (renewable) energy output was estimated as 19% in 2009.



    Key Responsibilities :




    • Worked on transferring Functional Requirement to Technical Spec.

    • Created custom Data Source on ‘Z’ table.

    • Developed data models, data flow diagrams, functional design and technical design documents.

    • Created Expert routines wherever required to meet the client requirement.

    • Identify data discrepancies and data quality issues, and work to ensure data consistency and integrity.

    • Worked on BADI to restrict F4 help values on Query selection screen

    • Created Analysis Office Report on Queries and designed Dashboards in Design Studio.

    • Enhanced Objects based on requirement.

    • Documented all the created/ changed objects.

    • Validated object before and after Transport.

    • Technical Environment:SAP BI 7.4, Design Studio, Analysis Office


Awards
  • Harvard Leadership Essentials
  • Infosys certified in SAP BW.

Similar Talent

Key Skills - Self Rating
  • ABAP
  • ABAP

View

Key Skills - Self Rating

View

Key Skills - Self Rating

View

Key Skills - Self Rating
  • SD
  • SD

View

Key Skills - Self Rating
  • SAP
  • Configuration of SAP PLM
  • Employee Central
  • Recipe Development
  • SAP ABAP

View