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 (SSIS and Azure Data Factory), and various business intelligence programs, applied across manufacturing, healthcare, agriculture, and government.

Work Experience

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

Automated the ingestion, manipulation, and output of flat files to Power BI dashboards.
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 from flat files and SQL Server to Azure environments.
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.
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 AWS, SAP BusinessObjects, SQL, Sprinklr, Excel and Python.
Created database and qualitative data categorization standards, reducing reporting effort by 70%.

Data Analyst | Aviagen (May 2020 – Jul 2021)

Analyzed quality metrics and created Qlik dashboards..
Automated reports, cutting reporting report creation time by 90%.
Worked with Data Manager to troubleshoot QA issues and perform A/B tests

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.