SUMMARY

• Commended by Vice President of Operations for identifying obsolete data in the hosted Benefit Administration system yielding a $2000.00 monthly expense reduction
• Customized existing Benefit Enrollment programs using VB.net via Visual Studio
• Initiated and developed additional Access databases for internal tracking of call logs for determination of billable hours. Developed in house utility programs as needed using Excel, Microsoft VBA and VB.net, Adobe Acrobat for use by various personnel for massaging batch data and scheduling timelines
• Coordinated with IT management, peers, project managers, external clients and carriersas needed to ensure proper development and implementation of client benefitenrollment programs.
• Enhanced Technical Analyst Daily and Project Tracking Excel workbook which management shared with other Analysts to help organize time and determine resource capacity
• Automated existing manual procedure to reduce lengthy processing time

SKILLS: 

MS ACCESS , MS EXCEL, MS OFFICE2003/2007/2010/2013, MS VBA, MS VISUAL STUDIO2008, ADOBE LIVECYCLE, DESIGNER v.8AOBE ACROBAT v.8

PROFESSIONAL EXPERIENCE 

Confidential,NJ

TECHNICAL ANALYST / IT SUPPORT

• Perform data manipulation, mapping, conversions, and validations utilizing internalsystems, external files, Access, and Excel
• Gather and document business requirements to develop technical and functional design specifications for new programs or modifications to existing programs per client requirements
• Analyze technical requirements, test plans, training materials and procedure documents
• Develop and generate client specific and ad - hoc reports
• Assist with Project Management tasks such as scope definition, project plans, issue management, and status updates
• Utilize company proprietary software and other software applications to perform system setup, analysis, maintenance, and enhancements as required by clients needs and project plan specifications
• Establish and cultivate relationships with clients, vendors, carriers and internal departments to ensure successful implementations, renewals and ongoing administration
• Execute test plans and test case scenarios to ensure requirements are being met
• Determine proper data logic and file structures utilizing SQL and Access queries

Confidential,Hammonton, NJ

 SYSTEMS ANALYST

• Build 50 + Client specific databases, adhering to project management time constraints, to construct Employee Benefit Enrollment programs
• Conducted quality assurance testing to ensure accuracy of Benefit Enrollmentprograms
• Developed file generation modules in MS Access for numerous HRIS, payroll, and carrier file formats and reports including HIPPA standard files
• Documented all Processes and Procedures for each Client Case
• Analyzed, massaged and merged data supplied by clients and insurance carriers using queries and VBA code modules via MS Access based on client specifications
• Audited all post production data files and reports for accuracy of benefit enrollment data and conformance to the individual carrier and client eligibility rules
• Managed client and 3rd party carrier files securing though PGP encryption and transmitting by means of FTP, SFTP and other secure transmission methods
• Created various ad hoc reports for internal and/or external users as needed

Confidential,NJ

IT SUPPORT SPECIALIST 

• Developed databases - Facility Sales Department for production sales tracking and eporting to determine user functionality - IT Help Desk laptop tracking 
• Reconfigured existing Super Bowl Travel Database for Travel Department to ormalize and simplify the database
• Supported and maintained numerous existing Access databases
• Developed Training Materials for internal users for MS Office 2007, In-houseapplications, and New Hire and Intern Training
• Acted as primary instructor of training classes in MS Office 2007Support for Off Site Events including Business Summit, Owners Meetings, 
• Provided desktop user support of applications consisting of MS Access, MS Word, MSExcel, MS Outlook, MS PowerPoint, ScheduAll, Internet Explorer, Mozilla Firefox,
• Provided hardware support for Printers, Scanners, Cisco IP Phones, FTP site
• Generated Fillable PDF forms using Adobe LiveCycle Designer ver.8 and posted to
• Created secure PDF forms using Adobe Acrobat
• Constructed custom MS Outlook forms
• Researched, recommended, and installed software upgrades and/or replacements

Confidential, Moorestown, NJ

• Main Liaison with online advertisers regarding data feed
• Managed Google/Yahoo web ad campaigns to promote regional websites
• Created new design templates and logos using Adobe Photo Shop
• Updated PDF files using Adobe Acrobat
• Developed and delivered live training for up to 800 + RE/MAX of NJ Associates
• Composed Technology articles and Tech Tips for company intranet site
• Created and updated Regional Intranet web pages using MS FrontPage
• Set up and coordination of Audio Video Technology for live presentations
• Provided Help Desk support to 3700 + RE/MAX of NJ Associates for Imprev Design
• Provided Support of Regional agent and office websites for 3700 + RE/MAX of NJ
• Troubleshoot issues, identified and purchased all computer software and hardware f
• Upgrade all in - house computers hardware, software, and OS to Windows XP