Alan Hoffmann Email & Phone Number

Greater Denver Area

Develop Oracle procedures in an agile environment to introduce enhancements to reports and ETL procedures which propagate and maintain data. Also respond to service tickets reporting problems and incorrect information on schedules and reports.

Bellevue, Wa

Develop Oracle procedures to propagate and maintain data from numerous vendors. Analyze data and work with business analysts to define requirements. Tools frequently used include Toad, SVN, and Informatica.

Bellevue, Wa

•Work with business analysts to refine requirements and present prototypes and alternate solutions. Assist Business analysts with initial requirements as detailed by the client for reporting solutions and table structures. When I could think of more appropriate data for reports I would present both, then develop final solution after getting feedback from client.•Use Oracle 10g to develop PL/SQL procedures to maintain and extract reporting data.•Create ETL jobs using proprietary ETL tools to load files from customers and apply complex business rules as defined in specifications such as transforming and validating incoming data, executing procedures which send email marketing messages and create text files with summaries and statistics for reporting.•Support scheduled jobs and the needs and questions from business analysts and sales people.

Seattle, Wa

•Create Oracle PL/SQ procedures to maintain and extract reporting data.•Ad-hoc research requests, identify common patterns in data.•Created and maintained the ETL processes which loaded data from various OLAP data warehouses. Restart jobs after taking appropriate actions.•Developed a suite of procedures to perform quality checks which could be dynamically configured to alert when values varied significantly from the prior period or exceeded a predefined range or has an invalid value.

Bellevue, Wa

Consultant through TEK Systems hired to fill the gap while the lead dba was on sabbatical. • Provided developer support including query optimization, access privileges, review queries and objects (tables/columns/indexes) associated with new code.• Supported day to day operations. Used OEM extensively to assist with capacity planning and to identify performance issues. Monitored load and jobs, reviewed the database logs.

Seattle, Wa

CTI Administrator Role (March 2003 – December 2005)•Participated in the design, development, and deployment of CRM telephone and email interaction routing applications to 3 remote call centers located in Oregon, Europe, and Japan.•Manage deployment of new programs, enhancements, and bug fixes. Create and execute test plans and develop documentation required for weekly change control meetings. Document business justification for changes and back out plans, create Visio architectural diagrams, coordinate and communicate deployments with management and other technical resources and user community (managers and switch administrators at call center service providers).•Respond to loss of service incidents when contacted by network operations. Research root cause and attend morning “production control” meetings to discuss cause and plans to prevent similar loss of service incidents.Oracle Database Administrator Role (June 1999 – December 2005)•Maintain complex Entity Relationship Diagram with Oracle Designer 6 and data flow charts using Visio.•General performance tuning, capacity planning, and deploying shell scripts to help ensure maximum availability and performance.•Part of data migration team tasked with migrating data from Informix to Oracle and also migrating a US-ASCII Oracle database to UTF8 to support multiple character sets.•Regularly created new databases for various development teams: Installed Oracle and latest patch set, created appropriately sized database, setup users, provide data modeling to determine what tables, columns, and indexes would be most efficient in regards to performance and ease of use for the deverlopers. Create tables, indexes, triggers, and other database objects. Setup and test RMAN backup and recovery scripts.