Data Engineer and Support Specialist Resume Title

WILLIAM ANDREW KEILSOHN

Email: *******.********@*****.*** Phone: +81-809-***-****

LinkedIn: www.linkedin.com/in/william-keilsohn-8680348b GitHub: https://github.com/wkeilsohn Summary

Database Developer with experience in developing custom Python scripts to automate tasks between data warehouse and AWS instances. Proficient in Python, SQL, and data modeling, with a track record of improving data accuracy and decision-making processes. Developed a Django-based web application for real-time data display, enhancing data accessibility. Eager to leverage technical expertise to contribute to innovative solutions as a Python Engineer.

EDUCATION

University of Maryland, Online Jun 2021 - Sep 2022 Graduate Certificate, Digital Forensics & Cyber Investigation

GPA: 4.00/4.00 Online

Villanova University, Villanova, PA Aug 2017 - May 2019 Master of Science, Biology

GPA: 3.40/4.00 Villanova, PA

Study Abroad: Costa Rica January 2018

University of Delaware, Newark, DE Aug 2013 - May 2017 Bachelor of Science, Marine Science & Entomology

GPA: 3.75/4.00 Newark, DE

Achievements: Honors

Study Abroad: New Zealand January 2017 – February 2017 CERTIFICATIONS

• PCAP - Certified Associate in Python Programming: Python Institute Open Education and Development Group January 2019

• Hanyu Shuiping Kaoshi (HSK) Level 2: Hanban Confucius Institute December 2021

• TEFL: International TEFL Academy May 2022

• Salesforce Certified Administrator: Trailhead Salesforce September 2023 EXPERIENCE

Interac Network Japan Mar 2025 - Present

ASSISTANT LANGUAGE TEACHER Ibaraki, Japan

• Teaches multiple sections of English as a foreign language to Japanese students in class sizes of approximately 40, enhancing their language skills and cultural understanding.

• Assists in grading assignments, quizzes, and tests, ensuring timely feedback and supporting student progress.

• Creates lesson plans and managed class time to ensure students met MEXT objectives, fostering a structured and effective learning environment.

• Communicates complex topics to a diverse audience from various cultural and language backgrounds, enhancing understanding and engagement.

• Solves problems quickly and under pressure to keep lessons engaging and entertaining, maintaining student interest and participation. Center for American Progress May 2022 - Mar 2025

Contract to Hire – Addison Group Consulting May 2022 – Oct 2022 DATABASE DEVELOPER Washington DC USA

•Served as system administrator for two company Salesforce systems/instances including an NPSP instance, each with approximately 300active daily users.

• Managed and resolved user requests, such as provisioning new users, updating personal information, granting and revoking access to records, and improving system efficiency / user experience.

• Developed custom Flows, Objects, Page Layouts, Fields, and Views within both Salesforce systems to meet customer demands.

• Utilized REST API's to coordinate and automate tasks between a Data Warehouse instance and an AWS instance via the implementation of custom Python scripting.

• Used Python requests to extract byte data from a PostgreSQL Database, then using Pandas and NumPy recompiled those files into documents the finance team could access.

• Automated Python scripts using Bash files and Task Scheduler to keep user data aligned across four systems, improving data consistency and reducing manual data entry errors.

• Leveraged Pandas to clean and format legacy data, enabling seamless transfer into an Azure Data Warehouse instance and ensuring data integrity.

• Utilized Microsoft Power Automate to create automatic processes for the legal department, streamlining the approval process for large contracts and reducing processing time.

• Created customized business intelligence reports in both Power BI and Tableau, and presented them to the finance and legal teams, facilitating data-driven decision-making.

• Built a custom web application using HTML5, CSS, JavaScript, and Flask, allowing the finance team to query legacy invoices directly from a PostgreSQL Database, enhancing efficiency in invoice retrieval.

• Automated spreadsheets for HR using Smartsheet and connected them to Salesforce, improving data accuracy and efficiency in HR processes.

• Used Pandas to interpret files from Paycom and created automated scripts for onboarding new employees, enhancing efficiency by connecting to Salesforce and Active Directory via RESTful HTTP calls.

• Leveraged Microsoft Power Automate and Microsoft Adaptive Cards to create an automated process integrated with Microsoft Teams, enabling the fundraising team to efficiently validate grants with the finance department.

• Integrated Slack with Salesforce to notify the fundraising team about their goals in Slack, improving communication and goal tracking.

• Wrote a Python application to update and remove users from Salesforce and Active Directory based on changes in Paycom, ensuring data consistency and reducing manual errors.

• Created an automatic response system for user support tickets that directed them to internal company help articles using HTTP requests to search the company's Confluence repository, improving response time and user satisfaction. Trinity Rail Industries Sep 2021 - Mar 2022

DATA MANAGEMENT ANALYST Texas USA

• Analyzed over 200,000 data points within three MSSQL databases using Python, improving data accuracy and decision-making processes.

• Aligned matching columns across databases and created primary keys via Pandas, enhancing data integrity and facilitating efficient data analysis.

• Conducted cross-reference searches and validations between databases with Pandas and NumPy, ensuring data consistency and reliability.

• Stored and scheduled scripts in Azure Databricks, automating data processing tasks and improving workflow efficiency.

• Built a Django-based web application to connect to all three company database instances, providing real-time data displays and enhancing data accessibility.

• Presented a data management application to upper management, highlighting its potential to streamline data processing and improve decision-making.

• Built Decision Tree, Random Forest, and K-Nearest Neighbors algorithms using Python packages Matplotlib and scikit-learn to predict which train cars would most likely need repairs.

• Utilized scikit-learn and Pandas to isolate the portion of a train car most likely to need repair, enhancing maintenance efficiency and reducing downtime as well as helping to reduce company costs.

• Achieved over 90% accuracy with at least two predictive models, significantly improving the reliability of maintenance predictions and resource allocation.

SAP North America Jun 2019 - Sep 2021

SUPPORT ENGINEER Pennsylvanian USA

• Provided premium-level support for a wide variety of customers with various IT and SaaS needs, resulting in improved customer satisfaction.

• Installed and configured a variety of SAP products on customer systems such as Solutions Manager, SAP Analytics Cloud, and SAP FTP Connections.

• Leveraged SAP Analytics Cloud to create dynamic dashboards and displays to help customers better visualize, understand, and utilize their company's data.

• Communicated complex technical concepts to customers, colleagues, and consultants of all organizational levels, leading to improved understanding and collaboration across teams.

• Helped customers connect to SAP HANA, primarily through OData and ODBC connections.

• Collaborated with customers to leverage their data using proprietary company tools, resulting in the creation of insightful dashboards and reports that enhanced decision-making

• Developed a Linear Regression model for predicting system outages based on three company test systems.

• Achieved over 80% accuracy with the Linear Regression model, enhancing the reliability of system outage predictions. Biology Department, Villanova University Aug 2017 - May 2019 BIOLOGY TEACHING ASSISTANT Pennsylvanian USA

• Taught multiple lab sections of General Biology (I & II) as well as Entomology and Biomechanics courses.

• Ensured the integrity of assignments for undergraduate students while grading them quickly and professionally.

• Published findings in ProQuest as DEAD BUGS DO TELL TALES: A genetic examination of the coastal distribution of the Maritime Earwig (Anisolabis maritima)

• Analyzed data from multiple museums and international scientists, contributing to a comprehensive understanding of species distrib- ution.

• Performed Bayesian statistics using GeneiousTM, enhancing the accuracy of genetic data analysis for my research project.

• Used a 3130X Genetic Analyzer to obtain and process samples and data, improving the accuracy of my genetic analysis results.

• Leveraged Python to manage and organize data files and calculate the length of branches on phylogenetic trees, ensuring that the results were accurate and within acceptance.

• Collaborated with scientists from around the world, including Japan, to obtain a robust pool of specimens, enriching the diversity and reliability of research data.

• Performed PCR (polymerase chain reaction) on both fresh and dried insects to obtain sampling data, contributing to the understanding of insect genetic diversity.

Dr. Douglas Tallamy, Professor and Chair of Entomology and Wildlife Ecology Aug 2015 - May 2017 LAB TECHNICIAN Delaware USA

• Published findings in the February 2018 volume of the Journal of Insect Conservation: Roadside Habitat Impacts Insect Traffic Mortality

• Led the research team by setting goals and timetables, as well as keeping records of permits and sampling locations.

• Worked closely with other researchers to build statistical models and graphs of data via R.

• Created detailed plots using ggplot2, enhancing data presentation and interpretation for research findings.

• Provided insect identification data to the National Wildlife Federation as part of their project to create an electronic search tool. PROFESSIONAL SKILLS

• Python, Pandas, Flask, Django, SQL, PostgreSQL, MSSQL, MySQL, Word, Excel, PowerPoint, Outlook, Power Automate, Other, Salesforce, Power BI, Tableau, AWS, Azure, COBOL, JavaScript, Linux Development, Linux Operating System, Data Pipelines

Contact this candidate