Post Job Free

Resume

Sign in

Application/Database Analyst

Location:
Derry, NH, 03038
Posted:
March 16, 2010

Contact this candidate

Resume:

Gregory A. Stuart

* **** ******

Derry, NH ****8

(603) 216- 5674 my530y@r.postjobfree.com

OBJECTIVE: To obtain a growth oriented position in the field of Information Systems.

QUALIFICATIONS: Over ten years of comprehensive IT experience analyzing, developing and managing databases in a variety of corporate and institutional environments. Skilled in various applications including Microsoft Access, Microsoft Excel, Microsoft Project, Oracle and SQL

RELEVANT

EXPERIENCE: Monster Worldwide Technologies Feb. 2007 – Feb. 2010 Maynard, MA

Project Server/ProSight Administrator and Reporting Analyst

 Responsible for the administration and maintenance of the Project Management System (ProSight)

 Responsible for the administration and maintenance of the Resource Management System (Project Server)

 Monitor communication between Oracle, ProSight and Project Server

 Designed and implemented reports using Microsoft Access databases

 Designed and implemented reports using Microsoft Excel spreadsheets

 Responsible for various Month End Management reports

 Responsible for the internal training and support of Oracle, ProSight and Project Server applications

 Responsible for maintaining and updating user documentation for Oracle, ProSight and Project Server

 Responsible for updating and publishing the company Organizational Structure

 Responsible for creating and updating Project data within Oracle, ProSight and Project Server

 Responsible for giving Employees access to Projects within Oracle, ProSight and Project Server

 Responsible for creating, maintaining and updating the GPMO Sharepoint site

Lowell General Hospital Oct. 2005 – Feb. 2007 Lowell, MA

Decision Support Analyst

 Responsible for the creation and maintenance of Healthcare contracts

 Monitor daily information interfaces between Patient System and Contract System (HCC - Oracle)

 Designed and implemented reports for several departments using Business Objects and Microsoft Access

 Responsible for various Month End reports

 Worked with Patient Accounting to simplify their business processes

 Assisted with the Budget process for the hospital

 Responsible for maintaining and updating of user documentation for the Contract System

Sullivan & Worcester LLP Nov. 2001 – Oct. 2005 Boston, MA

Database Analyst/Programmer

 Responsible for database administration of SQL and Microsoft Access databases

 Designed and implemented queries, forms, and reports in Microsoft Access databases (97 and 2000)

 Responsible for the management and maintenance of Cost Recovery Systems (Equitrac and Bill Back)

 Assisted in the client, matter, and timekeeper input processing for Time and Billing system (Elite)

 Designed and implemented reports in Business Objects

 Responsible for the processing and maintenance of EDI (Electronic Data Invoice) processing

 Responsible for the distribution and collection of personal disbursement accounts (Personal codes)

 Assisted in a conversion from WSI to Elite Time and Billing system

 Assisted in a conversion from Equitrac to Bill Back Cost Recovery system

 Assisted in the check input processing with the Collections department through Elite

 Assisted in the billing of clients through Elite

 Responsible for the maintenance of bill formats (Document Studio)

 Responsible for the creation and distribution of Management reports and surveys

 Assisted various users across the entire firm with technical support and report requests

 Designed and implemented data flow charts for new applications

 Responsible for testing new applications before going live

 Assisted in the creation of a data warehouse

Zoots Jun. 2000 – Oct. 2001 Newton, MA

Applications/Financial Systems Analyst

• Responsible for the loading and maintenance of a multi-dimensional database (Pilot Software)

• Designed and implemented queries and stored procedures in SQL and Microsoft Access

• Responsible for database administration of SQL and Microsoft Access databases

• Designed and implemented ASP pages

• Designed and implemented reports using Crystal

• Responsible for the financial reporting aspects of the company

• Managed and assisted credit card processing using ICVerify Software

• Assisted with the maintenance of the Great Plains Software

• Assisted with the maintenance of the ADP Oracle Software

• Responsible for the testing and maintenance of Spot (DOS/2000) Retail Software

• Assisted users across all departments within the company with technical support and report requests

Accountemps: Jun. 1997- Mar. 2000 Lexington, MA

Andover Coated Products Inc. Salisbury, MA

Scheduling Manager

• Scheduled the daily production of products.

• Managed inventory control.

• Assisted in the implementation of Total Quality Management Program.

• Responsible for insuring that daily production schedules were met.

Dynatech Corporation. Burlington, MA

Database Administrator

• Assisted in the implementation of an investment portfolio system in Peachtree.

Howland Development Company. Wilmington. MA

Database Administrator

• Researched and maintained accounting data in their systems, Peachtree and ATB.

Vestcom of New England. Woburn, MA

Database Administrator

• Researched and maintained accounting data in their system, Peoplesoft.

ConCentra, Managed Healthcare. Waltham, MA

Database Administrator

• Researched and collected health insurance data; maintained this data in Oracle.

POSCO Inc. Wilmington.MA

Database Administrator

• Collected and organized accounts payable and receivable : maintained data in, SBT.

ATC Associates. Woburn, MA

Database Administrator

• Collected and organized accounts payable data; maintained this data in , SBT.

Cabot LNG, Distrigas Everett, MA

Database Administrator

• Modified and upgraded daily gas supply spreadsheets in Excel.

Other Work Experience: Part-time work at Rite-Aid, Bob’s Store, and Market Basket

EDUCATION: Fairfield University, Fairfield, CT

Bachelors of Science - Management Information Systems, Minor in Accounting GPA: 3.3

Computer courses completed in SQL, Microsoft Word, Microsoft Excel, Microsoft Access, HTML and Java

Accounting courses completed in Financial Accounting, Managerial Accounting, and Cost Accounting

Conferred: May 2000.

REFERENCES: Furnished upon request.



Contact this candidate