2647 Hidden Ridge
Drive ▪ Arlington,
Texas 76006 ~ (817) 637-6388
▪ andy@awall.com
ANDREW J. WALL
Database
Developer / Application Architect
Senior developer with vast experience across the full
life-cycle of software development in organizations ranging from emerging
web-based companies to Fortune 1000 companies.
·
Results-oriented
implementing effective technologies for a wide array of business needs
·
In-depth,
hands-on experience throughout all phases of the system development life cycle
·
Focused
execution to align technical solutions with business objectives
Core Competencies
|
Enterprise Systems Architecture
|
Database Design
and Modeling
|
|
Web
Development
|
Database RDBMS
9i, 10g
|
|
Oracle
Fusion Middleware
|
Oracle
Application Server 10gR2
|
|
Oracle
Forms, Oracle Designer, Oracle Reports
|
Jdeveloper, ADF
|
|
C, PRO*C
|
SQL,
PL/SQL, stored procedures, triggers
|
|
XML, HTML,
CSS
|
Extraction,
Transformation, Loading (ETL)
|
|
UNIX,
Linux, Sun Solaris, Windows Server
|
Java, Javascript, AJAX
|
|
Oracle
Application Interfaces and Conversion
|
Oracle
Custom Development
|
|
Software-as-a-Service
(Saas) architecture
|
Co-Location
Infrastructure Design
|
Notable Achievements
Led the
development and deployment of multiple innovative systems to on-time and on
budget completion:
- Energy futures and options trading
platform, pipeline scheduling, exchange accounting
- Oracle reporting data warehouse
and distributed application
- Oracle 1st web-based
platform financial application integrating dozens of data sources
- Oracle Certified Professional
PL/SQL - 2001
Professional Experience
Senior Database Developer Sep 2008 – Jan 2009 Epsilon
Responsibilities:
- Development
and maintenance of software for loyalty rewards programs on Oracle 9i/10g
- PL/SQL,
stored procedures, triggers, Oracle Forms and Unix shell scripting, IBM
AIX
- Teamed
with system analysts to design functional and technical specifications
- Web
site support and monitoring
Accomplishments:
- Redesigned
code modules, significantly reducing runtime and costs
- Implemented
robust validation routines, improving data quality
- Automated
external data feeds, designing custom ETL scripts and procedures
Lead Developer Aug
2006 - Aug 2008 Tacilent Corporation
Responsibilities:
- Lead
architect and developer of web based SaaS software product suite
- Oracle
Web Forms and Reports 10g, PL/SQL, stored procedures, Sun Solaris, Linux, Windows
- Installation,
configuration, management of Oracle Application Server 10gR2 including
OID, OC4J, Web Cache, Forms and Reports
Accomplishments:
- Successful
implementation of core software product six months ahead of schedule
- Deployment
led to first revenue in advance of expectations and new sales
opportunities
- Received
national award as Trend Setting Application of 2007 by KM World Magazine
Senior Developer / DBA Sep 2001 -
Jul 2006 Thobe Group, Inc.
Responsibilities:
- Designed
and developed software to replace in-house salary survey system written in
Access, VBA
- Oracle
9i database, Oracle Forms and Reports 6i, PL/SQL, stored procedures, Windows
2000 Server
- Liaised
with clients to successfully resolve technical issues and provide
implementation assistance
- Managed
distribution of application to meet aggressive schedule for survey polling
and publication
- Maintained
corporate website
Accomplishments:
- New
services increased revenue by 20%
- Improved
customer satisfaction
- Migration
to initial release in three months
- Improved
performance and response for client application and internal evaluation
and publishing
- Reduced
cycle time for survey production by 90%
- Improved
quality of service and technical infrastructure
Senior Developer Oct
1995 – Aug 2001 StockSmart
Responsibilities:
- Designed
and developed web-based platform for institutional level global financial
research
- Directed
all aspects of technical and software development
- Designed
and deployed interfaces to multiple real-time streaming data feeds
- PL/SQL,
SQL*LOADER, PRO*C, Unix shell scripting, Sun Solaris
- Manage
installation and administration of Oracle Databases, Oracle Web Server
Accomplishments:
- Selected
as a premier web application by Oracle Corporation
- Recognized
as one of the first sites to provide software-as-a-subscription revenue
- Achieved
4 million dynamic page views and over 1 million active updates per day to
web-application
- Won
$1.4 million dollar contract with Credit Suisse
Senior Principal Contract Consultant Jul
1995 – Sep 1995 Oracle
Corporation
Responsibilities
- Custom
development for McDonald Douglas in PRO*C for database login security
- Custom
development for Oracle Fixed Assets system for Southwest
Bell
- Developed reports in PRO*C for Rockefeller
Foundation for financial awards management
Accomplishments:
- All projects completed on time
an within budget
Senior Developer / DBA Jun 1992 - May1995 Superconducting Super Collider
Responsibilities:
- Oracle application design and
development
- PL/SQL, PRO*C, Oracle Forms, SQL,
Unix shell scripting
- Design and deploy distributed
application for Oracle Application financial reporting
- Oracle Financials and
Procurement Application development
Accomplishments:
- Replaced Oracle Fixed Assets
with custom application
- Project delivered on time and
within budget
- Promoted to senior position to
provide extended support during operation shut-down
- Maintained systems and support
with limited staff and budget during operation shut-down
Education
Certification
in Systems Programming and Design: Control Data Institute, Arlington, Virginia
Bachelor of
Music, Classical Guitar Performance: Ithaca
College, Ithaca, New York
Associates
Degree, Arranging and Composition: Berklee
College of Music, Boston, Massachusetts