• Developed SQL and ETL for data warehouse and data mart databases • Tested SQL and ETL for accuracy, robustness, and unintended consequences• Modifed existing SQL and ETL to meet changing business rules and customer requirements• Supported monthly enterprise data warehouse and data mart production loads, diagnosing job failures, implementing hotfixes, and recovering as necessary

• Provided data, information and analysis to support strategic business decisions• Developed and tested SQL and ETL processes for the enterprise data warehouse• Designed and managed the business intelligence (BI) tools and application environments• Configured BI tools, developed semantic layer and metadata, and created reports and report definitions• Adapted SQL and ETL processes to accommodate changes in source systems and new business user requirements

• Diagnosed and resolve technical issues on faculty, staff, and lab computers• Delivered, setup, and configured new computer systems and peripherals• Transfer user data, bookmarks, and other essential files to new computers• Tested new, upgraded, and repaired systems on-site for operation• Explained technical concepts and ideas to non-IT faculty and staff

• Prepared spreadsheets verifying interest calculations for an audit by New York State Insurance Department• Designed and populated database with policy-holder information• Programmed existing reserving calculator to retrieve data from aforementioned database and modified calculator to reserve for those specific accounts• Researched, analyzed, and summarized mutual fund investment patterns of life insurance companies