SUMMARY:

• Experienced SAS Developer/Analyst with 9 years of experience in Life Sciences/Health Care domains.
• Rich SAS experience with exposure to Base SAS, Macros, SAS CONNECT, SAS ACCESS, SAS ODS, SAS 9 BI Suite (SAS ETL, SAS Management Console, SAS Enterprise Guide, SAS Stored Procedures, SAS Add - in for Microsoft Office).
• Experienced in generating reports for Clinical Trials, Drug Safety Domain
• Possesses strong understanding of business processes. Capable of overseeing project from conceptual phase to successful implementation.
• Experienced in Drug Safety applications and providing safety data using SAS/Oracle as per business needs.
• Experienced in data analysis, data manipulation and data quality reports for large datasets in SAS.
• Integrating SAS with other databases like Oracle, Netezza, SQL Server etc
• Experience in full life cycle of software design process including Requirements definition, Prototyping, Design, Migration, Maintenance & Support.
• Experience in Managing SAS Servers, Stored Process and Metadata libraries.
• Strong communication, motivation, team building, liaison, and leadership skills.
• Certified Advanced SAS Programmer (SAS9)

TECHNICAL SKILLS:

Operating Systems: Windows and UNIX

Databases: MySQL, Oracle, Teradata and Netezza

Tools: MS Visio, Toad, PL/SQL Developer, Aginity and SQL Server Management Studio

SAS: SAS/BASE, SAS/MACROS, SAS/SQL, SAS/ODS, SAS/REPORT, SAS Stored Process, SAS EGSMC. SAS Info Map Studio, SAS CI Studio and SAS BI

Environment: SAS 9.1.3 /9, UNIX, SAS/Access, SAS/ConnectSAS Add in for Microsoft Office and SAS Metadata/MidTier Server

EMPLOYMENT HISTORY:

Confidential, Boca Raton, FL

Sr. SAS Developer

Responsibilities:

• Meetings with business stakeholders and end users to development segmentation strategies and add efficiencies to the campaign development and execution process
• Generate reports, listings and graphs using SAS/Base, SAS/Macro and SAS/Graph, SAS/SQL, SAS/Access, SAS/ODS and SAS/connect.
• Create SAS Stored Processes to use them from different client SAS applications.
• Managed data from SAS Management Console Studio and then mapping it from SAS Information Map Studio so it can be readily available for business stakeholders.
• Managed access/authorization and deploying jobs from SAS Management Console.
• Provided insights on effectively running of marketing campaigns including direct mail, email, mobile and other digital channels.
• Documented all programs and procedures to ensure an accurate historical record of work completed on assigned project.

Tools: Base SAS, Macros, SAS Connect, SAS/Access, UNIX, Enterprise Guide, SAS Management Console, SAS/Stored Process, SAS CI Studio.

Confidential, Louisville, KY

SAS Technical Lead

Responsibilities:

• Conducted a Campaign Requirements Analysis workshop to gather requirements and developed insights for creating multi channel marketing campaigns for Pharmacy.
• Daily Meetings with business stakeholders and end users to development segmentation strategies and add efficiencies to the campaign development and execution process
• Performed Data analysis, statistical analysis, generated reports, listings and graphs using SAS/Base, SAS/Macro and SAS/Graph, SAS/SQL, SAS/Access, SAS/ODS and SAS/connect.
• Produced quality Ad Hoc reports for clinical team and clinical data manager.
• Managed SAS Servers, Stored Process and metadata repositories.
• Managed data from SAS Management Console Studio and then mapping it from SAS Information Map Studio so it can be readily available for business stakeholders.
• Managed access/authorization and deploying jobs from SAS Management Console.
• Provided insights on effectively running of marketing campaigns including direct mail, email, mobile and other digital channels.
• Documented all programs and procedures to ensure an accurate historical record of work completed on assigned project.

Tools: Base SAS, Macros, SAS Connect, SAS/Access, UNIX, Enterprise Guide, SAS Management Console, SAS/Stored Process.

Confidential

SAS ETL Lead

Responsibilities:

• Coordinating offshore activities of the project
• Interacting with the client for requirements when development activities is done and if any issues occur.
• Writing SAS Macros to add new tables in SAS ETL.
• Reviewing the SAS codes written by other team members.
• Automation of codes which run manually.
• Debugging and fixing of codes in case of failures.
• Mentoring new associates on SAS and project processes.
• Performance tuning of already existing codes.
• Preparing different projects documents that includes project manual, checklist, daily tracker etc..

Tools: Base SAS, Macros, SAS Connect, SAS/Access, UNIX, Enterprise Guide

Confidential

SAS Developer/Analyst

Responsibilities:

• Extracting data from different sources (CSV, SAS data files etc.)
• Developing SAS programs to analyze the clinical data
• Validating the Source with respect to provided CSR and CRFs based on the requirement, developing programs in Base SAS for converting the source data into the specified Client Standard
• Involved in mapping of Clinical study data
• Performing the Quality checklists on the mapped data, and preparation of Quality Gate documents at different levels
• Running the different level reports on the mapped data using SAS programs, creating listings and summary reports on the mapped data
• Verifying the created listings and summary reports with the CSR and legacy reports, and recording all the incosistencies and mismatches to the Quality Gate document.
• Developing the macros at various instances for automating the output
• Generation of multiple safety domain related reports like demographics, Treatment emergent adverse events, serious adverse events etc.
• •Understand clinical trial related documents (e.g., Protocol, CRF, SAP)
• Analysing and Interacting with Client for collection and finalization of requirements
• Assignment and coordination of work for the team
• Review and QC of all deliverables and reports developed.
• Analyse and report defects and do the causal analysis.
• Tracking Issues during the study and keeping records of the opening/closing of the issues.
• Developing Generic processes and macros to streamline the activities using Base SAS and Macros.

Tools: Base/SAS, Macros, SAS/ODS, SAS Connect, SAS/Access, UNIX, SAS/SQL and MS Excel, Client internal tool (CDARS and DT)

Confidential

SAS Developer/Analyst

Responsibilities:

• Involved in creation and validation of Analysis Datasets and Integrated Databases
• Involved in creation of SAS Macros that create standardized Analysis Reports for various therapeutic areas
• Study and analyze the requirements and develop detailed specifications for development of new Broad Use Modules.
• Analyze the requirements and develop detailed specifications for enhancement/changes of existing Broad Use Modules.
• Study and Analysis of Functional requirements and Design document.
• Develops, creates, and maintains extract systems/programs for Clintrial, CRO and InForm™ studies using SAS.
• Software Testing including Unit Testing, Test case/data preparation, execution and verification of the test results.
• Review of test documents and results.
• Performing walkthrough & inspection as per standard operating procedure (SOP).
• Performs peer reviews and acceptance testing for all applications/programs supported by the Team.
• Coordination of activities with Onsite team.
• Preparation of weekly and Monthly status reports.

Tools: Base SAS, Macros, SAS Connect, SAS/Access, UNIX

Confidential

SAS Developer/Analyst

Responsibilities:

• Coordinating offshore activities of the project, which includes making project deliveries of various studies, interacting with the client on a regular basis in order to understand the problems they are facing in the studies, collecting their suggestions and then conveying the suggestions to the people working on that study.
• Writing SAS codes to create analysis dataset.
• Reviewing the SAS codes written by other team members.
• Writing tools and utilities in SAS which are used for automating analysis dataset creation and testing of the analysis dataset.
• Reviewing the existing utilities and working for their performance enhancement.
• Training new associates on Base SAS.
• Handling managerial activities.

Tools: Base SAS, Macros, SAS Connect, SAS/Access, UNIX