*Managed the analytics schema for the Purchase Finance line of business, designing and implementing custom ETL scripts for data transformation, converting raw data into structured, actionable insights.*Architected and led process improvement initiatives, automating ETL workflows with Apache Airflow DAGs to reduce manual intervention and enhance pipeline efficiency by 30%.*Built Python scripts to extract data from third-party APIs and automate its integration into data warehouse tables, streamlining data flow and significantly improving data accessibility and reporting efficiency.*Optimized Tableau data sources to enhance BI reporting efficiency and enable deeper insights, boosting productivity by 35% and supporting data-driven decision-making.*Constructed custom PL/SQL scripts to deploy data changes to production AWS Oracle databases, utilizing version control systems (GitHub) to manage updates and ensure consistency across environments.*Led the migration of an analytics schema from a legacy Oracle database to an AWS cloud data warehouse, improving scalability, data accessibility, and operational efficiency.*Mentored analysts on KPIs, SQL, and data best practices, reducing onboarding time by 25% and enhancing team analytics capabilities.*Collaborated with the credit risk team to define data requirements and create custom data sources aligned, applying data modeling techniques to enhance accuracy and alignment with risk modeling needs.

*Assumed primary responsibility for the CaliberRM requirements repository.*Maintained various templates and documents used to support the project Business Analysts.*Led training sessions and workshops for new and current users.*Communicated with Business Analysts, Project Managers, Quality Assurance team members, and Borland Software to resolve technical issues.*Elicited requirements for a project integrating CaliberRM with Mercury Quality Center.*Interviewed MBA students to fill a Business Analyst co-op position.

*Streamlined the process of importing Apache web logs into a Sybase database.*Wrote a PERL script that converts Apache web logs into a Sybase database compatible text file format.*Coded another PERL script to automatically generate XML files for use with OpenNMS.*Developed scripts using Emacs in a Linux desktop environment.