Senior Programmer/Analyst Resume

SUMMARY:

20+ years experience in data analysis/reporting in multiple industries
9 years CRO experience
SDTM, data listings, back end checks, Pinnacle21, submission, data transfers, ad hoc reports
Data analysis and manipulation from multiple sources
EDC (Rave) and SDTM mapping, programming, validation
Set up programming reporting, validation, data check and documentation processes
Ability to act as programing lead and mentor
Excels at fostering positive client and colleague relationships
Setting up department programming practices, validation procedures, documentation
Multiple performance awards, nominated by peers
Q2 Peak Performance Award for work on a high visibility study
Performance award for special projects
Outstanding performance and achievement

PROFESSIONAL EXPERIENCE:

Confidential

Senior Programmer/Analyst

Responsibilities:

Senior programmer for multiple Rave studies for SDTM, including mapping specifications, programming based on raw Rave and vendor data, data transfers to client, Pinnacle21, submission preparation
Coordinate multicultural distinct teams to meet milestones as assigned, interact with corporate team and CDM team members to negotiate timelines, responsibilities and deliverables
Conduct secure data transfers to/from sponsor
Work with external data vendors of data to develop process for data transfers and resolve data issues, and in corporate Lab, PK and other vendor data into SDTM datasets
Mentor other team members and Lead Programmers in training and develop technical and database expertise.
Work effectively and efficiently with international colleagues
Develop and maintain excellent, effective and collaborative relationship with client

Confidential, Austin, TX

Clinical Programmer

Responsibilities:

Create and maintain programs used for data listings, data checks, data management and validation
Program and validate incoming and outgoing data transfers
Extraction from Rave EDC data source
Program and maintain SDTM and data listings/checks programs, following mapping specifications
Communicate effectively with project team to complete assigned tasks on time and within budget.

Confidential, PA

Team Lead

Responsibilities:

Contributed as lead for global team, delegating work and ensuring deadlines were met
Proactively managed process transition for ad-hoc report requests from email-based method to ticket-based method. Programmers were resistant to the change, and requests and deadlines were being missed. Result was 100% compliance
Trained new team members
Provided ad hoc reporting and snapshot data listings with zero-tolerance for errors
Extracted data from EDC data source, merged, transformed, cleaned data prior creating reports
Managed incoming/outgoing data transfers with outside vendors.
Converted data from one format to another (.sas7bdat, .csv, .txt, .xls)
Processed potentially unblinding data (PUBD) to remove data that is not to be seen by unauthorized persons.

Confidential,Lake Oswego,OR

Clinical Programmer

Responsibilities:

Developed SAS programming reporting, validation and data check processes to ensure reports meet internal SOP and FDA requirements. Wrote work instructions
Extracted data from EDC data source, merged, transformed, cleaned data prior creating reports
Took reporting processes from Excel/Crystal Reports- based to SAS- based, achieving much quicker turnaround times and more robust output results. Developed self-service databases for clinical study engineers to pull their own ad-hoc reports. This resulted in quicker delivery of reports to engineers and less SAS time spent on ad-hoc reporting
Developed and maintained ad hoc and periodic internal reports using a combination of SAS, Excel and Access to output results

Confidential,Vancouver,WA

SAS Programmer

Responsibilities:

Worked with senior warranty analyst to create tools for global warranty analysts to use in forecasting warranty costs for time periods covering 1 month to 5 years. Scrubbed and aggregated data from multiple sources and processed in SAS

Confidential

SAS Programmer

Responsibilities:

Using VBA, created and supported automated, complex analysis tools for business analysts and manufacturing plants worldwide. Tools could concurrently analyze supply and demand data to help make decisions
Gathered requirements and interpreted business rules needed for these tools
Trained worldwide users on use of tools
Created performance-tracking metrics reports