Resume 7

• Convert Notes dB to Java based system. Modify the current Notes dB to allow for easier Export to Excel.
• Write Lotus Script Agent using ODBC to load multiple Microsoft Access dB s into a Notes dB. This procedure saves the clerk about 20 hours per month. Create a similar routine to monitor the number of personnel needed at each Day Care Center. This enabled management to reduce the number of staff at each center, saving the company several salaries.
• Create product that allows users to export their Notes Data to either Excel or an ASCII File. Design product using Lotus Script, and easily installed into any Notes dB. Allow users to pick template of fields, fields within the template, type of delimiters for multi-value fields, and what documents. Allow customization by programmers to include Computed for Display Fields, other fields from notes dB s and Notes Document properties. Product was advertised in the Lotus Advisor, Jan/2002 Issue.

• Create Web based Software Order system using Notes and Javascript to allow users to request software. Allow main user to export their data into excel to produce Pivot table reports showing amount of workloads, and reports by divisions approx. 200 users . This was developed under R5 of Notes.
• Support of key databases used by the investment department, Travel Management approx. 300 users , Listing of Profiles approx. 500 users , Institutional Client List 200 users , Company Meetings approx. 400 users . dB s were developed mostly with Lotus Script, using Script Libraries for standard routines. dB s were developed under R4.6 of Notes.
• Assist the Notes Administrator by developing dB to move dB s from the staging server to production; dB to read the notes directory allowing notes team to update the dB with key users, links to other dB s, scheduled agents and documentation. Write Lotus Script routines to mass update the Corporate NAB and users local NAB when the domain name changed. Agents developed using Lotus Script.
• Develop Lotus Script that allows the users to Load Notes dB s into an Access dB and Load Access Data into a Notes dB.
• Develop dB where users can import their Excel Workbooks into a dB that provides workflow capabilities. After Associates enter their information, which they can then send to Custody/Portfolio Associates and Accounting for processing. When the department finishes their work, the associate is notified that the work is complete. Create agents to notify the departments of when work is coming due, due that day and over due. Develop agent that notifies the associated when the enter batch of work is complete, and partially complete telling them what pieces are still not done . System tracks history of when emails are sent and who was notified. System handles money movements of major clients, usually moving over 1 million per transaction. approx. 300 users
• Develop agents to import data from legacy systems into Notes dB s. These agents can be run via the views or as scheduled agents. The agents send email on normal completion as well as failure. These routines were used to replace LEI and Repli-Action. All routines were written using Lotus Script.
• Wrote standard Lotus Script Libraries for use by other programmers to increase productivity.

• Install Lotus Notes for the company. First install covered about 600 people, with 6 servers. Connected satellite offices, 4 at that time with their own servers. Set up replica copies of key databases through out the offices. Oversaw the Notes Administrator and 4 programmers. Work with all Senior Management on implementation and scheduling of Notes for their departments.
• Decreased time to process a loan from 25-30 minutes per loan to 10-13 minutes, processing nearly 10,000 loans per month by using ODBC drivers to load data from Foxpro to a Notes dB. This allowed the Data Entry team to be able in increase the number of loans to be processed from 250 million/month to 650 million/month with no increase in staff. Agents were run at night sending out dB s to offices showing possible errors, thus correcting possible mistakes before the loan made it to the Servicing System.
• Lead team to bring imaging in house Domino.Doc , as of March 99 in final testing phase. 10 to 20 people expected in workforce reduction. Total cost of system will be under 400,000 imaging nearly 1 million documents.
• Implement Lotus Domino, provide senior management with key databases, e.g. Delinquency by Source, Funding by Date, Provide alternative lookups into CPI loan servicing system reducing the cost of looking up loans.
• Develop routines to load Notes Data into Access dB s. Develop/Train Sales force on how to use Access creating their own Queries.
• Eliminate 30-50 jobs using Lotus Notes to increase employee productivity.
• Implemented Help Desk to assist users who are having problems with hardware and/or software. Provide classroom training and one on one training.

• Worked closely with users and management to update/enhance the Subscription Services Program. This was an in-house developed package. The system was written in VAX Basic running under a VAX/VMS operating system. Provided training to staff to increase productivity. Decreased the amount of paper work by over 60 by providing Notes dB s to management and the Sales force. This allowed them to access/view the data without the need to carry reports.
• The Notes dB s were developed from R2 to R4 of Lotus Notes.
• Load VMS Data from RMS to a Notes dB for the Sales Staff. Provide simple Notes dB for groups.
• Provide support of software packages purchased, e.g. Great Plains Accounting and FAS Fixed Asset Accounting.
• Aided in moving software from VAX 8650 to 3100, resolved day-to-day problems modify command procedures.
• General Program Maintenance; investigated rounding problems; documented how and provided solutions to every day tasks; instructed European staff on how to use EDT to improve productivity

Bachelor of Science, Business Administration
Babson College
Major: Quantitative Methods
Minor: Accounting, Finance, Investments

Languages: Lotus Script, JavaScript, HTML Some C and Java
Lotus Notes Developer for 10 years

References: Available upon request