I'm Jim Heath

SQL Server Developer

Hello, My Name is Jim Heath.

I am a Software Developer in the Greater Cincinnati area.

With extensive experience working with Microsoft SQL Server, my objective is to leverage my deep expertise in database management, optimization, and development to create and maintain robust, efficient, and secure SQL Server databases. I am committed to ensuring data integrity, optimizing query performance, and developing scalable solutions that meet the dynamic needs of modern businesses. I stay abreast of the latest SQL Server advancements to deliver high-quality, innovative database solutions that drive organizational success.

Contact Details

Services

“I'm lucky enough to do what I like for work - not everyone's that fortunate.”  — Rafael Nadal

1. Strategy

A strong website strategy lays the foundation for every successful website, ensuring alignment with your core business goals and shielding you from irrelevant distractions. Furthermore, it enables efficient performance tracking, empowering you to monitor progress and make necessary adjustments, thus saving valuable resources. By establishing a clear plan, potential costly errors can be avoided, fostering efficiency and effectiveness in your online endeavors.

2. Branding

A business website often serves as the primary introduction to a company, its products, and services. Consequently, it becomes a vital component of the branding strategy, effectively communicating the business's identity, offerings, and commitments through its content, organization, and appearance.

By employing a cohesive array of visual components like logos, color schemes, fonts, and overall design, we establish a distinctive identity for your website. This distinctiveness fosters a memorable and recognizable brand presence, setting your website apart from competitors.

3. Web Design

A successful web design embodies your company's brand identity and pertinent information, while prioritizing a seamless user experience. Such design proficiency not only enhances user engagement but also drives conversions, whether in the form of leads or sales.

Two primary categories encompass web design: Front-end and Back-end. Front-end design dictates the visual elements and user experience of a website, encompassing aspects like color schemes, typography, imagery, and layout. On the other hand, Back-end design governs the website's functionality, entailing the coding of its infrastructure, including the database and server operations.

4. Social Media

Social networking platforms like LinkedIn, Twitter, and Meta have become integral parts of every company's marketing strategy. With Meta hosting a staggering 2.9 billion active users and a substantial portion of Twitter users engaging with businesses, products, or brands, leveraging these platforms is essential. A well-planned social media campaign not only protects your brand's online visibility but also drives traffic from these networks to your website.

5. Development

We develop using Microsoft.NET

.NET applications are esteemed for their efficiency and expandability, boasting a diverse array of frameworks and libraries suitable for crafting an assortment of applications, such as web, desktop, and mobile applications. With its compatibility across multiple platforms—including Windows, macOS, Linux, and iOS—.NET emerges as a prime candidate for developing cross-platform applications. Moreover, its robust security features fortify applications against potential malicious intrusions.

6. Consulting

If you seek a seasoned, adept, innovative, and trustworthy software development consultant, I urge you to reach out to me. I'm eager to delve into your software development requirements, and I'm confident in my ability to assist you in reaching your objectives.

My Strengths

“Your strengths are your superpower. Use them to your advantage.”  — Steve Maraboli

100%
Problem Solving
100%
Analytical Skills
100%
Coding Skills
100%
Communication Skills
100%
Collaboration Skills
100%
Learning Agility

My Resume

“Your resume is your first impression. Make it count.”  — Steve Tobak

My Education
1974 - 1992

1990 - 1992

College of Mount Saint Joseph - Weekend College

Continuing education classes at the College of Mount Saint Joseph weekend college, Business Administration majoring in Computer Information.

1979 - 1981

Associate of Applied Science Degree - Cincinnati Technical College

In 1981, I earned an Associate of Applied Science degree in Electro-Mechanical Engineering Technology, focusing on drafting, measurement systems, automation and control systems, servo-mechanisms, mini-computers, microprocessors, electronic devices utilized in production, computer programming, fabrication control in manufacturing, industrial hydraulics and pneumatics, and motor controls. My academic achievements include being named to the Dean’s List for three out of five terms.

1974 - 1977

Graduated - Colerain High School

Colerain High School - Cincinnati, Ohio
Graduated 1977.
Pursued academic curriculum.

Work Experience
1979 - Now

2023 - Now

Consulting Business Owner - Machdev.Net

Freelance Software Developer. Develop and deliver software solutions. Ability in a variety of programming languages and technologies. Able to work independently and as part of a team. Excellent problem-solving and debugging skills. Committed to delivering high-quality software on time and within budget.

2022 - 2023

Software Developer - Air Force Security and Cooperation (AFSAC)

Assigned through Stellar Innovations and Solutions. I worked on the Worldwide Warehouse Redistribution Services (WWRS) project. WWRS is a program that accepts material back on behalf of the U.S. government to fill other Foreign Military Sales (FMS) requisitions. Updated the WWRS application using Microsoft.Net, Visual Studio, C#, and MVC.

2021 - 2022

Senior SQL Server Developer - CommuniCare

Worked with clerical management to gather requirements for creating a new web application and update existing web applications using ASP.Net. Used event handling to generate audits and logs for SSIS packages. Processed raw data through the ETL process using SSIS, archiving the data as needed. Developed and maintained ETL processes, enterprise reports, and requirements gathering using SQL Server Reporting Services (SSRS). Created, changed, and perfected Microsoft SQL Server stored procedures, functions, views, and indexes for analysis and reporting. Created queries for reports and datasets based on business needs. Thoroughly documented all new development and existing processes and procedures. Corrected repository structures in Team Foundation Server (TFS). Developed and documented an easy-to-use process to store and update Microsoft SQL Server stored procedures in Team Foundation Server using Visual Studio.

2021 - 2021

SQL Server Developer - Fisher Homes

Assigned to Fisher Homes through CBTS as a Senior SQL Server Developer for a three-month contract. I wrote T-SQL stored procedures and views for the Sapphire-to-Solver conversion project. I also documented existing procedures as needed.

2020 - 2021

Software Developer - Air Force Sustainment Center (AFSC)

Assigned to the RIPIT web development team at the Air Force Sustainment Center through LMI Consulting. Performed requirements analysis and collaborated with internal teams to produce software design and architecture solution that was clean and scalable code using .NET programming languages. I also tested and deployed applications and systems, revised, updated, refactored, and debugged code, improved existing software, developed documentation throughout the software development life cycle, served as an expert supplying technical support for applications, and developed SQL Server applications and scripts. I took the initiative to write Power BI reports for Microsoft DevOps Server, which significantly changed how the Program Manager reported project status to upper management by making the process much more efficient and correct.

2018 - 2020

SQL Server Developer - Kroger Corporation

Assigned through Catapult Solutions Group as a SQL Server Developer and Database Administrator for Kroger Freshness & Standards department. I was responsible for a wide range of tasks, including extracted data from disparate database systems, transformed it into a consistent format, and loaded it into their SQL Server central database, created new and repaired and enhanced existing SSIS packages and SSRS reports, established link server connections to several disparate database systems to allow for the sharing of data between systems, created SQL Agent jobs to automate repetitive database maintenance tasks and run reports. Supplied subject matter expertise (SME) to users on SQL Server and database administration topics. Developed and taught structured T-SQL classes for department personnel allowing them to write their own SQL report queries. Created a library of stored procedures, table valued functions, scalar-valued functions, and update triggers to improve the performance and functionality of my database applications. Wrote procedures to proactively notify business analysts and management in case of changes or failures of SQL Agent jobs to ensure that they were aware of potential as they occurred. Analyzed and added indexes to all pertinent tables across multiple databases to significantly decrease existing query run times. Found and repaired existing database security and authentication issues to ensure databases and database object were secure while allowing authorized access. Created a SQL Server database driven system to track in-store backstock inventory across 2,720 retail grocery stores in thirty-five states and created reports for all stores in all divisions, saving the company an estimated $50MM annually.

2017 - 2018

Senior Software Developer - Fidelity Investments

Assigned to Fidelity Investments through TPA Technologies to support their internal facing 401k Implementation Project Workspace web application, which uses SQL Server and .Net. I implemented changes to the application, converting it from Visual Studio 2013/.Net Framework 4.5 to Visual Studio 2017/.Net Framework 4.5, and SQL Server 2008 R2. I also modernized the application UI using Bootstrap and jQuery and found and corrected hundreds of application errors. Designed and implemented Project Copy and Plan Copy solutions using SQL Server, rather than .Net, as they had previously struggled to do. I supported and performed all phases of development testing leading to implementation and aided in the planning and conducting of user acceptance testing. I developed comprehensive documentation and managed post-installation testing of any problems. I set up a project plan for the Project Copy and Plan Copy project, which was of moderate scope. I worked on complex assignments and often multiple phases of a project and performed independent and complex technical and functional analysis. I also implemented SQL Server Reporting Service (SSRS) reports and SQL Server Integration Service (SSIS) packages.

2016 - 2017

SQL Server Database Administrator - PNC Equipment Finance

Assigned to PNC Equipment Finance through Synergy Consulting Group as a SQL Server Database Administrator for the Oasis development systems. Performed backup, restore, security, permissions, and scripting for these systems. I was also responsible for the support and administration of applications and services used for the production, management, and delivery of content and services online. Created incidents, requests, change requests, and knowledge base documents using ServiceNow. I worked with internal and external users to ensure prompt resolution of issues. I coordinated scheduled system outages to mitigate downtime. I created disaster recovery documentation for application mnemonics. I worked with the ethical hacking team to analyze, develop, and implement remediation solutions to application vulnerability reports. I found faults and issues and recommended proper paths to resolution. Contributed to process development and best practice, looking at new ways to improve resilience, performance levels, and supportability. I supported the development teams in deploying applications and solving problems.

2015 - 2016

Senior Application Developer - GE Risk Management

Assigned as a Splunk API Application Developer for GE Risk Management through CBTS. Designed, changed, developed, assessed, and implemented software programming applications and components. Supported and installed software applications and components. Worked from written specifications and pre-established guidelines to perform the functions of the job and kept documentation of process flow. Used established development tools, guidelines, and conventions, including Visual Studio, ASP.NET, SQL Server, HTML, CSS, JavaScript, C#/VB.Net, and PowerShell scripting. Created and delivered data-driven reports. Designed, coded, and assessed new Windows and web software applications. Enhanced existing systems by analyzing business goals, preparing an action plan, and finding areas for modification and improvement. Supported existing software systems by identifying and correcting software defects. Investigated and developed skills in innovative technologies. Created technical specifications and test plans. Created new and extended existing operational documentation.

2013 - 2015

Senior Application Developer - U.S. Defense Information Systems Agency (DISA)

Developed, changed, and supported complex custom-built web applications using ASP.Net and VB.Net. Developed and integrated IBM Cognos and SQL Server Reporting Services reports into new and existing web applications. I developed and performed unit, system, and user acceptance testing. Developed, documented, and supported a budgeting, execution, and financial reporting project using Visual Studio, VB.Net and a Microsoft SQL Server backend. Collaborated with the customer to satisfy new system requirements. Gathered user requirements and created systems design, providing specifications with time estimates for user interfaces, application enhancements, new functionality, and back-end processes. Supplied production support, trouble ticket resolution, and production break-fix support. Worked with DBAs and other team members to ensure execution of data models according to user requirements. I held a DoD Secret security clearance level and obtained CompTIA Security+ certification.

2010 - 2013

Senior Programmer Analyst - Standard Textile

Maintained and enhanced the AccuQuote online ordering system used by over four hundred sales consultants and customer service representatives. Designed and coded the product sample ordering system for Decorative Products, which allows customers to order product samples online. Interfaced with AS/400 programming staff to ensure correct transmission of ordering data. Used a variety of technologies in these projects, including ASP, ASP.Net, VB.Net, JavaScript, SSRS, Crystal Reports, IIS, SQL Server 2000 and 2008, AJAX, and jQuery.

2010

Senior Programmer Analyst - First Group America

Gathered requirements from the business side of the organization to create specification documents for a new customer relationship management (CRM) system. Determined the needs for a new reporting system based on feedback from internal teams and customers. Supported existing applications by troubleshooting problems and supplying user support. Supplied Tier 3 customer service to both internal and external customers by resolving complex technical issues. Created SQL Server SSRS reports based on various specifications from internal teams and customers. Documented a custom-built system to create technical specifications, end-user documentation and training materials.

2009 - 2010

Business Intelligence Developer - Phillips Edison & Company

Converted the MRI Commercial Real Estate system reports to SQL Server 2005 Reporting Services, which allowed users to view reports in a more user-friendly format. Created new stored procedures to improve the performance of the MRI Commercial Real Estate system. Modified existing stored procedures to correct errors and improve functionality. Created User Defined Functions to simplify the process of accessing data from the MRI Commercial Real Estate system.

2008 - 2009

Senior Developer - DSC Consulting

Modernized the DSC WebWorks web-based service request ticketing system, which improved the performance and functionality of the system. Completely redesigned client website, which supplied a more user-friendly and visually appealing interface. Configured IIS on the customer's Windows SBS 2003 server, which ensured that the website was accessible to users. Integrated with SQL Server 2005, which allowed the website to store and retrieve data more efficiently. Developed a .Net coding standards document, which ensured that all code was consistent and well-organized. Developed internal web application documentation, which supplied clear and concise instructions on how to use the website. Developed Unit Test Procedures, which ensured that the website was functioning properly.

2007 - 2008

Software Project Lead - Pole/Zero Corporation

Coordinated the development of a new .Net application that improved the efficiency of the customer service department. Led a team of developers in the migration of existing reports from SQL Server Reporting Services to IFS reporting. Documented all business processes prior to the implementation of an IFS ERP system, which ensured that the system met the needs of the business. Wrote technical specifications for a new software project, which ensured that the project was well-defined and had clear goals.

2006 - 2007

Application Developer - Great American Financial Resources, Inc.

Wrote the code for the Annuity Claims application, which queries existing annuity policy information from LifePRO databases and adds or edits claim information in an Annuity Claims database. Implemented report functionality in the Annuity Claims application, which allows users to generate reports on claim data. Implemented web services in the Annuity Claims application, which allows users to access the application's functionality over the web.

2005 - 2006

Software Engineer - Robert Half Technology

Contracted to Intellitech Systems. Assigned to Wright-Patterson Air Force Base, Air Force Security Assistance Center (AFSAC). I evaluated the existing mainframe application and gathered requirements for the conversion of the Parts & Repair Ordering System (PROS) invoicing. I had a Secret clearance level. I evaluated the existing mainframe application, which was used to process invoicing for the PROS system. I gathered requirements from stakeholders, which included AFSAC personnel and PROS users. I developed a plan for the conversion of the PROS invoicing system, which included the evaluation of new software and hardware. Contracted to CareSource. Enhanced the web-based Health Screening and Assessment (SAmi) application by adding the ability to handle Indiana applicants. Added several features to the application, including navigation and context-sensitive help, which increased end-user satisfaction. Designed and implemented the Provider Expansion Resource Tool (PERT) to track potential new providers and manage follow-up contact activity with the Provider Relations department. Designed and developed a new Provider Verification System (PVS) to track and report CareSource Medicare healthcare providers. Further enhanced the PVS to handle the Ohio Expansion Request for Application (RFA). This business-critical system was successfully implemented before the project deadline, thus avoiding costly delay penalties. Contracted to Cashland Financial Services. As a BI developer, converted Microsoft Access reports to SQL Server 2005 Reporting Services. Created new reports. Created new and modified existing stored procedures, and User Defined Functions.

2002 - 2005

Consulting Business Owner - Parametric Systems

Owned and operated Parametric Systems, a web development and IT services company. Provided web development, web hosting, DNS services, network consulting, system administration, and IT infrastructure services. Developed websites for clients using IIS, Dreamweaver, Fireworks, Flash, Photoshop, ASP.NET, VB.Net, and Microsoft SQL Server technologies. Specific applications include a public e-commerce website and the back-end admin website. Provided custom modifications to shopping cart software and integration with Amazon.com's Seller Central.

2001 - 2002

Director of Information Systems - Grad Partners, Inc.

Reported to the company's CIO. Responsible for the overall management of an organization's information systems, including setting the strategic direction for the IS department with senior management to develop a strategic plan for the IS department outlining the department's goals and aims, as well as the strategies used to achieve those goals. Oversaw the day-to-day operations of the IS department ensuring that the IS department was running effectively and efficiently. Developed and managed the IS department's budget, ensuring that the department's spending aligned with the department's goals and aims. Oversaw the development and implementation of new IS projects, ensuring projects completion on time and within budget. Managed the IS risks that the organization faced, ensuring that the organization has a plan in place to mitigate the risks associated with our IS systems. Maintained the IS infrastructure by ensuring that the organization's hardware and software were up-to-date, and that the organization's data was secure. Supplied leadership and guidance to the IS department. This included setting the department's culture, ensuring that the department's employees were motivated and engaged.

1999 - 2001

Director of Application Systems & Development - Student Loan Funding Resources

Managed IS&T applications staff and resources to implement solutions to business needs. Ensured that the IS&T team had the skills and experience necessary to meet the organization's needs, as well as providing them with the resources they needed to be successful. Supplied strategic business oversight of the implications, requirements, and opportunities provided by application technology, web development, and information management. This included understanding the organization's business needs. It also included finding new opportunities for IT to improve the organization's operations. Supplied input to annual operating and capital budgets. This included deciding the IT budget needs for the upcoming year and ensuring that the budget aligned with the organization's strategic goals. Oversaw development and implementation of projects related to new applications, systems, web development, and quality assurance. This included ensuring that projects completed on time, within budget, and to the required quality standards. Provided management with correct and prompt status reporting. This included supplying regular updates on the status of projects, as well as any risks or challenges that may be affecting the project.

1998 - 1999

Integration Engineer II - MicroAge

Provided service and support for mid-range and micro systems. Provided consulting services for Sun, Alpha, VAX, and Intel platforms.

1995 - 1998

Technical Analyst - E.W. Scripps

Responsible for system management of Sun, Alpha, VAX, and Intel platforms running Solaris, DEC Unix, OpenVMS, and Windows NT. Upgrade operating systems and layered products. Analyze and implement hardware configuration changes. Troubleshoot and resolve software and hardware problems. Design and implement procedures to transfer payroll and benefits information to various banks and financial institutions. Automate system management functions. Provide backup support to network administrator. Programming technologies used included DCL and COBOL.

1985 - 1995

Systems Specialist - GE Aircraft Engines

Performed system management of mini-computer hardware, software, acquisition inventory, maintenance, and updates of computer systems used for office and engineering user organizations. Integrated mini-computers and PC's. Decisions were made in the areas of implementation, management, and training. Provided system support to users. Provided counsel, advice, and assistance to users in new and existing software applications, and hardware configurations.

1979 - 1985

Technician - Cincinnati Milacron

Responsible for the timely diagnosis and repair of production equipment involved in silicon wafer manufacturing and quality control. Responsible for the timely diagnosis and repair of production equipment involved in machine tool manufacturing. Worked 40 hours a week in ten-week cycles in Co-op capacity while attending college. Graduated from Milacron Modular Training Program. Gained experience in all aspects of machine tool design, operation, implementation, troubleshooting and repair, and programming.

References

“Network continually. 85 percent of all jobs are filled through contacts and personal references.”  — Brian Tracy

Sabel Systems

"Jim is officially the man! His level of professionalism and the understanding of web development is the reason I will be looking forward to working with him in the future."

Douglas Kinyon
Principal

Peerless Technologies

"Jim did an excellent job in just few hours. Great communication and fast execution. Thanks for great work."

Ann Puckett
Project Manager Business Development

Definity Partners

"As always, great creative thinking for the best solution. Jim is by far the most professional and knowledgeable developer I've worked with. I will hire him again."

Todd Dorcheff
Senior Application Developer

Sabel Systems

"We called on Jim to help us deliver on few projects with tight deadlines. He seamlessly integrated into our workflow and quickly became a key part of our team. Great job!"

Kevin Ryan, PMP, PSM I
Project Manager

Sabel Systems

"Jim's technical knowledge and development experience came together and resulted in a site that is not only catching and interesting, but also one that is user-friendly. Thanks again."

Dustin Moses
Software Development Engineer and Entrepreneur

The Kroger Company

"Jim was a welcome addition to our process improvement team at Kroger for FY2018/FY2019. As a data-driven organization we benefited greatly from Jim’s technical skills (SSIS, SSRS, DBA) and his prompt support during normal business hours and evenings/weekends. In a department with limited resources, Jim demonstrated how quickly he could pick up the different facets of our business which for us is almost a necessity. Jim developed great relationships with our business partners which gave us a high degree of confidence that the outputs generated would be high quality and “customer first”. If we have similar needs in the future we wouldn’t hesitate to hire Jim again and whole heartily recommend him as a “go to” guy for enterprise information management needs."

Bill Pitzer
Information Architect

Skills & Expertise

“Skills are what you are capable of doing. Expertise is knowing how to do it in a way that makes a difference. ”  — Peter Drucker

100%

Microsoft Azure

100%

Microsoft SQL Server

100%

T-SQL

100%

SSIS

100%

SSRS

100%

Microsoft.Net

Microsoft Azure Knowledge

“Human behavior flows from three main sources: desire, emotion, and knowledge.”  — Plato

Azure Virtual Machines

100%

Azure App Services

100%

Azure Storage

100%

Azure Networking

100%

Azure Active Directory

100%

Azure DevOps

100%

Certifications

“A certification is a piece of paper that says you've learned something. But it's what you do with what you've learned that counts.”  — Neil Ramiller

CompTIA Security+ 2015

  • As a certified Security+ professional, I have demonstrated mastery in essential cybersecurity principles, including threat identification, risk management, cryptography, access control, and security architecture.
  • With hands-on experience in implementing robust security solutions and mitigating cyber threats, I bring a strategic approach to safeguarding critical assets and maintaining the integrity of IT infrastructure.
  • Employers can trust in my ability to proactively detect and respond to security incidents, ensuring compliance with industry standards and regulations while fostering a culture of security awareness within the organization.

Milestones Achieved

“You need to have goals, create milestones and have a strategy in place to set yourself up for success.”  — Yogi Berra

10

Cups of Coffee

10

Hours Worked

10

Successful Projects

5

Happy Clients

Work Process

“A well-designed website can help you achieve your business goals”  — Neil Patel

Successful development processes are highly collaborative. We collaborate closely with you every step of the way to ensure your website aligns with your needs and aspirations. Our commitment is to deliver a top-tier website that supports your objectives. The timeline varies based on your website's complexity, spanning from a few weeks to several months. Expect thorough communication as we iterate on the design and functionality, ensuring it meets your standards. Transparency is key, and we'll keep you informed of our progress. Our ultimate goal is to provide a website of exceptional quality that exceeds your expectations.

1. Concept
2. Plan
3. Design
4. Develop
5. Test
6. Launch

  • Concept - Commencing the development process necessitates formulating a vision for your project. This vision spans the spectrum from a straightforward personal website to an intricate enterprise solution. Upon establishing this vision, we embark on the journey of brainstorming and outlining your concepts.
  • Plan - When we grasp the essence of your website's vision, we initiate the planning phase. This enables us to conceptualize your ideas effectively and validate their feasibility. We employ diverse tools for this process, such as traditional pen and paper methods, whiteboards, and digital sketching tools.
  • Design - Upon approval of the initial sketches, we proceed to the design stage of your website. Here, you'll have the opportunity to choose the colors, fonts, and overall aesthetic that best represent your vision. Additionally, you'll need to deliberate on the layout and the seamless interaction between different pages of your website.
  • Develop - Upon finalizing the approved design, we embark on the development phase of your website. Here, we translate the design into reality by coding your website and bringing it to life.
  • Test - Following the completion of website development, we undertake a comprehensive testing process to verify its proper functioning. This involves rigorous testing of functionality, design, and layout across various devices and browsers to ensure seamless performance. Our goal is to ensure that your website not only looks appealing but also operates flawlessly across all platforms.
  • Launch - Upon your approval following thorough testing, we proceed to make your website live and accessible to visitors. Whether launching internally, to a specific audience, or to the public, we ensure a seamless transition. Additionally, we offer assistance in promoting your website to enhance traffic and visibility.

Contact Me

Say
Hello

Jim Heath

jd[dot]heath[at]machdev[dotnet]

513.341.5335

Schedule a phone call with me: Calendly - Jim Heath