Aimee Vedar Email & Phone Number

Garnet Valley, Pa, Us

Utilized Query Analyzer in SQL Server 2000 to create Ad Hoc SQL queries for custom reports requested by various department heads within company.Gathered metrics data from various managers to create a Dashboard Report for Medical Directors.Gathered requirements for new applications to be built for departmental groups.Documented test plans and issue logs for applications built to ensure quality product delivered.Built intranet applications for internal customers with HTML and JavaScript using Macromedia HomeSite.Maintained data for proprietary applications with SQL Server 2000 (Created and maintained tables, stored procedures, user-defined functions and scheduling jobs).Built DTS (Data Transformation Services) packages in SQL Server 2000.Aided in conversion from SQL Server 2000 to 2005 (migration of tables, rebuilding DTS packages in SSIS - SQL Server Integration Services).Updated/maintained monthly reports for various departments with MS Access.Updated/maintained an interdepartmental Intranet page housing links to documents throughout company.Monitored and responded to central inbox updates/requests on a daily basis.Provided technical support to various departments with troubleshooting application errors.Provided tutorials/training for new applications deployed to various departments.Gained exposure to Client Letter (a MEDecision Company product for use with creation of letters/surveys for Insurance members).Received training in Business Objects for daily/weekly reports mailed to Local Union Groups.

Processed weekly/monthly client files by reviewing deviations in assets for available funding. Ensured that assets were in line.Troubleshot causes of deviations in numbers throughout client files or in our extracts.Created issues database in MS Access to track client processing issues.Performed User Acceptance Testing on extract revisions on clients in need of rework

Troubleshot claims for Hold Codes coming through MHS System.Update benefit packages in system according to new change requests.Actively review Claim Holds to reduce inventory for BI Hold Code Report (daily maintenance)Backup for Mapset liasion to generate new mapsets and maintain/delete historical and current mapsets.

Owned and maintained Cobra Program across 4 clients.Created Ad Hoc SQL requests (data pulls and participant issues) for Internal and External Clients.Acted as liaison between vendors and clients to define resolutions for issues and enhanced systems and assumed ownership of such programs.Performed QA on client participant communications to ensure accuracy of benefit information.Managed medium difficulty projects for Internal/External Clients.Assisted team members in execution of projects to meet demanding deadlines for Open Enrollment. Also provided peer review of Ad Hocs to provide a timely turnaround.Performed QA for Production Processing Group work to ensure quality of files between Vendors and Clients (internally and externally).Engaged in internal training to expand Benefits Administration knowledge such as Health and Welfare Parameter coursework.Participated in Client Conversion project from current platform to HWModule (universal client platform for Towers Perrin)Performed QA Testing for client IVR (Integrated Voice Recognition).