$$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Expert
{{ $t($store.state.user.experience_search_name) }}
0
jobs
Abi Kolade Profile
Abi Kolade
,
London
Experience
Other titles
Skills
I'm offering
Proven design & problem-solving skills. As an experienced Consultant with an eye for detail, I am equally at home working on solo projects or in a team environment. I have excellent communication skills & is particularly adept at translating complex user requirements into robust functional applications.
Markets
United Kingdom
Language
English
Fluently
Ready for
Larger project
Full time contractor
Available
My experience
2019 - ?
job
Senior Database Developer
CPA Global.
Designing changes to CPA's Trademark platform & ensuring its stability, reliability, and performance.
Complex T-SQL scripting, SSRS, SSIS.
Complex T-SQL scripting, SSRS, SSIS.
Sql, Database, Scripting, T-SQL, Ssis, SSRS, Developer
2015 - 2019
job
Report Analyst/Developer
J A Kemp Patent Attorneys.
In this position I had overall responsibility for reporting infrastructure and all the processes that go into maintaining an efficient reporting environment.
As we were unable to make any changes to the core IP system other than adding custom objects on a separate schema, I created an operational data store by restoring the latest backup of the Live database on to a separate server. I then created indexes and statistics where necessary to speed up data retrieval and pointed all reporting that doesn't require up to the minute information to stored procedures on the operational data store. An Sql agent job restores the backup nightly and a series of other jobs create the indexes and attendant statistics. In addition to speeding up data retrieval, this has the advantage of taking a lot of strain off the core system.
I built a separate data warehouse from scratch with all the attendant mechanisms for data storage, refresh and efficient retrieval. As a result, the firm has access to a suite of Work in Progress (WIP) reports that are refreshed hourly and run in seconds.
Over hauled Fee Earner Performance Monitoring and created an entire universe that not only produces reports but disseminates information to Fee Earners and other interested parties in a timely fashion.
Fully automated both KPI and WIP reporting using the aforementioned data warehouse along with several other processes
I have worked in conjunction with the management accountant to develop processes for accurate financial reporting.
Rewrote the Financial Interface between Inprotech and SUN so that the process of transferring data from the IP system to the accounting system now takes a matter of seconds rather than hours at a time.
I introduced data driven subscriptions following our Sql Server 2017 upgrade which I agitated for thus making the process of disseminating information infinitely more flexible.
As we were unable to make any changes to the core IP system other than adding custom objects on a separate schema, I created an operational data store by restoring the latest backup of the Live database on to a separate server. I then created indexes and statistics where necessary to speed up data retrieval and pointed all reporting that doesn't require up to the minute information to stored procedures on the operational data store. An Sql agent job restores the backup nightly and a series of other jobs create the indexes and attendant statistics. In addition to speeding up data retrieval, this has the advantage of taking a lot of strain off the core system.
I built a separate data warehouse from scratch with all the attendant mechanisms for data storage, refresh and efficient retrieval. As a result, the firm has access to a suite of Work in Progress (WIP) reports that are refreshed hourly and run in seconds.
Over hauled Fee Earner Performance Monitoring and created an entire universe that not only produces reports but disseminates information to Fee Earners and other interested parties in a timely fashion.
Fully automated both KPI and WIP reporting using the aforementioned data warehouse along with several other processes
I have worked in conjunction with the management accountant to develop processes for accurate financial reporting.
Rewrote the Financial Interface between Inprotech and SUN so that the process of transferring data from the IP system to the accounting system now takes a matter of seconds rather than hours at a time.
I introduced data driven subscriptions following our Sql Server 2017 upgrade which I agitated for thus making the process of disseminating information infinitely more flexible.
Backup, Processes, UP, Agent, Go, Data Storage, Server, Accountant, Storage, Monitoring, KPI, Sql, Infrastructure, Analyst, Stored procedures, Developer, Statistics, Management, Fashion, Data Warehouse, Database, SQL Server
2011 - 2014
job
Solutions Consultant
API Software Ltd.
Analysis, design, build, customisation and deployment of AutoRek, an SQL-based financial management solution for the Financial Services sphere. AutoRek enriches and imports data from disparate sources and automatically reconciles data. It has an exception management workflow to help staff deal with any transactions that cannot be reconciled.
Financial data consultancy, requirements gathering, data modelling, reconciliation, exception management, data migration, T-SQL Scripting, VB.Net, IIS, Microsoft Business Intelligence Stack. Writing complex stored procedures, building SSIS packages, SSRS reports, and SSAS cubes in order to deploy and/or customise AutoRek.
All Software development undertaken in a collaborative Agile environment.
I devised and implemented a system to allow the IT department of a large Fund Manager to create and update permissions on their AutoRek installation. I had to create a series of stored procedures to gather existing permissions into a matrix and use Reporting Services to export the results to an Excel spreadsheet. This spreadsheet could then be updated and imported back into the system using an SSIS package that also ran a series of stored procedures to make the necessary system changes. All of this was plumbed into the front end of AutoRek so all the user saw was the interface.
I was involved in the customisation of the AutoRek Installation at the headquarters of a high street bank. I had to create SSIS packages for data loads, SSRS reports and update cubes on the Analysis Services Instance. I also created an automated deployment package to implement all these changes.
Financial data consultancy, requirements gathering, data modelling, reconciliation, exception management, data migration, T-SQL Scripting, VB.Net, IIS, Microsoft Business Intelligence Stack. Writing complex stored procedures, building SSIS packages, SSRS reports, and SSAS cubes in order to deploy and/or customise AutoRek.
All Software development undertaken in a collaborative Agile environment.
I devised and implemented a system to allow the IT department of a large Fund Manager to create and update permissions on their AutoRek installation. I had to create a series of stored procedures to gather existing permissions into a matrix and use Reporting Services to export the results to an Excel spreadsheet. This spreadsheet could then be updated and imported back into the system using an SSIS package that also ran a series of stored procedures to make the necessary system changes. All of this was plumbed into the front end of AutoRek so all the user saw was the interface.
I was involved in the customisation of the AutoRek Installation at the headquarters of a high street bank. I had to create SSIS packages for data loads, SSRS reports and update cubes on the Analysis Services Instance. I also created an automated deployment package to implement all these changes.
Net, Manager, Vb, Software, SSAS, Microsoft business intelligence, Development, Workflow, IIS, Stored procedures, SSRS, It, Ssis, Design, T-SQL, Management, Vb.net, Deployment, Scripting, Agile, Software development, Writing, Business Intelligence, .Net, Excel, Sql
2011 - 2011
freelance
BI Developer
Fresh Service.
Solo Greenfield data warehouse development on the SQL Server 2008 r2 platform using Kimball based dimensional modelling, VBA & SSIS Packages in conjunction with complex T-SQL stored procedures and user defined functions
Service, Developer, BEE
2011 - 2011
freelance
Analyst
Ford Motor Company.
Requirements gathering. Data Modelling using conformed dimensions & multiple data marts. Financial Analysis and Reporting. Data warehousing. Application design using Oracle SQL, Access VBA and Excel VBA.
Run time generation & manipulation of pivot tables.
Re engineered regular reporting, e.g. Stock ageing, dealer profitability (AIA), shipping lead times, model launch distribution, dealer stock & finance, entity mix (stat8), press releases, business channels (STT), so that analysts can generate reports at the click of a button instead of getting bogged down in interminable copy & paste operations.
Report archiving & data retention.
Provision of insight & identification of trends in new car registrations & stock movement thus enabling Ford to fine-tune their sales strategy.
Supporting the sale & registration of new vehicles.
Business systems analyst for DVLA AFRL (Automated First Registration & Licensing web portal) & Ford AFRL. Business systems analyst for Ford SEER.
Managing availability of stock for sale
Provision of a regional registration bean counter to drive month end sales.
Supporting DVLA & Dealer Assistance Centre with customer enquiries regarding registration paperwork, import/export, etc.
Provision of data feeds to external entities such as GMAP, Underman & SMMT.
Technical reference for the business community.
Mentoring 3 colleagues
Run time generation & manipulation of pivot tables.
Re engineered regular reporting, e.g. Stock ageing, dealer profitability (AIA), shipping lead times, model launch distribution, dealer stock & finance, entity mix (stat8), press releases, business channels (STT), so that analysts can generate reports at the click of a button instead of getting bogged down in interminable copy & paste operations.
Report archiving & data retention.
Provision of insight & identification of trends in new car registrations & stock movement thus enabling Ford to fine-tune their sales strategy.
Supporting the sale & registration of new vehicles.
Business systems analyst for DVLA AFRL (Automated First Registration & Licensing web portal) & Ford AFRL. Business systems analyst for Ford SEER.
Managing availability of stock for sale
Provision of a regional registration bean counter to drive month end sales.
Supporting DVLA & Dealer Assistance Centre with customer enquiries regarding registration paperwork, import/export, etc.
Provision of data feeds to external entities such as GMAP, Underman & SMMT.
Technical reference for the business community.
Mentoring 3 colleagues
Design, Sql, Excel, Oracle, Mentoring, VBA, Finance, Sales, Analyst, Oracle sql, Retention, Community, Shipping, Web, Portal
2010 - 2010
freelance
Senior Developer
Cogitare UK.
Created an integrated mobile timing application in Excel VBA to monitor and improve the real time performance of tube trains as part of the on-going Jubilee Line upgrade.
Data Modelling and Data Warehousing using SQL Server 2008 & a combination of T-SQL coding & SSIS packages. Built a data warehouse to drive the efficient utilisation and maintenance of Tube lines' physical Assets. Data generated over the lifetime of assets is imported into the warehouse where various simulations are applied in order to work out the optimum usage for each asset type.
Data Modelling and Data Warehousing using SQL Server 2008 & a combination of T-SQL coding & SSIS packages. Built a data warehouse to drive the efficient utilisation and maintenance of Tube lines' physical Assets. Data generated over the lifetime of assets is imported into the warehouse where various simulations are applied in order to work out the optimum usage for each asset type.
Sql, Excel, SQL Server, Data Warehouse, VBA, T-SQL, Ssis, Developer, Senior Developer, Server, Sql server 2008
2009 - 2009
freelance
Senior Consultant
Egis Mobilité UK.
Application design in T-SQL and VBA. Data Warehousing for the M25 PFI contract in order that KPI's defined by the Highways Agency can be met. This includes advising on data management strategies, design of data warehouse, data extraction, transformation and loading (ETL), system migration, and spreadsheet applications.
Using SQL Server 2005 as the ultimate repository, data is imported from a variety of disparate systems across the network via multiple SSIS packages into a staging area where it is transformed by further SSIS packages and loaded into a Dimensional Data Store as a series of facts and measures that are applicable to the entire operation at any given time.
Using SQL Server 2005 as the ultimate repository, data is imported from a variety of disparate systems across the network via multiple SSIS packages into a staging area where it is transformed by further SSIS packages and loaded into a Dimensional Data Store as a series of facts and measures that are applicable to the entire operation at any given time.
Design, Sql, SQL Server, Data Warehouse, Data management, ETL, VBA, Management, Network, T-SQL, Ssis, It, Transformation, KPI, Server, SQL Server 2005
2007 - 2008
freelance
Developer
Ford Motor company.
Web Server – Client development using PL SQL, Excel VBA, HTML & Java script. PL SQL packages, stored procedures & functions for data validation & the population of website gizmos. In my role at Ford Motor Company I was intimately involved in the development eDB, a Ford specific web-based system that analyses & reports measures like sales volume & value. This system uses Oracle 9i as the backend & Web pages as the frontend. It gives the user the ability to build custom web-based tools by using controls on the front end to extract & analyse data they have chosen. It also contains the facility to perform further analysis in Excel. This involves programming initially in PL SQL where packages containing myriad cursors & functions are used to extract, cleanse & transform data. In cases where all the transformation & analysis can be performed on the server then results are reported on the user's web page using a combination of Java & HTML. If more complicated analysis is required then results are reported on Excel spreadsheet where VBA macros which are stored in predefined templates operate on the data before the spreadsheet actually opens. All the user sees is the end result, be it graphs, pivot tables, OLAP cubes, or just data duly analysed & formatted.
PL SQL, Oracle sql, Excel and VBA programming, Html, Javascript
2007 - 2007
freelance
Financial Systems Analyst
CMS Cameron McKenna.
Gathering business requirements from high level members of the finance department. Analysing these requirements & translating them into user friendly tools.
Application design & development using SQL Server, T-SQL, ADO, ODBC, VBA. MS Access & MS Excel. Data Warehousing, SSIS, SSAS, Stored Procedures, Functions, Triggers. Cross platform data extraction & transformation. Billing Analysis. Reconciliations.
Application design & development using SQL Server, T-SQL, ADO, ODBC, VBA. MS Access & MS Excel. Data Warehousing, SSIS, SSAS, Stored Procedures, Functions, Triggers. Cross platform data extraction & transformation. Billing Analysis. Reconciliations.
Design, Sql, Excel, SQL Server, VBA, Finance, T-SQL, Ssis, Access, Stored procedures, Analyst, Transformation, Development, SSAS, Server
2004 - 2007
job
Project Analyst
Legal Services Commission.
Analysing business requirements provided by high level members of the finance department & translating them into functional applications.
Data warehousing from several Oracle databases using PL SQL, SQL, ADO, DAO & ODBC. Application Design in MS Access & Excel using VBA with embedded SQL Scripts. Detailed financial analysis of the Legal Aid budget. Reconciliations. Highlighting short and medium term trends in Legal Aid take up and expenditure.
Data warehousing from several Oracle databases using PL SQL, SQL, ADO, DAO & ODBC. Application Design in MS Access & Excel using VBA with embedded SQL Scripts. Detailed financial analysis of the Legal Aid budget. Reconciliations. Highlighting short and medium term trends in Legal Aid take up and expenditure.
Design, Sql, Excel, Oracle, Budget, VBA, Finance, Embedded, Access, Analyst, UP
2002 - 2004
job
Database Administrator
AG Thames Holdings.
Application design in SQL Server 2000, MS Access, & MS Excel. VB/VBA. SQL, T-SQL, MS Query. Writing Stored Procedures on SQL Server.
Data Warehousing, Data Modelling, Data Normalisation. Application support on MS Exchange, all versions of Windows, & MS Office. Network wide anti virus operations.
Data Warehousing, Data Modelling, Data Normalisation. Application support on MS Exchange, all versions of Windows, & MS Office. Network wide anti virus operations.
Windows, Vb, Administrator, Server, Office, Support, Stored procedures, Access, T-SQL, Network, Design, VBA, Exchange, Database, MS office, Writing, SQL Server, Excel, Sql
2000 - 2002
job
Analyst
Test Research.
Application design, statistical analysis, report writing & presentations using MS Access & MS Office. Database development & enhancement. Integration of Access with Excel, Word & PowerPoint. MS Office & general application support.
Design, Excel, Writing, Powerpoint, MS office, Database, Word, Integration, Access, Analyst, Support, Development, Office
1998 - 1999
job
Administrative Officer
Dept of the Environment Transport & the Regions.
Application design, statistical analysis, report writing & presentations using MS Office. Database development, Integration of Access with Excel, Visual Basic/VBA. SQL Server, Office Automation, ODBC. Presenting output on PowerPoint slides.
Design, Sql, Excel, SQL Server, Writing, Powerpoint, MS office, Database, Automation, VBA, Integration, Development, Presenting, Office, Server, Basic
My education
1998
-
1999
University of Westminster
Short Course, Programming for Access Development
Short Course, Programming for Access Development
1988
-
1993
University of Westminster
Bachelors, Social Science
Bachelors, Social Science
Abi's reviews
Abi has not received any reviews on Worksome.
Contact Abi Kolade
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Abi 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