Database Analyst/gis Technician Resume
5.00/5 (Submit Your Rating)
Tallahassee, FL
SUMMARY:
- Highly organized/dependable employee with a positive attitude
- Works well under pressure; thrives on challenging projects
- Problem solver/team player with proven leadership qualities
- Strong analytical skills with attention to detail
TECHNICAL SKILLS:
MS SQL Server 2005/2008 R2/2014, Paradox 9, Transact - SQL, MS Access, Excel, MS Remote Desktop Connection, Crystal Reports, PL/SQL, PowerPoint, Visio, Oracle SQL, FoxPro 9.0, HTML, TOAD, Coldfusion, JavaScript, ESRI ArcGIS 10.3.1, SSRS, Tableau, Import/Export Data, SQL Server Management Studio
PROFESSIONAL EXPERIENCE:
Database Analyst/GIS Technician
Confidential, Tallahassee, FL
Responsibilities:
- Worked as Developer creating complex stored procedure, triggers, indexes, table views and joins
- Fine-tuned the logic in procedures and triggers for the best performance.
- Write SQL scripts and stored procedures using Transact-SQL to provide data for requests to internal and external customers
- Created TSQL scripts to manipulate and edit the structure of data received in various formats such as excel, access, text, .dbf, csv
- Load data into SQL server database using the import/export feature in SQL Server Management Studio
- Provide customer service
- Test development, beta and production websites for data errors
- Create/modify new and existing databases, tables, views and triggers
- Perform data entry either manually or from other sources such as excel, text, .dbf, etc.
- Develop graphs and reports of data results using Excel and Crystal Reports
Data Mining/Report Writer
Confidential, Tallahassee, FL
- Utilized knowledge in SQL to retrieve data for reports from an Oracle relational database by writing queries and scripts
- Designed/edited MS Access databases for reports
- Provided analysis of data for reports as it relates to performance
- Generated Workforce Investment Act (WIA) analysis reports for Workforce Florida Inc.
- Provided information after reviewing table relationships to determine how data can be retrieved/stored in the database
- Created maps using ARCGIS 9 software to display report data.
- Used FOXPRO 9 to create tables and manipulate large amounts of data
- Created/Updated data dictionary
- Provide monthly audit reports for Grants and Special Contracts programs run by One-Stop section. These reports provide the necessary and appropriate data to run the programs.
Web Application Programmer
Confidential, Tallahassee, FL
- ColdFusion programmer responsible for development and maintenance of the Florida One Stop Service and Tracking System(OSST)
- Designed complex reporting application tools that replaced paper reporting forms and helped make Case Managers service more efficient.
- Worked with the applications team to design and develop a hot jobs application for customers.
- Fixed errors from the ColdFusion Error Logs using JavaScript
Computer Programmer Analyst
Confidential, Tallahassee, FL
- Provided technical support
- Developed code, tested and debugged computer programs
- Updated and edited documentation of the web
- Interpreted technical information relating to computer programs
- Tested, edited, and ran programs which produced reports for user needs