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 migration from BigQuery platform to Snowflake and building staging, intermediate modules & marts for the business. Helped form standardization & best practices for database naming conventions, historical tracking & documentation.• 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. Created data models and standard reporting for Sotheby’s Financial Services on Tableau and for integration into other systems.• 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 ingestion, and standards to use for staging layer development in the warehouse.• 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 to modern toolsets. As we championed new technology in the org and to other global BI teams, I gained exposure to many different areas of the business to help build solutions that had real, actionable impact.• 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 were rolled out to 120+ people in the field and eventually picked up for global implementation.• 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 different types of data (internal systems, external, unstructured, etc.) required a range of techniques from star schemas to 3NF, SQL queries and stored procedures.• 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 geographic / demographic analysis using GIS shapefiles and A/B event comparison reports.• 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 published to Tableau / Power BI.• 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, transformation processes & dashboards. Used RPA tools to pull reports from customer portals.

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 initiative. I was still fairly new to database development, but with a focused goal and great team we made it happen. The foundation that we built with 2 developers, 3 analysts and our charismatic leader would continue to evolve and grow along with the size of the team which still exists today.• 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 logic. Created queries and stored procedures for driving reports and applications.• 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, working closely with our Tableau developer on data needs. Utilized fuzzy matching for householding accounts across systems.• 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 Forms, I took this knowledge and ran with it. Our work on this team later led to us becoming the main database developers on the BI team.• 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 drove reporting.• 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, vlookups and nested formulas. Learned to create MS Access forms as a method of data entry and accessibility for other members on the team.• 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 responsible for 2nd review on existing materials to correct grammar / punctuation and enhance visual presentation.

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 & checking of over 900 funds each day, to developing automation and validations for the 6-person team. I was able to pass that torch to other junior members as time went on who would continue to evolve and improve the process into a well-oiled machine.• 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 & correcting daily production issues to meet strict deadlines on a nightly basis.

• 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