David Hickman Email & Phone Number

San Francisco, California, Us

*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.

San Francisco, California, Us

San Francisco, California, Us

San Francisco, California, Us

Round Rock, Texas, Us

*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.