Database Analyst Federal Government
Resume:
Roger A. Zions
**********@*****.***
Experience
*/**** – 10/2022
ScribeDoc, Inc.
Database Analyst - Fairfax, VA
100% remotely.
Hired to create a database system for the Federal Government.
Microsoft Access, Microsoft Excel, SQL and VBA were used.
When the database is opens only a form shows, preventing the User from viewing anything else.
The form only consists of combo boxes, list boxes and check boxes, for the purpose of the data being entered correctly and making the entry of information easier for the User.
After data is selected from a combo box, other information on the form is automatically filled.
Database is located on the server, where the data can be shared.
Each User is linked to the server and able to enter data and run queries symmetrically.
The results of each query are shown both in the format of a spreadsheet and chart.
Never assisted.
Reason for leaving: I resigned because my co-workers were very difficult to cooperate.
2/2019 – 12/2019
Database Analyst
Bestica, Inc. – San Antonio, TX
Worked in Arlington, VA. as a Contractor for the NAVY Veterans Association.
Never met a co-worker in San Antonio, TX.
Never assisted.
Often had to work remotely when Commander not in office.
Created a database to store data of the health benefits for the NAVY Veterans Association.
Extracted, transferred, and loaded data into the database every week.
Created dozens of queries and with a simple click on a button to view the results.
Reason for leaving: The Federal Government transferred the position far from my current residence.
4/2007 – 12/2018
Data Analyst
SoHaR – Culver City, CA
Worked as a sub-contractor for Engility Corporation, located in the DC/VA district.
Never assisted.
Never met a co-worker in Culver City, CA.
Creating a trend analysis presentation for the Federal Aviation Association.
Able to ETL all types of data, permitting the data to be utilized.
Used scores of functions in queries, from the basic Sum, Count, Max, Min to Crosstab-Parameters, and created forms, reports, and charts too. With Excel I created macros, used common functions such as DSum, DLookup and Pivot Tables and Pivot Charts.
Queries were used to view the results as spreadsheets and charts.
During tenure, my responsibilities increased from one project per month to five.
Dedicated maximizing the quality of each project.
Advised co-workers to choose most appropriate formulas or applications for specific projects.
Reason for leaving: The Federal Government made a budget cut in which I was laid off.
1/2006 – 3/2007
Database Manager
John J. Kirlin – Rockville, MD
Created database to enable Employer’s Management team to view their client’s requests, projects status, and history of each client.
The database was on the company’s server, with the Managers linked to the database, known as the Back-End to Front-End database. This allowed all Managers to view the database at the same time and update information.
Created time-sheet for the accountants, making it trouble-free, by using BE/FE database.
Reason for leaving: The position was discontinued, in which I was laid off.
Education
Salisbury State University, Graduated 1989
Bachelor of Arts
Contact this candidate