Programmer Resume
NJ
TECHNICAL SUMMARY
Concepts: Problem Analysis, Data Analysis, Data Integrity, Structured Programming Design and Techniques, Object Oriented Design, Debugging, Testing Plans and Procedures, Database and File Manipulation.
Hardware: PC’s and IBM 3090 Mainframe
Software: Microsoft Access, VBA, VB.Net, Visual Basic, ASP.Net, C++, FTP, DB2, SQL, SQL Plus, PL/SQL, Crystal Reports, Oracle 9i, COBOL II, COBOL, MVS JCL, TSO, ISPF, Syncsort, VSAM, PC Dos, UNIX, Intro. To CICS, Intro. To Java, Powerbuilder 5.0
PROFESSIONAL EXPERIENCE
Confidential,Parsippany,NJ - Charge Back Services Specialist / Programmer 2006 – 2010
- Maintained in house Microsoft Access 2003 applications writing VBA code and SQL.
- Validated the accuracy of data files and reports before delivery to the client.
- Managed and integrated usage based charge back clients into appropriate programs.
- Integrated data from PBX’s and various telecom vendors into in-house AS400 I-Series based system.
- Conducted on-going analysis on clients’ polled data to identify any uncommon dial patterns, call routing, call volume increases/decreases as well as usage increases/decreases to ensure the service is meeting the business and financial needs of the client
Confidential,East Hanover, NJ – Programmer Analyst 1996 – 2005
Wrote Microsoft Access 2003 VBA code along with SQL doing coding, testing, and debugging for the following in-house applications.
- NPAX (Access Application) – A company sponsored VISA credit card, also created user manual in Word for this application.
- Script Data (Access Application) – This was a Clinical / Financial utilization tool. Downloaded processed data from mainframe, and used Script Data to build an application also in Access that allowed the client to view reports and graphs of their data. Also did total Y2K remediation and testing of this application. Created user manual in Word for this application.
- Project Time (Access Application) – IT Department application used to track time of IT staff against projects assigned. Created user manual in Word for this application.
Designed Crystal Reports and SQL against DB2 backend on server for Data warehousing initiative.
- Wrote several mainframe extracts to bring client data down to DB2 database on server, and ran DB2 load scripts to load data onto data warehouse.
- Designed reports / SQL queries along with team members using Crystal Reports as requested by users.
- Lead person in charge of monitoring the accuracy of the data in the data warehouse, setting up new users in the system along with security settings. Point of contact for issues with users, and training new users.
- Created each manual in Word for both the users and developers on this system.
Designed programs using COBOL II, VSAM, JCL, Syncsort for data decommissioning project.
- Worked along with team members writing programs to extract data from old mainframe (NPA’s) (including transforming IDMS hierarchical data into flat files) onto cartridges to be sent to new parent company (Express Scripts) to make client data available.
- Check points were placed in code to verify accuracy of the extracts.
Confidential,Whippany, NJ – Programmer Analyst 1995 – 1996
Coded in Visual Basic 3.0 and 4.0 in a Windows environment to work on company developed software TOPAZ PC/PO Professional Procurement System. This application was made up of multiple modules. Applications ran on client/server LAN.
- Responsible for designing, coding, testing and debugging of TOPAZ software.
- Responsible for light customer support.
Confidential,East Hanover, NJ - Computer and Data Support 1987 – 1995
Utilized IMS BASIC 6.0/IMS Query v2.3 in Unix environment.
- Assisted in all computer related functions.
- Assisted in the development of user specific query reports.
- Responsible for maintenance of hardware for 5 different on-site computer systems.
- Responsible for proper entering / billing / crediting of customer’s orders.
- Maintained and updated customer’s discount contract files.
- This position required extreme attention to detail, for which I was commended for 7 consecutive yearly reviews.
Confidential,NJ – Technical Help Desk 1986 – 1987
- Troubleshooter / Help Desk.
- Initial analysis of hardware / online / batch problems.
- Worked under limited time constraints ensuring all work was completed by deadline with quality and the proper resolution.
EDUCATION
MS Access, VB, VB.Net, ASP.Net, Oracle 9i, PL/SQL, C++, C, Unix, Java, Foundations of Information Security, Management of Information & Security Systems, Network Security
Received certificate for completion of Information Security program.
