Sign in

Sql Server Active Directory

Omaha, Nebraska, United States
February 12, 2018

Contact this candidate



PO Box **

Hancock, IA 51536

712-***-**** (Cell) (preferred) (preferred) Software Programmer/Analyst/Engineer or Equivalent Languages used:

ASP.NET, C#.NET, MVC, WEB API, VB.NET, MS SQL Server 2014, Transact-SQL, JQuery/ JQueryUI, JQGrid, SoapUI, Infragistics 15.1, Laserfiche, SharePoint 2007/2010, CSLA.NET, WCF, Kofax Capture 10.1, Content Manger Client for Windows, IBM eClient CMS, ExpressionEngine 2.3.1, PHP, JQuery, AngularJS, JavaScript, Prototype, CSS3, Classic ASP, DHTML, Social Media, XHTML, XML, XSLT, AJAX, Photoshop Elements, Visual Basic 6/VBA/ VBScript, Delphi, PL/SQL, MySQL, MSSQL Server 2008 R2, DevExpress and Access Databases, Java EE, MSDOS (Batch Executables), DB2, SSRS, Report Builder, Crystal Reports for VS 2013, Silk Test (4Test) 15.5, Fiddler, WireShark, TortoiseSVN Certifications:

Windows Server 2008 Active Directory Domain Services Configuration, May 2011 Platforms used:

VS 2008/2010/2013, SQL Server 2005/2008/2014, Windows XP, Vista, 7 EXPERIENCE:

Dept. of Transportation, State of Nebraska – Lincoln, NE C#.NET Consultant Aug 2017 – Present


Converted the PFS Project Management widget from Telerik to KendoUI.

Added CSV-file export functionality to the NDOT Traffic Analysis AVC5View application, generating a Signal Miss Consolidated Report based on street-embedded, traffic-counting sensor data, by Station, Date, Lane and Direction for either of two desired date ranges (previous 7 days vs previous Sunday-Saturday).

Created a new Expense Adjustment page and functionality for the NDOT Project Financial System application in C#.Net/MVC with Entity Framework.

Created MSI install files for various Traffic Analysis-related applications.

Provided analysis for the on-going Domain Migration from NDOR (Nebraska Department of Roads) to STN (Department of Transportation).

Upgraded Vertical Clearance console application from SQL Server 2012 to 2016.

Upgraded Traffic Analysis applications from VB6 to C#.NET as part of the switching domains.

Iowa Realty – Des Moines, IA

Business Intelligence Consultant Apr 2017 – Jun 2017 Accomplishments:

Built a new ETL process for Berkshire Hathaway-First Realty Open House data downloaded from the RETS Connector and merge them with the Iowa Realty data for the Des Moines, IA market.

Built an Active Listings SSRS Report for the Cedar Rapids, IA market.

Created a Matrix Credentials and Form Simplicity SSIS packages for Iowa Realty and First Realty to query/FTP files in .csv format.

Built Iowa Realty Builders SSRS report.

Refactored Real Satisfied Invitations SSIS package and SQL queries to include First Realty agent data.

Refactored Top 10 Builders SSRS reports, views and queries to break-out Greenland sub- builders.

Converted Allied Leads Access application to SSRS.

Fixed MailPrint Data Load SSIS package to more accurately cull the returned Agent Listing data.

Modified VBA application controlling Homestead Letters email generation for Cedar Rapids and Iowa City markets.

Contracting Opportunities Apr 2013 – Mar 2017

Scrum Master/VB.NET Consultant, Avera Health Plans via ALR – Sioux Falls, SD MVC /.NET/Web Service Consultant, Moody’s Analytics via Midwest Cloud Computing – Omaha, NE VB.NET Application Consultant, Hertz Agriculture Management via ALR – Omaha, NE Software Engineering Consultant, Wells Fargo Retail Lending via KForce – Des Moines, IA Web UI Consultant, EBusiness, First Nat. Bank of Omaha via Client Resources Inc. – Omaha, NE Top Accomplishments (WebForms and WinForms, Database, WebServices, Front-End):

Converted Kofax validation scripts from SBL to VB.Net.

Served as Kofax Document Repository Administrator and Developer.

Refactored Invoice-Parsing program to handle two additional document types in Kofax.

Rewrote Kemin’s SmartProducts application to their new NexaProducts web/win/mobile applications using MVC5 and MVVM design patterns, Razor, Entity Framework and Web API.

Ran daily scrums and managed project due-dates and time-reporting.

Coordinated SSIS, SSRS and .NET projects of a team of VB.Net Developers.

Built a web-based project rating application in VB.NET/SQL Server for rating all IT tickets by upper-management.

Built six new SOAP Web Services to handle Great Western Bank's Experian risk ratings and scorings.

Refactored Suncorp's MVC Group-Locking Toggle process.

Created Web API to handle Suncorp's Ignite loans.

Fixed Javascript/JQuery script issues which were causing updated loans to inadvertently duplicate. Also updated Credit Action AJAX calls to enhance the user experience.

Helped develop on the MARQ Portal Repository to port User-supplied application data to the Lending Cloud Repository using WebAPI, JSON, C#.NET and SQL, specifically adapting the Repository Setup and Credit Action interfaces and back-end processing, as well as analyzing and modifying the overall access within the Lending Cloud application.

Upgraded the Batch Reporting System from VS2010 to 2015, .Net Framework from 4 to 4.6.1, Infragistics 13.1 to 15.1, Crystal Reports Run-Time from XI 4.0 to CRVS13.0.15 and SQL Server 2005 to 2014.

Automated ePayment process using SQL Server 2005, VB.Net, PowerShell, WinSCP 5.7.5 using Kleopatra-GnuPG4Win 2.1.0 Encryption.

Created a SPA Web Console for displaying and resubmitting rejected MQ messaging transactions as part of the Rewards program.

Created a Web Application to isolate fraudulent transactions for American Express.

Started integrating Web Front-end with AngularJS.

Converted Fulfillment (WPF) Application to a tabbed format and added Batching functionality.

Refactored eConnect Web Service to update Great Plains inventory.

Restyled Cash Management proxy pages.

Created UI for Invoicing, Payments and Online Enrollment, and Commercial Card Alerts. American National Bank – Omaha, NE

System Analyst - Web Services, Mar 2011 – Mar 2013


Rewrote company intranet and Money Order & Cashier’s Check processes onto SP2010 using true ASP.NET/C#/MS SQL Server interfaces.

Created RSS feeds for both the SharePoint 2007 and Expression Engine 2.3.1 intranets.

Created a PDF-based Branch Key Log and Audit application using Adobe Acrobat X Pro.

Built a real-time online Approval Process using PHP/MySQL and AJAX Web Service calls for approving large-amount Cashier’s Checks.

Converted an on-line printer install application to an XML/XSLT Web Service application.

Revamped the Cashier’s Checks/Money Order extract audit processes using PowerShell.

Revamped company-wide SharePoint permissions using MS Active Directory.

Redesigned the Human Resources, Loan Ops and Consumer Lending Home Pages.

Supported the Auction and Raffle fund-raising activities for the United Way.

Helped Create Dashboards for the Retail Department using Qlikview BI Enterprise Edition. Nebraska Red Zone – Omaha, NE

Lead Web Developer, Jul 2010 – Mar 2011 Accomplishments:

Added popular social-media (Facebook (Like), Twitter, Digg, StumbleUpon) link-buttons to all product pages.

Helped redevelop the Home Page appearance and animation.

Helped create a blogging subdomain to support the E-Commerce SEO ratings.

Created displays to indicate when orders would ship and when their estimated arrival.

Created a remaining shipping days countdown display keyed to each game on Nebraska’s schedule.

Created a Stock Item Database entry application for building each season’s item catalog using VBA and Access 2007.

Contracting/Freelance Web Development Opportunities Mar 2008 – Jul 2010 Web Contractor, The Moeck's Group via Robert Half International – West Des Moines, IA

Web Developer Subcontractor, Corporate Travel Safety – Marina del Rey, CA

Contract Developer, Business Solutions Team, Farm Bureau Insurance via ACS - Des Moines, IA Top Accomplishments:

Fixed/Updated MasterPages, MasterPage Partial Class, Javascript and XHTML files.

Fixed dropped Cookie information being passed to the Fulfillment page and its subpages.

Controlled differential file access for Administration, General and Regional Managers, and Direct and Associate Dealers.

Converted 100+ existing web pages into a MySQL database format in WordPress.

Converted said web pages from standard HTML to include PHP.

Improved performance by using MySQL queries drive new site navigation.

Merged over 35 policy scripts into one fully flexible master script using Object Oriented techniques.

Mid America Computer Corporation (MACC) – Blair, Nebraska System Analyst, Customer Master & Bill Master Teams Nov 2000 – Jan 2008 Accomplishments:

Reduced script run-times for an individual client company and engineered easier maintenance tools and applications.

Introduced innovative, forward-thinking technologies.

Worked with the Conversion Team to help on-board new companies using ETL database processes using SQL Server.

Reduced production error rates to less than 1% per billing cycle while reducing company run- times by over 50%.

Reduced code duplication substantially.

Eliminated JCL duplication.

Modularized and re-engineered all job streams and critical programs.

Increased efficiency and effectiveness of the Bill Master process.

Created and rewrote numerous reports in Report Builder. Education:

June 1995 Ph.D. Candidate, University of Connecticut August 1990 M.S., Texas A&M University

May 1988 B.A., University of Nebraska – Omaha, Cum Laude

Contact this candidate