Van Stevens Email & Phone Number

Watertown, Ma

• Automated the input process of 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.

Boston, Ma

• Maintained a detailed understanding of the Bank's Invoice Processing Platform (IPP) system at a level appropriate to provide a high level of support to internal and external customers.• Developed standard periodic and ad hoc reports of agent activity by obtaining data from the IPP systems, including the government and commercial in house databases, the call tracker system and some manual files.• Used MS-Access to combine the data from the different sources. Ensured the data was clean and reportable by comparing the results to prior periodic reports to look for any anomalies and by checking with the owners of the IPP transaction data. • After the data was cleansed and combined, it was exported to MS-Excel spreadsheets and made presentable to the personnel that requested the information. The presentations included comments on any noticeable changes since the prior reporting periods.

Wakefield, Ma

• Worked on a team in support of an Oracle database marketing system for one of the company’s largest clients.• Ran and monitored all daily and weekly Unix scripts for the weekly marketing Oracle database deliverable. • Communicated production issues to project team• Developed custom Unix scripts which automated the receipt and reconciliation of incoming data files

Boston, Ma

• Solely responsible for the retail and managed fund College Investment Trust Oracle database application, including daily updates, testing and implementation of changes and custom reporting.• Ran and monitored the daily Linux scripts and Oracle application updates • Resolved transaction issues with source mainframe systems• Used SQL to develop, test and distribute a substantial number of custom reports for business partners

Cambridge, Ma

• Solely responsible for the migration of the company’s SAS software environment from PC-SAS to Linux SAS• Provided user training on Linux SAS for 20 SAS programmers and statisticians• Maintained a record of all departmental statistical software, including licenses and media• Installed specialized statistical software on user’s Windows machines

Woonsocket, Ri

• Worked on a marketing team supporting all of the company’s internal and vendor related marketing campaigns• Supported marketing campaigns by developing SAS and SQL programs that ran on the department's Unix box to pull data from CVS' Oracle database• Provided the results and recommendations of the analysis to clients in a clear and concise manner• Developed custom Perl scripts to monitor usage of the SAS environment on the department's Unix box

Waltham, Ma

• Worked on a diverse team supporting all of the bank’s marketing campaigns• Developed SAS programs that ran on the department's Unix box to pull data from the Harte-Hanks database in support of marketing campaigns• Provided the results and recommendations of the analysis to clients in a clear and concise manner• Interfaced with Product Marketing to interpret business requirements

Waltham, Ma

• Installed the Harte-Hanks monthly database refresh onto the marketing department's Unix box.• Monitored user's file systems and home directories for disk usage• Developed custom Perl scripts to monitor usage of the department's Unix box• Added and deleted user ids and user groups as needed. Granted and maintained records of permissions to groups for users.

Billerica, Ma

• Worked with clients to understand their business requirements, translated them into technical specifications, and had programs written to satisfy the specs• Ran and monitored all daily, weekly and monthly job streams for the periodic update deliverable• Developed test plans to QC programs which were implemented into the periodic job streams

Waltham, Ma

• Designed, developed and supported an information system that satisfied the needs of the company's end users and marketing staff.