Edgar Loor
Reading,MA
Summary
Passionate about data analytics, data reporting, and BI reporting platforms. Keen eye for detail and deep understanding of business needs. 15 Years of experience in health information systems, both from an end-user perspective and on the back-end side. Well-versed in handling diverse data sets from various databases. Expertise includes data reporting using relational databases, SQL Server, Power BI, SQL Server Reporting Service reports, Oracle PL/SQL, Crystal Reports, Business Objects, Pentaho Data Integration, Azure Data Factory, Excel Pivot Tables, and Power Query Editor. Self-motivated to work independently and thrive as a team player in collaborative projects. Known for meticulousness and organizational skills. Excels at working efficiently under tight deadlines. Enthusiastic team player eager to contribute to company success.
Overview
14
14
years of professional experience
Work History
Senior Product Software Engineer
Wolters Kluwer Clinical Effectiveness
11.2014 - Current
- With a departmental transition in our organization in 2022, I now belong to the Data Engineering department where I build pipelines and help in the maintenance and enhancement of our Enterprise DW in Synapse
- Subject Matter Expert for internal products in order to help with data solutions translated from business users to developers
- Previously as data analyst I was working in an agile environment with internal customers to serve reporting needs to support business projects for departments like International and Domestic Sales, Marketing, Product Development, Compliance, Order Entry, and other ad-hoc requests
- We deliver data analytics and reports using a variety of platforms that include dashboards, tabular reports, data dumps, including the collection of data from transactional databases to staging it using ETL tools for the final reporting use
- We also provide administration services for our reporting platforms for users and superusers so they get the appropriate access level to reports and data
- Analyzed proposed technical solutions based on customer requirements.
- Collaborated with management, internal and development partners regarding software application design status and project progress.
- Developed scalable and maintainable code, ensuring long-term stability of the software.
BI Report Developer Manager
Commonwealth Care Alliance
07.2013 - 11.2014
- Company Overview: The business of Commonwealth Care Alliance consists of being a not-for-profit, consumer-governed organization, operating as a prepaid care delivery system for Medicare and Medicaid beneficiaries with complex medical needs
- Managing a group of 2 people in order to serve the data needs to answer business questions, what-if scenarios, operational workflows of different Information Systems/Technologies, reporting needs for compliance with State regulations, among other responsibilities
- It uses Medicare/Medicaid risk-adjusted premiums to redesign care for our members and provides enhanced primary care and care coordination through multi-disciplinary clinical teams including physicians, nurses, and behavioral health and geriatric specialists, and thus it creates savings from reduced hospitalizations and institutional care
- The business of Commonwealth Care Alliance consists of being a not-for-profit, consumer-governed organization, operating as a prepaid care delivery system for Medicare and Medicaid beneficiaries with complex medical needs
- Developed thorough documentation for all created reports, contributing to a comprehensive resource library for team reference and training purposes.
- Assisted in the migration of legacy reports to newer platforms, ensuring minimal disruption during the transition period.
- Balanced multiple simultaneous projects while maintaining strict deadlines and consistently delivering high-quality work products.
- Increased user satisfaction by providing prompt responses to ad hoc report requests, addressing specific needs in a timely manner.
- Troubleshot issues with existing reports, identifying root causes and implementing fixes to prevent future occurrences.
- Participated in regular meetings with stakeholders to present findings and discuss potential improvements for upcoming report iterations.
- Communicated proactively with end-users throughout the report development process, gathering feedback on design choices and making adjustments as necessary for optimal results.
- Collaborated with cross-functional teams to gather requirements for custom reports, ensuring accurate and timely delivery.
- Provided training and support to junior team members, enhancing their technical skills and understanding of reporting best practices.
- Automated multiple reporting tasks through creation of reporting tools.
- Prepared monthly ad hoc reporting in alignment with client needs.
Clinical Informatics Analyst
Commonwealth Care Alliance
03.2012 - 07.2013
- Data analyst dedicated to report development in order to support business departments such as Quality, Clinical Operations, Enrollment and Retention, Medical Affairs, Compliance, Pharmacy, and third-party vendors using data production and analysis by writing ad hoc SQL scripts, standard stored procedures, and standard SSRS parameterized reports
- Team member/business analyst for the roll-out of an Enterprise Data Warehouse (EDW) tool that combines EMR (CaseNet & eClinical Works), medical & pharmacy claims, enrollment, premium, risk factor data
- Lead team member for the data migration of Casenet data to eCW EMR system for go-live in October 2013, and report writer for CCC eBO reports based on eCW production data
Data Analyst in Quality Management and Business Analytics
Cambridge Health Alliance
09.2010 - 03.2012
- Dedicated analyst for Ambulatory generating SQL scripts for reports regarding quality/HEDIS measures for preventive cancer screening, asthma, diabetes, depression, well child and service measures such as no show rates, third next available appointment, bump & cancellation of appointment rates
- Lead team member for the ICD-10 Implementation Business Analytics sub-committee, in charge of identifying a report inventory currently using ICD-9 codes including SSRS reports, Crystal reports, stored procedures, database objects, to later work with GEM (General Equivalent Mapping) to find cross-walk ICD-10 CM solutions
- Analyzing and assessing Epic Clarity as well as Meditech databases for ICD-10 CM transition
- Team member of the Ambulatory Reporting Workbench roll out, working with an initial group of 20+ members identifying and setting up standard public reports for use across the Ambulatory team as well as troubleshooting private reports created by users from master templates
- Report writer for 22 Patient Center Medical Home measures including diabetes, asthma, cancer screening, tobacco assessment/intervention, and influenza vaccinations, using billing records as well as Epic Health Maintenance topic and override records
- Creator of monthly PDE files for Elderly Service Program patients that use Cambridge Health Alliance pharmacy to refill prescriptions, in order to submit the specific-formatted file to CMS for payment collection
- Worked with Epic Application analysts to create new Master files in the Epic registration module to be able to report on them using Clarity
- Worked with Epic DataLink jobs to turn on/off health maintenance modifiers and to create patient lists for clinical and reporting purposes
- Report writer for Reporting Workbench reports in Epic
- Use of SQL Server Job Agent and SSIS for automation and ETL of monthly build of tables for reporting purposes
- Various report writing for labs, ICU mortality rates, ED boarders, PCP patient lists, among others
Education
Bachelor of Science - Management/Information Systems
University of Massachusetts of Boston
Boston, MA12.2009
Certificate - Visual Basic Programming
Protcom School of Software
Guayaqui - Ecuador12.2002
Recording Industry -
Middle Tennessee State University
Murfreesboro, TN12.2001
Certificate - Recording and Producing Engineer
Institute of Audio Research
New York, NY12.1998
Skills
- ETL development
- Advanced SQL
- Azure: Data Factory, Databricks, Synapse
- Python Programming
- Git Version Control
- Agile
Professional training and education
- Power BI Dashboard in a Day, 09/01/19
- Introduction to MongoDB, 06/01/16
- Recombinant Data Trust, 05/01/13
- EClinicalWorks EBO and Data Schema, 01/01/13
- Epic Reporting Workbench version 2010, 10/01/11
- Epic Clarity Data Modeling, 02/01/12
- Lean-Six Sigma Green Belt training program, 07/01/11
- SQL Server Reporting Services 2008 R2, 12/01/10
- Microsoft SQL Server 2008, 11/01/10
- Bachelor of Science in Management/Information Systems, University of Massachusetts of Boston, 12/01/09
- Massachusetts General Hospital, 01/01/04
- Certificate of Visual Basic Programming, Protcom School of Software, 01/01/02
- Middle Tennessee State University, 01/01/01
- Certificate of Recording and Producing Engineer, Institute of Audio Research, 01/01/98
Hobbies
- Soccer player and soccer dad
- Avid consumer of news regarding alternative energy solutions and investments
- Passionate about electric cars
- Constant learner and user of AI technologies
Languages
Spanish
Native or Bilingual
Polish
Elementary
Quote
Complexity appeals to stupid
E. Musk
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Software
Databricks
Data Factory
SQL
Interests
Soccer
Electric Cars
Solar Energy
Timeline
Senior Product Software Engineer
Wolters Kluwer Clinical Effectiveness
11.2014 - Current
BI Report Developer Manager
Commonwealth Care Alliance
07.2013 - 11.2014
Clinical Informatics Analyst
Commonwealth Care Alliance
03.2012 - 07.2013
Data Analyst in Quality Management and Business Analytics
Cambridge Health Alliance
09.2010 - 03.2012
Recording Industry -
Middle Tennessee State University
Certificate - Recording and Producing Engineer
Institute of Audio Research
Bachelor of Science - Management/Information Systems
University of Massachusetts of Boston
Certificate - Visual Basic Programming
Protcom School of Software
Similar Profiles
Christopher WillisChristopher Willis
Implementation Consultant at Wolters Kluwer Financial ServicesImplementation Consultant at Wolters Kluwer Financial Services
Oon Jee AnnOon Jee Ann
Head of Software Sales, SEA at Wolters Kluwer Sdn BhdHead of Software Sales, SEA at Wolters Kluwer Sdn Bhd
VIjaya Gomathi GVIjaya Gomathi G
Software Test Automation Engineer at Wolters KluwerSoftware Test Automation Engineer at Wolters Kluwer