Data Human Resources

Revathi S. Joshi

** ********* ** ****

Warren, NJ 07059

Mobile 908-***-****

e-mail – ***********@*****.***

Summary Nineteen years of sound knowledge in relational database design and development in

Oracle. Possess good communication and interpersonal skills, problem solving and

analytical abilities. Enjoy working standalone and in environments.

Hardware Apple Mackintosh, IBM Compatible PCs.

Software Oracle 11.2.0, SCT Banner Applications, Raiser’s Edge, SQL, SQL*Net, PL/SQL, SQR,

Resource 25, Resource 25 Web Viewer, Oracle Discoverer, MS Office, InConnect.

Systems UNIX, MS-DOS, MS Windows 2007, Windows NT.

Education MS (Zoology), Hyderabad, India.

2 years of intensive course in Database Application, Development and Design, Columbia

University, NY

Training Banner 2000 Web Programming & Development at Malvern Pennsylvania.

Experience Teacher’s College, Columbia University, New York, NY.

June 1999 – June 2012

Programmer/Analyst.

Working with Oracle Database in SCT’s Banner modules – Office of Registrar

Room Assignment Department/R25, ALUMNI, HOUSING and Human Resources..

Providing main support to Office of Registrar Room Assignment Department as R25 Admin, and R25 Functional Admin.

Support of R25, the Room Assignments system. Worked with Room

Assignments to provide initial room assignments for the Summer,

Fall and Spring terms.

Created a master photo database of all assignable rooms and their dimensions

that will be made available online (via web viewer) as well as in

Resource 25.

Worked with DBA to move R25 to a new PROD server (GAUDI); upgraded

Oracle Client to 9.2.0.8 on all workstations, including patches.

Installed and configured R25 v33 and its patches.

Installed, Configured and Automated Interface between R25 and SIS (Banner

Student Database) for Scheduling classes.

Installed and Configured R25 Web Viewer which accesses R25 Database and

allows the users from the internet to view classes, available rooms, and news.

Supported changes and additional room assignments after beginning of term by

making changes and running daily reports.

Provided Training to new employees for Room Assignments in Registrar’s

Office and continued support to three scheduling officers.

Installed, Configured, Maintained, Applied Patches and Upgrades R25 and its

various components on the TEST & PROD servers.

Installed and Configured R25 v3.3.1 on the TEST Server.

Upgrading R25 to V3.4.

Supported information system needs of the Development office, mainly through the Banner Advancement Module.

Implemented option in Banner Web for Alumni Gift giving without normal

Banner login. This required extensive modification to the SCT web

functions to satisfy user requirements.

Written Online Web Programs for various departments for Gift giving.

Modification of Alumni Web for Email Forwarding and directory structures.

Developed a program to update area codes based on files from outside sources.

Made changes to in-house scripts to run via Job Submission.

Converted views from Banner to more useful SQR programs.

Created jobs to load pledge data into Banner tables for every appeal.

Enhanced gift records by consolidating IDs as needed.

Updated Banner tables with new data sent by Harris Publishing Company. (A

major effort involving new tables and many SQR scripts.)

Periodically updated Banner tables with address changes and phone changes

based on files from NCOA after every appeal.

Installed latest version of Web for Alumni in TEST/PROD DB in preparation for

implementation.

Modified many in-house reports and scripts for Alumni to meet user

requirements.

Assisted in maintaining reports for Alumni staff.

Responsible for moving the Alumni data to Raiser’s Edge. A major effort

involving extensive creation of scripts, shell scripts.

Support collaboration between Alumni and Career Services Offices. Modified many web programs.

Providing primary support to the Housing and Residential Life Office.

Implemented option in Banner Student Module for Online Vacate Notification

Form, if the residents (students) are planning to leave Teachers College.

Supported opening of New Residence Hall and the addition of International

House with new and updated procedures.

Improved interfaces between Admissions and Housing.

Implemented entry of family members into Banner as affiliates, and modified

reports to include them.

Made changes to in-house scripts for processing via Job Submission under

Banner GUI.

Modified and tested reports as requested by Housing.

New package for Online Request For Lock Change for Residents. Upon

Submission emails are sent to the Resident and Housing office.

New package for Online Photo ID Request for Students, Contractors, University

Affiliates, Visitors and Service Technicians.

New package for Online Incident Report Form for Students.

New package for Online Request for Housing Contract Renewals for Residents.

This includes User Fill-in packages, Student Look-up Packages and Admin

Look-up Packages. A major effort involves in creating tables, constraints and

Procedures. Integrated with Online Request Form for deleting Student

Affiliates and Pets and an Online Lead Paint/Window Guard Fill-in

Form (required by Law).

New package for Online Request for Faculty License Renewals. This also

includes User Fill-in packages, Student Look-up Packages and Admin

Look-up Packages. A major effort involves in creating tables, constraints and

Procedures. Integrated with Online Request Form for opt-in and opt-out

Payroll Deduction Form and an Online Lead Paint/Window Guard Fill-in

Form (required by Law).

Responsible for maintaining CLEAN ADDRESS

Installation, configuration and maintenance of CLEAN ADDRESS packages and

forms from Runner Technologies. With CLEAN ADDRESS, the user cannot

update his/her address without accepting the “Suggestions” as outlined in the

CLEAN Address packages. These “Suggestions” are written as per the USPS

standards. For eg. On Address Line1 = 325 Clinton Ave, on Address Line2=

Apt 6D, then Line2 gets appended to Line1 and is shown like this on Line1=

325 Clinton Ave Apt 6D. This will enable the Office of Registrar to print out

address labels correctly on the envelopes.

Installed, Configured and Maintained the CLEAN ADDRESS on the TEST

server as well.

Applying Updates to CLEAN Address periodically (every 3 months) to get new

data (name and address) from USPS.

Did many in-house modifications and testing to the Banner name, address, email

and telephone Packages, as per the user specifications before it went into

Production.

Red Flag Notifications

Automated the process for sending out Red Flag Notification emails to the

Students and Employees when their existing name, address, email or

telephone numbers are changed in Banner.

Automated the process to send out emails to the Registrar, and Human

Resources Departments and receive the daily file for CLEAN Address

Updates by user as an email attachment.

Emergency Notification System - ENS

Installed, Configured and Maintained InConnect – the software for ENS in

TEST and PROD. Did Upgrades and applied Patches as well.

Wrote a Web package which enables students, faculty or staff to submit an

Opt-in/opt-out for university-sent text messaging for Emergency Notification

System. Send TC Alert notification to such “Newbies” group welcoming to

TC Alert. Collects their phone numbers, whether SMS (TEXT) or

Work Phone (Voice) for ENS and they are stored in the table based on their

Telephone Types.

Automated a program to collect data from Banner Database for 18 groups of

such “Newbies”. It will then process the data file into the Mir3 system via

the InConnect software thru a batch process which performs some

verification of prerequisites and initialize logs prior to initiating batch

processing of data into the Mir3 database. Additionally, post processing

verification will be performed to identify, report, and address error

conditions. Lastly, it will write a summary report to standard out. This

program also sends out SMS (TEXT) or Work Phone (Voice) messages to

“Newbies” based on their error conditions so that they can advise their

phone carriers to allow Notifications from TC Alert.

Supporting data integrity effort.

Worked on merging multiple ID’s and deleting bad data from Banner tables.

Providing backup support for Student Module.

Providing backup support for credit card processing.

Producing and sending the credit card settlement reports to the users.

CompuSoft, Inc., New York, NY.

January 1998 – May 1999.

Project Experience –

Analyzed and identified functional sub-systems, and wrote project requirements

and business and technical specifications for the automation of the business

with a relational database.

Produced event list, Data Flow Diagram (DFD), and Data Repository using System

Architect.

Designed a normalized logical model: Entity Relational Diagram (ERD).

Implemented complex business rules by means of triggers and subprograms stored in

packages on the server.

Memorial Sloan-Kettering Cancer Center, New York, NY.

September 1992 - December 1997.

Inventory Management and Sales Ordering System

Developed IMSO system for the neuro-oncology lab.

System Analysis.

Report preparation and verification.

Analysis and bookkeeping.

The system was designed to maintain stock levels of new and existing items, chemicals and lab supplies. Enter sales orders for laboratory and receive orders.

Environment: SQL and EXCEL

Senior Research Technician / NeuroOncology Lab

Cell Culture Techniques (rat and mammalian cell lines) and transfection,

Histological techniques, immunohistochemistry (including multi-label IHC),

Histochemistry (B-Gal stain).

Contribute data for publication/presentation (abstracts) in international scientific journals

and conferences.

References Available upon request

Contact this candidate