Data Entry Database Administrator
Resume:
Herman Hill
Ft. Washington, MD *0744
*******@*****.***
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