Sales Sql

Location:

Holbrook, NY, 11741

Posted:

July 26, 2010

Contact this candidate

Resume:

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 &