We provide IT Staff Augmentation Services!

Sas Consultant Resume

2.00 Rating

Pennington, NJ

SUMMARY

  • An Accomplished professional with overall 13+ years of experience in healthcare industry and 2 years life science
  • SAS programmer with experience in programming, analyzing, quality control (QC) and validation of application using SAS windows environment.
  • Experience in conducting GAP, Mapping analysis, using CDISC SDTM version 3.1 model classes (Special purpose, Findings, Intervention and Events).
  • Created and used previously generated Macros to improve automation for data analysis and report creation.
  • Experience with generating Tables, Listing, and Graphs (TLG's) and generated report using SAS/ODS(RTF and PDF)
  • Familiar with PROC SQL(inner Join, left Join, Right Join, Union Join, Update, Alter)
  • Annotated Case Report Form (CRFs) and reviewed protocol, Statistical Analysis Plans (SAPs), reviewed mockup TLG’s for clinical study.
  • Analysis data and creating reports in MS Excel & SAS
  • Good math, communication, interpersonal problem solving and project management skills and analytical, data mapping and data tracking abilities
  • Proficiency with spreadsheets & presentation software (Excel & PowerPoint) for effective generation, analysis and presentation of management information for central operational and business decision making.
  • Standard templates were created for data visualization using Spotfire for clinical data.
  • Qualified and result - oriented professional offering over 8+ years of experience in driving Data Analysis related Operations
  • Ability to work as individual contributor and with team as well as the ability to build and lead effective teams. .
  • Hands on experience working with end users and extending them technical support
  • Ability to learn and efficiently use tools to access data and analyses data
  • Ability to work with the client to prioritize and rationalize the requirements
  • Ability to work in a rapidly changing and growth oriented environment with regularly changing priorities and developing opportunities
  • Ability to work independently and complete tasks with minimal supervision

TECHNICAL SKILLS

  • Tibco Spotfire
  • SAS/BASE
  • SAS/ GRAPH
  • SAS/STAT
  • SAS/SQL
  • SAS/MACROS
  • SAS/VIEWER
  • SAS/LOG CHECKER
  • WINDOWS SAS
  • OPEN CDISC VALIDATOR Windows 7
  • Windows XP
  • MS Office 2007 & 2010 Active Directory 2008
  • Active Directory 2003
  • QCPR
  • CERNER
  • Affinity
  • EDM
  • QES

PROFESSIONAL EXPERIENCE

Confidential, Pennington, NJ

SAS Consultant

RESPONSIBILITIES:

  • Worked on conversion .XPT files with the data into SAS Data Sets with the SAS Program for DEM, ECG, AELOG, DOS SO, ADPAGG, BLEED, CRIT, VISIT & MED.
  • Converted PKDATA and PKARDATA .xls files into SAS DATA Sets through SAS Application environment.
  • Performed the data validation on the raw data BY using PROC SORT, UNIVARIATE, and COMPARE.
  • Performed the data manipulation for the final data analysis BY using PROC COPY, SQL, and TRANSPOSE
  • Developed the derived variables: SAFEPOP, GRP, ITT in DM Data Set; AE DUR in AE Data Set.
  • Documented and maintained the Quality Control Tracking Sheet for summary tables, listings and graphs.
  • Responsible for collecting raw data from multiple sources.
  • Familiar with macro variables, macro program & used few standard macros for the study.
  • Created Data definition document for all the transport files for E-submission.
  • Worked and Identified the GAPs by performing the Gap analysis /mapped the variables between the source and target SDTM Domain (Version 3.1), and implementation guide 1.3 and used controlled terminology (Code list Code). Familiar Proc CDISC, Vcolumn (SASHELP) and used Open CDisc Validator on the data sets.
  • Migration of xpt files into SAS datasets using Xport engine to create transport files. Using Cport and Cimport to import xpt files to SAS datasets.

Confidential, Plainsboro, NJ

Application Control and Reporting Analysis

RESPONSIBILITIES:

  • Handled troubleshooting of various applications via remote tools such as SMS, LogMeIn, Dameware and VNC client
  • Set up preapproved Role-Based Access Control (RBAC) and eliminated access request forms for nursing floors, improving productivity by 50%
  • Created/managed network accounts, mailboxes, VPN accounts and permissions for all users, including applications such as QCPR, Affinity, CERNER,Minitab,SAS, Affinity, Lawson, EDM, QES, Wellsoft, RAS, Allscripts Homecare, McKesson, GE-OR, GE Parental and Optilink.
  • Worked with VM Administrators and Citrix Console to reset desktops and restore availability of programs
  • Checked Lawson daily termination report, log termination ticket in LANDesk and terminated access from all applications.
  • Monitored egate interface engine, restart application and interface.
  • Created access for both network (with exchange mail), and applications for end users; resolved all access control helpdesk calls. Supported management during internal and external audits. Monitored egate interface and resolved EDM and ADT interface issues overnight.
  • Excellent Understanding of Lawson Database.

Confidential

Reporting Analyst

Responsibilities:

  • Creating of New Templates for all the reports maintaining Master database weekly report, monthly report and monthly review presentations.
  • Generating Daily termination Report
  • Perform ad hoc duties in accordance to business needs
  • Responsible for all daily, weekly, monthly and regular interval reports being run and distributed in a timely manner
  • Preparation of monthly performance status reports to senior management..
  • Effectively combine data from multiple, disparate sources and understand how they relate.
  • Analyses, interpret and translate this info/data into meaningful, actionable information
  • Ensure the accurate, thorough and timely delivery of all deliverables to become a key partner to the team's success
  • Maintain a reporting schedule and documentation of reporting procedures.

Confidential, Princeton NJ

Data Analyst

Responsibilities:

  • Initiated various projects and deployed concepts to increase performance level, achieve long term company goals
  • Maintain the research database, update and upgrade it from time to time and ensure safe storage of data.
  • Prepare analysis reports and assist in responding to the management on queries & concerns and other issues.
  • Regularly audited internal departments to track integrity issues and disclosed the same at the corporate level.
  • Assist the organization in performing data compiling, mining and analysis required to evaluate the given data.
  • Participated in business reviews to drive process linkage between planned & actual performance.
  • Delicately imparted training of Advanced Excel, MS-Access, PPT Presentation to MIS & Analytical and Quality team as for knowledge sharing and adding skills.
  • Preparation of sections of expert reports, dashboards, scorecards including review, summarization, analysis, verification and presentation of data required and identifying key issues.

We'd love your feedback!