SUMMARY:

• Analytical, problem - solving computer Programmer Analyst, with 20+ years’ experience, seeking a position where my skills and noledge to design and implement innovative and efficient technical business solutions, and evaluate new and updated computer programs can be applied.

TECHNICAL SKILLS:

Languages: C, C++, Java, JavaScript, COBOL, HTML, DHTML, VBA, SQL, AWK

Platform: Windows, Unix, Linux

D Confidential base Systems: Oracle, MySQL, SQL Server, PL/SQL, Oracle ProC

Report Writers: ARGOS, Crystal Reports, COGNOS

Tools: Oracle Scheduler, Automic (UC4), Netbeans, Eclipse, IntelliJ, Toad, SQLDeveloper

PROFESSIONAL EXPERIENCE:

Confidential

Programmer Analyst

Responsibilities:

• Enhancing PL/SQL packages as per requirements by finding where the and what was needed to make the required changes
• Unit Testing these changes by mocking up test d Confidential .
• Trouble shooting INC tickets dat involved PL/SQL defects submitted by users in Service Now
• Used Subversion Software, Visual MQ to place files on que for Informatica Workflow processes to pick up and load into Oracle Tables and Informatica GUI to start and stop Workflow processes.

Confidential

Programmer/Analyst

Responsibilities:

• Recommended and implemented Oracle Scheduler, a solution to run batch jobs at night
• Designed, coded and implemented the Disbursement process for Financial Aid.
• Implemented a Java class dat produced a directory listing. This was compiled in the D Confidential base and wrap in PL/SQL: so dat it could be called from any PL/SQL procedure.
• Involved with integrating Banner with University Housing Software, Simplicity.
• Assisted in designing, coding and implementing ARGOS reports.
• Modified and enhanced existing COGNOS reports for various departments

Confidential

Responsibilities:

• Migrated a script based report application from AIX ( Confidential ’s UNIX) to a Linux OS. Wrote a brief spec breakdown of the 122 programs, extracting the main sql for use in an ARGOs report.
• Among the 122 programs were 20 ProC programs which had to be recompiled and modified to run on the new platform. There were issues with using strcpy and getenv functions which initially caused a segmentation fault. I debugged using gdb and modified the code to get rid of the segmentation fault.
• Wrote a procedure to extract d Confidential from Banner into an XML file. Also offered another solution to the Client for Windows by writing a Java based desktop application to accomplish the same result.

Confidential, Somerset, NJ

Responsibilities:

• Created and modified PL/SQL packages for D Confidential extraction and Integration of third party products with Banner.
• Converted Microsoft Access queries to Oracle SQL and tuned the queries for better performance.
• Modified Pro C. programs to extend baseline solutions for a particular client requirement. This involved re-writing and recompiling new versions of the baseline code.
• Design, coded and implemented reports using ARGOs by creating Banded Reports as well as OLAP Cubes
• Wrote sqlPlus scripts for extracting Student Registration Information.
• Helped Financial Aid in creating rules in BANNER.
• Used performance tuning tools to analyze queries dat were running inefficiently, and made modifications for improved performance.
• Designed, coded and Implemented small Java Desktop Applications:
• GPA Calculator
• Program to put math remedial courses in an Excel Spread Sheet.
• JSP servlet application to connect to NJTransit Website for student discount tickets.
• Worked with Student, Financial Aid, Accounts Receivable, and HR

Confidential | Philadelphia, PA

Programmer Analyst

Responsibilities:

• Bedrock QA support-Testing Confidential High Speed internet provisioning.
• Project GP implementation AstraZeneca D Confidential migration using C/PL/SQL to read information from one set of Oracle 8i tables and insert them into another.
• SQL performance tuning using SQL TRACE and Oracles explain plan.
• Wrote Oracle triggers dat would flag newly updated records.

Confidential | Clark, New Jersey

Software Engineer

Responsibilities:

• Design and code enhancement to OSS (Operation Support System) for Verizon In C++ on an Confidential Risc 6000 platform running Confidential ’s AIX. The enhancement involved creating trouble ticket for customers having problems with Verizon’s networks. Trouble-Ticket handle codes were to be populated by the enhancement.
• Develop screens for GUI using Confidential ’s Visual Age for C++ (OS/2) composition editor for Verizon’s southeastern region. The GUI was used by CLEC’s in the North East.
• Maintain the existing GUI in the North East (Bell Atlantic)
• Design and code other enhancements to other existing OSS for Bell Atlantic.
• Re-engineer RETAS which was written and maintained in C++ and converting it to Enterprise Java 2 platform creating EJBs through inheritance, building java utility programs, building EJBs dat extract information from Oracle D Confidential bases.
• Build a front end GUI for the previous system using JSP’s Servlets
• Production support for installation of applications
• SQL performance tuning using SQL TRACE and Oracles explain plan.
• Write Oracle triggers dat would flag newly updated records.Available on request.