SUMMARY

Seeking a position in Software Development / Support where more than 20 years of experience will contribute.

PROFESSIONAL PROFILE

• Over ten years of experience with ANSI SQL databases.
• Mature, reliable, service-oriented personality with proven skills resolving end-user and customer problems.
• Experienced in classroom training and preparation of graphical documentation.
• Disciplined programmer having a thorough understanding of technical issues, quality, and configuration management.

COMPUTER SKILLS

• Languages: SQL, PL/SQL, HTML. Familiar with Python, PHP, Perl, Javascript, Ruby.
• Databases: Oracle, MySQL, PostgreSQL, Microsoft SQL Server.
• Applications: Student Records Management, Human Resources, Call Center, Expense Accounting, Banking, Library, Manufacturing, Laboratory, Direct Marketing, Shipping.
• Operating Systems: Windows, UNIX, Linux, DOS.
• Hardware: PCs and peripherals, barcode, SCSI, basic networking.
• Miscellaneous: SQL Loader, XML, Apache, SOAP, awk, bash, ksh, ftp, make, vi, CSS, CVS, Subversion.

EXPERIENCE

Confidential

Gathered and organized existing customer configuration data for conversion to a new software platform.

Confidential

Performed data retrievals and manipulations using Greenplum, PostgreSQL, MySQL, and Oracle databases. Set up jobs to perform tasks at regular intervals using cron, bash, and Python. Designed such jobs to be configurable and used PHP to create web interfaces to modify their configuration. Wrote a Python script to move data via a web service.

Confidential

Performed programming tasks developing Oracle PL/SQL packages. Analyzed data extracts from external sources. Wrote configuration scripts to import text into the data warehouse via SQL Loader. Documented test plans and results.

Confidential

Performed programming tasks using Oracle PL/SQL, developing packages and scripts. Wrote a highly configurable package to purge aged rows from tables of a data store. Wrote a script to send emails regarding logged database exceptions. Thoroughly documented development details and test plans. Performed all job scheduling functions on project with Autosys.

Confidential

Performed programming duties as directed, writing scripts, web applications, and stored procedures. Tools used included PHP, Microsoft SQL Server, MySQL, Python, Classic ASP, VBScript, Linux, and Apache.

Confidential

Performed maintenance on a legacy application. Wrote a new application to parse text and report it in Excel XML format. Trained staff to get these projects checked into version control with Subversion.

Confidential

• Performed database development tasks using Oracle SQL, PL/SQL, and SQL Loader, as directed.
• Provided Level 2 support for various custom applications revolving around the student management Oracle databases. Developed solutions to day-to-day support issues using SQL and PL/SQL. These issues includes data fixes, data loads, and ad-hoc reports. Trained staff in the use of Oracle databases, scripting, and UNIX. Developed and maintained SQL scripts, SQR scripts, PL/SQL packages and triggers, database jobs, and cron jobs. Diagnosed and corrected root causes of data problems. Used JIRA, StarTeam, and Confluence to document changes, processes, and new features. Played a key role in assuring the software development life cycle followed standards and adhered to compliance concerns. Communicated pertinent results effectively to a very large staff.

Confidential

Developed, supported, maintained web-based database applications using XML, Python, PostgreSQL, and Linux. Performed analysis to optimize the existing database design and merge numerous databases in an ongoing project to improve performance, simplicity, and stability. Conducted user training, coordinated projects, wrote documentation, and developed business processes.

Confidential

Developed, supported, maintained desktop and web-based database applications. Implemented CVS revision control system. Supported Linux servers running Apache, Samba, email servers, etc. Set up multi-port fax server. Programming was done largely in Clipper with some shell scripting.

Confidential

Developed, supported, maintained web and desktop database applications. Set up and administered Apache web, MySQL database, and Vividata OCR servers. Legacy programs were written in Clipper 5.x and Perl with data on Novell servers. New applications were Python cgi scripts. HTML and Javascript were also used. Re-engineered products to a more scalable and widely-used platform, resolving many technical issues.

Confidential

Created scripts for loading new client data into an Oracle database. Initiated the use of reusable scripts for cleansing this data. Worked with client IT staff to facilitate periodic synchronization of data with their existing systems. Wrote custom reports to cover client requests beyond the standard capabilities of Amcom's product, usually involving accounting or billing issues. Work was done using PL/SQL, SQL Plus, SQL Loader, UNIX, awk, telnet, Excel, and Windows.

Confidential

Supported, configured, enhanced, and maintained an employee scheduling system.

Confidential

Member of a team working on a commercial leasing application. Improved database performance, wrote stored procedures, and administered the Interbase database server. Wrote a Delphi application to universally upgrade the database. Created reports using Ace Reporter.

Confidential

Maintained and enhanced a DOS database application written in Clipper 5.x while porting it to a Windows client/server application using the Interbase SQL Server and Delphi.

Confidential

In charge of support for the Toronto operations, providing new applications, reports, and LAN administration as directed. Tools used were Clipper 5.2 and Watcom SQL Server on a Novell LAN.