grlewycky@yahoo.com
DOWNLOAD RESUME FILES in TXT, PDF & WORD formats
Recent Resume (PDF) Oracle Skills & Experience (PDF) SQL Server (PDF) ADABAS (PDF)
Resume of George R. Lewycky: SQL Server Oracle SQL PL/SQL Ebusiness Mainframe COBOL JCL NJ NYC
http://georgenet.net/resume/
grlewycky@yahoo.com
DOWNLOAD RESUME FILES in TXT, PDF & WORD formats
Recent Resume (PDF)
Oracle Skills & Experience (PDF)
SQL Server (PDF)
ADABAS (PDF)
CURRENT STATUS:
"have eyes out" as of 01/10/2012
due to second year of on-going layoffs from a state economic crisis
If its urgent send me a brief text message (140 characters!!!)
SEND ME A TEXT MESSAGE (via email) TO MY CELL PHONE Click here, or
use this website and enter my cell # 908 705 0404
Preferred Industries: Education, Pharmaceutical, Not for Profit, Media/Entertainment, Non-Financial, Energy, Transportation, Research/Scientific/Academia or Government.
Preferred Locations: New York City or New Jersey area (after November 2012 when my lease is up I could be open to other locations), or with SPECIAL ARRANGEMENTS
Also I know several available Mainframe, Midrange (AS400), Database, Macintosh & PC tech support professionals
Click here for other resumes of people I worked with
Also I know other Mainframe, Database (DB2, Adabas, Access), Fortran, PC and Macintosh skilled professionals who are looking NJ/NYC area
Please contact me by email
grlewycky @ yahoo.com Give me details and I expect finders fee
Over twenty years of data processing experience in various industries using a diversity of languages and operating systems. Strong problem-solving skills, writing skills, analytical, and interpersonal skills
Experience in banking, brokerage, telecommunications, retail, mail-order and distribution systems, government and academia. Involved in full cycle phases of analyzing, programming and testing as well as conversions and documentation using a variety of languages and operating systems in a multitude of environments.
November 1997 to present
State Government Agency, New York, New York
Senior Programmer Analyst (Application, Databases, Mainframe)
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
Support 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
Oracle's Accounts Receivable System 2001-September 2008:
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 and 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 Memoforms using customized PL/SQL programs along with conversion to duplex printing, and ultimately to Metaviewer for archiving, ease of printing and searching functionality.
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
Research of products, vendors and consultants together with arranging demonstrations and meetings for user and TIS requirements ranging from: Adobe and Evergreen for custom invoices to Appworx's scheduling package to NoetixDashboard.
Mainframe: JCL, MVS Utilities (DFSORT), COBOL, VSAM, FTP DOS/PC: COMSPEC, DOS menus, FTPs and scripting Oracle: SQL*Loader, SQL*Plus, TOAD, PL/SQL (Procedures, Packages), FNDLOAD 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:
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
Duties as a Programmer/Analyst involved programming in: COBOL, ADABAS/SQL, Natural 2.2, CICS/CL, JCL, PROC's, VSAM, and OS/MVS Utilities on an IBM 3090 under MVS/XA serving 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.
Designed, tested, documented, and developed several automated and customized report generation package for the Department of Special Services of Joyce Kilmer School, Milltown, New Jersey. This package produces a personalized report for a student to improve the student's personal and educational growth.
CyberLibrarian/Information Broker and Web design
Assorted World Wide Web (WWW) pages which can be accessible through this link or searched through most major web searchers using my last name.
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.
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