Lead Solutions Engineer
2021 - PRESENTMasTec- Created a C# application to call third-party APIs through GET and POST requests. I used the GETs to ensure that POSTs were successful by comparing before and after data to the source and destination.
- Wrote PowerShell scripts to push data to multiple systems, including Microsoft SQL DB, into Active Directory.
- Created an ETL process to export data from the in-house database into a file on the file transfer protocol site.
- Built a second ETL process to read data dumps from an external source back into the in-house database and compare differences.
Technologies: SQL Server Integration Services (SSIS), C#, Python, Windows PowerShell, APIs, SQL, Microsoft SQL Server, ETL, Data Engineering, Data Pipelines, Query Optimization, Performance Tuning, Back-end, Analytics, Business Intelligence (BI), Data Modeling, Data Architecture, Software Design, Web Development, Architecture, Full-stack, Leadership, Requirements Analysis, Windows, Visual Studio 2016, .NET Core, REST APIs, .NET, C#.NET, Relational Database Design, Database Architecture, Relational Databases, Data Analytics, SQL Stored Procedures, T-SQL, Linked Servers, JavaScript, SQL Server Management Studio, Visual Studio, TFS, XML, JSON, Git, Jira, Bitbucket, Back-end Development, Microsoft Excel, Reports, DevOps, Database Optimization, Data Visualization, User Experience (UX), Databases, Datasets, Data Analysis, Data Cleansing, Data Profiling, Query Plan, Data Entry, SQL Views, Database Design, Database Schema Design, Stored Procedure, API Databases, Relational Database Services (RDS), DB, Microservices, Technical Leadership, Agile, Prototyping, Application Architecture, Software Architecture, .NET 4, Web API, SQL Server 2016, Training, Networking, IT Security, API Integration, Data Integration, Office 365, Team Leadership, Management, Reporting, Data Transformation, Database Administration (DBA), Microsoft DBA, Transact-SQL, SQL DML, Data Queries, SQL Performance, ELT, Big Data Architecture, Data Migration, Data Extraction, DAX, Power QueryOwner and Independent Consultant
2007 - PRESENTFreelance Clients- Wrote Python scripts to load well data from multiple states. Each state could have different formats, column names, and data points to create and map out all points of a well.
- Built a MySQL stored procedure to take data from a flat row data lake and migrate it into a data source, pivotable based on month and year, and used Loop to process running historical data for different period comparisons.
- Performed all project lifecycle phases, including proposal, work statement, requirements gathering, development, deployment, and production support.
- Optimized the database by correcting indexes created by previous developers and implementing an archiving process to remove millions of records from the application's core table.
- Generated over 30 enhanced .NET controls to make development faster, more efficient, and consistent.
- Created an online address and phone book with Ajax, ASP.NET, and C# for an interactive user experience, allowing users to find what they were looking for quickly.
- Developed an online auction website for cars and recreational vehicles and implemented set bid increments and up-to-bid limits to eliminate users' need to watch items constantly, including a buy-it-now feature, reserve pricing logic, and invoicing.
- Collaborated with a third-party hosting and DNS company support team when servers or services were down, causing client downtime, to resolve the issue as quickly as possible.
- Implemented multiple inventory management websites, including the inventory's public display and a back-end administrator login to manage inventory.
- Engaged with multiple clients fixing database object performance, returning incorrect data results, data, and database security.
Technologies: PHP, MySQL, Microsoft SQL Server, SQL Server Integration Services (SSIS), Python, Windows PowerShell, C#, ASP.NET, SQL, T-SQL, APIs, JavaScript, React, AngularJS, CSS4, VBScript, Microsoft Power BI, WordPress, SiteFinity, Windows Presentation Foundation (WPF), Windows Communication Foundation (WCF), XML, JSON, Git, Jira, Bitbucket, TFS, Azure, Azure Functions, GitLab, REST, Ajax, IIS, SQL Server Reporting Services (SSRS), Excel VBA, Visual Basic for Applications (VBA), Data Modeling, Business Intelligence (BI), RabbitMQ, Back-end Development, Front-end Development, LINQ, OOP Designs, Relational Databases, Data Analytics, AWS RDS, ETL, Data Engineering, Data Pipelines, Query Optimization, Performance Tuning, Data Warehouse Design, Data Warehousing, Back-end, Analytics, PL/SQL, Data Architecture, Google Analytics, CSS, HTML, Software Design, Web Development, Architecture, Full-stack, Leadership, Requirements Analysis, Desktop App Development, Windows, Visual Studio 2016, .NET Core, Angular, REST APIs, .NET, Amazon Web Services (AWS), Docker, C#.NET, Relational Database Design, Database Architecture, SQL Stored Procedures, Linked Servers, Data Lakes, SQL Server Management Studio, Visual Studio, ODBC, VB.NET, Oracle PL/SQL, PL/SQL Developer, Web Services, Windows Services, Microsoft Excel, Reports, DevOps, Database Optimization, Data Visualization, User Experience (UX), Azure Data Lake, Databases, Datasets, Data Analysis, Data Cleansing, Data Profiling, Query Plan, Data Entry, SQL Views, Database Design, Database Schema Design, Stored Procedure, API Databases, Relational Database Services (RDS), Oracle Database, DB, Site Reliability Engineering (SRE), OAuth 2, Functional Programming, Java, Microservices, Technical Leadership, Agile, Prototyping, Node.js, React Native, Lambda Functions, NGINX, Lambda Architecture, Application Architecture, Software Architecture, Server-side Rendering, Serverless, .NET 4, Web API, Model View Controller (MVC), SQL Server 2016, jQuery, Bootstrap, Training, Amazon EC2, Linux, Networking, IT Security, Google Tag Manager, Google Ads, Windows Forms (WinForms), API Integration, Data Integration, G Suite, Office 365, Office 365 API, DocuSign, G Suite API, PHP 7, GitHub, Reporting, Data Transformation, CRM APIs, Database Administration (DBA), Microsoft DBA, Crystal Reports, Transact-SQL, SQL DML, Data Queries, SQL Performance, ELT, Big Data Architecture, Data Migration, Data Extraction, DAX, Power Query, Microsoft AccessVP of Operations
2018 - 2021JOHO, LLC- Built over 100 ETL packages using SSIS to extract, transfer, convert, and load multiple bank cores' data into a single data warehouse daily into dimension and fact tables.
- Devised a process to keep the standard JOHO data warehouse consistent across all clients while supporting individual client-only data warehouse needs through customer-based database schemas.
- Communicated with a third-party software company to help them understand our specific reporting software needs so that they could provide us with future enhancements or workarounds.
- Managed the report development team, held one-on-ones, and looked to help mentor and share knowledge with all team members.
- Designed a flat-table building process that took any SQL views with certain prefixes and created faster-loading SQL tables from that data nightly, recreating indexes and constraints, which also provided faster data loading from the data warehouse.
- Created a data scrubbing process to scrub and sanitize production data into fake testing data, leveraging real account transactions but changing names and addresses and adjusting balances, account numbers, and any personally identifiable information.
- Developed a custom .NET software product and deployed it to multiple clients' on-premises servers for consistency and efficiency.
- Set up a process that enables client data to flow through Azure Functions from an on-premise server into an Azure server securely using a hybrid connection manager.
- Configured ten complete Azure server environment developments, tests, and productions using Azure Functions and hybrid connections to move data.
- Centralized the critical data scrubbing logic into database functions and stored procedures to streamline the data scrubbing process.
Technologies: C#, Azure, Azure Functions, Microsoft SQL Server, ASP.NET, Telerik, DevExpress, ODBC, SQL Server Integration Services (SSIS), Windows PowerShell, Visual Studio, SQL Server Management Studio, ETL, Data Engineering, Data Pipelines, Query Optimization, Performance Tuning, Data Warehouse Design, Data Warehousing, Back-end, Analytics, Business Intelligence (BI), SQL, Data Modeling, Data Architecture, CSS, HTML, Software Design, Web Development, Architecture, Full-stack, Leadership, Requirements Analysis, Windows, Visual Studio 2016, .NET Core, REST APIs, .NET, C#.NET, Relational Database Design, Database Architecture, OOP Designs, Relational Databases, Data Analytics, SQL Stored Procedures, T-SQL, Linked Servers, APIs, Data Lakes, JavaScript, Web Services, IIS, Windows Services, TFS, XML, JSON, Git, Jira, Bitbucket, Back-end Development, Front-end Development, Microsoft Excel, Reports, DevOps, Database Optimization, Data Visualization, User Experience (UX), Databases, Datasets, Data Analysis, Data Cleansing, Data Profiling, Query Plan, Data Entry, SQL Views, Database Design, Database Schema Design, Stored Procedure, API Databases, Relational Database Services (RDS), DB, Functional Programming, Java, Technical Leadership, Agile, Prototyping, Application Architecture, Software Architecture, Server-side Rendering, .NET 4, Web API, SQL Server 2016, jQuery, Bootstrap, Training, Linux, Networking, IT Security, API Integration, Data Integration, Office 365, Team Leadership, Management, Reporting, Data Transformation, Database Administration (DBA), Microsoft DBA, Transact-SQL, SQL DML, Data Queries, SQL Performance, ELT, Big Data Architecture, Data Migration, Data ExtractionDirector of Technology Services
2014 - 2018Razor Consulting Solutions- Corrected the SQL Server security, cleaning up all users' permissions by assigning database roles, creating custom database roles for specific objects, and removing multiple people as admins or owners.
- Used SSIS to pull data from the SQL Server, flat and Excel files, and SharePoint, transform them into clearer metrics, and store them back on the SQL Server for reporting.
- Displayed custom reports using Power BI, allowing users to filter. In some instances, I also used Excel's Power Pivot, Power Query, and Pivot Tables to create reports.
- Set up consistent structure and processes, so each project has the same workflow.
- Collaborated and communicated efficiently with consultants from four other companies to formulate a solution for clients.
- Coordinated the software development team's priorities, roles, and responsibilities and analyzed each project's priority weekly to determine if resources needed adjusting to meet deadlines.
- Innovated a replication process between the Sybase database through VPN and into the SQL Server on the Rackspace cloud environment.
- Sent weekly clear communication with clients on terms, contracts, status updates, budgets, and action items.
- Engaged with the company's leadership and executive team, contributing impactful decisions that affected the company's roadmap, strategy, and employees.
- Managed the company's technical side, including all projects, employees, and other aspects.
Technologies: Microsoft SQL Server, MySQL, ASP.NET, C#, VB.NET, Power Pivot, Windows PowerShell, Microsoft Power BI, SQL Server Integration Services (SSIS), ETL, Data Engineering, Data Pipelines, Query Optimization, Performance Tuning, Back-end, Analytics, Business Intelligence (BI), SQL, Data Architecture, Google Analytics, PHP, CSS, HTML, Software Design, Web Development, Architecture, Full-stack, Leadership, Requirements Analysis, Windows, Visual Studio 2016, REST APIs, .NET, Amazon Web Services (AWS), C#.NET, Relational Database Design, Database Architecture, OOP Designs, Relational Databases, Data Analytics, SQL Stored Procedures, T-SQL, Linked Servers, APIs, JavaScript, SQL Server Management Studio, Visual Studio, ODBC, Web Services, IIS, Windows Services, WCF Web Services, TFS, XML, JSON, Git, Jira, Bitbucket, Back-end Development, Front-end Development, Microsoft Excel, Reports, Database Optimization, Data Visualization, User Experience (UX), Databases, Datasets, Data Analysis, Data Cleansing, Data Profiling, Query Plan, Data Entry, SQL Views, Database Design, Database Schema Design, Stored Procedure, API Databases, Relational Database Services (RDS), DB, Site Reliability Engineering (SRE), Functional Programming, Technical Leadership, Agile, Prototyping, Node.js, Application Architecture, Software Architecture, Server-side Rendering, .NET 4, Web API, Model View Controller (MVC), SQL Server 2016, jQuery, Bootstrap, Training, Networking, IT Security, Windows Forms (WinForms), API Integration, Data Integration, Office 365, DocuSign, G Suite API, Team Leadership, Management, Reporting, Data Transformation, Database Administration (DBA), Microsoft DBA, Crystal Reports, Transact-SQL, SQL DML, Data Queries, SQL Performance, ELT, Data Migration, Data Extraction, DAX, Power QuerySoftware Application Development Manager
2007 - 2014NAU Country, a QBE Insurance Company- Devised custom web and user controls that improved team efficiency by placing repetitive logic setup and control validation at the control level.
- Researched a faster and more efficient way for developers to track errors across all applications to set up a core base error logging, so anything that rolls to the highest point of code still gets logged.
- Built tools to optimize the development team's productivity by creating alerts when Oracle database objects were invalidated due to a change, to not cause others downtime.
- Helped design and develop a code compare tool to verify code changes in all yearly-based files and prevent bugs from recurring.
- Managed multiple projects, fulfilling different roles of designer, developer, code reviewer, and quality assurance officer within the development lifecycle.
- Collaborated with designers to work on stronger security practices, coding standards, and other items that should be communicated to the entire development team.
- Developed automated tests to run for release deployment verifications to remove the need for manual testing after nightly releases.
- Created task alerts to email team members of pending high-priority tasks that need immediate assistance.
- Owned release manager responsibilities and worked with project management, business analyst, quality assurance, server, network, build, deployment, and development teams to communicate daily release status updates.
- Handled Progress Telerik Sitefinity configuration, customization, and enhancements after the initial vendor installation.
Technologies: Oracle, Tableau, Oracle PL/SQL, PL/SQL Developer, Microsoft SQL Server, T-SQL, C#, Visual Basic 6 (VB6), ASP.NET, ASP, IIS, Visual Studio, Windows PowerShell, Python, WCF Web Services, Windows Services, TFS, Query Optimization, Performance Tuning, Back-end, Analytics, Business Intelligence (BI), SQL, PL/SQL, Data Architecture, Google Analytics, CSS, HTML, Software Design, Web Development, Architecture, Full-stack, Leadership, Requirements Analysis, Desktop App Development, Windows, REST APIs, .NET, C#.NET, Relational Database Design, Database Architecture, OOP Designs, Relational Databases, Data Analytics, SQL Stored Procedures, Linked Servers, APIs, JavaScript, PHP, SQL Server Management Studio, VBScript, ODBC, Web Services, Windows Communication Foundation (WCF), XML, JSON, Back-end Development, Front-end Development, Microsoft Excel, Reports, Database Optimization, Data Visualization, User Experience (UX), Data Engineering, Databases, Datasets, Data Analysis, Data Cleansing, SolarWinds, Query Plan, Data Entry, SQL Views, Database Design, Database Schema Design, Stored Procedure, API Databases, Relational Database Services (RDS), Oracle Database, DB, Site Reliability Engineering (SRE), Functional Programming, Technical Leadership, Agile, Application Architecture, Software Architecture, .NET 4, Web API, Model View Controller (MVC), jQuery, Training, Networking, IT Security, Windows Forms (WinForms), API Integration, Data Integration, Team Leadership, Management, Reporting, Transact-SQL, SQL DML, Data Queries, SQL Performance, ELT, DAX, Power QueryApplication Developer
2002 - 2007Microsoft- Engaged as one of the top developers requested by project managers to be part of the development team due to experience and ability to work on any part of the system.
- Ensured high-quality code output from myself and everyone else on the team. During testing sessions, I would thoroughly review as many features as possible, looking for issues that needed correcting before the next release.
- Participated as one of the leading developers who interacted with consultants from around the globe to answer their questions, provide feedback, and do code reviews.
Technologies: ASP.NET, C#, Web Services, IIS, Windows Services, Query Optimization, Back-end, SQL, Data Architecture, CSS, HTML, Software Design, Web Development, Architecture, Full-stack, Leadership, Requirements Analysis, Windows, .NET, C#.NET, Relational Database Design, Database Architecture, OOP Designs, Relational Databases, SQL Stored Procedures, T-SQL, JavaScript, SQL Server Management Studio, Visual Studio, VBScript, ASP, WCF Web Services, TFS, Windows Communication Foundation (WCF), XML, Back-end Development, Front-end Development, Microsoft Excel, Database Optimization, User Experience (UX), Data Engineering, Databases, Datasets, Data Analysis, Query Plan, Data Entry, SQL Views, Database Design, Database Schema Design, Stored Procedure, API Databases, Relational Database Services (RDS), DB, Functional Programming, Java, Web API, Windows Forms (WinForms), Transact-SQL, SQL DML, Data Queries, SQL Performance, ELT, Data Migration, Data Extraction