ILMYRDE BOSQUET
Melrose,MA
Overview
22
22
years of professional experience
Work History
Data Engineer
Mass General Brigham Inc
Boston, MA
04.2021 - Current
- Perform EDW ETL/ELT ingestions and integrations to ensure support data and analytic needs
- Build and enhance standard solution that provides efficient and scalable ETL/ELT solutions from multiple data sources
- Ensure the quality of data assets and robustness of data engineering processes
- Experience with change control, release management and other ITIL processes
- Challenge existing process and drive process improvement
- Perform troubleshooting on ETLs and related components
- Identify application bottlenecks and opportunities to optimize performance
- Participate ETL solution, code, and pre-prod review to ensure optimal data delivery architecture is consistent throughout ongoing projects.
Data Warehouse Specialist/Developer
Partners Healthcare Corporate
Boston, MA
08.2015 - 04.2021
- Key contributor to the delivery of all components of a data warehouse environment for production and development systems, such as architecture, data capture, integration, data quality and implementation in Business Intelligence department
- Provide project management as directed of project-based deliverables, including business and technical requirements, project plans, budget, schedules, stakeholder communication and support plans
- Collaborate with business users as directed to understand their analytic objectives and requirements to develop requirements and plans for the implementation of ETL, reporting and analytic solutions
- Educate users on data set, tools, methods, and new functionality from both technical and business perspective
- Provide a vehicle for dissemination of information about data, tools and methods
- Provide guidance regarding best practices around current and emerging technology
- Facilitate and encourage widespread adoption of and innovation in the use of the data warehouse.
Data Warehouse Analyst
Partners Healthcare Corporate
Boston, MA
06.2012 - 08.2015
- Assist with the delivery and maintenance of components in the BICC data warehouse environment (AADW and MDW)
- This includes collecting business requirements, data capture, integration, data quality and implementation
- Develop, update and maintain existing business data assets for the MDW, including proprietary and third party data
- Utilize best practices for data extraction, data loading, and data transformation into and out of a data warehouse
- Develop and maintain operational and user documentation
- Educate and support users on data sets, tools, methods and new functionality.
Market Data Analyst
Partners Healthcare Corporate
Boston, MA
08.2010 - 06.2012
- Develop, update and maintain existing databases, which include proprietary and third-party data (e.g.; historical inpatient utilization data, forecasts for inpatient and outpatient utilization, physician data, population forecast)
- Utilize best practices for data extraction, data loading, and data transformation
- Serve as the resident expert on the data, data tools and provide client support (e.g
- Maintain documentation of data and data tools on a SharePoint site)
- Analyze and report on the performance of markets and hospitals, forecast future volumes using internal tools, report on physician presence, and gather market intelligence on a routine and ad-hoc basis
- Research industry information to understand healthcare trends, market share, and other benchmarks for academic medical centers and community hospitals
- Participate in the planning, development and implementation of business intelligence reporting tools.
Research Analyst
AIR Worldwide
Boston, MA
01.2008 - 07.2010
- Analyze project needs and develop databases and queries in Access and SQL Server
- Maintain existing applications and databases
- Familiarity with handling raw data and manipulating large data sets
- Develop and enhance databases containing the locations and characteristics of residential, commercial, and industrial properties in different regions of the world
- Collect and analyze data pertaining to natural hazards such as wind, precipitation, temperature, land use etc
- Write technical documentation for internal use and distribution to clients
- Create and deliver presentations of analysis methods and results to coworkers and senior management
- Work closely with a team of scientists, engineers, and analysts, statisticians, and GIS specialists to estimate spatial distributions and develop valuation models for properties exposed to natural and manmade hazards around the world
- Act as database administrator for our group; work closely with IT department to ensure that storage, archiving, backup and recovery procedures are functioning correctly.
Project Specialist
American Tower Corporation
Woburn, MA
05.2004 - 01.2008
- Assist in the planning, implementation, and quality management of a variety of research and administrative projects related to tower collocation
- Regularly perform research, data collection and analysis to help managers evaluate project requirements and meet objectives
- Evaluate applications by customers to collocate on towers and other structures owned or operated by American Tower; approve, modify, or decline such applications after reviewing and interpreting tower design drawings, prior structural analyses, and other available documentation and then apply generally accepted engineering principles to determine structural viability.
Lab Technician
GE Panametrics
Waltham, MA
08.2001 - 08.2002
- Built and performed calibrations for various pressure transducers, both standard catalog units and special designs
- Analyzed and collected data of tested transducers’ volumetric rate, K factor, and Reynolds No
- Calibrations performed on PVC, Carbon or Stainless Steel pipes
- Worked with Research & Development group that developed ultrasonic transducers for a number of diverse applications, including flaw detection, thickness gauging, and materials research.
Education
Master of Science in Health Informatics -
Northeastern University
05.2018
Bachelor of Science in Mechanical Engineering -
Northeastern University
06.2002
Skills
- Operating Systems: Window 95, Window XP
- Programming Languages: HTML, C, SQL
- Applications: Microsoft Office (Excel, PowerPoint, Word, Outlook), SolidWorks, FEA, AutoCAD, MatLab, Microsoft Visio, Adobe Photoshop, SAP Business Objects, Tableau, Alteryx
- Fluent in English
- SQL and Databases
- Data Analysis
- Quality Analysis
- Database Development
- Technical Support
- Report Generation
- Data Migration
- Database Design
- Database Structures
- Data Analytics
- Requirements Gathering
- Key Performance Indicators
Timeline
Data Engineer
Mass General Brigham Inc
04.2021 - Current
Data Warehouse Specialist/Developer
Partners Healthcare Corporate
08.2015 - 04.2021
Data Warehouse Analyst
Partners Healthcare Corporate
06.2012 - 08.2015
Market Data Analyst
Partners Healthcare Corporate
08.2010 - 06.2012
Research Analyst
AIR Worldwide
01.2008 - 07.2010
Project Specialist
American Tower Corporation
05.2004 - 01.2008
Lab Technician
GE Panametrics
08.2001 - 08.2002
Master of Science in Health Informatics -
Northeastern University
Bachelor of Science in Mechanical Engineering -
Northeastern University
Similar Profiles
Mario MonteiroMario Monteiro
Inventory Specialist at Mass General Brigham Mass General BrighamInventory Specialist at Mass General Brigham Mass General Brigham
Jessica A. DietzJessica A. Dietz
Practice Assistant II at Mass General Brigham (Brigham & Women’s Hospital)Practice Assistant II at Mass General Brigham (Brigham & Women’s Hospital)
ANGELA KELLYANGELA KELLY
Senior Director, Performance Improvement & Outcomes - Perioperative and Procedural at Mass General Brigham, Brigham & Women's HospitalSenior Director, Performance Improvement & Outcomes - Perioperative and Procedural at Mass General Brigham, Brigham & Women's Hospital
Jon FullertonJon Fullerton
Director, Operations & Process Improvement at Brigham & Women's Hospital | Mass General BrighamDirector, Operations & Process Improvement at Brigham & Women's Hospital | Mass General Brigham
Jack FiricanoJack Firicano
Barista at La'QcharaBarista at La'Qchara