Back Jan Bower 1 Oakwood Road Balby Doncaster South Yorks DN4 8RQ Phone : (01302) 817566 Mobile : (07880) 723369 Email : JanBower@blueyonder.co.uk

Duties at Ericsson Mobile Communications (UK) Ltd :
System Analyst Programmer

• High Involvement in Various In House Projects :
  Development of Access databases and Uniface Applications using a structured approach Project Life Cycle
  - Feasibility Plan
  - Writing of Requirement Specifications
  - Creating a Project Plan
  - Design of Project
  - Development of Project
  - System Testing
  - Acceptance Testing
  - Implementation / Handover Documentation
  - User Manual Documentation
  
• ABAP Query Report Writing : Projects being requested as 2nd line support for SAP R/3 ERP users in all Business Areas (MM,FM,CO,SD,PM,PP,LO etc).
  This involves developing the Functional Area Structures for further use in creating the ABAP Query.
  I have an in-depth knowledge of SAP R/3 database tables, logical databases and structures needed to create ABAP Queries.
  
• MS Access Development : Departmental Projects
  I have written various MS Access databases for specific purposes.
  - Data Management Group Task Issuing Database
  - IT Software Asset Register Database
  - IT Helpdesk Database
  - Including Data Objects and Active X components
  
• Various Data Extractions and Manipulations :
  - Use of Unix C scripts, Informix SQL and various Reporting tools to extract live data from legacy systems to prepare for uploading into SAP R/3 ERP package at data take-on time
  - Using Software tools such as MS Excel Macro writing and VBA
  - Handling large data extractions with ACL 6 for Windows Reporting tool to show Financial Reports - such as VAT Audit and Reconciliation reports where the number of records exceeds 65000 rows
  - Analysis of large amounts of Data using Cognos Powerplay to show anomalies on Control Output machines on the Shop Floor

• Various Data Cleanup :
  - Creation of routines in SAP to define records for cleanup, archive and deletion

• Data Clean Up and Extraction from Legacy systems ready for SAP r/3 Go Live :
  - Creation of various reports in legacy system to show the Business areas needed to be cleansed
  - Generation of temporary Tables and Dictionaries to extract cleansed data ready for input into new SAP R/3 ERP system
  - Use of Automated scripts to run routines daily
  - Ability to follow set Project plans to attain the results needed in tight deadlines
  
• UNIFACE Development :
  - Creating screen forms and reports to show Statistical Analysis of dynamic Production Line Test Results
  - Using Libraries and Repositories

• Contractor for Report Writing Skills :
  - Creating Queries and Reports from CISAM and Informix Tables on NT, AIX and UNIX servers
  - Using a Report Writer tool called Reporter
  - Using Dictionary structures
  - Using Informix SQL
  - Automating Reports to run at specific times - using Cron scripts and Unix C scripting
  
• Training Course Development :
  - Technical Information to be used in a 5 day course presentation to Customer / Users.
  - Creating Training material - manuals, overhead projection documents, MS Powerpoint presentations and handouts
  - Holding the training course for up to six Customers / Users at a time.
  
• Computer System Administrator :
  - Sole IT person dealing with all aspects of a IBM AIX server based MRP software package with 24 users.
  - Setting up Users, Passwords, Security, Reporting, Training, Backups, Screen Developments etc
  - Creating Business Processes for Users
  - Complete Upgrade from a legacy IBM System 36 system to a IBM RS6000 
  
• Home Brew Shop Manageress :
  - Handling all transactions from ordering, banking, credit card payments, wages etc.