Name: Clare Fleming

Address: 36 Riverwood Gardens, Castleknock, Dublin 15.Phone: 0872409637E-mail: claremfleming@gmail.com

Summary

I am an IT professional with over 16 years software development experience with a bluechip multinational organization in the financial services sector and 1.5 years systems analysis and technical support experience in the charity sector. This includes 10 years experience at a senior analyst level incorporating team leading responsibilities both locally and internationally. I have extensive experience dealing with with clients from large multinational organizations at both a technical and business level. I have a positive outlook and work ethic and am committed to working in and contributing to a team environment. Keywords / Skill Set

SQLServer 2005/2012; T-SQL; Stored Procedures; Performance Monitoring; Data Integrity; ThankQ CRM Support; System Analysis; Business Requirements Gathering; SDLC; Functional/Technical Spec Writing; UAT Support; Code delivery; MS Visual Studio; MS Excel; MS Access; Cobol; IBM mainframe; DB2; Oracle; MS Word; CSC 'Exceed' General Insurance System; CSC 'Cogen' general insurance system; iSeries/LiFE/Life400; MS PowerPoint; XML; XSL; XSLT; Java.

Education

Feb – July 2013. Digital Marketing Institute.Professional Diploma in Digital Marketing.

2008/2009. CSC internal training.Introduction to Smart, Introduction to LiFE. iSeries Diary course for LiFE system.

2007Introduction to XML, XSL. ('itrain' in company training).

2001. Blanchardstown Institute of Technology, Dublin.Java programming (6 months night course).

1987 – 1991. Waterford Institute of Technology.BSc In Applied Computing.

1981 - 1987. Sacred Heart of Mary Secondary School, Waterford.Leaving Certificate. Higher level: English:C, Physics & Chemistry:C, Accountancy:C, Business Org:C, French D;Lower level: Maths:A, Irish:C.

Employment History:

May 2014 – Present - Concern Worldwide, Camden St., Dublin 2.Fundraising Systems Analyst.

'International humanitarian organisation; responsible for maintenance and improvement of the fundraising CRM system and MS SQL Server database, gathering/analysing business requirements and providing appropriate solutions'.

Key technologies: SQLServer 2005/2012 database programming; T-SQL; Stored Procedures; DB Job scheduling; Performance Monitoring; Data Integrity; ThankQ CRM Software Support; Systems Analysis; Business Requirements Gathering; MS Visual Studio; MS Excel; MS Access;

Working as part of the Fundraising Systems team, analysing and developing new and improved processes

and procedures to maximize effectiveness, efficiency and service to donors. Ensuring the data integrity of the CRM database by maintaining and improving data entry rules to end-

users, data validation rules for data imports and nightly jobs to detect and fix incorrectly entered data on the database.

Assisting with database administration of the MS SQL Server database, maintaining and improving performance monitoring plans.

Proactively working with ROI and UK Donor Care teams, providing system support and developing new solutions to improve the donor care service.

Working with the ROI and U.K. Marketing teams to improve and enhance the functionality of the CRM

system to keep apace with emerging traditional and digital marketing trends.

Liaising with Concerns third party providers of their Web, Digital marketing and Tele-marketing services and their CRM software system 'ThankQ'. Documenting and submitting software errors for investigation and resolution and managing change requests for development, testing and delivery.

Significant Projects/Roles:

Heavily involved with the analysis and preparation of raw data gathered from various third party marketing agencies for importation to the crm database.

Worked with the team on the integration of the Hub-spot inbound marketing software to the ThankQ CRM system using API data transfers.

Worked with the CRM manager and TM manager to develop and improve statistical analysis reports on individual activity and achievements using MS SQL server and MS Visual Studio.

Responsible for the implementation of a new helpdesk ticketing system for the Fundraising Systems Team.

June 2012 – April 2014.Career break, furthering education. Professional Diploma in Digital Marketing – Digital Marketing Institute.

May 1996 – May 2012 - CSC Ireland Ltd., Marine House, Dublin 2.Senior Application Consultant.

'US multinational software house, involved with all aspects of the full project lift cycle from refining business requirement with clients and producing specifications through to managing development, testing, delivery and live support; worked with client book of leading insurance multinationals'.

Key technologies: Cobol; IBM mainframe; DB2; Unix; Oracle; MS Word; Endevor code management system; Xpeditor debugging tool; Spufi sql tool; Abend-aid fault management tool; File-aid; CSC 'Exceed' general insurance system; CSC 'Cogen' general insurance system; iSeries/LiFE/Life400; CSC 'SMART' toolset; MS PowerPoint; IBM Websphere; XML; XSL; XSLT; Java.

Team Management - performance management; coaching; mentoring; co-ordinating and integrating completed work; quality assurance; motivating;

Client Management – client facing roles; building trust; resolving issues; professional approach;

Deadlines – agreeing estimates with client; negotiating rework timescales; monitoring progress against estimates for team; dealing with delays, showstoppers etc;

Planning/Organising – assigning tasks based on individuals experience; team meetings; client meetings; project deliveries; documentation completion and delivery;

Communication – professional level of communication with client to ensure a constructive working

relationship; enthusiastic and motivating tone with team members to create a culture of task ownership and personal responsibility;

Application analysis & development – developing CSC insurance systems for the client using cobol and sql/db2; writing functional/technical specifications; executing/supporting testing using MS Excel.

Significant Projects/Roles:

Major Bluechip insurance company - led an international team to plan, develop, test and deliver a project to convert an in-house sub-system on to the CSC Exceed insurance system on the IBM mainframe using cobol and sql. Heavily involved with database changes including data extraction, table modification and data reload into modified tables using SQL DDL, DML, DCL.

Major Portuguese Insurance company - Responsible for leading a team of programmers to add several new Client specific products to the CSC COGEN Insurance system, using the UNIX operating system, Oracle database system and SQL DDL, DML and DCL. Responsible for the technical design of these products using business specifications and through liaisons with the client and business analyst.

Large Swedish Insurance company - Part of a large project to develop a web-enabled front-end to sit on an existing backend system, responsible for writing xsl files for various functions using the xml language on IBM web sphere platform. Responsible for the writing and execution of functional test plans for the various front-end screens developed for the client.

Major International Insurance company – Responsible for the development of new functionality for the client on the CSC iSeries Life/400 insurance product using cobol, CSCs Smart toolset and MS Excel for testing purposes.

March 1993 – March 1995 - RJV Data Resources.Software programmer.

'US magazine fulfillment company, responsible for software development and testing, backups, report writing'.

Key technologies: Cobol; SQL Programming and analysis – using cobol and sql Report writing and data analysis - analyse subscriber statics by age, gender, location etc. Organising backups - daily and weekly backups of the databases

Interests.Music. Fitness. Family.

ReferencesAvailable on request.