M. L. (Mary Lou) Haynes
Chicago, IL 60643 * 773-233-9397 * [email protected] * www.apexcybersystems.com
ADDENDUM
SOFTWARE / HARDWARE TECHNOLOGIES
OPERATING SYSTEM ENVIRONMENTS
· CLIENT / SERVER - MS Windows 2003, 2000, 3.1, 95, 98, AD, NT, XP Professional.
· UNIX - IBM AIX, HP-UX, NIS, Sun Solaris
· MID-RANGE - AS/400 - 0S/400. IBM OS/2, VMS, VM/CMS
· MAINFRAME - IBM OS/390, IBM z/OS, IBM MVS, IBM XA
INFORMATION SECURITY
· Client / Server - Windows 2003 Active Directory, Enterprise Administrator, Policy
Director / Tivoli Access Manager, Arcot Digital Certificate / Tokens, MS Access
· Enterprise & Mainframe - CA-Top Secret Security, CA-acf2 Security software, CA-ETFA, BMC Control-SA
ESS Console, DB2/ProSecure (DBSecure), IMS Delta Virtual Terminal, AS/400
RDBMS & MDBMS & DATABASES
· Database Administration - Data Modeling, Acquisition, Microsoft Access, Analysis,
ETL (Extract Transform Load), ODS (Operational Data Store)
· Databases / Data Marts / DWH - SAS, Oracle, IBM z/OS DB2, IMS DB, FOCUS. Dimension tables, Fact tables.
Metadata, Data Dictionary, Schemas - Star, Snowflake, RDBMS, ROLAP
· Data Modeling / Mapping - MS Visio, Visio CAD, ERD (Entity Relationship Diagrams),
LDM (Logical Data Modeling), PDM (Physical Data Modeling)
ENVIRONMENTS
· Architectures - SAA, Large Systems Architecture, PL/1 Arrays, Structures of Arrays,
Arrays of Structures (similar to MDBMS OLAP Cubes)
· Automations - XML, Data Warehouse ETL (Extract Transform Load), Performance Tuning,
QA, Audits, Triggers, Scripts, Data Marts
· Change Mgt & Communications - Panvalet, Librarian. IMS DC, VSAM, CICS
· Messaging - MS Exchange & Outlook, Mail, Schedule+, SMTP, Uuencode, MIME, Lotus Notes
· Networking & Protocols - TCP/IP, Telnet, Exceed, FTP, ISDN, Reflections, Shiva, WAN/LAN, Bitvise SFTP
· Project Mgt / Methodologies - Microsoft Project, SDLC, JAD, Warnier
· Mainframe report viewers - ERD (Enterprise Report Distribution), Flasher, SAR, RMDS, SDSF, View Direct
· Suites - Microsoft Office - Access, Excel, Outlook, Word, PowerPoint
· Service Management (like Remedy) - Best Practical Solutions’ RT (Request Tracker), BMC Service Desk Express (i.e. Magic)
· Systems Programming & Admin - CRON, Trace, Omegamon, NetView, SNA, SuperSession, IPL
· UNIX / Shells - Korn, Bourne. vi Editor
· Utilities - Visio, AbendAid, Adobe Acrobat PDF, AION (Artificial Intelligence), ASIM,
Capture EZ 97, File-Aid, Delta IMS Virtual Terminal, JES2/JES3, IBM Utilities, SyncSort, TSO, ISPF, Waapdsut
PROGRAMMING LANGUAGES
· Languages (Scripting, Web Services) - XML, SQL, PL/SQL, SQL+/QMF, HTML, JavaScript, VBScript, ASP, Shell - sh, ksh,
Perl, awk, grep, sed, VBA, VMS, CList, REXX, LDAP ds tools
· Languages (Programming) - SAS/Macros, SCL, JCL, PL/1, FOCUS, BAL, CA-Easytrieve, DL/1
Network Protocols used:
ISDN (Integrated Services Digital Network), Token Ring, TCP (Transmission Control Protocol), DNS (Domain Name Service),
FTP (File Transfer Protocol), LDAP (Lightweight Directory Access Protocol), MIME (Multipurpose Internet Mail Extensions),
SSH (Secure Shell), SMTP (Simple Mail Transfer Protocol), Telnet, IBM SNA (Systems Network Architecture)
Vendor Software Products Used
Microsoft products used:
Windows 2003, 2000, 3.1, 95, 98, Active Directory, NT, Vista, XP Professional.
Outlook, Visio, Access, Digital Image Editor, Excel, Exchange, Front Page (now Expression Web), Image Composer,
Office Suite - Word, Excel, Power Point - Project, Publisher, System Manager, VBA, VBScript, ASP (Active Server Pages)
SAS Institute - Statistical Analysis System products used:
· SAS Modules & Reporting - Base, AF, FSP, Access, Connect, SCL, Macros, Stat, DMS. Data Null Data Step.
Procs - Report, Plot, Printto
· SAS Scoring & Stats Procs - Compare, Rank, Score. Means, Summary, Freq, Tabulate, Univariate
· SAS Utility Procs - Append, Catalog, Compare, Download, Datasets, Format,
PDSCopy, PMenu, SQL, Transpose
Additional: Arrays, By-group processing - combining data sets. Conversions - character to numeric.
System & Data Set options, Do-loops, Dropping, Functions, Informats,
Labeling variables, Macros. Date / time processing, Renaming variables, Selecting strings.
IBM (International Business Machines) products used:
Utilities - IEBGENER, IEHLIST, IEBUPDTE, and more.
AIX AS/400 Security, BAL/Assembler, CICS, COBOL, DL/1, CList (Commands List),
DB2, ISPF, JCL (Job Control Language), Mainframe, MVS, OS/2, OS/90,
Policy Director / Tivoli Access Manager, PL/1, QMF, REXX, SPUFI,
TSO, z/OS, IMS - DB, DC, DIF, DOF, MID, MOD.
BMC products used:
BMC Service Desk Express (i.e. Magic), BMC Control-SA ESS (Enterprise Security Station) Console
Computer Associates products used:
ACF2 Security, CleverPath Aion Business Rules Expert (formerly AION), CA-EARL, CA-TSS (Top Secret)
Oracle products used:
PL/SQL, SQL*Plus
Various Third-Party Vendor products used:
Action Works Metro WORKFLOW,
Arcot Digital Security Tokens,
awk, grep, sed
Best Practical Solutions’ RT (Request Tracker),
Bitvise SFTP, Bitvise Tunnelier ,
DYL-280 (now Advantage VISION:Results),
Pansophic Systems Easytrieve,
Enterprise Administrator,
ETL (Extract Transform Load), Fact tables,
Information Builders FOCUS,
Compuware File-Aid,
HTML,
Sun JavaScript,
LDAP DS Tools,
LOTUS Notes,
ODS (Online Data Store),
Message Manager,
Perl,
Shiva,
Schemas - Snowflake and Star,
SQL,
UNIX,
Unix Shell Scripting - sh, ksh,
SyncSort,
Uuencode,
Visio CAD,
VMS, VMS Scripts,
EDS Waapdsut,
XML