Candidates About

Preetha

 Summary:

• Certified SAS Programmer with 9+ years of experience in HealthCare and Financial domain.
• Experience in Tableau and SAS ( SAS/BASE, SAS/SQL, SAS/MACRO, SAS/GRAPH).
• Developed and published dashboards and scheduled them on Tableau server.
• Worked in Adhoc Reporting (Sales & Marketing) in HealthCare Domain.
• Performed Adhoc analysis, Data Validation for Client Analysis in SAS as necessary to support Business needs.
• Worked in Consumer Bank Risk (BASEL II) in Financial Domain.
• Hands on in Analyzing the data from diverse client data source files.
• Experience in Data Manipulation procedures such as SAS Formats/Informats, Merge, Proc Append, Proc Datasets, Proc Sort, Proc SQL and Proc Transpose.
• Proficiency on various SAS procedures like Proc PRINT, Proc REPORT, Proc SQL, Proc Sort, Proc Means, Proc Univariate, Proc Freq and Proc Summary, Proc TABULATE, Proc COMPARE.
• Good understanding of Study Protocols, SAP (Statistical analysis plan),BRD,FRD.
• Experienced in the preparation of SAS Datasets, Tables, Listings, Graphs, Reports, Output Delivery System (ODS) and Summaries according to requirements, Standard Operating Procedures (SOPs), Statistical Analysis Plan (SAP).
• Knowledge of Programming languages like C, Visual Basic, .NET,PL/SQL
• Possess strong ability to adapt to new applications and platforms.

Skillset:

SAS tools                      : SAS/BASE, SAS/MACRO, SAS/SQL, SAS/STAT

Operating Systems      : Windows XP/NT/2000, UNIX, LINUX

Languages                   : C, C++, VB, .NET, SQL/PLSQL

Databases                   : Oracle 9i, Oracle11g , Amazon RedShift

Reporting Tools           : Tableau,ThoughtSpot

Software                      : ArcGIS Version 9.1

Office tools                 : MS-word, PowerPoint, Excel, Toad, SQL Developer, MS Visio

Clinet : Bristol Myers Squibb                                                            Duration: Aug 2013 – Sep 2017

Role     : SAS Analyst/Tableau Developer

Responsibilities:

·            Experienced in incorporating and manipulating data in SAS from various datasources ( Excel, csv, text, Oracle, AWS,Vertica, Netezza) .

·            Created and scheduled Weekly / Monthly Adhoc reports .

·            Experienced in handling Webmetrics data in analyzing the performance of the website data.

·            Developed SAS programs for SMART in analyzing the execution of the Alerts on time by brand by Salesforce.

·            Developed Launch Tracker dashboard which helps in analyzing the product reach after the lauch and also in MCM (Multichannel Marketing).

·            Developed, designed and deployed Graphic Visualizations (Trend lines, heat map, bar chart, pie charts, LOD etc) in Tableau per the metrics required by Business.

·            Generated Global Filters, Parameters, Groups, Set, Calculated fields, Drill downs & Hierarchy, interactive views as required by Users. Also used Data Blending between two different data sources in Tableau.

·            Experienced in handling the Media Campaign data which aids in evaluating the incoming traffic to the Website and in determining the product reach.

·            Handled Iplan, HealthStar , Veeva, FICO data.

·            Developed SAS programs and dashboards for Reptrigger, Direct Mail and Home/Office Emails related data and evaluating the performance of the reps in territory.

·            Published, Scheduled dashboards and granted privileges to Users on Tableau Server.

·            Worked on Performance Based Contracting in analyzing the brand performance for the contract by computing the market share.

·            Exposure to Thoughtspot.

Environment: SAS 9.1/9.2/9.4(SAS/Base, SAS/SHARE), Unix , Oracle Sql Developer 3.2,

                        Vertica, Netezza, Sql Workbench, Amazon redshift, Oracle, Tableau 8/9.0/10.3

Client: CitiGroup                                                            Duration: Apr 2011 – Jul 2013

Role: SAS Programmer/Analyst

Responsibilities:

·         Worked in analytical model to segregate the data into Clusters based on the risk drivers.

·         Developed and executed SAS programs by interpreting the business requirements.

·         Created SAS data sets by extracting data from Oracle database and flat files using Proc SQL, Proc Import, SAS Data Step, cleaned, validated and manipulated data by SAS and SQL.

·         Worked on developing cluster programs of the three BASEL Parameter (Probability of Default (PD), Credit Conversion Factor (CCF), Expected Loss Given Default (ELGD)) for RWA (Risk Weighted Assets) calculation.

·         Created macros to perform the calculation/operation required for the clustering data.

·         Performed T-Test between two clusters to determine the significant difference.

·         Performed testing, debugging, and documentation of the SAS programs, which are used in computing the RWA. 

·         Used various SAS PROC’s and SAS SQL’s for manipulating the data and stored the results back to the Oracle tables for further calculations and generated diverse output files.

·         Developed and delivered the ad-hoc requests from the users.

·         Prepare daily, monthly, and ad hoc reports and presented the findings and recommendations.

·         Renewed the SAS licenses on AIX servers in Dev and PROD environments.

Environment: SAS 9.1.3(SAS/Base, SAS/Macro, SAS/SQL) Oracle 11g, PL/SQL, Excel, AIX.

Client: Schering Plough                                                   Duration: Oct 2009 – Nov 2010

Role: SAS Programmer/Analyst

Responsibilities:

·         Extract the raw data from database and prepared SAS Datasets

·         Created edit check programs to find data discrepancies in raw datasets provided by Data Management Group.

·         Prepared Annotation CRF for submission.

·         Worked with biostatisticians for creating analysis datasets (ADS) by deriving endpoints according to the specifications and requirements in the SAP by writing SAS programs.

·         Performed derived variables verification and program validation using Proc Compare, Proc Means, Proc Print, keep drop statements.

·         Generated tables, listings and graphs according to Protocol and Statistical Analysis Plan (SAP) using PROC MEANS, PROC FREQ, PROC TRANSPOSE, PROC REPORT, PROC GCHART, PROC GPLOT procedures.

·         Used SAS ODS to produce HTML, PDF and RTF format files.

Environment: SAS 9.1.3, SAS/Base, SAS/Macro, SAS/SQL, SAS/Graph, Oracle 9i, PL/SQL, Excel, Windows NT.

Client: Alcon Pharmaceutical, Fort Worth, TX                Duration: Jul 2008 – Sep 2009

Role: SAS Analyst

Responsibilities:

·         Developed and modified SAS programs to load data from the source and create study specific datasets for report generating programs.

·         Created reusable Macros and used existing macros for Data Cleaning, Validation, and Analysis and Report generation.

·         Performed Data Analysis on the data sets using PROC ANNOVA, PROC MEAN, PROC UNIVARIATE, PROC FREQ and PROC TRANSPOSE.

·         The accuracy and integrity of data were verified by performing validation checks written in SAS and checked for data related errors, outliers, and missing values.

·         Generated reports and carried out quality control related duties using the SAS procedures Proc REPORT, Proc SQL, Proc Sort, Proc Means, Proc Univariate, Proc Freq and Proc Summary.

·         Produced tables, listings, and figures for the Clinical Study Report (CSR).

·         Used Proc Compare, Proc Means and other standard procedures for data validation and edit checks.

Environment: SAS v.9.0, (Base, Graph,  Macros, SQL)

Client: Shasun Chemicals & Drug, Chennai, India Duration: Sep 2006 – Jun 2007

Role: Statistical Programmer

Responsibilities:

·         Imported data from Excel and flat files into SAS datasets.

·         Performed data validation on the data sets and deleted repeated values using conditional data steps such as @@, if-then statements.

·         Developed analysis plans including specs for tables, listings, graphs and validation.

·         Worked on pre-specified statistical tables, figures, and reports concerning the study and analysis relevant to publication.

·         Developed listings, tables and graphs for Efficacy and Safety for assigned clinical studies

·         Created reusable macros and developed SAS Programs for Data Cleansing, Validation, Analysis, and Reporting purposes

·         Tested and debugged existing macros.

·         Provided output for the Clinical Study Report and the Integrated Summary of Safety/Efficacy (ISS/ISE).

·         Used TRANSPOSE, UNIVARIATE, SUMMARY, MEANS, FREQ, TABULATE, REPORTS, CONTENTS, SORT, PRINT and SQL extensively

·         Designed, built and tested a series of SAS programs.  Used SAS/ODS to generate PDF, HTML, and RTF listings.

Environment: SAS V8, SAS/BASE, SAS/MACRO, Win 2K.

Education:

BS        -           Information Technology, School of Engineering & Technology, INDIA.

MS       -           Geo Hydro Informatics, Bharathidasan University, INDIA