ANDREW HORAN skk5mb@r.postjobfree.com

**** ******** *** ~ Reston, VA 20190 ~ 571-***-**** (Google Voice)

PROFESSIONAL HIGHLIGHTS

• Performed Application development in MS Access, Oracle 8-11G, SQL Server, HTML

• Wrote multi-user MS Access applications with role based security and activity logging

• Created KPI’s, Deck’s and executive briefings.

• Gathered business rules, led all development efforts through all phases of the SDLC.

• Received ITIL 1.0 certification.

• Designed and wrote code for MS Access forms, queries, and reports.

• Designed applications using SQL Server, Oracle, and COTS applications as data sources.

EXPERIENCE

Senior Consultant, Federal Reserve Bank, Jul 2012 – Sep 2012

• Automated and prepared network reporting for the Federal Reserve Bank (FRIT) using

VBA/Excel.

• Automated VMware reporting combining data from multiple Oracle databases.

• Analyzed network traffic statistics from NetQOS.

• Identified and automated existing data flows for speed and efficiency (removing excessive

manual intervention).

• Provided instructions on how to use and maintain new programs/tools.

• Taught VBA coding to staff.

• Federal Reserve Bank Public Trust clearance

Software Developer/Capacity Planner, TNS, 2008 – Feb 2012

• Used MS Access to develop multi-user applications with role-based security using Oracle

11G database, SQL Server, and MS Access as data sources.

• Gathered business rules and led all development efforts through all phases of the SDLC.

• Performed SQL optimization, solved record locking/concurrency issues, SharePoint

development, and integration with COTS applications.

• Performed Oracle development with Toad and Oracle SQL Developer.

• Gathered business rules and led all development efforts through all phases of the SDLC.

Capacity Manager/Network Capacity Planner, Savvis, Inc., Mar 2000 - Mar 2008

- Savvis purchased Cable and Wireless in 2005

• Composed numerous MS Access applications to perform IPv4 network traffic analysis.

• Designed several business analysis tools parametric traffic simulators for survivability

analysis, resiliency analysis, and traffic forecasting; created and analyzed network health

reports utilizing the internal network traffic tool.

• Directed space and power for the installation of multiple data center products, such as co-

location and managed hosting products, for seven West Coast IDCs, representing

approximately 18% of company revenue.

• Gathered business rules and led all development efforts through all phases of the SDLC.

• Led project management and software development efforts in supporting the planning of the

AS3561 network.

• Performed business analysis tasks such as traffic forecasting, regression analysis, trending,

data mining, and programming as well as network feasibility for IP customers. Project

managed several network integration projects.

• Performed multiple packet capture studies using C-FlowD and Arbor to identify BGP traffic

flows.

• Performed network modeling with Wandl and OPNet.

• Performed SQL optimization, solved record locking/concurrency issues, integration with

COTS applications.

• Performed SQL optimization, solved record locking/concurrency issues, SharePoint

development, and integration with COTS applications.

• Provided executive-level briefings/analysis for Cable and Wireless executives leading to the

purchase of Exodus and Digital Island.

• Received ITIL 1.0 certification.

• Used SQL to perform data-mining in Oracle/Hyperion.

• Wrote applications using VB.NET, ASP.NET, MS Access, and MS Excel.

• Wrote MS Access multi-user applications with role-based security using Oracle 11G database,

SQL server, COTS, and MS Access as data sources.

Project Manager, Netstar, 1999-2000

• Established testing procedures and test plans Developed Business Continuity Plans.

• Performed risk assessments and disaster recovery audits.

• Managed the Y2K remediation team of project managers for the Engineering Division of

Cable and Wireless, ensuring system and procedures were complaint for 13 business units.

Consultant, System Engineering Services Corp., 1998-1999

• Developed and tested MS Access applications at Mobil Corporation, including a railroad car

inventory system calculating the volume of toxic chemicals for transportation by rail.

Consultant, Information Management Consultants, 1996-1998

• Performed full SDLC MS Access development for the Center for Substance Abuse and

Treatment (a division of HHS), which was audited by the IRS to be CMM Level 2 compliant.

The application was an MS Access-based project tracking system with military level

encryption.

• Served in several positions from technical writing, configuration management, quality

assurance testing, and technical lead for FDA and HHS divisions.

Senior Technical Writer, M-Cubed, 1995-1996

• Performed both quality assurance and technical writer tasks for the Nuclear Regulatory

Commission.

• Served in several positions from technical writing, configuration management, and quality

assurance. Secret Clearance

EDUCATION

University of Nevada, Las Vegas: Bachelor of Arts, Political Science

University of Phoenix, Masters in Information Technology

AFFILIATIONS

Cloud Security Alliance – Washington DC Chapter since 2011

Contact this candidate