Paul R. Vaher
Holbrook, NY 11741
abl88b@r.postjobfree.com
Mobil: 646-***-****
OBJECTIVE: Business Analyst, Marketing Analyst, Data Analyst, SAS
Programmer, SAS Quantitative Analyst, Statistician, SQL Programmer, or
Microsoft Analyst
SUMMARY
[pic] VP trainee at NBTY
[pic] Over 10 years experience with SAS (full-time & part-time)
[pic] Experience translating programs from SQL to SAS
[pic] Experience with retail data
[pic] Experience with Business Reporting
[pic] Experience with Marketing Analytics
[pic] Experience with Database Marketing
[pic] Experience with Target Marketing
[pic] Experience with eCommerce, on-line sales and on-line marketing
[pic] Experience with Base SAS, SAS SQL, SAS Macros, SAS STAT, SAS
Graph
[pic] Experience with SAS Reporting tools: PROC TABULATE, PROC FORMAT,
PROC PRINT, PROC MEANS, PROC FREQ, PROC REPORT, SAS GRAPH, MS-EXCEL
[pic] Experience with SAS Enterprise Guide
[pic] Experience with SAS Business Intelligence Platform: SAS add-in
for Excel, Information Maps, Web Report studio, Dashboards, JMP, OLAP
Cubes
[pic] Advanced Proficiency with Microsoft Applications: SQL Server, MS-
EXCEL, MS-ACCESS and MS-WORD
[pic] Experience with writing SQL query & relational databases
[pic] Experience with ETL & database management
[pic] Experience with statistical modeling, linear and logistic
regression
[pic] Graduate level education in Psychology with background in
statistics & experimental design
[pic] Twelve (12) graduate level credits in statistics
[pic] Experience with multivariate statistics
[pic] Published Researcher
[pic] Ten (10) classroom based courses in computers
[pic] Strong written & verbal communication skills
[pic] Flexible, adaptable, Self-starter
[pic] Leader
[pic] Able to work well independently as well as with others
TECHNICAL SKILLS
SAS Tools: Base SAS 9/8.2/8.1/6(mainframe), SAS/STAT, SAS Macros, SAS/SQL,
SAS ODS, SAS GRAPH, SAS Enterprise, SAS Business Intelligence (BI) platform
Reporting Tools: Base SAS versions 9/8/6, SAS Enterprise, SAS GRAPH, AXUM,
MS-EXCEL, SAS BI Platform, MS-PowerPoint
RDBMS: SAS SQL, SAS Enterprise, SAS BI Platform, MS-ACCESS, Microsoft SQL
Server, MySQL, intro to Oracle, intro to DB2, intro to SAP
Languages: SAS, SQL, Basic
Platforms: UNIX, Windows 95/98/XP/Vista/Win 7, UNIX, SOLARIS, Linux (Red
Hat & Xandros), MAC OS, Windows NT/2000/2003
Batch Server: UNIX, SSH
Web Server: MS-FrontPage, HTML, Linux, Apache Server
Networking: Windows 95/98/XP, Linux, Server+
Photo/Graphics: Adobe Photoshop, MS-PAINT
RELEVANT EXPERIENCE
Global Resources LTD./Insight Engineer, Lead Technician (Part-time Contract
Assignments)
March 2007 - Present
- Clients include Chase Bank & JP Morgan
- Computer help-desk, computer & printer repair, Install & image desktop
systems, image laptops, assess safe & secure locations for printer
installation, server installation, more.
NBTY, Dept. of Business Intelligence - SAS System Specialist & Marketing
Analyst (Contract Assignment) June 2008 - December 2008
- Vitamin conglomerate dealing with on-line retail sales data
Responsibilities:
- VP trainee
- Translation & parallel testing of programs from FoxPro (SQL) into SAS
(Monthly Recency Reports)
- Successfully translated 24 programs
- Develop new SAS programs (morning source code report)
- Experience generating reports on demand
- Generated programs for customer segmentation (Loyalty Program)
- Experience with SAS reporting tools
- Experience with SAS Enterprise Guide
- Experience using SAS Business Intelligence platform
- Experience with the SAS ODS output and formatting
- Experience with a large retail databases (10 million customer files)
- Experience with relational databases
- Experience with SQL query
- Experience generating tables with SQL
- Experience merging & joining datasets
- Experience with data mining
- Assist in developing new products
- Study on using computers to randomize subjects
- Encouraged expansion of growth through expansion into retail sales
- Encouraged expansion of growth by fortifying Internet sales
Environment: Base SAS, SAS Enterprise, SAS Business Intelligence Platform,
FoxPro SQL, SAS SQL, MS-Excel, MS-ACCESS, Winspool
"Computer Parts -N- More" February 2002-Present
- On-line sales of Computers, Computer Parts and Accessories
Responsibilities:
- Experience with relational databases
- Maintenance of sales records
- Maintenance of inventory
- Create databases using MS-Excel and MS-Access
- Create SAS programs to import databases
- Query databases with SAS SQL and MS-ACCESS
- Create new databases using SAS SQL Views
- Create SAS programs to assist in cost analysis
- Create Email advertising campaigns
- Create SAS programs to generate mailing lists
- Create income tax reports with MS-EXCEL
- Develop advertisements for auction items
- HTML programming of auction advertisements
- Photograph items for on-line sale
- Process digital images with Adobe Photoshop
- Design of desktop computer systems for on-line sale
- Computer repair and consultation
Environment: Windows XP, SAS 9.0, SAS Base, SAS Macros, SAS SQL, SAS Stat,
SAS Graph, MS-WORD, MS-EXCEL, MS-ACCESS, MS-FRONTPAGE, Apache Server,
Linux, Adobe Photoshop
Minnesota Clinic for Epilepsy Care (MNCEP) - Researcher/SAS Programmer
(Contract Assignment)
July 2005 - September 2005
Responsibilities:
- Assist in completing research project for publication
- Created written reports, abstracts and presentations
- Generated statistical output with SAS STAT
- Generated Multivariate Analysis using PROC ANOVA and PROC MANOVA
statements
- Created SAS programs to organize output from FileMakerPro
- Created new databases using the SET Statement
- Created SAS programs with SAS Macros
- Created new databases using PROC MERGE to merge and join files
- Generated tables, listings and reports with PROC FREQ, PROC PRINT, PROC
TABULATE
- Experience using the ODS system
- Generated graphs, reports and HTML output with SAS Enterprise
Environment: Windows XP-Pro, SAS 8.2, SAS Base, SAS Macros, SAS SQL, SAS
STAT
SAS Enterprise, MS-EXCEL, MS-WORD, File Maker Pro, MAC Computers, End Notes
Maker
Intellidyn Corp. - SAS Programmer/Data Analyst (Contract Assignment)
December 2004 - January 2005
Responsibilities:
- Evaluated a financial database for possible subscription
- Experience with Target Marketing
- Experience with Statistical Models, linear & logistic Regression
- Experience with large financial databases (5 million files, 350
variables)
- Experience with trend analysis
- Executed SAS programs to generate marketing response files
- Generated reports using PROC PRINT and PROC FREQ
- Generated reports by region using PROC FORMAT
- Experience with customer segmentation using percentiles
- Experience with SAS Macros
- Generated Excel output using SAS ODS statements
- Creating SAS programs to transpose data sets for reports
- Experience with PROC TRANSPOSE
- Experience de-duping data sets
- Creating SAS Programs to import data
- Experience with MS-EXCEL Pivot Tables
- Experience formatting tables in MS-EXCEL
- Experience with financial dictionaries
- Experience executing SAS scripts on UNIX server
- Experience uploading SAS scripts to UNIX server
Environment: Windows XP-Pro, SAS 9.0, Unix Server, SSH, SAS MACROS, SAS
SQL, MS-EXCEL, MS-WORD.
TRAINING
Classroom Training
SAS Business Intelligence Fast Track, SAS Institute NY September 2008
Advanced MACRO Programming, SAS Institute New York NY November 2006
SAS Programming 3: Advanced Topics, SAS Institute New York NY June 2006
SAS Programming 3: Advanced Topics, SAS Institute New York NY March 2006
SAS Macros, SAS Institute New York NY March 2005
SAS/STAT1, SAS Institute New York NY November 2004
SAS SQL, SAS Institute New York NY April 2004
SAS Programming 2, SAS Institute New York, NY July 2003
SAS Programming 1, SAS Institute New York, NY May 2003
UNIX Fundamentals, Netcom New York, NY November 2003
Microcomputers, Psychology 704, City University of New York
ON-LINE TRAINING
SQL Server 7.0, Part 1, Careerlearn.org May 27, 2010 - Present
- SQL Server Enterprise Manager, Create and Query Database Diagrams,
relational databases, SQL views, SQL Query Analyzer, logon, permissions,
basic security administration, oSQL, Transact SQL, local variables,
batches, scripts (stored processes), Control of flow (if-then-else, Begin-
End), case, constraints (Primary Key, Foreign Key, Default Key, Check Key),
Indexes, Joins, Advanced Joins (three table joins, self-joins more
Security+ Certification Training (Part 2), Hardening Internal Systems and
Services - CareerLearn.org
April 2010 - May 2010
- Hardening Operating Systems, Network File & Printers, DHCP servers &
Directory Services
Server+ Certification Training - CareerLearn.org March 15, 2010 - April
11, 2010
- Server hardware, installing, configuring, maintaining, troubleshooting
servers, backup & disaster recovery
SELF-STUDY
MS-EXCEL 2003 Tutorial June 2010
- Review of fundamentals, paste special, absolute vs. relative values,
advanced graphing techniques, more with formulas, error codes, IF function,
referencing multiple workbooks, review of pivot tables, filter pivot
tables, group by dates, subtotals, vlookup, insert & edit spreadsheets into
Word, hyperlinks, web query, review of macro recording, editing Macros,
Macro programs, create input boxes, advanced topics, workbook sharing, data
forms, lists, lists toolbar, filters, advanced filters, validation masks &
other topics
MS-ACCESS 2003 Tutorial May 2010
- Creating databases, tables, queries, reports, forms, rearranging columns,
captions, filters, advanced filters, indexes, primary keys, formatting,
input mask, lookup tables, relational databases, orphan files, complex
queries, operators, expressions, append, update, MACROS, advanced MACROS,
import, export, open in MS-EXCEL & other topics
MS-ACCESS 2007 Tutorial - What's new in 2007? April 2010
MS-WORD 2003 Tutorial May 2010
- Formatting text & paragraphs, margins, tabs, page breaks, headers &
footnotes, passwords...
RHI On-Line Training May 2006
- Topics include: SAS Output Delivery System (ODS), MS-EXCEL, MySQL, and
Oracle SQL
MANUSCRIPTS IN PREPARATION
Book of Horizontal Joins for SAS Users by Paul Vaher, Manuscript, May 2009
- Survey of different methods of horizontal joins
CURRENT READING
- SAS Newsletter - "The Missing Semicolon"
- SQL for Dummies, a 7-in-1 book
- O'Reilly Pocket Guide to SQL
EDUCATION
Boston University School of Medicine - Postdoctoral Study 1996-1999
- Three-way ANOVA analysis
- SAS mainframe experience
University of Virginia School of Medicine - Postdoctoral Study 1995-
1996
Graduate Center of C.U.N.Y. - Doctorate of Philosophy, Biopsychology
1987-1995
- Assistant to Graduate Experimental Psychology
- 12 graduate level credits in statistics
- Audited course on multivariate statistics (1 credit)
- Class project on multivariate linear regression
- Experience with SAS V6 on mainframe
Queens College of C.U.N.Y. - Bachelor of Arts, Biology 1980-1985
- Deans list x2
- Experience executing statistics using scripts written in GW-BASIC
OTHER RELEVANT WORK EXPERIENCE
Boston University School of Medicine - Researcher & Teaching Assistant
1996-1998
University of Virginia School of Medicine - Researcher 1995-1996
Marymount Manhattan College - Instructor in Psychology 1993-1994
Graduate Center of C.U.N.Y. - Researcher, Instructor & Teaching Assistant
1988-1995