Senior Certified SAS Programmer/Analyst :: Available for your Corp-Corp Positions
Kalyan Charan/ Vibha, Inc.
Please Respond to h...@vibhainc.com
Please contact Kalyan Charan @ 916 265 0734 or Shrini @ 916 978 1057 Ext: 309 for rate information.
Consultant Name: Srilakshmi Gogula
Skill Set: SAS Programmer
Status: Own H1
Current Location: Cleveland, OH
Preferred Location: Open
Availability: Immediate
Professional Summary
§ Certified SAS Programmer with about SEVEN years of professional experience in working with SAS/BASE and SAS tools in Clinical and Financial industries.
§ Over 3 years of expertise in UNIX environment and Shell scripting.
§ Worked with Statisticians, Data managers and Clinicians to provide SAS Programming in analyzing Clinical data and also involved in all phases of Clinical trials.
§ Strong experience in SAS/BASE, SAS/GRAPH, SAS/STAT, SAS/ODS, SAS/MACROS, SAS/SQL, SAS/ACCESS, SAS/CONNECT, SAS/Assist, SAS/ETL in Windows and UNIX environments.
§ Experience in using SAS to Read, Import and Export to another data file formats that includes Delimited files and Spreadsheet files.
§ Extensive experience in SAS/REPORT generating procedures like PROC SUMMARY, PROC FREQ, PROC MEANS, PROC UNIVARIATE, PROC TRANSPOSE, PROC FORMAT, PROC REPORT and PROC TABULATE etc.
§ Extensive experience in using the Set, Update and Merge statements for Creating, Updating and Merging various SAS datasets. Also having excellent programming skills in SQL for joining the data using PROC SQL.
§ Experience in SAS/ETL (Extraction, Transformation and Loading) with Oracle/Access connectivity.
§ Experience in importing data from Excel spreadsheets and external RDBMS (Oracle DB2 and SQL Server) tables using LIBNAME and SQL PASSTHRU facility.
§ Experience in using SAS/ STAT procedures like PROC CORR, PROC REG, PROC GLM and PROC ANOVA.
§ Experience in altering existing SAS programs using Macros in order to improve ease, speed and as well as consistency of results.
§ Expert in using SAS ODS to create HTML, RTF and PDF output files and Data _Null_ to generate ad-hoc and customized reports.
§ Expert in creating Reports in style format using the ODS statements and PROC TEMPLATE.
§ Good experience using SAS/GRAPH procedures, exclusively PROC GPLOT.
§ Generated Reports, Tables, Listings, Graphs and Summaries as per company standards and in compliance with 21 CFR Part 11, FDA, NDA and other regulatory compliance.
§ Prepared SOPs of SAS Programming standards, SAS Validation, CDISC SDTM standards.
§ Knowledge of CRF-Annotation with respect to various database designs in clinical trials for pharmaceutical industries.
§ Good knowledge in extracting data from various databases like Oracle, DB2, SQL Server and MS-Access using SQL and PL/SQL.
§ Skilled at using basic and advanced RDBMS concepts, SQL, PL/SQL.
§ Have a strong platform in working with UNIX shell scripts using Putty Environment.
§ Familiarity in Data Mining and Statistical Modeling techniques for CRM.
§ Good knowledge in Statistical Analysis (Linear Regression, Logistic Regression, Multiple Regression, Neural Networks, ANOVA) and Predictive modeling.
§ Excellent communication skills, analyzing skills, team spirit and the ability to deal with changing circumstances.
Technical Skills
SAS tools SAS V8, V9.1, SAS/BASE, SAS/MACROS, SAS/SQL, SAS/ACCESS, SAS/GRAPH, SAS/STAT, SAS/REPORTS, SAS/ODS
SAS Procedures Means, Freq, Summary, Report, Tabulate, Transpose, UNIVARIATE, CORR, REG,
GLM, ANOVA, Sort, Import, Export, CIMPORT, CPORT, Format, GPLOT, Template,
SQL, Print, Contents, Compare
Statistical tools SPSS, S-plus, R, Insightful Miner, Spot fire.
Languages C, C++, C#, SQL, PL/SQL, PERL
Operating Systems UNIX (Sun Solaris 8.0, Red Hat Linux), WINDOWS 98/2000/XP/NT
Web technologies HTML, DHTML, XML, Dream weaver, Adobe Photoshop
Databases Oracle 8i/9i/10g, DB2, SQL Server, MS Access
Office tools MS-Office (Word, Excel, Power point, Visio)
Professional Experience
Sr. SAS Programmer/Analyst
Client - Well Care Health Plans, Inc., FL Aug’08 – Till Date
Well Care Health Plans, Inc. provides managed care services exclusively for government-sponsored healthcare programs, focusing on Medicaid and Medicare. As a part of the team, I extensively conducted data analysis and programming support to identify the healthcare plans overpayments. I often used to review SAS code to determine accuracy and completeness according to the specifications.
Responsibilities:
§ Responsible for Data collection, Management, and manipulation of healthcare plans database.
§ Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS tools such as SAS/BASE, SAS/MACRO, SAS/STAT, SAS/GRAPH, SAS/CONNECT and SAS/ACCESS.
§ Using SAS/CONNECT, raw data was acquired from Oracle and DB2 tables and loaded it into SAS datasets.
§ Transferred the data from one platform to another by using PROC SQL, PROC import, PROC export statements (i.e. from ORACLE to SAS, SAS to ORACLE, ORACLE to EXCEL, SAS to Statistical) to be used for further analysis.
§ Written/Executed Edit check programs according the specifications for the purpose of Database verification.
§ Created quality customized reports and provided descriptive statistics using PROC MEANS, PROC FREQ, and PROC UNIVARIATE.
§ Used Macro routines to convert different types of source file (Excel, Word, and Text) to produce SAS reports and graphs.
§ Created SAS customized reports using the DATA_NULL_ technique for evaluations.
§ Developed and scheduled SAS jobs using UNIX/Shell scripts. The processed data is downloaded to the local PC which is a Windows XP operating system.
§ The procedures such as Proc Tabulate, Summary, Report etc., are used to generate these reports and stored as Datasets, MS-EXCEL, MS-ACCESS Databases, HTML and Delimited text files depending upon the requirement.
§ Created reports in the style format using ODS statements and PROC TEMPLATE. The generated reports are reviewed by the statisticians for further processing.
§ Performed Quality assurance, Validation/Verification in compliance with regulations and policies by creating constraints on the transported data and reports.
§ Reviewed and streamlined outdated SAS code to eliminate errors and improve functionality.
§ Experience in the preparation of SAS datasets, Tables, Listings, Graphs, Reports and Summaries according to the requirements such as Standard Operating Procedures (SOPs), Statistical Analysis Plan (SAP).
§ Effective in expressing concepts in individual and informal group situations and presenting ideas in an organized and concise manner.
Environment: SAS V9.1, SAS/BASE, SAS/MACRO, SAS/GRAPH, SAS/ODS, SAS/STAT, SAS/SQL, SAS/CONNECT, SAS/ACCESS, Oracle 9i, DB2, UNIX, Windows XP.
SAS Programmer/Analyst
Client - John Hancock Financial Services Inc, MA Sep’07 – Aug’08
John Hancock is a leading insurance and financial service company that provides life insurance and a broad range of mutual funds to meet the needs of today and tomorrow. The survey results of the customers were analyzed and graphed and this information was used by the marketing department to address the needs for better customer satisfaction.
Responsibilities:
§ Involved in Extraction of data and developed reports on the financial information of the customers to the desired level of the detail.
§ Performed ETL-Extract/Transform/Load, Data analysis, Data migration and preparation, Statistical Analysis, Graphical representation, Validation.
§ Extracted raw data from an Oracle database and used SAS/ACCESS to read it and ran statistical analysis using SAS/STAT.
§ Performed statistical categorical data analysis on marketing information and extensively used various statistical procedures such as Proc FREQ, Proc MEANS, Proc REG, and Proc UNIVARIATE for analysis.
§ Used Proc Import to convert .CSV files into SAS data files.
§ Created and tested programs for the Import and Export of SAS datasets.
§ Performed data analysis, generated reports, listing and graphs using SAS tools- SAS/BASE, SAS/GRAPH, and SAS/SQL.
§ Developed and executed SAS SQL queries for merging, concatenating and updating large volumes of data.
§ Developed SAS Macros for data cleaning and analysis. Extract/ ETL from the database and created SAS Reports.
§ Used SAS/ODS for generating the HTML, Listings, RTF reports for presenting the findings of various statistical procedures.
§ Worked closely with data modeling and management team like Marketing managers, Campaign managers, financial managers etc., to analyze customer related data.
§ Involved in enhancement of SAS programs and successfully generated permanent and temporary SAS data sets for the analysis.
§ Worked with more than hundred million rows of data sets.
§ Created flow charts to exhibit the flow of data from source datasets to the final reports using VISIO.
§ Prepared extensive set of validation test cases to verify the data.
§ Created the Reports from the analysis as per the Client’s requirement.
§ Executed the SAS jobs in batch mode through UNIX shell scripts.
Environment: SAS V9.1, SAS/BASE, SAS/ACCESS-Teradata, SAS/STAT, SAS/MACROS, SAS/SQL, SAS/GRAPH, SAS/ODS, Oracle 9i, UNIX Solaris, UNIX Shell Scripting, Windows 2000/XP, MS Access, MS Excel, MS Visio.
SAS Programmer/Analyst
Vertex Pharmaceuticals Inc, MA Jun’06 –Sep’07
Vertex Pharmaceuticals main aim is to transform the way serious diseases are treated. Vertex’s drug discovery platform has been highly productive and is the source of key product opportunities in infectious diseases, cystic fibrosis, inflammatory disease, cancer and other areas.
Responsibilities:
§ Worked closely with the research team of scientists to analyze the data, generate the reports, and list them according to specifications.
§ Involved in analyzing, writing clinical trial reports and presenting clinical trial results.
§ Generated the required SAS datasets from the database using sorting and merging techniques.
§ Performed Data conversions, Data corrections, Uploading/Downloading the data.
§ Developed and summarized clinical trials data using SAS/STAT procedures such as PROC CORR,
PROC REG, PROC ANOVA, PROC GLM and Data step programming.
§ Extensively used SAS procedures such as PRINT, REPORT, TABULATE, FREQ, MEANS, SUMMARY and TRANSPOSE for producing ad-hoc, customized reports and external files.
§ Created Custom reports using DATA_NULL_ and PUT statements.
§ Designed flowcharts indicating the input data sets and the techniques that would be used (sorting, merging, etc) to get the desired output.
§ Used SAS Macro functions to simplify the process and get consistent results.
§ Using SAS/Macros, reports were updated on a monthly basis according to the schedule.
§ Used SAS/ODS to create HTML, RTF and PDF outputs files in the process for producing reports.
§ Developed the programs for generating Efficacy (ISE) and Safety (ISS) tables.
§ Based on the specification document created CDISC-SDTM SAS datasets following all the standards.
§ Involved in creating transport files as per the CDISC standards for electronic submissions to the FDA.
§ Worked with validation team to validate the applications in compliance with 21 CFR Part 11 and other FDA mandatory regulations.
§ Reviewed study Protocol, Annotated Case Report Form (ACRF), and performed validation of clinical trial data to identify illogical data entries.
§ Involved in data transmission and integrity checking of the existing and in-house clinical trial systems.
Environment: SAS V8.2, SAS/BASE, SAS/STAT, SAS/ODS, Oracle 8i, SQL, MS-Excel, Windows 2000, UNIX (Solaris)
SAS Programmer
Client - American Century Investments, MO Jul’05 –Jun’06
American Century Investments is a privately held investment management firm. Their major criterion is to serve investment professionals, institutions, corporations and individual investors. More than 40 percent of American Century Investments' profits support research to help find cures for the genetically-based diseases including cancer, diabetes and dementia. I was involved in performing complex analysis on the data.
Responsibilities:
§ Used PROC SQL Pass-through facility and Oracle DB Load procedure for data transfer.
§ Created SAS views from the tables in Oracle database using SAS/ACCESS.
§ Involved in the data transfer and data conversion from one platform to the other (SAS to Oracle, Oracle to Excel) and the obtained data was used for further analysis.
§ Extensively used statistical procedures like UNIVARIATE, SUMMARY, TABULATE, MEANS.
§ Modified existing SAS programs using SAS/MACROS to improve the performance and enhance the data quality and developed numerous decision support reports in a distributive environment for the management department.
§ Manipulated data by using MERGE, APPEND, CONCAT, SORT PROCs and generated the reports.
§ Generated graphs using PROC GPLOT through SAS/GRAPH and the SAS Graphic Editor.
§ Developed efficient, well-documented, comprehensible and modifiable SAS code for ad-hoc jobs using SAS/BASE and SAS/Macro facility.
§ Validated data by checking data distribution and by comparing it to a standard data.
§ Ran SAS report programs to generate weekly/monthly/annual reports and exported the results to Excel for further analysis.
Environment: SAS V8, SAS/BASE, SAS/MACROS, SAS/SQL, SAS/GRAPH, SAS/ACCESS, SQL, PL/SQL, Windows 2000.
SAS Programmer/Analyst
Client - Fifth third Bank, OH Aug’04 – Jun’05
The project involved data validation and extraction of the Bank customers. Statistical models were developed to find which customers were likely to apply for a loan, which customers can repay the loan on time and which customers were likely to default. Tasks involved data cleaning, data transformation, report generation and inputs for marketing and financial decisions.
Responsibilities:
§ Responsible for data validation and corrections – uploading/downloading data.
§ Good working experience in importing various External Data Files into SAS Datasets and SAS Library by Using SAS/ACCESS, SAS/SQL.
§ Programming of data listings using SAS tools. Programming of data validation tools using PL/SQL
§ Writing analysis plans including specifications for table listings. Taking raw data and creating datasets.
§ Processed data using DO loops and SAS Arrays.
§ Creates permanent formatted SAS data sets and developed reports using PROC REPORT, PROC TABULATE and DATA_NULL_ for analysis.
§ Create reports in Excel spreadsheets using SAS/ODS and implementing them in Power point presentations.
§ Wrote Edit check programs and listing of data.
§ Ran weekly and monthly reports using SAS.
§ Created electronic data sets (i.e. SAS transport files) for electronic submission.
§ Good knowledge in debugging and testing against the test data.
§ Responsible for locating appropriate databases for the projects.
Environment: SAS V8, SAS/BASE, SAS/ACCESS, SAS/SQL, SAS/GRAPH, SAS/ODS, Oracle 8i, PL/SQL, Windows 2000, MS- Excel and MS- Access.
SAS Programmer/Data Analyst
Client - Dr. Reddy’s Laboratories Ltd, India Dec’03 – Aug’04
Dr. Reddy’s laboratory is an emerging global pharmaceutical company. It conducts new chemical entities (NCE) research in the areas of metabolic disorders, cardiovascular indications, anti-infective and inflammations. As a part of the clinical trial, the project involved randomized trials on Type 2 Diabetes. Our team was responsible for developing various SAS procedures, applications, programs for the data. I worked as SAS programmer in the clinical trial data in the generation of various reports.
Responsibilities:
§ Experience in utilizing SAS Procedures and other SAS applications for data updates, data cleansing and reporting
§ Identify and correct data step syntax and programming logic errors.
§ Efficient in using data step programming to solve complex programs.
§ Experienced in Import and Export of clinical data across a variety of applications to and from SAS.
§ Experienced in validation of programs and processes to extract data from Clinical data management systems, to prepare data listings, summary tables and reports using SAS.
§ Provided data verification and problem resolution as and when required.
§ Proficient in SAS/BASE, SAS/ODS, SAS/SQL and experience in producing external files and reports employing various SAS procedures like PROC PRINT, PROC REPORT, PROC SUMMARY.
Environment: SAS V8, SAS/BASE, SAS/SQL, SAS/ODS, Windows 98, Excel/Access 2000.
Database Developer
Client - Extranet Software Solutions, India Jul’03 – Dec’03
Responsibilities:
§ Interacted with end users for gathering requirements.
§ Performed database tuning, monitoring, loading and back up.
§ Created prototype reporting models, specifications, diagrams and charts to provide direction to system.
§ Developed procedure and functions using PL/SQL and developed critical reports.
§ Developed Date entry, Query and Report request screens.
§ Created record groups for manipulation of data. Performed unit and system integrated testing.
§ Co-Ordination with users and SQL tuning on existing reports.
§ Identified class diagrams, object diagrams, class and operational specifications using object oriented analysis and methodology within the problem domain.
§ Development of various classes and member functions containing attributes of entities.
§ Development of data entry screens using Oracle forms.
§ Creating various reports using C, C++ library functions and stored procedures.
Environment: HTML, UNIX, C, C++ Libraries, Oracle 8i, PL/SQL, Oracle Forms, Reports, and Windows NT.
Kalyan Charan