Senior Database Analyst and Administrator for the university’s Administrative Systems Renewal project implementing Peoplesoft Financial, Material Management, Human Resources, and Student Administration. Steered the databases from Peoplesoft install through go-live of the Financials implementation phase, including a successful switch to the standby database when a microcode bug caused block corruptions.

Responsibilities:

Provide overall leadership and technical support for all core system (PeopleSoft – Financial, Materials Management, Human Resources and Student Administration) database services
Ensure that external and internal regulations and policies governing data management are met including regulations concerning security, auditability and privacy.
Supervise, mentor and train other database staff.
Plan and coordinate database security measures and access controls.
Monitor the production database, application server, and web server and tune long running queries and processes.

Achievements:

Immediately, and single handedly, managed the implementation of Oracle databases for development, test and production of Peoplesoft Finance/Supply Chain Management, HR, and Student Administration. Continued to maintain multiple databases for each system including on-demand duplications and refreshes. 3 different and separate development groups meant managing 20 to 30 databases and associated middle tiers.

Proactively investigate performance characteristics of the expected production databases using open source tools (the Grinder).

Invent and implement a solution to prevent sql generated by psquery to consume too many database resources.

Responsibilities:

In interaction with the users evaluate, develop and implement integrated client/server solutions to assist in meeting the clients’ business goals and objectives.

Advise and assist developers and management on issues regarding development tools, databases, communications, client/server architecture.

Achievements:

Contributed and participated as a core project team member in the successful delivery of a distributed General Ledger system (Peoplesoft GL with Oracle on AIX) in time and under budget. This system has improved the timeliness of financial reporting while giving online access to the underlying data. My main deliverables were: technical advisor to project leader and management - benchmarking and stress testing - architect the placement and integration of application, communication and database components - implement business rules using database triggers and stored procedures - performance tuning

Established the dynamic workstation configuration that became the basis for the standard workstation configuration in the corporate division.

Developed a Windows application to verify/create the necessary environment before starting other applications, resulting in simplified installs and fewer support calls.

Early adopter of object-oriented methodology.  Evaluated development tools and recommended Powerbuilder for client/server development in 1992.  Chaired the project that defined and established standards for Powerbuilder development.

Designed and implemented rules and procedures for source code control for the corporate division.  Received favorable review for speed of implementation.

Responsible for installation and maintenance of IMS DB/DC, DB2, SQL/DS, and related products.  Formulated strategies and procedures related to databases and transaction monitors.

Led the project to review an acquired IMS-based software package.  Identified and implemented changes which - without program modifications - resulted in substantial reduction of CPU consumption and improvements in on-line and batch performance.

Designed and programmed a DB2 call attach program interface that enabled a modular design of on-line applications.

Designed and implemented a user friendly menu front-end for IMS applications

Responsible for installation and maintenance of IMS DB/DC, CICS, DISOSS, ADABAS, NATURAL Developed crucial modifications to the original NATURAL/IMS interface to make it functional.  Created an on-line ADABAS monitoring system under NATURAL.

Responsible for installation and maintenance of DL/1 in a CICS-DOS/VSE, later MVS, complex.  Proposed and developed a CICS application which enabled operations to take applications on-line or off-line individually, without shutting down the system, increasing availability for unaffected applications.

In a team of two, designed and programmed the operating system kernel of a hardware test system for the 43xx series.  We were both recognized with awards for our accomplishment.

Access counter: