Daniel E. Graham
3440 W. Walnut Hill Ln.
Irving, TX 75038
daniel.edward.graham@gmail.com
[Send email to request phone number] 30-8773 (cell)
SUMMARY
Disciplined, productive professional with over ten years experience in
applications development and systems development and integration. Highly
knowledgeable in computer programming, systems engineering, and systems analysis.
Has taken lead role at several companies, making lasting and highly visible
contributions. Works well in a team environment; sharing ideas, mentoring,
creating solutions. Invaluable asset to an organization due to diverse project
experiences.
SKILLS
Languages:
Perl, PL/SQL, Java (J2SE/Swing), Korn, C/C++, Visual Basic, VBA, SQL, Pro*C,
awk, bash, Ada, JavaScript, HTML, XML, XSLT, XSD
Databases:
Oracle (v. 6, 8, & 9i), Sybase (v. 11 & 12), Access (v. 97, 2000, & 2003),
Unify
Operating Systems:
Windows 2003/XP/2000/NT/98, Linux, HP-UX, Solaris, AIX, Tru64, SCO, Irix
Applications:
Kenan Arbor Billing System (v. 8, 9, & 11), Concerto (Aspect) Unison CTI (v. 4,
5, 6, & 7), DREAM (v. 6)
Configuration Management:
svn, cvs, rcs, sccs, ClearCASE, SEMS
CERTIFICATIONS
BrainBench
Java Perl Oracle PL/SQL
MS Windows XP Desktop Administration UNIX Administration (Solaris) UNIX
Administration (Linux)
Telecommunications Industry Knowledge Computer Telephony Integration UNIX
Administration (AIX)
RDBMS Concepts
EXPERIENCE
Consultant (Software Engineer), AT&T, Atlanta, GA, 12/2007 – present
· As a developer on the DSL Monitoring team, contributed Perl code to generate
HTML Wiki documentation from the source tree. Documented existing monitor
framework code with POD. Developed Java/Swing/JDBC GUI application for querying
and modifying Oracle monitoring database. Programmed a multi-threaded socket
server daemon in Perl. Utilized Mercury QC.
Consultant (Application Systems Engineer), Wells Fargo, Minneapolis, MN, 3/2007
– 10/2007
· Contributed to the OmniPlus 5.5 401K System upgrade activities, involving Perl
and Korn scripting on the HP-UX 11i platform. Developed software to efficiently
parse and summarize millions of lines of compare reports and compare base-record
OmniPlus data. Efforts saved the business hundreds of man-hours in the data
validation process.
· Utilized Tivoli Maestro to run investment data warehouse jobs, using JSC and
Conman.
· Created schedules and jobs in Maestro using both JSC and Composer.
· Enhanced the test process by writing Access/VBA graphical report generator for
OmniPlus job dependencies.
· Performed data-cleansing on several Giga-bytes of 401K data, using Perl and
Awk.
· Performed PL/SQL development on Oracle 10g datawarehouse.
Consultant, Epsilon, New York, NY, 11/2006 – 2/2007
· Developer and Project Manager for Custom Solutions Team.
· Completed training for DREAM (Direct Response Email Application Manager),
involving Perl, PL/SQL, Oracle, MySQL, and Apache (Linux and Solaris).
· Completed custom scripting for Expedia client, (non-registrant de-dup script),
using Perl/DBI and PL/SQL. This involved use of collections for efficient
processing on the VLDB. Completed web page development in HTML, JavaScript, and
Embedded Perl, which significantly enhanced the Epsilon web site.
· Performed project management activities for a team of six people, including
offshore personnel.
· Thoroughly documented existing code, procedures, and DREAM functionality.
Consultant, Walgreens, Deerfield, IL, 4/2006 – 11/2006
· Contributed over 5000 lines of Korn and PL/SQL for the new Central Punch and
Schedule, Oracle 9i database/ETL process running on Solaris/SunFire. This
project potentially saves Walgreens millions of dollars in unscheduled overtime.
These programs move, transform, and load data from all of the stores’ on-site
AS/400 computers.
· Utilized Perl to generate records for stress testing.
· Wrote a Java/Swing, client/server, socket, GUI application for manual loading
of the database. This involved writing a custom Java RemoteShell class that
utilizes the Telnet protocol.
· Wrote parameterized, generic archiving programs for Oracle tables in an OLTP
environment, using PL/SQL, Korn, SQL*LOADER, and SQL*PLUS. Over 25 million
records were archived on a one-time and on-going basis, using these programs.
To support OLTP and database performance, these programs kill sessions,
revoke/grant privileges, disable/enable triggers, rebuild indexes, and analyze
statistics. This software supports Master/Child relationships on tables.
· Completed documentation of processes. Completed requirements for a
conversion of all data processing from CSV to XML data representation, and
utilized Perl for XML translation.
Kenan/Oracle Consultant, eBay, San Jose, CA, 1/2006 – 4/2006
· Completed Kenan/Oracle table configuration for billing two new products, using
SQL and PL/SQL. This enabled the launch of the new Hong Kong site, as well as
Vehicle Local Listing for eBay Motors.
· Wrote Perl program for generating SQL and PL/SQL for Kenan table configuration
of products, including automatic generation of verification and rollback
scripts.
· Wrote Java/Swing program for creating checksums on language translation files.
This, potentially, reduces errors from handling the files after the language
translation team has finished.
· Followed through on production tickets for the Kenan Arbor billing system v.
11 running on Solaris.
· Generated XML and XSD for Kenan batch programs.
Senior Software Engineer, EP Network Storage Performance Lab, El Paso, TX, 2005
- 2006
· Wrote Automated GUI Test Programs for NetApp’s Network Attached Storage (NAS)
Device, as a part of the extended quality assurance team of Network Appliance,
Inc.
· Automated GUI test procedures on Windows 2003, Windows 2000, and Windows XP,
using Perl and the Win32::GuiTest module.
· Wrote thirty test programs for Volume Shadow Copy Services and twenty for
Active Directory, including automatic setup and configuration of Active Directory
(LDAP, WMI) for Win2000 and Win2003.
· Worked extensively with the CIFS filer protocol and Network Appliance’s OnTap
Operating System.
· Wrote DNS/NIS network management program in a lab containing Linux, HP-UX,
AIX, Windows, and Solaris
Telecommunications Analyst/Contractor, SITEL, Detroit, MI, 2004 - 2005
· Led a team that provided software development and production support for
outbound programs on the predictive dialers (Concerto) at two call centers.
· Developed software for system integrity check, data scrubbing, and reporting
on the Solaris/Sybase dialers, involving SQL, Perl, and Korn. Created an RDBMS
written in Perl that included a SQL parser and query engine based on DBM for
system check DB.
· Wrote dialer client software for proof-of-concept in Visual Basic for
Applications, potentially saving $50K.
· Developed hit screens in Unison Application Development Tool.
· Thoroughly documented Concerto Operations Procedures, System Level Commands,
and Troubleshooting.
· Provided daily production support for RightFax system, Avaya Message Care, and
Siebel 2000.
· As part of a team, completed technology refresh and Concerto Unison upgrade of
two call centers employing inbound, outbound, fax, and email agents. Provided
timely issue resolution for General Motors customer.
· Resolved problems with Concerto dialer and NICE call logging system, by
working with vendor technical support and using troubleshooting skills.
Produced system-wide documentation.
Network Engineer, Wells Fargo Financial, Des Moines, IA, 2003
· Provided tier-3 support of outbound call centers using Concerto Unison.
Improved process and productivity of team by developing Access software for
tracking cases and outages. Participated in Concerto Ensemble product
selection process. Wrote call disposition dynamic upload and FTP automation
script in Perl on Solaris/Sybase. Monitored trunk line quality. Developed
PowerPoint training material for UNIX Scripting and SQL.
Programmer/Contractor, Prospect Lead Solutions, Inc., Fort Worth, TX 2002
· Performed maintenance programming in Korn, SQL, awk, and C for a Concerto
predictive dialer host. Facilitated new Unify database extraction of potential
customers for contact by the call center.
Systems Engineer/Contractor, Verizon Online, Grapevine, TX, 2001
· Wrote software in C for account, product, and service provisioning, using the
Kenan API and Tru64/Sybase.
· Acted as Tester during upgrade of Kenan Arbor billing system from v8.1 to
v9.1.
· Tested Kenan Arbor Lockbox function and facilitated secure transfers with
Wachovia.
· Developed billing system production support software in Perl, Korn, SQL, and
VB.
· Resolved billing system issues as on-call (pager) support.
· Produced detailed requirements documentation for Verizon company-wide adoption
of Kenan.
· Completed training in SEI Capability Maturity Model and Arbor.
Teacher, Computer Learning Centers, Hurst, TX, 2000 – 2001
· Completed teaching, grading, tutoring, and mentoring for the following (3)
modules: Advanced C++, Visual Basic, and Advanced Visual Basic. This service
enabled over 20 students to pursue IT careers.
Software Developer/Contractor, Verio, Dallas, TX, 2000
· Wrote software for Kenan Arbor that provided intranet web-based agent id and
password maintenance. This involved HTML, JavaScript, Perl/CGI, PL/SQL, and
Korn.
· Performed Oracle SQL tuning and PL/SQL programming for reporting on a
multi-million record Arbor billing database running on Solaris/Oracle.
· Programmed a production script for billing system adjustment using Pro*C,
Korn, SQL, and the Kenan Arbor API. Completed report generator programming in
Perl and VB. Became familiar with Kenan Arbor tables, programs, and stored
procedures.
Director of IS, Lead Services/National Health Insurance Co., Fort Worth, TX,
1998 - 2000
· Solely developed and supported the computer network, applications, and
hardware for a call center employing 50 telemarketing service representatives.
Manager for a small, but growing IS department, including apprentice mentorship.
Negotiated purchases, worked with contractors, and supported customers.
· Performed integration tasks during call center dialer upgrade from proprietary
hardware to DAVOX (Concerto) /Unison. Utilized Pro*C for candidate extraction
software. Rebuilt RS/6000 PowerServer hardware and Oracle database during
outage.
· Completed Oracle database migration and upgrade (Oracle 6/AIX to Oracle 8/NT).
Creator and maintainer of Oracle 8/NT candidate database of seven million
records including PL/SQL, VBA, SQL, Perl, Korn, and Visual C++ programs for
automation, user interface, extraction, loading, and maintenance. Programmed
extraction process from 9-track tape to Oracle8/NT. Rewrote candidate
extraction program in PL/SQL. Developed user interface in VBA with ADO.
· Developed and supported a 2-Tier LOIS (Lead Order Invoice System) billing
database application in Oracle and Visual Basic for Applications.
· Wrote automation and extraction scripts in Solaris/Sybase for DAVOX (Concerto)
dialer.
· Creator of a lead-distribution solution involving platform-independent
HTML-mail using JavaScript that was distributed to hundreds of clients, weekly,
using Perl/ODBC automation software.
· Maintained backup schedule and printing of thousands of postcard mailers,
weekly, using software written in Visual C++. Distributed custom Access
lead-repository software to clients. Administered Linux print server.
Maintained production support of call center employing telemarketing service
representatives and 6 office staff.
· Efforts stabilized the company, providing robust systems, increase in
efficiency, and future growth and security.
Administrator/Systems Development, GTE/Verizon, Irving, TX 1998
· Performed analysis and operational support as the sole technical resource for
a MOSAIX call center with INFORMIX back-end database.
· Resolved internal client issues and adhered to and enhanced the goal of survey
reporting using INFORMIX 4-GL, SQL, Korn, awk, MS Excel, and MS Access.
Trained a replacement in Pell City, AL, by teaching HP-UX/INFORMIX
administration. Produced documentation on call center technical operations.
Computer Programmer/Analyst, United Benefit Managed Care Corp. (Walker
Financial), Fort Worth, TX 1997 – 1998
· Wrote software for Unify database extraction and maintenance in C, Korn, awk,
and SQL for the SCO UNIX platform. Earned a “commendable” yearly performance
review. Maintained dialogic call center hardware and C/sockets software.
· As a member of a three-person team, completed programming for DAVOX call
center upgrade. Performed programming as requested by marketing and operations
departments.
· Performed screen design and development using Unison ADT and Script+.
· Produced documentation for automated telemarketing system UNIX scripts and C
programs.
· Completed DAVOX (Concerto) Application Development Tools and Script+ training
in Westford, MA.
Software Engineer, Hughes Training, Inc./Link Division (L3), Binghamton, NY –
Arlington, TX 1996 – 1997
· Completed software development for a successful KC-10 flight simulator
integration and testing project.
· Resolved software and network issues during testing on the simulators, both on
the full simulator and a software test-bed.
· Completed the Record-Playback subsystem by programming in C, Fortran, and Ada
for a Digital UNIX host involving writing/reading the 10000+ variable state of
the simulator to disk sixty times per second.
· Developed GUI software for the IOS “Instructor Operator Station” in TrueGuide
and Ada.
· Completed Visual Basic training.
EDUCATION
· Bachelor of Science degree in Mathematics, Northwestern State University,
Natchitoches, LA. 1990
· Completed 12 hours towards Master of Science in Computer Science, Louisiana
Tech University, Ruston, LA. Pursued Applied Math/Computer Science BS degree at
Carnegie Mellon University, Pittsburgh, PA.
· Employed as “Assistant Computer Operator” at Carnegie Mellon University
computer science department, Pittsburgh, PA, as a work-study employee.
· Employed as “Support Computer Operator” at Electronic Data Systems (EDS),
Plano, TX, during summer work program. Online training in MVS/TSO completed.
· Employed as “Graduate Assistant”, Louisiana Tech University, where research
was performed on multimedia intelligent tutoring systems. Taught high school
students in summer program.
· Employed as “Graduate/Research Assistant”, Northwestern State University.
Presented original research related to object-oriented database applications and
Datalog. Taught a university class in computer applications. Wrote software
in PASCAL and DeluxePaint Animation for the summer space science camp.
TESTIMONIALS
“He got along well with his co-workers and never hesitated to put in the extra
time and effort sometimes required to complete a project.”- Dale Niekamp, Team
Leader, United Benefit
“He is knowledgeable in his profession and holds high ethical standards.”- Ting
Zhuang, Programmer, United Benefit
“[His accomplishments were] development for all our applications, did Oracle,
designed our network, always writing scripts.” - Dan Reeves, Vice President,
National Health Insurance Company
“He's strongly experienced with Oracle database. He's also excellent in C and
object oriented programming languages as well.”- Rachel Nguyen, Database Manager,
Lead Services, Inc.
|
