Software Engineer, Data

• Oct 2020 - Present

- Developed backend system for credit card rewards scoring application (Python, AWS Glue). - Developed SCD ETL to enable segment-based scoring. - Implemented a new release process to use standard git flow model. - Refactored ETL scripts into module-based applications, deployable as wheel packages. - Helped with onboarding of new team members, knowledge transfer, and creating documentation for the team. - Develop BDD-style use cases for the QA team. - Developed backend system for credit card rewards scoring application (Python, AWS Glue). - Developed SCD ETL to enable segment-based scoring. - Implemented a new release process to use standard git flow model. - Refactored ETL scripts into module-based applications, deployable as wheel packages. - Helped with onboarding of new team members, knowledge transfer, and creating documentation for the team. - Develop BDD-style use cases for the QA team.

Senior Data Analyst

• Nov 2019 - Oct 2020

- Developed integration between SQL Server and SAS Enterprise using Python so that data can be pushed automatically to SAS pipeline. - Refactored stored procedure ETL processing to Python with SQLAlchemy. - Led company-wide training sessions on how to use git for version control (Github). - Trained the analytics team on how to use AWS EMR spark for large scale data processing. - Built parsing tool that creates diagrams directly from raw SQL ETL scripts. - Created ETL verification tool that checks for logical correctness of SQL queries using graph algorithms. Show less

Infrastructure & Automation

• Jan 2019 - Nov 2019

- Created ansible playbooks to automate ec2 configuration and app deployment. - Created terraform scripts to store infrastructure state for automated deployment. - Using Docker with Flask and Kafka, developed an integration between PagerDuty and Remedyforce to automatically generate tickets from alerts. - Lead project management of Devo implementation for new log centralization. - Created python scripts to automate dashboard creation of IT ops metrics. - Created ansible playbooks to automate ec2 configuration and app deployment. - Created terraform scripts to store infrastructure state for automated deployment. - Using Docker with Flask and Kafka, developed an integration between PagerDuty and Remedyforce to automatically generate tickets from alerts. - Lead project management of Devo implementation for new log centralization. - Created python scripts to automate dashboard creation of IT ops metrics.

IT Product Manager

• Apr 2018 - Jan 2019

Product Manager

• Apr 2017 - Apr 2018

Product Manager

• Oct 2015 - Mar 2017

- Manage scrum for team of engineers- Liaison between IT and the rest of the business- Prioritize new features and bug fixes for custom-built CRM software- Gather end user and manager requirements for new features, write specs for engineering- Perform QA on new features and bug fixes- Research new technology and software options to improve business processes, as well as work on "skunkworks" projects

Senior Operations Analyst

• Feb 2015 - Oct 2015

- Business process improvement and automation through PHP programming- Develop integrations between multiple applications using their APIs- Develop advanced SQL queries for business users and DB optimization where necessary using query planner- Contributed to ETL for data warehouse project

Oracle PeopleSoft Financial Analyst

• Aug 2013 - Jan 2015

- Gather requirements from clients to create custom reports - Write testing scripts for system testing and UAT - Convert client requirements into specs for the developers - Gather requirements from clients to create custom reports - Write testing scripts for system testing and UAT - Convert client requirements into specs for the developers

Financial Operations Manager

• Nov 2011 - Jul 2013

- Designed and implemented procedures for internal control and treasury operations - Prepared monthly and annual profit and loss statements - Maintained bank statement and merchant account reconciliation - Performed auditing and exception-handling of electronic payment system transactions - Designed and performed audits of client accounts to satisfy state campaign finance regulations - Designed and implemented procedures for internal control and treasury operations - Prepared monthly and annual profit and loss statements - Maintained bank statement and merchant account reconciliation - Performed auditing and exception-handling of electronic payment system transactions - Designed and performed audits of client accounts to satisfy state campaign finance regulations