Develop NLP pipelines with text extraction for sorting and analysis with PySparkSolve information collection problems utilizing NER with spacy to collect key attributesSpecialize in pattern matching with unstructured text dataUtilize pipelines to process documents at terabyte scaleAnalyze confusion matrices and precision and recall scores to determine model categorization accuracyWork with non technical clients doing requirements gathering, and sharing progress deliverables on text extraction projectsDesign highly versatile functions for handling multiple document conditions for tabular and raw text formatsDevelop complex phone matching criteria on unstructured document data to handle differing formats, have exclusionary criteria, and condition groupings depending on surrounding keywords identified (phone or fax number)Parse legacy documents using AWS Textract for advanced analysisApply regular expression pattern matching to documents to extract keywords and to build categories for future client dashboard useUtilize Databricks to monitor and schedule jobsDesign pipelines based on medallion architecture with most work completed in the silver layer (cleansed and conformed data)Complete exploratory analysis to determine the future structure of data pipelines Utilize String Similarity Metrics such as Cosine Similarity or Levenshtein Distance in fuzzy matching for entity resolution for dirty text data for structuring and organizationDesign advanced SQL queries utilizing common table expressions (CTE) for complex criteria sortingWrite derived queries to simply readability and designPush and update production code using version control tools such as Git and GitLabCreate a Camelot function and pipeline for versatility across uses, which effectively handles erroneous table dataAnalyze relationships using graph databases such as AWS NeptuneLead scrum sprint meetings and develop dashboards in Jira

Developed weekly PowerPoint presentations on our 22 million dollars worth of Lititz projectsMet and coordinated with project leaders to quantify financial risks and projectionsWrote and edited Excel VBA code for macro enabled dashboards for advanced reportingGenerated purchase ordersUtilized SAP to track project cash flowsBuilt pivot tables, nested formulas, and joint Excel documents to allow for data driven decision-making

Complete website maintenance requests by creating new website filters and toppers, listing new products, editing product page criteria, writing transcripts, and general site improvements on the backendCompile Monday Power BI reports for the Images DepartmentAssist in projects on extended warranties, parts, and shipping weight/volumeDevelop new methods of completing requests in Excel and with in-house toolsData clean using Excel macrosAuto-populate tables with equations including but not limited to nested IF, AND, OR, INDEX, MATCH,TEXTJOIN, etc...Moderate product reviews, and record competitor MAP violations

Responsible for screening and recruitment of Student Ambassadors, including interviews and mock toursMaintained confidentiality regarding applicants for the admissions departmentCoordinated and organized student ambassadors on event days and weekend toursDelivered feedback for Student Ambassador annual rehires and new guides and determined the quality of the guide on a pass-fail basis

Promoted Susquehanna University using statistics, experience, and giving details of majors, as well as providing informed responses to questionsFiled and sorted early applications and maintained confidentiality with details regarding Susquehanna applicantsAssisted admissions team by in inputting recruitment event data into Excel

Contacted prospective business students directly through texting or email by utilizing Slate for on and off campus contactDeveloped listings of key criteria on prospective business students for database entryUtilized queries in Slate to access necessary criteria and contact information

Developed key metrics on the min/max production times of polishers in relation to all sizes of materialsCreated listings and graphs analyzing the production capabilities of meters/hr for a standard weekDesigned a table to show the amount of time X number of tubes would take at the minimum, average, and maximum time based on prior dataWrote a report developing a plan for more streamlined data collection and general improvements to maximize the time value of polishing

Developed a simplex linear programming table in Excel for the Hegins glass line-1, decreasing labor slack time by 8%Analyzed second shipment reports with logistics team where we developed a shortage report of MIA unitsMaximized skills with six-sigma, process control plans, and flow diagrams to further develop production efficiency Created process control plans for PA plants regarding the 1650-1, glass line-1, and the 3500-2 window series lines to allow simple task operation reorganization to maximized production capabilitiesReviewed engineering diagrams and learned techniques for utilizing Autodesk and AutoCAD programs