Using my SQL Server and Business Intelligence skills to deliver statistics based on SUS patient records. These statistics include delivery in the form of metrics, measure groups, standard deviations, charts and tolerance levels using mainly T-SQL to prepare the Fact tables and Dimension tables then using MDX to perform further analysis within the cubes. These statistics are presented in reports and charts using SSRS which can be rendered in various formats such as Excel, PDF or CSV. Further reports are being delivered using SSIS, SSAS & presented on SharePoint and SSRS. Mentoring other members of staff in the areas of business analysis, BI, SQL and project management including creating requirements definition templates.

Studied for MCTS SQL 2005 Business Intelligence and
MCTS SQL 2005 Implementation and Maintenance

Gained skills in MDX, SSAS Data Mining and DMX, SSRS Report Builder, SSRS Report Modeller in addition to my commercial experience in preparation for this exam.

Specifying, designing, implementing SQL Server Reporting Services (SSRS) objects for a range of property planning maintenance systems where these reports indicate quality and status of different stages of planning maintenance jobs from request to order completion. The implementation of these reports included configuring security, scheduling and modelling underlying data sets where further exposure was given to SQL Server Integrated Services. T-SQL was used when required to implement specified business rules. All the deliverables both technical and none technical were checked into SourceGear. I mentored other members of staff in the development of SSRS reports. I also created a template for report specifications which was accepted as a new standard by the Lead Data Warehouse Architect as a document of communication between Data Warehouse Developers and Project Managers.

Specifying, designing, implementing, Project Managing and documenting a Business Intelligence system using SQL Server 2005 focusing on SSIS and various data sources with SUS (Secondary User Service) as the primary data source. The SUS data sources included Payment By Results and Extract mart. Information extracted from these marts include Accident and Emergency, Spells, Outpatients and Episodes of care. The main objective of this information system is to empower the Information Analysts to more effectively respond to reporting requirements. Contributed to the technical strategy of this organisation by pioneering the upgrade to SQL 2005, delivered training and mentoring of staff.

Delivered SQL Server Analysis Services cubes (SSAS) cubes including security schemas. The business objective of these SSAS cubes is to deliver quality investigation reports on NHS Payment by Results data sets from many different perspectives putting into practice Ralph Kimball’s Dimensional Modelling Techniques.

Responsible for the extraction and analysis of data and set up of data cleansing business processes from the hospital PAS system. The preparation and submission of data sets, ensuring that the hospital meets its contractual reporting requirements as an Independent NHS Free Choice Network Provider. Development, execution, documentation and hand over of business processes related to 18 Weeks, (CDS)Commissioning Data Sets and (ECN) Extended Choice Network. Specification of reports to further improve business process execution to Claremont’s COTS(Commercial Off The Shelf) application.

and Web Developer for Local Organisations.

Focused on Performance Management Information deliverables such as Reference Costs, Patient Activity and 18 Weeks to meet agreed targets. Assisted in performing a data mapping exercise between data sources and their forth coming data warehouse.

Specifying, designing, implementing, Project Managing and documenting a Business Intelligence system using SQL Server 2005 focusing on SSIS and various data sources with SUS (Secondary User Service) as the primary data source with a view to extending this data warehouse in the future to extract other data sources such as SLAM (NHS finance system) and QOF (Quality Outcome Framework). The SUS data sources included Payment By Results and Extract mart. Information extracted from these marts include Accident and Emergency, Spells, Outpatients and Episodes of care. The main objective of this information system is to empower the Information Analysts to more effectively respond to reporting requirements.

During April negotiated some part time work from home at Stockport PCT to deliver SQL Server Analysis Services cubes (SSAS) cubes. The business objective of these SSAS cubes is to deliver quality investigation reports on NHS Payment by Results data sets.

Performing a variety of roles such as Database Analyst / Development, Business Analysis and Project Management. Creating the following example deliverables; - reporting tools, data warehouse server specifications, risk logs, data dictionaries, requirements analysis documents and 18 Weeks Patient Referral to Treatment reports, exposure to various data sets such as Connecting for Health Secondary Uses Service (SUS) and Commissioning Data Sets (CDS). Various reports were created using HRG (Health Care Resource Groups) and OPCS (Office for Population Censuses and Surveys) to perform more detailed analysis on this information. These reports were typically delivered to senior managers and directors within the PCT.

Senior IT Officer within Large Local Authority and Web Developer for Local Churches.
Responsibilities: Database design & development, focusing on business-critical, technical and strategic needs within this authority. Including implementation of all stages of the Software Development Life Cycle in MS Access and MS SQL Server using SQL, VBA, Visual Basic, VB.NET and Crystal Reports. I provide technical advice to other database designers and always ensure use of clear specifications and documentation to empower users to design their own queries and reports. I have delivered cascade training to an entire division of 300 users.

Various temporary assignments Including training of supervisors / managers in the use of Excel; designing web sites using FrontPage 2000; and designing databases using MS Access 97 and VBA for the Civil Service.

This position was part of an overall plan, gaining experience in serving poor communities, to enable me to use my IT skills in the future within my own business, to train and develop those who have been in poverty.
Responsibilities: Full time volunteer. I led shifts in the night-shelter and undertook managerial duties supporting staff, with responsibility for 18 residents at the same time. Working with very damaged individuals with challenging needs. General domestic duties.
Skills: A very intensive year in which many people-skills were learned; dealing with being constantly stretched physically, mentally and emotionally. I gained vital experience in management and relating to people and found that I excelled in this role.