Data Sas

Qamar Sultana

OBJECTIVE

Looking forward to a challenging and competitive work atmosphere leading to a Professional experience with a dynamic and progressive organization where my skills, talents and abilities will be utilized to the fullest for mutual benefit.

SUMMARY

Over 7 years experience in analysis, design, development, testing and implementation of various applications using SAS for interactive/dynamic reports generation in Health Care and Finance Industry

Proficiency in SAS, SAS/BASE, SAS/GRAPH, SAS/SQL, SAS/STAT, SAS/MACRO, SAS/ACCESS, SAS/INSIGHT, SAS/ASSIST, SAS/ODS, SAS/AF in Windows and UNIX environments.

Thorough knowledge in SAS programming, Macro Facility, SAS Procedures, SAS formats, SAS functions, SAS statements, SAS Informats, merging SAS Data set, Preparing data, Producing reports, storing and managing data in SAS

Strong experience in Clinical Trials and Reporting Tools and have created statistical reports for FDA/NDA submission

Strong knowledge of clinical trial data and Good experience in designing, developing and analyzing the data, debugging the errors, reviewing the SAS code.

Experience in creating the SAS datasets by merging, concatenating, interleaving and validating datasets and TLG’s based on company requirements and resources.

Extensive experience in generating reports and creating summaries according to the specifications of Statistical Analysis Plan (SAP) and Standard Operating Procedures (SOP).

Extensive experience working on Phase I, Phase II, Phase III and Phase IV

Good working knowledge of Clinical Trials data like Demographic data, Discrepancy data, Adverse Events (AE), Serious Adverse Events (SAE), laboratory data (lab data), physical and vital signs and Audit Trials

Thorough knowledge in Post Marketing study analysis and IMS Prescription data analysis

Excellent skills in diagnosing & avoiding errors, understanding & enhancing output to furnish reports

Generated various SAS reports according to the 21 CFR-Part11.

Created PDF, RTF, HTML files using SAS/ODS

Extensive experience developing applications using SQL Server, Oracle, DB2, MS Excel and MS Access

Excellent interpersonal, organizational, leadership and oral/written communication skills contributing to project success in multi-tasking, fast paced environment

Experience in working with customers to determine their needs, gather, analyze and document requirements, communicate with customers throughout the development cycle, manage customer expectations, resolve issues and provide project status

Experienced working with operating systems like UNIX, Windows, LINUX.

TECHNICAL SKILLS

SAS Tools

SAS/BASE, SAS/GRAPH, SAS/SQL, SAS/MACRO, SAS/ODS, SAS/ACCESS, SAS/INSIGHT, SAS/ASSIST, SAS/STAT, SAS/AF, SAS/ETL and SAS Procedures.

Statistical Tools

SPSS, Maple 9.0, Mathcad Explorer 7.03, Mathpro Explorer, MATLAB 6.1, Scientific Work Place 3.0, Mathematica 5, Minitab.

Languages

C, C++, FORTRAN 77, SQL, PL/SQL, SQL*PLUS, SCL, FoxPro

Databases

Oracle, MS-Access, DB2, SQL Server, Teradata 4.2

Microsoft Tools

MS-Word, MS-Excel, MS-PowerPoint, and MS-Access

Web Tools

HTML

O/S

Windows, Linux and UNIX

PROFESSIONAL EXPERIENCE

JP Morgan Chase. Newport, NJ Jul ‘13-Till Date

Role: SAS Programmer

Responsibilities:

Involved in extracting, analyzing and auditing marketing data from the data-warehouse using SAS

Participated in marketing campaign-planning meetings with program managers in order to develop and document campaigns specifications

Created SAS data sets by extracting data from Oracle tables using SAS/CONNECT and SAS/ACCESS

Developed scripts, procedures and applications to generate sophisticated ad hoc reports

Worked with Marketing and Financial departments to develop required applications for performing complicated analysis like customer retention analysis, identifying cross-sell opportunities, portfolio performance tracking, calculating moving averages etc.

Used PROC SQL for ad-hoc report programming, to perform the tasks like data manipulation of multiple views in Oracle, creation of the ad hoc reports for marketing research data, preplanning and doing ad hoc joining of multiple Oracle views

Modified existing SAS programs and developed new SAS programs and generated weekly/monthly/quarterly/annual reports using PROC TABULATE, REPORT. Also provided descriptive statistics using PROC MEANS, FREQ, and UNIVARIATE

Generated SAS MACROS and several PL/SQL stored procedures for reusability and to minimize data processing

Ran SAS report programs and exported the results into Excel for data analysis

Created survival graphs in MS-Excel by transporting SAS data sets into Excel spreadsheets. Retrieved Oracle tables with Proc SQL using Pass through Facility.

Environment: SAS 9.4, SAS/BASE, SAS/MACROS, SAS/ACCESS, SAS/SQL, SPLUS, Excel/Access 2013, Oracle 12c, DB2 UDB, Window 7 and 8, and UNIX.

Comcast, West Chester, PA Sep ‘12-Jul ‘13

Role: SAS Programmer/Analyst

Responsibilities:

Creation of SAS datasets by accessing remote clients through SAS/CONNECT and SAS/ACCESS.

Involved in developing code using Base SAS & SAS macros to extract data from Oracle tables.

Usage of SAS/FSP for managing datasets.

Upgraded and enhanced existing systems for better performance.

Developed different Regression models, Categorical Analysis, Multivariate Analysis.

Usage of Proc SQL to create new tables in proposed format.

Exported SAS files to Excel using DDE (Dynamic Data Exchange).

Interacting with project team members to understand reporting requirements.

Creation and Export of analysis reports to the web to enable clients to have access through SAS Integration.

Extensive usage of SAS/ODS to export the data.

Updating systems whenever necessary with sales, customer information.

Managing and reporting data so that it complies with FCC regulations.

Coordination with different departments such as Sales, Marketing, Technical centers to obtain the data and provide required information.

Environment: SAS 9.3, SAS/Base, SAS/Macro, SAS/Connect, SAS/Graph, SAS/Stat, SAS/AF, Oracle 11g/12c and DB2, Excel and Word 2010, Windows 7, NT, UNIX.

Omnicare Clinical Research, East Greenbush, NY Jan ‘11-Sep ‘12

Role: Clinical SAS Programmer

Responsibilities:

Data Extraction: Converted MS-Excel tables into SAS data sets.

Provided SAS programming and analysis support for Phase II clinical trials.

Performed data analysis, statistical analysis, created listings, graphs and reports using SAS and various SAS procedures.

Produced quality customized reports by using PROC REPORT, SUMMARY and also provided descriptive statistics using PROC Means, Frequency, and Univariate.

Used sorting and merging techniques on the input data sets for Data Preparation, to get the required output and then writing the code using SAS tools.

Wrote SQL queries to check data for different conditions.

Involved in generating ad-hoc reports.

Extensively involved in the process of data validation.

Environment: Base SAS, SAS/Macro, SAS/Sql, SAS/Connect, SAS/Access, SAS/Graph, SAS/Stat, MS office, Windows, UNIX, Outlook.

INTROGEN Therapeutics Inc, Austin, TX Mar ‘10-Jan ‘11

Role: Clinical SAS Programmer

Responsibilities

Generated analysis data sets for both safety and efficacy parameters based on the guidelines provided in the SAP (Statistical Analysis Plan).

Modified data sets using set, merging, sort, update, formats, and functions.

Validated datasets and TLGs by writing competing code.

Participation in Team meetings to discuss various issues.

Collected requirements from statisticians, prepared requirements document.

Developed macros for report generation using SAS/Macros as per the statisticians’ requirements and programs for statistical analysis and data displays.

Used SAS ODS to create RTF and PDF reports.

Generated SAS/Graphs using standard macros.

Promoted developed code to production environment with proper documentation of changes made.

Participated in Program validation and e-submission (CDISC).

Used SAS functions, procedures, arrays, macros, formats extensively.

Environment: Base SAS v9, SAS/BASE, SAS/ACCESS, SAS/SQL, SAS/STAT, SAS/GRAPH, Windows, MS Office, HTML, Macros, UNIX.

Lee Pharma, Hyderabad, India Jun ‘08-Mar ‘10

Role: SAS Programmer

Responsibilities

Provided system solutions to client using various systems & software (SAS, SQL, Oracle) .

Extensive use of procedures such as proc transpose, proc compare, proc format, and proc contents. Responsible for developing new SAS programs and modifying existing SAS programs.

Developed reports using proc report, proc tabulate proc univariate, proc summary, proc means, and data null steps. Extensive use of SAS MACRO facility, SAS/GRAPH, SAS/ODS, SAS/SQL, and proc template. Provided QA and extracted data from existing data sources and perform ad hoc queries.

Responsible for developing programs using proc SQL and extracting data from ORACLE tables.

Build Hypothesis testing, comparing independent groups, Paired groups, test for normalization. Programming of data listings using SAS.

Environment: SAS/BASE (V 4.1), SAS/STAT, SAS/SQL, SAS/MACRO, SAS/GRAPH, SAS/ACCESS, SAS/ODS, SAS/ETS, SAS/QC, Oracle 10.2.0.1, Windows 2007.

Contact this candidate