Megan S. Willesen

*** *. *** **.

Lawrence, KS **044

785-***-****

acw8xz@r.postjobfree.com

Computer

Skills:

Development languages/Platforms: Transact-SQL, Visual Basic for Applications (VBA), Visual Basic.NET and 6.0, Active Server Pages (ASP), ASP.NET, Python Software: Microsoft SQL Server Management Studio and performance tools including SSIS/SSRS, ApexSQL suite, Microsoft SharePoint, Microsoft Team Foundation Server, Microsoft Access, Microsoft Visual Studio, Microsoft Internet Information Services (IIS), Visual SourceSafe and Subversion source control, Tableau Reporting

Experience: May 2012 - Present TEK Systems Overland Park, KS Database Developer under contract with Kiewit

Creation of ETL and reporting projects using Microsoft SSIS and SSRS

SharePoint data integration with Microsoft SQL databases

Creation of SQL stored procedures and user-defined functions to 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 Microsoft Access and SQL databases

Involvement in the design of a new enterprise-wide web-enabled application used to manage project deliverables (engineering drawings and specifications), transmittals, estimation data, and ERP. June 2011 – April 2012 Infinitive Dulles, VA (via telecommute) Database Developer under contract with Verizon Business

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 June 2010 – June 2011 Datacore Marketing Mission, KS Software Engineer and Database Developer

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

March 2010 – June 2010 Paige Technologies Overland Park, KS Contractor

Full-time contractor for Datacore Marketing (detail, see above). October 2004 – November 2009 Mediware Information Systems, Inc. Lenexa, KS Senior Applications Developer and SQL Database Administrator

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 March 2004 – October 2004 LaGarde, Inc., StoreFront eCommerce Olathe, KS Independent Contractor

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 (d/b/a DataPipe) Hoboken, NJ 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 March 2002 – April 2003 LaGarde, Inc., 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 (KCSL) Topeka, KS

(later established as Kansas Innovations, Inc., a for-profit branch of KCSL) Database Engineer/Applications 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 July 1998 - March 2000 Computech Service of Kansas Topeka, KS Software Support Technician/ Database Developer/Instructor

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 July 1997 - July 1998 Netspace Internet Services Salina, KS Internet Support Technician

Configuration and support of dial-up and high-speed internet services

Creation and maintenance of homegrown MS Access-based internal call handling system

On-site support of operating system and connectivity issues Certifications: ExpertRating Global Certification, Microsoft SQL Server 2005 (transcript ID 1809584) ExpertRating Global Certification, Microsoft Access 2007 (transcript ID 1809582) Microsoft Certified Professional (MCP)

Education: January 2001-May 2001: Johnson County Community College Kansas City, KS Areas of study: Biology, Sign Language

January 1995-May 1997: Hutchinson Community College Hutchinson, KS Areas of study: Accounting, French

August 1991 - May 1996: Buhler High School Buhler, KS Areas of study: Accounting, French

Contact this candidate