Jonathan B Lehman
SQL | Bash | Oracle | Automation | Python
- Role
- Project Lead Developer at Ohio Crime Victim Justice Center
- Location
- Columbus, OH, US
- LinkedIn followers
- 500 followers
About Jonathan B Lehman
Data and developer professional proficient in working with unstructured, semi-structured…
Experience
Project Lead Developer
Ohio Crime Victim Justice Center
Jan 2019 — Present · Columbus, OH, US
Grant Report Automation• Constructed Zapier automation to extract data from case management system• Connected custom form (Jotform) with greater conditional logic and data validation to database, and wrote python code to automate the creation of entities in Case Management App via REST API (with OAuth)• MySQL Administration: Designed database tables, triggers, views, stored procedures, functions, and modeled all data inserted into database to accommodate grant report and Jotform integration• Administered Google Cloud to provision Linux virtual machines and manage a MySQL database• Developed python code to perform data cleaning and transformation populate SQL tables• Constructed Google Data Studio/Looker report for monthly and quarterly summaries• Project Management: Jira boards, cardsAd Hoc: Google Data Studio display of OCVJC page views from Google analytics
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.