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 students for each conversion to campusvu.

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 the customer (Department Of Energy), and Vendor (Knowledge Relay) for implementing their software tools. The toolsets were Information visualizer, Talend (ETL tool), Job Scheduler, idashboard.Approximately one third of my time was devoted to writing test cases for the dashboards and software products being implemented. Tested ETL scripts from Primavera to their datamart to support their reporting data needs.

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, user defined functions, stored procedures, database analysis, gathering requirements for PHP Web based application.

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 Analyst (2004-2007) Troubleshooting production issues, analyzing and developing peoplecode, application packages, components, application engine, integration broker, application messaging, dms scripts, configurations and workflow events. Discussed bugs found by testing team, triaged bugs to developers, followed up and reported status to Project team. Peoplesoft HRMS Senior Programmer Analyst (1999-2004) Developed, tested, and documented SQR programs, crystal reports, dbase objects etc and lead technical walk throughs with business partners. Developed UNIX scripts to FTP files created by SQR’s. Developed automated winrunner programs for updating HRMS application.

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 production issues including integration problems. Created procedures and training manuals depicting business and system configurations. Designed mock application screens. Modified and enhanced HCM and CRM application package PeopleCode to display additional fields to the 360 degree view, saving Call Center Users time and increasing call volume by 30%.Modified and enhanced application package PeopleCode to resolve third party CTI integration issues resulting in keeping our project on target.Modified component PeopleCode to display user's name on all case pages instead of their logon id's, increasing user's visual experience and clarity.Developed DMS scripts for migrating configurations, email templates, security tables, resulting in reusability, and saving programmer resourcesModified channel partitioning increasing application message throughput by 50%.

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 budget spreadsheets, made travel arrangements, provided word processing for entering drydock specifications, memos, faxes etc. as needed by engineers. Researched and resolved engineering invoices. Microfilmed and indexed engineering documents and invoices.

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