Business Intelligence Lead Developer

• Aug 2021 - Present

Senior Application Manager/Database Developer

• May 2020 - Jun 2021

• Principle database developer and manager of 10 technical analysts/database reliability engineers across London and Bucharest.• Accountable for optimal performance and 24/7 operation of multiple mission critical production SQL Server databases, ranging in size from 1TB to over 30TBs. • Focus on SQL Server (2008R2 – 2019): - Development: Stored procedures, functions, views, triggers, dynamic SQL, recursive CTEs - Optimization: Query plan analysis and performance tuning, wait statistics review, indexing strategies, plan guide implementation, deadlock analysis and prevention, SQL profiler, DMVs. - Administration: Transaction/tempdb log breach analysis, DBCC checks, SQL Agent, filegroup & partitioning deployment. • Instrumental in the implementation of incident, problem and risk management functions, including establishment of IT key performance and key risk indicators.• Regular contributor and attendee of multiple governance initiatives including risk forum, operational committee, portfolio forum and change management steering committee.

Product Design Engineer

• Sep 2019 - Apr 2020

• Highly technical role focusing on improving efficiency and resilience of UnaVista platform, solutions and underlying infrastructure. • Extensive SQL Server development (stored procedures, functions, views, triggers) and optimization, troubleshooting poorly performing solutions, database latency and collaborating with UnaVista Development team on platform code enhancements.• Mentoring of Solutions, Customer Support and Professional Services colleagues on SQL Server development best practices across a range of UnaVista solutions (SFTR, MiFIR Reporting/Reconciliations and EMIR Trade Repository/Data Warehouse).• Responsible for resolution of multiple internal and external technical escalations ranging from regulated system latency (MiFIR/EMIR) to functional solution issues. Directly involved in the resolution of critical service/priority one incidents collaborating with numerous technical teams across LSEG.• Championed upgrade of UnaVista Solutions from SQL Server 2008R2 to SQL Server 2017.

Implementation Specialist

• Feb 2019 - Sep 2019

• SQL and XLST development on the Everest platform, a comprehensive front-office solution providing portfolio/trade order management, performance attribution and credit/direct lending research modules to investment management clients. • Exposure to multiple asset classes with a key focus on modelling FX instruments and their interaction with renown back-office accounting systems such as Geneva. • Extensive interaction with senior client stakeholders ranging from front to back office, elicitation/analysis of requirements and ownership of key project artefacts throughout client implementations. • Key focus on project scoping and resource allocation, management of offshore development team.

Product Solutions Team Lead

• Feb 2017 - Jan 2019

• Lead Microsoft SQL Server developer on the UnaVista platform coupled with extensive exposure to financial markets and compliance regulation.• Owner of multiple intricate financial systems, focus on application efficiency and large data throughput for regulatory transaction reporting and associated services.• Mentoring of Solution Architects encompassing platform guidance, business data knowledge and SQL Server development best practices.• Reporting line to Managing Director in enhancing solutions delivery frameworks.• Management of local and offshore Solution Architecture team including hiring, training and liaising with project management office in allocation of resources.

Product Solutions Architect

• Nov 2014 - Jan 2017

• Business analyst/developer role, providing extensive exposure to full system development lifecycle and various technologies• Advanced development in Microsoft SQL Server (complex transact-SQL scripts, performance tuning/optimization, programming/functions/triggers).• Extensive exposure to XML message programming (schema definition/interpretation and extraction of data through proprietary Java-based language) focus on industry standard message types (SWIFT, ISO 20022, FpML).• Extensive client interaction including requirements elicitation, demonstrations/presentations of systems and key project deliverables and training of internal and external global project teams.• Ownership of key project artefacts including: functional requirements specifications, performance and functional test plans and scripts, training documentation, solution design documentation and system release notes.

Automate and Product Integration Specialist

• Feb 2014 - Oct 2014

• Development of complex ETL processes utilizing internal software, providing extensive exposure to XML, SQL and C#. • Automation and standardization of daily client ETL and reporting processes, re-alignment of operational processes using outsourced Bulk Process Automation (BPA) server management software. • Integration of third-party applications with internal cloud-based software, via the Salesforce CRM platform. • Documenting business requirements elicited from senior internal stakeholders, production of technical specifications and prototypes for delivery to internal and external developers. • Training of global client service teams in third party applications integrated with in-house cloud-based software.

Data Warehouse Implementation Consultant

• Sep 2011 - Dec 2013

Infovest is a private South African based company servicing the data integration and data warehousing needs of the investment management industry. Infovest develops and licenses investment data management software and consulting services in order to provide a comprehensive data management solution to a number of clients. Key responsibilities include: • Development of complex SQL Server objects (stored procedure, functions, triggers etc.) • Optimization of MS-SQL queries by analysing query plans, index fragmentation and table statistics. • Development of data workflows (ETL) using a propriety workflow engine based on Windows Workflow Foundation (WF). ETL processes resembled SSIS providing exposure to C#, VBA programming and regular expressions. • Training junior SQL developers in data warehousing principles and MS-SQL best practices. • SSRS development: client compliance reporting, fund fact sheets and investment research/business intelligence reports.

Business Analyst

• Feb 2011 - Sep 2011

The role required the understanding and interpretation of client requirements in order to accurately define business specifications for project development. Key responsibilities included: • Build and maintain sound professional relationships with customers. • Ability to understand and merge Business and Technical Requirements. • Identify business needs and market opportunities. • Document business requirements (including Business Requirement Specification documentation, Business Investigation and Competitor Analysis documentation etc.). Effectively communicate business requirements Contribute to the design of business solutions • Work closely with technical teams to ensure that the best solution is delivered.