Delio Nobrega Email & Phone Number

Gold Coast, Queensland, Australia

Providing Data Engineering, Data Consultancy as well as SQL Server SME knowledge to the Finance, Investment and Fiduciary Industry. Reinforcing key values around Data Governance, Data Designs, Systems Integration and Software Engineering disciplines underpinned by good data principles.

Jersey, United Kingdom

Employed as the development lead for the organization in order to provide and implement standards across the board on development / software practices.Responsibilities• Manage the development team and mentor junior members of the greater IT team• Implement source control processes using Azure-Devops• Design and implement SQL best practices across our whole estate• Provide technical approval on all changes as part of the Change Acceptance Board (CAB)• Provide SME knowledge on SSRS, PowerBI and all reporting• Provide SME knowledge on SQL, C#, PowerShell, Microsoft Office• Automation of monitoring of SQL Server and Reporting estate• Design and Implement a Single customer view for the business for a number of key systems, SAP, MS CRM, Microsoft Dynamics NAV, Pershings / Nexus and Eris (REST APIs and Data Design)• Design and Deliver industry best practice SQL Backup solution• Design and Implement an Investments, Security, Banking, Human Resources and Marketing DataMart.• Provide a consistent and self-service delivery for regulatory and FATCA / CRS reporting• Support the existing SSAS solutionsAchievements• Automation of monitoring of SQL Server and Reporting estate• Delivery of a DataMart for the Investments business providing them self-service over their key data• Implementation of a robust SQL monitoring solution using PowerShell, TSQL and PowerBI• Delivery of a Security DataMart providing visualizations of their key data points across the organisation• Implementation of row level security across the organization on all DataMarts, allowing users to see what they have been authorized to (GDPR).• Delivery of workflow driven data quality Regulatory / FATCA / CRS reporting taking away weeks’ worth of manual work

Jersey, United Kingdom

Providing systems integration and software development experience across a number of key areas.Responsibilities• Technical SME for the GDPR project• Technical SME for the organization on SQL, DataStore DSX, Nav2009 and NavOne• Replace and decom. of Oracle / Crystal reports reporting App• Review and deliver a decommissioning strategy for the old SQL Server estate• Migrate all SQL Servers to Azure• Delivery of a new integration to FINSCAN (AML Sanctions, PEP and KYC screening solution) from SAP, Navision and Pershings• Delivery of a robust Regulatory reporting, including Fiduciary Returns and FATCA / CRS solution• DataStore, Kofax and NavOne upgrade Technical SME• Automation of key time consuming processes for the BAU and Security Team Achievements• Successfully delivered the on premise DataStore DSX upgrade to the Azure cloud (315 users)• Successfully migrated MS Dynamics Nav2009 to NavOne on the Azure cloud (215 users)• Successfully delivered SQL reporting solution for the Fiduciary business, providing Realtime data analytics of their key data; allowing the business to proactively monitor and track their day to day work, using PowerBI Dashboards • Created a showcase for the Data Team to use; demonstrating what is possible with data – “Decisions lead by Data”• Automated installation of NavOne and DataStore on workstations using PowerShell. • Using PowerShell created an Asset Register system querying Active Directory• Developed scripts to automate repetitive AD Tasks i.e. bulk update of User Groups• Provided technical training on DataStore DSX and NavOne to the technical resources on the ServiceDesk (1st and 2nd line)• Created a robust and comprehensive data migration reconciliation comparing source to destination database at column and row level. This proved invaluable as the project in question was selected for external auditing by PWC• Implemented an automated SFTP transfer and blend from Bloomberg of trades and indices to ObjectWay

Jersey

Engaged to transition all key systems from Barclay’s infrastructure to a new private cloud including its design, strategic direction and delivery.Provision of trusted consultancy services for MI, DMS, SQL, Navision, virtualization, licensing for the newly formed Fiduciary company.Responsibilities• Migrate all SQL Servers to new private cloud• Advise on the design of the new private cloud and technical strategic direction• Migrate key systems, namely SharePoint 2010, Microsoft Dynamics Nav 2009• Replace Kofax scanning solution with a bespoke simpler version• Provide SME support for SharePoint 2010, Nav 2009 and SQL Server• Implement and design SQL high availability groups, backup strategy and security• Implement jurisdictional segregation at SharePoint, SQL and Navision level to allow Regulatory legislation to prevail• Maintain the existing NavDataMart / SSRS solution to house MI / BI data for the business, adjusting to the demands of new ownersAchievements• Successfully migrated all SQL servers to new private cloud • Implemented self-monitoring algorithms on the SQL Servers to proactively monitor and correct itself where possible• Provided invaluable knowledge on private Cloud transition aligning to company strategic direction• Successfully migrated all key systems and created a new simpler scanning solution• Successfully completed all work, 3 months ahead of schedule and to budget• Provided technical direction until new CIO appointed• Successfully migrated SharePoint 2010 documents / data to new DMS solution

Jersey

Initially employed as project manager for the MI and DMS streams part of a larger transformation project. Then ongoing I project managed development initiatives and their resources .Responsibilities• Architect and project manage the MI stream for a large Transformation project• Technical lead on Dynamics NAV MI and DMS projects• Navision FATCA extract for Geneva, Jersey and Isle of Man• Document migration for the DMS stream (SharePoint, Kofax & OnDemand)• Manage offshore development team • Design a data modeling solution for central reporting of cross jurisdictional MI• Develop technical spec. and business requirements• Coordinate change control for the MI / DMS stream• Assist the “technical delivery” team in troubleshooting production issues• Advise on the Kofax Scanning into MS CRM / SharePointAchievements• Successfully managed the migration of Trust client documents from 3 data sources to new DMS solution. All jurisdictions were migrated to within a 0.5% error margin• Developed the corporate EDRMS solution architecture • Designed and documented the DMS migration so it could be replicated• Implemented DataWarehouse solution to consolidate all offshore jurisdictional data• Successfully managed and implemented a BI reporting portal (BIDS) for Nav 2009 using SSRS / SSIS / SSAS• Designed and delivered the Navision FATCA reporting and extract mechanism • Successfully delivered the DMS / MI stream to Hong Kong, Singapore, India, Isle of Man, Geneva and Cayman• Trained the existing “Technical delivery” team on systems delivered• Performed in-depth knowledge transfer to the “application support” team• Successfully managed deployment of all changes with a 100% success• Project manager and architect of a new ETL delivery, monitoring and auditing system • Successfully created a reporting strategy / design for all legacy applications and their eventual decom. and license release• Responsible for the migration of all SQL 2008 ETL to SQL 2012

I was a founder and owner of Cronus Consultancy Ltd, a boutique consultancy and software development company, which we grew to around 25 staff. We created a number of successful products in the financial market, such as RiskTracker, with the most well-known of which being the Oscar Trust system, which we then sold to market leader Microgen and is now their flagship product, 5-series.We also successfully won a number of contracts for local government, Jersey Financial Regulator and large financial institutions.Responsibilities• Management of the development team• All project delivery, change and quality assurance • Relationship management of key corporate accounts• Staff development, training and career progression• Provision of management intelligence for shareholders on department performance• Head of Project Management Office (PMO)• Providing SQL, reporting, MS Office and development internally and externally• Providing Business / System Analysis and Business Process Engineering expertise to Cronus and key clients• Delivery of Data Warehousing and data mining expertiseAchievements• Developed and ran a successful business • Managed 10 direct reports, inclusive of their appraisals and career development• Created a PMO office on a best of breed approach targeted at development arena• Ran the Cronus Cloud platform, delivering a single, tenanted cloud offering • Gained considerable insight on running a business• Pivotal in winning the Enterprise Business awards in 2006 • Instrumental to Cronus becoming the first Channel Island company to achieve Microsoft Gold Partner status and holds six of its accreditations in 2003• Gained considerable domain knowledge in the logistics, regulator, government and financial arena due to my consulting exposure• Implemented a successful training and mentoring strategy• Won a number of public tenders for local government• Implemented a number of business support tools, including MS CRM

Employed as a trainee software developer straight out of university. Within 2 years I was leading technical teams and 12 months later I become one of the most respected senior consultants. At Itex I harnessed my technical skillset through various training courses, gained valuable client engagement experience and business development acumen.• Produced various specifications, requirements analysis and feasibility documents for a number of clients• Re-architected various systems, in order to improve their performance and maintainability• Mentored and trained a number of staff• Carried out a number of teaching presentations on new techniques and technologies to developers• Obtained MCSD, MCDBA, MCSE and MCP+Internet (1st to do so in Channel Islands)• Managed a number of clients (relationship management)• Introduced a number of project estimation techniques and improved the change control process• Implemented Quality Assurance / Test Driven Development practices• Designed various consultancy templates • Key member of the tendering team which included presentations, documentation, project planning, estimation and costings

• Learnt how to develop in Microsoft Access, Visual Basic 5 & 6, SQL Server, Crystal Reports and COM• Re-wrote the Rates System to Microsoft Access• Wrote a Doctors Surgery System and supported it• Learnt web development using Interdev and Visual Studio (HTML, ASP, Vbscript / Jscript)• Designed, wrote and lead the development of the Jersey Legal Info website• Became a team leader on various development projects• Architected, wrote, lead and specified the requirements for a three-tier client server application for the Jersey Financial Services• Setup the Development Domain / Servers using NT4 and later Windows 2000

Bsc (Hons), Software Engineering Management

Matters covered Include: • Programming, Software Design and Quality Control • Metrics and its use in Software Quality • Project Management.

Btec National Diploma, Business And Finance (With Computer Studies)