Eugene Schultz Email & Phone Number

Greenville, Wi, Us

Neenah, Wisconsin, United States

Olympia, Washington, United States

Lacey, Washington, United States

Olympia, Washington

Completely rewrote code and created new data models for large-scale federal reports, designed stored procedures and SSIS packages to integrate and transform data from multiple systems and applications and designed SSRS reports with summaries and visuals for trend analysis for USDOL and internal agency customers.Administered and maintained data warehouse servers, including constructing and monitoring SQL Agent jobs and data refreshes and schedules, setting permissions for server and database principals, troubleshooting job and load failures, optimizing data scalability and availability.Refactored and redesigned old ASP data warehouse security and reports portal website with C#, JavaScript, EF Core, and ASP.NET Core.Built complex data models and engineered pipelines for reports and reporting applications using T-SQL, SSMS, SSIS packages, SSRS, PowerShell and command-line scripts, DbSchema for logical and physical schema mapping, R and RStudio, and Power BI.Assisted with migrating eight SQL Server 2012 servers to SQL Server 2017 environments, mapped and documented all data objects and jobs, updated, migrated, and tested over one hundred SSIS packages, tested jobs and pipelines, version control with TFS and Azure DevOps.Created Power BI self-service reports and apps, created cleaned, conformed datasets and star schema data models and dynamic visuals and complex calculations with DAX.Administered Power BI online service including setting up access permissions, workspaces, data gateways and scheduled data refreshes.Worked on developing Azure Data Lake Storage environments including setting up HDFS folder structures and partitioning schemas, and created data pipelines with Azure Data Factory and Azure Synapse Analytics for ELT and ETL, managed pipeline development and testing and version control with Azure DevOps and Git.Developed dimensional modeling schemas in serverless and dedicated SQL pools and Azure Spark notebooks in Azure Synapse Analytics.

Madison, Wisconsin

Madison, Wisconsin Area

Created complex reports using Crystal Reports, SSRS, WebIntelligence, Qlik NPrinting and Oracle SQL and PL/SQL for SSM and Dean hospitals and clinics. Published reports and managed user access with SAP Business Objects Enterprise, Microsoft Report Manager, and SharePoint. Developed applications for user-generated reporting, analysis, and dashboards with QlikView, Visual Studio, SAS, SQL and Tableau. Conducted complex analysis and data mining projects to assist with hospital and clinical processes, such as clinical financial performance, provider workflows and patient treatment and diagnostic trends. Assisted with QlikView and Business Objects Enterprise server administration, set up and monitored loads, implemented load and security packages and scripts. Created and executed Cogito Data Warehouse version upgrades validation and testing process using SSMS, SSIS packages, Oracle PL/SQL packages, and Kimball data warehouse design best practices. Also updated Enterprise data warehouse ETL packages with validation processes.

Milwaukee, Wi

Created and optimized reusable, reliable modules and scripts and developed compelling and actionable reports using T-SQL, SQL Server 2008, and SQL Server Analytics Services and Reporting Services. Automated weekly, monthly, and quarterly report and project program and script execution. Developed and designed data mining, predictive modeling and trend analyses with SQL Server Analytics Services to assist clients in developing optimal property and casualty insurance products to customers. Collaborated with development team and clients on data management improvements and optimizing management of large data sets including queries, transactions, and structuring.

Olympia, Wa

Created and maintained databases for research data for county stormwater unit with Access 2010 and SQL Server 2012. Gathered user requirements and formulated testing, development, and deployment plan with users and successfully met deadlines for each phase of the plan. Consolidated and cleaned up data, normalized tables, applied integrity constraints, and created queries and procedures for data maintenance and manipulation. Developed forms that allowed users to quickly and easily generate queries and perform calculations such as annual or monthly average number of dry ponds per residence, through form control events, modules, and classes coded with Visual Basic and C#.

Participated in the development, organization, and maintenance of both physical and electronic budgetary and distribution systems related to all accountable item inventory for central offices and sub-agents in the state of Washington. Assisted the Information Systems unit as an applications tester. Composed ad hoc, User Acceptance, and quality assurance test plans, and aided in conducting client-side tests on an updated release of an email renewal system for license, permit, and tab renewals for state residents. Aided in discerning appropriate process modeling and test cases for potential effects of a new tax code on business processes for internal and external clients. Helped develop process that was then translated into unit tests by the programmers for testing licensing financial transactions, and then participated in testing the releases by performing integration, system, and acceptance tests.

Computer Science

Object-Oriented Programming I

Bachelor Of Arts (B.A.), Cognitive Psychology And Psycholinguistics

No Degree, Computer Programming

Activities and Societies: Intro to Programming with Visual Basic, Java and Visual Studio 2008, Web Page Development (HTML, CSS.