Data, SAP, SQL
Resume:
ERIC W. ANONSEN
***** ******* **. ***. *** Spring, Tx. 77389
******@*****.***
Professional Summary
Over twenty-eight years of experience in information services in analyzing and developing custom applications on SAP, Mainframe, and Unix platforms with a strong emphasis in Master Data and Data Governance in SAP and SAP Retail. Over twenty-two years of experience in SAP R/3 environment developing functional specs, technical specs, enhancements, interfaces, and custom reports in SAP R/3 environment and providing post production support. Proficient in SAP R/3, ABAP/4, MySQL, Access DB, Cobol II, SQL, JCL, and Micro Focus Cobol. Familiar with UNIX and IBM 3090 MVS operating systems. Solid background in computer science, software engineering, and database management. Interested in management, software design, application development, computer system analysis, support and consulting in the SAP R/3 environment.
EXPERIENCE
SAP S/4 HANA, SAP BODS, 1610 SAP DBM, SAP IS-Oil, SAP Retail, SAP ECC 6.0, GTS, FI/CO, SD, MM, and PS Modules, SAP CRM 3.0, and IDOC mapping to X12 EDI standards
ABAP/4 Programming, BAPI, BADI, Custom reporting, Interactive reporting.
. Interface Development for both inbound and outbound to SAP System
. Data Conversions using S/4 HANA Migration Cockpit, LSMW, BDC batch sessions, and Call Transaction processing.
. Data Conversions using tools Mercator, and Winshuttle.
SAP TRAINING
SAP related training:
SAP Retail Overview SAPIRT, October, 2006, St. Ingbert, Germany.
SAP Retail Master Data IRT310, December, 2006, Newtown Square, Pennsylvania.
ABAP Delta class – October, 2001, KDC SAP Center in Dallas, Tx.
Application Interface (AI) interface tool by Andersen Consulting at Celanese, Ltd., Dallas
UPI interface tool by Deloitte and Touche at Dr. Pepper, Dallas, Tx.
Mercator Data Mapping tool by TSI International Software Ltd., 1998, at TSI training center in Boca Raton, Fla.
Dialog Programming by Deloitte and Touche at IT Services, Inc.
Internal SAP/R3 Courses at Lennox International, Dallas:
BC170
BC180
BC190
EDUCATION
BBA in Information Systems 1991
University of Texas at San Antonio (UTSA).
PROJECTS
April 2017 to May 2020 Stefanini Group
Consultant - ExxonMobil
The Woodlands, Tx.
Data Engineer.
Responsibilities include:
Managing and defining data solutions for internal ExxonMobil projects.
Designing and modeling databases using ER/Studio for internal projects utilizing a multitude of tools like Access, SQL Server Management Studio, Tableau, SAP Business Objects Data Services (BODS), etc.
Received EBX by Orchestra Networks Data Management Software Training
Received Python Training
Data Lead on Project to de-merge Company Code for all Retail Locations in Germany. Physical Business locations moved to a Branded Wholesaler model and the country was split into 8 regions and 11 company codes from just 1.
Data design lead to move SCADA Pipeline readings from an ACCESS DB to a new SQL Server DB. I created the data model in E/R Studio and built the new DB in SQL Server Management Studio. I created 3 new forms in the ACCESS application and linked to SQL Server with ODBC.
Data lead on new Sales Opportunity application in Salesforce which is taking over from existing Seibel CRM system. Data from the Seibel system and from SAP is staged in a Data Hub and views created in SAP S4 HANA to feed the data through the Mulesoft ESB to the Salesforce tables for Products and Accounts.
Created multiple BODS Jobs with over 700 Workflows to pull SAP ERP tables’ data and write to SQL Server Database for Auditing Group.
.
November 2016 to February 2017 The Hershey Company,
Hershey, Pa.
SAP Data lead on ERP Transformation Project. Client is moving from SAP ECC 6.0 to Cloud-based SAP S/4 HANA1610.
Responsibilities include:
Managing the creation of Function Specification documents for 87 Migration Objects by the Functional Team.
Managing the creation of Technical Field Mapping documents for 87 Migration Objects by off-shore Development Team in India.
Deciding migration methodology for 87 Migration Objects. Tools being used are SAP LSMW, BODS/IDOC (SAP Data Services), and the S/4 HANA 1610 Migration Cockpit.
Making changes to S/4 HANA delivered Migration Cockpit Objects using the Data Modeler inside the tool for adding fields and/or creating new objects for Hershey’s Migration Objects that are not included in the delivered S/4 HANA Migration Cockpit product.
Assisting Hershey with the mapping of the SAP ECC 6.0 data to the new S/4 HANA 1610 system. This include both the MDG (Master Data Governance) tables inside S/4 HANA as well as the S/4 HANA tables.
April 2012 to March 2016 Rush Enterprises,
New Braunfels, Tx.
SAP Data lead for IS-A-DBM client. Responsibilities included:
Project Manager for roll-out of SAP UEM by KNOA software
Project Manager for rollout of SAP Single Sign-On (SSO)
Data Lead on all Dealership/Branch Go-Lives (every 2 months for last 4 years) for all Master Data loads in all modules, including, assets, customers, vendors, vehicles, parts/materials, pricing types, condition records and procedures, info records, contracts, employees, user id’s, and user security roles, along with all Data Governance guidelines.
Led effort for development of methodology for removing duplicate customers and the way conversions from the legacy system will be done moving forward.
Responsible for converting all Zip Codes to +4 to accommodate roll-out of SABRIX tax solution. Done with MELISSA address standardization program.
Responsible for maintaining Users and User Security Roles through SU01, SUIM, and PFCG.
Occasionally debugging and fixing Enhancement Z-programs in User Exits by coding ABAP changes and modifying Z-tables
May 2008 to May 2009 Westernacher Consulting
AES - Arlington, Va.
Corporate Project Data Lead at Fortune 200 Energy company, AES, in Arlington, Va. I was responsible for developing overall methodology for data migration as well as coordinating the delivery of functional and technical specifications to the offshore teams in Beunos Aires, Argentina and India for all conversion objects as well as time and budget estimates for each. Responsibilities also include writing of all Data Cleansing Procedure documents, and all Data Migration Procedure documents for the methodology approved by the steering committee. I also helped in the data cleansing with the Business Owners of the legacy systems’ data and converting legacy data into SAP Configuration values to prepare the data for the LSMW load programs for the following objects
oGL balances to ECC 6.0
oGL historical balances to BW
oMaterial Master
oVendor master
oCost Center upload
oProfit Center upload
oIntercompany customers
oAssets master data and balances
oHR Organizational data upload
oHR Employee master data upload
July 2006 to March 2008 SAP Retail, Inc.
SAP Retail Master Data Lead at Electronics company, Tweeter, in Boston, Ma. Providing functional and technical specifications to the development team and developing the mapping requirements from the Legacy systems of record to SAP R/3.
SAP Retail Master Data Lead at large Retail company, Luxottica, in Cincinnati, Ohio. Providing functional and technical specifications to the development team and developing the mapping requirements from the Legacy systems of record to SAP R/3. Responsibilities included:
Article Master configuration, conversion, and interface design/mapping/documentation from multiple Legacy systems to R/3 utilizing IDOC ARTMAS05, design/mapping/documentation of Article Pricing conversion utilizing IDOC CONDA01.
Merchandise Category Hierarchy and Merchandise Category design, including Merchandise Category reference article setup.
Site Master configuration including Site Customer records, DC Vendor and Customer records, listing strategy for Articles to Assortments and reference site setup. This includes Reference Site methodology and design for Assortments, Distribution Chains, Logistics & Replenishment, and Purchasing.
Feb 2005 to July 2006 Cap Gemini, NA
Sr. Consultant responsible for leading technical data conversions and interfaces for Retail Master Data team at large SAP Retail 5.0 client, Limited Brands, in Columbus, Ohio. Budgeting, time estimating, and documenting of methodologies were some primary responsibilities. I was also responsible for identifying and documenting, both functional and technical, specifications for FIRECs (Forms, Interfaces, Reports, Enhancements, Conversions) to be sent offshore for development in Mumbai, India. Responsible for developing test scenarios for both offshore, and onshore pre-go-live data migration runs and working with SME’s during data cleansing and conversion phases for identifying and implementing SAP conversion rules. Working with GTS (Global Trade Services) team to design interfaces to load EH&S data (Harmonized Tariff Schedule codes created in Expert Rules and stored in EHS Specification database), Master Data (Articles, Vendors, to the GTS system). Involved in Pre-Entry and Post-Entry design of GTS functionality. I also worked Master Data team to cleanse data and develop LSMW load programs for Open Purchase Orders and Purchase Info Record data using IDOCs.
Jan 2003 to Feb 2005 AMProfessionals
Sales and technical support for VTI Mobile Framework by Sky Technologies (Australia) software written in ABAP and Java. Responsible for generating leads, creating and presenting demos for prospective clients and creating implementation strategies and methodologies.
May 2002 to Aug 2002 Exxon -Fairfax, Va
Technical developer at global CRM 3.0 implementation for large client with pre-configured IS-Oil. Version 4.6 SAP/R3 and CRM 3.0. Responsible for conversions of SAP master data to CRM 3.0 system tables, developing enhancements/ modifications to standard CRM 3.0 functionality, and custom CRM 3.0 reports.
Wrote program to limit order visibility for a contact person based on their valid ship-to relationships from table BUT050. This involved custom function modules making remote (RFC) calls back to SAP R/3 tables to obtain order data for orders on CRM 3.0 tables CRMD_ORDERADM_H and CRMD_ORDERADM_I.
Wrote enhancement program to retrieve order header and item statuses from SAP/R3 tables VBUK and VBUP to be returned to CRM 3.0 system to update order statuses.
Wrote conversion programs to load UNSPSC codes and Viscocity into CRM 3.0 material master.
Wrote custom report to show customers that ordered products that are in their Webshop, but outside of their catalog view.
Wrote custom sales volume and realization report to show quantities/currency amounts of orders for last 12 months by Sold-to/Ship-to customer and product.
October 2001 to January 2002 RPP,
Houston, Tx
Technical lead for Interface development of the world-wide project of Resolution Performance Products. This was a global implementation of release 4.6 in the pre-Configured Client for IS Oil.
Responsibilities were identifying and documenting all interface requirements for the blueprint phase, including estimates for manpower, time, and expense. This included preparing technical documents and flow diagrams for all interfaces. Spent two weeks in Amsterdam, NL gathering requirements and working with process teams to identify currently running interfaces.
October 2000 to October 2001 Citrix,
Ft. Lauderdale, Fl
Responsible for converting Inventory values into SAP using program RM07MMBL to load values as a goods movement with movement type 561.
Responsible for custom reports in the Project System module and CCS system and a user exit for reading billing rates from a custom table and changing net values on the DP90 transaction with a pricing condition. These reports accessed PRPS, COEP, AD01DLI, AD01DLIEF, VBAP, and PA0001 tables.
Responsible for the Material Master conversion. Created a custom ABAP program for converting data values into the format of the direct input program RMDATIND and custom ABAP programs for extending text data into different languages into the MM module.
Designed and programmed interfaces to send and receive delivery and shipping data with a shipping partner. This was done with RFC calls using SAPGUI RFC program startrfc.exe to connect to the SAP system and execute custom function modules which read tables LIKP, KNA1, and LIPS for delivery information and updated deliveries with transaction VL02N.
Responsible for converting customer credit information into SAP using load program RFBIDE00 and transaction FD32.
Responsible for Bill of Materials conversion using the standard SAP load program RCSBI010.
March 1999 to January 2000 Compuware,
Dallas, Tx.
Created custom modification (function) which updates sales document condition rates using a call to VA02 transaction when price was changed on the invoice creation (MRHR transaction). Done on version 4.5B
Core Module change to default a movement reason code in the ML81 transaction when configuration requires a movement reason code with a movement type. This corrected the abending of the transaction when trying to accept the service entry sheet. This work was done for Trust Joist MacMillan. Done on version 4.5B.
Created customized version of layout sets PM_JOB_TICKET, PM_CONT_TICKET, PM_GOODS_ISSUE, PM_TIME_TICKET, PM_OBJECT_LIST, PM_CONFIRM_SLIP and PM_NOTIF_OVERVW for Trust Joist MacMillan to include additional data and change the format. Version 3.1H.
Created customized version of MRP listing report program RMDLDR00 to include Storgage Location, Bin number data, material long text, and Classification / Characteristic Value data. Versions 4.5B and 3.1H.
Created Tax Deduction by payer report driven off tables BKPF, BSEG, and VBRK. Version 4.5B.
December 1997 to November 1998 Celanese Ltd.
Dallas, Tx
Responsible for Material Master conversion. Created an outbound interface to send Material master information from SAP R/3 system to legacy systems using Andersen AI Enterprise Architecture ABAP programs and Mercator data mapping tool.
Created an outbound interface to send Customer master information from SAP R/3 to legacy system using Andersen AI Enterprise Architecture ABAP programs and Mercator data mapping tool.
Created oubound and inbound data maps using Mercator data mapping tool for IDOC’s and EDI requirements.
Worked on various outbound and inbound interfaces between SAP/R3 and legacy systems using BDC programs.
May 1997 to December 1997 Dr Pepper,
Dallas, Tx
Created an interface from legacy system to bring Customer information to SAP R/3 system using XD01 transaction. Led the Customer Master Conversion including requirements definition, technical spec writing, and programming the interface in ABAP.
Created an interface to bring Customer Credit information from legacy system to R/3.
Created conversion programs to convert Customer hierarchy into SAP R/3 system.
May 1996 to May 1997 Lennox International
Dallas, Tx
Created program to convert Vendor master and related data into SAP System
Created program to interface Vendor invoices from legacy system into R/3.
Created program to convert Customer master data into SAP R/3.
Created user exit to determine storage location in delivery processing in SAP System.
Created custom modification to hide certain cost fields on screens.
Programmed and modified various reports, On-Line programs, Layout sets to support user needs.
January 1996 - May 1996 Card Systems,
Dallas, Tx
Worked on development project for transaction level pricing credit card system. Client/Server GUI tool ‘APS’ by Intersolv using SQL Server which was the development platform which was then ported to Tandem for the client.
July 1995 - Jan 1996 Neiman Marcus
Dallas, Tx
Support and Development for the list management systems which reside both on the 3090 (MVS COBOL) and the RISC 6000 AIX Unix boxes. The Unix application utilized Ingres databases and Micro Focus COBOL.
May 1991 - July 1995 Hogan Systems,
Dallas, Tx
Support for the EAS (Earnings Analysis System) profitability measurement software system for large financial institutions by Hogan Systems using DB2 / COBOL II and GUI front end. Responsabilites also included writing custom reports with the CQS Reporting tool. Worked at various client sites in USA, South Africa, Europe, and South America. Assisted in installing, customizing, and training of software.
COMPUTER
SKILLS
Language/Sft: ABAP/4, MySQL, Access, COBOL, COBOLII, SQL, JCL, CQS, Clipper, S-Cobol, Micro Focus Cobol,
Microsoft Office suite, Access, SQL Server Management Studio, ER/Studio
Hardware and Systems :
Client Server Based SAP R3,
HP, UNIX platform using Oracle database
IBM-RS6000
MS SQL Server
MVS 3090
PC and Macintosh
REFERENCES
Available upon request
Contact this candidate