Over three decades of IT/data processing experience in various industries and lines of business with various technologies, databases, languages and operating systems.

COMPUTER EXPERIENCE AND SKILLS

• Hardware: IBM 3090 and 3081, Sun & Sparc Workstations, Prime 9955 II, 6550 and 4050
• Operating Systems: IBM OS/MVS/XA/390, IBM MVS JES2 JES3, Windows 3.1/95/NT 4.0/2000/XP/7/10, Unix (Sun, SCO & Solaris), Macintosh, DOS (PC's), VM/CMS, X-Windows, PICK, Primos
• Languages: COBOL II/MVS, JCL, SQL, NATURAL, Microfocus COBOL 3.2 (Unix), SAS, SPSS (Statistics), CICS | CLICK HERE FOR MORE IBM Mainframe DETAILS
• Databases: SQL Server, ORACLE (see below), ADABAS, dBase III, SQL, Filemaker
• Assorted Software: TSO, ISPF/PDF, VSAM, Panvalet, Syncsort, PANAPT, File-Aid, Abend-Aid, RealWorld
• Software (PC's/Macintosh): Office, Dejawin, Visio, Rumba, scripting and automation, assorted software
• Oracle: Oracle Financials 11.5.7, Oracle Utilities, PL/SQL, SQL*Plus, TOAD | CLICK HERE FOR MORE ORACLE DETAILS
• SQL Server: SQL Server 2010-2016, SQL Server Management Studio (SSMS), SQL Server Reporting Services (SSRS) 2012+, SQL Server Integration Services (SSIS) | CLICK HERE FOR MORE SQL Server/ASP.NET/Java DETAILS
  • Transaction-SQL (T-SQL / Stored Procedures )
  • Visual Studio 2008, 2010; Visual Basic ( .net 3.0 & 4.0 ), Javascript, JQuery

EXPERIENCE

November 1997 to present
State Government Agency, New York, New York
Senior Programmer Analyst (Application, Databases, Mainframe)

Involved with the following applications, systems and projects :

Internet & Business Technologies: September 2008 to present : Supporting various data sources from within the agency for databases, reports and firms website.
Some cases requiring program changes to queries, forms, programs, logic to accommodate them also.
Office automation: Citrix re-engineering; interfaces using Excel templates & DOS scripts to streamline desired data.
Requirements gathering, work and data flow, interfaces, third party product research and testing for customer address standardization to transaction logging and other third-party solutions.
Developed console applications to interface data between IBM mainframe and SQL Server for database feeds and complex SQL queries, views, data conversion and normalization, reports and documentation.
Contributor and supported 9 others applications, including conversion to SQL Server/VB/ASP.NET.

Software:   ASP, Visual Studio 2008, Filemaker 5.0 (Windows), Excel (macros & templates), XML, SourceSafe
DBMS:  SQL Server 2008, Transact-SQL (stored procedures), CTE (Common Table Expressions)
Platform & Server:   SQL Server 2008, Microsoft SQL Server Management Studio

Oracle's Accounts Receivable System (eBusiness) 2001-2008:
November 1997 to September 2008

Supported of Accounts Receivable (A/R) system along with other financial systems, interfaces and subsystems. Functions and responsibilities included disaster recovery, troubleshooting and coordination with data center technicians of upgrades, installations and testing of third party software and operating systems.

CLICK HERE FOR MORE ORACLE DETAILS

Support of Accounts Receivable application along with other financial applications, interfaces and subsystems. Functions and responsibilities included disaster recovery, troubleshooting and coordination with data center technicians of upgrades, installations and testing of third party software.
Involved with the following systems and projects:

Replaced legacy mainframe system with Windows based Oracle's ERP eBusiness Financials Suite. Customer and General Ledger data for conversion, mapping, and interfaces. Cleansed, validated and migrated legacy with other essential data using scripted automation and updates from mainframe. Support of end-users in the Office of the Controller for data, application, hardware and technical issues.

Mirrored firms legacy Invoice and Credit Memo's forms using customized PL/SQL programs with duplex printing, and ultimately to Metaviewer for archiving, ease of printing and searching functionality and cost.

DFSORT PTF upgrade and testing with IBM to streamline data exchange from EBCDIC to ASCII to produce converted files without having to write programs especially for packed and signed numerical data. Technical, Reference and end-User documentation; Customization and working with consultants, Oracle technicians and DBA's. | DFSORT publication

Research of products, vendors and consultants together with arranging demonstrations and meetings for user and IS requirements ranging from: Adobe and Evergreen for custom invoices to Appworx's scheduling package to Noetix's Dashboard.

Mainframe:  JCL, MVS Utilities (DFSORT), COBOL, VSAM, FTP
DOS/PC:   COMSPEC, DOS menus, FTP and scripting
Oracle:   SQL*Loader, SQL*Plus, TOAD, PL/SQL (Procedures, Packages), FNDLOAD, Discoverer
Platform & Server:   Oracle 8i, 9i, 10g under Windows 2000/NT Server, FTP
Interfaces:   Customer Interface, AutoInvoice, Lockbox, Chart of Accounts, Flexfields, Metaviewer
Oracle eBusiness Suite Financials (Release 11i):  Implementation, customization of AR & GL modules
Training:   SQL, PL/SQL, Oracle Financials (A/R, G/L), Fundamentals, Discoverer

Legacy Accounts Receivable System 1998-2001:

Supported legacy A/R system, Y2K, and Accolade to CICS conversions and migration to Oracle Financials package (see above). Disaster Recovery and other data center projects.
Environment consisted of: COBOL, COBOL II, Accolade, MVS, OS/390, JCL, SAS, VSAM, CICS/CL, Expediter, TSO/ISPF, Visual Basic 6 (trained).

Legacy Budget System 1997-2004:

Support and maintenance of internal operating budget for OMB. Weekly hours to gross processing, and interface with Payroll and other departments and systems. Also heavy analysis, debugging and documentation; supervised and trained a staff of three.
Environment consisted of: SAS, COBOL, JCL, MVS Utilities, VSAM, and CICS.

November 1996 to June 1997
Princeton University , Research Analyst/Programmer (temporary employee)

Supported the Office of the Registrar, various Deans and other departments with programming, maintenance, development and analysis using a variety of databases, languages and operating systems to support several Grading and Course systems on multiple environments. Duties included data analysis, documentation, conversions, re-engineering, report writing and computer programming with the following:

• Platforms: DOS, Windows (3.1 & NT 4.0), Unix, VM/CMS, MVS JES3, Novell Netware
• Languages/Software: JCL, SPSS (Statistics), SQL, Office 97, R&R Report Writer,Mark IV
• Databases: dBase, IMS, Oracle7
• Internet/Intranet: Researching products and platforms for developing sites for internal and external use.

April 1996 to November 1996
Coopers & Lybrand , Consultant

Client: Seiko Corporation of America , Mahwah NJ Serving as a consultant for several systems and sub-systems written in ADABAS/NATURAL 2.2 (structured/reporting mode) for batch and on-line applications. Along with, JCL, PROC's,and OS/MVS Utilities on an IBM 3090 under MVS/XA serving corporate users and customers. Duties and projects include: day to day operations, resolving user problems and requests, coding, heavy documentation, testing debugging, and analysis.

August 1995 to March 1996, Programmer/Analyst
EMCO Sales & Service, N. Bergen, NJ

Duties as a Programmer/Analyst involved programming in: Microfocus COBOL 3.0, 3.1 & 3.2, and assorted Unix utilities on several Unix machines running both Sun/Solaris and SCO Unix serving corporate, end-users and customers. Supported assorted financial and distribution applications and systems for internal users and customers. Major projects include: major redesign and rewrite of the customer's media pricing system for automation and data integrity; full cycle development of a merchandise location database to track and pull merchandise using FIFO; along with assorted conversions, utilities and reports. Converted Microfocus COBOL 3.0, 3.1 to 3.2. Documentation of systems, programs and procedures, and integrating subroutines and standards to be implemented. Supported Macintosh users, and RealWorld accounting package, Also involved with production, user and technical support.

April 1994 to August 1995, Programmer/Analyst
Chase Manhattan Bank , Brooklyn New York

Supported corporate and international users; assisted conversion to firm wide commercial loan package Advanced Commercial Banking System (ACBS®) by LANSA Under AS/400 in Bournemouth, UK for corporate and international users for reconciliation and adjustments. Mentored and trained several college students in programming and data processing.
Environment consisted of: COBOL, ADABAS/SQL, Natural 2.2, RUMBA, PANAPT, CICS, JCL, VSAM, and OS/MVS Utilities on an IBM 3090 under MVS/XA. Supported corporate and international users. Major projects included redesign of the reconciliation and adjustment process, conversion to a new firmwide loan package. Also involved with the firms plans to design and support various Internet connections and protocols. Heavy analysis of existing processes along with modifications and debugging of existing and new processes. Also responsible for production, user and technical support.

September 1990 to April 1994, Programmer/Analyst
Merrill Lynch , Manhattan, New York

Duties as a Programmer/Analyst involved programming in: COBOL, ADABAS/SQL, Natural 1.2 and 2.2, CICS/CL,JCL, PROC's, VSAM, DB2 (trained), OS/MVS Utilities on an IBM 3090 under MVS/XA. To serve corporate and international users. Responsibilities and projects included: Loading, validating and maintaining data integrity and financial balancing on a wide range of tapes, files and databases from both, internal and external sources. Such as account executives, geographical data, corporations, insurance companies, private corporations, bank holding companies, money markets and banks. Also developing, modifying and correcting numerous on-line, batch and production applications; producing customized and Ad hoc reports and files for various users; converting ADAMINTS to ADABAS/SQL and Natural 1.2 programs to Natural 2.2. Full cycle development, support and maintenance of Tokyo trade conversion processing; processing Qualified Institutional Buyers (QIB's) in compliance with SEC rules; Mass customer account updates; Money Market trade processing; and Account Executive purge and pending processing.

December 1989 to June 1990, Consultant
AT&T Communications, Piscataway, New Jersey

Responsible for all systems development, testing, design, maintenance and user support for AT&T's marketing groups serving major accounts under the Software Defined Network (SDN). Duties included coding, analysis, testing, development and production of various clients requests of bill detail information ranging from Ad hoc and customized reports to tapes and cartridges serving AT&T's Fortune 500 clientele served under SDN. Also responsible for researching and analyzing production and end-user problems as well as resolving them. As well as producing documentation and user specifications.
Programming was done in batch COBOL (migrating to COBOL II) using JCL, OS Utilities and PROC's on a IBM 3090 under MVS/XA using sequential and VSAM files.

October 1988 to October 1989, Programmer/Analyst
J. Crew/Clifford & Wills, Manhattan, New York

Programmed, analyzed and tested numerous applications in distribution and merchandising for a $150,000,000 Catalog firm. Programmed in COBOL (batch and on-line) on Prime 9955 II, 6550, and 4050 under PRIMOS using MIDAS files and a IBM 3090 under MVS/XA using VSAM and sequential files. Involved with the Prime to IBM conversion of the Shipping Manifest, Receiving and Warehouse systems and files. Wrote, designed and implemented a detailed transaction file update system for receiving; a Pallet program to fill orders on demand and to produce labels; a program to transfer data from Prime to the McDonnel Douglas 6000 computer for inventory control purposes; modified and improved order release pick tickets to improve order processing turnaround; numerous file conversion, maintenance and inquiry programs and numerous applications and reports for Inventory, Merchandising, Purchase Order, Receiving and Finance.

October 1987 to May 1988, Programmer / Operator
SYMS Corp., Secaucus, New Jersey

A key participant in the development of a MIS department at both a corporate headquarters and state-of-the-art distribution center serving a 22 store chain. Programmed, operated and maintained a unique system, at one of only a few worldwide Beta test sites for the McDonnel Douglas (formerly Microdata) Series 18 Pegasus. It served as the primary computer, while a McDonnel Douglas 9250 computer served as the backup system.Concurrently interfacin g to a Digital PDP 11/96 to maintain the distribution center's sorters. Programming and troubleshooting in the PICK environment, consisting of PICK BASIC, TCL, ENGLISH and PROC with application and maintenance programming for utilities, accounting and databases, given in detail below.

Utilities: Password subroutine, documentation generator, a time correction module to correct "sleeping" processes on Phantoms/TIPH's, a cross reference finder and a universal time and date verifier.

Accounting: Vendor merge program for A/P, redesigned an Inventory program from 32K down to 26K, maintenance and modifications to various packages ranging from sales analysis and check generators to many reports and data entry upgrades.
Databases: Tape Library and System Statistics.

- Developed system, application and user documentation.
- Involved with system recovery and backup procedures.
- Handled hardware, system, data communication, peripheral and
  software troubleshooting.
- Worked with engineers and vendors maintaining software and
  various hardware devices and services to support over 80 users
  throughout the corporation, distribution
  center and stores.

SCIENTIFIC / NON I.T.

Applied for and was granted time using the Hubble Space Telescope as an amateur to perform research of Saturn's moon Titans' atmosphere using high-resolution spectroscopy in the ultraviolet (UV). Data reduction and analysis using the following hardware and software: Sun/Sparc Workstations, Unix, X-Windows, IRAF and STSDAS.

EDUCATION

DeVRY INSTITUTE OF TECHNOLOGY, Chicago, Illinois
Bachelor of Science in Computer Information Systems, 1987

DeVRY TECHNICAL INSTITUTE, Woodbridge, New Jersey
Diploma in Computer Information Systems, 1987

PERSONAL