Information Technology Architect
Resume:
PROFESSIONAL SUMMARY
Accomplished track record of working with leadership and business teams to develop strategic procedures and drive change management. More than 15 years of business, process and technology experience, spanning several industries including: Manufacturing, Distribution, Retail (POS), Telecommunication, Healthcare and Business Finance.
PROFESSIONAL EXPERIENCE
Specialties
Management Systems - IBM Rational Portfolio Manager (RPM), Microsoft Project/Server 2000-2003, HP Quality Center, SDLC, Functional specification documents(FSD), Business Requirement Document (BRD), SOX, JSOX
Languages - RPG IV, RPG free, RPG III, CL, CLLE, DDS (sub files), SEQUEL, SQL, embedded SQL(RPG/COBOL), COBOL, Web Facing/Web Sphere, FTP, HTML, XML, SEU, SDA, IBM Rational
Software – BPCS 5.0, BPCS V61.02, MAPICS DB & XA, ALDON, EDI, DB2
IT PROGRAMMER / ANALYST (REMOTE) ANDERSEN WINDOWS, DES MOINES, IA Feb 2024 – Jun 2024
Storm door manufacture (EMCO) using BPCS .
Languages Used: RPG III, RPG IV, RPG free, CL, CLLE, DDS, SQL
Revised/Tested / implemented RPGLE for Price checking for Def Leopard project for batch and interactive programs
Designed / Developed / Tested/ Implemented RPGLE to select and print picking list for sub assemblies
Developed Bill of Material work file build to download into spreadsheet and then email to user
IT PROGRAMMER / ANALYST (REMOTE) ANDERSEN WINDOWS, DES MOINES, IA Jun 2023 – Sep 2023
Storm door manufacture (EMCO) using BPCS .
Languages Used: RPG III, RPG IV, RPG free, CL, CLLE, DDS, SQL
Designed / Developed / Tested / implemented RPGLE for Price checking for Def Leopard project for batch and interactive programs
Designed / Developed / Tested/ Implemented RPG free Sub file to update Def Leopard Prices file(table) by style and diminutions
Revised Programs to use larger diminutions from 5(3) to 6(3) and test.
Created SQL scripts to build test data for interactive and batch processes
IT PROGRAMMER / BUSINESS ANALYST SELF EMPLOYED, ROCK HILL, SC Jul 2018 – Dec 2022
Self employed consultant to Manufacturing industry.
Languages Used: RPG III, RPG IV, RPG free, CL, CLLE, DDS, SQL online and embedded in RPG IV/RPG free, DDL
Designed / Developed / Tested / implemented SQLRPGLE for Sales Support combining Local and remote BPCS data bases
Designed / Developed / Tested processes to allow Customer Service staff to select Invoices to email to Clients from BPCS spool files
Analyzed problems with BPCS V61.02 software. Documented solution using BRD within JSOX standards.
Created utility to convert Physical file to SQL DDL format for BPCS and BPCS work files
IT DATABASE ANALYST COMMISSION FOR HIGHER EDUCATION, COLUMBIA, SC May 2018 – Jul 2018
South Carolina Commission for Higher Education keeps up with College students GPA/Facilities/scholarships within the State.
Languages Used: RPG III, RPG IV, RPG free, CL, CLLE, DDS, SQL online and embedded in RPG IV/RPG free, DDL
Created Data Dictionary for Reporting
Reviewed Software Standards for Current programs
Researched GUI software and servers for new software development.
Created Cross reference between Files and programs and function(input/output/update/etc.) used in each program
IT PROGRAMMER / BUSINESS ANALYST SELF EMPLOYED, ROCK HILL, SC Mar 2014 – Jun 2018
Self employed consultant to Manufacturing industry.
Languages Used: RPG III, RPG IV, RPG free, CL, CLLE, DDS, SQL online and embedded in RPG IV/RPG free, DDL
Designed / Developed / Tested / implemented SQLRPGLE for Sales Analysis BPCS 6.0 databases for Local and remote sites
Supported Remote locations with New and revised Reports for Inventory and Billing using BPCS 6.0 databases for fiscal year
Supported Operations staff when absent or on vacation
Analyzed problems with BPCS V61.02 software. Documented solution using BRD within JSOX standards.
IT Programmer / Business Analyst IBM, GREENVILLE, SC Dec 2013 – Feb 2014
Billing Services for Healthcare industries.
Languages Used: RPG III, RPG IV, RPG free, CL, COBOL, DDS, SQL online & embedded in RPG IV/RPG free
Developed / tested / implemented SQLRPGLE and COBOL programs to create Electronic Funds Transfers (payments) using NACH format to specified bank (using FTP from AS/400 to Federal Reserve Main frames)
Modified Reports and database file to handle Diagnosis Code size increase.
Create database files from EDI flat files to be transferred to Clients for processing.
oUsed SQL to correct data leading zeros removed with nulls following and Nulls instead of spaces
IT Programmer Analyst Manheim thru Collabera, Atlanta, GA Mar2013 – Sep 2013
Manheim is a wholesale vehicle auction operation.
Languages Used: RPG III, RPG IV, RPG free, CL, COBOL, DDS, SQL online & embedded in RPG IV/RPG free
Developed / tested / implemented into production SQL scripts to merging purchased division dealers with current software package.
Creates Databases for conversion from oracle to DB2.
Setup scheduled jobs to run SQL scripts on AS/400(iSeries).
Revise GL software to allow purchased division (Account codes) to be used in Seller side transactions on.
IT Programmer Analyst / Software support Atlas Copco thru Ajilon, Rock Hill, SC Oct 2011 – Jan 2013
Atlas Copco is a world leading provider of industrial productivity solutions.
Languages Used: RPG III, RPG IV, RPG free, CL, CLLE, DDS, SQL online & embedded in RPG IV/RPG free
Revise/design/convert Data Bases using SQL and utility (Queries) software.
Assist users with Authority / Data / software / hardware issues on BPCS 6.0.
Combined and Setup new Company with users from multiple company access for BPCS 6.0
Security officer on AS/400 (creating User Profiles) for local and remote sites(Multiple AS/400) for BPCS 6.0 users
Develop Plans for conversion of Hardware and Software to new naming convention
Work with Managers/Systems Analyst to Develop/test/install software for Distribution Center using RPG with embedded SQL.
QA Tester Wells Fargo thru Apex, Charlotte, NC Aug 2011 – Oct 2013
Wells Fargo is world leading financial (banking) institution.
Languages Used:, SQL online & scripted
Develop Plans for conversion of Hardware and Software to new naming convention
Document eWFM (Work Force Management) data base information flow. Create test plan and test SQL scripts for stream lining data base flow for Scheduling & Capacity Planning module of ECCOS system.
IT Consultant BCBS thru Ciber, Capel Hill, NC Apr 2010 – Sep 2010
Blue Cross Blue Shield of North Carolina is the foremost health care system.
Languages Used: RPG III, RPG IV, RPG free, CL, CLLE, COBOL, DDS, SQL online & embedded in RPG IV/RPG free
Programmed and Tested enhancements to heath care industry software using COBOL embedded SQL.
Tested XML from Mainframe DB2 to iSeries DB2. Updating DB2 files on iSeries using interactive .net programs and XML back to Mainframe. These Programs was Object oriented with service programs.
EDI files from network server to iSeries to process
IT Programmer/Project Management CTA, Rock Hill, SC Oct 2008 – Feb 2010
Carolina Technology Associates provides software and IT processing for telecommunications industry
Languages Used: RPG III, RPG IV, RPG free, CL, COBOL, DDS, SQL online & embedded in RPG IV/RPG free
Enhanced and supported AR, GL, AP, Purchasing, Inventory, Labor Reporting, and Payroll Package software for communications industry
On call support for nightly Processes
Setup overlays for Signatures on Accounts Payable and Payroll Checks
Developed and supported Electronic filing for W2’s and 1099’s
Corrected EDI transfer of cable TV programming for remote sites.
IT Programmer/Project Management CDS, Rock Hill, SC Sept 1998 – Oct 2008
Comporium Data Services provides software and IT processing for telecommunications industry
Languages Used: RPG III, RPG IV, RPG free, CL, COBOL, DDS, SQL online & embedded in RPG IV/RPG free
Interface Client Payroll Software with ACH transactions for Direct Deposit for Multiple Companies on single transmission.
Fringe Wages detail per pay cycle to apply to YE W2's
YE processing of W2's including balancing YTD Summary information with Detail transactions.
Enhanced and supported AR, GL, AP, Purchasing, Inventory, Labor Reporting, and Payroll Package software
Project Manager/Programmer Meineke, Charlotte, NC Nov 1997 – Aug 1998
Meineke is an automotive service business
Languages Used: RPG III, RPG IV, RPG free, CL, DDS, SQL online & embedded in RPG IV/RPG free
Produced an interactive or batch form Letter Writing System. The LWS includes Signatures, security (letters available per User); this system is used in the problem resolution for Meineke.
Created invoicing and payment entry for Rents Receivable and Notes Receivable. Notes and Rents interfaced with JBA General Ledger software.
Designed interface for Legacy software with JBA software.
EDUCATION/TRAINING
York Technical College, Winthrop University
Contact this candidate