George R. Lewycky 30 Regent Street, Apt. #709, Jersey City, NJ 07302 grlewycky@yahoo.com SUMMARY 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 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, 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 Databases: SQL Server 2005/2008, 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 (see below for more details) EMPLOYMENT State Government Agency, New York City Customer Service’s Refund System 2008-present: September 2008 to present Analyzed and ultimately replaced customized Filemaker database/application, being used as a customer service tool, to upgrade into a custom intranet and internet application under Visual Studio 2008 and ASP.NET with SQL Server 2008 R2 backend in order to expedite customer claims in a customized and complex customer claim processing system. Involvement ranged from requirements gathering, work and data flow, developed interfaces, product research, review and testing for 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 requests and complex SQL queries, views, data conversion and normalization. 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 November 1997 to September 2008 Senior Programmer/Analyst Support of Accounts Receivable (A/R) 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 and operating systems. Involved with the following systems and projects: Oracle’s Accounts Receivable System 2001-Current: 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 Memo’s forms 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’s. 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 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, and Visual Basic 5 (trained). 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. Princeton University, Princeton, New Jersey November 1996 to June 1997 Research Analyst/Computer Programmer (temporary) Supported the Registrar, Deans, and various departments for grading and course systems. Development of a new course/professor database which, produced a more efficient algorithm that was utilized for other applications. Complex statistical Grade Point Average reports using SPSS. Platforms: Windows (3.1 & NT 4.0), Unix (Sun), VM/CMS, DOS, MVS, Novell Netware Languages/Software: SPSS (Statistics), JCL, PROC’s, SQL, R&R Report Writer, Quattro, Mark IV Databases: dBase III, IMS, Oracle Coopers & Lybrand, New Jersey April 1996 to November 1996 Consultant Seiko Corporation of America, Mahwah, NJ Consultant for several systems under ADABAS/NATURAL. Operations, support, analysis and documentation. EMCO Sales & Service, North Bergen, New Jersey August 1995 to March 1996 Programmer/Analyst Financial and distribution applications. Also support of Macintosh users and Real World accounting package. Programmed in: Microfocus COBOL 3.0-3.2, Windows, and assorted Unix utilities on Unix (Sun/SCO) machines. Chase Manhattan Bank, Brooklyn, New York April 1994 to August 1995 Programmer/Analyst Served corporate and international users with projects for the reconciliation and adjustment process. Conversion to firm wide loan package under AS/400. Involved with committee regarding the firms Internet site. Mentored and trained several college students in programming and data processing. Programmed in: COBOL, ADABAS/SQL, Natural 2.2, RUMBA, CICS, JCL, PROC's, VSAM, and OS/MVS Utilities on an IBM 3090 under MVS/XA Merrill Lynch, Manhattan, New York September 1990 to April 1994 Programmer/Analyst Validated and maintained data integrity and financial balancing on a range of tapes, files and databases from both, internal and external sources such as geographical data and banks. Development, support and maintenance of Tokyo trade conversion processing. Environment consisted of: COBOL, ADABAS/SQL, Natural 1.2/ 2.2, CICS/CL, JCL, PROC's, VSAM, DB2, SQL, PANAPT, OS/MVS Utilities on an IBM 3090 under MVS/XA. AT&T Communications, Piscataway, New Jersey December 1989 to June 1990 Consultant Systems development, testing, design, maintenance and user support for AT&T's marketing groups serving major accounts under the Software Defined Network (SDN). Produced various clients’ requests of bill detail information ranging from customized reports to tapes and cartridges. Researched production and end-user problems as well as resolving them and 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. J. Crew/Clifford & Wills, Manhattan, New York October 1988 to October 1989 Programmer / Analyst Programmed, analyzed and tested numerous applications in distribution and merchandising for a 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 using VSAM and sequential files. IBM conversion of the Shipping Manifest, Receiving, and Warehouse systems. Wrote, designed and implemented a pallet system to fill orders on demand and produce customized labels for the warehouse; and modified and improved order release pick tickets for order processing turnaround. Syms Corp., Secaucus, New Jersey October 1987 to May 1988 Programmer / Operator 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. Programmed in the PICK environment, consisting of PICK BASIC, TCL, ENGLISH and PROC with application and maintenance programming for various utilities, accounting applications and databases. 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 REFERENCES Furnished upon request