Sign in

Customer Service Test Cases

Bronx County, New York, United States
December 03, 2017

Contact this candidate


Shoshanna Goldfeld

*** ******* ****** *** *** Bronx, NY 10463



•A logical, analytical thinker with 15+ years of Oracle development experience

•Extensive experience and expertise in Banner Environment

•Proficient in SQL, PL/SQL Development, Tuning in an Oracle Environment

•Expert in Oracle Forms and Reports Development 11g, MS Access, Excel, Argos Reporting

•Proficient in HTML /HTML5.0, CSS, CSS3, JavaScript, JQuery, XML, Express

•Strong customer service orientation and support

•Other tools and technologies: TOAD, Git, Linux, Hiroku, Cloud9, SharePoint


Yeshiva University, New York, NY - Database Analyst / Programmer May 1999 – Feb 2017

University Banner Reporting:

•Designed and developed department specific reports using Oracle Forms/Reports 11g:

•AYUSTAR – alumni and student information reporting system, which included variety of mailing reports and statistics

•SHYTRAN – official student transcripts generator

•YUTODAY - a quarterly e-publication distributed among board members, alumni, contributors, and parents of students

•AYUSECR - security reports that generate users privileges based on selected parameters

•FRYBRUN (Grant Billing Reports) - produces comprehensive information about grants

•Online Undergraduate Housing Reports – provided personal and emergency contact information, student living, study habits, etc.

•Designed and developed Argos based Admission, Registrar and Housing data blocks and reports to replace legacy MS Access based functionality.

•Developed variety of widely used reports for Bursar, Financial Aid, Finance, HR as well as specialty reports based on specific user request.

University Banner Strategy, Design and Development:

•Participated in the development of the University Application Platform based on Banner system using SQL, SQL Loader, and PL/SQL Scripts.

•Worked closely with internal/external customers during product integration and deployment to integrate systems and processes during university-wide transition to the new Banner Student/Financial Aid/HR/Finance modules.

•Created and modified Oracle views, functions, stored procedures, packages and tables to fulfill the requirements.

•Created migration plan to convert security data from legacy system into Banner.

•Developed and tested programming code. Created test cases. Provided proper traceability from business requirements to test cases using SQL queries.

University Operations and Support:

•Supported Banner users by managing inquiries, analyzing and solving problems in real-time.

•Responsible for security and user maintenance for various systems.

•Assigned and reviewed user security. Defined users access rights.

•Organized Banner objects into job responsibilities unique to each department and organization.

•Implemented Distributed User Security profiles. Produced various security reports.

•Secured reporting system by implementing Fine-Grained Access Control (FGAC).

•Loaded employee and finance details from existing excel files into Banner tables.

•Created technical and functional documents for new software installations/upgrades.

•Supported and troubleshooted any problems end users might have when using the production application.

•Interacted with clients to understand processes, analyzed business requirements, provided

solutions and estimations, conducted design and code reviews.

•Also worked on incident tickets assigned during production support whenever there was a need.

Luminis Administrator, Development and Support:

•Developed, customized and maintained various Luminis pages; created new portlets, troubleshooted Glassfish, Portal and CAS servers.

•Developed login pages for all the employees and students by integrating with Gmail, Kronos, OBIEE, Canvas, Maccabuy authentication.

•Loaded XML data into database tables.

•Developed new YU Luminis themes.

•Created and customized JavaScript, CSS and HTML scripts.

•Maintained LDAP users and system parameters database.

•Designed and maintained Luminis triggers, stored procedures, tables.

•Managed Self Service Banner: Developed and customized Web Menus, maintained Channel Preferences.

•Participated in Luminis conversion from 5.03 to 5.22.

•Ensured consistency between Banner and Luminis Users/Roles creation and management.

•Created and maintained Luminis Test Environment.

•Developed specifications based on user requirements.

•Consulted and provided guidance to users in Finance, HR, Student, Procurement and other university departments.

•Responded to all incoming questions and inquiries related to Luminis application.


New York Code & Design Academy, New York, NY Feb 2017 - Jul 2017

Part-Time Web Development Intensive

Long Island University, Brooklyn, NY Sep 1999 – Jan 2000

Select Courses in Computer Science

Prime View Professional Training Program, New York, NY Dec 1997 – Sep 1998

ORACLE Database Developer

CUNY, Hunter College, New York, NY Sep 1994 – Jun 1997

Bachelor of Science

Contact this candidate