2647 Hidden Ridge DriveArlington, 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