Learn Data Skills
Beta
Eduardo Diego Solomon

Eduardo Diego Solomon

Data Analyst

IQVIA

Technologies

My Portfolio Highlights

My New Course

Understanding Data Science

Insights artist, transforming data into visually stunning masterpieces of knowledge.

My Work

Take a look at my latest work.

course

Intermediate SQL Queries

course

Understanding Data Science

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

Crown Castle | Mar 2022 - Present

Sr Data Analyst

Extracted, Transformed, and Loaded (ETL) data into custom designed templates to generate reports to further investigate and analyze for operations and finance leadership. Used a combination of software including JDE, Excel (including VBA Macros), and PowerBI to ensure validity and consistency. Worked with tens of thousands of lines of real estate acquisition, finance, and geographic data for special projects. Managed and monitored daily Prime Lease data for accuracy, quality, completeness, and conformity to provide support for client facing staff who worked on lease contracts. Updated data governance documentation to reflect changes in workflow and evolution of data as new web browsers were adopted once Internet Explorer applications retired. Designed and maintained custom templates and macros to be used by multiple teams for validation and integration.
Show More

Codebusters | Oct 2021 - Mar 2022

Quality Data Analyst

Created a master data dictionary with custom filters for sorting scorecard measures for programs such as HAC, HRRP, HCAHPS, VBP for Center for Medicaid & Medicare Services. Summarizing calculations & establishing infrastructure for various hospital departments. Supported Quality Committee needs by building custom monitoring templates for plugging in report generated data. Trained healthcare quality leaders and staff in data culture, literacy, visualizations, & basic statistical models. Developed exec summaries of local, state, & federal payment systems for department performance metrics.

Bethlehem Haven | Jul 2020 - Aug 2021

Data & Quality Administrator

Pulled client data from Allegheny COC / HMIS data warehouses (OKTA, ClientView, eClinicalWorks, EPIC) for all service, housing, and clinical programs for weekly, monthly, quarterly & annual reports. Lead efforts to identify incompleteness or system errors & delegated to appropriate staff or outside agencies. Developed formulas and macros (VBA) & pivot tables to plug processed data into custom visuals, tables & business intelligence tools. Presented to multiple county executives to demonstrate services meet local, state & federal benchmarks & requirements. These designs are current best practice models for analytics across larger health organizations and the county. Project Manager for the analytics platform designed by VISIMO integrated with inhouse Crystal (Ruby) database MyAvatar. Additional consultation provided at Electronic Health Records (EHR) groups, Root Cause Analysis (RCA) groups & middle management financial operations via Microsoft PowerBI. Managed, monitored & wrote data governance policies for unstructured data collection to ensure quality, consistency & accuracy. Provided data across all programs & maintained databases for service gaps, operations troubleshooting, conflict or compliance investigations & other business intelligence queries. Data entry of archived files for historical & predictive analysis regarding bias & demographic trends to ensure equitable & effective service delivery for all clients.

Bethlehem Haven | Jan 2019 - Jun 2020

Medical Respite Care Coordinator

Empowered vulnerable populations with acute recuperative needs to achieve their goals around housing and recovery while enduring substance use, mental health, and chronic medical needs. Completed intakes using myAvatar Medical Database Software. Designed automated Excel spreadsheets to track client intakes, discharges, room availability, and medical appointments to inform stakeholders of costs, invoices, and programming. Collaborated with medical to schedule appointments, create individualized calendars, and communicate summaries to prioritize the medical needs of 10-25 clients. Coordinated transportation to medical appointments for disabled and medically compromised clients. Monitored 29 rooms for cleanliness, damages, inventory counts, intake preparedness, and returning client belongings. Facilitated weekly art therapy for 1-5 clients. Attended medical and mental health crisis trainings. Transported and chaperoned monthly clothing shopping trips to Light of Life for 1-5 clients. Worked overnight shifts to ensure daily client monitoring runs smoothly. Participated in Diversity and Inclusion Committee and Colleague Engagement Counsel to give input on gender and culturally diverse employee experiences.

Crafton & Ingram Borough | May 2018 - Dec 2018

Planning, Zoning & Vacant Housing Data Analyst

Managed the Blight / Enforcement Action Team over 8 weeks, gathering input from residents & local professionals on policies to fight blight & vacancy. Presented to council & planning commission recommendations for code enforcement, zoning & rental / vacant registry policies. Gathered local & county data to create maps of blight, vacancy & real estate movement using GIS ArcPro for council.

Urban Redevelopment Authority of Pittsburgh | May 2017 - May 2018

Housing Policy & Data Analyst

Assisted Project Managers with community process for ongoing developments & programs for URA property, funding, or legal services. Attended meetings with developers, community leaders, URA board members, City Council & the public for discussions around residential & mixed use developments. Toured URA / HACP related property for site inspection & auditing, & developing marketing tools using Microsoft Publisher. Analyzed affordable housing data (HUD, PHFA, NLIHC & HACP) to recommend policy for the Affordable Housing Task Force. Created custom VBA macros for cleaning using Microsoft Excel & Microsoft Access (SQL). Mapped using ArcGIS & Tolemi. Informed decisions to achieve affordable housing goals. Worked with Finance, Housing & Exec to educate new users of custom Salesforce software. Tested software & communicated across departments for data entry or programming errors. Created a screen capture video tutorial product line of new data entry processes using Camtasia. Also used Portfol.

Queer House | Jul 2014 - Aug 2017

Property Manager

Maintaining monthly and yearly leases between 5-7 tenants and 1-3 properties, managing house finances, bills, and other expenditures. Interviewing potential tenants, coordinating and delegating chores and tasks between tenants, arbitrating conflicts. Coordinating events hosted at property, holding meetings to discuss house rules and changes to property. All tenants were either queer or transgender, which often includes oppression and subsequent experiences of disability, mental health, chronic health, substance use, or similar. Contracting maintenance, repairs and installation.

City of Pittsburgh | Sep 2016 - May 2017

Neighborhood Planning & Land Use

Created professional communications for public process, utilizing Adobe Illustrator, Photoshop, SketchUp, and Powerpoint to translate technical transportation designs into presentations for stakeholders and the public for the development of a Bus Rapid Transit system. Participated in public process for the Uptown Eco Innovation District. Collaborated with neighborhood planners to create Pittsburgh’s first official Comprehensive Plan utilizing the 92 different neighborhood planning manuals. Reported on the accessibility accommodations of the Pittsburgh Airport compared to similarly sized domestic airports. Software Included: Word PDF Adobe Illustrator

ULTRA TESTING LLC | Aug 2014 - Oct 2016

Software Tester

Tested software for various web based clients using a systematic and thorough list of trigger points. Multiple test environments including web browsers, mobile devices, and operating systems through emulators. Used Jira project management tool to report issues and follow-up with developers.

Performance Bicycle | Apr 2014 - Aug 2016

Sales & Bike Builder

Assembling bicycles in a corporate retail bike shop in addition to selling bicycles, accessories, and services to local cyclists. Worked the sales floor and answered questions, matched customers to bikes and accessories, sold services, and connected customers with local cycling community resources. Purchased own set of tools for more efficiently building road, mountain, comfort, and single speed new from box without interfering with other mechanic’s work tools.

Neighborhood Learning Alliance | Feb 2014 - Aug 2016

Tutor

Worked individually with high school students on after school credit recovery online courses in math, physics, English, history, health, and Spanish, four or more times a week.

Self-Employed | Jun 2014 - Nov 2015

Professional Organizer

Assisted an individual to organize their space by cleaning and designing more efficient storage methods, and selling excess household goods.

Cinelease, Inc. | Oct 2014 - Mar 2015

Dayplayer

Lighting equipment warehouse inventory, testing and fixing lighting equipment for rent

NBC Sports | Nov 2014 - Nov 2014

Grip

Worked as cable pull for NBC's Texas University vs. West Virginia University football game on November 1st.

Best Buy | Oct 2013 - Apr 2014

Computers & Tablets

Being a "computer and tablets expert", selling the latest consumer electronics. In depth training on current products, product usage, and product specs, in addition to hands-on experience with products.

Chatham University | Sep 2012 - Dec 2013

Bike Mechanic

Ran the shop and sold bike merchandise. Diagnosed and repaired mechanical problems with students, faculty, and local community bicycles. Organized events, co-designed media, and encouraged the commuting lifestyle. Attended monthly meetings and collaborated with local bike organizations. Created BikeShare program and ordered parts. Offered volunteer mechanic training classes for Free Ride and coordinated bicycle riding lessons at Chatham University. Bike maintenance and repair, fixing flats, adjusting seats, handlebars, derailleurs and chains, recommendations for parts from other shops, teaching bike maintenance skills, road riding and route advice, sales of basic bike accessories.

Bravo Babies | Aug 2013 - Nov 2013

Webmaster

Updated the website to include music samples and additional photos, in addition to implemented a new color theme. Wordpress, HTML, CSS

RadioShack | Sep 2012 - Oct 2013

Sales Associate

Assisted consumers to find the right tech for their needs, including phones, batteries, audio & visual cables, DIY hardware components, or other electronics. Occasional hands-on diagnostics.

Pittsburgh Post-Gazette | Jan 2013 - May 2013

Staff Assistant

Helped Post-Gazette sports department staff by answering calls to record scores.

Valencia College | Oct 2011 - Apr 2012

Math Tutor

One-on-one homework help, modeled good study habits for tests, study skills, and taught basic math skills to college aged and returning students in math classes.

eBay Inc | Aug 2008 - Aug 2010

Sales

Item research and sale description, minimal web development, inventory management, customer service, packing and shipping.

My Education

Take a look at my formal education

Masters of Science in Policy Management and Management, Urban and Economic DevelopmentCarnegie Mellon University - H. John Heinz III College | 2019
Bachelor's degree, Communication, Journalism, and Related ProgramsChatham University | 2013
Associate's degree, General StudiesValencia Community College | 2012

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • Create Your Data Portfolio for Free