Sas Data
Resume:
Kala Rachamalla
US Citizenship
****.******@*****.***
Professional Summary:
SAS Developer with over 5 years of programming/analysis experience in SAS on Windows and UNIX environment.
Strong SAS Programming experience in Health care, Retail and Pharmaceutical industries.
Strong SAS programming background for creating, maintaining existing code,
ad hoc reporting and supporting the reporting functions.
Expertise in using various SAS report generating procedures such as: PROC REPORT, PROC FORMAT, PROC GPLOT, PROC GCHART, PROC COMPARE, PROC EXPORT, PROC SQL, PROC FREQ, PROC MEANS, PROC TABULATE, PROC TRANSPOSE, PROC COPY, PROC SUMMARY, PROC IMPORT.
Generated reports using PROC REPORT, DATA _NULL_ and PROC TABULATE for customized report writing.
Excluded and Included the MS Access tables data.
Created new MS Access tables and imported the MS Access tables data using proc import.
Included multiple MS Access tables data and imported the data.
Generated daily, weekly and monthly reports using PROC REPORT and SQL.
Knowledge in requirement gathering, analysis, planning and designing.
Experience in SAS to extract data from a variety of operational data sources on multiple platforms.
Experience in using SAS to read, write, import and export to another data file formats, including delimited files, Microsoft Excel, PDF and MS Access tables.
Additional experience includes using Graph, Macros, Data Step, Proc SQL extracting internal/external data including cleaning and validation, use of formats and in formats.
Experience in producing HTML, RTF, CSV and PDF formatted files using SAS/ODS.
Experience in SAS/BASE, SAS/SQL, SAS/MACROS, SAS/GRAPH, SAS/ACCESS, Base SAS,SAS/ENTERPRISE GUIDE,SAS Data Integration tools.
Experience in developing complex SAS programs, macros for data updates, data cleansing, and reporting.
Good understanding in designing and implementing statistical reporting processes for regular data collection and clinical data analysis in Phase I, II and III Clinical Trials.
Trained in Good Clinical Practice (GCP), Regulatory Compliance, FDA Guidelines, Data interpretation, supporting statistical methodologies and review SAP.
Dedicated to maintaining a reputation built on quality, service and uncompromising ethics.
Highly motivated individual with excellent organizational and interpersonal skills.
Possess strong ability to quickly adapt to new applications and platforms.
Certifications:
BASE SAS Certification.
TECHNICAL SKILLS:
SAS Skills: SAS/BASE, SAS/MACRO, SAS/SQL, SAS/ACCESS, SAS/ODS, SAS/STAT, SAS/GRAPH
Database: Oracle, MS SQL Server, MS-Access, MS-Excel, SQL
Operating: Windows (XP/2000), UNIX
Office Tools: MS Office, MS Excel, MS-Access.
Professional Experience:
Blue Cross Blue Shield of NC, Durham, NC Jun 2019 to Dec 2019
Business Solutions Developer
Responsibilities:
Working in Provider Data Management (PDM) team as a Business solutions Developer.
Creates technical solutions to address moderately complex business capability needs by utilizing SAS.
Experience in full software development life cycle (SDLC) as requirement gathering to development.
Will communicate and coordinate with the impacted business areas.
Review and analyze business requirements (or use cases) to create a technical solution residing outside of the normal Information Services production environment. Truly a reporting and Systems update role, run batch process in SAS.
Utilize technical solutions for the creation of business enabling tools, error handling management and productivity improvements while adhering to technical specifications
Independently test and debug code; participate in the testing of other Business Solutions Developers’ projects as needed.
Document and track project plan for work deliverables.
Using SAS tool for Data manipulations.
Worked with large provider and practitioner data sets.
Generated various adhoc reports using large data.
Worked pulling in various network systems like NPM, Power MHS and Facets.
Experience in working with several providers, practitioners and claims data.
Daily responsibilities generating the various adhoc reports and query updates as per the business rules using webtool PRIMO.
Experienced in Importing and Exporting data using SAS technologies Proc Import and Proc Export procedures for the external and internal data files like Excel and Access.
Experienced in Data manipulations using SAS technologies. Worked in modifying of the query logic so that the query will be able to pull the data according the new networks and date of 01/01/2020.
Experienced in including the New Core Networks as part of the query update.
Experienced in using the Proc Import, Proc Export, Proc SQL, Proc transpose, Proc Formats, Proc Reports and SAS data step programming.
Experienced in using the SAS Data step concepts like Merge, SET. And variously used Pros SQL for joining multiple SAS datasets.
Included and Excluded multiple MS Access tables data and imported the data using proc import.
Created new MS Access tables and imported and included the tables data using proc import.
Experienced in SAS Base Macro programming as part of the query updates and including the new core networks.
Working Experience with MS Office suite like MS Word, MS Power Pint, MS Outlook, MS Access, MS Excel.
Experience in BASE SAS,SAS Data Integration Tool, SAS Enterprise Guide.
Good Knowledge in Python.
Environment: SAS/BASE 9.1.3, SAS/MACRO, SAS/Enterprise Guide, SAS/ODS, UNIX, SQL Navigator 4, PRIMO web tool, MS Office products.
Infosys, Raleigh, NC Aug 2018 to Jun 2019
Senior Systems Analyst
Responsibilities:
Utilize SAS base, SAS SQL and SAS Macros etc. to evaluate statistical data.
Experience in Software Development Life Cycle(SDLC) from requirement gathering, programming, testing and moving the data into production.
Manage data to prepare graphs, tabulations and statistical charts.
osysDesign summary reports with help of various SAS procedures.
Environment: SAS/BASE 9.1.2, SAS/MACRO, SAS/STAT, SAS/ACCESS, SAS/CONNECT, SAS/ODS, SAS/SQL, SAS/Base, UNIX.
DataPhiles Programming LLC., Durham, NC May 2016 to Feb 2017
Associate SAS Programmer
Responsibilities:
Produced and validated reports of various kinds like Listings, Tables, and Figures (TLF).
Worked with senior Bio-statisticians and Team Leads and Senior programmers in Analysis Data sets, Listings, Tables and SDTM Data sets validation.
I have experience in studies like Oncology, Women Health.
Experience with CDISC SDTM Datasets creation for small studies and validation of multiple studies.
Experience in SDLC(Software Development Life Cycle) process from requirement gathering,programming and testing.
Worked with MS Excel and MS Access tables data and imported and exported the data.
Validated tables and listings according to the specification documentation.
Worked with Clinical Trials data such as Demographic data (DM), Adverse Events (AE), Laboratory data (Labs), and Vital Signs (VS),Concomitant Medication (CM),Questionnaires(QS), Medical History (MH), Physical Examination(PE),Tumor Units(TU), Tumor Elements(TE), Trial Arms(TA) and Trial Elements(TE).
And I have generated the SDTM Data sets for Phase I studies and validated the SDTM Datasets for phase III studies.
SAS programming for the analysis and validations of Phase II-IV Clinical trials.
SAS programming techniques in SAS 9.1
Environment: SAS/BASE 9.1.2, SAS/MACRO, SAS/STAT, SAS/ACCESS, SAS/CONNECT, SAS/ODS, SAS/SQL, SAS/Base, UNIX.
Clinical Data Oriented Apr 2014 to Dec 2014
Training(Intern)
Qtech Solutions
Responsibilities:
Produced low-medium complexity derived data sets, tables, figures and data listings using BASE SAS procedures and standardized macros.
SAS Procedures Proc Report and Proc Tabulate for generating listings.
Executed import and export programs, in either standard format according to the specification document.
Performed data checks and write and compare QC programs to verify the output generated for data displays; follow all SOP's and guidelines; interact with Clinical Data Management (CDM) to resolve data issues .
extracting internal / external data, data cleaning and Identifying edit check validation.
Environment: SAS/BASE 9.1.2, SAS/MACRO, SAS/STAT, SAS/ACCESS, SAS/CONNECT, SAS/ODS, SAS/SQL, SAS/Base, UNIX.
Quintiles, RTP, NC. Apr 2011 to Oct 2011
Role: Clinical Data Programmer
Description: Quintiles is the only fully integrated bio and pharmaceutical services provider offering clinical, commercial, consulting and capital solutions . I have worked in Data Management group. I have worked with large data to data EDC data extractions and import, export the data. And experienced in production and QC data extractions. And working with setup the database portal links to different Studies and give access to the users. Working with Inform Servers for data extractions. After data extractions converting the Oracle data into Raw data sets using SAS Procedures.
Responsibility:
Working with Large health and Pharmaceutical related data.
Extracting Oracle data from sFTP server on daily basis and importing the raw data into SAS Server to converting into SAS data sets.
Experience in CDISC SDTM Datasets validation for multiple studies and used Pinnacle21.
Experience in validating the Oncology study data sets like Tumor Units (TU) and Tumor Elements(TE) For phase I study.
Working with production and quality data extractions.
EDC data production and QC extractions.
And transferring the data to internal and external clients.
Working with EDC Inform Servers.
And working with preparing Monthly Extract Schedule Calendar.
Experience in creating new MS Access database and assign the primary key and imported the tables data using the proc import.
Run and validated the edit checking SAS programs in Batch mode in SAS Data Integration tool.
QC checks of validation edit check programs under the specification’s documents.
Submitting requests to Oracle Phase Forward for TDE data for EDC production extracts, CDD data for QC Extracts and clean core dump files for generating QC database links and setup the link for data validations and SAS listings.
Experience with data validation log file checking.
Checking for Errors and Warnings and Uninitialized variables in Edit checking SAS programs.
Executing and running SAS programs according to the specification documents.
QC database installations and giving access to the users.
Experience in BASE SAS 9, SAS Data Integration Tool, SAS Enterprise Guide.
Environment: SAS/BASE 9.1.2, SAS/MACRO, SAS/STAT, SAS/ACCESS, SAS/CONNECT, SAS/ODS, SAS/SQL, SAS/Base, UNIX.
Parata Systems, Durham, NC. Aug 2009 to Dec 2010
Role: SAS Programmer
Description: Parata leads the pharmacy automation industry with technology solutions that help pharmacies improve safety and convenience for customers at key touch points in the circle of pharmacy care: Fill, Serve and Adhere.
Responsibility:
Manual testing of validation programs.
Running SAS programs according to the specification document.
Executing the Log files according to the specification documents.
Working with SQL Queries for data validations.
Monitech, Raleigh, NC. Aug 2008 to Jan 2009
Role: Crystal Reports Developer
Description: Monitech Field Applications servers as the central access and repository for electronic forms needed to maintain control of the Monitech interlock system.
Responsibilities:
Generating reports using sales data using .Net Technology.
Working with SQL for validating data in the database.
Manual Testing VB. Net Application.
Experience in using Quality center to manual testing.
Education:
Master’s Degree in Computer Applications (M.C.A), Bharathiar University, India.
Bachelor’s Degree (B. Sc.) in Mathematics, Physical Science and Chemistry at SK University, India.
Oracle Clinical training from January 2012 to August 2012.
Base SAS Certification.
Clinical Data Oriented Training (CDISC, SDTM) in 2015.
Contact this candidate