Austin, Texas

More than 12 years of experience with relational databases, programming and systems support.  Exceptional ability to quickly master and apply new software.  Customer Service oriented.  Articulate, patient and organized professional with creative and resourceful approach to solving problems.  Communicates effectively with staff at all organizational levels.  Notary Public, State of Texas.

• Provided hardware and software support and upgrades for 25 users
• Developed forms and templates in MS Word and pivot tables in MS Excel
• Worked on department’s web presence, including FAQs, Contacts and Solicitations
• Helped Buyers prepare Executive Summaries for weekly Commissioners Court meetings
• Ran queries for ad-hoc reports and data downloads for internal and external customers
• Maintained older and developed new queries for data from the AS/400 mainframe using NGSIQ
• Developed Countywide training class and manual for HTE Purchasing and Inventory module
• Provided experience-based consulting on internal business processes
• Liaison with ITS staff for system and network troubleshooting and problem resolution
• Recommended replacement computers and peripherals, as needed
• Served as the Purchasing Office Y2K Coordinator

• Developed enhancements for Power Production library application using MS Access (originally developed in dBASE III+, converted to MS Access 2.0 through Access 97). Re-designed data screens and wrote code in Visual Basic to activate Password Verification, Searches (queries), Reporting and Data Retrieval functions. Revised data structure of second library system for ease in merging the two systems into one department-wide application, to enable its use of the same screens and code as the Power Production system.
• Maintained internal Oracle-based Budget application using PL/SQL and SQL Forms 3.0
• Maintained and ran PL/SQL-based Monthly Monitor financial reporting application
• Extracted data from, and imported data to IBM mainframe using Data Query, TSO and JCL
• Uploaded meter inventory data files to the mainframe computer via Reflections FTP Client and TSO
• Modified and submitted the JCL to produce Revenue Reports on an as-needed basis (weekly during the summer months, at the end of each utility billing cycle otherwise)
• Converted Maintenance Management System Project forms from Oracle Forms 3.0 to Oracle Forms 4.5, also using PVCS to manage the forms version control
• Participated on the team to release SafeActs, an MS Access-based application developed in-house and released on a trial basis for possible future marketing
• Investigated the migration of and made recommendations for the Gas Nomination program from the Novell Network to a Windows NT server
• Evaluated Condenser Cleanliness Calculation program for conversion to MS Access
• Studied Transmittal Manager Program being converted from Paradox to MS Access
• Provided Human Resource Information System support to the HR Admin. group

• Administered relational databases for Human Resource Information System (HRIS)
• Developed and expanded internal Human Resource Information System using dBASE IV
• Developed customized screens, queries and reports in dBASE SQL
• Developed menu-driven Affirmative Action Reporting system based on dBASE SQL query code
• Developed and produced custom staff demographic reports for top-level management
• Analyzed requests for data and their results for optimal use by requestors
• Wrote documentation for the HRIS using MS Word, PowerPoint, and Snap!
• Queried data to produce staffing demographics including EEO Analyses, responses to legal complaints and Position Control reconciliation
• Prepared, maintained and distributed organization charts, management reports, and system documentation
• Prepared confidential reports dealing with sensitive employee issues, such as potential layoffs and early retirement eligibility
• Provided systems support on various platforms (PC, Macintosh and VT terminals)
• Conducted one-on-one training in MS Office suite for staff on Mac and PC platforms
• Assisted with the preparation of the budget by making hardware and software needs assessments, recommendations and justifications
• Served as resource for policy interpretation to other HR personnel

• Maintained and enhanced internal Human Resource Information System and its relational databases, queries, reports and screens
• Performed data analysis for staffing demographics including EEO Analyses, responses to legal complaints, Position Control reconciliation and Affirmative Action Reports
• Prepared personnel sheets for annual budget
• Processed and tracked City and County personnel action forms
• Served as employee services liaison with City and County Human Resources Departments
• Researched and interpreted City and County personnel policy
• Distributed City and County Payroll on biweekly and monthly basis
• Prepared and distributed organization charts and management reports
• Provided systems support on various platforms (PC, Macintosh and VT terminals)
• Conducted one-on-one software training for staff on various platforms
• Provided administrative support to the HR Manager and his Assistant

• Coordinated personnel activities between the City and County Human Resources and Payroll departments by processing and answering inquiries regarding personnel actions(appointments, promotions, transfers, terminations, adjustments to pay, time records, and leave balances)
• Provided employment verification by phone and mail
• Tracked departmental vacancies
• Distributed job postings and payroll checks throughout the department
• Maintained the integrity of the automated Personnel Information System by updating and relating databases, repairing existing and creating new programs, reports and label lists for management
• Maintained the agency's organizational charts
• Performed data entry in the preparation of the personnel pages for the City Budget projections

• Prepared confidential correspondence and reports
• Managed, maintained and manipulated existing and newly-created databases for management reports (dBASE III Plus)
• Troubleshoot problems in existing reports and programs
• Extensive word processing, including regret letters to applicants ("MailMerge", Wordstar 2000)
• Statistical typing
• Created and maintained departmental organizational charts using Org Plus software
• General clerical, including typing of personnel action forms for employees