SUMMARY

• Resourceful and Research OrientedSASAnalytics professional, with around 5 years of experience in application development, database design, data validation, manipulation, data analysis, process optimization and root cause analysis.
• Well versed with Descriptive, Inquisitive, and prescriptive analytics techniques.Strong abilities in problem solving, data analysis and complex reports generation.
• ProficientinSAS SAS/BASE,SAS/MACRO,SAS/ACCESS,SAS/SQL,SAS/STAT,SAS/GRAPH,SAS/Reports,SAS/ODS,SAS/Stored Procedures, AS/Web Report Studio, AS Dashboard, AS Management Console and ETL Operations and managing software quality/functionality testing.
• Proficient in Requirement elicitation, refining requirements and data mapping.
• Proficient in inferring results and writing analytical reports.
• Strong fundamentals in Business Statistics, Mathematical Statistical Analysis, Linear Algebra and financial mathematics concepts.
• Skilled at data modeling, database design, views, normalization, stored procedure, triggers and functions.
• Strong programming, analytical and problem solving skills.
• Experience in programming for generating graphs, data listings and tables using data steps, procedures, and SQL andSASmacros.
• Experience in developing application for data updates, data cleansing and reporting.
• Proficient in Microsoft Office Suite (Word, Excel, Outlook and PowerPoint).
• Exceptionally well organized, strong work ethics, and mindset to work hard to achieve client's objectives on time.
• Skilled in extracting, manipulating data, and creating Data Sets from various sources like Excel, flat files, Oracle database, Access database using PROC IMPORT techniques and SQL pass through facility.

TECHNICAL SKILLS

• SAS/Base
• SAS/SQL
• SAS/STAT
• SAS/Access
• SAS/Macros
• SASEnterpriseGuide
• SAS/Graph
• SAS/ODS
• SASBI
• SASDI
• SASWebReport
• Studio
• SASManagement
• Console
• SAS/Connect
• SAS/Map
• SASInformation Map

PROFESSIONAL EXPERIENCE

Confidential, Lincoln, Rhode Island

Clinical SAS Programmer

Responsibilities:

• Created analysis datasets based on the guidelines provided in the Data Definition Tables (DDT) and following the CDISC standard. Used SDTM model (3.1.1)/ ADaM for domain creation and CDISC compliant analysis datasets.
• Contributed to Integrated Summary of Safety (ISS), Integrated Summary of Efficacy (ISE) and Reports forclinicalStudies.
• Used Proc CDISC for verifying compliance of datasets with CDISC standards and electronic submissions.
• Worked on multiple protocols and/or drug compounds at a time.
• Responsible for providingClinicalSASprogramming and analysis support forclinicalstudies across multiple protocols for the submissions like CSR and Safety.
• Generated Tables, Listings and provide QC check, validation of outputs forclinicaltrials.
• Handled dropouts and missing data by following the conventional approach of Last Observation Carried Forward (LOCF) and Best Observation Carried Forward (BOCF) on visit - wise data.
• Responsible for Developing reports for Safety and efficacy as per study requirements.
• Involved in Developing, Debugging, and validating the project-specificSASprograms to generate derivedSASdatasets, summary tables, and data listings according to departmental standards.
• Used Sorting and Merging techniques on the raw data sets for value added data preparation, to get the required Reports or Analysis data sets.
• Performed QC (Quality Check) extensively on tasks performed by other team members and involved in data validation and data cleaning in all phases ofClinicalstudies.
• Extensively used Proc SQL to retrieve, update and report on information fromSASdata sets and other database products.
• Modification of existingSASprograms and creation of new programs usingSASMacros.
• Built Macros and create macro variables using %LET, CALL SYMPUT, and DATA NULL to halp generate analysis data sets and create specified structure of TLFs.
• Ability to quickly debugSAScompiling errors, to reviewSAScode and quickly identify areas of concern.
• Worked with Statisticians andClinicalData Managers to provideSASprogramming in analyzing theClinicalTrials and generating Reports.

Environment: SAS9.x/8.x,SAS/BASE,SAS/MACROS,SAS/STAT,SAS/GRAPH, Windows NT.

Confidential, Providence, RI

Statistical/SAS Programmer

Responsibilities:

• Categorizedclinicaltrial data as per CDISC into intervention class, event class, finding class, demographic class.
• Used SQL procedures to replace complex merge statements.
• Checked SDTM compliance through OPENCDISC VALIDATOR.
• Converted different file formats (Excel, CSV, and Plain Text Files) toSASdatasets.
• SASImport procedure/ Import wizard for non-RDMS (Excel, Access) data importing and SQL-pass through facility for importing data from RDBMS.
• Performed Ad-hoc Programming and Reporting.
• Designed flowcharts indicating the input data sets and the techniques dat would be used sorting, merging, etc. to get the desired output.
• Generated and validated patient profiles for the different studies developed standard macros and also used existing macros according to the requirements.
• Prepared Efficacy analysis with tumor response (CR or PR) and survival by customized DATA NULL programming, PROC TABULATE, PROC REPORT, FORMCHAR option for ASCII text for FDA submission.
• Summarized table as per mock TLG for extent of exposure, adverse event, hematology and serum toxicities, non-investigational medication, and vital sign for summary analysis.
• Developed TLG (table, listing, graph) and report of patient's data with descriptive and inferential statistics for continuous/categorical variables programmed by extensively using PROC FREQ, PROC UNIVARIATE, PROC MEANS, PROC LOGISTIC.
• Case report form Tabulation (CRT) using PROC REPORT as per CDISC SDTM standard.
• DevelopedSASprograms for summary Tables, Listing and figures, analysis datasets (CDISC ADaM) and analyses specified in the Statistical Analysis Plan.
• CreatedSASXPORT format file as per eCTD guideline usingSAS/Macro, PROC COPY, PROC CPORT
• Created complex and reusable Macros and extensively used existing macros and developedSASprograms for Data Cleaning, Validation, Analysis and Report generation. Tested and debugged existing macros.
• Formatted HTML, PDF and RTF reports, usingSAS/ODS system.

Environment: SAS8/9,SAS/BASE,SAS/MACROS,SAS/STAT,SAS/ACCESS,SAS/SQL,SAS/ODS,SAS/Report,SAS/XML Mapper Oracle, Window NT/2000, Excel/Access 2000

Confidential

Data Analyst

Responsibilities:

• Interacted with cross-functional teams to facilitate gathering of business requirements for the reports.
• Documented and updated procedures/policies for various processes
• Created ad-hoc reports on need basis using Excel
• Performed ad-hoc problem solving and analysis to resolve data discrepancies
• Extensively used excel and excel functions (V-lookup, Pivot tables) to create highly complicated reports dat would suffice the needs of higher management and Project Managers
• Retrieved data using SQL queries as needed to create reports for internal and external clients
• Assisted in creating dashboard reports required to effectively manage large portfolio of projects
• Efficiently generated weekly and monthly report distributions
• Effectively prepared and presented data to senior management
• Worked in multiple and changing priorities with different teams

Environment: SQL, MS Excel, Tableau, MS access

Confidential

Statistical Programmer

Responsibilities:

• Performed statistical analysis and data management on study data by utilizing appropriate statistical methods using SAS and SAS tools.
• Created SAS programs using Proc Report, Proc Summary to generate reports on patients who deviate from Protocol specifications. Served close with the statistician and make sure everything is in right place.
• Primarily using SAS and Excel for statistical analysis of online activity and call center data.
• Gathers, consolidates, links and analyzes data/metrics from multiple sources such as site analytics, customer sat, order flows, and back-offices. Identifies out of trend results and data issues and drives for resolution with data owners and appropriate service and support teams.
• Creates results presentations and facilitates results review meetings with senior leadership,directors and managers to analyze results and action planning.
• Oversees transitioning of manual service/support reporting processes to the outside vendors and monitor performance on an ongoing basis, monitors performance of vendors and ensure accurate reporting.
• Directly responsible for supporting business needs from metrics need standpoint and working with responsible parties to deliver results.
• Results are performed using SAS programming and using techniques such as SAS Macro language, advanced data manipulation, and statistical procedures (e.g., PROC FREQ, PROC REPORT).
• Provide SAS Programming support and technical assistance in the accurate development and intermediate steps required.
• Coding SAS programs with the use of SAS/BASE and SAS/Macros for ad hoc jobs.
• Maintained and enhanced existing SAS reporting programs for marketing campaigns.
• Participated in designing, coding, testing, debugging and documenting SAS Programs.
• Used SAS Enterprise Guide to access data, to manage data, to create reports and to validate data and data mining.