Air Force Support Analyst

Jerry Glen Glasgow Jr.

**** ******** *****

San Antonio, TX 78258

210-***-**** Cell

512-***-**** Alt

Email: *********@*******.***

SUMMARY

20+ years experience. Exceptional BI SQL Server Database Administrator experience delivering in-house native Business Intelligence methodologies for existing multi-platform environments, supporting enterprise organizational departments, improving turnaround times and minimizing manual interventions through integrated, centralized and tiered data solutions. (e.g., SQL Server, Oracle, SAS, Solaris, Linux, UNIX and Windows)

Experience

(Seabrook Solutios), San Antonio, TX 02/2020 to 03/2022

SUMMARY

Database Manager, Systems Manager, Security Systems Officer (SSO), Applications Developer, AETC Pilot Instructor Client Application Support. Involved numerous roles wearing several hats.

“MANY HATS” - CTO, SSO, Sys Mgr, DB Mgr, Ctr Mgr,

Managed the Pilot Instructor Training Capturing feedback for student pilot evaluation feedback providing a central data repository on both the instructor led flight training, student evaluations and instructor feedback on the student, syllabus released material, or previous instructor led training combined Air Force Air Education Training Command led by the 19th AF under a three star.

lManaged the entire enterprise for 19th/AETC (DOR) with the sole purpose of capturing feedback data from AETC training locations and the operational command units students were assigned to after graduating pilot training including Air Force, Navy, and Marines (Helicopters for A1).

lThe student populations included active duty, reserve, and guard.

lEffectively centralized instructor feedback on all 12 AETC base training locations while also integrating over a 150+ operating command unit locations (outside the AETC Command) under the direct requirements set forth by General Wills (2 Star for the 19th).

lSuccessfully communicated directives to 150+ Operational Units by rolling out a variety of guides, based on emails guides, customized content tailored to audience (ie: BSA, Instructor, Leadership (Col, Major…), POC’s etc…) utilizing Oracle Apex Coded content; coupling scheduled agents executing daily notices alerting for student feedback (occurring after student graduation; built-in calculations factoring arrival to follow-on course, integrated get-to-know-you instructor window based on released syllabus covering the student gambit such as - : F16 Fighters, F22 Bombers; C-17’s Loaders, drone operators raptors, flight nav’s, sensor operators, if to opunit (first official post assignment after grad courses, then ops and special ops etc…). The notices of student feedback becoming due, having integrated their specific student feedback application links sent to the Instructors, assigned poc’s, bsa’s, and senior leadership if requested.

lApex (19.1) developed applications, running on Oracle Enterprise (19c), Fusion Middle-Ware (WebLogic 13c) provided a centralized source for data I/O, customized audience based dashboards providing heads-up stats, and customer experience (in-mind) for drill down navigations specifically designing need to know content, and broadening elements based criteria, providing the business intelligence of data capture automation, while information metrically driven based on priority, allowing streamlined content infused for quick efficient actions, status’s, and overall readiness providing fulfillments before the bi-weekly details in a mandatory General’s briefing addressing results requiring attention all in the single embodied processed effort to continually improve instructor material and student training.Manages all servers.

l Managed security meeting cyber space regulations and compliance by identifying requirements and meeting regs; Performed total server software/hardware maintenance cycles applying newest release of DISA stigs against Windows Server, Oracle 19.2 Enterprise, Oracle Fusion WebLogic 12.2, Oracle Secure Backup, Apex 19.2.

lAchieved the Air Force ATO renewal allowing a three year window to operate. Going line by line with stig results with approval authorities from DISA, A6 Cyberspace, and AETC 555th Security identifying flaws, CAT (1’s, 2’s & 3’s), providing required plan creating implementation guidances coupled with time lines followed by new scans until all regs and requirements were satisfied, confirmed, and affirmed for audit successes.

lSuccessfully performed Oracle 12.4 Enterprise migration to Oracle Enterprise 19.2.

lImplemented a full scale enterprise backup solution implementing OSB 12.4. Implemented integrations using native PS scripts to create full backups including platform environments with zero down time; specifically avoiding application outages while ensuring zero latency.

lWorked with A5 Cloud1 environment beginning a cloud migration.

lCreated numerous full scale application harvesting integrated built-in capabilities of Apex with customized Java coded pages uniquely creating a user intuitively based design providing real time background operations specifically tailoring predictive analysis to the individual user, prioritizing user based dashboard information, analytics, and required actions.

(DHA), San Antonio, TX 10/2018 to 10/2019

SUMMARY

Named by reputation; identified, scoped and implementing end to end integral operational automated solutions centralizing informational based processes covering, instituting, and meeting required regulations and practices for Information Assurance, Configuration Management, Data/Server tiered status/s, audits, alerting. Uniquely privileged to work with FFA’s handpicked highly experienced team WDMS through Service and Delivery will benchmark seamless operational practices recognized by A1.

(Defense Health Agency (DHA)), San Antonio, TX 6/2018 to 9/2018

Data Science & Decision Support Analyst

Aligned work flow processes with DHA’s vision and objectives. Provided leadership with direction on Big Data capabilities, consumer initiatives, and best practices within the departments.

lCreated integration processes to automate executions of repeatable coded logic by encapsulating control flows and methodologies into packages, hosted and maintained on package stores.

lHarnessed built-in memory managed services native to the SQL Server Enterprise to achieve different solutions.

lStreamlining data efficiencies for end to end agent controlled work-flow operations utilizing BI.

lModeled database table structure based on specs provided for Navy’s “Orion” App requirements.

lCreated an automated EDI file process from Navy’s “Orion” App to DHA involving criteria based data transformations before and after the import.

lIdentified undocumented manual executions missing fundamental checks, validations or, alerting methods causing highly visible production outages exposing the customer to extensive downtime.

lEliminated outages by promptly integrating intelligent packaged work flows with monitored steps firing emailed alerts, and updating a centralized dashboard.

lProvided analytics for diverse data sources utilizing hands free automated processes.

lImproved analytic data visibility by decreasing time spans data was updated from weeks to hours, resulting in providing the medical community with much faster responses.

lStreamlined analytics by removing manual steps, encapsulating BI workflows into multi-step packages.

lCreated data mining analytic solutions providing predictive modeling for the Orion application.

lBy metrically capturing ratios from user routines with custom logic structures to call values based on individual user activity.

lBy moving packages to package stores; executions natively harnessed the powerful memory managed services, which dramatically increased transformation performance speeds (i.e. data prep, archiving, validation routines, washed derived calculations, updates) etc..

lPackaged EDI steps into a single work flow executed through a managed agent; providing monitoring and alerting.

lGreater functionality within SharePoint was achieved by analyzing workflows,

lIdentifying missing logic for patient timespans for Orion where different periods drove case management action. Produced logic containing casted functions capturing derived output, which was washed to obtain static values.

lValidated packaged logic which was provided to developers and implemented.

lProvided a CM solution harnessing built-in intelligence and powerful efficiencies native to SQL Server File Streaming services.

lProvided at ZERO cost an enterprise CM solution integral to preserving the integrity of the enterprise while providing an intelligently managed centralized method of tracking files, code, and executions.

lCreating a centralized repository managed at the Server level produced total interoperability seamless integration of monitoring and alerting via dashboard, logs, and email.

lArchitected a go to troubleshooting file repository for the SQL Server Enterprise environments.

lImplementing Microsoft’s SQL Server Best Practices created a categorical repository identifying helpful Dynamic Views (DMV’s) to quickly ascertain and troubleshoot.

lIdentified inefficiencies, undocumented executions and provided creative solutions –providing improved departmental namely (analyst and developer) work flows.

lProvided a real-world workload automation, reducing cost by utilizing Native services (SSIS), and combining the OEM’d component for Business Intelligent increasing data throughput on DISA by 200% for large instances.

lCreated a code and execution optimization plan to develop work flows providing increased clarity and decreased down mistakes which were delaying data refreshes.

lProvided DBA’s with scripts to identify I/O related issues creating application degradation, and the automated process to check, identify and remove performance blockers, reducing runaway in-memory executions.

lDefined a plan to scope code, identify executed performances, and optimize code utilizing well laid-out processes.

lAchieved faster data transfers with highly efficient transformations performing source extractions utilizing MS OEM Components intrinsically providing packet level performance.

lIdentified non-conformed collections of code and related data to establish fully documented references, and provide optimizations.

lConfigured Team Foundation Server to pull in individual developer activities. By allowing TFS built-in policies to change development work flows; it seamlessly bridged the gap to a controlled environment, which through stages resulted in aligning a unified approach to code management.

lSupported database migrations to Teradata providing a way ahead for continued analytics while providing integrations for SSIS, SSRS, SharePoint, and TFS.

lFor the purposes of development training provided a sql level crossed referenced comparison between Microsoft’s Tsql and Teradata’s format

(AFSC- WDMS), San Antonio, TX 6/2018 to 9/2018

SUMMARY

Named by reputation; identified, scoped and implementing end to end integral operational automated solutions centralizing informational based processes covering, instituting, and meeting required regulations and practices for Information Assurance, Configuration Management, Data/Server tiered status/s, audits, alerting. Uniquely privileged to work with FFA’s handpicked highly experienced team WDMS through Service and Delivery will benchmark seamless operational practices recognized by A1.

Air Force Security Services (AFSC)

AFSC- WDMS SQL Server DBA

lIdentified missing operational work flow processes for Information Assurance and Configuration Management, where governance of file results did not exist; Utilizing native solutions at ZERO cost implementing business intelligence, SSIS, SSRS, and File Streaming which provided the results while capturing leaderships approving attention having a centralized dashboard for material resulting references.

lCreated IA methodologies supporting governance over operational practices providing a up to date situational awareness.

lUtilizing IASE DISA defined security requirements STIG’d all SQL Server environments and IIS environments.

lRolled out fixes through defined maintenance windows throughout DEV/TEST/PROD

lEquipping IA, CM, and developers with centralized up to date information using native automated services to deliver information to customers, and leadership faster and much more efficiently.

lIdentified SQL Server and data redundant and fault tolerant solutions.

lStandardized development environments to match operational tiers.

lCreated SQL Server baselines for all tiered environments

lCentrally located Information and status reporting through SSRS hosted hands free dynamically driven report links.

lProvide developer assistance supporting code based queries and redesign for much faster and more efficient returns by decreasing customer wait times and improving the overall customer experience.

lReduced transactional logging time ensuring DML activity does not adversely affect excess growth, truncations, and maintained during round robin backup operations.

lProviding central changed audit alert and hosted report to identify any schema, asset, object, security, or server changes and inform need to know.

lProviding all elements of support, guidance, and projection to and exceed Air Force expectations.

Diversified Technical Services, Inc. (DTSI), San Antonio, TX 11/2005 to 3/2018

CORPORATE ROLES

Oracle DBA, SQL Server DBA, Server/Network Administrator, Exchange (Mail Administrator), Application Developer, Technical Report Writer

Air Force Personnel Center (AFPC) Program Management Office - MILPDS

AFPC- PMO Senior Oracle DBA

lEBS installations and upgrades, SFTP between Windows and Linux/Unix environments.

lUtilize utilities Quest/TOAD and SQLDEV.

lUtilize SSH sessions keys for local and DISA environments and SFTP seamless authentication utilizing keys.

lMonitored and maintained APEX Applications utilizing JDBC Connections and DBLINKS.

lMetalink - Oracle SR's, Oracle tickets required information to support a successful resolution, Compiled invalids.

Supported Solaris 10.0 and numerous CRON jobs integrating SFTP operations.

lSupported Profiles limiting logon attempts and restricting connections locking parameters timeouts.

lPerformed DATABASE using DUP to refresh and copy of PRODUCTION Database and EBS App refresh creating a functional duplicate for clients to perform pulls from. Supported SYSADMIN shop to load correct RPM's when standing up Redhat Linux 7.1.

lOracle migrations from HPUX Unix, IA64 to Linux, performed Oracle EBS and Weblogic migration to Linux.

lUpgraded maintained and supported 11.2.0.4 Databases, supported Discoverer Instances, supported Dataguard, supported HPOPENVIEW and Reporter Linux and 11.2.0.4 configurations, configured AE256 encryption SQLNET.ORA Configurations producing dblink seamless encryption, utilized METALINK to perform quarterly patch releases and required Opatch files.

lPerformed 11.2.0.4 Database and Java patches, prepped servers for patching, enabled and configured auditing and archives, performed SFTP and RMAN Backups.

lMaintained DISA STIG Analysis - ATO's accomplished for MILPDS all tiered environments to include: MILPROD, ARMS, DCPDS.

lSupported MILPROD (all tiered environments), ARMS (Automated Records Management), EBOSS (Board Support), CIV Environments.

lSupported Linux/Unix/Solaris Storage Mounts (i.e. structuring UMOUNTS) - BDFM / DF -h -k - NFS Shared Mounts, Identified Stale Mounts, Worked with DISA to increase storage for shared MP's for SOLARIS DB Servers and Linux Application Servers.

lApps: R12 EBS – Weblogic – Apache - Fusion Middleware R12 EBS, Oracle Access Manager, Launch Java Apps for Concurrent Manager support and Configured App Nodes.

lFNDCLEAN refreshing Concurrent Processing Nodes (Primary/Secondary) $Context_file.xml.

lADAUTOCFG - applying (i.e. binding settings, changes, updates etc.)

to the Context File (Configured on ADMIN and ran on ADMIN first followed by CM Primary/Secondary and followed by all app nodes).

lStart/Stop App Servers - utilizing $Admin_Scripts_Home for *.sh scripts: Weblogic Admin Node / Primary Concurrent Manager Node (adcmctl.sh) / Secondary CM Nodes / Weblogic Client Nodes / Java Services / Apache Services.

lDatabase Administration and Support for /ETC File configurations (i.e. /etc/oratab), for Database and OEM Agents Services, Mounts Open Mounted Nomount, LSNRCTL Listener administration - TNSNames *.ora for connection strings / Supported ORATAB's and AUTOCFG Executions.

lPrimary Concurrent Manager / Secondary Concurrent Manager Upgrades, performed an EBS 12.1 to a 12.2.4 upgrade in support of the Secretary of Defense, configured Oracle EBS in a Windows Server environments, trained entire Oracle staff on how to properly bring down App servers in the correct order. Managed Apache application support.

AFPC- PMO Senior SQL Server DBA

lCreate dashboards for heads up display. Upgrades from SQL2000 to 2005, 2008R2, 2012, and 2014.

lInstalled, configured and administered SSRS Servers to include RDL (report migrations). Built reports utilizing Report Builder, BIDS, and customized XML based standalone RDLC report files sync'd to the reporting server. Allocated RDL reports RDS datasets supporting SSRS via BIDS.

lCreated granular, integrated authentications providing client based hierarchy reporting permission supporting organizational and analytical data reporting.

lBackup/Restores/Disaster Recovery: Created Database round robin backup strategies, performed restores (full differentials and point in time), performed disaster recovery against a dual instance R2 SSIS and SSRS services.

lInterfaced with customers to gather requirements for System Change Requests (SCRs)

lMigrated SSIS packages (2005 to 2008R2 and R2 to 2012 and 2014).

lCreated a Dashboard for heads up displays depicting real time status of servers and jobs, utilizing SQLCMD.

lTrained less experienced administrators.

lInstalled/configured/maintained 2000/2005/2008R2/2012/2014 standalone/multi-instance/clustered environments. Planned and coordinated data migrations.

lDeveloped load procedures using SQL and other procedures to keep the Database current.

lExperienced in creating database Objects (e.g., Tables, Stored Procedures, Views, Triggers, user defined data types and functions).

lCreated Database Maintenance Planner for Performance Integrity Checks, Update Database Statistics and Re-indexing, checking integrity, backup and recovery, rebuilding and reorganizing indexes, updating statistics and running DBCC, Database backup and Disaster recovery solutions.

lSetting up and monitoring high availability solutions such as Replication, Mirroring, Log Shipping and Failover Clustering.

lDocumented processes for installations, clustering, patching, BI, SQLCMD, BCP, Mail, Alerts, SSRS, Disaster Recovery.

Consistently monitored 50+ instances and 400+ DB's for proactively monitoring of SQL Server using DMV'S, SQL Profiler, perfs, logs, and Event Viewer using Links/BIDS/SSIS/SSRS. Monitored, optimized and requested allocation of physical data storage for database systems.

lUsed BIDS/SSIS/SSRS/XML/SQLCMD/BCP in automating numerous ETL processes, data modeling, solution deployment and maintenance. Centralized SQL, SAS, Oracle, Linux/Unix/Solaris source environments into SQL Server, designed data captures to organize, analyze and report from external sources.

lDesigned and developed different types of reports including; Drill through reports, Sub reports, and Drill down reports based on business requirements using SSRS.

lResponsible for ongoing maintenance and change management to existing reports, as well as optimizing report performance, server health, job status and addressing user/dev/job requirements.

lCreated SSIS packages (DTS 2000, 2005, 2008, 2012, 2014) executing various ways (e.g., Compiled Hosted in MSDB, Agent cmd, SQLCMD, etc.).

lReduced work flow processes by replacing steps with automated data solutions (SSIS/SSRS) for Senior Leadership, Project Managers, Engineering, Developers (e.g., index health, etc.) and DBA Environment Status/Health.

lCreated Configuration Management workflow processes to execute DB scripts ensuring Quality Assurance of production releases.

Diagnosed job errors, worked with developers/Server Administration as necessary to solve break/fix and other issues.

lPerformed Database Security, Requirements Analysis, Database Performance Tuning, Large Clustered System Implementations/Migrations.

Performed routine maintenance, monitored and tuned databases using Performance Monitor, SQL Server Profiler and Dynamic Management Views; implemented and maintained security rules and security audits; and, maintained state of audit readiness;

Data analysis and cleansing, data transfer and operations, create reports and processes for reports.

Facilitated implementation of Defense Information System Agency's (DISA) Security Technical Implementation Guide regulations on SQL Server database servers.

Extensive knowledge of using VB.net and VBScript for data manipulation.

lMaintained and performed On-call rotation.

AFPC- PMO CoreComm & DBA

Scripted and automated SMS pushes automating application and system updates and upgrades, meeting IA overall goals AFPC-Wide. Developed scripts optimizing upgrade processes and integrating automated services. Engaged in all aspects of the department.

lCreate/push SMS automated Client/System utilizing vbs compiled WMI files remotely executed via automated schedules.

lCreated an in-house solution for testing client applications for the first Air Force Standard Desktop.

lInteracting on inter-personnel request from General Stewart to stand-up an internal e-mail solution for applications.

lCreated DNS (CNAME's) with associated MX Records to achieve systemic applications-driven mail traffic tests inside application relayed traffic, to avoid production saturation of relayed traffic. SMTP Relay Servers Dual Symantec Relay Servers in support of Third tier Military and Civilian Application outages. Configured BIG IP “F5” ensuring controlled traffic flow.

lStood up the first A1 (Pentagon) AFPC list server, implementing emergency development application SMTP solutions over Air Force Relays.

Corvel Corp, Austin, TX 01/1999 to 8/2004

Area IT Manager (Hands On)

lDeveloped, implemented, and administered a diversified window of development/networking solutions.

lExtended mainframe data reporting and multiple interfaces for customers as Texas Municipal League, Service Group Insurance/Service Lloyd’s Insurance, Texas Builders Insurance, Attorney General Crime Victims Division, Association Casualty Insurance, and others,

lMultiple, departmental, internal and customer based status reporting available on-line involving multiple record layouts, customizing imports/exports, integrating data automation, and cross platform database servers such as, AS400 to VMS, MSSQL and Gupta SQL environments.

lUsing a variety of reporting tools such as Crystal Reports and Enterprise I also created multiple AS400 on-line data solutions and software utilities for reporting and lookup’s increasing proficiency.

lIntegrated cross platform databases and daily-automated EDI’s to include: VMS, Oracle on Solaris, SQL Server, Gupta, DB2, flat files

lIn-depth experience in AS400 data development, reports and custom software interfaces.

lIn-depth experience with integrating AS400 and other server and development platforms.

lExperience in hosting, and developing web based data projects from AS400, VMS, SQL.

lExperienced in multi-tier networks, routing, switching, fault tolerant high-end server technology. Hands-on background in LAN/WAN environments, with proven skills in system and data optimization.

lExtensive hands-on background in LAN/WAN and Development environments.

lAbility to translate technical issues/solution into practical English

lCreative problem solver – ability to use existing resources to solve issues.

lTroubleshooting ability - ability to go to the core of the problem.

lI have managed the setup and optimization of numerous complex and critical multi-cross platform data and reporting solutions

lIntegrated pharmacy data into existing layouts for numerous insurance companies. Helped program Service Group Insurance Company’s to integrate their platform environment to support Pharmacy bills.

lDeveloped numerous status detail reports and analysis on employee processes, insurance customers reductions/profits, product specific growth, and services such as multiple bill review processes, pre-certification processes and other related services.

lEnd-to-end data solutions thinker creating an on-line customized bill review control process for Association Casualty Insurance Company, which after bills where reduced insurance adjusters approved which bills to pay from a custom on-line interface.

lCreated many customized solutions for data validation and quality control for EDI processes.

lDeveloped several software utility code related lookup programs increasing productivity and saving time from adjusters and analysts looking through multiple thousand page books.

lDeveloped an internal program for Service Lloyds Insurance to invert a flat file from bill review and pre-certification services into an AS400 format. I developed a cross platform EDI on-line transfer update for Texas Municipal League importing data from their AS400 into an Alpha VMS platform.

lDeveloped a regional PPO Web based database for the Texas Ppo department inputting data, data searches, updating different networks and providing real time integrated stats for management on developer progress, network, and other stats.

lDeveloped an on-line optical imaging bill review process for Texas Builders Insurance Company.

lRetained by Corvel Corporate in coloration with corporate development to win a state bid by developing state rules against data reflecting reporting stats of greater reduction costs per each Medicare bill.

lDeveloped and sold a Medicare based program to a national healthcare management company, which by running bills through reduced insurance costs significantly.

lMy other strengths include developing network designs, procuring software and hardware at reduced costs, and setting up, configuring optimizing networks, systems, and software development.

lProficient in many server technologies, back-office utilities, and cross platform environments.

lExperienced at Internet based systems. Master in diagnosing and troubleshooting LAN/WAN and system issues and making ends meet with existing resources. I’m also a creative thinker, quick learner and team player.

lProvided IT support for many satellite offices located across the country. I was responsible for every aspect of software development solutions, LAN/WAN, including server configuration and optimization, archiving and backups, performance monitoring, domain administration, hardware installation and configuration, etc…

lIntegral part of a team and crucial member in installing and configuring a variety of complex networks from both the hardware and software side. I was also instrumental in developing 3 junior system engineers into mid-level system engineers.

lEstablished an NT Domain PDC/BDC environment integrating a domain model with a Novell 3.12 network, and established dual authentications.

l Improved Network performance, implementing a switched network configuring cut through for better throughput.

lBuilt, and managed network faxing, using 95-Exchange routing incoming faxes to the recipient, and used 2000 advance server for a remote solution via a domain trust which received incoming faxes and sent to the remote server.

lBuilt & manage multiple SQL2000 servers using Query Analyzer, DTS for remote table updates, and created database infrastructure using SQL virtual databases loaded into memory.

lCreated VMS reporting solutions.

lImplemented Web Enabled Database Solutions with Access, and SQL backend.

lEstablished communications with customer, and setup VPN with Attorney Generals Office for an optical imaging project.

lDeveloped an internal program for Service Lloyds to invert a flat file into an AS400 format.

lCreated an intuitive Web enabled Helpdesk program including integrated reporting, automatic email updates, and page alerts based on priority.

lCreated a PPO Web enabled database for the state of TX for all TX developers to house their data, and a way to track developer progress, with online integrated reporting using ASP, IIS5, and SQL 2000 Server.

lCreated a custom record layout for EDI’s with Association Casualty Insurance Company, for Texas Builders Insurance Corporation.

lWork closely with all customers to implement programs.

lMoved an entire Data center in the Houston Branch office.

lEstablish support guidelines; make decisions on software, and hardware based on diversified needs, while incorporating the least cost.

lCreated a scanning solution for Texas Builders, taking online bills CorVel received to audit, scanning results of the audited bill, and FTP’s to customer.

lSetup Multiple hosting services including web sites, and ftp sites for multiple customers.

lCreated several RAS Servers, and currently maintain VMS server.

lDeveloped an automated FTP program for the Kroger account, which searches, renames, deletes, and gets, with a GUI, and Progress associations. And much more. . .

lDeveloped several data solutions from AS400 and cross platform environments.

lDeveloped many reporting solutions from the AS400 environment.

lDeveloped custom solutions for the AS400 environment tailoring to insurance customers.

lDeveloped many VMS reporting solutions.

lDeveloped an internal program for Service Lloyds to invert a flat file into an AS400 format.

lDeveloped Web Enabled

Contact this candidate