20161209_david guerrero

David GuerreroSenior Netweaver Developer and SAP Solution Manager Consultant

4790 Voyager DriveFrisco, TX 75034

cell (214) 435-1233e-mail: [email protected]

Goals

My objective is to partner with every stakeholder in the implementation of SAP-based solutions and staying aligned with ALM best practices, forming a strategy for maintaining a lower total cost of ownership for our SAP customers.In that overarching endeavor, my experience to date makes me expert at developing custom solutions using ABAP-based technologies. Most recently, I have gained expertise in many of the Solution Manager-based ALM capabilities. These include Custom Code Management, Solution Documentation and Solution Implementation, Business Process Management and Template Management, Test Management, as well as Change Request Management, to effectively manage customer solutions. I am a committed to utilizing SAP Solution Manager to the fullest extent to protect the customer’s investment in SAP, and to establish myself as a trusted advisor in that endeavor.I continue to maintain expert knowledge and experience in the areas of 1) custom development in the SAP Web Application Server, employing Object-Oriented programming concepts and techniques such as Persistent Objects, ABAP Unit, Shared Memory Objects, and class-based exception handling, using ABAP Objects to realize custom report and dialog programs, ABAP WebDynpro applications, BAPI/RFC , and the SAP Enhancement Framework; and 2) custom integration solutions, leveraging IDOC and ALE/EDI technologies and the Process Integration (SAP XI) Netweaver component.Also, effectively using the OpenSAP and SAP Learning Hub offerings to get up to speed on the development technologies supporting the emerging HANA-based solutions and becoming knowledgeable about S/4HANA implementation methodology.

Consultant Profile Proficiency with SAP Solution Manager 7.1, Solution Documentation, Solution

Implementation, Test Management, Business Process Management, Template Management, Change Request Management, and Custom Code Management. Also knowledgeable about Solution Manager upgrade to version 7.2.

Expert in Global Template Roll-out functionality of Solution Manager. Proficiency in the functional integration of the ARIS modeling tool with Solution Manager. Proficiency in the functional integration of the HP ALM (HPQC) test management toolset. Expert at customer engagement as Senior Technology Consultant with 16 years of SAP

project experience, specializing in the enhancement of R/3 Functional Business Modules (Core R/3, as well as Human Resources (HCM), and Financial Supply Chain) and in the development of solutions based on the Netweaver Platform, including SAP Web AS Development and Process Integration (SAP XI).

Excellent team leadership skills, and thorough knowledge of implementation strategies and requirements resulting from greater than 5 full-scale successful implementations. Highly skilled at the Blueprint task of estimating work effort and at developing coding standards and reviewing custom code to ensure adherence to standards during the realization phase.

Recent experience customizing standard integration scenarios between ECC 6.0 and SAP Business Suite Software, including SAP SCM (SNC), SAP SRM.

Expert in the design of solutions for development tasks required for successful implementations. Development tasks include Reports, Interfaces, Conversions, Enhancements, Forms, and Workflow (RICEFW).

Heavy experience with SAP Aerospace and Defense (A&D) solution, as well as Public Sector, both Federal, as well as State and Local Government.

David GuerreroDXG Consultinge-mail: [email protected]


(214) 435-1233

Experienced developing custom solutions for Business Suite applications, specifically Supply Chain Management-Supplier Network Collaboration business processes and XML-based interfaces, and customized integration scenarios with the Supplier Relationship Management (SRM) product.

Experience integrating Siemens PLM software (along with Tesis Teamcenter Gateway for SAP® (T4S)) and SAP’s Manufacturing Execution product – SAP ME. (SAP ME integration realized with SAP Manufacturing Integration and Intelligence (MII) middleware tool.) Also experienced with custom integration scenarios

Technical Skilled in ABAP Report and Dialog Programming, Object-Oriented Programming and

ABAP Objects, WebDynpro for ABAP, ALE/EDI and Idoc development and configuration, SAPScript, Smartforms, and Adobe Interactive Forms development and Integration technologies including RFC, Business Connector and Java Connector integration technologies.

Skilled in all of the various Master Data conversion technologies, including BDC, CATTs, Legacy Systems Migration Workbench (LSMW), and BAPI.

Completed course work in SAP ABAP Language; ABAP Programming in SAP HR Personnel Administration and Payroll Reporting; SAP Web Application development tools including Business HTML, BSP, XML, and JavaScript. Also, courses completed in Business Connector, Java Connector, and RFC-enabled Function Modules, SAP ALE/EDI and Idoc technologies, SAP Workflow, SAP Enhancements and Modifications, SAP Enhancement Framework, Java Programming, and SAP XI.

EDS Systems Engineer experienced in Object Oriented Analysis and Design. Implemented and maintained batch systems utilizing C++ programming and User Interface development using Powerbuilder. Completed all course work in EDS Systems Engineering Development Program, which included intense exercise in the C Programming Language and in Visual Basic.

EDS Systems Administrator, leading a team of individuals responsible for maintaining systems for the Staffing Department. Systems included client/server hardware, HR Applications, Desktop applications, e-mail, and Corporate Administrative Systems connectivity.

Employment History

DXG Consulting, LLC – Independent Senior Netweaver Consultant – June 2008

thru Present

SAP America, Inc. – Senior Netweaver Consultant – June, 1998 thru June, 2008

Electronic Data Systems – Applications Developer - 1995 thru 1998

Electronic Data Systems – System Administrator – 1993 thru 1995

Johnson & Johnson Medical, Inc. – Internship – Information Technology – 1992

thru 1993

IBM – College/Work Study – Electronic Card Assembly and Test – 1989 - 1991

of 13



(214) 435-1233

Training and Study

Classroom 2008 May – NET310 – Webdynpro for ABAP 2008 Apr – BC401 – ABAP Objects 2007 May - BIT400 – SAP XI 2006 Nov – Java Core 2005 Mar – SAP Webdynpro for ABAP 2005 Mar – Enhancement Framework 2003 Nov – SAP WebFlow

Books SAP Solution Manager for SAP S/4HANA – M.Schafer, M.Melich – SAP Press SAP Solution Manager Enterprise Edition – M.Schafer, M.Melich – SAP Press SAP Treasury and Risk Management – R.Brysa, T.Fritzsche, M.Hess – SAP

Press SAP Netweaver BW and SAP Business Objects – A Comprehensive Guide–

L.Heilig, T.Kessler – SAP Press Managing Custom Code in SAP – T.Thomasis/A.Templeton - SAP Press SAP Essentials – Change Request Management with SAP Solution Manager SAP Solution Manager Enterprise Edition – M.Schafer/M.Melich – SAP Press ABAP Objects: Application Development from Scratch – T.Franz/T.Trapp - SAP

Press Next Generation ABAP Development – R.Heilman/TJung – SAP Press Object-Oriented Programming with ABAP Objects – James Wood - SAP Press SAP Exchange Infrastructure – J.Strumpe/J.Orb – SAP Press

Memberships/Conference(s) 2016/17 Learning Hub subscription 2016 Open SAP training courses 2011 SAP TechEd – Las Vegas

of 13



(214) 435-1233

Experience/Project Work

THE BOEING COMPANY (August 2015 – Present) Industry: Aerospace and Defense Sector – Bellevue, WAProject Description/Scope: Core R/3 implementation (ECC6.0) and Solution Manager 7.1Role: Solution Manager Functional Lead Duration: 1 Year 4 Months

Responsibilities/Deliverables: As Solution Manager Functional Lead, configured the Solution Manager system for best practice ALM processes. The Solution Manager-based processes meet ITIL industry standards for Application Lifecycle Management. My focus was on Solution Documentation and Implementation, Test Management, Business Process Management and Template Management. Our implementation leveraged the strategic partnership with Software AG, and integrated the ARIS business process modeling toolkit to model processes and interface them to the Solution Manager Global Template. Similarly, the Test Management process featured tight integration between Solution Manager and HP ALM. Our team members engaged in proof of concepts for all major capabilities, following the directive of the customer to maximize the user of Solution Manager to achieve ALM processes aimed at efficient management of the large and complex system landscape and deliver on the promise of lower TCO. Achievements: Successfully worked with a team of ARIS developers to synchronized Business Process hierarchy content to the Solution Manager Global Template. We managed scope of multiple implementation projects from multiple lines of business, with content derived from Global Template. I led effort to roll out training to project team for Solution Documentation and Implementation processes. We organized a workshop to establish the best practice test management process (Option 2) and, as such, configured Solution Manager to interface the project blueprints to the Requirements module of the corresponding HP ALM projects, to establish the basis for creating test plans and individual test cases. As the customer SAP practice matured, the Solution Manager team transitioned to the growing SAP Center of Excellence

STATE OF SOUTH CAROLINA (July 2014 – August 2015) Industry: State and Local Government/Public Sector – Columbia, SCProject Description/Scope: SAP Treasury and Risk Management - ECC6.0Role: Senior NetweaverDeveloper Duration: 1 Year 1 Month

Responsibilities/Deliverables: As Senior Developer, my responsibilities were to participate in the review of Functional Specification documents and to design technical solutions to those specifications. I delivered Technical Specification document(s) and coded ABAP-based solutions. The team employed the ASAP implementation methodology. Primary tasks were to develop solutions for Interfaces and Enhancements, but also to include remainder of (RICEF) development requirements. Achievements: I gained experience with the Financial Supply Chain Management module – specifically Treasury functionality. FSCM features data structures and processes optimized for industry-standard financial transactions. Coded and designed parts of large custom sub-system

of 13



(214) 435-1233

termed Pooled Investments, meeting a gap in standard SAP functionality. Pooled Investments manages participation in large investment portfolios, and conforms to legislative mandate in the periodic allocation of gains and losses to participants. Participants were managed leveraging standard Business Partner cross-application functionality. We extended standard Business Partner functionality to meet custom requirements.

RAYMARINE (FLIR) (March 2014 – July 2014) Industry: Aerospace and Defense – Fareham, Hampshire, United Kingdom Project Description/Scope: Implementation – Core R/3 (ECC6.0)Role: ABAP Consulting Duration: 5 Months

Responsibilities/Deliverables: Senior ABAP Developer with primary responsibility in the FI and SD modules. Focus was designing solutions to gaps in the blueprint. Many of the enhancements were oriented toward exposing custom designed function modules as Web Services.

Achievements: Exposing custom-developed function modules as web services was a chief accomplishment. I created cross-application function modules – e.g. Customer Credit Check, together with SD order data, and exposed the FM as a web service, to provide interface to existing legacy user interface application. I also gained experience in the area of Warranty Claim Management

UNITED STATES ARMY (October 2013 – December 2013) Industry: Federal Public Sector – Alexandria, VAProject Description/Scope: Custom Code Management - AssessmentRole: ABAP Consulting Lead Duration: 3 Months

Responsibilities/Deliverables: As Development Lead, my responsibilities were to provide support for all development aspects of the three primary areas addressed by the assessment: 1) Solution Manager-based Global Template, 2) Custom Code Management, and 3) Sustainment. The approach to assessing the custom code was to conduct workshops to review the major business processes from a functionality perspective, and then take deep-dives to review selected custom development objects in each area and make recommendations for custom code optimization. Sustainment project personnel from customer team, as well as third-party vendor participated in the workshops. The project team presented a summary of the findings, as well as delivered a written draft detailing findings and recommendations.

Achievements: Leveraged the results of the Custom Code Impact Analysis previously performed on the customer

system as a basis for assessing the four dimensions of custom code: a) Quantity; b) Quality; c) Technical Severity; and d) Business Criticality.

Drafted content for both summary presentation and final Assessement document, and took part in formal presentation.

Made a compelling case to the customer for the implementation of the Custom Code Management business process, while positioning myself as a trusted advisor to the customer.

L3 COMMUNICATIONS - CSW (March 2011 – October 2013) of 13



(214) 435-1233

Industry: Aerospace and Defense – Salt Lake City, UTProject Description/Scope: ECC6.0/PLM/MERole: ABAP Consulting Lead Duration: 2 yrs 6 Months

Responsibilities/Deliverables: As ABAP Consulting Lead, my primary responsibility is to serve as the ABAP subject matter expert and as a trusted adviser to the organization responsible for custom development. I also served as lead in integration scenarios required with the solution, namely PI development and SAP MII configuration and development. I helped to create a matrix of estimates based primarily on development type (RICEFW) and complexity. I participated in the interview process to augment the customer developer staff to meet the demand for development. I helped to draft the organization’s Development Strategy and Approach document, as well as Naming Standards document. I helped to draft the template for Functional and Technical Specification documents and ensured a complete set of documentation for all custom RICEFW development through the entire project. I established the SAP package strategy for all custom development and helped manage transports during system build activities. Post go-live, I helped to establish processes and procedures for overall change request management. Achievements: Participated in the Blueprint phase of the project to: 1) advise on requirements determination as

per identified gaps in functionality; 2) accurately estimate work effort for development tasks; 3) supplemented classroom training for customer development staff to prepare the team for the Realization phase; 4) serve as subject matter expert for the ABAP development team; and 5) drafted customer-specific Development Strategy and Approach and SAP Development Programming and Naming Standards documents.

Participated in Functional Specification Document Peer and Final Reviews, as well as organized Technical Specification Final Reviews and corresponding Code Walkthroughts. Code Walkthroughs were used to ensure solution accuracy and program robustness, as well as adherence to established development standards. This included reviews over large, comlex, ABAB Webdynpro-based custom code solution for hardware cost estimating functionality.

Successfully established PI as the standard for third-party integration requirements, and SAP MII as the off-the-shelf solution to integrate ECC and SAP ME. Ten custom reports/queries were created using the MII Workbench to serve customer manufacturing analysts.

Completed an exercise to capture into transports the 46C custom code solution to a requirement for a hardware cost estimating subsystem, and migrate it into out ECC 6.0 instance for further evaluation.

Developed a custom end-to-end integration scenario between SAP ECC and a legacy MSSQL database. The solution included a custom XI integration scenario utilizing ABAP Proxy technology as well as the standard JDBC adapter to facilitate a stored procedure call.

Developed break-fix solutions for many of the custom development objects during multiple integration test cycles, hypercare, and post-go-live support. Tasks featured development using traditional tools, including ABAP Objects, BAdI, BAPI, IDOC, LSMW as well as current technologies with PI, including ABAP Proxy, file and SQL adapters, and ABAP Webdynpro.

STATE OF SOUTH CAROLINA (July 2009 – March 2011) Industry: State and Local Government/Public Sector – Columbia, SCProject Description/Scope: Core R/3 - ECC6.0/HRRole: Senior Developer Duration: 1 Year 8 Months

of 13



(214) 435-1233

Responsibilities/Deliverables: As Senior Developer, my responsibilities are to participate in the review of Functional Specification documents and to design solutions to those specifications. I designed the technical solutions and documented them in Technical Specification document(s). Primary tasks were to develop solutions for Interfaces and Enhancements (RICEF) requirements. Achievements: Worked with ABAP and ABAP Objects in the Realization Phase to successfully create a

broad enhancement, termed Program Cost Account (PCA) to much of the FI and Logistics document creating/editing functionality. I utilized BADIs (both explicit and implicit enhancement points), Standard Enhancement Spots, and Business Transaction Events (BTE), to realize this customized functionality, whereby Functional Areas doubled as PCA Codes. Use of a PCA code resulted in automatic splitting of account line items (PO) and accounting attributes of FI document detail lines, as well as account info for Funds Management documents. The PCA enhancement is effective in applicable standard online transactions, as well as in custom interface programs. The functionality extends to the GL Accounting Documents (posted and parked), the Customer Invoice, the SRM Shopping Cart, Funds Reservation Documents, Purchase Orders, and potentially OrgMgmt Infotype 1018 – Cost Distribution.

I leveraged BADIs to extend the scope of PCA functionality to SAP SRM. As such, I programmed in ABAP Objects, using available classes and methods to implement the custom functionality, maintaining the SAP Standard.

I created a custom dialog program for the maintenance of PCA master data. I worked to create and complete custom Interface programs to process inbound

Financial and Materials Management interface files from decentralized State Agencies. Utilized SAP XI with File Adapter for interface file handling.

I worked in the Integration Testing stage of the project to troubleshoot defects and make corrections to all RICEFW development objects, including Adobe Interactive Forms.

I use my excellent communication skills to share knowledge with the customer to eventually create the most in in-house expertise and realized lower total cost of ownership for SAP.

SUMISHO COMPUTER SYSTEMS (June 2009 – July 2009) Industry: Consulting Services/Telecom – Irving, TXProject Description/Scope: Core R/3 - ECC6.0Role: Senior Developer Duration: 2 Months

Responsibilities/Deliverables: Joined the project in its final stages. As a Senior Developer, my responsibilities were to design Reporting solutions, as per Functional Specification documents. I documented solutions in Technical Specification document(s). On this engagement, I worked to effectively complete tasks within prescribed time frames. Achievements: Worked effectively with functional consultants to design solutions for reporting from the

Project Systems module. I leveraged the Project Systems Logical Database, PSP, to extract data from SAP and create reports and formatted interface files. PSP data included Logistics documents as broken down by WBS elements, as well as by Cost Element Groups. The reports were in lieu of standard Report Painter reports, which

of 13



(214) 435-1233

customer was not able to export for interfacing. Reports utilized the ABAP List Viewer (ALV) to take advantage of the summing/grouping and export functionality.

Worked to troubleshoot defects in the post-Integration Testing phase of SRM SmartForms solutions.

LOCKHEED MARTIN (June 2008 – March 2009) Industry: Aerospace and Defense – Fort Worth, TXProject Description/Scope: A&D Logistics Industry Solution; ECC6.0Role: Senior Developer Duration: 9 Months

Responsibilities/Deliverables: As Senior Developer, my responsibilities were to participated in the review of Functional Specification documents and to design solutions to those specifications. I designed technical solutions to the functional specifications and documented them in Technical Specification document(s). I primarily developed solutions to interfaces and enhancements requirements. I also completed development with SmartForms and with Adobe Interactive Forms Designer. Assigned to the Global Sustaining team, responsibilities touched many Manufacturing process. Specifically, development centered around MRO activity (Service Notifications/Service Orders). I worked to effectively complete tasks within prescribed time frames solution – Planning and Delivery Process Teams and Data Transformation Team. Achievements: Worked effectively with various groups to realize a solution to interface the Work Order

object from the SAP SCM Supplier Network Collaboration (SNC) module to the Service Notification of the ECC6.0 Logistics module. This effort required development of a custom program to trigger the interface of the SNC Work Order on a regularly scheduled basis from the SCM instance to the ECC6.0 instance, via SAP XI. A customized XML message is developed to passed between SNC and XI and a customized IDOC type was developed to pass between XI and ECC6.0, along with a customized processing routine. This custom interface was developed as there is no standard interface scenario for the SNC Work Order. The solution utilized standard SAP on the SNC side, as the standard ManufacturingWorkOrderInformation message type was employed. Data type enhancements were used to enhance the message structures and were propagated to the SCM instance using SPROXY. Finally, the SAP Enhancement Framework was used to derive data and fill enhanced structures to be interfaced to ECC6.0. Service Notification BAPIs “BAPI_ALM_NOTIF_DATA_MODIFY” and “BAPI_ALM_NOTIF_DATA_ADD” and others were used to create/update the ECC6.0 Service Notification.

Worked effectively with users and functional experts to resolve defects for interface, enhancement, and forms objects during various Integration Test Cycles.

Leveraged SAP SmartForms to develop forms output in PDF format. Also, utilized the Adobe LiveCycle Designer to develop Adobe Interactive forms in the integrated form builder (txn SFP). An interactive form was developed for the SAP Purchase Order. The form is saved to disk, e-mailed to Vendor, and allowed vendor to enter alternate part numbers in the form, save form to disk, and send back to customer.

Worked intergration test defects for all development objects, including SmartForms and Adobe Interactive Forms.

RAYTHEON COMPANY (May 2006 – June 2008) of 13



(214) 435-1233

Industry: Aerospace and Defense – Dallas, TX/Long Beach CAProject Description/Scope: A&D Logistics Industry Solution; v4.7Role: Key Developer Duration: 2 Years 0 Months

Responsibilities/Deliverables: As Key Developer, responsibilities were to serve as first point of contact for development tasks and issues for three of five functional teams of logistics solution – Planning and Delivery Process Teams and Data Transformation Team. Achievements: Worked effectively with customer and functional experts to successfully roll out

Aerospace and Defense solution to multiple divisions within corporation. Functional sub-teams included Master Scheduling, MRP, Depot (MRO), Facilities Management, and Master Data – Material Master and Bill of Material.

Coded solution for customized determination of Destination Storage Bin and Storage Unit during Transfer Order creation (Warehouse Management).

Coded custom dialog program for creating/maintaining Inter-Organizational Transfer (IOT) data. Technical solution integrates seamlessly with standard Planned Independent Requirements functionality.

Design and Maintenance of custom programs: Customized Copying of Bills of Material, Web Page interface for Facilities Management, PDM Interface, Proposal Estimating Interface.

CENTEX CORPORATION (March 2006 – April 2006) Industry: Residential Construction – Dallas, TXProject Description/Scope: Core R/3 ImplementationRole: Project Team Member Duration: 4 WeeksResponsibilities/Deliverables: Introduced to the team for short period to aid in the completion of development of financial reports for project analysis.

Achievements: Worked effectively with customer and functional experts in developing various

customized financial reports. Effectively utilized the ALV output format to allow for organization and flexibility of complex financial data.

NOVARTIS ANIMAL HEALTH (February 2006 – February 2006) Industry: Pharmaceutical – Greensboro, NCProject Description/Scope: Development SupportRole: Project Team Member Duration: 2 WeeksResponsibilities/Deliverables: Introduced to the team for short period to aid in the creation of development enhancements in the SD module. Achievements: Worked effectively with customer and functional experts in enabling and developing

customer exits for creation of line items in the SD sales order. The enhancements allowed for automation of line item creation for orders meeting various seasonal sales and marketing initiatives.

WHITEWAVE FOODS (January 2006 – January 2006) of 13



(214) 435-1233

Industry: Consumer Packaged Goods – Broomfield, COProject Description/Scope: Development SupportRole: Project Team Member Duration: 3 WeeksResponsibilities/Deliverables: Introduced to the team for short period to aid in the validation of ALE/EDI Distribution Model. Achievements: Worked effectively with customer and functional experts in validating the solution to the

EDI scenarios developed for core R/3 implementation. Validated the mapping of standard SAP IDOC structures and message types with industry-standard EDI message types, including Sales Order, Sales Invoice, PO Acknowledgement, Shipment Notification, WM Shipping Order, WM Shipping Advice, WM Stock Transfer Order, WM Stock Transfer Order Receipt Advice, WM Inventory Adjustment, Payment Advice, Tender Request, and Tender Advice.

RAYTHEON COMPANY (August 2004 – December 2005) Industry: Aerospace and Defense – Tucson, AZProject Description/Scope: SAP R/3 Enterprise – Core R/3, including Material Master, Inventory Management, Warehouse Management, Sales and Distribution, Quality Management, Production Planning, and Shop Floor. SAP 4.7Role: Project Team Member Duration: 9 MonthsResponsibilities/Deliverables: As a top performer on the Supply Chain Management team, completed enhancement and interface development tasks critical to the project go-live. Solely responsible for all Material Master Customizations and responsible for providing a solution for receipt and serialization of SU-managed materials. Also, developed inbound and outbound file interface programs to the legacy Inventory and Asset Management system. Delivered thorough documentation for all development objects. Provided regular and accurate reporting of status of development projects (this was critical, as the scope of project and size of development team were large). Mentored developers in areas of SAPScript and SmartForms and in LSMW conversion utility. Achievements: Worked effectively with customer and functional experts in developing highest quality

solutions to development requests on time and according to specification, while adhering to customer development standards.

Worked effectively with development support team to successfully achieved knowledge transfer, in preparation for post go-live support.

Effectively mentored development support team members on the use of LSMW for Material Master Conversion, leading to on-time delivery of the solution.

TARRANT COUNTY (November 2003 – July 2004) Industry: Public Sector/State and Local Government – Fort Worth, TXProject Description/Scope: Phase II – SAP R/3 Enterprise – Core R/3, including FI/CO, Material Master, Asset Management, Funds Management, Grants Management, Budget Prep, and HR-Payroll Integration. SAP 4.7Role: SAP Development Lead Duration: 9 Months

of 13



(214) 435-1233

Responsibilities/Deliverables: Led team of developers in all development efforts required to implement core R/3. Participated in project planning with breakdown and estimates of planned development tasks. Mentored ABAP developers on customer team through the completion of assigned tasks. Prescribed a structured development process and documented approach in the customer SAP Development Standards Document. Monitored the development process to ensure high quality in delivered development objects. Developed all enhancements, featuring numerous customer exits and Business Add-Ins (BAdI). Scope of project included various workflows, SAPScripts/Smartforms, a Purchase Order XML interface to vendor using Business Connector, and an e-mail notification enhancement for Funds transfers.

Achievements: Delivery of high quality set of development objects, as per structured approach to

development. Delivered a library of three ring binders, each containing full documentation for a specific

development object. Implementation of 3rd Party XML interface using Business Connector product. Successfully achieved knowledge transfer, exceeding of expectations, to customer

development team Mentoring and knowledge transfer allowed the development staff to remain self-sufficient

and with a low reliance on consulting, maintaining the full confidence of the organization, and lowering total cost of ownership (TCO).

TARRANT COUNTY (February 2003 – November 2003) Industry: Public Sector/State and Local Government – Fort Worth, TXProject Description/Scope: Phase I – SAP R/3 Enterprise – Human Resources, including Personnel Administration, Personnel Development, Benefits Administration, Compensation Management, Time Management, and Payroll. SAP 4.7Role: SAP Development Lead Duration: 10 MonthsResponsibilities/Deliverables: Led team of developers in all development efforts required to implement SAP HR, on R/3 Enterprise (4.7), extension set 2.00, for Public Sector. Participated in project planning with breakdown, estimates, and delegation of development tasks. Successfully utilized the SAP HR 4.7 Pre-configured System (PCS) to manage conversions and leverage predefined development objects. Mentored ABAP developers on customer team through the completion of assigned tasks. Delivered and maintained the MS Access RICE (Reports, Interfaces, Conversions, and Enhancements). Developed all enhancements, featuring standard customer exits, with no core modifications. Developed custom Payroll results interface to existing legacy Financials system. Developed enhancements to add custom rules to time entry, manage dependent IDs to conform to 3rd party benefits administrator standards, and enabled detailed payroll results reporting normally only available with R/3 to R/3 payroll integration.

Achievements: As sole experienced developer, fully leveraged standard tools, especially in the areas of

conversion and reporting to successfully accomplish tasks in all critical phases of the project, notably multiple mock conversions and multiple phases of parallel payroll processing and check printing.

of 13



(214) 435-1233

Create a custom program to provide temporary interface to legacy financials system (Payroll results to GL Account posting) using the R/3 TEMSE (Temporary Sequential) file.

Successfully achieved knowledge transfer, allowing customer to maintain ownership of data during master data conversions, and being readily able to meet reporting and interface needs of all HR Infotype data, as well as Payroll results post go-live.

Demonstrated competence and leadership so as to position SAP as a trusted advisor and secure a role in subsequent phases of SAP implementation project.

AMDIndustry: Manufacturing/Semiconductor, Austin, TX / Sunnyvale, CAProject Description/Scope: SAP 4.6CRole: Technical Consultant (Tools) Duration: 4 MonthsResponsibilities/Deliverables: Aided in the completion of development work for SAP HR implementation. Complete work in the area of the HR Forms Editor, for modification to the HR Payroll Remuneration statement. Initially a spot assignment, I remained on the project for the duration of go-live and helped to complete various reports, interfaces and enhancements. Successfully coded a complex enhancement involved the activation of a customer exit to add payroll garnishment data to an existing Idoc interface, where the interface source system is a separate SAP FI instance and the target system a third-party bank responsible for distributing funds to the various customer garnishment vendors. Also notable were the timely creation of conversion programs to quickly facilitate the transfer of Training and Events master data, and the creation and maintenance of a critical interface to a third party system used for managing planned positions in the Organizational Management functional Area.Cooper CameronIndustry: Oil Well Services and Equipment, Houston, TXProject Description/Scope: SAP 4.6CRole: Technical Consultant (Tools) Duration: 7 MonthsResponsibilities/Deliverables: Led the effort to perform the master data conversions for the implementation of the HR module. Included were Personnel Administration(PA), Benefits(BN), Payroll(PY), and Organizational Management (OM). He was instrumental in leveraging Pre-configured client conversion programs to load master data in a short period of time, managing to meet functional Integration Testing, Parallel, and Go-Live schedules. Also, David effectively mentored the customer development staff in its endeavor to support development of reports and interfaces.Worldwide Flight ServicesIndustry: Airline Services, Euless, TXProject Description/Scope: SAP 4.6CRole: Technical Consultant (Tools) Duration: 7 MonthsResponsibilities/Deliverables: Participated in the implementation of the Human Resources 4.6C Pre-configured System. Managed technical tasks including data conversions, interfaces to 3rd parties, and report programming, but to also manage the diverse and often strained relationships between project team members working in stressful conditions.

of 13



(214) 435-1233

Coca-Cola EnterprisesIndustry: Beverage (non alcoholic), Atlanta, GAProject Description/Scope: SAP ImplementationRole: Technical Consultant (Tools) Duration: 6 MonthsResponsibilities/Deliverables: This project afforded Mr. Guerrero the opportunity to hone his skills in a variety of areas, as the project was characterized as ongoing and multi-faceted. Early in the engagement, David worked with EDI scenarios and IDocs. Subsequent tasks included support of a roll-out to a manufacturing site by way of master data conversions using the Legacy System Migration Workbench (LSMW), and the development of various SAPScript forms to replace the current JetForms document generation subsystem. It is anticipated that the multi-faceted nature of the project will allow Mr. Guerrero the opportunity to further develop skills in the New Dimensions products and the Internet-related mySAP.com initiatives.

Federal ExpressIndustry: Logistics (SCM), Irving, TXProject Description/Scope: SAP SCM Joint Development ProjectRole: Technical Consultant (Tools) Duration: 9 MonthsResponsibilities/Deliverables: Introduction to Supply Chain Management and SAP APO product offering. The project aimed to create a product which offered an integrated suite of applications designed to plan, execute, and monitor a client’s end-to-end supply chain of specified products. The suite of applications principally consist of an existing customer R/3 system, SAP APO, SAP Business Information Warehouse (BW), and a customer global inventory visibility (GIV) product. The application integration environment is provided for by the WebMethods B2B software solution. Tasks centered around the integration of the products involved, and include the following: 1) EDI configuration for Sales Order, Purchase Order, Transfer Order, and Shipping Document data distribution from R/3 to GIV; 2) master data distribution from R/3 to GIV via ABAP programs created to extract master data from R/3; 3) Support of the installation of Internet Transaction Server (ITS) to ultimately support the Collaborative Planning (CP) component of APO ; 4) ARMing (Application Response Measurement) of component systems utilizing the HP OpenView suite of system management products; 5) support for applying OSS notes in all R/3 systems

EDUCATION

B.A. in Economics, University of Texas, Austin, B.S. in Management Information Systems, University of Texas at Arlington Languages: English, Spanish

of 13