Experience

Ideal Concepts, Inc.

• United States
• Insurance
• 100 - 200 Employee

• Database Engineer

  • Mar 2019 - Present

  MS SQL database design, development, and performance tuning. MS SQL database design, development, and performance tuning.



Financial Information, Inc.

• Greater New York City Area

• .Net Developer / Analyst / Support

  • Mar 2004 - Jul 2018

  Development and support for company of 30 people. Converted company data from an outsourced mainframe to an in-house MS SQL Server. This involved converting data from EBCDIC to ASCII format. This conversion eliminated a monthly mainframe charge, provided 24/7 online availability to clients, and allowed more flexibility for enhancements going forward. Programming was done using VB .Net and SQL scripts. Provided end to end SQL Server support. This included maintenance plans, Integration and Reporting Services, and SQL scripting (stored procedures, functions, triggers, etc.). SQL Server version started at 2000 and was last upgraded to 2016. Provided support for Intranet Data Entry system, including troubleshooting problems and requested enhancements. The site was written using Visual Studio, VB .Net, Javascript, and JQuery. Automated desktop support (Windows XP and 7) using Active Directory and WSUS. This provided consistency which reduced troubleshooting times when problems did occur.



Merrill Lynch

• United States
• Financial Services
• 700 & Above Employee

• VP

  • Oct 1988 - Mar 2004

  Lead Developer - 10 years Provided end to end support for a multi-million dollar dividend mainframe system. This included both online and batch processing. Data was stored in various formats including VSAM, IMS, and DB2. Made performance changes to main dividend module (COBOL) by changing data types used in dividend calculations and refactoring code. Changes resulted in a 50% reduction of CPU usage (usage was an hour on average per daily execution prior to the changes). Performed technical interviews on behalf of the department. Windows Server / Desktop Support - 5 years End to end Windows NT support for a building with about 1500 clients and 50 servers. Served as site manager for 2 of these years and supervised 15 technicians. Y2K compliance technical point of contact. Supervised an additional 20 consultants allocated to the project. There were no Y2K incidents when the new year occurred.



State of New Jersey

• Trenton, NJ

• Programmer / Analyst

  • Jun 1985 - Oct 1988

  Mainframe Developer Fire Safety, Rental Assistance, and Insurance systems. Assumed an advisory role within two years. Mainframe Developer Fire Safety, Rental Assistance, and Insurance systems. Assumed an advisory role within two years.