Patrick Wang Email & Phone Number

Data Pipeline Development: Design, implement, and manage robust data pipelines using Microsoft Azure Data Factory to automate data integration and transformation processes.Database Management: Utilize SQL for data manipulation, extraction, and loading, ensuring that databases are optimized for performance and reliability.Data Quality Assurance: Continuously monitor and improve data quality, clarity, and integrity through rigorous testing and validation processes.Collaboration: Work closely with production team, analysts, and other stakeholders to understand data requirements and deliver solutions that meet business needs.Performance Optimization: Optimize data workflows and database performance to support the organization's data-driven initiatives.Documentation: Maintain comprehensive documentation of data workflows, processes, and methodologies to ensure transparency and knowledge sharing within the team.Troubleshooting: Identify, diagnose, and resolve data-related issues to ensure uninterrupted data availability

Facilitates use of data to solve organizational problems through development of reports, stored procedures, SQL objects, and adhoc solutionsMaintained/updated stored procs and extracts to support Legacy's ever growing patient care and staff needs

Determined and designed data collection methodology, maintenanceof data collection systems, and detailed data analysis/reporting for quality improvement, compliance, and insight.

Wilsonville, Oregon, United States

- Worked under the supervision of Guorong Fang, current team lead and softwaredevelopment engineer within the Business Models and Entitlements group inconjunction with system integration group to help troubleshoot, run test scenarios,and conduct platform testing validation, as well as document user defects.- Implemented updates and maintenance across various data schemas using OracleSQL Developer

Portland, Oregon, United States

- Worked in Manufacturing Engineering to continuously improve quality, efficiency, and transparency in operations.- Implementing innovative technology in regards to analytics and internal applications to closed feedback loops which helped provide actionable information.- Business Intelligence Tools Used: Alteryx, Alation, and Tableau to create workflows, develop SQL queries, and produce Tableau reports to help supplement individuals within Manufacturing Engineering