Jonathan Hanna Email & Phone Number

I am a Team Lead in the Data Migrations department at Filevine: a leader in the legal – tech industry. I develop advanced SQL scripts for migrating the data and documents of incoming client migrations. I also architect solutions for complex data mappings, transformations, and loads. In addition to migrations, I write Python to perform data analysis and updates through API calls. I also build tools to analyze, audit, and make suggestions based on client datasets. With Domo, I manage real-time and scheduled reports and visualizations. I'm also tasked with managing AWS infrastructure (S3, RDS, EC2) and moving data in and out through Python and the CLI. Finally, I assist other engineers with data scoping, ETL, incoming data feed management, query optimization, reporting, and customer service.

Pittsburgh,Pa

-Use T-SQL, SSIS, Powershell, and Python to perform API operations, create links between systems, and create ETL processes-Build reports and dashboards using PowerBI, SSRS, and front end languages like HTML,CSS, JavaScript, and ColdFusion-Create complex stored procedures, functions, and scripts to support the needs of the various departments across campus-Participate in database design, architecture, warehousing, analysis, and management of SQL Server databases to support software applications and custom tools

Pittsburgh,Pa

-Oversee incoming/outgoing data and design code for data feed processes-Create, maintain, and optimize database objects and functionality with stored procedures, SSIS packages, jobs, cross-database/object SQL in both a development and production environment-Assist in functional design and technical development of SSIS ETL system within an Agile format

Pittsburgh, Pa.

-Use PL-SQL, Unix/Linux commands, and multiple Oracle utilities to maintain 10g, 11g, and 12c database environments-Use T-SQL and various SQL Server tools to administer 2008-2012 databases, Integration Services, and Analysis Services-Assist in all database practices including database backups, refreshes, clones, migrations, permission configurations, CPU/Memory/Disk administration, security, and documentation-Develop shell scripts, as well as PL/SQL and T-SQL scripts to build and alter database objects for various projects across different teams

Pittsburgh, Pennsylvania

-Shadowed the daily routines and tasks of multiple Oracle DBAs (rman hot/cold backups, memory and process management, etc.)-Used DDL and DML to define and modify data structures for customers-Utilized Oracle Client tools including Oracle Enterprise Manager, Oracle 11g and 12c grids-Designed and implemented multiple web applications using HTML, CSS, JavaScript, JQuery, and Classic ASP-Completed multiple training courses that cover both Oracle Database Administration and Unix/Linux commands

State College, Pennsylvania

-Constructed and implemented a web application for research purposes-Worked with graduate students on smaller tasks related to data mining and analysis-Developed knowledge and skills of PHP, HTML/CSS, Javascript, and SQL.

-Developed PHP, SQL, and HTML/CSS knowledge and skills-Handled smaller tasks under supervision of Project Manager-Developed knowledge of business processes and market research

Master Of Business Administration - Mba, Information Technology

Bachelor'S Degree, Information Sciences And Technology

Activities and Societies: THON, Club Wrestling, Intramural Hockey