1. No category

312.772.2260
[email protected]
Dawn K. Gilbert
PROFESSIONAL SUMMARY
16 years of Information Technology expertise including SAP technical and functional experience.
•
•
•
•
•
•
Solid foundation in programming fosters my functional and technical expertise in SAP ECC 6.0
Experience in system integration (modules AP, MM, FI), inter-company invoicing to payment program and
check printing configuration (FBZP setup), Tax procedures
SAP Business application driven Workflow with Content Server imaging integration (Archivelink)
Design, code, test ABAP programs, ABAP reports, user-exits, EDI integration, FI validations and
substitutions.
Vistex experience with Data Management Pricing Modules.
OData Modeling on SAP Netweaver Gateway.
Possess strong skills in business analysis and integration architecture.
Resolve complex technical and functional issues by analyzing business processes, presenting options/demoing prototypes to
the client.
Lead technical design and development; including assessing impacts on operations, sizing and other issues.
Hands on experience in technical trouble shooting such as performance improvements, OSS research, table analysis, ABAP
programming and code debugging.
Technical team leader of numerous full life cycle implementations of SAP’s Accounts Payable (AP), T&E, AR/SD.
Produce high quality documentation and detailed functional and technical program specifications.
Innovative thinker who produces deliverables in a short period of time.
Problem solving skills allow me to assist even in SAP modules that are not my expertise.
Take initiative and am self-guided.
Assertive and reach out to appropriate cross-impacted areas to ensure proper design and integration.
Quickly assimilate information to come up with alternative solutions.
Take initiative in identifying cost saving opportunities for my clients.
Assist the client in any way possible to build, configure, integrate and enhance the functionality in the SAP system.
I believe in empowering the client to become self-sufficient in maintaining and trouble-shooting their own system.
EDUCATION
1991-1995
Miami University
Bachelor of Science: Systems Analysis & Minor: Mathematics
Oxford Ohio
TECHNOLOGY SKILLSETS
SAP Certifications:
Completion of SAP RE200 Flexible Real Estate Management; Certified in February 1998 in SAP R/3
3.0 in Materials Management (MM)
Integration of SAP with: IBM On Demand, IBM Content Manager, FileNet P8 imaging content management; Inovis EDI
solution, Order to Pay (OTP), Ariba, Ariba Analysis, Infor’s XM T/E application
1 of 6
Development Tools:
SAP Graphical Business Workflow, Business Data Toolset (BDT), SMARTFORMS, Legacy System
Migration Workbench (LSMW), SAP@Web Studio, SAP’s Internet Transaction Server, Webmethods
B2B Server and Mapping Tool, Mercator
Testing Tools:
Mercury Quality Center (MQC), Quick Test Professional (QTP)
EDI Software Suites:
Sterling’s Gentran Server Client Server, Sterling’s Gentran Mapper for UNIX, Harbinger Mapping
Workbench, Harbinger Trusted Link Enterprise
Languages:
ABAP, SQL, COBOL, C, HTML
Computer System:
UNIX, Windows, SAP R/3 Enterprise ECC 6.0, Enterprise Buyer Professional (EBP/SRM)
Microsoft Products:
Word, Excel, Access, Powerpoint, Project, Visio
EMPLOYERS
Self Employed at Dawn to Dusk Consulting, LLC
JPMorgan Chase, Vice President, Applications Development Senior, Integration Architect
CSC Consulting SAP Practice, Senior SAP Product Specialist
CSC Consulting Chicago Business Unit, Programmer
February 2012 – Present
April 2003 – February 2012
February 1998 - March 2003
August 1995 - February 1998
EXPERIENCE
January 2013 – Current
•
•
•
•
•
•
•
•
•
•
•
•
Client site: Kohler
Technical Lead for SAP Workflow within the QM
Kohler, Wisconsin
Designed and developed PPAP (Product Part Approval Process) Workflow within the QM (Quality Management) module.
Workflow designed to ‘self-fix’ when agent determination not found.
Workflow interaction with SAP Supplier Portal via Web services. Bi-directional calls to keep SAP Supplier Portal and SAP
synchronized.
Lead workshop discussions and demos with client to gain business buy-in of the PPAP Workflow design.
Provided detailed Workflow training guide and hosted several training sessions with client ABAP team. Client became selfsufficient on maintenance of the Workflow.
February 2012 – September 2012
•
Mason, Michigan
Designed, configured and developed Deviated Price Request Process and approval notification Workflow within SAP
Vistex.
Designed and built several OData Services on SAP Netweaver Gateway for custom Portal consumption. Portal utilizing SAP
UI5 (Dev toolkit for HTML5) framework with a Fiori user experience.
Configuration of Vistex objects such as Price Request, Price Proposal, Condition Map, Index Profile.
Configuration of Vistex Pricing Accelerator (VPA) which loads pricing condition records and material master records into
memory for faster retrieval during Pricebook calls.
Managed 4 onshore/offshore ABAP developers.
October 2012 – November 2012
•
Client site: Manufacturing
Data Management Pricing (DMP) Consultant
Client site: AMT Montreal Canada
SAP Technical Lead for CAM/BAS, RE-FX map
integration and Workflow Expert
Montreal, Canada
Lead Senior SAP Technical Integration for custom integration within REFX development for integration of Google map into
the Architectural view and the Usage view objects.
Developed dynamic reporting tool (via SMARTFORMS) for REFX-Contract to meet Legal Department requirements of
tracking Law articles.
Technical lead for Flexible Real Estate (RE-FX) Screen enhancements via Business Data Toolset (BDT).
– Enhanced several RE-FX screens integrating Google map with latitude/longitude values utilizing BDT (Architecture
Object, Business Entity, Buildings, Land: AO, BE, BU, PR).
– Configured additional tab and screen sections for custom attributes and Google map for several RE objects (AO, BE,
BU, PR, Contract).
Reviewed and improved the ESRI integration points within Land Usage management to improve precision.
Designed custom BI import process for extraction of ECC Contract memo fields for reporting in BI.
2 of 6
•
•
Technical Development lead for the SAP ECC 6.0 and CRM 7.0 of the Central Address Management (CAM), Business
Address services (BAS).
– Designed custom extension to SAP table to adjust CAM/BAS in order to integrate the functionality with REFX and with
Business Partners.
– Designed and prepared load program based on Canada Post data.
– Design and prepared utility to update Canada Post data monthly.
Tested, debugged and validated conversion load programs for Business Partner, Contracts and RE-object’s geospatial
coordinates.
April 2003 – February 2012
JPMorgan Chase
SAP AP Technical Lead, Integration Architect
(ECC 6.0), EDI and Workflow Expert
Chicago, Illinois
•
Technical AP Integration lead for the SAP ECC 6.0 US Globalization, Mexico, Canada and Ireland rollout implementations.
– Managed 10+ on/off shore business analysts and programmers; head contact for any design issues.
– Designed/configured SAP AP for multi-currency invoice to payment process: Inbound invoice interfaces to handle
VAT taxes (assessed/non-assessed tax scenarios) integration to Vertex O series, FBZP payment run configuration,
designed custom FI Validation/Substitutions to meet country specific requirements.
– Designed custom interfaces with Ariba Spend Management (ASM, versions 9R1 SP7, SP16) (vendors, cost/profit
centers, GL accounts, company country data)
– Designed/configured SAP Tax procedure for VAT taxes based on Mexico requirements (recoverable and nonrecoverable VAT, tax withholding).
– Designed/configured SAP Tax procedure for VAT taxes based on Canada requirements (integration with Vertex O
series, vendor assessed tax and self-assessed scenarios).
– Lead overall design of SAP AP configuration and over 60 functional specifications.
– Lead numerous design discussions on complex requirements with clients from different touch points (Accounts
Payable, Infor’s XM T/E application, Paysource, IB Famis, Xign’s Order to Pay (OTP))
– Managed Test Plan, Test Lab, Defects and their resolution via Mercury Quality Center (MQC).
– Designed/tested 40+ autosys boxes for job scheduling.
– Produced/presented robust Runbook ‘BAU’ support guides for each country implementation.
– SAP AP SME, guide/mentor to on/offshore analysts, programmer and client.
– Expert at LSMW (Legacy System Migration Workbench) to assist in loading/posting data from custom files into
Standard input, SM35 batch recording, BAPI or IDoc.
– Technical understanding of BTE, BADI, call transaction, BDC, standard posting programs which makes it easy for me
to design processes utilizing these.
•
AP/AR/SD Technology Lead for SAP system upgrade to ECC 6.0.
– Identified the Instances of Change for modules AP, AR, SD. Presented differences to the business and provided a
training guide.
– Managed test plan, test lab, defects and their resolution via Mercury Quality Center (MQC).
– Researched OSS notes, submitted issues to SAP via OSS, tested/implemented dozens of OSS notes.
•
Lead SAP Technical Integration Architect for custom integration with Xign (Order to Pay; OTP). This implementation
allowed decentralized invoice entry/approval flow/image scanning by employees and outside suppliers. Invoice
payments from SAP AP including dynamic early payment discount processing. The invoice and discount interfaces
utilized FIDCCH01 and FIDCCP02 IDoc formats. Enhancement of FIDCCP02 included custom segments to incorporate
mapping of custom header/line texts as well as DOCID image links for SAP image retrieval via Archivelink.
– Designed and created dozens of functional/technical specifications for overall interfaces between OTP and SAP.
Worked closely with the ABAP development team to ensure coding adhered to the specification details. These
interfaces passed invoice data, invoice status, invoice payment/void, discount instructions and vendor master
data/changes.
– Designed custom imaging solution with OTP which included faxing, imaging storage, image retrieval (RightFax,
Captiva, IBM Content Manager, CommonStore for SAP).
– Implemented file naming conventions, file frequency as well as file transmission with sFTP and pgp encryption.
– Functioned as the SAP technical ‘go to person’ for functionality and technical questions from analysts/developers as
well as Corporate Accounts Payable team members.
•
Design architect and lead developer for two custom highly complex SAP application driven workflows for Accounts
Payable (AP) processes during the largest financial institution merger to date.
3 of 6
–
–
–
–
–
–
–
–
–
Workflow included invoice imaging of over 6,000 documents daily; 200+ AP offshore processors.
Fax/Scan integration with external content server (RightFax, EasyLink, Captiva, IBM Content Manager, CommonStore
for SAP) utilizing SAP’s Archivelink functionality.
Robust SAP business application driven workflows included creative solutions such as indexing image, dynamic queue
determination (via custom rule determination function), dynamic work item text construction and custom
queue/productivity reporting.
Customized standard SAP object and developed numerous methods utilizing custom code, BAPIs and functions.
Configured Archivelink settings to external content server (IBM CommonStore, IBM FileNet P8) for early and late
archiving scenarios for .PDF and other doc type images.
Designed and tested numerous custom FI validations and substitutions.
Customized tax calculation with Vertex Q series/Vertex Tax Decision Matrix utilizing the actual functional location
for tax incentive exemption processing.
Developed Quick Test Professional (QTP) scripts to auto-load workflow workitems to be used in performance testing
as well as user acceptance testing (UAT).
Created the necessary SAP security roles for workflow users. Built a spreadsheet template of the relationship
between the security access and organizational structure setup (PPOME) for each type of workflow ‘queue’
processor.
•
Developed and instructed SAP custom workflow technical administration training sessions for production support team
and 30 offshore AP processors. Created 100+ page thorough workflow support guide for workflow managers as well as
technical administrator. Prepared training material and setup system data for hands-on exercises in system.
•
Designed creative SAP workflow solution for procurement card processing as well as a custom invoice interface and audit
report.
– Workflow and ABAP program updated custom table which linked monthly card statement data to the event of the
user faxing the monthly statement. Monthly statement image linked to vendor master for easy retrieval to suffice
audit requests.
•
Implemented late archiving imaging scenario for National Reconciliation department. 30+ on/off-shore users are now
attaching supplemental documentation to line item reconciliation in SAP OIM. Printing of documentation and storage at
Iron Mountain no longer necessary.
– Prototyped late archiving scenario via web-ex demos to management with immediate buy-in.
– Documented, configured and tested late archiving for Word (.DOC) document type.
•
Project manager for Data Management (DMA) and Data Archiving Optimization (DAO) SAP initiatives which resulted in
over 2 terabytes of data reduction in database as well as improved data archive read reporting to satisfy data users and
audit requests.
– Coordinated numerous workshops with module leads.
– Designed/implemented creative solutions for archiving issues.
– Prototyped and implemented several SAP Archiving Information Structures (AS) (IDocs, Financial Documents).
•
Hotpack testing manager for two hotpack upgrades for FI, AP, MM, SD, AR, PS modules. Managed 4 off-shore contractors
to execute 900+ test scripts loaded into Mercury Quality Center (MQC). Provided guidance and mentoring to keep testers
on-track during the implementation time-line. Loaded scripts from Microsoft Excel to MQC.
•
Designed SAPScript output of Invoice layouts for over 20 customers.
– Utilized custom header/line item texts as well as standard text variables to normalize down to one SapScript program
output for all state-agency customers.
•
Developed GoldClient strategy for new SD/AR functionality implemented for Food Stamp program.
– Analyzed what objects were required for SIT/UAT testing.
– Produced task plan of data to be cleaned in target system, extract from source system, and loaded to target system.
•
Researched and analyzed current Value Added Network (VAN) costs for the EDI volume. Not only presented findings to
upper manager on a cost-saving plan to move to direct FTP but also received immediate buy-in.
•
Designed innovative mass auto-reversal interactive SAP program to assist with follow-on process after a voided payment.
Streamlined cumbersome process which was reverse one document at a time via standard reversal transaction(s).
4 of 6
•
SME for numerous critical production issues with existing SAP out bound interfaces. Posted/paid data extract to
downstream reporting system was sending invalid data. Team did not recognize the logic issues of the program.
Redesigned extract and worked closely with the developer to ensure accuracy. Program designed, coded, tested, user
acceptance tested in two weeks while the original program was having testing issues for over eight months.
•
Guided/mentored several development team members (on-shore/off-shore) during code of custom ABAP programs
across MM, AP, FI modules.
•
Conformed to Sarbanes Oxley documentation requirements. Produced dozens quality technical specifications as well as
and business process procedure documents (BPPs). (sample documentation can be provided on request).
Consulting Client Engagements (with CSC Consulting SAP Practice)
August 2002 – March 2003
•
Alpharetta, Georgia
Technical lead for data normalization project of 30+ MRP systems with redundant master data.
– Trained client on use of LSMW (Legacy System Migration Workbench) and provided LSMW training materials.
August 2001 – July 2002
•
Siemens
Technical Lead Data Normalization
Office of Inspector General (USPS)
Team Lead EBP/SRM Development and Workflow
Arlington, Virginia
Development team lead for SAP’s Enterprise Buyer Professional (EBP, SRM) indirect procurement solution for a
government agency. Managed 4 individuals during custom coding. Assisted in unit and string testing.
– Developed functional and technical specifications of interfaces and conversions for team of programmers.
– Designed and coded complex user-exit enhancements to the EBP system.
– Modified existing EBP requisition approval workflow to incorporate a complex approval strategy.
– Provided client with workflow approval documentation detailing the routing logic.
– Produced numerous quality technical documentation and business process procedure documents.
August 1999 - March 2001
General Motors Locomotive Group (GMLG)
EDI Project Manager and Team Lead
La Grange, Illinois
•
EDI implementation project manager – Prepared EDI statement of work, project plan, managed project scope, mentored
team members, reported project status, issues and accomplishments to upper management.
•
Electronic Data Interchange (EDI) team lead of four people for a full-scale SAP implementation at this major locomotive
production corporation.
– Participated in EDI vendor selection process with client. Compared/contrasted several software packages to assist
client in choosing appropriate software.
– Designed, mapped, tested, and implemented five ANSI X12 EDI transaction sets (810, 820, 855, 856, 997) for over 30
Trading Partners.
– Configured SAP for EDI (Partner profile, RFC connection, port, external/internal customer/vendor table mapping)
– Proficient in the Cleo communication software setup and execution.
– Managed interaction with Trading Partners and coordination of inter-connect setup with several Value Added
Networks (VANS).
– Produced detailed technical documentation and business process procedure documents.
•
Developed and instructed SAP EDI workflow training sessions for over 20 clients.
– Prepared training material and setup system data for hands-on exercises in system.
– Cross-trained/transitioned EDI production support activities to client resource. Wrote 100+ page EDI technical
operations guide for client hand-off. Included step by step instructions and screenshots.
February 2001
•
GATX
Process Improvement and EDI Evaluator
Chicago, Illinois
Consulted for this major rail car leasing corporation utilizing expertise in the area of EDI and SAP’s Sales and Distribution
(SD) module functionality related to client’s Month-end Billing Process. Facilitated several workshops to define current
and future state. Documented findings and presented cost savings analysis to Senior Management.
5 of 6
February 1997 – August 1999
•
Bank One
Lead ABAP Programmer & EDI Coordinator
Chicago, Illinois
Key team member on an ERP project at this $280 billion Midwest bank.
– Lead developer for suite of custom Web-enabled SAP transactions (utilizing the Internet Transaction Server (ITS))
permitting intranet access to Employee Self Service T/E Expense functionality for over 60,000 client employees.
Designed and implemented custom workflow approval notifications via SAP Business application driven Workflow.
Coded screens via ABAP and corresponding HTML pages via SAP@WebStudio.
– Coordinated the conversion of EDI purchasing system from an AS400 OS to an HP Unix platform for over a dozen PO
trading partners.
– Designed and coded several user-exits for inbound INVOIC IDoc processing.
– Cross-trained/transitioned EDI production support activities to client.
– ABAP developer for two general ledger conversions participating in all levels of testing of programs (unit, string,
integration).
Consulting Client Engagements (with CSC Consulting Chicago Business Unit)
October 1995 – February 1997
•
College of American Pathologists, Dupage
County Courthouse, St. Paul Federal Bank
Cobol Programmer
Chicagoland area
Programmer and tester of numerous COBOL reports, conversions, and interface programs. Created relational database
tables accessed via SQL queries.
6 of 6