• Design and manage internal applications through the Power Platform and a SQL Server database to provide internal data collection utilized by the Real Estate, Lease, and Permitting departments to transform deals into Agreement of Sales.• Develop various reports and processes used by multiple departments to maintain real estate deals and permitting processes.• Provide ad hoc reporting necessary to facilitate business decisions.

• Created Agreements of Sale and related legal documents for approximately 30 deals a year, as well as management of said agreements.• Designed internal application used to manage above legal documents using Power Platform products.• Designed and maintained SQL Server database.• Created multiple reports utilized by various departments to make necessary business decisions and process improvements.

• Responsible for management of twenty-member office (nine attorneys and eleven staff) as well direct supervision of the five-member asbestos team of paralegals and legal assistants. • Assist employees with both onboarding process, understanding of benefit packages, and submitting of claims to the firm’s HRA.• Streamlined the payroll process for the Pittsburgh office providing for accurate and timely tracking of both hours worked as well as PTO hours.• Implemented a daily Scrum meeting with staff members to review workload needs, deadlines, issues, and foster a general team-building environment.• Provided front line help desk support for IT related issues, including setting up for computer equipment, and basic troubleshooting.• Designed and implemented all asbestos procedures providing for an efficient caseload work up including the creation of a case management database utilizing Microsoft Excel and Access. • Reduced client overhead by streamlining reporting processes, case review processes, and workflow implementation. • Succeeded in making the asbestos department a predominantly paperless department, reducing overhead costs in printing and file storage as well as eliminating potential HIPAA compliance risks.

• Managed and maintained the lease database system using SLIM 7.2. • Streamlined the review and abstraction of all lease documents by converting process from paper and pen to an automated process by designing Excel templates that utilized coding for accuracy. • Constructed various Excel tools allowing for the reduction of errors in the review process while increasing the speed and efficiency of real estate team. • Built numerous Crystal Reports providing both business decision makers with integrated lease portfolio information and real estate team with tools necessary to perform lease related functions such as timely payment of rent, taxes, and Common Area Maintenance fees.

• Electronic coding of documents for discovery.• Recovery and review of documents to determine applicability for discovery release.• Redaction, indexing, and Bates stamping of discovery.

Responsible for all court filings to both county and federal courts. Manage closed files including the storage and indexing. Various other general law firm support functions.