Experience

• 

  Keane, inc.

  Oct 1997 - Apr 2003

  Programmer analyst senior

  Programmer Analyst Senior, NYSEG Customer Information System teamJanuary 2002 - April 2003Member of base maintenance support team for the Customer Information System at NYSEG.Programmer Analyst Senior, NYSEG deregulation project teamJanuary 2001 – January 2002Applications developer on large deregulation project.Programmer Analyst, NYSEG Customer Information System teamMarch 1988 - January 2001Member of base maintenance support team for the Customer Information System at NYSEG. Promoted to Programmer/analyst senior within one year as I became primary support for the Field Service system.Programmer Analyst, Y2K Project, Mutual of New YorkOctober 1997 -March 1988Worked on Y2K contract at Mutual of New York (MONY). MVS system with IMS and DB2 database, written in COBOL. Show less

• 

  Cornell university

  Apr 2003 - now

  Development and operational support of data warehouse in support of university data analytics:• Development and maintenance of extract/transform/load processes. Primary tool is Wherescape, mainly working with source and target Oracle databases in the Amazon Cloud, also importing and exporting external JSON and CSV files using SFTP via Python scripting.• Development and maintenance of Python “backbone” process running on Windows, used by all data warehouse and staging loads targeting non-Oracle databases. This process handles -- Management of connections to various database platforms. -- Secure sign on using passwords stored in Amazon Secrets Manager and Keepass -- Index and grant housekeeping necessary for high availability of data marts. • Development and maintenance of PL/SQL “backbone” process which is used by all data warehouse and replication functions that target Oracle databases.• Development and frequent operation of process which quickly replicates or syncs metadata between development, test, and production Oracle databases, needed for migration of changes and creation of parallel environments for Oracle database upgrades.• After hours support of Attunity data replication processes. Source data is replicated from transactional systems, to provide static daily snapshot for consumption by nightly extract/transform/load processes.• After hours support of business-critical data warehouse nightly loads (primarily student data mart). Support of Opsgenie configuration, which will send alerts on failure of overnight processes, driven by email integrations, and provide voice/text notifications to personal cell phones on a team rotation• Work closely with customers to provide highly specialized data curation for the office of Institutional Research and Planning.• Support data marts including student, contributor relations, general ledger, facilities, as well as many downstream marts. Work with dashboard developers who consume these marts. Show less PeopleSoft Applications Support November 2008 – March 2015• Operational support of highly customized and mission critical PeopleSoft student applications, including integrations with HR and Payroll system. On call after hours support.• Maintain financial aid customizations for federal regulatory compliance and annual policy changes.• Coordinate vendor upgrades.• Project work as needed.Applications Developer on Student Systems ProjectJuly 2007 – November 2008Customize and implement PeopleSoft student systems at Cornell. Analyzed customer requirements and designed customizations to PeopleSoft Financial Aid components. • Federal and university loan promissory note servives.• Control the disbursement of federal funds based on student data from Department of Education.• Legacy data conversions• NY state financial aid award interface• Tax data verification using College Board's IDOC serviceService Manager for Financial Aid systemJune 2005 – July 2007Responsible for the all applications support and development for the Financial Aid Management System (FAMS) and Loan Management System (LMS). Primarily MVS systems with a VSAM database, written in COBOL with a CICS front end for on line processing.Programmer Analyst Senior, Legacy Financial Aid teamApril 2003 – June 2005Worked on the support team for FAMS and LMS. Show less

  • Business Intelligence Engineer

    Mar 2015 - now

  • Applications Programmer

    Apr 2003 - Mar 2015