- Imported and Exported files
- Created Pivot Tables
- Used VLookup and HLookup functions
- Designed and created custom charts/graphs
- Designed and created custom formatting
- Created command buttons
- Created/ maintained RDMS database tables, queries, views, functions
- SQL programming in SQL Server, Access and SAS
- Visual Basic for Applications (VBA) programming in Excel and Access
- Microsoft Access databases, created, modified, queried
- SAS programming, procs, data statements, sas sql
- Collected, analyzed, formatted and compiled survey, database and downloaded data
- Statistical analysis of numeric and character data
- Queried data in multiple large (million+ record) database files
- Analyzed data in Excel, Access and SQL Server databases
- Reported summarized data for management and clients in Excel tables and graphs
- Microsoft Excel
- Research and Data Analysis
- Microsoft SQL Server
- Microsoft Access
RECENT RELEVANT WORK HISTORY:
- I compiled, cleaned, interpreted and evaluated economic occupation and wage data.
- I queried agency data warehouse databases.
- I used Excel, Access, VBA and SAS.
- I performed complex statistical analysis on Higher Education economic data.
- I created databases in Microsoft Access and created tables, views, queries in SQL Server.
- I created Excel workbook applications.
- I wrote programming in T - SQL, SAS and VBA.
- Calculated and reported statistical data for the Confidential program.
- I created Excel workbooks and created and maintained SAS programming.