Russ Wagner 403-400-4721
SAP certified ABAP/4 programmer Calgary, Alberta

Profile
An SAP certified ABAP/4 programmer with over 12 years of experience in SAP including multiple implementations, upgrades, and the ongoing duties of maintenance and support.
A highly driven, results-orientated with 20 years of proven success in computer software, computer hardware, customer service, and support.
Expert knowledge levels in accounting, point-of-sale, inventory control, and management reporting systems.
Participated in multiple implementations and upgrades, as well as provided ongoing service and support as part of a sustainment team.

Technical
HR ABAP developer, part of a HR implementation (net payroll).
Canadian payroll interfaces to/from Ceridian (master data, transactional data, and GL posting).
Canadian and US payroll interfaces to/from ADP (master data, transactional data, and GL posting).
Various inbound / outbound interfaces in HR, FI, AR, AP and PS.
SAPScripts and Smartforms (HR cheque, SD order confirmation, quotation, picklist).
Custom reports in HR, AR and CATS (ALV and Standard List).
Custom Infotypes (Incentive Compensation, Employment History, Bonus History).
Numerous HR and CATS user exits.
Employee benefits extracts (Great West Life, Morneau, EDS, Sun Life) using PU12.
BAdI’s (disable Org. Structure button, add buttons to FBLxN tranx’s, 401K contribution override, benefits calculations, start dates, and participation dates).
Payroll function to calculate monthly, quarterly, and yearly commissions to be included in payroll results.
Implementing the Environmental Health & Safety (EH&S) module (including Excel/SAP integration).
C# (Visual Studio) web services for data validation using SAP’s .Net Connector and SOA.

Experience/Project Work

Industry: Oil & Gas
Project Description/Scope: SAP Implementation
Role: SAP HCM Technical Developer Duration: 8 months – Present
Responsibilities/Deliverables:
Numerous HR BAdI’s, including: Screen modifications to infotype screens, LTD coverage amounts, Benefits calculations, benefit start and participation dates.
Great West Life interface.
Smartforms/SAPScript: Order Confirmation, Quotation, Picklist, consignment fill-up order, HR cheque.
Conversion: Load certificates and training documents (.pdf’s, .tiff’s, .doc’s) into infotype 0024 (qualifications).
Mentor junior developers.

Industry: Transporter
Project Description/Scope: SAP Implementation
Role: SAP HCM/Payroll Technical Developer Duration: 12 months
Responsibilities/Deliverables:
Canadian payroll interfaces to Ceridian Insync (master data and transactional data payroll data).
Inbound interface from Ceridian to create ‘parked’ GL documents.
Custom Infotype – Incentive Compensations, Employment History, Bonus History.
Custom HR user-exits including, Infotype 0002 (personal data) override begda with hire date not birth date. CATS prevent posting to multiple cost objects on line entry, prevent posting to home cost centre or blocked cost centre’s. Override/modify time sheet defaults. Display Vacation, Banked O/T and Flex time on CATS entry screen. Activity type override. Disable “Org.
Structure’ button on infotype 0001.
Modified various reports to allow execution in ESS/MSS.

Industry: Energy
Project Description/Scope: SAP Implementation
Role: SAP HCM/Payroll Technical Developer Duration: 12 months
Responsibilities/Deliverables:
Canadian and US payroll interfaces to ADP (master data and transactional data)
Custom Infotype – Incentive Compensations (using transaction PM01).
Custom HR user-exits.

Industry: Chemicals- Calgary, Alberta
Project Description/Scope: SAP version: ECC 5.0
Role: SAP HCMTechnical Developer Duration: 3 months
Responsibilities/Deliverables:
Modified to employee benefits extracts (Morneau, EDS, Sun Life) as part of the creation of a new company division (new SAP client).

Industry: Utility
Project Description/Scope: SAP version: 4.6C and ECC 6.0
Role: SAP Technical Developer Duration: 24 months
Responsibilities/Deliverables:
HR Employee Master Data Interface for Ceridian/InSync (external payroll provider). Basic pay (infotype 0008) and benefits (infotype 0171) information (among other’s) using logical database PNP, macros, and clusters.
SAP’s EH&S (environmental health & safety) module.
Work consisted of two components. One: Create an Excel form (VBA) that incident reporters can use off-line to file reports. Two: Write an ABAP program using SAP’s Desktop Office Integration (ABAP Objects) that can read the form, collect the data, validate it, and then create incident/accident logs (CBIH82) based on that information.
Inventory replenishment program (MM).
Gave FI, CO, and MM support.

Industry: Telecommunications
Project Description/Scope: SAP version: 4.6C
Role: SAP HCM Technical Developer Duration: 5 months
Responsibilities/Deliverables:
HR Function (PE04) for the calculation of monthly, quarterly and yearly commissions.
HR BAdI (PE18/19) for checking/over-riding 410k contributions limits.

Industry: Technology Services
Project Description/Scope: SAP version: 4.7 Enterprise
Role: Senior Consultant Duration: 10 months
Responsibilities/Deliverables:
ABAP Team (Enhancements and Interfaces). Review functional specifications, creation of technical specifications, estimations of effort, resource assignment, and progress monitoring.
Contributed to the creation of a number of work products including Business Charter, Technical Requirements Plan, Documented Requirements for Custom Development, Documented User Interface requirements.
Project Planning using Microsoft’s Office Project (task assignment, resource assignment and leveling).
Rated “Significantly Exceeds Expectations” in performance review by Managing Director and Project Manager.

Industry: Energy
Project Description/Scope: SAP version: 4.7 Enterprise
Role: Plant and Field Support Duration: 19 months
Responsibilities/Deliverables:
SAP Microsoft Office Desktop Integration (DOI). ABAP programmatic creation of an Excel Inspection spreadsheet that is used in the field by inspectors, then uploaded into SAP.
Web Application Development and Sustainment (ITS and Web Studio) Equipment Tracking and Maintenance.
Administration of INTools, PCMS (Plants condition and maintenance systems), LIMS (Laboratory Information Management System) systems. Configuration, maintenance, users, security.
Visual Basic programming of interfaces between various non-SAP Enterprise systems.

Industry: Energy
Project Description/Scope: SAP version: 4.6B to 4.7 Enterprise
Role: SAP Developer Duration: 5 months
Responsibilities/Deliverables:
SAP Enterprise Upgrade (from 4.6B) FI/MM modules.
Resolve SPAU entries.
Correct FI/MM processes failing as a result of upgrade.

Industry: Utility
Project Description/Scope: SAP Implementation
Role: SAP technical developer Duration: 3 months
Responsibilities/Deliverables:
Backfill for vacationing PS technical members.
Year-end asset Disaggregation
PS project reports using report painter (drill-down reporting).

Industry: Utilities
Project Description/Scope: SAP Implementation
Role: Consultant Duration: 10 months
Responsibilities/Deliverables:
Document achieving with IXOS software (bar-coded reports and SAPScript).
User-exits for customized functionality with purchase orders.

Industry: IT Services
Project Description/Scope: SAP Implementation
Role: Consultant – ABAP/4 Programmer: Level 3 Duration: 3 years 8 months
Responsibilities/Deliverables:
Creation, completion and maintenance of complex programs including:
Reports (including ALV – abap list viewer).
Dataloads for the one-time import of legacy data into SAP (BDC, call transaction, LSMW).
Interfaces with legacy systems for periodic processing (BDC, call transaction, LSMW).
SAPscript documents (such as customer statements, invoices, reports and shop papers).
Modifications of existing SAP delivered reporting and data selection programs (print programs).
Bar-coding and graphics within SAPscript.
Table creation and maintenance.
Dialog programming.
Field exits, user exits.
OSS notes, SAP repairs (fixes) and enhancements.
EDI configuration and sustainment (with Sterlings ‘Gentran’).
ALE configuration and Idoc processing.
Typical sustainment duties (program modifications and fixes).
3.1H to 4.5B upgrade (SPAU and SPDD).
Primary modules included FI, SD, MM, PS and PM within versions 3.1H, 4.5B, 4.6C, 4.7, ECC 5/6

Non SAP Experience:

Industry: Services- Calgary, AB
Role: General Manager Duration: 8 years
Responsibilities/Deliverables:
Designed, developed, documented and maintained ‘The Retail Companion’ Point-of-Sale Software. A windows based computer program which acts as a front-end from general merchandise sales.
Compatible data interchange with a number of off-the-shelf accounting programs including, MYOB, QuickBooks, Peachtree, and others.

Industry: IT Services- Calgary, AB
Role: General Manager Duration: 6 years
Responsibilities/Deliverables:
Sales, installation, training, support and service of Retail Point-of-Sale, Inventory Control, Accounting, and Financial reporting systems.

Industry: IT Services- Calgary, AB
Role: General Manager Duration: 6 years
Responsibilities/Deliverables:
Sales and support of hospitality systems to hotels and restaurants.

Education & Certification
Matriculated Diploma, Crescent Heights High School

Certification:
SAP Partner Academy Certified – ABAP/4 Development Workbench
Cert. ID: 0000767916 06/98

C#, ASP, XML, SOAP, .Net, Web Services, VBA, VB: Self-study

PS-CD: Public Sector Collections and Disbursements (IPS51/PSCD 4.72).
IS-MW: Industry Solution Migration Workbench (IUTW90/FI-CA).
CRM Base Customizing: Customer Relation Management (CR100).
Interaction Center: Interaction Center WebClient in CRM (CR410).
SAP .Net Connector: .Net (dot-net) Connector Programming in C# (Windows/Web-based) (BIT528).
Oracle DBA Certification: Mount Royal College-132 hrs, incl. Data Modeling & Design, Introduction to SQL PL/SQL Plus, Extended Data Retrieval & PL/SQL programming.
SAP BW: SAP Global Training Center Dallas (3 weeks – Feb. 2001).
BW200 – BW Overview, BW205 – BW Reporting.
BW209 – BW Web Reporting, BW210 – BW Configuration
BW220 – BW Extraction
SAP EDI/Idoc: PricewaterhouseCoopers Training Center, Philadelphia, PA.
Electronic Data Interchange/Intermediate Doc. (5 day-Oct. 99).
SAP HR 350: Programming in HR Release 4.0 (3 day – March/99).
C++: Introduction to C++ UBC (6 week [nights] – January/99).
SAP ABAP Workbench 4.0: Introduction to ABAP Workbench Release 4.0 (2 day – Jan./99).
Interax Corp.: Myers-Briggs Communications Workshop (2 day – Oct./98).
OmniLogic “Omnium”
Methodology Training Strategies in Successful SAP Implementations (1 week-June/98).
OmniLogic Boot Camp Introduction to SAP Functionality in FI, CO, SD, MM (2 week).

Citizenship: Canada

Mobility: Willing to travel

Languages: Written and spoken fluency in English

Page PAGE 2 of NUMPAGES 5

Consultant’s Profile

Consultant’s Profile

SAP for Regional & Local Governments
Dragan ?†panoviƒá
Managing Director
SAP West Balkans
Agenda
An Introduction to Regional & Local Government – Glasgow City Council
What Pressures and Drivers do RLG face today
What do Citizens Want Today
Agenda
Glasgow City Council overview
What Solutions does RLG need?
SAP for Regional & Local Government -Breadth of Solution
Transforming Regional & Local Government
Glasgow City Council
Glasgow City Council
Agenda
Regional & Local Government – Over 300 Customers in more than 70 Countries
SAP Worldwide

–û—Ç—Å—É—Ç—Å—Ç–?–?–µ –?–?—Ç–µ–?—Ä–?—Ü–?–? —Å—Ç—Ä–?—Ö–æ–?–æ–? –? —Ñ–?–?–?–?—Å–æ–?—ã—Ö —Å–?—Å—Ç–µ–º —É—á–µ—Ç–?
Allianz Business Services
–ü–ª–?–? —Ä–?–?–?–µ—Ä—Ç—ã–?–?–?–?—è SAP

–§–æ—Ä–º–? 1
–§–æ—Ä–º–? 2
–§–æ—Ä–º–? 4
–-–?–±–?–?–µ –æ—Ç—á–µ—Ç—ã SAP BW

The citizen of 1 ICT for social protection in the digital age
Who would have that thought this headline could be published and taken seriously?
The link? Convergence the Smartphone at the centre of commercial and government service experience
Global Smartphone Penetration – 35% and growing – 7bn mobile phone subscriptions – Kazakhstan is on a similar growth curve
A traditional view of IT in social protection -the core social processes
A reliable core social security ICT system is expected -but it is not enough
IT is following a similar path to the manufacturing maturity cycle – the consumer/citizen of 1
Rising citizen expectation from digital convergence is leading to the 2-speed ICT shop
Digital Government -a new paradigm
Examine social policy to service delivery in terms of a continuous improvement cycle
The modern social protection system design paradigm -serving people ahead of the organisation

The future : creating a platform to encourage innovation in apps development from across the social ecosystem
Leveraging data to drive the omni-channel engagement -around citizen needs and choice
SAP for Social Protection Empowering people to achieve their social and economic potential
For more information
Please contact : Brian Lee-Archer
brian.lee-archer@sap.com

discover.sap.com/sap-institute-for-digital-government

Business Capability Model for Social Protection

General Fund Enterprise Business System Update
Army Day
2 June 2010
What is the General Fund Enterprise Business System?
GFEBS Complements Objectives Of Secretary of Army And Chief of Staff
Support the Accomplishment of Our Strategic Objectives in Iraq and Afghanistan
Continue Efforts to Restore Balance
Sustain Soldiers, Civilians and Families
Establish an Integrated Management System for Army Business Operations
Effective stewardship requires an integrated management system for the Army’ s business operations…
It also requires an information architecture that provides decision makers with timely and accurate information
With these systems in place, we can generate the most capable and ready Army at the best value for our country.
Implement the Army Leadership Strategy
Refine the Army of the 21st Century

Where We Are and Where We Are Going
General Fund Enterprise Business System Overview
Project Status (As of May 2010)
GFEBS Currently Has A Sizeable Footprint
System Performance
Implementing Change Is Not Easy – – Change Management Is Important
Lessons Learned And Key Actions Taken
Using chain of command to inform and actively engage all levels of the Army in the deployment process
Lengthened deployment timeline to 15 months for each Wave
Created a GFEBS Deployment and Transformation Team
Developed an integrated management schedule for deployment with activities of the program office and gaining organizations
Implemented Power User Program
Improved and proactively managing End User role assignment process
Redesigning and revising End User training materials
Revised way we engage organizations to collect and prepare data
Actions For Smooth And Successful Implementation — Roles
Learn what activities each role can perform and then assign all the roles you need to perform your mission
Get and review lessons learned from Early Waves
The tasks an end user can perform in GFEBS are governed by roles assigned and training certified
Therefore supervisors must assign all necessary roles to each user on time to support adequate scheduling of courses
Supervisors must get employees to end user training prior to go live

Field Comment: More work could be done explaining the roles. The deployment team tells folks 7-10 roles per budget analyst often need more

Actions For Smooth And Successful Implementation — GRC
Learn how to use Governance, Risk, and Compliance (GRC) software
GRC is a web-based application for managing end user role assignments and security

Field Comment: GRC role assignment software is Greatest improvement since the Wave 1 transition. It lets the field fix its own issues.

Actions For Smooth And Successful Implementation -Interfaces
Coordinate with GFEBS to make sure that interfaces you need are identified, tested and working when you Go-Live with GFEBS
Data structures need to be compatible for effective data transfers (e.g FCM, ATAAPS)
Interfaces need to be tested (e.g. SPS)
GFEBS and legacy systems owners need to work together

Field Comment: Wave 2 received much more help in updating interfacing systems prior to conversion. Though much more could be done here.
Actions For Smooth And Successful Implementation -Power Users
Capitalize on your Power Users
They are the primary GFEBS functional experts in your organization with classroom and òsandbox’ experience
They can relate GFEBS processes to your current business practices

Field Comment: Power User participation in Instructor Lead Training courses was a terrific help

Actions For Smooth And Successful Implementation -IMS and Reporting
Review list of preparation tasks in the Integrated Management Schedule (IMS) and report on progress in the Site Readiness Scorecard
IMS provides a list of tasks through time, based on prior deployments, to walk new organizations to implementation
Site Readiness Scorecard involves monthly reporting on progress from each new organization through their chain-of-command

Field Comment: This will provide you with information on whether you are generally on schedule or need help.

Actions For Smooth And Successful Implementation -Deployment Team
Know how to find and use the GFEBS Deployment Teams that are on-site at and after Go Live
Teams include GFEBS project personnel and individuals from organizations that previously went live
They are on-site for up to several months post Go-Live

Field Comment: GFEBS Deployment Teams are much more familiar with Army processes and have become a great help during deployment vs. just helping enter a help ticket. They also know who to call to get things fixed. Great improvement.

Example of What You Can Get From GFEBS Economic Recovery Act îFunds Status

GFEBS Is Transforming the Army
GFEBS is coming to you
Army-wide implementation by 2nd Quarter FY1012
The GFEBS system is performing well
Change is difficult — we need everyone’ s support
We are always looking, listening, learning and trying to improve the process
Good and detailed planning leads to smoother and more successful operations — you should begin your planning now!