Records Analyst / Data Manager

Paul Gamblin

Greater Atlanta Area 678-***-**** **********@*****.***

www.linkedin.com/in/paulgamblin

* **** ******* / ******* *******

Dedicated, knowledgeable and service-oriented Data Manager / Records

Analyst in an insurance-related environment. Recommended for his work

ethic, diligence and integrity. Demonstrated ability to protect the

confidentiality of sensitive data and to maintain the integrity and

security of data. Known for being a team player possessing great integrity,

organizational skills and discipline. Core competencies include:

Database administration. Created or edited Access databases to run reports

or verify data integrity. Processed electronic enrollment file conversions

to prepare data for QicLink database. Cut processing time on enrollment

file conversion by 50% for one of our larger groups (of 15,000+ enrollees).

Records management. Operated document scanning and processing equipment.

Verified accuracy of document indexing system. Created SQL statements to

update DB2 database as needed to correct index errors. Helped to avoid

company losses of anywhere from $10K to $5M per claim through claims paid

in error (or policies issued in error) by researching / retrieving missing

documents.

Data archives. Identified operations data to be archived and isolated it in

folders. Set up and performed data archive jobs using TSM (Tivoli Storage

Module) and deleted empty folders after archive was done. This allowed IT

to concentrate on other functions and solved their problem of how to

manually identify operations data to be archived.

2 Professional Experience

1 August 2014 - Present Man Your Stations, Inc. Newnan, Georgia

Man Your Stations, Inc., is a locally-owned company exclusively contracted

to Coweta County for the receipt and handling of household trash and

recyclable products.

2 Independent contractor

Monitor incoming customers to Herring Road facility.

Operate trash compactor as necessary.

Sort recyclables as necessary

Spot-check cardboard for styrofoam and/or plastic left in boxes.

Report weekly counts.

2 May 2010 - March 2014 Document Technologies, Inc. Dunwoody, Georgia

Document Technologies (DTI) is the largest independent provider of on-site

facilities management services and electronic data discovery solutions

servicing top law firms and corporations nationwide.

1 Evidence Coordinator

Worked with Storage Administrator to streamline a procedure of incremental

data backups to help prevent system downtime due to network storage space

issues, which prevented an off-budget memory purchase of $31K.

Regularly received and securely logged electronic media sent in by our

clients for processing, then safely copied that media to staging network.

Also flattened forensic computer images using EnCase or FTK Imager.

Processed documents to prepare for legal presentations using electronic

discovery programs such as IPRO eCapture and NUIX.

3 June 2005 - March 2009 Wells Fargo Third Party Administrators, Inc.

Newnan, Georgia

Formerly JSL Administrators, Wells Fargo Third Party Administrators

administers small group health and dental groups by processing enrollment,

claims, etc.

1 Business Systems Consultant

Improved personal productivity by 37.5% over the first six months.

Worked with advanced Excel spreadsheets, cut and pasted, exported as ASCII

files. Maintained HIPAA regulations on all confidential data.

Communicated with internal and external data providers to receive, decrypt,

convert, and load enrollment / electronic claims files daily. Files were

sent / received via FTP or SFTP, encrypted with PGP.

Ran Access database extractions via ODBC to verify accuracy of data uploads

to QicLink.

Contacted representative at Musketeer Group as necessary to resolve

problems with ZRTE program in QicLink.

Contacted coworkers in claims department, administration, etc., to ensure

receipt of data files loaded into QicLink.

Reset passwords for employees using QicLink system (on average at least one

per week).

Ran database extracts to generate various reports, and then sent files via

FTP or SFTP to banks or outside vendors.

Assisted medical claims department in re-pricing claims (~40 per day, on

average one day per week).

Assisted TReE (Tech support group at Salt Lake City office) with resolving

problems on co-workers' PCs - two or three times a week on average - which

helped decrease technician travel expenses.

2 October 1987 - June 2005 Primerica Duluth, Georgia

Primerica, a subsidiary of Citigroup, is a nationwide provider of life

insurance, financial services, mutual funds and home mortgages. Their

"Financial Needs Analysis" broke new ground in discovering and meeting

client's needs.

3 Records Analyst

Improved performance after each promotion or transfer to the point where I

became the subject matter expert (SME) in my function within four to six

months.

Increased productivity in New Business Policy Assembly filing area by

reorganizing the filing system, which decreased filing time by 10% to 15%.

Routinely helped to avoid company losses of anywhere from $10K to $5M per

claim by analyzing and retrieving key records in the database. This helped

me win the "Above and Beyond" award (similar to "Employee of the Month") 16

times in 17 years at Primerica.

Created and edited ~15 technical manuals for positions within the Image

Technology Center.

Wrote and performed SQL queries of database to update index data.

Conducted one-on-one technical training for around 10 new Image Technology

Center associates.

Prepared documents to be scanned (up to five or six batches of up to 2000

each at times).

Processed mutual fund account transaction requests (~five batches per day

of up to 50 transactions each).

3 Education and Technical Inventory

Associate of Arts Truett-McConnell College Cleveland, Georgia

1 Technical Inventory

Data extraction / forensic tools: IPRO eCapture, FTK Imager, Encase,

Monarch, Pervasive (Data Junction), FTP / SFTP

Operating systems: Windows, Unix

DBMSs: MS Access, QicLink (RIMS), some DB2 exposure

Languages: SQL, HTML, Joomla web software, PGP

MS Office tools: Word, Excel, Outlook, PowerPoint

4 Volunteer Experience

1 July 2013, June 2014 Family Partner Lighthouse Family Retreat

Norcross, Georgia

Served as Family Partner one week of each month listed, serving families

who are going through childhood cancer.

Family Partners come alongside Retreat Families and serve their needs

(laundry, sitting with children, praying, cleaning) while families are

given time away from the stress of dealing with the treatment of the child

with cancer.

2 October 2004 - October 2009 Transportation Coach Bill Glass Champions

for Life Dallas Texas

Participated as teammate to share Christ with prisoners in Atlanta area

prisons on seven different weekend events, in Atlanta, Perry, Birmingham,

and Montgomery.

Participated three years in a row on planning team for Atlanta Weekend of

Champions, a mission to share Christ with 15-20 Atlanta area prisons each

year.

Organized and Coordinated transportation for 20-30 platform guests (special

speakers) and 400-500 teammates for three years in a row to get everyone to

their assigned facility each day (Friday and Saturday), including airport

pick-up and drop-off for around 15 guests and/or teammates.

3 March 2009 - September 2009 Web Developer Crossroads Church Newnan,

Georgia

Participated on team led by Graphic Designer in building new church website

(www.crossroadsnewnan.org).

Created over 80 article pages in Joomla software for church website.

Created or edited about 60 menu links.

Contact this candidate