Sql Server Computer Operator
Resume:
Curriculum Vitae
Melvin P Hones MBCS
Address
** ********, ***** *********, ***** HP2 5PU
Telephone
014**-****** (H) & 079**-****** (M)
********@*****.**.**
Personal Profile:
An IT Professional with 32 years of IT Commercial experience within the Insurance, Banking, Retail and Leisure sectors.
Proficient in a broad range of technical software and packages with core technical competencies in development technologies such as SQL Server 2000, 2005, 2008 & 2012 (T-SQL, SSRS and DTS), Cognos 8, COBOL, DB2, IMS and CICS. With experience of system support and different aspects of the Software Development Lifecycle from analysis through to design, development and deployment along with the implementation of industry best practices for development (including ITIL).
Career History:
Waitrose
(Contract Role - Jan 2016 – Sep 2016)
Waitrose is a chain of British supermarkets, which forms the food retail division of Britain's largest employee-owned retailer, the John Lewis Partnership. Its head office is located in Bracknell, Berkshire, England. As of February 2015, Waitrose had 344 branches across the United Kingdom, including 30 "little Waitrose" convenience stores, and a 5.1% share of the market, making it the sixth-largest grocery retailer in the UK.
Working as an Applications Operations Technical, provided 3rd line support for incident, problem and change via the work queues in the ServiceNow system.
Creating/amending SQL Server 2008 timed Jobs, producing numerous ad-hoc reports using SQL Server 2008 (T-SQL) queries to produce reports and creating/amending COBOLII Programs as required.
Support and promote strategic IT Service Management policy and processes throughout Waitrose IT.
Support any development work taking place within Merchandising and Ticketing systems team itself and also in other teams which require Merchandising or Ticketing input.
Achievements:-
Part of the team that created in-house Service Counter Tickets that were previously produced by a 3rd party, thus saving the company £900,000 per year.
Designed, coded, tested, implemented and supported changes that added the Block/Shelf/Sequence details to tickets in Branch. This greatly assisted the Branches in quickly locating each product to be ticketed.
Designed and coded Ticketing changes to highlight reductions in product price. This led to increased sales in all Branches.
Saved roughly a million sheets of paper (and associated costs) by reducing the amount of unnecessary Mainframe reports produced, including merging/removing various reports.
Created a new report which gave Branches a heads-up of the Impact of future Layout Group Changes, thus giving more time to plan staffing levels etc.
Provided high-quality design/coding/testing work for the Ticketing & Merchandising systems.
Reduced the number of problems and incidents by making appropriate system changes.
Ensured Wiki and other support documentation was kept up to date.
Built good relationships with end-users and colleagues alike.
Fixed live data via the Change Management system as required.
Thermo Fisher Scientific
(Contract Role - Nov 2012 – Dec 2015)
With revenues of $12 billion, Thermo Fisher Scientific have approximately 39,000 employees and serve customers within
pharmaceutical and biotech companies, hospitals and clinical diagnostic labs, universities, research institutions and government
agencies, as well as in environmental and process control industries. Their products and services help our customers solve
complex analytical challenges, improve patient diagnostics and increase laboratory productivity
Working as an Application Support Analyst, helped maintain the FCS applications, made data changes in accordance with FCS data
change process and produced reports as required ensuring service of the applications were provided to a high standard of production
and availability.
Creating/amending reports using SSRS (2005 & 2008) as well as creating stored procedures, views, jobs, etc using T-SQL.
Extensive use of SQL Profiler.
Achievements:-
Quickly responded to and resolved IT application request and queries logged via the IT Support Help Desk in accordance to priorities set and the associated SLA’s and in general provide guidance and IT support to FCS users when called upon in respect of the applications.
Generated database queries to extract data for end users as guided by the Help Desk or Desktop & Application support supervisor.
Produced documentation required by business regulations to support data changes and database development.
Organised workload to ensure priority is given to critical systems in association with the Desktop & Application support supervisor.
Gained Business knowledge through internal training of the FCS business in order to contribute to the development of bespoke systems.
Assisted with the installation, control and maintenance of the applications and databases for FCS Horsham.
Fixed raw data on a daily basis.
Dealt with exceptions in a timely, professional manner.
Ensure all IT SOPs relating to application development are followed to deliver an IT service in accordance with the regulations governing our business.
Interfaced with FCS users to provide support as necessary.
Accurately documented processes.
Provided ad hoc management information as required.
Bourne Leisure Limited
(Contract Role - Jan 2011 – Mar 2012)
Bourne Leisure is the UK’s number one leisure business. Operating three of the most successful holiday brands – Haven
Holidays, Warner Leisure Hotels and Butlins – have been providing holidays for millions of families since the 1960’s.
Working as a Systems Support Analyst alongside the Finance department supporting a web-based purchase order system,
including occasional site visits to assist and train users.
Extensive use of SSRS 2005 & 2008 and T-SQL.
Achievements:-
As 1st line support, responded to and helped resolve day to day system queries from both Parks and Head Office.
Created a monthly SQL procedure that initially notified the users, then deleted any invoice > 6 months old that the user had not asked to be excluded from the deletion process. This made far more accurate accounting possible.
Produced/amended various reports via SSRS, including the provision of accurately measuring all unpaid invoices and their value, which was used to “clean up” the systems.
Created email alerts using T-SQL, HTML & XML to pro-actively report potential data errors before they reach the system.
Amended numerous Cognos D-CUBES, D-LINKS and D-LISTS to cater for a new Charter Of Accounts system.
Monitored and acted upon failure email alerts quickly and efficiently.
Maintained administration, including security/permissions.
Supported end users and trained new users in a helpful “can do” manner.
Ensured reconciliation against the accounting system.
Ran general house-keeping of the system and data
Ensured completion of workflow.
Other Roles:
Company
Date
Title
Description
Lloyds Banking Group (formerly HBOS)
Permanent Role - Mar 2007 to May 2010
Senior Analyst Programmer
Originally part of the COBOL, CICS and DB2 arena, responsible for design and coding on a single Box Management to support the daily allocation of units to funds. Developed Services to deliver this ground breaking high visibility solution.
In the SQL Server arena, responsible for supporting and developing reconciliations for the Investment Accounting and Finance Operations area. Skilled in Autorek, SSRS, and T-SQL.
Designed Functional Design Documents and amended/created Service Definitions.
Provided high-quality design/coding/testing work for a number of other Insurance & Investment systems.
Cross skilled from COBOL/DB2 to a Microsoft SQL Server environment.
MBA Ltd (onsite at the European Patent Office)
Contract Role - Dec 2006 to Mar 2007
Senior Analyst Programmer
Responsible for analysis, design, programming, testing and documentation. Also had involvement with integration testing, and Liaised as necessary with the user community, operation staff and related development groups. Provided analytical and technical expertise on a critical project which updated the computer systems at The European Patent Office in The Hague, Holland, to be in line with the new laws/rules governing the Patent process, which came into effect in December 2007.
Xansa (onsite at Bank Of Scotland
Contract Role - Jan 2002 to Nov 2006
Senior Analyst Programmer
Working initially within the Commercial Systems Support team, was made a team leader within 3 weeks of joining the project. Subsequently worked on a large data migration project that was successfully released into production, on time and to budget
Xansa (onsite at Bank Of Scotland)
Contract Role - Jul 2000 to Dec 2001
Senior Analyst Programmer
Led a small team during coding, testing and implementation. Also provided expert technical advice to the offshore team
Xansa (onsite at Sainsburys)
Contract Role - Jan 2000 to Jul 2000
Senior Analyst Programmer
Key member of a team that modernised the pay structure for 100,000 employees of this major retail organisation
Xansa (onsite at Tesco)
Contract Role - May 1998 to Dec 1999
Senior Analyst Programmer
Worked in a team that smoothly converted a large system from Imperial to Metric. Also provided out of office hours support during the implementation of this project
Xansa (on the Royal Insurance project)
Contract Role - Sep 1995 to May 1998
Senior Analyst Programmer
Worked in a large team on a high profile project involving the successful integration of two large insurance organisations working towards aggressive target dates
Xansa (on the John Lewis project)
Contract Role - Jan 1993 to Sep 1995
Senior Analyst Programmer
Worked as part of a small team on a highly visible pilot DB2/COBOL project responsible for the delivery of high quality programs to tight deadlines to form part of a new buying income system
Crossfield Electronics Ltd
Permanent Role - Apr 1992 to Dec 1992
Systems Consultant
Considerably enhanced the Parts Service order processing system which involved close liaison with end users to determine their requirements and the specification, coding and testing of numerous programs.
SKF (UK) Limited
Permanent Role - Mar 1989 to Apr 1992
Senior Computer Operator/ Analyst Programmer
Promoted twice to the position of Analyst/Programmer in recognition of his success as a Senior Operator and Trainee Programmer
United Glass
Permanent Role - May 1987 to Mar 1989
Senior Computer Operator
The provision of a complete operations service to ensure that the requirements of end users were met
AGB Attwood
Permanent Role - May 1984 to May 1987
Computer Operator
Appointed as a Computer Operator following the successful completion of an in-house training programme
Key Technical Skills:
Covering Windows and Mainframe platforms:
SQL SERVER 2005, 2008 & 2012 (T-SQL & DTS), SSRS 2005, 2008 & 2012, COBOL II, CICS, SQL SERVER 2005 & 2008, VISUAL SOURCE SAFE, IBM COGNOS 8, MICROSOFT OFFICE, TELON, EASYTRIEVE+, IMS/DL1, TSO, DB2, CSP, XML, VISUAL STUDIO 2005 & 2008, VSAM, ENDEVOR, FILEAID, QMF, SPUFI, XPEDITER, UNIX
Professional Training & Qualifications:
Course
Date
Microsoft SQL Server 2005 : Developer
Oct 2008
Microsoft SQL Server 2005 : Integration Services
Oct 2008
Microsoft : Designing a Business Intelligence Solution for the Enterprise Using Microsoft SQL Server 2005
Jul 2009
Microsoft : Tuning and Optimising Queries Using Microsoft SQL Server 2005
Jul 2009
Microsoft : Implementing and Maintaining Microsoft SQL Server 2005 Analysis Services
Jul 2009
Microsoft : Implementing and Maintaining Microsoft SQL Server 2005 Reporting Services
Jul 2009
MBCS Membership
Jan 2009
IBM Cognos Analyst
May 2011
Interests:
Social, sport, reading and home IT
References:
Given on request
Contact this candidate