• Gathered business rules & requirements from subject matter experts to map data from multiple sources into a consolidated data mart to be used for reporting
• Developed, tested, and deployed both reusable and custom components of ETL processes using SAS and SQL code
• As a developer, performed data preparation, cleansing, and integration, and ensured data quality and integrity
• Handled large data sets, retrieving them from either an MS SQL Server or Hadoop Distributed File System (HDFS)
• Optimized existing SAS Data Integration Studio jobs & SQL code that produced reports
• Provided documentation of processes to clients across all projects
• Projects as a consultant were primarily in the banking industry using SAS Data Integration Studio and SAS Enterprise Guide