Data Analyst

Technical Skills

Advanced knowledge of Microsoft Access and SQL Server Databases, PostgreSQL / PGAdmin

Visual Basic, Access and Excel

MAP Info Professional

FTP command line

Professional Experience

Marvelous Mystery Store Manager Mar 2019 to Present

- Management of POS System

- Customer Service Rep

- Cashier / Store Inventory

Self Employed Consultant Jun 2017 to Jan 2019

- Freelance Excel / Access Programming

- Business Consulting

BSG Financial Sr. Data Analyst/Technical Supervisor Oct 2013 to April 2017

- Technical Supervisor – Implementations and Production Data Mining

- Created normalization / data integrity checks in Monarch (Implementation and Pre-Load checks)

Partnered with YKS Marketing Business Consultant / Development Lead Jun 2011 to Sep 2013

- Consulting / development for PRC scanning and data transformation (using QR codes vs. barcodes)

- Developed routine to read barcode data from scanned images, transform data and FTP files to India

Humana, Inc Business Consultant Jan 2007 to May 2011

-Managed ETL data extract from Dunn & Bradstreet

-Managed Prospect Targeting Project using mathematical modeling to recast data for the Market Analysis Package

-Used MAP Info Prospect Targeting modeling system - also responsible for presentation of findings to the sales VPs.

-Created Group Sales tool to list prospects and rate the prospects based on Humana networks and pricing index.

-Managed the GEO Access Analytics Team. Responsible for reporting member accessibility to provider networks.

-Managed GEO Access reporting for HSD Project - Medicare HSD filings with the CMS (received Star Award for this)

Executive Communications Consultant and Design Specialist Oct 2006 to Dec 2006

-Involved in creating Access databases for Client Exit Interview process.

Parago, Inc. I/T Production Specialist (Acquisitions) Mar 2005 to Feb 2006

-Administrated the transition of LSY business to Parago

-Updated/Restructured web programming for all LSY customers using VB 6.0 and Cold Fusion

LSY Marketing Services, Inc. – Hired as Systems Analyst

Promoted to I/T Manager (Programming and Technology) Jan 1999

Nov 1997 – Feb 2005

-Reported directly to VP Technology

-Managed DBA and Web designer/programmer

-Managed the rebate check releases for $38,000,000+ / year

-Responsible for $80,000+ annual cost savings during last 3 years at LSY

-Supported offshore move of mail room, scanning and data entry operations to India for considerable annual cost saving

-Developed Data Entry Review and Document screens

-Developed automated billing routine for NMG invoicing using Visual Basic 6.0

-Developed new “quick” duplication checks (for determining fraudulent rebate submissions) using Visual FoxPro

-Managed the distribution of new program/marketing notifications to clients using Email Broadcast software

Contact this candidate