Jim Helm

Software Engineering Manager

Cognizant•  October 2021 - Present

Client site: TriZetto Provider Solutions (TPS) (Nov 2021 – July 2023) • Lead and supervise the development team in a pod setting • Interview potential technical candidates • Work with management team on project architectural designs and implementation • Refine work that will be going to the developers • Worked on implementing Azure AD B2C custom policies for authentication • Worked on API development with Microsoft .Net • Worked on front end web development using Angular Client site: FIS (Oct 2021 – Nov 2021) • Lead and supervise the development team in a pod setting • Work with management team on project architectural designs and implementation • Onboarding for authentication system (teams placed on hold moved to new project)

Sr. Data Analyst and Tech Lead

Cognizant•  July 2021 - September 2021

Client site: TriZetto Provider Solutions (TPS) (July 2021 – Sept 2021) • Discovery project TPS to modernize current application • Define software and hardware architecture for discovery application • Analyzed the data process to locate data slowness areas • Analyzed modernization project to suggest new implementing technology.

Sr. Software Engineer

Cognizant•  February 2021 - July 2021

Client Site: NCR (Feb 2021 – July 2021) • Senior .Net developer for MobilePay team • Worked on getting the MobilePay application to pass security scans • .Net programming fixing and Integrating MobilePay application

Sr. Database Administrator

Cognizant•  July 2019 - February 2021

Client Site: Installations Made Easy (July 2019 – Feb 2021) • Manage multiple Microsoft SQL Servers (2019) in an Enterprise environment, Reporting Services, and Integration Services. • Upgrade Microsoft SQL Server 2008 R2 to Microsoft SQL Server 2019 • Design and manage SQL entity relationship diagrams (ERD). • Implement procedures to ensure database tuning, capacity and future capacity planning. • Assist programmers in developing/coding SQL for a front-end client application connected to Microsoft SQL Server databases. • Identify ways to improve data reliability, efficiency and quality. • Develop and maintain SSRS reports used by the business for both internal and public access. • Develop and maintain SSIS projects for data movement and manipulation.

Sr. Data Engineer and Tech Lead

GF Health Products, Inc.•  December 2018 - July 2019

• Lead and supervise the development team in designing software applications that follow the full software development cycle. • Ensure all new software functions smoothly across various programs and platforms. • Ensure software validation and/or verification testing has been completed as per business requirements and FDA regulations. • Develop, construct, test and maintain all data architectures aligning the architecture with business requirements and data privacy regulations. • Develop data set processes. • Identify ways to improve data reliability, efficiency and quality. • Deploy sophisticated analytics programs, machine learning and statistical methods using Python. • Use Apache Spark to pull in data from multiple sources including SQL Server for analysis and sales prediction. • Store Analytical data in Azure Data Lake Storage. • Use data to discover tasks that can be automated. • Evaluate and implements new and major enhancements of critical business applications. • Build out BI solution and create Analytics reports. • Create analytical dashboard reports in Power BI. • Create and maintain ETL solutions for data warehouse. • Deliver updates to the Company Executives based on analytics.

Sr. SQL Database Administrator – Tech Lead

GF Health Products, Inc.•  May 2008 - December 2018

• Managed multiple Microsoft SQL Servers (2008, 2012, 2014, 2016, 2017) in an Enterprise environment, including Analysis Services, Reporting Services, and Integration Services. • Build out BI solution and create Analytics reports using PerformancePoint and Power BI. • Create ETL solutions for data warehouse. • Manage servers in Microsoft Azure Cloud. • Design and manage SQL entity relationship diagrams (ERD). • Lead and supervise the development team in designing software applications that follow the full software development cycle. • Support programmers in developing/coding a front-end client application connected to Microsoft SQL Server databases. • Developed E-commerce website using the ASP .NET framework. Programming languages used were VB .NET and C#. • User Interface development using HTML, CSS, and javascript

SQL Database Administrator

GF Health Products, Inc.•  March 2003 - May 2008

• Provides support for production, development, and test enterprise database systems using Microsoft SQL Server (2000, 2005, 2008) and Oracle (9i, 10g). • Database administration and security of all databases. • Implement procedures to ensure database tuning, capacity and future capacity planning • Develop and implement procedures for regular database backup; inclusive of method and backup frequency. • Recommend improvements and optimize database systems

AS400 Coordinator

GF Health Products, Inc.•  May 2000 - March 2003

• Managed Business Planning and Control System (BPCS) on IBM AS/400 • Programmed support applications for the AS/400 in RPG

Network/Desktop Administrator

GF Health Products, Inc.•  November 1998 - May 2000

• Managed Novell network and servers. • Managed Groupwise email server. • Provided network and computer technical support.

Database Applications Programmer

Facility Management Services•  February 1996 - November 1998

• Developed task/time management application in Delphi programming in Object Pascal, C-Builder, and J-Builder with an Interbase SQL backend. • Assisted lead Paradox database programmer in developing a purchase order/requisition database application.