Dave Ogle Email & Phone Number

20406 W Rainbow Trl. Buckeye Az 85326

• Custom Intranet / Web Based Applications using Microsoft .Net / C# / SQL Server technology• Custom Database Programming: Designed, Created and Implemented an Inventory Control Management system using Access 2000, SQL scripts and SQL Server for a warehouse distribution center in Chandler, AZ.• Computer & Network Technical Support and Training• Technical Writing and Documentation• Installation, Maintenance and Troubleshooting of Server and Desktop • Hardware, Software and Networking Protocols• Configuration and Maintenance of Routers, Wireless Technology, Firewalls, Network infrastructure, Cat5e cabling, Modem, Router, Server, Telecom - Including recent design, installation and implementation of complete Network System and Telecommunication infrastructure.

2555 W. Chandler Blvd Chandler, Az 85224

• SQL Server 2005/2008, SSIS Packages and T-SQL stored procedures• Data Analysis / SQL Development providing analytics of home loans and insurance customer survey data supporting the Bank of America Office of the President.

4131 N. 24Th St. Phoenix Az 85016

Design, Develop, Configuration and Implementation of:• .Net Web Application utilizing Visual Studio 2010, .Net 4, SQL Server, LINQ. for the Intranet• School hardware, software and infrastructure• Internet and Telephone communications

3443 N Central Ave Phoenix, Az 85012

• Visual Studio 2010/2008 .Net 1.0 – 3.5, C#, LINQ, SQL Server 2005, T-SQL Stored Procedures, SQL Server Integration Services (SSIS), Visual Source Safe 6.0• Created C# libraries for XML data processing interfacing with SQL Server tables.• Designed and developed an EDI engine to validate and process HIPAA EDI medical transactions including the ANSI X12 834, 820 and 837i, 837p formats• Database Architect designed relational database schemas for the above X12 formats• Utilized BizTalk 2009 for X12 to XML translation of the above X12 formats• Composed Business Requirements Documents (BRD) and Technical Documents and Specifications

Performing the dual role of business/application analyst and lead developer, I worked directly with the client to determine an application solution. Based on the business needs and requirements to re-design and then develop the enterprise level financial application called OBI (Objective Based Incentive), which processes $155 million dollars in incentive compensation payouts per year and used by over 5000 employees, providing a cost savings of over $600,000 versus manual calculation in Excel files. Reverse engineering and analysis of existing MS Access queries, VBA programming and business flow processes, which enabled a major role in designing OBI.Support and enhanced existing MS Access databases, Excel spreadsheets and automated processes which calculate bonus payouts for the HR department in Countrywide. Lead developer of a 4 member team during the re-design and development of OBI.

Responsible for all maintenance and updates of a Java based application called Continuous Quality Improvement (CQI) which used Java, MySQL and a custom interface to an Oracle database to display hospice quality performance indicators.Designed, created and implemented a Perl and DOS based custom EDI solution to extend the capabilities of a large medical billing software, using ProEDI EDI translator, Perl programming, DOS scripts and various communications software for file transfer between Medicare and state Medicaid agencies.Responsible for all maintenance and updates of a DOS based legacy medical billing and information system named Patient Care System (PCS), which was a multi-relational database using dBase III, Clipper, Blinker and Report Writer.Created desktop user guides and detailed documentation for responsibilities listed above.Assumed responsibility for maintenance and updates for many automated VB scripts using MS Access and Excel.Daily interface with users for support and requirements documentation for development of CareNation, which is a browser interface, C++, HTML, PHP with Oracle database back end.Team member for development of CareNation in using C++ and HTML.Telecommute 2 days per week via Internet and Dame WareReceived Employee of the Month and multiple recognition awards

Customer representative to many clientsInstallation, troubleshooting and maintenance for MS NT, Small Business and Novell Servers.Networking troubleshooting and supportGeneral computer usage trainingProgramming for VistaCare Inc. as consultant using Clipper and dBase

Certificate Of Completion, Advanced Html

Certification Of Completion, Visual C++

Completion, Computer Programming

Activities and Societies: GPA 4.0 OP Hancock Award