Frank V. Roviello
154 Cider Mill Loop
Wappingers Falls, New York 12590
Home: (845) 430-6906
E-mail: FRANKROVIELLO @ YAHOO.COM
Summary
I am a highly proficient programmer with 11 years experience in SAP ABAP/4 software development. Application design expertise in Sales and Distribution, Materials Management, Financial, Project Systems, Production Planning and Warehouse Management modules. SAP releases 2.2 to 4.7, utilizing ABAP workbench and SAPScript/Smartforms tools. I have years of experience developing and managing software applications with extensive experiences in the total life cycle of a project, from requirements architecture definition, project planning through test and installation. I have strong technical abilities including proficiency in multiple software languages, operating systems and application architectures.
Objective
I am seeking a SAP programming position in ABAP/4 software application development and integration. I desire opportunities to provide technical guidance and contributions through the use of SAP R/3 in support of business requirements.
Professional Experience
August 2004 to Present: SAP R3 ABAP Consultant, Kodak Polychrome Graphics.
Developed various inventory, manufacturing process, supply chain, purchasing, sales and financial applications through the use of reports, dialog screen transactions, Batch Data Communication, user exits, external EDI and batch interfaces. Designed and developed applications for mass updates of manufacturing yields and material characteristics using custom dialogues and BDC sessions. Developed financial ledger updates for employee expense reporting and applications for the analysis and sales order controls of constrained products. Implemented user exits for changing sales order plant determinations, schedule lines and purchase order tax jurisdictions changes. Developed EDI Invoice Modification for inter-company transfers and Check Overflow Printing enhancements. Designed and implemented ALV pricing reports for detail customer analysis by various product hierarchies. My activities required expert communication skills and knowledge of all aspects of SAP R3, functional and technical with high proficiency in the ABAP/4 programming language, data dictionary, function modules, screen painter, menu painter, ALV, SAPScript, Smartforms and SAP Query.
April, 2004 to June, 2004: SAP R3 ABAP Consultant, FMC Corporation.
Supported the installation of a central warehouse distribution of all corporate products. This required detail knowledge of the SAP Material Management module for the design and installation of print programs and SAPScript for a bill of lading based on purchase orders and shipping labels involving various mix of products and handling units. The warehouse implementation also required Quality Management configuration, design and implementation. Included were custom screens for QM notifications with user-exits, function modules and BDC’s to invoke other SAP transactions, SAPSript forms and print programs. Provided Inventory summary data and automated spreadsheets in support of monthly plant level material valuation reporting. This was an significant improvement in how material costs were gathered to minimize manual processing. Provided support to download and upload, via spreadsheets, customer’s pricing information. Creation of ALV based reports for auditing usage of SAP transaction for accounting, purchasing, good receipts and vendor update activities.
March, 2004 to April, 2004: SAP R3 ABAP Consultant, Amareda Hess Corporation.
Developed and implemented a Sales and Distribution billing invoice process that eliminated the need to interface to an external printing application. The process included obtaining images of scanned receipts and merging them with the printed invoice, developed using Smartforms. The process was complicated by the need to expand the SAP Business Document Service to process fax images from a Unix file and convert into bit mapped object. Task included configuration of the billing output types, development of an invoice data formatting program and complete testing of the solution.
March, 2003 to November, 2003: SAP R3 ABAP Consultant, Lucent Technologies.
I Developed solutions to create SAP sales orders from purchase orders submitted by Internet and 850 EDI based Lucent customers; assignment required extensive knowledge of SAP Sales and Distribution processes. Solution included validation of customer purchase order content compared to SAP configuration as well as reference to sales quotes with updates from the purchase orders. The tasks included technical specification development, mapping to a "ProcessPO BOD" for different Lucent customers and all related software development and test. Developed technical specifications mapping specifications and function module to process inbound AckDelivery BOD, derived from an 852 EDI transaction, enabling the update of consignment products via material movement BAPI’s. Created a user interface to provide electronic sales order ship confirmation to selected Lucent customers. Confirmations were captured in user exits associated with releasing SAP Project System ship activities or via posting a ship date directly to a sales order. Tasks included mapping SAP data to end user requirements, setting up SD output condition type requirements, creating enhancements to the SyncSalesOrder BOD, all programming and testing and implementing via Business Connector, accessed using RFC.
November, 2002 to December, 2002: SAP R3 ABAP Consultant, New York Power Authority
I provided development support for updating Material Master Data, text and characteristics, for all materials within the NYPA inventory. Tasks involved data analysis and cleansing, mapping to SAP R3/4.6C using both LSMW and custom code, production support during the update process and follow-up with end users for verification. These tasks required rapid analysis and creation of ABAP code to clean-up and reset material master data.
October, 2001 to June, 2002: SAP R3 ABAP Consultant, Lucent Technologies.
I provided technical leadership for the decommissioning of a SAP 3.1 order management system, Sales and Distribution module, through consolidation with a centralized SAP order management system. Major responsibilities included requirement analysis with end user involvement. Delta analysis with specification development for multiple interfaces, including UNIX scripts, in an Oracle file managed environment, with legacy service management systems. Other activities included reports and Sales and Distribution user exits to synchronize sales orders and purchase order quantities, implementation of financial interfaces for ledger updates and creation of financial reports via report writer/report painter tools. The financial interfaces required both debit and credit transactional updates via BDC programs and internal interfaces with other SAP ledger processing programs. Other development activities included lead technical advisor for all function modules and tables being moved to the centralized SAP instance, Tracking of tasks via Excel and resolution of all problems related to object transports for integration test.
Designed and developed solutions for managing network sales orders via the Project Systems functionality of SAP 4.6C. All tasks included heavy end user communication, creating functional and detail specifications as well as test plans. ABAP activities included creating dialog screen transactions, for maintaining material specifications and text data involving complex table structures, sales order bills of materials and utilizing BAPI interfaces for updating purchase requisitions and purchase orders. Designed and implemented a complex series of function modules for updating actual PS node activities, such as installation data for networked sale orders, via Business Connector BOD interfaces, using RFC to external systems. Developed Inbound and outbound IDOC’s via ALE to distribute transportation costs to multiple sales orders; including partner configuration. I developed an interface to a PeopleSoft application for maintaining HR employee data within SAP.
August, 2000 to July, 2001: SAP R3 ABAP Consultant, Bayer Corporation.
Senior SAP/ABAP Consultant supporting the implementation of SAP R3 Release 4.6B Material Management and Sales and Distribution for the Pharmaceutical Division.
Responsibilities included creation of detail design specifications with heavy end-user communication, configuration for customer master and creation of sales orders and billing documents to support testing and requirement clarification.
I was team leader for the design and development of a solution employing a complex series of processes to keep the SAP customer master current with sale representative data from a legacy system. Designed, developed and implemented an external interface to SAP of a monthly forecast demand for selected products and materials. Solution used both UNIX scripts and SAP programs to synchronize updates. Designed, developed and installed ABAP programs for the efficient initial load of millions of equipment warranty data records. Provided ABAP transaction programs to analyze sales orders and assign to an alternate shipping location to meet demand. I created SAPScript letters for canceling orders due to credit problems, export quotations and proforma invoice documents. Developed application and associated tables for tracking material movements, shipments and availability for foreign trade zone requirements. I developed data mapping and interface programs for sales history data between Legacy system and SAP Business Warehouse. Designed and implemented numerous SAP reports for analyzing product price structures vs. cost for audit requirements, modification of pricing dialogs and allocations for customers. The requirements called for an in-depth knowledge of pricing rules, costs, materials and product BOM’s. Developed and installed numerous solutions for customizing screen edits for sales orders, credit management variants via user exits and SAP table extensions.
March, 2000 to June, 2000: SAP R3 ABAP Consultant, Centocor, Inc.
Senior SAP/ABAP consultant implementing a SAP 4.0 MM inventory management interface between multiple manufacturing locations and a central distribution center. Technical team lead for the design and development of various programs to maintain batch managed pharmaceutical inventories, customer master information and sales information records between SAP R3 and the remote legacy systems at a central distribution center. Coordinated and tested with the external distribution center personnel using numerous test cases to transmit, receive and report inventory, sales and customer master activity. Tasks required extensive knowledge of the MM module, material and sales information structures for problem diagnostics and the ability to customize data and rules.
December, 1999 to February, 2000: SAP R3 Test Consultant, IBM
I developed test scenarios supporting the development of a world wide SAP Sales and Distribution solution with an emphasis on external interfaces to billing, credit and materials support systems. These tasks required extensive skills in SAP SD processes, transactions and customizations. I setup and executed SAP CATT procedures for regression testing. I provided diagnostic support for transactional errors as well as validation of test results for accuracy and audit readiness.
July, 1999 to December, 1999: SAP ABAP Knowledge Transfer, Pitney Bowes Inc.
I developed functional specifications for processing interplant sales orders and vendor purchase orders including IDOC mapping and SAP partner configuration. Developed customized search/help for vendor selection; field exits for material master transactions. Developed solutions within the Production Planning module for capacity load balancing and initial batch data load ABAP programs for work centers and routing information. I implemented a generic BAPI external system interface via ALE. Solution allowed for standard BDC processing for updating SAP master data from an external source. Responsible for training and technical leadership to a team of SAP programmers engaged in the startup of SAP 4.5B. Duties include functional and detail specification reviews associated with SAP enhancements and reports, SAPScript training and data dictionary consultation.
January, 1999 to June, 1999: SAP R3 ABAP/4 Consultant, Acme Steel Company.
I provided ABAP software for SD sales order processing, sales bonus plans using SIS, reports for open order quantities and reconciliation with MRP requirements. I also provided EDI configuration for advance ship notices. I created packing lists via SAPScript including a customer support transaction. I developed financial account receivable reports for open invoice analysis, "lock-box" processing and 1099 forms using SAPScript. I implemented archiving strategies and support for general ledgers, purchase orders and production orders. I development support for HR functions including programs for archiving and retrieving payroll data and report macros. I provided technical direction to other ABAP programmers.
July 1998 to January, 1999: SAP R3 Consultant, IBM Inc.
Design and implementation of ABAP/4 programs supporting Warehouse Management physical inventory cycle counting. I ensured an uninterrupted inventory count cycle after cut over to SAP. I developed ABAP/4 reports and BDC programs for the automatic processing of IM material movements and transfer postings. I provided daily customer support activities and problem resolution of the shipping functions within Sales and Distribution. I provided analysis of material handling procedures, SAP transaction flow and problems moving materials from manufacturing to the shipping dock.
November, 1995 to June, 1998: SAP R3 Implementation Team Leader, IBM Server Division.
I developed the software application architecture supporting the IBM Server Divisions reengineering efforts and the implementation of SAP R3; a $22M project spanning 5 fulfillment and fabricator centers. Project and task planning for all information technology products consisting of legacy system interfaces, data migration programs, batch data communication programs, dialog programs and reports. Test leader for all IT development. Created the testing processes and supportive documentation, established the problem tracking processes and tools, monitored and supported the test case executions. These tasks required coordination of both external interfaces and data movements through the SAP functional modules. Emphasis was on processing orders from an external interface through Sales and Distribution order entry, creating deliveries and shipping. Developed all task plans and controls utilizing tools such as Excel and Project Workbench. Organized the test team, monitored progress and applied corrective actions to remain on schedule. I expanded this role to include the end-user verification and acceptance test activities. Technical approval of functional specifications for SAP R/3 end user transactions, reports and modifications for the integrated supply chain requirements for automatic material replenishment and inventory management. Tasks included technical leadership and approval of general design documents, detailed program specifications and test plans for data bridges to legacy systems, batch processing and SAP transactions. I received an IBM Division Award for exceptional leadership.
Prior to November, 1995: Senior/Advisory Programmer, IBM Corporation
I Managed ADM departments responsible for development and implementation of office productivity tools and workstations, application support for order processing and factory floor control systems, and analysis support for the engineering change processes. Duties included personnel management and technical guidance of five direct reporting managers and over 50 department members. I directed 3 departments in the development of LPAR micro code in conjunction with the IBM hardware development laboratory. I managed the total life cycle of the software functions for multi-partitioning of a 3090. I received several awards for application of a rapid development process.
Directed assignments in the analysis and programming of sensor based tool control applications supporting the IBM substrate and device manufacturing facility. I provided leadership to a team of programmers and engineers during the design of process tooling prototypes.
Skills
SAP R3 ABAP/4, Data Dictionary, Material Management, Sales and Distribution
Sensor Based Programming
Project Planning and Control
Project management tools: Microsoft Project Workbench, ABT Project Workbench, Lotus 1-2-3
Programming Languages: ABAP/4, C/C++, REXX, EDX, PL/1, BASIC, Assembler
C++, Visual C++
Productivity Tools: Lotus Notes (incl. forms/view design), Freelance Graphics,
Lotus Word Pro, Microsoft Power Point, Excel, Word, Visio
System Environments: S/390, DOS, Microsoft Windows, AIX, DB2, DB2/6000, UNIX
Education
Saint John's University, Queens, New York, B. S. in Mathematics
Pennsylvania State University, State College, Pennsylvania, B. S. in Meteorology.