Sap Data
Resume:
Nick Belangdal
****@*********************.*** 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