Systems Administrator Resume Profile
Dearborn, M
Professional Summary
While I have experience in the software development arena my greatest value-added skills are in the areas of business analysis. I have long experience in gathering user requirements, creating high-level systems documentation, low-level program and systems specifications, creation of detailed test scripts, quality assurance evaluations and performance measurements. My experience includes application of formal methodologies e.g., STRATUS by McDonnell-Douglas and more generalized methodologies such as Agile Development, JAD, RAD, SCRUM, Orr-Warnier, Yourdan-Constantine and others. Testing and quality assurance tasks have been performed using both manual test scripts and evaluation techniques and, more recently, automated testing and quality control products of vendors Computer Associates and Compuware in this expanding market.
- COBOL, PL/1, IBM Assembler BAL
- MVS JCL, VSE JCL, Unix, Windows, Linux
- IMS DC/DC, DB2, VSAM, Oracle
- CICS
- EDI, FTP, NDM
- Syncsort, Easytrieve, FileAid
Professional Experience
System Administrator
Confidential
- Production support of the MOMS Mechanization of Master System used by the parts warehouses of Ford's Customer Service Division which supplies dealers with aftermarket genuine Ford parts. It is a standard warehouse application with features for receiving and storing inventory, applying standard costs to that inventory, processing shipments to customers and other warehouses, doing cycle and wall-to-wall inventories, processing customer returns and other normal warehouse functions.
Environment: z/OS, z/VSE, JCL, TSO/ISPF, ICCF, JCL, QSAM, VSAM, DB2, DATACOM, CICS, MQSeries, Websphere MQ, COBOL, Syncsort, Intertest, CA7, Mobius, FAQS, File Aid, Abend Aid, Expediter, Remedy, Rational Rose, ClearView, ClearCase, Microsoft Project, Access, Powerpoint, Excel, Visio and Word.
Confidential
- This assignment was a disappointment as I was unable to convince the project management of the true role of quality assurance beyond the iterative unit testing QA had been assigned. In an agile environment, QA should take on a much greater role, be proactive, build end-to-end automated testing capabillities that can be executed with each build. But, I was not successful in marketing these concepts so, thankfully, my participation was concluded and I moved to.
Environment: Quality Center 10.0 and 11.0, Remedy, Clear Case, JUnit, AccuRev, AutoSys, Java framework with SQL database tables.Detector, Rational Rose, ClearView, ClearCase, Anthill, Selenium, Microsoft Project, Access, Powerpoint, Excel, Visio and Word.
Confidential
- Performed maintenance and enhancement to address performance issues on initial database load for upgrade to version 12.5 of Practice Plus Solutions software achieving 40 reduction in runtime requirement.
- Created technical specifications for changes to accounting practices linking unapplied payments to specific charges and modifications required to support ICD-10 diagnosis code changes mandated for 10/2012 implementation.
Environment: COBOL, Oracle, Tuxedo and Unix operating system. UltraEdit and UltraCompare were primary tools along with Putty and a few ISAM files.
Confidential
- Stress testing of data feeds and processes involved in distribution center warehouse activities using mainframe-based data sources and file transfers to Unix-based application servers running Manhattan Associates supply chain warehouse management and logistics management systems.
- The project is a prelude to the business season in retail in which e-commerce customer orders from Kohl's website will be sent to one of the warehouses for packing and shipping.
Environment: z/OS, JCL, TSO/ISPF, JCL, QSAM, VSAM, DB2, CICS, MQSeries, Websphere MQ, COBOL, Syncsort, Intertest, ESP, File Aid, Abend Aid, Expediter, Remedy, Clarity, Oracle DB, PL/SQL, SQL Plus, Trace, TOAD, Blue Martini, FTP, EDI, Biztalk, MySQL, Unix/AIX scripts k, c, bash, bourne shells , PERL, sed awk, Crystal Reports, Microsoft Project, Access, Powerpoint, Excel, Visio and Word.
Confidential
- Primary responsibility was the data mapping for conversions of clients from other vendors or internal systems to Thomson/Reuters data architecture. Some data was mapped, other data required conversion rules. All conversions were first completed in the test environment and verified by Thomson/Reuter and then by the client. When completed, conversions were run in the production environment. All conversions in the backlog were completed on schedule.
Environment: z/OS, JCL, TSO/ISPF, JCL, QSAM, VSAM, DB2, DATACOM, CICS, MQSeries, Websphere MQ, COBOL, Syncsort, Intertest, SAR, ZEKE, ZEBB, File Aid, Abend Aid, Expediter, Remedy, Peregrine, Change Manager, Main Event, Detector, Rational Rose, ClearView, ClearCase, Microsoft Project, Access, Powerpoint, Excel, Visio and Word.
Confidential
- Performed data validation and loading of sales and marketing data warehouse. Files were transferred between servers and mainframes and validated prior to database update.
- Performed ad hoc queries, produced analysis reports, did data analysis to certify data integrity, performed a variety of cross platform file transfer functions, maintenance and enhancement development and 24 x 7 production support.
Environment: z/OS, JCL, TSO/ISPF, QSAM, VSAM, DB2, Oracle DB, CICS, Change Manager, MQSeries, COBOL, Expediter, ZEKE, ZEBB, File Aid, Abend Aid, Peregrine, FOCUS, Quikjob, Easytrieve, UNIX, Remoteware, C Shell, Bourne Shell, Bourne Again Shell scripting, Crystal Reports, Visual Basic Express, C , .NET, SQL Server, VMWare, Microsoft Project and Office 2007.
Confidential
- Converted data from EDI formats to the ERP system Passport and its server-based front ends Documentum and APEx for vendor ASNs. The transactions for this process were sent in ANSI standard record types and layouts. Mainframe-based applications validated the data and reformatted the EDI transactions into data records acceptable to the in-house batch process which handled ASNs.
Environment: z/OS, TSO/ISPF, JCL, QSAM, VSAM, Oracle DB, COBOL, CICS, Change Manager, MQSeries, Intertest, Websphere MQ, File Aid, Abend Aid, DB2, Endevor, Citrix, UNIX, CA 7, CA 11, Citrix, VPN for remote access , Visual Basic, C , VMWare, Microsoft Office 2007.
Confidential
- Performed system analysis and conversion programming, testing in preparation for merger of MGIC and its intended partner in Philadelphia.
- Engaged in DB2 resource evaluation and tuning, troubleshooting and performance issues resolution.
Environment: z/OS, TSO/ISPF, JCL, QSAM, VSAM, COBOL, DB2, Oracle DB, CICS, Panvalet, Easytrieve, MQSeries, UNIX, Oracle, C Shell, Bourne Shell scripting, ZEKE, ZEBB, Microsoft Office 2007.
Confidential
- Designed automated third-party prescription benefits applications to medical insurance accumulators. Developed automated file transfers via CICS/MQSeries interfaces to edit and validation programs and subsequent introduction of validated data to the batch update environment.
Environment: z/OS, JCL, TSO/ISPF, Endevor, COBOL, Assembler, File Aid, Interest, VSAM, MQSeries, NDM, CA 7, CA 11, Microsoft Office 2007, Microsoft Project.
Confidential
- Supported a variety of cross platform IBM mainframe and DEC VAX manufacturing, planning, scheduling and financial applications. A great deal of process analysis and data verification was required to meet ad hoc information requirements of users and website developers.
- Constant user interfaces with plant financial reporting staff and plant production management personnel was required to determine requirements, set performance standards and metrics, determine data requirements and availability and perform ad hoc process improvement functions.
Environment: z/OS, TSO/ISPF, JCL, VSAM, QSAM, IMS DB/DC, SAS, DB2, Oracle DB, File Aid, Abend Aid, Easytrieve, Quikjob, Syncsort, Dataxfer, COBOL, PL/1, Assembler, Change Manager, NDM, CA-7, CA-11, Oracle, SQL Server, Visual Basic, Access, Crystal Reports, AS/400 with COBOL/400, DB2 UDB, OCL/400 and the usual midrange tools, Peregrine, Microsoft Office, Microsoft Project.