Robin Cavanaugh Email & Phone Number

Leesburg, Va, Us

Database Developer for the US Army Corps of Engineers’ A-76 Quality Assurance Management IV&V support contract. This effort includes the development of a comprehensive Quality Assurance (QA) program related to the oversight of Information Management/Information Technology (IM/IT) Service Providers (SPs) throughout the Continental U.S. (CONUS) and Overseas (OCONUS), to include Germany, Afghanistan, Iraq, Japan and Korea. Specific details include providing data analysis, design and development of a Quality Management System (QMS). Technologies associated with this effort include Microsoft SQL Server Developer 2005 and SAP’s Strategy Management (SSM) 2007. Responsibilities include meeting with Senior Regional Information Officers (SRIOs), Regional Information Officers (RIOs), and representatives from the CIO’s office to identify organizational objectives, key metrics, performance standards, and data sources associated with these metrics. Additionally, this effort includes all design and development activities associated with implementing external interfaces with USACE and Service Provider data sources applicable to the collection and integration of performance metrics; ingestion of these results into the SSM’s multidimensional database; and development and configuration of the SSM’s back-end database and user interfaces to support analysis and reporting through the SSM’s Scorecard, Dashboard and Report features. Update and maintain CETAC SQL database and maintain CETAC Strategy Management model, which is based on the ACE-IT Strategy Management model. Also update and maintain CETAC SQL database, which entails an additional 45,000+ records per month.

• Ran SQL queries to run dashboard reports for executive management. • Wrote simple queries to pull data for executive spreadsheet reports and powerpoint decks, including Ad Hoc reports on an as needed basis. • Ran weekly and monthly reports generating data pertaining to ticket and circuit information for all of Verizon Business and create several types of charts and/or tables for easy interpretation of results.

• Software support of relational database known as GoldMine, as well as Business Objects, SAP and EOES (an in-house financial system). • Trained users on software functionality. Developed and revised training materials. • Supported over 300 internal users consisting of marketing directors and marketing managers. • Wrote SQL queries to pull data from various tables for reporting purposes and marketing campaigns. Queries were written with 9i, Enterprise Manager or embedded into Excel spreadsheets. • Assisted with revision and implementation of software upgrades and patches. • Converted ExpoCad floorplans to Cadvance and EOES for web usage and billing purposes. • Supported pipeline reporting for five office locations. Analyzed data to determine if expositions and/or conferences were on target for deadline and meeting sales quotas.

• Worked as a consultant at Nextel in the Program Management Department. • Gathered and manipulated data to track and estimate fiscal budgetary requirements for 2003 budget. This involved the use of Microsoft Excel, numerous embedded formulas, pivot tables, Visual Basic language, and creating graphs and charts for executive review of which programs would be implemented for the year. • Created databases and spreadsheets to project resources. • Assisted in development of a program tracking tool for company wide use on the intranet. • Coordinated the collection of project data for compilation of executive weekly reports. Maintained all files, logs and databases to support the Technical Review Board process.

• Co-managed a major $27 million subsea build across the Atlantic for six months • Solely managed a $2.7 million dollar metro ring build from backbone down to T1 level with a cost savings of $500K per month • Successfully implemented a major metro ring upgrade that required a six-hour outage and migration of 90% of customer traffic• Established and directed implementation team from the planning stages of project to operations handover• Created and maintained several databases utilizing Microsoft Access to track and report status of projects

• Maintained constant contact with over 200 schools regarding material requests and program policy• Directed the Regional Science and Engineering Fair, which consisted of approximately 1,800 participants and 3,500 spectators• Posted information onto school system’s intranet for 4,500+ elementary teachers• Coordinated and controlled several departmental budgets exceeding $1 million• Disseminated and controlled science materials for approximately 9,000 science teachers• Formatted and created teacher and student guide books for hands-on science, including graphics• Initiated and secured an interactive web page for utilization by all 25 high schools