Sathwika Chimmula
Walnut Creek,USA
Summary
With around 5 years of experience as a SAS Data Analyst with extensive experience supporting clinical trials and managing ETL processes, I bring expertise in SAS programming, including macros, SQL, data step programming, and SAS statistical analysis processes. I have a proven track record of adhering to project guidelines and programming standards to ensure the timely delivery of high-quality deliverables. My strong analytical and problem-solving skills enable me to effectively execute projects using sophisticated SAS and macro programming techniques.
Overview
6
6
years of professional experience
Work History
Statistical Programmer/ Analyst
Paradigm
Walnut Creek, CA
01.2023 - Current
- Company Overview: https://artugentherapeutics.com/about/
- Provide programming support to the study team, ensuring adherence to study requirements and timelines
- Built Macros to produce customized tables utilizing DATA STEP and various procedures including PROC REPORT, PROC FREQ, PROC TABULATE, PROC MEANS, PROC SUMMARY, and PROC FORMAT
- Develops data tables, patient data listings, and reports in accordance with the statistical analysis plan
- Create SAS programs for extracting, transforming, and analyzing clinical datasets
- Maintained programming documentation, including study trackers, code, logs, and outputs, in compliance with regulatory standards
- Presents statistical results with the help of pie diagrams and bar graphs using SAS/Stat
- Extensively used SAS/Macros, Proc SQL, Proc Transpose, Arrays and Microsoft Excel and created SAS programs for extracting, transforming, and analyzing clinical datasets
- Extract data from various databases DB2, Oracle into SAS using SQL pass-through facility for creating various reports required based on the requirements
- Proficient in utilizing MS Office Suite, particularly skilled in Word, Excel, and Outlook, for efficient documentation, data analysis, and communication purposes
- Ensure that statistical deliverable (tables, figures, listings) and study datasets (SDTMs, ADaMs) are validated and meet the standards requirements of regulatory agencies and Sponsors
- Integrate Power BI with SAS environments to streamline data flows and reporting processes, ensuring efficient data visualization and analysis
- Strong communication and interpersonal skills, capable of collaborating effectively with stakeholders across all organizational levels
- Estimate project timeline accurately and communicate effectively with the study team and management
- Https://artugentherapeutics.com/about/
- Environment: SAS 9.2, SAS/Macros, SAS/Base, SAS/SQL, SAS/Stat, SAS/Connect, SAS/Graph, SAS Enterprise Guide, Power BI, Windows, Oracle, MS Office and DB2
Statistical Programmer
Eliassen Group
02.2021 - 01.2022
- Participated in open-label, double-blind, parallel design clinical studies
- Reviewed and assessed Statistical Analysis Plans (SAPs), TFL shells, and study protocols for clarity and adherence to standards
- Implemented standardized procedures for migrating to the Standard Data Tabulation Model (SDTM), ensuring the production of high-quality SAS datasets
- Employed tools like Open CDISC Validator and Pinnacle 21 to detect and resolve compliance issues in SDTM and ADaM datasets
- Drafted SDTM specifications for key domains such as DM, AE, MH, CM, DS, EG, and VS
- Developed ADaM specifications for ADCM, ADCE, ADDV, ADMH, and ADVS, following mock shells and the ADaM Implementation Guide 1.1
- Generated and validated ADaM datasets, adhering to specifications and deriving data from SDTM datasets based on the SAP and mock shells
- Compiled various tables and listings in line with SAP guidelines and mock shell templates
- Created comprehensive reports in RTF and PDF formats using SAS ODS and PROC REPORT
- Conducted data analysis utilizing SAS procedures including PROC MEANS, PROC TRANSPOSE, PROC FREQ, and PROC SUMMARY
- Ensured thorough documentation and summarization of data in compliance with standard operating procedures (SOPs) and FDA regulations
- Environment: SAS 9.3, SAS/Base, SAS/Connect, SAS/ODS, SAS/Stat, SAS/SQL, SAS/Graph, SAS/Access, Oracle
SAS Data Analyst
Accenture
Hyderabad, India
01.2019 - 11.2020
- Extracted, transformed and loaded ETL datasets with basic modeling variables for each segment type using Proc Import and SQL queries, imported data from Oracle database into SAS files
- Extracted data from the Oracle database using SAS/Base, SAS/Access, and wrote SQL queries using Proc SQL procedures and created SAS datasets
- Involved in data manipulations and stored the updated data into corresponding data marts in Oracle warehouse
- Acquired raw data from Oracle tables and loaded the data into SAS datasets for further analysis and reporting and 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
- Generated complete and efficient analysis data models following approved dataset designs or specifications
- Documented SAS programs, processes, and methodologies to ensure reproducibility and knowledge sharing within the team
- Contributed to the development and improvement of data management strategies and processes, optimizing data quality and accessibility
- Prepared ad-hoc reports, documenting SAS work, and directing SAS outputs to RTF and HTML files through SAS ODS facility
- Indicatively developed, enhanced, evaluated, and validated standardized macros, optimizing programming efficiency and minimizing efforts across multiple studies
- Documented data and programming information in accordance with corporate SOPs
- Provided technical support and expertise to users of SAS applications, troubleshooting issues, and delivering timely resolutions
- Developed programming efficiencies to ensure a productive work environment producing deliverables of high quality
- Environment: SAS 9.3, SAS/Base, SAS/Connect, SAS/ODS, SAS/Stat, SAS/SQL, SAS/Graph, SAS/Access, Oracle
Education
Master’s - computer science
Wright State University
04.2023
Skills
- Append
- Means
- Freq
- Sort
- Summary
- Format
- Transpose
- Compare
- SQL
- Tabulate
- Import
- Export
- Plot
- SAS 94
- BASE SAS
- ADVANCE SAS
- SAS/MACROS
- SAS/STAT
- SAS/GRAPH
- SAS/ACCESS
- SAS/REPORT
- SAS/SQL
- SAS/CONNECT
- SDTMs
- ADAM
- Clinical trials
- DefineXML
- Base SAS
- Adv SAS
- HTML
- XML
- JSON
- Basics of R
- Basics of Python
- Medidata Rave
- Oracle
- MS Access
- SQL Server
- Windows
- UNIX
- Power BI
- Microsoft Office (Excel)
- Microsoft Office (Word)
- Microsoft Office (Outlook)
- Microsoft Office (PowerPoint)
Skillsandtools
Append, Print, Means, Freq, Sort, Summary, Format, Transpose, Compare, SQL, Tabulate, Import, Export, Plot, SAS 9.4, BASE SAS, ADVANCE SAS, SAS/MACROS, SAS/STAT, SAS/GRAPH, SAS/ACCESS, SAS/REPORT, SAS/SQL, SAS/CONNECT, SDTMs, ADAM, Clinical trials, Define.XML, Base SAS, Adv SAS, SQL, HTML, XML, JSON, Basics of R & Python, Medidata Rave, Oracle, MS Access, SQL Server, Windows, UNIX, Power BI, Microsoft Office (Excel, Word, Outlook, PowerPoint)
Timeline
Statistical Programmer/ Analyst
Paradigm
01.2023 - Current
Statistical Programmer
Eliassen Group
02.2021 - 01.2022
SAS Data Analyst
Accenture
01.2019 - 11.2020
Master’s - computer science
Wright State University
Similar Profiles
Fanis EllisFanis Ellis
Case Manager at ParadigmCase Manager at Paradigm
Jessica MazzerJessica Mazzer
3D Artistry Manager at Paradigm3D Artistry Manager at Paradigm
James IglesiasJames Iglesias
Delivery Driver at ParadigmDelivery Driver at Paradigm
Jazzlasha BlueJazzlasha Blue
System Executive at ParadigmSystem Executive at Paradigm
THOMAS KILCOURSETHOMAS KILCOURSE
Mortgage Loan Officer Assistant at PNC Bank N.A.Mortgage Loan Officer Assistant at PNC Bank N.A.