EDI/Data Analyst

Faith Wainwright

Summary

Extensive experience with EDI, Excel reporting, research and system queries.

Developed and documented processes for several positions and teams.

Assisted Issue Management team with Enrollment system conversion by data evaluation and coordination

Validated mismatched data between the enrollment systems and client files to determine corrections needed

Perform various Excel functions to group policy primary & dependent data for analyzing termination dates

Utilize Excel Vlookups to compare and update spreadsheets with correct system information

Created and maintained Trading Partner EDI transmission setups in the AS400 system or proprietary systems and Sterling Integrator

Created profile on EDI server for several forms of transmission protocol

Provided analysis and solution for production issues on EDI server or file configuration application

Interfaced with vendors and customers regarding conversion to EDI or production issue resolution

Education

Upson County Technical School, Thomaston, GA Accounting I & II

FSCJ, Jacksonville, FL 29 credit hours

Awards

Editor’s Choice Award

Raising the Bar Award 3 times

Certificate of Appreciation Going Over and Beyond

President’ s Award of Excellence Nominee

Client Customer Satisfaction Award

Director’s Outstanding Customer Service Award

MS Office Suite Certificate of Achievement

Quality Parking Place 2 times

Skills

Strong analytical and critical thinking

Attention to detail and time management

Very proficient in Microsoft Office Suite

Excel V-Lookup, Conditional Formatting, Data Analysis, functions, advanced filters, macros and Pivot Tables

MS CRM queries and various meter reading systems

Text converters; ie, Boxer and Monarch, Snipping tools, Visio, Salesforce, etc.

Word processing at 60 WPM

10-key by touch, 173 strokes per minute

Minimal experience SQL queries using Viewpoint

Professional Experience

Allstate Benefits, Jacksonville, FL

10/16-6/30/17

System Data Analyst

Managed Workflow Database unassigned files and cases.

Fixed file ftp issues due to missing setups, incorrect ftp path and naming convention issues.

Resolved and reprocessed Benefit Platform file errors and unprocessed bombed files.

Created file and account configuration for Multi-Record, Simplified Data and Genelco files from companies with employee supplemental insurance selections.

Validated client’s test and production files through MS Access, manually proofing employee premiums, providing feedback and follow up to move files into production.

Prepared Implementation Packages for sold opportunities containing file data information, specs and rate charts for all insurance plans sold to the client.

Assisted management with any special projects such as year-end file clean-up, CRM updates and file exports from proprietary databases.

Researched case issues in CRM, Billing Platform, Customer Service Platform and electronic documents to correct and reprocess bad Enrollment Data.

Florida Blue, Jacksonville, FL

5/2016-09/2016

IT Business Analyst

Assisted Issue Management team with Enrollment system conversion by data evaluation and coordination

Validated mismatched data between the current enrollment system Servicelink and Siebel to determine corrections needed

Performed various Excel functions to group policy primary & dependent data for analyzing termination dates

Utilized Excel Vlookups to compare and update spreadsheets with new system report information

After conversion, evaluated failures for cause and resolution

Baker Distributing, Jacksonville, FL

7/2015-2/2016

EDI Business Analyst

Created and maintained Trading Partner EDI transmission setups in the AS400 system

Created profile on EDI server for several forms of transmission protocol

Provided analysis and solution for production issues on EDI server

Interfaced with vendors and customers regarding production issues or possible conversion to EDI

Converted partners to exchange X12 4010 files 850, 810, 855, 856 and 846

Created VBScripts, File Definitions and new Job Processes for special partner requests through the Sterling Integrator

Utilized Viewpoint software to create SQL queries

Manually reconciled daily all invoices on EDI server to AS400 database

Gathered inventory of all vendors for future testing and current partner’s transmission protocols, job names and special scripting

Yardi, Inc, Jacksonville, FL

8/2014-7/2015

Research Analyst

Prepared annual budgets for several high-level property management groups

Developed 15-year maintenance forecast for top client with over 100,000 units

Initiated projects to identify missing links between multiple systems using MS Dynamics CRM queries

Performed Quality Control as needed for several high profile clients & special cases

Assisted proposal coordinator by performing audits for material & labor proposals for property

Yardi, Inc, Jacksonville, FL

10/2010-8/2014

Quality Control Analyst

Verified maintenance visits, communicating issues, impacts and possible solutions to management

Implemented quality measurements along with identifying areas of improvement for team

Assisted management and HR to gather confidential information on problem technicians

Performed audits of various read systems, compiling reports for management & external clients

Involved in merger of three systems of data accuracy analysis for new database MS Dynamics CRM

PSS World Medical, Jacksonville, FL

1/2010-7/2010

EDI Onboarding Coordinator

Participated in converting from paper purchase orders and invoices to EDI process

Interfaced with vendors to review requirements and specifications

Created purchase orders in JD Edwards and updated vendor database

Utilized Gentran Integrated System to create code lists, envelopes & export files

Worked with Sterling van to test vendor files

Brought on board 67% of vendors for 850, 810, 855, 997 and some 856 transactions

Smiley & Smiley, PA

8/2008-3/2009

Accounting Assistant

Assisted Senior Auditors in preparing work papers to test Florida Nursing Home Medicare and Medicaid charges to the government

Used the government licensing software Sunbiz.org investigated fraud of any related parties to nursing home offices and administrators

Created templates based on management requirements and enhanced formulas for existing templates as needed

Audited General Ledger to Cost Report and Cost Report to balance sheet

Prepared specific analytics for auditors to review and use for facility testing

Assisted senior auditors in any area as requested and assisted team with any computer or email issues. Provided Microsoft Outlook training to all auditors and assistants

Nelnet fka Intuition, Jacksonville, FL

7/2000-8/2008

EDI Transmission Analyst

Setup and maintained EDI transmission by creating physical files, directory paths, name patterns and sessions in the AS400-ISeries

Provided analysis for production issue resolution for any EDI related situation

Technical lead on projects which included Disaster Recovery exercises and on-call duties

Encryption key exchange and UAT with client for pop3/smtp, https and ftp set ups

Tested case scenarios during conversion to XML and proofed all team system changes

Worked with the Change Management team to promote tested changes to production

Maintained file inventory database for over 3,000 clients

Prepared daily forecasting of system peak times for management

Gathered measurements for company-wide objectives of system and transmission protocols

Nelnet fka Intuition, Jacksonville, FL

1/1999-7/2000

Documentation/Report Specialist

Managed transition of AS400 procedural documentation from WordPerfect to MS Word and then to a web-based product, RoboHelp

Created work flow charts for the AS400 process flow documentation

Updated system documentation after enhancements by Engineers and System Analysts

Gathered data to forecast system processing times during educational peak periods

Interline fka Barnett Brass & Copper, Jacksonville, FL

8/2000-1/2001

EDI Specialist

Monitored and assisted with mapping of EDI files between Barnett and client purchases using mainly the 810, 880, 997, 855, 856 & 850 layout

Client interface setups using Goldmine vendor management system

Interline fka Barnett Brass & Copper, Jacksonville, FL

9/1999-8/2000

Database Administrator

Assisted in creating company’s new website and online catalog

Excelled in side-by-side comparison of website to hard copy catalog

Helped in developing online catalog sales layouts

Worked with vendor to create hot keys and codes for special characters in website database

Trained part-time data entry employees

Interline fka Barnett Brass & Copper, Jacksonville, FL

8/1998-9/1999

Product Dev Marketing Asst

Supported General Merchandising Manager, Marketing Manager and Product Managers

Developed advertising page layouts

Updated catalogs with new pricing & sales information

Revised mainframe system with any price changes

Contact this candidate