Experience

Wokingham Borough Council

• United Kingdom
• Government Administration
• 700 & Above Employee

• Business Analyst - Reports

  • Oct 2014 - Present

  • Leading on the development of the reporting sector across Children's and Adults Services.• Developing complex reports using SQL and other reporting tools to meet statutory requirements and business needs.• Managing a small team responsible for data extraction across a number of systems, as well as supporting statutory returns and ensuring data consistency across systems.• Leading on reports repository upgrades from critical path analysis/implementation planning to liaising and with external suppliers and ensuring upgrades are fully tested via test scripts.• Creating PL/SQL functions within databases.• Developing cross connection databases in access, querying multiple datasources across the service to meet business and statutory requirements. • Automating the production of regular datasets in access, leading to minimal input and time saving.• Problem solving and analysing complex reporting requsts to come up feasible solutions to extract the required data and statistics using SQL and functions.

• Senior Performance Analyst

  • Jul 2014 - Sep 2014

  Responsibilities are mainly the ones held in my previous role with the addition of writing and developing SQL reports for Adults social care from framework-I and understanding relevant workflows/mapping.

• Research and Information Officer

  • Sep 2012 - Jul 2014

  • Leading on statutory social care data collections for children’s Services• Development of inspection datasets in SQL reports. • Embedding SQL scripts in Microsoft Access using pass through queries, along with other data sources and querying theses. • Automated and scheduled weekly business object reports to be run to a specific file location and emailed directly to key members of staff.• Using data-migration and matching techniques in order to match records between Framework-i and EMS systems using pass through queries in Microsoft Access, in order to obtain UPN’s for the CIN census. •Working closely with the Framework-I Business Analyst to configure workflow to capture statutory information. Also carrying out mapping of filters, switches and groups, in order for tables to populate correctly to ensure extracted data is correct. • Identifying issues with tables through SQL Developer and liaising with the software supplier, by logging calls through JIRA and following them until resolution (as necessary escalated issues as appropriate to Senior management/Corporate IMT).• Responding and dealing with ad-hoc reporting queries/requests from the service, which involved developing new SQL reports to extract specific data to support specific lines of enquiry and explaining where data has been extracted from within the system, using non-technical language.• Using test scripts to test system upgrades and reporting conclusions back to the system manager to confirm whether upgrades should go ahead or not. • Built up a good understanding of EMS (ONE) system, both front end user interface, as well as querying the database in SQL developer, Microsoft Access and SQL Server Reporting Services.• Good understanding of the E–caf database design and starting to write queries using in-built reporting functionality to create reports for users. • Writing and developing SQL reports for Adults social care from framework-I and understanding relevant workflows/mapping.

• Information Support Assistant

  • Jul 2010 - Sep 2012

  • Developing Business Objects reports to meet service requirements• Assisting on statutory data collections• Production of monthly, weekly and ad-hoc PI monitoring reports, along with performance analysis to senior managers• Analyse and manipulate extracted data in excel using various statistical and data validation techniques, pivot tables, array formulas, etc. • Producing reports based on analysed data by summarising key trends and business performance in order for managers and other boards/agencies to make informed decisions• Carrying out benchmarking analysis on Wokingham’s performance against other local authorities and highlighting distinctive trends to managers, leadership team and other stakeholders.• Working on cleansing data for the social care statutory returns • Worked on developing a new excel reporting tool, based on reports generated from the new system to allow automatic analysis and statistics to be produced• Configured reports on the new social care system based on current/future reporting requirements.• Carrying out Free School Meal checks for schools• Producing key stage data packs at the end of academic year, analysing school and local authority performance



Private Landlord

• 1 - 100 Employee

• Finance / Lettings Assistance

  • Jul 2009 - Apr 2010

  • Producing profit-loss statements and manipulating spreadsheets in order to present information in an effective manner to the Landlords.• Analysing mortgages by modelling and forecasting repayments.• Carrying out general administrative tasks and dealing with the legal side of the portfolio i.e. issuing notices, attending court, etc.• Marketing properties via different channels i.e. web, shops, etc and dealing with potential clients directly, over the phone and by email. • Producing profit-loss statements and manipulating spreadsheets in order to present information in an effective manner to the Landlords.• Analysing mortgages by modelling and forecasting repayments.• Carrying out general administrative tasks and dealing with the legal side of the portfolio i.e. issuing notices, attending court, etc.• Marketing properties via different channels i.e. web, shops, etc and dealing with potential clients directly, over the phone and by email.



Forrest Property Services

• United Kingdom
• Business Consulting and Services

• Finance / Lettings Assistance

  • Sep 2008 - Sep 2008

  • Leading on the migration project between paper-based system to a computerised system. • Establishing levels of income generated and costs incurred for each property, in order for the associated tax to be calculated• Producing and storing key documentation for each tenancy. • Carrying out general administrative tasks and dealing with the legal side of the portfolio i.e. issuing notices, attending court, etc.• Attending property viewings with prospective tenants and carrying out property inspections.

• Finance / Lettings Assistance

  • Jul 2007 - Sep 2007

  • Leading on the migration project between paper-based system to a computerised system. • Establishing levels of income generated and costs incurred for each property, in order for the associated tax to be calculated• Producing and storing key documentation for each tenancy. • Carrying out general administrative tasks and dealing with the legal side of the portfolio i.e. issuing notices, attending court, etc.• Attending property viewings with prospective tenants and carrying out property inspections.