University of North Carolina at Charlotte

Microsoft Certified Azure Data Engineer

Permanent position as an Azure Data Engineer utilizing Azure SQL Server, Data Factory, Synapse and Databricks to develop and maintain data pipelines for onboarding patient data into Dynamics 365.  This position taught me Delta Live tables using medallion architecture as well as using Azure Dev Ops to properly deploy to production environments.

Doctor Care Anywhere

Data Engineer

Permanent position as a Data Engineer / ETL Developer utilizing Azure SQL Server and SSIS to develop and maintain data pipelines for spend analytics.  Created data ingestion and transformation pipelines for a variety of data sources including SAP, Oracle and Sage for clients such as Sony, NBCUniversal Media and Coca-Cola.

Rosslyn Data Technologies

Engaged as Data Warehouse Developer to administer/develop SQL Server data warehouse which held all call data records and financial information for the company including 130 data sources and 13m new records daily. Responsible for supporting planning and development for migration to Snowflake and Redshift, developing system to identify SMS abusers and to support fraud detection, and completing a POC of Data Transformation using DBT and Snowflake. Utilised Agile and Kanban development methodologies.

giffgaff

Data Warehouse Specialist

Engaged as SQL Developer to provide large datasets of trade data to major banks to facilitate FCA reporting. This involved creating SSIS packages to facilitate export in different formats, creating daily SSRS reports based on Oracle and SQL Server and writing complex queries against MiFID II trade data.

Trax

Contract SQL Server Developer

Engaged as SQL/Data Warehouse Developer to develop and support several data warehouses used by internal users and car dealerships throughout the UK, Slovenia and Morocco. Responsible for managing Click and Decide (v12) including user support, ad hoc query and database development for SQL Server and Sybase, managing complex proprietary ETL processes for multiple environments and delivering a business-critical month end reporting system.

RCI Financial Services

Contract SQL Server / Data Warehouse Developer

Engaged as Developer to lead SQL development and report configuration for a major transaction reporting tool used by the operation support desk to investigate problems with the Visa transaction processing system. Worked closely with Business Analysts to create user stories ad support deployment to test, QA and production environment. In addition, managed the end to end development of authentication system for the main extranet using web services, ASP.Net, XML and XSLT.

Visa Europe

Contract Developer

Engaged as Team Leader / Developer to oversee the BBC iPlayer development team with ownership for leading a team of 3 Developers, 3 Testers and a Business Analyst. Managed development within strict SLA measures to prevent financial penalties and led deployment of web service code and database updates across 4 networks and 34 servers

Siemens PLM Software

Team Leader / Developer

Engaged as Developer on 2 separate contracts to develop a 360o Assessment application for senior management involving gathering requirements, writing technical specifications, designing database and application and developing reports. The application was subsequently approved and deployed to users. In addition, led projects including SQL Server integration and Windows Forms.

Hampshire County Council

I established Server Side Events Ltd to provide clients with a range of data warehouse and SQL development, data warehouse administration, systems migration, reporting solutions implementation and data warehouse consolidation. Over the past 13 years, I have supported leading clients across the telecoms, financial services, technology and local government sectors including Giffgaff, RCI Financial Services and Visa Europe. 

Notable Assignments include:

	Giffgaff: Administered and developed SQL Server data warehouse and developed system to identify SMS abusers and performed POC of data transformation.
	MarketAxess/TRAX: Provided large datasets of trade data to major banks to facilitate FCA reporting with ownership for creating SSIS packages, creating daily SSRS reports and writing complex queries. 
	RCI Financial Services: Developed and supported data warehouses used by internal users and car dealerships throughout the UK, Slovenia and Morocco. In addition, managed Click and Decide (v12), oversaw complex proprietary ETL processes and delivered a month end reporting system.
	Visa Europe: Led SQL development and report configuration for a major transaction reporting tool used by the operation support desk to investigate problems with the Visa transaction processing system. 
	Siemens Internet Services: Oversaw BBC iPlayer development team with ownership for leading a team of 3 Developers, 3 Testers and a Business Analyst, and led deployment of web service code and database updates across 4 networks and 34 servers.
	Hampshire County Council: Developed a 360o Assessment application for senior management which was approved and deployed to users. Additionally, led SQL server integration and Windows Forms projects.
	iBuy: Led conversion of the intranet and customer service software from Classic ASP to ASP.Net 2.0. System processed £15m of orders during the conversion process.

Jim O'Hara