|
PROFESSIONAL
OVERVIEW:
An experienced Business Object / Database Specialist with a
proven track record of success in the commercial SME market
sectors. Creating strategic solutions to resolve complex
technical issues and to enable client to maximise application
potential. A strong pro-active leader, empowering staff to take
ownership, providing coaching and mentoring to build cohesive
teams working together to achieve individual targets and company
objectives.Results oriented and client focused, building
excellent working relationships with both internal and external
customers and clients. Experienced in business objects, database
software, data warehouse tools, ERP systems, business analysis
and financial management and control.
Business
Objects
·
Building testing & implementing all reporting requirements using
BO reporter version 6.5.1
·
Gathered requirements, agreed timescales and delivered and
implemented end user solution
·
Based the accounting reports on requirements from the Sage Line
500 accounting system
·
Enhanced data warehouse to produce solution including extra
tables, views & joins to supplement source data
·
Added supplements to Unix server database using SQL and then
appended to relevant BO universe
·
Maintained 5 divisional Unix databases with their own BO
universe
·
Provided users with a visual display of all factors involved in
MRP in a single BO report
·
Utilised BO Supervisor to set up and maintain users
·
Set up around 100 reports scheduled to run overnight using BO
Broadcast Agent
Database
Software
·
Used Informix SQL 4.2 on a Unix server running AIX Release 3
·
Created and maintained 5 databases, associated schema files and
the links to the Sage data files
·
Maintained & enhanced Microsoft Access to provide some data
entry front-end screens to some users
Data Warehouse
Tools
·
Used SQL to create and maintain the data warehouse of 5
databases linked to standard Sage system
·
Added Summary tables to supplement the Sage system to facilitate
faster report production
·
Created separate database & BO universe to store fixed subset on
year-end data files for financial year end
·
Ran various SQL scripts to populate each data warehouse, then
reconciled back to the source data
·
Migrated from Chess legacy system into the Sage system using SQL
to design & write ETL programs
Software Developer
[snip] 2004 to Date
·
Responsible for maintaining and enhancing complex BO
applications and data warehouses providing a view of MRP
operating multiple universes over multiple databases
·
Enabled interfacing with Sage ERP on a Unix platform to
auto-generate Purchase Orders into Sage
·
Allows for displays of current stock, sales forecast, sales
history & purchase order data using Access front-end
·
Scheduled reports to run overnight with distribution over the
network using the BAC
·
Converted legacy Informix reports into BO and used BAC and WEBI
for report distribution
·
Converted legacy bespoke Unix MRP system into Sage ERP using own
ETL SQL scripts
·
Developed & maintained back-end data warehouse using SQL,
consisting of 2400 line Unix/SQL script
Freelance Business Objects Specialist [snip] 1999 to 2004
·
Responsible for office automation projects interfacing between
Informix databases, Sage Tetra & Microsoft back office using
ODBC and FTP
·
Provided extra data entry screens, reports & databases to
customise the Sage system to maximise use
·
Manipulated data in Excel and transferred into the Sage Tetra
via Informix database
·
Migrated a legacy Finance & MRP system into the Sage Tetra
application
·
Transferred receipts & payments between HSBC Hexagon banking
system to & from Tetra sales & purchase ledger cash batch files
over the network using FTP
·
Interfaced between sales ledger Intrastats transfer files to
Customs & Excise web site
·
Worked towards meeting Sarbanes Oxley legal requirements for
BS7799
·
Carried out data conversions from legacy systems into Sage Line
500 CS3
Senior Technical Consultant Customer
Engagement Company 1997 to 1999
·
Responsible for providing software development solutions to a
variety of customers
·
Project managed an integrated Document Management system
·
Integrated Tetra Financials, Informix V7, Access 97 and
Watermark
·
Developed Cognos Impromptu & Powerplay complaints indexing
reporting system & data warehouse
Early Career includes:
·
Owner / Director
Crystalclear Computer Services 1990 to 1997
·
Self
Employed
1989 to 1990
·
Database Team Leader Tetra Business
Systems 1987 to 1989
·
Installation & Support Technician Databasix
1984 to 1987
·
Installation, Training & Support CCL / Travicom
1980 to 1984
·
Trainee Chartered
Accountant
1977 to 1980
·
Business Objects Reporter, Designer, Supervisor 6.5, BAC,
Infoview (WEBI)
·
Sage Line 500 Tetra CS3 ERP Financials, Distribution,
Warehousing, Bill of Materials
·
Works Order Processing, Job Costing & Payroll
·
Informix SQL RDBMS to version 7, Informix 4GL maintenance
programming
·
Access & ODBC
·
Unix HP-UX 11, AIX 4.2, SCO Unix
·
Unix Shell programming, FTP scripting, SQL 6.5, Crystal Reports
8.5
·
Cognos Impromptu, Powerplay Business Intelligence Reporting
·
Linux under RedHat
·
NT4, Windows 95 to XP
·
Watermark Document Management
·
Project Management and man-management
·
Software specification and End-User documentation
·
System and User Acceptance Testing
·
On-site hands-on training
EDUCATION, PROFESSIONAL TRAINING & QUALIFICATIONS:
·
BSc Economics
·
Diploma in Management Studies
·
3 ‘A’ Level & 10 ‘O’ Level qualifications achieved
·
Full clean Driving Licence
·
References available on request
|
