Van Stevens

vanstevens@yahoo.com
Van Stevens
Technical Analyst Professional

508-265-3545
Natick, MA 01760

Health Care Data Analyst TUFTS Health Plan Watertown, MA
September 2015 to December 2015
• Automated the input process on a SAS monthly job stream designed to validate the data that is sent to the government as part of President Obama€™s Affordable Care Act.

• Corrected the SAS validation programs that are submitted by the above job stream. Generates SQL queries against the marketing database for customer portfolio analysis and measurement of sales campaigns

• Reconciled the data being sent to the company€™s Red Brick database before it was shipped to the government.

End User Support Analyst The Federal Reserve Bank of Boston Boston, MA
July 2011 to September 2015
• • Maintained a detailed understanding of the Bank’s Invoice Processing Platform (IPP) business at a level appropriate to provide a high level of support to internal and external customers

• Responded promptly to first and second line customer inquiries via telephone and email.

• Assisted with customer questions and problems by troubleshooting software issues, including simulating or recreating those issues in a QA environment to resolve operational difficulties

• Created documentation around support processes and issues usable by technical and non-technical users.

Production Engineer Epsilon Data Management Wakefield, MA
2010 to 2011
Database Marketing

Managed the database marketing application updates for two major clients
Automated the receipt and reconciliation of incoming daily files
Reduced the size of the operations manual for one of their major clients by 70%
Built and maintained a 100 user data security system
Communicated production issues to client and project team

Application Support Analyst Fidelity Investments Boston, MA
2006 to 2009
Financial Services

Managed college investments mutual fund application updates for two lines of business
Provide end-user support and training for users of both systems
Built and maintained a 20 user data security system
Using SQL, developed, tested and distributed custom reports for business partners
Monitored daily, weekly, monthly and annual production job streams

Technical Support Analyst Keane Cambridge, MA
2004 to 2006
Biostatistics Group

Managed the migration of SAS software from Windows to Unix
Provided end-user training for Unix to biostatisticians and technical programmers
Installed and maintained custom statistical software
Maintained the SAS Unix user environment
Developed a SAS template for their NEditUnix editor

SAS Programmer Analyst Extra Care Rewards Program Woonsocket, RI
2003 to 2004
Retail Marketing – Extra Care Rewards Program

Interfaced with Product Marketing and vendors to understand business needs
Developed, tested and executed SAS and SQL programs for business partners
Distributed the extracted data in Excel format which provided clear and understandable results
Managed the upgrade of SAS platform from version 8 to version 9
Developed custom Perl scripts to monitor SAS user disk space

Bachelor of Science Computer Science Northeastern University
Boston, MA

SQL, SAS, Unix script, MS-Access, MA-Excel, Perl, Oracle

Skills:

SQL
MS-Access
MS-Excel
SAS
Client Relations