$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Senior
{{ $t($store.state.user.experience_search_name) }}
0
jobs
BI analyst /developer consultant
Camilla Sguazzin
,
Experience
Other titles
Skills
I'm offering
Markets
United Kingdom
Links for more
Once you have created a company account and a job, you can access the profiles links.
Language
Danish
Fluently
English
Fluently
Spanish
Fluently
Italian
Fluently
Ready for
My experience
2019 - ?
job
Underwriting Performance Analyst
Liberty Mutual Specialty Markets.
Working closely with Underwriters to create reports to control and investigate potential breaches and to highlight exceptions on a timely basis the rules to adhere to underwriting authority review team across different line of businesses. Integration of Max Lines in the data warehouse and determine rate change limits with GAAP and PIM rates at individual underwriter level. Incorporating tactical and strategic solutions, enabling more robust oversight in Power Bi with a Control Dashboards and preparation of monthly 286,287,288 PMD's reports.
Power BI, Data Warehouse, Integration, Analyst, BEE, Power, PIM, Underwriting
2017 - 2017
freelance
Business Intelligence and Report Consultant
ED&F Man.
SSRS reports in 2008R2 and 2012 with subscriptions for MLP client (molasses commodities) based in Amsterdam hence with consultation trips involved to Netherland for requirements gathering. Use of Dynamic SQL was necessary due to the multitude and global location of servers. Used of Team Work application for team track project management and release management of reports in 3 different environments. SQL agent jobs creation to refresh data and import new fields from all global ITAS applications. Source Tree used as source control. Reports scripts optimisation is a constant requirement with temporary tables favoured over CTE's, use of indexes and execution plan due to the large amount of data dealt with.
Sql, Project Management, Business Intelligence, Optimization, Management, SSRS, Agent
2015 - 2016
job
BI Developer
Randall and Quilter Investment Holdings.
Developer, BEE
2014 - 2015
job
BI Developer
Charles Taylor Insurance plc.
Extending new Data Warehouse DB with new tables, views and store procedures, triggers for P&I Standard Club as migration from Milan application to Columbus has been the main project taken place. Working next to the BAU team for SSRS reports with data sources from different SQL Servers 2000, 2005, 2008R2, 2012.
Creation of KPI's in Power BI and Power Pivot Dashboards for Solvency II with use of DAX and integrating them on SharePoint 2010. I have given application support financial SUN system and to MatterSphere users and created reports with data sources from both.
I have also been involved various SSIS migration solutions involving building appropriate staging tables extracting data from local and third party Reinsurance System and integrating this into new Dimension and Fact tables. Other data activities included creating data cleansing processes and applying best practices to create efficient SQL scripts to manage large data extracts and transformations.
Released many SSRS reports all documented in TargetProcess from 2005, 2008 to 2012 from visual SourceSafe to SVN in Visual Studio 2012.
Creation of KPI's in Power BI and Power Pivot Dashboards for Solvency II with use of DAX and integrating them on SharePoint 2010. I have given application support financial SUN system and to MatterSphere users and created reports with data sources from both.
I have also been involved various SSIS migration solutions involving building appropriate staging tables extracting data from local and third party Reinsurance System and integrating this into new Dimension and Fact tables. Other data activities included creating data cleansing processes and applying best practices to create efficient SQL scripts to manage large data extracts and transformations.
Released many SSRS reports all documented in TargetProcess from 2005, 2008 to 2012 from visual SourceSafe to SVN in Visual Studio 2012.
Sql, Power BI, SharePoint, Data Warehouse, Visual Studio, Ssis, SSRS, Developer, Support, KPI, BEE, Power, SVN, Processes, Power Pivot
2013 - 2014
job
DBA/T-SQL Developer
H W Fisher and Co.
I played a key role in SQL administration and support including security, upgrade, stored procedures, T-SQL. Install, configure and manage MS SQL server in clustered environment. Managing and configuring all SQL databases backup and recovery.
Support and develop any reporting requirements in Excel 2010 with PowerPivot & Crystal Reports providing second line support to the HW Fisher users in Practice Engine. Maintain, perform troubleshooting of Windows servers, VMware, Citrix servers, Exchange server, Company Intranet, Software and web based Applications.
Work well with other tech and non-tech members of staff, documenting all work to standards including system build and troubleshooting procedures. Provide network administration and support including Active Directory security management. Giving support and maintenance of tax databases such as TaxPoint to Digita Personal Tax, Viztopia and Access Dimensions.
Support and develop any reporting requirements in Excel 2010 with PowerPivot & Crystal Reports providing second line support to the HW Fisher users in Practice Engine. Maintain, perform troubleshooting of Windows servers, VMware, Citrix servers, Exchange server, Company Intranet, Software and web based Applications.
Work well with other tech and non-tech members of staff, documenting all work to standards including system build and troubleshooting procedures. Provide network administration and support including Active Directory security management. Giving support and maintenance of tax databases such as TaxPoint to Digita Personal Tax, Viztopia and Access Dimensions.
T-SQL, Server, Web, Software, Powerpivot, Backup, Support, Developer, Security, Citrix, Network, Sql, Stored procedures, Windows, Management, VMware, Exchange, Active Directory, SQL Server, Administration, Excel
2013 - 2013
temp
Temporary role
Charity Org. Biochemical Society.
as Assistant DBA
2012 - 2013
freelance
Junior BI Consultant
Hitachi Consulting.
Short position at Hitachi Consulting where I was involved in SSIS and SSRS training with SQL Server 2012 and as well in the ongoing of internal projects for the development of SSIS costumed components. Querying and tuning in SQL Server 2008 R2 and 2012, store procedures, triggers, views. All the training packages of Microsoft Office 2010 were completed.
Sql, SQL Server, Training, Consulting, Ssis, SSRS, Development, Office, BEE, Server, Sql server 2012, Tuning, Sql server 2008
2012 - 2012
job
Junior T-SQL Developer
Amlin Insurance.
This role comprised 50% Release Management, and configuration/testing/release/packaging work and 50% T-SQL Data Warehouse enhancement, data fixes and development work. Good T-SQL skills to write queries and debug T-SQL errors.
A data dictionary was created in Excel with the data flow of Amlin's DW and a good eye for details and understanding was required. Release management in VSS, understanding of a project life cycle and of development/test/release processes.
SSIS understanding of Data Warehouse methodologies, Kimball methods, ETL data flow in DWH systems and working knowledge of source control VSS.
A data dictionary was created in Excel with the data flow of Amlin's DW and a good eye for details and understanding was required. Release management in VSS, understanding of a project life cycle and of development/test/release processes.
SSIS understanding of Data Warehouse methodologies, Kimball methods, ETL data flow in DWH systems and working knowledge of source control VSS.
Sql, Excel, Packaging, Data Warehouse, ETL, Management, Test, T-SQL, Ssis, Developer, Testing, Development, Kimball, Processes
2012 - 2012
job
IT Admin and Software Support
Core ltd.
In a SharePoint environment, I looked after the Service Desk, creating daily reports, manual testing, fixing bugs and helpdesk tickets.
Good knowledge of SQL Server 2008 queries, Active Directory and fixes and functionality changes applied in asp.net and C# coding in .Net 3.5.
Good knowledge of SQL Server 2008 queries, Active Directory and fixes and functionality changes applied in asp.net and C# coding in .Net 3.5.
ASP, Sql server 2008, Server, Software, Testing, Support, It, Net, Service, Sql, Manual testing, C, Active Directory, SharePoint, ASP.NET, SQL Server, .Net
2011 - 2011
job
Technical Solution Specialist for Windows Azure Microsoft
CBS Interactive.
Providing technical enablement to clients developing applications on a cloud platform. In addition, successfully communicating with contacts via phone, email and instant message channels were daily basis tasks and recording everything in Microsoft CRM dynamics.
Proven understanding of developing Microsoft technologies like Windows Azure Platform, SQL Server, Windows Server, Visual Studio, .NET, with cloud computing.
Jan '11 - Aug '11 Travelling and training across Asia and South Asia
Proven understanding of developing Microsoft technologies like Windows Azure Platform, SQL Server, Windows Server, Visual Studio, .NET, with cloud computing.
Jan '11 - Aug '11 Travelling and training across Asia and South Asia
Sql, SQL Server, CRM, Azure, Training, Cloud, Visual Studio, Windows server, Windows, Net, Server, Asia
2009 - 2010
internship
Internship - Junior Developer
unknown.
In a software-solutions-house environment helping in the development of Mail Tracking, File Tracking and Records Management.
I worked next to the senior developer maintaining a few assets of their software solutions in house .net 2.0 environment. Front-end experience with the use of HTML, CSS and JavaScript in website building content; Also application testing and first line support.
I worked next to the senior developer maintaining a few assets of their software solutions in house .net 2.0 environment. Front-end experience with the use of HTML, CSS and JavaScript in website building content; Also application testing and first line support.
Javascript, Css, Html, HTML/CSS/Javascript, Management, Content, Website, Net, Developer, Support, Testing, Development, Software, Senior Developer, Junior Developer, Internship
1991 - 1991
job
Bdx data.Liaison
Lloyd's Syndicate.
Production of monthly Borderau (bdx) SSRS reports in line with timeline requirements as defined in the Binder agreements with carriers. Quality assurance of all data contained within the bdx to include, extracted, calculated, derived data fields Maintenance of external reference data used in the calculation or derivation of bdx data. Observance of appropriate signoff and authorisation processes. Application of appropriate controls around any manual manipulation of Bdx data.Liaison with IT team for Bdx development and / or issue resolution. Liaison with third party stakeholders in matters arising from Bdx processing. Reporting of Bdx production status and any issues/matters arising. Other SSRS reports with store procedures/ functions longer than 1000 lines of code, CTE's temp tables, optimisation of queries and maintenance in BIDS SS2008 and SSDT 2012 for the Underwriting and Finance team dealing with directly with stakeholders in gathering requirements specification. The reports in Visual Studio 2008R2 and 2012 have to adhering to Lloyds reporting templates generating reporting triangles for claims and uploading to Lloyds. Expanding existing Data Warehouse creating new fact tables dimensions, recreation of existing reports from DWH for Lloyd's Syndicate 1991 (views, store proc., functions), Catlin's and Synergy syndicates. Testing and reconciliation of data with PowerPivot. Tableau exposure in changing existing reports. All reports mirrored in a DEV UAT and PROD environment in TFS. Knowledge of Eclipse and Websure CRM insurance systems and creating Data Modelling for both.
Quality Assurance, SSDT, Processes, Processing, Production, Underwriting, Insurance, Powerpivot, Development, Testing, CRM, TFS, It, SSRS, Eclipse, Finance, Optimization, Visual Studio, Tableau, Data Warehouse
My education
2015
City University of London
N/a, Risk Management
N/a, Risk Management
2008
-
2009
City University
N/a, N/a
N/a, N/a
2002
-
2007
London South Bank University
BSc, Internet Computing
BSc, Internet Computing
2000
-
2002
London South Bank University
Hndhncorequivalent, Internet Computing
Hndhncorequivalent, Internet Computing
1999
-
2000
City and Islington College
N/a, Biomedical Sciences
N/a, Biomedical Sciences
1998
-
1999
Hackney College
N/a, English
N/a, English
1990
-
1996
Liceo Scientifico G Parini
Secondary, Scientific subjects
Secondary, Scientific subjects
Camilla's reviews
Camilla has not received any reviews on Worksome.
Contact Camilla Sguazzin
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Camilla directly in Worksome.
38000+ qualified freelancers
are ready to help you
Tell us what you need help with
and get specific bids from skilled talent in Denmark