Data Sap

Andre O. Barrett

**** ***** **** **** **., Atlanta, GA, 30319

Mobile: 404-***-**** • E-mail: ************@****.***

Objective

To diligently occupy a profession which will allow me to utilize my skills in the field of computer and information technology in addition to, enabling me to be an imperative individual in a highly competitive technological environment.

Education

COMPUTER SCIENCE At Georgia State University, Atlanta, GA

Professional Skills

Computer Skills

SAP BusinessObjectsData Integrator Certified

Expert in SAP Process Integration, Informatica ETL Development, Java Development, Store Procedure and query optimization

Expert in creating complex queries in an Oracle, SQL, SYBASE, and DB2 databases

C++, Php, Java, Java Script, SSH shell, Unix shell, Assembly Programming

Efficiently utilize Microsoft Excel, Access, PowerPoint, Project, Font Page, Visio, Word, Info Path, and Outlook…

Expert using Oracle Toad, Visual Studio, Active Batch, Data Junction, J-Builder, J-Creator, QuickBooks, …

Rapidly grasp operation of software and hardware

Business Skills

Perform assignments with careful detail and accuracy

Work collaboratively with others to generate exceptional outcomes

Adapt and positively function efficiently in professional environments

Strategically interact with clients and professionals to produce high business results

Related Work Experience

WEBER-STEPEN / DICKINSON+ASSOCIATES, SAP Information Steward Architect, Jul 2020 – january 2021

Palatine, Illinois

Size, Architect & Install SAP Information Platform Services, SAP Data Services & SAP Information Steward

Migrate from SAP Data Services 4.2 SP7 to 4.2 SP14.

Create Templates & Help Document and create all SAP Information Steward Data Insight Rules for Business Partner, Customer Master, Vendor Master and Material Master.

Create Cleanse Process to Consolidate Customer Master & Vendor Master into Business Partners for S4HANA 1909 Migration.

Create All Required SAP Data Services Extraction Process Required for SAP Customer Master, Vendor Master and Material Master including Long Text.

Create training material required to get the business fully self-sufficient on SAP Information Steward.

Create Data Integrations in SAP Information Steward in order to identify data lineage.

TRANSMONTAIGNE, S4HANA IS/OIL ARCHITECT, JAN 2019-Jul 2020

Denver, Colorado

Create functional data conversion documents to migrate the following objects: Business Partner, AP Open Items, AR Open, Material Master, and all associated IS OIL Downstream Processes such as Batch Management and TMS.

Cleanse and Harmonize data using SAP Data Services Address Cleanse Package, Information Steward Person/Firm Package and Match Transforms prior to loaded data into S4HANA

Building Custom Function modules which could be used by the S4 HANA Migration Cockpit (LTMOM, LTMC) to load data in S4 HANA

Install and Upgrade SAP Data Services and SAP Business Objects BI Cloud Solution and Integrate with the SAP Hana Cloud Platform

Create custom SAP Business Objects BI Cloud Webii Reports and Universe

Install and Configure SAP BOBJ, Data Services, and Information Steward.

Configured Single Sign on using Kerberos Authentication on a clustered environment with 4 Application Servers.

Build RFC Enabled Function Modules to Load Data in SAP

Automate Bill Of Lading Match process using Business Object Data Services as an ETL tool to integrate TopTech and S4 HANA

EXXON MOBIL, S4HANA TECHNO FUNCTIONAL PRINCIPLE CONSULTANT, SEPT 2017-JANUARY 2019

Fort Worth, Texas

Create functional data conversion documents to migrate the following objects: Business Partner, Fixed Assets, AP Open Items, AR Open Items, Cost Centers, Material Master, Class, Characteristics, Material Classification, PRA objects, etc… in SAP S4HANA 2.0. P

Create ABAP function modules in SAP S4HANA to load data into S4 HANA either using Standard BAPI or BDC recordings.

Create SAP Business Objects Cloud Reports in Both Crystal Report and Webii

Create real-time / web service ABAP code to retrieve Geo Coding Data From Data Services and GIS.

Utilize the S4HANA Data Migration Cockpit to load data directly into S4HANA’s ERP system.

Utilize SAP Data Services Rapid Deployment Solution to load data into S4HANA via IDOC and ABAP function modules.

Create User Defined Transformation in SAP BODS using Python.

Utilize SAP Information Steward to Analyze and profile uncleanness data.

BWAY CORPORATION, SAP BUSINESSOBJECTS DATA SERVICES CONSULTANT, APRIL MAY 2017-SEPT 2017

Atlanta, Georgia

Use SAP Data Services to connect to Hadoop Cloudera KUDU system in order to load millions of records within seconds using Data Services

Created automated process using SAP Business Objects Data Services to upsert data in Cloudera Hadoop KUDU system via HDFS via custom functions and via the KUDU API

Create And Update Historical Data into Cloudera Hadoop KUDU tables in Hue and in to current data into S/4 Hana

Configure SAP BODS scheduling using BODS’ Management Console and configure the Central Repository as the primary source of version control

Create automated process for Inventory Daily, Inventory Monthly, Production Daily, Production Monthly, Safety, Claims, Complaints, On Time In Full, etc..

Update Customer Master, Vendor Master and Material Master KPI’s Using SAP Information Steward in order to monitor data quality

COCA-COLA, SAP BUSINESSOBJECTS DATA SERVICES ARCHITECT, APRIL 2016–APRIL 2017

Atlanta, Georgia

Create SAP Business Objects Data Services (BODS) ETL jobs from scratch for the following objects Plan Maintenance (PM) Objects: Task List, Recipe, Material Master, Material Characteristics, Material Classification, Equipment, Functional Location, Maintenance Plan, Long Text, Measuring Points, etc…

Create BODS jobs from scratch which loaded data via LSWM, BAPI (Function Module), WinShuttle, BDC, and IDOC.

Create rules in SAP MDG in order to cleanse Vendor Master and Customer Data prior to load into SAP

Utilize SAP BusinessObjects Best Practice job or Hana Rapid Deployment Solution to load data via an IDOC In S/4 Hana

Configuring SAP BODS DQM Solution to MDG in order to preform real time address cleanse

Coordination with Project team stakeholders - Business / Data Owners, SAP Functional teams, SAP ABAP / Basis teams, ETL teams, Legacy data team etc…

Following SAP’s Best Practices for Data transformation Procedures, Post migration data validation procedures, Data retention, Data security procedure

WC BRADLEY, SAP BUSINESSOBJECTS DATA MIGRATION CONSULTANT, APRIL 2016– NOVEMBER 2016

Columbus, Georgia

Install and Configure SAP Information Platform Services, SAP Data Services and SAP Information Steward 4.2 SP4

Used SAP Business Objects Data Services Best Practice (BPDM) to migrate various source systems in SAP ECC.

Created SAP Data Services Jobs via IDOCS, LSWM, BDC, and BAPI function calls in order to load the following SAP Objects: Vendor Master, Customer Master, Material Master, G/L Account, Cost Center, Cost Element, Cost Center Group, Cost Element Group, Activity Type, Activity Group, Activity Price, Profit Center, Profit Center Group, Profit Center Account Group, Article Master, Additional, Product Catalog, Product Catalog Item, Price List, Assortment, Service Master, Characteristic, Class, Classification, Document, Purchasing Info Record, Conditions, Order Book, Change Master, Bill of Material, Document BOM, Work Breakdown Structure, PA Object Type Person, PD Object Type

Using the SAP Data Services python compiler to manipulate and remove special characters and line feeds and to convert CSV into Excel

Prepare data migration templates to map various source systems fields to ECC fields.

Coordinate with business and functional team data collection and population in data templates.

Lead the data cleansing activities

Work with ABAP team in developing the data upload objects

US BANK, SAP BUSINESSOBJECTS PRINCIPAL CONSULTANT, JANUARY 2016– APRIL 2016

St. Louis, Missouri

Install and Configure SAP BOBJ BI Platform, SAP Information Platform Services, SAP Data Services, & SAP Information Steward on Suse Linux 11.4

Migrated all 3.1 Objects; Webii, Data Services Local, Central and Profiler repositories, Repositories, BOMM to BI Platform 4.2 SP04 and IPS 4.2 SP04.

Identify, develop, create, test, debug, document and maintain data quality scorecards in SAP Information Steward as well as data jobs that will be used to create Stage tables.

Develop and deliver management dashboards that describe the state of master data health across the company.

Assist with developing new KPI's for business processes and data improvement.

Created an ETL process using Data Services which allowed each business user to view all of the Sap Information Steward Rule Failures in one report.

Create an ETL and Dashboard process which automatically performed sentiment analysis on each buyer’s feedback and determine if the feedback was negative, positive, strongly positive, etc…

Utilize Metadata Integrator to view Report Data Lineage across multiple data sources

MOEN CORPORATION, SAP BUSINESSOBJECTS architect, August 2015– JANUARY 2016

Cleveland, Ohio

Install and Configure SAP BOBJ BI Platform, SAP Information Platform Services, SAP Data Services, & SAP Information Steward on Suse Linux 11.4

Configure SAP’s DQM Realtime Address Cleansing with CRM using Data Services Realtime Jobs

Configure Single Sign on Using Kerberos Authentication and LDAP authentication with Windows Active Directory in SAP BOBJ BI, SAP Data Services, and SAP Information Steward using Role Based Access Control (RBAC)

Identify, develop, create, test, debug, document and maintain data quality scorecards in SAP Information Steward as well as data jobs that will be used to create Stage tables.

Develop and deliver management dashboards that describe the state of master data health across the company.

Assist with developing new KPI's for business processes and data improvement.

Create universes using Information Design Tool, created Crystal, Explorer, Webii and Lumira Reports.

Created an ETL process using Data Services which allowed each business user to view all of the Sap Information Steward Rule Failures in one report.

Create Information Steward Business Rules For Customer Master, Material Master, MRO, and Vendor Master.

Created an ETL process which loaded all POS data in SAP BW automatically

Configured CRM Delta Queue to perform delta loads in Data Services in order to decrease load times

Create an ETL and Dashboard process which automatically performed sentiment analysis on each buyer’s feedback and determine if the feedback was negative, positive, strongly positive, etc…

Create a material creation process using Data Services to converts an excel input into an IDOC and post the IDOC in SAP ECC

Utilize Metadata Integrator to view Report Data Lineage across multiple data sources

Graphic Packaging international, SAP businessObjects architect / senior business systems manager, march 2014 – august 2015

Atlanta, Georgia

Using Data Services To Perform BW, SQL, & Excel data extraction, staging, transformation, loading, and query development

Integrated Salesforce with SAP ECC using SAP Data Services

Install and Configure Lumira 1.25 on SAP BusinessObjects for Reporting Purposes

Create Lumira reports in the SAP cloud for mobile device use

Creating Design Studio Reports

Performed End To End Migration of SAP Data Services and Information Steward Jobs & Projects from Windows/Oracle environment to a SAP Hana Cloud Environment.

Install and Configure SAP BOBJ BI Platform, Information Platform Services (IPS), SAP Information Steward, SAP Data Services, SAP Data Quality Management (DQM) with CRM

Setup SAP BOBJ single sign-on using kerboros on both LDAP and Active Directory on Both Linux and Windows using Role Based Access Control (RBAC).

Integration SAP with using Webservices and Salesforce adapters using SAP Data Services.

Automating the entire Material Master, Customer Master and Vendor Master process using IDOCs.

Automate SAP Information Steward Cleansing Process For Material Master, Customer Master and Vendor Master.

Building BOBJ universes, creating SAP explorer, webii and crystal reports

Creating Qlik Sense & Qlik View reports.

Developing and architecting data integration, data management, and data quality services solutions specifically utilizing BusinessObjects Data Services

Connecting BODS to BOOMi in order to decrease data errors

Using BusinessObjects Data Services platform products (Data Integrator, Data Quality, Information Steward, and MetaData Manager)

Coordinating with employees to map existing legacy system data and structures to the SAP ERP system.

Create Information Steward Business Rules For Customer Master, Material Master, MRO, and Vendor Master.

Leading the ETL design and implementation process using a variety of legacy systems, integration, and cleansing of data before loading into data warehouses.

Designing financial management and planning metrics and analytics; including analyzing the business requirements for the financial applications, analysis of accounting and finance rules and practices, documentation of financial requirements, design and build of data models, and building the resulting analytics/metrics

Creating WinShuttle Designer to create forms and to perform SAP changes.

Setup And Automate The Information Steward Match Review Process

Nexeo Solutions, SAP SOLUTION ARCHITECT, January 2014 – march 2014

The Woodlands, Texas

Integrate, Profiling, and Data Quality with Information Steward

Effectively used Data services usage for SAP data migrations (ECC, BW) both as source and target systems

Experience using out of box Data services capabilities in SAP space i.e. best practice usage and standard template utilization for data mapping

Create User Defined Transformation in SAP BODS using Python.

Experience in building quality scorecards using Information Steward

Hands on experience in building data cleansing packages using Cleansing Package Builder of Information Steward

Migrate Vendor Master and Customer Master from a SAP ECC 6 to a SAP Cloud ECC7 Instance Using Sap Data Services

Migrated Crystal, Explorer, Webii, and Lumira Reports.

mmg., SAP SOLUTION ARCHITECT, SEPTEMBER 2013 – January 2014

Melbourne, Australia

Extract, cleanse and map data from Pronto & SAP to a SAP Clould system using SAP Data Services version 4.1

Transform data from various data sources to a common format load file (LSMW or iDOC or BAPI) or any other pre-defined formats.

Setup and Automate the Migration Process Using SAP’s Best Practices for Data Migration (BPDM) Data Services Jobs

Test scripting as developer and peer reviewer and test scenarios.

Manage and provide guidance to a team of 2 offshore resources.

Conduct data mapping workshops from source to target SAP systems with client personnel, peers and techno-functional consultants rating good customer facing communications/skills.

Creating WinShuttle Designer to create forms and to perform SAP changes.

Implement processes using LSWM, BAPI and IDOCs which migrated BOM, Material Master, Customer Master, Vendor Master, Recipe, Task List, Maintenance Plan, Classification, Characteristics, Functional Location, WorkCenter, Equipment, Material Master, Long Text, Purchase Order, etc…

Work effectively with limited direction, including engaging with business and technical personnel to get information and influence prompt reviews.

Work directly with clients to validate requirements for cleansing and standardizing existing legacy master data and provide custom configurations in unique environments.

Perform and publish data health assessment reports which use Business Objects Data Insight to perform data profiling on source systems to assess legacy data quality.

Design and implement data parsing routines for extraction of attribute data from the source systems.

Design and implement data standardization and validation routines to improve the data quality prior to migration

SAP MIDDLE EAST, BUSINESS OBJECTS ARCHITECT, JULY2013– SEPTEMBER 2013

Doha, Qatar

Reviewing SAP Business Objects (WebI, Dashboards & Analysis) along with Data Services 4.1 design and provide recommendations.

Assess solution design to evaluate business needs fit

Evaluate flexibility, efficiency, completeness, and maintainability of the solution design

Consider whether the proposed solution is in line with SAP standards and best practices

Provide assessment and recommendation of the impact on solution design and completeness

Detailed report of findings and recommendations

SAP America, SAP BOBJ CONSULTANT, JULY2011– JULY 2013

Atlanta, Georgia

Facilitates the technical implementation, upgrades, and ongoing support of SAP products and processes to enhance the value that customers receive from their SAP solutions.

Business Objects report development (Web Intelligence, Crystal Reports, etc.)

Moving Data between Hadoop big data lakes into SAP Hana using Sap Data Services.

Installing and Administer SAP Business Objects Data Services, Business Intelligence Platform as well as Information Platform Service with SSO using Kerberos Authentication.

Experience in installing, implementing, and administer SAP Information Steward: Experience using Data Insight, Meta Data Management, Cleaning Package Builder, and Metapedia.

Assumes a lead role in the implementation process and creates value for SAP customers through the enhancement of the customers’ business functionality and overall system performance.

Maintain a high degree of customer satisfaction in each of their accounts and growing and developing reference able customers through their investigation, analysis, consulting, coaching, knowledge transfer and relationship building efforts.

Assume primary responsibility for solving customers’ technical issues by providing technical expertise, project planning, guidance and instruction on SAP solutions and business processes (System Consultant & Development Consultant).

Analyze customers’ technical requirements and systems infrastructure (e.g., system architecture & landscape design) and provide support in the areas of database administration, SAP product installations, upgrades, SAP administration (e.g., Correction Transport Management, back-up/recovery procedures) change management, performance tuning and overall technical consulting assistance (System Consultant).

Building ER Diagram and Load Processes in Order To Load Computer Associates Identity Management System

Architect and Create Data Models For SAP HANA and create an ETL Cleanse Process Using SAP Data Services to Load This Data from SAP BW & Excel Files into SAP HANA

Create SAP HANA Models and views for reporting

Support customers with the development activities including data conversion, interface development, reports development, forms development, enhancements and custom transaction development, workflow, EDI, i-Docs, etc. (Development Consultant)

Maintain high degree of knowledge/ understanding of SAP technologies, business processes and solutions, keeping current with release levels and industry issues; prepare training materials and instruct technical classes as needed; and coaches/mentors (System Consultant & Development Consultant).

Installing Design Studio and creating Design Studio Reports for the BusinessObjects BI Platform

Experienced in building data models for SAP HANA Databases and creating SAP Data Services ETL and ELT processes.

Create universes using Information Design Tool, created Crystal, Explorer, Webii, and Lumira Reports.

AMERICAN EXPRESS, SR. Programmer Analyst, June 2006 – July 2011

Atlanta, Georgia

Managed a team of 8 people; configuration engineers, implementation engineers, and QA in the United States and in India

Created customized SAP PI and SAP Business Objects Data Services 3.2 and 4.0 configurations for each SAP client

Implemented and streamlined an implementation process that resulted in timely and accurate deliverables

Create training program and manuals for incoming engineers to create a well-rounded and talented team

Experience configuring SAP Process Integration configuration and debugging

Ability to handle on-call duties in a 24/7 environment

Installing and Administer SAP Business Objects Data Services 3.2 & 4.0 BI Platform

Implementing new J2EE code, store procedure and database package enhancements on a $7 billion dollar platform.

Implemented over a $3 billion dollar in charge volume for American Express' BIP platform

Create complex queries and store procedures for both SQL and Oracle databases

Use both InformaticaCDE (B2B Data Transformation), Power Center and Data Junction/ Pervasive Data Integrator ETLs to read data from its source and format it uniformly and write it to the target repository for exploitation

Manage file transfer environments: UNIX servers, SFTP servers, manage file transfer user accounts, primary system/network

Create universes using Information Design Tool and Universe Design Tools to created Crystal and Webii reports.

Administer multiple platforms with proficient knowledge of UNIX systems

Resolve processing/scripting in shell, java, perl, or related

Create complex scripts that queries databases, generate reports, sends email notifications, send files via FTP, SFTP, and NDM

UNIX - commands, file movement, AWK, GREP, FIND

Network administrator / troubleshooting

Windows 2000 & 2003 server administration

Understanding of file transfer protocols, PGP, GDP

Monitor operational activities on the on multiple platforms

Resolve processing errors on multiple platforms

Deploying and maintaining of Linux and windows Servers

LEX BUSINESS SOLUTIONS, EDD CONSULTANT, DECEMBER 2003 – june 2006

Atlanta, Georgia

Provide project assistance to six employees EDD production, including: budget control; production timetable, status reporting, client/project coordination, and quality assurance

Create complex queries for data extraction and data conversion

Create concordance and summation load files

Electronic Data Discovery using IPRO as an ETL tool to perform uploads, snapshots and data processing

Contact this candidate