We provide IT Staff Augmentation Services!

Sas Developer Resume

4.00/5 (Submit Your Rating)

Houston, TX

SUMMARY:

  • Experienced ETL & data analytics professional with 9 years of experience in the field of Data warehouse, data analytics, data profiling, data migration and data visualization.
  • ETL / Data Analytics Expertise: Experienced in SAS Base, SAS Macros, Proc SQL, SAS Enterprise Business Intelligence (SAS EG; SAS DI Studio), SAS Visual Analytics (VA), SAS Dataflux Data Management Studio, SAS Platform Manager & SAS Management Console Tools.
  • Reporting Expertise: Deployed complex dashboards and visualizations using different Reporting Tools - Tableau; Qlikview; Power BI & SAS VA
  • SAS Admin Expertise: Experienced in SAS Administration for house-keeping, fine-tuning applications, strong experience in SAS Platform Administration in SAS installation, configuration, migration (9.1.3, 9.2, 9.3 & 9.4), users and group’s administration (grant/revoke privileges), Metadata management in Linux and Windows environments in HealthCare, Banking and Marketing.
  • Database / DWH Expertise: Experience working with databases Oracle, SQL Server, Netezza & HIVE
  • Industrial Expertise: Hands on experience in Pharma, Banking, Finance, Insurance, Oil & Gas industries.
  • Extensively used SAS Client & Web Applications - OLAP Cube Studio, Information Map Studio, Web Report Studio, BI Dashboard, and Information Delivery Portal.
  • Proficient in working on Windows & UNIX (Shell Scripting) platforms.

TECHNICAL SKILLS:

SAS Skills: BASE SAS, Advanced SAS (SAS MACROS)

SAS EBI: SAS Data Integration (DI) Studio, SAS Visual Analytics, SAS Flow Manager, SAS Dataflux Data Management Studio, SAS Visual Analytics, SAS Enterprise Guide, SAS Management Console, SAS Information Map Studio, SAS OLAP Cube Studio, SAS Information Delivery Portal, SAS Web Report Studio, SAS Dash Boards, SAS Add In for MS Office

Database: SQL, Oracle, Netezza, and HIVE.

OS: UNIX, Windows.

Reporting: SAS Visual Analytics, Power BI, Tableau, Qlikview

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

SAS Developer

Responsibilities:

  • Designing the DWH model, creating Dims and Facts for multiple segments using SAS & Hive
  • Building the models to calculate the Assets per job, Tools per job, Excess and Shortages etc.
  • Creating the process for Daily refresh in multiple environments
  • Designing and scripting the Shell scripts for Daily refresh process
  • Experience in designing reports using SAS VA & Power BI
  • Involved in Migrations, Schedules & Supporting the daily production runs

Environment: SAS Base, SAS Macros, SAS Enterprise Guide, SAS Visual Analytics, Hadoop, Hive, UNIX Shell, SQL Server, UNIX, Power BI.

Confidential, Charlotte, NC

SAS DI Developer

Responsibilities:

  • Experienced in Developing SAS programs to automate repetitive task to improve accuracy
  • Utilized SAS to create reports on large product testing data, analyze patterns & detect failures
  • Experience in designing reports using Qlikview & Tableau.
  • Worked with business users to approve requirements, get approvals / sign-offs
  • Migrating and promoting the Jobs/Metadata from Dev to Test & Test to Production Environments.
  • Providing Support for UAT & Production Teams.
  • Worked on CR and new enhancement requests & Defects Fixing.

Environment: SAS Base, SAS Macros, SAS Data Integration Studio, SAS Data flux, SAS Enterprise Guide, SAS Management Console, SAS Flow Manager, Tableau, SQL, UNIX, Netezza, Qlikview, Tableau.

Confidential

SAS ETL / DI Developer

Responsibilities:

  • Designed & developed Extract, Transform, and Load (ETL) processes using SAS Data Integration Studio
  • Coding SAS programs and SAS/Macros for Pre & Post Process of Jobs and User written transformations.
  • Validating the Data using different techniques in SAS Data Flux
  • Experienced in Jobs Migration & Deployment Using SAS Data Integration Studio
  • Experienced in Flows Creation & Scheduling Using SAS Management Console.
  • Scheduling the Jobs According to the Flow Design Document
  • Worked on new change requests & resolving production issues.

Environment: SAS Base, SAS Macros, SAS Data Integration Studio, SAS Enterprise Guide, SAS Management Console, SAS Flow Manager, SAS Data Flux, SQL, Windows.

Confidential

SAS Developer

Responsibilities:

  • Develop, Modify Codes using SAS base, SAS MACRO & PROC SQL
  • Verified and validated data accuracy to improve the overall accuracy
  • Created ODBC connection using SQL PASSTHRU facility in SAS/ACCESS
  • Generated customized reports using SAS ODS and SAS Procedures
  • Experienced on Jobs Migration & Deployment using SAS DI Studio
  • Worked on resolving production issues, debugging procedures for existing code.

Environment: SAS Base, SAS Macros, SAS Data Integration Studio, SAS Data flux, SAS Enterprise Guide, SAS Management Console, SAS Flow Manager, SQL.

We'd love your feedback!