Eric Sarno Email & Phone Number

Enfield, CT, US

New York, New York, US

• Data Warehousing / Architecture – Using DBT, led cleanup & migration efforts of BI data models and marts. Core member leading conversations around data modeling in regards to business delivery. Primary DBT engineer for.
• Dashboard Development – Rebuilt Tableau data sources for consolidation, performance and consistency. Worked with Client Strategy, Marketing & Luxury Divisions to develop scalable RFM models used in client segmentation..
• Training & Leadership – Helped train BI analysts on usage of DBT & BigQuery, specifically using in conjunction with Tableau. Worked closely with data engineering to help set priorities and requirements for data.
• Tools Utilized – DBT, GitHub, Snowflake, Kimball, Data Vault, Star Schema, Google BigQuery, Alteryx Server, Alteryx Designer, Tableau

Billund, DK

• Summary – My role in the BI team at LEGO was centered around data, technology and architecture. As one of two technical members on the team, I was a key player in helping shape the transition from Excel-based reporting.
• Application Development – Built internal applications for desktop and mobile devices using PowerApps. These ranged from data validation and enrichment apps serving a few people, to merchandising assistant apps that.
• Data Warehousing – Designed & built the BI reporting warehouse to support US, CA, MX and LATAM regions. Created data marts to help serve each functional area’s reporting needs and business app data storage. The mix of.
• Dashboard Development – Using Tableau & Power BI, created reporting solutions to support sales, marketing, merchandising and eCom teams. These covered standard drill-down type dashboards, as well as interactive.
• Data Transformation – Created ELT / ETL flows & monitoring process to the data warehouse using a combination of Alteryx & SQL. Leveraged the warehouse, Alteryx & SQL to also create the reporting models that would be.
• Other – Core member of the Tableau Task Force to promote best practices for training and deployment across the org. SME for Alteryx development, assisting developers in Supply Chain to build out their data warehouse.

Springfield, Massachusetts, US

• Summary – My role in the BI team at MassMutual was an exciting one, joining a tiny start-up team to tie together 5 separate retirement platforms – a goal that hadn’t materialized after a much larger corporate.
• Data Warehousing – Designed & built the BI reporting warehouse to tie together the 5 retirement platforms that covered the MM business. Built out using a combination of star schema and 3NF for translation and business.
• Data Transformation – Created ETL flows for the data warehouse using a combination of Alteryx & SQL. Leveraged the database using Alteryx & SQL to also create the reporting models that would be published to Tableau.
• Application Development – Used MS Access Forms as a front-end for other groups to connect to our SQL Server queries and pull data as well as push updates to the database.
• Other – Presented to executive leadership and other teams within retirement services on our BI warehouse work as well as the tools we were using, championing how they could help other areas go beyond Excel.

Springfield, Massachusetts, US

• Summary – My role on the investments team at MassMutual was where I gained my first experience in database development and concepts. Trained by a senior teammate on the principles of primary keys and creating MS Access.
• Data Warehousing – Assisted in development of investments database built on SQL Server, learning core database concepts and methodologies. Created SSIS scripts for importing data and queries / stored procedures which.
• Data Transformation – Responsible for automation & workflow enhancement of several processes, including Plan Snapshots, quarterly attribution, RetireSMART daily reports and Bloomberg-based analysis tools.
• Application Development – Created & supported Excel-based reporting and analytical tools for investment directors. These tools were made using a variety of techniques including VBA macros, collections, pivot tables.
• Other – Responsible for ad-hoc fund analysis and reporting in support of investment directors & consultants. Created reporting / marketing materials from Weekly Market Overviews to quarterly platform reporting. Also.

Springfield, Massachusetts, US

• Summary – My role on the fund operations team at MassMutual was where I first started my journey into the tech world. With the encouragement of a senior member on another team, I changed my role of manual data entry &.
• Data Transformation – Using Excel & VBA, implemented continuous process improvement ideas and tools that have reduced manual input while improving accuracy and timeliness of pricing & unit value calculations.
• Application Development – Used advanced formulas / Excel VBA code to design & create spreadsheet tools used for reporting, reconciliation and analysis for the nightly valuation process.
• Other – Selected for project work and designated as subject matter expert for the VPA nightly valuation process for the newly acquired Hartford line of business. Consistent strong performance in researching &.

• Logo design & re-design for Rugged Maniac & Great Bull Run races
• Create print & web advertisements, flyers, t-shirts, posters, Facebook & YouTube pages for upcoming events
• Responsible for developing new art direction to stand out from other competing adventure races
• Designed, coded and created interactive web graphics for enhanced user interface on main website
• Consistently delivered on strict deadlines for creating media from concept to final product
• Managed volunteers during races

Billund, DK

• Handle customer inquiries and complaints in the professional, fun and friendly image of the company
• Learned and developed mastery of SAP, CRS and CRM processing systems
• Quickly and accurately enter data for orders, customer accounts and emails
• Defuse escalated situations and negotiate compromise solutions for the customer
• Strong track record of going above and beyond to help customers with special requests

Bachelor Of Arts (Ba), Economics

Bachelor'S Degree, Economics