SQL Server Developer - T-SQL, SSIS, SSRS
Resume:
Megan S. Willesen
*****@********.***
https://www.linkedin.com/in/meganwillesen
Technologies
/Software:
Transact-SQL, Microsoft SQL Server Management Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), ETL, Visual Basic (VBA, .NET), Python, XML, Microsoft Power BI, Microsoft Azure DevOps, Microsoft Team Foundation Server, Microsoft Visual Studio, Microsoft Access, SAP Business Objects Crystal Reports, ApexSQL suite, Visual SourceSafe, Subversion source control
Experience: August 2022 - Present Colliers Mortgage Holdings Minneapolis, MN Independent Contractor, Senior Database Developer
Development and management of change-logging processes, business rule validation engine, and other internal tools
SSRS report development
SSIS package development for file processing, notification, data validation, and job monitoring
Complex database object development: stored procedures, triggers, and functions September 2023 – June 2024 Jewett Automation Richmond, VA Independent Contractor, Database Developer
Data cleansing and restructuring for systems migration from 2 in-house developed SQL databases to 3rd party ERP system
Development of a standalone database for parts integration across multiple systems
Development and modification of Crystal Reports
August 2019 – May 2023 TranSystems (via Advantage Tech) Kansas City, MO Database/Business Intelligence Developer
Complex SQL object development, query performance tuning and process automation
Report and data visualization development via SSRS and Power BI
Creation and maintenance of SSAS cubes for the purposes of business process tracking and analysis
SSIS package creation and management for data imports, cleansing, and validation November 2016 – July 2019 Pioneer Financial Services (via Advantage Tech) Kansas City, MO ETL Developer
Development of ETL packages via SSIS for purposes of file processing, data import/export, XML parsing, data aggregation, logging, and notification
Design and development of internal tools to perform administrative functions such as log truncation, advanced error notification, and metadata documentation
Data validation, query performance tuning, and advanced SQL server object development
Recipient of seven ‘Salute’ awards for development of creative solutions and outstanding performance May 2012 - October 2016 Kiewit Corporation (via TEK Systems) Overland Park, KS SQL Database Developer
Technical ownership of a new division-wide application used to process project takeoffs o Definition of the data strategy, entities, and design o Authorship of the technical requirements and documentation
Creation of ETL and reporting projects using Microsoft SSIS and SSRS using external data sources from SharePoint, Active Directory, and flat files
Creation of complex SQL objects (views, stored procedures, and user-defined functions) to validate, streamline, and add functionality to new and existing processes
Development and administration of 42 SQL databases used in the management of project deliverables
Data migration of project databases from Microsoft Access to Microsoft SQL Server June 2011 – April 2012 Verizon Business (via Infinitive) Dulles, VA SQL Database Developer
Development and administration of SSIS packages for bulk imports and sales data processing
Compilation of reports to issue invoices and payouts using SSRS
Troubleshooting and correction of SQL job failures
Development of stored procedures used to process data and provide event notifications March 2010 – June 2011 Datacore Marketing Mission, KS Software Engineer and Database Developer
Development of SSIS ETL packages for bulk imports, rebate processing, and list management
List pulls for one-off email blasts and other campaign needs involving the creation of complex SQL objects
Anomaly-detection and cluster analysis to determine trends used to better target marketing efforts October 2004 – November 2009 Mediware Information Systems, Inc. Lenexa, KS Senior Applications Developer
Administration of Windows 2003 Server and multiple critical Microsoft SQL 2005 databases
Data manipulation via T-SQL scripting, DTS/SSIS packages, and SQL stored procedures for the purposes of advanced reporting, ETL, and bulk updating
Performance tuning and auditing of enterprise SQL databases using Microsoft SQL tools and ApexSQL
Creation and regular test executions of disaster recovery plans utilizing both off-site and “soft” backups, transaction-level SQL replication, and server mirroring
Development and maintenance of company-wide custom applications used for vital office processes
Custom report creation using Crystal Reports
March 2004 – October 2004 LaGarde, Inc., dba StoreFront eCommerce Olathe, KS Independent Contractor, Web Services
Data manipulation via T-SQL scripting, database table structure manipulation and documentation
Customization of the StoreFront ecommerce software interface (ASP/VBScript, ASP.NET/VB)
Development of software add-ons for inclusion in StoreFront version 7.0 April 2003 – March 2004 Hoboken Web Services (dba DataPipe) Hoboken, NJ Applications Developer
Administration of 8 shared SQL servers
Database object creation for the purposes of data import and manipulation
Development of in-house web applications for the administration of web services March 2002 – April 2003 LaGarde, Inc., dba StoreFront eCommerce Olathe, KS Software Developer/Support Technician
Development of the StoreFront 6.0 database upgrade utility and application software
StoreFront database troubleshooting, upgrading, upsizing, and repair
Technical Support of StoreFront software and resulting websites April 2000 – January 2002 Kansas Children’s Service League Topeka, KS Database Engineer/Applications Developer
SQL database engineering and administration for data related to foster and adoptive children and families
Database interface development using Microsoft Access, VBA, and ColdFusion
Windows 2000 network setup, administration, and troubleshooting Coursework
/Certificates:
Dec 2023 Pluralsight SAP Crystal Reports Fundamentals July 2019 Microsoft Virtual Academy DAT207x: Analyzing and Visualizing Data with Power BI March 2016 The University of Texas System CSE1309x: Python Programming November 2015 Delft University of Technology EX101x: Data Analysis: Take it to the MAX
Contact this candidate