SUMMARY

• I was an Actuate report developer and DB2 database administrator. I held dual roles. I created new measurement based reports and modified existing ones for Confidential ’s internal and external customers
• My responsibilities included new report development, maintenance and troubleshooting. I employed the problem and change management systems to provide customer service in the resolution of defects and in introducing enhancements and new information into customer reports. I worked with other teams (requirements analysts, ETL, test, technical support) in troubleshooting and resolving problems
• I was also responsible for providing on - call support. In my DB2 role, I installed software, created databases and database objects, managed user access and troubleshooted problems. I supported AIX and Linux systems in this capacity.
• Database administrator. As a team lead, I was responsible for assigning and coordinating account coverage, off shift coverage, and providing third level problem support.
• The team I led supported multiple internal and external customers, hundreds of servers and thousands of databases. Our team dealt with both AIX and Windows based databases. In my other role as a production dba
• I installed and configured database software and installed fixpacks, created, and modified databases. I also worked with the db2 product developers in troubleshooting errors so they could create patches. Additionally
• I performed database monitoring in order to address performance issues. I was also responsible for implementing and monitoring security settings and performing health checks
• In addition I designed and created many PERL scripts to assist our team and the other teams in managing backups, archive logs, monitoring tablespaces, monitoring disk space usage, performing table reorganizations and running statistics on tables
• Due to my efforts, we replaced many different db related scripts with common ones used across multiple accounts. This led to increased efficiency because of a standardization in configuring these scripts became much easier to the team as each scripts had a common look and feel.
• I worked for The Confidential, Confidential and Confidential in that capacity for about 9 years. In my position with Confidential, I supported a software order fulfillment and distribution system
• My responsibilities included supporting a 20+ PC LAN based network of workstations consisting of different software loads and functionality. This LAN was connected to a Series/1 computer which housed a proprietary database solution from a third party vendor
• I utilized “C” programming to support this system and over a short period of time replaced the third party vendor saving Confidential $300,000 per year in contract support fees.
• I gained extensive experience in many areas including team leadership, hardware interfaces, DOS, OS/2, PC LANs, software application interactions with databases, barcode printers and barcode scanners.
• In addition to my work at Confidential as both a programmer and as a database administrator, I worked as a software consultant for Confidential and then a software engineer for The Confidential . In these positions, I worked with C++, OS/2 and DB2 to support a Media Manufacturing system for Confidential and an order entry system
• I have been a “work-at-home” employee since the year 2000, and I am self motivated, task oriented and require little to no supervision or direction. I am equally productive and driven working in a team environment or alone.
• I am seeking to partner with a company that can utilize my many skills and take advantage of my desire and ability to develop new ones.

PROFESSIONAL EXPERIENCE

Actuate Report Developer/DB2 Developer

Confidential

Responsibilities:

• Designing and developing standard and custom information objects and reports. Also responsible for troubleshooting, debugging and modifying existing reports, working problem tickets, opening, tracking, coordinating and implementing change tickets involving multiple groups. In my DB2 role
• I installed and configured DB2 on Linux servers including the creation of file systems, user groups, users, dbm instance and db configurations, creation of db objects (tables, indexes, foreign keys, etc), setup cron jobs, wrote db utility scripts, wrote customer import scripts
• Assisted developers with writing queries. Performed troubleshooting. Worked with db2 support to resolve product issues.

Production Database Administrator

Confidential

Responsibilities:

• Team lead over multiple accounts. Monitor and manage customer databases. Perform annual security health checks identifying and resolving exposures. Install database software and database upgrades
• Create new databases. Implement database changes. Created and implemented database maintenance scripts such as reorg checks, reorgs, runstats, deletion of old backups and archival log files from tsm
• Wrote database user exit program for archival logging. Wrote database ddl. Designed table and tablespace specifications including bufferpool requiremements.

Software Engineer

Confidential

Responsibilities:

• Part of a four-member team responsible for supporting existing order entry system while at the same time designing and developing a replacement system. Project was OS/2 based using VisualAge C++, and was developed for MCI.

Software Consultant

Confidential

Responsibilities:

• Worked alone in the design, development and implementation of the first phase of a continuous flow media manufacturing system (OS/2, DB2/2, C Set/2).

Senior Associate Programmer

Confidential

Responsibilities:

• Provided all support for a software distribution system (DOS based Confidential PC LAN with 20+ workstations connected to a Series/1 database. System also consisted of Kosan Crisplant Tilt Tray mechanical sorter, barcode printers and scanners, and an automated high demand publication picking subsystem.
• I wrote and implemented a customer database migration plan in order to transfer a database across the country. The account was being supported by another services provider, and that support was being transitioned to Confidential in Boulder, Colorado
• Migration occurred in a very compressed timeframe, switched hardware platforms in the process, and occurred in a highly volatile environment in which both applications and database were upgraded while the migration plan was being tested.
• Supported major customer software upgrade rolled out to 1700 production servers. This upgrade touched many areas of the customer's environment at the same time including hardware operating system, database and application upgrades
• My contributions to this project included writing a user exit program for DB2 UDB so that the customer could enable archival logging on a critical database. This enhancement allowed Confidential to shorten the window of potential data loss from 24 hours to seconds. I was also responsible for finding an alternative solution to BMC Patrol since Patrol was no longer supported on the new operating system. In order to achieve the desired requirement
• I developed a DB2 database and supporting applications using Microsoft Access on the front end to replace the functionality that was lost with the discontinuance of using BMC Patrol.

Confidential

Database Support Transition

Responsibilities:

• Assisted in the successful transition of database support from major bank client to Confidential .Documented processes and identified exposures. Built database support documentation from the ground up
• Trained team members. Designed and implemented many database maintenance utilities in OS/2 REXX. Wrote security audit documentation and performed annual audit. Audit thoroughness and documentation were well received by the customer.

TECHNICAL SKILLS

• C
• DB2/2
• wxWidgets
• C++
• DB2 for Common Servers
• INNO Setup Compiler
• PERL
• DB2 UDB
• MinGW Developer Studio
• Actuate
• DB2 LUW
• Antheminon Dialog Blocks
• HTML
• SQL
• AIX
• Object Oriented Development
• Stored Procedures
• Linux
• Lotus Notes
• Triggers
• Windows
• DOS
• TCP/IP
• FTP
• BMC Patrol
• Microsoft Word
• ODBC
• Clearcase
• Microsoft Excel
• MySQL
• Lotus 123
• Microsoft Project
• mSQL
• Lotus WordPro
• Microsoft Access
• Dbase IV
• Ethernet Networks
• Codeigniter
• SQL Server
• Hummingbird Exceed
• Apache Web Server
• Oracle
• Query Manager
• Javascript
• CPIC
• PHP
• EHLLAPI
• OS/2
• Java
• SystemView
• PVCS
• Drumbeat
• NetFinity
• Script
• Troubleshooting
• Documentation