Herman Hill

**** ****** **.

Ft. Washington, MD *0744

202-***-****

adwhhc@r.postjobfree.com

EDUCATION

Bachelor’s Degree: Information Systems

Strayer University (Washington, D.C.)

Year of completion: 2006

TRAINING

• Microsoft SQL Server Fundamentals (11 weeks), Syracuse University, 2021

• R Statistical Analysis Course (11 weeks), Syracuse University, 2021

• Linux + (5 days), INFOSEC, 2021Microstrategy Data Analyst Course (5 days), 2020

• MicroStrategy Administration for Enterprise Analytics (5 days), 2020

• MicroStrategy Introduction to Big Data (5 days), 2020

• Oracle 12c Database Administration, Online Course, Skillsoft.com, 2017 - 2019

• Information Security (11 weeks), Strayer University, 2017

• Oracle 11g, Skillsoft.com, 2011

• DISA Information Assurance, 2010

• Learning Tree International, Oracle 1-Week Course, 2008

• Learning Tree International, Linux 1-Week Course, 2007 TECHNICAL SUMMARY

Operating Systems: Windows 10, Windows Server, Linux, Mainframe Languages: SQL, VBA, C#, PL/SQL, bash, PowerShell

Database: Oracle, MS Access, PostgreSQL, MySQL, db2, Sybase Microsoft Suite: MS Word, MS Excel, MS Outlook, MS Access Database, MS Power point Virtualization: VMWare, VirtualBox

SKILL SUMMARY

• 10+ years of IT professional experience in Database Administration industry with Oracle, PostgreSQL, and Access skills.

• Strong experience in Business and Data Analysis, Data Governance, Data Profiling, Data Migration, Data Mining, Data Conversion,

• Proficient in preparing Presentations, Graphs, Pivot Tables using Microsoft Excel and PowerPoint

• Proficient in ANSI SQL, Oracle SQL+, SQL Developer, and Oracle Enterprise Manager, Oracle Virtual Box Virtualization software

• Solid skills in writing PL/SQL, UNIX shell, Postgres Enterprise DB, Windows PowerShell, and Microsoft Visual Studio

• Knowledge of Oracle advanced infrastructure such as Oracle Real Application Clusters (RAC), container databases, Oracle Flashback, Data Guard

• Writing complex SQL queries for data validation for verifying the SSIS Packages and business Rules.

• Strong skills using Excel formulas, including SUM, VLOOKUP, HLOOKUP, Index, Match, IF Statements, Data Validation, Lists, Ranges, Pivot Tables

• Extensive experience with Visual Basic for Application in the context of both Microsoft Excel and Microsoft Access, including the construction of conditional statements. Loops, For-each, Case statements and the like

• Data Analysis primarily Identifying Data Sets, Source Data, Source Meta Data, Definitions and Data Formats.

• Experience in coding SQL/PL SQL using Procedures, Triggers and Packages.

• Experience in Data Analysis, Data Validation, Data Cleansing, Data Standardization, Data Verification and identifying data mismatch.

• Used most of the SQL Functions including character functions, number functions, date functions and conversion functions

• Queried various joins and sub queries.

• Widely used Case expressions in SQL queries

PROFESSIONAL EXPERIENCE

Randstad/Walmart Corporation

Data Manager

July 2022 – January 2023

Remote

Responsibilities:

• Worked with a team to inspect and improve data quality of Walmart database systems, including the quality tracking of product details, attributes, and other relevant consumer data

• Designed databases in MS Access to assist with rapid data entry, comparing attributes, and locating duplicate records

• Used common and advanced Excel features to facilitate data management and data munging

• Created macros and VBA code in Excel to expedite repetitive and mundane tasks

• Utilized SQL join queries wherever possible to detect duplicate or non-existent data in lists

• Worked with Walmart supervisors to improve processes and work more efficiently to accomplish projects

• Held regular meetings with team members to discuss project requirements, and to ensure clarity with regards to project goals, success, and timely completion

R&P Technologies

Data Monitor/Analyst

September 2021 – April 2022

Washington, D.C.

Responsibilities:

• Responsible for tracking data related to shipbuilding contracts for the U.S. Navy

• Utilized Microsoft Excel and Access to enter, track and filter data as needed

• Created software code in Visual Basic to ingest, process, loop through, and export data from MS Access into pdf files on a on-demand basis

• Processed, managed, and moved data by use of VBA recordsets and control statements, and conditional keywords such as If/Then, Case, For Loops, Do While Loops and the like

• Devised time-saving techniques for data entry, data management and data processing

• Built macro in Microsoft Word using Visual Basic for Application code to loop through recordsets and output data onto Word documents using Mail Merge features

• Created a tracking mechanism in MS Access to query and filter important data for reporting to supervisors and colleagues Beacon Hill Staffing

Temporary Staffer

September 2019 - August 2021

Washington, D.C.

Responsibilities:

• Developed database in Microsoft Access to track data used for New York Eviction Prevention Initiative funded by the federal government

• Created tables, queries and forms to facilitate management of important data

• Able to track work progress through the use of queries, forms and reports

• Provided useful time-saving tips and shortcuts to colleagues and staff CORMAC/FDA

MS Access Developer

January 2019 - March 2019

Silver Spring, MD

Responsibilities:

• Managed MS Access databases that house critical data relating to prescriptive drugs, lot numbers, and medical watch lists

• Executed procedures within VBA (Visual Basic) to manage metadata, count table records, and quantify queries and reports

• Worked with other database developers on a daily basis to ensure data accuracy, run reports for management, and make key improvements to front end and back-end design

• Designed VBA code as needed to loop through records and perform edits on database tables

• Integrated data from Access into Excel spreadsheets to facilitate data management to non-technical staff members

• Used SQL queries to manage data on forms and reports Exelon/PEPCO

Database Manager

June 2018 - December 2018

Washington, D.C.

Responsibilities:

• Responsible for making data entry processes more efficient through the use of MS Excel, Access and SharePoint

• Worked with users to design better and more effective methods to validate data and convert data into Oracle-based systems that require strict data entry values

• Used Excel and Access to analyze and transform data as needed Rose International

Cyber Analyst

July 2017 - Feb 2018

Rockville, MD

Responsibilities:

• Used special software to analyze and track e-mail phishing attacks

• Created an MS Access database to track the history and resolution of phish log tickets including various tables, parameter queries, forms and reports to expedite processing

• Prepared data from Excel to be imported into Access by aligning fields and verifying data type accordance Ross Professional Service

MS Office Specialist/Database Developer

August 2016 – February 2017

Washington, D.C.

Responsibilities:

• Worked with supervisors to correct errors in spreadsheet data, including re-organizing data and re-managing data types

• Imported data from Excel to Access for user-oriented data analysis

• Created pie charts and stacked charts for managers to assess company trends and analytics

• Created various data entry forms and databases using MS Access and MS Excel

• Transferred large data sets from Google Sheets into Excel

• Able to sort, group and summarize data in Excel and Access

• Handled issues regarding various data types such as text, dates, and numbers

• Created formulas to do various calculations and sums

• Able to transfer data easily between Excel and Access

• Created other forms for data transfer between Access and SharePoint SAIC (Springfield, VA)

September 2015-August 2016

Database Developer/Admin

Environment: MS Access, Visual Basic, Windows

Responsibilities:

• Responsible for managing connections to and from back-end databases to front-end applications

• Backed up and maintained the databases

• Managed user security, passwords, and connections to the database in a multi-user environment

• Ensured database maintained superior performance over the network

• Utilized effective SQL queries and joins within the application code

• Extensive use of Visual Basic for Applications (VBA), as well as MS Access front-end and back-end databases

• Assisting in the development of User Interface (UI) forms, reports, and menus to facilitate efficient data entry

• Responsible for testing, verifying, and deploying new software updates as needed Lockheed Martin (Washington, D.C.)

September 2014-August 2015

Database Administrator

Environment: Oracle 11g, SQL+, Enterprise Manager, SQL Developer, PowerShell, Windows DOS Command Line Responsibilities:

• Served as the principal Oracle Database Administrator

• Manage database objects such as tables, views, functions and packages

• Assist with installation of patches and updates

• Create sql queries to gather important information about users, archive logs, table constraints, and other system properties

• Assist in the preparing the database for hardening as required by DISA STIGs

• Monitor space usage and space consumption on disk

• Monitor rman backups and daily data pump exports

• Consider methods to improve database performance

• Work with application developers to explore efficient ways to fetch and manage data

• Establish audit logs and flashback logging

Leidos (Alexandria, VA)

August 2013-May 2014

Oracle DBA

Environment: Oracle, SQL+, PL/SQL Data Guard, VMWare, Red Hat Linux, JIRA Responsibilities:

• Supported the Fusion Brain System which ingests data from multiple sources in order to provide a comprehensive knowledge database of important data for military command centers

• utilized Oracle 11g, DataGuard, and ASM in a virtualized environment using VM Ware/vCenter

• performed post-cloning activities for database virtual machines; managed Oracle accounts in a Linux environment

• troubleshot database issues such as connection issues, ip conflicts, and user profile issues

• responsible for executing DISA STIG scripts to determine database, network, and system vulnerabilities

• able to clone, snapshot, and review general information of virtual machines

• involved in the documentation of system features and functions

• assisted senior DBA’s with various database and system issues such as re-compiling invalid objects

• involved in the setting up of audit logs for the database Lockheed Martin (Washington, D.C.)

August 2012-May 2013

Oracle DBA/Software Tester

Environment: Oracle 11g, Sybase, RAC, Data Guard, Linux, Solaris, Service Manager, Responsibilities:

• Worked on a temporary surge-support project primarily involved with Oracle and Sybase upgrades

• Responsible for performing vital pre-requisite checks on Linux/Solaris servers to ensure they are adequately prepared for Oracle grid, RAC, and single-node database software

• Served as a liaison between the DBA team and Unix system administrators and storage engineers

• Utilized pre-built Unix scripts that test kernel parameters such as memory size, swap space, and file permissions in preparation for new database software; providing regular updates to managers in the progress and status of upgrade process and maintenance windows

• Executed Unix scripts to fetch data from the data repository to satisfy audit requests from management personnel

(occasionally made alterations to shell scripts using vi and python)

• Attended weekly status meetings with entire database management team to discuss procedures, issues, resolutions and work-arounds

• Worked on a team to help ensure software quality for the FBI Sentinel Program

• Handled Service Manager trouble tickets involving the Sentinel Case Management System

• Provided effective and timely customer service assisting FBI personnel resolve issues related to the Sentinel system Company: Force 3, Inc (Arlington, VA)

November 2010-December 2010

Role: Oracle DBA

Environment: Oracle 11g, Solaris, Enterprise Manager, SQL+ Responsibilities:

• Worked as an Oracle DBA in the Joint Operations Support Center (JOSC)/Joint Staff Support Center (JSSC) at the Defense Information Systems Agency (DISA)

• Responsible for monitoring databases, applications, reference files, and interfaces in the Joint Operation Planning and Execution System (JOPES) and Global Status of Readiness and Training System (GSORTS)

• Work with clients, customers, and other agency officials to assess their needs, provide information or assistance, resolve their problems, and satisfy their expectations

• Possess a thorough knowledge of DISA's Information Assurance policies and requirements

• Served on a temporary assignment to assist during a transition period

• Worked with other Database Administrators to gather system and database information from incumbents

• Helped to gather information about database configurations such as High-Availability Pairs, Oracle Grid, and Real Application Clusters

• Gained experience with IBM’s DB2 on mainframe platform Company: General Dynamics (Alexandria, VA)

May 2009 – October 2009

Role: Oracle DBA

Environment: Oracle 11g, IBM DB2, Mainframe, Enterprise Manager, Solaris, SQL+ Responsibilities:

• Served on a temporary assignment to assist during a transition period

• Worked with other Database Administrators to gather system and database information from incumbents

• Helped to gather information about database configurations such as High-Availability Pairs, Oracle Grid, and Real Application Clusters

• Worked briefly with IBM’s DB2 on mainframe systems Company: ITT (Washington, D.C.)

January 2007-November 2008

Role: Postgres/MySQL DBA

Environment: PostgreSQL, Linux, Solaris, MySQL

Responsibilities:

• Served as the Database Manager responsible for database maintenance, installations, back-ups, and data manipulation

• Maintained databases in a MySQL and Oracle environment using MySQL Administrator and Oracle Enterprise Manager Console as GUI tools and MySQL Command Line and SQL Plus for CLI-related tasks

• Devised various SQL scripts to check the status of system catalogs and user tables

• Responsible for data migration from Postgres7 on Solaris 10 to Postgres8 on Red Hat Linux

• Worked extensively with system administrators and Java/C developers to coordinate the effective flow of data between various subsystems and operating platforms~O2

Contact this candidate