SUMMARY

Developer / analyst with varied skills such as c#, vb.net, asp.net, database, technician, jr network admin, database development, crm.

TECHNICAL SKILLS

• C#, vb.net, asp.net, visual basic 6.0, PHP, ZEND
• N-tier software development, object orientated design, MVC
• Database: SQL SERVER, ORACLE, ACCESS.
• Reporting. Creating or modifying Crystal Reports.
• Database development. Helping identify proper data sources and formats needed for direct marketing operations and CRM.
• Data validation. Ensuring proper formats fill rates, and data types of data sources.

WORK EXPERIENCE

Confidential Madison, WI
Asp.net Developer, network admin, all IT functions May 2010 - present
Environment: ASP.NET, C#, VB.NET, Web Services, SQL Server 2005, Stored Procedures Windows Server 2003, Windows XP Pro

• Creation of new or modifying existing intranet applications which drive the daily core business via utilizing both vb.net, c#.
• Integrating Web applications with client processes: Web Services. Integrated internal app with a local power company so that power outages were pushed to their engineering database via web services.
• Maintenance of 15 workstations, 5 servers, and 5 virtual servers (VMWare ESX Server 3i)
• Process data received from clients: Coordinate, map, load into SQL Server many times using MS Access as an intermediate database.
• Work with manager to plan application enhancements and new functionality
• Run / monitor Database, Website, and user files backups.
• Modify MS Outlook rules which auto print, forward, delete on certain conditions
• Creating workstation and server images and backups
• Maintain internal email system (SquirrelMail with hmailserver)
• Troubleshoot, fix workstation, server, and network issues

Confidential Verona, WI
Senior Database Analyst, Retail Client Solutions Feb 2004 - July 2009
Environment: SQL Server 2005, MS Access, VBA

• Coordinated data intake for clients on disparate computer systems
• Converted a client's data from a propriety system so that it could be loaded into SaleForce CRM and 3rd Wave CRM with a heavy use of MS Access to help format and filter the data using about 100 queries run in steps to cleanse, filter, and format. Worked with SalesForce engineers to help them load the data.
• Validated file formats using either MS Access or SQL Server. In many cases that was just as simple as loading a client file into Access and then checking to see that the expected fields were present with data that made sense for the given field. Manually reported on fill rates back to the customer until I automated the process.
• Created spreadsheets / reports in MS Excel for tracking client campaigns that was used to determine ROI.
• Mapped data sources to database fields using MS Access as an intermediate point
• Automated the process of customer file analysis report by creating an application in vb.net that analyzed and reported on fields, fill rates, data types in data files received by customers and created a Excel report using VBA

Confidential Madison, WI
VB Lead Programmer Jan 2001 - Feb 2004
Environment: Visual Basic 6.0, MS Access, Windows XP Pro

• Converted a commercial ticketing software (Ticketmaker) system from a propriety database locking scheme to an optimistic/pessimistic scheme, which resulted in increased concurrency and multi-user throughput.
• Maintenance and enhancement of ticketing system that is one to the top leaders in its class.
• Addressed hardware/software problems to which the support staff couldn't handle alone.
• Fixed numerous bugs to software.
• Maintained, modified reports as needed

Confidential Appleton, WI
Visual Basic Programmer Aug 1999 - Jan 2001
Environment: Visual Basic 6.0, MS Access, Windows XP Pro

• Developed RS-232 communication program that interfaces with tank monitoring systems found at convenience stores and truck stops, which monitors fuel levels and water condensation.
• Designed an application that generates purchase orders based on current inventory, past sales, and on-order quantity.
• Designed an application that generates purchase orders based on current inventory, past sales, and on-order quantity.
• Designed tool to update client databases as needed using a master database as template.
• Designed, modified crystal reports as needed

Confidential - Oshkosh Appleton, WI
Technician Jul 1997 - Apr 1999

• Enabled workstations to communicate in a Novel 3.12 environment.
• Fixed Various Hardware and Software problems.
• Upgrade hardware and install new software.
• Performed duties while student.

PROJECT ACCOMPLISHMENTS

• Formulated and programmed the necessary steps to convert data from propertity system so that it was in usuable from to be loaded into both SalesForce the 3RD Wave Research CRM
• Converted a commercial ticketing software (Ticketmaker) system from a propriety database locking scheme to an optimistic/pessimistic scheme, which resulted in increased concurrency and multi-user throughput
• Developed RS-232 communication program that interfaces with tank monitoring systems found at convenience stores and truck stops, which monitors fuel levels and water condensation.

EDUCATION

Confidential-Oshkosh Oshkosh, WI
B.A. Management Information Systems 1995-1999