Post job
zippia ai icon

Automatically apply for jobs with Zippia

Upload your resume to get started.

Programmer analyst-consultant skills for your resume and career

Updated January 8, 2025
5 min read
Quoted expert
James Sellmann Ph.D.
Below we've compiled a list of the most critical programmer analyst-consultant skills. We ranked the top skills for programmer analyst-consultants based on the percentage of resumes they appeared on. For example, 9.0% of programmer analyst-consultant resumes contained sql server as a skill. Continue reading to find out what skills a programmer analyst-consultant needs to be successful in the workplace.

15 programmer analyst-consultant skills for your resume and career

1. SQL Server

Here's how programmer analyst-consultants use sql server:
  • Identified system bottlenecks, optimized SQL queries and rewrote transactions to reduce lock contention and improve SQL server concurrence.
  • Utilized ASP's and SQL Server for task inventory tracking, administration, data collection and reporting system.

2. C Net

Here's how programmer analyst-consultants use c net:
  • Added/Removed user accounts and basic network administration.
  • Implemented the Electronic Network Administration System.

3. Oracle Sql

Here's how programmer analyst-consultants use oracle sql:
  • Corrected data utilizing batch change loads, Oracle SQL Loader, Unix scripting, Unix shells, and AutoTester programs.
  • Performed work order specific live database modifications using Oracle SQL Developer.

4. Data Warehouse

Data warehouse, often abbreviated as either DW or DWH is a system used in computing for data analysis as well reporting. The DW is also considered to be an integral component of business intelligence as they also provide storage facilities for both real-time and historical data. ETL and ELT are the two driving forces behind a data warehouse system.

Here's how programmer analyst-consultants use data warehouse:
  • Provided Oracle database administrative support to various business entities, including Data Warehouses and Human Resources.
  • Designed and developed an automated data warehouse integrating legacy system with SQL 2000.

5. Cobol II

Here's how programmer analyst-consultants use cobol ii:
  • Maintained COBOL II/DB2 sub-system, which captured detail on a quarterly basis and reported quarterly claims volume in multiple statistical variations.
  • Collaborated with in-house analysts to prepare program specifications, developed appropriate code to accomplish the tasks using COBOL II and DB2.

6. CICS

Here's how programmer analyst-consultants use cics:
  • Prepared test cases and tested two subsystems of an Automated Clearing House system operated on IMS DB, and CICS environment.
  • Provided coding modifications of IBM mainframe COBOL programs, JCL, CICS transactions, DB2 tables and created QMF reports.

Choose from 10+ customizable programmer analyst-consultant resume templates

Build a professional programmer analyst-consultant resume in minutes. Our AI resume writing assistant will guide you through every step of the process, and you can choose from 10+ resume templates to create your programmer analyst-consultant resume.

7. Java

Java is a widely-known programming language that was invented in 1995 and is owned by Oracle. It is a server-side language that was created to let app developers "write once, run anywhere". It is easy and simple to learn and use and is powerful, fast, and secure. This object-oriented programming language lets the code be reused that automatically lowers the development cost. Java is specially used for android apps, web and application servers, games, database connections, etc. This programming language is closely related to C++ making it easier for the users to switch between the two.

Here's how programmer analyst-consultants use java:
  • Designed, implemented and tested a Java server that will provide an encrypted middle-tier for a web based Project Management solution.
  • Investigated migrating to IBM WebSphere using Enterprise Java Beans for server, and migrating Java applets to JavaServer Pages.

8. Mainframe

A mainframe is a high-performance digital computer used by large organizations for mission-critical applications, high transaction volumes, and reliable performance, designed for intensive high-speed computing for large-scale computing purposes that require greater availability and security which a smaller machine cannot offer.

Here's how programmer analyst-consultants use mainframe:
  • Designed and coded front end mainframe COBOL/DB2 programs to prepare data for the DOC1 statementing and messaging software.
  • Convert Wang mainframe applications to new A-Series mainframe COBOL applications in online, real time and batch environments.

9. Procs

Here's how programmer analyst-consultants use procs:
  • Manage and participate in over 300 JCL and PROCS to suit the current system documentation updates.
  • Monitored and performed maintenance on production jobs, COBOL programs, and JCL PROCS.

10. C++

C++ is a general-purpose programming language that is used to create high-performing applications. It was invented as an extension to the C language. C++ lets the programmer have a high level of domination over memory and system resources. C++ is an object-oriented language that helps you implement real-time issues based on different data functions

Here's how programmer analyst-consultants use c++:
  • Designed and developed C++ classes for business and data processes.
  • Converted Fortran building geometry generator program to C++ to improve integration with existing design system.

11. XML

XML is a medium for storing and transporting data that is independent of software and hardware. XML stands for eXtensible Markup Language. XML, like HTML, is a markup language that was created to store and transport data. It was created with the intention of being self-descriptive. There are no predefined tags in the XML language. Another feature is that XML is extensible.

Here's how programmer analyst-consultants use xml:
  • Developed dynamic listing of content in tree view fashion where required using XML and XSLT transformation.
  • Develop new maps/systems in WTX and Message Broker, flat file, and custom XML.

12. VSAM

Here's how programmer analyst-consultants use vsam:
  • Coded several conversion programs that utilized SQL and VSAM which aided in the encryption of credit card numbers.
  • Access DB2, IMS databases, and VSAM files to extract the required data using COBOL programming.

13. Unix

UNIX is a computer operating system that was first created in the 1960s and has been constantly updated since then. The operating system refers to the set of programs that enable a machine to function. It is a multi-user, multi-tasking device that works on computers, laptops, and servers. UNIX systems also have a graphical user interface (GUI), similar to Microsoft Windows, that makes it simple to use.

Here's how programmer analyst-consultants use unix:
  • Designed multiple triggers, stored procedures, functions, packages, views, UNIX shell scripts and other reusable architecture components.
  • Replaced JCL jobs with UNIX shell scripts for programs to run in the new UNIX/LINUX batch environment after conversion.

14. Xpediter

Here's how programmer analyst-consultants use xpediter:
  • Used Xpediter to debug unit test issues and used FileAid to confirm test results.
  • Performed debugging modified on-line programs using GUI/XI debugging tolls for XML and Xpediter.

15. Management System

A management system is a set of policies, processes, and procedures taken by an organization or a business to ensure it can fulfill its tasks and achieve its objectives. A management system makes sure that the company excels financially and improves the user experience. The management system also takes care of the worker's and employees' needs and manages their workload and oversees their performance. Apart from interior matters of the company, a management system also deals with exterior matters like legislations, tax matters, and law issues.

Here's how programmer analyst-consultants use management system:
  • Enhanced and developed their existing application for Warehouse Management System, ABS Forecasting production planning and Inventory Location.
  • Defined, designed, developed and implemented a Document Management System.
top-skills

What skills help Programmer Analyst-Consultants find jobs?

Tell us what job you are looking for, we’ll show you what skills employers want.

What programmer analyst-consultant skills would you recommend for someone trying to advance their career?

James Sellmann Ph.D.

Dean, Professor of Philosophy and Micronesian Studies, University of Guam

General advice is to keep in mind that you must leverage your skills, especially your soft skills of being able to work with people, to communicate effectively and to be able to solve problems. Be real. Don't try to pretend to be someone else to impress others. Be your authentic self. And show up on time.

List of programmer analyst-consultant skills to add to your resume

Programmer analyst-consultant skills

The most important skills for a programmer analyst-consultant resume and required skills for a programmer analyst-consultant to have include:

  • SQL Server
  • C Net
  • Oracle Sql
  • Data Warehouse
  • Cobol II
  • CICS
  • Java
  • Mainframe
  • Procs
  • C++
  • XML
  • VSAM
  • Unix
  • Xpediter
  • Management System
  • Windows NT
  • RPG IV
  • Payroll
  • SAS
  • JavaScript
  • HTML
  • Tivoli
  • ASP
  • PC
  • Endevor
  • TSO
  • ISPF
  • CL
  • QA
  • PL/SQL
  • System Design
  • AS/400
  • Visio
  • CSS
  • HR
  • MQ
  • SPUFI
  • File-Aid
  • IMS Db/Dc
  • Billing System
  • Ims Db
  • Test Data
  • Test Cases
  • Technical Specifications
  • GUI
  • Legacy Systems

Updated January 8, 2025

Zippia Research Team
Zippia Team

Editorial Staff

The Zippia Research Team has spent countless hours reviewing resumes, job postings, and government data to determine what goes into getting a job in each phase of life. Professional writers and data scientists comprise the Zippia Research Team.

Browse computer and mathematical jobs