• 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

MidCountry Financial Group (via Advantage Tech) | Nov 2016 - Jul 2019

Database Developer

• Responsible for the development of ETL solutions with SSIS and complex server objects. • Design and build of a ground-up change log process to conform to industry and regulatory standards. • Development of two separate solutions to cast and clean raw data in layers using data-driven rules and providing notifications of type or rule violations. • Database structure engineering, analysis, and diagramming. • Recipient of seven 'Salute' recognition awards for exemplary performance from both management and peer teams.

Kiewit (via TEK Systems) | May 2012 - Oct 2016

SQL Database Developer

• Technical ownership of a new division-wide application used to process project takeoffs -Definition of the data strategy, entities, and design -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. • Data migration of project databases from Microsoft Access to Microsoft SQL Server • Development and administration of 42 SQL databases used in the management of project deliverables (engineering drawings and specifications), transmittals, estimation data, and ERP.

Verizon Business (via Infinitive) | Jul 2011 - Apr 2012

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 of SQL job failures • Development of stored procedures used to process data and provide event notifications

Datacore Marketing | Mar 2010 - Jun 2011

Software Engineer

• Development and administration of ETL applications and SSIS packages for bulk imports, rebate processing, and list management • Complex list pulls for one-off email blasts and other campaign needs • Payment management and reporting for recipients of rebate payouts • Anomaly-detection and cluster analysis (data mining) to determine trends used to better target marketing efforts

Mediware Information Systems | Oct 2004 - Nov 2009

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 off- site and “soft” backups, transaction-level SQL replication, and server mirroring • Configuration and analysis of SQL auditing and security settings • Development and maintenance of company-wide custom applications used for vital office processes (Customer relations, call-handling, sales pipeline and lead management) • Custom report creation using Crystal Reports by SAP Business Objects

Datapipe | Apr 2003 - Mar 2004

Database Administrator/ Applications Developer

• Administration of 8 shared SQL servers • Script-writing for the purposes of data import and manipulation • Development of in-house web applications for the administration of web services

LaGarde | Mar 2002 - Apr 2003

Software Developer

• 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

Kansas Children's Service League | Apr 2000 - Jan 2002

Database Engineer/Software Developer

• SQL database engineering and administration for management of data related to children available for adoption/fostering as well as potential adoptive/ foster families • Database interface development using Microsoft Access, VBA, and ColdFusion for both client/service applications as well as web applications • Windows 2000 network setup, administration, and troubleshooting

Integrated Solutions Group | Jul 1998 - Mar 2000

Software Technician/Database Developer

• Development of Microsoft Access database interfaces both for native engine as well as Microsoft SQL • Software installation and support • Learning center instruction for Microsoft Windows, Microsoft Office, and general internet usage

My Education

Take a look at my formal education

Power BIMicrosoft Virtual Academy | 2019

About Me

Megan hasn't filled in a bio text

Create Your Data Portfolio for Free