SUMMARY:

• SAS Advance and Base certified with Over 7 years of robust professional work experience in Data Cleaning, Data Aggregation, Data Mining, Data Analysis, Application Development and Reporting with SAS.
• Ability of creating submission-ready standard data presentations and data sets using standard coding and
• following OPD processes including SDLC.
• Experienced of extracting, manipulating, summarizing, analyzing and presenting data using SAS procedures.
• Experienced of SAS/MACRO, SQL and SAS/BASE procedures
• Extensive knowledge of SAS/GRAPH and Statistical procedures
• Experienced of Clinical data and medical dictionaries
• Seasoned experience with study reporting
• Extensive experience using CDISC/STDM/ADaM
• Firm knowledge of basic statistics, relational database principles and Oracle Clinical
• Clear understanding of clinical needs for data/presentations
• Good written and verbal communication skills and interpersonal skills
• Extensive knowledge of routine statistical methodology and its application
• Understands the value of programming and process standards in the achievement of long term objectives
• Exhibits routine and occasionally complex problem solving skills
• Firm understanding of the use of established standards, SOPs and best practices.
• Recognizes when negotiating skills are needed and seeks assistance
• Seasoned experience on clinical data programming
• Proficient with current Windows operating system and MS Office Suite.
• Ability to utilize above average written and oral communication skills to accomplish projects, Ability to prioritize and manage individual time across multiple projects, Ability to work well in a team environment.
• Deep understanding of the client's vision, goals, limitations, data sources and time lines.
• Independent judgment is employed in problem solving subject to limits previously established by management.
• Firm grasp over understanding of business needs and strategies to develop reliable and effective solutions.
• Firm understanding of Proc Olap and Proc Infomap to deliver solutions meeting complex business needs.
• Extensive experience transferring data across platforms (Mainframe, Unix, PC) based on the business and reporting needs.
• Vast experience in presentation using SAS, Excel, Pivot Tables, DDE for presenting the end results.
• Proven skills in SAS Base (data step and proc) and SAS Macro fulfilling on demand business needs.
• Advanced SQL skills with ability to code complex queries to load, clean, format & store data.
• Extensive SAS programming and documentation support for combining data extracts from multiple databases into a common dataset for analysis purposes.
• Seasoned SAS programming and documentation support for generating a standard set of statistical tables, summaries, charts and listings based upon data extracts from multiple databases.
• Designed several ETL jobs using SAS DI Studio to port the ODS data into data marts with tasks involving configuring metadata libraries in SMC, developing transformation logic and staging the final data.
• Ability to code complex MDX code for OLAP cubes to have a tradeoff between storage space and performance
• Experience in SAS/STAT with linear and logistic regression, ANOVA, DOE, Clustering etc. to gain insight into the data.
• Skilled in analytical and business reporting using SAS, MS Office, VBA and RDBMS technologies.
• Conceptual knowledge of marketing mix, segmentation and association rules, market basket analysis, test and control groups, sample size criteria, hypothesis testing etc. in marketing domain.
• Experience in loading SAS Metadata Server with metadata from external packages for ETL development.
• 3 years of experience in job scheduling and load balancing using SAS Grid and LSF.
• Involved in preparing and reviewing BRD, FRD documents to serve development and reporting.
• Experience in coding mathematical expressions in SAS as per the requirement using legacy and new functions.
• Extensive experience in Teradata tools & utilities like SQL Assistant, BTEQ, FastExport & TPump for business analytics and reporting on massive Enterprise Data Warehouse.
• Strong skills in requirements gathering, analysis and ETL design, coding, debugging.
• Excellent expertise with different types of data load strategies and scenarios like Historical dimensions, Surrogate keys, Summary facts etc.
• Completed several projects with accountability for design, development, and implementation of enhancements which involved secure data transfers to external vendors.
• Involved in projects having to deal with cross functional teams and multiple stakeholders.
• Minimum time to self-sufficiency in any environment.

TECHNICAL SKILLS:
SAS Tool : SAS/BASE, SAS/MACROS, SAS/STAT, SAS/GRAPH, SAS/SQL, SAS/ODS, SAS Enterprise Guide
Office Tools : MS office.
Operating Systems : Windows 98/2000/XP/Win-7/Win-8, UNIX.
Languages : SAS v 8/9/9.1.3, SQL, C.
Databases : Oracle, MS-Access

PROFESSIONAL EXPERIENCE:
Confidential, Atlanta, GA
Role: SAS Programmer
Responsibilities:

• Analyzed business workflow and system needs.
• Conducted interim analysis, QC, eSub work, as required.
• Firm understanding to work to delivery timelines including allowing time for internal FSP QC, as appropriate.
• Experienced working with supervisor to balance conflicting priorities.
• Experienced in understanding timelines for and milestones affecting their work and alert supervisor and PoC to potential slippage.
• Ensured training done before embarking on a task
• Experienced as an Alert Supervisor where skills or knowledge are not adequate for the task set – seek help
• Developed appropriate QC programs as defined at kick-off or by PoC
• Ran routine QC programs with TQM, Control Charts, Pareto Analysis, Fishbone Analysis, VOC.
• Developed and validated output programs using SAS.
• Extensive SAS programming and documentation support for combining data extracts from multiple databases into a common dataset for analysis purposes.
• Seasoned SAS programming and documentation support for generating a standard set of statistical tables, summaries, charts and listings based upon data extracts from multiple databases.
• Extracted the data from DB2 and Oracle using PROC SQL pass through facility.
• Extensive proficiency with current Windows operating system and MS Office Suite.
• Ability to utilize above average written and oral communication skills to accomplish projects, Ability to prioritize and manage individual time across multiple projects, Ability to work well in a team environment.
• Deep understanding of the client's vision, goals, limitations, data sources and time lines.
• Worked with the Guest browser's data, sales data that consists of more than 2 billion records.
• Used Common Table Expressions (CTEs) to improve the resources usage and increase the performance.
• Converted raw data file into SAS datasets using the SAS INFILE statement.
• Scheduled SAS jobs using CRON TAB Scheduler.
• Extensively used proc SQL, proc EXPORT and SAS Macros.
• Used SAS/MACRO facility to decrease the redundancy of extensively used SAS scripts and to increase the flexibility of the code.
• Developed SAS code and created ad-hoc reports based on the given requirements.
• Created dashboard reports and ad-hoc reports on weekly and monthly bases.
• Used excel and VBA scripts to develop the ad-hoc reports.
• Extensively used query analyser to check the data in the Database (DB2) and run the SQL queries directly in the DB2.
• Created Indexes to improve the efficiency.
• Wrote the SAS code from scratch to develop the reports.
• Used Output Delivery system (ODS) facility to direct SAS output to RTF, PDF and HTML files.
• Worked on ad-hoc requirements and later converted them as monthly and quarterly reports.

Environment: Windows XP, SAS/BASE, SAS/Macro, SAS/ODS, SAS/SQL, SAS/STAT, Excel, Proc SQL, PC SAS, DB2.

Confidential, Columbus, OH
Role: SAS Analyst/Programmer
Responsibilities:

• Developed SAS programs for statistical analyses and data displays.
• Communicated accurate task and project timelines, informing appropriate individuals (PoC/CPM/etc) of completion status
• Extensive experience in writing technical documents (e.g., code specifications and program documentation) concise and unambiguous.
• Carried out rework as requested by supervisor/PoC
• Participated in workgroup meetings or in immersion meetings provide feedback to PoC supervisor and work group members on issues related to PoC deliverables.
• Detected errors in detailed work and corrects them (e.g., reviews tables/listings, edit checks output and SAS programs to ensure quality of deliverables).
• Carried out rework as requested by supervisor, PoC.
• Followed escalation process and neither suppress nor over-escalate issues.
• Contributed to close-out evaluations and any discussion.
• Took raw data, built input data sets used sorting and merging techniques to get the required output and then wrote code using SAS/Base, Proc SQL and SAS Macro facility.
• Extensive SAS programming and documentation support for combining data extracts from multiple databases into a common dataset for analysis purposes.
• Seasoned SAS programming and documentation support for generating a standard set of statistical tables, summaries, charts and listings based upon data extracts from multiple databases.
• Data Analysis and graphical presentation for various summary reports using Base SAS and SAS/Graph facility.
• Ability to utilize above average written and oral communication skills to accomplish projects, Ability to prioritize and manage individual time across multiple projects, Ability to work well in a team environment.
• Deep understanding of the client's vision, goals, limitations, data sources and time lines.
• Raw data was processed to create datasets in the required format and tabulated so as to easily analyze data. Extensively used Proc Tabulate procedure for the purpose.
• Report generation using many SAS proc statements, SAS/MACROS, and data null steps.
• Actively involved in design and implementation of application software using primarily SAS system and analyzed existing application software and recommended improvements.
• Extracted raw data from excel spreadsheets and MS Access. Created input data sets and analyzed the data by creating graphs using the SAS/GRAPH facility.
• SAS was used for pre-processing data, SQL queries, data analysis, generating reports, and statistical analyses.
• Processed data collection to ensure proper quality of data. Maintained the daily error log for cleaning the data.
• Extensively used data export techniques. The data after being analyzed was directed to different output files such as Excel Spreadsheets and DBF files
• Extensively used Proc SQL procedure for working with oracle database for creating and updating the data as and when processed.
• Involved in post-Campaign Analysis.
• Designed, developed, tested and debugged new macros and modified the existing macros according to the enhancements in the business.

Environment: SAS/BASE, SAS/MACROS, SAS/SQL, SAS/ACCESS, SAS/GRAPH, MS Excel, Access 2000, Window NT/2000

Confidential, Cambridge, MA
SAS Programmer / Analyst
Responsibilities:

• Worked on Phases I and II Clinical Trials for Oncology and analyzed Phase I and II Clinical Trials.
• Produced listings, reports, tabulations and summaries of clinical trial data using procedures such as Freq, Means, Univariate, Summary, Tabulate, Report, and Transpose for statistical analysis by other Bio-statisticians.
• Provided input to planning documents such as Validation, Study Protocol and SAPs.
• Extraction of data from Oracle, DB2, Access and Excel for further analysis using Proc SQL Pass through Facility and DDE.
• Created and implemented Statistical Analysis Plans and specification documents; participated in database design, data collection guidelines and logic checks.
• Conducted, documented and reported data validation inspection in compliance with FDA Regulations (21 CFR Part 11) and other regulatory compliance.
• Participated in designing, coding, testing, debugging and documenting SAS programs and Macros.
• Developed SAS programs using Base SAS for tabulation counts, correlations and checks for dispersion for normality using PROC Means, PROC Tabulate and PROC Univariate.
• Applied generally accepted programming standards and techniques to assure efficient program logic and data manipulation.
• Created SAS Reports using the Data Null technique and Proc Report for NDA submission as per FDA regulations and company standards.
• Used PROC MIGRATE to migrate data sets from SAS 8.1 to SAS 9.1 in a Windows environment.
• Worked on SAS/GRAPH to present results in BAR Chart, PIE Chart and SCATTER Plot.
• Experienced using SAS/ETL tool to extract, clean, transform, load and manage data in a Windows environment.
• Formatted HTML, RTF and PDF reports using SAS/ODS.
• Created SAS views from an Oracle database upon statistician's requests.
• Worked with team members for SAS data migration and also helped them to validate the data sets after migration with the help of Migrate Validation Tools.
• Involved in preparing study results as well as ISS and ISE for NDA submissions using SAS.
• Seasoned skills on individual time across multiple projects, Ability to work well in a team environment.

Environment: BASE SAS V8, SAS/ACCESS, SAS/CONNECT, SAS/GRAPH, SAS/STAT, Excel, Access, Oracle 8, Window NT / 2000, UNIX

Confidential, SAS Programmer
Responsibilities:

• To extract data from flat files like excel and access using proc import.
• To clean the data and loading into new datasets by applying constraints.
• Loading the cleaned data after cleaning into access database.
• Creating user defined formats by using Proc Format.
• Manipulating the character and numeric data by using SAS Functions.
• Summary statistics were performed on demographic data like age, gender and color.
• Developed routine SAS macros to create tables, graphs and listings for inclusion in Clinical study reports and regulatory submissions and to maintain existing ones.
• Generated reports as per the mockups provided by the client using proc means, proc tabulate, proc report and ODS.
• Generate Safety Tables as per Statistical Analysis Plan.

Environment: Windows, SAS 9, SAS/BASE, SAS/STAT, SAS/MACROS, SAS/ODS.

Confidential, India
Role: SAS Programmer/Analyst
Responsibilities:

• Modified/developed SAS codes for data cleaning and Reporting and to support routing processing.
• Developed efficient, well-documented, readily comprehensible and modifiable SAS code using SAS/ Base and SAS/ Macro facility.
• Identified problems with the data, if there were any, and also produced derived data sets, tables, listings and figures, which analyzed the data.
• Produced quality customized reports by using proc tabulate, proc report, and proc summary and also provided descriptive statistics using PROC Means, Frequency, and Univar ate.
• Report generation using many SAS procedural statements, SAS/MACROS, and data null steps.
• SAS was used for pre-processing data, SQL queries, data analysis, generating reports, and statistical analyses.
• Processed data collection to ensure proper quality of data. Maintained the daily error log for cleaning the data.
• Worked on edit check programs to maintain data consistency and data validation.
• Transformed the statistical data in various formats (excel, access) into SAS data sheets. Provided statistical programming expertise in the production of analysis, tabulations, reports and listings.
• Developed various SAS reports for Survey project and involved in code reviews for all the developed reports.
• Run daily report to help determined how many loans are in foreclosure or will be in foreclosure within the next ten days.

Environment: SAS/BASE, SAS/SQL, SAS/ACCESS, MS Excel, MS Power Point, Window NT/2000