Denise Prendergast Email & Phone Number

Develop crystal reports for the environmental health group. Support Envision Connect application.

Davis, CA

Contracted to UC Davis to convert reports developed in Power Builder/Infomaker over to Crystal Reports.Converted sql to stored procedures, documented, configured, uploaded and tested reports on SharePoint.

San Francisco Bay Area

Updated client Clinical trial databases via SQL statements and stored procedures (300 possible databases). High volume of transactions.Required extreme attention to detail, long hours and weekends and high volume of transactions into a production environment.

San Francisco

Worked as a Programmer Analyst contractor for TEK Systems supporting Peoplesoft’s Campus Solutions for Heald College campuses at their headquarters in San Francisco.Fixed peoplecode issues, application engine programs, crystal reports, sqr’s, and developed complex query extracts for business partners via sql server.Developed scripts for locking out.

Los Angeles, CA

Temporarily moved to Washington State-tri cities area. Developed dashboards, and was responsible for implementing their BI software tools into the development, test and production environments.Worked as a dashboard developer for Knowledge Relay (a software company who develops Business Intelligence tools) at the Department of Energy.Acted as liason between.

Contracted at Mal Warwick in Berkeley for Robert Half International to maintain and develop crystal reports. Tasks included analysis of complex functions/stored procedures in PostgreSQL. Updated data regions for 20 excel charts and migrated to a word document. Converted complex 18 page report from Foxpro to Crystal. Skills: Crystal reports XI, PostgreSQL.

Subject matter expert for the peoplesoft CRM application, promoted to Lead analyst in 2007. Managed monthly release changes, performing code and document reviews, for implementing the changes into production. Troubleshooted production issues, triaged, and prioritized fixes.Made recommendations to improve application usage.Peoplesoft CRM Senior Programmer.

CRMSubject matter expert for the PeopleSoft CRM application, promoted to lead analyst in 2007. Analyzed, documented, developed, enhanced and implemented changes utilizing PeopleCode, application designer, Integration broker technology, and dms scripts. Authored functional and technical specifications, change management, SDLC, test cases, troubleshooted.

Contracted at Kaiser remediating programs to become Y2K compliant. Visual basic, access, oracle, foxpro, dbase, pascal, crystal reports, paradox were some of the many applications requiring remediation. Some required upgrading to new versions. Utilized versioning control software.

Developed and maintained T-SQL scripts for building a data warehouse from legacy systems. Developed crystal reports for HR Executives.Environments: Crystal reporting, Microsoft sql server, Transact Sql, Visual Basic, Microsoft Access Database development, IBM Platinum Queries and extracts.

Entered and verified cobol programs, weekly payroll, name and address changes etc as needed on Nixdorf equipment. Transmitted nightly to our data center.Transferred to the port engineers department due to lay-off, and duties included providing administrative assistance to 12 port engineers, answered phones, handled incoming and outgoing mail, updated.

Peopletools, Peoplecode, Helpdesk For Hr, Intro To Hrms, Application Engine

Certificate, Management Information Systems

I completed an Extended Education program at Cal State University Hayward which encompassed desktop applications, project development.

Sql, Architecture & Admin,

Visual Basic 6.0

Education record

Education record

Intro To Unix

Winrunner