Hunter James

Data Professional | Lifelong Learner

About Me

I am a data professional with an interest in constant learning and improvement.
I have worked in roles with tasks that align with those of a data analyst, database developer, software specialist, data engineer, and DBA.
I have experience with SQL, Python, R, Scala, HTML, ETL tools, and various business intelligence programs, applied across manufacturing, healthcare, agriculture, and government.

Work Experience

SQL Developer | General Dynamics IT (Jun 2023 – Present)

Designed and developed new database structures, including ERDs.
Created data migration scripts to transfer and reformat data, ensuring the integrity of hundreds of millions of records.
Utilized Databricks for the transformation and analysis of large datasets.
Optimized stored procedures, triggers, and indexes to improve performance.
Developed ETL pipelines using SSIS and ADF to automate workflows and migrate data.
Collaborated with cross-functional teams to ensure seamless database integration.
Managed the NCHHSTP’s SQL Server Production, Training, QA, Failover, and Development instances.

Software Developer | TEKsystems (Nov 2022 – Jun 2023)

Contract to Hire for the CDC through General Dynamics (hired on at GDIT at the end of the contract).
Developed interactive dashboards on Power BI to visualize key metrics.
Created and optimized SQL functions, triggers, and stored procedures.
Designed and maintained SSIS & ADF pipelines for ETL processes.
Worked with senior developers to enhance database efficiency and integrity.
Assisted in migration projects by refining data structures and processes.

Application Specialist | Aviagen (Jan 2022 – Oct 2022)

Managed SQL databases and user access.
Beta-tested program updates and designed UI wireframes.
Provided reports using SQL, Ingres, Crystal Reports, and Qlik.

Service Intelligence Analyst | LG (Jul 2021 – Jan 2022)

Analyzed call center data with Excel & Python.
Used AWS, SAP BusinessObjects, SQL, and Sprinklr.
Automated reporting, reducing time by 70%.

Data Analyst | Aviagen (May 2020 – Jul 2021)

Analyzed quality metrics and automated reports.
Created databases, cutting reporting effort by 90%.

Education

University of Illinois Urbana-Champaign (Aug 2024 - August 2026)

Western Governors University (Mar 2024)

MS Data Analytics

Royal Holloway, University of London (May 2020)

BS Accounting, Finance & Economics

Skills

Databases & ETL: SQL, MS SQL Server, Ingres, SSIS, ADF, Databricks, Synapse
Programming & Analysis: Python, R, SQL, Excel (Power Query, PivotTables)
BI & Reporting: Power BI, Tableau, Qlik Sense, SAP BusinessObjects
Languages: Spanish (B2 Proficiency)

Projects

Review Categorization – For my capstone project, in Python, I utilized RNNs to predict the star rating customers left products based on the content of the reviews. I then created an application that processes sets of reviews using the trained RNN and assigns them a rating.