Project Manager Resume
Thousand Oaks, CA
SUMMARY
- Twenty - four years of multivariate statistical data analytics with SAS and SPSS.
- Seventeen years of database marketing with extensive SAS and SQL programming.
- Twelve years of demonstrated leadership as a commissioned Air Force officer.
- Eleven years of behavioral science/applied psychology experience.
TECHNICAL SKILLS
Operating Systems: MS Windows
Platforms: UNIX, MVS/TSO
Programming Languages: SAS, SAS EG, SAS EM, SPSS, SQL
Office Applications: MS Office, Excel, Word, PowerPoint, Outlook, Visio
Software Tools: AQT, Toad, MS SQL Server Management Studio, SAP, Hummingbird Exceed, WinZip, WS FTP Pro, Filezilla, UltraEdit, Nielsen Prime Location, MapInfo, Business Objects, Cognos, Workday, QlikView, SurveyGizmo, TIBCO Spotfire
Databases: Teradata, Oracle, DB2, SQL Server, Access
PROFESSIONAL EXPERIENCE
Project Manager
Confidential, Thousand Oaks, CA
Responsibilities:
- SAS/STAT 9.4 programming on PC
- Extracted HR data from Workday & created custom reporting in SAS
- Provided Staffing & EEOC compliance reports with Workday & SAS
- Consulted on HR Analytics dashboards with TIBCO Spotfire
HR Analytics Manager
Confidential, St. Louis, MO
Responsibilities:
- SAS/STAT 9.4 programming on PC
- Developed Analytics SAS Datamart
- Extracted HR data from Workday & created custom reporting in SAS
- Modeled turnover rates with SAS Proc Logistic
- Created custom compensation statements using Workday Report Designer (BIRT)
- Survey creation and analysis with SurveyGizmo
- Created HR Analytics dashboards with QlikView 12
Analytics Manager
Confidential, St. Louis, MO
Responsibilities:
- Managed analytics for credit card collections and recovery for the fifth largest bank in the U.S.
- Supervised analysts
- Interviewed job candidates and provided ratings for personnel selection
- SAS/STAT 9.4 programming on UNIX (AIX), SAS EG and PC
- SQL programming in SAS and TOAD
- Managed a predictive model of monthly collections charge off losses
- Taught SAS training classes
Senior Statistical Analyst
Confidential, St. Louis, MO
Responsibilities:
- SAS/STAT 9.3 programming on UNIX (AIX), SAS EG and PC
- Constructed customer acquisition and retention direct marketing campaign lists
- Programmed scoring of branch location optimization and sales goal setting models
- Programmed data extraction and analysis to support Media advertising plans
- Managed the relationship & contracts of two major vendors: Acxiom & Nielsen Claritas
- Mapping and data extraction using Nielsen Claritas iMARK, Prime Location, and MapInfo
- Interviewed job candidates and provided ratings for personnel selection
Solutions Developer/Modeling and Analytics Team Leader
Confidential, Little Rock, AR
Responsibilities:
- SAS/STAT 9.1.3 programming on Linux Data Grid, UNIX (AIX), and PC
- Supervised 4 SAS programmers
- Served as Line of Business Leader for all Modeling, Analytic, and Database issues
- Developed Analytic SAS Datamart to support Modeling and Reporting
- Supervised Model Implementation, Scoring, and Auditing using SAS
- Taught SAS training classes
SAS/SQL Programmer
Confidential, Norcross, GA
Responsibilities:
- SAS/STAT 9.1.3 programming on UNIX (Sun Solaris) and PC
- Reported churn probability of large business accounts
- Business retention campaign reporting
- Loaded business account data into Salesforce.com CRM tool
- Created Ad Hoc analysis of business account data
- SAS/STAT 9.1.3 programming on UNIX (Sun Solaris) and PC
- Supervised analysts
- Analyzed performance of targeted retention models that ranked telephone service representatives based on their performance to the value of a customer's account for inbound service calls to maximize retention rate and saved revenue
- Consulted on automated outbound telemarketing performance metrics reporting
- Calculated and reported persistency of insurance product accounts
- Provided SAS programming training to analysts
- SAS 9.1 programming on UNIX (AIX 4.3) and PC
- Data mined Oracle databases using SQL with TOAD 8.0 and Microsoft Access
- Created process workflow documentation using Visio flowcharts
- Constructed customer acquisition and retention direct marketing campaign lists
- Interfaced with vendors for NCOA and credit scoring of prospects, including PGP key encryption/decryption
- Programmed automated daily error reports and designed Excel pivot table report for management review
- Programmed automated weekly metrics reports to evaluate the timeliness of enrollments and sales channel, vendor, and system performance
- Performed quality control of all targeted customer enrollments and worked with vendors to correct and minimize the occurrence of errors
- Programmed automated weekly D2D sales reports and reconciled received enrollments to identify, rectify, and minimize the occurrence of missing enrollments
- Programmed automated weekly reconciliation report of enrollment agreement images in FileNET
- Managed the due diligence, selection, contracting, training, and testing of new imaging & data entry vendor.
- Maintained customer information in SAP
- Validated customer information and tracked EDI transactions using ERCOT portal
- Ran customer enrollment metrics reports with Cognos
- Managed FTP of data files across platforms and servers with Hummingbird
- Wrote a training manual on enrollment quality control processes and issue resolution
- Consulted on the design of survey instruments to provide metrics for bonus pay calculation
- Interviewed job candidates and provided ratings for personnel selection
Adjunct Professor
Confidential, Plano, TX
Responsibilities:
- Taught both sections of Psychology 2302, Applied Psychology.
- Application of psychological theory and methodology to human resource management issues in organizations
- Emphasis on Industrial/Organizational, Human Factors, and Consumer Psychology topics
- Received outstanding student evaluations of teaching quality
- Selected new and greatly improved textbook with online web content
Campaign Consultant
Confidential, Dallas, TX
Responsibilities:
- SAS 8.2 programming on UNIX (Sun Solaris 5.6) and PC
- Performed Statistical analysis of effectiveness of direct marketing and CRM campaigns
- Data mined customer information in Oracle database using SQL in TOAD
- Created marketing campaign mail lists with SAS using demographic information to maximize customer response and profitability while minimizing marketing expenses
Marketing Analyst
Confidential, Plano, TX
Responsibilities:
- SAS 6/8.2 programming on mainframe (MVS TSO/JCL), UNIX (SGI), and PC
- Analyzed insurance product and membership services marketing effectiveness and profitability
- Used fast count easy access to analyze customer information in a relational database
- Scored prospects using statistical models predicting probability of purchase and profitability
- Managed warehousing, quality control, and transfer of data between platforms
- Used Excel spreadsheet statistical formulas and macros to report and analyze data
Occupational Analyst/Assistant Section Chief
Confidential, TX
Responsibilities:
- Performed job analysis of space & missile operations specialties to validate redesign of 24 training courses, streamlining and improving training for 4,000 officers and enlisted personnel
- Performed knowledge needs analysis to modernize staff development officer training course
- Performed knowledge needs analysis to validate promotion tests for 270,000 enlisted personnel
- Instructed subject-matter experts how to utilize job analysis data for test development
- Consulted with training managers to implement recommendations based on job analysis data
- Interviewed job incumbents and subject-matter experts to develop task lists and survey questions
- Developed and administered task/knowledge inventories and job satisfaction survey instruments
- Analyzed data utilizing Comprehensive Occupational Data Analysis Programs (CODAP) on mainframe
- Multivariate statistical analyses with SPSS
- Supervised computer security, hardware & software configuration, computer training, and technical support for section of 10 analysts as Internal Computer Monitor
- One of seven behavioral scientists competitively selected Air Force wide for full scholarship at civilian school of choice
Graduate Student Intern
Confidential, Plano, TX
Responsibilities:
- Researched, developed, and validated personnel selection tests for assessment centers, including interviews, in-basket exercises, written communication tests, and predictive job application bio-data
- Interviewed job incumbents and subject-matter experts to content validate test items
- Consulted with business managers to determine knowledge, skills, abilities, and other attributes to assess in job applicants
- Multivariate statistical analyses with SPSS
Research Psychologist/Security Manager
Confidential, AZ
Responsibilities:
- Designed and conducted experiments testing pilots' dynamic visual acuity, distance estimation, target detection, and situational awareness while using night vision goggles (NVGs)
- Interviewed subject-matter experts to evaluate flight simulator war-gaming fidelity and training effectiveness
- Investigated techniques to improve aircrew performance and training
- Multivariate statistical analyses with SPSS
- Supervised industrial, physical, and personnel security of research laboratory employing 75 military, civil service, and contractor personnel including administration of all security clearances
- Received USAF Security Police Security Manager training
- Controlled all operations, maintenance, and security of squadron of 50 Minuteman II ICBMs
- Commanded missile combat crewmembers, security police, maintenance, and support personnel
- Strategic Air Command Inspector General Outstanding Performer -- one of only six awarded in Wing
- Strategic Air Command Safety Screen Award for detecting and correcting hazardous situations
- Selected Squadron Crew of the Month six times for outstanding job performance under demanding circumstances, twice being also selected Wing Crew of the Month
- Earned two Outstanding Performer ratings for exemplary job performance evaluations
- Operations Group Commander Honor Roll (Top 15%) for excellent demonstrated job knowledge
