Piyush Srivastava

About Piyush Srivastava

Certified Base SAS Programmer and SAS PlatForm Administrator with 8+years of Experience.Excellent Knowledge of Base SAS,SAS Macros, SAS Procedures, SAS SQL and SAS ODS/ACCESS/SHARE and SAS Tools:(SAS Management Console, SAS DI Studio, SAS BI IMAP Studio, Web Portal/Web Report Studio, SAS Enterprise Guide, SAS EMiner, SAS Viya, SAS Visual Analytics).Expertise in using Microsoft Excel to create pivot tables, used advanced Excel functions ( HLOOKUP, VLOOKUP etc.) and worked on creating macros VBA programs to automatically update Excel workbooks.Strong understanding of Data Warehousing concepts and had worked in SAS environment and automated the reports efficiently and provided key insights and patterns to the clients for forecasting & help them in driving the business analysis. Learning new technology or process is not a barrier for me, I am open to any challenge and have an ability to work in any critical situations.

Experience

1. Business Intelligence System Analyst

   GM Financial

   Aug 2018 — Present · Arlington, TX, US

   Extensively working on Migration of SAS 9.4 on Linux OS to SAS 9.4 GRID Environment.• Designed and deployed Unix Shell scripts and scheduled jobs using Crontab and AutoSys. • Maintaining SAS Windows and Linux servers & SAS services and resolving the issues.• Automated the process for archiving the logs, history data and other irrelevant files to make availability of disk space in the environment for the Business Users.• Experience in automating the SAS jobs thorough SAS EG, Management Console for the Business Users for high efficiency.• Extensively worked on SAS 9.3 and 9.4 Suite on a SAS GRID Environment and troubleshoot the issues.• Assist SAS users with troubleshooting and performance tuning their models/code.• SAS Metadata and ETL developer with extensive knowledge of building & implementing metadata repository & metadata security• Proficient in design and development of SQL queries and crystal reports.• Resolving Requests and Incidents on the Service Now and developed a dashboard for the reporting purpose. • Specialized in designing, implementing, and maintaining security using SAS Metadata and ACL\'s.• Created scripts for restarting the server and midtier, which checks the availability of the online SAS Portal and sends in an email to the SAS Admin group if the SAS Portal is not responding.• Developed and automated the process for checking the user’s orphaned process running on the SAS Environment and kill them and utilize the disk usage.• Extensive experience in installing, configuring and testing SAS/Access Interface to Oracle, MS-SQL Server & Teradata on SAS Enterprise Platform.• Maintaining Security and Create/manage users, Groups, Licenses and integrate with Active Directory.

Education

• ICSE Board

  High School, Computer Science

  2004 — 2005

• RED ROSE SCHOOL

  12th; 10+2, Computer Science

  2005 — 2007

• SRM UNIVERSITY

  Bachelor’s Degree, Computer Science and Engineering

  2008 — 2012

• Stevens Institute of Technology

  Master’s Degree, Management Information Systems, General

  2017 — 2018