Data Project
Resume:
Cherie’ L. Stagg
West Chester, Pa 19380
(h) 610-***-****
(c) 610-***-****
************@*****.***
SUMMARY
Experienced professional with over 20 years of IT industry experience in the
analysis, manipulation, management and Reporting of data in conjunction
with SAS.
Strong industry experience in Pharmaceutical and marketing to include Phase
I, II, III and IV Clinical Trails experience.
Team leader with ability to work as a team member as well as lead a team and
mentor junior staff and keep morale and productivity high.
TECHNICAL
SAS 6.x-9.x, SAS/Base, SAS/Macros, SAS/MF, SAS/PC, SAS/SQL, SAS/Macros, SAS/AF,
SAS/SCL, SAS/FSP, Cognos, Oracle, Unix, Essbase,Impromptu, Powerplay, IBM, Unix, NT,
Lotus Notes, Business Objects, HP 9000, Rapidfiler, VAX, VMS, MS/Dos, TCP/IP, CC-Mail,
TSO/ISPF, Cobol, VM/CMS, Focus, OASIS/SMS, Paradox, JCL, Reflection, Outlook
EXPERIENCE
8/08 – 3/09 Bank of America
Assistant Vice President Business Intelligence Analytics & Information Management
Develops, enhances, debugs, supports, maintains and tests software applications that support
business units or supporting functions that may involve diverse development platforms, software,
hardware, technologies and tools.
Participates in the design, development and implementation of complex applications, often using
new technologies.
Provide technical direction and system architecture for individual initiatives.
Serves as a fully seasoned/proficient technical resource.
May lead projects and direct activities of a team related to special initiatives or operations.
o Develop and maintain a site-specific website.
May have responsibility for a project and project budget.
May collaborate with external programmers to coordinate delivery of software application.
Routine accountability is for technical knowledge and capabilities.
3/08 – 08/08 Bank of America - Contractor/Consultant
Sr SAS/Financial Analyst/Consultant
SAS programming for major initiative to convert existing programs, written primarily in
FOCUS, to either PROC SQL or dataset programming.
Provide analytical support on various product strategies to ensure company goals are met.
Develop complex program models to extract data and use databases to provide statistical and
financial modeling.
Provide training to existing staff to support their job functions.
Work directly with Vice Presidents. Managers, Account Analysts.
3/07 – 3/08 Freelance - Contractor/Consultant
Sr SAS/Clinical Analyst/Consultant
SAS programming for Clinical trials and studies.
Programming Analysis Data Sets, Safety and Efficacy Tables, Listings.
Data analysis, Macro’s
Creation of CDISC Defines
Programming of QC programs for CDISC
QC of Analysis Data sets to insure correlation with SAP (Statistical Analysis Plan)
Work directly with Managers, Biostatisticians and Statistical Programmers.
2/02- 03/07 AstraZeneca Pharmaceutical, Inc., Wilmington, De.
Principal Statistical Programmer / Principal Project Leader/Employee
Supervise Senior and Junior programming staff, both internal and external, to provide programming
support, for clinical trials by developing and maintaining final data, analysis datasets, macros,
tables and listings or safety, efficacy, demography, population.
Negotiated with CRO’s for programming support by consultants. Including interviewing, salary
negotiation, programming expectations and responsibilities.
Managed CRO activities and coordinated among simultaneous timelines and divergent teams.
Communicated timelines to study teams which included Global Brand Leaders, US Study leaders,
Program/Project Management, Data Managers, Study Delivery managers, Medical Leaders.
Organized and facilitated scheduled meetings, and open communication with Data management to
ensure delivery of data, processing and resolution of queries to outside vendors.
Keep lines of communication open with Biostatistics.
Instituted using standardized macros developed by an outside vendor.
Manage resources efficiently even in Multi-Project environments.
2/02- 03/07 AstraZeneca Pharmaceutical, Inc., Wilmington, De.
Principal Statistical Programmer / Principal Project Leader/Employee cont.
Ensure that Trials are appropriately planned, coded, validated and delivered and to meet or better
project milestones.
Attend and contribute to Global and US team meetings to ensure programming representation at all
stages of a project; from protocol development to delivery of tables and listings deliverable to the
FDA.
Member of Clinical Study Team for a new indication of major Neuroscience compound.
Attendee of Clinical Development Team meetings for a major Neuroscience compound.
Member of Global Analysis and Reporting Team to standardize format and delivery of clinical
study reports. Responsibilities include reviewing documentation from all work streams, training the
training staff and employees on new standards.
Mentor intern(s) and/or junior team members.
Completed five (5) Trials, successfully in 2004/2005.
Completed Interim Analysis for a major Neuroscience compound which resulted in FDA approval.
Co-Developed standardization template now being used by a Global team to develop company-
wide standards for all programming efforts.
8/01- 2/02 AstraZeneca Pharmaceutical, Inc., Frazer, Pa. cont.
Statistical Programmer/Consultant
Statistical programmer for GastroIntestinal Therapeutic Area.
Responsibilities include leading programming team to providing programming support, for
clinical trials by developing and maintaining computer programs
Extracting data from text files, Excel spreadsheets, or SAS datasets to be used in the analysis
of marketing data.
Responsible for:
To support design of temporary Tables and Listings and figures
To support reporting, finalize, and run Tables and Listings
To support execution and programming of Tables and Listings
To support execution and creation of analysis data sets
To support reporting transfer Tables and Listings to archive for publication
To support reporting and filing of electronic submissions
Design, develop and implement tools for managing timelines, cost, quality, resources at all
levels including trial, set of deliverables, business plan at all levels
Continuous improvement of process and tool
Develop/integrate project metrics, processes & tools
Set and execute business objectives
To support design SAP review
To support execution review Tables and Listings
To support reporting review CTR
To support design protocol review
To support design collection tool approval
To support reporting database creation
Contact with: Internal: Clinical, data management, database, biostatistics External:
CROs, labs, data management, other CDMA
Environment; SAS 8.2, PC SAS, IBM PC(Compatible), Windows NT, MacStat v3.1, MicroSoft
Outlook 2000, Microsoft Office, Reflection X for Windows 95 and Windows NT,
5/01-6/01 Sullivan Direct, Cincinnati, OH
Sr SAS Analyst/Consultant
SAS programmer for Marketing Adhoc Reporting. Responsibilities included programming
for direct mail campaigns, data analysis, and summarization of data. The ultimate goal being
text files - tables and listings providing information to the marketing staff and to the outside
customer from which to mail a select population based upon criteria.
Extracting data from text files, Excel spreadsheets, or SAS datasets to be used in the analysis
of marketing data.
Responsible for:
Collating a data dictionary based upon source data.
Analysis for the purpose of creating a data warehouse/datamart for source data.
Recommending strategy based on above findings.
Rewrote SAS program used for monthly loads for optimal efficiency.
Contact with in-house marketing clients and outside clientele.
Environment; SAS 8.1, PC SAS, IBM PC(Compatible), Windows 2000, Microsoft Office,
DBMSCopy
08/99-5/01 Origin Technologies, Columbus, OH
Sr SAS/Data Analyst/Consultant
Data Analyst/Business Analyst for the Financial Division of a major Insurance Company.
Data Integrity specialist in support of the Financial Division's Data Warehousing initiative.
Responsibilities include research, analysis, and documentation of multiple source data for
inclusion/exclusion in a new data warehouse. Business owner of 6+ Facts of a new Financial
Data Warehouse. Research, interrogate, and validate all data elements and values.
Validate business models for effectiveness, thoroughness, intuitiveness of the design and the
interrelationship between the model and the actuality of the data warehouse.
Determine the viability of current company-wide reports and the derived data and the
derivation of such reports from the new FDW.
Balance and verify the integrity of the data from source to FDW; FDW to management
reporting.
Work with the Data Modeling team and the IT department on both the physical and logical
structure of the data warehouse to insure continuity and integrity of the data.
Researching and documenting report specifications for end-user management reporting.
Gather, researched, and cross-map all identified dates in the warehouse for the purpose of
integrity and standards.
Work with the reporting team on the logical creation of cubes using the newly designed tables
using PowerPlay Business Software and Impromptu Reporting Software.
Work with the reporting team on the creation of reports using the newly designed tables using
PowerPlay Business Software and Impromptu Reporting Software. Ensure data balances
before distributing reports or screens.
Developed script standards for end-user reporting. Identified imperative aggregations levels
that extended the scope and timeline of the project.
Environment; Cognos Business Software, Impromptu 5.5 PowerPlay 6.5, IBM PC (Compatible),
Windows NT, Lotus Notes (E-Mail)
4/98-8/99 Anthem Blue Cross/Blue Shield, Mason, OH
Sr SAS Programmer/Analyst/Consultant
SAS /SQL programmer for Risk Management/Account Reporting.
Responsibilities included programming for customized reporting, data analysis, and
summarization of data. The ultimate goal being Excel Spreadsheets or hard copy reports-
tables and listings providing information to the sales personnel and/or underwriting staff from
which to make business decisions.
Working directly with Systems Analysts and DBA’s to extract data from a data warehouse,
mainframe, or SAS datasets to be used in the analysis of insurance data, at either a group,
provider or member level by product and sales representative.
Writing and maintenance of monthly and adhoc listings and tables.
Lead programmer for Ohio on the Standard Account Reporting Project (SAR).
Key person on three (3) SAR teams including Data/Summary Team, Programming Team,
Tools Team.
Consultant to the Training Team.
Responsible for mapping data from a pre-established database to a new data-warehouse.
Responsible for mapping fields to the data-warehouse and testing for the integrity of the data
as well as creating reports off the new warehouse and balancing them with previous reporting.
Responsible for the introduction and implementation of formal documentation of the process
which is now used for the SAR project.
Directly responsible for discovering data discrepancies within the Data Warehouse which
resulted in the postponement of many reports for the SAR project as well as the escalation of
some of the discrepancies Data Warehouse data.
Coordinator for the introduction of BI/Query as the tool to be used to pull data from the data-
warehouse and to put a hands-on tool on the user’s desks, i.e. proposals, meetings, conference
calls, seminars, in-house training.
Work with DBA’s and the Business Development Center to plan and develop data model to
be used for the SAR Project.
Lead programmer reprogramming reports written in SAS to use SQL and the BI/QUERY
software.
Environment; SQL(ANSI-Standard and PROC SQL), BI/Query 5.1, SAS 11/12, PC SAS, IBM
PC(Compatible), Lotus Notes(E-Mail), Windows 97/NT, PowerPoint, Metadata, Teradata
8/97-4/98 Proctor & Gamble, Blue Ash, OH
Sr SAS Programmer/Analyst/Consultant
SAS / SQL programmer for Marketing and Business Development.
Responsibilities included programming for customized reporting, data analysis, and
summarization of statistical tables. The ultimate goal being Excel Spreadsheets or hard copy
reports- tables and listings providing information to market/business analysts from which to
make business decisions.
Working directly with Systems Analysts and DBA’s to extract data from a data warehouse,
mainframe HP9000, or SAS datasets to be used in the analysis of pharmaceutical data, at
either a physician or summarized level by brand and marketing supervisors.
Writing and maintenance of monthly and adhoc listings and tables.
Responsible for implementation of group library used department wide for either SQL or SAS
code.
Directly responsible for discovering data discrepancies within the Data Warehouse, which
resulted in the postponement of reporting calls/samples from the data warehouse for five(5)
months; as well as an ongoing investigation into the validity of Data Warehouse data.
Environment; SAS 11/12, PC SAS, HP PC, UNIX, Oracle, Windows 95, Rapidfiler, CC-Mail
2/96-6/97 Berlex Laboratories Inc., Fairfield NJ
Sr SAS/Clinical Analyst/Consultant
SAS programming for Clinical trials and studies.
Responsibilities included programming for customized reporting, data analysis, and
summarization of statistical tables.
SAS Macro application to produce complete, concise, sequential listings of clinical study
data. The ultimate goal being Case Report Forms - tables and listings providing information
to data reviewers to minimize the amount of time needed to review and edit data.
Working directly with Clinical Data Coordinators in the analysis of pharmaceutical data and
the design of listings representing the data. Writing and maintenance of final listings and
tables for FDA submission to include Phase I and II Clinical Trails.
Responsible for integrity, usability and maintenance of macro library used department wide
Working directly with Database programmers in the creation of format catalogs
Environment; SAS 6.8, SAS 11, PC SAS, HP PC, VAX/ VMS, MS/DOS, TCP/IP,CC-MAIL
11/94-2/96 Schering – Plough, Kenilworth, NJ
Sr SAS/Clinical Analyst/Consultant
Environment; SAS 6.8, IBM PC, MVS/ TSO/ISPF, Lotus Notes, MS/DOS, TCP/IP,
12/93-10/94 Memorial Sloan-Kettering Cancer Center, New York, NY
Ambulatory Care Systems / Programmer/Analyst/Consultant
Environment; Paradox 4.0 & 4.5/ DOS, IBM PC, TSO/ISPF, Lotus 123/Windows, Word for
Windows, MS/DOS, TCP/IP, OASIS/SMS
11/92-12/93 AT&T, Basking Ridge NJ
Winback Marketing Division/Data Base Quality Control / Consultant
Environment: SAS 6.07, IBM 30XX, IBM PC, JCL, TSO/ISPF, OS/MVS, MS/DOS,
Wordperfect, Windows, Microsoft/Excel
6/91-11/92 National Exchange Carrier Association (NECA), Whippany, NJ
SAS Programmer/Systems Analyst /Consultant
Environment; SAS 6.06/6.07, SAS/AF, SAS/SCL, SAS/Macros, IBM 30XX, IBM PC, TSO/ISPF,
OS/MVS, MS/DOS, JCL, Wordperfect
EDUCATION
Union Institute, Cincinnati, OH
BA in Psychology*
Computer Processing Institute, Paramus, NJ
AA in Business Computer Programming
Courses
Case Report Form Creation, Printing and Management SOP Training., MedDRA Essentials
Training, Authoring Environment Training – Documentum, E-Labor Training,
SAS Fundamentals, SAS Programming, SAS Report Writing, SAS/AF, SAS/FSP, SAS/SCL,
Advanced SAS Programming, Basic Project Management, IS Project Management, Insurance
Course 14, Introduction to Paradox, Advanced Paradox, Oracle SQL Statement Tuning, Advanced
SQL, BI/QUERY Courses: Fundamentals of BI/Query USER, Advanced Query Building,
BI/QUERY Reports, BI/Query for Administrators, Cognos-Report Writing, Cognos–Advanced
Report Writing, Cognos – Powerplay, Clinical Study Protocol Development, Clean File and QC
Process, HIPAA, Local CIM Working Instruction US/9/1 on Compilation of CSR Sections 11 and
12, GSOP 08 Clinical Study Protocol Development, Version #3, Pharmaceutical Industry Today,
Clean Data, Clean File and QC Process, HIPAA, US/CDM/AMOS 3.1.2 Data Entry,
US/CDM/AMOS 3.1.2 Demo, Global Guideline 11 Global Process Description for Reconciliation
of SAEs, Version #2, GSOP 08 Protocol Development and Approval, Version #2, GSOP 08
Protocol Template Training, Version #2, GSOP 02 Adverse Event Reporting, Version #2, SOP
#CR/US-001.1 US Process for Clinical Study SAE Reporting/, US/CDM/Advanced MedDRA
Data Collection, Review and Presentation/, US/RA/Common Technical Document (CTD)
Overview, GSOP 05D Forecast, Preparation & Ordering of Study Drug at R&D Site, GSOP 12
The Handling of Poor Quality and Fraud in Clinical Research, Global Guideline 19 Peer Review
Process: Protocol Review Committee, Global Guideline 22 Closure of a Drug Project, SOP
#US/CD-001.1 Creating, Printing and Management CRF, SOP #US/CS-001.1 Outsourcing to
Contract Research Organizations, GSOP 15A Data Management Preparation at Project and Study
Level, US/QDS/Advanced MedDRA Analysis and Reporting, SOP #US/CD-001.1 Creation,
Printing and Management CRF, US/CDM/MedDRA Essentials
Seminars
End-User Support, Customer Interaction, Business Writing – Documentation, Emerging
Leadership I, Coaching for Success, Presentation Do’s and Don’ts, Emotional IQ: What Is It?
What Is Yours ?, Pharmaceutical Industry Today, Applied Statistical Techniques for TA
Management (US/INT/ABL), Career Development Workshop, IND Overview, Coaching for
Success, - Influencing Without Authority, Overview of Drug Development, Introduction to the
FDA and Regulations
Contact this candidate