OmniData

➢	Architected and delivered custom data analytics solutions for D365 and Business Central in Microsoft Fabric. 
➢	Directed technical delivery of five simultaneous data and security compliance projects in Azure, Microsoft Fabric, and Microsoft Entra.
➢	Built bespoke solutions in Microsoft Fabric for continuous delivery of data for predictive modeling.
➢	Conducted detailed analysis of legacy platforms, and designed cloud-based solutions for modernization of the client’s analytics program.
➢	Tools: Microsoft Fabric, Azure Key Vault, Azure Storage, Azure VM, Dataverse, Power BI, Microsoft Entra, Azure DevOps, T-SQL, Microsoft Excel.

Senior Solutions Architect

Core BTS

Senior Solution Architect with Data Analytics/Data Processing (DADP) practice at Core BTS. With over thirty (30) years of experience in the information technology industry, has played key roles in multiple data architecture projects across a wide variety of industries.
 
Core skills include data architecture, data governance, data engineering and data analytics, performance tuning, automation, DevOps. Graeme has significant experience on the Azure and Microsoft platforms, including Microsoft Fabric, Microsoft Purview, Azure SQL Database (all formats), Azure Data Factory, Azure Synapse, Azure Automation, and Azure OpenAI.

Senior Solution Architect

Health Catalyst

Architected specialized data lake to accommodate large number of deep-hierarchy JSON files (FHIR format), producing a searchable tabular format, available for testing and analysis.

Data Synthesis Architect

Neudesic

Lead team of 10 data professionals in data engineering, analytics, and visualization for multiple clients.

Practice Leader, Data and AI (Houston)

Architected a secure Enterprise Data Platform in Azure Synapse ● Design and build pipelines to consume data from multiple source types: Oracle, SAP, SQL Server, Excel spreadsheets, REST, CSV, JSON, etc. ● Use medallion approach to data purification and transformation ● Automation to create and enhance views in serverless pool ● Query data in Azure Data Lake (Synapse) ● Design and build Data Warehouse for Science and Analytics ● Establish CICD pipelines to promote code to subsequent environments using Azure DevOps

Principal Consultant II

Senior Consultant II

ARCHER Systems, LLC

Enterprise Data Architect

VisionIT

Assigned at MurphyUSA in El Dorado, AR. ▪ Tools: SQL Server 2016-2017, Azure DevOps, SSIS, Visual Studio 2017, tableau (some), Power BI (intro) ▪ Architect DevOps solution (pipelines) for release management ▪ Redesign company database for retail data ▪ Query authoring and debugging; performance tuning ▪ Mentor developers in best practices for ETL, unit testing, code ▪ Mentoring new DBA  ▪ Teaching agile (Scrum) and best practices ▪ Team Lead

Data Warehouse Architect

Cybersoft Technologies

Tools: SQL Server 2016, 2014, 2008R2, T-SQL, TFS 2017, SSIS, SSRS, Visual Studio 2015, Microsoft Dynamics CRM

Architect and script enterprise databases and related server objects. 

Administer multiple instances of SQL Server, databases, SSIS, SSRS, including security, upgrades, backups, replication, etc.

Design and manage database deployment processes using various methods (including Visual Studio Database Project).

Custom, advanced T-SQL programming for variety of needs, often complex situations. Very familiar with SQLCMD mode.

Architect and automate database schema change management and data congruency.

Analyze and resolve SQL object performance issues (stored procedures, e.g.) for databases in various environments across the country. Heavy experience with query performance tuning and SQL Exec Plans.

Architect migration scripts to move data from old to new schema (200+ tables).  Write code to generate code for hundreds of table data migrations between mismatched schemas.

A current project: Build a generator (TSQL code) to write scripts to move all the data in all tables related to one recordset from one database into another, while managing key changes. Generator automatically handles relationships between 1000+ tables (up and down).

Perform code reviews of SQL and business object code.  Make changes for performance or correct errors.

Mentor junior developers on defensive coding methods to improve performance and reliability.

Database Architect/DBA

RealEC Technologies

Tools: ASP.NET MVC 2.0-3.0, Entity Framework 4.0, Telerik MVC Extensions, SQL Server 2008R2

Architect, write and test an internal web application for reporting on all aspects of customer and vendor configuration. Utilize the repository and unit-of-work patterns, rewrite several T4 templates to generate code supporting inversion of control.

Working to establish standards for SQL code and architecture. Create and document methods for automation of SQL code.

Perform code reviews of SQL and business object code. Make changes for performance or correct errors.

Counsel junior developers on coding methods to improve performance and reliability.

Web Solutions Developer / DBA

Avanade

ETL/Business Intelligence, using SQL Server Integration Services (SSIS), SQL Server 2008R2.  Tech lead in Managed Services Level 3 team with offshore consultants.

Senior Solution Analyst

Sapphire Technologies

[Continental Airlines] Built and tested internal web application (confidential) from mock-ups.  Architected supporting database (SQL Server), custom security, inventory management and parts ordering system and dashboard.  Wrote custom ETL solution to migrate existing data from multiple databases into one (30,000 lines of SQL code). Tools: SQL Server Enterprise, ASP.NET 3.5, telerik controls for AJAX.

Senior Developer

Making someone's job easier or life more peaceful is my greatest passion. This starts with listening to their dream, which leads to designing an analytics platform that faithfully represents results. It is about service and doing the right thing at the right time. It is about knowing which tool fits best.

Specialties: Azure cloud analytics with Synapse and Microsoft Fabric, Azure SQL Database, ELT, Medallion Architecture, Cloud Migrations, Data Lakehouse, Azure Automation, Cloud Adoption Framework, query tuning and data governance with Microsoft Purview; smart analytics, MDM. Superior soft skills.

Taplio

Graeme Martin's Linkedin Analytics

Want to drive more opportunities from LinkedIn?

Taplio

.css-1jgreyo{background-image:linear-gradient(284deg, rgba(39,43,72,1) 0%, rgba(33,47,183,1) 100%);color:transparent;-webkit-background-clip:text;background-clip:text;}Graeme Martin's Linkedin Analytics

Want to drive more opportunities from LinkedIn?

Graeme Martin's Linkedin Analytics