Leadership & Program Innovation -Spearheaded the deployment of a new subscription and governance model for City Year’s Azure environment, to include enhanced resource tagging/ tracking, strengthened role-based access control, and implementation of previously non-existent source control. -Successfully created and maintained automated CI/CD pipelines for code deployment of Data Factory and Databricks resources using Azure DevOps, cutting down release times by 80%. -Assisted in cutting costs through identification of several unused resources, as well as implementing cost alerts and controls to prevent future resource bloat with savings of approximately $20k a year. Pipeline Development & Automation -Phased out all soon to be deprecated U-SQL based transformation pipelines and migrated to a modern Databricks architecture in Python, cutting down pipeline run times by 70%. -Significantly enhanced code maintainability by consolidating 50+ individual U- SQL transformation scripts into 5 flexible and modular Python scripts. Technologies Within This Role: Azure Devops, Databricks, Data Factory, Python, PowerShell, Azure SQL Database, Azure Key Vault, T-SQL

American City Business Journals | Jan 2021 - Feb 2022

Data Engineer

Pipeline Development & Automation -Designed, implemented, and maintained pipelines using Azure Data Factory and Databricks, integrating hundreds of gigabytes from various data lakes and transferring stored processed data to Azure Data Warehouse. -Automated the company’s lockbox process by developing a daily pipeline to extract each day’s files and checks for further processing, saving 200 weekly manual hours. Built and maintained through Azure Databricks in Python, with integrations to Jira (ticket management system). -Automated the company’s daily Address Change Service (ACS) mailing process, updating subscriber’s current address. Files pulled/cleaned/wrangled using Python in Databricks, updating tables in SQL Server, and pushing results to an AWS S3 bucket. -Ingested data from disparate data sources using a combination of SQL, Jira API, AWS Boto API, SFTP, and Ring Central using Python to create data views to be used in Power BI reports. Data Visualization & Data Sourcing -Constructed report to visualize and identify various customer segment changes for the means of applying targeted ads and assessing their efficiency. One such example is identifying high frequency subscribers from weeks prior that have changed to casual readers this week. -Designed budget vs actual, call center metrics, and account executive sales reports, to include the sourcing and storage of relevant data. Technologies Within This Role: Azure SQL Database, Databricks, Data Factory, Azure Machine Learning Studio, AWS - S3, Power BI, Power Automate, Jupyter, Python, T-SQL

Bank of America | Mar 2018 - Nov 2020

Data Scientist

Leadership & Program Innovation -Spearheaded the creation of the Security Operation Center’s (SOC) previously non-existent analytics capabilities. Resulting in the identification of various untapped data and insights. -Delivered regular high-level briefings to senior leadership and various teams regarding status of data driven initiatives and insights gained from cross functional team projects. -Addressed and provided a remedy for a fatal flaw in management’s Utilization formula for the SOC. Challenging the status quo saved a significant part of the team from facing the chopping block. Data Wrangling & Model Development -Automated 212 weekly analyst hours through developing a Logistic Regression spam filter with 95% accuracy, enabling the SOC’s Abuse team to take on more pressing responsibilities. -Built a data aggregation tool pulling both internal and external data sources for the purpose of extracting insights regarding suspicious email trends that were targeting specific lines of business; This data assisted the organization’s Security Awareness Training team in what lines of business need further protection. -Developed modular Python scripts for pulling, parsing, cleaning and manipulating various types of data; To include: time series, text, emails, employee data, Splunk logs, and Twitter data. Data Visualization & Report Building -Developed various threat intelligence dashboards for malicious email trends and performance metrics, in support of the SOC’s Managers and Analysts. -Optimized staffing needs through generating case volume reports to management. Technologies Worked With: Splunk, Cofense (PhishMe Triage), Proofpoint, BlueCoat, LastLine, FireEye Email, ArcSight, Anomali, Tableau, Jupyter Notebooks, Python - Pandas, SciKit Learn, NLTK, Beautiful Soup

Spectrum Enterprise | Mar 2014 - Mar 2018

Data Analyst, Enterprise Technical Support

-Developed Tableau reports and dashboards for management regarding various types of customer issues by region, highlighting where we may need infrastructure or equipment attention -Handled client escalations, providing clients with timely updates and analyzing root cause of escalations in order to drive process improvement. -Remotely troubleshooted Layer 1 to 3 networking issues and outages for commercial fiber clients. -Handled client escalations, providing clients with timely updates and analyzing root cause of escalations in order to drive process improvement. -Processed escalations of client issues as necessary to, but not limited to, the Enterprise and Core NOC, as well as to Engineering and Voice Operations under acute pressure. -Provided direction and assistance with complex technical support incidents, to include WAN/LAN environment issues, Fiber and Voice technologies, and large corporate hardware/software environments. -Optimized micro/macro staffing needs through continuous analysis of case volumes.

United States Air Force | Mar 2010 - Mar 2014

Security Forces

● Conducted weapons maintenance and weapons serviceability inspections for 510 firearms as well as conducting accountability for 1.6 Million dollars of associated munitions, and communications equipment. ● Maintained and ensured swift completion of all work orders pertaining to upkeep as role of government facility manager. ● Supervised a diverse team of 4 in constantly changing operations, to include evaluation and discipline.

My Education

Take a look at my formal education

Bachelor's degree, Software DevelopmentECPI University | 2018

Associate of Science - AS, Computer Science - Network SecurityECPI University | 2016

About Me

Patrick hasn't filled in a bio text

Create Your Data Portfolio for Free