Jen MacDonald
Salem,WI
Summary
Results-driven data professional with keen eye for detail and passion for uncovering actionable insights from data. Proven track record of utilizing data analysis and visualization tools to drive business decisions and optimize processes. Team-oriented with strong focus on collaboration and adaptability, consistently delivering reliable results in dynamic environments.
Overview
14
14
years of professional experience
Work History
Senior Implementation Conversion Data Analyst
FIS
12.2016 - 10.2024
- Conduct data analysis, product mapping and client interviews to assess data requirements for software utilization.
- Create data maps and transaction workflow documents that show exactly how every field will be converted.
- Perform tests to ensure new, customized software meets customer specific needs.
- Coordinate and conduct readiness reviews to ensure conversion is proceeding correctly.
- Produced reports using Access for client review.
- Train customers on new systems and procedures.
- Generated standard and custom reports to provide insights into customer usage.
- Collaborate with data programmers.
- Provided technical support for troubleshooting analytics and reporting issues.
- Utilized data visualization techniques to present and explain complex data sets to customers.
- Updated and developed scripts and queries to extract and analyze data from multiple sources.
- Identified patterns and trends in large data sets and provided actionable insights.
- Developed customized reports, summarizing and presenting data in visually appealing format.
- Analyzed data to identify root causes of problems and recommend corrective actions.
- Improved data governance practices, ensuring compliance with regulatory standards and internal policies.
- Enhanced business efficiency by identifying trends and patterns in complex datasets.
- Collaborated with cross-functional teams to ensure data integrity and accuracy, resulting in better-informed decisions.
- Produced test and production reports using Access functions.
- Facilitated cross-departmental data integration, enhancing overall data coherence and utility.
- Enabled more personalized customer experiences by analyzing behavior patterns and preferences.
- Contributed to automated routine data analysis tasks, freeing up time for more complex analysis.
Data Integration Engineer
Randstad - Wageworks
04.2016 - 10.2016
- Responsible for analyzing complex support issues and uses independent judgment and knowledge to resolve client problems which fall outside commonly experienced support issues.
- Wrote complex SQL queries and scripts to support data integrity issues for large datasets.
- Implemented complex outbound custom data feeds for clients and third party administrators.
- Responded to technical issues to provide migration and file level support for escalated non-repetitive data issues. Analyze, identify and resolve data issues by creating complex scripts to resolve data conditions and abnormalities in an efficient and effective manner that is in accordance with established Service Level Agreements (SLA's).
- Created detailed mapping plans to implement outbound file feeds. This includes collaboration with a third party vendor, developing an implementation plan, testing files (Quality Assurance) and moving to production.
- Ensured that migrations and integrations are completed timely and accurately by creating and testing detailed scripts.
- Developed, maintained, and provided documentation on processes, scripts, and case resolution procedures for future reference or use.
IT Systems Analyst
TekSystems - Froedtert
11.2015 - 01.2016
- Automated the identity management process involving setup of standard access dependent on the employee's position within the organization.
- Analyzed Epic access requirements dependent on employee's position.
- Updated Courion roles based on findings from access investigation.
- Modified computer security files to incorporate new software, correct errors, or change individual access status.
Systems Administrator
TekSystems - Rockwell Automation
08.2015 - 09.2015
- Configured security settings or access permissions for groups or individuals using scripts for over 2 TBs of data.
- Built servers using VMware.
- Utilized commands and observe system functioning to verify correct operations and detection of errors.
Systems Security Administrator
ProHealth Care, Inc.
06.2010 - 01.2015
- Implemented ongoing process improvements and development of best practices utilizing Powershell to automate team procedures.
- Performed identity management functions using Novell, Active Directory, Epic, and multiple healthcare applications; validate that users receive appropriate network, file share, and application security according to their position within the organization.
- Responsible for weekly termination and transfer reporting as well as monthly expired user reporting.
- Provided auditors with required data and determine the most efficient method to retrieve accurate information.
- Collaborated with Compliance department when necessary to investigate possible HIPPA and security violations.
- Created user internet usage reports where necessary.
- Ensured that user data is transferred appropriately within the organization.
- Provided operational support for IT security applications which includes application administration.
- Provided staff and users with assistance solving computer related problems, such as malfunctions and program problems.
- Modified computer security files to incorporate new software, correct errors, or change individual access status.
- Reviewed violations of computer security procedures and discuss procedures with violators to ensure violations are not repeated.
Education
Associate of Science - Administrative
Gateway Technical
Kenosha05-1997
Skills
- Data integration
- Software testing
- Data extraction
- Communication Skills
- Analyze trends
- Write reports
- Customer reporting
- Process Automation
- Data Visualization
- Data Security
- Data Interpretation
- Database Design
- Data Management
- Problem-solving aptitude
- SQL Scripting
- Access Queries
- Critical Thinking
- Multitasking Abilities
- Problem-solving abilities
- Documentation
- Data Analysis
- Data quality assurance processes
- Data formatting
Timeline
Senior Implementation Conversion Data Analyst
FIS
12.2016 - 10.2024
Data Integration Engineer
Randstad - Wageworks
04.2016 - 10.2016
IT Systems Analyst
TekSystems - Froedtert
11.2015 - 01.2016
Systems Administrator
TekSystems - Rockwell Automation
08.2015 - 09.2015
Systems Security Administrator
ProHealth Care, Inc.
06.2010 - 01.2015
Associate of Science - Administrative
Gateway Technical