Data Sas

Manu Yadawar

****.*****@*****.***

Ph- 510-***-****

Objective: Overall 4+ years of experience in SAS Programming with Financial, Banking, Healthcare, and Clinical industries. Expertise in analyzing and reporting various phases Of Trials using tools like Base SAS, SAS EG, SAS/STAT, SAS/GRAPH, SAS/SQL, SAS/MACRO, SAS/ACCESS and SAS/ODS in UNIX and Windows environment.

Skilled communicator & Strong experience in handling multiple projects simultaneously. A very good team player, quick thinker and rapid problem solver with commitment and strong work ethics.

Summary:

Over 4+ years of experience in SAS programming with good knowledge of advanced statistical methodologies applied in Financial, Banking, Healthcare, and Clinical industries.

Expertise in analyzing and reporting various phases Of Financial, Banking, and Healthcare using tools like Base SAS, SAS EG, SAS/STAT, SAS/GRAPH, SAS/SQL, SAS/SGPLOT, SAS/MACRO, SAS/ACCESS and SAS/ODS in UNIX and Windows environment.

Working knowledge of General linear models, Categorical data analysis, Survival analysis, Multivariate analysis, Design of experiments, longitudinal data analysis, randomized trial designs and survey design and analysis.

Expertise in SQL, creating/modifying Tables, Views, Stored Procedures, Functions, indexes, CTEs and Triggers and in-depth knowledge in query optimization & performance tuning.

Experience in providing statistical support for clinical studies, including the design of studies, selection of appropriate statistical methodologies and tests, sample size and power calculations, randomization, statistical analyses, and interpretation of results.

Thorough knowledge of CDISC STDM and ADAM Standardization.

Developed datasets for analysis in SAS, and Excel for hospital surveys.

Experience in debugging and testing SAS programs to check and process data, generate graphs, listings, and tables, sorting and merging of data validations in the analysis system.

Extensive experience in using DATA_NULL data step for producing customized reports.

Individually capable of developing new SAS Programs and/or enhancing existing SAS programs from protocols and SAP’s.

Performed data analysis for clinical trials and developed reports for publication.

Used SAS Enterprise Guide to access data, to manage data, to create reports and to validate data and data mining.

Experience in creating context diagram, sequence diagram, Entity Relationship Diagrams, Use case, and Activity diagrams.

Actively coordinated with the marketing department in conducting Business intelligence and market research activities for designing new marketing plans to fight competition, increase customer & dealer satisfaction and achieve greater sales growth.

Generation of data tables, patient data listing and reports using SAS; Preparation of statistical analysis plans; Contribute to statistical section of clinical trial protocols; review of the analysis of financial trial data.

Highly proficient with various project Management skills such as Planning, Budgeting, Project delivery, proposal process, resource loading (recruiting/staffing), resource leveling (sharing resources), team building, team consensus, developing project scope (budgets, timelines and delivery dates), Customer relationship building and satisfaction, and customer reviews. Understanding of client's IT and technical/business environment and propose products and services to client needs. Continuous process improvements, report generation, performance and trend analysis.

Excellent experience in Data manipulation and producing reports employing various SAS procedures like PROC SQL, PROC REPORT, PROC TABULATE, PROC FREQ, PROC MEANS, PROC UNIVARIATE, PROC SUMMARY, PROC FORMATE and PROC CONTENTS.

Hands on experience in SAS programming for importing and exporting huge data sets from Flat files, Excel spreadsheets and external RDBMS (ORACLE) tables using LIBNAME and SQL PASSTHRU facility.

Extensive experience with Cluster Analysis, Decision Tree Analysis, Linear Regression, Logistic Regression, and Monte Carlo Simulation in financial applications.

Excellent experience in storing and managing large data in SAS files, merging SAS data step, Do-Loops, Macros, SAS Formats, and SAS In formats.

Extensive use of SAS/ACCESS, SAS/CONNECT to connect to various databases such as development and production database (DB2 on UNIX).

Experience in reviewing case report forms CRF’s/SDTM/ADaM to ensure that the protocol objectives are met and the project standards are maintained.

Working knowledge of medical terminology in clinical trials, clinical trial methodologies, and software systems development.

Efficient in maintaining working relationships with clients and internal project members, including data managers, research scientists, and other statistical programmers.

Experience in developing and maintaining statistical documentation, including a description of statistical methods, SAS programs, results, and discussion.

Documented, summarized and recorded data as per standard operating procedures (SOPs) and FDA regulations.

Working knowledge of VB to create User-defined functions in excel.

Excellent Microsoft Excel skills including, advanced formulas, Vlookup, pivot tables, charts, graphs and custom reports.

Possess a strong ability to adapt and learn new technologies and new business lines rapidly.

Ability to work with a minimum of direct supervision and guidance.

Ability to install and configure packaged software components independently.

Accustomed to working in challenging environments under deadlines, excellent analytical, and problem-solving skills.

Effective team player with strong communication & interpersonal skills.

Technical Skills:

SAS Procedures/Tools

SAS/BASE, SAS/MACRO, SAS EG, SAS/GRAPH, SAS/ODS, SAS/STAT, SAS/ACCESS, SAS/CONNECT, SAS/SHARE, MEANS, REPORT, PRINT, UNIVARIATE, REG, CORR, FREQ, SUMMARY, IMPORT, EXPORT, SORT, SET, MERGE, TABULATE, FORMAT, TRANSPOSE, CONTENTS, ANOVA

Web Technologies

HTML, HTML 5, XHTML, XAML, CSS, CSS 3, XML, JavaScript

Languages

SAS 9.1.3, SAS 9.2, SAS 9.3, SQL, C, SQL, Python, VBA, R, Perl

Operating Systems

Windows Vista/ XP /2000/2007/2010, Linux, UNIX

Database and Tools

SAS, ETL, MS SQL, MS Access, MS-Office2007/2010/2013 (Excel- Vlookup, Pivot Tables, VB Macro)

Test Management Tools

HP Quality Center(ALM), Test Director

Web Service Testing Tools

SharePoint Query Web Service, SoapIU

Project Methodologies

Agile Methodology, FTP, Waterfall

Analyst Skills

Business Process analysis & design, Requirements gathering, analysis and design, Defect Tracking and Management, Document Analysis, Gap Analysis, Data analysis, Use test cases, Testing Plan & scenarios, UML, ERD Plus and Data Flow Diagrams (DFD)

Education:

Masters in Electrical Engineering with GPA 3.63/4, USA

Bachelor of Engineering in Electronic & Communication Engineering, INDIA

Professional Experience:

Prime Healthcare, Ontario, CA

SAS Analyst May 2016 – Present

Description: Prime Healthcare stands apart from others by its unique ability to save and transform hospitals. We have been named the “fastest growing hospital system” in the country by Modern Healthcare. And as we continue to grow and fulfill our mission of “saving hospitals, saving jobs and saving lives,” we remain committed to delivering exceptional care and creating a legacy that will improve healthcare.

Responsibilities:

Created and extracted Clinical data tables from SQL, Text, CSV, and Excel files to SAS using SAS tools like SAS/ACCESS, Infile, LIBNAME engine.

Created, analyzed and summarized safety and efficacy SDTM, ODM and ADaM dataset associated with clinical studies, as per the specifications in the SAP (statistical analysis plans) at study-level and project-level.

Created customized figures for clinical study reports as well as ad-hoc requests using SAS procedures Gplot and Gchart.

Used SAS and SAS tools on the Clinical trials data to perform sorting and merging to prepare and validate data.

Utilize statistical methods including linear and logistic regression, linear mixed model, survival analysis, power and sample size calculation, preprocessing and normalization of microarray and sequencing data, ROC analysis, resampling, simulation, visualization, and pathway analysis.

Do trend analysis and check interaction p-values based on separated and combined dataset, using results of regression analysis, and make the programs reusable using SAS MACRO.

Implemented waterfall method of Software Development Life Cycle (SDLC) methodology for design, development, and implementation and testing of various SAS modules.

Worked with financial data like analyzing the salary sheets, inpatient and outpatient billing.

Analyzed clinical trial data and generated tables, listings, and graphs using MACRO, GRAPH, and SQL.

Proficient in working with Base SAS, SAS EG and all the procedures which are in SAS.

Generated Summary Tables, Listings and Graphs to support clinical study reports by using Base SAS, SAS/STAT, SAS/MACRO SAS EG and SAS/GRAPH.

Implemented CDISC SDTM and ADaM standards as well as generating tables, figures, and listings to support the statistical analysis of clinical trials data.

Summarize results of complex data and statistical analysis, and present reports to laboratory to support decisions on future operations and manufactory orientation.

Used SAS ODS to generate reports for FDA submission and presentation.

Built Macros and create macro variables using %Macro and %Mend, and DATA _NULL_ to help generate analysis data sets and create specified structure.

Environment: BASE SAS 9.2, SAS EG 7.1, SAS/Connect, SAS/STAT, SAS/Graph, SAS Macros,

SAS SQL, SAS ODS, UNIX SAS, VB, MS Excel, MS Access, UNIX, and Windows.

Verifacts Services Pvt Ltd, Hyderabad, INDIA July 2011 – Nov 2014

Client: Bank of Maharashtra Nov 2013 to Nov 2014

Job Title: SAS Modeler/Programmer

Description: Maharashtra Bank With the goodwill and trust of our 180 million customers and well-wishers the Bank has crossed the milestone of Rs.200,000 million in total business achieving a business level of Rs.207,171 million as on 31.03.2014.The Bank now has a Pan India presence with a branch network of 1890 branches spread across all States & Union territories.

Responsibilities:

Understand and update the existing code or create new code by using BASE/SAS, SAS/MACROS, and SAS/SQL to implement new requirements.

Expertise in statistical modeling and analysis on study data by utilizing appropriate statistical methods.

Extracted data from Oracle using SQL Pass-through facility and generated reports.

Develop SAS code to validate data of different portfolios.

Modified existing SAS programs and created new programs using SAS macro variables to improve ease and speed of modification as well as the consistency of results.

Generate Reports in user required format by using ODS and PROC REPORT.

SAS data sets are validated using SAS procedures like PROC MEANS, PROC FREQUENCY, and PROC UNIVARIATE.

Performed data integrity checks and data cleaning using SAS MACROS and data steps, created HTML outputs with a table of contents using ODS HTML.

Used SAS PROC SQL Pass-through Facility to work with Teradata database.

Analyzed and implemented the code and table changes to improve performance and enhance data quality.

Created and revised the common macros.

Reading data from different sources like .csv, excel, tab delimited files.

Perform various business checks on the source data to confirm whether data is correct or not.

Compare the source data with historical data to get some statistical analysis.

Perform transformations like Merge, Sort and Update to get the data in the required format.

Create the understandable EXCEL template to start dad mapping for each line of business.

Extensively utilized SAS/BASE, SAS/SQL, and SAS/MACRO.

Extensively used procedures such as PROC APPEND PROC IMPORT, PROC MEANS, PROC SUMMARY, PROC CONTENTS and PROC SQL.

Involved in project review meetings with respective Business SME's.

Environment: SAS/Base, SAS/STAT, SAS/GRAPH, SAS/MACROS, SAS/ACCESS, SAS/CONNECT, SAS/ODS, SAS/SQL, MS-Office, UNIX/ Windows.

Client: Apollo Hospitals July 2011 – Oct 2013

Job Title: Clinical SAS Programmer

Description: Apollo Hospitals is widely recognized as the pioneer of private healthcare in India, and was the country’s first corporate hospital. The Apollo Hospitals Group, which started as a 150-bed hospital and today, operates 9215 beds across 64 hospitals. A forerunner in integrated healthcare, Apollo has a robust presence across the healthcare spectrum. The Group has emerged as the foremost integrated healthcare provider in Asia, with mature group companies that specialize in insurance, pharmacy, consultancy, clinics and many such key touch points of the ecosystem. The Apollo Group has touched the lives of over 45 million patients, from 121 countries.

Responsibilities:

Designed reports for key health care modules like administration IP billing OP billing and pharmacy as per the requirements of the higher authorities

Created reports for finding out the load balance of the patients for particular time intervals for analysis of business

Converted MS SQL server data tables into SAS data files using SAS SQL and uploaded SAS data files into MS SQL Server tables using PROC DBLOAD

Imported the data into SAS from Excel Spreadsheet, and various delimited files using Proc Import to generate reports as per the directions of the higher management

Generated reports using PROC TABULATE, PROC REPORT, DATA NULL, SAS ARRAYS, PROC SQL, AND SAS MACROS.

Created case report forms CRF’s/SDTM/ADaM to ensure that the protocol objectives are met and the project standards are maintained.

Extracted data from MS SQL Server using SQL pass-through facility and generated ad-hoc reports. Tested and debugged SAS programs against the test data

Processed the data in SAS for the given requirement using SAS programming concepts

Imported and Exported data files to and from SAS using PROC IMPORT AND PROC EXPORT from Excel and various delimited text based data files such as .txt (tab delimited) and .csv (comma delimited) files into SAS datasets for analysis

Used statistical analysis procedures in the generation of reports periodically for analyzing the business using SAS STAT procedures such as Regression Univariate, Correlation, and ANOVA

Utilized procedures such as PROC ACCESS, PROC SQL AND PROC DBLOAD in SAS/ACCESS to retrieve the data into SAS from MS SQL server database

Environment: SAS/Base, SAS/STAT, SAS/GRAPH, SAS ODS.SAS/MACROS, SAS/ACCESS, MS-Office.

Contact this candidate