Shira Jacobson

• Worked closely with clients to establish specifications and system designs.
• Identified causes of issues within applications and determined which modifications needed to be made.
• Performed regression and system-level testing to verify software quality prior to release.
• Authored code fixes and enhancements for inclusion in future code releases and patches.
• Directed software design and development to meet client needs for functionality and performance.
• Provided technical support using knowledge of complex technology to solve problems and support new projects.

• Converted an older reporting system to an extensive online user interface for viewing case exceptions. This process was based on an older system which ran in batch to produce exception reports for users. I developed and interactive version of this process utilizing sql embedded RPG for selection which created an exception report which was presented to the user via a subfile screen. I documemted and maintained this system for the client, and was involved in updating the system with new exceptions as per request.
• Worked with other business analysts to develop specifications for large and small IT projects based on meetings with end users. Successfully translated users needs into technical spec documents.
• Worked with cross-functional design teams to create software solutions that improved overall functionality and performance.
• Wrote and maintained RPG/RPG LE, RPG free and SQL embedded RPG programs and CL code as a contractor for a midsize legal/collections firm
• Designed and Developed a new online system where collections personnel could view data exceptions in an online format on the iSeries AS/400.

• Developed an emergency response process to enable University wide alerts in cases of emergency. Was involved in this project from the planning and specs through implementation and then regular maintenance. The project involved extensive meetings with user groups on various campuses for each campus’s particular requirements, and built in logic for each campus into the process. I was responsible for creating the general specs for this process, coding the procedures and functions in PL/SQL, creating test plan with real test case scenarios, parallel testing and implementation. I was also responsible for creating extensive technical and non technical documentation for the process. After implementation, I was responsible for maintenance which involved tweaking the logic and documentation as per request by various user groups.
• Worked as technical business analyst to convert user needs into functional/technical specifications for projects
• Wrote and maintained RPG/RPG LE programs and CL modules on iseries/AS400 for college registration and admissions modules and requested special projects
• Participated in a major conversion effort from legacy iSeries/AS400 to Oracle. Wrote conversion programs in RPGLE to create conversion tables for import to Oracle
• Analysis of existing admissions modules for use in conversion to new Jenzabar module
• Systems Support in the off hours for iSeries/AS400 batch overnight processes
• Created programs for customized functionality for various university departments using RPG/RPGLE on legacy iSeries/AS400 system
• Troubleshoot issues on legacy AS/400 system
• Create reports for analytics using Cognos, Tableau as well as excel pivot tables and V-lookup
• Extensive testing for conversion to new admissions module
• Created flowcharts to document project specs
• Followed through on project life cycle through specification, design, unit testing and debugging, and promotion from TEST to PROD environment.
• Write and develop Cognos reports for conversion to Banner system.
• Meet with user groups in various departments to determine technical specifications and needs for ad hoc requests and ongoing projects
• Develop and maintain new and existing stored procedures in Oracle using PL/SQL as necessary for various college projects, and department needs
• Update and maintain various Oracle objects (tables, views) as per request by user groups throughout the College
• Write and develop Pl/SQL scripts for reporting off of Banner/Oracle upon request by user
• Develop documentation for new and existing procedures