$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Senior
{{ $t($store.state.user.experience_search_name) }}
0
jobs
SQL BI developer
Ahmad Ahmad
,
LONDON, United Kingdom
Experience
Skills
I'm offering
Experienced SQL developer
Markets
United Kingdom
Links for more
Once you have created a company account and a job, you can access the profiles links.
Industries
Language
English
Fluently
Ready for
Ongoing relation / part-time
Available
My experience
2018 - 2019
freelance
MI Developer
unknown.
(Contractor) / W.R. Berkley Underwriting
Example Projects:
● Aged Debt Report (SQL, SSIS, SSRS)
Tasked with replacing the existing solution which was slow, complex and contained data issues,
began by gathering requirements. Created a new report which handled many complexities in a
far simpler way than the pre-existing solution. Integrated a feed from SharePoint list for manual
exceptions. Resulted in pre-processing time reducing from an hour to 2 minutes.
● Brexit Changes (SQL, SSIS, SSRS, SSAS)
Analysed full set of existing reports to identify changes required for new EU business structure.
Designed and developed the necessary changes across database, end user reports and SSAS
cube. Developed validation processes to identify potential user entry errors.
● Consolidation of SSIS packages and Reports (SSIS, SSRS)
Replaced a group of 10-20 feeds with a single table feed and re-wrote reports to use it. Analysed
measures and dimensionality and added fields to pre-existing table to use it as a single source.
Other Responsibilities:
● Analysed and documented pre-existing database structures and complex legacy data flows
● Monthly creation & reconciliation of Lloyds submission. Liaised with business to verify anomalies
● Ad-hoc resolution of user queries, functionality issues and data investigations
● Provision of end to end reconciliation across various sources and measures for auditors
1
Example Projects:
● Aged Debt Report (SQL, SSIS, SSRS)
Tasked with replacing the existing solution which was slow, complex and contained data issues,
began by gathering requirements. Created a new report which handled many complexities in a
far simpler way than the pre-existing solution. Integrated a feed from SharePoint list for manual
exceptions. Resulted in pre-processing time reducing from an hour to 2 minutes.
● Brexit Changes (SQL, SSIS, SSRS, SSAS)
Analysed full set of existing reports to identify changes required for new EU business structure.
Designed and developed the necessary changes across database, end user reports and SSAS
cube. Developed validation processes to identify potential user entry errors.
● Consolidation of SSIS packages and Reports (SSIS, SSRS)
Replaced a group of 10-20 feeds with a single table feed and re-wrote reports to use it. Analysed
measures and dimensionality and added fields to pre-existing table to use it as a single source.
Other Responsibilities:
● Analysed and documented pre-existing database structures and complex legacy data flows
● Monthly creation & reconciliation of Lloyds submission. Liaised with business to verify anomalies
● Ad-hoc resolution of user queries, functionality issues and data investigations
● Provision of end to end reconciliation across various sources and measures for auditors
1
Sql, SharePoint, Database, R, Ssis, SSRS, It, Developer, SSAS, Underwriting, Processing, Processes
2011 - 2017
freelance
BI Consultant
Thorogood Associates.
Example Projects:
● Unilever - Promotional Packaging Cost Allocation (Azure SQL Database)
Collaborated closely with client to iteratively and experimentally explore the potential cost
inefficiencies of promotional packaging. Developed SQL procedures to proportionately allocate
aggregate repackaging costs down to SKU level and to individual retail customers. Delivered
solution which identified specific product and customer combinations where these promotional
investments worth millions of Euros were not delivering financial returns.
● Unilever - Supplier Intelligence Portal (SQL, SSIS, SSRS, SAP BODS, Azure IaaS)
Long term multi-phase project which I worked on over 3 years. Initially carried out development
(SQL, SSRS) and testing on system which provides suppliers with insights into their performance.
In the subsequent phase, was involved in architecting and designing the migration to Azure.
Later took on project management and technical lead roles as the system expanded globally and grew in its functionality and scope of data. Used Kimball approach to bring in data from several
new sources, and to create feeds for other new downstream systems.
● Lloyds Banking Group - Corporate Banking MI System Support (SQL, SSAS, DTS)
Technical system support and data services for a data warehouse with ~100 feeds, which
provides analysis tools for corporate relationship managers. Monthly reporting validation and publication, as well as working closely with business representatives for ad-hoc support.
Other Responsibilities:
● Training - Trained new recruits on SSRS, SharePoint and TFS.
● Marketing - Presented on Azure solutions at a seminar, and delivered 5 webinars/workshops
● Sales - Estimated project costs and helped shape sales proposals
● Line Management - Managed offshore consultants during their stay in the UK
● Recruitment - Supported HR in promotion of roles and selection process.
● Unilever - Promotional Packaging Cost Allocation (Azure SQL Database)
Collaborated closely with client to iteratively and experimentally explore the potential cost
inefficiencies of promotional packaging. Developed SQL procedures to proportionately allocate
aggregate repackaging costs down to SKU level and to individual retail customers. Delivered
solution which identified specific product and customer combinations where these promotional
investments worth millions of Euros were not delivering financial returns.
● Unilever - Supplier Intelligence Portal (SQL, SSIS, SSRS, SAP BODS, Azure IaaS)
Long term multi-phase project which I worked on over 3 years. Initially carried out development
(SQL, SSRS) and testing on system which provides suppliers with insights into their performance.
In the subsequent phase, was involved in architecting and designing the migration to Azure.
Later took on project management and technical lead roles as the system expanded globally and grew in its functionality and scope of data. Used Kimball approach to bring in data from several
new sources, and to create feeds for other new downstream systems.
● Lloyds Banking Group - Corporate Banking MI System Support (SQL, SSAS, DTS)
Technical system support and data services for a data warehouse with ~100 feeds, which
provides analysis tools for corporate relationship managers. Monthly reporting validation and publication, as well as working closely with business representatives for ad-hoc support.
Other Responsibilities:
● Training - Trained new recruits on SSRS, SharePoint and TFS.
● Marketing - Presented on Azure solutions at a seminar, and delivered 5 webinars/workshops
● Sales - Estimated project costs and helped shape sales proposals
● Line Management - Managed offshore consultants during their stay in the UK
● Recruitment - Supported HR in promotion of roles and selection process.
Ssis, Customer, Portal, Kimball, Tech lead, BEE, Development, Testing, SSAS, Support, TFS, Workshops, Azure SQL, SSRS, Offshore, Marketing, Banking, Recruitment, Sales, Management, Data Warehouse, Database, Training, SharePoint, Azure, Packaging, SAP, Retail, Project Management, Sql
2009 - 2010
internship
Server Compliance
IBM UK Ltd.
(Intern during University) / IBM UK Ltd
Began role as compliance analyst, which involved running security scans on servers and helping manage and resolve violations. Later, took on a larger role driving the rollout of automated compliance analysis
tools. Also undertook a related project creating and initiating a process to manage server inventory.
Began role as compliance analyst, which involved running security scans on servers and helping manage and resolve violations. Later, took on a larger role driving the rollout of automated compliance analysis
tools. Also undertook a related project creating and initiating a process to manage server inventory.
Security, Compliance, Analyst, Server, Internal
My education
2007
-
2011
University of Manchester
BSc, Information Technology and New Media (Minor in Information Management & Business)
BSc, Information Technology and New Media (Minor in Information Management & Business)
2005
-
2007
Heaton Manor School
Secondary, Mathematics
Secondary, Mathematics
Ahmad's reviews
Ahmad has not received any reviews on Worksome.
Contact Ahmad Ahmad
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Ahmad 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