Greencastle, Pennsylvania, United States
As a data professional, my goal is to build solutions that not only meet today's needs but also anticipate future ones. With experience in SQL, Python, large-scale ETL projects, Oracle APEX, and Streamlit (including LLM-powered applications), I design data pipelines, applications, and reports that turn complex requirements into clear, actionable results. Known for adapting quickly to new technologies and thriving in fast-paced, high-pressure environments, I enjoy tackling complex end-to-end challenges and communicating findings clearly to both technical and non-technical stakeholders.
Currently in my role as a Business Data Analyst III I am: - Working to create dynamic forms and applications for University departments, using Oracle Apex, PL/SQL, CSS, and JavaScript - Continuing to work on and automate integration projects through ETL and Procedural SQL, saving hundreds of hours of work a year - Leading trainings to increase overall knowledge and efficiency in creating SQL queries that can send to different populations dynamically using JSON variables for marketing promotions - Automated personal tasks using Python scripts, optimizing time worked on larger projects
As a Business Data Analyst II, I have: - Led training and technical enablement for an 8-member marketing analytics team by creating and delivering workshops, building a dynamic request search engine, and developing an incident catalog that improved resolution time for recurring issues. - Automated marketing campaign development by designing 15+ dynamic SQL bases and 130+ reusable SQL templates, reducing manual coding effort by hundreds of hours and significantly lowering team workload. - Streamlined data integrations through PLSQL and ETL automation, saving over 1,000 hours annually across multiple University departments. - Built a cost-saving course evaluation report that improved review efficiency and saves the university $38K and over 1,000 hours annually. - Developed and maintained complex Tableau and Argos dashboards leveraging statistical models and large datasets to monitor critical institutional processes and inform decision-making.
As a Business Data Analyst I, I consistently: - Developed complex Tableau reports, including visualizations of student course data and dashboards supporting Duplicate Identity Manager case reviews. - Supported key internal processes for marketing campaigns, including campaign setup, quality control, and incident investigation. - Worked on data integration projects leveraging batch ETL feeds to report on student and faculty data, and built automated email campaigns driven by that data.
As a Resident Assistant, I had to: - Manage a hall of 57 men and organize hall events - Manage a $2000 budget from both the brother and sister halls - Resolve conflict and provide counseling to students when needed - Help develop and encourage through one on one meetings each week