Sr Database Marketing Analyst
- Developed and lead SQL and SAS training sessions for team of analysts.
- Created validation queries, discussed findings with technical team and made recommendations for resolution during transition from Hadoop to Redshift.
- Consolidated data from various sources to produce email reporting that included email metrics such as sents, click and opens along with transactional details like orders, revenue and products purchased.
- Reduced run time for critical program by converting from SAS to Redshift SQL using nested queries and windowing functions.
- Developed inventory reporting that identified entry errors during the transition from one distribution center to another.