SUMMARY:

• Anthony has 20 years experience in the information technology industry with 15 years hand - on experience using Oracle Enterprise (7.3-11g). He has architected, designed, constructed and supported enterprise scale online transaction processing databases (OLTP), operational data stores (ODS), data marts and data warehouses for Fortune 500 companies such as Confidential, Disney, Wyndham Vacation Ownership, Confidential and Florida Turnpike Enterprise SunPass.
• Anthony’s degree in Mechanical Engineering trained him to solve complex problems and think outside of the box when crafting solutions. His leadership ability, developed through eight years of primary and secondary education at a naval military academy, along with his excellent communication skills enable him to efficiently and effectively work with executives, subject matter experts, and technical staff to deliver successful projects.
• He has professionally programmed and deployed applications in Java J2EE, Javascript, Delphi, C++, Ruby on Rails, Python, Perl and PL/SQL using Oracle, DB2, MS SQL Server, InterBase, Sybase, Paradox, Lotus and MS Access databases.

TECHNICAL SKILLS:

Operating Systems: Windows 3.1, 3.11, WFW, 95, 98, NT 3.51, NT 4, Windows 2000, Windows XP, Windows Terminal Server, Novell v3.1 - v4.1, Unix/Linux, AS/400, Citrix Winframe & Metaframe

Languages: Delphi v1-v7, Visual Basic v3-v6, Fortran, Borland C++ Builder, Borland J-Builder v8, HTML, Windows API, MS Visual InterDev, Active Server Pages, IBM Visual Age 4

Databases: MS SQL Server v6.0 - v7.0, InterBase v4.0 - v6.0, Oracle v7.3 - v10g, Sybase, Paradox, Borland Database Engine (BDE), DB2, MS ADO, MS DAO, MS RDO

Networking: NT Server Domain Setup and Administration, Novell Bindery and NDS Setup and Administration, Internet/Intranet Setup and Administration, TCP/IP, DHCP, FTP, SMTP, POP, NNTP, Telnet, Installation/configuration of hubs, switches, routers and proxy servers, ISDN, T1, Frame Relay

Other: MIDAS, COM, DCOM, CORBA, ActiveX, MS Transaction Server (MTS), MS Site Server, MS Exchange Server, MS Proxy Server, MS Index Server, MS Small Business Server, InstallShield, ForeHelp, MS Visual Source Safe, MKS Source Integrity, GroupWise, Seagate Backup Exec, MS Office 97, MS Project 98, MS Team Manager, MS Outlook 98, Rational Rose, Embarcadero DBArtisan and Schema Manager, Rational Rose, Erwin, Data Architect

PROFESSIONAL EXPERIENCE:

Confidential,Odessa, FL

President and Senior Consultant

• Member of the Architecture Review Board
• Assisted the Director of Architecture in implementing their enterprise information architecture discipline based upon TOGAF and FEA
• Worked within the enterprise architecture team to define the data reference model
• Assisted in the creation of the enterprise meta-model
• Created and maintained the ontology, taxonomy and semantic artifacts
• Oversaw the creation of UML class diagrams of core entities and relationships
• Mentored junior solution architects in data architecture discipline
• Performed logical/physical data modeling using ER/Studio and maintained metadata
• Forward engineered changes from models to DDL packages for deployment
• Maintained the BI Bus Matrix
• Performed an assessment for the VP of Architecture and Data Services of the applications, systems and data assets for the newly acquired Shell Vacations.

Confidential,Tampa, Fl

Consultant

• Logical and Physical Database Design
• Advanced PL/SQL ETL development (pipelined functions, bulk operations, etc.)
• Profiling and analysis of complex legacy data for migration planning and mapping
• Indexing, clustering and partitioning strategies/implementation
• Oracle Advanced Queue design to eliminate polling by the automated engines
• Archive strategy and implementation
• AIX KSH shell scripting for scheduled data pump jobs
• Metadata management
• Naming standardization, PL/SQL coding and best practices
• Offshore team leadership, mentoring and code reviews
• Data migration of millions of historical loans in a 48 hour maintenance period
• Top-tier application database support
• Break-fixes and enhancements with rollback strategies

Confidential,Louisville, KY

Consultant

Responsibilities:

• The $1.2 billion expansion of the WorldPort hub facility was very complex and heavily impacted the core sorting system along with the over 10,000 devices attached to it. The intricacy and sheer volume of changes within the change window excluded the possibility of a manual change management process.
• I was responsible for the requirements gathering, data analysis using Business Objects, architecture, database development and support of a new application called the Site Configuration Tool (SCT) to manage the hardware and software configuration changes required to implement the 26-week “step plan”.
• SCT was built on Oracle 10g with very complex PL/SQL packages, stored procedures, triggers and views to implement ETL, data transformation, version control, business rules, QA and change reporting in the most efficient manner possible. I worked with the Microsoft .NET development team lead to define and implement an API for easy GUI integration with the database. ERWIN was used to create the logical and physical database design.
• The UPS hub expansion was a complete success and SCT was a major component.

Confidential,New York, NY

Consultant - MySQL Database Performance Tuning, Architecture and Administration

Responsibilities:

• Identifying the most expensive queries and tuning them for optimum performance
• Analyzing the overall database structure looking for inefficiencies
• Submitting recommendations to the Ruby on Rails development team to better utilize MySQL without requiring more hardware
• Planning a new database approach that was better suited to scaling

Confidential,St. Petersburg, Fl

Consultant - Oracle Data Warehouse Architecture and Design

Responsibilities:

• Conceptual, Logical and Physical Star Schema design using ERWIN data modeler
• Data Warehouse, Data Mart and Staging schema implementations on Oracle 10gR2 on Linux
• Data Profiling, Data Quality and Extract, Transformation, Load (ETL) scripting using Oracle Warehouse Builder (OWB) 10.2 and custom PL/SQL
• Near-real time data replication from Oracle data sources to the warehouse staging environment using Oracle Hotlog Asynchronous Change Data Capture (ACDC) based upon Streams and Advanced Queues components.
• Linking DB2 and SQL Server databases to the Data Warehouse via Oracle’s Heterogeneous Services and Transparent Gateways.
• Operational Data Store (ODS) design for transactional near-real time reporting
• Cognos 8.2 Business Intelligence Server installation and configuration
• Active Directory and LDAP integration with Cognos
• Cognos Custom Authorization Provider implementation with Cognos Framework manager projects to provide user/group/role base row and column level data security.
• Cognos Framework Manager project design and deployment
• Cognos Connection Portal security configuration
• Cognos report development in Report Studio, Metric Studio, Query Studio and Analysis Studio
• Server sizing and capacity planning

Confidential,Carmel, IN.

Consultant - System Analysis and Data Architecture

Responsibilities:

• Reverse engineering and analysis of numerous SQL Server and Oracle databases
• Creation of the consolidated logical data model design and documentation
• Creation of the legacy system to enterprise logical data model mapping
• Analysis of the complexity of the Extract, Transform and Load (ETL) rules
• Creation of the construction project plan with time estimates for budgeting purposes.
• Heavy use of ERWIN data modeling tool

Confidential,Boca Raton, Fl

Consultant - SunPass Applications and Host Database Team Lead

Responsibilities:

• Requirements gathering and documentation
• Conducted user JAD sessions
• Created general and detailed technical designs and documentation
• Oracle (8i-10g) DBA and application data architect, Advanced PL/SQL programming, database schema creation, Advanced Queue and Oracle Streams creation and management.
• Delphi and Java programming
• Source code management
• Application build management
• Automated string, unit, and full system test planning and execution
• Performance tuning
• End user documentation
• Implementation planning and documentation
• 24x7 support utilizing the ITIL framework
• Work with team members to institute and continuously improve best practices
• Help resolve difficult technical issues with team members
• Perform source code reviews with team members for adherence to conventions and best practices
• Mentor junior programmers
• Conduct high level strategic planning with management to optimize business processes
• Communicate effectively with my team members and management
• Was respected by the staff for leading by example
• Was always available to the staff even when not on-call
• Perform database backups and recovery with RMAN

Confidential,Tallahassee, FL

Consultant (Application Architect & Java Team Lead)

Responsibilities:

• Application and Database Design
• Code builds and deployment to Websphere Application Server 4.0
• Source Code Management
• Mentoring of the Career Service Staff
• Technical Documentation
• Java coding in IBM Visual Age 4.0
• Java framework architecture coding based on Java Struts

Confidential,Orlando, FL

Consultant (Oracle & Java Development)

Responsibilities:

• Writing sophisticated data interfaces from legacy systems into CDS
• Keeping the Oracle Development, QA, and Production databases synchronized with the appropriate software releases
• Keeping the ERWIN diagram up to date
• Light Java programming using IBM’s Visual Age
• Oracle Performance Monitoring and Tuning
• Writing complex Stored Procedures, Queries, Triggers and Packages

Confidential,Clearwater, FL

Consultant (Delphi Programming)

Responsibilities:

• Remove the existing integration from TowManager to PeachTree Office Accounting
• Provide the ability to automatically update the software when new revisions became available to our customers on the subscription plan.
• Architect and develop an Internet based 3-tier E-Commerce subscription management control module with SSL capabilities.
• Write a data conversion program to extract accounting data from PeachTree (Sybase SQL Anywhere database) and import it into the new version of TowManager (MS Access 2000).
• Architect and code an Invoicing/Accounts Receivable module to the program along with all the necessary reports.
• I was able to deliver the above functionality in just over 3 months, just in time for the largest trade show of the year. TowManager v2.0’s release was very well received and sets a new standard in the Towing Industry.

Confidential,Clearwater, FL

Consultant (Senior DBA/System Architect)

• I was contracted to develop EC-Care after several other development teams had failed to do so over the course of the previous 18-24 months. This was a “Death March” project from the beginning with very tight deadlines due to my predecessor’s failures and undelivered promises that had been made to customers.
• I worked with the lead analyst and lead programmer to design a complex database capable of supporting the required functionality. I then managed a team of four database programmers to construct it in both Oracle and SQL Server. EC-Care is comprised of 200+ tables, 400+ views, 800+ stored procedures/functions, 100+ triggers and several hundred constraints.
• Throughout the development process, my experience and leadership navigated the development team through difficult times. I am the “Go-To” person when technical problems arise and I am routinely called upon to debug ASP and IIS issues that the programming team can’t solve.
• EC-Care was recently deployed and is now SSI’s flagship managed care product.

Confidential,Crownsville, MD

Senior Consultant

• Duties included VB 6 Programming, Network Performance Analysis, CITRIX Winframe Performance Tuning, Delphi Programming, IS Management, Hardware and Software Support, Oracle Performance Tuning, and Network Security Analysis.
• Successfully tuned the CITRIX servers to execute the primary applications over 300% faster and support 30% more users. Additionally, I wrote a Delphi application to automate the performance tuning process for other applications being deployed on CITRIX.
• Was tasked to enhance, finish and debug a large Delphi 4 application that had been mismanaged by two other project teams, for the Department of Defense Medical Examination Review Board.
• I acted as the lead programmer and technical lead of a staff of four. Duties included project management, custom component creation, Oracle schema creation and management, and NT network support. I used Erwin, Rational Rose, Crystal Reports 7, Delphi 4, Oracle 8.0.5, and Microsoft Project on a daily basis.

Confidential,Tampa, FL

Consultant (Delphi Programming)

• Designed and developed a building cost estimating program known as DCOST for architects using Delphi, the Borland Database Engine, and several custom components. D4COST strongly utilizes SQL and solid Delphi programming to enable architects to quickly estimate the cost of a building from a database of previously constructed buildings.

Confidential,Baltimore,MD

NT INSTRUCTOR

• I taught Windows NT First Look and Intermediate Windows NT classes for Confidential .
• Both courses were taught in a hands-on lab environment. Teaching the classes sharpened my communication skills and strengthened my comprehensive knowledge of Windows NT.

Confidential,Pasadena,MD

Senior Systems Consultant

• I managed a team of 5 Delphi programmers and was contracted to the Maryland Department of Human Resources PC Applications projects. Responsibilities included the complete system design and technical project management of fourteen Y2K related programs including a cutting edge 3-Tier Client/Server financial system.
• The financial system integrated 25 network servers capable of supporting hundreds of users across the OIM Enterprise. The system leveraged the power of the Inprise Delphi Client/Server Suite and Inprise MIDAS middle-ware architecture. Fail-over Fault Protection, Transaction Load Balancing, Business Object/Constraint Brokering, and Data Replication were all provided for within the system.
• I was instrumental in estimating the load of the system and in specifying the hardware and software requirements to support it. I also provided budgetary figures to the OIM staff.
• Other accomplishments included a specially designed application that customized the configuration of Windows NT 4.0. It was installed statewide on over 4000 PC's during the OIM PC replacement project.

Confidential,Seminole, FL

Information Systems Manager

• As the Information Systems Manager, I was responsible for the design and development of a revolutionary Windows based background-checking program know as BackTrak. The program was developed using Visual Basic and was completed in six months.
• The program was awarded HR Executive Magazine’s Product of the Year Award and increased sales from 2,000 checks a week in February 1995 when BackTrak was released to over 10,000 checks a week in January 1997.
• To handle the increase in volume, a new infrastructure was developed using Delphi, Paradox, Interbase and Visual Basic. Additionally, two Delphi/Visual Basic programmers were hired to assist in the development of the system. The new infrastructure included a real time automated order processing system utilizing the Borland Database Engine and supported 100+ PC workstations on a Novell network. It consisted of over 100 programs written in Delphi.
• Additionally, I supervised three technical support representatives that maintained the BackTrak installation base of over 5000 accounts, provided training sessions to the employees of CIC and developed and maintained the CIC Internet Web site.

Confidential,Seminole, FL

Project Manager

• Hired as a programmer and was quickly promoted to Project Manager.
• I managed the development team for several custom software packages from conception to marketable product.
• The largest program was a medical scheduling and billing application that interfaced with an IBM AS/400.
• The products were developed using OS/2, DB2, LAN Manager, and DDCS.

Confidential,Madeira Beach, FL

Hardware/Software Technician

• Built computers from the component level to specifications provided by the customer and wrote custom business applications for local companies.
• Additionally, I diagnosed and repaired Personal Computer / Macintosh hardware using advanced troubleshooting equipment.