Production of a single distributor view database based on IFA’s from multiple data sources.
Requirement gathering to produce a business case for a phased database build. Developed a 'test and learn' strategy that enabled continual learning from each interaction,
Reviewed the accessibility, integrity and freshness of each data source. Identified data overlap to develop a central data store that contains merged and standardised versions of the most reliable pieces of data.
Developed an automated strategy for updating the central data store.
Produced Business Objects Universe and reports for regular output.
Primary skills – data integration, customer analytics, requirements gathering. SQL Server 2005, Business Objects

Turning detailed information into headlines which will be thoroughly understood, have clear actions and have impact to drive the business agenda.
Develop, produce and automate regular MIS. Administer SQL server analysis data warehouse.
Develop and unit test Business Objects universes and reports based on specifications and data models.
Primary Skills – Communication, requirements gathering, problem solving, Access, Business Objects, SQL Server, Excel, SPSS

Understand, assess and consolidate current reporting practices and databases across various business areas. Requirements gathering, design, develop and implementation of solutions. Production of regular and ad-hoc management information.
Primary Skills – Communication, information gathering and evaluating. Database creation, development and management.

Creation of test plans, preparation of test conditions and scripts and the execution of testing, together with raising and co-ordinating the resolution of defects and compiling test completion results.
Primary skills – Business Objects, Access, SQL, documentation

Running family beverage business. Wide-ranging tasks included, sales, account management, financial analysis & planning. Built CRM database. Increased turnover by 33%.
Primary skills – communication, negotiation, financial analysis, man-management, troubleshooting

Business Analyst for the Actuarial data team. Interface between Actuarial department and centralised IT function to ensure the smooth implementation of data requests and changes. Analysed business needs to identify problems and propose solutions. Produced business cases and high-level feasibility studies. Compiled change requests, process mapping (current state/future state) and resolved issues. Gathered requirements from project managers and system testers, which led to a thorough understanding of both the systems development and project life-cycles. Involved in a wide range of projects from small data changes to multi-million pound data migrations.
Primary skills – communication, analysis, facilitation, interpretation & evaluation, data gathering, documentation, presentation & reporting.

Database Analyst in a change role instilling a knowledge culture for business benefit. Produced structured and ad-hoc analyses for increased understanding and use of customer information. Evaluated customer analysis and compiled reports with campaign recommendations. Presented reports to campaign managers and external businesses linked to NU. Led a team of data analysts. Produced campaign management information. Automated all regular reporting using Business Objects. Increased the profile of the customer analysis team within the NU. Instigated and led the change in structure of the analysis department.
Primary skills – Communication, data manipulation and interpretation, report production and presentation. Software (Business Objects, Access, Excel, PowerPoint, SAS, SQL, SPSS)

Produced mailing lists following detailed analysis of customer potential. Provided post-campaign analysis to identify purchase trends, response rates and customer propensity for implementation into future campaigns. Prepared regular reports on net new business, sales force performance and campaign performance.
Primary skills – IBM mainframe, Microsoft Access