$$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Expert
{{ $t($store.state.user.experience_search_name) }}
0
jobs
Excel and Access Expert Data Analyst
John Middlewick
,
Reading, United Kingdom
Experience
Other titles
Skills
I'm offering
I've been working with Excel and MS Access projects for more than 25 years supplying solutions in a variety of industries working with large and varied data sources. Mainly in corporate environments, I am looking to explore the possibilities freelancing.
Examples of projects I have worked on -
• Telecoms sales team customer monitoring solutions utilising SQL and ODBC links to access several pan European Oracle billing databases, pinpointing customers with dips in usage, unusual patterns in usage and possible fraud delivered via daily summaries provided to relevant sales managers.
• Development of bespoke end to end billing solutions for telecoms resellers from ETL to fulfilment either printed or electronic. Using multiple data sources from telecoms providers.
• Development of broadband network capacity database to facilitate calculation of KPI’s, dashboards, forecasts, identification of points of congestion in the network and possible resolutions delivered in spreadsheets and PowerPoint Using links to SQL Server, uploads of CSV and spreadsheets.
• Facilitation of integrated content reconciliation process for major mobile phone provider by collation of content provider data, HQ finance data, franchisee data into an Access database. Statements and invoices from the various parties in excel spreadsheets with differing templates. Automated output of printed statements to franchisees and content providers.
• Health and Leisure CRM projects.
Examples of projects I have worked on -
• Telecoms sales team customer monitoring solutions utilising SQL and ODBC links to access several pan European Oracle billing databases, pinpointing customers with dips in usage, unusual patterns in usage and possible fraud delivered via daily summaries provided to relevant sales managers.
• Development of bespoke end to end billing solutions for telecoms resellers from ETL to fulfilment either printed or electronic. Using multiple data sources from telecoms providers.
• Development of broadband network capacity database to facilitate calculation of KPI’s, dashboards, forecasts, identification of points of congestion in the network and possible resolutions delivered in spreadsheets and PowerPoint Using links to SQL Server, uploads of CSV and spreadsheets.
• Facilitation of integrated content reconciliation process for major mobile phone provider by collation of content provider data, HQ finance data, franchisee data into an Access database. Statements and invoices from the various parties in excel spreadsheets with differing templates. Automated output of printed statements to franchisees and content providers.
• Health and Leisure CRM projects.
Markets
United Kingdom
Language
English
Fluently
Ready for
Larger project
Ongoing relation / part-time
Full time contractor
Available
My experience
2009 - 2019
job
Data Analyst Capacity Reporting and Network Planning
Virgin Media.
Development and management of Utilisation Reporting Database in MS Access, identifying required datasets in various formats and locations and incorporating into Utilisation Reporting Database using SQL queries, automated uploading of CSV files and Excel files and OBBC links to other SQL databases.
Development and running of daily, weekly and monthly reports relating to network capacity and utilisation by accessing data from Utilisation Reporting Database and manipulating in Excel using pivot tables, VBA, advanced functions, charts utilising dynamic named ranges delivered as interactive spreadsheets, Powerpoint slides including embedded Excel Charts and used to deliver KPI's, forecast, scorecards, drill down to identify over utilised cells, reasons and possible fixes and dates to facilitate proactive congestion management.
Migration of data feeds after changes to data sources. Changes to the source data involved migrating from CSV outputs to a SQL server database and further migrating the ETL process form the CSV scenario to the SQL source. Achieved by creating new feeds via ODBC links mapping and validating the new data sources to the existing tables in MS Access database. Running the existing and revised processes in parallel to test the effectiveness off the migration.
Modelling of network planning scenarios regarding product launches, equipment rollouts anticipated growth utilising using utilisation data and presenting in slide packs and interactive spreadsheets.
Automation and streamlining of various internal reporting processes within implementation team using Excel, Access and VBA
Management of decommissioned of legacy equipment.
Implementation of remedy ticket tracking and reporting process by development of MS Access database and deployment of database.
Development and running of daily, weekly and monthly reports relating to network capacity and utilisation by accessing data from Utilisation Reporting Database and manipulating in Excel using pivot tables, VBA, advanced functions, charts utilising dynamic named ranges delivered as interactive spreadsheets, Powerpoint slides including embedded Excel Charts and used to deliver KPI's, forecast, scorecards, drill down to identify over utilised cells, reasons and possible fixes and dates to facilitate proactive congestion management.
Migration of data feeds after changes to data sources. Changes to the source data involved migrating from CSV outputs to a SQL server database and further migrating the ETL process form the CSV scenario to the SQL source. Achieved by creating new feeds via ODBC links mapping and validating the new data sources to the existing tables in MS Access database. Running the existing and revised processes in parallel to test the effectiveness off the migration.
Modelling of network planning scenarios regarding product launches, equipment rollouts anticipated growth utilising using utilisation data and presenting in slide packs and interactive spreadsheets.
Automation and streamlining of various internal reporting processes within implementation team using Excel, Access and VBA
Management of decommissioned of legacy equipment.
Implementation of remedy ticket tracking and reporting process by development of MS Access database and deployment of database.
Embedded, Processes, Forecast, Server, KPI, Development, Remedy, Presenting, Analyst, Implementation, Growth, Access, Sql, Network, Test, Management, ETL, VBA, Deployment, Database, Automation, Powerpoint, SQL Server, Excel
2008 - 2008
job
Data Analyst
Telindus Belgacom ICT.
Development of Telecoms billing Database on access to reconcile bills with contracts, using VBA to create form driven user front end to allow data upload and reporting suite.
Development of a suite of CCTV activity reports using reporting services.
Mapping of Campaign data from Email Reaction campaign management tool to the via Inaport Goldmine Marketing database.
Cleansing of data from various sources to upload customer data in central pan European database.
Development of a suite of CCTV activity reports using reporting services.
Mapping of Campaign data from Email Reaction campaign management tool to the via Inaport Goldmine Marketing database.
Cleansing of data from various sources to upload customer data in central pan European database.
Marketing, Contracts, Database, VBA, Management, Analyst, Development, Campaign, Contracts
2007 - 2008
job
Data Analyst
Voadafone.
Development and population of historical content database in MS Access to provide financial analysis and reporting to resolve historical billing and tax issues and current data to March 2008. Using Excel and Access VBA skills to develop ETL process extracting and cleansing data from spreadsheet templates populated by local Operating companies and head office finance function and also SAP generated data. Ongoing population of database.
The initial phase involved a data migration process, migrating excel spreadsheets had been instigated in the first phase process development which were of varying formats, content and naming conventions into homogenised data sets in an Access database using techniques such as data mapping, cleansing, deduplication and validation.
Development of MS Access form driven process to enable input of invoice and tax certificate recording and tracking to be analysed against the data captured in the historical content database in standard reports and developing MS Access reports to generate standard letters to assist resolution of tax and billing issues.
Enhancement of existing Excel spreadsheets used for monthly reporting.
Development of integrated processes and process documents to enable the team to work efficiently on resolution of the recharging and tax issues.
Weight-Watchers International
Millennium House, Maidenhead
The initial phase involved a data migration process, migrating excel spreadsheets had been instigated in the first phase process development which were of varying formats, content and naming conventions into homogenised data sets in an Access database using techniques such as data mapping, cleansing, deduplication and validation.
Development of MS Access form driven process to enable input of invoice and tax certificate recording and tracking to be analysed against the data captured in the historical content database in standard reports and developing MS Access reports to generate standard letters to assist resolution of tax and billing issues.
Enhancement of existing Excel spreadsheets used for monthly reporting.
Development of integrated processes and process documents to enable the team to work efficiently on resolution of the recharging and tax issues.
Weight-Watchers International
Millennium House, Maidenhead
Excel, SAP, Database, VBA, ETL, Finance, Content, Access, Analyst, Development, Office, International, Process development, Naming, Processes
2003 - 2007
job
Data Reporting Analyst
unknown.
Introduction of Business Objects as a reporting tool in European and UK operations. Development of Oracle data warehouse, Business Objects universes and report design. Employing extensive use of PL/SQL, SQL and Oracle and Toad skills.
Development of customer data analysis strategies in liaison with marketing departments in Weight-Watchers European countries to ensure maximum direct mail impact. Using Insite and MapInfo GIS, demographic and profiling data in conjunction with Oracle customer database.
Support of existing local Excel and Access VBA systems.
Introduction of MicroStategy as a reporting tool in European operations. Development of European data warehouse, Microstrategy projects and report and document design.
Using CACI Insite mapping tool to create penetration maps used in local meeting planning, identifying areas where new meetings can be opened and where over saturation had caused poor performing meetings.
Supply of data files for direct mail campaigns, follow up mailings and samples for telephone and e-mail surveys /campaigns, liaison with Data cleansing houses and printers, post mailing update of member's database to reflect contacts made and changes in customer details and preferences provided by data cleansing house, using SQL processes.
Development of reporting solutions for regional offices using Excel and Access front ends to Oracle databases Via ODBC links.
Support of Business objects and Microstrategy users.
Development of customer data analysis strategies in liaison with marketing departments in Weight-Watchers European countries to ensure maximum direct mail impact. Using Insite and MapInfo GIS, demographic and profiling data in conjunction with Oracle customer database.
Support of existing local Excel and Access VBA systems.
Introduction of MicroStategy as a reporting tool in European operations. Development of European data warehouse, Microstrategy projects and report and document design.
Using CACI Insite mapping tool to create penetration maps used in local meeting planning, identifying areas where new meetings can be opened and where over saturation had caused poor performing meetings.
Supply of data files for direct mail campaigns, follow up mailings and samples for telephone and e-mail surveys /campaigns, liaison with Data cleansing houses and printers, post mailing update of member's database to reflect contacts made and changes in customer details and preferences provided by data cleansing house, using SQL processes.
Development of reporting solutions for regional offices using Excel and Access front ends to Oracle databases Via ODBC links.
Support of Business objects and Microstrategy users.
VBA, Processes, UP, Performing, Development, Analyst, Support, Surveys, Gis, Pl/sql, Marketing, Data Warehouse, Database, Operations, Oracle, Data Analysis, Excel, Sql, Design
1999 - 2002
job
Billing Reporting Analyst
Ventelo UK Ltd.
Initial development and roll out of sales and operational reporting requirements following implementation of Saville/ADC billing system to all countries. Achieved through combination of Oracle table creation and SQL scripting and ODBC access front ends driven by VBA presented as MS Access reports or exported to Excel for distribution depending on requirement. Involving extensive liaison with country based sales and operational teams in nine countries, Saville/ADC developers and in house project managers.
Development of reconcilable unbilled daily and weekly data feeds to for reseller customers to ensure call data provided during the month includes all calls eventually billed.
Business Objects universe development, reporting (full client and web intelligence) and administration based on Oracle data warehouse feeding from in house operational databases and third party systems.
Development of additional business objects Universes and reports based on live billing systems and data warehouse as required, to support corporate and local country requirements.
Migration of previously developed sales and operational reports to Business objects.
Design development and maintenance of Oracle based Data Warehouse for billed and unbilled call data. PL/SQL development to allow daily feeds from countries using oracle based in house billing systems into data warehouse. VBA solutions developed for countries using third party systems providing call records as text files. Summarisation of downloaded call records, creation and scheduled updating of customer reference data.
Daily monitoring of rated traffic highlighting issues in mediation processes and billing system.
Ongoing scheduled publishing of reports and modification in line with country requirements.
Development of a model to calculate terminating costs incorporating adjustments for inter-company and wholesale costs. Download of costs into data warehouse to allow margin analysis.
Business Objects support and administration and Ad-Hoc Business Objects reporting on request.
Non Business Objects developments of systems such as post billing report suite for France and shared cost rating tool, predominantly MS Access, Excel and ODBC links to Oracle databases.
Support and maintenance of reseller feeds, providing weekly feed of unbilled CDR's to resellers reconcilable to invoiced totals utilising SQL skills. Ongoing production and support of reseller feeds.
Development of reconcilable unbilled daily and weekly data feeds to for reseller customers to ensure call data provided during the month includes all calls eventually billed.
Business Objects universe development, reporting (full client and web intelligence) and administration based on Oracle data warehouse feeding from in house operational databases and third party systems.
Development of additional business objects Universes and reports based on live billing systems and data warehouse as required, to support corporate and local country requirements.
Migration of previously developed sales and operational reports to Business objects.
Design development and maintenance of Oracle based Data Warehouse for billed and unbilled call data. PL/SQL development to allow daily feeds from countries using oracle based in house billing systems into data warehouse. VBA solutions developed for countries using third party systems providing call records as text files. Summarisation of downloaded call records, creation and scheduled updating of customer reference data.
Daily monitoring of rated traffic highlighting issues in mediation processes and billing system.
Ongoing scheduled publishing of reports and modification in line with country requirements.
Development of a model to calculate terminating costs incorporating adjustments for inter-company and wholesale costs. Download of costs into data warehouse to allow margin analysis.
Business Objects support and administration and Ad-Hoc Business Objects reporting on request.
Non Business Objects developments of systems such as post billing report suite for France and shared cost rating tool, predominantly MS Access, Excel and ODBC links to Oracle databases.
Support and maintenance of reseller feeds, providing weekly feed of unbilled CDR's to resellers reconcilable to invoiced totals utilising SQL skills. Ongoing production and support of reseller feeds.
Access, Processes, Wholesale, Production, Web, Development, Monitoring, Analyst, Support, Implementation, Design, Sales, Pl/sql, VBA, Scripting, Data Warehouse, Oracle, Administration, Excel, Sql
1998 - 1999
job
Billing Analyst
Face Value.
Development of new client billing requirements using MS Access, VBA and reports to provide a complete billing solution incorporating;
Mediation of call records from the client's suppliers
Reference data and account structuring
Rating and charge structures
Bill layout and design output as MS Access Reports.
Billing processes
Fulfilment and distribution.
Personal responsibility for end to end billing of assigned reseller clients;
Acceptance of client data and resolution of data issues with providing telco
Processing of clients bill
Delivery to print house and quality checks
Support for on sight client software.
Mediation of call records from the client's suppliers
Reference data and account structuring
Rating and charge structures
Bill layout and design output as MS Access Reports.
Billing processes
Fulfilment and distribution.
Personal responsibility for end to end billing of assigned reseller clients;
Acceptance of client data and resolution of data issues with providing telco
Processing of clients bill
Delivery to print house and quality checks
Support for on sight client software.
Design, Layout, Print, VBA, Access, Support, Analyst, Development, Software, Processing, Processes
1996 - 1998
job
Billing Projects Analyst
Energis Communications.
Development of customised paper and electronic billing solutions for corporate customers.
Rating solutions for reseller market.
Training of customer service and sales staff in electronic billing media.
Development of in house quality processing and pre-billing checks to ensure effective quality assurance.
Rating solutions for reseller market.
Training of customer service and sales staff in electronic billing media.
Development of in house quality processing and pre-billing checks to ensure effective quality assurance.
Training, Customer service, Sales, Service, Quality Assurance, Analyst, Development, Processing
1995 - 1996
job
Traffic Analyst
unknown.
Day to day reconciliation of traffic flow though polling, suspended call and rating to unbilled usage.
Investigation and resolution of suspended calls.
Investigation and resolution of suspended calls.
Analyst
1987 - 1995
job
Assistant Billing Manager
Royal Mail Parcelforce.
Development of planning cost / traffic models for restructuring of depots using VBA and Excel
Supervision of data input staff.
Allocation of work and monitoring of targets.
Resolution of billing issues.
Day to day maintenance of in house billing system.
Supervision of data input staff.
Allocation of work and monitoring of targets.
Resolution of billing issues.
Day to day maintenance of in house billing system.
Excel, VBA, Supervision, Monitoring, Development, Manager
My education
Hatfield Polytechnic
BSc, Studies 2 (Minor in Geology)
BSc, Studies 2 (Minor in Geology)
The Holy Family Comprehensive School
Secondary, Maths B
Secondary, Maths B
John's reviews
John has not received any reviews on Worksome.
Contact John Middlewick
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to John directly in Worksome.
38100+ qualified freelancers
are ready to help you
Tell us what you need help with
and get specific bids from skilled talent in Denmark