Experience

Optimal Blue

• United States
• Financial Services
• 100 - 200 Employee

• Data Integration Specialist

  • Jun 2022 - Present



Kohler Co.

• United States
• Manufacturing
• 700 & Above Employee

• Data & Analytics - System Analyst

  • Nov 2019 - Jun 2021

  Sheboygan, Wisconsin Area I have the same core responsibilities as when I was an Associate System Analyst, but with expanded roles in building up of our Azure Data Architecture and working with the business to deliver future proof data solutions. Responsibilities include: + Develop ETL jobs in BODS and manage offshore ETL resources + Work with the Business on future Data Architecture Solutions by holding working sessions, gathering requirements, estimating hours, and more for Data & Analytics Projects. +… Show more I have the same core responsibilities as when I was an Associate System Analyst, but with expanded roles in building up of our Azure Data Architecture and working with the business to deliver future proof data solutions. Responsibilities include: + Develop ETL jobs in BODS and manage offshore ETL resources + Work with the Business on future Data Architecture Solutions by holding working sessions, gathering requirements, estimating hours, and more for Data & Analytics Projects. + Data Validation and Querying on SQL Server and Oracle + Creation and Tuning of Stored Procedures (T-SQL & PL/SQL) + Work on our Azure Storage and Compute Environment consisting of Azure Data Lake Store, Azure SQL DB, Data Bricks, and Azure Data Factory. + Create Visualizations using PowerBI

• Data & Analytics - Associate System Analyst

  • May 2018 - Nov 2019

  Sheboygan, Wisconsin Area Working on the Data & Analytics Team (Formly Business Intelligence ) inside the Digital Capabilities group. Main focuses are job creation using SAP's ETL tool Data Services (BODS) to move data from SAP to Azure Cloud (ADLS, Data Warehouse, SQL DB) and support of BODS environment and Oracle Data Warehouse. Responsibilities include: + ETL job Development using BODS + Azure Data Engineer on PaaS ADLS, DW and SQL DB. + Data Validation and Querying on SQL Server and Oracle +… Show more Working on the Data & Analytics Team (Formly Business Intelligence ) inside the Digital Capabilities group. Main focuses are job creation using SAP's ETL tool Data Services (BODS) to move data from SAP to Azure Cloud (ADLS, Data Warehouse, SQL DB) and support of BODS environment and Oracle Data Warehouse. Responsibilities include: + ETL job Development using BODS + Azure Data Engineer on PaaS ADLS, DW and SQL DB. + Data Validation and Querying on SQL Server and Oracle + Creation and Tuning of Stored Procedures (T-SQL & PL/SQL) + Support of Data Warehouse + Management of Offshore ETL resources

• Server/Desktop Support - Information Technology Rotational

  • Feb 2018 - May 2018

  Sheboygan, Wisconsin Area IT Rotational Program with the Windows Server/Desktop team working as a System administrator and Storage Administrator. Main focus is working on automated Windows deployment (MDT), Powershell scripting, Virtualization with Rail and working with new remote technology, Bomgar. Responsibilities Include: + Windows System Administration (MDT, Active Directory, etc) + Powershell Scripting + NAS and SAN Storage Administration (EMC) + VMware Administration: vCenter and VxRail +… Show more IT Rotational Program with the Windows Server/Desktop team working as a System administrator and Storage Administrator. Main focus is working on automated Windows deployment (MDT), Powershell scripting, Virtualization with Rail and working with new remote technology, Bomgar. Responsibilities Include: + Windows System Administration (MDT, Active Directory, etc) + Powershell Scripting + NAS and SAN Storage Administration (EMC) + VMware Administration: vCenter and VxRail + Windows Desktop/Server Support and Incident handling (ServiceNow)

• Business Intelligence - Information Technology Rotational

  • Nov 2017 - Feb 2018

  Sheboygan, Wisconsin Area IT Rotational program with the Business Intelligence team working with SAP's ETL tool Data Services and Power BI. End goal to populate an Azure Data Lake with Production data to enable more advanced methods of analysis focused on unstructured data from IoT and Social Media. Involved with data loading, data analysis , building metrics, generating reports and working with Azure Data Lake. Responsibilities Include: + Work with SAP and SAP Data Services + SQL for writing… Show more IT Rotational program with the Business Intelligence team working with SAP's ETL tool Data Services and Power BI. End goal to populate an Azure Data Lake with Production data to enable more advanced methods of analysis focused on unstructured data from IoT and Social Media. Involved with data loading, data analysis , building metrics, generating reports and working with Azure Data Lake. Responsibilities Include: + Work with SAP and SAP Data Services + SQL for writing queries and accessing data + Statistical work, data visualization and data analysis + Report Generation with Power BI + Oracle and SQL Server database administration + Azure Administration

• UNIX and Database Administrator - Intern

  • May 2017 - Nov 2017

  Sheboygan, Wisconsin Area Kohler IT Intern working with the Database and UNIX Support team. Working on a variety of different tasks including, but not limited to: Oracle upgrade of SAP SRM system, SQL Server installation and upgrade(s), perform Oracle schema upgrades, check the validity of SQL Server backups, document SQL Server landscapes, provide general SQL Server support, Physical and Virtual server setups, UNIX system administration, Cloud Infrastructure administration, DevOps and new technology… Show more Kohler IT Intern working with the Database and UNIX Support team. Working on a variety of different tasks including, but not limited to: Oracle upgrade of SAP SRM system, SQL Server installation and upgrade(s), perform Oracle schema upgrades, check the validity of SQL Server backups, document SQL Server landscapes, provide general SQL Server support, Physical and Virtual server setups, UNIX system administration, Cloud Infrastructure administration, DevOps and new technology discovery/research. Responsibilities Include: + Setting up physical servers + Setting up virtual servers with VMware and Oracle VM + Setting up Docker Containers + Administration of UNIX systems (RHEL and Solaris) + Monitoring systems with Oracle Enterprise Manager + Installing, deleting , restoring, upgrading and other administrative tasks for both Microsoft Sql Servers and Oracle 11g/12c. + Using Azure Cloud for administration of SQL Server databases + Setting up High Availability Clusters for Unix Servers + Backup and Restores with Networker and Avamar + Bash scripting and SQL Queries + Documentation of an extensive Sql Server landscape As an Intern at a large company there is also opportunity for me to get exposure in the other areas of IT at Kohler like Security, Networking, Applications, Help desk and Computer Hardware.



CDW

• United States
• IT Services and IT Consulting
• 700 & Above Employee

• ScienceLogic Support Technician

  • Nov 2016 - Apr 2017

  Madison, Wisconsin Area Contractor working at CDW on the discovery and enrollment of VMware, Cisco: UCS and UC Voice devices into ScienceLogic monitoring software. "ScienceLogic makes IT service delivery easy. It's more than just an IT monitoring tool. Auto-discover IT assets, visualize dependencies, correlate events, enable automation, and more. All from a single platform." Responsibilities include: + Troubleshooting of VMware Technologies (vCenter and ESX hosts). + Extensive knowledge and usage… Show more Contractor working at CDW on the discovery and enrollment of VMware, Cisco: UCS and UC Voice devices into ScienceLogic monitoring software. "ScienceLogic makes IT service delivery easy. It's more than just an IT monitoring tool. Auto-discover IT assets, visualize dependencies, correlate events, enable automation, and more. All from a single platform." Responsibilities include: + Troubleshooting of VMware Technologies (vCenter and ESX hosts). + Extensive knowledge and usage of ScienceLogic. + Helping Virtualization and UC Engineers with any ScienceLogic needs. + Supporting Customers on time sensitive monitoring issues. + Basic Unix and Windows System Administration Show less