Eric Hermetz Email & Phone Number

• Provide ad-hoc reports, analysis and extracts based on business needs (T-SQL, SSRS, SSIS, Pentaho)• Create Data warehouse and Data Mart and design the ETL process (SSIS, Pentaho)• Work closely with database administrators to build and support the BI environment• Assure and check the quality and the integrity of the data (T-SQL)• Optimize stored procedures, views, datasheet into SQL Server to increase overall performance and time/server use of daily functions• Migrate reports and jobs from previous Visual Studio versions (2005 through 2017)

• Create reports from scratch for different type of users: director, marketing, sales, warehouse and accounting. (T-SQL, SSRS)• Provide standard reports and dashboards that range from simple listings to more complex analysis of this data that include basic data grids and graphs. (T-SQL, SSRS)• Created and optimized stored procedures, views and triggers used by the company ERP software (T-SQL)• Assured and checked the quality and the integrity of the data (T-SQL)• Optimized stored procedures, views, dataset into SQL Server to increase overall performance and time/server use of daily functions

Used SQL Server to analyze data collected in stores and provided reports to the Commercial Team.• Compiled lists of stores respecting criteria given by client services, while minimizing collection costs• Assured and checked the quality and the integrity of the data received from the store collectors • Wrote and analyzed trending reports, drew extrapolations from findings • Created process in Data Warehouse to retrieve and analyze data, extracted, transformed and loaded data in the Data Mart System• Employee of the year in 2007 for best teamwork player