Senior Consultant

• Jan 2023 - Present

Senior Data Engineering Consultant

• Feb 2022 - Jan 2023

Technical Implementation Consultant

• Nov 2017 - Feb 2022

Client-facing consultant implementing B-One, a performance and attribution tool for asset management Data integration solution design and implementation Custom code development for user-defined processes Database engine migrations Database replication and environment migration Requirement analysis with Business Users Data modeling and database administration (Oracle, MS SQL, PosgtreSQL) Custom workflow design Performance tuning and query optimization Database application development using PL/SQL and PL/PGsql Fielding questions from clients for product support Involved in decisions regarding software/hardware architecture and data warehousing strategies Development and communication of best practices Linux server administration and maintenance of highly available server cluster Server Firewall configuration Network analysis and TCP/IP issue remediation between application interfaces Shell/Python programming Nightly batch design and development Show less

Business Implementation Data Consultant

• Jan 2016 - Oct 2017

Performed complex mainframe to open systems application migrations Programming tasks in Ab Initio, Korn Shell, Perl, and SQL Developed several custom solutions for the team including dynamic file watching for customer input, generic Ab Initio graphs for input processing, and custom file shipping solutions Mentored less experienced Ab Initio developers on my team and assisted in developing solutions for their customers Delivered high quality custom applications for customers to monitor credit event based “triggers” and deliver data within 24 hours of important changes Production support and batch application management Show less

Senior Programmer

• Jan 2015 - Jan 2016

ETL programming tasks using Ab Initio and Teradata. Data warehousing Unix/Linux shell scripting Made use of ESRI/GIS tools for geographical data enhancements to database Batch Database Processes Business Analysis/Data Mapping Data Modeling and profiling Data quality/referential integrity assurance Worked in agile development, executing sprints between 2 and 3 weeks long Lead ETL developer on a project which created a database of merchant information for use in various rewards and promotion platforms within the company Worked with outside vendors to supplement merchant database with other pertinent data points Production support and batch application management Show less

Senior Analyst, Data and Reporting

• Jun 2014 - Dec 2014

Salesforce administration Data Integration/Payer Mapping for sales organization Dashboard creation in GoodData and mapping to geographic territories in Salesforce to create dynamic market share and revenue dashboards, narrowly focused on individual salespeople’s portfolios. Data modeling and metric creation Designed high volume data feed with IMS Health to identify Walgreens’ market share along multi-level payer hierarchy to identify opportunities for sales organization Worked with other organizations within Walgreens to share insights being generated by dynamic reporting Planned and executed weekly agile sprints Show less