Project: SAS Analytical Platform
Client : US based Lifescience Customer
Role : SAS Platform Administrator
- SAS Analytical platform is Grid architecture setup in Linux environment. This platform consists of a clustered metadata server, high availability horizontal/vertical clustered Web tier servers and 13 LSF Grid nodes. It is one of the most complex environments which consist of 3k plus users and around 20k jobs are being run on the platform on a daily basis for clinical data analysis with Medidata RAVE.
- Languages/Tools Used: SAS 9.4 M3 Administration, SAS Grid architecture, Platform LSF v9.0
Project: DataScience Platform
Client: Amgen
Role: Platform Admin
- DataSciene.com platform is high availability, clustered environment hosted in AWS cloud which support all major analytics tools and software. This is one of the critical platform which consist of 1K+ users and 500+ EC2 session a day.
Languages/Tools Used: Python, R, AWS, Docker, SQL, Latex, Octave, Hadoop, Teradata, Git
Project: SAS Data Store
Client: Amgen
Role : SAS Application Support
Timeline: May2017-Sep 2017
- Amgen sales team has come up with a requirement to track a unit of medicine sold in market, revenue generated and customer details in all country region wise and to maintain historical SAS dataset for business decision making.
- Languages/Tools Used: SAS BASE, SAS Macro, PROC SQL
- Data source: txt file, ODS, XLSX file, Teradata, Redshift
Client: Amgen
Project: SCA
Role: SAS Application Support
Timeline: Mar 2018-Aug 2018
- Making a daily SAS report on clinical research associate, coordinators, subjects, investigators and other team members who are involved in a clinical study in various clinical research organizations across the globe which includes historical reports and current report. Also comparing previous day and previous week report for any updating, deletion and new entries.
- Languages/Tools Used: SAS BASE, SAS Macro, PROC SQL, Python
- Data source: ODS
Project: Learning management code Migration
Client: Amgen
Role: SAS Programmer
Timeline : November-2019 to Dec 2019
- Business compliance team has been maintaining its employee data on their internal training and certification activity track of their 3lakh + employees since 40 years which includes both historical and current data in oracle database which need to be fetched from redshift database going forward due to ODS decommission.
- Languages/Tools Used: SAS EG, SAS BASE, MACROS, PROC SQL, UNIX shell scripting
- Data source: Redshift, Oracle