Database engineer and architect using Oracle 11g and Oracle 12c, plus SQL Server 2008R2, supporting cloud based health insurance enrollment, billing and other products. Participate in technical and architecture design process to ensure optimal database and application design. Participate in software requirements development, design sessions, development, quality assurance and product deployment. Responsible for preparing and executing DDL statements for new database objects and maintaining existing objects, including creation of tables, views, stored procedures, functions and triggers. Responsible for preparing and executing DML statements to populate configuration tables, as well as making full use of the Object-Relational and XML capabilities of the Oracle platform. Perform data loading using SQL Loader and custom scripts. Responsible for working with DBAs for performance tuning using Oracle Enterprise Manager and other tools. Responsible for monitoring the databases during daily and quarterly product upgrades, as well as routine and urgent patches.

SQL developer maintaining existing and preparing new reports using SQL Server 2008R2 and SSRS. Involved with the full lifecycle development from the development of requirements, report design and development, testing and migration into final production. Reports are prepared using Visual Studio and SSMS is used to create database objects. Final reports are deployed using embedded report manager via corporate intranet and include both individual and data driven subscriptions. Reports cover all areas of corporate operations including personnel, financial, project controls, and prospect management; and support FGG business with agencies such as the Department of Defense, Department of Energy, and FEMA.

Performed short term consulting contracts including web development, and database development and administration. Included one 2 month contract as a PL/SQL developer with insurance provider using Oracle 11g. Additionally, engaged in further education and completed an Information Systems Security Certificate from Villanova University.

Analyst providing database programming, data mart analysis and financial data reporting in support of the Revenue and Cost Optimization Department of telecommunication provider. Made use of a variety of tools to interact with the data mart hosted on Oracle 10g using PL/SQL to interact with and manage all databases. Performed regular Extraction, Loading and Transformation of data from a variety of production databases including Oracle 8i and SQL Server. Prepare scripted routines to perform regularly scheduled data mart events. Specific project included analyzing the data mart and implementing revisions to improve efficiency and optimization of queries for retrieving and reporting financial information. Performed as technical lead in corporate project to collect and present data on the company’s position in the market, and to recognize areas available for growth and groups of customers vulnerable to turn over. Completed additional routine and special tasks supporting business continuance, including project documentation. Conducted organized PL/SQL and other training at the department level.

Prepared product customization for web based enterprise database application for government, national and international corporations ported to Oracle databases and Microsoft SQL Server. Participated in the design and development of interfaces to outside applications, including the use of SQL Server DTS/SSIS, XML and Java; prepared product customization using both PL/SQL and Transact SQL, prepared custom reports using Crystal Reports 8; and performed data conversions for new and for existing clients upgrading from legacy systems. Provided onsite technical software support and training. Maintained close contact between clients, project managers and team leaders. Prepared multiple custom PL/SQL Packages to act as interfaces between client systems and the enterprise application.

Web based application development using SQL Server 2000 and Visual Studio.NET (C#). Acted as principle database architect. Prepared models to document new logical and functional data designs. Developed all types of database objects and jobs using Transact-SQL. Developed processes to interface with electronic funds transfers. Performed database and application tuning using included tools. Performed database administration for routine maintenance and troubleshooting. Used PMI methodology to plan and complete projects including development of web services and the completion of multiple software upgrades. Prepared formal documentation upon completion of project. Established and implemented development processes for the company.

Instructor teaching “Introduction to Computers” in the curriculum division, as well as continuing education courses ranging from “Introduction to PC’s” to courses in application development using Visual Basic, MS Access and MS Excel.

Client/Server application development using Oracle database and Oracle development tools in support of electric utility cooperatives. Participated in the full development cycle. Developed server based program units using PL/SQL, developed windows based client applications using Oracle Forms and developed reporting tools using Oracle Reports. Developed interfaces to import and export data files from the database. Participated in two product upgrades of database and application. Successfully managed three projects to convert new clients from legacy software to Oracle based applications

Prepared new and maintained existing computer based training modules in support of USMC helicopter aircrew training. Initiated and completed project to complete and document fulfillment of DOD Y2K requirements for site. Initiated and completed project to log training errors.

Acted as security manager for two major Marine Corps commands and held multiple positions in the artillery, intelligence, and special operations fields. Qualified as Naval Parachutist, Naval Aerial Observer, and deployed to combat operations in Southwest Asia and Somalia. Managed USMC intelligence operations during a major NATO exercise. Managed allocation of personnel and information technology resources within a major Marine Corps command. Had three professional articles published.

Planned, prepared and conducted computer based simulations for Marine Corps units. Developed procedures and manuals, conducted system training, and resolved technical problems in support of simulations. Planned and conducted simulations using multiple models and operating systems in confederation over a national wide area network during two exercises, including after action analysis and development of future requirements.