Experience

• 

  Cerba Research

  • Lake Success, New York

  • Senior Data Transfer Developer at Cerba Research

    • Jan 2021 - Present
    • Lake Success, New York

• 

  BARC Global Central Laboratory

  • Lake Success, NY

  • Data Transfer Programmer

    • Jun 2008 - Oct 2021
    • Lake Success, NY

    * Created data transfers for multiple major drug companies.* Created a generic data transfer specifications based on the CDISC and SDTM standard.* Improved internal documentation practices.* Trained users in the use of Excel pivot tables and vertical lookups.* Wrote VBScripts to convert proprietary database exports into Excel files.* Wrote startup and logon scripts for the system administer.* Wrote Excel calculator spreadsheets for Program Management department to verify calculations done within the database.* Wrote Perl scripts to help programmers manage their assigned projects.* Translated Dutch programmer language guide into English.* Created a HTML / VBScript for the programmers that generates date and time regular expressions.* Developed automated procedures to fill in Word and Excel forms used during data transfers.* Trained users in the use of the computer generated error reports to improve data consistency.

• 

  Sun Valley Systems, Inc.

  • Long Beach, NY

  • Senior Programmer Analyst

    • Jul 1999 - Feb 2007
    • Long Beach, NY

    * Analyzed and implemented New York State Education Department statewide data warehouse requirements.* Configured and maintained backups for databases.* Refreshed development databases with production data.* Adjusted UDB parameters for database performance.* Upgraded and verified all software to year 2000 compliance.* Developed a print manager so the end-users could preview, reprint, and delete, saved reports.* Developed encryption routines to protect saved reports from unauthorized use.* Created Excel pivot table lookups.* Designed a secure MS Access menu system for the custom user reports.* Created an interface between the student administration software and third party electronic gradebook interface.* Improved default date routine to have a choice of 45 different dates.* Managed version control of software.* Designed and implemented standardize report headings.* Analyzed software for areas of improvement.* Supervised office when manager went on vacations.* Provided guidance to lower level computer programmers in debugging and testing programs.* Worked with end users, one-on-one, in resolving routine software issues.* Developed several end user guides which were adopted and implemented.

• 

  Cantor Fitzgerald

  • Manhattan, NY

  • Senior Programmer Analyst

    • Sep 1996 - Jul 1999
    • Manhattan, NY

    * Wrote customer monthly statement system for fixed income business.* Incorporated Treasury Inflation-Indexed Securities into fixed income business.* Verified year 2000 compliance of all back office systems.* Assisted in developing testing procedures for year 2000 compliance of all systems.* Developed interface for Corporate Broker trading system into back office system.* Corrected interest calculations for Canadian Broker back office system.* Developed exception reports by combining multiple reports together, reducing end user work load.* Designed flexible transaction fee system.

• 

  Cold River Software, Inc.

  • Edgewood, NY

  • Senior Programmer Analyst

    • Jun 1993 - Apr 1996
    • Edgewood, NY

    * Lead programmer for Digitax 990 income tax system.* Maintained 1040, 1065, 1120, 1120S, and 1041 income tax systems.* Trained in Visual C++ for upcoming General Ledger product.* Developed many utilities and routines that increased programmer productivity.* Developed a word processor to replace the existing Cobol multiple line text entries.* Evaluated Window languages to replace 8-bit MicroFocus Cobol.* Evaluated third-party software packages for integration with DOS products.* Wrote end-user documentation for using the word processor I developed.* Wrote programmer documentation for the word processor routines I developed* Supervised programmers when manager went on vacations.* Instructed programmers on how to use the Cobol ANSI’85 extensions.* Interviewed potential customers to determine their needs for our services.* Wrote end-user documentation for using our products.

• 

  Cantor Fitzgerald Securities

  • Manhattan, NY

  • Senior Programmer Analyst

    • Jan 1983 - Jun 1993
    • Manhattan, NY

    * Developed real time government securities trading system that matched buys and sells against bids and offers, using C, Cobol, system services, and Ingres, on a VAX 6620.* Member of damage control team that setup temporary trading rooms after the World Trade Center Bombing.* Member of elite damage control team sent to the London office after their computer department resigned.* Assisted in development of Eurobond Giveup Billing system on a MicroVax II.* Supervised consultants in development of tape interface between DEC VAX trading system and the Univac back office processing system.* Supervised programmers in development and maintenance of VAX Cobol batch and on-line back office applications, on a VAX 6320.* Developed on-line RTC realty auctioning system using C and Ingres, on a VAX 3900.* Redesigned existing VAX Cobol and UNIVAC Cobol programs to improve performance and reliability.* Developed on-line accounts payable system using Cobol and DMS.* Responsible for conversion of Paine Webber's Mortgage Backed batch system from an Univac 90/30 to an Univac 1100/70.* Supervision of programmers in developing applications for in-house use.* Developed a utility on the Univac 1100 to help programmers search for variable names in the source code libraries. This utility also allowed senior programmers with special privileges to globally make text string changes to the code.* Responsible for analyzing needs for the Cage areas and the accounting department for system improvements.* Developed screen and batch programs for data entry of Corporate Giveup's Billing system.* Assisted in development of Morgan Stanley's Mortgage Backed on-line and batch systems.* Responsible for conversion of Municipal and Corporate data entry and batch systems from Univac 90/30 to Univac 1100/70.* Implemented communication procedures on PC’s for automatic retrieval of data from various banks.

• 

  Imperial News Company, Inc.

  • Melville, NY

  • Computer Operator-Programmer

    • Jan 1978 - Dec 1982
    • Melville, NY

    * Wrote and debugged market analysis report programs for major national magazine publishers.* Maintained, wrote, and debugged JCL and Cobol programs, for the allocation, shipping, and billing of magazines and paperbacks to retail dealers.* Responsible for conversion of Cobol ANSI’68 programs to Cobol ANSI’74.* Responsible for running batch programs on Univac 90/40, Prime PDR3109, and Honeywell Dual 1200 computers.* Wrote and maintained operator's handbook for running of batch jobs.