Chandan Kumar

About Chandan Kumar

Total 12 years of experience in SAS, as SAS9 and SAS Viya developer. SAS 9.4 to SAS Viya Migration Worked on SAS 9.2, SAS 9.3, SAS 9.4 & SAS Viya 3 & SAS Viya 4. SAS Global Certified Base and Advance Programmer for SAS9. Expert in Base SAS & Advanced SAS programming and used advanced level programming using Macros, SAS auto call Macro library, Macro quoting functions, SAS Access, SAS SQL, SAS Access, Indexes, SQL pass through facility, merging techniques using data step, Hash tables, parallel processing, Bulk load to DB to load large data, etc. Expert in development of ETL Jobs Using SAS DI, Base SAS, Advanced SAS, SAS EG, DB2, SAS SMC & LSF. Expert in development of SAS BI reports using SAS EBI reporting tools like SAS InfoMap, SAS WRS, SAS BI Dashboard, SAS IDP, SAS VA, Base SAS, SAS Stored Process (STP) and SAS EG. Expert in SAS Marketing Automation (Campaign Management) using SAS IMap, SAS CI, SAS SMC, SAS STP. Experience to handle large data, performance tuning, code & job optimization, complex jobs. Worked on SAS System Migration project from SAS9.3 to SAS9.4. Working experience on SAS Viya. Worked on SAS Migration project from SAS 9.4 to SAS Viya. Development Experience on SAS Viya, Programming on SAS Viya, CAS Library, SAS Drive, SAS Studio, SAS Data Explorer, SAS Data Studio, SAS EM, SAS Job Execution, etc. Experience to Manage SAS Platform (SAS Admin) and perform task like creating user, group, role, monitor sas servers, re-start SAS services, create connection to different DB, etc. in SAS 9.4 as well in SAS Viya. Enable log trace and analyze log of different SAS Viya services like CAS Controller and Workers, compsrv, launcher, compute, SAS Studio, etc. Manage users Authentication and Authorization of end users. Experience in SAS Program performance benchmarking and debugging the Batch Server Logs, Stored Process Log, MA Core Log, etc. Used UNIX command, ssh, scp script and x/sysexec command to run OS Command in SAS. used SFTP, FTP and MFT to transfer the file among servers. Knowledge of CI/CD approach with tools like Git and Jenkins, used in SAS Studio, SAS EG and SAS DI Hands-on experience of Data Visualization tools like SAS VA. Hands on knowledge of Snowflake DW, like Virtual Warehouse, Compute server, cache, Virtual storage, cloud storage, DB, Stage, File Format, Pipe, Snowsql, Process, Load and unload of Structure & Semi-structure data.

Experience

1. Assistant Consultant

   Tata Consultancy Services

   Nov 2021 — Present · Noida, IN

   Technical Lead A&I, Senior SAS Developer, SAS Viya 4 Developer

Education

• Savitribai Phule Pune University

  Master of Computer Applications - MCA

  2010 — 2013

• Sam Higginbottom Institute of Agriculture, Technology & Sciences, Allahabad

  Master of Business Administration - MBA, Information Technology

  2015 — 2017

• Sikkim Manipal University - Distance Education

  BCA, Computer applications

  2007 — 2010

Skills

• Sas Di
• Sas Va
• Db2
• Sas Advance
• Sas
• Microsoft Sql Server
• Etl
• Sas Base
• Unix
• Data Warehousing
• Data Analysis
• Sql
• Sas Ci
• Sas Bi
• Business Intelligence
• Data Mining
• Databases