Ritesh Patel

Senior Data Engineer

PremFina

Jul 2023 - May 2024 (11 months)

Power BI Mastery - Solved complex challenges in report development, optimising the tech stack for seamless data integration Data Model Innovator - Migrated Power BI models from operational (Silver) to optimised Kimball (Gold) using Medallion architecture. ETL Proficiency - Built lightning-fast ETL routines in Python & Azure Functions for sub-20ms data loading from JSON to Azure SQL Azure Databricks Wizardry - Delivered high-performing reports & visualisations through advanced SQL and Python ETL workflows API Architecture - Designed Azure APIs and leveraged Postman for efficient development and testing. Collaborative Problem Solver: Partnered with stakeholders to refine requirements via interactive POC feedback loops Data Lakehouse

Senior SQL Server Business Intelligence Data Engineer

RenaissanceRe

Jul 2021 - Apr 2022 (10 months)

SQL Server & Azure Data Solutions Expert Mastery of T-SQL and the full SQL Server Tech Stack, including Tabular SSAS models, SSIS, and Azure solutions. Transformed reinsurance finance systems by enhancing cash operations reporting and integrating Power BI with Paginated Reports (RDL) for seamless data insights. Designed and implemented ETL pipelines and advanced data visualizations using SQL Server, Data Lake, and virtualization tools. Collaborated with MIS, Finance, and Business Transformation teams to analyze data, design solutions, and drive best practices in database technology and analytics. Championed continual improvement of data platforms, leveraging industry trends for process and system optimization. Developed and maintained

SQL Server Architect

London Metropolitan University

Jan 2021 - Jul 2021 (7 months)

Led technical teams and third-party suppliers in migrating an Oracle database to a SQL Server 2019 stack for a core business system (SITS). Conducted a deep-dive discovery, uncovering hidden database interfaces, enabling the rationalization of the interface landscape. Designed and implemented new environments to manage seamless data migration across lifecycle stages, supporting multiple integration workstreams. Rewrote over 800 Oracle objects and custom scripts to ensure a high-performance, zero-data-loss migration process. Delivered detailed report for client and technical analysis documentation for smooth handover to the on-site team.

SQL Server Architect

London Metropolitan University

Jan 2021 - Jul 2021 (7 months)

Led technical teams and third-party suppliers in migrating an Oracle database to a SQL Server 2019 stack for a core business system (SITS). Conducted a deep-dive discovery, uncovering hidden database interfaces, enabling the rationalization of the interface landscape. Designed and implemented new environments to manage seamless data migration across lifecycle stages, supporting multiple integration workstreams. Rewrote over 800 Oracle objects and custom scripts to ensure a high-performance, zero-data-loss migration process. Delivered detailed report for client and technical analysis documentation for smooth handover to the on-site team.

Senior Business Intelligence Consultant

CDP

Sep 2020 - Apr 2021 (8 months)

Expert in SQL Server and Azure Data Solutions, designing high-performance, scalable architectures. Led Azure SQL migration and ADF pipeline strategies with a focus on PaaS/SaaS over IaaS. Transformed complex business requirements into streamlined, database-driven solutions through stakeholder collaboration. Reduced data processing time 250x, achieving real-time data throughput from 1 transaction per 2 minutes to 2 transactions per second. Engineered advanced T-SQL solutions incorporating .NET principles to solve critical business challenges. Optimized SQL Server systems with a laser focus on performance tuning and simplicity. Played a pivotal role in team expansion, recruiting top-tier data engineers.

SITS SQL Server Technical Lead / Architect

Stu Limited

Apr 2020 - Jan 2021 (10 months)

Data and Analytics Developer

Brewin Dolphin

Oct 2019 - Apr 2020 (7 months)

Working on Data Lake Gen 2 and Azure Data Factory2 solutions Scripting with ARM templates. Working via Azure DevOps process. Collaborative team working across PowerBI, Azure and SQL Server BI.

SQL Server 2017 Tech Lead

Deloitte Consulting

Aug 2019 - Sep 2019 (2 months)

SQL Server Tech Lead to implement a complex calculation engine for a short term project that delivered sophisticated formulas for ceded reinsurance allocation splits. Transformed all aspects of the projects into a fully automated solution with data governance principles built in. Expert Level in T-SQL and performance tuning and troubleshooting all aspects of SQL Server. Provided an interface between multi-disciplinary IT teams including Project, BA and Azure Cloud teams. Transition to client / Deloitte offshore team for continue support and testing.

Undertook intensive Azure cloud training (Instructor led with classroom labs)

Dataqubed Ltd

Jun 2019 - Jul 2019 (2 months)

June 10th-14th: AZ-103 - Microsoft Azure Infrastructure and Deployment (5 days). June 17th-21st: AZ-300 - Microsoft Azure Architect Technologies (5 days). June 24th-28th: AZ-301 - Microsoft Azure Architect Design (4 days). July 1st - 5th : DP-200/201 - Microsoft Azure Data Engineer Associate (5 days) July 15th - 17th: BCS Diploma - Practitioner Certificate in Requirements Engineering (3 days). Certification in both AZ-300 and AZ-301 earn Azure Solution Architect Expert. June/July: PCAP - Programming Essentials in Python. Potential Further Training Plans (TBD): Microsoft Data Scientist Associate Azure Artificial Intelligence Associate

Senior SQL Server 2017 Business Intelligence Specialist (Contract)

CDP

Mar 2019 - Jun 2019 (4 months)

Expert Level in programming T-SQL and in all areas of SQL Server including SSIS, SSAS, SSRS. Advanced knowledge of DAX and PowerBI. Designed and delivered end to end BI and data warehouse solutions using best practices using Kimball methodology. Built and maintained ETL packages including the collaborating on delivering C# script tasks with other developers. Resolved and debugged ETL and data warehousing issues including performance problems with the cardinality estimator. Provided technical design & development task estimates and contributed to sprint planning in an Agile environment working with Teams, Slack, TFS with tight deadlines. Significant track record and experience of delivering creative BI solutions using the Microsoft BI s

SQL Server and Azure Specialist

Dataqubed Ltd

Jan 2019 - Jul 2019 (7 months)

SQL Server 2017 Senior Developer (Contract)

NOW Pensions

Oct 2018 - Dec 2018 (3 months)

Providing business intelligence architected solutions and guiding a data cleansing project required for a business-critical financial reconciliation Liaised with all key stakeholders to identity the scope of the project and its barriers Acting as an internal consultant for the team helping remove roadblocks in their workstreams. Writing complex, elegant T-SQL, stored procedures, views and functions that are optimised for performance by deciphering their execution plans Using Power BI visualizations/PowerPivot to report the progress of data correction of various entities Applying business intelligence techniques such as matrixes, banding, pivoting to grade problem severity Identifying complex underlying reasons that explained how data

A

SQL Server MI/BI Expert (Contract)

AdventGroup Insurance Fairfax company

Nov 2017 - Aug 2018 (10 months)

• Expert at applying the full SQL Server tech stack (T-SQL, SSRS, SSAS, SSIS) to business problems. • Designed the MI and BI strategy including the Tabular Model with a view to using DAX for business calculation problems. • Presented a series of ‘tech nuggets’ to solidify technology concepts to company wide audiences. • Involved in developing Machine Learning (includes POC on Azure) procedures by working with Senior Actuaries and supporting them with the interoperability of R code and SQL Server. • Embedded within the business to work on several projects and significantly reduced time to delivery by working directly with business users and stakeholders. • Championed a business case to move to SQL Server 2017 Enterprise which was approved o

D

SQL Server Consultant (Contract)

Deutsche Investment Bank

Jul 2017 - Nov 2017 (5 months)

• Worked on a tactical compliance archive reconciliation project to satisfy banking regulatory objectives involving massive datasets. • Successfully re-designed the database components to scale the shelf life from 2 years to 8 years. • Wrote advanced T-SQL stored procedures to analyse and perform complex data analysis for reconciliations derived from several heterogeneous sources involving dynamic pivot, high performing windowing functions and running totals. • Optimized SQL Server with extensive query performance tuning such as ensuring queries harness partition elimination to support the scaling and analysis of large datasets over the billion row mark. • Expertly remodelling/re-architected the database schema significantly improving effic

SQL Server 2008/2008R2/2012/2014/2016 Enterprise Expert/SME (Contract)

ProSight Specialty Insurance

Jan 2017 - Apr 2017 (4 months)

• Used expert SQL Server skills across the tech stack (SSRS, SSIS, SSAS) to support and enhance the business finance transformation project and data warehouse strategy. • Wrote T-SQL programmable objects to analyse and perform financial reconciliations from multiple systems. • Worked on the business analysis side of insurance e.g. writing logic to analyse binders, bordereaux, cover holders, agents, sub-classes, risk code splits and associated values such as gross, net and deduction splits. • Previous end to end delivery and management across analytics, development, testing and implementation. • Awareness of mapping and translating data across disparate systems to warehouse data. • Worked with 3rd Party vendors to assess the viability of the

B

SQL Server SME 2016/2014/2012 Developer/DBA/BI (Contract)

Beazley Insurance

Jan 2016 - Jan 2017 (1 year 1 month)

Multi-SQL Server Administration Using Powershell with T-SQL Development DBA activities

SQL Server 2014 Developer/Architect (Contract)

Nomura

Jul 2015 - Dec 2015 (6 months)

SQL Server 2014 Stored Procedures

SQL Server Expert (Contract)

Tokio Marine Kiln Underwriters for the Lloyds of London Syndicate The City

Dec 2012 - Jul 2015 (2 years 8 months)

• Worked within the Lloyds of London Syndicate on FSA regulated IT and database financial systems. • Used diverse change management practices to evolve the SQL Estate whilst adhering to heavily audited FSA regulated principles within the ITIL framework. • Consulted with project team heads resulting in release of budgets from the executive team and the initiation of enterprise wide projects in order to revamp the SQL Estate and its processes. • Custom developed a range of management suite dashboards in SSRS/SSIS for capacity management to help the organisation reach internal maturity level goals. • Worked with Risk Management and Underwriting teams to drastically improve the performance of and (enhance the uptime) of their business critical

B

SQL Server 2008R2 Systems Technical Architect (Contract)

Brinkely Services Limited

Aug 2012 - Nov 2012 (4 months)

Identified areas within the data model to perform data consolidation and improve data architecture. Reviewed and tested several methods such as transactional replication multiple publisher single subscriber topology, merge replication, Change Data Capture and Merge DML approaches. Architected a Change Tracking solution to implement data consolidation from multiple database to single data store that created a data warehouse that was extremely efficient by importing delta rows only in a slowly changing dimension type II scenario.. Identified and provided recommendations to improve and resolve isolation level concurrency issues Made major strategic recommendations to change the architecture and improve high availability and disaster recover

SSRS SQL Server Analyst

Treasury Wine Estates

Jul 2012 - Aug 2012 (2 months)

Short term assignment undertaken as part of a challenge to deliver critical end of fiscal-year profit and loss general ledger reports to the executive team. Drafted in as an SSRS expert to deliver highly pressured deadlines visible at director level. Crafted highly complex T-SQL that was packaged into sophisticated future proof stored procedures providing elegant solutions to particularly tricky problems. Designed dynamic SSRS reporting solutions using table and matrix styles involving report parameters, VB expressions, grouping and sorting techniques, subreports and drillthrough reporting in order to support visualisation of complex datasets. Quickly established strong working relationships and rapport with the B.I lead architect, busi

SQL Server Architect

Plextek Ltd

Oct 2011 - Dec 2011 (3 months)

Architected and developed a highly efficient SQL Server 2008R2 database for a start-up project involving high throughput SMS based transactions to forward the actual commercial realisation of a novel concept. Evaluated and made technical recommendations by gathering the business requirements and specifications through iterative interview sessions with existing technical and business analysts. Developed SQL Server 2008R2 database alongside efficient and expert coding of stored procedures, functions and views for a large scale system pilot. Utilised techniques for defensive T-SQL coding and error handling. Performance tuning of code was a priority to provide resilience under constant heavy load. Analysed weaknesses of the system by conduct

I

Senior SQL Server Specialist (Mobile Banking)

IBMVodafone

Sep 2009 - Nov 2011 (2 years 3 months)

Core team member involved in change transitioning IBM into M-PESA technologies (mobile banking via SMS, IVR, USSD using MSMQ). Performed knowledge transfer, documentation and training to IBM Indian offshore teams. Trained on-shore IBM technical and management personnel in relevant aspects of the M-PESA system with its extensive SQL Server Estate as a subject matter expert based upon all aspects of SQL Server technologies including Business Intelligence Studio (BIDS) for SSIS, SSAS and SSRS. Provided technical design architectural strategies to continuously drive the system forward, e.g. completely re-architected multi-TB data warehousing system. Redesigned and optimised OLAP cubes and ETL processes from 24 hr+ completion time reduced to

Managing Director

Dataqubed Ltd

Feb 2008 - Current (18 years 6 months)

SQL Server, Azure and Power BI Expert

Dataqubed Ltd

Feb 2008 - Current (18 years 6 months)

D

Microsoft SQL Server Consultant

DataQubed

Apr 2007 - Aug 2012 (5 years 5 months)

A supplier of core SQL server 2005/2008 technologies through innovative uses of the technology stack, Business Intelligence solutions and Database Systems Architecture. Advanced skills in database design and data modelling ensure that all project specifications are delivered with the greatest efficiency. DataQubed was previously working on the world pioneering M-Pesa project and is currently seeking it's next client.

S

SQL Server Business Systems Analyst (Mobile Banking)

SagentiaVodafone

Apr 2007 - Sep 2009 (2 years 6 months)

Core member of the groundbreaking world’s first global mobile money transfer system – M-PESA (through Vodafone), a mobile financial system that transits £several million hundred daily. Supporting several million users with several thousand new subscriptions daily. Dynamically shifted strategies to keep pace with growth. Lead the technical aspects of the project, architecture and implementation of the biggest deployment based in India associated with a revenue stream of several million GBP. Co-ordinated and managed the technical deployment on-site in Mumbai for over 3 months with a distributed team of 8. On-call (within 30 minute response time), 24/7 production DBA with practical experience of DR and high-availability techniques on VLDBs

Managing Director at Dataqubed Ltd.

Dataqubed Ltd

Feb 2007 - Jan 2022 (15 years)

SQL Server Developer

Inca Digital Printers

Nov 2006 - Apr 2007 (6 months)

Lead a series of projects that performed a thorough analysis of the business with a view to re-engineering the existing out-dated information system and modernising it. Expert in database architecture and Entity-Relationship design. Developed several databases to co-ordinate and manage complex data throughput as a direct result of business analysis. Developed and supported several VBA Access Database Project front-end applications that served as data entry and reporting vehicles for the end-user that operated robustly as mission-critical systems.

D

Business Systems SQL Server DBA

Digital Healthcare

Nov 2005 - Nov 2006 (1 year 1 month)

Scripted complex stored procedures to automate and speed up data fixes; cleansed and extracted all forms of data in all formats for reporting and improved existing data models. Performed diverse range of database and data administration techniques for over 50+ live production databases with sizes in excess of 30GB over remote connection all across the UK to access NHS sites. Frequently visited a variety of client-sites to deploy install/upgrade software projects and ensure correct SQL server and application functionality whilst under critical pressure. Developed a framework of strategies and defined structured methodologies to deal with complicated and time-consuming database data ‘fix-ups’ and maintenance issues. Discovered data errors

About

Detail

Timeline

Résumé