Sap ABAP Consultant

EDUCATION:

B.Sc. - Education (Ohio State University)

CERTIFICATIONS:

SAP R/3 - ABAP/4 Coding, SAP Business Information Warehouse 4.0,

SAP XI 3.0, R/3 ASAP Methodology

SAP EXPERIENCE / SUMMARY:

John is a certified SAP Technical Analyst with 18 years of ABAP/4 R3 3.0x, 4.0x, and 6.0 experience included in a total of 40 years of Information Technology experience. He is also certified in BW 4.0, XI 3.0, and the SAP ASAP methodology. For 7 years he has worked extensively in the Industry Solution-Utilities Customer Care System under 4.0B and 4.6C and 6.0. CCS work includes conversion programs; custom screens, user exits, reports including ALV reports, and interfaces with other non-SAP systems. Interface strategies include the use of custom inbound and outbound IDOCs, XI middleware integration, Remote Function calls, IDE, and BAPI technologies. Several of these enhancements to CCS involved the use of SAP’s object oriented technology.

He has been through eleven complete and successful SAP implementations, six of which were for major Electric, Gas, Water and Waste Utilities on ISU/CCS and five were in the core SD, MM and FI modules at major manufacturing companies. One was with the U.S. Army on their Medical Material Logistics System in the Public Sector arena. Another Public Sector assignment involved doing Sustainment on the Deployment 1 SAP systems for the U. S. Department of Agriculture in Washington DC.

He has worked for the U.S. Army at Fort Detrick Maryland on two different occasions and has the necessary military security clearances for such assignments. On the first 6-month assignment he participated in the Technical Blueprint for Phase I of an SAP implementation for medical material logistics for the Iraq and Afghanistan military engagements. The second two-year assignment involved Sustainment (maintenance) of the Phase I production modules.

He is also worked for Accenture at their Deliver Center in San Antonio. During that period he has been the Technical Team Lead in charge of a team of ABAP Developers doing O&M (maintenance) for the Deployment 1 SAP System at the U.S. Department of Agriculture in Washington DC. He also did some sustainment work for the US DLA (Defense Logistics Agency) which provides war materials and equipment for our Armed Services personnel in the war theatres in Iraq and Afghanistan.

His primary experience in the core SAP system has been in the SD modules but also has experience with the MM and FI/CO modules and Industry Solution-Oil. One engagement utilized Industry Solution-Telecommunications where he also gained experience with the SAP modules CRM and RM/CA. Another engagement was with a multinational electric products manufacturing company and an aircraft manufacturing company.

He was engaged with a county government organization in Atlanta where he was the Conversion Team Lead on a CCS project for water billing using the SAP Product ISU/CCS. While there he led a team of 10 conversion developers and configured the SAP ISU/CCS conversion tool EMIGALL and also developed numerous ABAP ALV reports on the CCS data.

Another engagement was with Waste Management in Houston. They were implementing the ISUI/CCS modules for their international Waste Collection businesses. For the first pilot deployment he completed 4 interfaces to third party systems including the development and configuration of the XI middleware objects for these interfaces. He also developed 13 ALV reports for the first deployment.

His third last engagement was with a Military Aircraft Manufacturing plant in Dallas Texas. They went live with their SAP implementation on May of 2011 and have subsequently accumulated over 400 system maintenance tickets. He worked on a 4 person SWAT Team to resolve and complete the majority of those maintenance tickets. At the end of the engagement the Team reduced the ticket count to fewer than 100.

His primary SAP strength is in batch and real-time interfaces, CCS EMIGALL conversions, enhancements, and standard and ALV reports. He has interfaced CCS to MDSI’s Mobile Data and Order Scheduling Systems, Siemen’s Outage Analysis System called DMS, Paraphonic’s IVR system and deregulated utilities through IDE using IDOCS and XI middleware. Besides his Public Utility experience he has Public Sector experience with the Federal Government and Manufacturing company experiences. He has vast and mature analytical, business, and communications skills. He is motivated, seasoned, and believes in the value of teamwork.

In 2004 he obtained certification in Business Information Warehouse 4.0. This 5-week course included training in the creation of Data Sources, Transfer Rules, Info Sources, Update Rules and Info Cubes for Master Data, Transaction Data, Text and Hierarchies. Data extraction from R/3 using the Logistics Cockpit and data extraction from R3, flat files and external systems were covered. BW Reporting using the Business Explorer Analyzer to produce Excel output and the Business Explorer Browser to produce HTML output were also covered. In 2005 he obtained certification in SAP XI 3.0 and has utilized that training on two different engagements.

SAP EXPERIENCE:

Consultant

U.S. Army LMP Project, Marlton, New Jersey 1/2014 to 3/2014

Developed a custom screen which allows Users of CJ020N (Project Systems) to store multiple Milstrip Numbers (Standard Document Numbers) per Project Number.

I subcontracted to CSC on this project and obtained a Trusted Public Employee security clearance from the Department of Defense.

Consultant

Pepco Holdings, Newark Delaware 4/2013 to 11/2013

Consolidating three legacy Electric and Gas Systems into one ISU/CCS System. This project called Solution 1 standardizes and modernizes the processes for all three of their Electric and Gas Utility companies.

I rewrote the SAP Manual Billing program so that it would be easier to use than the delivered SAP program.

Collected and summarized hourly Itron readings using Web Methods that request and deliver Itron meter readings from their IEE system for the purposes of allowing the Bill Print program to print daily consumption graphs on the Electric and Gas bills. Part of this was done by developing an PI ABAP Proxy method that updates the custom table.

Developed an ABAP Proxy method which request meter readings from Itron for customers who sell their excess generated electricity back to the Electric Company. These negative readings are stored on a custom table and produce a credit line in the Bill Print program. The process is part of a larger process called Dynamic Pricing.

Consultant 10/2012 to 01/2013

Consumers Energy, Jackson Michigan

.

Subcontracting to Accenture on a four month project at Consumers Energy to interface the Meter Readings from their new Smart Meter System to the SAP ISU/CCS Billing System.

My program receives the Bulk Meter readings sent from the AMI System to SAP via PI and manipulates the Meter Reading Dates and Times in a BADI according to the Functional Spec requirements and then posts the Meter Reading results which are later in the SAP Billing System.

Unit testing on my first module is complete and end-to-end Functional Unit testing will continue until 04/13.

Consultant 09/2011 to 09/2012

Triumph Vought Aircraft Company, Dallas Texas

Employees at the Jefferson Street facility build and assemble integrated airframe systems for military and commercial aircraft programs.

Currently working with a SWAT Team of four Contract Developers with the assignment to reduce the current backlog of 400 maintenance tickets down to a manageable level.

We have reduced the backlog of maintenance tickets significantly. As of 9/1/2012 we have reduced the ticket volume to 130 tickets.

Work included fixing existing bugs, enhancing functionality and developing new reports and processes.

Here are some specific examples of my work:

oAdded 2 new fields to the existing XI/PI middleware for the interface between their legacy MES System (Manufacturing Execution System) and the SAP PP (Production Planning) System for Production Order factory operations.

oCreated 2 new XI/PI interfaces for the Month End contract labor Accruals and Reversals coming from PeopleSoft for posting Accrual and subsequent Reversal labor charges into the SAP General Ledger. This was required because the Union Contract labor was paid every week and the Vought Employees were paid every other week, so these two new interfaces were required for Contract labor processing.

oCreated a custom table and generated a table maintenance dialog to capture PM order customer relief dates for subsequent extraction in to the BI/BW system.

Developed a new ALV Non-Production Shortage Report for the Procurement-to-Pay group.

Modified the Select Options on the ZSHPRT report to not be case sensitive.

Developed a new ALV Early/Late Purchasing Document Shipping Report for the Procurement-to-Pay group.

Made several changes to Production Order User Exits to ensure that all Routing Operations were confirmed before Goods Movements were allowed in the MIGO transaction. This was done for the Production Planning group.

Modified the Order Scheduling program to reschedule Excess and Obsolete Production Orders into the future.

Developed a new Dynpro which allowed for Where-Used and Mass Maintenance on factory routing text fields and codes. This was very helpful to the manufacturing Engineering group who had no way to find which operations had standard texts on them and had no SAP delivered mass maintenance capability to modify these text elements.

Added number of material retests allowed and number of retests done to report LX27.

Reinstated Production Order header status validation on PP orders.

Added an alternate index to the PLPO table to speed up the routing text mass maintenance process.

Stop allowing the entry of direct labor hours on PP order operations with control keys of ZP01.

Developed new ALV report to search for Operation Confirmation texts.

Optimize the performance on the ZMMI_SAP_VENDOR_MES program.

Developed an ALV report to show WorkCentre information for the Hawthorne plant in LA.

Developed a new BOM Browser Dynpro which shows Bill of Material explosions on material from a single plant or material which comes from another Vought plant.

Developed an ALV report that audits the routing control keys for completeness.

Modified PP order User Exit to discontinue the batch printing of material labels for the Nashville plant.

Added 3 new fields and 3 new Select Options to the ZRWM_INV_VAL report.

Updated the SAP COOIS transaction in a BADI to add 2 new fields to the Confirmation and Routing reports.

Modified report ZPO_CNTRLKEY to ignore operations with a status of Delete.

Added alternate index to the LTAK table to speed up the performance of the LZ_WM_PP_SHORTAGE_TO_CHECKU01 module per recommendations from SAP.

Permanent Employee 1/2009 to 08/2011

Accenture Health and Public Services, San Antonio Data Center

Technical Team Lead for the maintenance of the Deployment 1 SAP Systems at the U.S. Department of Agriculture in Washington D.C.

oLead a team of two Developers: One at the San Antonio Data Center and one in DC.

oEstimate, schedule, and manage the completion of Change Requests for break/fix and enhancements.

oMy team has completed about 70 change requests mostly on time and on budget and with high quality and little re-work..

oI mentored both team members, did their code reviews, and get them all the training that they needed to improve as Accenture Consultants.

oI proposed a dual landscape environment so that the RICEFW Team could work on the Deployment 2 programs while my O&M team could maintain the Deployment 1 programs simultaneously. I also successfully managed the synchronization of the changed modules between the landscapes.

oSince I was a Technical Team Lead, my team did most of the program modifications. However, below are some of the modifications that I made myself:

I made a custom version of the SAP program SXMB_MONI which looks up XML messages coming to and from XI/PI. The enhancement I made was to allow the User of the program to select specific contents within the XML which speeded up their XML search since the delivered program did not have that capability.

I did a lot of research on long running programs and implemented lots of alternate indexes on SAP tables. This was necessary due to the huge volume of the data that the USDA had.

Since the USDA had 21 legacy systems that we interfaced to SAP ECC, they developed a custom table called their Shorthand code table which translated the accounting coding block from their legacy system to the SAP Public Sector financial keys. Since one of the USDA divisions that we brought on to the system converted their Shorthand Codes wrong, I was involved in a very long clean-up process which ended up being completely successful. You can see a lot of transports below that have the word "Shorthand" in them.

When we added the USDA Forrest Service Agency to the system there were so many Forrest Service employees that our Payroll interface execution time increased from one day (24 hours) to 5 days and 1 hour. This was such a big problem for the USDA that we had to report our progress in speeding up this posting run to the Under Secretary of the USDA on a daily basis. I designed a solution which called for the parallel processing of the Payroll Files in 5 Batch Processes instead of 1 which brought the total time of the run back to 24 hours. I designed the parallel processing solution, wrote the specs for my ABAP Team, oversaw the testing and coordinated the implementation of the changes. The project was completely successful.

I made changes to the custom Corporate Lockbox validation program.

I put a wrapper around the Vendor Load program so that multiple files could be processed in the one run of the program.

Also a lot of my time was researching production short dumps which usually came from bad data and didn't need production program fixes and transports.

Consultant 07/2007 to 07/2009

U.S. Army Medical Material Agency, Fort Detrick Maryland

Completed 30 Sustainment (maintenance) assignments on the Army’s SAP TEWLS System.

oAssignments varied from some problem resolutions that were of very short duration to some major system enhancements that took several months to complete.

oAll assignments were completed on time and on budget.

oSamples of maintenance orders completed:

Excess quantity is overwriting requirement quantity in outbound IDOC.

Dumps in production from transaction ME59N.

Add error message for C2L IDOC processing.

NAC records from TAMMIS System create failed IDOCs.

Inbound DJ7 IDOC posts incorrect quantities in certain cases.

AS ship status (EDI 856) is not posting for Non-stock.

Change logic for Order Release Strategy.

Order Cost Analysis Report.

Source List creation for plants ASB7 and ASU2.

Status change on custom table ZUF_CCSSF_SF,

Report ZM32 incorrectly lists BOM components.

Consultant 12/2005 to 07/2007

Waste Management, Houston, Texas

Developed four interfaces to and from SAP to various Third Party systems.

oOne interface involved the sending of the print images to an external printer for returned check letters. I also developed the XI development and configuration objects for this interface.

oOne interface involved extracting collection stops information from specific collection routes and sending the spreadsheets to a Vendor’s website so that these customers could be notified via Autodialer that their collection was cancelled due to vehicle problems.

oOne interface involved posting SIC and NAICS codes to a custom table in SAP for specific Contracts via a Third Party data service. I also developed the XI development and configuration objects for this interface.

oOne interface involved extracting data from the major CCS tables to support a Service Center in New Mexico, which was not allowed access to the SAP System. The data supported custom inquiries that were developed in MS Access.

Developed thirteen ALV reports

oCash Posting Report

oPayments by Type of Payments Report

oPayment Lot Summary Report

oRefund Simulation Report

oUpstream Billing Report

oA/R Aging Detail and Summary Reports

oLandfill Debit Memo Report

oLandfill Ticket Report

oPrice Increase Validity Report

oElectronic Invoice Report

oRecovered Write-Off Report

oPotential Cut-Off Write-Off Report

oRefund Simulation Report

Consultant 5/2005 to 12/2005

Gwinnett County Government, Atlanta Georgia

Serving as Conversion Team Lead for the conversion of the legacy system data to the SAP ISU/CCS system for Water Billing for all of the residents of Gwinnett County, which is North East of Atlanta. SAP’s EMIGALL conversion tool is being used for this conversion.

EMIGALL conversion objects include: CONNOBJ, PREMISE, MRU, INSTLN, FACTS, DEVLOC, NOTE_DLC, DEVCAT, DEVICE, DEVINFOREC, INST_MGMT, METERREAD, CONSUMPT, PARTNER, ACCOUNT, ACC_NOTE, MOVE_IN, DOCUMENT, SECURITY, and PAYMENT.

Developing various ALV reports from the SAP ISU/CCS data.

Consultant 1/2005 to 5/2005

U.S. Army Medical Material Agency, Fort Detrick Maryland

Worked in a team to produce a Blueprint document for the implementation of a SAP system to handle the procurement and distribution of medical material to the front lines of the engagement in Iraq and Afghanistan. I obtained a government security clearance for this work.

Developed technical specifications for 31 interfaces between the SAP system and various other Army systems to synchronize the procurement, distribution, and financials for the medical material in the other legacy Army systems. The interfaces used IDOC and XI technologies.

Consultant 11/2004 to 12/2004

PolyOne Corporation, Cleveland Ohio

Made performance improvements to the online Delivery list, transaction VL10, by rewriting the data selection code in the user exits.

Added Authorization Objects to 45 ABAP programs to secure programs against a company that was being spun off in a divestiture but continues with computer support from PolyOne.

Redesigned security tools for the Security department. Custom modules were developed to enhance and simplify SU53 and SU01 processing. Enhancements included sending emails to approvers asking for approval to allow particular users to have a requested transaction codes be added to their profile. The adding of particular roles was also enhanced in a custom version of SU01.

Enhanced the purchase order receipt process to not update the material evaluation table for “free” goods received.

Enhanced a “where used” material report to properly display the consumption amounts from the bill of materials.

Consultant 7/2004 to 11/2004

Cooper Industries, Houston, Atlanta, and Syracuse New York

Developed an interface between SAP and an external shipping planning system named ClipperShip for the LaGrange Ill. plant.

Developed an interface between SAP and an external Special Pricing Arrangement management system named SPA. Debit and Credit memo requests from special customers are received by the SPA System and posted to the SAP system. Daily and Weekly data is extracted from SAP and sent to SPA for their subsequent updating.

Developed an interface between SAP and an external system named PanPro that manages the warehouse inventory levels of the company’s external stocking agents. The system is a one-way interface that recalculates all open SAP shipment backlog levels involving Stocking Agents and updates the PanPro System with daily backlog amounts.

Developed a conversion program that converted and reprocessed errors for the three major pricing condition types. The 600,000 pricing conditions were converted successfully in the available conversion time window.

Developed two Sales Backlog Forecast reports for the various corporate plants.

Consultant 3/2004 to 6/2004

AT&T, Morristown, New Jersey

Developed a mass Dunning Block program that applies dunning locks to a large number of customers in the event of a natural disaster.

Developed modules at the appropriate RM/CA user exists that would cancel multiple interest charges and recalculate one interest charge for the entire period.

Wrote a data comparison program that compared the Business Partner and Contract Account data between the CRM system and the RM/CA system that helped reconcile the synchronization of these systems via the SAP middleware.

Developed exit modules that produced the KONTL accounting key for On-Platform Fee charges in the RM/CA system. This was necessary for a subsequent interface to their existing general ledger system.

Populated 10 custom tables in their SAP system with an open SQL interface from the corresponding tables in their legacy Oracle system.

Developed several ALV reports.

Consultant 12/2002 to 11/2003

United Illuminating, New Haven CT

Developed interfaces, user exits, conversions and custom reports for an October 2003 CCS “go-live”.

Completed an interface from CCS to an Outage Analysis system using custom IDOCs.

Developed user exits for CCS Budget Billing.

Converted legacy Streetlight data into SAP Functional locations and Equipment records.

Developed various custom ABAP reports.

Consultant 4/2002 to 11/2002

Greater Pennsylvania Utilities, Reading Pa

Performed a 6-month Production Support contract for GPU.

Duties included solving production problems with the SAP CCS Front Office, Billing, and Reporting.

I developed several new reports as assigned.

I executed and monitored many production jobs that required manual submission and parameter changes.

Consultant 9/2000 to 2/2002

City Public Services of San Antonio, San Antonio Texas

We completed the development phase of the CCS project and successfully completed integration testing for the July 2002 go-live. Development activities included gathering detail requirements, writing technical program specifications, and developing and testing ABAP code. I had overall responsibility for all interfaces between CCS and the new Siemen’s Outage Management System being installed at CPS. Included in the Outage interface is an interface to Paraphonic’s IVR system for outage callbacks. I also handled the customer notification processing for Planned Outages. Another major interface I completed produces credit memos in SD for refunds to builders for Mainline Extension Refund Contracts. These refunds are interfaced using a workflow that is triggered when customer meters are installed. Other responsibilities included designing and implementing the Texas Drivers License move-in name validation interface to CCS Front Office and the implementation of the MDSI OSS (Order Scheduling System) interface between CCS Front Office and MDSI. All interfaces were implemented using IBM’s MQSeries middleware. I also implemented user exits that provide Front Office with move-in screen default values during the creation of Contract Account and Contracts. I’ve completed several CCS Budget Billing enhancements. These including a custom budget billing simulation and plan creation screen for Front Office and the automatic creation of installment plans for budget billing customers who have a balance forward of more than $25 at the time of the annual renewal of their budget billing plans.

Participated in and completed a blueprint-estimation project for the implementation of CCS, FI, MM, and Work Management for CPS. My part was to define and estimate the programming effort to convert and implement all CCS interfaces, conversions, enhancements, and reports. The project was completed on time and a fixed bid estimate was delivered to the client for the implementation phase. The CCS project will include the conversion of 750,000 gas, electric, and solid waste customers to CCS. Interfaces will include CCS interfaces to the MDSI System for mobile data, the Itron System for meter readings, and NCR equipment for remittance processing. Extensive enhancements are planned for the IVR (Interactive Voice Recognition) system in order to handle improved automated customer call responses. Plans were also established for customer inquiry and processing via the Internet using SAP’s ITS (Internet Transaction Server) feature of SAP 4.6. The ASAP methodology was used to create the blueprint and specifications for the project.

Consultant 03/1998 to 05/2000

Reliant Energy, Houston Texas (formerly called Houston Lighting and Power)

Worked on the Customer Care module of the SAP Industry Solutions/Utilities system. Reliant Energy owns the electric utility company in Houston and gas utilities in Houston, Shreveport, and Minneapolis. We fully implemented all billing and customer service functions for the 700,000 customers of Arkla Gas in Shreveport. Emphasis then turned to implementing CCS for the newly deregulated electric markets. We then implemented deregulated billing in the Atlanta electric market using CCS. Future plans call for implementing the system for the deregulated Texas market and the other regulated electric and gas subsidiaries owned by the company.

The team obtained approximately 3 months of training on the IS/U Customer Care modules. This is new SAP functionality and Houston Industries was the first customer shipment of this product. We were on release 1.1B of Customer Care and release 4.0B of SAP. We worked closely with the Customer Care developers in Germany to ensure that the new releases worked properly and problems were resolved.

Developed many conversion programs to populate the system with Arkla legacy data.

Developed many reports, spreadsheets, and user screens for use with the CCS Front Office subsystem. Several of the custom enhancements to the Front Office system were implemented using SAP’s object oriented technology.

Developed both inbound and outbound interfaces to other system using custom IDOC and BAPI technology. One of inbound interfaces utilized SAP’s IDE technology to exchange deregulated electric customer information between participating Electric Utilities.

Developed a custom ABAP program that calculates and updates a daily price for Weather Normalization for Arkla Gas. This daily price factor is calculated based on the customer volumes and price factors and daily average temperatures per geographical weather area.

Developed a custom ABAP system for Utility budget billing for the electric and gas companies.

Developed SAP remote function calls that interface with an external Voice Response Unit that handles customer telephone inquiries.

Consultant 8/97 to 2/98

PENNZOIL, Houston TX

•Developed 20 ABAP/4 conversion programs to convert all of the SD and MM data from one company/sales organization to another. Converted customers, vendors, material, prices, contracts, credit data, and open accounts receivables.

•Developed ABAP interfaces from SAP's customer maintenance and material maintenance programs to synchronize this information in a data warehouse. The process used the user exit in the Customer Maintenance program (SAPMF02D) to capture file maintenance transactions to a custom SAP table that was later used to drive the nightly extract program.

•Extended the standard SAP Sales Orders Blocked for Delivery Report (RVSPERAU) for additional data fields.

•Repaired the standard SAP Contract Add program to allow copy with reference from a different plant.

•Developed seven petroleum exchange reports.

•MM/SD Phase II "go-live" occurred on schedule in January 1998.

Consultant 12/96 to 8/97

AMERADA HESS, Houston TX

Developed and executed ABAP conversion programs for their SAP I/S Oil installation. Areas converted include bank information, joint operating agreement data, joint venture data, and cost centers. Conversion data came from their mainframe systems, Access databases and Excel spreadsheets.

Developed interfaces from the mainframe legacy systems for their account receivable feed into SAP.

"Go live" for I/S Oil SAP was set for 8/97 and all efforts were completed on schedule.

Consultant 10/95 to 12/96

COMPAQ Computer Corporation, Houston TX

•Developed ABAP/4 BDC and custom file data loading programs for the SAP Voyager system.

•Performed troubleshooting of production problems and developed various ABAP/4 diagnostic, repair, and report programs.

•Developed a series of ABAP on-line programs to facilitate mass file maintenance changes to the databases.

•Developed programs which extract data from the SAP database using ABAP/4, merge and match tables using C++ applets, load reporting data back to the database using ABAP/4 and report the data using ABAP/4 interactive reporting and on-line facilities. This was called COLAR reporting.

•Developed interfaces between the custom planning system and the standard SAP system.

NON-SAP EXPERIENCE:

SEVERN TRENT SYSTEMS, Houston TX 04/92 to 05/95

Modified company's Computer Utility Billing Information System package.

Gathered system modification requirements at customer's location and customized the package per those requirements, including analysis, design, programming and testing.

Led an analysis and design team including recruiting and supervising four contract programmers.

HOUSTON LIGHTING AND POWER, Houston TX 01/89 to 04/92

•I worked on a feasibility study and conceptual design for an integrated IDMS Work Management System.

•I used Rapid Application Development (RAD) techniques to develop a complete system using IEW, APS, MICROFOCUS COBOL WORKBENCH and XDB case tools.

•Maintained the Total Work Order System (TWKS) to handle all engineering work orders for the company.

ENRON GAS PIPELINE GROUP, Houston TX 06/84 to 01/89

Designed and developed an integrated Gas Purchase Management System for four pipeline companies using structured analysis, design and CASE tools.

Recruited and led four member team which handled all maintenance responsibilities of Reserves, Contracts and

Contact this candidate