David Hance Email and Phone Number

• Developed an online application Manufacturing System software, using VS-2013 MVC Design Pattern and SQL Server 2014.• Purchase Order Management• Inventory materials receiving utilizing barcode tracking.

• As a consultant for Tyco Electronics now TE Connectivity Support for the Global Learning Management System as Oracle database and applications developer and SAP HR SFTP data-feed administrator providing support for over 60 countries having support and access to external courses taken for all of TE’s 115,000+ employees to Rosetta-Stone and Paulson online and offline training and others…• Kronos Workforce Central software suite, v6 application administrator - Perform or coordinate necessary system configuration on servers, Oracle data bases, devices supporting over 115 Clocks around the United States and developing customized reports with Visual Studios• Develop understanding and working relationship with other IT areas providing support • Perform system health checks, environment management, optimization and secure PGP encryption of all HR data• Managed TE’s Applicant Tracking System hiring managers login and access into iCIMS

• Developed as a team member an Automatic Scheduling Request (ASR) surgery web application with MS VS2010 C# for West Penn Allegheny Health System.• LDAP- Active Directory ASP.NET Authorization integration• Enterprise Master Patient Index (EMPI) WCF web Services Querying and consumption. • Responsible for Performance Optimization for Microsoft SQL Server, to improve database performance and ensure scalability and ETL • Created the Software Architecture Document (SAD) for the ASR project.

• As a consultant at Capital Blue Cross (CBC) designed the Request Center Services. • Training personnel and supervising new software engineer to assume duties.• ETL data warehousing development, Business Intelligence with Oracle/ Cognos reports.• Completing the upgrade of CBC’s Request-Center to 9.3 from 9.1• Developing custom Java for LDAP mapping.• Assisted in developing custom java applications.

A+ and Net+ Certification Technician Instructor at the NCAS School of Business. Community Developer for Quick Books® XML-VBA database integrationEvents videographer, Training, and commercial video development. Mac and PC platform development –IPad development of App’s.Website design and maintenance. Developed an EPA Method, networked Quality Control database program for water samples (LIMS), for Wilson Testing Labs in Shamokin PA using, SQL Server, MS Access and VB.Development and installation of multiple NT networked LAN and WAN systems while acting as Systems Administrator for each system.PC and server repair – managed maintenance of systems and software for various businesses.Website design and web database management service ASP.NET / SQL. Example – www.pbwnc.com, www.pinnaclefranchise.biz , kreationsbykrisflorist.comSoftware development service for business ASP.NET, .NET, C#, VB.NET AND VB6 developer.Sonic firewall’s installation and maintenance.Edited a COBOL financial program for the Visiting Nurses Association of Northumberland County for year 2000 compliance (AIX Unix). As a Community Developer for Quick Books, Developed a VB6 Module to accurately input purchase orders and estimates from an Access Database. Developed a chemical inventory and hazardous waste database using VB6, for Bloomsburg University’s Waste Management Office. While working as the Bloomsburg University’s Chemistry and Physics Departments Lab Manager in 1994 -1996

Create design prototypes, including graphic design, site navigation, and layout of content, for the main corporate web site and for department websites. www.hxcorp.com and www.ephratahospital.org a DotNetNuke siteProducing a design that will be attractive to the target user, has a logical navigation system and has all the features required; Writing web pages in a combination of languishes, such as hypertext mark-up language (HTML), JavaScript, and Flash, or using code-generating programs, such as Dreamweaver, Photoshop, Adobe Illustrator, and Paint Shop Pro. Deciding on how images and other material will be digitally optimized and presented for the web;Ensuring that material on the web site is accessible to all groups including those with disabilities;Testing the site for functionality in different browsers and at different resolutions; fixing errorsEnsure that the layout of the content is accessible and logical; recommend improvements if necessary.Create visual concepts that match the content and the image wanted by corporate and clients but that fit in the corporate global image; ensure that sites are easy to navigate.Build websites using technologies that conform to international standards and make sure that they are universally accessiblePerform maintenance and updates to existing internal and external websites.Provide training on maintenance and update procedures to clients who choose to take charge of their own websites.Contribute to the overall development of the Web Communications group and of the corporate website.

Developed Active Directory group policies for the critical update server to distribute Microsoft critical updates to the Danville campus, Wyoming Valley campus and to numerous remote clinics utilizing little bandwidth.On call for helpdesk technicians as senior support analyst.Tracked and documented the replacement of outdated computer devices utilizing Remedy software then organized and distributed the computers to non-profit organizations throughout the United States.Maintained over 8,500 devices remotely utilizing Microsoft and LANDesk software.Tested and designed a remote data backup system to replace the cost of Symantec Ghost software.

Directed cutting edge software development projects for one of the nations leading home building enterprises, servicing builders from around the world. Managed the company's exchange email, SQL2000 data and web servers, hubs, switches, protocols, etc. Maintained and monitored WAN infrastructure - routers, CSU/DSU, data circuits and administered the company's Cisco firewall. Developed a remote data software system for builders and real estate personnel to intake a home order. Builders using this data would transfer the order process and create purchase orders using Peachtree Accounting Software and update a palm developed management system, thus, reducing the turnover building process to less than ninety builder days from order to finish and saving the company millions of dollars each year.

Database design with visual programming tools such as: Visual InterDev, VB 6.0, ASP, SQL 2000, Java and Front Page, MS Access, C++ and SQL2000, and DB2.; Allowed users to access documents from home on a secure LDAP connection. Shared GIS information between counties.Enabled county residents to access public information using custom-designed software for the Union County Courthouse.Setup and maintained state supplied T1 Network for PA Workforce development. DSL Installation and management.Video telecommunication technical advisor for Pennsylvania's Integrated Justice Network (JNET).Troubleshoot enterprise level networks, Novell NetWare.Administer backup management for enterprise-wide network.

A+ and Net+ Certification Technician Instructor at the NCAS School of Business. Teaching Shamokin Hospital technicians.Compiled a chemical inventory and hazardous waste database using VB6, for Bloomsburg University's Waste Management Office.Community Developer for Quick Books® XML-VBA database integration.Edited a COBOL financial program for the Visiting Nurses Association of Northumberland County for year 2000 compliance (AIX Unix). Videoconferencing over IP to reduce travel time for training.Website design and maintenance. Developed an EPA Method, networked Quality Control database program for water samples (LIMS), for a water testing company in Central PA using, SQL2000 and MS Access VBA.Development and installation of multiple NT networked LAN and WAN systems while acting as Systems Administrator for each system.PC and server repair - managed maintenance of systems and software for various businesses.Website design and web database management service ASP.NET / SQL; Software development service for business ASP.NET, .NET framework 3.5, C# and VB.NET developer.Sonic firewall installation and maintenance.Hance Productions - Training, website and commercial video development.