Mel Suarez Email & Phone Number

Watertown, MA

Developed and/or maintained data feeds into membership databases. Retired at the end of 2018.

Medford, MA

Development and support of the ETL related to incoming/outgoing EDI messages and related reporting.

Burlington, MA

Developed a POC dashboard using Power BI Desktop and Power BI Pro with automatic refresh from on-premise, SQL Server data source. The source happens to be an enterprise information modeling tool called Apptrak that I have developed over the years.While consulting at TJX as a business analyst, developed a metadata repository for capture of retail analytics.

Burlington, MA

Build packages and structures to Import/export data to the Quaero DW in support of sales and marketing campaigns customizing SSIS and adding required framework metadata.Enhanced a dynamic SQL metrics application and delivered 100+ metrics and a somewhat complex, pivoted view for ease of reporting.

Bedford, MA

Lead analytics designer of two cubes based off of the two main, corproate services - medical coding and billing being rolled out in a flagship dashboard/scorecard offering.Remodeled portions of the operational data store (ODS) used by the cubes.Responsible for implementing master data management (MDM) using Microsoft's latest technology, SQL Server 2012.

Norwood, MA

Helping companies and government agencies develop business intelligence solutions.VERC ENTERPRISES - redesigned parts of their DW load logic using SQL Server 2008 R2, SSIS, SSAS, adding improved MDX to their Sales cube.CIRCOR - fire-fighting fixes/enhancements to an elegantly Supplier DW fed from international locations. Gurnet was the main consulting firm.

Reading, MA

Ran a small business that provided low-cost, low altitude, low noise aerial services such as aerial photography of estates, houses, schools; aerial drops; survey; search; videography.Used miniature, radio control, model helicopters with 5-ft diameter rotors.

Developed custom, business intelligence solutions for clients over the years before merging with eDatamate into Boston Data Group in 2006.Customers included:- Rockland Trust - assisted in the development of a Loan Risk Management data warehouse and introduced the corporation to web-based analytics - 5M records.- Mass Human Resources Division (HRD) where we.

Managed several, custom database development projects at firms such as Commonwealth Energy, Boston Edison (now Verizon).I.T. Committee chair overseeing the internal systems and infrastructure of the Boston Office.

At the Central Artery/Tunnel project (Big Dig), assisted in the development of Contract Change tracking systems. Developed a project-wide executive information system and kiosk with a touch-sensitive screen and drill-down.Before that analyzed GPS/Inertial navigation data developing custom, FORTRAN data processing.

Navigation systems analysis and sales support.

Cambridge, MA

Inertial navigation systems error analysis using optimal estimation. Languages included FORTAN and MAC.Brought the concept of computer algebra to Draper by acquiring MACSYMA and pushing its use as a method of verifying complex derivations.Developed a deterministic, computer-based approach for the development of a network of satellites for full-earch.

Performed analyses for teams doing satellite design.

Ms, Aeronautics & Astronautics

Activities and Societies: Radio Control Club, Delta Tau Delta, intramural soccer and basketball.MIT is were I learned to fly and finally.

Beme, Mechanical Engineering

Activities and Societies: American Society of Mechanical Engineering (ASME) Delta Tau Delta (DTD) Freshman basketball Intramural.

H.S., General

Activities and Societies: Debating Society, varsity basketball and baseball.Amazing school. I recommend it. 20 in my graduating class.

Bachelor'S Degree, Mechanical Engineering

Activities and Societies: Intramural basketball, president ASME, member Tau Beta Pi, member of Delta Tau DeltaGreat experience. Will never.