Ying Hang
Saint Paul,MN
Summary
Lab Research Chemist with extensive experience at 3M, specializing in SQL and data analysis. Demonstrated success in optimizing data management processes and improving compliance through collaboration. Proficient in Power BI reporting, consistently delivering high-quality results while ensuring effective communication with stakeholders.
Overview
21
21
years of professional experience
Work History
Lab Research Chemist/Physicist/Engineer/Data Management (Contractor)
3M
Maplewood, MN
10.2025 - Current
- Document experimental data and observations accurately, prepare reports, and present findings orally.
- Collaborated with engineers to gather details for technical data sheets.
- Monitored lifecycle of master data to ensure accuracy and integrity throughout various stages.
- Created PLM approvals record enhancing traceability and compliance.
- Optimized linkages between various entries within PLM.
- Project and data management to update and create documents relating to existing and new products.
- Collaborate with data analysts, data engineers, and business and project stakeholders to incorporate their expertise into data science solutions.
Administrative Assistant/Data Analyst (3 to 6 Month project)
Ramsey County
Saint Paul, MN
05.2025 - 08.2025
- Returning Resident Calls and providing Status Updates.
- Monitor State data workflows and resolve client’s info and payments discrepancies.
- Preparing documents, maintaining records, and providing general support to staff.
- Maintain a high level of customer service with timely and professional communication.
- Audited and processed bills and claims, posted transactions, and balanced and reconciled accounts to ensure accurate and timely payments.
- Communicated with internal teams to clarify documentation needs and resolve discrepancies, enhancing workflow efficiency.
- Handling sensitive information with discretion and confidentiality (HIPAA).
- Use call scripts or talking points to ensure clear and consistent messaging to residents.
- Document the call outcomes in Case note or a tracking sheet. Tracking and Following Up on Missing Verifications.
- Reviewed case notes for missing documents, contacted residents to remind them of required verifications, and explained submission process to facilitate timely compliance.
- Notify the assigned eligibility specialist when verifications are received.
- Coordinate with the workers to identify residents needing appointments (e.g. missed SNAP interviews or follow-ups).
- Performed data entry and updated case statuses in SAP MAXIS to maintain accurate records.
- Input data for pending applications (e.g., contact information, verification status) into SAP MAXIS.
- Update case notes to reflect follow-ups, received documents, and call attempts.
- Ensure case statuses are current.
EP Regulatory Windchill Coordinator (Contractor)
ABBOTT
Plymouth, MN
08.2022 - 12.2024
- Use SQL to manage structured data and communicate with relational databases.
- Use Power BI to clean, shape, and model data for analysis. Generate shareable reports and dashboards.
- Review, edit, and format documents for clarity, consistency, and compliance with quality standards.
- Executed product release activities in Windchill, ensuring accurate master data, ZFIN (MDD and MDR) selection, EP PRA Checklists, and proper approvers for assigned regions.
- Supported projects including data cleanup, quality system documentation, training, and system enhancements.
- Facilitated change documentation and approval workflows, accurately tracking regulatory and impact-related documentation within Windchill.
- Managed bills of material for medical devices, ensuring compliance and accuracy throughout the product lifecycle.
- Analyze root cause of GTS blocked orders and implement correct solution to resolve blocked order (PRA completion, new ZFIN, etc.) per assigned regions.
- Support prioritization of product release with international regulatory specialists or product expert for region on a weekly basis.
- Communicate with customer service, regulatory affiliates, supply chain, regulatory specialists, and product experts on timelines for releasing products to assigned regions.
Regulatory Windchill Coordinator (Contractor)
ABBOTT
Little Canada, MN
01.2020 - 07.2022
- Updated Windchill fields to ensure accuracy of approval records, dates, models, manufacturers, facilities, and certificate numbers.
- Pulled regulatory approval records for targeted countries using defined search criteria in SAP application.
- Assisted Regulatory Affairs with EU MDR compliance related to blocked orders.
- Performed data cleansing by removing or expiring GTS licenses within the Windchill system.
- Identify out of syncs between specific metadata fields and the approval records.
- Communicated discrepancies, including expired approval records, missing models in Windchill, and instances of multiple approval records with identical information.
- Analyze financial statements, sales reports, and other performance indicators.
- Use SQL to manage structured data and communicate with relational databases.
- Use Power BI to clean, shapes, and models data for analysis. Generate shareable reports and dashboards.
- Review, edit, and format documents for clarity, consistency, and compliance with quality standards.
- Designed a PowerPoint trend chart for executive review, enhancing visual data interpretation.
Payments Specialist/Data Analyst (Contractor)
MEDTRONIC
Mounds View, MN
02.2018 - 11.2019
- Pull large data from client CTMS system and update information via Excel spreadsheet.
- Tracked and prioritized invoice approvals and payment status, ensuring adherence to internal compliance and audit requirements.
- Coordinated with procurement and vendors to resolve invoice and payment discrepancies, enhancing financial accuracy and compliance.
- Use Spotfire system to look up clients' information to create reports for data management.
- Administers, extends, negotiates and terminates standard and nonstandard contracts.
- Applied fundamental principles of contracting to enhance agreement processes.
- Uses Microsoft Office (Excel and Word) for contract and metrics tracking.
- Verify clinical trial information in Oracles.
- Review, edit, and format documents for clarity, consistency, and compliance with quality standards.
- Handled routine tasks and reviewed agreements of limited scope and complexity, including Confidential Disclosure Agreements.
- Works closely with Manager and/or contracting personnel on projects of limited scope.
- Coordinates and organizes agreement processes and projects assigned.
Data Management Analyst (Contractor)
CARGILL
Hopkins, MN
01.2017 - 11.2017
- Utilized VLOOKUP and CONCATENATE in Excel to identify data gaps in large multi-column reports.
- Collaborated with Data Process leads to align on processes and data setup, addressing upstream and downstream impact.
- Worked with business units to understand business requirements for both present state and future state.
- Constructed vendor data for PT testing, cutover plant locations and UAT testing.
- Work in SAP screen to look at sales adjustments, data pricing, inventory review, and material returns.
- Maintain and update client records in accordance with company policy.
- Review, edit, and format documents for clarity, consistency, and compliance with quality standards.
- Compiled and organized supplier and ordering addresses from various merchants to streamline procurement processes.
Data Analyst (Contractor)
MEDTRONIC
Mounds View, MN
04.2015 - 12.2016
- Retrieved and analyzed client information using Spotfire for comprehensive data management reports, facilitating informed decision-making.
- Extracted and updated large datasets from client CTMS system into Excel for enhanced data accuracy and accessibility.
- Ensured accurate payment processing through checks and electronic filing, supporting financial integrity.
- Review, edit, and format documents for clarity, consistency, and compliance with quality standards.
- Administered and extended contracts to ensure compliance with company policies.
- Apply basic contracting principles, theories and concepts.
- Uses Microsoft Office (Excel and Word) for contract and metrics tracking.
- Coordinates and organizes agreement processes and projects assigned.
Sales Operations Support (Contractor)
SECURIAN FINANCIAL GROUP
Saint Paul, MN
06.2014 - 03.2015
- Generated and updated daily and monthly reports via Salesforce Client System, supporting data-driven decisions for Sales Operation Department.
- Create billing reports for the dashboards in Salesforce.
- Utilized Excel to create and update sales data using VLOOKUP and pivot tables, enhancing data analysis for sales performance.
- Created campaigns within Salesforce that contributed to sales revenue generation.
- Collaborated with internal wholesalers to generate Excel sales reports.
- Addressed sales support inquiries using Lotus Notes to ensure timely resolutions.
- Obtain missing information from FINRA Brokercheck search and update Salesforce.
- Review, edit, and format documents for clarity, consistency, and compliance with quality standards.
Referral Document Specialist (Full-Time)
LENDERS PROCESSING SERVICES
Mendota Heights, MN
10.2004 - 03.2013
- Review, edit, and format documents for clarity, consistency, and compliance with quality standards.
- Reviewed Bankruptcy and Foreclosure files for errors and researched to resolve discrepancies.
- Developed Excel report to track Bankruptcy and Foreclosure documents efficiently.
- Executed data entry tasks with attention to detail and accuracy.
- Input data and updated computer database once new information is obtained.
- Supported clients via email and phone regarding document requests and issue resolution.
- The documents are Motion for Relief, Plan Objection, Proof of Claim, Foreclosure, and Motion of Abandonment.
- Sorted and organized items to maintain inventory accuracy.
- Unpack and sort daily mails and make sure it distributes to the correct departments.
Education
Bachelor of Science -
University of Wisconsin Stout
Menomonie, WI01.1998
Skills
- SQL and data analysis
- Power BI and reporting
- Business intelligence tools
- 3M PLM platform
- Windchill document control
- CTMS management
- SAP Oracle database
- Salesforce CRM
- VLOOKUP and pivot tables
- Microsoft Office Suite
- MS OneNote for note-taking
- Lotus Notes and email management
- Cisco Jabber for communication
Technical Experience
- 3M Global PLM Platform
- SQL
- VLOOKUP
- Pivot Tables
- Data Analysis
- MS Office Suite
- MS Word
- MS Excel
- Power BI
- MS SharePoint
- MS PowerPoint
- Outlook
- SAP
- Maxis and MMIS
- Lotus Notes
- Salesforce
- Windchill System
- CTMS (Clinical Trial Management System)
- Ecats
- Spotfire
- Business Object
- Oracle Clinical Database
- MS OneNote
- Cisco Jabber
Timeline
Lab Research Chemist/Physicist/Engineer/Data Management (Contractor)
3M
10.2025 - Current
Administrative Assistant/Data Analyst (3 to 6 Month project)
Ramsey County
05.2025 - 08.2025
EP Regulatory Windchill Coordinator (Contractor)
ABBOTT
08.2022 - 12.2024
Regulatory Windchill Coordinator (Contractor)
ABBOTT
01.2020 - 07.2022
Payments Specialist/Data Analyst (Contractor)
MEDTRONIC
02.2018 - 11.2019
Data Management Analyst (Contractor)
CARGILL
01.2017 - 11.2017
Data Analyst (Contractor)
MEDTRONIC
04.2015 - 12.2016
Sales Operations Support (Contractor)
SECURIAN FINANCIAL GROUP
06.2014 - 03.2015
Referral Document Specialist (Full-Time)
LENDERS PROCESSING SERVICES
10.2004 - 03.2013
Bachelor of Science -
University of Wisconsin Stout