We provide IT Staff Augmentation Services!

Sap Business Bydesign Consultant Resume

4.00/5 (Submit Your Rating)

Mountain View, CA

SUMMARY

  • About 2 year experience in SAP HANA/ Big Data modeling, SAP BOBJ and SAP Lumira/ Predictive Analysis implementations & project management experience.
  • 12 + years of experience in SAP NetWeaver BI/ BW, SAP Business Objects, SAP SEM, SAP ECC and SAP Solution Manager implementations, upgrades, maintenance support & end - to-end delivery and project management experience.
  • 9 + years of experience in non-SAP areas such as IT, Business-process-engineering, Civil-structural engineering & International trade.
  • SAP HANA/ Big Data Application Associate Trainings from SAP Education, U.S.; SAP HANA 1.0 SP 6/7.
  • System Development Life Cycle experience: Project Planning, Scoping, Requirement Gathering, Analysis, Design, Development, Testing, Deployment, Post Production Support, Documentation and User Training.
  • Excellent ability to understand and transform complex business requirements into functional design document for solution development, delivered on time, to specification, scalable, performance optimized and maintainable. Ability to interact with End-Users to understand various business requirements.
  • A highly motivated individual abreast of latest technology, able to accomplish tight deadlines, communicate effectively with technical peers as well as with business users.
  • Hands-on experience in using ASAP, SDLC Waterfall Model & Agile methodologies.
  • Hands-on knowledge of SAP NetWeaver BI/ BW, SEM BPS (Planning, Budgeting and Forecasting): SEM BCS ( Corporate Financial Reporting), SEM BSC ( Corporate Performance Management & Scorecard) and SAP CRM.
  • Industry Experience: Information Technology, Oil & Gas, Public Sector, Heavy Industries, Pharmaceuticals, Healthcare, Financial, Investment Banking, Consumer Goods, Utility & Retail.
  • SAP HANA/ Big Data business requirements Proof of Concept (POC) architecture on SAP & non-SAP source systems including SAP BW on HANA, SAP BOBJ in large and complex environments.
  • SAP ECC tables data modeling in HCM/HR, Finance, Controlling, and SCM & Sales.
  • SAP HANAprogramming including SQL, SQL Script, and CEScript.
  • Reporting experience handling complex scenarios; SAP BO Tools: BO Explorer, WEBi, Crystal Reports on Enterprise, BEx Web application; SAP Predictive Analysis/ SAP Lumina data visualization.
  • Data provisioning landscaping methods such as SAP Landscape Transformation (SLT), SAP Data Services, or Direct Extractor Connection (DXC) for replication/ extraction of data from SAP/ non-SAP source systems.
  • RDBMS modeling of Classic Star schema Infocubes (Transactional & Masterdata tables) into SAP HANA Optimized Infocubes; Modeling of SAP HANA objects such as: Attribute Views, Analytic Views & Calculation Views with various join conditions; creating Calculated Columns, Restricted Columns, Filters, Hierarchy, etc.
  • Complex Calculation Views using SQL Scripts and Procedures.
  • SAP HANA and BOBJ Security & Authorization Proof of Concept.
  • SAP HANA Live & Rapid Deployment Solutions.
  • BI Data Modeling - Extensive configuration experience in Administrator Workbench.
  • Dimensional Data modeling, Extended Star Schemas, design and maintain various Info Objects, Info Sources, Info Packages, DSO Objects & types, Attributes & types, Info Cubes, Info Sets, Transformations, Data transfer process and it’s types, Data Source(PSA), data cleansing and Process Chains etc.
  • Different phases of Testing: Unit Testing, UAT to Integration Testing.
  • Experienced in new query development and customized as per requirements.
  • Experienced in configuring additional/required fields of Master Data and Transaction Data.
  • Uploading Master Data and Transaction Data to BI; LO Extractors, Generic Extractors, extracting data from other Source System (SQL), and Data Source Enhancement.
  • BEx Queries, Analyzer, Workbooks, Web Template and Web Reports Structures, Variables, with Process types Formulas, New Selections. Calculated Key Figures Restricted Key Figures.

TECHNICAL SKILLS

Data Warehousing: SAP HANA/ Big Data 1.0 SP07/10/11; SAP Netweaver BI/BW 7.3/7.4

ERP: SAP ECC 6.0/ 7.0; SAP Netweaver BI/BW 7.3/7.4; SAP S/4 HANA (SAP Simple Finance)

Reporting Tools: SAP BO Tools BO Explorer, WEBi, Crystal Reports on Enterprise, BEx Web application, BEx;SAP Lumira and Predictive Analysis; and MS Excel

Data Provisioning: SAP Landscape Transformation (SLT);SAP Data Services;Direct Extractor Connection (DXC); and MS Excel flat file

SAP SEM: BPS, Balanced Score Card, Risk Management, Management-Cockpit, Value-Driver-Tree.

Databases: HANA 1.0 SP 7/10/11; Oracle 9i, Oracle 10g, Sybase, DB2SQL Server, MaxDB

Software Methodologies: SAP Activate, SAP-ASAP, SDLC Waterfall Model & Agile

Document Repository Tools: SAP Solution Manager

Operating Systems: MS Windows 2000/XP/7/8,Unix

PROFESSIONAL EXPERIENCE

Confidential, Mountain View, CA

SAP Business ByDesign Consultant

Responsibilities:

  • Have taken up this short assignment to carry our further customization and support SAP Business ByDesign system mainly related to financial accounting and Costing, reporting; to carry out the data cleansing, data migration into a new ERP system.
  • Understanding of existing databases/ systems residing in SAP / non SAP environment and their business architecture.

Confidential, San Jose, CA

SAP HANA/ Big Data Data Modeler/ Architect and Reporting Consultant

Responsibilities:

  • SAP HANA business requirements Proof of Concept (POC) for technical & functional rollout for SAP and non-SAP source systems to include reporting tools.
  • Integrated planning,design, implementation & support ofSAP HANAbased solutions including SAP NetWeaver BI/BW on HANA and SAP BI/BOBJ in large and complex environments.
  • Understanding of existing databases/ systems residing in SAP / non SAP environment and their business architecture.
  • Knowledge of SAP ECC table data models and analysis such as: HCM/HR, Finance, Controlling, Supply Chain and Sales.
  • Experience in BW on HANA; loading of database on to SAP HANA; upgrading of ‘SAP NetWeaver BI/BW 7.x on xDB’ to version ‘SAP NetWeaver BI/BW 7.3/7.4 on HANA, and reporting.
  • Experience withSAP HANAprogramming including SQL, SQL Script, and CEScript.
  • Reporting experience including handling complex scenarios using joins and SQL.
  • Landscaping data provisioning methods such as SAP Landscape Transformation (SLT), SAP Data Services, or Direct Extractor Connection (DXC) for replication/ extraction of data from SAP/ non-SAP source systems.
  • Knowledge of SAP ERP extractors for data provisioning to SAP HANA.
  • Knowledge in heterogeneous data copying of data providers from SAP BI to SAP HANA DB.
  • Monitoring, investigation & optimization of data models and reporting performances on SAP HANA.
  • Evaluate impact of different implementation options such as table joins, aggregation, or filters. Understanding of performance implications of the various reporting tools and connection types.
  • RDBMS modeling of Classic Star schema Infocubes (Transactional & Masterdata tables) into SAP HANA Optimized Infocubes; Modeling of SAP HANA objects such as: Attribute Views, Analytic Views & Calculation Views with various join conditions; creating Calculated Columns, Restricted Columns, Filters, Hierarchy, etc.
  • Experience in creating complex Calculation Views using SQL Scripts and Procedures appling techniques such as currency conversion, variables and input parameters.
  • Worked extensively on various batch jobs, Data flows and configuration of data stores in Data Services.
  • Experience in Importing and Exporting functionalities of SAP HANA.
  • Experience in creating Security & Authorization Proof of Concept; Creation of Users & Roles and Privileges especially Analytic Privilege; assignment of privileges to Roles and Roles to Users; Performing basic security and authorization troubleshooting.
  • Knowledge of SAP HANA Live & Rapid Deployment Solutions.
  • Experience in creating reports on SAP HANA database using SAP BO Tools such as BO Explorer, WEBi, Crystal Reports on Enterprise, BEx Web application; Creating MS Excel reports
  • SAP reports in functional areas such as HCM/HR, Finance, Supply Chain, and Sales.
  • Experience in creating data visualization reports using tools like SAP Lumira/ Predictive Analysis: Past performance doesn’t guarantee future results; now you can anticipate them using SAP Predictive Analysis, best with SAP HANA for real-time predictive insight. This tool takes advantage of intuitive and iterative predictive modeling and leverages endless possibilities with R integration.

Confidential, San Jose, CA

Business Analyst

Responsibilities:

  • Part of Cisco’s Supply-Chain operations identifying essential processes, retire obsolete processes and eliminate waste leading to cost reduction, value engineering & nonmaterial spending.
  • Conducted a comparative analysis of vendor responses against requirements, developing a decision matrix and appropriate financial analysis to submit all purchasing recommendation to upper-management.
  • Preparation and implementation of strategies that included cost reductions and cost containment initiatives.
  • Worked with sourcing teams with contract framework agreements and development of commercial terms.
  • Interacted with Cisco’s global engineering, procurement and quality organizations based out of Thailand, Mexico, Russia to manage supplier development goals and strategic sourcing objectives in N. America.
  • Developed key supplier relationships and managed commercial strategies for N. Americansupply chain.
  • Measured supplier's ability to effectively utilize their quality processes in their manufacturing operations.
  • Attended review meetings with key suppliers, to provide feedback on measurable KPI results.
  • Interacted with supplier's to guide suppliers toward process and quality improvements, in relationship to ISO9000, ISO9001, ISO18001 and ISO14001.

Confidential, Richmond, VA

SAP Netweaver BI Consultant

Responsibilities:

  • Requirement gathering in Sales & Purchasing for cross functional analysis.
  • Data model development & monitoring for various functional requirements for queries & cubes from business content.
  • Source data mapping (SAP R3/non-SAPR3) to target data in BI/BW.
  • Extraction process using LO cockpit and V-3 updates, configuration of BW objects including generic data sources to extract data.
  • Reporting needs study, design/develop flexible queries and pre-calculated reports using BEx features like variables, exceptions and conditions.
  • Initial data load and implementation of daily update process chains
  • End-user training & support in Go-live process
  • Triggering and monitoring the Initial and Delta data loads of daily update process chains.
  • Translation of BW requirements into data analysis and reporting solutions, primarily using SAP Business Intelligence solutions (SAP BW).
  • ETL - preparing SAP R/3 for SAP BW and defining the loading strategies, initial and delta data loads using IDOCs, loading data via flat files, scheduling and monitoring data loads.

Confidential, Indianapolis, IN

SAP BW/BI/SEM-BPS Consultant

Responsibilities:

  • Translated business warehouse requirements into data analysis and reporting solutions, primarily using SAP Business Intelligence solutions (SAP BW).
  • ETL - preparing SAP R/3 for SAP BW and defining the loading strategies, initial & delta.
  • Systems Administrator for SAP Solution Manager & Quality Centre 9.2.
  • CRM and SAP BW Integration; Extracted data to BW from CRM data sources; creating Transactional Info cubes for BPS Layouts.
  • BPS Layouts - Planning Profile, Planning Area Planning Level, Planning packages & Planning Layouts; Data slices maintenance in Planning Areas.
  • Design & Construction Phase and Build & Test Phases, Fit-Gap Analysis, Process Design Documentation; Tested the new features of BI 7.0 which includes new data flow, re-modeling, integrated Planning, Real-time Data Acquisition, enhanced features of Process Chains etc.
  • Maintenance and Production Support project; continuous monitoring of loads, high-level prioritized tickets and process improvement requests.
  • Daily Production runs in Production Support; Proposed RCA’s (Root cause analysis) to the client for the frequent failures; Monitoring of info packages and analyzing the reasons for frequent failures of info packages.
  • Maintain Work History and daily time schedule for the run to ensure jobs are finished within the specified time frame.
  • Process Chain errors & rectifications; monitored loads before handing to client; Object transportation from Dev to QA and subsequently to Productions; UAT & other tests.
  • Environment: SAP 4.6c, ECC 5.0, ECC 6.0, BW 3.0b, BW 3.5, BI 7.0, BW-CRM, SEM-BP

We'd love your feedback!