Post Job Free

Resume

Sign in

Sap Data

Location:
Salt Lake City, UT
Posted:
April 06, 2020

Contact this candidate

Resume:

Nick Belangdal

adcoqe@r.postjobfree.com M 408-***-****

www.linkedin.com/in/nickbelangdal

Education and Professional Certifications

Certified SAP Professional : SAP HANA

Certified SAP Professional : SAP BusinessObjects Data Services (BODS)

Certified SAP Professional : SAP BusinessObjects Enterprise (BOE)

Certified SAP Trainer : SAP Data Services (BODS) and SAP Data Quality

De La Salle University, Bachelor of Science in Computer Studies - 1994 Profile

Worked on fortune 100 clients notably SAP, Accenture, Deloitte, Citibank North America, Overstock.com, Zionsbancorp, L-3 Communications, Exxon, Ergon Inc, Nokia, Quest, LDS Church, FedEx, WR Grace Chemicals, Exxon Mobil, CSL Behring, Campbell Soup, Harry and David, Minto Group, Newmont Mining, Delta Dental, Owens and Minor, Newport Inc, Sony BMG, Fedex Ground, Eli Lilly, Maersk Lines Ltd, Williams International, AM General

Can perform the following roles:

Data Lead for SAP Data Migration

Data Migration Lead for SAP Data Migration

SAP BODS / Data Services Consultant

SAP Data Quality Consultant

SAP HANA Consultant

SAP Data Migration Consultant

Business Intelligence / Analytics Consultant

Integration, Interfaces and Data Governance Consultant SAP Business Objects Consultant

Seasoned professional with 25 years of IT Consulting experience in the following areas

Solutions Architecture

End to End Solutions landscape design and implementation for ERP and CRM Systems, Business Intelligence, Data Warehousing, Master Data Governance, Data Quality, Custom Application Systems, Information Delivery Solutions, Analytics

Development of hybrid SAP Data Migration methodology for Aerospace and Defense

SAP Data Migrations and Interfaces

Technical Leadership on end to end data migration of legacy ERP systems to SAP ECC/SAP S4HANA

Use of SAP All-in-One Methodology, pre-built contents for data staging database structure, mapping, SAP Data Services (BODS) ETL jobs, Web Intelligence reconciliation reports and BusinessObjects universes

Expertise in Aerospace and Defense industry data migration on following objects: Finance, Project Systems, Project Ledger, GPD (Grouping, Pegging and Distribution), Supply Chain, MRP and Capacity Planning, Production Planning, GL/AP/AR, Purchasing, Sales, Contracts and Billings, Sales Delivery, Shipments, Inventory

Business Intelligence, Enterprise Performance Management and Business Analytics

SAP BusinessObjects Enterprise Architecture

SAP BusinessObjects Reports and Universe Development

SAP BusinessObjects Dashboarding and Visualizations

SAP BOE Migrations, Upgrades and Customizations

SAP Rapidmart for SAP ECC – FI, SD, PP,AP/AR,GL,INV,MRP,Cost Center, Profit Center, PU

Enterprise Information Management /ETL / Datawarehouse

SAP Data Services Architecture (BODS) (Installation, Sizing and Tuning)

Data Quality Rules/Dashboard/Reporting using SAP Information Steward

Data Architecture

Data Conversion / ETL / Data Warehousing

Data Quality Framework (Global/North America Address and Data)

Data Quality Management (DQM) for SAP ECC/CRM Solutions

SAP AIO Best Practices for Data Migration

Master Data Management and Data Governance

Data Health Assessment

SAP Data Migration ETL

SAP Rapidmarts for SAP ECC – FI, SD, PP,AP/AR,GL,INV,MRP,Cost Center, Profit Center, PU

Realtime / Webservices using SAP Data Services (BODS) Real Time jobs

SAP HANA Live

SAP BW and SAP HANA In-Memory Computing

Data Provisioning using SAP Data Services (BODS)

Calculation views development/Modeling using SAP HANA Studio/Information Modeler/Scripting

SAP HANA server administration

SAP HANA Business Analytics for SAP ECC

SAP BW data replication/provisioning on SAP HANA/SLT

SAP HANA Models/Calculation Views tuning

SAP HANA Models/Calculation Views analytic privilege security Design and Implementation

Information Delivery using SAP BOE (Webi, Xcelsius,Design Studio), Tableau, Qlikview

SAP BusinessObjects Trainings

Training Program Development

Conducted Trainings on SAP BusinessObjects Enterprise Architecture and Tool Suite

Conducted Trainings on SAP BusinessObjects Data Services (Data Integrator and Data Quality)

Conducted Trainings on SAP All-In-One Best Practices for Data Migration

Technical Training Development and Implementation

Design of extensive Infrastructures for Training Environments

Development of real business scenarios case project studies

Covered environments: SAP ECC/BW, SAP HANA, SAP Data Services, SAP BusinessObjects, SAP Rapidmart Solutions, SAP Data Migration, Database servers, SAP HANA Live

Knowledgebase Infrastructure

Setup of Virtual machines to support Technical Teams for Research and Development, Training, Resolution of client issues

Virtualization of SAP BOE, SAP Data Services, SAP HANA, SAP ECC and Network Administration on Extranet deployment

Development of knowledge base from different solutions implemented

Cloud Integration/Data Governance between Salesforce.com and SAP ECC Technical

SAP BusinessObjects Enterprise 5.x/6.x/ XI R2/ XI 3.x/4.x Architecture Setup, Sizing, Admin and Migration, SAP Integration Kit

SAP BusinessObjects Enterprise (CMC, BI Launchpad, Universe Designer, Information Design Tool (IDT), WebIntelligence, Business Explorer, Design Studio, Lumira, Xcelsius/Dashbaord Manager, Business Explorer)

SAP Data Services (BODS) 6.x/3.x/4.x – (Designer,Repository Manager, Server Manager, Data Services Management Console, IPS)

SAP Information Steward 3.x/4.x (Metadata Management, Data Cleansing dictionary, Data Insight)

SAP Data Quality address directories: Global / US Regulatory / North America

SAP Data Quality cleansing package: custom and North America english

SAP AIl-in-One Best Practices for Data Migration 3.2 / 4.0 / Suite for HANA / S/4HANA LTMC

SAP Data Quality Management (DQM) Solutions for SAP ECC 5.0/6.0 /CRM

SAP Rapidmarts for SAP ECC: modules include Project Systems, GL/AR/AP, Production Planning, Capacity Planning and MRP, Manufacturing, Cost Center, Profit Center, Purchasing, AR/AP, Fixed Asset, Inventory, Inventory, Sales Delivery and Shipments, Sales Distribution, Contracts and Billings

SAP ECC/BI BW Data Integration and Harmonization with Non-SAP systems

SAP HANA (High Performance Analytical Appliance) Modeling, Administration, Setup and Maintenance

SAP HANA Information Modeler and Integration to SAP Data Services(BODS) and SAP BusinessObjects Business Intelligence

SAP HANA Business Analytics for SAP ECC

Master Data Management for customer / vendor / material objects

Data Warehousing, ETL / Data Integration, Oracle PL/SQL, MS Transact SQL, Toad Suite, SQL*Plus, Constellar ETL

Business Intelligence: Web Intelligence, Webi Rich Client, Desktop Intelligence, Crystal Reports, Universe Designer, Information Design Tool, BusinessObjects Explorer, Crystal Xcelsius, Xcelsius 2008, Dashboard Designer, Dashboard Manager, Performance Manager, Crystal Reports, Live Office, Query as a Web Service, BI Webservice

Customizations: BO SDKEnterprise, Full client SDK, Enterprise Webi SDK XI R2/3.x/4.x, RESTful API, Xcelsius XML data feeder, Salesforce.com API, Dartmail API

Languages: Visual Basic / ASP/ .NET, Oracle PL/SQL, MS Transact SQL, Delphi, Oracle Developer 2000, Java

DB Tools : Query Analyzer, SQL Server Management Studio, Toad Suite, SQL*Plus, SAP HANA Studio

Scripting : Unix Shell Scripting, SQL scripting, Vbscripting, Jscripting

Databases: Oracle, MS SQL Server, MS-Analysis OLAP Services, Teradata, DB2, MySQL, MS Access, Sybase

Network/OS Admin: Active Directory, DNS Server, Router IP Address translation, FTP Server Setup, Extranet

SAP Data Migration using iDocs: Vendor Master / Material Master objects / Material classifications / characteristic / Sales Order / Purchase Order / Inventory Control / Project Ledger / Project Systems Work Breakdown structures, networks and milestones / BOM/Inventory/GPD, etc Work Experience

Role(s): Data Lead / Integration Lead / Tech Lead SAP Data Migration / Lead BI and BODS Consultant / Solutions Architect

Duration: Feb 2016 – Dec 2019

Client: Deloitte Consulting for Williams International – Walled Lake/Pontiac, MI

Aerospace and Defense : Implementation of

o SAP Data Migration

o ERP Business Intelligence and Analytics

o Systems Integration and Interfaces

o SAP HANA calculation views modeling for OLAP analysis o Solutions Architecture

o Data Quality

SAP BODS(BusinessObjects Data Services), SAP BOBJ(BusinessObjects) Enterprise, SAP Information Steward Architecture

o Installation, Configuration and Administration

Design and Implementation of SAP BODS and SAP BOBJ Security for combined US and Non-US personnel usage

Design and Implementation of Data Staging Strategy for combined US and Non-US personnel usage

Installation, Configuration and Customization of SAP Rapid Deployment Solutions for Data Migration (SAP RDS for SAP ERP)

Training of Offshore development team counterparts on SAP RDS Methodology and pre-built ETL jobs

Training of Functional Leads/resources on SAP RDS business process documents, mapping templates, Configuration maintenance

Design and Coded SAP HR Real Time Management Engine powered by SAP HANA, SAP BODS and SAP BOBJ

SAP HR Real Time Dashboard and Reporting from SAP HANA

Design, Coding, Implementation and Maintenance of SAP Interfaces with Legacy Systems on the following areas:

o Legacy HR System for Master Data, Time Management, Payroll and Accounts Payable posting o Legacy Project Management System

o Electronic Fund Transfer / Wire Transfer

o Job shop Accounts Payable posting

o Timesheet Confirmation Auditing

o SAP HR Exceptions Notifications

o APR Engine

o Time Lock/Unlock Profiles

o Accounts Payable Invoice

o Finance Income Statement/Balance Sheet

o Engine Profit and Loss Dashboard

o Corporate Operations Dashboard

Design, Coding and Implementation of Real Time Widgets for Finance/HR/SAP BODS Housekeeping

Design and Coding of HR/Finance OLAP Reporting using SAP HANA calculation view Models

Coding of data masking of sensitive SAP ERP data for SAP Training environments

Design and configuration of SAP HANA roles, objects and analytic privileges for BOBJ Reporting and Interfaces

Design of ITC Data validation workflow from conversion execution all the way to reconciliation

Coding of all Finance and HR conversion objects

QA of SAP BODS/BOBJ/HANA codes developed by the team

Design of SAP BODS/BOBJ/HANA migration process

Design of SAP BOBJ Enterprise security

Design of Security Integration of SAP BODS/SAP BOBJ/SAP HANA for interfaces, reporting and publication

Design, coding and implementation of HANA models/dimension/cubes/Calculation views for Finance/HR/Operations Reporting and Interfaces

Implemented CUBE reporting using HANA Calculation views for Finance/Cost Management/Business Planning/HR with emphasis on complex combination of hierarchies for cost elements/ project systems/GL Accounts/Customized Time Dimensions

Implementation of HR Time Management Dashboard/Time Management Interfaces using BODS/Real time HANA Calculation views

Trained Developers of HANA Modelling, HANA security design on contents, Business Objects Reporting, SAP BODS

Role(s): Integration Lead / Solutions Architect for SAP Rapid Deployment Solutions for Data Migration for S4HANA Architect

Duration: Mar 2018 – Dec 2018

Client: Deloitte Consulting for AM General

Setup and Configured SAP RDS for S4 HANA on premise edition

Trained Offshore Developers on SAP RDS Methodology and pre-built technical contents

Architected and Implemented Data Security and Housekeeping processes for Legacy Staging, S4HANA data pull, Idoc monitoring and Reconciliation, SAP Configuration Maintenance

Installed/Configured/Sized and Deployed SAP Data Services (BODS)

Installed pre-built contents for SAP RDS on BODS and SQL Server databases

Optimized SAP BODS Servers, MS SQL DB Servers

Resolved code issues from offshore during ITC cycles

Developed the following migration objects:

o Bill of Materials (BOM)

o Routings

o Open AP

o Open AR

o Material Master

o Purchase Order

Role(s): Data Migration and Data Quality Consultant / ETL/SAP Data Services Consultant / Business Analyst Project: Data Migration/Master Data governance between Salesforce.com and SAP ECC Duration: Sep 2015 – Nov 2015

Client: Newport Inc (Irvine, CA)

Developed mappings for Salesforce.com CRM entities

(Leads/Contacts/Accounts/Opportunities/attachments/notes/opportunitycontactrole/opportunityhistory)

Developed profiling jobs for customers, leads, contacts, opportunities and notes from Salesforce.com, SAP ECC,

Performed Address and Data cleansing of master data from various CRM sources for the following: Customer, contacts, leads, opportunities, notes

Designed and Developed Data Quality processes for Salesforce.com Leads, contacts, opportunities and accounts

Designed Developed Data Quality ETL jobs for master data address parsing, correction, standardization and enrichment

Designed and Developed ETL jobs for matching, de-duplication and consolidation of master data for customers, contacts, opportunities, attachments, notes

Worked with data owners on handling of data quality issues on duplicates

Developed ETL jobs for cascading consolidation of identified an verified duplicates for customers,

Provided sizing recommendations of SAP Data Services installations including update of Address directories

Setup web services data stores for Salesforce.com in SAP Data Services

Developed and performed data migration of CRM objects to Salesforce.com

Developed SAP Data Services Real Time jobs for global address suggestions

Developed SAP Data Services Real Time jobs for contacts/accounts/leads/opportunities matching Role(s): Solutions Architect / Trainer / SAP HANA Consultant / SAP Data Services and BI Consultant / VM Consultant Duration: Mar 2015 – Aug 2015

Client: KloudData/Signifiance (San Jose, CA)

Project: SAP BusinessObjects and SAP HANA Instrastructure Development Role: Solutions Architect

Setup infrastructure through VMWare ESX 5.0/6.0 for the following servers:

SAP Businessbjects Enterprise

SAP Data Services

SAP Data Quality

SAP Information Steward

SAP HANA

MS SQL Server

SAP ECC

SAP BW

Qlikview

Tableau

Servicenow

Hadoop

Cognos

Informatica

Maintained and managed VMware ESX and Hyper-V virtual machines

Conversion of Hyper-V virtual machines to VMWare ESX virtual machines

Developed and conducted training modules for

SAP ERP concepts

SAP HANA modeling

SAP Businessobjects Enterprise user content admin, server admin, setup and installation

WebIntelligence Reports Development

Universe Development

SAP Data Services and Data Quality

SAP Data Services Real Time

SAP Dashboard via SAP BE webservices, SAP Data Services Real Time

SAP Data Migration

SAP Rapidmart pre-built contents: database staging structures, Idoc Mappings, ETL jobs, Reports, Universes

SAP ECC basics

SAP HANA Business Analytics for ECC

Developed SAP HANA Business Analytics for SAP ECC

Managed a team of developers

Project: SAP HANA Business Analytics

Role: SAP HANA Modeler, SAP Data Services (BODS) Developer Tasks:

Imported SAP HANA Business Analytics for SAP ECC schema andpackages (FI/CO, PM, MM/CRM) to SAP HANA using Delivery Unit import

Provisioned raw data to SAP HANA from SAP ECC using SAP DataServices (BODS)

Granted roles, System and Object Privileges in SAP HANA

Develop Reports using WebIntelligence, Tableau, Design Studio and XCelsius using HANA as the source system.

Designed custom reports for Purchasing, GL, Sales Distribution on SAP ECC

Redirected IDT connections from RDBMS to SAP HANA Project SAP HANA on BW

Role: SAP HANA Developer

Tasks:

Pulled data from SAP BW Info Cubes (Purchasing, Sales & Distribution) using SLT to HANA.

Modeling and activating standard Business Content, extending and enhancing using User Exits according to the end-user requirements

Used SAP BW components including composite providers, Extract Structures, Extractors, Data Sources, Transformations, Info Objects, DSO, Info Cubes

Build custom queries using Variables, Structures, Conditions and Exceptions, Restricted and Calculated Key Figures and saved them in workbooks for later references

Database Performance Tuning, Data Load Performance Tuning, and Query Performance Tuning

Coordinating, driving and working with the BI team to meet the deliverables and milestones per project plan

Develop Reports using webi, tableau, design studio and xcelsius. Project: SAP HANA prototype for SAP ECC using project systems/project ledger data Role: SAP HANA Developer / Business Analyst / SAP Data Services Developer / SAP BusinessObjects universe and reports developer

Tasks:

Identified SAP ECC transaction tables and master data tables for provisioning

Analyzed entity relationship of project system tables

Designed metrics and dimensions for project systems reporting on costs(labor,material, overhead, etc), work breakdown structures, hierarchy and networks

Designed and created schema/content (Attribute, Analytical, and Calculation Views) in SAP HANA using SAP HANA studio information modeler

Developed SAP Data Services (BODS) jobs for data extraction from SAP ECC to SAP HANA

Defined and designed reports requirements

Developed SAP BusinessObjects Universe and WebIntelligence reports to deliver information Role(s): SAP Data Services (BODS) Consultant/Architect, SAP BusinessObjects Consultant / ETL and Data warehouse Architect / Business Analyst

Duration: Sep 2013 – Feb 2015

Client: Deloitte and Beacon Systems for L-3 Communications West (Salt Lake City, UT)

Maintenance and Tuning of SAP Rapidmart ETL modules

Development of SAP ECC data extraction jobs

Integration of Legacy data with SAP ECC data warehouse, SAP Rapidmart ware house

Development of Adhoc-reports related to GPD, MRP and Capacity Planning, Supply Chain, Project Systems, Project Ledger, Project Costing and Project Performance, cost center, profit center, SAP business transactions, Production Planning, Human Capital Management, Dassian, Contracts and Billings, BOM

Business and Technical analysis on financial reports requirements

Development of universes and web intelligence reports

Data analysis and development of adhoc queries to support PCSM, operations and finance business segments

Worked with functional team on report requirements for GPD, Government regulatory compliance

Design and Development of Finance Dashboard, Project Performance Dashboard using SAP DS Real Time and SAP Dashboard

Production support on Active Batch triggered SAP Data Services rapidmart jobs (all modules)

Installations, setup, configuration, optimization of SAP BOE, SAP Data Services environments

SAP ECC Data warehouse implementation, maintenance and Tuning

SAP Rapidmart implementation (ETL/Data warehouse/Reporting) of the following modules:

Production Planning

Sales, Delivery and Shipments

MRP and Capacity Planning

Cost Center

Profit Center

Accounts Payable

Accounts Receivable

General Ledger

Purchasing

Inventory

Plant Maintenance

Project Systems

Role(s): Data Migration Technical Lead Consultant / Business Intelligence Consultant / ETL Architect / Business Analyst

/ SAP HANA Consultant

Duration: Sep 2012 – July 2013

Clients: Deloitte and Beacon Systems for L-3 Communications West

Implemented and maintains SAP Rapidmart modules

Maintained universes for Rapidmart and SAP ECC Reporting

Developed and designed SAP Business Objects reports for MRP / GPD / Quality Assurance / Production Planning / Project Systems / Contracts and Billings / Dassian

Optimized and production support for SAP Data Services Rapidmart jobs

Optimized and production support for custom SAP ECC ETL Jobs

Business and Data analysis for adhoc financial reporting on GPD / Pegging History / Excess/Scrap Week over Week Cost progression metrics

Primary developer for SAP Project Systems (PS) master data load including Project, WBS Element, Network, and Network Activity creation

Designed and executed legacy WBS structure data defect report to facilitate data cleansing and preparation for SAP cutover

Primary developer and ETL executioner on SAP Grouping, Pegging, & Distribution (GPD) data conversion for Work in Process (WIP) and on hand inventory o Designed SAP BAPI postings to post costs to production orders o Designed conversion and transformation of legacy WBS assignment to develop GPD PEG_TASS

(Pegging Assignment)table to preserve alignment of replenishment objects to their respective projects

Coded SAP contracts assignments to WBS Elements for Fixed, Cost Plus, Time and Material contract types

Designed data migration reconciliation solutions for project systems structures and project ledger

Coded and developed approximately 200 BODS data migration jobs to support finance objects in migrating legacy to SAP ECC

Designed and executed data loads to post costs to all historical SAP projects for historical ledger actuals and current year actuals

Designed reporting universes using Information Design Tool to support

adhoc analysis of staged legacy data

Preload vs. Post load SAP data

preload vs post load reporting adhoc requirements

data quality/data cleansing of legacy data for

developed approximately 100 Web Intelligence reports to support

finance data validation

adhoc data analysis

data cleansing effort in legacy

preload reporting

post load reporting

reconciliation of project ledger postings - preload vs SAP

reconciliation of projects/wbs/network objects - preload vs SAP

cost shift analysis for GPD (Grouping, Pegging and Distribution)

involved in execution, monitoring, validation of SAP data migration of projects systems and project ledger SAP FICO objects in multiple cycles including final cutover Role(s): Solutions Architect/ Tech Lead Developer/Data Migration Tech Lead Consultant/ Trainer Duration: Oct 2010 – Aug 2012

Clients: Utopia, Inc

Provided SAP with expertise using Utopia’s Enterprise Data Lifecycle Management Methodology

Conducted Data Services boot camps at Utopia for SAP Data Services and SAP AIO Best Practices for Data Migration

Involved in hiring process of Data Migration Consultants

Supported pre-sales in proposals and estimates

W.R. Grace Chemicals (under SAP Partner Utopia Inc), Columbia, MD / Cambridge, MA

Implemented SAP Data Quality Management for SAP Solutions 4.0 sp1 o DQM RFC Server installation and configuration

o Business Add-ins installations on SAP ECC 5.0

o DQM setup and configuration on SAP ECC 5.0

SAP BO Data Services 4.0 sp2 (IPS, Data Services, Information Steward, Data Quality Address Directories, Data Cleansing Package, SQL server repositories and DB Mailing) installation and Configuration

Customized DQM pre-built Batch and Real-Time jobs for Address Cleansing and Batch Matching to cater only for US customers

Developed Data Services jobs for Business Rule Compliance for US customers that generates exception reports, compliance statistics and metrics, Change data capture

Developed Data Quality job that generates standardized, enriched and corrected Customer name based on North American English cleansing package

Developed project plan using ASAP methodology

Designed and developed Business Rules Compliance Dashboard using Xcelsius and Data Services Real Time

Performed Data Health Assessment on Customer Master critical fields Pulse Electronics (SAP Project under SAP Partner Utopia Inc), San Diego CA

Developed extraction jobs to pull data from SAP ECC for Purchase Order, Sales Order and Inventory Control

Customized SAP AIO BPFDM jobs to for data migration from HP MM ERP to SAP ECC using SAP Idoc using Business Objects Data Services ABAP dataflows and SAP CREMAS, SALESORDER_CREATEFROMDAT2, Inventory inbound Idocs message types

Investigated and resolved Data issues for failed Idoc data segments for Sales Order and Purchase Order

Conducted SAP BusinessObjects Data Services and SAP AIO BPFDM Training Newmont Mining (SAP Project under SAP Partner Utopia Inc), Denver CO

Developed Customized Profiling Job for huge source datasets

Developed macros for automatically pulling attributes from BPCS ERP tables

Customized training program for the client to suit their SAP Data migration strategy

Conducted SAP BusinessObjects Data Services(DI + DQ) and SAP AIO BPFDM Training

Setup SAP AIO BPFDM 3.2 environment

Supervised team of consultants in SAP AIO BPFDM during on the job training CSL Behring, King of Prussia PA

Conducted Data Health Assessment of Material/Product Master and Vendor Master Data

Conducted SAP BusinessObjects Data Services(DI + DQ) for SAP basis team and Analysts

Setup SAP BO Data Services environment including Address Directory and Data cleansing package, RFC connections, data stores and repositories

Migrated old SAP BODS codes into new environment Minto Group (SAP Project under SAP Partner Utopia Inc), Ottawa Canada

Installed and configured Data Services infrastructure including Address Directory and Data cleansing and SAP AIO BPFDM contents

Conducted SAP BusinessObjects Data Services(DI + DQ) and SAP AIO BPFDM Training to SAP consultants

Architected and Developed Data Quality Real Time services for Customer Master

Installed and configured SAP AIO BPFDM 3.2 and trained in-house SAP developers/analysts

Developed Data Quality Jobs for address and person/firm names for Customer Master

Developed Post governance Real Time jobs for Customer Object using staged cleansed and enriched Customer Data

Campbell Soup (SAP Project under SAP Partner Utopia Inc), Camden NJ

Project is about Vendor Master and Material Master - Master Data Management and Harmonization

Management Team for Implementation

Developed Technical specifications for Data Harmonization project

Architected Data Architecture of the control and staging database

Designed end to end solution for the entire Data synchronization between SAP ECC and Optiva in-house system

Designed and developed SAP Idoc data services jobs for updating SAP ECC Material Master

(Master Data / Alternate Units of Measures / Material Classification and Characteristics)

Developed reusable dataflows for automated emailing, exception and update history report generation

Designed and developed 30 Jobs that includes harmonization process (Material Master and Vendor Master) and housekeeping (Idoc monitor and reconciliation, oracle backend statistics update, job parameter updates, reference/translation table loading)

Implemented data loading using SAP Idoc and SAP idoc monitoring interface using Business Objects Data Services ABAP dataflows and SAP MATMAS05, CLFMAS, CREMAS, DEBMAS inbound Idocs

Hypercare and Production support for Master Data Harmonization project Exxon Mobil (SAP Project under SAP Partner Utopia Inc), Houston HQ

Conducted SAP BusinessObjects Data Services(DI + DQ)

Setup environment for use cases related to SAP BO Data Services connectivity with SAP BI/BW and SAP ECC

Developed POC jobs that showcase SAP BO Data Services connectivity with SAP BI/BW as source and Target

Conducted best practices workshop on SAP BO Data Services migration process KloudData, Fremont CA

Developed Solutions Architecture for Salesforce.com integration with SAP ECC and other non- SAP systems for an MDM Solution for Aruba Networks in San Jose CA

Created presentations for a client on the value proposition of using SAP Business Objects Data Services to perform data quality and system integration activities to resolve specific client business issues

Developed blueprint of Customer Master Data solution for a Proof Of Concept (POC) using SAP Business Objects Data Services and SAP MDM

Developed Real Time integration and harmonization of Salesforce.com Accounts, Accounts Hierarchy with SAP ECC Customers using Business Objects Data Services, Data Quality, SOAP, Idocs

Developed Customer Hierarchy derivation from Test D&B database for Salesforce.com account hierarchy

Developed extraction jobs that pulls data from Salesforce.com CRM and SAP ECC for Accounts, Leads, Opportunities and Customer Master/Sales Org Role(s): Dashboard Architect/Developer

Duration: 3 Months Nov 2011 - Jan 2012

Client: Alpine - Non Profit Organization in Utah

Project Scope and Description: Data Integration, Business Analysis, Dashboard Design and Development for Performance, What-if and Budgeting Analytics

Responsibilities/Deliverables:

Scoped out requirements for Performance Analytics and Budgeting Dashboard

Interacted with SME's: Finance and Operations team for blueprinting

Oriented Stakeholders on KPIs (Key Performance Indicators) and Metrics

Defined KPIs and Metrics

Designed Data Architecture and Dashboard Interface for Performance, Budgeting and What-if analysis

Designed Navigation workflow for parent and child drill down

Developed extraction job to pull Profit and Loss data from Quickbooks Accounting Software using SAP BO Data Services

Developed transformation jobs using SAP BO Data Services that loaded data into multi dimensional dashboard aggregates for Xcelsius 2008 consumption

Developed Xcelsius User Interface that shows Year over Year Deviation in % and $ of KPIs and metrics for each P&L groups

Developed Xcelsius User Interface that provides interactive What-if scenarios for comparative years for each P&L Account Lines to help in setting Budgets for 2012

Delivered and Presented to Finance Board who recognized the value in the entire Performance Review and Budgeting process

Role(s): SAP BODS/Data Services/ETL/Data Integrations Consultant Duration: 17 Months Jan 2009 - Oct 2010

Client: Deloitte Consulting for LDS Church in Salt Lake City UT Project Scope and Description: Conversion, Data Warehouse, Banking System Responsibilities/Deliverables:

Developed technical specs for ETL interfaces based on functional design and mappings

Developed and Managed code migration process Develop BO Data Services jobs for 15 ETL interfaces that include check-in clearing



Contact this candidate