Nicole M.

Data Engineer @Hunt Electric

Bloomington, MN, US

Proficient in Microsoft SQL Server Enterprise Data Warehouse, encompassing modeling, design implementation, and troubleshooting. • Experienced in crafting T-SQL functions, views, and other SQL Server constructs for ETL processes and reporting purposes. • Implemented Common Table Expressions (CTE) and temporary tables to streamline complex queries. • Formulated and formatted reports leveraging Global Variables, Expressions, and Functions, with a focus on creating visually appealing layouts. • Deployed SSIS Packages into Production, employing Package configuration to ensure package environment independence. • Designed SSIS packages incorporating For Each Loop in Control Flow for batch processing of Excel files, File System Task for file management, and Execute SQL Task for database operations. • Developed and deployed SSIS packages for ETL tasks from OLTP systems and various sources to staging and then to the Data Warehouse, utilizing a variety of tasks and transformations including Lookup, Derived Columns, and Slowly Changing Dimension. • Provided support for the Production Environment by scheduling packages and implementing dynamic configurations with SQL Server Package Configuration. • Proficient in handling partially/full blocking transformations and adept at performance tuning of SSIS packages. • Expertise in configuring Event Handlers, Package Configurations, Logging, and managing System and User-defined Variables within SSIS Packages. • Skilled in creating and managing SQL JOBS, scheduling tasks, and setting up alerts. • Knowledgeable in developing Stored Procedures, Triggers, User-Defined Functions, Views, Indexes, and Analytical Functions using T-SQL, SQL Server, and PL/SQL. • Developed complex queries involving joins across multiple tables to validate data integrity and identify discrepancies.

Park University

Bachelor's degree