We provide IT Staff Augmentation Services!

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

We'd love your feedback!