Experience

Aqua America

• PL/SQL Programmer

  • Jul 2017 - Present



Montclair State University

• Senior Programmer/System Analyst

  • Aug 2002 - Jun 2017

  Higher EducationMy duties are:a)Supporting/ Developing/Testing Ellucian Banner Student ERP System for 2 years – extracting data from BANNER Student Oracle data base using PL/SQL, Scheduling several PL/SQL jobs using Automic (UC4 or APPWRX), some support of Degree works, through knowledge of Internate Native Banner(INB), some reporting through COGNOS. Worked on Banner Recruiter, Admission and Registration systems.b)Supporting/Developing Montclair State University’s Learning… Higher EducationMy duties are:a)Supporting/ Developing/Testing Ellucian Banner Student ERP System for 2 years – extracting data from BANNER Student Oracle data base using PL/SQL, Scheduling several PL/SQL jobs using Automic (UC4 or APPWRX), some support of Degree works, through knowledge of Internate Native Banner(INB), some reporting through COGNOS. Worked on Banner Recruiter, Admission and Registration systems.b)Supporting/Developing Montclair State University’s Learning Management system CANVAS using data feeds extracted from Banner Student database by PL/SQL in CSV formats and scheduling them through Linux CRON jobs. Sound knowledge on Linux commands.c)Developing some COGNOS reports based on Banner student data.d) Implementation/testing of 25LIVE system ( student class scheduler) in Banner providing data from SCT+ system through FOCUS program.e)Supporting /developing some in-house JAVA applications using Eclipse, Java 7, Tomcat , J2EE technology with struts-2 framework and Linux servers.f)Supporting /Developing Ellucian SCT+ Student system for 13 years using VAX COBOL, reporting tool FOCUS, developing CRYSTAL reports from our internally developed operational (ODS) database in SQL SERVER.g)Supporting/Developing ACA (Affordable Care Act) programs in XML formats using VAX COBOL.h)Supporting/Developing Montclair State University’s Learning Management System BLACKBOARD generating feed files from Student system , HR system using FOCUS , CRON jobs during the period 2002 through 2012.i)Extensive technical support to MSU Students, faculty and various departments specially Registrar’s office.j)Converting several PL/1 jobs to VAX COBOL, to get rid of renewing PL/1 compilers license. Show more Show less