Currently a member of the Fort Washington Investment Advisors IT team working to build out its Informatica platform and Data Warehouse using Agile methodology.• Analyzing and developing new Informatica workflows/mappings and SQL Server views to provide current data for daily investment decision making. Also providing maintenance/production support and off-hours support.• Worked as ETL developer transforming the staging layer of their operational data store with masking technology for PII. At the same time also enhancing data pulls so they only occur from the source once.

ETL technical lead/coordinator on two Agile teams with several contractors each. Accountable for performing design reviews, code reviews, and providing expertise on how new code should work within existing ETL framework.• Analyzed and developed new Informatica workflows/mappings that are used in a migration from Oracle to a new custom third-party loss prevention application. These are now part of the main integration daily process.• Designed, programmed, implemented, and maintained ETL logic associated with populating data models, custom third-party interfaces, and various other integrations using Informatica PowerCenter, Ab Initio, Korn shell scripting, Connect Direct, and Tivoli Workload Scheduler (TWS).• Provided support and maintained several legacy applications, including involvement with the Support Center, Infrastructure teams, and vendors; providing off-hours support as required. This kept integral legacy systems up-to-date and relevant.• Assisted and mentored other team members on best practices, standards, and development principles by working with them individually and teaching ETL classes. This reinforced a solid working relationship with others on the team and with associates in other departments.

Worked as ETL developer on the Enterprise Labor Management System (ELMS) and Data Warehouse teams using Ab Initio, Unix shell scripting, and Tivoli Workload Scheduling software.• Served as component lead for several subject areas which required technical design, estimates, development, implementation, testing, and rollout tasks needed for maintaining them. • Acted as developer for several pharmacy extracts/transforms using Oracle SQL*Plus, PL/SQL, and SQL Developer sent to third-party vendors. This aided in more efficient data reporting and billing.• Assigned to a 'tiger team' during the summer of 2010 as one of the ETL developers for quickly developing interfaces into existing systems for tracking weekly sales and determining impact from various promotions.• Converted backend Unix based legacy system that was using cron and Unix shell scripts to Ab Initio and Tivoli Workload Scheduler (TWS) for enterprise-wide use. Continues to be used by store managers today.