William Bibbs Email & Phone Number

Austin, Tx, Us

• Establish architectural and governance standards for a Security Data Lakehouse using Azure Databricks, outlining and documenting secure handling, storage, and disposal of data• Administer multiple Azure Cloud subscriptions, utilizing various Azure tools such as Blob Storage, Event Hubs and Resource Monitor to enable effective Lakehouse operation and health• Support development teams on boarding and migrating on-prem solutions to the cloud• Establish and oversee a CI/CD pipeline, powered by GitHub Actions and Terraform, for concurrent development teams, enabling rapid and secure deployment with least-privilege access• Enhance and design Lakehouse ingestion pipelines with PySpark to integrate novel data sources such as Azure Event Hubs, ensuring the daily ingestion of over 10 terabytes of high-quality data • Design Python modules to streamline ETL pipeline development for the Lakehouse, simplifying common operations and providing straightforward, user-friendly methods and documentation to empower developers• Created an Azure Databricks API pipeline to stream compute resource utilization data, enabling visualization and analysis to optimize Datalake functionality by mitigating high resource utilization periods and reducing inefficient use of resources• Create PySpark data pipelines to ingestdata sources into the Lakehouse

Austin, Texas, United States

• Developed data models for a Manufacturing Cybersecurity Data Repository, consisting of 50 tables designed in third normal form, with data from 8 unique data sources. These data sources were further combined into a unifying Data Asset• Worked cross-functionally with data architects, developers and business analysts to ensure Data Repository design followed industry and company standards, as well as encapsulated business asks and developer input• Thoroughly documented data flows with data integration and data mapping documents, ensuring ease of access and understanding of all tables within the Data Repository• Lead development of a Python-based in house tool, scanning computer hardware and software to ensure total security compliance with company standards• Designed a Python-based BigFix mechanism to load hard-to-source data into configuration files that were distirbuted to over 21,000 devices• Drove remediation efforts for large vulnerabilities such as WannaCry, Deja Blue and Bluekeep via BigFix analyses, identifying computers that required additional patching and calculating compliance across all manufacturing sites• Designed an Azure DevOps pipeline to increase the efficiency of COTS product patching, introducing simultaneous automatic server patching, increasing patching efficiency by 80% by reducing patch time from 8 hours to 1.5 hours

• Maintained a 100% on time delivery satisfaction across all jobs• Manage multiple concurrent orders, coordinating and fulfilling an average of 3 jobs per hour• Determine time commitment per job, and fulfill them within a one hour delivery block• Coordinate with customers during job fulfillment, informing of shop and delivery progress

Glenside, Pennsylvania, United States

• Evaluated and provided solutions to hardware malfunctions • Handled an average of 20 tickets of varying nature per week• Supervised a team of student workers, overseeing workflow and work quality• Delegated work tasks to workers, ensuring assignments were done quickly and efficiently• Oversaw deployment of new and recycled computer hardware in a quick manner• Maintained hardware inventory to sustain demands for immediate system replacements• Assisted with the preparation and deployment of over 40 new systems during an enterprise-wide security audit with a two-week deadline

Glenside, Pennsylvania

• Provided level 1 and 2 technical support to customers via phone, email, and in-person• Utilized ServiceNow ticketing system to organize workflow and communication• Understood and performed troubleshooting for various forms of technology (projectors, desktops, laptops, printers, network drives, Windows, macOS, iOS, Android, ChromeOS)

Sydney, Australia

• Designed and implemented predictive analytics algorithms to assess marketing campaign effectiveness based on isolated variables• Collaborated with a senior developer to deepen understanding of digital marketing success metrics and align project goals with company objectives

Master Of Science - Ms, Computer Science

Bachelor Of Science - Bs, Computer Science

Activities and Societies: Arcadia University Computer Science Club