Eric Wunderlich Email & Phone Number

Greater Chicago Area

Chicago, Illinois, Us

Chicago, Illinois, Us

Inspire11 is a rapidly growing consultancy recently identified as one of Inc. 5000 fastest growing companies, ranking #10 overall in America, #1 in professional services.

Chicago, Illinois, Us

Work with .NET developers to develop new features for food operator research platform product by developing stored procedures, functions and other database objects in an Agile-like development cycleComplete monthly and quarterly data loading tasks in the timely manner to meet customer deadlinesStreamlined monthly data loading tasks using Azure Data Studio python and SQL jupyter notebooks making easier and faster to completeWork on data engineering tasks like ETL, schema design, etc for teams working on projects using new data sourcesConverted and existing MySQL data warehouse to Azure Synapse SQL pool. Created new ETL pipeline within Synapse to download data from vendor on a monthly basis Set up a Azure Batch account so python scripts can be ran easilyConverted testing preview database refresh SSIS package to a python script to be executed in Azure batch

Chicago, Illinois, Us

Work with software developers to develop new features for food research platform product by developing stored procedures, functions and other database objects in an Agile-like development cycleProvide proof-of-concept queries during design phase of projects and gather requirementsImport data from external data sources in Azure SQL databasesCreate and maintain data warehouse tables for client facing outputMaintain several instances of SQL server hosted in Azure and monitor performanceCreate and maintain SSIS packages for ETL processes including supplying data for Data Scientists for processingWork closely with data management team to support product data and ensure data integrity as well as provide ad-hoc queries and communicate with non-technical usersConverted SQL server database index and data rebuilding scheduled tasks to pipelines in Azure Data Factory enabling better monitoring and alertingDesigned and implemented a data repository for data engineering source control using MS DevOps and GitHelped with the database schema design for menu data restructure and wrote all database objects for new internal data entry applicationCreated a python script that is used for monthly data import that reads from Excel into SQL Server. Collaborated with the data management team to design a work process for efficient execution

London, Gb

London, Gb

Fix data integrity issues within product suite via scripts using SQL ServerDebug the product suite legacy website C# code to fix minor bugs and complete website code deployments. Work with software engineers to identify bugs and complete sprint itemsWork closely with Data Scientist to deliver data sources for analysis and manipulation and implement data processes that uses modeling and forecasting.Design and implement new data processing/ETL framework for as part of re-architecture project. Use SSIS to implement data syncing processes between legacy and new architecture systems.Execute and troubleshoot data processes that use AWS and Azure cloud technologies.Create custom solutions for reporting to meet client requirements (i.e., custom data extracts, custom offline solutions, etc.) using SQL Server, SQL Server Agent Jobs and SSIS packages.Investigate client inquires with the product suite, providing technical solutions through performing root cause analysis managed by Salesforce.Complete database maintenance tasks removing old data and backing up databases to AWS S3.Monitor multiple legacy SSIS package ETLs that generate production data and troubleshoot data failures.

Milwaukee, Wisconsin, Us

Develop and execute custom and standard reports using MS SQL Server Management StudioInterpret data trends or patterns in complex data sets and analyze results using statistical techniques Work with clients to establish eligibility data exchange and write data mapping specifications for custom file layoutsUtilize SSIS for daily data extractions from vendors and load into SQL Server Work closely with Business Intelligence Analyst/DBA to complete reporting tasks, monitor automated SSIS jobs, and analyze data Improve client and business reporting by assisting in implementing SSRS and job automation softwareHandle confidential information in accordance to HIPAA and interact professionally with clients and third-party vendors

San Mateo, Ca, Us

Respond to technical issues to provide third tier support for escalated and non-repetitive data issues. Analyze, identify and resolve data issues by creating scripts to resolve data conditions in an efficient manner in accordance with established Service Level AgreementsMonitor automated core business processes. Respond to failures and troubleshoot them to completion off-hoursDay-to-day completion of internal cases within department SLAs: SQL scripting, reporting using custom queriesHandle confidential information in accordance to HIPAA (including card data) and interact professionally with internal and external clients, vendors, and third party administrators

San Mateo, Ca, Us

Analyze complex support issues and uses independent judgment and knowledge to resolve client problems which fall outside commonly experienced support issuesWrite complex SQL queries, macros and scripts to support data integrity issues for large datasetsImplement inbound and outbound custom data feeds for clients and third party administrators