Yeshwanth N

Sr Sas Programmer @Aetna, A Cvs Health Company

Chicago, IL, US

Involved in all phases of SDLC including Requirement Gathering, Design, Analysis and Testing of customer specifications, Development, and Deployment of the Application. • Primary responsibilities included creating and validating datasets, tables, listings, and graphs for Phase I and Phase II. • Followed CDISC guidelines to create ADaM specifications, DDT, datasets which help to create TLF’s. • Used SAS for advanced analytics and business intelligence. • Data Extraction, aggregations, and consolidation of Data within AWS Glue using PySpark. • Developed a Python script to transfer Data from on-premises and to hit REST API\'s and extract data to AWS S3. • Developed Python scripts to update content in the database and manipulate files. • Developed jobs to load data from AWS s3/Snowflake to servers and excel to Snowflake/s3. • Developed Python code to load semi-structured to Snowflake, from JSON, XML etc. • Knowledge of SAS Viya architecture and migration to Viya. • Experience in planning, programming, and generation of analysis datasets (per ADaM IG) • Create study specific macros and perform change control on existing macros whenever required. • Working closely with clients and statisticians to respond to Ad hoc requirements.

Anurag Group of Institutions

Bachelor of Pharmacy - BPharm, Pharmacy

University of North Texas

Master's Degree, Information Science with concentration in Health Informatics