David A. Semotan

**** ****** **** **

Green Cove Springs, FL 32043-9266

Cell 860-***-**** E-mail: adc1av@r.postjobfree.com

Data Analyst with 15 years of experience analyzing data to drive business solutions. Proficient knowledge of SQL and other analytic tools. Excellent ability to understand business operations and data analytics to meet client business needs.

OBJECTIVE To obtain a challenging position that utilizes my superior research and analytical skills, and provides opportunity for increasing responsibility and career growth.

EXPERIENCE

06/18 to 02/20

Beeline Jacksonville, Florida.

Solutions Analyst, Integrations (06/2018-02/2020)

• Troubleshooting and maintaining VMS software for Beeline’s growing 300 clients.

• Resolved over 958 Service Request, Defect and Customer Support tickets for client VMS within a 24-48 hour turnaround time.

• Responsible for leading requirements gathering sessions with 30 clients to understand their business needs, workflows and functional requirements for building integration packages within Beeline VMS.

• Document, supervise and execute end-to-end testing of client technical requirements for integration using SQL and Data Analytics.

• Implement, configure and troubleshoot Single Sign On (SSO) SAML technology for 15 of Beeline’s clients in order to maintain VMS security. 11/15 to 05/18

Automatic Data Processing (ADP) Jacksonville, Florida. Technical Application Analyst (03/2018-05/2018)

• Maintaining benefits file delivery, data integrity and reporting with file monitoring team for ADP’s growing 800 clients.

• Providing guidance to Implementation Specialists and Account Managers on file delivery and data integrity issues to meet EDM standards improving data quality by 25%.

• Authored and revised client’s file monitoring flow process leading to a 15% increase in processing time.

• Responsible for providing data analysis and research for internal and external customers using SQL.

Configuration Analyst (11/2015-03/2018)

• Responsible for configuring client’s benefit systems across multiple platforms and applications for ADP’s 700 clients.

• Provided front-line troubleshooting for Account Managers submitting service requests related to clients benefit calculations, exports, and annual reporting to the IRS for tax reporting.

• Responsible for resolving 22,000 service request submitted in a 3-4 hour turnaround time.

• Responsible for training new associates on using multiple HRIS systems.

• Participated in multiple ad-hoc research projects identifying client benefit issues related to the Affordable Care Act implementation.

• Provided testing and feedback for new client database system developed for tracking benefit platforms for new and existing clients. 8/00 to 02/15 Harland Clarke-VALASSIS Direct Mail, Inc. (formerly ADVO) Windsor, Connecticut.

Sr. List Technician; (06/2003-02/2015)

• Maintain 100% data integrity of 172,000,000 address database through USPS updates and customer input, which provided accurate targeting information for our sales force and external clients resulting in $2 million revenue in sales/consulting profit.

• Lead investigator for theft of information by competitors. Department liaison with Legal department and United States Postal Service to determine appropriate resolution and reparations.

• Responsible for conducting multiple trend and growth analyses for Marketing/Targeting department resulting in $500,000 savings for our department.

• Provide research and data analysis for internal and external customers using SQL.

• Responsible for developing database to identify unique undeliverable addresses within Valassis Direct Mail, Inc. database. CMS Help Desk Agent; (02/2002-06/2003)

• Front-line problem resolution and support of 500 member sales force in the effective day to day utilization of Client Management System.

• Facilitator for new and existing Sales Representative and Sales Manager training program for company contract database program.

• Technology coordinator for 500 member sales force. Client Data Team Representative; (08/2000-02/2002)

• Maintaining and verifying database of client’s Companies, Franchises, and Agencies. Verifying and advising Sales Representatives on proper hierarchy structure for sales contracts.

SOFTWARE

SKILLS

• Microsoft Office MS Word, Excel, PowerPoint, Access, Visio (15 years)

• SQL for data analysis (15 years)

• Toad for Oracle 10.6 (15 years)

• Basic understanding of Microsoft Visual FoxPro 9.0 (2 years)

• Microsoft Office Outlook (8 years)

STRENGTHS • Analytical by nature, with solid problem-solving abilities.

• Strong Research and investigative skills.

• Recognized for leadership, resourcefulness and dependability.

• Demonstrated self-starter with effective combination of creativity, organizational and interpersonal communication skills.

• Proficient with File format and transmission protocols (XML, SFTP, FTP)

• Certified Healthcare Reform Specialist

EDUCATION B.A., Criminal Justice; Valdosta State University, Valdosta, GA

Contact this candidate