Adam Iona
Durham,NC
Summary
IT Analyst specializing in data management and transformational analytics, skilled in SQL programming (PostgreSQL, SQL Server) and Python for ETL and data integration. Demonstrated success consulting with stakeholders to design structured datasets and visual reporting. Adept at ensuring data quality and compliance across complex environments.
Overview
13
13
years of professional experience
1
1
Certification
Work History
Intern
Miami Waterkeeper
Miami, FL
05.2015 - 08.2015
- Established online campaigns to support member engagement and improve outreach
- Served as consultant to maximize the utility of Salesforce.com by integrating ETL solutions and suggesting extension applications
- Created documentation and assisted with the development of 10 custom objects and app installation to enhance system functionality
- Answered questions and assisted with troubleshooting to improve user experience
Data Analyst Contractor
Cisco Systems
Morrisville, NC
02.2015 - 05.2015
- Compiled and analyzed large data sets from multiple sources to produce weekly snapshots of operations, supporting data transparency
- Implemented 5 quality assurance (e.g., version control) measures to ensure reports met accuracy standards
- Extracted and manipulated data to develop meaningful and actionable insights for strategic decision-making
- Collaborated with multiple service entities to provide necessary data resources
- Provided formatted data for internal team and division-wide presentations and visuals to support project goals
- Ensured data integrity and consistency by developing templates for transforming data to specific standards
- Improved reporting efficiency by documenting strengths and weaknesses of existing procedures
Practicum
North Carolina Institute of Public Health
Chapel Hill, NC
01.2014 - 05.2014
- Increased efficiency of data gathering by 10% by creating a unified form for data collection
- Translated technical concepts into clear language for a non-technical audience, improving overall understanding
Database Consultant
Kenan Institute of Private Enterprise, UNC Kenan Flagler Business School
Chapel Hill, NC
06.2012 - 12.2012
- Fine-tuned 10 queries, forms, and reports from created database to optimize data retrieval
- Improved data integrity by maintaining the database to comply best practices
- Supported Quality Assurance by collaborating with end users to test database functionality and implemented their feedback
Data Analyst/Programmer
UNC-Chapel Hill Biostatistics
Chapel Hill, NC
01.2023 - 01.2025
- Collaborated with a team to produce analytical reports using SQL, enabling study sites to assess data quality issues
- Designed and customized data visualizations and dashboards using PostgreSQL and in-house design tools for data integration
- Created and tested over 20 PostgreSQL queries to organize and tabulate collected data by study sites in accordance with governance policies
- Granted rights for users and sites to enter and modify data in study forms, ensuring compliance
- Maintained update history of study documents to support auditing processes
- Configured and coordinated internal ETL processes, optimizing data loading procedures
Business Analyst
PennyMac
Cary, NC
01.2021 - 01.2022
- Created data mapping documents and provided business application consulting during migration to new data architecture and support ETL processes
- Documented data flow across multiple database systems using Google Sheets to create data visualizations that enhanced clarity
- Wrote 10 complex SQL queries in SQL Server and Snowflake to obtain sample data for testing
- Compared data output across systems to describe data transformations, ensuring data integrity
- Collaborated with a cross-functional team to apply analytical skills in identifying defects causing incorrect data output
- Assisted developers and quality assurance testers to ensure defects were resolved promptly
IT Data Analyst
Fidelity Investments
Cary, NC
01.2015 - 01.2020
- Analyzed incoming and existing client data and made corrections to client records to minimize risk, adhering to data governance guidelines
- Produced error reports for over 100 clients to facilitate data correction and compliance reporting
- Implemented protocols involving large datasets' consistency and validity in line with regulatory standards
- Provided detailed analysis to identify anomalies in data resources from mainframe
- Collaborated with an international team to refine analysis tools for improved data processing
- Maintained effective communication with client representatives to rectify errors and ensure satisfaction
- Developed daily action plans focused on ensuring data quality and compliance
SalesForce.com CRM Consultant
Kenan Institute of Private Enterprise, UNC Kenan Flagler Business School
Chapel Hill, NC
01.2012 - 01.2014
- Supported organization-wide implementation of Salesforce.com CRM by offering training and creating user documentation in plain language to simplify processes
- Improved workflow efficiency by 10% by consolidating data into one organized database
- Conducted business analysis that enabled users to successfully integrate Salesforce.com into their current workflows
- Researched extension applications to improve efficiency and capabilities of Salesforce.com, enhancing user satisfaction
Education
Master of Science - Information Science
University of North Carolina-Chapel Hill
Chapel Hill, NC01.2013
Bachelor of Arts - Philosophy with a Minor in Psychology
Knox College
Galesburg, IL01.2011
Skills
- MySQL
- Metadata
- JavaScript
- Python
- Complex SQL Queries
- Data Mining
- Business Analytics
- Big Data
- Data Visualization
- ETL
- Analytical Skills
- Data Integration
- Strong Interpersonal Skills
- Data Cleaning
- Systems Analysis
- Business Application Consulting
Certification
- Data Analytics Boot Camp Certificate, University of North Carolina-Chapel Hill, 01/01/20
- Clinical Information Science Certificate, University of North Carolina-Chapel Hill, 01/01/14
Personal Information
Title: Application Systems Analyst
Recent Projects
- Python API Challenge, https://rb.gy/8uikwd
- Python Challenge, https://rb.gy/ekvjz6
- Human Trafficking Analysis, https://rb.gy/mqtbgg
- Fidelity Customer Data Intake Tool
Timeline
Data Analyst/Programmer
UNC-Chapel Hill Biostatistics
01.2023 - 01.2025
Business Analyst
PennyMac
01.2021 - 01.2022
Intern
Miami Waterkeeper
05.2015 - 08.2015
Data Analyst Contractor
Cisco Systems
02.2015 - 05.2015
IT Data Analyst
Fidelity Investments
01.2015 - 01.2020
Practicum
North Carolina Institute of Public Health
01.2014 - 05.2014
Database Consultant
Kenan Institute of Private Enterprise, UNC Kenan Flagler Business School
06.2012 - 12.2012
SalesForce.com CRM Consultant
Kenan Institute of Private Enterprise, UNC Kenan Flagler Business School
01.2012 - 01.2014
Bachelor of Arts - Philosophy with a Minor in Psychology
Knox College
Master of Science - Information Science
University of North Carolina-Chapel Hill