Experience

• 

  Science and technology, inc. , huntsville, al

  Jun 1985 - Jan 1988

  Programmer

  Using CA/IDEAL on the OS/MVS Amdahl 5860 computer, CA/PC Datacom, SIMWARE/SIMPC and Dbase III Plus: Wrote several programs of the Army Automation Resources Planning Management Information System (ARPMIS-mainframe) for inventory control of all army-wide ADP equipment. Wrote PC version of the ARPMIS system providing file transfer (upload/download) capability. Wrote in-house programs providing internal control of system changes for the projects using Dbase III Plus.

• 

  Computer associates, inc

  Jun 1985 - Jun 1988

  Programmer/analyst

  Using CA/IDEAL, Procedures, JCL and DATACOM/DB utilities: Provided programming support for the US Army Forces Command on two Forces Command (FORSCOM) mainframe applications. At Fort Stewart, provided on-site support to convert the Army Continuation Education System from IBM/DMS to CA/DATACOM DB.

• 

  Digicon

  Oct 1989 - Feb 2000

  Sr. programmer/analyst

  (Jul 1998 – Feb 2000) Using COGNOS OLAP tools, ERWIN/ModelMart, Oracle 8.0/7.3, and SQL: Developed business intelligence data cubes. Worked closely with HQ FORSCOM G-4 Medical Logistics officer to identify, refine, and ensure accuracy of the data cubes. This effort included requirement analysis, data analysis/cleansing/extraction/query, creating reports and multi-dimensional data cubes for supporting predictive analysis of readiness and redistribution of FORSCOM equipments. Developed Entity-Relationship diagrams for data modeling, Process Flow diagram and OLAP documentation. Created an Excel template to retrieve data from Oracle database, evaluate readiness, and populate to Excel worksheet using VB5, ADO, and Oracle.(Sep 1997 – Jul 1998) Using UML, Visual Basic 5.0, Visual SourceSafe 5.0 and SQL Server 6.5: Worked on the development of a 4-tier web-enabled client/server system to support Resource Management for the US Army Reserve Command. Developed Use Case diagrams to capture functional requirements, business rules, and to define business objects (classes) and object attributes. Developed stored procedures, User-Centric and Data-Centric Business Objects (ActiveX DLLs), and User Interfaces (ActiveX Controls and Executables) for part of the Resource Management Order Writer System. (Jun 1996 - Sep 1997) Using Visual Basic 5.0, SQL Server 6.5, Visual SourceSafe 5.0, RDO, and Crystal Report 4.6: Developed programs (ActiveX controls and DLLs), stored procedures, tables, views and triggers for client-server application systems in support of the Force Structure and Accounting Division of the US Army Reserve Command. (Sep 1993 – Jun 1996) Using Information Builder’s PC/FOCUS Hierarchical Database Language, VSCOM and Carbon Copy communication software: Provide programming support for the convoy movement tracking and financial/fund control applications for the National Guard and US Army Reserve Commands. Show less

• 

  John h. harland company

  Feb 2000 - Sept 2000

  Software development architect

  • Created BI data cubes and reports using COGNOS scripting and tools. • Wrote VB programs for part of the Customer Information Management System and the Repository System for the DW/DSS department using VB6, ADO2.5, ANSI-SQL (INFORMIX).

• 

  Digicon

  Oct 2000 - Jul 2011

  Oracle dba

  • Provided database administration functions, maintenance and support for the U.S. Army Forces Command, Atlanta, GA. • Managed the production, staging and development databases housing both transactional and snapshot data for .net application system (WDS) and COGNOS reporting. • Implemented database security and auditing in compliance with the Department of Defense Information Assurance Certification and Accreditation Process (DIACAP) following the DB STIG V8.1 guidelines. • Configured and upgraded the production databases for Oracle 8i, 9i, 10gR2 and 11gR2 on the DELL servers (DELL PE 6650, 6850). • Installed Oracle software (servers and clients), OID, ODP for .NET (10.1.0.3.0) and ODAC component. • Setup Oracle Heterogeneous Service from 64-bit Oracle 11g to 32-bit Sybase 11 ASA for daily refresh of materialized views, remote query and data pull. • Applied quarterly Critical Patch Update. • Automated data refresh weekly and monthly using secure FTP scripts, SQL Loader, SQL scripts and batch files. • Provided database backup and recovery using RMAN’s 10g Incremental Merge and batch files. • For capacity planning, prepared server specification and disk layouts (RAID10) for 2 production database servers:- DELL PE 6650 & PV220S and new DELL PE 6850 & PV MD3000 SAS based upon Optimal Flexible Architecture standard. • Tuned Oracle instances, queries, and indexes. • Experienced with Table Partitioning, Materialized Views, Data Pump, Export/Import, SQL Loader, SQL Trace, SQL scripts, FTP (SSH/SSL) scripts, PL/SQL stored procedures, triggers, EM, TOAD and dbms_obfuscation_toolkit (9i). • Experienced with data loads (structured & unstructured), data cleansing and data extraction using SQL Loader, MS/DTS, PL/SQL (dbms_lob) and SQL scripts. • Worked with Advanced Replication (Multi-Master) in 9i. • Redesigned an Individual Development Plan (IDP) database using ERWIN and migrated data from SQL server to Oracle 9i using MS/DTS. Show less

• 

  Morphotrust usa (fka: l-1 identity solutions)

  Jul 2011 - Jan 2018

  Sr. oracle dba