Data Anayst
Resume:
Tara King
Sarasota, Fl *****
*********@*****.***
OBJECTIVE: A challenging career and an opportunity for professional growth utilizing technical skills to meet business objectives.
TECHNICAL EXPERTISE
Advanced Knowledge in: SQL, Microsoft Reporting Services, MSAccess, MSExcel, MSWord, IVR, OCR, Paybase, Crystal, SSIS, DTS, .Net, Source Safe
WORK HISTORY
Sarasota Family YMCA 2006-2008
SQL Database Administrator/Developer Sarasota, Florida
Responsible for the backups and maintenance of databases
Perform complex data conversions from multiple file formats into SQL database using SSIS, DTS and BCP
Create complex stored procedures and user-defined functions
Create reports using SQL Server Reporting Services
Maintain SQL Server security
Design and maintain Crystal reports
Unisource Administrators – Insurance TPA & MGA 2003-2006
Data Analyst II Sarasota, Florida
Design DTS Packages to import and export claim and policy data between TPA/MGA and business partners
Create Stored procedures for extraction, interfaces. DTS packages, reports and analysis
Troubleshoot, analyze, and resolve all data related issues whether generated by the application, user error, conversions or scripts
Conceptualized, developed and deployed data model, work flow procedures & application design for aggregate and specific reinsurance tracking and reporting application
Automated the creation and distribution of month end reports (over 750 reports)
Utilize SQL for mass data updates, imports, exports, problem resolution, reporting and analysis
Develop reports in SQL Reporting Services, MSAccess and Crystal
HR Logic – Professional Employer Organization 2000-2003
Data Analyst Bradenton, Florida
Designed database for benefits department with a switchboard interface utilizing VB and macros to transmit electronic files to BCBS for open enrollment and subsequent mid year enrollments.
Preformed QA for new software releases and Web based applications
Developed testing matrix and procedures
Evaluated system data to improve operational workflow
Created reports for external clients as well as audit purposes using MS Access and SQL
Facilitated import of payroll data for the conversion from Payplus to UltiPro (payroll software)
Conceptualized, designed and wrote Positive Pay files for various banks including control reports.
Queried data and formatted to meet the DOL requirements for electronic reporting of new hires
Designed database for benefits department with a switchboard interface utilizing VB and macros to transmit electronic files to BCBS for open enrollment and subsequent mid year enrollments.
Trained users how to perform new time saving functions within software applications
Authored training material for new processes
National In Store - Marketing 1999-2000
Database Administrator Sarasota, Florida
Analyzed and solved computer related issues. Specialized with scanner software, data extraction and storage (txt, pdf and tif files)
Designed databases specifically for individual business needs
Responsible for the maintenance and manipulation of database.
Implemented proper procedures for more efficient data management.
In charge of paying employees nationally.
Enabled sales staff to acquire archived information within moments
Upgraded systems (hardware, software)
Maintained Key Voice System
EDUCATION
Keiser College 8/99 A.S. Computer Science
PROFESSIONAL CERTIFICATIONS
CNA - Certified Novell Administrator
Certified in OCR for Forms (Optical Character Recognition)- scanning software
Contact this candidate