SAS\Azure Data Enginner

1/2022 – 7/2022

• Having 14+ years of rich experience in SAS BI Tools, SAS Programming and SAS Administration in diverse domains such as Banking and financial sector.
• Strong technical skills in using Advanced SAS Programming Techniques Base SAS, SAS DI Studio, SASEG, SAS DQ, SAS Visual Analytics7.3
• ETL Developer in SAS and Data Warehousing lifecycle involving requirements gathering, development, analysis, and testing using industry accepted methodologies and procedures using SAS BI tools.
• Extensively worked as a Production Support Analyst in resolving job failures and in Ticket resolutions raised by Business users.
• Extensive experience in extraction, transformation and loading of data directly from different heterogeneous source systems like flat files, Excel, Oracle, SQL Server.
• Basic Knowledge on UNIX, File Transfer Protocol’s like ftp, sftp & shell scripting.
• Implemented best practice solutions in ETL process development includes performance tuning.
• Involved in Populating and Deploying, Scheduling the ETL jobs using SAS DI Studio.
Expertise in Developing ETL jobs using SAS Data Integration Studio and like SCD type2, table loader, splitter, join, file reader, loop, lookup etc.

SAS Business Intelligence (BI), SAS (Software)

10/2018 – 12/2021

• Having 14+ years of rich experience in SAS BI Tools, SAS Programming and SAS Administration in diverse domains such as Banking and financial sector.
• Strong technical skills in using Advanced SAS Programming Techniques Base SAS, SAS DI Studio, SASEG, SAS DQ, SAS Visual Analytics7.3
• ETL Developer in SAS and Data Warehousing lifecycle involving requirements gathering, development, analysis, and testing using industry accepted methodologies and procedures using SAS BI tools.
• Extensively worked as a Production Support Analyst in resolving job failures and in Ticket resolutions raised by Business users.
• Extensive experience in extraction, transformation and loading of data directly from different heterogeneous source systems like flat files, Excel, Oracle, SQL Server.
• Basic Knowledge on UNIX, File Transfer Protocol’s like ftp, sftp & shell scripting.
• Implemented best practice solutions in ETL process development includes performance tuning.
• Involved in Populating and Deploying, Scheduling the ETL jobs using SAS DI Studio.
• Expertise in Developing ETL jobs using SAS Data Integration Studio and like SCD type2, table loader, splitter, join, file reader, loop, lookup etc.

SAS Business Intelligence (BI), SAS (Software)

5/2008 – 9/2018

SAS Program Skills:

• Strong skills with SAS Base, SAS Macros and SAS DI Studio jobs
• Design, develop and automate ETL jobs/ flows using SAS DI.
• Migrated SAS deployed jobs from one environment to multiple environments.
• Created UNIX Scripting in AIX or Linux based systems.
• Executed Performance Tuning techniques on existing SAS DI jobs
• Conducted Do Analysis and subsequent resolution of Trouble Tickets.
• Do Coding / Fixing of Code running in production by adhering to the Application Maintenance Service Delivery Life Cycle
• Hands on experience in Visual Analytics
• Providing level 1,2 and 3 production support with knowledge on Incident Management, Problem Management, and Change Request Management

SAS Admin Skills:
• Understand and Administer Viya servers and services.
• In-depth knowledge of SAS Foundation 9.3/9.4, SAS Metadata BI Server 9.3/9.4, SAS Grid 9.4, Platform LSF Suite (patches / maintenance releases / usage tracking, RTM monitoring, alerts notification, applying hot fixes, licenses, and so on)
• Managing metadata using SAS SMC including all admin work on SMC like user creation, group creation, server creation, library creation, set-up security for different group of users, scheduled / ad-hoc processes.
• Starting and stopping SAS Services in Unix environment
• Monitoring storage utilization on mounted volumes and managing Unix permissions on directories and files.

SAS Business Intelligence (BI), SAS (Software)