Data Sas
Resume:
Rakesh Reddy
***********@*****.***
PROFESSIONAL SUMMARY:
7+ years of experience in SAS Clinical Programmer / SAS BI Application Developer as analysis, design, development, testing, and implementation of various applications like HealthCare, Consulting and Technology services, Banking, Finance and Pharmaceutical companies.
Extensive experience in Base SAS (Macros), SAS/STAT, SAS/GRAPH, SAS/ACCESS, SAS-ODS and SAS-SQL.
Solid knowledge in data management and processing techniques like merging, appending, concatenating, interleaving of SAS datasets and data validation.
Strong experience in various SAS procedures like Utility Procedures, Report Procedures, Statistical Procedures.
Good experience in using SAS functions like Date functions, Character functions and very good knowledge in using Formats and Informats with data and proc steps.
Good command in importing and exporting complex data sets using PROC IMPORT & EXPORT.
Experience on working with Enterprise guide.
Excellent skills in SAS Stored Processes Web Application, SAS Web Report Studio, SAS Information Map Studio, SAS Information Delivery Portal, SAS OLAP CUBE Studio, SAS BI Dashboard, SAS Management Console.
SAS Management Console used to create the metadata libraries and also for password administration.
Strong experience in SAS Enterprise guide in creating stored processes using the dynamic prompts containing both packaging or streaming output, and prepared reports using ODS.
Thorough experience in extracting data from data sources and sorting from various databases like Oracle, SQL Server, MS Access and DB2.
Excellent command in producing Reports employing various SAS Procedures, strong working experience in modifying existing SAS programs and creating new SAS programs using Macros.
Good ability to work either individually with minimal supervision or as a member of a large team and a quick learner with Strong analytical, debugging and problem solving skills.
Converting existing SSRS reports to SAS web reports by creating SAS Information Maps and using those maps for creating SAS web reports using SAS Web Report Studio.
TECHNICAL SKILLS:
SAS Software
SAS/BASE, SAS/MACRO, SAS/SQL, SAS/GRAPH.
SAS Procedures
Means, Summary, Freq, Sort, Print, Append, Import, Export, Format, Tabulate, Chart, Compare, Content, SQL, Transpose
Databases
SQL Server, MS Access, Oracle 9i/10g, DB2.
Operating Systems
Windows Family, Unix and Linux
Languages
SAS, ASP.Net, HTML, VBScript.
PROFESSIONAL EXPERIENCE
ORGANIZATION DESIGNATION DURATION
BLUE CROSS BLUE SHIELD
SAS Programmer
Mar2014-Till date
GUILFORD PHARMACEUTICALS
SAS Programmer Analyst
Aug2012-Feb2014
HSBC BANK
SAS Programmer Analyst
Jan2011-Jul2012
EXIMIAS PHARMACEUTICALS
SAS Analyst
Sep2009-Dec2010
ICICI BANK
SAS Programmer
Jun2008-Aug2009
CLIENT: Blue Cross Blue Shield, TX Mar 2014 to Current date
Role: SAS Programmer.
Blue Cross and Blue Shield insurance companies are licensees, independent of the association and traditionally of each other, offering insurance plans within defined regions under one or both of the association's brands. This project is to create monthly submission of Medicaid Advantage (Liberty) data to NYSDOH, using standard MEDS II specifications and logic for both institutional and professional category of service.
Responsibilities:
Worked closely with Business System Analyst in gathering requirements from end users and developed report layouts.
Understanding File Layouts required for State.
Understanding the relationships in tables for MEDICARE and MEDICAID Claims and involved in identifying DUAL Claims.
Extracted data from ORACLE database through SAS/ACCESS for ORACLE and extensively used PROC SQL to manipulate data and performed joins on datasets.
Extensively used the SET, UPDATE and MERGE statements on SAS datasets to read and manipulate claims data.
Used different SAS Functions like LENGTH, TRIM, PUT, INPUT, STRIP and COMPRESS.
Accessed External files and created permanent SAS data sets.
Extensively used SAS MACROS for code reusability and used different options like SYMBOLGEN, MPRINT, MLOGIC, SOURCE, SOURCE2, and SAS TRACE for debugging.
Used SAS Array temporarily for processing group of variables within a data step.
Analyzed data using PROC FREQ and PROC SUMMARY.
Used ODS features for outputting SAS data into XLS, TXT and PDF formats.
Fine tuning the code prior to moving into production and implementing the code in production.
Environment: UNIX, SAS 9.3, SAS/BASE, SAS/ACCESS, SAS/CONNECT, SAS Macros, SAS ODS, ORACLE, Lync2013, MS Office.
CLIENT: Guilford Pharmaceuticals Inc., Baltimore, MD Aug 2012-Feb 2014
Role: SAS Programmer Analyst – Clinical Trials
Guilford Pharmaceuticals Inc. is a fully integrated pharmaceutical company that discovers, develops and markets novel pharmaceutical products targeting the cancer and other disorders. As a SAS programmer my role was in analysis of clinical trial data and generating required reports, listings, summaries and graphs for submission to FDA and other regulatory authorities.
Responsibilities:
Performed statistical analysis, wrote SAS code for data management and reporting and performed validation, including testing SAS code.
Prepared clinical data listings and summaries for statistical analysis and analyzed clinical data using SAS system.
Developed reports using PROC REPORTS, PROC TABULATE and DATA_NULL_.
Developed efficient, well documented, readily comprehensible and modifiable SAS code using SAS/BASE and SAS/MACRO facility.
Used SAS for pre-processing data, SQL queries, data analysis, generating reports, graphs and statistical analyses.
Accessed various database to gather data, performed a table lookup and translated data values for meaning and readability.
Downloaded data from Oracle using SQL in to SAS to be analyzed and then exported to Excel for further analysis.
Involved in clinical trials programming of data tables and listings for reporting on safety & efficacy.
Produced customized reports by using PROC TABULATE, REPORT and also provided descriptive statistics using PROC Means, Frequency.
Environment: SAS9.1, SAS/BASE, SAS/SQL, SAS/MACROS, SAS/GRAPH, SAS/STAT, Oracle.
CLIENT: HSBC Bank, Mattawan, IL Jan 2011 – Jul 2012
Role: SAS programmer analyst
HSBC Bank USA offers its 3 million customers access to global markets and services. The Bank provides a full range of commercial banking products and services to individuals, corporations, institutions and governments, through its personal financial services, private banking, commercial banking and corporate investment banking and markets segments.
Responsibilities:
Created highly accurate predictive and descriptive models using Enterprise miner based on analysis of vast amounts of data.
Worked on ECONOMETRIC MODELS --(step-by-step approach used to derive the statistical models)
Applied many statistical techniques like Decision trees, artificial neural net works and logistic regression.
Used the SAS Enterprise Miner Interactive Grouping node to select the predictive variables using Information Value and calculating Weight of Evidence values
used the SAS Enterprise Miner Scorecard node to build a preliminary scorecard using the appropriate scaling methodology
Performed the reject inference techniques such as hard cut-off augmentation, parceling, and fuzzy augmentation using the SAS Enterprise Miner.
Copied SAS datasets using PROC COPY utilities.
Developed SAS programs with the use of Base SAS and SAS/Macros for ad hoc jobs.
Used SAS/Access and SAS SQL procedures to create and maintain SAS Data Sets that are extracted from DB2 and Sybase Databases.
Modified the existing programs according to the new business rules.
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.
Developed SAS programs to run the ad hoc jobs
Developed JCL code on mainframe (MVS) for processing batch jobs.
Used SAS technical skill to provide greater consistency in decision making by delivering standard data and analysis capabilities to more users in the organization
Developed Macros and performed statistical analysis working with large volume of data for supporting Market Operation Department in order for acquisition of Credit Card new customers
Uploaded and downloaded the datasets from and to UNIX platform to MVS system and PC also.
Documented the code for one whole module, which includes the process flow, dataflow diagrams and the Meta data dictionary.
Modified the code to reduce the processing time from 8 hrs to 3.5 hrs for a SAS job on the Mainframe.
Written and Modified the Shell scripts, to create tar files and ftp them to the desired location
Automated the manual process of extracting specific data from files on a Solaris box and backing the same on Mainframe.
Environment: Base SAS 9.2, SAS/Access, SAS/Connect, SAS/SQL, SAS/ODS, SAS/Macros, DB2,
Sybase, UNIX, IBM Main Frame.
CLIENT: Eximias Pharmaceuticals Inc, PA Sep 2009-Dec 2010
Role: SAS Analyst
Eximias Pharmaceutical Corporation is a privately-held pharmaceutical company that engages in the acquisition, development and commercialization of products for the treatment of cancer. Task involved working with Oncology group, involved in analysis of phase I and phase II clinical trial data, producing tables, listings and graphs, electronic Submissions and quality control for clinical data.
Responsibilities:
Provided SAS programming support for pre-processing data, data analysis, data manipulation and report generation for phase I and phase II clinical trials.
Involved in creating standard and value-added datasets as per statistical analysis plan and programming plan specifications to reflect company data standards.
Perform additional/ad-hoc SAS programming of data listings, summary tables and statistical analysis as required for clinical team review and data management staff.
Program standard SAS macros for validation of data listings and tables which can be used across different studies and protocols.
Modified SAS Macro programs to generate and validate reports, tables and listings for Bio statistical and team review.
Created ISS and ISE datasets.
Code with SAS/Base, SAS/Access, SAS/SQL and SAS/Macros to extract, clean and validate data from database.
Worked on Clinical Trials data like Demographic data, Adverse Events (AE), Serious Adverse Events (SAE), Laboratory data (Lab data), ECG, ECOG, Physical, Vital Signs and Audit trials.
Environment: SAS/BASE, SAS/GRAPH, SAS/STAT, SAS/MACROS, SAS/SQL, SAS/ODS, Oracle,
SAS/AF, SAS/ACCESS, MS Excel, Windows and UNIX
CLIENT: ICICI bank, Hyderabad, India Jun 2008-Aug 2009
Role: SAS Programmer /Oracle Developer
ICICI Bank is a leading bank in India. The team was responsible for acquisition modeling in the emerging markets of India.
Responsibilities:
Created SAS datasets from Oracle database with random sampling technique and created Oracle tables from SAS datasets by using SAS Macros.
Created large datasets by combining individual datasets using various inner and outer joins in SAS/SQL and dataset merging techniques of SAS/BASE.
Analyzed data using various statistical procedures like PROC SUMMARY, PROC MEANS, PROC FREQ, PROC UNIVARIATE, PROC REG and PROC ANOVA.
Extensively used SAS/Macro facility to create macros for statistical analysis, reporting results and data extraction.
Proposed a set of action plans to mitigate the risks identified with the sourcing decision.
Generated HTML, Listings, EXCEL and RTF reports for presenting the findings of various statistical procedures using procedures like PROC REPORT, PROC PRINT, PROC FREQ and also SAS ODS.
Environment: SAS 9.1 (BASE, STAT, GRAPH, MACRO, ETS and ODS), Oracle, PL/SQL.
Contact this candidate