Project: Monarch License Update (Cost Optimization, Licensing Compliance)
- Led the Monarch License Update, resulting in significant cost savings for the company.
- Collaborated with cross-functional teams to ensure seamless integration and compliance with regulatory requirements.
Project: Pay by Text (Customer Engagement, Payment Processing, Business Analytics)
- Developed and deployed Pay by Text, enabling the business to identify users not utilizing credit cards via short codes.
- Designed automated reports to provide insights into user payment behaviors and adoption trends.
- Managed and optimized ETL processes, ensuring high data integrity across databases. Automated metrics dashboards, reducing manual efforts by 70% and improving efficiency. This project is to improve customer experience by prompting the card members to pay before they incur late payment fees.
- Led the migration of Enterprise Data Platform (EDP) from MySQL to Snowflake, optimizing scalability and performance.
Project: Financial Reporting
- The Financial Reporting ETL takes about 3-4 hours to run each day. Based on the run times in test, it is expected to reduce the run time by 50 to 75 percent. This will take significant loads off the server whilst group B jobs are running allowing more timely access to the data by internal analysts
- Streamlined complex workflows by breaking them down into manageable components for easier implementation and maintenance.
- Optimized data processing by implementing efficient ETL pipelines and streamlining database design.
- Led end-to-end implementation of multiple high-impact projects from requirements gathering through deployment and post-launch support stages.