JOHN LACKEY
EMAIL: abiom5@r.postjobfree.com
WORK EXPERIENCE:
SAS Analyst/Programmer (Contract Telecommuting Position)
Bank of America
Charlotte, NC
September 2009 - September 2010
- Converted Home Equity Data Load, Analysis, and Reporting Processes, to a
SAS Data Integration Studio\BI all inclusive data flow process.
- Designed a repository of Data Marts for end-user access.
- Documented all Applications and Data Marts I created.
- Trained end-users in the use of SAS/BI tools functionality to access Data
Marts for their business needs.
- Managed Developers creating further application projects (Mortgage &
Credit Cards) using my Home Equity project as a template/standard.
- Supervised maintenance of SAS BI applications, system updates and changes
(Hotfixes & SAS Installations).
- Functioned as the liaison between SAS BI Developers and Business Analysts
to ensure correct interpretation of development specifications.
- Used SAS Marketing Automation to set up initial Credit Card Marketing
Campaigns to new customers meeting parameters (Credit Score, Income, Home
Ownership & etc.) for various card issuances.
- The automation of the bank's credit cards to new customers will function
as a template when card offers are made to existing customers.
- Developed programming standards to do Teradata Data Base pulls and
subsets.
- Created SAS Stored Processes from final specs for end-user tools access
(Excel, MS Word).
- Worked on MS Windows and UNIX platforms.
SAS Analyst/Programmer (Contract Telecommuting Position)
Wachovia/Wells Fargo
Charlotte, NC
October 2008 - August 2009
- Developed algorithms and standardized methodologies to improve/create
Card Analytic Metrics.
- Card Analytic Metrics were used to determine the success of new Credit
Card Marketing Campaigns. Rate of return on applications sent out and the
responses different delivery systems (direct mailing, email, internet
advertising) generated.
- Rebuilt Card Asset Portfolio to improve accuracy of Scoring Models and
Risk Metrics.
- Created Mortgage Rating Reports and Ad Hoc drill-downs on Mortgage Data
per end user requests.
- Developed Analysis Data Sets to be used in Mortgage Performance Modeling.
- Developed Edit Checks to identify and fix erroneous source Mortgage and
Card data.
- Created SAS Ad Hoc Reports per end-user requests to derive accurate
movement of Card Accounts.
- Developed SAS MACROs to automate pulls from Teradata Data Base.
- Basically, I created a full set of ETL procedures for Campaign
Management, Mortgage Analytics, Card Analytics, and Risk Scoring Models.
- Worked on MS WINDOWS and UNIX platforms.
SAS Programmer/Developer (Contract)
Cisco Systems Inc.
San Jose, CA
Contracted throught Saama Technologies.
October 2007 - October 2008
- Developed SAS/BI OLAP-enhanced Applications (Water Fall Tables,
SAS/Graphs, Stored Process for Derivations) and their subsequent output to
HTML files.
- Created SAS Web Report Writer Tables/Reports and links to Data Sets for
editing dynamically (drill-down & multi-dimensional aggregation) generated
reports.
- Wrote SAS Stored Processes connected to EXCEL spreadsheets to allow end-
users to process data in SAS and output it back to EXCEL without ever
having to go into SAS.
- Also wrote SAS Stored Processes connected to POWERPOINT to allow end-
users to generate SAS Graphs and write them out to POWERPOINT without ever
having to go into SAS.
- Presented strategy for further SAS Stored Process creation and use.
Weighed creation time against the necessity of the report generated and
presented my conclusions.
- Trained end-users to use and manipulate reports with SAS Web Report
Writer and SAS EG.
- Provided consultation on the configuration of SAS Applications and end
user access.
- Wrote standards for code and data review before production release of all
programs and data.
- Created SAS/MACROs to automate multiple user processes/programs into
single comprehensive programs.
- Assisted with the installation of SAS v9.1.3 on a HP-UX (UNIX) Server.
- Set up data structure (directory tree) for all code generation and data
storage.
- Worked on UNIX and MS WINDOWS platforms.
SAS Programmer (Contract)
The Gap, Inc.
San Francisco, CA
February 2007 - September 2007
- Worked on the Campaign Management of various ad campaigns Gap was
creating for their seasonal clothes launches.
- Wrote SAS programs to automate the analysis between predictions of the
advertisement sales impact and actual sales achieved.
- Presented strategy on how to create Business Reports using stored SAS
MACRO calls. I determined this was the best course for The Gap to pursue
given their SAS resources and available data.
- Developed SAS MACROs to generate Predictive Sales Models output in SAS
Tables and Graphs.
- Developed SAS MACROs to perform queries and Data Set creation via
scripted PROC SQL pulls from TERADATA Data Base.
- Wrote all SAS MACROs created to a SAS MACRO Library and trained end-users
how to use these stored compiled SAS MACROs.
- Scripted UNIX programs that run several SAS Batch Jobs and send their
output (HTML files) to designated file locations.
- Maintained existing code and optimized its performance.
- Wrote Ad Hoc SAS Programs per user requests.
- Created Data Dictionary for Source Data Sets used for indexes across
different brands (Gap, Old Navy, and Banana Republic).
- Worked on UNIX and MS WINDOWS platforms.
SAS Clinical Trials Programmer (Contract)
Medtronics, Inc.
Santa Rosa, CA
July 2006 - February 2007
- Medtronics is a medical device company and source data had to be
extracted from ORACLE, TERADATA, and EXCEL Spreadsheets and validated via
internal company guidelines. I created SAS MACROs to automate this entire
process.
- Was in charge of administering all validation programs and processes used
to create documentation for FDA submittal.
- Validated submission programs for Analysis SAS Data Sets, Tables,
Listings, and Graphs.
- Also, as lead programmer, created Derived Analysis SAS Data Sets, Tables,
Listings, and Graphs.
- Built a suite of MACROs to produce Analysis SAS Data Sets, Tables,
Listings, and Graphs, to be used across multiple studies.
- Developed overall department strategy and methodology for
starting/implementing CDISC standards and SDTM Final Data Sets.
- Developed SAS Macro Calls for standard Raw Data read-ins and Query
Reports.
- Worked directly with CROs for transportation of PMA data from Clinical
Test sites to Medtronics. Wrote up documentation for the implementation
steps for the CROs to follow in the data transportation process (FTP) used.
SAS Clinical Trials Programmer (Part-Time Contract Telecommuting Position)
Genitae, Inc.
South San Francisco, CA
August 2006- October 2006
- Developed Validation Schema and administered its use and implementation.
- Created SAS Analysis Data Sets, Tables, Listings, and Graphs for Phase
III study submission.
- Built all Analysis and Statistical Modeling Output Data Sets per CDISC
and SDTM standards.
- Validated lead programmer's code on subsequent study.
- Developed SAS MACROs for standard edit checks of all raw data read in.
- Performed all the work for this project on a part-time telecommuting
basis that overlapped with other projects.
SAS Data Analyst (Contract)
Madison & Tyler
Beverly Hills, CA
January 2006 - May 2006
- Performed thorough Edit Checks and Data Analysis for Econometric Models.
- Developed algorithms (weighted average and moving average methodology)
for deducing the credibility of a variable's input to an Econometric Model.
- Created Ad Hoc Queries and Tests to validate the reliability of Raw Data
and its' sources.
- Advised on the creation of Analysis SAS Data Sets and efficiency in
programming for large Data Streams.
- Worked on MS Windows platform.
SAS Clinical Trials Programmer (Contract)
Advanced Research Associates
Mountain View, CA
January 2005 - December 2005
- Created Analysis SAS Data Sets for Phase I/II/III studies from
extrapolated Raw Data.
- Edited Raw Data for problems in Data Collection Process.
- Consulted on the guidelines for Data Extraction and Edit Checks
performed.
- Created Tables, Listings, and Graphs per SAP Documentation.
- Implemented CDISC Data Review Standards and Edit Checks.
- Built and created Final Locked Analysis Data Sets per SDTM standards.
- Co-authored documentation that instructed how to create standard ISS
Tables, and then created subsequent tables.
SAS Clinical Trials/Data Management Programmer (Contract)
Gen-Probe, Inc.
San Diego, CA
January 2004 - November 2004
- Edited SAS programs already in use and made updates and changes where
needed prior to Data Base Lock.
- Performed SQL Server Database extractions.
- Created Tables, Listings, Graphs, and Excel Spreadsheets per SAP
documentation..
- Created SAS Data Sets for Phase I, II, and III studies for FDA
submission.
- Developed standard SAS FORMATs and MACROs to be used across multiple
studies.
- Performed half the work on this project on a telecommuting basis.
SAS Clinical Trials/Data Management Programmer (Contract)
SuperGen, Inc.
Dublin, CA
January 2003 - December 2003
- Created Test Scripts and Test (Dummy) Data to test standard SAS programs
in use and make changes where needed. I tried to find any coding problems
before Data Base Lock.
- Developed standard SAS FORMATs and MACROs to be used across multiple
studies, to automate Analysis Data Set creation.
- Performed edit checks on SAS Data Sets generated on site against SAS Data
Sets created for validation purposes, and investigated differences.
- Basically, this was Supergen's initial study and I was used to make sure
their study submission would pass Phase I requirements.
- Wrote up end-user training documentation so Validation standards could be
followed.
- Performed all the work for this project on a part-time telecommuting
basis that overlapped with other projects.
SAS Clinical Trials Programmer (Contract)
CV Therapeutics
Palo Alto, CA
April 2002 - December 2002
- Created validation programs for ISS Tables and analysis SAS Data Sets
created as final results in Phase I/II/III studies.
- Wrote Ad Hoc Data Extraction and Edit Check programs per user requests.
- Advised on use, creation, and implementation of standardized SAS MACROs
to be used across studies.
- Created Tables, Listings, and Graphs per SAP documentation.
- Created derived analysis data sets from raw data and compared contents to
validate original procedures used.
- Signed off on validation documentation to complete each Phase's study.
SAS Clinical Trials Programmer (Contract)
Gilead Sciences
Foster City, CA
March 2001 - March 2002
- Created Tables, Listings, and Graphs for the evaluation of Raw SAS Data
Sets for Phase I, II, and III studies.
- Generated Ad Hoc queries and reports per CRA requests.
- Developed Analysis SAS Data Sets for Biostatisticians from Raw SAS Data
Sets.
- Performed edit checks and clean up on CRO generated SAS Data Sets.
- Developed standard SAS MACROs for batch processes to be used by other SAS
Programmers.
- Worked with SAS Programmers and CRA team on project schema and changes to
CRF annotation.
SAS Clinical Trials Programmer (Contract)
Allergan Inc.
Irvine, CA
January 2000 - February 2001
- Performed edit checks and clean up of data extracted from ORACLE Tables
before generating Data Base Lock SAS data sets for Phase I and II studies.
- Created statistical output SAS Data Sets verifying study results,
primarily using PROC MEANS and PROC UNIVARIATE.
- Developed SAS MACROs for the transportation of SAS Listings and Graphs
into MS WORD via the SAS HTML driver.
- Generated Tables, Listing, and Graphs per SAP documentation.
- Worked with Oracle Clinical programmers on creating test data populated
ORACLE Tables to validate process of data extraction, data validation, and
data set creation prior to using real data.
- Worked with Biostatisticians in the generation of Listings and Tables to
be used in their analysis of the Data Base Lock SAS data sets, primarily
using PROC REPORT. Duties include producing Efficacy, Demographic, and
Safety Tables to measure the development of different study drugs.
- Participated in Peer Review of other CLINICAL TRIAL SAS PROGRAMS for
validation purposes.
- Produced Ad Hoc reports and standardized SAS MACRO generated reports for
review of MEDDRA data used in the development of the MEDDRA DICTIONARY of
terms used in Allergan's Clinical Trial Process.
SAS Clinical Trials Programmer (Contract)
Genentech Pharmaceutical
S. San Francisco, CA
January 1999 - December 1999
- Double-checked CRA's reports to verify their display of Data and Stat
results.
- Wrote validation programs to verify SAS Data Sets prior to Data Base Lock
for Phase III and IV.
- Created Tables, Listings, and Graphs per SAP documentation.
- Worked with Data Managers and Associates to create better views,
listings, and approaches to review their data.
- Used PROC SQL to create views and SAS Data Sets from ORACLE Tables.
SAS AF Developer (Contract)
United Airlines
Long Beach, CA
October 1998-December 1998
- AF Extended Table Application on an MVS Mainframe.
- Built Pricing Model based on Seat and Flight Demand.
- Developed SAS/AF GUI to flight reservations data
- Wrote edit checks on raw data and created SAS Data Base from this.
- Used SAS/AF (SCL) and FSEDIT.
- Set up SAS CONNECT to remotely submit various SAS JOBS depending on which
object the end-user selected (clicked on) in their Extended Table
application.
- Did all the work on a telecommuting basis.
- Worked on a MVS Mainframe.
SAS Programmer/Analyst with Travel Data (Contract)
Norwegian Cruise Lines
Miami, FL
July 1998-December 1998
- Developed Demand Forecast Models for cabin surplus filled by discounted
pricing.
- Used SAS/STAT Procedures (PROC REG, UNIVARIATE) to create output SAS Data
Sets for the Demand Forecast Model.
- Created User interface to run models and query SAS Data Sets generated
using SAS/AF (SCL) and SAS/FRAME.
- Developed Ad Hoc Query Reports.
- Helped to develop schema for project objectives.
- Set up different SAS MACROs that ran different SAS CONNECT jobs based on
the data extraction needed.
- Wrote documentation for all reports created.
- Worked four weeks onsite and the rest of the work was completed offsite.
- Worked on UNIX and MS WINDOWS platforms.
SAS Programmer/Analyst with Pharma Sales Data (Contract)
Amgen, Inc.
Thousand Oaks, CA
January 1998-June 1998
- Performed data retrieval and edit checks for Business Reporting and
Sales/Marketing Groups with Sales/Marketing SAS Data Sets and ORACLE
Tables.
- Cleaned up and collapsed data down per index variable to make data
warehousing of SAS data sets more efficient and useable.
- Developed Ad Hoc queries.
- Re-wrote existing code for more efficiency.
- Helped with the initial development of Project Plans.
- Developed extensive SAS MACROs for multiple repetitive tasks.
- Created UNIX shell scripts to run multiple batch SAS JOBS (PROC SQL) to
do data extractions from ORACLE Database.
- Performed all the work onsite.
- Worked on UNIX and MS WINDOWS platforms.
SAS Financial Applications Developer (Contract)
Textron Finance
Providence, RI
June 1997-December 1997
- Developed a SAS Database to allow the addition, changing, showcasing, and
deletion of financial data.
- Created a SAS/AF and SAS/FRAME GUI front-end to SAS Database to allow end-
user access to SAS Data Sets.
- Developed whole system from scratch using SAS Datastep, SAS MACROs,
SAS/AF (SCL), SAS/FRAME, and SAS/GRAPH.
- Wrote end-user and database manager documentation for the system.
- Performed all work onsite.
SAS Banking Applications Developer (Contract)
NationsBank
Charlotte, NC
September 1996-December 1996
- Wrote validation programs to ensure all data collected was correct.
- Developed a library of SAS MACROs used in the generation of various Ad
Hoc Reports. The end-user only had to submit the MACRO with the correct
parameters.
- Wrote end-user documentation for the Ad Hoc reports MACROs.
- Created derived SAS Data Sets to be used in final Credit Risk Score
Analysis.
- Created SAS/GRAPHS to display customer credit use trends.
- Performed a quarter of the work onsite and the rest offsite.
- Worked on MS WINDOWS platform.
SAS Banking Applications Developer (Contract)
First Union National Bank
Charlotte, NC
December 1995-August 1996
- Worked on the development of a SAS Database to be used to extract data
from and generate Statistical Models and Ad Hoc reports from.
- Wrote validation programs to ensure that all data was correct before
being added to the Database.
- Used SAS/Frame, AF (SCL) and EIS to develop the SAS Database and end user
query application.
- Used SAS Datastep and MACROs to write the validation programs.
- Performed a quarter of the work onsite and the rest offsite.
- Worked on MS WINDOWS platform.
EDUCATION:
BA in Economics and Business Management
Minor in Computer Science, 1990
North Carolina State University, Raleigh, NC
OPERATING SYSTEMS:
MS WINDOWS, MS WINDOWS NT, UNIX, MVS/TSO, VM/CMS
PROGRAMMING LANGUAGES:
SAS DATASTEP, SAS MACROs, SAS (PROC SQL), SAS/GRAPH, SAS/AF (SCL),
SAS/FRAME, SAS/BI (WEB REPORT WRITER, DI STUDIO), SAS EG, SAS/CONNECT, SAS
(PROC REPORT), ODS, OLAP.
DATABASES:
ORACLE, TERADATA, MS ACCESS
REFERENCES:
Available upon request.