SUMMARY:

• Experienced application developer with a proven track record providing quality application and database design, development, and integration.
• Very fast learner and a team player with a keen understanding of the quality development cycle and its importance in satisfying long term business requirements.
• Seeking a prominent company on the forefront of information technology to utilize and build on current development strengths and over - exceed the company’s expectations.

TECHNICAL SKILLS:

• Windows 9x - Server 2016
• VB 6
• VBA and VB .NET
• SQL 2000 - 2012
• ASP and ASP .NET
• PHP jQuery
• HTML
• CSS
• Crystal Reports
• Adobe Creative Suite
• BCC Mail Manager
• VMWare
• Microsoft Hyper-V
• Drupal
• Wordpress
• Linux
• Amazon AWS

PROFESSIONAL EXPERIENCE:

Confidential, Bloomington, MN

Senior Business Analyst

Responsibilities:

• Oversaw development and expansion of dozens of new client-interfacing web sites.
• Designed and implemented secure payment processing systems for tens of thousands of franchise owners’ use to access our applicant tracking systems.
• Developed solutions to integrate 20,000+ franchisees’ job postings with Indeed.com job searches.

Confidential, Minneapolis, MN

Program Analyst III

• Investigated and resolved high priority application errors in live hospital environments throughout the full suite of electronic health record applications (Hospital, Clinic, ER, Medical Records, Registration, Clinical Documentation, Laboratory, Microbiology, Radiology, Mammography, Billing, Insurance Processing, Accounts Payable, Accounts Receivable, Collections, General Ledger, Revenue Cycle Management, Materials Management, Payroll, Time and Attendance, User Administration, Custom reports, and more).
• Provided critical escalation support to deployment team to resolve “hospital down” priority errors.
• Provided Tier 3 support to client care, functioning as an escalation bridge to development for “real” bugs. Analyzed research done by tier 1 and tier 2 support teams, including the steps to reproduce an issue, expected result, and actual result, and comparing results between the live hospital version and several versions on internal servers, to determine validity of bug/feature.
• Utilized SSMS and SQL Profiler to investigate errors in remote procedure calls and T-SQL transactions, debugged and isolated the VB.Net, C#, ASP.Net, or SQL code causing the errors.
• Designed and proposed fixes for the bug in cooperation with business analysts, escalated to development VP for hot fix approval, deployed the proposed hotfix at the live hospital, checked it into Subversion for inclusion into future versions and updated Jira with all branch fix versions.
• Represented Tier 3 team in cross-functional critical performance improvement project, including improvements in design (pagination), build (data transfer priorities), deployment (table indexes and constraints), code (left vs right comparison, avoiding scans, temp tables vs CTE, etc).
• Designed and implemented custom application changes for certain hospitals with unique requirements, often times requiring deployment in a live environment mid-day. This was usually modification of SQL stored procedures which could be deployed live after internal testing, but also included front end code in ASP.Net, CSS, VB.Net, C# dll’s or exe’s.
• Assisted Quality Assurance and Product Management teams with development and testing of complex validation scenarios which required development knowledge.
• Worked with IT support team to diagnose and resolve environment-related application issues on client side, such as .Net framework errors, .Net security issues, COM+ component errors, prerequisite conflicts, local performance issues.
• Worked with IT support team to diagnose and resolve environment-related application issues on application server side, including COM+ client/server component issues, ASP.Net configuration and authentication errors and other IIS errors and configuration issues.
• Worked with IT support team to diagnose and resolve environment-related application issues on the backend database side, including troubleshooting errors in SQL Server 2012 such as maintenance job errors and transaction log issues.

Confidential, Eagan, MN

Senior Developer

• As sole developer for 6 months after others moved on, became solely responsible for developing, testing, and implementing custom applications and modules to integrate in existing applications for both new and existing customers using VB and VB.Net.
• Utilized rapid development cycle in developing data-centric VB.Net and SQL backend solutions to perform complex logic on large data files and database tables to perform data conversion, data mining, and reporting, typically dealing with millions of records at a time.
• Developed new quality systems and reports using VB.Net and SQL 2005 queries and views to ensure business requirements are followed and identify problems previously unnoticed.
• Developed complex views, queries, and stored procedures using T-SQL in SQL 2000 and 2005 databases and VB.Net frontend to implement FedEx automation solution integrated with existing VB.Net production applications.
• Created numerous DTS and SSIS packages integrated with VB and VB.Net solutions.
• Designed and led server migration project to move all IT systems from a hosted environment to new servers on site, resulting in a 25-time increase in processing speed for the two most business-critical applications.
• Developed, tested, and implemented substantial VB.Net application changes, SQL database changes required for transition to newly built servers in the new location, including in all 8 business critical applications.
• Built new physical server cluster, consolidated and rebuilt all existing servers as virtual servers using VMWare and VMotion.

Confidential, Eagan, MN

Programmer

• Improved and maintained existing VB and VB.Net data conversion applications by adding error trapping, source control and versioning, and a complete test environment.
• Developed custom VB modules to integrate with existing applications for new customers’ specific business rules, project reporting, and production requirements.
• Developed numerous SQL databases, views, complex queries, and stored procedures for data storage and conversion.
• Became resident mail specialist by developing custom, automated solutions with BCC Mail Manager and perform address validation at the record level and presort customer address lists, and integrated automation with VB applications.
• Utilized a rapid development cycle with both VB and VBA to solve crucial on-the-spot customer and internal requests in a very fast-paced production environment.
• Met with existing customers to determine needs for program changes, and new customers to establish business rules according to customer and internal production needs.
• Provided help desk services for employees and maintained corporate backups.

Confidential, Bloomington, MN

Webmaster / Database Administrator / IT Support

• Consulted on IT solutions, part time, 20 hours/week.
• Maintained and provided emergency support of the corporate web site.
• Added new sections to the web site, maintaining consistency with CSS.
• Built iSelectSetup.com, an ASP.net / SQL 2005 solution to automate the importing of thousands of new clients to the corporate database.
• Provided on-call technical support for employees and clients.
• Maintained employee computers and corporate backups.

Confidential, Mankato, MN

Professional Political Fundraiser

• As a part time college job, maintained “core” employee status throughout schooling in a very competitive, performance based, high-turnover environment.
• Strengthened sales skills, especially phone-related.
• Consistently raised “top-10” revenues for the site.

Confidential, Gurnee, IL

Web Designer / Database Administration

• Performed design and maintenance of web sites as a part time consultant.
• Creation and implementation of owner-controlled administration section for all sites, consisting of an SQL 2000 database backend with an ASP interface.
• Utilize ASP, HTML, and SQL database skills to solve problems.
• Graphic design and implementation in sites.

Confidential, Minneapolis, MN

Web Designer

• Honed template & graphic design skills.
• Created corporate presences for dozens of high-profile companies.
• Maintained shared ColdFusion-based content management system.