TECHNICAL SUMMARY

Servers: Sun, HP, IBM Sun, HP, MS Windows Server 2008 R2

Database: Sybase Adaptive Server Enterprise, Qlikview, MS SQL Server 2008 R2, Oracle 12g R2, MySQL

Software: CA’s ERwin, IBM’s Rational Rose, ASG’s Rochade, MS Visio 2012, Sparx Enterprise Architect

Processes Agile Development

EMPLOYMENT HISTORY

May 2015 to Current

Robert Hall Contractor, Newport News, VA

Senior Data Architect – Limelight Networks – May 2015 – September 2015

Engaged with Limelight Networks to develop data models and MySQL database structure for their MMR intiative. Models consist of Entity Relationship diagrams – conceptual, logical and physical models.

October 2012 to May 2015

Corrona LLC, Newport News, VA

Senior Data Architect

Developed and implemented an architecture which integrates multiple Healthcare Registry databases from two distinct vendor implementations into one unified database platform. This unified database hosts many registries as well as source extracts and reports, Dashboards and child databases for a multitude of analytical and business requirements. This database retains a complete, robust trail of all written activity. By design, this database is the heart of company.

December 2002 to September 2012

CACI, Norfolk, VA (Formerly American Management Systems)

Data Architect/Database Administrator – Veteran Lifetime Electronic Record VLER, from March 2011

Nationwide Healthcare Information Network Project (NHIN)

Defined and refined new and existing processes for storing, transporting, protecting, archiving and retiring Healthcare records for the Veteran. Scalability, Data Volume and Data Privacy were chief concerns in connecting a variety of systems together to control information flow seamlessly.

Federal Information Sharing Technologies Project

Developed and executed terabyte database migration effort. Despite stringent and complex requirements these databases were migrated from one secure datacenter to another secure datacenter located two time zones away from each other. All data accounted for no unplanned outages.

Defined data structures to support seamless audit logging via database triggers.

Cross Project Management Considerations

Lead a team of DBAs in support of large development efforts within NHIN to tighten development practices and improve Administrator processes, modeling the entire database development lifecycle, and producing a DBA Standards and Practices guide. These products delivered an improved developer – customer relationship. In addition, performed Line Manager functions for a team of Java Developers.

Agile Development processes were instituted to ensure continuous improvement and development of software that maintained step with fast paced Business Requirements. Quick responsiveness was demanded of the database team meet Agile demands. A key component to rapid response was development of Standards and Practices to deliver a consistent methodology for database definition, delivery and maintenance.

Technical Architect II – Distributed Learning Systems, from December 2002

Serves the Army Distributed Learning System (DLS) as the primary government architect databases, primarily for the Army Learning Management System (ALMS). Responsibilities include design recommends and business process changes for implementation of enterprise program-related databases and data structures. Ensure the quality of data being received by and sourced from the DLS, scrutinizing interfaces with external systems. Provides oversight and recommendations for management of DLS metadata and consistent modeling of data within the DLS program. Recommends tools and processes, and exercises tools and processes for learning management and training metadata.

Additionally responsibilities include DLS backup Configuration Manager and backup Army Learning Management System Project Manager (Contractor). Lead Technical resource for the DLS Technical Management Division for identifying Service Oriented Architecture (SOA) practices and deliverables supporting DoD’s Net-Centric Data infrastructure initiative. Provide oversight of, and recommend modifications to practices held by the DLS integration contractor and the program management office, having visibility to the environments in which they work. Review and makes recommendations regarding contractor deliverables including the documentation they provide.

Secret Security Clearance: obtained in June ’03, but not engaged for the DLS program.

Acquisition 201A Certified obtained April ‘10

May 1998 to November 2002

CSG Systems, Washington DC (Formerly Lucent Technologies, Formally Kenan Systems)

Performance Architect

Consulting architect responsible for shaping new developments in the Kenan Arbor Billing and Customer Care products for high performance; which introduced parallel processing architecture and tools. Third-party hardware and software tools and in-house development software tools were evaluated for implementation to support the new billing engine.

Analyzed and defined concepts for future product releases with an eye toward performance, for implementation as new product features. Initiated conceptual design offering delivering an in-memory and network architecture supporting a scalable, high performance backend billing engine.

Global Performance and Operability Manager

Leader of a spirited team of over twenty contributors, worldwide, to resolve serious performance related issues whether they be at the client site or uncovered during new version product performance testing. Fostered the creation of tools to appropriately size hardware environments across Billing and Customer Care software products employing modeling and simulation practices enabling the collection of performance metrics of single or concurrent products. Established ground rules and objectives of large-scale benchmark exercises supporting platform vendor, proof of concept or client driven events.

Software/Hardware Platform Porting Engineer

Spearheaded research activities for migrating UNIX based software to Intel-based technology supported under Microsoft’s SQL Server database engine. This effort not only established the simplicity of migrating the software tools, but established performance metrics and measured throughput volumes against established metrics. Additional responsibilities of this exercise include initial concept, hardware sizing, acquisition and the migration of data from any database platform to SQL Server.

Lead Operations Engineer – Systems Engineering Group

Critical to Kenan’s success factor by correcting performance-troubled large-scale deployments worldwide. Successfully persuaded desperate clients to implement time consuming, sweeping hardware and database configuration changes to resolve dismal performance problems. Orchestrate assembled teams of professionals specializing in System, Database and Disk management, often mixed with Hardware vendors and Integration Specialists, in high pressure, high-energy, crisis-control situations.

As the last word regarding database and operation efficiency, especially Sybase, a wide range of individuals from the Development, Consulting, Benchmark, Performance Tuning and Systems Engineering organizations sought consultation. Dissemination of information was achieved through formal and informal communications. The formal flow of information was via course instruction and authoring whitepapers.

April 1997 to May 1998

Sybase Inc., Bethesda, MD

Senior Systems Consultant – Advanced Server Group & Product Service Group

Exercised broad-ranging skills spanning the database technology spectrum. Twice honored as contributing panelist authoring four certification examinations for Sybase 11.5. Fine-tuned and oversaw technical procedures for migrating SQL Servers from version 4.9.2 to 11 for Fannie Mae Corp. and Bell Atlantic Corp; whose environments consisted of two hundred database servers.

Member of an elite SWAT team, restoring performance of crippled production databases, often in two to three days. These engagements often demanded instantaneous application of analytical and tactical skills in high pressure, often hostile situations. Among the satisfied customers were National Public Radio, IBM, CorNet International, with all situations positively resolved.

Synergized hardware and database configuration for SUN, optimizing performance during a SUN and SGI benchmark. This activity allowed SUN to strengthen a foothold in an SGI dominated environment. Crafted high performance stored procedures for Wellspring Resources.

January 1995 to April 1997

Kenan Systems Corp., Cambridge, MA

Database Engineer - Performance Specialist

Achieved the position of Performance and Benchmark Specialist by demonstrating a commanding knowledge of database behaviors. In this capacity, discovery and resolution of database bottlenecks increased billing system performance and concurrency throughput a ratio of fifteen to one. This feat enabled Kenan Systems to develop a larger customer install base.

Analyzed and tuned production support environments, resolving many potentially crippling issues. Production problems were challenging to this billing system as each customer employed the application differently, shifting bottlenecks to various portions of the database.

Responsible for streamlining product development environment ensuring a high quality database structure. Performed technical management tasks while owning the Database Development Domain and leading a small team of database developers. Evaluated third-party tools for performance monitoring, reverse engineering and database platform conversion.

August 1993 to January 1995

Factory Mutual Engineering & Research, Norwood, MA

Senior Database Administrator

Joined the firm during their process of outsourcing major portions of their MIS function. Led a team of technically oriented individuals through the analysis, repair and re-integration of a corrupt VAX Common Data Dictionary. Because of the speed and effectiveness of the repairs, the major outsourcing project remained on schedule. Coached and assisted other DBAs through performance and process improvements for 35 production RDB databases resulting in streamlined production processes for backup, recovery, and analysis achieving 30 to 50 percent improvement. Advised application programmers of specific “dos and don'ts” of effective and efficient database access techniques.

July 1984 to August 1993

Digital Equipment Corporation, Maynard, MA

Database Administrator (December, 1989 to August 1993)

Designed, developed, and maintained a VAX/VMS RDB database. The database’s size was a ten gigabyte which was considered a large database for that time.

Educated programmers on database access techniques, enabling them to write more efficient code. Analyzed data to determine the amount of space the database required to meet its performance needs.

Captured performance metrics using database statistical tools in order to tune the databases. Critiqued and improved application architecture, specifically around database issues. Served as technical consultant within the department for database issues.

Applications Programmer (July 1984 to December 1989)

Provided full range analytical and technical support for the Domestic Materials Tracking and Salary Management System applications. Ensured proper documentation and code management practices delivering stable, supportable application environments.

January 1984 to July 1984

Hyde Athletics, Inc., Cambridge, MA

Programmer/Analyst

Supported existing systems and created new reports, using COBOL.

June 1982 to January 1984

Massasoit Community College, Brockton, Ma

Programmer/Analyst

Supported and developed new tools for existing applications.

EDUCATION

Massasoit Community College – Associates in Data Processing, June, 1981, High Honors

Contact this candidate