Jim Heath

Email: ad3gpz@r.postjobfree.com

Phone: 513-***-****

Milford, OH 45150

Authorized to work in the US for any employer.

Summary

10+ years of experience as a Microsoft .NET & SQL Server developer delivering high-performance, scalable solutions. Adept in all aspects of SQL Server development, from design and development to administration. Proven ability to streamline data flow with ETL processes and build robust data warehouses, leveraging strong T-SQL skills. Demonstrated success implementing SSIS, SSRS, and SSAS for secure and scalable solutions. Collaborative spirit and strong communication skills ensure project success.

Work Experience

Owner/Consultant

Machdev.Net – Milford, OH

April 2023 to Present

Full-stack developer with expertise in crafting tailored software solutions, visually engaging websites, and efficient databases. Collaborate with businesses of all sizes to understand their unique needs and deliver custom-built applications. Leverage strong skills in web development, testing & QA, and Microsoft SQL Server (design, queries, stored procedures, administration) to ensure high-quality, secure, and user-friendly solutions.

Contract Developer

Stellar Innovations & Solutions – Dayton, OH

October 2022 to April 2023

Developed and maintained WWRS application for Air Force Security And Cooperations (AFSAC) at Wright Patterson Air Force Base (WPAFB) as a Contract Developer. Leveraged Microsoft.Net, Visual Studio, C#, and Oracle to ensure smooth processing of material returns for US Government FMS requisitions.

Senior SQL Server Developer

CommuniCare - Cincinnati, OH

October 2021 to October 2022

Developed robust auditing and logging for SSIS packages through efficient event handling. Implemented an automated ETL process for archiving and processing raw data using SSIS.

Owned the full ETL lifecycle: designed and developed ETL flows, built enterprise reports with SSRS, gathered requirements, and maintained existing reports.

Collaborated with internal stakeholders to capture requirements for new and updated web applications built with ASP.Net.

Optimized database performance: created, modified, and optimized stored procedures, functions, views, and indexes for reporting and analysis. Tailored queries to specific business needs.

Extensive documentation: documented all new development and existing processes/procedures to ensure clarity and knowledge transfer.

Improved code management: streamlined repository structures within Team Foundation Server. Established a documented, user-friendly process for storing and updating SQL Server stored procedures in TFS using Visual Studio.

Consultant, SQL Server Developer

CBTS - Cincinnati, OH

March 2021 to May 2021

Delivered T-SQL stored procedures and views as Senior SQL Server Developer at Fisher Homes (Erlanger, KY) supporting the Sapphire to Solver conversion project. Documented existing procedures to ensure knowledge transfer. (3-month contract)

Consultant, Software Developer

LMI Consulting LLC - Wright-Patterson AFB, OH

January 2020 to January 2021

Contributed to the Air Force Sustainment Center's RIPIT software development team:

Collaborated in requirements analysis and design alongside internal teams.

Developed clean, scalable .NET code, ensuring code maintainability and future growth.

Performed comprehensive testing, deployment, and maintenance of applications and systems.

Enhanced existing software by revising, updating, refactoring, and debugging code.

Provided expert technical support for deployed applications.

Leveraged SQL Server development, scripting, and support to ensure data integrity.

Proactively built Power BI reports for MS DevOps Server, streamlining project reporting for management with increased efficiency and accuracy.

Consultant, Senior SQL Server Developer

Catapult Solutions Group - Cincinnati, OH

October 2018 to January 2020

Database Administrator & SQL Developer Kroger Freshness & Standards

Delivered high-performing data solutions:

oETL processes using SSIS packages, enhancing data accuracy and accessibility.

oStreamlined reporting with dynamic SSRS reports, enabling data-driven decision-making.

oConnected disparate databases, fostering cross-departmental accountability.

Automated critical tasks:

oImplemented SQL Agent jobs for automated backups and package execution.

oEstablished proactive alerts for job failures and data changes.

Empowered users:

oProvided expert support and training on SQL queries, fostering data utilization.

Optimized database performance:

oAdded strategic indexes, achieving significant query time reductions.

Resolved security issues:

oTroubleshoot and addressed database security and authentication challenges.

Innovation with impact:

oDeveloped a database-driven backstock tracking system saving $50M annually.

Consultant, Senior Software Engineer/ SQL Developer

TPA Technologies - Covington, KY

July 2017 to September 2018

Project: Fidelity Investments - 401k Implementation Project Workspace

Key Responsibilities:

Modernized internal web application for Fidelity's 401k platform, transitioning from Visual Studio 2013/.NET Framework 4.5 to 2017/4.5 and SQL Server 2008 R2.

Improved user experience through UI modernization using Bootstrap and jQuery.

Enhanced application stability by identifying and resolving hundreds of errors.

Streamlined processes by designing and implementing SQL Server-based Project Copy and Plan Copy solutions.

Led all phases of development testing and supported user acceptance testing.

Documented comprehensively all aspects of the application and processes.

Managed post-implementation testing and addressed any arising issues.

Planned and executed a project plan for the Project Copy and Plan Copy project.

Demonstrated proficiency in handling complex technical and functional analysis.

Implemented SSRS reports and SSIS packages for enhanced data integration and reporting.

Benefits:

Increased platform efficiency and user satisfaction.

Boosted application stability and maintainability.

Streamlined internal processes and saved development time.

Demonstrated strong technical and project management skills.

Consultant, Senior Support

Synergy Consulting Group, Inc. - Cincinnati, OH November 2016 to June 2017

PNC Equipment Finance - Database Administrator (SQL Server DBA)

Managed development systems for Oasis project, providing expertise in backup, restore, security, permissions, and scripting.

Supported applications and services used for online content and service delivery, troubleshooting issues and coordinating outages to minimize downtime.

Utilized ServiceNow to create incidents, requests, change requests, and knowledge base articles for efficient issue resolution.

Collaborated with internal and external teams to analyze, remediate, and document application vulnerabilities, enhancing security posture.

Identified and addressed system faults, recommending and implementing solutions to improve resilience, performance, and supportability.

Contributed to process development and best practices, fostering continuous improvement in operations.

Partnered with development teams to deploy applications and solve technical challenges, ensuring smooth production operations.

Developed disaster recovery documentation for application mnemonics, ensuring preparedness for unforeseen events.

Supported the ethical hacking team by analyzing vulnerability reports, contributing to a proactive security posture.

Consultant, Senior Application Developer, IT Security Managed Services

Cincinnati Bell Technology Solutions - Cincinnati, OH

2015 to 2016

Software Engineer GE Risk Management

Developed and implemented Splunk API applications supporting risk management needs.

Designed, coded, tested, and deployed new Windows and web applications.

Enhanced existing systems through analysis, planning, and implementation of improvements.

Maintained software integrity by identifying and resolving defects.

Created data-driven reports and technical specifications.

Utilized diverse technologies including Visual Studio, ASP.NET, SQL Server, HTML, CSS, JavaScript, C#/VB.Net, and PowerShell scripting.

Collaborated with management, staff, and colleagues on projects, tasks, and system maintenance.

Actively researched and acquired skills in emerging technologies.

Consultant, Senior Application Developer

Sabel Systems - Beavercreek, OH

2013 to 2015

Developed and maintained secure web applications for U.S. Defense Information Systems Agency (DISA):

Led full lifecycle development of budgeting, execution, and financial reporting project using Visual Studio, SQL Server, ASP.NET, and VB.NET.

Collaborated closely with DISA to gather requirements, design user interfaces, and implement new functionalities.

Integrated IBM Cognos and SQL Server Reporting Services reports for comprehensive data analysis.

Conducted rigorous unit, system, and user acceptance testing to ensure quality and usability.

Provided production support, resolving issues and ensuring smooth system operation.

Maintained data models aligned with user needs by collaborating with DBAs and team members.

Held Secret security clearance and CompTIA Security+ certification, demonstrating commitment to secure development practices.

Senior Programmer Analyst

Standard Textile - Cincinnati, OH

2010 to 2013

Developed and maintained e-commerce solutions for a leading sales & customer service platform.

Enhanced and supported AccuQuote online ordering system, utilized by sales consultants, ensuring its smooth operation and functionality.

Designed and implemented a custom product sample ordering system for Decorative Products, streamlining internal processes and improving efficiency.

Collaborated with AS/400 programming staff, ensuring accurate data transmission and integration between systems.

Proficient in diverse technologies including Classic ASP, ASP.Net, VB.Net, JavaScript, SSRS, Crystal Reports, IIS, SQL Server (2000 & 2008), AJAX, and jQuery, demonstrating strong technical versatility.

Information Systems Analyst

First Group America - Cincinnati, OH

2010 to 2010

Bridged the gap between business and technical stakeholders, effectively communicating complex IT initiatives to leadership.

Gathered and analyzed user requirements to create detailed specifications for new systems and enhancements, ensuring alignment with business needs.

Provided Tier 3 customer support to both internal and external clients, resolving complex technical issues efficiently.

Developed custom SQL Server/SSRS reports, extracting valuable insights from various data sources to inform decision-making.

Documented custom-built systems, creating comprehensive technical specifications, user guides, and training materials to facilitate adoption and support.

Consultant, BI Developer

Phillips Edison & Company - Cincinnati, OH

2009 to 2010

Database Developer: Migrated Intuit's MRI Commercial Real Estate system reports to SQL Server 2005 Reporting Services, enhancing reporting efficiency and accessibility.

Developed and optimized:

oNew stored procedures and User Defined Functions (UDFs) to streamline data access and manipulation.

Leveraged expertise in:

oSQL Server 2005 stored procedures

oSQL Server 2005 Reporting Services

oVisual Studio

Reduced report generation time by 30%

Consultant, Senior Developer

DSC Consulting - Cincinnati, OH

2008 to 2009

Modernized Web-based Service Request System:

Led the modernization of DSC WebWorks, a critical ticketing system for internal and external customers, by migrating it to .NET Framework 3.5 and SQL Server 2008. This involved a complete rewrite of the client website, ensuring enhanced performance, security, and user experience.

Designed and developed a secure, user-friendly admin back-end and integrated search engine optimization for improved searchability.

Enhanced Client Website Functionality:

Configured IIS on multiple client Windows SBS 2003 servers, seamlessly integrating them with SQL Server 2005.

Successfully delivered a public website with robust features and functionalities, exceeding client expectations.

Streamlined Development Processes at Cengage Learning:

Contracted by Cengage Learning to modernize their Atomic Dog Publishing platform. Migrated the existing backend admin website from classic ASP to ASP.NET, significantly improving efficiency and maintainability.

Established a .NET coding standards document, internal web application documentation, and unit test procedures, laying the foundation for consistent and high-quality development practices within the organization.

Education

Associate in Electro-Mechanical Engineering Technology

Cincinnati Technical College – Cincinnati, OH

1979 to 1981

High school diploma

Colerain High School – Cincinnati, OH

1974 to 1977

Skills

Microsoft SQL Server (10+ years), T-SQL (10+ years), SSRS (10+ years), SSIS (8 years), SSMS (10+ years), Visual Studio (10+ years), Asp.Net (10+ years), C# (10+ years), Vb.Net (10+ years), Reporting (10+ years), Javascript (10+ years), CSS (10+ years), JQuery (7 years), IIS (10+ years), Bootstrap (8 years).

Additional Information

https://machdev.net

Contact this candidate