Objective

• Senior level Business Intelligence/Data Warehousing professional with ten years experience in Information Systems, more recently in a leadership capacity.
• Technical experience is diverse covering all phases of BI, including requirements analysis, reports development, business intelligence tools administration, data warehousing, database design, business analysis, systems security, QA and production support.
• Strong collaborator and team lead, with years of experience facing clients and making recommendations to senior management.
• Gained this experience in five very different organisations: a major police force, a global manufacturing company, the purchasing wing of the NHS National Health Service , a FTSE 100 recruiting company and an insurance company.
• The systems worked with cover everything from recruiting, crime, criminal justice, human resources, sales, legal services, insurance to advertising.

Skills

Business Intelligence : Cognos 7 Powerplay, Impromptu, Transformer, Metrics Manager , Cognos 8 Report Studio, Query Studio,Framework Manager , Oracle Discoverer 4 9i, Business Objects 4 XI, Microsoft BI SSRS, SSAS,SSIS 2008, Excel Services 2007, Sharepoint 2010 , ERStudio.

Operating Systems : Windows XP 95 both Brainbench Certified

Databases : IBM DB2, Oracle 9i, Oracle 10g,SQL Server 2005 2008, MS Access

Programming/Coding Languages : C, SQL, Dargal

Office Software and Other Applications : TOAD, Golden, MS Office Excel. Access, Powerpoint ,Word , Outlook , MapInfo GIS Software , Checkpoint, Taleo, Zoomerang

Other Skills : Data Analysis, Business Analysis, Project Management, Team Leadership, Training, Problem Solving, Technical Writing Brainbench Certified , Experience on 8 Data Warehouse Projects, Technical Business Software Testing Brainbench Certified

Experience

Confidential

Senior Business Intelligence Analyst

Roles and responsibilities:

Business Analysis - Perform requirements gathering and analysis from all business leaders and users to understand global business rules and determine reporting needs, both from a specific report need and ad-hoc basis. Design report mockups. Data Analysis - Using TOAD and Excel, create data element mapping documents for the ETL Developer to implement, identifying source data and how it maps/relates to equivalent fields in the Data warehouse.

Testing Perform unit testing on the data warehouse and solution. BI Reporting /Training Educate all users through presentations and personal mentoring in the use of the Workforce Analytics data structures and reports.

Confidential

Senior Business Intelligence Analyst

Roles and responsibilities:

Technical Strategy Promote and roll out BI solutions using MOSS 2007, SQL Server 2008, Oracle 10g and Cognos.

Project Management Define project plan, milestones, deliverables. Co-ordinate teams and activities. Business Analysis - Perform requirements gathering and analysis from all business leaders and users on a project basis to determine reporting needs. Provide proof of concept versions of reports in Cognos, SSRS or Excel. Data Analysis - Using TOAD and Excel, create data element mapping documents for the ETL Developer to implement, identifying source data and how it maps/relates to equivalent fields in the Data warehouse.

Testing Create the testing strategy for Unit Testing and UAT of the data warehouse and Cognos and Microsoft reports,based on the data element mappings and business requirements. Manage and supervise the testing. Responsible for signing off on tests. Work with developers to resolve bugs. BI Reporting /Training Educate all users through presentations and personal mentoring in the use of the new Microsoft BI products, such as SSRS 2008 and Excel Services. Also analyst and technical support for current reports in Cognos 8.4. Documentation - Create documentation for entire project, business and technical. Create data flow diagrams and system architecture diagram in MS Visio.

Data Modelling Create and present data models in ER Studio as part of the design phase.

Service Level Agreements Create and define the SLA document. Present to all relevant senior parties and secure approvals

Tech Support Primary point of contact for technical issues raised about the data warehouse and Cognos reports on a daily basis, also gatekeeper for change controls relating to reports and the warehouse.

Education/mentoring- Regularly attend TDWI conferences to keep business up to date on new opportunities and developments in the BI world.

Confidential

Senior Technical Consultant

Roles and responsibilities: Business Analysis - Perform requirements gathering and analysis from all business leaders to define business rules and SLAs for each account, and how this relates to the Dashboard. Data Analysis/Modeling - Using TOAD and Excel, create data maps for the ETL Developer to implement, identifying source data and how it maps/relates to equivalent fields in the Cognos reporting database. BI Reporting - Thorough testing of the Cognos Dashboard in Report Studio, and create ad-hoc reports in Query Studio. Training - Train all users in completing MS Sharepoint data entry forms to feed into the Dashboard, also how to use the Dashboard. Documentation - Create documentation for entire project, business and technical. Create data flow diagrams and systems architecture diagrams in MS Visio.

Confidential

Technology Program Manager

Roles and responsibilities:

BI Reporting Create reports in Cognos 8.2 Report Studio and Query Studio for senior management, ad-hoc reporting in MS Access.

Business Analysis Perform requirements gathering to define reports to be created by Cognos developers or me. Analyze and document business processes and make recommendations for improvements.

Data Analysis Using TOAD, Excel, Cognos and Access, analyze source data for patterns and errors before and after data load processes.

Database Design - Design and create databases in MS Access to build recruiter scorecards.

Web Surveys Create and deploy customer satisfaction web surveys in Zoomerang.

Training Train recruiters and managers remotely and in person how to use client software.

Networks Security Configure and troubleshoot multiple VPNs and resolve Checkpoint issues.

Project Management Establish project plans and milestones for data warehouse project.

Team Leadership Member of core management team, client facing, lead small tech support team.

Tech Support Subject matter expert between Spherion and Honeywell helpdesks.

Confidential

Data Analyst

Roles and responsibilities:

Data Analysis Analyze and assess existing data from all sources and reports, gap analysis.

Database Design Design interim reporting databases in MS Access and assist in design of tables in SQL Server.

Data Modeling Create data models and maps enable ETL for SQL Server warehouse.

Business Analysis Gather requirements from business users to build specifications for BI reports.

Confidential

Business Objects Reports Developer Unilever

Roles and responsibilities:

BI Reporting - Create Ad-hoc Webi reports, test Webi reports built by developers.

BI Administration Create, manage, test and document security and connectivity in the Business Objects reporting platform.