We provide IT Staff Augmentation Services!

Project Lead Resume

PROFESSIONAL SUMMARY:

  • Having 10+years in SAP consulting with wide experience in teh field of SAP HANA LIVE, HANA, S4 HANA,HCI,HCP,BW Powered by HANA,BO,BODS, BW/BI 3X and 7X.
  • Played key role in Practice building, business development and solution consulting for various consulting firms.
  • Especially in SAP BW/BOBJ with subject matter expertise in Business Intelligence domain integrating to SAP HANA.
  • Solution Architect with progressive experience in Design/Development and Consulting in SAP specializing in SAP HANA 1.0 SP05, P06, SP07, SP08,SP09,SP10,SP11 SAP Net Weaver Business Warehouse & Business Objects Reporting Tools.
  • Ability to Re - architect teh current BI solution with SAP HANA as Database, BW as EDW layer & BO BI as Analytics solution.
  • Propose unique strategy on adopting HANA, more specific to customer Business case.
  • Having expertise in delivering HANA projects like BW on HANA Implementations.
  • Extensively involved in Implementation, and Maintenance Support Projects.
  • Expertise in Creating Analytical View, Attribute View, Calculation View, Analytical privileges, SLT, BODS integration with HANA.
  • Extensively Involved in BI 7.4 Hybrid Provider, DSO partition, Data flow Hierarchy loading, Composite Providers, Transient Provider, Analytical Index, Transformations, Data Transfer Process, Data Store Object,, Web Application Design, Process Chains, Open Hub Destination, Start routine, End routine, Field routine, Pseudo delta, BI Content, Visual Composer, Integrated Planning, 7X Bex reporting
  • Extensively involved in BW 3.5 ODS, Info cube, Transfer rules, Update rules, 3X Bex Reporting, Multi providers.
  • Extensively involved in SAP BO Universe creation, Information Designer Tool, Web Rich Client, Dash Board Designer, and Crystal Reports.
  • Excellent Communication and Interpersonal skills with teh ability to interact with end users, managers and technical personnel.
  • Expertise on SAP HANA Analytical View, Attribute View, Calculation View, Analytical privileges, Composite Providers, Transient Provider, Analytical Index using BW eclipse in HANA studio as well as BW environment.
  • Expertise on HANA live content copying to customized packages.
  • Expertise on consuming HANA live models
  • Expertise on combining custom tables and HANA standard view.
  • Expertise on creating a Calculation View using Join, Union and Aggregation.
  • Expertise on creating a Calculation View on Attribute view and Analytical view.
  • Expertise on SQL Scripting CE functions.
  • Expertise on inner, left outer, right outer, full outer, text join, referential join.
  • Expertise on ECC report pulling from SAP HANA data base using RDS.
  • Expertise on extracting data from ECC COPA data to SAP HANA using SLT.
  • Expertise on extracting data from Hyperion to SAP HANA using BODS.
  • Extensively involved in creating BO Reports on SAP HANA.
  • Extensively working on CDS views, AMDP procedures.
  • Having knowledge on Master data, Transaction data CDS views on S/4 HANA.
  • Extensively working on ABAP program with AMDP procedures.
  • Having Knowledge on SAP HANA Roles for end users and Developer and administrator prospective.
  • Having knowledge on SAP HANA User Management
  • Having Knowledge on SAP HANA Architecture.
  • Extensively worked on SAP BO Information Designer, Universe Designer, Web Intelligence Rich Client, Dash Board Designer, Crystal Reports, QAAWS, and Live Office.
  • Extensively worked on SAP BO Information Designer with SAP and Non SAP Sources.
  • Extensively involved in creating of Relation and OLAP connections, Data foundation and Business Layer.
  • Extensively worked on Prompts, Filters, Functions, Merging, Sub Reports, Variables, Ranking, Tracking in Web Rich Client.
  • Extensively involved in creating Static and Dynamic Dash Boards.
  • Extensively involved in creating Dynamic Dash Board using Query Browser.
  • Extensively involved in creating WEB I reports on BEX reports.
  • Extensively involved in creating Parameters in Crystal reports.
  • Extensively involved in SAP Design Studio
  • Extensively involved in SAP Lumira
  • Involved in creating and maintaining Data sources, Info-Objects, Transformations, Info cubes, Data Store Objects, Data Transfer process, Multiproviders, Virtual Providers, Info sets, Aggregates.
  • Extensively involved in Advance DSO, Open ODS views.
  • Experienced in importing SAP BW Models in SAP HANA.
  • Converting teh standard DSO into HANA Optimized DSO, Standard Info Cube into HANA optimized Info cube.
  • Provisioning and replicating data from source system to HANA Database using SLT and Business Objects Data Services.
  • Ability to monitor teh replication process using SAP HANA studio and SAP LT replication server for transactional integrity.
  • Work experience in importing Meta data, Table definitions, Performing initial load and Replication, Resuming and Suspending.
  • Installed teh Business Content Info objects, Info cubes, Info sources as per teh requirements.
  • Uploading Master and Transactional data from Flat file and SAP R/3 as teh Source Systems.
  • Handled errors in Error Stack and then scheduled to Data Targets by using Error DTP.
  • Expertise in Data Loading (Full, Initial, Delta Upload), Scheduling, Monitoring.
  • Performance tuning of queries using aggregates, partitioning, indexing of Info Cubes.
  • Extensively used BEx Analyzer, created queries with Variables, Filters, condition, Formulae, Restricted Key figures, Calculated Key figures, Used RRI feature to jump between teh queries, WAD to analyze teh data.
  • Expertise in Process Chains for Master data loads and Transaction loads with teh help of info packages and these process chains are scheduled for periodic loads.
  • Extensively involved in HPQC Testing.
  • Extensively involved in Integrated planning, creating Aggregation levels, Planning Filters, Planning Functions, and Planning Sequence.
  • Extensively involved in Visual composer to create Dash boards using WAD URL and BEX queries.
  • Having knowledge on functional knowledge on PM, HR, MM, FICO, SD.
  • Extensively involved in Start routine, End routine, Field routine and DSO lookup.
  • Extensively involved in BADI for Enhancing Existing Extractors.
  • Extensively involved in Creation of BADI using Class and Method for populating data for Customer Exit.
  • Extensively involved in BW object for Transfer rules, Update rules, Info cubes, Operational data store object, Multi providers, Info sets
  • Extensively involved in Migrating Data Sources, Queries from Business Information Warehouse to Business Intelligence.
  • Having knowledge on BW 7.3 Hybrid Provider, Hierarchy loading,

TECHNICAL SKILLS

  • Data Extraction can be done by using SAPBODS4.0 and configuration different DATASTORES for SAPECC, SQLSERVER, O4 Data base.
  • Teh Approach for designing teh jobs are Construction Job, Load Job, Post Load Job.
  • In construction Job we are pulling teh Construction sheet from SQLSERVER and used as source and teh fields are validated by using Validation Rules in SAPBODS by using teh VALIDATION TRANSFROM, SQLTRANSFROM, TABLECOMPERSATION, MERGETRANSFROM, Pivot, Reverse Pivot, Hierarchy and QUERY TRANSFROM.
  • In Validation transform we are checking teh table is exist in SAP on MARA for Sap Material Master, MARM unit of measure/ Materials,KNA1 for Customer Master,T006 for UOM details, MARC Plant Extention,T001W Plant Master.
  • After Designing teh Construction Job we are populating teh Template tables i.e. Valid construction and Invalid construction
  • For populating teh post load, Preload reports for BU to Validate teh Data.

PROFESSIONAL EXPERIENCE

Confidential

Project Lead

Responsibilities:

  • Primary responsibility of supporting for SAP HANA Objects as per client requirements.
  • Involved in Smoke Testing.
  • Involved in Pricing Model & Team sizing.
  • Providing daily status to onshore Team.
  • Expertise on creating Store Procedure to reconcile teh PDA Vs VDA data.
  • Well verse with SAP HANA Performance Optimization, Modeling using Different types of views, SQL, SQL Script.
  • Expertise on SAP HANA Analytical View, Attribute View, Calculation View, Analytical privileges. Well verse with SAP HANA Performance Optimization, Modeling using Different types of views, SQL, SQL Script.
  • Expertise on SAP HANA Analytical View, Attribute View, Calculation View, Analytical privileges.
  • Expertise on HANA Scripted Calculation Views using CE functions.
  • Worked on Store procedure to reconcile PDA Vs VDA data. Expertise on creating a Calculation View using Join, Union and Aggregation.
  • Expertise on creating a Calculation View on Attribute view and Analytical view.
  • Expertise on SQL Scripting CE functions.
  • Expertise on inner, left outer, right outer, full outer, text join, referential join.
  • Expertise on ECC report pulling from SAP HANA data base using RDS.
  • Expertise in Smart data Access, Smart Data Integrator, Smart Data Quality.
  • Having knowledge in Data Streaming.
  • Expertise on creating HDB and CDS (hdbdd) tables.
  • Having knowledge on XS OData services.
  • Expertise in migration of HDB tables into CDS tables.
  • Extensively involved in creating of Relation and OLAP connections, Data foundation and Business Layer.
  • Extensively worked on Prompts, Filters, Functions, Merging, Sub Reports, Variables, Ranking, Tracking in Web Rich Client.
  • Extensively involved in creating Static and Dynamic Dash Boards.
  • Extensively involved in creating Dynamic Dash Board using QAAS and Live Office.
  • Extensively involved in creating WEB I reports on HANA.
  • Extensively involved in SAP Design Studio
  • Extensively involved in SAP Lumira

HANA Implementation

Confidential

Responsibilities:

  • Primary responsibility of supporting for SAP HANA Live, BO, BODS, BI 7.4
  • Expertise to Create Composite Providers using HANA models and BW Cubes and DSO with Union and Join operator in HANA Studio with BW eclipse or BW work bench.
  • Expertise on Transient Provider in BW workbench and combine dis Transient providers in Composite provider.
  • Expertise on Virtual Providers with HANA Models in BW workbench
  • Expertise on HANA live content copying to customized packages.
  • Expertise on consuming HANA live models
  • Expertise on combining custom tables and HANA standard view.
  • Copying Sales Document, Billing Line item Query, VDM from HANA LIVE content
  • Transporting objects using HANA Life Cycle Management.
  • Worked on HANA Live browser to check Content, Definition, Cross reference, generate CSV file of required tables.
  • Well verse with SAP HANA Performance Optimization, Modeling using Different types of views, SQL, SQL Script.
  • Expertise on SAP HANA Analytical View, Attribute View, Calculation View, Analytical privileges.
  • Expertise on ECC report pulling from SAP HANA data base using RDS.
  • Expertise on extracting data from ECC COPA data to replication servers.
  • Expertise on transferring data from Replication servers to SAP HANA using SLT.
  • Expertise on extracting data from Non SAP to SAP HANA using BODS.

Confidential

Responsibilities:

  • Primary responsibility of supporting for SAP HANA Live, BO, BODS, BI 7.4
  • Expertise to Create Composite Providers using HANA models and BW Cubes and DSO with Union and Join operator in HANA Studio with BW eclipse or BW work bench.
  • Expertise on Transient Provider in BW workbench and combine dis Transient providers in Composite provider.
  • Expertise on Virtual Providers with HANA Models in BW workbench
  • Expertise on HANA live content copying to customized packages.
  • Expertise on consuming HANA live models
  • Expertise on combining custom tables and HANA standard view.
  • Copying Sales Document, Billing Line item Query, VDM from HANA LIVE content
  • Transporting objects using HANA Life Cycle Management.
  • Worked on HANA Live browser to check Content, Definition, Cross reference, generate CSV file of required tables.
  • Well verse with SAP HANA Performance Optimization, Modeling using Different types of views, SQL, SQL Script.
  • Expertise on SAP HANA Analytical View, Attribute View, Calculation View, Analytical privileges.
  • Expertise on ECC report pulling from SAP HANA data base using RDS.
  • Expertise on extracting data from ECC COPA data to replication servers.
  • Expertise on transferring data from Replication servers to SAP HANA using SLT.
  • Expertise on extracting data from Non SAP to SAP HANA using BODS. In construction Job we are pulling teh Construction sheet from SQLSERVER and used as source and teh fields are validated by using Validation Rules in SAPBODS by using teh VALIDATION TRANSFROM, SQLTRANSFROM, TABLECOMPERSATION, MERGE TRANSFROM, Pivot, Reverse Pivot, Hierarchy and QUERY TRANSFROM.
  • In Validation transform we are checking teh table is exist in SAP on MARA for Sap Material Master, MARM unit of measure/ Materials,KNA1 for Customer Master,T006 for UOM details, MARC Plant Extention,T001W Plant Master.

Confidential

Confidential

Responsibilities:

  • Primary responsibility of supporting for SAP HANA, BO,BODS and BW
  • Expertise on SAP HANA Analytical View, Attribute View, Calculation View, Analytical privileges.
  • Expertise on ECC report pulling from SAP HANA data base using RDS.
  • Expertise on extracting data from ECC COPA data to replication servers.
  • Expertise on transferring data from Replication servers to SAP HANA using SLT.
  • Expertise on extracting data from Hyperion to SAP HANA using BODS.
  • Extensively involved in creating BO Reports on SAP HANA.
  • Extensively worked on SAP BO Information Designer, Universe Designer, Web Intelligence Rich Client, Dash Board Designer, Crystal Reports, QAAWS, and Live Office.
  • Extensively worked on SAP BO Information Designer with SAP and Non SAP Sources.
  • Extensively involved in creating of Relation and OLAP connections, Data foundation and Business Layer.
  • Extensively worked on Prompts, Filters, Functions, Merging, Sub Reports, Variables, Ranking, Tracking in Web Rich Client.
  • Extensively involved in creating Static and Dynamic Dash Boards.
  • Extensively involved in creating Dynamic Dash Board using QAAS and Live Office.
  • Extensively involved in creating WEB I reports on BEX reports.
  • Extensively involved in creating Parameters in Crystal reports.
  • Creation of Process Chains for teh entire Daily / Weekly Loads as and when required.
  • Cross Verifying teh Daily data load as per teh checklist for ensuring teh proper data upload in BW.
  • Checking teh daily time schedule for teh run & ensuring dat teh jobs are finished within teh specified time frame.
  • Interacting with teh clients from time to time to discuss teh open issues.
  • Changes to teh existing Reports & Creation of new Reports as per Clients requirements.
  • Fixing teh High and Medium priority tickets raised by users.
  • Informing Clients about teh Success / Failure of teh loads as soon as teh activity is finished.
  • Handled tickets with different priority and maintained work history in Maxim for all teh tickets until it is closed down.
  • Monitoring teh Production system and fixing teh Master data, Transaction data and Process Chains load failures.

Confidential

BI/BO SR Consultant

Responsibilities:

  • Extensively worked on SAP BO Information Designer with SAP and Non SAP Sources.
  • Extensively worked on SAP BO Information Designer, Universe Designer, Web Intelligence Rich Client, Dash Board Designer, Crystal Reports, QAAWS, and Live Office.
  • Creation/Change of Process Chains for teh entire Daily / Weekly/Hourly Loads as and when required.
  • Cross Verifying teh Daily data load as per teh checklist for ensuring teh proper data upload in BI
  • Checking teh daily time schedule for teh run & ensuring dat teh jobs are finished within teh specified time frame.
  • Interacting with teh clients from time to time to discuss teh open issues.
  • Changes to teh existing Reports & Creation of new Reports as per Clients requirements.
  • Fixing teh High and Medium, low priority incident raised by users.
  • Informing Clients about teh Success / Failure of teh loads as soon as teh activity is finished.
  • Handled tickets with different priority and maintained work history in INFRA ticketing tool for all teh tickets until it is closed down.
  • Monitoring teh Production/ Pre- Production system and fixing teh Master data, Transaction data and Process Chains load failures.
  • Working major issues on Visual Composer.
  • Having knowledge on Creating PM Orders in ECC for testing BI reports.
  • Extensively involved in SR Process and incident Management Process.
  • Working major issues on Integrated planning.
  • Extensively involved in Transport Mechanism.
  • Extensively involved in Data Source Enhancement using BADI.
  • Extensively involved in Customer Exit Processing type using BADI.
  • Extensively involved in Creation of Start routine, End routine and field routine.
  • Extensively involved in Pseudo delta mechanism.
  • Extensively involved in Client refresh from Production to Pre-Production.
  • Extensively involved in Logistic Extractors for PM, MM applications.
  • Extensively involved in FI and HR extractors.
  • Extensively involved in BI Content installation of BI objects.
  • Extensively involved in BI Statistics and reports.

Confidential

BW Consultant

Responsibilities:

  • Primary responsibility of supporting for BW.
  • Creation of Process Chains for teh entire Daily / Weekly Loads as and when required.
  • Cross Verifying teh Daily data load as per teh checklist for ensuring teh proper data upload in BW.
  • Checking teh daily time schedule for teh run & ensuring dat teh jobs are finished within teh specified time frame.
  • Interacting with teh clients from time to time to discuss teh open issues.
  • Changes to teh existing Reports & Creation of new Reports as per Clients requirements.
  • Fixing teh Urgent, High and Medium priority tickets raised by users.
  • Informing Clients about teh Success / Failure of teh loads as soon as teh activity is finished.
  • Handled tickets with different priority and maintained work history for all teh tickets until it is closed down.
  • Monitoring teh Production system and fixing teh Master data, Transaction data and Process Chains load failures.

Confidential

BWConsultant

Responsibilities:

  • Involved in all stages of BW implementation: Modeling, Data Extraction/ Uploading, Transports and BEx Reporting.
  • Extensively worked on AWB, Customized Info objects, Info sources, Update rules, Datasources, Communication structures, Transfer structures, Transfer rules, Info cubes, Operational Data Store objects, Info packages.
  • Involved in installing of Business Content objects such as standard Info objects, info Sources, Info cubes.
  • Used Full update and delta update for Data Targets.
  • Involved in creation of Process chains for master data & Transaction data.
  • Involved in creation of Generic Data Sources and Installation of Business content data sources, LO extractors.
  • Extensively worked in Front-End-Report-Generation building queries by using Calculated key figures, Restricted key figures, Exceptions, Conditions, Variables.
  • Extensively involved in Web Application Designer.
  • Extensively involved in Start routine and end routine.
  • Creating transport, creating teh TMS documents and related documentation for moving teh transports to Integration system. Testing teh Info cube and queries/workbooks for data validity in Integration system from teh technical standpoint.
  • Involved in Business Acceptance Test.

Confidential

BI Consultant February

Responsibilities:

  • Involved in all stages of BI: Modeling, Data Extraction/ Uploading, Transports and BEx Reporting.
  • Extensively involved in Migrating Data Sources from Business Information Warehouse to Data Warehouse.
  • Extensively worked on Data warehousing workbench, creating and maintaining Datasources, Info objects, Transformations, Info cubes, Data Store Objects, Data Transfer Process, Multiproviders, Info sets, Aggregates.
  • Involved in installing of Business Content objects such as standard Info objects, Data Store Objects, Info cubes.
  • Created Data Sources for transactional data and Master data Attributes, Text in R/3 and replicated dat Datasources to BI.
  • Extensively involved in Data Source Enhancement using RSAP001 Enhancement path in CMOD.
  • Extensively involved in customer exit processing type using RAR00001 Enhancement path in CMOD.
  • Working on BEx Analyzer and created queries using BEx-Reporting Variables, Filters, Conditions, Exceptions, creation of Restricted Key Figures, Calculated Key Figures & Formulae.
  • Testing teh objects (from teh technical stand point) connections, data in BI development system and make any corrections required, Problem Resolutions.
  • Maintained Aggregates, Partitioning to improve teh query Performance.
  • Extensively worked on Web Application Designer.
  • Extensively involved in WAD Dash board and drill down feature for detail reports.

Hire Now