Systems Administrator Resume
Chicago, IL
EXECUTIVE SUMMARY
Applicant graduated from college in 1980 and his first job out of school was with International Harvester; he was involved with maintenance and updates to COBOL programs. After that he worked at PMSC doing updates and new development to online and batch COBOL programs and continued on in Mainframe development for the next 2 decades. Applicant also has knowledge specific to the insurance industry having tested on INS21 General Principles, INS22 Property and INS23 Casualty Insurance. At this point in his career, COBOL development has become routine for Applicant. More recently, Applicant has made an effort to update his skill set attempting to become more relevant in today’s competitive IT market. He’s received training on PL/SQL development and has recently been exposed to C#.NET. Applicant is available to interview immediately but he requires 1-2 weeks before he can start an assignment. His additional career highlights are bulleted below.
- Excellent organizational, interpersonal and communications skills with an energetic and self-motivated style that has consistently resulted in achievements of both short and long-range goals and objectives
- Used the principals of OOP such as Inheritance, polymorphism, In contrast, using object-oriented analysis, design, and programming techniques, the focus remains on the real-world objects throughout the development cycle. Although there is no clear winner in object-oriented analysis an overlap between each of the three development steps. The analyst and the programmer are both interested in development of usable (and reusable) objects. These programming objects (referred to as class declarations), once tested and made available to other programmers, do not have to be retested and redesigned every time changes are made to the data layout.
- Designing and developing R12 E-Business Suite extensions (R12 experience is KEY!) which includes configuring security and user management, configuring flexfields, managing concurrent processing, and setting up other essential features such as profile options and printing. In addition, configuration and maintenance of an Oracle E-Business Suite through Oracle Applications Manager is discussed
- Confidential, Oracle A.I.M. Methodology encompasses a project management methodology with documentation templates that support the life cycle of an implementation. The life cycle methodology and documentation templates allows A.I.M. to be a very useful tool for managing implementation projects successfully. The A.I.M. methodology can actually be used for any type IT software implementations however the value of A.I.M is within the documentation template. The software includes the documentation templates, manuals and an html website to manage these templates.
- Workflow/AME development skills highly desired One of the unique features of AME is its ability to respond to any changes that may occur in an organization during the approval process of a transaction. The changes can include organizational hierarchy changes (i.e. supervisor/manager), modifications to an AME rule or even changes to the values of the current transaction
- BI Publisher data and report template development experience a Cognos is IBM\'s business intelligence (BI) and performance management software suite. The software is designed to enable business users without technical knowledge to extract corporate data, analyze it and assemble reports. Cognos is composed of nearly three dozen software products. Because Cognos is built on open standards, the software products can be used with relational and multidimensional data sources from multiple vendors, including Microsoft, NCR Teradata,
- Oracle BI Publisher Oracle XML Publisher (XMLP) is Oracle Corporation’s new reporting technology. It was originally developed to solve the reporting problems faced by Oracle Applications. It was first released with Oracle E-Business Suite 11.5.10 in 2003. XML Publisher Enterprise with no dependency on Oracle Applications. When XML Publisher became part of the Oracle BI Enterprise Edition Suite it was re-branded as Oracle BI Publisher. BI Publisher separates the creation of data (XML) from the process of formatting it for different uses. The engine can format any well-formed XML data, allowing integration with any system that can generate XML, including Web Services or any data source available through JDBC BI Publisher can merge multiple data sources into a single output document.
- Experienced in all phases of the system development life cycle from specifications, analysis, logical design, physical design, programming, testing, installation, documentation and user training.
- Writing Shell scripts using ksh, bash, PERL for process automation of databases, applications, backup and scheduling.
- Experienced in performing DBA tasks including creating users, roles, tables, table spaces, imports and exports for development of databases.Used CRM modules such as Resource Manager and Territory manager of the foundation components.
- Provided production support in an on-call rotation in a 24x7 environment
- Used PL/SQL (Procedural Language/Structured Query Language) for Oracle\'s corporation procedural extension language for SQL and the Oracle relational database. Extreme desire to exceed and learn more about technology through education and work experiences.
EDUCATION
MA Master’s Degree in History
BS Computer Science
AA International Business
TECHNICAL CRITERIA
COBOL, CICS, Application Development Workstation, FileAid, DB2, IMS DB, PL/1, MicroFocus COBOL, TSO/ISPF, JCL, VSAM, PANVALET, Access, Excel, IFPS,DOS/VSE, SAS, HTML , SYNON ,MS Visio, Windows XP/98/95, ICCF, Desk-top Suite of Utilities, Roscoe, REXX, Oracle, Windows XP, Windows, UNISYS 1190, IBM RS6000, 3090, 308x, 4341, Apple IIE, AS 400 ,COMPAQ, Dell PC and IBM Compatible PCs
EXPERIENCE
Confidential., Chicago, IL 2008 – Present
Oracle Developer / Systems Administrator / Consultant
- Worked at AT&T installing new IOS\'s which included updated versions of firmware to CISCO routers & switches.
- Used PL/SQL for Oracle\'s corporation procedural extension language for SQL and the Oracle relational database. PL/SQL program units can be compiled into the Oracle database. Programmers can thus embed PL/SQL units of functionality into the database directly. They also can write scripts containing PL/SQL program units that can be read into the database using the Oracle SQL*Plus tool.
- Used procedures which are similar to Functions, in that they can be executed to perform work. The primary difference is that procedures cannot be used in a SQL statement. Another difference is that it can return multiple values. Procedures are traditionally the workhorse of the coding world and functions are traditionally the smaller, more specific pieces of code. PL/SQL maintains many of the distinctions between functions and procedures found in many general-purpose programming languages, but in addition, functions can be called from SQL, while procedures cannot.
- Executed SQL commands/scripts/stored procedures against the Database.
- Managed user accounts, developed Korn shell scripts for various system performances monitoring purposes and troubleshooting.
- Gained understanding of UNIX shell script and implemented it.
- Used packages as groups of conceptually linked functions, procedures, variables, PL/SQL table and record TYPE statements, constants, cursors etc. The use of packages promotes re-use of code.
- Used SAS at Mars Candy Company to present information in a way that’s understood by the audience for decision making. Once you collect your data and understand its structure, you need to be able to report and summarize your findings effectively and efficiently. With SAS procedures, SAS DATA steps, and SAS features including the Output Delivery System (ODS) and the macro facility, you have the tools to succeed at writing programs that analyze your data and create reports.
- Used SAS for retrieval, management and mining along with statistical analysis, business planning, forecasting and decision support.
- Used CICS for rapid, high-volume online processing in credit card environment.
- Used Macro-level CICS commands to access file and storage facilities.
- Used BMS for update, delete and modifications to CICS files and information.
- Used Temp Storage for the CICS partition and Transient Data for inter-partional data.
- Worked at Merrill Lynch converting itsnetworking infrastructure to Bank of American; installed CISC0 2800 Voice router 3800 Data router.
Confidential, Naperville, IL 01/07 – 10/07
Systems Engineer
- Used Oracle Application Express (Oracle APEX) as a rapid web application development tool for the Oracle database.
- Supported Shell scripting in a UNIX setting; used basic UNIX commands like LS to list files
- Used OAF development which can be split in two major categories namely: Personalization refers to the ability to declaratively alter the UI to suit user or business needs and Extensibility refers to the ability to programmatically extend an application\'s functionality.
- Used Oracle Applications - Apps E-Business Suite (also known as Applications/Apps or EB-Suite/EBS) to collect enterprise resource planning (ERP), customer relationship management (CRM), and supply-chain management (SCM) computer applications either developed by or acquired by Oracle.
- Worked in testing AP, AR, GL, FA, CE and other financial modules.
- Worked with CC&B Customer Care & Billing System in a UNIX environment; accessed Oracle table through the use of structure and efficient SQL.
- Used BizTalk to promote XML as the common data exchange language for e-commerce and application integration on the Internet.
- Worked in a TSO/ISPF environment.
Confidential, Naperville, IL 01/00 – 12/01
Systems Engineer
Contributions: ELANs, Simple Protocol for ATM Network Signaling, Firmware, Spectrum,(R.A.T.) Remote Access Tool, cassis’s, power supplies, operating system boot image, CISCO router, CISCO commands, IOS, Tier 3 support, Level-3 switches, UNIX database, Used DHCP servers in this bridged environment
Responsibly: Design, test, fix and update software and Hardware
Duties: Making sure system worked and functioned correctly
Confidential, Glenview, IL 11/98 – 12/99 Programmer Analyst
Contributions: Cobol DB2, PL/1, TCP/IP, FTP,CISC/RISC data formats, AS 400, SYNON, GDG, CA-7 for security, Network Data Mover, Stream weaver, MS Visio, Advanced Function Printing (AFP) to reduce mailing costs and create procedural documentation.
- I worked with users to request software changes
- Used AFP to define pages of output that mix fonts, electronic forms, graphics, and images and bar codes.
- Worked with AFP/U to form page definitions.
- Used SYNON along with AS/400 hardware to generate sophisticated high-level language code in COBOL.
- Used CA 2E to develop a specialized language to define an application\'s data model and the rules that ensure its integrity.
- Provided sound judgment in evaluating situations and in making decisions.
- Employed strong verbal and written communication skills; provided timely and accurate feedback to management about the status of critical assignments and about the team status
- Set up an MRP system with ORQ Order Replenishment Quantity) and SS (Safety Stock).
- Tested code in batch and online software.
Confidential 10/96 – 10/98 Technical Writer/Programmer Analyst
- Documented their contract management system.
- Procedures, navigation, and online screens were acknowledged and described in a manual.
- Used the AS/400 version of SYNON was named SYNON/2E
- SYNON pioneered the approach to development which in early 2005 became known as Architected Rapid Application Development (ARAD).
- The tool then automatically instantiates the specialized templates over the data model and generate sophisticated high-level language code in RPG or COBOL without any further developer intervention. It also generates the SQL or DDS code to define the necessary database tables and views.
- Used COBOL included many other features beyond object-orientation. These included (but are not limited to): National Language support (including but not limited to Unicode support), Locale-based processing, User-defined functions, CALL (and function) prototypes (for compile-time parameter checking), Pointers and syntax for getting and freeing storage, Calling conventions to and from non-COBOL languages such as C, Support for execution within framework environments such as Microsoft\'s .NET and Java (including COBOL instantiated as Enterprise JavaBeans),Bit and Boolean support, “True” binary support (up until this enhancement, binary items were truncated based on the (base-10) specification within the Data Division), Floating-point support, Standard (or portable) arithmetic results and XML generation and parsing.
Confidential 10/96 – 10/98 Programmer Analyst
- VM, which stands for "Virtual Machine" (not to be confused with the broader term virtual machine), is a widely-installed operating system for IBM-compatible computers and servers that can host other operating systems in such a way that each operating system behaves as if it were installed on a self-contained computer with its own set of programs and hardware resources.
- Virtual desktop infrastructure (VDI) is essentially the virtualization-based version of the client/server model that IT departments have traditionally offered their businesses. But what are the benefits of deploying VDI? How is it accomplished? In this virtual desktop infrastructure on VMware runbook, learn about planning and deploying VDI.
- I have taken college courses in Active Directory.
- Network management and network monitoring are still problem areas. This is especially true with the new 802.11n deployments because the physical layer is so dramatically different from legacy technology. Enterprises don\'t feel as though they really have a good grasp on wireless management. There is the perception that wireless is unreliable and "not ready for prime time" in the enterprise.
- 802.11n does improve network reliability (robustness). It takes some time for this fact to ripple through the industry. 802.11n does have an impact on the wired network. Access points should have gigabit Ethernet links. And some centralized controllers will even need 10 Gb Ethernet links.