Microsoft Office (Including PowerPoint, Excel, and Word)
Czarinna Clay
Data Analyst
Denver
Summary
Enthusiastic Data Management Specialist eager to contribute to team success through hard work, attention to detail and excellent organizational skills. 5 years training and an additional 4 years workplace experience as a data analyst with proven ability to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data and Data Visualization. Clear understanding of ArcGIS, SharePoint, proficient in Excel, SQL and Power BI. Motivated to learn, grow and excel.
Overview
7
7
years of professional experience
2021
2021
years of post-secondary education
Work History
Data Management Specialist
BLM Through Contractor - NV5
10.2023 - Current
- Created Power BI dashboards to increase project visibility and progress towards goals, allowing for easier insight by management and improve the decision making process.
- Created reports on requested topics to support federal staff in improving data management knowledge.
- Part of a 4 person team that created a BLM wide Active Directory hosted on SharePoint that allows for easier determination of project stakeholders across the board.
- Updated legacy data standards to match the 2023 formatting and file system, improving consistency and legibility in BLM Data Standards.
- Worked with interdisciplinary teams including data stewards, business analysts, data administrators and GIS specialists to determine business needs and produce data management schemas that met those needs.
- Supported federal staff to record the integrity, quality and accuracy of data used in various projects.
- Managed data within GBP infrastructure (ArcGIS Pro)
- Created a Standardized Operating Procedure for dashboard updates.
Technical Analyst
Relatient
07.2022 - 02.2023
- Designed and maintained consistent data collection protocols and standards across numerous databases and projects. Databases and programming were held within SharePoint, GitHub, and Amazon Web Services (AWS).
- Adhered to strict HIPAA guidelines while working with confidential data. Data was only ever handled by the customer and myself or a team member. Any data pertaining to patient information was censored or sent in an encrypted file that was only accessible with a password.
- Mapped and Traced data from system to system to better solve customer concerns, utilizing mySQL, GitHub, and Visual Studio Code.
- Authored technical requirement documentation in Microsoft Word to suit business goals and technological limits. Exported these documents to PDF to be viewed in Adobe Acrobat.
- Undertook technical maintenance of various database systems on AWS and developed database schemas to meed business data requirements through a combination of SharePoint, Visual Studio Code, Microsoft Word, and Excel. Authored guide on how to maintain said database schema and formatting guide to file naming and quality verification.
- Communicated technical findings via lay terminology using Microsoft Word, PowerPoint, and Excel to keep interdepartmental teams informed on vital developments.
- Lead weekly client calls via Microsoft Teams to update project stakeholders on important updates shown through Excel and PowerPoint.
- Authored training documentation in Microsoft Word, regarding pulling from databases using mySQL, which was distributed via SharePoint.
Materials Project Manager NPI Contractor
Lam Research Corp.
07.2020 - 05.2022
- Collected, consolidated, and analyzed data - utilizing mySQL, SAP, and Excel - to create material risk reports in Microsoft Word and PowerPoint for team members and upper management.
- Designed data reports and excel based reporting tools using VBA for weekly meetings with project stakeholders. Created excel macros to automatically process new data and training documents on how to use said Excel workbooks.
- Provided support to Engineering and Business Analyst team with data analysis and data modeling within Excel to assist with management decisions and data clarity.
- Analyzed data in Excel gathered weekly through SAP to identify patterns and correlations to report back to project stakeholders.
- Identified data requirements through meetings with management and customers.
- Created various change record documents in Microsoft Word to assist with pulling metrics data and recorded data sources.
- Established new reporting methods for interdepartmental requests. Reporting formats were created in Microsoft Word and Powerpoint, and distributed through SharePoint.
Graduate Research Assistant - GIS Programmer
Tennessee Technological University
03.2018 - 08.2018
- Created a model in ESRI's ArcGIS 10.5 that reduced cost incurred by Tennessee Department of Transportation by reducing need for field-level studies. This was accomplished using a combination of Raster, Vector, and LiDAR data and utilizing a program I built within ArcGIS Model Builder.
- Contributed to research and data analysis utilizing geospatial data. Gathered data from state databases and Google Earth Engine.
- Improved quality and legibility of data provided by the Department of Transportation for academic use. Cleaned files to be more easily read and pertain to the study area, extracted important features, cleaned up file names, and recorded metadata.
- Developed quality control for future data and metadata for the project as well as the database schema. Created a Microsoft Word guide on how to maintain said database schema and formatting guide to file naming and quality verification.
- Metadata followed the standard format presented within ArcGIS 10.5.
- Gathered, organized and entered geospatial data into ArcGIS, maintained metadata and geodatabases. Ensured consistent naming conventions and verified file accessibility after exporting.
- Analyzed acquired information and presented to professors utilizing a diverse multi-media approach through Microsoft PowerPoint, Excel, Word, Adobe Illustrator, and ArcGIS 10.5.
- Created training documentation and workflow diagrams for team members. Workflow diagrams were largely created in ArcGIS ModelBuilder as opposed to Visio, and the workflow was explained in depth in the Training Manual.
- Created a troubleshooting guide to assist team members in the event of any future questions.
Graduate Lab Coordinator - Earth Science
Tennessee Technological University
08.2018 - 12.2019
- Developed and managed organized, orderly student databases and tracking systems in Excel.
- Liaised between faculty and students to answer questions and optimize faculty time.
- Assisted faculty members with data collection via Excel for potential academic publications.
- Led weekly seminars to discuss research findings and build ideas to progress projects that utilized Excel, R-Studio, SQL, and ArcGIS Pro.
Education
Professional Science Masters - Environmental Informatics
Tennessee Technological University
Cookeville, TN Jan 2018 - 12.2019
Bachelor of Science - Biology And Geoscience
Tennessee Technological University
Cookeville, TN 01.2018 - 12.2018
Skills
Data collection and analysis
Project Management
Team collaboration
Critical Thinker
Ability to work under pressure
Advanced problem solving
Technical Writing
Effective communication
Technical Analysis
Remote Technical Support
Data Collection Monitoring
Software
R
Python Scripting
SAP
SQL
ArcGIS
ArcPro
QGIS
Adobe Acrobat
Visual Studio Code
AWS
Power BI
Timeline
Data Management Specialist
BLM Through Contractor - NV5
10.2023 - Current
Technical Analyst
Relatient
07.2022 - 02.2023
Materials Project Manager NPI Contractor
Lam Research Corp.
07.2020 - 05.2022
Graduate Lab Coordinator - Earth Science
Tennessee Technological University
08.2018 - 12.2019
Graduate Research Assistant - GIS Programmer
Tennessee Technological University
03.2018 - 08.2018
Bachelor of Science - Biology And Geoscience
Tennessee Technological University
01.2018 - 12.2018
Professional Science Masters - Environmental Informatics
Tennessee Technological University
Jan 2018 - 12.2019
Similar Profiles
Yalili LealYalili Leal
Administrative Assistant at NV5Administrative Assistant at NV5
Collin Lee DavisCollin Lee Davis
Deputy Inspector at NV5Deputy Inspector at NV5
Mario I TrujilloMario I Trujillo
Field Engineer at NV5Field Engineer at NV5