Data Sas
Resume:
Madhav Nan
**********@*****.***
Summary:
* ***** ** ************ ********** of SAS programming experience in Statistical analysis, Validation and Statistical report generation of Healthcare and Clinical trial data.
Extensive experience in the application of SAS tools such as SAS/BASE, SAS/STAT, SAS/GRAPH, SAS/MACROS, SAS/SQL, and SAS/ODS.
Extensive experience in creating external files and customized reports using SAS procedures such as Proc Report, Proc Tabulate, Proc Means, Proc Freq, Proc Univariate, Data _Null_, Proc Summary.
Experience in validating Tables, listings and CRTs manually and using Proc Compare as well as with departmental standard macros.
Experienced in oncology treatment studies and able to handle complex environment.
Solid knowledge of CRT dataset creation, CDISC and MedDRA for regulatory submissions.
Extensive knowledge of both CDISC SDTM and ADaM models.
Facilitate discussions on forecast modeling to capture questions that Client has expressed an interest in applying advanced analytics.
Solid knowledge in clinical trial data like Demographic data, Adverse Events data, Vital Signs data, Laboratory data etc.
Proficiency in writing maintainable, supportable, and well-documented SAS codes.
Experienced in Data management, data extraction, manipulation, validation, purification and analyzing large sized data.
Experience in generating RTF, HTML and PDF formatted files using SAS/ODS.
Experience in developing SAS Macros, applications for data cleaning and reporting and involved in preparing documentation.
Worked on statistical parametric analysis methods such as Correlation, Regression, Analysis of variance and general linear models using SAS STAT procedures such as PROC ANOVA, PROC GLM, PROC CORR, PROC REG.
Maintained and enhanced existing SAS reporting programs for marketing campaigns.
Good understanding of study related Statistical Analysis Plan (SAP) and produced Tables, Listings and Graphs based on the specifications in Table Shell.
Enthusiastic, result-oriented, team player as well as able to work well independently with strong communication, analytical, logical and programming skills.
Experience in complete Software Development Life Cycle (SDLC) of the project such as modeling, process flows, development, unit testing and documentation.
Highly motivated, Organized Team player with excellent analytical, communication and leadership skills.
Technical Skills:
SAS Tools: SAS V9.1.3, SAS/BASE, SAS/STAT, SAS/MACRO, SAS/GRAPH, SAS/ODS, SAS/ETL, MATLAB
Databases: Oracle, DB2, MySQL, MS-Access. Rapid SQL
Operating Systems: Windows 9x/NT/XP/Vista, UNIX, Shell Scripting, MVS
Education: Bachelor’s in Biotechnology from JNTU University, India
Professional Experience:
Wells Fargo, San Francisco, CA Jan ’14 - Present
SAS Lead Programmer/ Data Analyst
Wells Fargo and Co. is one of the nation’s largest and strongest financial holding companies. Through its banking subsidiaries, the company provides deposit, credit, trust, and investment services to a broad range of retail, business, and institutional clients. Other subsidiaries provide mortgage, banking, brokerage, investment management, equipment leasing, and capital market services.
Responsibilities:
Developed complex SAS macros to simplify SAS code and effectively reduce coding time
Interacted with Risk Managers and Analysts to define targeted customer segments
Extract, transform and load datasets with basic modeling variables for each segment type Using PROC IMPORT and SQL queries, imported data from Oracle database into SAS files
Manipulated and updated the tables as per specifications
Performed data cleaning by analyzing and eliminating duplicate and inaccurate data using PROC FREQ, PROC COMP, PROC UNIVARIATE, and macros in SAS
Formulated action plans and presented key information regarding profit dynamics to the senior management in the Bank
Maintained consistency of SAS variables formats and sorted various datasets using PROC SORT and merged them using MERGE
Maintain and enhance existing SAS reporting programs for marketing campaigns.
Produce SAS Graphical reports showing Trend Analysis charts for campaign
Worked on CONVERSION of SAS code originally in ORACLE to TERADATA compatible SAS code.
Generated the List outputs for Marketing Teams that have the list of customers to target as part of Campaigning.
Prepared ad-hoc reports, documenting SAS work, and directing SAS outputs to RTF and HTML files through SAS ODS facility
Used PROC/SQL and SQL –pass-through mechanisms
Assisting in the analysis, design, and development of tables, Excel files and ad-hoc reports.
Understood basic business analysis concepts for logical data modeling, data flow processing and data base design.
Interface with users, business analysts and other department heads to gather information and requirements. Developed databases and specifying specific data requirements.
Involved in writing the TDR’s and FDR’s for any new change or enhancement
Environment: SAS 9.0, SAS/Base, SAS/Macro, SAS/SQL, SAS/OLAP, SAS/STAT, Web Reports Studio, MS-Excel and Windows XP/7, SASGRD1, and Unix Sun Solaris.
Blue Cross Blue Shield, Dallas, TX Aug ’11 – Dec ‘13
SAS Lead Programmer
Blue Shield provides perfect local solutions that improve access to affordable, quality healthcare, and deliver insurance coverage for wide range of people in USA. My work involved in generating reports for client needs.
Responsibilities:
Developed SAS programs with the use of Base SAS and SAS/Macros for ad hoc jobs.
Modified the existing programs according to the new business rules.
Work cross functionally with all departments of the service center to solve purchase order, invoice and inventory discrepancies (supply chain Management).
Apply Forecasting and Analytical Methodologies, and contribute to its ongoing continuous improvement.
Participate in application design and architecture discussions and assess the impact and applicability of forecasting to client's business problem solutions.
Complete all levels of application testing and Q&A, and prepare all required documentation;
Extensively used SAS procedures like Print, Sort, SQL, Means, Summary, Freq etc.
Ran the monthly and quarterly maintenance jobs on the mainframe.
Documented the run instructions for two different processes in a project.
Participated in designing, coding, testing, debugging and documenting SAS Programs
Statistical analysis included coding the data sets, calculating simple percentage distributions, graphs, comparison of rates by Agency’s t-test and chi-square test, multiple tables and reports developed using SAS/STAT
Created RTF, PDF, HTML, LISTING, etc using Output Delivery System (ODS)
Extensively used various SAS Data Step functions, SAS procedures, and SQL to write reports logics for SAS Stored Processes
Converting existing Cognos reports to SAS web reports by creating SAS Information Maps and using those maps for creating SAS web reports using SAS Web Report Studio.
Created SAS Customized Reports using the Data _Null_ technique for FDA evaluations.
Developed routine SAS macros to create tables, graphs and listings for inclusion in Clinical study reports and regulatory submissions and maintained existing ones.
Produced quality customized reports by using PROC TABULATE, REPORT, and SUMMARY and also provided descriptive statistics using PROC Means, Frequency, and Univariate.
Created survival graphs in MS-Excel by transporting SAS data sets into Excel spreadsheets.
Formatted HTML and RTF reports, using SAS - output delivery system ODS.
Used the SAS Macro facility to produce weekly and monthly reports.
Validated programs and databases.
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.
Used various ODS outputs depending on the client requirements and provided with a fine framework for FDA submission
Environment:
Base SAS, SAS MACRO, SAS/SQL, SAS/STAT, SAS/GRAPH, and Windows 2000
Pneumrx, Mountain view, CA Feb ’09 – Jul ‘11
Lead statistical Programmer
Pneumrx, Inc. is a Medical device company, which develops and manufactures pulmonary related devices; my project was involved in supporting programming (production/validation) activities for clinical trials. My major project involved in creating and validating SDTM datasets and TLG’s as well.
Responsibilities:
●Generated and validated SDTM and ADAM datasets using respective specifications.
●Used Proc Means, Proc Freq, Proc Sort, Proc Univariate, Proc Import, Proc Export, Proc Transpose procedures for data processing and analysis
●Created SAS MACROS for Demographics, Vital Signs, etc. from scratch
●Performed Data analysis, statistical analysis, generated reports, listings and graphs using SAS/BASE, SAS/MACRO and SAS/GRAPH, and SAS/ODS
●Developed SAS MACROS for data cleaning and reporting
●Generating Tables, Listings summaries and Graphs for clinical study reports and generating statistical programs and tools in accordance with SAP and validation procedures
●In consultation with statisticians, writing programs to perform statistical analysis for regulatory submission
●Responsible for the accuracy and validation of programs, and for ensuring regulatory requirements pertaining to analysis and programming are satisfied
●Remaining current in state-of-the-art statistical programming methods useful in the execution of analysis of clinical trial data
●Worked on Some oncology studies of external pharmaceutical companies
●Developing data management reports for clinical trials under the direction of statisticians and clinical trial leaders to determine the efficiency in data reporting of the centers. These reports are used internally and externally and created using SAS 9.2 by writing the output to Windows and Excel using SAS/ODS and Data _NULL_
Environment: SAS/BASE 9.2, SAS/MACROS, Windows 7, SAS/Reports, SAS/Stat, SAS/SQL, SAS/ODS
Aai Pharma Eaton Town, NJ Apr ’07 - Feb ‘09
Statistical Programmer
AAI is a full service CRO that specializes in complicated trials. AAI used SAS to meet internal reporting needs and regulatory requirements on time and within budget. The project involved developing customized data displays and writing independent validation programs to verify derived data sets and data displays.
Responsibilities:
Modified existing SAS programs and created new programs using SAS to improve ease and speed of modification as well as consistency of results.
Experienced in building tables, Listings and Figures based on Business requirements, while adhering to defined development standards.
Worked on several drugs including cancer studies like oncology studies
Involved in importing and exporting of clinical data across a variety of applications to and from SAS.
Created data transformation and data loading (ETL) scripts for data warehouse.
Integrate data from wide range of sources including in-house clinical data management systems, labs and contract research organizations and perform data cleaning with data steps and procedure steps.
Performed Data Analysis on the data sets using PROC ANOVA, PROC MEANS, PROC UNIVARIATE, PROC FREQ, PROC COMPARE, PROC DATASETS and PROC ANOVA.
Developed reports using PROC REPORT, PROC TABULATE and DATA_NULL.
Used ODS statements and PROC TEMPLATE to create reports in style format.
Environment:
SAS v8, SAS/BASE, SAS/MACROS, SAS/SQL, SAS/GRAPH, SAS/ODS, MS SQL Server 2000, MS Excel, Windows 2003
Ranbaxy Pharmaceuticals, INDIA Jan ‘06 – Apr ‘07
SAS Programmer
Ranbaxy Pharmaceuticals is a major Pharmaceutical and bulk drug industry based in Bombay, is leader in manufacturing drugs. The project include in performing relevant statistical analysis of administrative and automated claim databases, surveys and economic data captured during clinical trials.
Responsibilities:
Worked in Phase I & II of clinical trials for studies in the Cardio-Vascular therapeutic area.
Integrate Data from wide range of sources including in-house clinical data management systems, labs and contract research organizations and perform data cleaning with data steps using DLM, DSM, and COMMA9. TRUNCOVER, MISSOVER etc.
Performed data validation on the data sets and deleted repeated values using conditional data steps such as @@, if-then statements.
Designed statistical tables, graphs, and data listings.
Created Data transformation and Data Loading (ETL) scripts for Data Warehouse.
Developed SAS macros for data cleaning and reporting and to support routing processing.
Performed Data Analysis on the data sets using PROC ANNOVA, PROC MEAN, PROC UNIVARIATE, PROC FREQ and PROC TRANSPOSE.
Developed reports using PROC REPORT, PROC TABULATE and DATA _NULL_.
Generated output files in text format, HTML & PDF format using SAS ODS.
Environment:
SAS BASE, SAS/STAT, SAS/SQL, SAS Macro, and UNIX
Contact this candidate