We provide IT Staff Augmentation Services!

Programmer Analyst Resume

Columbus, OH

PROFESSIONAL SUMMARY:

20+ years of Programming & Database Administration experience. Worked to create databases, tables for applications, granting permissions to the database at varies levels, modifying tables, creating Primary and Foreign Keys, maintaining integrity of the system, including documentation associated with the databases.

TECHNICAL SKILLS:

Skilled in: Informix SQL/4GL, Informix tools, Oracle PL/SQL, schematic tools for Oracle Database, Visual Basic and Configuration Management.

PROFESSIONAL EXPERIENCE:

Programmer Analyst

Confidential, Columbus, OH

Responsibilities:

  • Systems Administration responsible for Password Changes as member of the Enterprise Password Vault (EPV) Team.
  • Maintenance of EPV accounts with changes due to database migrations from Primary to Standby, Safe Accounts, and other issues requiring resolution for automation of passwords.
  • Maintaining user accounts on multiple EPV Vaults based on account type and number of accounts.
  • RSAM, TAMS, DB Portal, First Stop and My - Compute tools used to assist with databases and system analysis to provide information for the resetting of accounts
  • Microsoft Office tools with spreadsheets and word documents
  • Working with Oracle (PL/SQLPlus and TOAD) 10/11/12, Sybase (IBM Informix using TOAD), and MSSQL (2012) using scripts to check user accounts and databases
  • ITSM’s for Change Management assisted with user accounts passwords and unlocking accounts as need to complete the CM

Confidential, Toledo, OH

Database Administrator

Responsibilities:

  • Maintained the Informix Database system for Inventory/Sales, developed database documentation and system procedures for daily operations to maintain systems in all locations
  • Reversed Engineered the Data Dictionary based on contractor application open source code and Informix Database Tools to view the Metadata using Microsoft Office
  • Worked on PC Server from Toledo to Fort Wayne and Indianapolis, Indiana assisting with server (ISQL) and Database troubleshooting with local administrator on location.
  • Developed a management report using Crystal Reports for CEO to provide information residing in the Database Application.

Confidential, Novi, MI

Programmer Analyst and Consultant

Responsibilities:

  • Maintained and developed for various Informix Software Systems and Databases using Fourgen Application, for end-users various business operations.
  • Worked on the Motorola account to test for Y2K to assure all programs had been modified to handle the 2000 year field verifying that all programs were functional, noting all problems that occurred.
  • Database management support for varies customers using Informix Database SQL and bcheck tools in an UNIX environment

Confidential, Washington, DC

Programmer/Database Administrator/Configuration Manager

Responsibilities:

  • Develop and maintained various Informix Software Systems as programmer & database administrator of the existing systems and Inventory Hardware system. Creating screens, reports and scripts with ISQL and 4GL.
  • Worked on Oracle Database team- assisted with daily operations: creating & alternating table specifications, granting and revoking privileges, assisted with data for ETL process utilizing PL/SQL scripts
  • Developed and Maintained Database Schematic utilizing Oracle tools of the Enterprise Application that consist of over 300 tables with primary and foreign keys, identifying the 1:1, 1:M, and M:N relationships.
  • Managed the Technical Support Branch for Configuration Management Control for development and maintenance of systems, assisting in documentation for the user manual, data documentation, and systems documentation with Microsoft Office
  • Systems Administration duties for a couple of years in a UNIX environments on a Zilog, HP and Altos mini computers, setting up accounts and providing permissions to the Informix Database.

Confidential, Columbus, OH

Programmer/Analyst

Responsibilities:

  • Maintained and developed COBOL programs for the Data Division on the Team for Division of Water and Sewer System

Confidential, Columbus, OH

Programmer/Analyst/Manager

Responsibilities:

  • Installed, modified and trained users on Open Systems application in Visual Basic utilizing Informix Database platform, traveling to the user locations in Central Ohio
  • Setting up the accounts for the user granting permissions to the database in a UNIX environment
  • Modified a payroll system for Worthington Industries on a single payroll system
  • Worked on Altos Unix based systems, setting up the system, installing the operating system, loading the application for delivery, and then taking the system to the location and setting the system up for user utilization.
  • Worked with ISQL scripts to repair, tune and maintain databases for users as needed
  • Technical Manager for Programming Technical Staff of three programmers

Confidential, Columbus, OH

Programmer/Analyst

Responsibilities:

  • Installed, modified and trained users on Open Systems application in Visual Basic utilizing Informix Database platform, traveling to the user locations in Central Ohio
  • Worked with ISQL scripts to repair, tune and maintain databases for users as needed
  • Setting up the accounts for the user granting permissions to the database in a UNIX environment
  • Worked on Altos Unix based systems, setting up the system, installing the operating system, loading the application for delivery, and then taking the system to the location and setting the system up for user utilization.

Hire Now