Iseries Business Analyst
Resume:
●SCOTT A. DOTY
Fort Worth, TX **112
*******@*****.***
** ***** ** *****/ ******* Operating System Experience
Contract and Full time SENIOR SYSTEMS PROGRAMMER for IBM mainframe (zSeries, iSeries) systems specializing in ALL phases of systems support, Multi-platform - i.e. z/Os, iSeries, Microsoft - SYSTEMS SECURITY (protocols, policies and administration), disaster recovery, and upper management reporting services with strong ACCOUNTING/BOOKKEEPING experience. Senior level DATA ANALYST expert using MS Excel advanced formula, macro, and pivot table skills. Responsible 24 X 7 Customer support specialist for both internal and external customers. Specialize in compliance with U.S. government agencies (i.e. FAA, FDA, SEC) including Indian Health Organization.
EDUCATION
• TARRANT COUNTY COLLEGE
• Senior Level Professional development certificates include: 20+ years of IBM EDUCATION - MVS/ESA control Structure and Logic, Z/Os, SMP/E, SMS, DFHSM, TSO, ISPF, SDSF, RMF and SMF Performance Tuning, VSAM tuning, STOPX-37, ASTEX, ChiCor TRPS, Tibco - Rendezvous/Hawk, Tape Management, Job Scheduling, Report Management, MKS Implementer, SAS, Computer Validation, JD Edwards CMA, S/390, zOs, AS/OS-400, DASD Performance Management, MS Excel, and MS PowerPoint, Active Directory.
SKILLS
Advanced/Senior MS Office and highly skilled MS Excel and PowerPoint, IBM MVS/ESA Control Structure and Logic, ChiCor TRPS, Tibco - Rendezvous/Hawk, Job Scheduling, Tape Management, SMS, DFHSM, TSO, ISPF, SDSF, MKS Implementer, CA View Report Management, SAS, SQL, Computer Validation, JD Edwards CMA, RMF and SMF Performance Tuning, STOPX-37, Z/Os, AS/OS/400, BRMS, SQL Server/iSeries; Windows (both workstation and server) installs and maintenance, SMP/E,
JD Edwards CMA, SQL Server/iSeries, and Wintel suite. Accounting/Bookingkeeping.
KEY ACCOMPLISHMENTS
• The designated committee disaster recovery representative for the FDA validation for Alcon Labs/Nestle.
• Systems Security officer for all IBM platforms and security analyst for Windows platform.
Designed, authored, and executed the first IT disaster recovery plan for Alcon Labs. Partnered with systems teammates to develop an unprecedented/automated JCL generator for disaster recovery testing.
• Reduced disaster recovery testing efforts from eight hours to four.
• Installed and implemented IMS for Alcon Labs.
• Solely responsible for installing and implementing Z/Os SMS for Alcon Labs • Senior Team member for initial installations, implementations, and maintenance of S390 & z/Os core, TSO, JCL, ISPF, etc.
• Managed windows program product MKSIS with installation and customization in support of the company’s integration/ interface with JD Edwards iSeries manufacturing modules.
• Served on computer Validation committee to represent operations/technical support and disaster recovery functions.
• Upgraded S/390 non-validated mainframe into FDA compliance ahead of schedule and $100,000 under budget.
• Integral in assuring all S/390 mainframe software was Y2K compliant. PROFESSIONAL EXPERIENCE -(RETIRED) January 2022
DOTY & Associates(Semi-Retired) August 2014-December2021
Chickasaw Nation Medical Center – (DBA) March 2014-July 014
Support Clinical/Medical patient Database instances (Build and Deploy-Windows based software using CACHE’ database structure). Specialized use of Resource and Patient Management System (RPMS) Indian Health Services software. Responsibilities involved building all-encompassing database structures to support patient wellness from day-to-day care, imaging, surgical support, prescriptions and aftercare. On-call 24x7 for Emergency room and Careflight support.
Zodiac Aerospace - (Business Analyst) September 2012-December 2012
Contracted thru Buchanan Technologies. On-site iSeries systems support for Zodiac Aerospace ensuring software was FAA compliant. Fulfilling requirements for canned software customization for the Human Resource department. Union and non-Union Zodiac customization required. Involved SQL updating of IBM DB2 databases to reflect employee statistics in support of online access through kiosks.
Personal 2010-2011
Texas Roofing - (Sales) 2008-2009 Roofing Sales, bookkeeping and software support.
D & J’s Quilting – (Computer support) 2007
Computer support of automated quilting Gracefame software(Windows based).
Fidelity Investments-(Z Series Perf/Tuning Group) June 2006-December 2006 Contracted thru TEK Systems. Performed performance tuning on large Z/Os footprint(s). Responsible for assuring SEC Stock Market response time requirements were met or exceeded during stock market hours.
Alcon Laboratories, Inc. – (Senior Systems Analyst) 1983 - 2006 Served as S/390-z/Os, iSeries program product resource for Operating Systems and associated support products including but not limited to: ISPF, TSO, JCL, SMP/E, SAS, RMDS, scheduling packages, tape management packages, report viewing packages, and software conversions. Acted as comprehensive 24X7 on-call resource, Windows program product installation and support, and held JDE OneWorld CMA package promotion and build responsibilities.
• Shouldered 75% of production requests within one week of SQL Server admin training. • Responsible for new group responsibilities, including Windows disk space alert procedures for over 600 servers.
• Compounded group activities with continued past re-org transitions responsibilities from iSeries, JDE OneWorld, and S/390.
• Networked with experienced engineering DBAs, searching for solutions using documented SQL books, Internet search engines, and company-specific standard operating procedures.
• Provided coverage and support until additional SQL resource was added in late June and began building a successful team.
• Proposed system to assure 24X7 support was accomplished by using flexible rotation of on-call responsibilities over multiple operating systems and footprints.
Managed Windows program product support installation, customization, and support as company integrated tool to interface with MKS implementer installed on iSeries. Worked closely with applications programmers to develop highly customized application that allowed company to move worldwide iSeries manufacturing development coding and production environment rollout from European data center to Fort Worth data center.
Managed JDE OneWorld change management analyst utilizing JD Edwards client/server architecture. Supported application programmers in building one-of-a-kind order entry system.
Provided ongoing TIBCO support assuring that existing TIBCO integrations were managed in a production manner.
Discovered three anomalies in installation of MKSIM, including ability to only use flat file password authentication instead of NT/AD authentication, extremely slow response time, and application administrators losing access to application and its folders.
• Requested security group convert any users to local active directory domain. Worked closely with vendor and product specialist from MKS to build hot fix to allow users to dial in domains in a specific manner.
• Discovered vendor fix was only tested in small domain environment. Turned cache off and eliminated problem.
• Found that unbeknown to group, company server group had applied specific server permissions at direction of parent company that dictated folder permission rights that were updated every night. Reinstalled product in its own folders and security problems ceased.
Responsible for TIBCO integration technical support and served as member of a two-man support team who installed and managed TIBCO-rendezvous/hawk/product line environment rolled out to roughly 100 servers. Conducted constant hands-on management as product was not designed for large manufacturing environments. Re-evaluated JDE OneWorld support role. Successfully completed Y2K S/390 product upgrades, testing, and implementation.
Managed S/390 and JDE OneWorld disaster recovery effort. Was responsible for iSeries OS/400 installation and program product, including business recovery media services and performance management. Supported FDA compliant environment. Oversaw S/390 product support, encompassing tape management, disk management, report viewing and distribution, job scheduling, performance and capacity planning, and systems related tools.
• Grew with Alcon as they expanded during this period. Began on the computer room floor, then served as SR. DISK/DASD Analyst and ultimately Senior Systems Programmer.
• Performed Systems Analyst, Business Analyst activities and Disaster Recovery tasks; furthered education with provided training.
• Prepared test plans, data, and user documentation for customer billing system, JDEdwards World-Wide Manufacturing Systems (including Computer Validation), and Financial systems.
• Provided training for parent company (Nestle) and handled Systems Security Administrator responsibilities.
• Problem solved hardware and software issues in a high-pressure environment. • As a senior member of the FDA regulated Computer Validation Committee in conjunction with FDA inspector Dr. Ronald Teztlaff. Executed high level operations with a $400,000 budget to come in $100,000 under planned.
• Designed, wrote and executed Alcon Laboratories first Disaster/Business Recovery plans.
• Provided support for LINUX/UNIX operating system software. • IBM MQ series software installation and support.
REFERENCES AVAILABLE UPON REQUEST
Contact this candidate