Matt VanPortfleet
Senior Data Engineer
Zeeland,MI
Summary
Meticulous Senior Data Engineer maintaining highly functional digital systems for uninterrupted workflows and consistent productivity. Loves collaborating with customers and teammates to develop and implement creative technical solutions to challenging problems. Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals.
Overview
28
28
years of professional experience
2
2
years of post-secondary education
Work History
Senior Azure Consultant
Seneca Resources
Reston, VA
03.2024 - Current
- Managed use of various types of databases and configured, installed and upgraded new ones.
- Provided ongoing support for troubleshooting complex issues related to deployment and maintenance of Azure resources.
- Proven ability to learn quickly and adapt to new situations.
- Implemented robust security measures using Azure Active Directory, safeguarding client data and systems.
- Optimized client data storage systems with Azure Blob Storage, significantly reducing costs.
- Enhanced cloud infrastructure efficiency by implementing tailored Azure solutions for clients.
Engagement Manager (Associate Director)
IQVIA
Plymouth Meeting, PA
9 2021 - 03.2024
- Lead team responsible for design, implementation, and management of scalable cloud data solutions for ingesting, transforming, and storing structured and unstructured data into data lake
- Collaborate with cross-functional teams to identify areas of growth and needs of Enterprise Data across IQVIA
- Lead, mentor, and inspire high-performing team of data engineers and integration specialists while working with data analysts to come up with best design for integrating and presenting data
- Foster culture of collaboration, innovation, and continuous learning within team
- Provide constructive feedback for areas of growth and positive feedback to areas of excellence
- Create environment to cultivate collaboration, problem solving and team dynamics to allow team members to attack problems with out of box thinking.
- Evaluated post-engagement performance data to identify areas for improvement and implement strategies to enhance future engagements'' quality and effectiveness.
- Collaborated with sales teams to identify new business opportunities and expand company's client base.
- Streamlined internal processes to improve team efficiency and project delivery timelines.
- Implemented data-driven strategies for continuous improvement of engagement services, leading to improved performance metrics.
- Enhanced client satisfaction by effectively managing cross-functional teams and delivering high-quality solutions.
- Mentored local personnel on best practices and protocols to maximize productivity.
- Collaborated with sales, delivery and service teams to manage seamless client experiences.
- Led teams of up to 4 personnel, supervising daily performance as well as training and improvement plans
Senior Technical Consultant
Halfaker And Associates (SAIC)
Arlington, VA
7 2020 - 9 2021
- Leading role in transformation of VA from on-premises SQL data warehouse to modern cloud-based analytics platform using data lakes, AI, NLP and other PaaS architecture
- Using ADF to ingest data with Azure SQL Server parameters to create dynamic pipelines to ingest terabytes of CDW data
- Creation of ADF endpoints and meta data-driven creation of full and incremental pipelines
- Building combination of ground-to-cloud and cloud-to-cloud relational and unstructured data.
- Evaluated existing systems architecture, recommending upgrades or modifications as needed based on analysis findings.
- Collaborated with cross-functional teams, ensuring timely project completion and client satisfaction.
- Spearheaded research initiatives to stay current with industry trends and advancements in technology for better service delivery to clients.
- Led troubleshooting efforts for complex technical problems while maintaining focus on client satisfaction throughout resolution processes.
- Re-engineered existing computer systems to promote ease-of-use and improve system security.
- Proven ability to learn quickly and adapt to new situations.
Senior Technical Consultant
LTS
Reston, VA
09.2019 - 07.2020
- Community Care accounts for 30% of all veteran's healthcare being outsourced to private sector
- Acted as main architect for moving raw vendor-provided data into data zone where it could be merged with large volumes of internal VA health data to provide Business Intelligence layer capable of driving metrics to improve healthcare delivery
- Design and develop ADF pipelines to ingest on-premises data to cloud to provide reporting capabilities to business owners
- Gather and create report frameworks to help report writers create reports quickly and accurately
- VHA is moving from custom build EHR (VistA) application to Cerner and requires all interfaces to meet VHA standards
- Increased client trust and maintained long-term relationships through exceptional communication and problem-solving skills.
- My team was assigned to review interoperability within VHA applications to convert HL7 data from VistA to Cerner
- Review ingestion requests to validate feasibility of request with VA requirements and standards.
Senior Programmer/Analyst
OMT-Veyhl
Holland, MI
06.2017 - 07.2019
- Lead programmer and architect to drive development of dashboard reports and custom application for assembly line display and upper management reporting
- Full stack development using SQL Server and Visual Studio to create custom applications for assembly lines
- Using ETL to connect Microsoft Dynamic NAV to create reports using Power BI.
- Streamlined workflows by automating repetitive tasks using advanced programming techniques and tools.
- Created web-based dashboards and reporting tools for data visualization.
- Collaborated with other developers to refine software design and implementation.
- Established close working relationships with stakeholders to gather requirements accurately thus guaranteeing successful product outcomes.
- Built databases and table structures for web applications.
- Provided technical guidance to junior team members, fostering positive learning environment that encouraged professional growth.
Programmer Analyst III
Metro Health Hospital University Of Michigan Health
Wyoming, MI
10.2015 - 01.2017
- Lead developer to integrate Intersystems HealthConnect integration engine to allow three testing environments with minimal manual intervention
- Refactored interface engine to take into consideration three testing environments to create autonomous process to test without manual intervention
- Build custom X12 (837) parser and custom DICOM (radiology) parser to convert to HL7 to insert patient data from off-site locations
- Develop, code, and implement inbound and outbound interfaces (HL7, X12 and flat files) for offsite offices into Hospital EHR.
- Improved systems with addition of new features and infrastructure.
- Implemented innovative systems for data collection.
- Communicated complex technical concepts clearly to non-technical stakeholders during project discussions and progress updates.
- Stayed current with industry trends, enabling incorporation of emerging technologies into projects for competitive advantage.
- Wrote highly maintainable, solid code for software system.
- Identified opportunities for process improvement within development team, implementing changes that led to increased efficiency and collaboration among members.
- Provided technical support using knowledge of complex technology to solve problems and support new projects.
Programmer Analyst
Holland Hospital
Holland, MI
01.2006 - 10.2015
- Holland Hospital was moving from eGate interface engine to Intersystem HealthConnect interface engine
- Team was tasked to convert all interfaces, while reviewing and updating code, to seamlessly integrate from eGate to HealthConnect
- Planned, designed, and converted eGate integration engine to Intersystems HealthConnect, updating and re-coding all interfaces from eGate to Ensemble
- Implement new interfaces including HL7, DICOM, and X12 using HealthConnect to extend hospital PHI to local physician offices
- Troubleshoot, redesign, and document older code to streamline message flow to best utilize new features of Intersystems HealthConnect
- Lead architect and developer to create custom application to ingest patient visit information and use data to create and print scheduled reminder letters for three month and one-month appointments daily
- Lead developer to create hospital-wide lookup application to contact physicians using their personal preferences
- Increased hospital-wide productivity by designing and coding physician search application to contact physicians using personal contact preferences
- Code and integrate Crystal Reports and Microsoft SQL Server Reporting Service into web-based applications for internal departments to help submit to State of Michigan Quality Measurements
- Develop and coded Breast and Bone application to capture patient data for mammography reporting to bridge gap between custom application and commercial application.
- Championed culture of continuous learning within team, driving adoption of new development methodologies that yielded improvements in workflow processes.
- Created databases, data entry systems, web forms, and other applications for diverse uses.
- Excellent communication skills, both verbal and written.
- Resolved problems, improved operations and provided exceptional service.
- Assisted with day-to-day operations, working efficiently and productively with all team members.
- Enhanced user experience through development of intuitive and user-friendly interfaces.
Business Analyst
BDO, LLC
Grand Rapids, MI
04.2004 - 01.2006
- Succeeded in developing awareness for Unsolicited Commercial Email to help end users understand importance of filtering UCE
- Decreased Unsolicited Commercial Email by 97% by implementing new spam filter to reduce wasted time manually removing and checking email
- Daily updated BDO’s website content to ensure proper information was displayed for intranet and worldwide distribution
- Assessed, researched, interviewed, and implemented new software for BDO to increase productivity in recruiting new customers.
- Collaborated with stakeholders to identify business needs and data sources.
- Assisted with creating data cubes and OLAP models to improve data analysis.
- Provided technical support for troubleshooting analytics and reporting issues.
- Facilitated change management initiatives, ensuring smooth transitions during organizational transformations.
- Performed gap analysis to identify areas of improvement.
Educator
Grand Haven Area Public Schools
Grand Haven, MI
08.1997 - 01.2000
- Developed detailed goals and objectives for individual students while tracking and guiding their progress throughout school year
- Initiated and lead one on one and group discussions
- Planned, lead, and implemented constructive team-building activities for students and parents.
- Replenished classroom supply levels to support planned lessons and activities.
- Designed curriculum-aligned assessments to measure student progress and inform instructional decisions.
- Helped students explore concepts with engaging, learning-focused activities.
- Shifted between formal and informal methods of teaching to keep students engaged.
- Created and developed lesson plans to meet students' academic needs.
- Collaborated with adults and children to provide safe and educational experience.
- Modified lessons and curriculum to accommodate diverse learners by using strategies such as peer-assisted learning and group work.
Educator – Special Education
Coloma Community Schools
Coloma, MI
08.1996 - 06.1997
- Assessed and monitored students in areas of special education
- Worked together with teachers to create innovative learning environments for students
- Kept thorough individual records and interpreted results for each special education student.
- Established strong relationships with parents through regular communication, fostering supportive network for student success.
- Evaluated students' understanding of course material through examinations and in-depth essay writing.
- Fostered student curiosity and interest through creative hands-on activities.
- Created and implemented assessments to measure student progress.
- Passionate about learning and committed to continual improvement.
- Designed detailed learning plans for struggling students based on test, homework and assignment records
Education
Bachelor of Science - Computer And Information Sciences
Grand Valley State University
Allendale, MI 08.2001 - 12.2003
Skills
Azure Storage Solutions
Technical Analysis
Azure Architecture Design
Cloud services
Problem-solving abilities
Professionalism
Azure Data Factory
Azure SQL Database
Critical Thinking
Technical Guidance
Azure Storage Solutions
Azure Machine Learning
Interpersonal Skills
Time Management
Timeline
Senior Azure Consultant
Seneca Resources
03.2024 - Current
Senior Technical Consultant
LTS
09.2019 - 07.2020
Senior Programmer/Analyst
OMT-Veyhl
06.2017 - 07.2019
Programmer Analyst III
Metro Health Hospital University Of Michigan Health
10.2015 - 01.2017
Programmer Analyst
Holland Hospital
01.2006 - 10.2015
Business Analyst
BDO, LLC
04.2004 - 01.2006
Bachelor of Science - Computer And Information Sciences
Grand Valley State University
08.2001 - 12.2003
Educator
Grand Haven Area Public Schools
08.1997 - 01.2000
Educator – Special Education
Coloma Community Schools
08.1996 - 06.1997
Engagement Manager (Associate Director)
IQVIA
9 2021 - 03.2024
Senior Technical Consultant
Halfaker And Associates (SAIC)
7 2020 - 9 2021