SUMMARY:

• Ten years working with document composition software (OpenText Confidential ), composing and configuring output documents and files, and managing the production and distribution of documents produced from ERP applications such as SAP and Dynamics AX.
• Many years using SQL in different forms.
• Several years as a Data/MI Analyst using SQL, Access, and Excel.
• Recruited and managed a team of 12 support analysts working in 1 st and 2 nd line support for Confidential, the world’s largest food packaging company.
• A couple of years as a pre - sales consultant in the IBM mid-range arena (S/3x and AS/400 computers).
• My role was to assist Sales in completing tender documents, and to provide presentations and demonstrations of proposed accounting and order processing solutions.
• Over 20 years as an Analyst/Programmer working with COBOL:
• COBOL on Data General using ISAM and DBAM files structures and embedded SQL file access: Data General’s implementation of SQL has full transaction logging and its own fully featured T-SQL environment.
• Migrated 1500+ programs and macros for Confidential from Data General proprietary O/S to MicroFocus Net Express.
• MicroFocus COBOL in a Windows NT environment using ISAM files and UFOS access (an emulation package based on Data General’s DBAM files structures (multi-level ISAM files).

PROFESSIONAL EXPERIENCE:

Confidential

Advanced Excel Administrator/MI Analyst

Responsibilities:

• I redesigned the Bid Register, improving the content and presentation.
• The Register is used by the Bid Manager and Sales Executives to monitor the progress of customer quotations, and to provide reports and statistical analysis to management and sales personnel. Improvements were achieved by:
• Changing the visual style and bringing to the fore the workflow.
• Redesigning the structure of the Bid Register and adding additional external linked Workbooks to facilitate statistical reporting.
• Automating manual tasks using VBA routines for Outlook and Excel.
• Enhanced the presentation of information using charts and pivot tables.

Confidential Consultant

Confidential

Responsibilities:

• Installed Confidential 5.5 Build 1279 on the Development, Test, Shadow, and Production servers which were new servers (VMs) built with Server 2008.
• Coached and then worked with Confidential 3rd Level Support to create Confidential Oracle repositories on the new servers, and SQL Server repositories on the local development and testing machines.
• Migrated current applications to the new servers and resolved all connectivity issues with the Network, JMS Queues, and ESB connections.
• Worked with the Billing Team to update existing Confidential templates, produced supporting documentation, and provided and best practice guideline to enable ongoing basic changes by the Billing Team.
• Provided software application support to the Billing Team and 3rd Level Support.
• I working to Agile principles using Salesforce to help track and manage events, and JIRA for documenting and managing change requests. SVN was used for source code control.

Confidential Consultant

Confidential

Responsibilities:

• My role with Confidential was to provide Confidential production support following the implementation of upgraded Confidential applications.
• I worked with Infosys consultants to provide additional technical support, working to Agile principles with Scrum methodology.
• SAP/TIBCO input in the form of XML and RDI files.
• Confidential Persuasion 5.6.1.using Design Center, Control Center, Document Broker Plus, Storyteller, Composition Center, StreamStudio, and Post Processor, DBAT.
• Unix/Linux installation using Oracle back end databases.
• Output from Confidential in the form of XML, JMS, PDF, email, and AFP.
• Provide support during consolidation of changes made by Confidential to upgrade Confidential ’s Confidential applications to Persuasion 5.6.1 to take advantage of Document Broker Plus.
• Assisted in performance testing following changes made by Confidential to solve significant performance issue.
• Bug fixing and application maintenance. Web based Axios Assyst service management software was the platform used for reporting and managing software problems, linked in to JIRA issue management software.

Data Analyst

Confidential

Responsibilities:

• My responsibilities were for the analysis of market research survey results and the distribution of reports.
• I created and setup the online surveys, received the resulting data from clients by email or directly online, and processed the data, producing and distributing the reports.
• Some data was received from clients by post for offline surveys, mostly in Excel form, which was formatted manually, and in some cases imported into Access for further analysis.
• Automated some manual processes, cutting down the time to process some surveys by 75%.
• Successfully produced time critical reports to tight deadlines.

Document Composition Consultant

Confidential

Responsibilities:

• Business Requirements gathering.
• Stakeholder management.
• Document design (Billing).
• Confidential builds and testing.
• Upgrading to the most recent release of Confidential, splitting the existing Confidential applications up into smaller sub-projects, and using newer Confidential were all evaluated and recommended.
• PowerPoint was used to present the information and give the audience an opportunity to see what could be achieved.

Confidential

Consultant

Responsibilities:

• I provided the Confidential solution for a new ERP application being developed for Confidential by Confidential adhering.
• This was the largest implementation of Microsoft Dynamics AX in Europe and run to some very tight deadlines using Agile principles and the Scrum methodology.
• My role was to design and implement the document management solution alongside the Logica consultants and Confidential Solution Architects. XML files were used as the data transport mechanism between the AX application and Confidential .
• Installed Confidential 5.5 (Persuasion) on Production, Test, and Development servers located in Sweden.
• Designed the overall Confidential solution in Design Center using Confidential tools XMLIN, PageOUT, StoryTeller, Document Broker and Post Processor Queries, and all output documents working with Confidential Workstream Leads and Logica Consultants.
• Created XML schemas for all document designs to interface with the Dynamics AX ERP application.
• Created Confidential scheduled tasks for housekeeping the running applications.
• Provided application support for the new Confidential application, initially giving first and second level support, and eventually the Logica support team and transferring responsibility to them.
• Successfully completed and handover to the Logica Confidential Support team.
• All Confidential work was completed on time and to the tight deadlines set by the Logica Project Manager.

Senior Support Analyst

Confidential

Responsibilities:

• Recruited and developed a support team for the Confidential legacy applications (accounting, spare parts administrations, packaging administration).
• This was initially a team of 4 which grew quickly to a team of more than 12 analyst programmers.
• Specified, coded, and tested changes to Confidential ’s Packaging Administration System (PAS) to comply with the requirements of the use of the Euro and multi-currency financial transactions.
• Upgraded Confidential ’s COBOL applications for Confidential (more than 1,500 programs and runtime macros).
• Migrated Confidential applications written in COBOL from a proprietary Data General platform, to Microsoft NT servers using Micro Focus COBOL in a Micro Focus Net Express environment.